public MoveFormItemEntity FindOneItem(string formId, string itemId)
{
var sql = string.Format("select {0} from move_form_items where move_id = @p_move_id and id = @p_id", ITEM_COLUMNS);
var dc = Db.GetSqlStringCommand(sql);
Db.AddInParameter(dc, "p_move_id", DbType.String, formId);
Db.AddInParameter(dc, "p_id", DbType.String, itemId);
using (var reader = Db.ExecuteReader(dc))
{
if (reader.Read())
{
var entity = new MoveFormItemEntity();
entity.Init(reader);
return(entity);
}
}
return(null);
}
public List <MoveFormItemEntity> FindAllItems(string moveID)
{
var sql = string.Format("SELECT {0} FROM move_form_items WHERE move_id = @p_move_id", ITEM_COLUMNS);
var dc = Db.GetSqlStringCommand(sql);
Db.AddInParameter(dc, "p_move_id", DbType.String, moveID);
var list = new List <MoveFormItemEntity>();
using (var reader = Db.ExecuteReader(dc))
{
while (reader.Read())
{
var item = new MoveFormItemEntity();
item.Init(reader);
list.Add(item);
}
}
return(list);
}
public MoveFormItemEntity SaveItem(MoveFormItemEntity moveItem)
{
string sql = string.Empty;
if (string.IsNullOrEmpty(moveItem.Id))
{
sql = string.Format(@"insert into move_form_items({0}) values(
@p_id
,@p_move_id
,@p_form_no
,@p_product_id
,@p_count)", ITEM_COLUMNS);
moveItem.Id = Guid.NewGuid().ToString();
}
else
{
sql = @"update move_form_items set
move_id = @p_move_id
,form_no = @p_form_no
,product_id = @p_product_id
,count = @p_count
where id = @p_id";
}
DbCommand dc = Db.GetSqlStringCommand(sql);
Db.AddInParameter(dc, "p_id", DbType.String, moveItem.Id);
Db.AddInParameter(dc, "p_move_id", DbType.String, moveItem.MoveId);
Db.AddInParameter(dc, "p_form_no", DbType.Int32, moveItem.FormNo);
Db.AddInParameter(dc, "p_product_id", DbType.String, moveItem.ProductId);
Db.AddInParameter(dc, "p_count", DbType.Int32, moveItem.Count);
Db.ExecuteNonQuery(dc, DbTrans);
return(moveItem);
}
