智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
zzr99
2021-12-25 9385f2a2e4e2b6578f4b9e1cc139db977c2467ee 
 WebAPI/Controllers/Éú²ú¹ÜÀí/±¨¹¤Ì¨¹¤Ðò/Sc_MESProductReportStepBillController.cs


@@ -26,13 +26,13 @@


            {


                if (sWhere == null || sWhere.Equals(""))


                {


                    ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillWorkQtyStatus_Tmp " + sWhere+ "order by å•æ®å· desc", "h_v_IF_ICMOBillWorkQtyStatus_Tmp");


                    ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillProcessWorkQty_Tmp " + sWhere+ "order by å•æ®å· desc", "h_v_IF_ICMOBillProcessWorkQty_Tmp");


                }


                else


                {


                    string sql1 = "select * from h_v_IF_ICMOBillWorkQtyStatus_Tmp where 1 = 1 ";


                    string sql1 = "select * from h_v_IF_ICMOBillProcessWorkQty_Tmp where 1 = 1 ";


                    string sql = sql1 + sWhere+ " order by å•æ®å· desc";


                    ds = oCN.RunProcReturn(sql, "h_v_IF_ICMOBillWorkQtyStatus_Tmp");


                    ds = oCN.RunProcReturn(sql, "h_v_IF_ICMOBillProcessWorkQty_Tmp");


                }


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


@@ -59,7 +59,7 @@


            try


            {


                //根据选择资源ID获取当前生产工单、责任人


                ds=oCN.RunProcReturn("select * from h_v_IF_ICMOBillWorkQtyStatus_Tmp  where HInterID='" + linterid + "' and HICMOInterID='" + HICMOInID + "' and HICMOEntryID='" + HICMOEnID + "'", "h_v_IF_ICMOBillWorkQtyStatus_Tmp");


                ds=oCN.RunProcReturn("select * from h_v_IF_ICMOBillProcessWorkQty_Tmp  where HInterID='" + linterid + "' and HICMOInterID='" + HICMOInID + "' and HICMOEntryID='" + HICMOEnID + "'", "h_v_IF_ICMOBillProcessWorkQty_Tmp");


                if (ds.Tables[0].Rows.Count > 0)


                {