ZQHApi.git - Gitblit

			@@ -914,7 +914,7 @@


			#region[用户组列表查询]
			public static ToMessage UserGroupSearch(string stu_torgcode, string description,int startNum, int endNum, string prop, string order)
			public static ToMessage UserGroupSearch(string groupcode, string groupname, string stu_torgcode, string description, int startNum, int endNum, string prop, string order)
			{
			var dynamicParams = new DynamicParameters();
			string search = "";
			@@ -936,6 +936,16 @@
			break;
			default:
			break;
			}
			if (groupcode != "" && groupcode != null)
			{
			search += " and G.group_code like '%'+@groupcode+'%' ";
			dynamicParams.Add("@groupcode", groupcode);
			}
			if (groupname != "" && groupname != null)
			{
			search += " and G.group_name like '%'+@groupname+'%' ";
			dynamicParams.Add("@groupname", groupname);
			}
			var sql = @"select torg_code,parent.org_name,group_code,group_name,G.description
			from TGroup G
			@@ -960,7 +970,7 @@
			#endregion

			#region[用户组新增]
			public static ToMessage UserGroupAdd(List<StepDefect> json, string username)
			public static ToMessage UserGroupAdd(string type, List<GroupUser> json, string username)
			{
			var sql = "";
			List<object> list = new List<object>();
			@@ -968,33 +978,107 @@
			try
			{
			list.Clear();
			//循环写入用户组表
			for (int i = 0; i < json.Count; i++)
			if (type == "Add")
			{
			var sql0 = @"select * from TGroup where group_code=@group_code and torg_code=@torg_code";
			dynamicParams.Add("@group_code", json[i].code);
			dynamicParams.Add("@torg_code", json[i].storg_code);
			var data = DapperHelper.selectdata(sql0, dynamicParams);
			//判断用户组编码是否唯一
			sql = @"select * from TGroup where group_code=@group_code and torg_code=@torg_code";
			dynamicParams.Add("@group_code", json[0].code);
			dynamicParams.Add("@torg_code", json[0].storg_code);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "操作失败,编码重复!";
			mes.Message = "操作失败,用户组编码重复!";
			mes.data = null;
			return mes;
			}
			else
			{
			//写入用户组表
			sql = @"insert into TGroup(group_code,group_name,description,lm_user,lm_date,torg_code) values(@groupcode,@groupename,@description,@lm_user,@lm_date,@torg_code)";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			groupcode = json[i].code,
			groupename = json[i].name,
			description = json[i].flag,
			groupcode = json[0].code,
			groupename = json[0].name,
			description = json[0].flag,
			lm_user = username,
			lm_date = DateTime.Now.ToString(),
			torg_code = json[i].storg_code
			torg_code = json[0].storg_code
			}
			});
			//写入用户组关系表
			for (int i = 0; i < json[0].children.Count; i++)
			{
			sql = @"insert into TGroup(group_code,user_code) values(@groupcode,@usercode)";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			groupcode = json[0].code,
			groupename = json[0].children[i].usercode
			}
			});
			}
			}
			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;
			}
			}
			else
			{
			//修改用户组表
			sql = @"update TGroup see group_name=@,lm_user=@lm_user,lm_date=@lm_date,description=@description,torg_code=@torg_code where group_code=@groupcode";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			groupcode = json[0].code,
			groupename = json[0].name,
			description = json[0].flag,
			lm_user = username,
			lm_date = DateTime.Now.ToString(),
			torg_code = json[0].storg_code
			}
			});
			//删除用户组关系表
			sql = @"delete TGroupUser where group_code=@groupcode";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			groupcode = json[0].code
			}
			});
			//修改用户组关系表
			for (int i = 0; i < json[0].children.Count; i++)
			{
			sql = @"insert into TGroupUser(group_code,user_code) values(@groupcode,@usercode)";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			groupcode = json[0].code,
			groupename = json[0].children[i].usercode
			}
			});
			}
			@@ -1012,6 +1096,7 @@
			mes.count = 0;
			mes.Message = "操作失败!";
			mes.data = null;
			}
			}
			}
			catch (Exception e)
			@@ -1034,14 +1119,15 @@
			try
			{
			list.Clear();
			sql = @"select * from TUser where is_delete<>'1' and usergroup_code=@UserGrupCode";
			//判断当前用户组是否存在开报工记录
			sql = @"select * from TK_Wrk_RecordSub where 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.Message = "该用户组已经有报工,不允许删除!";
			mes.data = null;
			return mes;
			}
			@@ -1075,6 +1161,43 @@
			}
			#endregion

			#region[用户组查看关联人员]
			public static ToMessage GroupUserProject(string groupcode)
			{
			var sql = "";
			var dynamicParams = new DynamicParameters();
			try
			{
			sql = @"select * from TGroupUser where group_code=@groupcode";
			dynamicParams.Add("@groupcode", groupcode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "查询成功!";
			mes.data = data;
			return mes;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "该班组下无指定用户!";
			mes.data = null;
			return mes;
			}
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion