public Result PutUsuallyFault([FromRoute] int id, [FromBody] UsuallyFault usuallyFault)
{
var data =
ServerConfig.ApiDb.Query <UsuallyFault>("SELECT * FROM `usually_fault` WHERE Id = @id AND MarkedDelete = 0;", new { id }).FirstOrDefault();
if (data == null)
{
return(Result.GenError <Result>(Error.UsuallyFaultNotExist));
}
var cnt =
ServerConfig.ApiDb.Query <int>("SELECT COUNT(1) FROM `usually_fault` WHERE UsuallyFaultDesc = @UsuallyFaultDesc AND MarkedDelete = 0;", new { usuallyFault.UsuallyFaultDesc }).FirstOrDefault();
if (cnt > 0)
{
if (!usuallyFault.UsuallyFaultDesc.IsNullOrEmpty() && data.UsuallyFaultDesc != usuallyFault.UsuallyFaultDesc)
{
return(Result.GenError <Result>(Error.UsuallyFaultIsExist));
}
}
usuallyFault.Id = id;
usuallyFault.CreateUserId = Request.GetIdentityInformation();
usuallyFault.MarkedDateTime = DateTime.Now;
ServerConfig.ApiDb.Execute(
"UPDATE usually_fault SET `MarkedDateTime` = @MarkedDateTime, `MarkedDelete` = @MarkedDelete, " +
"`ModifyId` = @ModifyId, `UsuallyFaultDesc` = @UsuallyFaultDesc, `SolvePlan` = @SolvePlan WHERE `Id` = @Id;", usuallyFault);
return(Result.GenError <Result>(Error.Success));
}
public Result PostUsuallyFault([FromBody] UsuallyFault usuallyFault)
{
usuallyFault.CreateUserId = Request.GetIdentityInformation();
usuallyFault.MarkedDateTime = DateTime.Now;
ServerConfig.RepairDb.Execute(
"INSERT INTO usually_fault (`CreateUserId`, `MarkedDateTime`, `MarkedDelete`, `ModifyId`, `UsuallyFaultDesc`, `SolverPlan`) " +
"VALUES (@CreateUserId, @MarkedDateTime, @MarkedDelete, @ModifyId, @UsuallyFaultDesc, @SolverPlan);",
usuallyFault);
return(Result.GenError <Result>(Error.Success));
}
public Result PostUsuallyFault([FromBody] UsuallyFault usuallyFault)
{
var cnt =
ServerConfig.ApiDb.Query <int>("SELECT COUNT(1) FROM `usually_fault` WHERE UsuallyFaultDesc = @UsuallyFaultDesc AND MarkedDelete = 0;", new { usuallyFault.UsuallyFaultDesc }).FirstOrDefault();
if (cnt > 0)
{
return(Result.GenError <Result>(Error.UsuallyFaultIsExist));
}
usuallyFault.CreateUserId = Request.GetIdentityInformation();
usuallyFault.MarkedDateTime = DateTime.Now;
ServerConfig.ApiDb.Execute(
"INSERT INTO usually_fault (`CreateUserId`, `MarkedDateTime`, `MarkedDelete`, `ModifyId`, `UsuallyFaultDesc`, `SolvePlan`) " +
"VALUES (@CreateUserId, @MarkedDateTime, @MarkedDelete, @ModifyId, @UsuallyFaultDesc, @SolvePlan);",
usuallyFault);
return(Result.GenError <Result>(Error.Success));
}
public Result PutUsuallyFault([FromRoute] int id, [FromBody] UsuallyFault usuallyFault)
{
var cnt =
ServerConfig.RepairDb.Query <int>("SELECT COUNT(1) FROM `usually_fault` WHERE Id = @id AND MarkedDelete = 0;", new { id }).FirstOrDefault();
if (cnt == 0)
{
return(Result.GenError <Result>(Error.UsuallyFaultNotExist));
}
usuallyFault.Id = id;
usuallyFault.CreateUserId = Request.GetIdentityInformation();
usuallyFault.MarkedDateTime = DateTime.Now;
ServerConfig.RepairDb.Execute(
"UPDATE usually_fault SET `Id` = @Id, `CreateUserId` = @CreateUserId, `MarkedDateTime` = @MarkedDateTime, `MarkedDelete` = @MarkedDelete, " +
"`ModifyId` = @ModifyId, `UsuallyFaultDesc` = @UsuallyFaultDesc, `SolverPlan` = @SolverPlan WHERE `Id` = @Id;", usuallyFault);
return(Result.GenError <Result>(Error.Success));
}
