LKApi.git - Gitblit

			@@ -807,6 +807,30 @@
			}
			#endregion

			#region[角色类型下拉接口]
			public static ToMessage RoleTypeSelect()
			{
			string sql = "";
			try
			{
			//获取设备类型数据
			sql = @"select roletype_code,roletype_name from TRoleType where is_delete<>'1' ";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[角色清单查询]
			public static ToMessage RoleSearch(string RoleCode, string RoleName, string RoleTypeCode, string CreateUser, int startNum, int endNum, string prop, string order)
			{
			@@ -1041,39 +1065,6 @@
			#region[用户清单关联角色查询1]
			public static ToMessage RoleAssociationUserTwo(string rolecode)
			{
			var dynamicParams = new DynamicParameters();
			string sql = "";
			try
			{
			List<TreeDG> list = new List<TreeDG>();
			sql = @"select id,parent_id,org_code,org_name,description
			FROM TOrganization ";
			var dt = DapperHelper.selectdata(sql, dynamicParams);
			for (int i = 0; i < dt.Rows.Count; i++) //这里是循环所有
			{
			if (string.IsNullOrEmpty(dt.Rows[i]["PARENT_ID"].ToString()) \|\| dt.Rows[i]["PARENT_ID"].ToString() == "0") //判断是否最外层根节点
			{
			TreeDG tbj = new TreeDG();
			tbj.id = dt.Rows[i]["ID"].ToString();
			tbj.code = dt.Rows[i]["ORG_CODE"].ToString();
			tbj.name = dt.Rows[i]["ORG_NAME"].ToString();
			list.Add(tbj);
			}
			}
			digui(dt, list);
			mes.code = "200";
			mes.Message = "加载完成";
			mes.data = list;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.data = e.Message;
			mes.data = null;
			}
			return mes;

			string sql = "";
			var dynamicParams = new DynamicParameters();
			List<TreeObejct> list = new List<TreeObejct>();
			@@ -1160,8 +1151,6 @@
			#region[角色清单关联功能查询]
			public static ToMessage RoleAssociationRight(string rolecode,string type)
			{

			Dictionary<object, object> dList = new Dictionary<object, object>();
			List<object> list=new List<object>();
			try
			{
			@@ -1178,6 +1167,7 @@
			list.Add(SeachEncode.RightLocation(rolecode, type));
			}
			mes.code = "200";
			mes.count = list.Count;
			mes.Message = "查询成功!";
			mes.data = list;
			}
			@@ -1282,8 +1272,21 @@
			}
			if (unitAttr != "" && unitAttr != null)
			{
			search += "and unitattribute=@unitAttr ";
			dynamicParams.Add("@unitAttr", unitAttr);
			switch (unitAttr)
			{
			case "WG": //外购
			search += "and mtype=@unitAttr ";
			dynamicParams.Add("@unitAttr", unitAttr);
			break;
			case "WX": //外协
			search += "and btype=@unitAttr ";
			dynamicParams.Add("@unitAttr", unitAttr);
			break;
			default: //客户
			search += "and htype=@unitAttr ";
			dynamicParams.Add("@unitAttr", unitAttr);
			break;
			}
			}
			if (createUser != "" && createUser != null)
			{
			@@ -1296,7 +1299,7 @@
			}
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select id,code,name,unitattribute,conttacts,addr,lm_user,lm_date from TCustomer
			var sql = @"select id,code,name,mtype,btype,htype,conttacts,conttphone,addr,lm_user,lm_date from TCustomer
			where is_delete<>'1' " + search;
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			@@ -1316,18 +1319,20 @@
			#endregion

			#region[往来单位新增编辑]
			public static ToMessage AddUpdateCurrentUnit(string unitid, string unitcode, string unitname, string unitattr, string person, string contact, string description, string usercode,string OperType)
			public static ToMessage AddUpdateCurrentUnit(string unitid, string unitcode, string unitname, string mtypecode, string btypecode, string htypecode, string person, string contact, string description, string usercode,string OperType)
			{
			var dynamicParams = new DynamicParameters();
			try
			{
			if (OperType == "Add")
			{
			var sql = @"insert into TCustomer(code,name,unitattribute,conttacts,conttphone,addr,lm_user,lm_date)
			values(@unitcode,@unitname,@unitattr,@person,@contact,@description,@usercode,@CreateDate)";
			var sql = @"insert into TCustomer(code,name,mtype,btype,htype,conttacts,conttphone,addr,lm_user,lm_date)
			values(@unitcode,@unitname,@mtypecode,@btypecode,@htypecode,@person,@contact,@description,@usercode,@CreateDate)";
			dynamicParams.Add("@unitcode", unitcode);
			dynamicParams.Add("@unitname", unitname);
			dynamicParams.Add("@unitattr", unitattr);
			dynamicParams.Add("@mtypecode", mtypecode);
			dynamicParams.Add("@btypecode", btypecode);
			dynamicParams.Add("@htypecode", htypecode);
			dynamicParams.Add("@person", person);
			dynamicParams.Add("@contact", contact);
			dynamicParams.Add("@description", description);
			@@ -1351,10 +1356,12 @@
			}
			if (OperType == "Update")
			{
			var sql = @"update TCustomer set name=@unitname,unitattribute=@unitattr,conttacts=@person,conttphone=@contact,addr=@description,lm_user=@usercode,lm_date=@CreateDate where id=@RoleId";
			var sql = @"update TCustomer set name=@unitname,mtype=@mtypecode,btype=@btypecode,htype=@htypecode,conttacts=@person,conttphone=@contact,addr=@description,lm_user=@usercode,lm_date=@CreateDate where id=@unitid";
			dynamicParams.Add("@unitid", unitid);
			dynamicParams.Add("@unitname", unitname);
			dynamicParams.Add("@unitattr", unitattr);
			dynamicParams.Add("@mtypecode", mtypecode);
			dynamicParams.Add("@btypecode", btypecode);
			dynamicParams.Add("@htypecode", htypecode);
			dynamicParams.Add("@person", person);
			dynamicParams.Add("@contact", contact);
			dynamicParams.Add("@description", description);
			@@ -1389,28 +1396,41 @@
			#endregion

			#region[往来单位删除]
			public static ToMessage DeleteCurrentUnit(string unitid)
			public static ToMessage DeleteCurrentUnit(string unitcode)
			{
			var sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			list.Clear();
			sql = @"select * from TFlw_Rteqp where eqp_code=@unitcode";
			dynamicParams.Add("@unitcode", unitcode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "外协供方已关联外协工序,不允许删除!";
			mes.data = null;
			return mes;
			}
			//删除(更新状态)往来单位表
			sql = @"update TCustomer set is_delete='1' where id=@unitid";
			list.Add(new { str = sql, parm = new { unitid = unitid } });
			sql = @"update TCustomer set is_delete='1' where code=@unitcode";
			list.Add(new { str = sql, parm = new { unitcode = unitcode } });
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "删除用户成功!";
			mes.Message = "删除成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除用户失败!";
			mes.Message = "删除失败!";
			mes.data = null;
			}
			}