LXAPI.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);