public int SetShopItem(ShopItem item) { return JaneShopItemsDao.SetShopItem(item); }
internal static int SetShopItem(ShopItem item) { if (item == null) return -1; SafeProcedure.ExecuteNonQuery( Database.GetDatabase(JaneDefine.DBInstanceName), "dbo.Shop_items_Set", delegate(IParameterSet parameters) { parameters.AddWithValue("@Id", item.Id); parameters.AddWithValue("@name", item.Name); parameters.AddWithValue("@description", item.Description); parameters.AddWithValue("@body", item.Body); parameters.AddWithValue("@price", item.Price); parameters.AddWithValue("@SImage", item.SImage); parameters.AddWithValue("@LImage", item.LImage); parameters.AddWithValue("@PublishDate", item.PublishDate); parameters.AddWithValue("@AddUserId", item.AddUserID); parameters.AddWithValue("@Status", (int)(item.Status)); parameters.AddWithValue("@Hits", (int)(item.Hits)); parameters.AddWithValue("@BaseCountEachdeliver", (int)(item.BaseCountEachdeliver)); parameters.AddWithValue("@Weight", item.Weight); parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue); }, delegate(IParameterSet outputParameters) { item.Id = Convert.ToInt32(outputParameters.GetValue("@RetVal")); }); return item.Id; }
internal static ShopItem GetShopItem(int id, int hits) { ShopItem m = new ShopItem(id); if (id > 0) { SafeProcedure.ExecuteAndMapRecords( Database.GetDatabase(JaneDefine.DBInstanceName), "dbo.Shop_items_Get", delegate(IRecord record) { m.Id = record.GetInt32OrDefault(0, 0); m.Name = record.GetStringOrEmpty(1); m.Description = record.GetStringOrEmpty(2); m.Price = record.GetDouble(3); m.SImage = record.GetStringOrEmpty(4); m.LImage = record.GetStringOrEmpty(5); m.PublishDate = record.GetDateTimeOrEmpty(6); m.AddUserID = record.GetInt32OrDefault(7, 0); m.AddDate = record.GetDateTime(8); m.Status = (PublishStatus)(record.GetInt32OrDefault(9, 0)); m.Body = record.GetStringOrEmpty(10); m.Hits = record.GetInt32OrDefault(11,0); m.BaseCountEachdeliver = record.GetInt32OrDefault(12, 5); m.Weight = record.GetDouble(13); }, id, hits); } return m; }
internal static void MapList(IRecord record, List<ShopItem> list) { ShopItem m = new ShopItem(); m.Id = record.GetInt32OrDefault(0, 0); m.Name = record.GetStringOrEmpty(1); m.Description = record.GetStringOrEmpty(2); m.Price = record.GetDouble(3); m.SImage = record.GetStringOrEmpty(4); m.LImage = record.GetStringOrEmpty(5); m.PublishDate = record.GetDateTimeOrEmpty(6); m.AddUserID = record.GetInt32OrDefault(7, 0); m.AddDate = record.GetDateTime(8); m.Status = (PublishStatus)(record.GetInt32OrDefault(9, 0)); m.Body = record.GetStringOrEmpty(10); m.Hits = record.GetInt32OrDefault(11, 0); m.BaseCountEachdeliver = record.GetInt32OrDefault(12, 5); m.Weight = record.GetDouble(13); list.Add(m); }