JTAPI.git - Gitblit

			@@ -84,6 +84,7 @@
			#region [组织架构查找上级单位]
			public static ToMessage PrentOrganization(string orgcode)
			{
			var sql = "";
			var dynamicParams = new DynamicParameters();
			string search = "";
			try
			@@ -116,11 +117,14 @@
			dynamicParams.Add("@orgcode", orgcode);
			break;
			default:
			orgcode = "";
			search += "and description=@orgcode ";
			dynamicParams.Add("@orgcode", orgcode);
			break;
			}
			var sql = @"select roletype_code,roletype_name
			from TRoleType
			where A.is_delete<>'1' " + search;
			sql = @"select id,org_code,org_name
			from TOrganization
			where is_delete<>'1' " + search;

			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			@@ -564,6 +568,68 @@
			}
			#endregion

			#region[用户清单导入]
			public static ToMessage ImportUserExcel(string username, string filesName)
			{
			var sql = "";
			List<object> list = new List<object>();
			DataTable ds = new DataTable();
			var dynamicParams = new DynamicParameters();

			try
			{
			ds = NPOIHelper.GetExcelDatatable(filesName); //调用自定义方法
			int rowsnum = ds.Rows.Count;
			if (rowsnum == 0)
			{
			mes.code = "300";
			mes.Message = "Excel表格为空,无数据！";
			}
			else
			{
			list.Clear();
			for (int i = 0; i < ds.Rows.Count; i++)
			{

			if (ds.Rows[i][1].ToString() != "" && ds.Rows[i][1].ToString() != null)
			{
			sql = @"insert into TUser(usercode,username,enable,password,mobile,email,lm_user,lm_date,wagetype,stu_torgcode)
			values(@usercode,@username,@enable,@password,@mobile,@email,@lm_user,@lm_date,@wagetype,@stu_torgcode)";
			dynamicParams.Add("@usercode", ds.Rows[i][1].ToString());
			dynamicParams.Add("@username", ds.Rows[i][2].ToString());
			dynamicParams.Add("@enable", ds.Rows[i][3].ToString());
			dynamicParams.Add("@password", ds.Rows[i][4].ToString());
			dynamicParams.Add("@mobile", ds.Rows[i][5].ToString());
			dynamicParams.Add("@email", ds.Rows[i][6].ToString());
			dynamicParams.Add("@lm_user", username);
			dynamicParams.Add("@lm_date", DateTime.Now.ToString());
			dynamicParams.Add("@wagetype", ds.Rows[i][7].ToString());
			dynamicParams.Add("@stu_torgcode", ds.Rows[i][8].ToString());
			list.Add(new { str = sql, parm = dynamicParams });
			}
			}
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			mes.code = "200";
			mes.Message = "导入成功!";
			}
			else
			{
			mes.code = "300";
			mes.Message = "导入失败!";
			}
			}
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.Message = e.Message;
			}
			return mes;
			}
			#endregion



			#region[角色类型查询]
			@@ -895,9 +961,14 @@
			list.Clear();
			if (json == null \|\| json.Count <= 0)
			{
			mes.code = "300";
			mes.Message = "请先选择关联角色的用户信息";
			return mes;
			//清除用户关联角色表数据
			sql = @"delete TUserRoleRelation where role_code=@rolecode";
			dynamicParams.Add("@rolecode", rolecode);
			list.Add(new { str = sql, parm = dynamicParams });
			//标记角色表关联用户标识
			sql = @"update TRole set is_user='N' where role_code=@rolecode";
			dynamicParams.Add("@rolecode", rolecode);
			list.Add(new { str = sql, parm = dynamicParams });
			}
			else
			{
			@@ -939,6 +1010,105 @@
			}
			#endregion

			#region[角色清单关联功能查询]
			public static ToMessage RoleAssociationRight(string rolecode,string type)
			{

			Dictionary<object, object> dList = new Dictionary<object, object>();
			List<object> list=new List<object>();
			try
			{
			if (type == "" \|\| type == null)
			{
			list.Add(SeachEncode.RightLocation(rolecode, "PC"));
			list.Add(SeachEncode.RightLocation(rolecode, "APP"));
			}
			else if (type == "APP")
			{
			list.Add(SeachEncode.RightLocation(rolecode, type));
			}
			else {
			list.Add(SeachEncode.RightLocation(rolecode, type));
			}
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.data = list;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.Message = e.Message;
			}
			return mes;
			}
			#endregion

			#region [角色清单关联功能保存]
			public static ToMessage SaveUserAssoctRight(string rolecode,string usercode, List<TreeDM> json)
			{
			var sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			list.Clear();
			if (json == null \|\| json.Count <= 0)
			{
			//清除用户关联功能表数据
			sql = @"delete TRoleRightRelation where role_code=@rolecode";
			dynamicParams.Add("@rolecode", rolecode);
			list.Add(new { str = sql, parm = dynamicParams });
			//标记角色表关联功能标识
			sql = @"update TRole set is_right='N' where role_code=@rolecode";
			dynamicParams.Add("@rolecode", rolecode);
			list.Add(new { str = sql, parm = dynamicParams });
			}
			else
			{
			//清除角色关联功能表数据
			sql = @"delete TRoleRightRelation where role_code=@rolecode";
			dynamicParams.Add("@rolecode", rolecode);
			list.Add(new { str = sql, parm = dynamicParams });
			//循环写入用户关联角色表
			for (int i = 0; i < json.Count; i++) //PC、APP层
			{
			for (int j = 0; j < json[i].children.Count; j++) //一级菜单
			{
			for (int k = 0; k < json[i].children[j].children.Count; k++) //二级菜单
			{
			sql = @"insert into TRoleRightRelation(role_code,right_code,lm_user,lm_date) values(@role_code,@right_code,@lm_user,@lm_date)";
			dynamicParams.Add("@role_code", rolecode);
			dynamicParams.Add("@right_code", json[i].children[j].children[k].code);
			dynamicParams.Add("@lm_user", usercode);
			dynamicParams.Add("@lm_date", DateTime.Now.ToString());
			list.Add(new { str = sql, parm = dynamicParams });
			}
			}
			}
			//标记角色表关联用户标识
			sql = @"update TRole set is_right='Y' where role_code=@rolecode";
			dynamicParams.Add("@rolecode", rolecode);
			list.Add(new { str = sql, parm = dynamicParams });
			}
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			mes.code = "200";
			mes.Message = "操作成功!";
			}
			else
			{
			mes.code = "300";
			mes.Message = "操作失败!";
			}
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.Message = e.Message;
			}
			return mes;
			}
			#endregion
			}
			}