public static async Task <int> InsertUserFilterRuleJobAsync(UserFilterRuleJob job)
{
string sql = @"INSERT INTO Configuration..tbl_UserFilterRuleJob
( JobName ,
CreateUser ,
ModifyUser ,
IsPreview ,
IsSubmit ,
JobStatus ,
PreviewStatus ,
ResultCount ,
CreateDateTime ,
LastUpdateDateTime ,
LastRunDateTime ,
Description
)
VALUES ( @JobName , -- JobName - nvarchar(100)
@CreateUser , -- CreateUser - nvarchar(100)
@ModifyUser , -- ModifyUser - nvarchar(100)
@IsPreview , -- IsPreview - bit
@IsSubmit , -- IsSubmit - bit
@JobStatus , -- JobStatus - nvarchar(100)
@PreviewStatus , -- PreviewStatus - nvarchar(100)
@ResultCount , -- ResultCount - int
GETDATE() , -- CreateDateTime - datetime
GETDATE() , -- LastUpdateDateTime - datetime
GETDATE() , -- LastRunDateTime - datetime
@Description -- Description - nvarchar(500)
);SELECT @@IDENTITY; ";
using (var dbhelper = DbHelper.CreateDbHelper(false))
{
using (var cmd = new SqlCommand(sql))
{
cmd.CommandType = CommandType.Text;
var props = job.GetType().GetProperties();
foreach (PropertyInfo prop in props)
{
object value = prop.GetValue(job);
if (prop.Name.Equals("PKID", StringComparison.OrdinalIgnoreCase) ||
prop.PropertyType == typeof(DateTime))
{
continue;
}
if (prop.PropertyType.IsEnum)
{
cmd.Parameters.Add(new SqlParameter(string.Concat("@", prop.Name), value.ToString()));
}
else
{
cmd.Parameters.Add(new SqlParameter(string.Concat("@", prop.Name), value));
}
}
var result = await dbhelper.ExecuteScalarAsync(cmd);
return(Convert.IsDBNull(result) ? 0 : Convert.ToInt32(result));
}
}
}
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 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 static async Task <int> InsertUserFilterRuleJobAsync(UserFilterRuleJob job)
{
var result = await Repository.UserFilterRule.InsertUserFilterRuleJobAsync(job);
return(result);
}
