派生自 MES-WEB-API
WebAPI/Controllers/JHGL/Gy_RoutingBillController.cs
@@ -1,11 +1,16 @@ using Newtonsoft.Json.Linq; using Newtonsoft.Json; using Newtonsoft.Json.Linq; using Pub_Class; using SQLHelper; using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.IO; using System.Web; using System.Web.Http; using WebAPI.Controllers.SCGL.日计划管理; using WebAPI.Models; namespace WebAPI.Controllers @@ -19,7 +24,13 @@ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); DataSet ds; DAL.ClsIF_Material_View oMaterHlp = new DAL.ClsIF_Material_View(); public DAL.ClsGy_Process_View oProcHlp = new DAL.ClsGy_Process_View(); DAL.ClsGy_WorkCenter_View oCenHlp = new DAL.ClsGy_WorkCenter_View(); Gy_RoutingBill_temporary omdelMian = new Gy_RoutingBill_temporary(); public string BillType = "3301"; #region 工艺路线 列表 /// <summary> /// 返回工艺路线列表 ///参数：string sql。 @@ -68,6 +79,9 @@ } } #endregion #region 工艺路线 新增 /// <summary> /// 新增单据-保存按钮 ///参数：string sql。 @@ -104,15 +118,29 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); int hentryid = int.Parse(sArray[2].ToString());//子表的顺序id int OperationType = int.Parse(sArray[3].ToString());//数据类型 1添加 3修改 string user = sArray[4].ToString();//用户名 try { //判断是否有编辑权限 if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Edit", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无权限编辑!"; objJsonResult.data = null; return objJsonResult; } msg2 = "[" + msg2.ToString() + "]"; List<Gy_RoutingBill> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_RoutingBill>>(msg2); string BillType = "3301"; long HInterID = mainList[0].HInterID;//递入type得到的单据ID string HBillNo = mainList[0].HBillNo;//递入type得到的单据号 DateTime HDate = mainList[0].HDate;//日期 int HYear = 2021; int HYear = DateTime.Now.Year; double HPeriod = 1; string HRemark = mainList[0].HRemark;//备注 string HMaker = mainList[0].HMaker;//制单人 @@ -134,24 +162,48 @@ double HStdSourceQty = mainList[0].HStdSourceQty;//标准资源数 double HAddSourceRate = mainList[0].HAddSourceRate;//加资源增量 double HDelSourceRate = mainList[0].HDelSourceRate;//减资源减量 int HPRDORGID = mainList[0].HPRDORGID; //生产组织 int HOrgID = mainList[0].HOrgID; //组织 string HPicNumVer = mainList[0].HPicNumVer;//图号版本 string HPicNumAssemble = mainList[0].HPicNumAssemble;//总装图号 string HMaterTexture = mainList[0].HMaterTexture;//材质 string HProductNum = mainList[0].HProductNum;//成品编号 string HVerNum = mainList[0].HVerNum;//版本 //主表 oCN.RunProc("Insert Into Gy_RoutingBillMain " + "(HBillType,HInterID,HBillNo,HDate" + ",HYear,HPeriod,HRemark,HMaker,Hmakedate,HMaterID,HName,HMaterTypeID" + ",HRoutingGroupID,HUnitID,HMaterNumber,HUnitNumber,HStandard" + ",HMainGroupID,HMainProcID,HMainCenterID,HMainTimeUnit,HMainUnitTime,HMainWorkQty" + ",HMainPrice,HStdSourceQty,HAddSourceRate,HDelSourceRate" + ") " + " values('" + BillType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HMaker + "',getdate()," + HMaterID + ",'" + HName + "'," + HMaterTypeID + "," + HRoutingGroupID + "," + HUnitID + ",'" + HMaterNumber + "','" + HUnitNumber + "'," + Convert.ToString(HStandard ? 1 : 0) + "," + HMainGroupID + "," + HMainProcID + "," + HMainCenterID + ",'" + HMainTimeUnit + "'," + HMainUnitTime + "," + HMainWorkQty + "," + HMainPrice + "," + HStdSourceQty + "," + HAddSourceRate + "," + HDelSourceRate + ") "); if (OperationType == 1)//新增 { //主表 oCN.RunProc("Insert Into Gy_RoutingBillMain " + "(HBillType,HInterID,HBillNo,HDate" + ",HYear,HPeriod,HRemark,HMaker,Hmakedate,HMaterID,HName,HMaterTypeID" + ",HRoutingGroupID,HUnitID,HMaterNumber,HUnitNumber,HStandard" + ",HMainGroupID,HMainProcID,HMainCenterID,HMainTimeUnit,HMainUnitTime,HMainWorkQty" + ",HMainPrice,HStdSourceQty,HAddSourceRate,HPRDORGID,HDelSourceRate" + ",HPicNumVer,HPicNumAssemble,HMaterTexture,HProductNum,HVerNum,HOrgID) " + " values('" + BillType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HMaker + "',getdate()," + HMaterID + ",'" + HName + "'," + HMaterTypeID + "," + HRoutingGroupID + "," + HUnitID + ",'" + HMaterNumber + "','" + HUnitNumber + "'," + Convert.ToString(HStandard ? 1 : 0) + "," + HMainGroupID + "," + HMainProcID + "," + HMainCenterID + ",'" + HMainTimeUnit + "'," + HMainUnitTime + "," + HMainWorkQty + "," + HMainPrice + "," + HStdSourceQty + "," + HAddSourceRate + "," + HPRDORGID + "," + HDelSourceRate + ",'"+ HPicNumVer + "','" + HPicNumAssemble + "','" + HMaterTexture + "','" + HProductNum + "','" + HVerNum + "',"+ HOrgID + ") "); } else if (OperationType == 3) { //修改 oCN.RunProc("update Gy_RoutingBillMain set " + "HDate='" + HDate + "',HYear='" + HYear + "',HPeriod='" + HPeriod + "',HRemark='" + HRemark + "',HMaker='" + HMaker + "',Hmakedate=getdate(),HMaterID='" + HMaterID + "',HName='" + HName + "',HMaterTypeID='" + HMaterTypeID + "',HRoutingGroupID='" + HRoutingGroupID + "',HUnitID='" + HUnitID + "',HMaterNumber='" + HMaterNumber + "',HUnitNumber='" + HUnitNumber + "',HStandard='" + Convert.ToString(HStandard ? 1 : 0) + "',HMainGroupID='" + HMainGroupID + "',HMainProcID='" + HMainProcID + "',HMainCenterID='" + HMainCenterID + "',HMainTimeUnit='" + HMainTimeUnit + "',HMainUnitTime='" + HMainUnitTime + "',HMainWorkQty='" + HMainWorkQty + "',HMainPrice='" + HMainPrice + "',HStdSourceQty='" + HStdSourceQty + "',HAddSourceRate='" + HAddSourceRate + "',HDelSourceRate='" + HDelSourceRate + "',HPicNumVer='" + HPicNumVer + "',HPicNumAssemble='" + HPicNumAssemble + "',HMaterTexture='" + HMaterTexture + "'" + ",HProductNum='" + HProductNum + "',HVerNum='" + HVerNum + "' where HInterID='" + HInterID + "'"); //删除子表 oCN.RunProc("delete from Gy_RoutingBillSub where HInterID='" + HInterID + "' and HEntryID='" + hentryid + "'"); } //保存子表 objJsonResult = AddBillSub(msg3, HInterID); objJsonResult = AddBillSub(msg3, HInterID, hentryid); if (objJsonResult.code == "0") { objJsonResult.code = "0"; @@ -163,23 +215,28 @@ oCN.RunProc("exec h_p_Gy_RoutingBillCheck " + HInterID); //设置默认工艺路线 //判断是否重复工序号 ds = oCN.RunProcReturn("exec h_p_Gy_RoutingCtrl " + HInterID, "h_p_Gy_RoutingCtrl"); if (ds == null || ds.Tables[0].Rows.Count == 0) if (OperationType == 1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "判断重复工序号失败！"; objJsonResult.data = null; return objJsonResult; } else { if (ClsPub.isStrNull(ds.Tables[0].Rows[0][0]) == "2") if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = ClsPub.isStrNull(ds.Tables[0].Rows[0][1]); objJsonResult.Message = "判断重复工序号失败！"; objJsonResult.data = null; return objJsonResult; } else { if (ClsPub.isStrNull(ds.Tables[0].Rows[0][0]) == "2") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = ClsPub.isStrNull(ds.Tables[0].Rows[0][1]); objJsonResult.data = null; return objJsonResult; } } } objJsonResult.code = "1"; @@ -198,11 +255,14 @@ } } public json AddBillSub(string msg3,long HInterID) { List<Gy_RoutingBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_RoutingBillSub>>(msg3); for (int i=0;i< subList.ToArray().Length;i++) public json AddBillSub(string msg3, long HInterID, int hentryid) { List<Gy_RoutingBillSub> DetailColl = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_RoutingBillSub>>(msg3); int i = 0; foreach (Gy_RoutingBillSub oSub in DetailColl) { if (subList[i].HWorkQty <= 0) i++; if (oSub.HWorkQty <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -210,72 +270,34 @@ objJsonResult.data = null; return objJsonResult; } long HCenterID = 0;//工作中心ID string HTimeUnit = "";//时间单位 double HUnitTime = 0;//运行时间 double HReadyTime = 0;//准备时间 double HQueueTime = 0;//排队时间 double HMoveTime = 0;//转移时间 string HCloseMan = "";//关闭人 bool HCloseType = false;// string HProcType = "";//工序类型 bool HNextProcFlag = false;//下道流转工序 bool HFlowProc = false;//流转工序 double HFixPrice = 0;//班产定额 double HProcPrice = 0;//工序工价 double HBadPrice = 0;//不合格单价 double HWasterPrice = 0;//报废单价 bool HStdFlag = false;//标准定额 double HBeginDayQty = 0;//开工余量（天数） double HBeginFixQty = 0;//开工余量（固数） long HSourceInterID = 0;//源单主内码 long HSourceEntryID = 0;//源单子内码 string HSourceBillNo = "";//源单单号 string HSourceBillType = "";//源单类型 double HRelationQty = 0;//关联数量 double HRelationMoney = 0;//关联金额 bool HAutoTrunFlag = false;//自动移转 double HFixWorkDays = 0;//上道固定天数 double HTrunWorkDays = 0;//上道循环周期 double HReadyTimes = 0;//本道准备时间 double HICMOReadyTimes = 0;//换单准备时间 double HSubStdEmpQty = 0;//标准人数 double HSubCanUseSourceQty = 0;//可操作设备数 long HProcID_S = 0;//工段ID long HCenterID_S = 0;//产线中心ID double HWorkQty_S = 0;//产线产能 double HSubStdEmpQty_S = 0;//产线人数 string HMouldNo = "";//模具编号 double HChangeMould = 0;//换模时间/换刀时间 string HPackStd = "";//周转箱标准 string HPack = "";//周转箱 string HPutArea = "";//暂放区 double HMyWorkDays = 0;//生产周期 double HMyFixWorkDays = 0;//固定生产天数 oCN.RunProc("Insert into Gy_RoutingBillSub " + "(HInterID,HEntryID,HProcID,HProcNO,HSupID,HSupFlag" + ",HWorkQty,HCenterID,HTimeUnit,HUnitTime" + ",HReadyTime,HQueueTime,HMoveTime" + ",HCloseMan,HCloseType,HRemark,HProcType,HNextProcFlag,HFlowProc" + ",HFixPrice,HProcPrice,HBadPrice,HWasterPrice,HStdFlag,HBeginDayQty,HBeginFixQty" + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HAutoTrunFlag" + ",HFixWorkDays,HTrunWorkDays,HReadyTimes,HICMOReadyTimes,HSubStdEmpQty,HSubCanUseSourceQty" + ",HProcID_S,HCenterID_S,HWorkQty_S,HSubStdEmpQty_S,HMouldNo,HChangeMould" + ",HPackStd,HPack,HPutArea,HMyWorkDays,HMyFixWorkDays,HPassRate" + ") values(" + HInterID + "," + i + "," + subList[i].HProcID + "," + subList[i].HProcNo + "," + subList[i].HSupID + "," + Convert.ToString(subList[i].HSupFlag ? 1 : 0) + "" + "," + subList[i].HWorkQty + "," + HCenterID + ",'" + HTimeUnit + "'," + HUnitTime + "," + HReadyTime + "," + HQueueTime + "," + HMoveTime + ",'" + HCloseMan + "'," + Convert.ToString(HCloseType ? 1 : 0) + ",'" + subList[i].HRemark + "','" + HProcType + "'," + Convert.ToString(HNextProcFlag ? 1 : 0) + "," + Convert.ToString(HFlowProc ? 1 : 0) + "," + HFixPrice + "," + HProcPrice + "," + HBadPrice + "," + HWasterPrice + "," + Convert.ToString(HStdFlag ? 1 : 0) + "," + HBeginDayQty + "," + HBeginFixQty + "," + HSourceInterID + "," + HSourceEntryID + ",'" + HSourceBillNo + "','" + HSourceBillType + "'," + HRelationQty + "," + HRelationMoney + "," + Convert.ToString(HAutoTrunFlag ? 1 : 0) + "," + HFixWorkDays + "," + HTrunWorkDays + "," + HReadyTimes + "," + HICMOReadyTimes + "," + HSubStdEmpQty + "," + HSubCanUseSourceQty + "," + HProcID_S + "," + HCenterID_S + "," + HWorkQty_S + ", " + HSubStdEmpQty_S + ",'" + HMouldNo + "'," + HChangeMould + ",'" + HPackStd + "','" + HPack + "','" + HPutArea + "'," + HMyWorkDays + "," + HMyFixWorkDays + "," + subList[i].HPassRate + ") "); "(HInterID,HEntryID,HProcID,HProcNO,HSupID,HSupFlag" + ",HWorkQty,HCenterID,HTimeUnit,HUnitTime" + ",HReadyTime,HQueueTime,HMoveTime" + ",HCloseMan,HCloseType,HRemark,HProcType,HNextProcFlag,HFlowProc" + ",HFixPrice,HProcPrice,HBadPrice,HWasterPrice,HStdFlag,HBeginDayQty,HBeginFixQty" + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HAutoTrunFlag" + ",HFixWorkDays,HTrunWorkDays,HReadyTimes,HICMOReadyTimes,HSubStdEmpQty,HSubCanUseSourceQty" + ",HProcID_S,HCenterID_S,HWorkQty_S,HSubStdEmpQty_S,HMouldNo,HChangeMould" + ",HPackStd,HPack,HPutArea,HMyWorkDays,HMyFixWorkDays,HPassRate" + ",HTechnologyParameter,HPicNum,HProcCheckNote" + ",HOverRate,HProcWorkNum" + ") values(" + HInterID + "," + (hentryid==-1?i: hentryid) + "," + oSub.HProcID.ToString() + ",'" + (hentryid == -1 ? i : hentryid) + "'," + oSub.HSupID.ToString() + "," + Convert.ToString(oSub.HSupFlag ? 1 : 0) + "" + "," + oSub.HWorkQty.ToString() + "," + oSub.HCenterID.ToString() + ",'" + oSub.HTimeUnit.ToString() + "'," + oSub.HUnitTime.ToString() + "," + oSub.HReadyTime.ToString() + "," + oSub.HQueueTime.ToString() + "," + oSub.HMoveTime.ToString() + ",'" + oSub.HCloseMan + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "','" + oSub.HProcType + "'," + Convert.ToString(oSub.HNextProcFlag ? 1 : 0) + "," + Convert.ToString(oSub.HFlowProc ? 1 : 0) + "," + oSub.HFixPrice.ToString() + "," + oSub.HProcPrice.ToString() + "," + oSub.HBadPrice.ToString() + "," + oSub.HWasterPrice.ToString() + "," + Convert.ToString(oSub.HStdFlag ? 1 : 0) + "," + oSub.HBeginDayQty.ToString() + "," + oSub.HBeginFixQty.ToString() + "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + "," + Convert.ToString(oSub.HAutoTrunFlag ? 1 : 0) + "," + oSub.HFixWorkDays.ToString() + "," + oSub.HTrunWorkDays.ToString() + "," + oSub.HReadyTimes.ToString() + "," + oSub.HICMOReadyTimes.ToString() + "," + oSub.HSubStdEmpQty.ToString() + "," + oSub.HSubCanUseSourceQty.ToString() + "," + oSub.HProcID_S.ToString() + "," + oSub.HCenterID_S.ToString() + "," + oSub.HWorkQty_S.ToString() + ", " + oSub.HSubStdEmpQty_S.ToString() + ",'" + oSub.HMouldNo + "'," + oSub.HChangeMould.ToString() + ",'" + oSub.HPackStd + "','" + oSub.HPack + "','" + oSub.HPutArea + "'," + oSub.HMyWorkDays.ToString() + "," + oSub.HMyFixWorkDays.ToString() + "," + oSub.HPassRate.ToString() + ",'" + oSub.HTechnologyParameter.ToString() + "','" + oSub.HPicNum.ToString() + "','" + oSub.HProcCheckNote.ToString() + "', " + oSub.HOverRate.ToString() + ",'" + oSub.HProcWorkNum.ToString() + "'" + ") "); } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = null; @@ -283,6 +305,523 @@ return objJsonResult; } // #endregion #region 工艺路线 文件上传 [Route("Gy_RoutingBill/Gy_RoutingBillimport")] [HttpPost] public object Gy_RoutingBillimport() { try { var WorkBookName = HttpContext.Current.Request["WorkBookName"]; DBUtility.ClsPub.HOrgID = long.Parse(HttpContext.Current.Request["HOrgID"]); //获取文件名称 var file = HttpContext.Current.Request.Files[0]; //获取文件物理路径 string ExcelPath = HttpContext.Current.Server.MapPath("~/" + file.FileName); //保存文件 file.SaveAs(ExcelPath); NpoiHelper np = new NpoiHelper(); DataSet ExcelDs = np.ReadExcel(ExcelPath, 1,2, WorkBookName); //删除文件 File.Delete(ExcelPath); //创建临时表 DataTable tb2 = new DataTable("dt2"); //添加列名 for (int i = 0; i < ExcelDs.Tables[0].Columns.Count; i++) { tb2.Columns.Add(ExcelDs.Tables[0].Rows[0][i].ToString()); } //添加数据 for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++) { DataRow row = tb2.NewRow(); for (int j = 0; j < ExcelDs.Tables[0].Columns.Count; j++) { row[j] = ExcelDs.Tables[0].Rows[i][j].ToString(); } tb2.Rows.Add(row); } var error = ""; //查询工艺路线没有的列 if (!tb2.Columns.Contains("产品代码")) error += "没有找到【产品代码】的标题,"; if (!tb2.Columns.Contains("工序")) error += "没有找到【工序】的标题,"; if (!tb2.Columns.Contains("工作中心")) error += "没有找到【工作中心】的标题,"; if (!tb2.Columns.Contains("加工数量")) error += "没有找到【加工数量】的标题,"; if (!tb2.Columns.Contains("本道开工余量")) error += "没有找到【本道开工余量】的标题,"; if (!tb2.Columns.Contains("本道固定开工天数")) error += "没有找到【本道固定开工天数】的标题,"; if (!tb2.Columns.Contains("班产定额")) error += "没有找到【班产定额】的标题,"; if (!tb2.Columns.Contains("工序工价")) error += "没有找到【工序工价】的标题,"; if (!tb2.Columns.Contains("工序序号")) error += "没有找到【工序序号】的标题,"; if (!tb2.Columns.Contains("工艺参数")) error += "没有找到【工艺参数】的标题,"; if (!tb2.Columns.Contains("图纸编号")) error += "没有找到【图纸编号】的标题,"; if (!tb2.Columns.Contains("本工序确认记录")) error += "没有找到【本工序确认记录】的标题,"; if (!tb2.Columns.Contains("图号版本")) error += "没有找到【图号版本】的标题,"; if (!tb2.Columns.Contains("总装图号")) error += "没有找到【总装图号】的标题,"; if (!tb2.Columns.Contains("材质")) error += "没有找到【材质】的标题,"; if (!tb2.Columns.Contains("成品编号")) error += "没有找到【成品编号】的标题,"; if (!tb2.Columns.Contains("版本")) error += "没有找到【版本】的标题,"; if (!tb2.Columns.Contains("模具编号")) error += "没有找到【模具编号】的标题,"; if (!tb2.Columns.Contains("程序号")) error += "没有找到【程序号】的标题,"; if (!tb2.Columns.Contains("良率")) error += "没有找到【良率】的标题"; if (error.Length > 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = $"Excel模板存在错误,{error}\r\n" ; objJsonResult.data = null; return objJsonResult; } objJsonResult = (json)Checkdata(tb2); if (objJsonResult.code == "0") { return objJsonResult; } string hnumber = ""; if (tb2.Rows.Count > 0) { hnumber = DBUtility.ClsPub.isStrNull(tb2.Rows[0]["产品代码"].ToString()); } for (int i = 0; i <= tb2.Rows.Count - 1; i++) { string sHNumber = ""; if (DBUtility.ClsPub.isStrNull(tb2.Rows[i]["产品代码"].ToString()) != "") { // sHNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["产品代码"].ToString()); //审核代码是否合理 if (!DBUtility.ClsPub.AllowNumber(sHNumber)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "物料代码中不能出现连续‘.’并且首位末位不能为‘.’！"; objJsonResult.data = null; return objJsonResult; } if (hnumber == DBUtility.ClsPub.isStrNull(tb2.Rows[i]["产品代码"].ToString())) { //得到物料内码 if (!oMaterHlp.GetInfoByNumber(sHNumber)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "第" + (i+1).ToString() + "行," + sHNumber + "没有找到对应的物料！"; objJsonResult.data = null; return objJsonResult; } } else { hnumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["产品代码"].ToString()); sHNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["产品代码"].ToString()); //审核代码是否合理 if (!DBUtility.ClsPub.AllowNumber(sHNumber)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "物料代码中不能出现连续‘.’并且首位末位不能为‘.’！"; objJsonResult.data = null; return objJsonResult; } //得到物料内码 if (!oMaterHlp.GetInfoByNumber(sHNumber)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "第" + (i + 1).ToString() + "行," + sHNumber + "没有找到对应的物料！"; objJsonResult.data = null; return objJsonResult; } } } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "第" + (i + 1).ToString() + "行,没有找到对应的物料！"; objJsonResult.data = null; return objJsonResult; } } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = error; objJsonResult.data = tb2; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } //检查物料 private object Checkdata(DataTable dt) { bool b = false; string sErrMsg = ""; string sMsg = ""; for (int i = 0; i <= dt.Rows.Count - 1; i++) { string sHNumber = ""; string sHNamePoc = ""; string sHNumberCen = ""; Single sWorkQty = 0; Single sHPassRate = 0; // sHNumber = DBUtility.ClsPub.isStrNull(dt.Rows[i]["产品代码"].ToString()); sHNumberCen = DBUtility.ClsPub.isStrNull(dt.Rows[i]["工作中心"].ToString()); sHNamePoc = DBUtility.ClsPub.isStrNull(dt.Rows[i]["工序"].ToString()); sWorkQty = DBUtility.ClsPub.isSingle(dt.Rows[i]["加工数量"].ToString()); sHPassRate = DBUtility.ClsPub.isSingle(dt.Rows[i]["良率"].ToString()); if (sHNumber != "") { // int index = i + 1; //加工数量不能小于等于零 if (sWorkQty <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "第" + index + "行加工数量不能小于等于零！"; objJsonResult.data = null; return objJsonResult; } //良率不能小于等于零 if (sHPassRate <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "第" + index + "行良率不能小于等于零！"; objJsonResult.data = null; return objJsonResult; } //审核代码是否合理 if (!DBUtility.ClsPub.AllowNumber(sHNumber)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "物料代码中不能出现连续‘.’并且首位末位不能为‘.’！"; objJsonResult.data = null; return objJsonResult; } //得到物料内码 int j = i + 2; if (!oMaterHlp.GetInfoByNumber(sHNumber)) { sMsg = "[" + sHNumber + "]物料不存在"; if (sErrMsg.Contains(sMsg) == false) { sErrMsg = sErrMsg + "[" + sHNumber + "]物料不存在\r\n"; } b = true; } //得到工序内码 if (!oProcHlp.GetInfoByName(sHNamePoc)) { sMsg = "[" + sHNamePoc + "]工序不存在"; if (sErrMsg.Contains(sMsg) == false) { sErrMsg = sErrMsg + "[" + sHNamePoc + "]工序不存在\r\n"; } b = true; } //得到工作中心内码 if (!oCenHlp.GetInfoByName(sHNumberCen)) { sMsg = "[" + sHNumberCen + "]工作中心不存在"; if (sErrMsg.Contains(sMsg) == false) { sErrMsg = sErrMsg + "[" + sHNumberCen + "]工作中心不存在\r\n"; } b = true; } } } if (b == true) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = sErrMsg; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = sErrMsg; objJsonResult.data = null; return objJsonResult; } } #endregion #region 工艺路线 导入(保存) //临时字段 public class Gy_RoutingBill_temporary { public string HYear; public string HPeriod; public string DataAppend; public string HOrgID; } [Route("Gy_RoutingBill/Gy_RoutingBill_btnSave")] [HttpPost] public object Gy_RoutingBill_btnSave([FromBody] JObject sMainSub) { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); oCN.BeginTran(); //保存主表 objJsonResult = RoutAddBillMain(msg1); if (objJsonResult.code == "0") { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = objJsonResult.Message; objJsonResult.data = null; return objJsonResult; } oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "单据保存成功！"; objJsonResult.data = null; return objJsonResult; } public json RoutAddBillMain(string msg1) { string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string user = sArray[2].ToString(); try { if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Edit", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无保存权限！"; objJsonResult.data = null; return objJsonResult; } //表头字段 omdelMian = Newtonsoft.Json.JsonConvert.DeserializeObject<Gy_RoutingBill_temporary>(msg2); //JSON序列化转换字典集合 List<Dictionary<string, string>> list = new List<Dictionary<string, string>>(); List<object> jb = JsonConvert.DeserializeObject<List<object>>(msg3); foreach (JObject item in jb) { Dictionary<string, string> dic = new Dictionary<string, string>(); foreach (var itm in item.Properties()) { dic.Add(itm.Name, itm.Value.ToString()); } list.Add(dic); } var hnumber = ""; var HBillNo = ""; long HInterID = 0; for (int i = 0; i < list.Count; i++) { //获取物料数据 ds = oCN.RunProcReturn("select * from h_v_IF_Material Where HNumber=" + list[i]["产品代码"].ToString() + " and HUSEORGID=" + omdelMian.HOrgID, "h_v_IF_Material"); var HMaterNumber = list[i]["产品代码"].ToString(); var HMaterID = ds.Tables[0].Rows[0]["HItemID"].ToString(); var Hunitid = ds.Tables[0].Rows[0]["物料代码"].ToString(); var HUnitNumber = ds.Tables[0].Rows[0]["物料代码"].ToString(); //获取工序 ds = oCN.RunProcReturn("select * from Gy_Process Where HNumber=" + list[i]["工序代码"].ToString(), "Gy_Process"); var HProcID = ds.Tables[0].Rows[0]["HItemID"].ToString(); //获取工作中心 ds = oCN.RunProcReturn("select * from Gy_WorkCenter Where HNumber=" + list[i]["工作中心代码"].ToString(), "Gy_WorkCenter"); var HCenterID = ds.Tables[0].Rows[0]["HItemID"].ToString(); if (hnumber != list[i]["产品代码"].ToString()) { hnumber = list[i]["产品代码"].ToString(); HBillNo = DBUtility.ClsPub.CreateBillCode_Prod(BillType, ref DBUtility.ClsPub.sExeReturnInfo, true);//获得一个新的单据号 HInterID = DBUtility.ClsPub.CreateBillID_Prod(BillType, ref DBUtility.ClsPub.sExeReturnInfo);//获得一个新的id } var HName = list[i]["工艺路线名称"].ToString(); var HPicNumVer = list[i]["图号版本"].ToString(); var HPicNumAssemble = list[i]["总装图号"].ToString(); var HMaterTexture = list[i]["材质"].ToString(); var HProductNum = list[i]["成品编号"].ToString(); var HVerNum = list[i]["版本"].ToString(); //获取供应商 ds = oCN.RunProcReturn("select * from h_v_Gy_SupplierList Where HNumber=" + list[i]["供应商代码"].ToString(), "h_v_Gy_SupplierList"); var HSupID = ds.Tables[0].Rows[0]["HItemID"].ToString(); var HProcNo = list[i]["工序序号"].ToString(); var HTimeUnit = list[i]["时间单位"].ToString(); var hworkqty = list[i]["加工数量"].ToString(); var HFixPrice = list[i]["班产定额"].ToString(); var HMainPrice = list[i]["工序工价"].ToString(); var HBadPrice = list[i]["不合格单价"].ToString(); var HWasterPrice = list[i]["报废单价"].ToString(); var HBeginFixQty = list[i]["本道固定开工天数"].ToString(); var HBeginDayQty = list[i]["本道开工余量"].ToString(); var HFixWorkDays = list[i]["上道等待天数"].ToString(); var HTrunWorkDays = list[i]["上道循环周期"].ToString(); var HAutoTrunFlag = list[i]["自动转移"].ToString(); var HSupFlag = list[i]["外协标记"].ToString(); var HTechnologyParameter = list[i]["工艺参数"].ToString(); var HPicNum = list[i]["图纸编号"].ToString(); var HProcCheckNote = list[i]["本工序确认记录"].ToString(); var hpassrate = list[i]["良率"].ToString(); var hremark = list[i]["备注"].ToString(); var HMouldNo = list[i]["模具编号"].ToString(); var HProcWorkNum = list[i]["程序号"].ToString(); //物料分类 } // //主表 // oCN.RunProc("insert into Sc_WorkBillSortBillMain(HInterID,HBillNo,HYear,HPeriod,HBillType," + // "HBillSubType,HDate,HBillStatus,HMaker,HMakeDate,HICMOBillNo,HOrderType," + // "HICMOEntrySEQ,HWorkShopID,HSourceID, HYX, HEmpID," + // " HMaterID, HMaterName, HMaterModel, HUnitID, HBatchNo," + // " HSeOrderBillQty, HPlanQty, HCompleteQty,HPreparatDate," + // "HMainSourceInterID,HMainSourceEntryID)values" + // $"({HInterID},'{HBillNo}',{DateTime.Now.Year},{DateTime.Now.Month},'{BillType}'," + // $"'{BillType}',GETDATE(),1,'{user}','{HDate}','{HICMOBillNo}','{HOrderType}'," + // $"{(HICMOEntrySEQ == "" ? 0.ToString() : HICMOEntrySEQ)},{(HWorkShopID == "" ? 0.ToString() : HWorkShopID)},{(HSourceID == "" ? 0.ToString() : HSourceID)}, {(HYX == "" ? 0.ToString() : HYX)}, {(HEmpID == "" ? 0.ToString() : HEmpID)}," + // $" {(HMaterID == "" ? 0.ToString() : HMaterID)}, '{HMaterName}', '{HMaterModel}', {(HUnitID == "" ? 0.ToString() : HUnitID)}, '{HBatchNo}'," + // $" {(HSeOrderBillQty == "" ? 0.ToString() : HSeOrderBillQty)}, {(HPlanQty == "" ? 0.ToString() : HPlanQty)}, {(HCompleteQty == "" ? 0.ToString() : HCompleteQty)},getdate()," + // $" {HMainSourceInterID},{HMainSourceEntryID})"); //} // for (int j = 0; j < SumDay; j++) // { // //主表子表都有数据 // if (list[i][DateTime.Now.AddDays(j).ToString("yyyy-MM-dd")].ToString() != "") // { // SumCount += 1; // ////保存子表 // objJsonResult = RoutAddBillSub(HInterID == 0 ? list[i]["hmainid"].ToString() : HInterID.ToString() // , HBillNo == "" ? list[i]["单据号"].ToString() : HBillNo // , DateTime.Parse(DateTime.Now.AddDays(j).ToString("yyyy-MM-dd").ToString()) // , int.Parse(list[i][DateTime.Now.AddDays(j).ToString("yyyy-MM-dd")].ToString())); // if (objJsonResult.count == 1) // { // TrueCount += 1; // } // } // //主表有数据 子表无数据 // if (j == 30 && SumCount == 0 && HInterID != 0 && HBillNo != "") // { // objJsonResult = RoutAddBillSub(HInterID.ToString(), HBillNo, DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd").ToString()), 0); // } // } //} //if (TrueCount != SumCount) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = objJsonResult.Message; // objJsonResult.data = null; // return objJsonResult; //} objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = null; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion } }
