|  |  | 
 |  |  |         /// <returns></returns> | 
 |  |  |         [Route("Sc_MESBeginWorkBill/DeltetMESBeginWorkBill")] | 
 |  |  |         [HttpGet] | 
 |  |  |         public object DeltetMESBeginWorkBill(string HInterID,string UserName) | 
 |  |  |         public object DeltetMESBeginWorkBill(string HInterID, string UserName) | 
 |  |  |         { | 
 |  |  |             DBUtility.ClsPub.CurUserName = UserName; | 
 |  |  |             //编辑权限 | 
 |  |  |             if (!DBUtility.ClsPub.Security_Log("MES_MESBeginWorkBill_Delete", 1, true, DBUtility.ClsPub.CurUserName)) | 
 |  |  |             if (!DBUtility.ClsPub.Security_Log_second("MES_MESBeginWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) | 
 |  |  |             { | 
 |  |  |                 objJsonResult.code = "0"; | 
 |  |  |                 objJsonResult.count = 0; | 
 |  |  | 
 |  |  |         [HttpGet] | 
 |  |  |         public object AuditProcessReportList(int HInterID, int IsAudit, string CurUserName) | 
 |  |  |         { | 
 |  |  |             string ModRightNameCheck = "MES_MESBeginWorkBill_Check";  | 
 |  |  |             string ModRightNameCheck = "MES_MESBeginWorkBill_Check"; | 
 |  |  |             DBUtility.ClsPub.CurUserName = CurUserName; | 
 |  |  |             try | 
 |  |  |             { | 
 |  |  |                 //审核权限 | 
 |  |  |                 if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) | 
 |  |  |                 if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName)) | 
 |  |  |                 { | 
 |  |  |                     objJsonResult.code = "0"; | 
 |  |  |                     objJsonResult.count = 0; | 
 |  |  | 
 |  |  |         } | 
 |  |  |         #endregion | 
 |  |  |  | 
 |  |  |         #region 报工平台开工单保存/编辑 | 
 |  |  |         #region 报工平台开工单快速保存  | 
 |  |  |         /// <summary> | 
 |  |  |         /// 开工单 | 
 |  |  |         /// </summary> | 
 |  |  |         /// <param name="msg"></param> | 
 |  |  |         /// <returns></returns> | 
 |  |  |         [Route("Sc_MESBeginWorkBill/SaveGetMESBeginWorkFrom")] | 
 |  |  |         [HttpPost] | 
 |  |  |         public object SaveGetMESBeginWorkFrom([FromBody] JObject msg) | 
 |  |  |         [Route("Sc_MESBeginWorkBill/SaveGetMESBeginWorkFrom_KS")] | 
 |  |  |         [HttpGet] | 
 |  |  |         public object SaveGetMESBeginWorkFrom_KS(string HBillType,int HSourceInterID,int HSourceEntryID,string HSourceBillNo,string user,string HSourceBillType) | 
 |  |  |         { | 
 |  |  |          | 
 |  |  |             var _value = msg["msg"].ToString(); | 
 |  |  |             string msg1 = _value.ToString(); | 
 |  |  |             string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); | 
 |  |  |             string msg2 = sArray[0].ToString(); | 
 |  |  |             string UserName = sArray[1].ToString(); | 
 |  |  |             string refSav = sArray[2].ToString(); | 
 |  |  |             DBUtility.ClsPub.CurUserName = UserName; | 
 |  |  |  | 
 |  |  |           | 
 |  |  |             //保存权限 | 
 |  |  |             if (!DBUtility.ClsPub.Security_Log("MES_MESBeginWorkBill_Edit", 1, true, DBUtility.ClsPub.CurUserName)) | 
 |  |  |             if (!DBUtility.ClsPub.Security_Log_second("MES_MESBeginWorkBill_Edit", 1, false, user)) | 
 |  |  |             { | 
 |  |  |                 objJsonResult.code = "0"; | 
 |  |  |                 objJsonResult.count = 0; | 
 |  |  | 
 |  |  |                 objJsonResult.data = null; | 
 |  |  |                 return objJsonResult; | 
 |  |  |             } | 
 |  |  |         | 
 |  |  |  | 
 |  |  |             ListModels oListModels = new ListModels(); | 
 |  |  |             try | 
 |  |  |             { | 
 |  |  |  | 
 |  |  |                 ds = oCN.RunProcReturn("exec h_p_JIT_GetInfoByICMOStatusInterID @HSourceInterID=" + HSourceInterID + ",@HSourceEntryID=" + HSourceEntryID + ",@HSourceBillNo='" + HSourceBillNo + "',@HSourceBillType='" + HBillType + "'", "h_p_JIT_GetInfoByICMOStatusInterID"); | 
 |  |  |  | 
 |  |  |                 Models.ClsSc_MESBeginWorkBillMain ClsSc_MESBeginWorkBillMain = new Models.ClsSc_MESBeginWorkBillMain(); | 
 |  |  |                 ClsSc_MESBeginWorkBillMain.HProcID = int.Parse(ds.Tables[0].Rows[0]["HProcID"].ToString()); | 
 |  |  |                 ClsSc_MESBeginWorkBillMain.HMaterID = int.Parse(ds.Tables[0].Rows[0]["HMaterID"].ToString()); | 
 |  |  |                 ClsSc_MESBeginWorkBillMain.HSourceID = int.Parse(ds.Tables[0].Rows[0]["HSourceID"].ToString()); | 
 |  |  |                 ClsSc_MESBeginWorkBillMain.HMainSourceBillNo = ds.Tables[0].Rows[0]["HSourceBillNo"].ToString(); | 
 |  |  |                 ClsSc_MESBeginWorkBillMain.HMainSourceInterID = int.Parse(ds.Tables[0].Rows[0]["HSourceInterID"].ToString()); | 
 |  |  |                 ClsSc_MESBeginWorkBillMain.HMainSourceEntryID = ds.Tables[0].Rows[0]["HSourceEntryID"].ToString(); | 
 |  |  |                 ClsSc_MESBeginWorkBillMain.HMainSourceBillType = HSourceBillType == null ? "" : HSourceBillType; | 
 |  |  |                 ClsSc_MESBeginWorkBillMain.HDeptID = int.Parse(ds.Tables[0].Rows[0]["HDeptID"].ToString()); | 
 |  |  |                 ClsSc_MESBeginWorkBillMain.HICMOInterID = int.Parse(ds.Tables[0].Rows[0]["HICMOInterID"].ToString()); | 
 |  |  |                 ClsSc_MESBeginWorkBillMain.HICMOEntryID = int.Parse(ds.Tables[0].Rows[0]["HICMOEntryID"].ToString()); | 
 |  |  |                 ClsSc_MESBeginWorkBillMain.HICMOBillNo = ds.Tables[0].Rows[0]["HICMOBillNo"].ToString(); | 
 |  |  |  | 
 |  |  |                 ds = oCN.RunProcReturn("select * from h_v_xt_UserAssociationSelect where Czymc='" + user + "'", "h_v_xt_UserAssociationSelect"); | 
 |  |  |  | 
 |  |  |                 if (ds.Tables[0].Rows[0]["HGroupID"].ToString() == "0") | 
 |  |  |                 { | 
 |  |  |                     objJsonResult.code = "0"; | 
 |  |  |                     objJsonResult.count = 0; | 
 |  |  |                     objJsonResult.Message = "保存失败!用户没有绑定班组!" ; | 
 |  |  |                     objJsonResult.data = 1; | 
 |  |  |                     return objJsonResult; | 
 |  |  |                 } | 
 |  |  |  | 
 |  |  |                 if (ds.Tables[0].Rows[0]["HEmployeeID"].ToString() == "0") | 
 |  |  |                 { | 
 |  |  |                     objJsonResult.code = "0"; | 
 |  |  |                     objJsonResult.count = 0; | 
 |  |  |                     objJsonResult.Message = "保存失败!用户没有绑定职员!"; | 
 |  |  |                     objJsonResult.data = 1; | 
 |  |  |                     return objJsonResult; | 
 |  |  |                 } | 
 |  |  |  | 
 |  |  |                 ClsSc_MESBeginWorkBillMain.HGroupID = int.Parse(ds.Tables[0].Rows[0]["HGroupID"].ToString()); | 
 |  |  |                 ClsSc_MESBeginWorkBillMain.HEmpID = int.Parse(ds.Tables[0].Rows[0]["HEmployeeID"].ToString()); | 
 |  |  |  | 
 |  |  |                 DLL.ClsSc_MESBeginWorkBill oBill = new DLL.ClsSc_MESBeginWorkBill(); | 
 |  |  |                 List<Models.ClsSc_MESBeginWorkBillMain> lsmain = new List<Models.ClsSc_MESBeginWorkBillMain>(); | 
 |  |  |                 lsmain.Add(ClsSc_MESBeginWorkBillMain); | 
 |  |  |                 ClsXt_SystemParameter oClsXt_SystemParameter = new ClsXt_SystemParameter(); | 
 |  |  |  | 
 |  |  |                 DBUtility.ClsPub.CurUserName = user; | 
 |  |  |  | 
 |  |  |                 foreach (Models.ClsSc_MESBeginWorkBillMain oItem in lsmain) | 
 |  |  |                 { | 
 |  |  |                     oItem.HBillNo = DBUtility.ClsPub.CreateBillCode("3787", ref DBUtility.ClsPub.sExeReturnInfo, true); | 
 |  |  |                     | 
 |  |  |                     string sCapName = oClsXt_SystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo); | 
 |  |  |                     if (sCapName.Contains("凯贝")) | 
 |  |  |                     { | 
 |  |  |                         DataTable dt = getInfodatanow(oItem.HSourceID.ToString()); | 
 |  |  |                         if (dt.Rows.Count > 0) | 
 |  |  |                         { | 
 |  |  |                             DataRow dr = dt.Rows[0]; | 
 |  |  |                             oItem.HRunStatus = dr["runStu"].ToString(); | 
 |  |  |                             oItem.HSourceBeginQty = Convert.ToDecimal(dr["countAll"]); | 
 |  |  |                         } | 
 |  |  |                     } | 
 |  |  |  | 
 |  |  |                     oItem.HBillType = "3787"; | 
 |  |  |                     oItem.HBillSubType = "3787"; | 
 |  |  |                     oItem.HBillStatus = 1;   //单据状态(1未审,2审核通过,3关闭,4作废,5审核退回,6审核中,7已阅,8已回复,9结案,10验证,11下达,12开工,13申请审批,15申请检验,16 判定合格,17判定不合格)      | 
 |  |  |                     oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); | 
 |  |  |                     oItem.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month); | 
 |  |  |                     oItem.HMaker = user; | 
 |  |  |                     oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd")); | 
 |  |  |                     oItem.HBarCodeMakeDate = Convert.ToDateTime(DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"))); //扫描日期(年-月-日-时-分-秒) | 
 |  |  |  | 
 |  |  |                     oBill.omodel = oItem; | 
 |  |  |                 } | 
 |  |  |  | 
 |  |  |                 oCN.BeginTran(); | 
 |  |  |                 //保存 | 
 |  |  |                 //保存完毕后处理 | 
 |  |  |                 bool bResult = false; | 
 |  |  |                 if (oBill.omodel.HInterID == 0) | 
 |  |  |                 { | 
 |  |  |  | 
 |  |  |                     bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); | 
 |  |  |  | 
 |  |  |                 } | 
 |  |  |                 ds = oCN.RunProcReturn("select * from Sc_MESBeginWorkBillMain where HBillNo='" + oBill.omodel.HBillNo + "'", "Sc_MESBeginWorkBillMain"); | 
 |  |  |                 if (ds.Tables[0].Rows.Count == 0) { | 
 |  |  |                     oCN.RollBack(); | 
 |  |  |                     objJsonResult.code = "0"; | 
 |  |  |                     objJsonResult.count = 0; | 
 |  |  |                     objJsonResult.Message = "查无单据!"; | 
 |  |  |                     objJsonResult.data = 1; | 
 |  |  |                     return objJsonResult; | 
 |  |  |                 } | 
 |  |  |  | 
 |  |  |                 string sAutoCheck = oClsXt_SystemParameter.GetSingleSystemParameter("Sc_MESBeginWorkBill_AutoCheck", ref DBUtility.ClsPub.sExeReturnInfo); | 
 |  |  |                 if (sAutoCheck == "Y") | 
 |  |  |                 { | 
 |  |  |                     | 
 |  |  |                     if (!oBill.CheckBill(long.Parse(ds.Tables[0].Rows[0]["HInterID"].ToString()), ref DBUtility.ClsPub.sExeReturnInfo)) | 
 |  |  |                     { | 
 |  |  |                         oCN.RollBack(); | 
 |  |  |                         objJsonResult.code = "0"; | 
 |  |  |                         objJsonResult.count = 0; | 
 |  |  |                         objJsonResult.Message = "审核失败!"; | 
 |  |  |                         objJsonResult.data = 1; | 
 |  |  |                         return objJsonResult; | 
 |  |  |                     } | 
 |  |  |                 } | 
 |  |  |  | 
 |  |  |                 oCN.Commit(); | 
 |  |  |  | 
 |  |  |                 if (bResult) | 
 |  |  |                 { | 
 |  |  |  | 
 |  |  |                     objJsonResult.code = "0"; | 
 |  |  |                     objJsonResult.count = 1; | 
 |  |  |                     objJsonResult.Message = "保存成功!"; | 
 |  |  |                     objJsonResult.data = 1; | 
 |  |  |                     return objJsonResult; | 
 |  |  |                 } | 
 |  |  |                 else | 
 |  |  |                 { | 
 |  |  |                     objJsonResult.code = "0"; | 
 |  |  |                     objJsonResult.count = 0; | 
 |  |  |                     objJsonResult.Message = "保存失败!" + DBUtility.ClsPub.sExeReturnInfo; | 
 |  |  |                     objJsonResult.data = 1; | 
 |  |  |                     return objJsonResult; | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |             catch (Exception e) | 
 |  |  |             { | 
 |  |  |                 objJsonResult.code = "0"; | 
 |  |  |                 objJsonResult.count = 0; | 
 |  |  |                 objJsonResult.Message = e.Message; | 
 |  |  |                 objJsonResult.data = 1; | 
 |  |  |                 return objJsonResult; | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |         #endregion | 
 |  |  |  | 
 |  |  |         #region 报工平台开工单保存/编辑 | 
 |  |  |         /// <summary> | 
 |  |  |         /// 开工单 | 
 |  |  |         /// </summary> | 
 |  |  |         /// <param name="msg"></param> | 
 |  |  |         /// <returns></returns> | 
 |  |  |         [Route("Sc_MESBeginWorkBill/SaveGetMESBeginWorkFrom")] | 
 |  |  |         [HttpPost] | 
 |  |  |         public object SaveGetMESBeginWorkFrom([FromBody] JObject msg) | 
 |  |  |         { | 
 |  |  |  | 
 |  |  |             var _value = msg["msg"].ToString(); | 
 |  |  |             string msg1 = _value.ToString(); | 
 |  |  |             string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); | 
 |  |  |             string msg2 = sArray[0].ToString(); | 
 |  |  |             string UserName = sArray[1].ToString(); | 
 |  |  |             string refSav = sArray[2].ToString(); | 
 |  |  |             DBUtility.ClsPub.CurUserName = UserName; | 
 |  |  |             //保存权限 | 
 |  |  |             if (!DBUtility.ClsPub.Security_Log_second("MES_MESBeginWorkBill_Edit", 1, false, DBUtility.ClsPub.CurUserName)) | 
 |  |  |             { | 
 |  |  |                 objJsonResult.code = "0"; | 
 |  |  |                 objJsonResult.count = 0; | 
 |  |  |                 objJsonResult.Message = "无保存权限!"; | 
 |  |  |                 objJsonResult.data = null; | 
 |  |  |                 return objJsonResult; | 
 |  |  |             } | 
 |  |  |             //判断会计期是否合理 | 
 |  |  |             string s = ""; | 
 |  |  |             int sYear = 0; | 
 |  |  |             int sPeriod = 0; | 
 |  |  |             if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(DateTime.Now, ref sYear, ref sPeriod, ref s) == false) | 
 |  |  |             { | 
 |  |  |                 objJsonResult.code = "0"; | 
 |  |  |                 objJsonResult.count = 0; | 
 |  |  |                 objJsonResult.Message = s; | 
 |  |  |                 objJsonResult.data = null; | 
 |  |  |                 return objJsonResult; | 
 |  |  |             } | 
 |  |  |  | 
 |  |  |             ListModels oListModels = new ListModels(); | 
 |  |  |             try | 
 |  |  |             { | 
 |  |  | 
 |  |  |                             return objJsonResult; | 
 |  |  |                         } | 
 |  |  |                     } | 
 |  |  |  | 
 |  |  |                     DBUtility.ClsPub.CurUserName =oItem.HMaker; | 
 |  |  |                     ClsXt_SystemParameter oClsXt_SystemParameter = new ClsXt_SystemParameter(); | 
 |  |  |                     string sCapName = oClsXt_SystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo); | 
 |  |  |                     if (sCapName.Contains("凯贝")) | 
 |  |  |                     { | 
 |  |  |                         DataTable dt = getInfodatanow(oItem.HSourceID.ToString()); | 
 |  |  |                         if (dt.Rows.Count > 0) | 
 |  |  |                         { | 
 |  |  |                             DataRow dr = dt.Rows[0]; | 
 |  |  |                             oItem.HRunStatus = dr["runStu"].ToString(); | 
 |  |  |                             oItem.HSourceBeginQty = Convert.ToDecimal(dr["countAll"]); | 
 |  |  |                         } | 
 |  |  |                     } | 
 |  |  |                     DBUtility.ClsPub.CurUserName = oItem.HMaker; | 
 |  |  |                     oItem.HBillType = "3787"; | 
 |  |  |                     oItem.HBillSubType = "3787"; | 
 |  |  |                     oItem.HBillStatus = 1;   //单据状态(1未审,2审核通过,3关闭,4作废,5审核退回,6审核中,7已阅,8已回复,9结案,10验证,11下达,12开工,13申请审批,15申请检验,16 判定合格,17判定不合格)      | 
 |  |  | 
 |  |  |                 bool bResult; | 
 |  |  |                 if (oBill.omodel.HInterID == 0) | 
 |  |  |                 { | 
 |  |  |                     | 
 |  |  |  | 
 |  |  |                     bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); | 
 |  |  |                     if (bResult)  | 
 |  |  |                     if (bResult) | 
 |  |  |                     { | 
 |  |  |                         objJsonResult.HInterID = DBUtility.ClsPub.sExeReturnInfo; //返回主ID | 
 |  |  |                         //系统参数  自动审核 | 
 |  |  | 
 |  |  |                             } | 
 |  |  |                         } | 
 |  |  |                     } | 
 |  |  |                     | 
 |  |  |  | 
 |  |  |                 } | 
 |  |  |                 else | 
 |  |  |                 { | 
 |  |  | 
 |  |  |                 } | 
 |  |  |                 if (bResult) | 
 |  |  |                 { | 
 |  |  |                     | 
 |  |  |  | 
 |  |  |                     objJsonResult.code = "0"; | 
 |  |  |                     objJsonResult.count = 1; | 
 |  |  |                     objJsonResult.Message = "保存成功!"; | 
 |  |  | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |         #endregion | 
 |  |  |  | 
 |  |  |         public DataTable getInfodatanow(string hsoucreID) | 
 |  |  |         { | 
 |  |  |             SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); | 
 |  |  |             string sql = $" select HMacAddr, isnull(runStu,'')runStu, isnull(countAll,0)countAll from Gy_Source t1  left join HX_LIOTsys..Info_data_now t2 on t1.HMacAddr = t2.hid where t1.hitemid={hsoucreID}"; | 
 |  |  |             DataTable dt = oCn.RunProcReturn(sql, "dt").Tables[0]; | 
 |  |  |             return dt; | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         #region  报工平台验证单据状态 | 
 |  |  |         [Route("Sc_MESBeginWorkBill/GetMESBeginWorkBillStaus")] | 
 |  |  | 
 |  |  |  | 
 |  |  |         public static DataSet Sc_GetMESProductReportBillList(string sWhere) | 
 |  |  |         { | 
 |  |  |             string sql = string.Format(@"select a.HInterID, a.HBillNo,a.HDate,a.HBillType,a.HBillStatus,a.HMaterID,m.HNumber HMaterCode,m.HName HMaterName,m.HModel HMaterSpec  | 
 |  |  |                                    ,a.HSourceID,s.HNumber HSourceCode,s.HName HSourceName,a.HGroupID,g.HNumber HGroupCode,g.HName HGroupName | 
 |  |  |                                    ,a.HWorkManID,e.HName HWorkManName,a.HMaker,a.HMakeDate, a.HReportType   | 
 |  |  |                                    ,a.HQty,a.HICMOBillNo,a.HICMOInterID,a.HICMOEntryID  | 
 |  |  |                                    ,a.HSourceInterID,a.HSourceEntryID,a.HSourceBillNo, a.HSourceBillType | 
 |  |  |                                    from Sc_ICMOBillWorkQtyStatus_Tmp a  | 
 |  |  |                                    left join Gy_Material m on a.HMaterID=m.hitemid | 
 |  |  |                                    left join Gy_Source s on a.HSourceID=s.HItemID | 
 |  |  |                                    left join Gy_Group g on a.HGroupID=g.HItemID | 
 |  |  |                                    left join Gy_Employee e on a.HWorkManID=e.HItemID " + sWhere + " and HRelationInterID='0'"); | 
 |  |  |             return new SQLHelper.ClsCN().RunProcReturn(sql, "Sc_ICMOBillWorkQtyStatus_Tmp"); | 
 |  |  |             string sql = ""; | 
 |  |  |             if (sWhere != null && sWhere != "") | 
 |  |  |             { | 
 |  |  |                 sql = "select * from h_v_Sc_ICMOBillWorkQtyTmpList_ReportingPlatform " + sWhere; | 
 |  |  |             } | 
 |  |  |             else | 
 |  |  |             { | 
 |  |  |                 sql = "select * from h_v_Sc_ICMOBillWorkQtyTmpList_ReportingPlatform " ; | 
 |  |  |             } | 
 |  |  |              | 
 |  |  |             return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_ICMOBillWorkQtyTmpList_ReportingPlatform"); | 
 |  |  |         } | 
 |  |  |         #endregion | 
 |  |  |          | 
 |  |  |  | 
 |  |  |         #region 报工平台产量汇验证汇报数量是否超出计划数量辑 | 
 |  |  |         /// <summary> | 
 |  |  |         ///  | 
 |  |  | 
 |  |  |         { | 
 |  |  |             try | 
 |  |  |             { | 
 |  |  |                 ds = new SQLHelper.ClsCN().RunProcReturn("select isnull(sum(HQty),0) HQty,isnull(sum(HBadQty),0) HBadQty,isnull(sum(HWasterQty),0) HWasterQty   from Sc_ICMOBillWorkQtyStatus_Tmp with (nolock)" + sWhere, "Sc_ICMOBillWorkQtyStatus_Tmp"); | 
 |  |  |                 ds = new SQLHelper.ClsCN().RunProcReturn("select isnull(sum(HQty),0) HQty,isnull(sum(HBadCount),0) HBadQty,isnull(sum(HWasterQty),0) HWasterQty   from Sc_ICMOBillWorkQtyStatus_Tmp with (nolock)" + sWhere, "Sc_ICMOBillWorkQtyStatus_Tmp"); | 
 |  |  |                 if (ds.Tables[0].Rows.Count > 0) | 
 |  |  |                 { | 
 |  |  |                     objJsonResult.code = "1"; | 
 |  |  | 
 |  |  |                     if (bResult) | 
 |  |  |                     { | 
 |  |  |                         objJsonResult.HInterID = DBUtility.ClsPub.sExeReturnInfo; //返回主ID | 
 |  |  |                         //系统参数  自动审核 | 
 |  |  |                                                                                   //系统参数  自动审核 | 
 |  |  |                         string sReturn = ""; | 
 |  |  |                         if (oSystemParameter.ShowBill(ref sReturn) == true) | 
 |  |  |                         { | 
 |  |  | 
 |  |  |                 { | 
 |  |  |                     objJsonResult.code = "0"; | 
 |  |  |                     objJsonResult.count = 0; | 
 |  |  |                     objJsonResult.Message = "保存失败!"; | 
 |  |  |                     objJsonResult.Message = "保存失败!" + DBUtility.ClsPub.sExeReturnInfo; | 
 |  |  |                     objJsonResult.data = 1; | 
 |  |  |                     return objJsonResult; | 
 |  |  |                 } | 
 |  |  | 
 |  |  |         /// <returns></returns> | 
 |  |  |         [Route("Sc_MESBeginWorkBill/MESProductAuditProcessReportList")] | 
 |  |  |         [HttpGet] | 
 |  |  |         public object MESProductAuditProcessReportList(int HSourceID,int HSourceInterID,int HSourceEntryID,string HSourceBillNo, int HICMOInterID,int HICMOEntryID, int HInterID, int IsAudit, string CurUserName) | 
 |  |  |         public object MESProductAuditProcessReportList(int HSourceID, int HSourceInterID, int HSourceEntryID, string HSourceBillNo, int HICMOInterID, int HICMOEntryID, int HInterID, int IsAudit, string CurUserName) | 
 |  |  |         { | 
 |  |  |             string ModRightNameCheck = "MES_ProcExchReport_Check"; | 
 |  |  |             DBUtility.ClsPub.CurUserName = CurUserName; | 
 |  |  | 
 |  |  |             { | 
 |  |  |                 string StrMessage = ""; | 
 |  |  |                 //审核权限 | 
 |  |  |                 if (!WebClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName,ref  StrMessage)) | 
 |  |  |                 if (!WebClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName, ref StrMessage)) | 
 |  |  |                 { | 
 |  |  |                     objJsonResult.code = "0"; | 
 |  |  |                     objJsonResult.count = 0; | 
 |  |  | 
 |  |  |                 if (IsAudit == 0) //审核提交 | 
 |  |  |                 { | 
 |  |  |                     //审核提交 | 
 |  |  |                     if (oBill.CheckBill(HSourceID, HSourceInterID,HSourceEntryID,HSourceBillNo,HICMOInterID, HICMOEntryID, lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) | 
 |  |  |                     if (oBill.CheckBill(HSourceID, HSourceInterID, HSourceEntryID, HSourceBillNo, HICMOInterID, HICMOEntryID, lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) | 
 |  |  |                     { | 
 |  |  |                         objJsonResult.code = "1"; | 
 |  |  |                         objJsonResult.count = 1; | 
 |  |  | 
 |  |  |         #region 报工平台产量汇报删除 | 
 |  |  |         [Route("Sc_MESBeginWorkBill/DeltetMESProductReportBill")] | 
 |  |  |         [HttpGet] | 
 |  |  |         public object DeleteGetLineBindBillList(string HInterID,string HICMOInterID,string HICMOEntryID,string UserName) | 
 |  |  |         public object DeleteGetLineBindBillList(string HInterID, string HICMOInterID, string HICMOEntryID, string UserName) | 
 |  |  |         { | 
 |  |  |             try | 
 |  |  |             { | 
 |  |  |                 oCN.BeginTran(); | 
 |  |  |                 //查询产量汇报临时表数量 | 
 |  |  |                 ds = oCN.RunProcReturn("select isnull(HQty,0) HQty,isnull(HWasterQty,0) HWasterQty,isnull(HBadQty,0) HBadQty  from Sc_ICMOBillWorkQtyStatus_Tmp where HInterID='" + HInterID + "' and HICMOInterID='" + HICMOInterID + "' and HICMOEntryID='" + HICMOEntryID + "'", "Sc_ICMOBillWorkQtyStatus_Tmp"); | 
 |  |  |                 double HQty = double.Parse(ds.Tables[0].Rows[0]["HQty"].ToString()); | 
 |  |  |                 double HWasterQty = double.Parse(ds.Tables[0].Rows[0]["HWasterQty"].ToString()); | 
 |  |  |                 double HBadQty = double.Parse(ds.Tables[0].Rows[0]["HBadQty"].ToString()); | 
 |  |  |                 double sumqty = HQty + HBadQty + HWasterQty;  //汇报数量+不良+报废 | 
 |  |  |                                                               //更新产量装量临时表已汇报数量 | 
 |  |  |                 string sql1 = string.Format(@"update Sc_ICMOBillStatus_Tmp  set  HICMOStatus='1',HFinishFlag='0', HRelationInterID=0,HSplitRelationQty=HSplitRelationQty-" + sumqty + ",HDateFinishQty=HDateFinishQty-" + sumqty + "   where  HICMOInterID='" + HICMOInterID + "' and HICMOEntryID='" + HICMOEntryID + "'"); | 
 |  |  |                 oCN.RunProc(sql1); | 
 |  |  |                 //更新切换状态值 | 
 |  |  |                 string sql = string.Format(@"delete Sc_ICMOBillWorkQtyStatus_Tmp  where HInterID='" + HInterID + "'"); | 
 |  |  |                 oCN.RunProc(sql); | 
 |  |  |                 //更新产量装量临时表已汇报数量 | 
 |  |  |                 string sql1 = string.Format(@"update Sc_ICMOBillStatus_Tmp  set HRelationInterID=0,HSplitRelationQty=0 where HInterID='" + HInterID + "' and HICMOInterID='"+ HICMOInterID + "' and HICMOEntryID='"+ HICMOEntryID + "'"); | 
 |  |  |                 oCN.RunProc(sql); | 
 |  |  |  | 
 |  |  |                 oCN.Commit(); | 
 |  |  |                 objJsonResult.code = "1"; | 
 |  |  |                 objJsonResult.count = 1; | 
 |  |  | 
 |  |  |         #region 报工平台报检申请保存 | 
 |  |  |         [Route("Sc_MESBeginWorkBill/SaveGetMESProductReportBillList")] | 
 |  |  |         [HttpGet] | 
 |  |  |         public object SaveGetMESProductReportBillList(string ScMaxWork,string HSourceBillType, string workcode,int HSourceID,int HICMOInterID,int HICMOEntryID,string HMaker,string Czybm) | 
 |  |  |         {    | 
 |  |  |         public object SaveGetMESProductReportBillList(string ScMaxWork, string HSourceBillType, string workcode, int HSourceID, int HICMOInterID, int HICMOEntryID, string HMaker, string Czybm) | 
 |  |  |         { | 
 |  |  |             ListModels oListModels = new ListModels(); | 
 |  |  |             try | 
 |  |  |             { | 
 |  |  | 
 |  |  |                 //} | 
 |  |  |  | 
 |  |  |                 string sHSourceType = HSourceBillType; | 
 |  |  |                 string  BillType = "3711";  //单据类型 (生产汇报单) | 
 |  |  |                 //得到mainid | 
 |  |  |                  long HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); | 
 |  |  |                 string BillType = "3711";  //单据类型 (生产汇报单) | 
 |  |  |                                            //得到mainid | 
 |  |  |                 long HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); | 
 |  |  |                 //oCN.BeginTran(); | 
 |  |  |                 //根据单号、资源ID、订单主ID、订单子ID、制单人过滤产量汇报报检申请提交数据 | 
 |  |  |                 //string sql = string.Format(@"update Sc_ICMOBillWorkQtyStatus_Tmp set  | 
 |  |  | 
 |  |  |                 //ds = oCN.RunProcReturn("select top 1 * from  Sc_ICMOBillWorkQtyStatus_Tmp where HICMOReportInterID='" + HInterID + "' and HICMOReportBillNo='" + ScMaxWork + "'", "Sc_ICMOBillWorkQtyStatus_Tmp"); | 
 |  |  |                 //if (ds.Tables[0].Rows.Count <= 0) | 
 |  |  |                 //{ | 
 |  |  |                     //oCN.RollBack(); | 
 |  |  |                 //oCN.RollBack(); | 
 |  |  |                 //    objJsonResult.code = "0"; | 
 |  |  |                 //    objJsonResult.count = 0; | 
 |  |  |                 //    objJsonResult.Message = "当前单据无产量汇报记录!"; | 
 |  |  |                 //    objJsonResult.data = null; | 
 |  |  |                 //    return objJsonResult; | 
 |  |  |                 //} | 
 |  |  |                 | 
 |  |  |  | 
 |  |  |                 WebS.ClsSc_ICMOReportBillMain model = new WebS.ClsSc_ICMOReportBillMain(); | 
 |  |  |                 model.HInterID = HInterID; | 
 |  |  |                 model.HBillNo = ScMaxWork; | 
 |  |  | 
 |  |  |                 //model.HPRDORGID = DBUtility.ClsPub.isLong(ds0.Tables[0].Rows[0]["HPRDORGID"]); | 
 |  |  |                 model.HMainSourceInterID = HICMOInterID; | 
 |  |  |                 model.HMainSourceEntryID = HICMOEntryID; | 
 |  |  |                  | 
 |  |  |  | 
 |  |  |                 //oWebs.Timeout = 30000; | 
 |  |  |                 bool flag=oWebs.set_SaveICMOProductReportBill_Layui(model,workcode,HSourceID, sHSourceType, ref DBUtility.ClsPub.sErrInfo); | 
 |  |  |                 bool flag = oWebs.set_SaveICMOProductReportBill_Layui(model, workcode, HSourceID, sHSourceType, ref DBUtility.ClsPub.sErrInfo); | 
 |  |  |                 if (flag) | 
 |  |  |                 { | 
 |  |  |                     //oCN.Commit(); | 
 |  |  | 
 |  |  |                     objJsonResult.data = 1; | 
 |  |  |                     return objJsonResult; | 
 |  |  |                 } | 
 |  |  |                 else  | 
 |  |  |                 else | 
 |  |  |                 { | 
 |  |  |                     //oCN.RollBack(); | 
 |  |  |                     objJsonResult.code = "0"; | 
 |  |  |                     objJsonResult.count = 0; | 
 |  |  |                     objJsonResult.Message = "保存失败!"+ flag+ ";"+ DBUtility.ClsPub.sErrInfo; | 
 |  |  |                     objJsonResult.Message = "保存失败!" + flag + ";" + DBUtility.ClsPub.sErrInfo; | 
 |  |  |                     objJsonResult.data = null; | 
 |  |  |                     return objJsonResult; | 
 |  |  |                 } | 
 |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  |          | 
 |  |  |  | 
 |  |  |     } | 
 |  |  | } |