public MoveFormSerialEntity SaveSerial(MoveFormSerialEntity moveSerial)
{
string sql = string.Empty;
if (string.IsNullOrEmpty(moveSerial.Id))
{
sql = string.Format(@"insert into move_form_serial({0}) values(
@p_id
,@p_move_id
,@p_form_no
,@p_product_id
,@p_from_serial
,@p_to_serial
,@p_count
,@p_package_count)", SERIAL_COLUMNS);
moveSerial.Id = Guid.NewGuid().ToString();
}
else
{
sql = @"update move_form_serial set
move_id = @p_move_id
,form_no = @p_form_no
,product_id = @p_product_id
,from_serial = @p_from_serial
,to_serial = @p_to_serial
,count = @p_count
,package_count = @p_package_count
where id = @p_id";
}
DbCommand dc = Db.GetSqlStringCommand(sql);
Db.AddInParameter(dc, "p_id", DbType.String, moveSerial.Id);
Db.AddInParameter(dc, "p_move_id", DbType.String, moveSerial.MoveId);
Db.AddInParameter(dc, "p_form_no", DbType.Int32, moveSerial.FormNo);
Db.AddInParameter(dc, "p_product_id", DbType.String, moveSerial.ProductId);
Db.AddInParameter(dc, "p_from_serial", DbType.String, moveSerial.FromSerial);
Db.AddInParameter(dc, "p_to_serial", DbType.String, moveSerial.ToSerial);
Db.AddInParameter(dc, "p_count", DbType.Int32, moveSerial.Count);
Db.AddInParameter(dc, "p_package_count", DbType.Int32, moveSerial.PackageCount);
Db.ExecuteNonQuery(dc, DbTrans);
return(moveSerial);
}
public MoveFormSerialEntity FindToSerial(string formId, string toSerial)
{
var sql = string.Format("select {0} from move_form_serial where move_id = @p_move_id and to_serial = @p_to_serial", SERIAL_COLUMNS);
var dc = Db.GetSqlStringCommand(sql);
Db.AddInParameter(dc, "p_move_id", DbType.String, formId);
Db.AddInParameter(dc, "p_to_serial", DbType.String, toSerial);
using (var reader = Db.ExecuteReader(dc))
{
if (reader.Read())
{
var entity = new MoveFormSerialEntity();
entity.Init(reader);
return(entity);
}
}
return(null);
}
public List <MoveFormSerialEntity> FindAllSerials(string moveID)
{
var sql = string.Format("SELECT {0} FROM move_form_serial WHERE move_id = @p_move_id", SERIAL_COLUMNS);
var dc = Db.GetSqlStringCommand(sql);
Db.AddInParameter(dc, "p_move_id", DbType.String, moveID);
var list = new List <MoveFormSerialEntity>();
using (var reader = Db.ExecuteReader(dc))
{
while (reader.Read())
{
var item = new MoveFormSerialEntity();
item.Init(reader);
list.Add(item);
}
}
return(list);
}
private IList <MoveFormSerialEntity> FindSerialByProduct(string formId, string productId)
{
var sql = string.Format("select {0} from move_form_serial where move_id = @p_move_id and product_id = @p_product_id", SERIAL_COLUMNS);
var dc = Db.GetSqlStringCommand(sql);
Db.AddInParameter(dc, "p_move_id", DbType.String, formId);
Db.AddInParameter(dc, "p_product_id", DbType.String, productId);
var list = new List <MoveFormSerialEntity>();
using (var reader = Db.ExecuteReader(dc))
{
if (reader.Read())
{
var entity = new MoveFormSerialEntity();
entity.Init(reader);
list.Add(entity);
}
}
return(list);
}
