public static string Create(GoodsExtraEntity goodsExtra, Database db, DbTransaction trans)
{
var sql = string.Format(@"
insert into goods_extra(
{0}
)
values(
@p_id, @p_need_check, @p_need_split, @p_split_capacity, @p_mini_split_number, @p_valid_days, @p_expired_date, @p_split_copies, @p_split_unit
)", COLUMN_SQL);
var dc = db.GetSqlStringCommand(sql);
var id = Guid.NewGuid().ToString();
db.AddInParameter(dc, "p_id", DbType.String, id);
db.AddInParameter(dc, "p_need_check", DbType.Boolean, goodsExtra.NeedCheck);
db.AddInParameter(dc, "p_need_split", DbType.Boolean, goodsExtra.NeedSplit);
db.AddInParameter(dc, "p_split_capacity", DbType.String, goodsExtra.SplitCapacity);
db.AddInParameter(dc, "p_mini_split_number", DbType.Int32, goodsExtra.MiniSplitNumber);
db.AddInParameter(dc, "p_valid_days", DbType.Decimal, goodsExtra.ValidDays);
db.AddInParameter(dc, "p_expired_date", DbType.DateTime, goodsExtra.ExpiredDate);
db.AddInParameter(dc, "p_split_copies", DbType.Int32, goodsExtra.SplitCopies);
db.AddInParameter(dc, "p_split_unit", DbType.String, goodsExtra.SplitUnit);
db.ExecuteNonQuery(dc, trans);
return(id);
}
public static void Create(string incomingId, GoodsEntity goods, GoodsExtraEntity goodsExtra, int goodsCount, string userId, Database db, DbTransaction trans)
{
goods.SerialId = GoodsExtraRepsitory.Create(goodsExtra, db, trans);
Create(incomingId, goods, userId, db, trans);
GoodsInventoryRepository.AddOriginalCount(goods.ProductId, goods.HospitalId, goodsCount, db, trans);
if (!goodsExtra.NeedSplit)
{
GoodsInventoryRepository.AddUsableCount(goods.ProductId, goods.HospitalId, goodsCount, db, trans);
}
}
public static GoodsExtraEntity Get(string id)
{
var sql = string.Format("select {0} from goods_extra where id=@p_id", COLUMN_SQL);
var db = DatabaseFactory.CreateDatabase();
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_id", DbType.String, id);
using (var reader = db.ExecuteReader(dc))
{
if (reader.Read())
{
var entity = new GoodsExtraEntity();
entity.Init(reader);
return(entity);
}
}
return(null);
}
