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