public Result PutMaterialValuer([FromBody] MaterialValuer materialValuer)
{
if (materialValuer == null)
{
return(Result.GenError <Result>(Error.MaterialValuerNotExist));
}
if (materialValuer.Valuer.IsNullOrEmpty())
{
return(Result.GenError <Result>(Error.MaterialValuerNotEmpty));
}
var cnt =
ServerConfig.ApiDb.Query <int>("SELECT COUNT(1) FROM `material_valuer` WHERE Id = @id AND `MarkedDelete` = 0;",
new { id = materialValuer.Id }).FirstOrDefault();
if (cnt == 0)
{
return(Result.GenError <Result>(Error.MaterialValuerNotExist));
}
cnt =
ServerConfig.ApiDb.Query <int>("SELECT COUNT(1) FROM `material_valuer` WHERE Id != @id AND Valuer = @Valuer AND `MarkedDelete` = 0;",
new { id = materialValuer.Id, materialValuer.Valuer }).FirstOrDefault();
if (cnt > 0)
{
return(Result.GenError <Result>(Error.MaterialValuerIsExist));
}
var markedDateTime = DateTime.Now;
materialValuer.MarkedDateTime = markedDateTime;
MaterialValuerHelper.Instance.Update(materialValuer);
return(Result.GenError <Result>(Error.Success));
}
public Result PostMaterialValuer([FromBody] MaterialValuer materialValuer)
{
var cnt =
ServerConfig.ApiDb.Query <int>("SELECT COUNT(1) FROM `material_valuer` WHERE Valuer = @Valuer AND MarkedDelete = 0;",
new { materialValuer.Valuer }).FirstOrDefault();
if (cnt > 0)
{
return(Result.GenError <Result>(Error.MaterialValuerIsExist));
}
var markedDateTime = DateTime.Now;
materialValuer.MarkedDateTime = markedDateTime;
materialValuer.CreateUserId = Request.GetIdentityInformation();
MaterialValuerHelper.Instance.Add(materialValuer);
return(Result.GenError <Result>(Error.Success));
}
