~yxj/MES-WEB-API.git

			@@ -25,20 +25,59 @@
			/// </summary>
			[Route("Gy_Department/list")]
			[HttpGet]
			public object list(string sWhere)
			public object list(string sWhere,string user,string Organization)
			{
			try
			{
			//查看权限
			if (!DBUtility.ClsPub.Security_Log("Gy_Department", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无查看权限";
			objJsonResult.data = null;
			return objJsonResult;
			}
			string sql1 = string.Format(@"select * from h_v_IF_DepartmentList where 组织名称='" + Organization + "'");
			if (sWhere == null \|\| sWhere.Equals(""))
			{
			ds = oCN.RunProcReturn("select * from h_v_IF_DepartmentList " + sWhere, "h_v_IF_DepartmentList");
			ds = oCN.RunProcReturn(sql1 + sWhere + "order by 部门代码", "h_v_IF_DepartmentList");
			}
			else
			{
			string sql1 = "select * from h_v_IF_DepartmentList where 1 = 1 ";
			string sql = sql1 + sWhere;
			string sql = sql1 + sWhere + "order by 部门代码 ";
			ds = oCN.RunProcReturn(sql, "h_v_IF_DepartmentList");
			}

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


			/// <summary>
			/// 根据基础资料ID 查找记录
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Gy_Department/cx")]
			[HttpGet]
			public object cx(long HInterID)
			{
			try
			{
			ds = oCN.RunProcReturn("select * from h_v_IF_DepartmentListDetail where HitemID = " + HInterID, "h_v_IF_DepartmentListDetail");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			@@ -66,110 +105,91 @@
			}
			}


			/// <summary>
			/// 根据基础资料ID 查找记录
			///参数：string sql。
			///返回值：object。
			/// 部门列表删除功能
			/// </summary>
			[Route("Gy_Department/cx")]
			/// <returns></returns>
			[Route("DeltetGy_Department")]
			[HttpGet]
			public object cx(long HInterID)
			public object DeltetGy_Department(string HItemID,string user)
			{
			DataSet ds;
			DataSet ds1;
			try
			{
			ds = oCN.RunProcReturn("select * from Gy_Department where hitemid = " + HInterID, "Gy_Department");

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

			/// <summary>
			/// 部门列表删除按钮
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Gy_Department/Delete_Json")]
			[HttpGet]
			public object Delete_Json(long HItemID,string User,string ModRightNameDelete)
			{
			DAL.ClsGy_Department_Ctl oDept = new DAL.ClsGy_Department_Ctl();
			DAL.ClsGy_Department_View oDeptHlp = new DAL.ClsGy_Department_View();
			try
			{
			if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, true,User))
			//删除权限
			if (!DBUtility.ClsPub.Security_Log("Gy_Department_Delete", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有删除权限";
			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";
			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_Department where HItemID=" + HItemID, "Gy_Department");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有数据，无法删除！";
			objJsonResult.data = null;
			return objJsonResult; ;
			}
			ds1 = oCN.RunProcReturn("Select HItemID from Gy_Department Where HParentID='" + HItemID + "'", "Gy_Department");
			if (ds1.Tables[0].Rows.Count != 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "此项目存在子项目，不能删除！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			string HUseFlag = Convert.ToString(ds.Tables[0].Rows[0]["HUseFlag"]);
			if (HUseFlag == "已使用")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "此项目已使用，不能删除！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//v
			//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 from Gy_Department where HItemID=" + HItemID);
			oCN.Commit();//提交事务
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除成功";
			objJsonResult.Message = "* 数据删除成功！";
			objJsonResult.data = null;
			return objJsonResult;
			return objJsonResult; ;

			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.Message = "删除失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -250,7 +270,8 @@
			[HttpPost]
			public object AddBill([FromBody] JObject oMain)
			{
			try {
			try
			{
			var _value = oMain["oMain"].ToString();
			string msg1 = _value.ToString();
			//反序列化
			@@ -259,7 +280,7 @@
			DAL.ClsGy_Department_Ctl oDept = new DAL.ClsGy_Department_Ctl();
			DAL.ClsGy_Department_View oDeptHlp = new DAL.ClsGy_Department_View();




			List<Department> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Department>>(msg1);

			@@ -321,7 +342,7 @@
			//objJsonResult.data = null;
			return objJsonResult;
			}
			catch(Exception e)
			catch (Exception e)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			@@ -334,7 +355,7 @@


			/// <summary>
			/// 修改单据-保存按钮
			/// 保存按钮
			///参数：string sql。
			///返回值：object。
			/// </summary>
			@@ -354,12 +375,25 @@
			string msg2 = sArray[0].ToString();
			string msg3 = sArray[1].ToString();
			string msg4 = sArray[2].ToString();
			string msg5 = sArray[3].ToString();
			//string msg4 = sArray[2].ToString();
			//string msg5 = sArray[3].ToString();

			//编辑权限
			if (!DBUtility.ClsPub.Security_Log_second("Gy_Department_Edit", 1, false, msg3))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无保存权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//反序列化
			msg2 = msg2.Replace("\\", "");
			msg2 = msg2.Replace("\n", "");
			msg2 = "[" + msg2.ToString() + "]";
			List<Department> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Department>>(msg2);

			long HItemID = int.Parse(msg3);
			long HItemID = list[0].HItemID;
			string HNumber = list[0].HNumber;
			string HName = list[0].HName;
			string HShortNumber = list[0].HShortNumber;
			@@ -368,70 +402,95 @@
			long HParentID = list[0].HParentID;
			string HBarCode = list[0].HBarCode;
			string HHelpCode = list[0].HHelpCode;
			string HUpDater = list[0].HUpDater;
			long HEmpID = list[0].HEmpID;
			bool HStopflag = list[0].HStopflag;
			long HSecManagerID = list[0].HSecManagerID;
			//string HCreator = list[0].HCreator;
			long HCreateOrgID = list[0].HCreateOrgID;
			//DateTime HCreateDate = list[0].HCreateDate;
			long HUseOrgID = list[0].HUseOrgID;
			long HUseOrgID = long.Parse(msg4);
			string HUpdater = list[0].HUpDater;
			//DateTime HUpdateDate = list[0].HUpDateDate;
			string HChecker = list[0].HChecker;
			//DateTime HCheckDate = list[0].HCheckDate;
			string HDeleteMan = list[0].HDeleteMan;
			//DateTime HDeleteDate = list[0].HDeleteDate;

			long HLevel = 1;
			bool HEndFlag = true;
			long HEntityID = 1;

			//判断权限
			if (!ClsPub.Security_Log(msg5, 1, true, msg4))
			//if (!ClsPub.Security_Log(msg5, 1, false, 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;
			//}

			//保存
			//保存完毕后处理
			if (HItemID == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有找到该功能模块！";
			objJsonResult.data = null;
			return objJsonResult;
			//新增
			oCN.BeginTran();
			oCN.RunProc("Insert into Gy_Department " +
			" (HNumber,HName,HHelpCode,HShortNumber,HParentID" +
			",HLevel,HEndFlag,HStopflag,HRemark,HEmpID,HBarCodeForBase,HEntityID,HUSEORGID) " +
			" Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() +
			"," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HEmpID + ",'" + HBarCode + "'" +
			"," + HEntityID.ToString() + "," + HUseOrgID + ")", ref DBUtility.ClsPub.sExeReturnInfo);
			//修改上级为非末级代码
			oCN.RunProc("Update Gy_Department set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
			oCN.Commit();
			}


			if (!DBUtility.ClsPub.AllowNumber(HNumber))
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "代码中不能出现连续‘.’并且首位末位不能为‘.’！";
			objJsonResult.data = null;
			return objJsonResult;
			oCN.BeginTran();
			//主表
			oCN.RunProc("Update Gy_Department set " +
			" HNumber='" + HNumber + "'" +
			",HName='" + HName + "'" +
			",HHelpCode='" + HHelpCode + "'" +
			",HShortNumber='" + HShortNumber + "'" +
			",HParentID=" + HParentID +
			",HEmpID=" + HEmpID.ToString() +
			",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) +
			//",HUpdater='" + HUpdater + "'" +
			//",HUpdateDate= getdate()" +
			",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
			//修改子项目代码
			//oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Department,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
			//将上级为非末级
			oCN.RunProc("Update Gy_Department set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
			oCN.Commit();
			}

			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_Department set " +
			" HNumber='" + HNumber + "'" +
			",HName='" + HName + "'" +
			",HShortNumber='" + HShortNumber + "'" +
			",HParentID=" + HParentID +
			",HUpdater='" + HUpdater + "'" +
			",HUpdateDate= getdate()" +
			",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
			//修改子项目代码
			//oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Department,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
			//将上级为非末级
			oCN.RunProc("Update Gy_Department set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
			//
			oCN.Commit();
			objJsonResult.code = "1";
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "修改单据成功！";
			//objJsonResult.data = null;
			objJsonResult.Message = "保存成功！";
			//WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
			objJsonResult.data = 1;
			return objJsonResult;
			}
			catch (Exception e)
			@@ -444,7 +503,6 @@
			return objJsonResult;
			}
			}


			/// <summary>
			/// 获取最大基础资料ID
			@@ -512,27 +570,8 @@
			public object LoadTree_Json(string sWhere)
			{
			SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN();
			string sSql = "";
			// sSql = "select Name title,code id from province where code=330000 ";
			//sSql = "Select HItemID id,HName title,HParentID HParentID,1 HLevel,'true' lazy from Gy_Department";
			//List<Tree_Model> GetRegionList = GetRegion(sSql);
			//if (GetRegionList == null)
			//{
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "显示失败！原因：" + DBUtility.ClsPub.sExeReturnInfo;
			// objJsonResult.data = null;
			// return objJsonResult;
			//}
			//else
			//{
			// objJsonResult.code = "0";
			// objJsonResult.count = 1;
			// objJsonResult.Message = "获取成功！";
			// objJsonResult.data = GetRegionList;
			// return objJsonResult;
			//}
			ds = oCN.RunProcReturn("select * from h_v_IF_GroupList " + sWhere, "h_v_IF_GroupList");
			//ds = oCN.RunProcReturn("select * from h_v_IF_GroupList " + sWhere, "h_v_IF_GroupList");
			ds = oCN.RunProcReturn("select * from h_v_DepartmentLoadTree", "h_v_DepartmentLoadTree");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			@@ -551,64 +590,7 @@
			}
			}

			public List<Tree_Model> GetRegion(string sSql)
			{
			try
			{
			SqlDataReader reader = GetReader(sSql);
			List<Tree_Model> ModuleList = new List<Tree_Model>();
			while (reader.Read())
			{
			ModuleList.Add(new Tree_Model()
			{
			id = Convert.ToInt32(reader["id"]),
			HParentID = Convert.ToInt32(reader["HParentID"]),
			HLevel = Convert.ToInt32(reader["HLevel"]),
			lazy = Convert.ToBoolean(reader["lazy"]),
			title = reader["title"].ToString()
			});
			}
			reader.Close();
			return ModuleList;
			}
			catch(Exception e)
			{
			return null;
			}
			}

			public class Tree_Model
			{
			public long id;
			public string title;
			public string code;
			public long HParentID;
			public string HParentName;
			public long HLevel;
			public bool lazy;
			}
			public static SqlDataReader GetReader(string sql)
			{
			SqlConnection conn = new SqlConnection("Data Source=192.168.0.175;Initial Catalog=HX_LimsSys;User Id=HX_USER,Password=lc@841022;Integrated Security=True");
			SqlCommand cmd = new SqlCommand(sql, conn);
			try
			{
			conn.Open();
			SqlDataReader objReader =
			cmd.ExecuteReader(CommandBehavior.CloseConnection);
			return objReader;
			}
			catch (Exception ex)
			{
			conn.Close();
			throw ex;
			}
			//finally
			//{
			// conn.Close();
			// conn.Dispose();
			//}
			}

			//
			}