public Result PutManufactureTaskModule([FromBody] ManufactureTaskModule manufactureTaskModule)
{
if (manufactureTaskModule.Id == 0)
{
return(Result.GenError <Result>(Error.ManufactureTaskModuleNotExist));
}
var createUserId = Request.GetIdentityInformation();
var markedDateTime = DateTime.Now;
var manufactureTaskModuleOld =
ServerConfig.ApiDb.Query <ManufactureTaskModule>("SELECT * FROM `manufacture_task_module` WHERE Id = @Id AND MarkedDelete = 0;",
new { manufactureTaskModule.Id }).FirstOrDefault();
if (manufactureTaskModuleOld == null)
{
return(Result.GenError <Result>(Error.ManufactureTaskModuleNotExist));
}
manufactureTaskModule.Module = manufactureTaskModule.Module ?? manufactureTaskModuleOld.Module;
if (manufactureTaskModuleOld.Module != manufactureTaskModule.Module || manufactureTaskModuleOld.IsCheck != manufactureTaskModule.IsCheck)
{
manufactureTaskModule.MarkedDateTime = markedDateTime;
ServerConfig.ApiDb.Execute(
"UPDATE manufacture_task_module SET `MarkedDateTime` = @MarkedDateTime, `Module` = @Module, `IsCheck` = @IsCheck WHERE `Id` = @Id;", manufactureTaskModule);
}
return(Result.GenError <Result>(Error.Success));
}
public Result PostManufactureTaskModule([FromBody] ManufactureTaskModule manufactureTaskModule)
{
var cnt =
ServerConfig.ApiDb.Query <int>("SELECT COUNT(1) FROM `manufacture_task_module` WHERE `Module` = @Module AND MarkedDelete = 0;",
new { manufactureTaskModule.Module }).FirstOrDefault();
if (cnt > 0)
{
return(Result.GenError <Result>(Error.ManufactureTaskModuleIsExist));
}
var createUserId = Request.GetIdentityInformation();
var markedDateTime = DateTime.Now;
manufactureTaskModule.CreateUserId = createUserId;
manufactureTaskModule.MarkedDateTime = markedDateTime;
manufactureTaskModule.Module = manufactureTaskModule.Module ?? "";
ServerConfig.ApiDb.Execute("INSERT INTO manufacture_task_module (`CreateUserId`, `MarkedDateTime`, `Module`, `IsCheck`) VALUES (@CreateUserId, @MarkedDateTime, @Module, @IsCheck);", manufactureTaskModule);
return(Result.GenError <Result>(Error.Success));
}
