public static IList <CheckFormProductEntity> GetHandleCheckProducts(string formId, string userId)
{
var sql = @"
select
id,check_id,category,product_id,inv_standard_count,inv_using_package_count,
check_standard_count,check_using_package_count,status,
operator_id,operated_time,check_over,created_id,created_time
from check_form_products where check_id=@check_id and status=@p_status and operator_id=@p_user_id";
var db = DatabaseFactory.CreateDatabase();
var cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "check_id", DbType.String, formId);
db.AddInParameter(cmd, "p_status", DbType.String, CheckProductStatus.Handle);
db.AddInParameter(cmd, "p_user_id", DbType.String, userId);
var list = new List <CheckFormProductEntity>();
using (var reader = db.ExecuteReader(cmd))
{
while (reader.Read())
{
var entity = new CheckFormProductEntity();
entity.Init(reader);
list.Add(entity);
}
}
return(list);
}
public static CheckFormProductEntity GetCheckProduct(string formId, string productId)
{
var sql = @"
select
id,check_id,category,product_id,inv_standard_count,inv_using_package_count,
check_standard_count,check_using_package_count,status,
operator_id,operated_time,check_over,created_id,created_time
from check_form_products where check_id=@check_id and product_id=@p_product_id";
var db = DatabaseFactory.CreateDatabase();
var cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "check_id", DbType.String, formId);
db.AddInParameter(cmd, "p_product_id", DbType.String, productId);
var list = new List <CheckFormProductEntity>();
using (var reader = db.ExecuteReader(cmd))
{
if (reader.Read())
{
var entity = new CheckFormProductEntity();
entity.Init(reader);
return(entity);
}
}
return(null);
}
private static void UpdateCheckProduct(CheckFormProductEntity checkProduct, Database db, DbTransaction trans)
{
var sql = @"update check_form_products
set check_standard_count=@p_standard_count,check_using_package_count=@p_package_count,
operator_id=@p_operator_id,operated_time=@p_operated_time
where id=@p_id and check_over=@p_check_over";
var cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "p_id", DbType.String, checkProduct.Id);
db.AddInParameter(cmd, "p_standard_count", DbType.Int32, checkProduct.CheckStandardCount);
db.AddInParameter(cmd, "p_package_count", DbType.Int32, checkProduct.CheckUsingPackageCount);
db.AddInParameter(cmd, "p_operator_id", DbType.String, checkProduct.OperatorId);
db.AddInParameter(cmd, "p_operated_time", DbType.DateTime, checkProduct.OperatedTime);
db.AddInParameter(cmd, "p_check_over", DbType.Boolean, false);
db.ExecuteNonQuery(cmd, trans);
}
