派生自 MES-WEB-API
WebAPI/Controllers/LMESController.cs
@@ -7,6 +7,7 @@ using System.Data; using System.Data.SqlClient; using System.Web.Http; using System.Windows.Forms; using WebAPI.Models; namespace WebAPI.Controllers { @@ -16,6 +17,8 @@ private json objJsonResult = new json(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); public DAL.ClsSc_ICMOBill BillOld = new DAL.ClsSc_ICMOBill(); /// <summary> /// 返回进站扫描列表|工序进站接收单列表 ///参数：string sql。 @@ -62,17 +65,32 @@ { List<object> columnNameList = new List<object>(); //判断是否有查询权限 //if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Query", 1, false, user)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "无查询权限!"; // objJsonResult.data = null; // return objJsonResult; //} if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Query", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无查询权限!"; objJsonResult.data = null; return objJsonResult; } //获取系统参数 string Ret = ""; if (oSystemParameter.ShowBill(ref Ret)) { //判断客户为龙山汽配 if (oSystemParameter.omodel.WMS_CampanyName == "龙山汽配") { //获取需要拼接的字符串 string sql_splice = DBUtility.ClsPub.SpliceSQL(user, "工序派工单列表"); sWhere += sql_splice; } } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillQuery where 1 = 1 " + sWhere + " order by hmainid desc ", "h_v_Sc_ProcessExchangeBillQuery"); //添加列名 foreach (DataColumn col in ds.Tables[0].Columns) @@ -98,6 +116,274 @@ return objJsonResult; } } /// <summary> /// 工序流转卡只显示工序染厂的数据 /// </summary> /// <param name="sWhere"></param> /// <param name="user"></param> /// <returns></returns> [Route("LEMS/MES_ProcessExchangeBillList_Json")] [HttpGet] public object MES_ProcessExchangeBillList_Json(string sWhere, string user,int OperationType) { DataSet ds; try { List<object> columnNameList = new List<object>(); //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Query", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无查询权限!"; objJsonResult.data = null; return objJsonResult; } if (OperationType == 1) { //获取系统参数 string Ret = ""; if (oSystemParameter.ShowBill(ref Ret)) { //判断客户为乔一 if (oSystemParameter.omodel.WMS_CampanyName == "乔一") { sWhere += " and 工序='染厂' "; } else { sWhere += " and 工序='粗磨' "; } } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ds = oCN.RunProcReturn("select top 1000 * from h_v_Sc_ProcessExchangeBillList where 1 = 1 " + sWhere + " order by hmainid desc ", "h_v_Sc_ProcessExchangeBillList"); } else { //获取系统参数 string Ret = ""; if (oSystemParameter.ShowBill(ref Ret)) { //判断客户为龙山汽配 if (oSystemParameter.omodel.WMS_CampanyName == "乔一") { } } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeArrangementList where 1 = 1 " + sWhere , "h_v_Sc_ProcessExch_v_Sc_ProcessExchangeArrangementListhangeBillList"); } //添加列名 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("LEMS/ProcessExchangeArrangement_Add")] [HttpGet] public object ProcessExchangeArrangement_Add(string HInterID_S, int HSourceID,long HOrgID,string user) { DataSet ds; DataSet ds1; try { var HNum = HInterID_S.Split(','); oCN.BeginTran(); for (int j = 0; j < HNum.Length; j++) { long HInterID = long.Parse(HNum[j].Split('|')[0]); long HEntryID = long.Parse(HNum[j].Split('|')[1]); ds = oCN.RunProcReturn(@"select a.HMaterID,b.HProcID,a.HBillNo from Sc_ProcessExchangeBillMain a inner join Sc_ProcessExchangeBillSub b on a.HInterID=b.HInterID where a.HInterID=" + HInterID + " and b.HEntryID=" + HEntryID, "Sc_ProcessExchangeBillMain"); if (ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "查无此工序流转卡！"; objJsonResult.data = null; return objJsonResult; } //查询子工艺路线物料 工序 string HMaterID = ds.Tables[0].Rows[0]["HMaterID"].ToString(); string HProcID = ds.Tables[0].Rows[0]["HProcID"].ToString(); ds1 = oCN.RunProcReturn(@"select a.HMaterID,a.HMainProcID,b.* from Gy_RoutingBillMain a inner join Gy_RoutingBillSub b on a.HInterID=b.HInterID where a.HMaterID=" + HMaterID + " and a.HMainProcID=" + HProcID + " and a.HBillSubType='SUB'", "Gy_RoutingBillMain"); if (ds1.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有相对应的默认工艺路线,请先设置工艺路线！"; objJsonResult.data = null; return objJsonResult; } DAL.ClsSc_ProcessExchangeBill oBill = new DAL.ClsSc_ProcessExchangeBill(); string sReturn = ""; DBUtility.ClsPub.HOrgID = HOrgID; oBill.ShowBill(HInterID, ref sReturn); long HInterID1 = DBUtility.ClsPub.CreateBillID(oBill.omodel.HBillType, ref DBUtility.ClsPub.sExeReturnInfo); string HBillNo = DBUtility.ClsPub.CreateBillCode(oBill.omodel.HBillType, ref DBUtility.ClsPub.sExeReturnInfo, true); oBill.omodel.HInterID = HInterID1; oBill.omodel.HBillNo = HBillNo; oBill.omodel.HBillSubType = "SUB"; oBill.omodel.HDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); oBill.omodel.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); oBill.omodel.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month); oBill.omodel.HMaker = user; oBill.omodel.HMakeDate = DateTime.Now.ToString(); oBill.omodel.HMainSourceInterID = HInterID; oBill.omodel.HMainSourceEntryID = HEntryID; oBill.omodel.HMainSourceBillNo = ds.Tables[0].Rows[0]["HBillNo"].ToString(); oBill.DetailColl.Clear(); for (int i = 0; i < ds1.Tables[0].Rows.Count; i++) { Model.ClsSc_ProcessExchangeBillSub oSub = new Model.ClsSc_ProcessExchangeBillSub(); oSub.HInterID = HInterID1; oSub.HEntryID = (i + 1); oSub.HProcNo = long.Parse(ds1.Tables[0].Rows[i]["HProcNo"].ToString()); oSub.HProcID = long.Parse(ds1.Tables[0].Rows[i]["HProcID"].ToString()); oSub.HWorkRemark = ds1.Tables[0].Rows[i]["HRemark"].ToString(); oSub.HCenterID = long.Parse(ds1.Tables[0].Rows[i]["HCenterID"].ToString()); oSub.HSupID = long.Parse(ds1.Tables[0].Rows[i]["HSupID"].ToString()); oSub.HSupFlag = ds1.Tables[0].Rows[i]["HSupFlag"].ToString() == "1" ? true : false; oSub.HQty = oBill.omodel.HQty; oSub.HTechnologyParameter = ""; oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); oBill.DetailColl.Add(oSub); } bool bResult = false; bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); oCN.RunProc("update Sc_ProcessExchangeBillSub set HSourceID=" + HSourceID + " where HInterID=" + HInterID + " and HEntryID=" + HEntryID); if (!bResult) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "派工失败！" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } 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 = "异常！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 取消排缸功能 [Route("LEMS/ProcessExchangeArrangementDel")] [HttpGet] public object ProcessExchangeArrangementDel(string HInterID_S, int HSourceID, long HOrgID, string user) { DataSet ds; DataSet ds1; try { var HNum = HInterID_S.Split(','); oCN.BeginTran(); for (int j = 0; j < HNum.Length; j++) { ds = oCN.RunProcReturn(@"select * from Sc_ProcessExchangeBillMain a where a.HInterID=" + HNum[j], "Sc_ProcessExchangeBillMain"); if (ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "查无此子工序流转卡！"; objJsonResult.data = null; return objJsonResult; } string HMainSourceInterID = ds.Tables[0].Rows[0]["HMainSourceInterID"].ToString(); string HMainSourceEntryID = ds.Tables[0].Rows[0]["HMainSourceEntryID"].ToString(); ds1 = oCN.RunProcReturn(@"select * from Sc_ProcessExchangeBillMain where HInterID=" + HMainSourceInterID, "Sc_ProcessExchangeBillMain"); if (ds1.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "查无此子工序流转卡对应的主工序流转卡！"; objJsonResult.data = null; return objJsonResult; } oCN.RunProc("update Sc_ProcessExchangeBillSub set HSourceID=0 where HInterID=" + HMainSourceInterID + " and HEntryID=" + HMainSourceEntryID); oCN.RunProc("delete from Sc_ProcessExchangeBillMain where HInterID=" + HNum[j]); oCN.RunProc("delete from Sc_ProcessExchangeBillSub where HInterID=" + HNum[j]); } 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 = "异常！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion /// <summary> /// 返回工序流转卡维护列表从表 @@ -151,6 +437,21 @@ // objJsonResult.data = null; // return objJsonResult; //} //获取系统参数 string Ret = ""; if (oSystemParameter.ShowBill(ref Ret)) { //判断客户为龙山汽配 if (oSystemParameter.omodel.WMS_CampanyName == "龙山汽配") { //获取需要拼接的字符串 string sql_splice = DBUtility.ClsPub.SpliceSQL(user, "工序派工单明细列表"); sWhere += sql_splice; } } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeIssueBillQuery where 1 = 1 " + sWhere + " order by hmainid desc ", "h_v_Sc_ProcessExchangeIssueBillQuery"); objJsonResult.code = "1"; @@ -363,23 +664,42 @@ 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; //} if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Query", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无权限查询!"; objJsonResult.data = null; return objJsonResult; } //获取系统参数 string Ret = ""; if (oSystemParameter.ShowBill(ref Ret)) { //判断客户为龙山汽配 if (oSystemParameter.omodel.WMS_CampanyName == "龙山汽配") { //获取需要拼接的字符串 string sql_splice = DBUtility.ClsPub.SpliceSQL(user,"工艺路线列表"); sWhere += sql_splice; } } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select top 1000 * from h_v_Gy_RoutingBillList order by hmainid desc", "h_v_Gy_RoutingBillList"); ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList where 1 = 1" + sWhere + " order by hmainid desc", "h_v_Gy_RoutingBillList"); } else { string sql1 = "select top 1000 * from h_v_Gy_RoutingBillList where 1 = 1 "; string sql1 = "select * from h_v_Gy_RoutingBillList where 1 = 1 "; //客户自定义 if (oSystemParameter.omodel.WMS_CampanyName == "瑞与祺" || oSystemParameter.omodel.WMS_CampanyName == "凯贝奈特") { sql1 = "select top 1000 * from h_v_Gy_RoutingBillList where 1 = 1 "; } string sql = sql1 + sWhere + " order by hmainid desc,cast(工序号 as int)"; ds = oCN.RunProcReturn(sql, "h_v_Gy_RoutingBillList"); } @@ -397,6 +717,167 @@ #endregion #region 工艺路线历史列表 /// <summary> /// 返回工艺路线历史列表 ///参数：string sql。 ///返回值：object。 /// </summary> [Route("LEMS/MES_Gy_RoutingBillList_His")] [HttpGet] public object MES_Gy_RoutingBillList_His(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; } //获取系统参数 string Ret = ""; if (oSystemParameter.ShowBill(ref Ret)) { //判断客户为龙山汽配 if (oSystemParameter.omodel.WMS_CampanyName == "龙山汽配") { //获取需要拼接的字符串 string sql_splice = DBUtility.ClsPub.SpliceSQL(user, "工艺路线列表"); sWhere += sql_splice; } } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList_His where 1 = 1" + sWhere + " order by hmainid desc", "h_v_Gy_RoutingBillList"); } else { string sql1 = "select * from h_v_Gy_RoutingBillList_His where 1 = 1 "; //客户自定义 if (oSystemParameter.omodel.WMS_CampanyName == "瑞与祺"|| oSystemParameter.omodel.WMS_CampanyName == "凯贝奈特") { sql1 = "select top 1000 * from h_v_Gy_RoutingBillList_His where 1 = 1 "; } string sql = sql1 + sWhere + " order by hmainid desc,cast(工序号 as int)"; ds = oCN.RunProcReturn(sql, "h_v_Gy_RoutingBillList_His"); } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } return GetObjectJson(ds); } #endregion #region 查看工艺路线列表工价权限 /// <summary> /// 判断有无查看工价权限 ///参数：string sql。 ///返回值：object。 /// </summary> [Route("Web/CheckProcPrice")] [HttpGet] public object CheckProcPrice(string UserName) { try { //获取系统参数 string Ret = ""; if (oSystemParameter.ShowBill(ref Ret)) { //判断客户为龙山汽配 if (oSystemParameter.omodel.WMS_CampanyName == "龙山汽配") { //判断是否有查询工价权限 if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_CheckProcPrice", 1, false, UserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无查看工价权限!"; objJsonResult.data = null; return objJsonResult; } } } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "查看成功！"; objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "异常！" + e.Message; objJsonResult.data = null; return objJsonResult; ; } } #endregion #region 修改工艺路线工价权限 /// <summary> /// 判断有无修改工价权限 ///参数：string sql。 ///返回值：object。 /// </summary> [Route("Web/EditProcPrice")] [HttpGet] public object EditProcPrice(string UserName) { try { //获取系统参数 string Ret = ""; if (oSystemParameter.ShowBill(ref Ret)) { //判断客户为龙山汽配 if (oSystemParameter.omodel.WMS_CampanyName == "龙山汽配") { //判断是否有查询工价权限 if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_EditProcPrice", 1, false, UserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无修改工价权限!"; objJsonResult.data = null; return objJsonResult; } } } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "修改成功！"; objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "异常！" + e.Message; objJsonResult.data = null; return objJsonResult; ; } } #endregion #region 工艺路线 删除 /// <summary> /// 工艺路线删除功能 @@ -410,6 +891,7 @@ string ModRightNameCheck = "Gy_RoutingBill_Drop"; try { string HComputerName = SystemInformation.ComputerName; //设备名称 //删除权限 if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, user)) { @@ -430,7 +912,7 @@ return objJsonResult; } oCN.BeginTran();//开始事务 ds = oCN.RunProcReturn("select * from Gy_RoutingBillmain where HInterID=" + lngBillKey, "Gy_RoutingBillmain"); ds = oCN.RunProcReturn("select * from Gy_RoutingBillMain where HInterID=" + lngBillKey, "Gy_RoutingBillmain"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; @@ -459,6 +941,10 @@ //} oCN.RunProc("delete from Gy_RoutingBillmain where HInterID=" + lngBillKey); oCN.RunProc("delete from Gy_RoutingBillSub where HInterID=" + lngBillKey); LogService.Write("用户:" + user + ",日期:" + DateTime.Now + ",删除工艺路线单据:" + ds.Tables[0].Rows[0]["HBillNo"].ToString()); oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "删除工艺路线单据：" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','LMES-工艺路线模块','" + DBUtility.ClsPub.IPAddress + "','删除单据'", ref DBUtility.ClsPub.sExeReturnInfo); oCN.Commit();//提交事务 objJsonResult.code = "0"; objJsonResult.count = 1; @@ -521,6 +1007,84 @@ #endregion #region 工艺路线(维护工价) /// <summary> /// 返回工艺路线列表 ///参数：string sql。 ///返回值：object。 /// </summary> [Route("LEMS/MES_Gy_RoutingBillMainRates_Json")] [HttpGet] public object MES_Gy_RoutingBillMainRates_Json(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(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList_MainRate order by hmainid desc", "h_v_Gy_RoutingBillList_MainRate"); } else { string sql1 = "select * from h_v_Gy_RoutingBillList_MainRate where 1 = 1 "; string sql = sql1 + sWhere + " order by hmainid desc,cast(工序号 as int)"; ds = oCN.RunProcReturn(sql, "h_v_Gy_RoutingBillList_MainRate"); } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } return GetObjectJson(ds); } #endregion #region 判断物料是否已经存在工艺路线 /// <summary> /// 返回工艺路线列表 ///参数：string sql。 ///返回值：object。 /// </summary> [Route("LEMS/IsExistRoutingByMaterial")] [HttpGet] public object IsExistRoutingByMaterial(int HMaterID, string user) { DataSet ds; try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ds = oCN.RunProcReturn("select * from Gy_RoutingBillMain where HMaterID = '" + HMaterID + "'", "Gy_RoutingBillMain"); } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } return GetObjectJson(ds); } #endregion #endregion /// <summary> @@ -545,7 +1109,21 @@ return objJsonResult; } ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where 1 = 1 " + sWhere + " order by 单据号 desc", "h_v_IF_ICMOBillList"); //获取系统参数 string Ret = ""; if (oSystemParameter.ShowBill(ref Ret)) { //判断客户为龙山汽配 if (oSystemParameter.omodel.WMS_CampanyName == "龙山汽配") { //获取需要拼接的字符串 string sql_splice = DBUtility.ClsPub.SpliceSQL(user, "生产订单列表"); sWhere += sql_splice; } } ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where 1 = 1 " + sWhere + " order by 制单日期 desc,单据号 desc", "h_v_IF_ICMOBillList"); } catch (Exception e) { @@ -557,6 +1135,121 @@ } return GetObjectJson(ds); } #region 客户订单 生产订单完工 [Route("LEMS/sc_ICOMReportClose")] [HttpPost] public object sc_ICOMReportClose([FromBody] JObject sMainSub) { DataSet ds; try { var _value = sMainSub["sMainSub"].ToString(); string[] sArray = _value.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string HICOMBillNoNum = sArray[0].ToString(); string user = sArray[1].ToString(); //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBill_Edit", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无权限查询!"; objJsonResult.data = null; return objJsonResult; } var HICOMBillNo = HICOMBillNoNum.Split(','); oCN.BeginTran(); for (int i = 0; i < HICOMBillNo.Length; i++) { ds = oCN.RunProcReturn("select * from Sc_ICMOBillMain where HBillNo='" + HICOMBillNo[i] + "'", "Sc_ICMOBillMain"); if (ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "查无数据！"; objJsonResult.data = null; return objJsonResult; } oCN.RunProc("update Sc_ICMOBillSub set HSTATUS=5 where HInterID=" + ds.Tables[0].Rows[0]["HInterID"].ToString()); } 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 = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 客户订单 生产订单添加备注 [Route("LEMS/sc_ICOMReportAddHRemark")] [HttpPost] public object sc_ICOMReportAddHRemark([FromBody] JObject sMainSub) { DataSet ds; try { var _value = sMainSub["sMainSub"].ToString(); string[] sArray = _value.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string HICOMBillNo = sArray[0].ToString(); string HRemark = sArray[1].ToString(); string user = sArray[2].ToString(); //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBill_Edit", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无权限查询!"; objJsonResult.data = null; return objJsonResult; } oCN.BeginTran(); ds = oCN.RunProcReturn("select * from Sc_ICMOBillMain where HBillNo='" + HICOMBillNo + "'", "Sc_ICMOBillMain"); if (ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "查无数据！"; objJsonResult.data = null; return objJsonResult; } oCN.RunProc("update Sc_ICMOBillMain set HRemark2='" + HRemark + "' where HBillNo='" + HICOMBillNo + "'"); 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 = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 判断下推的生产订单是否审核 [Route("LEMS/ICMOBillCheck")] @@ -1495,6 +2188,231 @@ } #region 工艺路线审核/反审核功能 [Route("Gy_RoutingBill/CheckGy_RoutingBill")] [HttpGet] public object CheckGy_RoutingBill(string HInterID, int Type, string user) { try { //判断是否有删除权限 if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Check", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无权限审核!"; objJsonResult.data = null; return objJsonResult; } if (string.IsNullOrWhiteSpace(HInterID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HInterID为空！"; objJsonResult.data = null; return objJsonResult; } ClsPub.CurUserName = user; BillOld.MvarItemKey = "Gy_RoutingBillMain"; oCN.BeginTran();//开始事务 //Type 1 审核 2 反审核 if (Type == 1) { //判断单据是否已经审核 DataSet ds; string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID; ds = oCN.RunProcReturn(sql,BillOld.MvarItemKey); 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; } } //审核单据 if (!BillOld.CheckBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo)) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } else { //判断单据是否已经反审核 DataSet ds; string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID; ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey); 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; } } //反审核单据 if (BillOld.AbandonCheck(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo)) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //DataSet DSet = oCn.RunProcReturn("exec h_p_Sc_ICMOBill_AbandonCheckCtrl " + int.Parse(HInterID), "h_p_Sc_ICMOBill_AbandonCheckCtrl"); ////if (DBUtility.ClsPub.isInt(DSet.Tables[0].Rows[0]["Hback"]) != 0) ////{ //// objJsonResult.code = "0"; //// objJsonResult.count = 1; //// objJsonResult.Message = "该任务单已下推流转卡，不允许反审核" + DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[0]["HBackRemark"]); //// objJsonResult.data = null; //// return objJsonResult; ////} } else { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } oCN.Commit();//提交事务 objJsonResult.code = "0"; 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/CloseGy_RoutingBill_1")] [HttpGet] public object CloseGy_RoutingBill(string HInterID, int Type, string user) { try { //判断是否有删除权限 if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Close", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无权限关闭!"; objJsonResult.data = null; return objJsonResult; } if (string.IsNullOrWhiteSpace(HInterID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HInterID为空！"; objJsonResult.data = null; return objJsonResult; } ClsPub.CurUserName = user; BillOld.MvarItemKey = "Gy_RoutingBillMain"; oCN.BeginTran();//开始事务 //Type 1 关闭 2 反关闭 if (Type == 1) { //判断单据是否已经关闭 DataSet ds; string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID; ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey); if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["HCloseMan"] != null && ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已关闭!不需要再关闭!"; objJsonResult.data = null; return objJsonResult; } } //关闭单据 if (!BillOld.CloseBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo)) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "关闭失败!原因:" + ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } else { //判断单据是否已经反关闭 DataSet ds; string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID; ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey); if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["HCloseMan"] == null || ds.Tables[0].Rows[0]["HCloseMan"].ToString() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已反关闭!不需要再反关闭!"; objJsonResult.data = null; return objJsonResult; } } //反关闭单据 if (!BillOld.CancelClose(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo)) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "反关闭失败!原因:" + ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } oCN.Commit();//提交事务 objJsonResult.code = "0"; 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 }
