using DAL; using DBUtility; using Model; using Newtonsoft.Json; using Newtonsoft.Json.Converters; using Newtonsoft.Json.Linq; using SQLHelper; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Net; using System.Net.Http; using System.Web.Http; using WebAPI; using WebAPI.Models; using WebAPI.Service; namespace WebAPI.Controllers { public class WebAPIController : ApiController { public string sWhere = ""; public WebServer webserver = new WebServer(); public DataSet ds = new DataSet(); 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(); /// /// 送货单表头信息 /// /// /// [Route("Web/GetMAXNum")] [HttpGet] public object GetMAXNum(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; } } [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; // } //} /// /// 登录 /// /// 用户名 /// 密码 /// 组织 /// [Route("Web/GetUser")] [HttpGet] public object GetUser(string UserName, string PassWord, string HOrgName) { try { DataSet ds = null; ClsCN oCnLoc = new ClsCN(); DAL.ClsUser oUser = new DAL.ClsUser(); ds = oUser.CheckMainID(UserName.Trim(), DBUtility.ClsPub.StrToPsd(PassWord.Trim())); if (ds == null || ds.Tables[0].Rows.Count == 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "密码错误！"; objjson.data = null; 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 e) { objjson.code = "0"; objjson.count = 0; objjson.Message = "登录异常！" + e.Message; objjson.data = null; return objjson; ; } } /// /// 菜单栏 /// /// [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; ; } } /// /// 修改密码 /// /// /// /// [Route("Web/GetXGPassword")] [HttpGet] public object GetXGPassword(string UserName, string oldPassword, string PassWord, string Repassword) { try { ClsCN oCn = new ClsCN(); DataSet oDs = new DataSet(); //========== oDs = oCn.RunProcReturn("select Czmm from Gy_Czygl where Czybm='" + UserName + "'", "Gy_Czygl"); if (PassWord.Trim() != Repassword.Trim()) { objjson.code = "0"; objjson.count = 0; objjson.Message = "2次密码不一致！"; objjson.data = oDs.Tables[0]; return objjson; ; } //=========== if (oDs == null || oDs.Tables[0].Rows.Count == 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "没有这个用户，不能修改密码！"; objjson.data = null; return objjson; ; } else { oCn.RunProc("update Gy_Czygl set Czmm='" + ClsPub.StrToPsd(PassWord.Trim()) + "' where Czybm='" + UserName.Trim() + "'"); objjson.code = "0"; objjson.count = 1; objjson.Message = "* 密码修改成功！"; objjson.data = null; return objjson; ; } } catch (Exception) { objjson.code = "0"; objjson.count = 0; objjson.Message = "修改密码异常！"; objjson.data = null; return objjson; ; } } #region 用户设置 #region 获取用户信息 [Route("Gy_USERSet_PDA/GetGy_Czygl_Info")] [HttpGet] public object GetGy_Czygl_Info(string Czybm, string user) { try { //查看权限 //if (!DBUtility.ClsPub.Security_Log("Gy_ProjectStage_Query", 1, false, user)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "无查看权限！"; // objJsonResult.data = null; // return objJsonResult; //} string sql = @"select Czybm, Czymc, HWhID, HWhName, HSecManagerID, HSecManager, HKeeperID, HKeeper, HDeptID, HDept, HCloudUserName, HCloudUserPsd from Gy_Czygl where Czybm = '" + Czybm + "'"; ds = oCN.RunProcReturn(sql, "Gy_Czygl"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "未找到相关数据！"; objJsonResult.data = null; return objJsonResult; } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 保存用户信息 [Route("Gy_USERSet_PDA/SaveGy_Czygl_Info")] [HttpPost] public object SaveGy_Czygl_Info([FromBody] JObject sMainSub) { try { //获取参数 var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); Int64 HWhID = Int64.Parse(sArray[0].ToString()); string HWhName = sArray[1].ToString(); Int64 HSecManagerID = Int64.Parse(sArray[2].ToString()); string HSecManager = sArray[3].ToString(); Int64 HKeeperID = Int64.Parse(sArray[4].ToString()); string HKeeper = sArray[5].ToString(); Int64 HDeptID = Int64.Parse(sArray[6].ToString()); string HDept = sArray[7].ToString(); string HCloudUserName = sArray[8].ToString().Trim(); string HCloudUserPsd = sArray[9].ToString().Trim(); string Czybm = sArray[10].ToString(); string user = sArray[11].ToString(); //操作用户的用户名 ////判断是否有新增权限 //if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBillQualityStatus_Tmp_Edit", 1, false, user)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "无新增权限!"; // objJsonResult.data = null; // return objJsonResult; //} string sql = "update Gy_Czygl set " + "HWhID = " + HWhID + ", HWhName = '" + HWhName + "', HSecManagerID = " + HSecManagerID + ", HSecManager = '" + HSecManager + "', HKeeperID = " + HKeeperID + ", HKeeper = '" + HKeeper + "', HDeptID = " + HDeptID + ", HDept = '" + HDept + "', HCloudUserName = '" + HCloudUserName + "', HCloudUserPsd = '" + HCloudUserPsd + "' where Czybm = '" + Czybm + "'"; oCN.RunProc(sql); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #endregion //撤销缓存列表记录 [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; } } //删除缓存列表记录 [Route("Web/Delete_Json")] [HttpGet] public object Delete_Json(long sHInterID) { string sErrMsg = string.Empty; try { if (webserver.DeleteBillList(sHInterID, 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; } } //缓存列表刷新 [Route("Web/DisBillEntryList_Mate_Webs_Json")] [HttpGet] public object DisBillEntryList_Webs_Json(string HBillType, string sWhere) { try { ds = webserver.GetKf_PonderationBillMain_TempList(HBillType, sWhere); List columnNameList = new List(); //添加列名 foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 } 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; } } //根据内码返回缓存列表信息 [Route("Web/GetPonderationBill")] [HttpGet] public object GetPonderationBill(long HInterID) { try { ds = webserver.GetPonderationBill(HInterID); 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; } } //根据拖条码返回条码档案表唯一码信息 [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] public object GetHBW(long HBadType) { try { ds = webserver.GetHBW(HBadType); 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; } } //删除表记录 [Route("Web/Delete_Table")] [HttpGet] public object Delete_Table(string sqlStr) { try { //SQLHelper oCn; SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); oCN.RunProc(sqlStr); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "删除成功！"; objJsonResult.data = null; return objJsonResult; } catch (Exception) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "删除失败！异常"; objJsonResult.data = null; return objJsonResult; } } #region 基础资料 /// /// 获取仓库列表 /// /// [Route("Web/GetWarehouseList_Json")] [HttpGet] public object GetWarehouseList_Json(string Warehouse) { sWhere = " Where HStopFlag=0 and HEndFlag=1"; //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 { 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; } } /// /// 获取仓库列表 /// /// [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"; 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; } } /// /// 获取仓位列表 /// /// [Route("Web/GetStockPlaceList_Json")] [HttpGet] public object GetStockPlaceList_Json(string StockPlace, Int64 HWhID) { sWhere = " Where HStopFlag=0 and HEndFlag=1"; //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 ( 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); 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; } } ///// ///// 获取仓位列表 ///// ///// //[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; // } //} /// /// 获取仓位列表 /// /// [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; } } /// /// /扫描仓位二维码带出仓库仓位 /// /// /// /// [Route("Web/GetSpName_Json")] [HttpGet] public object GetSpName_Json(string HBarCode) { string[] sArray = HBarCode.Remove(0, 3).Split(';'); long HSpID = DBUtility.ClsPub.isLong(sArray[1]); var HWHID = DBUtility.ClsPub.isLong(sArray[0]); try { ds = webserver.GetSPInfoByIDandHWHIDandOrg(HSpID, HWHID, 001, 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; } } /// /// 获取供应商列表 /// /// [Route("Web/GetSupplierList_Json")] [HttpGet] public object GetSupplierList_Json(string Supplier, Int64 HOrgID) { sWhere = " Where HStopFlag=0 and HUSEORGID =" + 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 (Supplier != "" && Supplier != null) { sWhere = sWhere + " and ( HNumber like '%" + Supplier + "%' or HName like '%" + Supplier + "%' or HUSEORGID like '%" + HOrgID + "%' ) "; //sWhere = sWhere + " and ( HNumber like '%" + Supplier + "%' or HName like '%" + Supplier + "%' or HUSEORGID like '%" + HOrgID + "%' ) "; } try { string sql = "select HItemID,HNumber,HName from Gy_Supplier " + sWhere; ds = oCN.RunProcReturn(sql, "Gy_Supplier"); //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"; 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; } } /// /// 获取职员列表 /// /// [Route("Web/GetEmployeeList_Json")] [HttpGet] public object GetEmployeeList_Json(string Employee, Int64 HGroupID) { sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (HGroupID == 0) { if (Employee != "") { sWhere = " Where HStopFlag=0 and ( HNumber like '%" + Employee + "%' or HName like '%" + Employee + "%' ) "; } else { sWhere = " Where HStopFlag=0 "; } } else { if (Employee != "") { sWhere = " Where HStopFlag=0 and HWHID=" + HGroupID.ToString() + " and ( HNumber like '%" + Employee + "%' or HName like '%" + Employee + "%' ) "; } else { sWhere = " Where HStopFlag=0 and HWHID=" + HGroupID.ToString(); } } try { 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"; 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; } } /// /// 获取班组列表 ///参数：string sql。 ///返回值：object。 /// [Route("Web/GetProductionTeamList_Json")] [HttpGet] public object GetProductionTeamList_Json(string sWhere) { DataSet ds; try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); 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"; 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; } } /// /// 获取部门列表 /// /// [Route("Web/GetDepartmentList_Json")] [HttpGet] public object GetDepartmentList_Json(string Department) { sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (Department != "") { sWhere = sWhere + " and ( HNumber like '%" + Department + "%' or HName like '%" + Department + "%' ) "; } 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; } } /// /// 获取组织列表 /// /// [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"; 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; } } /// /// 获取物料列表 /// /// [Route("Web/GetMaterialList_Json")] [HttpGet] public object GetMaterialList_Json(string sWhere) { try { ds = webserver.GetMaterialList(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; } } /// /// 获取单位列表 /// /// [Route("Web/GetUnitList_Json")] [HttpGet] public object GetUnitList_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 != "") { 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_Unit where HStopflag=0 Order by HItemID ", "Gy_Unit"); } else { string sql1 = "Select HItemID,HNumber ,HName from Gy_Unit where HStopflag=0 and HEndFlag=1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_Unit"); } //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; } } /// /// 获取计量单位组列表 /// /// [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; } } /// /// 获取销售方式列表 /// /// [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; } } /// /// 获取结算方式列表 /// /// [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; } } /// /// 获取采购方式列表 /// /// [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; } } /// /// 获取客户列表 /// /// [Route("Web/GetCustomerList_Json")] [HttpGet] public object GetCustomerList_Json(string Customer) { sWhere = " Where HStopFlag=0 "; //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (Customer != "") { sWhere = sWhere + " and ( HNumber like '%" + Customer + "%' or HName like '%" + Customer + "%' ) "; } try { ds = webserver.GetCustomerList(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; } } /// /// 获取客户列表 /// /// [Route("Web/GetCustomerList_Json_New1")] [HttpGet] public object GetCustomerList_Json_New1(string sWhere) { try { ds = webserver.GetCustomerList(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; } } /// /// 获取工序列表 /// ///参数：string sql。 ///返回值：object。 /// [Route("Web/GetProcList_Json")] [HttpGet] public object GetProcList_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 ( p.HNumber like '%" + sWhere + "%' or p.HName like '%" + sWhere + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); 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 p.HNumber ", "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; } } /// /// 获取银行列表 /// ///参数：string sql。 ///返回值：object。 /// [Route("Web/GetBankList_Json")] [HttpGet] public object GetBankList_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(); string sql = "select HItemID,HNumber 银行代码,HName 银行名称,HStopflag from Gy_Bank where 1=1 " + sWhere; ds = oCN.RunProcReturn(sql, "Gy_Bank"); 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; } } /// /// 获取物料列表 /// ///参数：string sql。 ///返回值：object。 /// [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; } } /// /// 获取模具列表 /// ///参数：string sql。 ///返回值：object。 /// [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"; 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; } } /// /// 获取当前数据库名 /// /// [Route("Web/GetDataBases")] [HttpGet] public object GetDataBases() { try { ClsCN oCn = new ClsCN(); DataSet oDs = new DataSet(); //========== oDs = oCn.RunProcReturn("Select Name From Master..SysDataBases Where DbId=(Select Dbid From Master..SysProcesses Where Spid = @@spid)", "SysDataBases"); objjson.code = "1"; objjson.count = 1; objjson.Message = "获取成功！"; objjson.data = oDs.Tables[0]; return objjson; ; } catch (Exception e) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败！异常" + e.ToString(); objjson.data = null; 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 不良原因设置列表/保存/编辑/删除方法 /// /// 获取不良原因列表 /// /// [Route("Web/GetBadReasonList_Json")] [HttpGet] public object GetBadReasonList_Json(string BadReason) { //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); 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_BadReason where HStopflag=0 Order by HItemID ", "Gy_BadReason"); } else { string sql1 = "Select HItemID,HNumber ,HName from Gy_BadReason where HStopflag=0 and HEndFlag=1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_BadReason"); } //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; } } /// /// 保存不良原因 /// /// /// [Route("SaveGy_BadReasonList")] [HttpPost] public object SaveGy_BadReasonList([FromBody] JObject msg) { DataSet ds; var _value = msg["msg"].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值赋值 DataSet Maxds = oCN.RunProcReturn("select MAX(HItemID) HItemID from Gy_BadReason ", "Gy_BadReason"); if (Maxds != null || Maxds.Tables[0].Rows.Count > 0) { //HItemID= Maxds.Tables[0].Rows[0]["HItemID"] var maxid = Convert.ToInt32(Maxds.Tables[0].Rows[0]["HItemID"]); maxid += 1; HItemID = maxid; } ListModels oListModels = new ListModels(); try { WebAPI.DLL.ClsGy_BadReason_Ctl oBill = new WebAPI.DLL.ClsGy_BadReason_Ctl(); List lsmain = new List(); msg1 = msg1.Replace("\\", ""); msg1 = msg1.Replace("\n", ""); //\n lsmain = oListModels.getObjectByJson_Gy_BadReason(msg1); foreach (Model.ClsGy_BadReason_Model oItem in lsmain) { if (oItem.HNumber.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！代码不能为空！"; objJsonResult.data = 1; return objJsonResult; } if (oItem.HName.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！名称不能为空！"; objJsonResult.data = 1; return objJsonResult; } if (!DBUtility.ClsPub.AllowNumber(oItem.HNumber.Trim())) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！代码中不能出现连续‘.’并且首位末位不能为‘.’！"; objJsonResult.data = 1; return objJsonResult; } //查询数据中是否存在重复代码 ds = oCN.RunProcReturn("select * from Gy_BadReason where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Gy_BadReason"); if (oItem.HNumber.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！代码为空！"; objJsonResult.data = 1; return objJsonResult; } //新增时判断 if (oItem.HItemID == 0) { if (ds == null || ds.Tables[0].Rows.Count == 0) { } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！代码重复！"; objJsonResult.data = 1; return objJsonResult; } //检查父级是否存在 string sParent; sParent = DBUtility.ClsPub.GetParentCode(oItem.HNumber.Trim()); if (sParent.Trim() == "") { oBill.oModel.HParentID = 0; } else { if (oBill.HavParentCode(sParent.Trim(), HItemID)) { oBill.oModel.HParentID = oBill.oModel.HItemID; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！上级代码不存在或被禁用！"; objJsonResult.data = 1; return objJsonResult; } } } else//编辑时判断 { //检查父级是否存在 string sParent; sParent = DBUtility.ClsPub.GetParentCode(oItem.HNumber.Trim()); if (sParent.Trim() == "") { oBill.oModel.HParentID = 0; } else { if (oBill.HavParentCode(sParent.Trim(), oItem.HItemID)) { oBill.oModel.HParentID = oBill.oModel.HItemID; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！上级代码不存在或被禁用！"; objJsonResult.data = 1; return objJsonResult; } } } //得到短代码 string sShortNumber; sShortNumber = DBUtility.ClsPub.GetShortNumber(oItem.HNumber.Trim()); if (sShortNumber.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！短代码为空！"; objJsonResult.data = 1; return objJsonResult; } oItem.HShortNumber = sShortNumber;//短代码 oItem.HEndFlag = true;//末级标志 oItem.HLevel = DBUtility.ClsPub.GetLevel(oItem.HNumber.Trim()); //等级 oBill.oModel = oItem; } //保存 //保存完毕后处理 bool bResult; if (oBill.oModel.HItemID == 0) { // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); bResult = oBill.AddNew(); } else { bResult = oBill.ModifyByID(oBill.oModel.HItemID); } if (bResult) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "保存成功！"; //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单"); objJsonResult.data = 1; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = 1; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！" + e.ToString(); objJsonResult.data = 1; return objJsonResult; } } /// /// 保存不良类型 /// /// /// [Route("SaveGy_BadType")] [HttpPost] public object SaveGy_BadType([FromBody] JObject msg) { DataSet ds; var _value = msg["msg"].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_BadType_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值赋值 DataSet Maxds = oCN.RunProcReturn("select MAX(HItemID) HItemID from Gy_BadType ", "Gy_BadType"); if (Maxds != null || Maxds.Tables[0].Rows.Count > 0) { //HItemID= Maxds.Tables[0].Rows[0]["HItemID"] var maxid = Convert.ToInt32(Maxds.Tables[0].Rows[0]["HItemID"]); maxid += 1; HItemID = maxid; } ListModels oListModels = new ListModels(); try { DAL.ClsGy_BadType_Ctl oBill = new DAL.ClsGy_BadType_Ctl(); List lsmain = new List(); msg1 = msg1.Replace("\\", ""); msg1 = msg1.Replace("\n", ""); //\n lsmain = oListModels.getObjectByJson_Gy_BadType(msg1); foreach (Model.ClsGy_BadType_Model oItem in lsmain) { if (oItem.HNumber.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！代码不能为空！"; objJsonResult.data = 1; return objJsonResult; } if (oItem.HName.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！名称不能为空！"; objJsonResult.data = 1; return objJsonResult; } if (!DBUtility.ClsPub.AllowNumber(oItem.HNumber.Trim())) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！代码中不能出现连续‘.’并且首位末位不能为‘.’！"; objJsonResult.data = 1; return objJsonResult; } //查询数据中是否存在重复代码 ds = oCN.RunProcReturn("select * from Gy_BadType where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Gy_BadType"); if (oItem.HNumber.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！代码为空！"; objJsonResult.data = 1; return objJsonResult; } //新增时判断 if (oItem.HItemID == 0) { if (ds == null || ds.Tables[0].Rows.Count == 0) { } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！代码重复！"; objJsonResult.data = 1; return objJsonResult; } //检查父级是否存在 string sParent; sParent = DBUtility.ClsPub.GetParentCode(oItem.HNumber.Trim()); if (sParent.Trim() == "") { oBill.oModel.HParentID = 0; } else { if (oBill.HavParentCode(sParent.Trim(), HItemID)) { oBill.oModel.HParentID = oBill.oModel.HItemID; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！上级代码不存在或被禁用！"; objJsonResult.data = 1; return objJsonResult; } } } else//编辑时判断 { //检查父级是否存在 string sParent; sParent = DBUtility.ClsPub.GetParentCode(oItem.HNumber.Trim()); if (sParent.Trim() == "") { oBill.oModel.HParentID = 0; } else { if (oBill.HavParentCode(sParent.Trim(), oItem.HItemID)) { oBill.oModel.HParentID = oBill.oModel.HItemID; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！上级代码不存在或被禁用！"; objJsonResult.data = 1; return objJsonResult; } } } //得到短代码 string sShortNumber; sShortNumber = DBUtility.ClsPub.GetShortNumber(oItem.HNumber.Trim()); if (sShortNumber.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！短代码为空！"; objJsonResult.data = 1; return objJsonResult; } oItem.HShortNumber = sShortNumber;//短代码 oItem.HEndFlag = true;//末级标志 oItem.HLevel = DBUtility.ClsPub.GetLevel(oItem.HNumber.Trim()); //等级 oBill.oModel = oItem; } //保存 //保存完毕后处理 bool bResult; if (oBill.oModel.HItemID == 0) { // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); bResult = oBill.AddNew(); } else { bResult = oBill.ModifyByID(oBill.oModel.HItemID); } if (bResult) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "保存成功！"; //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单"); objJsonResult.data = 1; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = 1; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！" + e.ToString(); objJsonResult.data = 1; return objJsonResult; } } /// /// 不良类型获取信息 /// /// [Route("GetGy_BadTypeDetail")] [HttpGet] public ApiResult GetGy_BadTypeDetail(string HID) { var dataSet = oCN.RunProcReturn("select top 1 * from h_v_gy_BadTypeList where HItemID= " + HID + " ", "h_v_gy_BadTypeList"); if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) return new ApiResult { code = -1, msg = "不存在不良类型数据" }; return new ApiResult { code = 1, msg = "查询成功", data = dataSet }; } /// /// 不良类型删除功能 /// /// [Route("DeltetGy_BadType")] [HttpGet] public object DeltetGy_BadType(string HItemID, string user) { DataSet ds; //string ModRightNameCheck = "Sc_ProcessReport_check"; try { //删除权限 if (!DBUtility.ClsPub.Security_Log("Gy_BadType_Drop", 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)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HItemID为空！"; objJsonResult.data = null; return objJsonResult; } oCN.BeginTran();//开始事务 ds = oCN.RunProcReturn("select * from Gy_BadType where HItemID=" + HItemID, "Gy_BadType"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有数据，无法删除！"; objJsonResult.data = null; return objJsonResult; ; } //var HStopflag = Convert.ToBoolean(ds.Tables[0].Rows[0]["HStopflag"]); //if (HStopflag) //{ // oCN.RollBack();//回滚事务 // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "数据已删除无法再次删除！"; // objJsonResult.data = null; // return objJsonResult; //} oCN.RunProc("delete Gy_BadType where HItemID=" + HItemID); 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; } } /// /// 不良原因获取信息 /// /// [Route("GetGy_BadReasonDetail")] [HttpGet] public ApiResult GetGy_BadReasonDetail(string HID) { var model = LuBaoSevice.GetGy_BadReasonBillDetail(HID); return model; } /// /// 不良原因删除功能 /// /// [Route("DeltetGy_BadReason")] [HttpGet] public object DeltetGy_BadReason(string HItemID, string user) { DataSet ds; //string ModRightNameCheck = "Sc_ProcessReport_check"; try { //删除权限 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)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HItemID为空！"; objJsonResult.data = null; return objJsonResult; } oCN.BeginTran();//开始事务 ds = oCN.RunProcReturn("select * from Gy_BadReason where HItemID=" + HItemID, "Gy_BadReason"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有数据，无法删除！"; objJsonResult.data = null; return objJsonResult; ; } //var HStopflag = Convert.ToBoolean(ds.Tables[0].Rows[0]["HStopflag"]); //if (HStopflag) //{ // oCN.RollBack();//回滚事务 // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "数据已删除无法再次删除！"; // objJsonResult.data = null; // return objJsonResult; //} oCN.RunProc("delete Gy_BadReason where HItemID=" + HItemID); 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 /// /// 报废原因 /// /// [Route("Web/GetScrapReasonList_Json")] [HttpGet] public object GetScrapReasonList_Json(string BadReason) { //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (BadReason != "" && BadReason != null) { 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_ScrapReason where HStopflag=0 Order by HItemID ", "Gy_ScrapReason"); } else { string sql1 = "Select HItemID,HNumber ,HName from Gy_ScrapReason where HStopflag=0 and HEndFlag=1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_ScrapReason"); } //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; } } /// /// 获取工序计划单列表 /// /// [Route("Web/GetPlanList_Json")] [HttpGet] public object GetPlanList_Json(string Billno) { //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (Billno != "") { sWhere = sWhere + " and ( 单据号 like '%" + Billno + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select hmainid,hsubid,单据号,HMaterID,物料代码,物料名称,HCenterID,工作中心,规格型号,计划数量 from h_v_Sc_ProcessPlanList", "h_v_Sc_ProcessPlanList"); } else { string sql1 = "select hmainid,hsubid,单据号,HMaterID,物料代码,物料名称,HCenterID,工作中心,规格型号,计划数量 from h_v_Sc_ProcessPlanList where 1=1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "h_v_Sc_ProcessPlanList"); } //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; } } /// /// 获取登录页组织列 /// /// [Route("Web/GetOrganizations")] [HttpGet] public object GetOrganizations() { try { ClsCN oCn = new ClsCN(); DataSet oDs = new DataSet(); //========== oDs = oCn.RunProcReturn("select HItemID ID,Hname Name,HStopflag Stopflag from Xt_ORGANIZATIONS", "Xt_ORGANIZATIONS"); objjson.code = "1"; objjson.count = 1; objjson.Message = "获取成功！"; objjson.data = oDs.Tables[0]; return objjson; ; } catch (Exception e) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败！异常" + e.ToString(); objjson.data = null; return objjson; ; } } #endregion /// /// 获取职务列表 /// /// [Route("Web/GetDutyList_Json")] [HttpGet] public object GetDutyList_Json(string Duty) { //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (Duty != "") { sWhere = sWhere + " and ( HNumber like '%" + Duty + "%' or HName like '%" + Duty + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_Duty where HStopflag=0 Order by HItemID ", "Gy_Duty"); } else { string sql1 = "Select HItemID,HNumber ,HName from Gy_Duty where HStopflag=0 and HEndFlag=1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_Duty"); } //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; } } /// /// 获取宿舍列表 /// /// [Route("Web/GetDormList_Json")] [HttpGet] public object GetDormList_Json(string Dorm) { //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (Dorm != "") { sWhere = sWhere + " and ( HNumber like '%" + Dorm + "%' or HName like '%" + Dorm + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_Dorm where HStopflag=0 Order by HItemID ", "Gy_Dorm"); } else { string sql1 = "Select HItemID,HNumber ,HName from Gy_Dorm where HStopflag=0 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_Dorm"); } //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; } } /// /// 获取工种列表 /// /// [Route("Web/GetWorkTypeList_Json")] [HttpGet] public object GetWorkTypeList_Json(string WorkType) { //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (WorkType != "") { sWhere = sWhere + " and ( HNumber like '%" + WorkType + "%' or HName like '%" + WorkType + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_WorkType where HStopflag=0 Order by HItemID ", "Gy_WorkType"); } else { string sql1 = "Select HItemID,HNumber ,HName from Gy_WorkType where HStopflag=0 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_WorkType"); } //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; } } /// /// 获取核算方式组列表 /// /// [Route("Web/GetClassTimePrjGroupList_Json")] [HttpGet] public object GetClassTimePrjGroupList_Json(string ClassTimePrjGroup) { //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (ClassTimePrjGroup != "") { sWhere = sWhere + " and ( HNumber like '%" + ClassTimePrjGroup + "%' or HName like '%" + ClassTimePrjGroup + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_ClassTimePrjGroup where HStopflag=0 Order by HItemID ", "Gy_ClassTimePrjGroup"); } else { string sql1 = "Select HItemID,HNumber ,HName from Gy_ClassTimePrjGroup where HStopflag=0 "; string sql = sql1 + 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; } } [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.部门代码,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; } } /// /// 核算方式组编辑 /// /// /// /// [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 删除核算方式组 /// /// 核算方式列表删除按钮 ///参数：string sql。 ///返回值：object。 /// [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 /// /// 保存获取核算方式组 /// /// /// [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; } } /// /// 获取岗位列表 /// /// [Route("Web/GetGy_PostList_Json")] [HttpGet] public object GetGy_PostList_Json(string ParamPost) { //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (ParamPost != "") { sWhere = sWhere + " and ( HNumber like '%" + ParamPost + "%' or HName like '%" + ParamPost + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_Post where HStopflag=0 Order by HItemID ", "Gy_Post"); } else { 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; } } /// /// 获取设备主档列表 /// /// [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; } } /// /// 获取器具列表 /// /// [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); 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; } } /// /// 获取点检项目列表 /// /// [Route("Web/GetCheckItemList_Json")] [HttpGet] public object GetCheckItemList_Json(string CheckItem) { DataSet ds; try { 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) { 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 { ds = oCN.RunProcReturn("Select HItemID,HNumber,HName from Gy_DotCheck " + sWhere + " Order by HItemID ", "Gy_DotCheck"); } 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; } } /// /// 获取生产任务单列表 /// /// [Route("Web/GetSc_ICMOBillListView")] [HttpGet] public object GetSc_ICMOBillListView(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("")) { ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where 1=1 and isnull(审核人,'')<>'' and isnull(关闭人,'')='' and isnull(行关闭人,'')='' order by 单据号 desc,hsubid ", "h_v_IF_ICMOBillList"); } else { 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) { 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; } } /// /// 获取生产任务单列表 /// /// [Route("Web/GetSc_ICMOBillListView2")] [HttpGet] public object GetSc_ICMOBillListView2(int page, int limit, string ICMOBill, int OrganizationID) { try { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); int count = 0; int pageNum = page; int pageSize = limit; string sWhere = ""; if (ICMOBill == null || ICMOBill.Equals("")) { sWhere = " where 1=1"; } else { sWhere = " where 1=1 and 单据号 like '%" + ICMOBill + "%'"; } 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) { objJsonResult.code = "1"; objJsonResult.count = count; objJsonResult.Message = "返回记录成功！"; objJsonResult.data = JsonConvert.DeserializeObject(JsonConvert.SerializeObject(ds.Tables[0], new IsoDateTimeConverter { DateTimeFormat = "yyyy-MM-dd HH:mm:ss" })); //序列化DataSet中的时间格式，然后再反序列化回来 return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "暂无记录！"; objJsonResult.data = null; return objJsonResult; } } catch (Exception ex) { 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; //} } /// /// 获取当前生产资源下已经开工的生产任务单列表 /// /// [Route("Web/GetSc_ICMOBillListView3")] [HttpGet] public object GetSc_ICMOBillListView3(string ICMOBill, int OrganizationID,int HSourceID) { if (ICMOBill != "") { sWhere = " where 1=1 and (单据号 like '%" + ICMOBill + "%' or 产品代码 like '%" + ICMOBill + "%' or 产品名称 like '%" + ICMOBill + "%' or 规格型号 like '%" + ICMOBill + "%' )"; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where 1=1 and isnull(审核人,'')<>'' and isnull(关闭人,'')='' and isnull(行关闭人,'')='' and 状态 = '开工' and HSourceID_b = " + HSourceID + " order by 单据号,hsubid ", "h_v_IF_ICMOBillList"); } else { string sql = "select * from h_v_IF_ICMOBillList " + sWhere + " and isnull(审核人,'')<>'' and isnull(关闭人,'')='' and isnull(行关闭人,'')='' " + "and 状态 = '开工' and HSourceID_b = " + HSourceID + " order by 单据号,hsubid "; ds = oCN.RunProcReturn(sql, "h_v_IF_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; } } /// /// 获取工序流转卡列表 /// /// [Route("Web/GetSc_ProcessExchangeBillListView")] [HttpGet] public object GetSc_ProcessExchangeBillListView(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("")) { ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillList where 1=1 order by 单据号 desc,hsubid ", "h_v_Sc_ProcessExchangeBillList"); } else { string sql = "select * from h_v_Sc_ProcessExchangeBillList " + sWhere + " order by 单据号 desc,hsubid "; ds = oCN.RunProcReturn(sql, "h_v_Sc_ProcessExchangeBillList"); } 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; } } /// /// 获取检验项目列表 /// /// [Route("Web/GetGy_QCCheckItem")] [HttpGet] public object GetGy_QCCheckItem(string CheckItem, int OrganizationID) { if (CheckItem != "") { sWhere = " and ( HNumber like '%" + CheckItem + "%' or HName like '%" + CheckItem + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("Select HItemID,HNumber 代码,HName 名称 ,HQCCheckClassID 检验项目类别 from Gy_QCCheckItem where HStopflag=0 Order by HItemID ", "Gy_QCCheckItem"); } else { string sql = "Select HItemID,HNumber 代码,HName 名称 ,HQCCheckClassID 检验项目类别 from Gy_QCCheckItem where HStopflag=0 " + sWhere + "Order by HItemID "; ds = oCN.RunProcReturn(sql, "Gy_QCCheckItem"); } 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; } } /// /// 获取检验方案列表 /// /// [Route("Web/GetGy_QCCheckProject")] [HttpGet] public object GetGy_QCCheckProject(string CheckProject, int OrganizationID) { if (CheckProject != "") { sWhere = " and ( HBillNo like '%" + CheckProject + "%' or HName like '%" + CheckProject + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql = "Select HinterID HItemID,HBillNo 检验方案代码,HName 方案名称 from Gy_QCCheckProjectMain where 1 = 1 " + sWhere + "Order by HinterID "; ds = oCN.RunProcReturn(sql, "Gy_QCCheckProjectMain"); 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; } } /// /// 获取抽样方案列表 /// /// [Route("Web/GetGy_SampleScheme")] [HttpGet] public object GetSampleScheme(string SampleScheme, int OrganizationID) { if (SampleScheme != "") { sWhere = " and ( 抽样方案代码 like '%" + SampleScheme + "%' or 抽样方案名称 like '%" + SampleScheme + "%' ) "; } try { List columnNameList = new List(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql = "Select * from h_v_Gy_GetSampleSchemeListView where 1 = 1 " + sWhere + "Order by hmainid "; ds = oCN.RunProcReturn(sql, "h_v_Gy_GetSampleSchemeListView"); //添加列名 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) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ",没有查询到数据"; objjson.data = null; return objjson; } else { objjson.code = "1"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; objjson.list = columnNameList; return objjson; } } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// /// 获取检验值列表 /// /// [Route("Web/GetGy_InspectValue")] [HttpGet] public object GetInspectValue(string InspectValue, int OrganizationID) { if (InspectValue != "") { sWhere = " and ( 检验值代码 like '%" + InspectValue + "%' or 检验值名称 like '%" + InspectValue + "%' ) "; } try { List columnNameList = new List(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql = "Select * from h_v_Gy_GetInspectValueList where 1 = 1 " + sWhere + "Order by hmainid "; ds = oCN.RunProcReturn(sql, "h_v_Gy_GetInspectValueList"); //添加列名 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) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ",没有查询到数据"; objjson.data = null; return objjson; } else { objjson.code = "1"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; objjson.list = columnNameList; return objjson; } } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// /// 获取检仪器列表 /// /// [Route("Web/GetGy_InspectInstruMent")] [HttpGet] public object GetGy_InspectInstruMent(string InspectInstruMent, int OrganizationID) { if (InspectInstruMent != "") { sWhere = " and ( 检验仪器代码 like '%" + InspectInstruMent + "%' or 检验仪器名称 like '%" + InspectInstruMent + "%' ) "; } try { List columnNameList = new List(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql = "Select * from h_v_Gy_InspectInstruMent where 1 = 1 " + sWhere + "Order by HItemID "; ds = oCN.RunProcReturn(sql, "h_v_Gy_InspectInstruMent"); //添加列名 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) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ",没有查询到数据"; objjson.data = null; return objjson; } else { objjson.code = "1"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; objjson.list = columnNameList; return objjson; } } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// /// 根据检验方案主内码获取检验项目 /// /// [Route("Web/GetCheckItemByCheckProjectID")] [HttpGet] public object GetCheckItemByCheckProjectID(int CheckProjectID,int HBatchQty) { if (CheckProjectID <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "检验方案未选择"; objjson.data = null; return objjson; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql = "exec h_p_Gy_GetQCCheckItemByProject " + CheckProjectID + "," + HBatchQty; ds = oCN.RunProcReturn(sql, "h_p_Gy_GetQCCheckItemByProject"); 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; } } /// /// 根据器具主内码获取器具保养检验项目 /// /// [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 list = new List(); DataSet ds2; DataSet ds1; 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 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; } } /// /// 根据器具主内码获取器具保养检验项目 /// /// [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 list = new List(); 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; } } /// /// 器具点检规程单列表 /// /// [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; } } /// /// 根据设备显示设备保养规程项目 /// /// [Route("Web/GetMaintainItemtemByEquipProjectID")] [HttpGet] public object GetMaintainItemtemByEquipProjectID(string EquipProjectID) { if (EquipProjectID == null) { objjson.code = "0"; objjson.count = 0; objjson.Message = "产品器具未选择"; objjson.data = null; return objjson; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); List list = new List(); DataSet ds2; DataSet ds1; 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 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; } } /// /// 根据设备保养规程显示设备保养规程项目 /// /// [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 list = new List(); 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; } } /// /// 根据设备显示设备点检程项目 /// /// [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; } } /// /// 根据设备带出项目 /// /// [Route("Web/GetItemByEquipFile")] [HttpGet] public object GetItemByEquipFile(int EquipProjectID,string Type) { if (EquipProjectID <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "产品器具未选择"; objjson.data = null; return objjson; } try { string HView = ""; switch (Type) { case "DJ": HView = "h_v_Sb_GetDotCheckItemList"; break; case "BY": HView = "h_v_Sb_GetMaintainItemList"; break; default: objjson.code = "0"; objjson.count = 0; objjson.Message = "设备模块类型错误！"; objjson.data = null; return objjson; } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql = string.Format(@"select * from " + HView + " where HInterID = " + EquipProjectID); ds = oCN.RunProcReturn(sql, HView); 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; } } /// /// 查询各类设备单据列表（设备点检，设备维修，设备保养......） /// /// [Route("Web/GetEquipmentBillsList")] [HttpGet] public object GetEquipmentBillsList(string sWhere, string Type) { try { List columnNameList = new List(); string HView = ""; switch (Type) { case "DJ": HView = "h_v_Sb_EquipDotCheckBillList"; break; case "BY": HView = "h_v_Sb_EquipMaintainBillList"; break; case "WX": HView = "h_v_Sb_EquipRepairCheckBillList"; break; case "GZ": HView = "h_v_Sb_EquipConkBookBillList"; break; case "YS": HView = "h_v_Sb_EquipRepairCheckBillList"; break; default: objjson.code = "0"; objjson.count = 0; objjson.Message = "设备模块类型错误！"; objjson.data = null; return objjson; } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql = string.Format(@"select * from " + HView + " where 1 = 1 " + sWhere); ds = oCN.RunProcReturn(sql, HView); //添加列名 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) { objjson.code = "1"; objjson.count = 1; objjson.Message = "获取失败,查无数据"; objjson.data = null; objjson.list = columnNameList; return objjson; } else { objjson.code = "1"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; objjson.list = columnNameList; return objjson; } } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// /// 根据设备点检规程显示设备点检程项目 /// /// [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; } } /// /// 获取维修项目列表 /// /// [Route("Web/GetRepairList_Json")] [HttpGet] public object GetRepairList_Json(string Repair) { if (Repair != "") { sWhere = " and ( HNumber like '%" + Repair + "%' or HName like '%" + Repair + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_Repair where HStopflag=0 Order by HItemID ", "Gy_Repair"); } else { string sql1 = "Select HItemID,HNumber ,HName from Gy_Repair where HStopflag=0 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_Repair"); } 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; } } /// /// 获取扫码详情列表 /// /// [Route("Web/GetWMSBarCodeDetailsList")] [HttpGet] public object GetWMSBarCodeDetailsList(int HInterID, string HBillType) { try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ds = oCN.RunProcReturn("Select * from h_v_KF_PonderationBillMain_Temp_Sum where HInterID=" + HInterID + " and HBillType='" + HBillType + "' Order by HItemID ", "h_v_KF_PonderationBillMain_Temp_Sum"); //ds = oCN.RunProcReturn("Select top 10 * from h_v_KF_PonderationBillMain_Temp_Sum Order by HInterID ", "h_v_KF_PonderationBillMain_Temp_Sum"); 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; } } /// /// 根据ID删除缓存表中扫码记录 /// /// 缓存表ID /// object [Route("Web/DelCacheList")] [HttpGet] public object DelCacheList(long sHitemID) { try { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); oCn.RunProc("Delete from KF_PonderationBillMain_Temp where HitemID = " + sHitemID); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "删除成功！"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "删除失败！"; objJsonResult.data = e.ToString(); return objJsonResult; } } #region [从数据库加载菜单] public class MenuLoad { //public int HitemID { get; set; } public string HitemID { get; set; } //public int? HPartentID { get; set; } public string HPartentID { get; set; } public string HNumber { get; set; } public string HName { get; set; } public int HLevel { get; set; } public string Hurl { get; set; } public string HPicNum { get; set; } public List childMenus { get; set; } } [Route("Web/MenuList")] [HttpGet] public object MenuList(string HMakeName, string HType) { try { List mu = new List(); //以父子级结构存放菜单清单信息 SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //数据库操作工具 string sql = "select HItemID,HPartentID,HNumber,HName,HLevel,Hurl,HType,HPicNum from Gy_MenuDefineSet where HMakeName = '" + HMakeName + "' and HType = '" + HType + "' order by HPosition"; ds = oCn.RunProcReturn(sql, "Gy_MenuDefineSet"); //查询当前用户的自定义菜单数据 if (ds.Tables[0]==null || ds.Tables[0].Rows.Count == 0) //判断当前用户是否有设置过自定义信息，若记录数为0，则没有设置过，加载所有的菜单信息 { sql = "Select * from Gy_Menu_1 where HType = '" + HType + "' Order by HPosition "; ds = oCn.RunProcReturn(sql, "Gy_Menu"); } for (int i = 0; i < ds.Tables[0].Rows.Count; i++) //将菜单的根节点保存到列表menu中 { if (ds.Tables[0].Rows[i]["HPartentID"].ToString() == "0" || ds.Tables[0].Rows[i]["HitemID"].ToString() == ds.Tables[0].Rows[i]["HPartentID"].ToString()) //判断是否最外层根节点 { MenuLoad tbj = new MenuLoad(); 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(); if (ds.Tables[0].Rows[i]["HPicNum"] != null) { tbj.HPicNum = ds.Tables[0].Rows[i]["HPicNum"].ToString(); } mu.Add(tbj); } } diguiLoad(ds.Tables[0], mu); //使用递归，将需要加载的数据以父子级的结构存放在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; } } public void diguiLoad(DataTable dt, List tree) { for (int m = 0; m < tree.Count; m++) { tree[m].childMenus = new List(); for (int i = 0; i < dt.Rows.Count; i++)//第一次循环，得到所有根节点的子集 { if (tree[m].HitemID.ToString() == dt.Rows[i]["HPartentID"].ToString() && dt.Rows[i]["HitemID"].ToString() != dt.Rows[i]["HPartentID"].ToString()) { MenuLoad tbjson = new MenuLoad(); tbjson.HitemID = dt.Rows[i]["HitemID"].ToString(); tbjson.HPartentID = dt.Rows[i]["HPartentID"].ToString(); tbjson.HNumber = dt.Rows[i]["HNumber"].ToString(); tbjson.HName = dt.Rows[i]["HName"].ToString(); tbjson.HLevel = tree[m].HLevel; tbjson.Hurl = dt.Rows[i]["Hurl"].ToString(); if (dt.Rows[i]["HPicNum"] != null) { tbjson.HPicNum = dt.Rows[i]["HPicNum"].ToString(); } tree[m].childMenus.Add(tbjson); } } for (int i = 0; i < tree[m].childMenus.Count; i++) { diguiLoad(dt, tree[m].childMenus);//再次用子集去循环，拿出子集的子集 } } } #endregion #region [菜单目录自定义] #region 读取自定义数据 //对应Gy_Menu_1表中的记录，记录菜单清单，以及菜单中哪些被选中 public class MenuInit { public string HitemID; public string HPartentID; public string HNumber; public string HName; public int HLevel; public string Hurl; public string HType; public bool HSelected; } //获取树状的自定义数据，类中的每个属性都是layui中树组件的渲染参数option的data属性值的参数 public class MenuDefineList { public string title { get; set; } public string id { get; set; } public string field { get; set; } public List children { get; set; } public bool spread { get; set; } public bool selected { get; set; } } //在自定义菜单界面，获取自定义菜单信息时，通过该类对象返回 public class MenuDefineResult { public List dt; //记录Gy_Menu_1中的菜单清单，以及是否被选中 public List tree; //根节点列表，在前端经过递归获取所有节点以及各节点是否选中 } //自定义菜单：获取树组件数据 [Route("Web/MenuDefineSet")] [HttpGet] public object MenuDefineSet(string HMakeName, string HType) { try { //获取构建树状结构的数据 List menuInitList = new List(); //用以获取Gy_Menu_1中的所有菜单信息，以及对应节点是否被选中需要加载显示 SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); ds = oCn.RunProcReturn("Select * from Gy_Menu_1 where HType = '" +HType + "' Order by HItemID ", "Gy_Menu"); //获取Gy_Menu_1中的所有菜单信息，用于为menuInitList列表充实数据 DataSet ds1 = new DataSet(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) //将Gy_Menu_1中的菜单信息及选中情况保存到menuInitList列表中， { //填充基本数据 MenuInit menuInit = new MenuInit(); menuInit.HitemID = ds.Tables[0].Rows[i]["HItemID"].ToString(); menuInit.HPartentID = ds.Tables[0].Rows[i]["HPartentID"].ToString(); menuInit.HNumber = ds.Tables[0].Rows[i]["HNumber"].ToString(); menuInit.HName = ds.Tables[0].Rows[i]["HName"].ToString(); menuInit.HLevel = int.Parse(ds.Tables[0].Rows[i]["HLevel"].ToString()); menuInit.Hurl = ds.Tables[0].Rows[i]["Hurl"].ToString(); menuInit.HType = ds.Tables[0].Rows[i]["HType"].ToString(); menuInit.HSelected = false; //判断用户是否选中显示该菜单 String sql = "Select * from Gy_MenuDefineSet where HItemID = '" + ds.Tables[0].Rows[i]["HItemID"] + "' and HMakeName='" + HMakeName + "'"; ds1 = oCn.RunProcReturn(sql, "Gy_MenuDefineSet"); if (ds1.Tables[0].Rows.Count > 0) //对于Gy_Menu_1表中的菜单节点，通过检索在Gy_MenuDefineSet表中对应用户是否存在该节点的信息，判断该用户是否选中该节点需要加载显示在侧菜单栏 { menuInit.HSelected = true; } menuInitList.Add(menuInit); //将Gy_Menu_1表中的菜单节点信息逐一添加到menuInitList列表中 } //存储树状结构的数据 List tree = new List(); //用以获取菜单清单在layui中树组件渲染参数option中data值值的参数 for (int i = 0; i < menuInitList.Count; i++) //获取菜单清单中的根节点的渲染数据 { if (menuInitList[i].HPartentID == "0" || menuInitList[i].HitemID == menuInitList[i].HPartentID) //判断是否是根节点 { MenuDefineList define = new MenuDefineList(); define.id = menuInitList[i].HitemID; define.field = menuInitList[i].HitemID; define.title = menuInitList[i].HName; define.spread = false; define.selected = false; if (menuInitList[i].HSelected == true) { define.selected = true; } tree.Add(define); } } MenuDefineResult res = new MenuDefineResult(); res.dt = menuInitList; res.tree = tree; objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "查询成功！"; objJsonResult.data = res; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "查询失败！"; objJsonResult.data = e.ToString(); return objJsonResult; } } #endregion #region 保存自定义数据 //用户接收前端传递的值：对于前端传递的被选中节点的数据，只需要各节点的id和title属性值，对于类SaveDefineMenu的HItemID、HName属性 public class SaveDefineMenu { public string HItemID; public string HName; } //获取自定义菜单数据 [Route("Web/SaveMenuDefineSet")] [HttpPost] public object SaveMenuDefineSet([FromBody] JObject sMainSub) { try { //获取传参的自定义数据 var _value = sMainSub["sMainSub"].ToString(); string msg = _value.ToString(); string[] sArray = msg.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string HMakeName = sArray[1].ToString(); string saveData = sArray[0].ToString(); string HTypes = sArray[2].ToString(); List saveDataList = Newtonsoft.Json.JsonConvert.DeserializeObject>(saveData); //声明数据库操作工具 SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //设置数据库操作的回滚点，若在提交前报错，则回滚到该点，期间操作取消 oCN.BeginTran(); //删除当前用户的自定义数据 string sql = "delete from Gy_MenuDefineSet where HMakeName = '" + HMakeName + "' and HType = '" + HTypes + "'"; oCN.RunProc(sql); //插入当前用户最新的自定义数据 for(int i=0;i< saveDataList.Count; i++) { sql = "select * from Gy_Menu_1 where HItemID = '" + saveDataList[i].HItemID + "'"; ds = oCn.RunProcReturn(sql,"Gy_Menu_1"); if (ds.Tables[0].Rows.Count > 0) { string HPartentID = ds.Tables[0].Rows[0]["HPartentID"].ToString(); string HNumber = ds.Tables[0].Rows[0]["HNumber"].ToString(); int HLevel = int.Parse(ds.Tables[0].Rows[0]["HLevel"].ToString()); string Hurl = ds.Tables[0].Rows[0]["Hurl"].ToString(); string HType = ds.Tables[0].Rows[0]["HType"].ToString(); string HPicNum = ds.Tables[0].Rows[0]["HPicNum"].ToString(); if(HPartentID == "0" || HPartentID == ds.Tables[0].Rows[0]["HItemID"].ToString()) { string HPosition = ds.Tables[0].Rows[0]["HPosition"].ToString(); sql = "insert into Gy_MenuDefineSet(HItemID,HPartentID,HNumber,HName,HLevel,Hurl,HType,HMakeName,HPicNum,HPosition) values('" + saveDataList[i].HItemID + "','" + HPartentID + "','" + HNumber + "','" + saveDataList[i].HName + "'," + HLevel + ",'" + Hurl + "','" + HType + "','" + HMakeName + "','" + HPicNum + "','" + HPosition + "')"; oCN.RunProc(sql); } else { sql = "insert into Gy_MenuDefineSet(HItemID,HPartentID,HNumber,HName,HLevel,Hurl,HType,HMakeName,HPicNum,HPosition) values('" + saveDataList[i].HItemID + "','" + HPartentID + "','" + HNumber + "','" + saveDataList[i].HName + "'," + HLevel + ",'" + Hurl + "','" + HType + "','" + HMakeName + "','" + HPicNum + "','z')"; oCN.RunProc(sql); } } } //提交数据库操作 oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "保存成功！"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "查询失败！"; objJsonResult.data = e.ToString(); return objJsonResult; } } #endregion #endregion #region 用户菜单快捷方式自定义 #region 获取用户快捷方式选择菜单 //快捷方式自定义菜单：获取树组件数据 [Route("Web/Xt_UserFastMenu_Display")] [HttpGet] public object Xt_UserFastMenu_Display(string HMakeName, string HType) { try { //获取构建树状结构的数据 List menuInitList = new List(); //用以获取Gy_Menu_1中的所有菜单信息，以及对应节点是否被选中需要加载显示 SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); ds = oCn.RunProcReturn("Select * from Gy_Menu_1 where HType = '" + HType + "' Order by HItemID ", "Gy_Menu"); //获取Gy_Menu_1中的所有菜单信息，用于为menuInitList列表充实数据 DataSet ds1 = new DataSet(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) //将Gy_Menu_1中的菜单信息及选中情况保存到menuInitList列表中， { //填充基本数据 MenuInit menuInit = new MenuInit(); menuInit.HitemID = ds.Tables[0].Rows[i]["HItemID"].ToString(); menuInit.HPartentID = ds.Tables[0].Rows[i]["HPartentID"].ToString(); menuInit.HNumber = ds.Tables[0].Rows[i]["HNumber"].ToString(); menuInit.HName = ds.Tables[0].Rows[i]["HName"].ToString(); menuInit.HLevel = int.Parse(ds.Tables[0].Rows[i]["HLevel"].ToString()); menuInit.Hurl = ds.Tables[0].Rows[i]["Hurl"].ToString(); menuInit.HType = ds.Tables[0].Rows[i]["HType"].ToString(); menuInit.HSelected = false; //判断用户是否选中显示该菜单 String sql = "Select * from Xt_UserFastMenu where HSubFuncID = '" + ds.Tables[0].Rows[i]["HItemID"] + "' and HUserID='" + HMakeName + "'"; ds1 = oCn.RunProcReturn(sql, "Xt_UserFastMenu"); if (ds1.Tables[0].Rows.Count > 0) //对于Gy_Menu_1表中的菜单节点，通过检索在Gy_MenuDefineSet表中对应用户是否存在该节点的信息，判断该用户是否选中该节点需要加载显示在侧菜单栏 { menuInit.HSelected = true; } menuInitList.Add(menuInit); //将Gy_Menu_1表中的菜单节点信息逐一添加到menuInitList列表中 } //存储树状结构的数据 List tree = new List(); //用以获取菜单清单在layui中树组件渲染参数option中data值值的参数 for (int i = 0; i < menuInitList.Count; i++) //获取菜单清单中的根节点的渲染数据 { if (menuInitList[i].HPartentID == "0" || menuInitList[i].HitemID == menuInitList[i].HPartentID) //判断是否是根节点 { MenuDefineList define = new MenuDefineList(); define.id = menuInitList[i].HitemID; define.field = menuInitList[i].HitemID; define.title = menuInitList[i].HName; define.spread = false; define.selected = false; if (menuInitList[i].HSelected == true) { define.selected = true; } tree.Add(define); } } MenuDefineResult res = new MenuDefineResult(); res.dt = menuInitList; res.tree = tree; objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "查询成功！"; objJsonResult.data = res; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "查询失败！"; objJsonResult.data = e.ToString(); return objJsonResult; } } #endregion #region 保存用户快捷方式选择菜单 //保存用户快捷方式选择菜单 [Route("Web/Xt_UserFastMenu_Save")] [HttpPost] public object Xt_UserFastMenu_Save([FromBody] JObject sMainSub) { try { //获取传参的自定义数据 var _value = sMainSub["sMainSub"].ToString(); string msg = _value.ToString(); string[] sArray = msg.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string HMakeName = sArray[1].ToString(); string saveData = sArray[0].ToString(); string HTypes = sArray[2].ToString(); List saveDataList = Newtonsoft.Json.JsonConvert.DeserializeObject>(saveData); //声明数据库操作工具 SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //设置数据库操作的回滚点，若在提交前报错，则回滚到该点，期间操作取消 oCN.BeginTran(); //删除当前用户的自定义数据 string sql = "delete from Xt_UserFastMenu where HUserID = '" + HMakeName + "' and HType = '" + HTypes + "'"; oCN.RunProc(sql); //插入当前用户最新的自定义数据 for (int i = 0; i < saveDataList.Count; i++) { sql = "select * from Gy_Menu_1 where HPartentID = '" + saveDataList[i].HItemID + "'"; ds = oCn.RunProcReturn(sql, "Gy_Menu_1"); if (ds.Tables[0].Rows.Count == 0) //判断该节点是否为最下级节点，即不存在子节点 { sql = "select * from Gy_Menu_1 where HItemID = '" + saveDataList[i].HItemID + "'"; ds = oCn.RunProcReturn(sql, "Gy_Menu_1"); if (ds.Tables[0].Rows.Count > 0) { string HUserID = HMakeName; string HSubFuncID = ds.Tables[0].Rows[0]["HItemID"].ToString(); string HCaption = ds.Tables[0].Rows[0]["HName"].ToString(); string HType = ds.Tables[0].Rows[0]["HType"].ToString(); sql = "insert into Xt_UserFastMenu(HUserID,HSubFuncID,HCaption,HType) values('" + HUserID + "','" + HSubFuncID + "','" + HCaption + "','" + HType + "')"; oCN.RunProc(sql); } } } //提交数据库操作 oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "保存成功！"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "查询失败！"; objJsonResult.data = e.ToString(); return objJsonResult; } } #endregion #region 加载console.html页面的快捷方式 //快捷方式自定义菜单：获取树组件数据 [Route("Web/Xt_UserFastMenu_Init")] [HttpGet] public object Xt_UserFastMenu_Init(string HMakeName, string HType) { try { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); string sql = "select a.HSubFuncID, a.HCaption,a.HPicNum,b.Hurl from Xt_UserFastMenu as a join Gy_Menu_1 as b on a.HSubFuncID = b.HItemID where a.HUserID = '" + HMakeName + "' and b.HType = '" + HType + "' Order by a.HItemID"; ds = oCn.RunProcReturn(sql, "Xt_UserFastMenu"); //获取Xt_UserFastMenu中该用户设置的自定义菜单信息，用于在前端加载 objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "查询成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "查询失败！"; objJsonResult.data = e.ToString(); return objJsonResult; } } #endregion #region 保存快捷方式的图标 [Route("Web/Xt_UserFastMenu_IconSave")] [HttpGet] public object Xt_UserFastMenu_IconSave(string Icon, string HItemID, string HMakeName) { try { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); string sql = "update Xt_UserFastMenu set HPicNum = '" + Icon + "' where HSubFuncID='" + HItemID + "' and HUserID = '" + HMakeName + "'"; oCN.RunProc(sql); //获取Xt_UserFastMenu中该用户设置的自定义菜单信息，用于在前端加载 objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "查询成功！"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "查询失败！"; objJsonResult.data = e.ToString(); return objJsonResult; } } #endregion #region 获取快捷方式的图标 [Route("Web/Xt_UserFastMenu_IconGet")] [HttpGet] public object Xt_UserFastMenu_IconGet(string HItemID, string HMakeName) { try { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); string sql = "select HPicNum from Xt_UserFastMenu where HSubFuncID='" + HItemID + "' and HUserID = '" + HMakeName + "'"; ds = oCn.RunProcReturn(sql, "Xt_UserFastMenu"); //获取Xt_UserFastMenu中该用户设置的自定义菜单信息，用于在前端加载 objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "查询成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "查询失败！"; objJsonResult.data = e.ToString(); return objJsonResult; } } #endregion #endregion ///// ///// 产品入库缓存列表刷新信息 ///// ///// //[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; // } //} /// /// 产品入库缓存列表刷新信息 /// /// [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; } } /// /// 产品入库缓存列表刷新信息 /// /// [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 columnNameList = new List(); //添加列名 foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 } 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其他入库列表模块 /// /// 其他入库缓存列表刷新信息 /// /// /// /// /// [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 columnNameList = new List(); 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 /// /// 获取流水号列表 /// /// /// [Route("Web/GetProcNoList")] [HttpGet] public object GetProcNoList(int HInterID,string sWhere,string UserID) { List columnNameList = new List(); 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; } /// /// 获取运输公司列表 /// /// [Route("Web/GetConveyCompList_Json")] [HttpGet] public object GetConveyCompList_Json(string ConveyComp) { if (ConveyComp != "") { sWhere = sWhere + " and ( HNumber like '%" + ConveyComp + "%' or HName like '%" + ConveyComp + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_ConveyComp where HStopflag=0 Order by HItemID ", "Gy_ConveyComp"); } else { string sql1 = "Select HItemID,HNumber ,HName from Gy_ConveyComp where HStopflag=0 and HEndFlag=1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_ConveyComp"); } 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; } } /// /// 获取运输方式列表 /// /// [Route("Web/GetConveyTypeList_Json")] [HttpGet] public object GetConveyTypeList_Json(string ConveyType) { if (ConveyType != "") { sWhere = sWhere + " and ( HNumber like '%" + ConveyType + "%' or HName like '%" + ConveyType + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_ConveyType where HStopflag=0 Order by HItemID ", "Gy_ConveyType"); } else { string sql1 = "Select HItemID,HNumber ,HName from Gy_ConveyType where HStopflag=0 and HEndFlag=1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_ConveyType"); } 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; } } } }