| | |
| | | public DataSet ds = new DataSet(); |
| | | public WebServer webserver = new WebServer(); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | |
| | | #region ç产æ¥è®¡å æ¥è¯¢ |
| | | [Route("JIT_ICMOSortBill/JIT_ICMOSortBillList")] |
| | | [HttpGet] |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ds = oCN.RunProcReturn("select * from h_v_Sc_ICMOSortBillList", "h_v_Sc_ICMOSortBillList"); |
| | | |
| | | string Ret = ""; |
| | | if (oSystemParameter.ShowBill(ref Ret)) { |
| | | //夿客æ·ä¸ºå¯è´ |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "å¯è´å¥ç¹") //ç³»ç»åæ° |
| | | { |
| | | ds = oCN.RunProcReturn("select top 1000 * from h_v_Sc_ICMOSortBillList where 1=1"+ sWhere, "h_v_Sc_ICMOSortBillList"); |
| | | } |
| | | else { |
| | | ds = oCN.RunProcReturn("select * from h_v_Sc_ICMOSortBillList where 1=1"+ sWhere , "h_v_Sc_ICMOSortBillList"); |
| | | } |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |