public static IList <GoodsCheckEntity> Get(string hospitalId)
{
var sql = string.Format("select {0} from goods_check where hospital_id = @p_hospital_id and status = @p_status order by created_time desc", COLUMNS);
var db = DatabaseFactory.CreateDatabase();
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_hospital_id", DbType.String, hospitalId);
db.AddInParameter(dc, "p_status", DbType.String, GoodsCheckStatus.ACTIVE);
var list = new List <GoodsCheckEntity>();
using (var reader = db.ExecuteReader(dc))
{
while (reader.Read())
{
var entity = new GoodsCheckEntity();
entity.Init(reader);
list.Add(entity);
}
}
return(list);
}
public static void Save(GoodsCheckEntity entity)
{
entity.Id = Guid.NewGuid().ToString();
var sql = string.Format(@"insert into goods_check({0})
values(
@p_id, @p_name, @p_belong_to, @p_hospital_id, @p_status, @p_created_id, @p_created_time, @p_closer_id, @p_closed_time
)", COLUMNS);
var db = DatabaseFactory.CreateDatabase();
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_id", DbType.String, entity.Id);
db.AddInParameter(dc, "p_name", DbType.String, entity.Name);
db.AddInParameter(dc, "p_belong_to", DbType.String, entity.BelongTo);
db.AddInParameter(dc, "p_hospital_id", DbType.String, entity.HospitalId);
db.AddInParameter(dc, "p_status", DbType.String, entity.Status);
db.AddInParameter(dc, "p_created_id", DbType.String, entity.CreatedId);
db.AddInParameter(dc, "p_created_time", DbType.DateTime, entity.CreatedTime);
db.AddInParameter(dc, "p_closer_id", DbType.String, DBNull.Value);
db.AddInParameter(dc, "p_closed_time", DbType.DateTime, DBNull.Value);
db.ExecuteNonQuery(dc);
}
public static IList <GoodsCheckEntity> GetByHospitals(IList <string> hospitalIds)
{
var sql = string.Format("select {0} from goods_check where hospital_id in ('{1}') and status = @p_status order by hospital_id, name", COLUMNS, string.Join("','", hospitalIds));
var db = DatabaseFactory.CreateDatabase();
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_status", DbType.String, GoodsCheckStatus.ACTIVE);
var list = new List <GoodsCheckEntity>();
using (var reader = db.ExecuteReader(dc))
{
while (reader.Read())
{
var entity = new GoodsCheckEntity();
entity.Init(reader);
list.Add(entity);
}
}
return(list);
}
public void Save(GoodsCheckEntity entity)
{
GoodsCheckRepository.Save(entity);
}
