public async Task <ActionResult> EditUserFilterRule(int?jobid)
{
if (!jobid.HasValue)
{
var temp = new UserFilterRuleJob()
{
JobName = "会员筛选任务",
JobStatus = JobStatus.Created,
Description = "会员筛选任务",
CreateUser = CurrentUser.Name,
ModifyUser = CurrentUser.Name,
PreviewStatus = PreviewStatus.Created
};
var pkid = await UserFilterService.InsertUserFilterRuleJobAsync(temp);
return(RedirectToAction("EditUserFilterRule", new { jobid = pkid }));
}
var configs = await UserFilterService.SelectAllUserFilterValueConfigAsync();
var job = await Service.UserFilterService.SelectUserFilterRuleJobsAsync(jobid.Value);
ViewBag.configs = configs;
ViewBag.job = job;
ViewBag.jobid = jobid.Value;
return(View());
}
public void SubmitJobTest()
{
int jobid = 9;
var result = UserFilterService.SetFilterJobRunAsync(jobid).GetAwaiter().GetResult();
Assert.IsTrue(result);
}
public async Task <JsonResult> SubmitUserFilterResultConfigAsync(string basecategory, string tablename, string colname, int jobid, bool ischecked)
{
JsonResult jr = new JsonResult();
if (ischecked)
{
var count = await UserFilterService.SelectUserFilterResultConfigCountAsync(jobid);
if (count >= 6)
{
jr.Data = new { code = 0, msg = "筛选结果字段不能大于6个" };
return(jr);
}
}
var config = new UserFilterResultConfig()
{
BasicAttribute = basecategory,
ColName = colname,
TableName = tablename,
JobId = jobid
};
var result = await UserFilterService.InsertOrUpdateUserFilterResultConfigAsync(config);
jr.Data = new { code = 1, msg = "保存成功", data = result };
return(jr);
}
public async Task <JsonResult> SelectUserFilterResultConfigAsync(int jobid)
{
JsonResult jr = new JsonResult()
{
JsonRequestBehavior = JsonRequestBehavior.AllowGet
};
var result = await UserFilterService.SelectUserFilterResultConfigAsync(jobid);
if (result != null && result.Any())
{
var datas = result.Select(x => new
{
x.ColName,
x.BasicAttribute,
x.JobId,
x.PKID,
x.TableName,
TableColName = GetTableColName(x.BasicAttribute, x.ColName)
}).ToList();
jr.Data = new { code = 1, msg = "", data = datas };
return(jr);
}
jr.Data = new { code = 1, msg = "", data = result };
return(jr);
}
public async Task <JsonResult> SaveJobDescriptionAsync(int jobid, string description)
{
JsonResult jr = new JsonResult();
var result = await UserFilterService.SaveJobDescriptionAsync(jobid, description);
jr.Data = new { code = 1, msg = "保存成功", data = result };
return(jr);
}
public async Task <JsonResult> DeleteFilterRuleJobDetailAsync(string batchid)
{
JsonResult jr = new JsonResult();
var result = await UserFilterService.DeleteFilterRuleJobDetailAsync(batchid);
jr.Data = new { code = result > 0 ? 1 : 0, msg = result > 0 ? "删除成功" : "删除失败.." };
return(jr);
}
public async Task <JsonResult> SetJobStartRunAsync(int jobid, string forceupdate = null)
{
JsonResult jr = new JsonResult()
{
JsonRequestBehavior = JsonRequestBehavior.AllowGet
};
var job = await Service.UserFilterService.SelectUserFilterRuleJobsAsync(jobid);
if (job.JobStatus == JobStatus.Created || string.Equals(forceupdate, "forceupdate"))
{
var result = await UserFilterService.SaveJobRunStatusAsync(jobid, JobStatus.WaittingForRun);
jr.Data = result ? new { code = 1, msg = "提交成功" } : new { code = 0, msg = "提交失败" };
}
else
{
jr.Data = new { code = 0, msg = "该job已经开始执行或等待执行" };
}
return(jr);
}
public async Task <ActionResult> SelectFilterRuleOutResult(int?jobid)
{
if (!jobid.HasValue)
{
var job = new UserFilterRuleJob()
{
JobName = "会员筛选任务",
JobStatus = JobStatus.Created,
Description = "会员筛选任务",
CreateUser = CurrentUser.Name,
ModifyUser = CurrentUser.Name,
PreviewStatus = PreviewStatus.Created
};
var pkid = await UserFilterService.InsertUserFilterRuleJobAsync(job);
return(RedirectToAction("SelectFilterRuleOutResult", new { jobid = pkid }));
}
var userselectconfigs = await UserFilterService.SelectUserFilterResultConfigAsync(jobid.Value);
ViewBag.userselectconfigs = userselectconfigs;
ViewData["jobid"] = jobid.Value;
return(View());
}
public async Task <ContentResult> SelectUserFilterValueConfigsAsync(string type, string value)
{
IEnumerable <UserFilterValueConfig> data = new List <UserFilterValueConfig>();
if (type == "colname")
{
data = await UserFilterService.SelectUserFilterValueConfigByColNameAsync(value);
}
if (type == "parentvalue")
{
data = await UserFilterService.SelectUserFilterValueConfigByParentValueAsync(value);
}
var serializer = new JavaScriptSerializer {
MaxJsonLength = Int32.MaxValue
};
var result = new ContentResult
{
Content = serializer.Serialize(data),
ContentType = "application/json"
};
return(result);
}
