//用户登入
public object Login(string LoginType, string Name = "", string Pass = "", int Phone = 0)
{
Staff data = null;
var allData = DataSources.GetData <Staff>(ff, true);
switch (LoginType)
{
case "Pass":
data = allData.Where(item => item.Staff_Password == Pass).
Where(item => item.Staff_Account == Name).SingleOrDefault();
break;
case "Phone":
data = allData.Where(item => item.Staff_Phone == Phone).SingleOrDefault();
break;
}
if (data == null)
{
return new { code = 1 }
}
;
string Token = new JwtTokenUtil().GetToken(data.Staff_Account, data.Staff_Password);
return(new { code = 0, Token });
}
public bool Del(int Id)
{
bool status = ff.db <Student>().Delete(s => s.Id == Id); //调用实体类，执行删除操作
DataSources.GetData <Student>(ff, true); //将改动的数据在redis中重新加载
return(status);
}
public bool Del(string Ids)
{
var begin = DateTime.Now.Second;
dynamic[] dynamics = Ids.Split(",");
ThreadStart threadStart = new ThreadStart(delegate()
{
bool status = ff.db <InsertApply>().Delete(dynamics);//调用实体类，执行删除操作
});
Thread thread = new Thread(threadStart);
thread.Start();//多线程启动匿名方法
var zhong = DateTime.Now.Second;
DataSources.GetData <InsertApply>(ff, true);//将改动的数据在redis中重新加载
//等待线程结束
while (thread.ThreadState != System.Threading.ThreadState.Stopped)
{
Thread.Sleep(10);
}
var end = DateTime.Now.Second;
return(true);
}
//获取所有的角色
public object GetRole(int page, int limit)
{
var data = DataSources.GetData <Role>(ff);
int count = data.Count();
data = data.Skip((page - 1) * limit).Take(limit).ToList();
return(new { data = data, code = 0, count = count });
}
public bool PutDevelopers(Developers Developers)
{
Developers.Developers_changetime = DateTime.Now;
bool status = ff.db <Developers>().Update(Developers); //调用实体类，执行删除操作
DataSources.GetData <Developers>(ff, true); //将改动的数据在redis中重新加载
return(status);
}
public bool AddDevelopers([FromBody] Developers app)
{
app.Developers_changetime = DateTime.Now;
bool status = ff.db <Developers>().Insert(app); //调用实体类，执行添加操作
DataSources.GetData <Developers>(ff, true); //将改动的数据在redis中重新加载
return(status);
}
public bool DelDevelopers(string Ids)
{
dynamic[] dynamics = Ids.Split(",");
bool status = ff.db <Developers>().Delete(dynamics); //调用实体类，执行删除操作
DataSources.GetData <Developers>(ff, true); //将改动的数据在redis中重新加载
return(status);
}
public bool PutAppArrange(AppArrange AppArrange)
{
AppArrange.Atimes = DateTime.Now;
AppArrange.APost_code = "0001";
bool status = ff.db <AppArrange>().Update(AppArrange); //调用实体类，执行删除操作
DataSources.GetData <AppArrange>(ff, true); //将改动的数据在redis中重新加载
return(status);
}
public bool Put(InsertApply InsertApply)
{
InsertApply.InsertApply_ChangeTime = DateTime.Now;
InsertApply.InsertApply_tatus = 0;
bool status = ff.db <InsertApply>().Update(InsertApply); //调用实体类，执行删除操作
DataSources.GetData <InsertApply>(ff, true); //将改动的数据在redis中重新加载
return(status);
}
public bool Add([FromBody] InsertApply app)
{
app.InsertApply_ChangeTime = DateTime.Now;
app.InsertApply_tatus = 0;
bool status = ff.db <InsertApply>().Insert(app); //调用实体类，执行添加操作
DataSources.GetData <InsertApply>(ff, true); //将改动的数据在redis中重新加载
return(status);
}
public bool AddAppArrange([FromBody] AppArrange app)
{
app.Atimes = DateTime.Now;
app.APost_code = "0001";
bool status = ff.db <AppArrange>().Insert(app); //调用实体类，执行添加操作
DataSources.GetData <AppArrange>(ff, true); //将改动的数据在redis中重新加载
return(status);
}
public IEnumerable <int> getPowerIds(int[] roleIds)
{
var data = DataSources.GetData <Role_Power>(ff, true) as IEnumerable <Role_Power>;
foreach (var item in data)
{
if (roleIds.Contains(item.Role_Id))
{
yield return(item.Power_Id);
}
}
}
public IEnumerable <int> getStaffRoles(int staffId)
{
var data = DataSources.GetData <Staff_Role>(ff, true) as IEnumerable <Staff_Role>;
foreach (var item in data)
{
if (item.Staff_Id == staffId)
{
yield return(item.Role_Id);
}
}
}
//获取数据
public object GetDevelopers(int page, int limit, string Name = null)
{
var data = DataSources.GetData <Developers>(ff);
if (!string.IsNullOrEmpty(Name))
{
data = data.Where(s => s.Developers_Name.Contains(Name) || s.Developers_encoding.Equals(Name)).ToList();
}
int count = data.Count();
data = data.Skip((page - 1) * limit).Take(limit).ToList();
return(new { data = data, code = 0, count = count });
}
//获取数据
public object GetAppArrange(int page, int limit, string Name = null)
{
var data = DataSources.GetData <AppArrange>(ff);
if (!string.IsNullOrEmpty(Name))
{
data = data.Where(s => s.Aname.Contains(Name) || s.APost_code.Equals(Name)).ToList();
}
int count = data.Count();
data = data.Skip((page - 1) * limit).Take(limit).ToList();
return(new { data = data, code = 0, count = count });
}
public object getRolesPowers(int staffId)
{
//获取角色id
int[] roleIds = getStaffRoles(staffId).ToArray();
//获取权限id
int[] PowerIds = getPowerIds(roleIds).ToArray();
//获取权限
var data = DataSources.GetData <Power>(ff, true) as IEnumerable <Power>;
IEnumerable <Power> Powers = data.Where(item => PowerIds.Contains(item.Pid));
var datas = Powers.ToList();
return(datas);
}
//主界面加载信息
public object LoadPower()
{
string str = HttpContext.Request.Headers["Authorization"].ToString().Replace("Bearer ", "");
try
{
var Uncode = new JwtTokenUtil().UpToken(str);
Users use = JsonConvert.DeserializeObject <Users>(Uncode);
var uses = (DataSources.GetData <Staff>(ff) as IEnumerable <Staff>)
.Where(item => item.Staff_Account == use.Name)
.Where(item => item.Staff_Password == use.Pass)
.SingleOrDefault();
var allPowers = getRolesPowers(uses.Staff_Id);
new RedisHelper().Set(uses.Staff_Id.ToString(), allPowers, 10);
return(new { code = 0, allPowers });
}
catch { }
return(new { code = 1 });
}
//获取数据
public object GetULog(int page, int limit, string begin = null, string end = null, string Name = null)
{
var data = DataSources.GetData <ULog>(ff);
if (!string.IsNullOrEmpty(begin))
{
var begintime = Convert.ToDateTime(begin);
data = data.Where(s => DateTime.Compare(begintime, s.Utimes) <= 0).ToList();
}
if (!string.IsNullOrEmpty(end))
{
var endtime = Convert.ToDateTime(end);
data = data.Where(s => DateTime.Compare(endtime, s.Utimes) >= 0).ToList();
}
if (!string.IsNullOrEmpty(Name))
{
data = data.Where(s => s.Uname.Contains(Name) || s.Uapply.Equals(Name)).ToList();
}
int count = data.Count();
data = data.Skip((page - 1) * limit).Take(limit).ToList();
return(new { data = data, code = 0, count = count });
}
//token全局过滤
public override void OnActionExecuting(ActionExecutingContext context)
{
//获取token
string str = context.HttpContext.Request.Headers["Authorization"].ToString().Replace("Bearer ", "");
if (str != null)
{
var Uncode = new JwtTokenUtil().UpToken(str);
Users use = JsonConvert.DeserializeObject <Users>(Uncode);
//获取用户
var uses = (DataSources.GetData <Staff>(ff) as IEnumerable <Staff>)
.Where(item => item.Staff_Account == use.Name)
.Where(item => item.Staff_Password == use.Pass)
.SingleOrDefault();
if (uses != null)
{
var controllerName = context.RouteData.Values["controller"].ToString();
var actionName = context.RouteData.Values["action"].ToString();
var url = "/" + controllerName + "/" + actionName;
var allPowers = new RedisHelper().Get <IEnumerable <Power> >(uses.Staff_Id.ToString());
if (allPowers != null)
{
foreach (var item in allPowers)
{
if (item.Paction == url)
{
return;
}
}
}
}
}
//返回404
context.HttpContext.Response.Redirect("/Staff/Error");
}
public object Get()
{
var data = DataSources.GetData <Student>(ff);
return(new { data = data, code = 0 });
}
public int Add([FromBody] Student stu)
{
ff.db <Student>().Insert(stu); //调用实体类，执行添加操作
DataSources.GetData <Student>(ff, true); //将改动的数据在redis中重新加载
return(1);
}
