MES-WEB-API.git

			@@ -32,13 +32,13 @@
			{
			if (sWhere == null \|\| sWhere.Equals(""))
			{
			ds = oCN.RunProcReturn("select * from h_v_IF_GroupList " + sWhere, "h_v_IF_GroupList");
			ds = oCN.RunProcReturn("select * from h_v_GroupList " + sWhere, "h_v_GroupList");
			}
			else
			{
			string sql1 = "select * from h_v_IF_GroupList where 1 = 1 ";
			string sql1 = "select * from h_v_GroupList where 1 = 1 ";
			string sql = sql1 + sWhere;
			ds = oCN.RunProcReturn(sql, "h_v_IF_GroupList");
			ds = oCN.RunProcReturn(sql, "h_v_GroupList");
			}
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			@@ -67,8 +67,348 @@
			}
			}

			/// <summary>
			/// 根据基础资料ID 查找记录
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Gy_Group/cx")]
			[HttpGet]
			public object cx(long HInterID)
			{
			try
			{

			ds = oCN.RunProcReturn("select * from h_v_GroupListDetail where HitemID=" + HInterID, "h_v_GroupListDetail");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "false！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			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;
			}
			}

			[Route("Gy_Group/LoadTree")]
			[HttpGet]
			public object LoadTree_Json(string sWhere)
			{
			SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN();
			//ds = oCN.RunProcReturn("select * from h_v_IF_GroupList " + sWhere, "h_v_IF_GroupList");
			ds = oCN.RunProcReturn("select * from h_v_GroupLoadTree", "h_v_GroupLoadTree");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "false！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			}


			//
			/// <summary>
			/// 新增单据-保存按钮
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Gy_Group/AddBill")]
			[HttpPost]
			public object AddBill([FromBody] JObject oMain)
			{
			try
			{
			var _value = oMain["oMain"].ToString();
			string msg1 = _value.ToString();
			//反序列化
			msg1 = "[" + msg1.ToString() + "]";
			DAL.ClsGy_Group_Ctl oDept = new DAL.ClsGy_Group_Ctl();
			List<Gy_Group> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Group>>(msg1);
			long HItemID = list[0].HItemID.ToString() == "" ? 0 : list[0].HItemID;
			string HNumber = list[0].HNumber;
			string HName = list[0].HName;
			string HShortNumber = list[0].HShortNumber;
			long HParentID = list[0].HParentID;
			string HHelpCode = list[0].HHelpCode;
			string HRemark = list[0].HRemark;
			string HStopflag = list[0].HStopflag == "True" ? "1" : "0";
			string HUseFlag = list[0].HUseFlag;
			var HEmpQty = list[0].HEmpQty;
			var HBarCodeForBase = list[0].HBarCodeForBase;
			var HDeptID = list[0].HDeptID;
			var HDeptNumber = "";
			var HEndFlag = 0;
			var HLevel = "";
			var HProcID = "";
			if (!DBUtility.ClsPub.AllowNumber(HNumber))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "代码中不能出现连续‘.’并且首位末位不能为‘.’！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//若MAINDI重复则重新获取
			oCN.BeginTran();
			//主表
			string sql = "Insert into Gy_Group " +
			" (HNumber,HName,HHelpCode,HShortNumber,HParentID" +
			",HDeptNumber,HEmpQty" +
			",HLevel,HEndFlag,HStopflag,HRemark,HDeptID,HBarCodeForBase" +
			",HProcID) " +
			" Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HItemID.ToString() +
			",'" + HDeptNumber + "'," + HEmpQty +
			",'" + HLevel.ToString() + "'," + HEndFlag + "," + HStopflag +
			",'" + HRemark + "'," + HDeptID + ",'" + HBarCodeForBase + "','" + HProcID + "')";
			oCN.RunProc(sql, ref DBUtility.ClsPub.sExeReturnInfo);
			//修改上级为非末级代码
			if (list[0].HItemID.ToString() != "")
			{
			oCN.RunProc("Update Gy_Group set HEndflag=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
			}
			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.Message;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			/// <summary>
			/// 修改单据-保存按钮
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Gy_Group/EditBill")]
			[HttpPost]
			public object EditBill([FromBody] JObject oMain)
			{
			try
			{
			var _value = oMain["oMain"].ToString();
			string msg1 = _value.ToString();
			//反序列化
			msg1 = "[" + msg1.ToString() + "]";
			DAL.ClsGy_Group_Ctl oDept = new DAL.ClsGy_Group_Ctl();
			List<Gy_Group> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Group>>(msg1);

			long HItemID = list[0].HItemID;
			string HNumber = list[0].HNumber;
			string HName = list[0].HName;
			string HShortNumber = list[0].HNumber;
			long HParentID = list[0].HParentID;
			string HHelpCode = list[0].HHelpCode;
			string HRemark = list[0].HRemark;
			string HStopflag = list[0].HStopflag;
			string HUseFlag = list[0].HUseFlag;
			var HEmpQty = list[0].HEmpQty;
			var HBarCodeForBase = list[0].HBarCodeForBase;
			var HDeptID = list[0].HDeptID;
			var HProcID = list[0].HProcID;

			//判断权限
			//if (!ClsPub.Security_Log(msg5, 1, true, msg4))
			//{
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "没有找到该功能模块！";
			// objJsonResult.data = null;
			// return objJsonResult;
			//}
			//if (!DBUtility.ClsPub.AllowNumber(HNumber))
			//{
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "代码中不能出现连续‘.’并且首位末位不能为‘.’！";
			// objJsonResult.data = null;
			// return objJsonResult;
			//}
			//if (oDept.HavSameNumber(HItemID, HNumber))
			//{
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "代码重复！";
			// objJsonResult.data = null;
			// return objJsonResult;
			//}
			//若MAINDI重复则重新获取
			oCN.BeginTran();
			//主表
			oCN.RunProc("Update Gy_Group set " +
			" HNumber='" + HNumber + "'" +
			",HName='" + HName + "'" +
			",HShortNumber='" + HShortNumber + "'" +
			",HHelpCode='" + HHelpCode + "'" +
			",HParentID=" + HParentID +
			",HStopflag='" + HStopflag + "'" +
			",HRemark= '" + HRemark + "'" +
			",HDeptID=" + HDeptID +
			",HEmpQty=" + HEmpQty +
			",HBarCodeForBase='" + HBarCodeForBase + "' " +
			", HProcID = '" + HProcID + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
			//修改子项目代码
			//oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Group,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
			//将上级为非末级
			//oCN.RunProc("Update Gy_Group set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
			//
			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.Message;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			/// <summary>
			/// 维修列表修改按钮方法
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Gy_Group/xg")]
			[HttpGet]
			public object xg(long HInterID)
			{
			try
			{
			ds = oCN.RunProcReturn("select * from Gy_Group where HItemID=" + HInterID, "Gy_Group");

			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 = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			/// <summary>
			/// 维修方式列表删除按钮
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Gy_Group/Delete_Json")]
			[HttpGet]
			public object Delete_Json(long HItemID, string User, string ModRightNameDelete)
			{
			DAL.ClsGy_Group_Ctl oDept = new DAL.ClsGy_Group_Ctl();
			DAL.ClsGy_Group_View oDeptHlp = new DAL.ClsGy_Group_View();
			try
			{
			if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, true, User))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有删除权限";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (oDeptHlp.GetInfoByID(HItemID))
			{
			if (oDept.HavChildCodes(HItemID))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "此项目存在子项目,不能删除！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//删除前判断是否已使用 20141020
			if (oDeptHlp.omodel.HUseFlag != "未使用")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "此项目已使用或者未检测，不能删除！请重新检测再删除！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//
			if (oDept.DeleteByID(HItemID))
			{
			//写入日志
			ClsPub.Add_Log("", "删除项目，代码：" + oDeptHlp.omodel.HNumber + ",名称：" + oDeptHlp.omodel.HName, ClsPub.CurUserName);
			//更新上级为末级
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除成功";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "删除失败";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			//ds = oCN.RunProcReturn("delete from Gy_Department where HItemID = " + HItemID, "Gy_Department");

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除成功";
			objJsonResult.data = null;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			}
			}