public static IList <AuditingProductEntity> Query(string hospitalId, string vendorId, DateTime applyTime)
{
var sql = string.Format(@"select {0} from auditing_products
where hospital_id=@p_hospital_id and vendor_id=@p_vendor_id
and created_time <= @p_apply_time and is_audit=1
order by product_id, version desc", COLUMN_SQL);
var db = DatabaseFactory.CreateDatabase();
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_hospital_id", DbType.String, hospitalId);
db.AddInParameter(dc, "p_vendor_id", DbType.String, vendorId);
db.AddInParameter(dc, "p_apply_time", DbType.DateTime, applyTime);
var list = new List <AuditingProductEntity>();
using (var reader = db.ExecuteReader(dc))
{
while (reader.Read())
{
var entity = new AuditingProductEntity();
entity.Init(reader);
list.Add(entity);
}
}
return(list);
}
public JsonNetResult SaveAuditingProduct(AuditingProductEntity entity)
{
try
{
new AuditingProductService().Save(entity);
return(JsonNet(new ResponseResult()));
}
catch (Exception e)
{
return(JsonNet(new ResponseResult(false, e)));
}
}
public static void Save(AuditingProductEntity entity)
{
var sql = string.Format(@"insert into auditing_products({0})
values(@p_id,@p_hospital_id,@p_vendor_id,@p_product_id,@p_is_audit,
@p_version,@p_created_id,@p_created_time,@p_updated_id,@p_updated_time)", COLUMN_SQL);
entity.Id = Guid.NewGuid().ToString();
var db = DatabaseFactory.CreateDatabase();
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_id", DbType.String, entity.Id);
db.AddInParameter(dc, "p_hospital_id", DbType.String, entity.HospitalId);
db.AddInParameter(dc, "p_vendor_id", DbType.String, entity.VendorId);
db.AddInParameter(dc, "p_product_id", DbType.String, entity.ProductId);
db.AddInParameter(dc, "p_is_audit", DbType.Boolean, entity.IsAudit);
db.AddInParameter(dc, "p_version", DbType.Int32, entity.Version);
db.AddInParameter(dc, "p_created_id", DbType.String, entity.CreatedId);
db.AddInParameter(dc, "p_created_time", DbType.DateTime, entity.CreatedTime);
db.AddInParameter(dc, "p_updated_id", DbType.String, entity.UpdatedId);
db.AddInParameter(dc, "p_updated_time", DbType.DateTime, entity.UpdatedTime);
db.ExecuteNonQuery(dc);
}
public void Save(AuditingProductEntity entity)
{
AuditingProductRepository.Save(entity);
}
