派生自 MES-WEB-API
WebAPI/Controllers/SCGL/Sc_MESBeginWorkBillController.cs
@@ -1,4 +1,5 @@ using Newtonsoft.Json.Linq; using Pub_Class; using System; using System.Collections.Generic; using System.Data; @@ -12,6 +13,8 @@ { public class Sc_MESBeginWorkBillController : ApiController { public DBUtility.ClsPub.Enum_BillStatus BillStatus;//单据状态（新增，修改，浏览，更新单价，变更） private json objJsonResult = new json(); public DataSet ds = new DataSet(); public WebServer webserver = new WebServer(); @@ -19,8 +22,12 @@ private WebS.WebService1 oWebs = new WebS.WebService1(); //获取系统参数 Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain = new Pub_Class.ClsXt_SystemParameterMain(); public DAL.ClsSc_MESBeginWorkBill BillNew = new DAL.ClsSc_MESBeginWorkBill(); //对应单据类 public DAL.ClsSc_MESBeginWorkBill BillOld = new DAL.ClsSc_MESBeginWorkBill(); //对应单据类 public DAL.ClsSc_ICMOBillWorkQtyStatus_Tmp BillNew1 = new DAL.ClsSc_ICMOBillWorkQtyStatus_Tmp(); //对应单据类 public DAL.ClsSc_ICMOBillWorkQtyStatus_Tmp BillOld1 = new DAL.ClsSc_ICMOBillWorkQtyStatus_Tmp(); //对应单据类 #region 开工单 @@ -194,10 +201,11 @@ /// <returns></returns> [Route("Sc_MESBeginWorkBill/DeltetMESBeginWorkBill")] [HttpGet] public object DeltetMESBeginWorkBill(string HInterID) 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; @@ -284,7 +292,7 @@ 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; @@ -366,8 +374,8 @@ } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; @@ -386,8 +394,8 @@ } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "反审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; @@ -459,8 +467,16 @@ [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("MES_MESBeginWorkBill_Edit", 1, true, DBUtility.ClsPub.CurUserName)) if (!DBUtility.ClsPub.Security_Log_second("MES_MESBeginWorkBill_Edit", 1, false, DBUtility.ClsPub.CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -480,11 +496,7 @@ objJsonResult.data = null; return objJsonResult; } var _value = msg["msg"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); ListModels oListModels = new ListModels(); try { @@ -495,6 +507,55 @@ lsmain = oListModels.getObjectByJson_Gy_MESBeginWorkFrom(msg2); foreach (Models.ClsSc_MESBeginWorkBillMain oItem in lsmain) { if (refSav == "Add") { //单据号是否重复 if (BillNew.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据号重复！不允许保存！"; objJsonResult.data = 1; return objJsonResult; } } if (refSav == "Update") { if (BillOld.ShowBill(oItem.HInterID, ref s) == false) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "此单据有误！"; objJsonResult.data = 1; return objJsonResult; } //判断是否可编辑 if (BillOld.omodel.HChecker != "" && BillOld.omodel.HChecker != null) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "此单据已经被审核，不允许修改！"; objJsonResult.data = 1; return objJsonResult; } if (BillOld.omodel.HBillStatus > 1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "此单据处于不可编辑状态，不允许修改！"; objJsonResult.data = 1; return objJsonResult; } if (!DBUtility.Xt_BaseBillFun.Fun_AllowEditBill(BillOld, ref s)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = s + "，不允许修改"; objJsonResult.data = 1; return objJsonResult; } } DBUtility.ClsPub.CurUserName =oItem.HMaker; oItem.HBillType = "3787"; oItem.HBillSubType = "3787"; @@ -527,7 +588,7 @@ string sReturn = ""; if (oSystemParameter.ShowBill(ref sReturn) == true) { if (oSystemParameterMain.Sc_MESBeginWorkBill_AutoCheck == "Y") //系统参数 自动审核 if (oSystemParameter.omodel.Sc_ICMOBillWorkQtyStatus_AutoCheck == "Y") //系统参数 自动审核 { objJsonResult.Verify = "Y"; } @@ -661,7 +722,7 @@ { 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"; @@ -703,6 +764,8 @@ string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string refSav = sArray[1].ToString(); string s = ""; ListModels oListModels = new ListModels(); try { @@ -713,6 +776,55 @@ lsmain = oListModels.getObjectByJson_Gy_MESProductReportFrom(msg2); foreach (Models.ClsSc_ICMOBillWorkQtyStatus_Tmp oItem in lsmain) { if (refSav == "Add") { //单据号是否重复 if (BillNew1.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld1.omodel.HInterID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据号重复！不允许保存！"; objJsonResult.data = 1; return objJsonResult; } } if (refSav == "Update") { if (BillOld1.ShowBill(oItem.HInterID, ref s) == false) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "此单据有误！"; objJsonResult.data = 1; return objJsonResult; } //判断是否可编辑 if (BillOld1.omodel.HChecker != "" && BillOld1.omodel.HChecker != null) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "此单据已经被审核，不允许修改！"; objJsonResult.data = 1; return objJsonResult; } if (BillOld1.omodel.HBillStatus > 1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "此单据处于不可编辑状态，不允许修改！"; objJsonResult.data = 1; return objJsonResult; } if (!DBUtility.Xt_BaseBillFun.Fun_AllowEditBill(BillOld1, ref s)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = s + "，不允许修改"; objJsonResult.data = 1; return objJsonResult; } } oItem.HBillType = "3724"; oItem.HBillSubType = "3724"; oItem.HReportType = 3;//（1条码扫描，2机器汇报，3手工录入） @@ -741,7 +853,7 @@ string sReturn = ""; if (oSystemParameter.ShowBill(ref sReturn) == true) { if (oSystemParameterMain.Sc_ICMOBillWorkQtyStatus_AutoCheck == "Y") //系统参数 自动审核 if (oSystemParameter.omodel.Sc_ICMOBillWorkQtyStatus_AutoCheck == "Y") //系统参数 自动审核 { objJsonResult.Verify = "Y"; } @@ -797,16 +909,17 @@ [HttpGet] public object MESProductAuditProcessReportList(int HSourceID,int HSourceInterID,int HSourceEntryID,string HSourceBillNo, int HICMOInterID,int HICMOEntryID, int HInterID, int IsAudit, string CurUserName) { string ModRightNameCheck = "Sc_ICMOReportBill_Check"; string ModRightNameCheck = "MES_ProcExchReport_Check"; DBUtility.ClsPub.CurUserName = CurUserName; try { string StrMessage = ""; //审核权限 if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) if (!WebClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName,ref StrMessage)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核失败！无权限！"; objJsonResult.Message = StrMessage; objJsonResult.data = null; return objJsonResult; } @@ -884,8 +997,8 @@ } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; @@ -904,8 +1017,8 @@ } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "反审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; @@ -927,17 +1040,24 @@ #region 报工平台产量汇报删除 [Route("Sc_MESBeginWorkBill/DeltetMESProductReportBill")] [HttpGet] public object DeleteGetLineBindBillList(string HInterID,string HICMOInterID,string HICMOEntryID) 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; @@ -966,6 +1086,29 @@ ListModels oListModels = new ListModels(); try { //系统参数 生成生产汇报单前判断是否首检 //string sReturn = ""; //if (oSystemParameter.ShowBill(ref sReturn) == true) //{ // if (oSystemParameter.omodel.Sc_ICMOReportBill_FirstCheckOut == "Y") //系统参数 必须首件检验通过才能保存单据 // { // //系统参数审核,则根据生产订单号，关联首检检验单中源单号查找检验单数据，判断单据状态是否合格 // ds = oCN.RunProcReturn("select * from QC_FirstPieceCheckBillMain where HICMOInterID='" + HICMOInterID + "' and HICMOEntryID='" + HICMOEntryID + "'", "QC_FirstPieceCheckBillMain"); // if (ds.Tables[0].Rows.Count > 0) //有首检检验单 // { // int rows = ds.Tables[0].AsEnumerable().Where(item => item["HLastResult"].ToString().Equals("True")).Count(); //判断当前数据(一条或多条)中最终判定是否有合格 // if (rows <= 0) // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "当前工单首检检验判定不合格,无法生成汇报单！"; // objJsonResult.data = null; // return objJsonResult; // } // } // } //} string sHSourceType = HSourceBillType; string BillType = "3711"; //单据类型 (生产汇报单) //得到mainid
