public static IList <CheckFormProductValidationEntity> GetProductsValidation(string formId)
{
var sql = @"
select
id,check_id,product_id,barcode,inv_storeroom_id,inv_is_standard,inv_count,
check_is_standard,check_count,status,adjust_type,created_id,created_time
from check_form_products_validation
where check_id=@p_check_id and status in (@p_storeroom_status, @p_count_status, @p_no_exist, @p_in_system) order by barcode";
var db = DatabaseFactory.CreateDatabase();
var cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "p_check_id", DbType.String, formId);
db.AddInParameter(cmd, "p_storeroom_status", DbType.String, CheckProductValidationStatus.Storeroom);
db.AddInParameter(cmd, "p_count_status", DbType.String, CheckProductValidationStatus.Count);
db.AddInParameter(cmd, "p_no_exist", DbType.String, CheckProductValidationStatus.NoExist);
db.AddInParameter(cmd, "p_in_system", DbType.String, CheckProductValidationStatus.InSystem);
var list = new List <CheckFormProductValidationEntity>();
using (var reader = db.ExecuteReader(cmd))
{
while (reader.Read())
{
var entity = new CheckFormProductValidationEntity();
entity.Init(reader);
list.Add(entity);
}
}
return(list);
}
private static void Create(CheckFormProductValidationEntity entity)
{
var sql = @"insert into check_form_products_validation
(
id,check_id,product_id,barcode,inv_storeroom_id,inv_is_standard,inv_count,
check_is_standard,check_count,status,created_id,created_time)
values
(
@p_id,@p_check_id,@p_product_id,@p_barcode,@p_inv_storeroom_id,@p_inv_is_standard,@p_inv_count,
@p_check_is_standard,@p_check_count,@p_status,@p_created_id,@p_created_time
)";
var db = DatabaseFactory.CreateDatabase();
var cmd = db.GetSqlStringCommand(sql);
entity.Id = Guid.NewGuid().ToString();
db.AddInParameter(cmd, "p_id", DbType.String, entity.Id);
db.AddInParameter(cmd, "p_check_id", DbType.String, entity.CheckId);
db.AddInParameter(cmd, "p_product_id", DbType.String, entity.ProductId);
db.AddInParameter(cmd, "p_barcode", DbType.String, entity.Barcode);
db.AddInParameter(cmd, "p_inv_storeroom_id", DbType.String, entity.InvStoreroomId);
db.AddInParameter(cmd, "p_inv_is_standard", DbType.Boolean, entity.InvIsStandard.HasValue ? (object)entity.InvIsStandard.Value : DBNull.Value);
db.AddInParameter(cmd, "p_inv_count", DbType.Int32, entity.InvCount.HasValue ? (object)entity.InvCount.Value : DBNull.Value);
db.AddInParameter(cmd, "p_check_is_standard", DbType.Boolean, entity.CheckIsStandard.HasValue ? (object)entity.CheckIsStandard.Value : DBNull.Value);
db.AddInParameter(cmd, "p_check_count", DbType.Int32, entity.CheckCount.HasValue ? (object)entity.CheckCount.Value : DBNull.Value);
db.AddInParameter(cmd, "p_status", DbType.String, entity.Status);
db.AddInParameter(cmd, "p_created_id", DbType.String, entity.CreatedId);
db.AddInParameter(cmd, "p_created_time", DbType.DateTime, entity.CreatedTime);
db.ExecuteNonQuery(cmd);
}
public static CheckFormProductValidationEntity GetProductValidation(string formId, string barcode)
{
var sql = @"
select
id,check_id,product_id,barcode,inv_storeroom_id,inv_is_standard,inv_count,
check_is_standard,check_count,status,adjust_type,created_id,created_time
from check_form_products_validation
where check_id=@p_check_id and barcode=@p_barcode";
var db = DatabaseFactory.CreateDatabase();
var cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "p_check_id", DbType.String, formId);
db.AddInParameter(cmd, "p_barcode", DbType.String, barcode);
using (var reader = db.ExecuteReader(cmd))
{
if (reader.Read())
{
var entity = new CheckFormProductValidationEntity();
entity.Init(reader);
return(entity);
}
}
return(null);
}
public static void SaveProductValidation(CheckFormProductValidationEntity entity)
{
if (string.IsNullOrEmpty(entity.Id))
{
Create(entity);
}
else
{
Update(entity);
}
}
private static void Update(CheckFormProductValidationEntity entity)
{
var sql = @"update check_form_products_validation set
check_is_standard=@p_check_is_standard,check_count=@p_check_count,status=@p_status,
created_id=@p_created_id,created_time=@p_created_time
where id=@p_id";
var db = DatabaseFactory.CreateDatabase();
var cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "p_id", DbType.String, entity.Id);
db.AddInParameter(cmd, "p_check_is_standard", DbType.Boolean, entity.CheckIsStandard);
db.AddInParameter(cmd, "p_check_count", DbType.Int32, entity.CheckCount);
db.AddInParameter(cmd, "p_status", DbType.String, entity.Status);
db.AddInParameter(cmd, "p_created_id", DbType.String, entity.CreatedId);
db.AddInParameter(cmd, "p_created_time", DbType.DateTime, entity.CreatedTime);
db.ExecuteNonQuery(cmd);
}
public void SaveProductValidation(CheckFormProductValidationEntity entity)
{
CheckFormRepository.SaveProductValidation(entity);
}