ZQHApi.git - Gitblit

			@@ -242,7 +242,7 @@
			#endregion

			#region [组织架构删除]
			public static ToMessage DeleteOrganization(int orgid)
			public static ToMessage DeleteOrganization(int orgid, string orgcode)
			{
			var sql = "";
			var cont = 0;
			@@ -251,32 +251,42 @@
			{
			sql = @"select * from TOrganization where parent_id=@orgid and is_delete<>'1'";
			dynamicParams.Add(@"orgid", orgid);
			cont = DapperHelper.selectcount(sql, dynamicParams);
			if (cont > 0)
			var data0 = DapperHelper.selectdata(sql, dynamicParams);
			if (data0.Rows.Count > 0)
			{
			mes.code = "300";
			mes.Message = "当前组织有下级关联,请先删除下级组织!";
			return mes;
			}
			sql = @"select * from TUser where is_delete<>'1' and stu_torgcode=@stu_torgcode";
			dynamicParams.Add("@stu_torgcode", orgcode);
			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 TOrganization where id=@orgid";
			dynamicParams.Add(@"orgid", orgid);
			cont = DapperHelper.SQL(sql, dynamicParams);
			if (cont > 0)
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "删除操作成功!";
			mes.data = null;
			}
			else
			{
			sql = @"delete TOrganization where id=@orgid";
			dynamicParams.Add(@"orgid", orgid);
			cont = DapperHelper.SQL(sql, dynamicParams);
			if (cont > 0)
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "删除操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除操作失败!";
			mes.data = null;
			}
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除操作失败!";
			mes.data = null;
			}

			}
			catch (Exception e)
			{
			@@ -292,7 +302,7 @@


			#region[用户清单数据查询]
			public static ToMessage UserSearch(string UserCode, string UserName, string StuOrg,string description, string wagetype, string Enable, int startNum, int endNum, string prop, string order)
			public static ToMessage UserSearch(string UserCode, string UserName, string StuOrg, string description, string wagetype, string Enable, int startNum, int endNum, string prop, string order)
			{
			var dynamicParams = new DynamicParameters();
			string search = "";
			@@ -456,7 +466,7 @@
			#endregion

			#region[用户所属班组]
			public static ToMessage UserGroup(string stu_torgcode,string description)
			public static ToMessage UserGroup(string stu_torgcode, string description)
			{
			var dynamicParams = new DynamicParameters();
			string search = "";
			@@ -633,7 +643,7 @@
			sql = @"delete TUserRoleRelation where user_code=@usercode";
			list.Add(new { str = sql, parm = new { usercode = data.Rows[0]["USERCODE"].ToString() } });

			sql = @"update TUser set is_delete='1' where id=@userid";
			sql = @"delete TUser where id=@userid";
			list.Add(new { str = sql, parm = new { userid = userid } });
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			@@ -663,7 +673,7 @@
			#endregion

			#region[用户清单关联角色查询]
			public static ToMessage UserAssociationRole(string usercode,string stu_torgcode,string description)
			public static ToMessage UserAssociationRole(string usercode, string stu_torgcode, string description)
			{
			string sql = "";
			string search = "";
			@@ -697,7 +707,7 @@
			where C.user_code=@usercode
			) B
			on A.roletype_code=B.roletype_code
			where A.is_delete='0' "+search;
			where A.is_delete='0' " + search;
			dynamicParams.Add("@usercode", usercode);
			var data = DapperHelper.select<TreeObejct>(sql, dynamicParams);
			for (int i = 0; i < data.Count; i++)
			@@ -727,7 +737,7 @@
			#endregion

			#region[用户清单关联角色保存]
			public static ToMessage SaveUserAssoctRole(string usercode,string stu_torgcode,string description, List<RoleUserSubmit> json)
			public static ToMessage SaveUserAssoctRole(string usercode, string stu_torgcode, string description, List<RoleUserSubmit> json)
			{
			var sql = "";
			List<object> list = new List<object>();
			@@ -794,7 +804,7 @@
			for (int j = 0; j < json[i].Data.Count; j++)
			{
			sql = @"insert into TUserRoleRelation(user_code,role_code,torg_code) values(@usercode,@role_code,@stu_torgcode)";
			list.Add(new { str = sql, parm = new { usercode = usercode, stu_torgcode= stu_torgcode, role_code = json[i].Data[j] } });
			list.Add(new { str = sql, parm = new { usercode = usercode, stu_torgcode = stu_torgcode, role_code = json[i].Data[j] } });

			}
			}
			@@ -904,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 = "";
			@@ -927,11 +937,21 @@
			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
			left join TOrganization parent on G.torg_code=parent.org_code
			left join TOrganization as child on parent.parent_id=child.id
			where G.is_delete<>'1' "+search;
			where G.is_delete<>'1' " + search;
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			@@ -950,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>();
			@@ -958,50 +978,125 @@
			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;
			}
			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)";
			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[0].code,
			groupename = json[0].name,
			description = json[0].flag,
			lm_user = username,
			lm_date = DateTime.Now.ToString(),
			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[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
			}
			});
			}
			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;
			//删除用户组关系表
			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
			}
			});
			}
			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)
			@@ -1024,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;
			}
			@@ -1065,12 +1161,49 @@
			}
			#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




			#region[角色类型查询]
			public static ToMessage RoleTypeSearch(string stu_torgcode, string description,int startNum, int endNum, string prop, string order)
			public static ToMessage RoleTypeSearch(string stu_torgcode, string description, int startNum, int endNum, string prop, string order)
			{
			var dynamicParams = new DynamicParameters();
			string search = "";
			@@ -1097,7 +1230,7 @@
			from TRoleType R
			left join TOrganization parent on R.torg_code=parent.org_code
			left join TOrganization as child on parent.parent_id=child.id
			where R.is_delete<>'1' " + search;
			where R.is_delete<>'1' and roletype_code<>'001' " + search;
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			@@ -1147,7 +1280,7 @@
			{
			roletypecode = json[i].code,
			roletypename = json[i].name,
			torg_code= json[i].flag
			torg_code = json[i].flag
			}
			});
			}
			@@ -1183,12 +1316,22 @@
			{
			var sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			list.Clear();
			sql = @"select * from TRole where is_delete<>'1' and roletype_code=@roleTypeCode";
			dynamicParams.Add("@roleTypeCode", roleTypeCode);
			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 TRoleType where roletype_code=@roletypecode";
			list.Add(new { str = sql, parm = new { roletypecode = roleTypeCode } });
			sql = @"delete TRole where roletype_code=@roletypecode";
			list.Add(new { str = sql, parm = new { roletypecode = roleTypeCode } });
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			@@ -1218,7 +1361,7 @@
			#endregion

			#region[角色类型下拉接口]
			public static ToMessage RoleTypeSelect(string stu_torgcode,string description)
			public static ToMessage RoleTypeSelect(string stu_torgcode, string description)
			{
			var dynamicParams = new DynamicParameters();
			string search = "";
			@@ -1262,7 +1405,7 @@
			#endregion

			#region[角色清单查询]
			public static ToMessage RoleSearch(string stu_torgcode,string description,string RoleCode, string RoleName, string RoleTypeCode, string CreateUser, int startNum, int endNum, string prop, string order)
			public static ToMessage RoleSearch(string stu_torgcode, string description, string RoleCode, string RoleName, string RoleTypeCode, string CreateUser, int startNum, int endNum, string prop, string order)
			{
			var dynamicParams = new DynamicParameters();
			string search = "";
			@@ -1335,7 +1478,7 @@
			#endregion

			#region[角色清单新增编辑]
			public static ToMessage AddUpdateRole(string RoleId, string RoleCode, string RoleName,string stu_torgcode, string RoleTypeCode, string description, string Usercode, string OperType)
			public static ToMessage AddUpdateRole(string RoleId, string RoleCode, string RoleName, string stu_torgcode, string RoleTypeCode, string description, string Usercode, string OperType)
			{
			var dynamicParams = new DynamicParameters();
			try
			@@ -1421,16 +1564,29 @@
			{
			var sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			//更新角色表、角色关联用户标识及删除状态
			sql = @"update TRole set is_user='N',is_right='N',is_delete='1' where role_code=@RoleCode";
			//查找用户角色关联关系表
			sql = @"select * from TUserRoleRelation where is_delete<>'1' and role_code=@RoleCode";
			dynamicParams.Add("@RoleCode", RoleCode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "该角色下有关联的用户信息,不允许删除!";
			mes.data = null;
			return mes;
			}
			//更新角色表、角色关联用户标识及删除状态set is_user='N',is_right='N',is_delete='1'
			sql = @"delete TRole where role_code=@RoleCode";
			list.Add(new { str = sql, parm = new { RoleCode = RoleCode } });
			//更新角色关联用户表、角色关联用户标识及删除状态
			sql = @"delete TUserRoleRelation where role_code=@RoleCode";
			list.Add(new { str = sql, parm = new { RoleCode = RoleCode } });
			//删除(更新状态)角色功能表
			sql = @"update TRoleRightRelation set is_delete='1' where role_code=@RoleCode";
			sql = @"delete TRoleRightRelation where role_code=@RoleCode";
			list.Add(new { str = sql, parm = new { RoleCode = RoleCode } });
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)