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