/// <summary>
/// 获取指定组用户
/// </summary>
/// <param name="groupCode"></param>
/// <returns></returns>
public async Task <ServiceResponse> GetGroupUsers(string groupCode)
{
try
{
using (var db = new ZFSConfig())
{
var task = await Task.Run(() =>
{
return(db.View_GroupUser.Where(q => q.GroupCode.Equals(groupCode)).ToList());
});
return(new ServiceResponse()
{
Success = true, Results = task
});
}
}
catch (Exception ex)
{
LoggerHelper.WriteLog("获取指定组用户", ex);
return(new ServiceResponse()
{
Success = false, ErrorCode = ex.Message
});
}
}
/// <summary>
/// 更新组用户权限
/// </summary>
/// <param name="funcList"></param>
/// <returns></returns>
public async Task <ServiceResponse> UpdateGroupFunc(tb_Group group, List <View_GroupUser> userList, List <tb_GroupFunc> funcList)
{
try
{
using (var db = new ZFSConfig())
{
if (group.isid.Equals(0))
{
db.tb_Group.Add(group);
}
else
{
var Group = db.tb_Group.FirstOrDefault(t => t.isid.Equals(group.isid));
Group.GroupName = group.GroupName;
DbEntityEntry dbEntity = db.Entry <tb_Group>(Group);
dbEntity.State = System.Data.Entity.EntityState.Modified;
}
//2.更新组用户
var GroupUsers = db.tb_GroupUser.Where(t => t.GroupCode.Equals(group.GroupCode)).ToList();
foreach (var item in GroupUsers)
{
db.tb_GroupUser.Remove(item);
}
userList.ForEach(t =>
{
db.tb_GroupUser.Add(new tb_GroupUser()
{
Account = t.Account,
GroupCode = group.GroupCode //组编号
});
});
//3.更新组权限
var groupList = db.tb_GroupFunc.Where(t => t.GroupCode.Equals(group.GroupCode)).ToList();
foreach (var item in groupList)
{
db.tb_GroupFunc.Remove(item);
}
funcList.ForEach(t =>
{
db.tb_GroupFunc.Add(t);
});
var task = await db.SaveChangesAsync();
bool result = task > 0 ? true : false;
return(new ServiceResponse()
{
Success = result
});
}
}
catch (Exception ex)
{
LoggerHelper.WriteLog("更新用户组权限", ex);
return(new ServiceResponse()
{
Success = false, ErrorCode = ex.Message
});
}
}
/// <summary>
/// 获取用户组
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public async Task <ServiceResponse> GetGroups(string search)
{
try
{
using (var db = new ZFSConfig())
{
var task = await Task.Run(() =>
{
return(db.tb_Group.Where(q => q.GroupName.Contains(search) || q.GroupCode.Contains(search)).ToList());
});
return(new ServiceResponse()
{
Success = true, Results = task
});
}
}
catch (Exception ex)
{
LoggerHelper.WriteLog("获取用户组集合", ex);
return(new ServiceResponse()
{
Success = false, ErrorCode = ex.Message
});
}
}
/// <summary>
/// 登出
/// </summary>
/// <param name="account"></param>
public async Task <ServiceResponse> Logout(string account)
{
try
{
using (var db = new ZFSConfig())
{
var model = db.tb_User.FirstOrDefault(t => t.Account.Equals(account));
model.FlagOnline = "0";
DbEntityEntry dbEntity = db.Entry <tb_User>(model);
dbEntity.State = System.Data.Entity.EntityState.Modified;
var task = await db.SaveChangesAsync();
bool result = task > 0 ? true : false;
return(new ServiceResponse()
{
Success = result
});
}
}
catch (Exception ex)
{
LoggerHelper.WriteLog("登出", ex);
return(new ServiceResponse()
{
Success = false, ErrorCode = ex.Message
});
}
}
/// <summary>
/// 删除用户组
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <ServiceResponse> Remove(int id)
{
try
{
using (var db = new ZFSConfig())
{
var group = db.tb_Group.FirstOrDefault(q => q.isid.Equals(id));
db.tb_Group.Remove(group);
var users = db.tb_GroupUser.Where(q => q.GroupCode.Equals(group.GroupCode)).ToList();
users.ForEach(t => db.tb_GroupUser.Remove(t));
var funcs = db.tb_GroupFunc.Where(q => q.GroupCode.Equals(group.GroupCode)).ToList();
funcs.ForEach(t => db.tb_GroupFunc.Remove(t));
var task = await db.SaveChangesAsync();
bool result = task > 0 ? true : false;
return(new ServiceResponse()
{
Success = result
});
}
}
catch (Exception ex)
{
LoggerHelper.WriteLog("删除组", ex);
return(new ServiceResponse()
{
Success = false, ErrorCode = ex.Message
});
}
}
public async Task <ServiceResponse> GetModelByAccount(string account)
{
try
{
using (var db = new ZFSConfig())
{
var task = await Task.Run(() =>
{
return(db.tb_User.AsNoTracking().FirstOrDefault(q => q.Account.Equals(account)));
});
return(new ServiceResponse()
{
Success = true, Results = task
});
}
}
catch (Exception ex)
{
LoggerHelper.WriteLog("账户获取账户信息", ex);
return(new ServiceResponse()
{
Success = false, ErrorCode = ex.Message
});
}
}
/// <summary>
/// 获取用户权限
/// </summary>
/// <param name="account"></param>
/// <returns></returns>
public async Task <ServiceResponse> GetAuthority(string account)
{
try
{
using (var db = new ZFSConfig())
{
var task = await Task.Run(() =>
{
return(db.View_UserAuthority.Where(t => t.Account.Equals(account)).ToList());
});
return(new ServiceResponse()
{
Success = true, Results = task
});
}
}
catch (Exception ex)
{
LoggerHelper.WriteLog("获取用户权限", ex);
return(new ServiceResponse()
{
Success = false, ErrorCode = ex.Message
});
}
}
public async Task <ServiceResponse> GetMenuTrees()
{
try
{
using (var db = new ZFSConfig())
{
var task = await Task.Run(() =>
{
return(db.Database.SqlQuery <View_MenuTree>(
"SELECT a.isid, a.MenuName, a.MenuCaption, a.ParentName, b.AuthorityName, b.AuthorityValue, a.MenuCode" +
" FROM " +
"dbo.tb_Menu AS a " +
"LEFT OUTER JOIN dbo.tb_AuthorityItem AS b ON b.AuthorityValue & " +
"a.MenuAuthorities = b.AuthorityValue").ToList());
});
return(new ServiceResponse()
{
Success = true, Results = task
});
}
}
catch (Exception ex)
{
LoggerHelper.WriteLog("获取菜单列表", ex);
return(new ServiceResponse()
{
Success = false, ErrorCode = ex.Message
});
}
}
/// <summary>
/// 获取表结构
/// </summary>
/// <param name="tableName">表名</param>
/// <returns></returns>
public async Task <ServiceResponse> GetTableStructs(string tableName, string nameSpace, string desc)
{
try
{
using (var db = new ZFSConfig())
{
var task = await db.Database.
SqlQuery <TableStruct>("select a.COLUMN_NAME,a.DATA_TYPE,a.CHARACTER_MAXIMUM_LENGTH,b.value AS VALUE " +
"from information_schema.COLUMNS as a " +
"left join sys.extended_properties as b " +
"on a.TABLE_NAME = OBJECT_NAME(b.major_id) " +
"and a.ORDINAL_POSITION = b.minor_id " +
"where a.TABLE_NAME = '" + tableName + "'").ToListAsync();
if (task != null)
{
var ts = task.FirstOrDefault(t => t.COLUMN_NAME.Equals("isid"));
if (ts != null)
{
ts.ISPRIMARY = true;
}
IGeneratorToClass generator = new GeneratorToModelClass();
string cdoe = generator.Create(nameSpace, desc, tableName, CreateBody(tableName, task));
return(new ServiceResponse()
{
Success = true, Results = cdoe
});
}
return(new ServiceResponse()
{
Success = false, ErrorCode = "Error."
});
}
}
catch (Exception ex)
{
LoggerHelper.WriteLog("获取表结构", ex);
return(new ServiceResponse()
{
Success = false, ErrorCode = ex.Message
});
}
}
/// <summary>
/// 新增更新模块信息
/// </summary>
/// <param name="tb_Menus"></param>
/// <returns></returns>
public async Task <ServiceResponse> UpdateMenus(List <tb_Menu> tb_Menus)
{
try
{
using (var db = new ZFSConfig())
{
tb_Menus.ForEach(q =>
{
var row = db.tb_Menu.FirstOrDefault(x => x.MenuCode.Equals(q.MenuCode));
if (row != null)
{
row.MenuName = q.MenuName;;
row.MenuNameSpace = q.MenuNameSpace;
row.MenuCaption = q.MenuCaption;
row.MenuAuthorities = q.MenuAuthorities;
DbEntityEntry dbEntity = db.Entry <tb_Menu>(row);
dbEntity.State = System.Data.Entity.EntityState.Modified;
}
else
{
db.Set <tb_Menu>().Add(q);
}
});
var task = await db.SaveChangesAsync();
bool result = task > 0 ? true : false;
return(new ServiceResponse()
{
Success = result
});
}
}
catch (Exception ex)
{
LoggerHelper.WriteLog("批量更新", ex);
return(new ServiceResponse()
{
Success = false, ErrorCode = ex.Message
});
}
}
/// <summary>
/// 登录系统
/// </summary>
/// <param name="Account">账号</param>
/// <param name="Password">密码</param>
/// <returns>信息</returns>
public async Task <ServiceResponse> Login(string Account, string Password)
{
try
{
using (var db = new ZFSConfig())
{
var task = await Task.Run(() =>
{
return(db.tb_User.FirstOrDefault(
q => q.Account.Equals(Account) &&
q.Password.Equals(Password)));
});
bool result = task != null ? true : false;
if (result)
{
return new ServiceResponse()
{
Success = result, Results = task
}
}
;
else
{
return new ServiceResponse()
{
Success = result, Message = "账号或密码错误,请确认!"
}
};
}
}
catch (Exception ex)
{
LoggerHelper.WriteLog("登录错误", ex);
return(new ServiceResponse()
{
Success = false, ErrorCode = ex.Message
});
}
}
public async Task <ServiceResponse> GetDictionarys()
{
try
{
using (var db = new ZFSConfig())
{
var task = await Task.Run(() => db.tb_Dictionary.ToList());
return(new ServiceResponse()
{
Success = true, Results = task
});
}
}
catch (Exception ex)
{
LoggerHelper.WriteLog("获取字典", ex);
return(new ServiceResponse()
{
Success = false, ErrorCode = ex.Message
});
}
}
/// <summary>
/// 获取数据库表名列表
/// </summary>
/// <returns></returns>
public async Task <ServiceResponse> GetUvs()
{
try
{
using (var db = new ZFSConfig())
{
var task = await db.Database.SqlQuery <string>("select name from sysobjects where type " +
"in('U','V') order by name").ToListAsync();
return(new ServiceResponse()
{
Success = true, Results = task
});
}
}
catch (Exception ex)
{
LoggerHelper.WriteLog("获取表OR视图", ex);
return(new ServiceResponse()
{
Success = false, ErrorCode = ex.Message
});
}
}
