派生自 MES-WEB-API
WebAPI/Controllers/WebAPIController.cs
@@ -26,6 +26,7 @@ private json objjson = new json(); private json objJsonResult = new json(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); //public static string sUrl = "http://183.129.128.86:9090/WEBS-WMSTest/WebService1.asmx"; // private POInStockBillServices oclscg_poinstockbillmain = new POInStockBillServices(); /// <summary> @@ -79,6 +80,116 @@ 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> @@ -91,7 +202,7 @@ public object GetUser(string UserName, string PassWord, string HOrgName) { try { { DataSet ds = null; ClsCN oCnLoc = new ClsCN(); DAL.ClsUser oUser = new DAL.ClsUser(); @@ -128,7 +239,50 @@ objjson.code = "0"; objjson.count = 0; objjson.Message = "登录异常！"+e.Message; objjson.Message = "登录异常！" + e.Message; objjson.data = null; return objjson; ; } } /// <summary> /// 菜单栏 /// </summary> /// <returns></returns> [Route("Web/MenuBar")] [HttpGet] public object MenuBar(string UserName) { try { //获取系统参数 string Ret = ""; if (oSystemParameter.ShowBill(ref Ret)) { //判断客户为龙山汽配 if (oSystemParameter.omodel.WMS_CampanyName == "龙山汽配") { //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Xt_MenuBar_Unfold", 1, false, UserName)) { objjson.code = "0"; objjson.count = 0; objjson.Message = "无展开菜单栏权限!"; objjson.data = null; return objjson; } } } objjson.code = "0"; objjson.count = 1; objjson.Message = "展开成功！"; objjson.data = 1; return objjson; } catch (Exception e) { objjson.code = "0"; objjson.count = 0; objjson.Message = "异常！" + e.Message; objjson.data = null; return objjson; ; } @@ -209,7 +363,7 @@ { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "删除失败！"; objJsonResult.Message = "删除失败！"; objJsonResult.data = null; return objJsonResult; } @@ -274,6 +428,16 @@ try { ds = webserver.GetKf_PonderationBillMain_TempList(HBillType, sWhere); List<object> columnNameList = new List<object>(); //添加列名 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) { @@ -290,6 +454,7 @@ objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } } @@ -341,6 +506,159 @@ objJsonResult.Message = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } //根据拖条码返回条码档案表唯一码信息 [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; } } @@ -570,13 +888,79 @@ } ///// <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 HUSEORGID = " + HOrgID + " 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> /// <returns></returns> [Route("Web/GetStockPlaceList_Json_NEW")] [HttpGet] public object GetStockPlaceList_Json_NEW(string StockPlace, Int64 HWhID,Int64 HOrgID) 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 + ""; @@ -679,23 +1063,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 '%" + HOrgID + "%' ) "; } 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"; @@ -757,7 +1144,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"; @@ -799,7 +1187,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"; @@ -1019,6 +1407,227 @@ } /// <summary> /// 获取计量单位组列表 /// </summary> /// <returns></returns> [Route("Web/GetUnitGroupList_Json")] [HttpGet] public object GetUnitGroupList_Json(string Unit) { //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (Unit != "" && Unit != null) { sWhere = sWhere + " and ( HNumber like '%" + Unit + "%' or HName like '%" + Unit + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("Select HItemID,HNumber 计量单位组代码,HName 计量单位组 from Gy_UnitGroup where HStopflag=0 Order by HItemID ", "Gy_UnitGroup"); } else { string sql1 = "Select HItemID,HNumber 计量单位组代码,HName 计量单位组 from Gy_UnitGroup where HStopflag=0 and HEndFlag=1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_UnitGroup"); } //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> /// <returns></returns> [Route("Web/GetSellStyleList_Json")] [HttpGet] public object GetSellStyleList_Json(string SellStyle) { if (SellStyle != "") { sWhere = sWhere + " and ( HNumber like '%" + SellStyle + "%' or HName like '%" + SellStyle + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_SellStyle where HStopflag=0 Order by HItemID ", "Gy_SellStyle"); } else { string sql1 = "Select HItemID,HNumber ,HName from Gy_SellStyle where HStopflag=0 and HEndFlag=1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_SellStyle"); } 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/GetSettleStyleList_Json")] [HttpGet] public object GetSettleStyleList_Json(string SettleStyle) { if (SettleStyle != "") { sWhere = sWhere + " and ( HNumber like '%" + SettleStyle + "%' or HName like '%" + SettleStyle + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_SettleStyle where HStopflag=0 Order by HItemID ", "Gy_SettleStyle"); } else { string sql1 = "Select HItemID,HNumber ,HName from Gy_SettleStyle where HStopflag=0 and HEndFlag=1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_SettleStyle"); } 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/GetPoStockStyleList_Json")] [HttpGet] public object GetPoStockStyleList_Json(string PoStockStyle) { if (PoStockStyle != "") { sWhere = sWhere + " and ( HNumber like '%" + PoStockStyle + "%' or HName like '%" + PoStockStyle + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_PoStockStyle where HStopflag=0 Order by HItemID ", "Gy_PoStockStyle"); } else { string sql1 = "Select HItemID,HNumber ,HName from Gy_PoStockStyle where HStopflag=0 and HEndFlag=1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_PoStockStyle"); } 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> @@ -1078,12 +1687,110 @@ //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 ( p.HNumber like '%" + sWhere + "%' or p.HName like '%" + sWhere + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ds = oCN.RunProcReturn("Select HItemID,HNumber 工序代码,HName 工序 from Gy_Process where HStopflag=0 " + sWhere + " Order by HItemID ", "Gy_Process"); ds = oCN.RunProcReturn("Select p.HItemID,p.HNumber 工序代码,p.HName 工序,w.HItemID 工作中心ID,w.HNumber 工作中心代码,w.HName 工作中心,d.HItemID 部门ID,d.HNumber 部门代码,d.HName 部门 from Gy_Process p left join Gy_WorkCenter w on p.HWorkCenterID = w.HItemID left join Gy_Department d on p.HDeptID = d.HItemID where p.HStopflag = 0 " + sWhere + " Order by HItemID ", "Gy_Process"); if (ds == null || ds.Tables[0].Rows.Count <= 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 = ds.Tables[0]; return objjson; } } catch (Exception e) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + e.ToString(); objjson.data = null; return objjson; } } /// <summary> /// 获取物料列表 /// <summary> ///参数：string sql。 ///返回值：object。 /// </summary> [Route("Web/GetMaterList_Json")] [HttpGet] public object GetMaterList_Json(string sWhere) { DataSet ds; //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (sWhere != "") { sWhere = " and ( HNumber like '%" + sWhere + "%' or HName like '%" + sWhere + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ds = oCN.RunProcReturn("Select HItemID,HNumber 物料代码,HName 物料,HModel 规格型号 from Gy_Material where HStopflag=0 " + sWhere + " Order by HItemID ", "Gy_Material"); if (ds == null || ds.Tables[0].Rows.Count <= 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 = ds.Tables[0]; return objjson; } } catch (Exception e) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + e.ToString(); objjson.data = null; return objjson; } } /// <summary> /// 获取模具列表 /// <summary> ///参数：string sql。 ///返回值：object。 /// </summary> [Route("Web/GetRelationList_Json")] [HttpGet] public object GetRelationList_Json(string sWhere) { DataSet ds; //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (sWhere != "") { sWhere = " and ( HNumber like '%" + sWhere + "%' or HName like '%" + sWhere + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ds = oCN.RunProcReturn("Select HItemID,HNumber 模具代码,HName 模具,HModel 规格型号 from h_v_Gy_Mould where HStopflag=0 " + sWhere + " Order by HItemID ", "h_v_Gy_Mould"); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; @@ -1481,7 +2188,7 @@ /// <returns></returns> [Route("DeltetGy_BadReason")] [HttpGet] public object DeltetGy_BadReason(string HItemID,string user) public object DeltetGy_BadReason(string HItemID, string user) { DataSet ds; //string ModRightNameCheck = "Sc_ProcessReport_check"; @@ -1940,18 +2647,169 @@ 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")] [HttpPost] public object SaveGetClassTimePrjGroupList(string HNumber,string HName,int HDeptID,string refSav,string user,int HItem) [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)) { @@ -1961,18 +2819,18 @@ objJsonResult.data = null; return objJsonResult; } string sql=""; if (refSav== "Add") string sql = ""; if (refSav == "Add") { sql = "Insert Into Gy_ClassTimePrjGroup " + "(HNumber,HName,HStpoflag,HParentID,HLevel" + ",HEndFlag,HHelpCode,HDeptID,HGroupID,HUserFlag" + ") " + " values('" + HNumber + "','" + HName + "',0,0,0,0,''," + HDeptID + ",'未使用'" + ") "; 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; sql = "UpDate Gy_ClassTimePrjGroup set HNumber='" + HNumber + "',HName='" + HName + "',HDeptID=" + HDeptID + " where HItemID=" + HItemID; } oCN.RunProc(sql); objJsonResult.code = "1"; @@ -2017,6 +2875,124 @@ string sql1 = "Select HItemID,HNumber ,HName from Gy_Post where HStopflag=0 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_Post"); } //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> /// <returns></returns> [Route("Web/GetGy_EquipFileBillMainList_Json")] [HttpGet] public object GetGy_EquipFileBillMainList_Json(string EquipFileBill) { //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (EquipFileBill != "") { sWhere = sWhere + " and ( HEquipFileNumber like '%" + EquipFileBill + "%' or HName like '%" + EquipFileBill + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("Select HInterID,HEquipFileNumber,HName from Gy_EquipFileBillMain where 0=0 Order by HInterID ", "Gy_EquipFileBillMain"); } else { string sql1 = "Select HInterID,HEquipFileNumber,HName from Gy_EquipFileBillMain where 0=0 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_EquipFileBillMain"); } //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> /// <returns></returns> [Route("Web/GetGy_MouldFileMainList_Json")] [HttpGet] public object GetGy_MouldFileMainList_Json(string MouldFileMain) { //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (MouldFileMain != "") { sWhere = sWhere + " and ( HNumber like '%" + MouldFileMain + "%' or HName like '%" + MouldFileMain + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("Select HInterID,HNumber,HName from Gy_MouldFileMain where 0=0 Order by HInterID ", "Gy_MouldFileMain"); } else { string sql1 = "Select HInterID,HNumber,HName from Gy_MouldFileMain where 0=0 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_MouldFileMain"); } //ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo); @@ -2458,7 +3434,7 @@ [HttpGet] public object GetMaintainItemtemByMouldProjectID(int MouldProjectID) { if (MouldProjectID <= 0) { objjson.code = "0"; @@ -2473,7 +3449,7 @@ 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 string sql1 = string.Format(@"select a.HInterID,a.HBillNo,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 @@ -2570,7 +3546,7 @@ { 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"); ds = oCN.RunProcReturn(sql + sWhere, "h_v_Sc_MouldDotCheckRuleBillList"); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; @@ -2598,15 +3574,15 @@ } } /// <summary> /// <summary> /// 根据设备显示设备保养规程项目 /// </summary> /// <returns></returns> [Route("Web/GetMaintainItemtemByEquipProjectID")] [HttpGet] public object GetMaintainItemtemByEquipProjectID(int EquipProjectID) public object GetMaintainItemtemByEquipProjectID(string EquipProjectID) { if (EquipProjectID <= 0) if (EquipProjectID == null) { objjson.code = "0"; objjson.count = 0; @@ -2620,7 +3596,7 @@ 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 string sql1 = string.Format(@"select a.HInterID,a.HBillNo,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 @@ -2676,7 +3652,7 @@ 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 ); 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 @@ -2724,7 +3700,7 @@ { 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 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 @@ -2808,8 +3784,8 @@ return objjson; } } /// <summary> /// 获取维修项目列表 /// </summary> @@ -3034,7 +4010,7 @@ WebS.WebService1 oWebs = new WebS.WebService1(); try { ds = oWebs.GetKf_PonderationBillMain_TempList_New (HBillType, sHMaker, HOrgID); ds = oWebs.GetKf_PonderationBillMain_TempList_New(HBillType, sHMaker, HOrgID); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objJsonResult.code = "0"; @@ -3063,7 +4039,156 @@ } } /// <summary> /// 产品入库缓存列表刷新信息 /// </summary> /// <returns></returns> [Route("Web/chanpinruk1")] [HttpGet] public object chanpinruk1(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) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！"; objJsonResult.data = null; return objJsonResult; } List<object> columnNameList = new List<object>(); //添加列名 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 = 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]; objJsonResult.list = columnNameList; 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 /// <summary> /// 获取流水号列表 /// </summary> /// <param name="HInterID"></param> /// <returns></returns> [Route("Web/GetProcNoList")] [HttpGet] public object GetProcNoList(int HInterID,string sWhere,string UserID) { List<object> columnNameList = new List<object>(); try { ds = oCN.RunProcReturn("exec h_p_Sc_ProcNoList '" + HInterID + "','" + sWhere + "','" + UserID + "'" , "h_p_Sc_ProcNoList"); 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 = e.Message.ToString(); objJsonResult.data = null; objJsonResult.list = columnNameList; } return objJsonResult; } }
