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