派生自 MES-WEB-API
WebAPI/Controllers/WebAPIController.cs
@@ -1,6 +1,8 @@ using DAL; using DBUtility; using Model; using Newtonsoft.Json; using Newtonsoft.Json.Converters; using Newtonsoft.Json.Linq; using SQLHelper; using System; @@ -23,6 +25,7 @@ public DataSet ds = new DataSet(); private json objjson = new json(); private json objJsonResult = new json(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); //public static string sUrl = "http://183.129.128.86:9090/WEBS-WMSTest/WebService1.asmx"; // private POInStockBillServices oclscg_poinstockbillmain = new POInStockBillServices(); /// <summary> @@ -76,15 +79,126 @@ return objjson; } } [Route("Web/GetMAXNumPDA")] [HttpGet] public object GetMAXNumPDA(string HBillType) { try { string HBillNo = ""; string sErrMsg = ""; Int64 HInterID = 0;//显示的字段 HInterID = DBUtility.ClsPub.CreateBillID_Prod(HBillType, ref sErrMsg); HBillNo = DBUtility.ClsPub.CreateBillCode_Prod(HBillType, ref sErrMsg, true); DataSet ds; SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ds = oCN.RunProcReturn("exec h_p_IF_CheckBillIDExists_WMS " + HInterID + ",'" + HBillNo + "'", "h_p_IF_CheckBillIDExists_WMS"); if (ds == null || ds.Tables[0].Rows.Count == 0) { sErrMsg = "存在重复单据内码或单据号的单据，不允许新增，请退出后重新登录！"; objjson.code = "0"; objjson.count = 0; objjson.Message = sErrMsg; objjson.data = null; return objjson; } else if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0][0]) == "1") { sErrMsg = "存在重复单据内码或单据号的单据，不允许新增，请退出后重新登录！"; objjson.code = "0"; objjson.count = 0; objjson.Message = sErrMsg; objjson.data = null; return objjson; } else { //----------创建虚表------------------------ DataTable dt_Main = new DataTable("Json"); dt_Main.Columns.Add("HBillNo", typeof(string)); dt_Main.Columns.Add("HInterID", typeof(int)); //---------创建新行------------------------ DataRow dr_main = dt_Main.NewRow();//创建新行 dt_Main.Rows.Add(dr_main);//将新行加入到表中 dr_main["HBillNo"] = DBUtility.ClsPub.isStrNull(HBillNo); dr_main["HInterID"] = DBUtility.ClsPub.isLong(HInterID); //返回数据 objjson.code = "0"; objjson.count = 1; objjson.Message = "获取成功"; objjson.data = dt_Main; return objjson; } } catch (Exception e) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + e.ToString(); objjson.data = null; return objjson; } } //[Route("Web/Get_MaxBillNoAndID")] //[HttpGet] //public object Get_MaxBillNoAndID(string HBillType) //{ // try // { // string HBillNo = ""; // Int64 HInterID = 0;//显示的字段 // HInterID = DBUtility.ClsPub.CreateBillID(HBillType, ref DBUtility.ClsPub.sExeReturnInfo); // HBillNo = DBUtility.ClsPub.CreateBillCode(HBillType, ref DBUtility.ClsPub.sExeReturnInfo, true); // //----------创建虚表------------------------ // DataTable dt_Main = new DataTable("Json"); // dt_Main.Columns.Add("HBillNo", typeof(string)); // dt_Main.Columns.Add("HInterID", typeof(int)); // //---------创建新行------------------------ // DataRow dr_main = dt_Main.NewRow();//创建新行 // dt_Main.Rows.Add(dr_main);//将新行加入到表中 // dr_main["HBillNo"] = DBUtility.ClsPub.isStrNull(HBillNo); // dr_main["HInterID"] = DBUtility.ClsPub.isLong(HInterID); // if (HBillNo == null || HInterID == 0) // { // objjson.code = "0"; // objjson.count = 0; // objjson.Message = "获取失败"; // objjson.data = null; // return objjson; // } // else // { // objjson.code = "0"; // objjson.count = 1; // objjson.Message = "获取成功"; // objjson.data = dt_Main; // return objjson; // } // } // catch (Exception e) // { // objjson.code = "0"; // objjson.count = 0; // objjson.Message = "获取失败" + e.ToString(); // objjson.data = null; // return objjson; // } //} /// <summary> /// 登录 /// </summary> /// <param name="UserName">用户名</param> /// <param name="PassWord">密码</param> /// <param name="PassWord">组织</param> /// <returns></returns> [Route("Web/GetUser")] [HttpGet] public object GetUser(string UserName, string PassWord) public object GetUser(string UserName, string PassWord, string HOrgName) { try { @@ -100,21 +214,31 @@ objjson.data = null; return objjson; } else { objjson.code = "0"; objjson.count = 1; objjson.Message = "登录成功！"; objjson.data = ds.Tables[0]; return objjson; } string sql = string.Format(@" select a.* from Gy_UserByOrgRelation a where a.HUserID = '{0}' and a.HOrgID = '{1}'", UserName, HOrgName); DataSet _ds = oCnLoc.RunProcReturn(sql, "h_p_Xt_UserRelationOrg_Check"); //if (_ds == null || _ds.Tables[0].Rows.Count == 0) //{ // objjson.code = "0"; // objjson.count = 0; // objjson.Message = "用户" + UserName + "没有该组织权限"; // objjson.data = null; // return objjson; //} objjson.code = "0"; objjson.count = 1; objjson.Message = "登录成功！"; objjson.data = ds.Tables[0]; return objjson; } catch (Exception) catch (Exception e) { objjson.code = "0"; objjson.count = 0; objjson.Message = "登录异常！"; objjson.Message = "登录异常！" + e.Message; objjson.data = null; return objjson; ; } @@ -171,6 +295,45 @@ objjson.data = null; return objjson; ; } } //撤销缓存列表记录 [Route("Web/Rescind_Json")] [HttpGet] public object Rescind_Json(long sHInterID, string sBillNo, string sBillType) { string sErrMsg = string.Empty; try { if (webserver.RescindBillList(sHInterID, sBillNo, sBillType, ref sErrMsg)) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "删除成功！"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "删除失败！"; objJsonResult.data = null; return objJsonResult; } } catch (Exception) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "删除失败！"; objJsonResult.data = null; return objJsonResult; } } @@ -292,6 +455,159 @@ } //根据拖条码返回条码档案表唯一码信息 [Route("GroupOrder/GetBillEntry_TmpListGroupOrder")] [HttpGet] public object GetBillEntry_TmpListGroupOrder(string HBarCode) { try { ds = webserver.GetBarCode(HBarCode); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！"; objJsonResult.data = null; return objJsonResult; //DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning); } else { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; 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; } } //根据网格选中记录去修改条码档案、组托单子表记录并重新生成组托单sum表 [Route("GroupOrderBill/Edit")] [HttpGet] public object Edit(string HBarCode1, Int64 HQty) { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); try { oCN.RunProc("update Gy_BarCodeBill set HQty = " + HQty.ToString() + " where HBarCode = '" + HBarCode1 + "'"); oCN.RunProc("update Sc_PackUnionBillSub set HQty = " + HQty.ToString() + " where HBarCode = '" + HBarCode1 + "'"); DataSet ds = oCN.RunProcReturn("exec h_p_DisPlayBarCode '" + HBarCode1 + "'", "h_p_DisPlayBarCode"); long HInterIDTTM = 0; long HInterID = 0; string HBarCode_Pack = ""; string HBarCode = ""; string HUser = ""; HInterIDTTM = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HInterID_TTM"]); HBarCode_Pack = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBarCode_Pack"]); HUser = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HMaker"]); HInterID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HInterID"]); oCN.RunProc("exec h_p_WMS_PackUnionBill_SumSubBill " + HInterIDTTM.ToString() + ",'" + HBarCode_Pack + "','3783','" + HUser + "'," + HInterID.ToString()); //根据箱条码，写入 SUM表，SUM条码档案 objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "修改成功！"; objJsonResult.data = null; return objJsonResult; } //DataSet DS1 = webserver.GetBarCode(HBarCode); //HSPID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HSPID"]); //ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo); //if (DS1 == null || DS1.Tables[0].Rows.Count <= 0) // { // objjson.code = "0"; // objjson.count = 0; // objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; // objjson.data = null; // return objjson; // } // else // { // objjson.code = "0"; // objjson.count = 1; // objjson.Message = "获取成功!"; // objjson.data = DS1.Tables[0]; // return objjson; // } //} catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } //根据网格选中记录的唯一码 去删除条码档案 组托单子表 组托单sum表的唯一码数据 [Route("GroupOrderBill/Delete")] [HttpGet] public object Delete(string HBarCode1) { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); try { oCN.RunProc("delete from Gy_BarCodeBill where HBarCode = '" + HBarCode1 + "'"); oCN.RunProc("delete from Sc_PackUnionBillSub where HBarCode = '" + HBarCode1 + "'"); oCN.RunProc("delete from Sc_PackUnionBillSub_Sum where HBarCode = '" + HBarCode1 + "'"); //HSPID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HSPID"]); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "删除成功！"; objJsonResult.data = null; return objJsonResult; } //ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo); //if (DS1 == null || DS1.Tables[0].Rows.Count <= 0) // { // objjson.code = "0"; // objjson.count = 0; // objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; // objjson.data = null; // return objjson; // } // else // { // objjson.code = "0"; // objjson.count = 1; // objjson.Message = "获取成功!"; // objjson.data = DS1.Tables[0]; // return objjson; // } //} catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "删除失败" + ex.ToString(); objjson.data = null; return objjson; } } //根据黑点/白点返回不良代码、不良内码 [Route("Web/GetHWBDot")] [HttpGet] @@ -371,11 +687,58 @@ //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (Warehouse != "") { sWhere = sWhere + " and ( HNumber like '%" + Warehouse + "%' or HName like '%" + Warehouse + "%' ) "; sWhere = sWhere + " and ( HNumber like '%" + Warehouse + "%' or HName like '%" + Warehouse + "%' or HUSEORGID like '%" + Warehouse + "%' ) "; } try { ds = webserver.GetWarehouseList(sWhere, ref DBUtility.ClsPub.sErrInfo); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; objjson.data = null; return objjson; } else { objjson.code = "0"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; return objjson; } } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// <summary> /// 获取仓库列表 /// </summary> /// <returns></returns> [Route("Web/GetWarehouseList_Json_New")] [HttpGet] public object GetWarehouseList_Json_New(string Warehouse, Int64 HOrgID) { sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID =" + HOrgID + ""; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (Warehouse != "") { sWhere = sWhere + " and ( HNumber like '%" + Warehouse + "%' or HName like '%" + Warehouse + "%' or HUSEORGID like '%" + Warehouse + "%' ) "; } try { WebS.WebService1 oWeb = new WebS.WebService1(); ds = oWeb.GetWarehouseList(sWhere, ref DBUtility.ClsPub.sErrInfo); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; @@ -469,6 +832,72 @@ } } /// <summary> /// 获取仓位列表 /// </summary> /// <returns></returns> [Route("Web/GetStockPlaceList_Json_NEW")] [HttpGet] public object GetStockPlaceList_Json_NEW(string StockPlace, Int64 HWhID, Int64 HOrgID) { WebS.WebService1 oWeb = new WebS.WebService1(); sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + HOrgID + ""; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (HWhID == 0) { if (StockPlace != "") { sWhere = " Where HStopFlag=0 and ( HNumber like '%" + StockPlace + "%' or HName like '%" + StockPlace + "%' ) "; } else { sWhere = " Where HStopFlag=0 "; } } else { if (StockPlace != "") { sWhere = " Where HStopFlag=0 and HWHID=" + HWhID.ToString() + " and HWHID=" + HWhID.ToString() + " and ( HNumber like '%" + StockPlace + "%' or HName like '%" + StockPlace + "%' ) "; } else { sWhere = " Where HStopFlag=0 and HWHID=" + HWhID.ToString(); } } try { //ds = webserver.GetStockPlaceList(sWhere, ref DBUtility.ClsPub.sErrInfo); ds = oWeb.GetStockPlaceList(sWhere, ref DBUtility.ClsPub.sErrInfo); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; objjson.data = null; return objjson; } else { objjson.code = "0"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; return objjson; } } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// <summary> /// /扫描仓位二维码带出仓库仓位 /// </summary> @@ -513,23 +942,26 @@ } } /// <summary> /// 获取供应商列表 /// </summary> /// <returns></returns> [Route("Web/GetSupplierList_Json")] [HttpGet] public object GetSupplierList_Json(string Supplier) public object GetSupplierList_Json(string Supplier, Int64 HOrgID) { sWhere = " Where HStopFlag=0 and HEndFlag=1"; sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID =" + HOrgID + ""; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (Supplier != "") { sWhere = sWhere + " and ( HNumber like '%" + Supplier + "%' or HName like '%" + Supplier + "%' ) "; sWhere = sWhere + " and ( HNumber like '%" + Supplier + "%' or HName like '%" + Supplier + "%' or HUSEORGID like '%" + Supplier + "%' ) "; } try { ds = webserver.GetSupplierList(sWhere, ref DBUtility.ClsPub.sErrInfo); WebS.WebService1 oWeb = new WebS.WebService1(); ds = oWeb.GetSupplierList(sWhere, ref DBUtility.ClsPub.sErrInfo); //ds = webserver.GetSupplierList(sWhere, ref DBUtility.ClsPub.sErrInfo); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; @@ -591,7 +1023,8 @@ } try { ds = webserver.GetEmployeeList(sWhere, ref DBUtility.ClsPub.sErrInfo); string sql = $"Select * from h_v_IF_Emp {sWhere} Order by HNumber"; ds = oCN.RunProcReturn(sql, "h_v_IF_Emp"); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; @@ -633,7 +1066,7 @@ try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ds = oCN.RunProcReturn("Select HItemID,HNumber 班组代码,HName 班组 from h_v_IF_Group where HStopflag=0 " + sWhere + " Order by HItemID ", "h_v_IF_Group"); ds = oCN.RunProcReturn("Select HItemID,班组代码 班组代码,班组名称 班组 from h_v_GroupList where 1=1 " + sWhere + " Order by HItemID ", "h_v_GroupList"); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; @@ -679,6 +1112,53 @@ try { ds = webserver.GetDepartmentList(sWhere, ref DBUtility.ClsPub.sErrInfo); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; objjson.data = null; return objjson; } else { objjson.code = "0"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; return objjson; } } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// <summary> /// 获取组织列表 /// </summary> /// <returns></returns> [Route("Web/GetOrganizationList_Json")] [HttpGet] public object GetOrganizationList_Json() { WebS.WebService1 oWebs1 = new WebS.WebService1(); //sWhere = " Where HStopFlag=0 and HEndFlag=1"; ////sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); //if (Organization != "") //{ // sWhere = sWhere + " and ( HNumber like '%" + Organization + "%' or HName like '%" + Organization + "%' ) "; //} try { ds = oWebs1.get_ORGANIZATIONSList(); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; @@ -865,7 +1345,7 @@ //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (sWhere != "") { sWhere = sWhere + " and ( HNumber like '%" + sWhere + "%' or HName like '%" + sWhere + "%' ) "; sWhere = " and ( HNumber like '%" + sWhere + "%' or HName like '%" + sWhere + "%' ) "; } try { @@ -929,6 +1409,61 @@ return objjson; ; } } #region 产线中心列表查询 [Route("Web/Gy_LineCenter_Json")] [HttpGet] public object Gy_LineCenter_Json(string BadReason) { if (BadReason != "") { sWhere = sWhere + " and ( HNumber like '%" + BadReason + "%' or HName like '%" + BadReason + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_LineCenter where HStopflag=0 Order by HItemID ", "Gy_LineCenter"); } else { string sql1 = "Select HItemID,HNumber ,HName from Gy_LineCenter where HStopflag=0 and HEndFlag=1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_LineCenter"); sWhere = ""; } if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; objjson.data = null; return objjson; } else { objjson.code = "0"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; return objjson; } } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } #endregion #region 不良原因设置列表/保存/编辑/删除方法 /// <summary> @@ -1003,10 +1538,21 @@ { DataSet ds; var _value = msg["msg"].ToString(); string msg1 = _value.ToString(); //string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); //string msg2 = sArray[0].ToString(); //string msg3 = sArray[1].ToString(); string msg3 = _value.ToString(); string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg1 = sArray[0].ToString(); string msg2 = sArray[1].ToString(); //查看权限 if (!DBUtility.ClsPub.Security_Log("Gy_BadReason_Edit", 1, false, msg2)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无保存权限！"; objJsonResult.data = null; return objJsonResult; } Int64 HItemID = 0; SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); //获取最大ID值赋值 @@ -1202,21 +1748,21 @@ /// <returns></returns> [Route("DeltetGy_BadReason")] [HttpGet] public object DeltetGy_BadReason(string HItemID) public object DeltetGy_BadReason(string HItemID, string user) { DataSet ds; //string ModRightNameCheck = "Sc_ProcessReport_check"; try { //删除权限 //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "审核失败！无权限！"; // objJsonResult.data = null; // return objJsonResult; //} if (!DBUtility.ClsPub.Security_Log("Gy_BadReason_Delete", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无删除权限！"; objJsonResult.data = null; return objJsonResult; } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (string.IsNullOrWhiteSpace(HItemID)) @@ -1279,7 +1825,7 @@ { //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (BadReason != ""&& BadReason != null) if (BadReason != "" && BadReason != null) { sWhere = sWhere + " and ( HNumber like '%" + BadReason + "%' or HName like '%" + BadReason + "%' ) "; } @@ -1604,7 +2150,7 @@ } /// <summary> /// 获取核算方式列表 /// 获取核算方式组列表 /// </summary> /// <returns></returns> [Route("Web/GetClassTimePrjGroupList_Json")] @@ -1659,6 +2205,207 @@ objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } [Route("Web/GetClassTimePrjGroupBillList_Json")] [HttpGet] public object GetClassTimePrjGroupBillList_Json(string sWhere, string user) { if (!DBUtility.ClsPub.Security_Log("Gy_ClassTimePrj", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有查看权限"; objJsonResult.data = null; return objJsonResult; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql = "Select a.HItemID ,HNumber 核算方式组代码,HName 核算方式组名称,HDeptID,b.部门名称 部门 from Gy_ClassTimePrjGroup a left join h_v_Gy_Department b on a.HDeptID=b.HItemID"; if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn(sql, "Gy_ClassTimePrjGroup"); } else { sql = sql + sWhere; ds = oCN.RunProcReturn(sql, "Gy_ClassTimePrjGroup"); } //ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; objjson.data = null; return objjson; } else { objjson.code = "0"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; return objjson; } } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// <summary> /// 核算方式组编辑 /// </summary> /// <param name="sWhere"></param> /// <param name="user"></param> /// <returns></returns> [Route("Web/GetClassTimePrjGroupBillEdit_Json")] [HttpGet] public object GetClassTimePrjGroupBillEdit_Json(string sWhere) { //if (!DBUtility.ClsPub.Security_Log("Gy_ClassTimePrj", 1, false, user)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "没有查看权限"; // objJsonResult.data = null; // return objJsonResult; //} try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql = "select a.HNumber,a.HName,a.HDeptID,b.HName as 仓库名称 from Gy_ClassTimePrjGroup a left join Gy_Department b on a.HDeptID = b.HItemID where a.hitemid = " + sWhere; ds = oCN.RunProcReturn(sql, "Gy_ClassTimePrjGroup"); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; objjson.data = null; return objjson; } else { objjson.code = "1"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; return objjson; } } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } #region 删除核算方式组 /// <summary> /// 核算方式列表删除按钮 ///参数：string sql。 ///返回值：object。 /// </summary> [Route("Web/DeleteClassTimePrjGroupBillList")] [HttpGet] public object DeleteClassTimePrjGroupBillList(long HItemID, string User) { try { if (!DBUtility.ClsPub.Security_Log("Gy_ClassTimePrj_Delete", 1, false, User)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有删除权限"; objJsonResult.data = null; return objJsonResult; } oCN.BeginTran(); string sql = "delete from Gy_ClassTimePrjGroup where HItemID =" + HItemID; oCN.RunProc(sql); 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 /// <summary> /// 保存获取核算方式组 /// </summary> /// <param name="msg"></param> /// <returns></returns> [Route("Web/SaveGetClassTimePrjGroupList")] [HttpGet] public object SaveGetClassTimePrjGroupList(string HNumber, string HName, string HDeptID, string refSav, string user, string HItem) { try { int HItemID = int.Parse(HItem); //编辑权限 if (!DBUtility.ClsPub.Security_Log_second("Gy_ClassTimePrj", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无保存权限！"; objJsonResult.data = null; return objJsonResult; } string sql = ""; if (refSav == "Add") { sql = "Insert Into Gy_ClassTimePrjGroup " + "(HNumber,HName,HStopflag,HRemark,HShortNumber,HParentID,HLevel" + ",HEndFlag,HHelpCode,HDeptID,HGroupID,HUseFlag" + ") " + " values('" + HNumber + "','" + HName + "','','',0,0,0,0,''," + HDeptID + ",0,'未使用'" + ") "; } else { sql = "UpDate Gy_ClassTimePrjGroup set HNumber='" + HNumber + "',HName='" + HName + "',HDeptID=" + HDeptID + " where HItemID=" + HItemID; } oCN.RunProc(sql); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "保存成功"; objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！" + e.ToString(); objJsonResult.data = 1; return objJsonResult; } } @@ -1735,9 +2482,9 @@ sWhere = " Where HStopFlag=0 and HEndFlag=1"; SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (CheckItem != ""&& CheckItem!=null) if (CheckItem != "" && CheckItem != null) { sWhere = sWhere + " and ( HNumber like '%" + CheckItem + "%' or HName like '%" + CheckItem + "%' ) "; sWhere = sWhere + " and ( HNumber like '%" + CheckItem + "%' or HName like '%" + CheckItem + "%' ) "; ds = oCN.RunProcReturn("Select HItemID,HNumber,HName from Gy_DotCheck " + sWhere + " Order by HItemID ", "Gy_DotCheck"); } else @@ -1780,7 +2527,7 @@ /// <returns></returns> [Route("Web/GetSc_ICMOBillListView")] [HttpGet] public object GetSc_ICMOBillListView(string ICMOBill,int OrganizationID) public object GetSc_ICMOBillListView(string ICMOBill, int OrganizationID) { if (ICMOBill != "") { @@ -1795,7 +2542,7 @@ } else { string sql = "select * from h_v_IF_ICMOBillList "+ sWhere+ " and isnull(审核人,'')<>'' and isnull(关闭人,'')='' and isnull(行关闭人,'')='' order by 单据号 desc,hsubid "; string sql = "select * from h_v_IF_ICMOBillList " + sWhere + " and isnull(审核人,'')<>'' and isnull(关闭人,'')='' and isnull(行关闭人,'')='' order by 单据号 desc,hsubid "; ds = oCN.RunProcReturn(sql, "h_v_IF_ICMOBillList"); } if (ds == null || ds.Tables[0].Rows.Count <= 0) @@ -1831,50 +2578,99 @@ /// <returns></returns> [Route("Web/GetSc_ICMOBillListView2")] [HttpGet] public object GetSc_ICMOBillListView2(string ICMOBill, int OrganizationID) public object GetSc_ICMOBillListView2(int page, int limit, string ICMOBill, int OrganizationID) { if (ICMOBill != "") { sWhere = " where 1=1 and 单据号 like '%" + ICMOBill + "%' "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); int count = 0; int pageNum = page; int pageSize = limit; string sWhere = ""; if (ICMOBill == null || ICMOBill.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Sc_ICMOBillList where 1=1 and isnull(审核人,'')<>'' order by 单据号 desc,hsubid ", "h_v_Sc_ICMOBillList"); sWhere = " where 1=1"; } else { string sql = "select * from h_v_Sc_ICMOBillList " + sWhere + " and isnull(审核人,'')<>'' order by 单据号 desc,hsubid "; ds = oCN.RunProcReturn(sql, "h_v_Sc_ICMOBillList"); sWhere = " where 1=1 and 单据号 like '%" + ICMOBill + "%'"; } if (ds == null || ds.Tables[0].Rows.Count <= 0) DataSet ds0 = oCn.RunProcReturn("select count(*) CountNum from h_v_Sc_ICMOBillList " + sWhere + "", "h_v_Sc_ICMOBillList"); count = int.Parse(ds0.Tables[0].Rows[0]["CountNum"].ToString()); //string sql = string.Format(@"select top " + pageSize + " hmainid,日期,单据号,箱号条形码,净重,毛重,皮重,生产组织,部门,操作员,客户标签号,物料代码,物料名称,计量单位代码,计量单位名称,数量,制单人,制单日期 from(select row_number() over (order by hmainid desc) as RowNumber,hmainid,日期,单据号,箱号条形码,净重,毛重,皮重,生产组织,部门,操作员,客户标签号,物料代码,物料名称,计量单位代码,计量单位名称,数量,制单人,制单日期 from h_v_PackUnionBillList " + sWhere + ") as A where RowNumber >" + pageSize + " *(" + pageNum + "-1)"); string sql = string.Format(@"select * from h_v_Sc_ICMOBillList " + sWhere + " and isnull(审核人,'')<>'' order by hmainid offset ((" + pageNum + "-1)*" + pageSize + ") rows fetch next " + pageSize + " rows only"); ds = new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_ICMOBillList"); string aa = ds.Tables[0].Columns[0].ToString(); if (ds.Tables[0].Rows.Count > 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; objjson.data = null; return objjson; objJsonResult.code = "1"; objJsonResult.count = count; objJsonResult.Message = "返回记录成功！"; objJsonResult.data = JsonConvert.DeserializeObject<DataTable>(JsonConvert.SerializeObject(ds.Tables[0], new IsoDateTimeConverter { DateTimeFormat = "yyyy-MM-dd HH:mm:ss" })); //序列化DataSet中的时间格式，然后再反序列化回来 return objJsonResult; } else { objjson.code = "0"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; return objjson; objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "暂无记录！"; objJsonResult.data = null; return objJsonResult; } } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + ex.ToString(); objJsonResult.data = null; return objJsonResult; } //if (ICMOBill != "") //{ // sWhere = " where 1=1 and 单据号 like '%" + ICMOBill + "%' "; //} //try //{ // SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); // if (sWhere == null || sWhere.Equals("")) // { // ds = oCN.RunProcReturn("select * from h_v_Sc_ICMOBillList where 1=1 and isnull(审核人,'')<>'' order by 单据号 desc,hsubid ", "h_v_Sc_ICMOBillList"); // } // else // { // string sql = "select * from h_v_Sc_ICMOBillList " + sWhere + " and isnull(审核人,'')<>'' order by 单据号 desc,hsubid "; // ds = oCN.RunProcReturn(sql, "h_v_Sc_ICMOBillList"); // } // if (ds == null || ds.Tables[0].Rows.Count <= 0) // { // objjson.code = "0"; // objjson.count = 0; // objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; // objjson.data = null; // return objjson; // } // else // { // objjson.code = "0"; // objjson.count = 1; // objjson.Message = "获取成功!"; // objjson.data = ds.Tables[0]; // return objjson; // } //} //catch (Exception ex) //{ // objjson.code = "0"; // objjson.count = 0; // objjson.Message = "获取失败" + ex.ToString(); // objjson.data = null; // return objjson; //} } /// <summary> @@ -1935,7 +2731,7 @@ /// <returns></returns> [Route("Web/GetGy_QCCheckItem")] [HttpGet] public object GetGy_QCCheckItem(string CheckItem,int OrganizationID) public object GetGy_QCCheckItem(string CheckItem, int OrganizationID) { if (CheckItem != "") { @@ -2073,6 +2869,366 @@ } /// <summary> /// 根据器具主内码获取器具保养检验项目 /// </summary> /// <returns></returns> [Route("Web/GetMaintainItemtemByMouldProjectID")] [HttpGet] public object GetMaintainItemtemByMouldProjectID(int MouldProjectID) { if (MouldProjectID <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "产品器具未选择"; objjson.data = null; return objjson; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); List<object> list = new List<object>(); DataSet ds2; DataSet ds1; string sql1 = string.Format(@"select t.HMaintainItemID ,m.HNumber HMaintainItemNumber,t.HMaintainItem,t.HMaintainPart,t.HClaim,t.HManagerID,e.HNumber HManagerNumber,e.HName HManagerName,a.HRemark from Sc_MouldMaintainRuleBillMain a left join Sc_MouldMaintainRuleBillSub_Item t on a.HInterID=t.HInterID left join Gy_Maintain m on m.HItemID=t.HMaintainItemID left join Gy_Employee e on e.HItemID=t.HManagerID where a.HInterID=(select HMouldMaintainRuleInterID from Gy_MouldFileMain where HInterID=" + MouldProjectID + ") "); string sql2 = string.Format(@"select b.HMaterID,m.HNumber HMaterNumber,m.HName HMaterName, m.HModel HMaterSpec,b.HUnitID,u.HNumber HUnitNumber,u.HName HUnitName,b.HQty,b.HQtyMust,b.HRemark from Sc_MouldMaintainRuleBillMain a left join Sc_MouldMaintainRuleBillSub b on a.HInterID=b.HInterID left join h_v_IF_Material m on b.HMaterID=m.HItemID left join h_v_IF_Unit u on b.HUnitID=u.HItemID where a.HInterID=(select HMouldMaintainRuleInterID from Gy_MouldFileMain where HInterID=" + MouldProjectID + ") "); ds1 = oCN.RunProcReturn(sql1, "Sc_MouldMaintainRuleBillMain");//保养 ds2 = oCN.RunProcReturn(sql2, "Sc_MouldMaintainRuleBillMain");//配件 list.Add(ds1.Tables[0]); list.Add(ds2.Tables[0]); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.list = list; return objJsonResult; } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// <summary> /// 根据器具主内码获取器具保养检验项目 /// </summary> /// <returns></returns> [Route("Web/GetMouldMaintainItemtemByMaintainRuleID")] [HttpGet] public object GetMouldMaintainItemtemByMaintainRuleID(int MouldMaintainRuleID) { if (MouldMaintainRuleID <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "器具保养规程未选择"; objjson.data = null; return objjson; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); List<object> list = new List<object>(); DataSet ds2; DataSet ds1; string sql1 = string.Format(@"select t.HMaintainItemID ,m.HNumber HMaintainItemNumber,t.HMaintainItem,t.HMaintainPart,t.HClaim,t.HManagerID,e.HNumber HManagerNumber,e.HName HManagerName,a.HRemark from Sc_MouldMaintainRuleBillMain a left join Sc_MouldMaintainRuleBillSub_Item t on a.HInterID=t.HInterID left join Gy_Maintain m on m.HItemID=t.HMaintainItemID left join Gy_Employee e on e.HItemID=t.HManagerID where a.HInterID=" + MouldMaintainRuleID); string sql2 = string.Format(@"select b.HMaterID,m.HNumber HMaterNumber,m.HName HMaterName, m.HModel HMaterSpec,b.HUnitID,u.HNumber HUnitNumber,u.HName HUnitName,b.HQty,b.HQtyMust,b.HRemark from Sc_MouldMaintainRuleBillMain a left join Sc_MouldMaintainRuleBillSub b on a.HInterID=b.HInterID left join h_v_IF_Material m on b.HMaterID=m.HItemID left join h_v_IF_Unit u on b.HUnitID=u.HItemID where a.HInterID=" + MouldMaintainRuleID); ds1 = oCN.RunProcReturn(sql1, "Sc_MouldMaintainRuleBillMain");//保养 ds2 = oCN.RunProcReturn(sql2, "Sc_MouldMaintainRuleBillMain");//配件 list.Add(ds1.Tables[0]); list.Add(ds2.Tables[0]); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.list = list; return objJsonResult; } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// <summary> /// 器具点检规程单列表 /// </summary> /// <returns></returns> [Route("Sc_MouldDotCheckRuleInter/GetMouldDotCheckRuleInterList")] [HttpGet] public object GetMouldDotCheckRuleInterList(string sWhere) { try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql = string.Format(@"select * from h_v_Sc_MouldDotCheckRuleBillList "); ds = oCN.RunProcReturn(sql + sWhere, "h_v_Sc_MouldDotCheckRuleBillList"); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; objjson.data = null; return objjson; } else { objjson.code = "1"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; return objjson; } } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// <summary> /// 根据设备显示设备保养规程项目 /// </summary> /// <returns></returns> [Route("Web/GetMaintainItemtemByEquipProjectID")] [HttpGet] public object GetMaintainItemtemByEquipProjectID(int EquipProjectID) { if (EquipProjectID <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "产品器具未选择"; objjson.data = null; return objjson; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); List<object> list = new List<object>(); DataSet ds2; DataSet ds1; string sql1 = string.Format(@"select t.HMaintainItemID HMaintainItemID,m.HNumber HMaintainItemNumber,t.HMaintainItem HMaintainItem,t.HMaintainPart HMaintainPart,t.HClaim HClaim,t.HManagerID HManagerID,e.HNumber HManagerNumber,e.HName HManagerName,a.HRemark from Sb_EquipMaintainRuleBillMain a left join Sb_EquipMaintainRuleBillSub_Item t on a.HInterID=t.HInterID left join Gy_Maintain m on m.HItemID=t.HMaintainItemID left join Gy_Employee e on e.HItemID=t.HManagerID where a.HInterID=(select HEquipMaintainRuleInterID from Gy_EquipFileBillMain where HInterID=" + EquipProjectID + ") "); string sql2 = string.Format(@"select b.HMaterID,m.HNumber HMaterNumber,m.HName HMaterName,b.HUnitID,u.HNumber HUnitNumber,u.HName HUnitName,b.HQty,b.HRemark from Sb_EquipMaintainRuleBillMain a left join Sb_EquipMaintainRuleBillSub b on a.HInterID=b.HInterID left join h_v_IF_Material m on b.HMaterID=m.HItemID left join h_v_IF_Unit u on b.HUnitID=u.HItemID where a.HInterID=(select HEquipMaintainRuleInterID from Gy_EquipFileBillMain where HInterID=" + EquipProjectID + ") "); ds1 = oCN.RunProcReturn(sql1, "Sb_EquipMaintainRuleBillMain");//保养 ds2 = oCN.RunProcReturn(sql2, "Sc_MouldMaintainRuleBillMain");//配件 list.Add(ds1.Tables[0]); list.Add(ds2.Tables[0]); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.list = list; return objJsonResult; } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// <summary> /// 根据设备保养规程显示设备保养规程项目 /// </summary> /// <returns></returns> [Route("Web/GetMaintainItemtemByMaintainRuleID")] [HttpGet] public object GetMaintainItemtemByMaintainRuleID(int EquipProjectID) { if (EquipProjectID <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "设备保养规程未选择"; objjson.data = null; return objjson; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); List<object> list = new List<object>(); DataSet ds2; DataSet ds1; string sql1 = string.Format(@"select t.HMaintainItemID HMaintainItemID,m.HNumber HMaintainItemNumber,t.HMaintainItem HMaintainItem,t.HMaintainPart HMaintainPart,t.HClaim HClaim,t.HManagerID HManagerID,e.HNumber HManagerNumber,e.HName HManagerName,a.HRemark from Sb_EquipMaintainRuleBillMain a left join Sb_EquipMaintainRuleBillSub_Item t on a.HInterID=t.HInterID left join Gy_Maintain m on m.HItemID=t.HMaintainItemID left join Gy_Employee e on e.HItemID=t.HManagerID where a.HInterID=" + EquipProjectID); string sql2 = string.Format(@"select b.HMaterID,m.HNumber HMaterNumber,m.HName HMaterName,b.HUnitID,u.HNumber HUnitNumber,u.HName HUnitName,b.HQty,b.HRemark from Sb_EquipMaintainRuleBillMain a left join Sb_EquipMaintainRuleBillSub b on a.HInterID=b.HInterID left join h_v_IF_Material m on b.HMaterID=m.HItemID left join h_v_IF_Unit u on b.HUnitID=u.HItemID where a.HInterID=" + EquipProjectID); ds1 = oCN.RunProcReturn(sql1, "Sb_EquipMaintainRuleBillMain");//保养 ds2 = oCN.RunProcReturn(sql2, "Sc_MouldMaintainRuleBillMain");//配件 list.Add(ds1.Tables[0]); list.Add(ds2.Tables[0]); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.list = list; return objJsonResult; } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// <summary> /// 根据设备显示设备点检程项目 /// </summary> /// <returns></returns> [Route("Web/GetDotCheckRuleItemByEquipProjectID")] [HttpGet] public object GetDotCheckRuleItemByEquipProjectID(int EquipProjectID) { if (EquipProjectID <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "产品器具未选择"; objjson.data = null; return objjson; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql = string.Format(@"select b.HDotCheckItemID HDotCheckItemID,c.HNumber HDotCheckCode,b.HDotCheckItem,b.HDotCheckPart,b.HClaim, b.HManagerID,e.HNumber HManagerCode,e.HName HManagerName,b.HRemark,a.HInterID,a.HBillNo from Sb_EquipDotCheckRuleBillMain a left join Sb_EquipDotCheckRuleBillSub b on a.HInterID=b.HInterID left join Gy_QCCheckItem c on c.HItemID=b.HDotCheckItemID left join Gy_Employee e on e.HItemID=b.HManagerID where a.HInterID=(select HEquipDotCheckRuleInterID from Gy_EquipFileBillMain where HInterID=" + EquipProjectID + ") "); ds = oCN.RunProcReturn(sql, "Sb_EquipDotCheckRuleBillMain"); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; objjson.data = null; return objjson; } else { objjson.code = "1"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; return objjson; } } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// <summary> /// 根据设备点检规程显示设备点检程项目 /// </summary> /// <returns></returns> [Route("Web/GetDotCheckRuleItemByDotCheckRuleID")] [HttpGet] public object GetDotCheckRuleItemByDotCheckRuleID(int HDotCheckRuleInterID) { if (HDotCheckRuleInterID <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "设备点检规程未选择"; objjson.data = null; return objjson; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql = string.Format(@"select b.HDotCheckItemID HDotCheckItemID,c.HNumber HDotCheckCode,b.HDotCheckItem,b.HDotCheckPart,b.HClaim, b.HManagerID,e.HNumber HManagerCode,e.HName HManagerName,b.HRemark from Sb_EquipDotCheckRuleBillMain a left join Sb_EquipDotCheckRuleBillSub b on a.HInterID=b.HInterID left join Gy_QCCheckItem c on c.HItemID=b.HDotCheckItemID left join Gy_Employee e on e.HItemID=b.HManagerID where a.HInterID=" + HDotCheckRuleInterID); ds = oCN.RunProcReturn(sql, "Sb_EquipDotCheckRuleBillMain"); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; objjson.data = null; return objjson; } else { objjson.code = "1"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; return objjson; } } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// <summary> /// 获取维修项目列表 /// </summary> /// <returns></returns> @@ -2130,7 +3286,7 @@ /// <returns></returns> [Route("Web/GetWMSBarCodeDetailsList")] [HttpGet] public object GetWMSBarCodeDetailsList(int HInterID,string HBillType) public object GetWMSBarCodeDetailsList(int HInterID, string HBillType) { try { @@ -2195,6 +3351,193 @@ } } #region [查询菜单列表] [Route("Web/MenuList")] [HttpGet] public object MenuList() { try { List<Menu> mu = new List<Menu>(); SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); ds = oCn.RunProcReturn("Select * from Gy_Menu Order by HItemID ", "Gy_Menu"); //List<Menu> mu1 = ds.Tables[0].AsEnumerable().Select(t => new Menu()).ToList(); //List<Menu> users = ModelConvertHelper<Menu>.ConvertToModel(ds.Tables[0]); //var dd = ToHierarchy.ToHierarchyList(users); //string json = JsonConvert.SerializeObject(dd); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) //这里是循环所有 { if (ds.Tables[0].Rows[i]["HPartentID"].ToString() == "0" || ds.Tables[0].Rows[i]["HitemID"].ToString() == ds.Tables[0].Rows[i]["HPartentID"].ToString()) //判断是否最外层根节点 { Menu tbj = new Menu(); tbj.HitemID = ds.Tables[0].Rows[i]["HitemID"].ToString(); tbj.HNumber = ds.Tables[0].Rows[i]["HNumber"].ToString(); tbj.HName = ds.Tables[0].Rows[i]["HName"].ToString(); tbj.HPartentID = ds.Tables[0].Rows[i]["HPartentID"].ToString(); tbj.HLevel = int.Parse(ds.Tables[0].Rows[i]["HLevel"].ToString()); tbj.Hurl = ds.Tables[0].Rows[i]["Hurl"].ToString(); mu.Add(tbj); } } ToHierarchy.digui(ds.Tables[0], mu); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "查询成功！"; objJsonResult.data = Newtonsoft.Json.JsonConvert.SerializeObject(mu); return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "查询失败！"; objJsonResult.data = e.ToString(); return objJsonResult; } } #endregion ///// <summary> ///// 产品入库缓存列表刷新信息 ///// </summary> ///// <returns></returns> //[Route("Web/chanpinruk")] //[HttpGet] //public object chanpinruk(string HBillType, string sHMaker, Int64 HOrgID) //{ // try // { // ds = webserver.GetKf_PonderationBillMain_TempList_New(HBillType, sHMaker, HOrgID); // if (ds == null || ds.Tables[0].Rows.Count <= 0) // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "没有返回任何记录！"; // objJsonResult.data = null; // return objJsonResult; // //DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning); // } // else // { // objJsonResult.code = "0"; // objJsonResult.count = 1; // objJsonResult.Message = "获取信息成功！"; // 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; // } //} /// <summary> /// 产品入库缓存列表刷新信息 /// </summary> /// <returns></returns> [Route("Web/chanpinruk")] [HttpGet] public object chanpinruk(string HBillType, string sHMaker, Int64 HOrgID) { WebS.WebService1 oWebs = new WebS.WebService1(); try { ds = oWebs.GetKf_PonderationBillMain_TempList_New(HBillType, sHMaker, HOrgID); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！"; objJsonResult.data = null; return objJsonResult; //DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning); } else { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; 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 PDA其他入库列表模块 /// <summary> /// 其他入库缓存列表刷新信息 /// </summary> /// <param name="HBillType"></param> /// <param name="sHMaker"></param> /// <param name="HOrgID"></param> /// <returns></returns> [Route("Web/GetOtherInBillMain_TempList_New")] [HttpGet] public object GetOtherInBillMain_TempList_New (string HBillType, string sHMaker, Int64 HOrgID) { WebS.WebService1 oWebs = new WebS.WebService1(); try { List<object> columnNameList = new List<object>(); DataSet ds = oCN.RunProcReturn("exec h_p_KF_GetPonderationBillMain_TempList_New1 '" + HBillType + "','" + sHMaker + "'," + HOrgID.ToString(), "h_p_KF_GetPonderationBillMain_TempList_New1"); //添加列名 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列对象的列名 } if (ds == null || ds.Tables[0].Rows.Count <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！"; objJsonResult.data = 0; return objJsonResult; //DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning); } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; 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; } } #endregion } }
