智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
cwjbxqmz
2024-02-04 da1184528d1bcc9262f7faad5efddb7fd6d12669 
 WebAPI/Controllers/LMESController.cs


@@ -572,6 +572,7 @@




                //获取系统参数


                string Ret = "";


                string Count = "";


                if (oSystemParameter.ShowBill(ref Ret))


                {


                    //判断客户为龙山汽配


@@ -582,10 +583,16 @@




                        sWhere += sql_splice;                        


                    }


                    //判断客户为瑞与祺


                    if (oSystemParameter.omodel.WMS_CampanyName == "瑞与祺")


                    {


                        Count = "top 1000";


                    }


                }






                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


                ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeIssueBillQuery where 1 = 1 " + sWhere + " order by hmainid desc ", "h_v_Sc_ProcessExchangeIssueBillQuery");


                ds = oCN.RunProcReturn("select " + Count + " * from h_v_Sc_ProcessExchangeIssueBillQuery where 1 = 1 " + sWhere + " order by hmainid desc,CONVERT(int,流水号) asc", "h_v_Sc_ProcessExchangeIssueBillQuery");


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";