MES-WEB-API.git

			@@ -143,6 +143,56 @@
			}
			}

			/// <summary>
			/// 自动获取基础资料流水号就是代码
			/// </summary>
			/// <param name="HBillType"></param>
			/// <returns></returns>
			[Route("Web/GetMAXNumber")]
			[HttpGet]
			public object GetMAXNumber(string HBillType,string HName,string TableName)
			{
			try
			{
			string HNumber = "";
			HNumber = DBUtility.ClsPub.CreateHNumber(HBillType,HName, TableName, ref DBUtility.ClsPub.sExeReturnInfo, true);
			//----------创建虚表------------------------
			DataTable dt_Main = new DataTable("Json");
			dt_Main.Columns.Add("HNumber", typeof(string));

			//---------创建新行------------------------
			DataRow dr_main = dt_Main.NewRow();//创建新行
			dt_Main.Rows.Add(dr_main);//将新行加入到表中
			dr_main["HNumber"] = DBUtility.ClsPub.isStrNull(HNumber);


			if (HNumber == null)
			{
			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/Get_MaxBillNoAndID")]
			//[HttpGet]
			@@ -7859,6 +7909,307 @@
			}
			#endregion

			#region 项目费用设置列表/保存/编辑/删除方法
			/// <summary>
			/// 项目费用保存
			/// </summary>
			/// <param name="msg"></param>
			/// <returns></returns>
			[Route("SaveGy_ProjectMoneyList")]
			[HttpPost]
			public object SaveGy_ProjectMoneyList([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_ProjectMoney_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 isNull(MAX(HItemID),0) HItemID from Gy_ProjectMoney ", "Gy_ProjectMoney");
			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_ProjectMoney_Ctl oBill = new WebAPI.DLL.ClsGy_ProjectMoney_Ctl();
			List<Model.ClsGy_ProjectMoney_Model> lsmain = new List<Model.ClsGy_ProjectMoney_Model>();
			msg1 = msg1.Replace("\\", "");
			msg1 = msg1.Replace("\n", "");
			lsmain = oListModels.getObjectByJson_Gy_ProjectMoney(msg1);
			foreach (Model.ClsGy_ProjectMoney_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_ProjectMoney where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Gy_ProjectMoney");
			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()); //等级
			oItem.HMakeEmp = msg2; //创建人

			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;
			}
			}

			/// <summary>
			/// 项目费用获取信息
			/// </summary>
			/// <returns></returns>
			[Route("GetGy_ProjectMoneyDetail")]
			[HttpGet]
			public ApiResult<DataSet> GetGy_ProjectMoneyDetail(string HID)
			{
			var model = LuBaoSevice.GetGy_ProjectMoneyDetail(HID);
			return model;
			}

			/// <summary>
			/// 项目费用删除功能
			/// </summary>
			/// <returns></returns>
			[Route("DeltetGy_ProjectMoney")]
			[HttpGet]
			public object DeltetGy_ProjectMoney(string HItemID, string user)
			{
			DataSet ds;
			//string ModRightNameCheck = "Sc_ProcessReport_check";
			try
			{
			//删除权限
			if (!DBUtility.ClsPub.Security_Log("Gy_ProjectMoney_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_ProjectMoney where HItemID=" + HItemID, "Gy_ProjectMoney");
			if (ds.Tables[0].Rows.Count > 0)
			{
			if (ds.Tables[0].Rows[0]["HCheckEmp"].ToString() != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据已审核!不能进行删除！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (ds.Tables[0].Rows[0]["HStopEmp"].ToString() != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据已禁用!不能进行删除！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据不存在!";
			objJsonResult.data = null;
			return objJsonResult;
			}


			oCN.RunProc("delete Gy_ProjectMoney 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


			/// <summary>
			/// 用关联工序获取信息
			@@ -7972,6 +8323,31 @@
			var model = LuBaoSevice.Gy_UserByUserEdit(HID);
			return model;
			}

			/// <summary>
			/// 用户关联班组获取信息
			/// </summary>
			/// <returns></returns>
			[Route("GetGy_UserGroupDetail")]
			[HttpGet]
			public ApiResult<DataSet> GetGy_UserGroupDetail(string HID)
			{
			var model = LuBaoSevice.GetGy_UserGroupBillDetail(HID);
			return model;
			}

			/// <summary>
			/// 用户关联供应商获取信息
			/// </summary>
			/// <returns></returns>
			[Route("GetGy_UserSupplierDetail")]
			[HttpGet]
			public ApiResult<DataSet> GetGy_UserSupplierDetail(string HID)
			{
			var model = LuBaoSevice.GetGy_UserSupplierBillDetail(HID);
			return model;
			}


			/// <summary>
			/// 报废原因
			@@ -8645,11 +9021,11 @@
			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");
			ds = oCN.RunProcReturn("Select HInterID,HEquipFileNumber,HName,HModel2 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 sql1 = "Select HInterID,HEquipFileNumber,HName,HModel2 from Gy_EquipFileBillMain where 0=0 ";
			string sql = sql1 + sWhere;
			ds = oCN.RunProcReturn(sql, "Gy_EquipFileBillMain");
			}
			@@ -9071,11 +9447,11 @@
			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");
			ds = oCN.RunProcReturn("Select HItemID,HNumber 代码,HName 名称 ,HQCCheckClassID 检验项目类别,HDefaultResult 默认结论 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 ";
			string sql = "Select HItemID,HNumber 代码,HName 名称 ,HQCCheckClassID 检验项目类别,HDefaultResult 默认结论 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)
			@@ -9678,7 +10054,7 @@
			/// <returns></returns>
			[Route("Web/GetItemByEquipFile")]
			[HttpGet]
			public object GetItemByEquipFile(int EquipProjectID,string Type)
			public object GetItemByEquipFile(int EquipProjectID,string Type,string HDate)
			{
			if (EquipProjectID <= 0)
			{
			@@ -9708,7 +10084,8 @@
			}

			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			string sql = string.Format(@"select * from " + HView + " where HInterID = " + EquipProjectID);
			//string sql = string.Format(@"select * from " + HView + " where HInterID = " + EquipProjectID);
			string sql = string.Format(@"Exec h_p_Sb_GetCheckItem_PDA '" + EquipProjectID + "','" + Type + "','" + HDate + "'");
			ds = oCN.RunProcReturn(sql, HView);
			if (ds == null \|\| ds.Tables[0].Rows.Count <= 0)
			{
			@@ -9743,7 +10120,7 @@
			/// <returns></returns>
			[Route("Web/GetEquipmentBillsList")]
			[HttpGet]
			public object GetEquipmentBillsList(string sWhere, string Type)
			public object GetEquipmentBillsList(string sWhere, string Type,string user)
			{
			try
			{
			@@ -9758,7 +10135,7 @@
			HView = "h_v_Sb_EquipMaintainBillList";
			break;
			case "WX":
			HView = "h_v_Sb_EquipRepairCheckBillList";
			HView = "h_v_Sb_EquipRepairWorkBillList";
			break;
			case "GZ":
			HView = "h_v_Sb_EquipConkBookBillList";
			@@ -9775,6 +10152,15 @@
			}

			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();

			ds = oCN.RunProcReturn("select ManagerFlag from gy_czygl where czymc='" + user.Trim() + "'", "gy_czygl");
			if (!(bool)ds.Tables[0].Rows[0]["ManagerFlag"]) //是否管理员
			{
			//不是管理员
			sWhere += " and 制单人 = '" + user + "'";
			}


			string sql = string.Format(@"select * from " + HView + " where 1 = 1 " + sWhere);
			ds = oCN.RunProcReturn(sql, HView);
			//添加列名
			@@ -10023,6 +10409,37 @@
			}
			}


			/// <summary>
			/// 获取选单号的源单类型
			/// </summary>
			/// <returns></returns>
			[Route("Web/GetHSourceBillName")]
			[HttpGet]
			public object GetHSourceBillName(string HBillType)
			{
			try
			{
			ClsCN oCn = new ClsCN();
			DataSet oDs = new DataSet();
			//==========
			oDs = oCn.RunProcReturn("select * from xt_BillType where HNumber='" + HBillType + "'", "xt_BillType");
			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 [从数据库加载菜单]
			public class MenuLoad
			@@ -10925,6 +11342,47 @@
			}
			}

			/// <summary>
			/// 获取单据模块名称
			/// </summary>
			/// <returns></returns>
			[Route("Web/GetModuleName")]
			[HttpGet]
			public object GetModuleName(string HModuleType)
			{
			try
			{
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();

			ds = oCN.RunProcReturn("Select * from Xt_BillType where HNumber = '" + HModuleType + "'", "Xt_BillType");

			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;
			}
			}

			}

			}