DDMesApi.git - Gitblit

			@@ -145,23 +145,22 @@
			#endregion

			#region[新增编辑组织架构]
			public static ToMessage AddUpdateOrganization(string organType, string organCode, string organName, string Operator, int supUnit, string operType)
			public static ToMessage AddUpdateOrganization(string organType, string organCode, string organName, string Operator, int supUnit,string RightCode,string numvalue, string operType)
			{
			string sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			if (operType == "Add")
			{
			var sql = @"insert into TOrganization(parent_id,org_code,org_name,lm_user,lm_date,description)
			sql = @"insert into TOrganization(parent_id,org_code,org_name,lm_user,lm_date,description)
			values(@supUnit,@organCode,@organName,@Operator,@CreateDate,@organType)";
			dynamicParams.Add("@supUnit", supUnit);
			dynamicParams.Add("@organCode", organCode);
			dynamicParams.Add("@organName", organName);
			dynamicParams.Add("@Operator", Operator);
			dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
			dynamicParams.Add("@organType", organType);
			int cont = DapperHelper.SQL(sql, dynamicParams);
			if (cont > 0)
			list.Add(new { str = sql, parm = new { supUnit = supUnit, organCode= organCode, organName= organName, Operator= Operator, CreateDate= DateTime.Now.ToString(), organType= organType } });
			//sql = @"update T_CodeRules set value=@cunm2 where rightcode=@RightCode";
			//list.Add(new { str = sql, parm = new { cunm2 = numvalue, RightCode = RightCode } });
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			mes.code = "200";
			mes.count = 0;
			@@ -178,7 +177,7 @@
			}
			if (operType == "Update")
			{
			var sql = @"update TOrganization set description=@organType,org_name=@organName,parent_id=@supUnit,lm_user=@Operator,lm_date=@CreateDate where org_code=@organCode";
			sql = @"update TOrganization set description=@organType,org_name=@organName,parent_id=@supUnit,lm_user=@Operator,lm_date=@CreateDate where org_code=@organCode";
			dynamicParams.Add(@"organCode", organCode);
			dynamicParams.Add("@supUnit", supUnit);
			dynamicParams.Add("@organName", organName);
			@@ -224,7 +223,7 @@
			sql = @"select * from TOrganization where parent_id=@orgid";
			dynamicParams.Add(@"orgid", orgid);
			cont = DapperHelper.selectcount(sql, dynamicParams);
			if (cont <= 0)
			if (cont>0)
			{
			mes.code = "300";
			mes.Message = "当前组织有下级关联,请先删除下级组织!";
			@@ -302,9 +301,11 @@
			//search = search.Substring(3);//截取索引2后面的字符
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select u.id,u.usercode,u.username,u.stu_torgcode,t.org_name,u.password,u.mobile,u.email,u.wagetype,u.enable,u.lm_user,u.lm_date,u.is_role
			var sql = @"select u.id,u.usercode,u.username,g.group_code,g.group_name,u.stu_torgcode,t.org_name,u.password,u.mobile,u.email,u.wagetype,u.enable,u.lm_user,u.lm_date,u.is_role
			from TUser u
			left join TOrganization t on u.stu_torgcode=t.org_code where u.is_delete<>1 " + search;
			left join TOrganization t on u.stu_torgcode=t.org_code
			left join TGroup g on u.usergroup_code=g.group_code
			where u.is_delete<>1 " + search;
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			@@ -354,6 +355,34 @@
			mes.code = "300";
			mes.count = 0;
			mes.data = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[用户所属班组]
			public static ToMessage UserGroup()
			{
			var dynamicParams = new DynamicParameters();
			try
			{
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select group_code,group_name
			from TGroup
			where is_delete<>'1' ";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.count = total;
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -690,6 +719,141 @@



			#region[用户组列表查询]
			public static ToMessage UserGroupSearch(int startNum, int endNum, string prop, string order)
			{
			var dynamicParams = new DynamicParameters();
			try
			{
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select group_code,group_name,description
			from TGroup
			where is_delete<>'1' ";
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.count = total;
			mes.data = data.ToList();
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[用户组新增]
			public static ToMessage UserGroupAdd(List<StepDefect> json,string username)
			{
			var sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			list.Clear();
			//循环写入用户组表
			for (int i = 0; i < json.Count; i++)
			{
			sql = @"insert into TGroup(group_code,group_name,description,lm_user,lm_date) values(@groupcode,@groupename,@description,@lm_user,@lm_date)";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			groupcode = json[i].code,
			groupename = json[i].name,
			description = json[i].flag,
			lm_user = username,
			lm_date = DateTime.Now.ToString()
			}
			});
			}
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "操作失败!";
			mes.data = null;
			}
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[用户组删除]
			public static ToMessage UserGroupDelete(string UserGrupCode)
			{
			var sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			list.Clear();
			sql = @"select * from TUser where is_delete<>'1' and usergroup_code=@UserGrupCode";
			dynamicParams.Add("@UserGrupCode", UserGrupCode);
			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 = @"delete TGroup where group_code=@UserGrupCode";
			list.Add(new { str = sql, parm = new { UserGrupCode = UserGrupCode } });

			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "操作失败!";
			mes.data = null;
			}
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion





			#region[角色类型查询]
			public static ToMessage RoleTypeSearch(int startNum, int endNum, string prop, string order)
			{