SQL.Add('SELECT PP_DivisionMain.*,pp_halffinishedgoods.*,(CASE WHEN PP_DivisionMain.Status=10 THEN ''未分切'' WHEN PP_DivisionMain.Status=50 THEN ''分切完成'' END) AS 状态 FROM PP_DivisionMain inner join pp_halffinishedgoods on PP_DivisionMain.pp_halffinishedgoods_id = pp_halffinishedgoods.id'); //排序怎么办呀
'inner join pp_halffinishedgoods on PP_DivisionMain.pp_halffinishedgoods_id = pp_halffinishedgoods.id'
SQL.Add('FROM PP_DivisionMain inner join pp_halffinishedgoods on PP_DivisionMain.pp_halffinishedgoods_id = pp_halffinishedgoods.id'); //排序