public static GoodsSerialEntity GetByBarcode(string barcode) { var sql = @"select a.id,a.serial_no,a.parent_id,a.product_id,a.dispatched_count,a.hospital_id,a.vendor_id,a.need_audit,a.need_check,a.need_split, a.split_copies,a.split_unit,a.valid_days,a.batch_no,a.expired_date,a.split_capacity,a.split_package_count, a.logistics_code,a.logistics_content,a.is_closed,a.created_id,a.created_time,a.updated_id,a.updated_time from goods_serial a join goods_serial_barcodes b on a.id=b.serial_id and b.out=@p_out where b.barcode=@p_barcode"; var db = DatabaseFactory.CreateDatabase(); var cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "p_barcode", DbType.String, barcode); db.AddInParameter(cmd, "p_out", DbType.Boolean, false); using (var reader = db.ExecuteReader(cmd)) { if (reader.Read()) { var entity = new GoodsSerialEntity(); entity.Init(reader); return(entity); } return(null); } }
public static GoodsSerialEntity Get(string serialId, Database db, DbTransaction trans) { var sql = string.Format("select {0} from goods_serial where id=@p_id", COLUMNS); var cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "p_id", DbType.String, serialId); using (var reader = db.ExecuteReader(cmd, trans)) { if (reader.Read()) { var entity = new GoodsSerialEntity(); entity.Init(reader); return(entity); } } return(null); }
public static IList <GoodsSerialEntity> GetSplitSerials(IList <string> serialIds) { var list = new List <GoodsSerialEntity>(); if (serialIds == null || serialIds.Count == 0) { return(list); } IList <string> names; string namesSql; StringHelper.GenerInParameters("p_id", serialIds.Count, out names, out namesSql); var sql = string.Format("select {0} from goods_serial where id in ({1}) and need_split=@p_need_split", COLUMNS, namesSql); var db = DatabaseFactory.CreateDatabase(); var cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "p_need_split", DbType.Boolean, true); for (var i = 0; i < serialIds.Count; i++) { db.AddInParameter(cmd, names[i], DbType.String, serialIds[i]); } using (var reader = db.ExecuteReader(cmd)) { while (reader.Read()) { var entity = new GoodsSerialEntity(); entity.Init(reader); list.Add(entity); } } return(list); }
private static IList <GoodsSerialEntity> GetSubSerials(string parentId) { var sql = string.Format("select {0} from goods_serial where parent_id=@p_parent_id", COLUMNS); var db = DatabaseFactory.CreateDatabase(); var cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "p_parent_id", DbType.String, parentId); var list = new List <GoodsSerialEntity>(); using (var reader = db.ExecuteReader(cmd)) { if (reader.Read()) { var entity = new GoodsSerialEntity(); entity.Init(reader); list.Add(entity); } } return(list); }