public async Task Run(IJobExecutionContext context, int jobid)
{
//自己的业务
var list = await _userbussiness.QueryAsync();
if (jobid > 0)
{
//任务的业务，次数
var model = await _tasksQzServices.QueryAsync(jobid);
if (model != null)
{
model.RunTimes += 1;
await _tasksQzServices.UpdateAsync(model);
}
}
await Console.Out.WriteLineAsync("用户总数量" + list.Count.ToString());
}
public async Task <MessageModel <string> > GetMenu()
{
try
{
//throw new Exception();
var res = new MessageModel <string>();
var token = HttpContext.Request.Headers["Authorization"].ToString().Replace("Bearer ", "");
string json = "";
var tokenModel = JWTHelper.SerializeJwt(token);
var user = await _UserBussiness.QueryAsync(tokenModel.Uid);
List <TB_Menu> dt = null;
if (user.Issysadmin == "1")
{
dt = await _MenuBussiness.GetRoleMenu("");
}
else
{
dt = await _MenuBussiness.GetRoleMenu($"and mflag in(select mflag from tb_role_menu where roleid in (select roleid from tb_user_role where userid ='{Convert.ToInt32(user.Userid)}')) ");
}
// DataSet ds = new Member.BLL.Common().Getsql(sql);
if (dt.Count > 0)
{
json = "[{\"name\":\"" + dt[0].Mname.ToString() + "\",\"url\":\"#/console/console\",";
json += "\"icon\":\"" + dt[0].Ico.ToString() + "\"},";
var dr = dt.Where(o => o.Mlevel == 2).ToList();
if (dr.Count() > 0)
{
for (int i = 0; i < dr.Count(); i++)
{
json += "{\"name\":\"" + dr[i].Mname.ToString() + "\",\"url\": \"javascript:;\",\"icon\":\"" + dr[i].Ico.ToString() + "\",\"subMenus\":[";
string child = "";
var drs = dt.Where(O => O.Mparent == dr[i].Id).ToList();
if (drs.Count() > 0)
{
for (int m = 0; m < drs.Count(); m++)
{
child += "{\"name\":\"" + drs[m].Mname + "\",\"url\":\"#/" + drs[m].Murl + "\",\"icon\":\"" + drs[m].Ico + "\",\"subMenus\":[";
var drm = dt.Where(o => o.Mparent == drs[m].Id).ToList();
string child_ch = "";
if (drm.Count() > 0)
{
for (int n = 0; n < drm.Count(); n++)
{
child_ch += "{\"name\":\"" + drm[n].Mname.ToString() + "\",\"url\":\"#/" + drm[m].Murl.ToString() + "\",\"icon\":\"" + drm[n].Ico.ToString() + "\"},";
}
child_ch = child_ch.Substring(0, child_ch.Length - 1);
}
child += child_ch + "]},";
}
child = child.Substring(0, child.Length - 1);
}
json += child + "]}";
if (i != dr.Count() - 1)
{
json += ",";
}
}
}
json += "]";
}
else
{
res.data = "";
res.msg = "暂无数据";
res.code = System.Net.HttpStatusCode.OK;
res.success = false;
return(res);
}
if (!string.IsNullOrEmpty(json))
{
res.data = json;
res.msg = "获取成功";
res.code = System.Net.HttpStatusCode.OK;
res.success = true;
}
else
{
res.data = "";
res.msg = "暂无数据";
res.code = System.Net.HttpStatusCode.OK;
res.success = false;
}
return(res);
}
catch (Exception ex)
{
throw ex;
}
}