using Newtonsoft.Json; using Newtonsoft.Json.Linq; using Pub_Class; using SyntacticSugar.constant; using System; using System.Collections.Generic; using System.Data; using System.IO; using System.Web; using System.Web.Http; using System.Windows.Forms; using WebAPI.Controllers.SCGL.日计划管理; using WebAPI.Models; namespace WebAPI.Controllers { //工艺路线Controller public class Gy_RoutingBillController : ApiController { public DBUtility.ClsPub.Enum_BillStatus BillStatus; private json objJsonResult = new json(); 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(); DAL.ClsGy_Warehouse_View oCenWare = new DAL.ClsGy_Warehouse_View(); DAL.ClsGy_Source_View oSourceHlp = new DAL.ClsGy_Source_View(); Gy_RoutingBill_temporary omdelMian = new Gy_RoutingBill_temporary(); public string BillType = "3301"; Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); string user_LongShan = ""; string HName_LongShan = ""; #region 未知 /// /// 未知 ///参数：string sql。 ///返回值：object。 /// [Route("Gy_RoutingBill/list")] [HttpGet] public object list(string sWhere) { try { if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_MES_StationEntrustOutBillList " + sWhere, "h_v_MES_StationEntrustOutBillList"); } else { string sql1 = "select * from h_v_MES_StationEntrustOutBillList where 1 = 1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "h_v_MES_StationEntrustOutBillList"); } if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "false！"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 工艺路线 新增 /// /// 新增单据-保存按钮 ///参数：string sql。 ///返回值：object。 /// [Route("Gy_RoutingBill/AddBill")] [HttpPost] public object AddBill([FromBody] JObject sMainSub) { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); oCN.BeginTran(); //保存主表 objJsonResult = AddBillMain(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 = ds.Tables[0]; return objJsonResult; } public json AddBillMain(string msg1) { string sErrMsg = ""; oSystemParameter.ShowBill(ref sErrMsg); 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[2].ToString());//数据类型 1添加 3修改 2 复制 4添加子工艺路线 string user = sArray[3].ToString();//用户名 string HComputerName = SystemInformation.ComputerName; //设备名称 user_LongShan = sArray[3].ToString();//用户名 string HBillSubType = sArray[4].ToString();//单据子类型 try { if (HBillSubType == "3301") { //判断是否有编辑权限 if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Edit", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "工艺路线无权限编辑!"; objJsonResult.data = null; return objJsonResult; } } else { //判断是否有编辑权限 if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Sub_Edit", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "子工艺路线无权限编辑!"; objJsonResult.data = null; return objJsonResult; } } msg2 = "[" + msg2.ToString() + "]"; List mainList = Newtonsoft.Json.JsonConvert.DeserializeObject>(msg2); long HInterID = mainList[0].HInterID;//递入type得到的单据ID string HBillNo = mainList[0].HBillNo;//递入type得到的单据号 DateTime HDate = OperationType == 4 ? DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")) : mainList[0].HDate;//日期 int HYear = DateTime.Now.Year; double HPeriod = DateTime.Now.Month; string HRemark = mainList[0].HRemark;//备注 string HMaker = mainList[0].HMaker;//制单人 long HMaterID = mainList[0].HMaterID;//产品ID string HName = mainList[0].HName;//工艺路线名称 long HMaterTypeID = 0; long HRoutingGroupID = mainList[0].HRoutingGroupID;//工艺路线大类ID long HUnitID = mainList[0].HUnitID;//计量单位 string HMaterNumber = mainList[0].HMaterNumber;//产品代码 long HUnitNumber = mainList[0].HUnitID;//计量单位ID bool HStandard = mainList[0].HStandard;//是否默认工艺 long HMainGroupID = mainList[0].HGroupID;//生产班组ID long HMainProcID = mainList[0].HMainProcID;//工序ID long HMainCenterID = mainList[0].HMainCenterID;//工作中心ID string HMainTimeUnit = mainList[0].HMainTimeUnit;//运行时间单位 double HMainUnitTime = mainList[0].HMainUnitTime;//运行时间 double HMainWorkQty = mainList[0].HMainWorkQty;//加工数量 double HMainPrice = mainList[0].HMainPrice;//工价 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;//版本 int IsProNo = mainList[0].IsProNo;//是否转工序 HName_LongShan = mainList[0].HName;//工艺路线名称 string HProcPriceType = mainList[0].HProcPriceType;//定额类型（临时定额，永久定额） DateTime HBeginDate = mainList[0].HBeginDate;//开始日期 DateTime HEndDate = mainList[0].HEndDate;//失效日期 if (oSystemParameter.omodel.WMS_CampanyName == "凯贝奈特") { if (HPicNumVer == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "图号版本不能为空!"; objJsonResult.data = null; return objJsonResult; } if (HPicNumAssemble == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "总装图号不能为空!"; objJsonResult.data = null; return objJsonResult; } if (HMaterTexture == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "材质不能为空!"; objJsonResult.data = null; return objJsonResult; } if (HProductNum == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "成品编号不能为空!"; objJsonResult.data = null; return objJsonResult; } if (HVerNum == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "版本不能为空!"; objJsonResult.data = null; return objJsonResult; } } else if (oSystemParameter.omodel.WMS_CampanyName == "添康科技") { DataSet dss; dss = oCN.RunProcReturn("select COUNT(*) as number from Sc_ProcessExchangeBillMain where HRoutingBillID = " + HInterID, "Gy_RoutingBillMain"); //判断是否可编辑 if (dss.Tables[0].Rows[0]["number"].ToString() != "0") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "此单据已经被引用，不允许修改！"; objJsonResult.data = 1; return objJsonResult; } } if (OperationType == 2) { ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList where 单据号='" + HBillNo + "'", "h_v_Gy_RoutingBillList"); if (ds.Tables[0].Rows.Count > 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据号重复,请重新输入!"; objJsonResult.data = null; return objJsonResult; } } ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList where hmainid=" + HInterID + " and 单据号='" + HBillNo + "'", "h_v_Gy_RoutingBillList"); if ((OperationType == 1 || OperationType == 2) && ds.Tables[0].Rows.Count == 0)//新增 { //保存前控制========================================= string HBillNote = ""; ds = oCN.RunProcReturn("Exec h_p_Gy_RoutingBill_BeforeSaveCtrl " + HInterID.ToString() + ", '" + HBillNo + "','" + HBillNote + "',1 ", " h_p_Gy_RoutingBill_BeforeSaveCtrl "); if (ds == null) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存前判断失败！"; objJsonResult.data = null; return objJsonResult; } if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]); objJsonResult.data = null; return objJsonResult; } //========================================================= //主表 oCN.RunProc("Insert Into Gy_RoutingBillMain " + "(HBillType,HBillSubType,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,HProcPriceType,HBeginDate,HEndDate) " + " values('" + BillType + "','"+ HBillSubType + "'," + 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 + ",'"+ HProcPriceType + "','" + HBeginDate + "','" + HEndDate + "') "); //=========================保存后控制 添加审批流 //DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RoutingBill_AfterSaveCtrl " + HInterID.ToString() + ", '" + HBillNo + "',1 ", "h_p_Gy_RoutingBill_AfterSaveCtrl"); //if (ds2 == null) //{ // oCN.RollBack(); // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "保存后控制判断失败！"; // objJsonResult.data = null; // return objJsonResult; //} //if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0") //{ // oCN.RollBack(); // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "保存失败2！" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]); // objJsonResult.data = null; // return objJsonResult; //} //============================ LogService.Write("用户:" + user + ",日期:" + DateTime.Now + ",新增工艺路线单据:" + HBillNo); oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "新增工艺路线单据：" + HBillNo + "','LMES-工艺路线模块','" + DBUtility.ClsPub.IPAddress + "','新增单据'", ref DBUtility.ClsPub.sExeReturnInfo); } else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) { //修改 if (oSystemParameter.omodel.WMS_CampanyName == "乔一") { } else { //修改 DataSet dss; dss = oCN.RunProcReturn("select * from Gy_RoutingBillMain where HInterID=" + HInterID + " and HBillNo='" + HBillNo + "'", "Gy_RoutingBillMain"); //判断是否可编辑 if ((dss.Tables[0].Rows[0]["HChecker"].ToString() != "" && dss.Tables[0].Rows[0]["HChecker"] != null) || (dss.Tables[0].Rows[0]["HBillStatus"].ToString() != "1" && dss.Tables[0].Rows[0]["HBillStatus"].ToString() != "0" && dss.Tables[0].Rows[0]["HBillStatus"].ToString() != "5")) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "此单据状态未在创建，不允许修改！"; objJsonResult.data = 1; return objJsonResult; } } //保存前控制========================================= string HBillNote = ""; ds = oCN.RunProcReturn("Exec h_p_Gy_RoutingBill_BeforeSaveCtrl " + HInterID.ToString() + ", '" + HBillNo + "','" + HBillNote + "',2 ", " h_p_Gy_RoutingBill_BeforeSaveCtrl "); if (ds == null) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存前判断失败！"; objJsonResult.data = null; return objJsonResult; } if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]); objJsonResult.data = null; return objJsonResult; } //========================================================= oCN.RunProc("update Gy_RoutingBillMain set " + "HDate='" + HDate + "',HYear='" + HYear + "',HPeriod='" + HPeriod + "',HRemark='" + HRemark + "',hupdater='" + HMaker + "',hupdatedate=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 + "',HProcPriceType = '" + HProcPriceType + "',HBeginDate = '" + HBeginDate + "',HEndDate = '" + HEndDate + "' where HInterID='" + HInterID + "'"); //删除子表 oCN.RunProc("delete from Gy_RoutingBillSub where HInterID='" + HInterID + "'"); //=========================保存后控制 添加审批流 //DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RoutingBill_AfterSaveCtrl " + HInterID.ToString() + ", '" + HBillNo + "',2 ", "h_p_Gy_RoutingBill_AfterSaveCtrl"); //if (ds2 == null) //{ // oCN.RollBack(); // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "保存后控制判断失败！"; // objJsonResult.data = null; // return objJsonResult; //} //if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0") //{ // oCN.RollBack(); // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "保存失败2！" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]); // objJsonResult.data = null; // return objJsonResult; //} //============================ LogService.Write("用户:" + user + ",日期:" + DateTime.Now + ",修改工艺路线单据:" + HBillNo); oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "修改工艺路线单据：" + HBillNo + "','LMES-工艺路线模块','" + DBUtility.ClsPub.IPAddress + "','修改单据'", ref DBUtility.ClsPub.sExeReturnInfo); } //保存子表 objJsonResult = AddBillSub(msg3, HInterID, OperationType); if (objJsonResult.code == "0") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = objJsonResult.Message; objJsonResult.data = null; return objJsonResult; } if (oSystemParameter.omodel.WMS_CampanyName == "瑞与祺") { if (oSystemParameter.omodel.Gy_RoutingBill_SaveAutoLastProc == "Y" && OperationType == 1) { ds = oCN.RunProcReturn("select * from Gy_Process Where HTProcessFlag = 1 and HNumber='9999' ", "Gy_Process"); if (ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "未设置转工序!"; objJsonResult.data = null; return objJsonResult; } //设置转工序 oCN.RunProc("exec Gy_RoutingBill_LastProNo " + HInterID); } } else if (IsProNo == 1 && (OperationType == 1)) { ds = oCN.RunProcReturn("select * from Gy_Process Where HTProcessFlag = 1 and HNumber='9999' ", "Gy_Process"); if (ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "未设置转工序!"; objJsonResult.data = null; return objJsonResult; } //设置转工序 oCN.RunProc("exec Gy_RoutingBill_LastProNo " + HInterID); } if (oSystemParameter.omodel.WMS_CampanyName == "乔一") { //是否勾选默认工艺路线 if (HStandard) { //设置默认工艺路线 oCN.RunProc("exec h_p_Gy_RoutingBillCheck " + HInterID + ",'" + user + "'"); } } //判断是否重复工序号 ds = oCN.RunProcReturn("exec h_p_Gy_RoutingCtrl " + HInterID, "h_p_Gy_RoutingCtrl"); if (OperationType == 1) { if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; 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"; 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; } } public json AddBillSub(string msg3, long HInterID,int OperationType) { List DetailColl = Newtonsoft.Json.JsonConvert.DeserializeObject>(msg3); int i = 0; string Ret = ""; oSystemParameter.ShowBill(ref Ret); foreach (Gy_RoutingBillSub oSub in DetailColl) { i++; if (oSystemParameter.omodel.WMS_CampanyName != "龙山汽配" && oSystemParameter.omodel.WMS_CampanyName != "添康科技" && oSystemParameter.omodel.WMS_CampanyName != "宝工") { if (oSub.HWorkQty <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "第" + i + "行，加工数量不能为0或者小于0"; objJsonResult.data = null; return objJsonResult; } } //如果工价为0，则工价字段不做为必填字段 if (oSub.HProcPrice == 0 && oSystemParameter.omodel.WMS_CampanyName == "龙山汽配") { 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,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,HBadWHID,HWasterWHID, HWHID,HIsTime,HEstimate " + ",HWorkTimes_S,HSortProcFlag,HSubStdEmpAvg_S,HYDCoefficient" + ") values(" + HInterID + "," + i + "," + oSub.HProcID.ToString() + ",'" + oSub.HProcNo + "'," + 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.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() + "'," + oSub.HBadWHID.ToString() + "," + oSub.HWasterWHID.ToString() + "," + oSub.HWHID.ToString() + "," + Convert.ToString(oSub.HIsTime ? 1 : 0) + "," + oSub.HEstimate.ToString() + ", " + oSub.HWorkTimes_S.ToString() + "," + Convert.ToString(oSub.HSortProcFlag ? 1 : 0) + "," + oSub.HSubStdEmpAvg_S + "," + oSub.HYDCoefficient + ") "); //计价方式不为计时，则把计时暂估字段更新为空 if (oSub.HIsTime == false) { oCN.RunProc("update Gy_RoutingBillSub set HEstimate = 0 where HInterID = " + HInterID + " and HEntryID = " + i); } if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) { string HComputerName = SystemInformation.ComputerName; //设备名称 oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user_LongShan + "','" + HComputerName + "','" + "Gy_RoutingBill_Edit,工艺路线_编辑" + "','LMES系统-工艺路线编辑模块','" + DBUtility.ClsPub.IPAddress + "','" + "修改了工艺路线：" + HName_LongShan + " 工序号：" + oSub.HProcNo + " 工价为：" + oSub.HProcPrice.ToString() + "'", ref DBUtility.ClsPub.sExeReturnInfo); } } else { 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" + ",HTechnologyParameter,HPicNum,HProcCheckNote" + ",HOverRate,HProcWorkNum,HBadWHID,HWasterWHID, HWHID,HEstimate,HIsTime" + ",HQCSchemeID_Fst,HQCSchemeID_Proc,HQCSchemeID_Patrol" + ",HWorkTimes_S,HSortProcFlag,HSNCtrl,HQCFst,HQCProc,HQCPatrol,HMaterToSourceCtrl,HSubStdEmpAvg_S,HYDCoefficient" + ") values(" + HInterID + "," + i + "," + oSub.HProcID.ToString() + ",'" + oSub.HProcNo + "'," + 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() + "'," + oSub.HBadWHID.ToString() + "," + oSub.HWasterWHID.ToString() + "," + oSub.HWHID.ToString() + "," + oSub.HEstimate.ToString() + "," + Convert.ToString(oSub.HIsTime ? 1 : 0) + "," + oSub.HQCSchemeID_Fst + "," + oSub.HQCSchemeID_Proc + "," + oSub.HQCSchemeID_Patrol + ", " + oSub.HWorkTimes_S.ToString() + "," + Convert.ToString(oSub.HSortProcFlag ? 1 : 0) + "," + Convert.ToString(oSub.HSNCtrl ? 1 : 0) + "," + Convert.ToString(oSub.HQCFst ? 1 : 0) + "," + Convert.ToString(oSub.HQCProc ? 1 : 0) + "," + Convert.ToString(oSub.HQCPatrol ? 1 : 0) + "," + Convert.ToString(oSub.HMaterToSourceCtrl ? 1 : 0) + "," + oSub.HSubStdEmpAvg_S + "," + oSub.HYDCoefficient + ") "); //计价方式不为计时，则把计时暂估字段更新为空 if (oSub.HIsTime == false) { oCN.RunProc("update Gy_RoutingBillSub set HEstimate = 0 where HInterID = " + HInterID + " and HEntryID = " + i); } if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) { string HComputerName = SystemInformation.ComputerName; //设备名称 oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user_LongShan + "','" + HComputerName + "','" + "Gy_RoutingBill_Edit,工艺路线_编辑" + "','LMES系统-工艺路线编辑模块','" + DBUtility.ClsPub.IPAddress + "','" + "修改了工艺路线：" + HName_LongShan + " 工序号：" + oSub.HProcNo + " 工价为：" + oSub.HProcPrice.ToString() + "'", ref DBUtility.ClsPub.sExeReturnInfo); } } ////保存后控制========================================= 添加审批流 ds = oCN.RunProcReturn("exec h_p_Gy_RoutingBill_AfterSaveCtrl " + HInterID + ",'',"+ OperationType, "h_p_Gy_RoutingBill_AfterSaveCtrl"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存后判断失败！"; objJsonResult.data = null; return objJsonResult; } if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]); objJsonResult.data = null; return objJsonResult; } ////========================================================= } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = null; objJsonResult.data = null; return objJsonResult; } //工艺路线孙表 新增 [Route("Gy_RoutingBillSub/AddWorkQty")] [HttpPost] public object AddWorkQty([FromBody] JObject sMainSub) { try { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string user = sArray[1].ToString(); //判断是否有编辑权限 if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Edit", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "工艺路线无权限编辑!"; objJsonResult.data = null; return objJsonResult; } List DetailColl = Newtonsoft.Json.JsonConvert.DeserializeObject>(msg2); int i = 0; oCN.BeginTran();//开始事物 foreach (Gy_RoutingBillSub_WorkQty oSub in DetailColl) { i++; if (i == 1) { //先删除历史绑定数据后在重新保存 oCN.RunProc("delete from Gy_RoutingBillSub_WorkQty where HInterID = " + oSub.HInterID + " and HEntryID = " + oSub.HEntryID); }; oCN.RunProc($"insert into Gy_RoutingBillSub_WorkQty" + $"(HInterID,HEntryID,HEntrySubID,HSourceID,HWorkQty_Source,HEntryStdEmpQty,HEntryStdEmpAvg,HSortNum,HRemark)" + $"values({oSub.HInterID},{oSub.HEntryID},{i},{oSub.HSourceID},{oSub.HWorkQty_Source},{oSub.HEntryStdEmpQty}" + $",{oSub.HEntryStdEmpAvg},{oSub.HSortNum},'{oSub.HRemark}')"); } oCN.Commit();//提交事物 objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "保存成功！"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { oCN.RollBack();//回滚事物 objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 工艺路线孙表编辑获取数据 [Route("Gy_RoutingBill/EditWorkQty")] [HttpGet] public object EditWorkQty(long HInterID,long HEntryID) { try { ds = oCN.RunProcReturn($"select * from h_v_Gy_RoutingBillSub_WorkQtyEdit where hmainid={HInterID} and hsubid={HEntryID} order by HEntrySubID asc", "h_v_Gy_RoutingBillSub_WorkQtyEdit"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "false！"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 临时定额报表 /// /// 返回工艺路线列表 ///参数：string sql。 ///返回值：object。 /// [Route("Gy_RoutingBill/getProcPriceTypeChangeReport")] [HttpGet] public object getProcPriceTypeChangeReport(string sWhere, string user) { DataSet ds; try { //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Query", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "临时定额报表无权限查询!"; objJsonResult.data = null; return objJsonResult; } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ds = oCN.RunProcReturn("select * from h_v_Pay_ProcPriceTypeChangeReport where 1 = 1" + sWhere + " order by hmainid desc", "h_v_Pay_ProcPriceTypeChangeReport"); } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } return GetObjectJson(ds); } #endregion #region 临时定额报表 永久定额 /// /// 返回工艺路线列表 ///参数：string sql。 ///返回值：object。 /// [Route("Gy_RoutingBill/updateProcPriceType")] [HttpGet] public object updateProcPriceType(string HInterID, string user) { DataSet ds; 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; } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ds = oCN.RunProcReturn("Update Gy_RoutingBillMain set HProcPriceType = '永久定额' where HInterID = " + HInterID , "Gy_RoutingBillMain"); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "更改定额成功"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "出现错误！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 工艺路线编辑获取数据 [Route("Gy_RoutingBill/cx")] [HttpGet] public object cx(long HInterID) { try { ds = oCN.RunProcReturn("select a.*,m.HProcPriceType,m.HBeginDate,m.HEndDate,s.HQCProc,s.HQCFst,s.HQCPatrol,s.HMaterToSourceCtrl from h_v_Gy_RoutingBill_Edit as a,Gy_RoutingBillMain as m,Gy_RoutingBillSub as s where m.HInterID = hmainid and s.HInterID = hmainid and s.HEntryID = hsubid and hmainid =" + HInterID, "h_v_Gy_RoutingBillList"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "false！"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 工艺路线列表 查询系统参数 /// /// 返回工艺路线列表 ///参数：string sql。 ///返回值：object。 /// [Route("LEMS/MES_XT_List")] [HttpGet] public object MES_XT_List(string sWhere) { try { string sErrMsg = ""; oSystemParameter.ShowBill(ref sErrMsg); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = ""; objJsonResult.data = oSystemParameter.omodel; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; 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"); DataTable tb3 = new DataTable("dt3"); //添加列名 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 (!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; } 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 (!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; } } //删除临时表数据 oCN.RunProc("delete from diyipi"); //临时表添加数据 for (int i = 0; i < tb2.Rows.Count; i++) { oCN.RunProc(@"insert into diyipi(产品代码,产品名称,工序序号,工序代码,工序,工作中心,加工数量 , 良率, 工序工价, 不合格单价, 报废单价, 本道固定开工天数, 本道开工余量, 上道等待天数 , 上道循环周期, 自动转移, 外协标记, 供应商代码, 供应商, 工艺参数, 图纸编号 , 本工序确认记录, 备注, 图号版本, 总装图号, 材质, 成品编号, 版本 , 模具编号, 程序号, 班产定额, 工艺路线名称, 时间单位,工艺路线代码,不良品仓,报废品仓,良品仓)values ('" + tb2.Rows[i]["产品代码"].ToString() + "','" + tb2.Rows[i]["产品名称"].ToString() + "','" + tb2.Rows[i]["工序序号"].ToString() + "','" + tb2.Rows[i]["工序代码"].ToString() + "','" + tb2.Rows[i]["工序"].ToString() + "','" + tb2.Rows[i]["工作中心"].ToString() + "','" + tb2.Rows[i]["加工数量"].ToString() + "'" + ",'" + tb2.Rows[i]["良率"].ToString() + "','" + (tb2.Rows[i]["工序工价"].ToString() == "" ? "0" : tb2.Rows[i]["工序工价"].ToString()) + "','" + tb2.Rows[i]["不合格单价"].ToString() + "','" + tb2.Rows[i]["报废单价"].ToString() + "','" + tb2.Rows[i]["本道固定开工天数"].ToString() + "','" + tb2.Rows[i]["本道开工余量"].ToString() + "','" + tb2.Rows[i]["上道等待天数"].ToString() + "'" + ",'" + tb2.Rows[i]["上道循环周期"].ToString() + "','" + tb2.Rows[i]["自动转移"].ToString() + "','" + tb2.Rows[i]["外协标记"].ToString() + "','" + tb2.Rows[i]["供应商代码"].ToString() + "','" + tb2.Rows[i]["供应商"].ToString() + "','" + tb2.Rows[i]["工艺参数"].ToString() + "','" + tb2.Rows[i]["图纸编号"].ToString() + "'" + ",'" + tb2.Rows[i]["本工序确认记录"].ToString() + "','" + tb2.Rows[i]["备注"].ToString() + "','" + tb2.Rows[i]["图号版本"].ToString() + "','" + tb2.Rows[i]["总装图号"].ToString() + "','" + tb2.Rows[i]["材质"].ToString() + "','" + tb2.Rows[i]["成品编号"].ToString() + "','" + tb2.Rows[i]["版本"].ToString() + "'" + ",'" + tb2.Rows[i]["模具编号"].ToString() + "','" + tb2.Rows[i]["程序号"].ToString() + "','" + tb2.Rows[i]["班产定额"].ToString() + "','" + tb2.Rows[i]["工艺路线名称"].ToString() + "','" + tb2.Rows[i]["时间单位"].ToString() + "','" + tb2.Rows[i]["工艺路线代码"].ToString() + "','" + tb2.Rows[i]["不良品仓"].ToString() + "','" + tb2.Rows[i]["报废品仓"].ToString() + "','" + tb2.Rows[i]["良品仓"].ToString() + "')"); } 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; } string sErr = ""; if (oSystemParameter.ShowBill(ref sErr)) { if (oSystemParameter.omodel.WMS_CampanyName == "瑞与祺") { string HBadWHName = ""; //不良品仓 string HWasterWHName = ""; //报废品仓 string HWHName = ""; //良品仓 HBadWHName = DBUtility.ClsPub.isStrNull(dt.Rows[i]["不良品仓"].ToString()); HWasterWHName = DBUtility.ClsPub.isStrNull(dt.Rows[i]["报废品仓"].ToString()); HWHName = DBUtility.ClsPub.isStrNull(dt.Rows[i]["良品仓"].ToString()); //判断是否为空 if (HBadWHName == "") { sErrMsg = sErrMsg + "第" + index + "行 :不良品仓不能为空 !\r\n"; b = true; } if (HWasterWHName == "") { sErrMsg = sErrMsg + "第" + index + "行 :报废品仓不能为空 !\r\n"; b = true; } if (HWHName == "") { sErrMsg = sErrMsg + "第" + index + "行 :良品仓不能为空 !\r\n"; b = true; } //判断仓库是否重复 if (HBadWHName == HWasterWHName) { sErrMsg = sErrMsg + "不良品仓和报废品仓重复\r\n"; b = true; } if (HWasterWHName == HWHName) { sErrMsg = sErrMsg + "报废品仓和良品仓重复\r\n"; b = true; } if (HBadWHName == HWHName) { sErrMsg = sErrMsg + "不良品仓和良品仓重复\r\n"; b = true; } //得到仓库内码 if (!oCenWare.GetInfoByName(HBadWHName)) { sMsg = "[" + HBadWHName + "]仓库不存在"; if (sErrMsg.Contains(sMsg) == false) { sErrMsg = sErrMsg + "[" + HBadWHName + "]仓库不存在\r\n"; } b = true; } if (!oCenWare.GetInfoByName(HWasterWHName)) { sMsg = "[" + HWasterWHName + "]仓库不存在"; if (sErrMsg.Contains(sMsg) == false) { sErrMsg = sErrMsg + "[" + HWasterWHName + "]仓库不存在\r\n"; } b = true; } if (!oCenWare.GetInfoByName(HWHName)) { sMsg = "[" + HWHName + "]仓库不存在"; if (sErrMsg.Contains(sMsg) == false) { sErrMsg = sErrMsg + "[" + HWHName + "]仓库不存在\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; public Int64 HTProcessFlag; } [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.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(msg2); ds = oCN.RunProcReturn("select distinct 产品代码,isnull(工艺路线代码,'') 工艺路线代码 from diyipi ", "diyipi"); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { var HBillNo = ds.Tables[0].Rows[i]["工艺路线代码"].ToString();//获得一个新的单据号 if (HBillNo == "") { DataSet dataSet = oCN.RunProcReturn($"select HBillNo from Gy_RoutingBillMain where HBillNo='1' ", "Gy_RoutingBillMain"); while (1 == 1) { if (HBillNo != "") { if (dataSet.Tables[0].Rows.Count == 0) { break; } } HBillNo = DBUtility.ClsPub.CreateBillCode(BillType, ref DBUtility.ClsPub.sExeReturnInfo, true); dataSet = oCN.RunProcReturn($"select HBillNo from Gy_RoutingBillMain where HBillNo='{HBillNo}' ", "Gy_RoutingBillMain"); } } var HInterID = DBUtility.ClsPub.CreateBillID_Prod(BillType, ref DBUtility.ClsPub.sExeReturnInfo);//获得一个新的id oCN.RunProc($"exec Gy_RoutingBill_Excel '{ds.Tables[0].Rows[i]["产品代码"].ToString()}',{HInterID},'{HBillNo}','{user}',{omdelMian.HOrgID},{omdelMian.HTProcessFlag} "); } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "导入完成,共" + ds.Tables[0].Rows.Count + "个工艺路线"; 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 #region 工艺路线_孙表 文件上传 [Route("Gy_RoutingBill/Gy_RoutingBillimport_WorkQty")] [HttpPost] public object Gy_RoutingBillimport_WorkQty() { try { var WorkBookName = HttpContext.Current.Request["WorkBookName"]; DBUtility.ClsPub.HOrgID = long.Parse(HttpContext.Current.Request["HOrgID"]); Int64 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"); DataTable tb3 = new DataTable("dt3"); //添加列名 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 (!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_WorkQty(tb2); if (objJsonResult.code == "0") { return objJsonResult; } //删除临时表数据 oCN.RunProc("delete from diyipi_WorkQty"); //临时表添加数据 for (int i = 0; i < tb2.Rows.Count; i++) { string sql_temp = "insert into diyipi_WorkQty(工艺路线代码,工艺路线名称, 产品代码,产品名称,工序序号,工序代码,工序,工作中心,加工数量" + //", 良率, 工序工价, 不合格单价, 报废单价, 本道固定开工天数, 本道开工余量, 上道等待天数" + //", 上道循环周期, 自动转移, 外协标记, 供应商代码, 供应商, 工艺参数, 图纸编号" + //", 本工序确认记录, 备注, 图号版本, 总装图号, 材质, 成品编号, 版本" + //", 模具编号, 程序号, 班产定额, 时间单位,不良品仓,报废品仓,良品仓" + ",生产资源代码,HOrgID" + ") " + " values(" + "'" + tb2.Rows[i]["工艺路线代码"].ToString() + "'" + ",'" + tb2.Rows[i]["工艺路线名称"].ToString() + "'" + ",'" + tb2.Rows[i]["产品代码"].ToString() + "'" + ",'" + tb2.Rows[i]["产品名称"].ToString() + "'" + ",'" + tb2.Rows[i]["工序序号"].ToString() + "'" + ",'" + tb2.Rows[i]["工序代码"].ToString() + "'" + ",'" + tb2.Rows[i]["工序"].ToString() + "'" + ",'" + tb2.Rows[i]["工作中心"].ToString() + "'" + ",'" + tb2.Rows[i]["加工数量"].ToString() + "'" + //",'" + tb2.Rows[i]["良率"].ToString() + "'" + //",'" + (tb2.Rows[i]["工序工价"].ToString() == "" ? "0" : tb2.Rows[i]["工序工价"].ToString()) + "'" + //",'" + tb2.Rows[i]["不合格单价"].ToString() + "'" + //",'" + tb2.Rows[i]["报废单价"].ToString() + "'" + //",'" + tb2.Rows[i]["本道固定开工天数"].ToString() + "'" + //",'" + tb2.Rows[i]["本道开工余量"].ToString() + "'" + //",'" + tb2.Rows[i]["上道等待天数"].ToString() + "'" + //",'" + tb2.Rows[i]["上道循环周期"].ToString() + "'" + //",'" + tb2.Rows[i]["自动转移"].ToString() + "'" + //",'" + tb2.Rows[i]["外协标记"].ToString() + "'" + //",'" + tb2.Rows[i]["供应商代码"].ToString() + "'" + //",'" + tb2.Rows[i]["供应商"].ToString() + "'" + //",'" + tb2.Rows[i]["工艺参数"].ToString() + "'" + //",'" + tb2.Rows[i]["图纸编号"].ToString() + "'" + //",'" + tb2.Rows[i]["本工序确认记录"].ToString() + "'" + //",'" + tb2.Rows[i]["备注"].ToString() + "'" + //",'" + tb2.Rows[i]["图号版本"].ToString() + "'" + //",'" + tb2.Rows[i]["总装图号"].ToString() + "'" + //",'" + tb2.Rows[i]["材质"].ToString() + "'" + //",'" + tb2.Rows[i]["成品编号"].ToString() + "'" + //",'" + tb2.Rows[i]["版本"].ToString() + "'" + //",'" + tb2.Rows[i]["模具编号"].ToString() + "'" + //",'" + tb2.Rows[i]["程序号"].ToString() + "'" + //",'" + tb2.Rows[i]["班产定额"].ToString() + "'" + //",'" + tb2.Rows[i]["时间单位"].ToString() + "'" + //",'" + tb2.Rows[i]["不良品仓"].ToString() + "'" + //",'" + tb2.Rows[i]["报废品仓"].ToString() + "'" + //",'" + tb2.Rows[i]["良品仓"].ToString() + "'" + ",'" + tb2.Rows[i]["生产资源代码"].ToString() + "'" + "," + HOrgID + "" + ")"; oCN.RunProc(sql_temp); } 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_WorkQty(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; string sHNumberSource = ""; sHNumber = DBUtility.ClsPub.isStrNull(dt.Rows[i]["产品代码"].ToString()); sHNamePoc = DBUtility.ClsPub.isStrNull(dt.Rows[i]["工序序号"].ToString()); sHNamePoc = DBUtility.ClsPub.isStrNull(dt.Rows[i]["工序"].ToString()); sWorkQty = DBUtility.ClsPub.isSingle(dt.Rows[i]["加工数量"].ToString()); //sHNumberCen = DBUtility.ClsPub.isStrNull(dt.Rows[i]["工作中心"].ToString()); //sHPassRate = DBUtility.ClsPub.isSingle(dt.Rows[i]["良率"].ToString()); sHNumberSource = DBUtility.ClsPub.isStrNull(dt.Rows[i]["生产资源代码"].ToString()); if (sHNumber != "") { //记录检验数据的所在行 int index = i + 1; //得到物料内码 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 (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; //} ////得到工作中心内码 //if (!oCenHlp.GetInfoByName(sHNumberCen)) //{ // sMsg = "[" + sHNumberCen + "]工作中心不存在"; // if (sErrMsg.Contains(sMsg) == false) // { // sErrMsg = sErrMsg + "[" + sHNumberCen + "]工作中心不存在\r\n"; // } // b = true; //} //拆分【生产资源代码】，并逐个验证 if (sHNumberSource != "") { char[] delimiter = new char[] { ',' }; string[] sHNumberSourceList = sHNumberSource.Split(delimiter, StringSplitOptions.RemoveEmptyEntries); for (int t = 0; t < sHNumberSourceList.Length; t++) { if (!oSourceHlp.GetInfoByNumber(sHNumberSourceList[t])) { sMsg = "[" + sHNumberSourceList[t] + "]生产资源不存在"; if (sErrMsg.Contains(sMsg) == false) { sErrMsg = sErrMsg + "[" + sHNumberSourceList[t] + "]生产资源不存在\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 工艺路线_孙表 导入(保存) [Route("Gy_RoutingBill/Gy_RoutingBill_WorkQty_btnSave")] [HttpPost] public object Gy_RoutingBill_WorkQty_btnSave([FromBody] JObject sMainSub) { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); oCN.BeginTran(); //保存主表 objJsonResult = RoutAddBillMain_WorkQty(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.Message; objJsonResult.data = null; return objJsonResult; } public json RoutAddBillMain_WorkQty(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(msg2); string finalErrMsg = ""; //获取导入表中的最新数据 DataSet dsMain = oCN.RunProcReturn("select distinct 产品代码 from diyipi_WorkQty", "diyipi_WorkQty"); if (dsMain.Tables[0].Rows.Count > 0) { for(int i=0;i< dsMain.Tables[0].Rows.Count; i++) { string HMaterNumber = DBUtility.ClsPub.isStrNull(dsMain.Tables[0].Rows[0]["产品代码"]); if (!oMaterHlp.GetInfoByNumber(HMaterNumber)) { string sMsg = "物料【" + HMaterNumber + "】不存在！"; if (finalErrMsg.Contains(sMsg) == false) { finalErrMsg = finalErrMsg + "物料【" + HMaterNumber + "】不存在！\r\n"; } continue; } //获取该物料导入的数据中是否存在多个工艺路线，如果存在，则报错 string HBillNo = ""; Int64 HInterID = 0; DataSet dsHBillNo = oCN.RunProcReturn("select distinct 工艺路线代码,工艺路线名称 from diyipi_WorkQty where 产品代码 = '" + HMaterNumber + "'", "diyipi_WorkQty"); if (dsHBillNo.Tables[0].Rows.Count > 1) { string sMsg = "物料【" + HMaterNumber + "】存在多组【工艺路线代码，工艺路线名称】！"; if (finalErrMsg.Contains(sMsg) == false) { finalErrMsg = finalErrMsg + "物料【" + HMaterNumber + "】存在多组【工艺路线代码，工艺路线名称】！\r\n"; } continue; } else //物料对应工艺路线唯一，获取工艺路线主内码与工艺路线代码 { //生成唯一的工艺路线代码 HBillNo = DBUtility.ClsPub.isStrNull(dsHBillNo.Tables[0].Rows[0]["工艺路线代码"]); if (HBillNo == "") { DataSet dataSet = oCN.RunProcReturn($"select HBillNo from Gy_RoutingBillMain where HBillNo='1' ", "Gy_RoutingBillMain"); while (1 == 1) { if (HBillNo != "") { if (dataSet.Tables[0].Rows.Count == 0) { break; } } HBillNo = DBUtility.ClsPub.CreateBillCode(BillType, ref DBUtility.ClsPub.sExeReturnInfo, true); dataSet = oCN.RunProcReturn($"select HBillNo from Gy_RoutingBillMain where HBillNo='{HBillNo}' ", "Gy_RoutingBillMain"); } } //生成唯一的工艺路线内码 if (HInterID == 0) { while (1 == 1) { HInterID = DBUtility.ClsPub.CreateBillID_Prod(BillType, ref DBUtility.ClsPub.sExeReturnInfo);//获得一个新的id DataSet dataSet = oCN.RunProcReturn("select * from Gy_RoutingBillMain where HInterID=" + HInterID, "Gy_RoutingBillMain"); if (dataSet.Tables[0].Rows.Count == 0) { break; } } } } //拼接主表插入语句 string sqlMain = "insert into Gy_RoutingBillMain" + "(HInterID,HYear,HPeriod,HBillType,HBillNo,HName,HDate,HMaker,HMakeDate,HRemark,HOrgID" + ",HMaterID,HMaterNumber,HUnitID,HUnitNumber,HStandard,HRoutingGroupID) " + "values(" + "" + HInterID + "" + "," + DateTime.Now.Year + "" + "," + DateTime.Now.Month + "" + ",'" + BillType + "'" + ",'" + HBillNo + "'" + ", ''" + "," + "convert(varchar(100),getdate(),23)" + "" + ",'" + user + "'" + ", getdate()" + ",'" + "批量导入(包含孙表)" + "'" + "," + omdelMian.HOrgID + "," + oMaterHlp.omodel.HItemID + "" + ",'" + oMaterHlp.omodel.HNumber + "'" + "," + oMaterHlp.omodel.HUnitID + "" + ",'" + oMaterHlp.omodel.HUnitNumber + "'" + "," + 1 + "" + "," + 0 + "" + ")"; //获取该物料的工艺路线信息子表数据 DataSet dsSub = oCN.RunProcReturn("select * from diyipi_WorkQty where 产品代码 = '" + HMaterNumber + "' order by 工序序号", "diyipi_WorkQty"); for(int j = 0; j < dsSub.Tables[0].Rows.Count; j++) { string HProcNumber = DBUtility.ClsPub.isStrNull(dsSub.Tables[0].Rows[j]["工序代码"]); //得到工序内码 if (!oProcHlp.GetInfoByNumber(HProcNumber)) { string sMsg = "工序【" + HProcNumber + "】不存在！"; if (finalErrMsg.Contains(sMsg) == false) { finalErrMsg = finalErrMsg + "工序【" + HProcNumber + "】不存在！\r\n"; } continue; } else { string sqlSub = "insert into Gy_RoutingBillSub" + "(HInterID,HEntryID,HProcNo,HProcID,HCenterID,HWorkQty,HSortProcFlag,HRemark,HTimeUnit,HReadyTime,HQueueTime,HMoveTime) " + "values(" + "" + HInterID + "" + "," + (j + 1) + "" + "," + DBUtility.ClsPub.isLong(dsSub.Tables[0].Rows[j]["工序序号"]) + "," + oProcHlp.omodel.HItemID + "" + "," + 0 + "" + "," + DBUtility.ClsPub.isDoule(dsSub.Tables[0].Rows[j]["加工数量"]) + ",1" + ",'批量导入(包括孙表)'" + ", 0" + ", 0" + ", 0" + ", 0" + ")"; char[] delimiter = new char[] { ',' }; string HSourceNumberList = DBUtility.ClsPub.isStrNull(dsSub.Tables[0].Rows[j]["生产资源代码"]); string[] sHNumberSourceList = HSourceNumberList.Split(delimiter, StringSplitOptions.RemoveEmptyEntries); for(int t = 0; t < sHNumberSourceList.Length; t++) { //得到生产资源内码 if (!oSourceHlp.GetInfoByNumber(sHNumberSourceList[t])) { string sMsg = "生产资源【" + HProcNumber + "】不存在！"; if (finalErrMsg.Contains(sMsg) == false) { finalErrMsg = finalErrMsg + "生产资源【" + HProcNumber + "】不存在！\r\n"; } continue; } else { string sqlSub_WorkQty = "insert into Gy_RoutingBillSub_WorkQty" + "(HInterID,HEntryID,HEntrySubID,HRemark,HSourceID) " + "values(" + "" + HInterID + "" + "," + (j+1) + "" + "," + (t+1) + "" + ", '批量导入(包括孙表)'" + "," + oSourceHlp.omodel.HItemID + "" + ")"; oCN.RunProc(sqlSub_WorkQty); } } oCN.RunProc(sqlSub); } } oCN.RunProc(sqlMain); oCN.RunProc("update Gy_RoutingBillMain set HStandard = 0 where HMaterID = " + oMaterHlp.omodel.HItemID + " and HInterID <>" + HInterID); } } if (finalErrMsg.Length > 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = finalErrMsg; objJsonResult.data = null; return objJsonResult; } oCN.RunProc("delete from diyipi_WorkQty"); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "导入完成,共" + dsMain.Tables[0].Rows.Count + "个工艺路线"; 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 #region 工艺路线 审核、反审核 /// /// /// /// 单据ID /// 审核(0),反审核(1) /// 审核人 /// Gy_RoutingBill/CheckGy_RoutingBill [Route("Gy_RoutingBill/AuditGy_RoutingBill")] [HttpGet] public object AuditGy_RoutingBill(string HInterID, int IsAudit, string CurUserName) { try { //审核权限 if (!DBUtility.ClsPub.Security_Log_second("Gy_RoutingBill_Check", 1, false, CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核失败！无权限！"; objJsonResult.data = null; return objJsonResult; } var ds = oCN.RunProcReturn("select * from Gy_RoutingBillMain where HInterID=" + HInterID, "Gy_RoutingBillMain"); if (ds.Tables[0].Rows.Count > 0) { if (IsAudit == 0) //审核判断 { if (ds.Tables[0].Rows[0]["HChecker"].ToString() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已审核!不能再次审核！"; objJsonResult.data = null; return objJsonResult; } } if (IsAudit == 1) //反审核判断 { if (ds.Tables[0].Rows[0]["HChecker"].ToString() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据未审核!不需要反审核!"; objJsonResult.data = null; return objJsonResult; } } } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据不存在!"; objJsonResult.data = null; return objJsonResult; } oCN.BeginTran(); if (IsAudit == 0) //审核判断 { //审核前控制========================================= string sql1 = "exec h_p_Gy_RoutingBill_BeforeCheckCtrl " + HInterID + ",'" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','" + CurUserName + "'"; var ds2 = oCN.RunProcReturn(sql1, "h_p_Gy_RoutingBill_BeforeCheckCtrl"); if (ds2 == null || ds2.Tables.Count == 0 || ds2.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "审核失败!原因:审核前判断失败，请与网络管理人员联系"; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } if (ds2.Tables[0].Rows[0]["HBack"].ToString() != "0") { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "审核失败!原因:" + ds2.Tables[0].Rows[0]["HRemark"].ToString(); ; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } //================================================================================== //审核工艺路线 oCN.RunProc("update Gy_RoutingBillMain set HChecker='" + CurUserName + "',HCheckDate=getdate(),HBillStatus=2 where HInterID=" + HInterID); //审核后控制========================================= string sql2 = "exec h_p_Gy_RoutingBill_AfterCheckCtrl " + HInterID + ",'" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','" + CurUserName + "'"; ds = oCN.RunProcReturn(sql1, "h_p_Gy_RoutingBill_AfterCheckCtrl"); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "审核失败!原因:审核后判断失败，请与网络管理人员联系"; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } //================================================================================== //获取系统参数 string Ret = ""; if (oSystemParameter.ShowBill(ref Ret)) { //判断客户 if (oSystemParameter.omodel.WMS_CampanyName == "添康科技") //系统参数 { //刷新默认工艺路线 oCN.RunProc("exec h_p_Gy_RoutingBillCheck " + HInterID + ",'" + CurUserName + "'"); } } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "审核成功"; objJsonResult.data = null; } if (IsAudit == 1) //反审核判断 { //反审核前控制========================================= string sql1 = "exec h_p_Gy_Routing_BeforeUnCheckCtrl " + HInterID + ",'" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','" + CurUserName + "'"; var ds2 = oCN.RunProcReturn(sql1, "h_p_Gy_Routing_BeforeUnCheckCtrl"); if (ds2 == null || ds2.Tables.Count == 0 || ds2.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "审核失败!原因:反审核前判断失败，请与网络管理人员联系"; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } if (ds2.Tables[0].Rows[0]["HBack"].ToString() != "0") { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "审核失败!原因:" + ds2.Tables[0].Rows[0]["HRemark"].ToString(); ; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } //================================================================================== //反审核工艺路线 oCN.RunProc("update Gy_RoutingBillMain set HChecker='',HCheckDate=null where HInterID=" + HInterID); //反审核后控制========================================= string sql2 = "exec h_p_Gy_RoutingBill_AfterUnCheckCtrl " + HInterID + ",'" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','" + CurUserName + "'"; ds = oCN.RunProcReturn(sql1, "h_p_Gy_RoutingBill_AfterUnCheckCtrl"); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "审核失败!原因:反审核后判断失败，请与网络管理人员联系"; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } //================================================================================== objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "反审核成功"; objJsonResult.data = null; } oCN.Commit(); return objJsonResult; } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核失败或者反审核失败！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 工艺路线 关闭、反关闭 /// /// /// /// 单据ID /// 审核(0),反审核(1) /// 审核人 /// [Route("Gy_RoutingBill/CloseGy_RoutingBill")] [HttpGet] public object CloseGy_RoutingBill(string HInterID, int IsAudit, string CurUserName) { try { //审核权限 if (!DBUtility.ClsPub.Security_Log_second("Gy_RoutingBill_Close", 1, false, CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核失败！无权限！"; objJsonResult.data = null; return objJsonResult; } var ds = oCN.RunProcReturn("select * from Gy_RoutingBillMain where HInterID=" + HInterID, "Gy_RoutingBillMain"); if (ds.Tables[0].Rows.Count > 0) { string HBillStatus = Convert.ToString(ds.Tables[0].Rows[0]["HBillStatus"]); //string hdeleteman = Convert.ToString(ds.Tables[0].Rows[0]["hdeleteman"]); if (HBillStatus == "6") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据在审核中,不能关闭！"; objJsonResult.data = null; return objJsonResult; } if (IsAudit == 0) //关闭判断 { if (ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已关闭!不能再次关闭！"; objJsonResult.data = null; return objJsonResult; } } if (IsAudit == 1) //反关闭判断 { if (ds.Tables[0].Rows[0]["HCloseMan"].ToString() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据未关闭!不需要反关闭!"; objJsonResult.data = null; return objJsonResult; } } } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据不存在!"; objJsonResult.data = null; return objJsonResult; } oCN.BeginTran(); if (IsAudit == 0) //关闭判断 { oCN.RunProc("update Gy_RoutingBillMain set HCloseMan='" + CurUserName + "',HCloseDate=getdate() where HInterID=" + HInterID); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "关闭成功"; objJsonResult.data = null; } if (IsAudit == 1) //反关闭判断 { oCN.RunProc("update Gy_RoutingBillMain set HCloseMan='',HCloseDate=null where HInterID=" + HInterID); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "反关闭成功"; objJsonResult.data = null; } oCN.Commit(); return objJsonResult; } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "关闭失败或者反关闭失败！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 工艺路线 作废/反作废 /// /// /// 单据ID /// 作废(0),反作废(1) /// 作废人 /// [Route("Gy_RoutingBill/DeleteGy_RoutingBill")] [HttpGet] public object DeleteOA_AndengFlowRuleBill(int HInterID, int IsAudit, string CurUserName) { string ModRightNameCheck = "Gy_RoutingBill_Delete"; DBUtility.ClsPub.CurUserName = CurUserName; try { //检查权限 if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "作废失败！无权限！"; objJsonResult.data = null; return objJsonResult; } //HInterID数据判断 if (HInterID <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HInterID小于0！"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HInterID); //对HInterID进行类型的转换 DAL.ClsGy_RoutingBill oBill = new DAL.ClsGy_RoutingBill(); //实例化单据操作类，用于进行相关操作 //针对需要进行的操作，检验当前单据的状态是否支持需要进行的操作 if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //根据HInterID获取该单据的数据 { if (oBill.omodel.HChecker.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已审核!不能进行作废！"; objJsonResult.data = null; return objJsonResult; } if (IsAudit == 1) //作废判断 { if (oBill.omodel.HDeleteMan.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已作废!不能再作废！"; objJsonResult.data = null; return objJsonResult; } } if (IsAudit == 2) //反作废判断 { if (oBill.omodel.HDeleteMan.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据未作废!不需要反作废！"; objJsonResult.data = null; return objJsonResult; } } } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } //进行需要进行的作废/反作废操作 if (IsAudit == 1) //作废提交 { //作废前控制========================================= string sql1 = "exec h_p_Gy_RoutingBill_BeforeDropCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'"; ds = oCN.RunProcReturn(sql1, "h_p_Gy_RoutingBill_BeforeDropCtrl"); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "审核失败!原因:审核前判断失败，请与网络管理人员联系"; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } //================================================================================== //作废提交 if (oBill.Cancelltion(lngBillKey, oBill.omodel.HBillNo, "h_p_Gy_RoutingBill_AfterDropCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "作废成功"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "作废失败!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } if (IsAudit == 2) //反作废提交 { //反作废前控制========================================= string sql1 = "exec h_p_Gy_RoutingBill_BeforeUnDropCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'"; ds = oCN.RunProcReturn(sql1, "h_p_Gy_RoutingBill_BeforeUnDropCtrl"); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "作废失败!原因:反作废前判断失败，请与网络管理人员联系"; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "作废失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } //================================================================================== //反关闭提交 if (oBill.AbandonCancelltion(lngBillKey, oBill.omodel.HBillNo, "h_p_Gy_RoutingBill_AfterUnDropCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "反作废成功"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "反作废失败!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "作废失败或者反作废失败！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 工艺路线列表 主表 /// /// 返回工艺路线列表 ///参数：string sql。 ///返回值：object。 /// [Route("Gy_RoutingBill/Gy_RoutingBillQuery")] [HttpGet] public object Gy_RoutingBillQuery(string sWhere, string user) { DataSet ds; try { //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Query", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无权限查询!"; objJsonResult.data = null; return objJsonResult; } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql1 = "select top 1000 * from h_v_Gy_RoutingBillQuery where 1 = 1 "; string sql = sql1 + sWhere + " order by hmainid desc"; ds = oCN.RunProcReturn(sql, "h_v_Gy_RoutingBillQuery"); } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } return GetObjectJson(ds); } #endregion #region 工艺路线列表 子表 /// /// 返回工艺路线列表 ///参数：string sql。 ///返回值：object。 /// [Route("Gy_RoutingBill/Gy_RoutingBillQuerySub")] [HttpGet] public object Gy_RoutingBillQuerySub(string sWhere) { DataSet ds; try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql1 = "select top 1000 * from h_v_Gy_RoutingBillQuerySub where 1 = 1 and hmainid=" + sWhere; string sql = sql1 + " order by hmainid desc,cast(工序号 as int)"; ds = oCN.RunProcReturn(sql, "h_v_Gy_RoutingBillQuerySub"); } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } return GetObjectJson(ds); } #endregion /// ///封装状态码及返回信息的公用方法。 ///参数：DataSet。 ///返回值：json。 /// public object GetObjectJson(DataSet ds) { try { List columnNameList = new List(); //添加列名 foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.list = columnNameList; objJsonResult.data = ds.Tables[0]; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #region 工艺路线--物料名称获取 [Route("Gy_Routing/GetHMaterList")] [HttpGet] public object GetHMaterList(string HMaterName) { try { DataSet oDs = new DataSet(); //========== oDs = oCN.RunProcReturn("select distinct top 15 HName from Gy_Material where HName like '%" + HMaterName + "%'", "Gy_Material"); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "获取成功！"; objJsonResult.data = oDs.Tables[0]; return objJsonResult; ; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "删除失败！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 工艺路线需要我审批流审批的 [Route("Gy_Routing/NeedChecklist")] [HttpGet] public object NeedChecklist(string user, string userid) { try { List columnNameList = new List(); //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Query", 1, false, user)) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "无权限查看!"; objJsonResult.data = null; return objJsonResult; } //搜索需要审核的 string sql = " select a.*,c.HItemID as HCheckFlowStatusID,m.HName as 审批流,c.HCheckFlowID,i.HName as 审批项目名称,c.HCheckItemID,c.HChecker as 项目审核人,c.HCheckNote as 审批流审核建议,c.HCheckDate 审批流审核日期 from h_v_Gy_RoutingBillList AS a LEFT JOIN Xt_BillCheckFlowStatus AS c ON a.hmainid = c.HBillInterID and a.单据类型 = c.HBillTypeID" + " LEFT JOIN Xt_CheckFlowMain as m ON m.HInterID = c.HCheckFlowID" + " LEFT JOIN Gy_RoutingBillMain as po ON a.hmainid = po.HInterID" + " LEFT JOIN Xt_CheckItem as i ON i.HItemID = c.HCheckItemID" + " LEFT JOIN Xt_CheckUserRight as cr ON cr.HCheckItemID = i.HItemID and cr.HCheckFlowInterID = m.HInterID" + " where 工序代码 != '9999' and a.HBillSubType<>'SUB' and po.HBillStatus = 6 and po.HCheckItemNowID = i.HItemID and cr.HUserID = '" + userid + "'"; ds = oCN.RunProcReturn(sql, "h_v_Gy_RoutingBillList"); foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 } objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 工艺路线已经审批流审批的 [Route("Gy_Routing/Checkedlist")] [HttpGet] public object Checkedlist(string user) { try { List columnNameList = new List(); //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Query", 1, false, user)) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "无权限查看!"; objJsonResult.data = null; return objJsonResult; } //搜索需要审核的 string sql = "select TOP 1000 a.*,c.HItemID as HCheckFlowStatusID,m.HName as 审批流,c.HCheckFlowID,i.HName as 审批项目名称,c.HCheckItemID,c.HChecker as 项目审核人,c.HCheckNote as 审批流审核建议,c.HCheckDate 审批流审核日期 from h_v_Gy_RoutingBillList AS a LEFT JOIN Xt_BillCheckFlowStatus AS c ON a.hmainid = c.HBillInterID and a.单据类型 = c.HBillTypeID" + " LEFT JOIN Xt_CheckFlowMain as m ON m.HInterID = c.HCheckFlowID" + " LEFT JOIN Xt_CheckItem as i ON i.HItemID = c.HCheckItemID" + " where 工序代码 != '9999' and a.HBillSubType<>'SUB' and c.HCheckDate is not NUll and c.HChecker = '" + user + "'"+ " ORDER BY a.hmainid DESC;"; ds = oCN.RunProcReturn(sql, "h_v_Gy_RoutingBillList"); foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 } objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 工艺路线驳回 [Route("Gy_Routing/RejectCheckFlow")] [HttpGet] public object RejectCheckFlow(string HInterID, string CurUserID) { try { Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HInterID); //对HInterID进行类型的转换 DAL.ClsGy_RoutingBill oBill = new DAL.ClsGy_RoutingBill(); //实例化单据操作类，用于进行相关操作 //获取系统参数判断工艺路线是否启用多级审批禁用 Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); string sReturn = ""; if (oSystemParameter.ShowBill(ref sReturn) == true) { if (oSystemParameter.omodel.Gy_RoutingBill_EnableMultiLevel.ToUpper() == "N") //系统参数 未启用自动审核 { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "工艺路线未启用多级审批禁用"; objJsonResult.data = null; return objJsonResult; } } if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //根据HInterID获取该单据的数据 { if (oBill.omodel.HBillStatus != 6) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "单据未在审核中不能驳回"; objJsonResult.data = null; return objJsonResult; } //发起驳回 if (oBill.RejectCheckFlowProgress(lngBillKey, oBill.omodel.HBillNo, CurUserID, ref DBUtility.ClsPub.sExeReturnInfo) == true) { objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "驳回成功"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "驳回失败失败!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } else { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } catch (Exception e) { oCN.RollBack(); objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 工艺路线 发起审批 [Route("Gy_Routing/StartCheckFlow")] [HttpGet] public object StartCheckFlow(int HInterID, string CurUserName) { DBUtility.ClsPub.CurUserName = CurUserName; try { ////审核权限 //if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "审核失败！无权限！"; // objJsonResult.data = null; // return objJsonResult; //} //获取系统参数判断工艺路线是否启用多级审批禁用 Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); string sReturn = ""; if (oSystemParameter.ShowBill(ref sReturn) == true) { if (oSystemParameter.omodel.Gy_RoutingBill_EnableMultiLevel.ToUpper() == "N") //系统参数 未启用自动审核 { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "工艺路线未启用多级审批禁用"; objJsonResult.data = null; return objJsonResult; } } //HInterID数据判断 if (HInterID <= 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "HInterID小于0！"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HInterID); //对HInterID进行类型的转换 DAL.ClsGy_RoutingBill oBill = new DAL.ClsGy_RoutingBill(); //实例化单据操作类，用于进行相关操作 //发起审批 if (oBill.startCheckFlow(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) { objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "发起审批成功"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "发起审批失败!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } catch (Exception e) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "发起审批失败失败！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 工艺路线 多级 审核/反审核 /// /// /// 单据ID /// 审核(0),反审核(1) /// 审核人 /// [Route("Gy_Routing/AuditFlow")] [HttpGet] public object AuditGy_Routing_Flow(int HInterID, int IsAudit, string CurUserName, string CurUserID) { //string ModRightNameCheck = "Gy_Routing_Check"; DBUtility.ClsPub.CurUserName = CurUserName; try { ////审核权限 //if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "审核失败！无权限！"; // objJsonResult.data = null; // return objJsonResult; //} //获取系统参数判断工艺路线是否启用多级审批禁用 Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); string sReturn = ""; if (oSystemParameter.ShowBill(ref sReturn) == true) { if (oSystemParameter.omodel.Gy_RoutingBill_EnableMultiLevel.ToUpper() == "N") //系统参数 未启用自动审核 { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "工艺路线未启用多级审批禁用"; objJsonResult.data = null; return objJsonResult; } } //HInterID数据判断 if (HInterID <= 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "HInterID小于0！"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HInterID); //对HInterID进行类型的转换 DAL.ClsGy_RoutingBill oBill = new DAL.ClsGy_RoutingBill(); //实例化单据操作类，用于进行相关操作 //针对需要进行的操作，检验当前单据的状态是否支持需要进行的操作 if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //根据HInterID获取该单据的数据 { if (oBill.omodel.HCloseMan.Trim() != "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "单据已关闭!不能再次审核！"; objJsonResult.data = null; return objJsonResult; } if (oBill.omodel.HDeleteMan.Trim() != "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "单据已作废!不能再次审核！"; objJsonResult.data = null; return objJsonResult; } if (IsAudit == TypeConstant.AUDIT) //审核判断 { //判断是否已经发起审批 string sql0 = "select * from Xt_BillCheckFlowStatus where HBillInterID = " + lngBillKey + " and HBillTypeID = '" + oBill.BillType + "'"; DataSet ds0 = oCN.RunProcReturn(sql0, "Xt_BillCheckFlowStatus"); if (ds0 != null && ds0.Tables[0].Rows.Count == 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "审核失败!原因:单据未发起审批！"; objJsonResult.data = null; return objJsonResult; } //判断单据当前状态 if (oBill.omodel.HChecker.Trim() != "") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "审核失败!原因:单据已完成审核!不能继续审核！"; objJsonResult.data = null; return objJsonResult; } } if (IsAudit == TypeConstant.REVERSE_AUDIT) //反审核判断 { //判断是否存在审核过的项目 string sql0 = "select * from Xt_BillCheckFlowStatus where HBillInterID = " + lngBillKey + " and HBillTypeID = '" + oBill.BillType + "' and ISNULL(HChecker,'') <> ''"; DataSet ds0 = oCN.RunProcReturn(sql0, "Xt_BillCheckFlowStatus"); if (ds0 != null && ds0.Tables[0].Rows.Count == 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "反审核失败!原因:单据不存在已经审核的项目！！"; objJsonResult.data = null; return objJsonResult; } } } else { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } oCN.BeginTran(); //进行需要进行的审核/反审核操作 if (IsAudit == TypeConstant.AUDIT) //审核提交 { #region 审核前的相关判断 //审核前控制========================================= //string sql1 = "exec h_p_Gy_Routing_BeforeCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'"; //ds = oCN.RunProcReturn(sql1, "h_p_Gy_Routing_BeforeCheckCtrl"); //if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "审核失败!原因:审核前判断失败，请与网络管理人员联系"; // objJsonResult.data = null; // return objJsonResult; //} //if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ; // objJsonResult.data = null; // return objJsonResult; //} //================================================================================== //进行 会计期间 结账 的判断和控制 string s = ""; int sYear = 0; int sPeriod = 0; DateTime HDate = DateTime.Now; if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) { objJsonResult.Message = s; return objJsonResult; } #endregion //获取当前审核项目 string sql0 = "select * from " + oBill.MvarItemKey + " where HInterID = " + lngBillKey; DataSet ds0 = oCN.RunProcReturn(sql0, oBill.MvarItemKey); string HCheckFlowID = ds0.Tables[0].Rows[0]["HCheckFlowID"].ToString(); //审批流内码 string HCheckItemNowID = ds0.Tables[0].Rows[0]["HCheckItemNowID"].ToString(); //当前审批项目内码 string HCheckItemNextID = ds0.Tables[0].Rows[0]["HCheckItemNextID"].ToString(); //待审批项目内码 //判断用户是否有权限 审批 当前审批流的审批项目 //string sql01 = "select * from Xt_CheckUserRight where HUserID = '" + CurUserID + "' and HCheckFlowInterID = " + HCheckFlowID + " and HCheckItemID = " + HCheckItemNowID + " and HValue = 1"; string sql01 = "select * from Xt_CheckUserRight where HUserID = '" + CurUserID + "' and HCheckFlowInterID = " + HCheckFlowID + " and HCheckItemID = " + HCheckItemNowID + ""; DataSet ds01 = oCN.RunProcReturn(sql01, "Xt_CheckUserRight"); if (ds01.Tables[0].Rows.Count == 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "审核失败!原因:用户无当前审核项目的审核权限！"; objJsonResult.data = null; return objJsonResult; } //更新 单据审批状态表 中对应审核项目的审核状态 string sql02 = "update Xt_BillCheckFlowStatus set HChecker='" + CurUserName + "',HCheckDate=getdate() where HBillTypeID = '" + oBill.BillType + "' and HBillInterID=" + lngBillKey + " and HCheckFlowID=" + HCheckFlowID + " and HCheckItemID=" + HCheckItemNowID; oCN.RunProc(sql02); //判断当前审核项目是否是最后一个项目，如果是，审核后反写单据的单据状态。如果不是，获取下一个审核项目并更新到销售订单主表 if (HCheckItemNextID != "0") //刚刚审核的审核项目不是最后一个审核项目 { string sql03 = "select b.HInterID,b.HCheckItemID from Xt_CheckFlowMain as a " + "inner join Xt_CheckFlowSub as b on a.HInterID = b.HInterID " + "where a.HBillTypeID = '" + oBill.BillType + "' " + "and a.HInterID = " + HCheckFlowID + " " + "order by b.HFlowNo asc"; DataSet ds03 = oCN.RunProcReturn(sql03, "Xt_CheckFlowMain"); //获取新的当前审核项目和待审核项目 for (int i = 0; i < ds03.Tables[0].Rows.Count; i++) { if (ds03.Tables[0].Rows[i]["HCheckItemID"].ToString() == HCheckItemNextID) { HCheckItemNowID = HCheckItemNextID; } else if (HCheckItemNowID == HCheckItemNextID) { HCheckItemNextID = ds03.Tables[0].Rows[i]["HCheckItemID"].ToString(); break; } } //新的当前审核项目为最后一个审核项目，待审核项目不存在，设为默认值"0" if (HCheckItemNowID == HCheckItemNextID) { HCheckItemNextID = "0"; } //更新单据主表的审批流数据 string sql04 = "update " + oBill.MvarItemKey + " set HCheckItemNowID=" + HCheckItemNowID + ",HCheckItemNextID=" + HCheckItemNextID + " where HInterID = " + lngBillKey; oCN.RunProc(sql04); objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "审核成功"; objJsonResult.data = null; } else //刚刚审核的审核项目是最后一个审核项目 { //更新单据主表的审批流数据 HCheckItemNowID = "0"; HCheckItemNextID = "0"; string sql04 = "update " + oBill.MvarItemKey + " set HCheckItemNowID=" + HCheckItemNowID + ",HCheckItemNextID=" + HCheckItemNextID + " where HInterID = " + lngBillKey; oCN.RunProc(sql04); //更新单据的单据状态 if (oBill.CheckBill(oCN, oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Gy_RoutingBill_AfterCheckCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true) { objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "审核成功"; objJsonResult.data = null; //获取系统参数 string Ret = ""; if (oSystemParameter.ShowBill(ref Ret)) { //判断客户 if (oSystemParameter.omodel.WMS_CampanyName == "添康科技") //系统参数 { //刷新默认工艺路线 oCN.RunProc("exec h_p_Gy_RoutingBillCheck " + HInterID + ",'" + CurUserName + "'"); } } } else { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } } } if (IsAudit == TypeConstant.REVERSE_AUDIT) //反审核提交 { #region 反审核前的相关判断 //反审核前控制========================================= DataSet ds = oCN.RunProcReturn("Exec h_p_Gy_Routing_BeforeUnCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'", "h_p_Gy_Routing_BeforeUnCheckCtrl"); if (ds == null) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "反审核失败!原因:" + "反审核前判断失败！"; objJsonResult.data = null; return objJsonResult; } if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0") { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "反审核失败!原因:" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]); objJsonResult.data = null; return objJsonResult; } //========================================================= //进行 会计期间 结账 的判断和控制 string s = ""; int sYear = 0; int sPeriod = 0; DateTime HDate = DateTime.Now; if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) { objJsonResult.Message = s; return objJsonResult; } #endregion //获取需要反审核的审核项目 string sql0 = "select c.* from Xt_CheckFlowMain as a " + "inner join Xt_CheckFlowSub as b on a.HInterID = b.HInterID " + "inner join Xt_BillCheckFlowStatus as c on a.HBillTypeID = c.HBillTypeID and b.HCheckItemID = c.HCheckItemID " + "where c.HBillTypeID = '" + oBill.BillType + "' and c.HBillInterID = " + lngBillKey + " " + "order by b.HFlowNo asc"; DataSet ds0 = oCN.RunProcReturn(sql0, "Xt_BillCheckFlowStatus"); if (ds0 == null || ds0.Tables[0].Rows.Count == 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "反审核失败!原因:未发起审批！"; objJsonResult.data = null; return objJsonResult; } string HCheckFlowID = ds0.Tables[0].Rows[0]["HCheckFlowID"].ToString(); //审批流内码 string HCheckItemNowID = "0"; //当前审批项目内码 string HCheckItemNextID = "0"; //待审批项目内码 if (oBill.omodel.HBillStatus == 6) { for (int i = 0; i < ds0.Tables[0].Rows.Count; i++) { if (ds0.Tables[0].Rows[i]["HChecker"].ToString() != "") { HCheckItemNowID = ds0.Tables[0].Rows[i]["HCheckItemID"].ToString(); HCheckItemNextID = ds0.Tables[0].Rows[i]["HCheckItemID"].ToString(); } else { HCheckItemNextID = ds0.Tables[0].Rows[i]["HCheckItemID"].ToString(); break; } } if (HCheckItemNowID == HCheckItemNextID) { HCheckItemNextID = "0"; } } else { HCheckItemNowID = ds0.Tables[0].Rows[ds0.Tables[0].Rows.Count - 1]["HCheckItemID"].ToString(); HCheckItemNextID = "0"; } //判断用户是否有权限 审批 当前审批流的审批项目 //string sql01 = "select * from Xt_CheckUserRight where HUserID = '" + CurUserID + "' and HCheckFlowInterID = " + HCheckFlowID + " and HCheckItemID = " + HCheckItemNowID + " and HValue = 1"; string sql01 = "select * from Xt_CheckUserRight where HUserID = '" + CurUserID + "' and HCheckFlowInterID = " + HCheckFlowID + " and HCheckItemID = " + HCheckItemNowID + ""; DataSet ds01 = oCN.RunProcReturn(sql01, "Xt_CheckUserRight"); if (ds01.Tables[0].Rows.Count == 0) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "反审核失败!原因:用户无当前审核项目的审核权限！"; objJsonResult.data = null; return objJsonResult; } //更新 单据审批状态表 中对应审核项目的审核状态 string sql02 = "update Xt_BillCheckFlowStatus set HChecker='',HCheckDate='' where HBillTypeID = '" + oBill.BillType + "' and HBillInterID=" + lngBillKey + " and HCheckFlowID=" + HCheckFlowID + " and HCheckItemID=" + HCheckItemNowID; oCN.RunProc(sql02); //判断反审核的单据是否已经审核完成，若审核完成，反审核需要变更单据状态。 if (oBill.omodel.HBillStatus == 6) { //更新单据主表的审批流数据 string sql04 = "update " + oBill.MvarItemKey + " set HCheckItemNowID=" + HCheckItemNowID + ",HCheckItemNextID=" + HCheckItemNextID + " where HInterID = " + lngBillKey; oCN.RunProc(sql04); objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "审核成功"; objJsonResult.data = null; } else { //反审核提交AbandonCheck if (oBill.AbandonCheck(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo) == true) { //更新单据主表的审批流数据 string sql04 = "update " + oBill.MvarItemKey + " set HCheckItemNowID=" + HCheckItemNowID + ",HCheckItemNextID=" + HCheckItemNextID + ",HBillStatus=6 " + " where HInterID = " + lngBillKey; oCN.RunProc(sql04); objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "反审核成功"; objJsonResult.data = null; } else { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "反审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } } } oCN.Commit(); return objJsonResult; } catch (Exception e) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "审核失败或者反审核失败！" + e.ToString(); objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } } #endregion #region 工艺路线 关闭其它单据 [Route("Gy_Routing/CloseOther")] [HttpGet] public object CloseOther(int HInterID, string CurUserName) { DBUtility.ClsPub.CurUserName = CurUserName; try { //判断是否有关闭其它权限 if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_CloseOther", 1, false, CurUserName)) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "工艺路线无权限关闭其它单据!"; objJsonResult.data = null; return objJsonResult; } oCN.BeginTran();//开始事务 //判断单据是否存在 DataSet ds; string sql = "select * from Gy_RoutingBillMain where HinterID = " + HInterID; ds = oCN.RunProcReturn(sql, "Gy_RoutingBillMain"); if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { //if (!(ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "")) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "单据未审核!不可以被启用为该物料的默认工艺路线!"; // objJsonResult.data = null; // return objJsonResult; //} } else { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "单据不存在，检查该单据是否已经被删除!"; objJsonResult.data = null; return objJsonResult; } //刷新默认工艺路线 oCN.RunProc("exec h_p_Gy_RoutingBillClose " + HInterID + ",'" + CurUserName + "'"); oCN.Commit();//提交事务 objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "执行成功！"; objJsonResult.data = null; return objJsonResult; ; } catch (Exception e) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "关闭其它失败失败！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 待失效报表 /// /// 待失效报表 ///参数：string sql。 ///返回值：object。 /// [Route("Gy_RoutingBill/getInvalidityReport")] [HttpGet] public object getInvalidityReport(string sWhere, string user) { DataSet ds; try { List columnNameList = new List(); //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Query", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "待失效报表无权限查询!"; objJsonResult.data = null; return objJsonResult; } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList where 定额类型 = '临时定额' and 状态!= '关闭' and 失效时间 BETWEEN CAST(GETDATE() AS DATE) AND DATEADD(DAY, 15, GETDATE()) " + sWhere + " order by hmainid desc", "h_v_Gy_RoutingBillList"); foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 } objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } return GetObjectJson(ds); } #endregion #region 工艺路线(集体) 批量多级审核 [Route("Gy_Routing/CheckAllFlow")] [HttpGet] public object CheckAll(string HInterIDS, int IsAudit, string CurUserName, string CurUserID) { try { //处理字符串 if (!string.IsNullOrEmpty(HInterIDS)) { int[] idArray = Array.ConvertAll(HInterIDS.Split(','), int.Parse); // 处理idArray... for (int i = 0; i < idArray.Length; i++) { objJsonResult = (json)AuditGy_Routing_Flow(idArray[i], IsAudit, CurUserName, CurUserID);//审核执行 if (objJsonResult.count == 0) { objJsonResult.Message += "第" + (i + 1) + "行出现问题无法继续完成"; return objJsonResult; } } } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "请选择正确行"; objJsonResult.data = null; return objJsonResult; } objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "执行成功！"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核或反审核工艺路线失败！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 工艺路线 批量驳回 [Route("Gy_Routing/RejectAllCheckFlow")] [HttpGet] public object RejectAllCheckFlow(string HInterIDS,string CurUserID) { try { //处理字符串 if (!string.IsNullOrEmpty(HInterIDS)) { int[] idArray = Array.ConvertAll(HInterIDS.Split(','), int.Parse); // 处理idArray... for (int i = 0; i < idArray.Length; i++) { objJsonResult = (json)RejectCheckFlow(idArray[i].ToString(),CurUserID);//审核执行 if (objJsonResult.count == 0) { objJsonResult.Message += "第" + (i + 1) + "行出现问题无法继续完成"; return objJsonResult; } } } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "请选择正确行"; objJsonResult.data = null; return objJsonResult; } objJsonResult.code = CodeConstant.SUCCEED; objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "执行成功！"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "驳回工艺路线失败！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 工艺路线撤回 [Route("Gy_Routing/WithdrawCheckFlow")] [HttpGet] public object WithdrawCheckFlow(string HInterID, string user) { try { Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HInterID); //对HInterID进行类型的转换 DAL.ClsGy_RoutingBill oBill = new DAL.ClsGy_RoutingBill(); //实例化单据操作类，用于进行相关操作 //获取系统参数判断工艺路线是否启用多级审批禁用 Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); string sReturn = ""; if (oSystemParameter.ShowBill(ref sReturn) == true) { if (oSystemParameter.omodel.Gy_RoutingBill_EnableMultiLevel.ToUpper() == "N") //系统参数 未启用自动审核 { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "工艺路线未启用多级审批禁用"; objJsonResult.data = null; return objJsonResult; } } if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //根据HInterID获取该单据的数据 { if (oBill.omodel.HBillStatus != 6) { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "单据未在审核中不能撤回"; objJsonResult.data = null; return objJsonResult; } //判断是否有编辑权限 if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Edit", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "工艺路线无权限撤回!"; objJsonResult.data = null; return objJsonResult; } } else { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } //判断是否存在审核过的项目 string sql0 = "select * from Xt_BillCheckFlowStatus where HBillInterID = " + lngBillKey + " and HBillTypeID = '" + oBill.BillType + "' and ISNULL(HChecker,'') <> ''"; DataSet ds0 = oCN.RunProcReturn(sql0, "Xt_BillCheckFlowStatus"); if (ds0 != null && ds0.Tables[0].Rows.Count == 0) { oCN.BeginTran(); //获取需要驳回的审核项目 string sql1 = "select c.* from Xt_CheckFlowMain as a " + "inner join Xt_CheckFlowSub as b on a.HInterID = b.HInterID " + "inner join Xt_BillCheckFlowStatus as c on a.HBillTypeID = c.HBillTypeID and b.HCheckItemID = c.HCheckItemID " + "where c.HBillTypeID = '" + this.BillType + "' and c.HBillInterID = " + lngBillKey + " " + "order by b.HFlowNo asc"; DataSet ds1= oCN.RunProcReturn(sql1, "Xt_BillCheckFlowStatus"); if (ds1 == null || ds1.Tables[0].Rows.Count == 0) { sReturn = "撤回失败!原因:未发起审批！！"; return false; } //获取当前审核项目 string HCheckFlowID = ds1.Tables[0].Rows[0]["HCheckFlowID"].ToString(); //审批流内码 sql0 = "select * from Gy_RoutingBillMain " + " where HInterID = " + lngBillKey; ds0 = oCN.RunProcReturn(sql0, "Gy_RoutingBillMain"); string HCheckItemNowID = ds0.Tables[0].Rows[0]["HCheckItemNowID"].ToString(); //当前审批项目内码 //更新 驳回删除审核流状态表 string sql02 = "Delete Xt_BillCheckFlowStatus where HBillTypeID = '" + this.BillType + "' and HBillInterID=" + lngBillKey + " and HCheckFlowID=" + HCheckFlowID; oCN.RunProc(sql02); oCN.RunProc(" Update Gy_RoutingBillMain" + " set HChecker='',HCheckDate=null,HBillStatus=1,HCheckItemNowID = 0,HCheckItemNextID = 0 Where HInterID=" + lngBillKey.ToString()); oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "撤回成功！"; objJsonResult.data = null; return objJsonResult; ; } else { objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "撤回失败!原因:单据存在已经审核的项目！！"; objJsonResult.data = null; return objJsonResult; } } catch (Exception e) { oCN.RollBack(); objJsonResult.code = CodeConstant.FAIL; objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion } }