| | |
| | | } |
| | | #endregion |
| | | |
| | | #region 报工平台产量汇验证汇报数量是否超出计划数量辑 |
| | | /// <summary> |
| | | /// |
| | | /// </summary> |
| | | /// <param name="msg"></param> |
| | | /// <returns></returns> |
| | | [Route("Sc_MESBeginWorkBill/GetMESOverStepQty")] |
| | | [HttpGet] |
| | | public object GetMESOverStepQty(string sWhere) |
| | | { |
| | | 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" + sWhere, "Sc_ICMOBillWorkQtyStatus_Tmp"); |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "已有产量汇报数据返回!"; |
| | | objJsonResult.data = ds; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "无产量汇报数据!"; |
| | | objJsonResult.data = null; |
| | | } |
| | | |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = ex.Message; |
| | | objJsonResult.data = null; |
| | | } |
| | | return objJsonResult; |
| | | } |
| | | #endregion |
| | | |
| | | #region 报工平台产量汇报保存/编辑 |
| | | /// <summary> |
| | | /// 开工单 |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //调用WebService服务 |
| | | |
| | | WebS.ClsSc_ICMOReportBillMain model = new WebS.ClsSc_ICMOReportBillMain(); |
| | | model.HInterID = HInterID; |
| | | model.HBillNo = ScMaxWork; |
| | | model.HYear= DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | model.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month); |
| | | //model.HYear= DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | //model.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month); |
| | | model.HDate = DateTime.Now; |
| | | model.HRemark = ""; |
| | | model.HMaker = HMaker; |
| | | model.HEmpID = 0; |
| | | model.HGroupID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HGroupID"]); |
| | | model.HDeptID= DBUtility.ClsPub.isLong(ds0.Tables[0].Rows[0]["HDeptID"]); |
| | | model.HPRDORGID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HPRDORGID"]); |
| | | model.HPRDORGID = DBUtility.ClsPub.isLong(ds0.Tables[0].Rows[0]["HPRDORGID"]); |
| | | WebS.WebService1 oWebs = new WebS.WebService1(); |
| | | bool flag=oWebs.set_SaveICMOProductReportBill_Layui(model, sHSourceType, ref DBUtility.ClsPub.sErrInfo); |
| | | if (flag) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "保存成功!"; |
| | | objJsonResult.data = 1; |
| | | } |