public static IList <GoodsSerialBarcodeEntity> GetBarcodes(string serialId) { var sql = "select id,serial_id,barcode,is_printed,out from goods_serial_barcodes where serial_id=@p_serial_id and out=@p_out order by barcode"; var db = DatabaseFactory.CreateDatabase(); var cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "p_serial_id", DbType.String, serialId); db.AddInParameter(cmd, "p_out", DbType.Boolean, false); var list = new List <GoodsSerialBarcodeEntity>(); using (var reader = db.ExecuteReader(cmd)) { while (reader.Read()) { var entity = new GoodsSerialBarcodeEntity(); entity.Init(reader); list.Add(entity); } } return(list); }
public static IList <GoodsSerialBarcodeEntity> GetBarcodes(IList <string> serialIds, bool includeOut = false) { var list = new List <GoodsSerialBarcodeEntity>(); if (serialIds.Count == 0) { return(list); } string sqlIds; IList <string> names; StringHelper.GenerInParameters("p_serial_", serialIds.Count, out names, out sqlIds); var sql = string.Format("select id,serial_id,barcode,is_printed,out from goods_serial_barcodes where serial_id in ({0})", sqlIds); if (!includeOut) { sql += " and out=@p_out"; } var db = DatabaseFactory.CreateDatabase(); var cmd = db.GetSqlStringCommand(sql); for (var i = 0; i < names.Count; i++) { db.AddInParameter(cmd, names[i], DbType.String, serialIds[i]); } if (!includeOut) { db.AddInParameter(cmd, "p_out", DbType.Boolean, false); } using (var reader = db.ExecuteReader(cmd)) { while (reader.Read()) { var entity = new GoodsSerialBarcodeEntity(); entity.Init(reader); list.Add(entity); } } return(list); }
public static IList <GoodsSerialBarcodeEntity> GetBarcodesByRoot(string serialId) { var ids = GetSubSerials(serialId).Select(item => item.Id).ToList(); ids.Add(serialId); IList <string> names; string namesSql; StringHelper.GenerInParameters("p_serial_id", ids.Count, out names, out namesSql); var sql = string.Format("select id,serial_id,barcode,is_printed,out from goods_serial_barcodes where serial_id in ({0}) and out=@p_out order by barcode", namesSql); var db = DatabaseFactory.CreateDatabase(); var cmd = db.GetSqlStringCommand(sql); for (var i = 0; i < names.Count; i++) { db.AddInParameter(cmd, names[i], DbType.String, ids[i]); } db.AddInParameter(cmd, "p_out", DbType.Boolean, false); var list = new List <GoodsSerialBarcodeEntity>(); using (var reader = db.ExecuteReader(cmd)) { while (reader.Read()) { var entity = new GoodsSerialBarcodeEntity(); entity.Init(reader); list.Add(entity); } } return(list); }