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);
}
