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); }