protected void btnUpdate_Click(object sender, EventArgs e) { int num; GiftInfo entity = new GiftInfo(); if (!int.TryParse(txtNeedPoint.Text.Trim(), out num)) { ShowMsg("兑换所需积分不能为空,大小0-10000之间", false); } else { entity.GiftId = Id; entity.NeedPoint = num; entity.Name = txtGiftName.Text.Trim(); entity.Title = txtGiftTitle.Text.Trim(); entity.Meta_Description = txtTitleDescription.Text.Trim(); entity.Meta_Keywords = txtTitleKeywords.Text.Trim(); Globals.EntityCoding(entity, false); if (SubsiteGiftHelper.UpdateMyGifts(entity)) { ShowMsg("成功修改了一件礼品的基本信息", true); } else { ShowMsg("修改件礼品的基本信息失败", true); } } }
public override bool AddOrderGift(string orderId, GiftInfo gift, int quantity, DbTransaction dbTran) { DbCommand sqlStringCommand = database.GetSqlStringCommand("select * from distro_OrderGifts where OrderId=@OrderId AND GiftId=@GiftId"); database.AddInParameter(sqlStringCommand, "OrderId", DbType.String, orderId); database.AddInParameter(sqlStringCommand, "GiftId", DbType.Int32, gift.GiftId); using (IDataReader reader = database.ExecuteReader(sqlStringCommand)) { while (reader.Read()) { DbCommand command2 = database.GetSqlStringCommand("update distro_OrderGifts set Quantity=@Quantity where OrderId=@OrderId AND GiftId=@GiftId"); database.AddInParameter(command2, "OrderId", DbType.String, orderId); database.AddInParameter(command2, "GiftId", DbType.Int32, gift.GiftId); database.AddInParameter(command2, "Quantity", DbType.Int32, ((int)reader["Quantity"]) + quantity); if (dbTran != null) { return (database.ExecuteNonQuery(command2, dbTran) == 1); } return (database.ExecuteNonQuery(command2) == 1); } DbCommand command = database.GetSqlStringCommand("INSERT INTO distro_OrderGifts(OrderId,GiftId,DistributorUserId,GiftName,CostPrice,ThumbnailsUrl,Quantity) VALUES(@OrderId,@GiftId,@DistributorUserId,@GiftName,@CostPrice,@ThumbnailsUrl,@Quantity)"); database.AddInParameter(command, "OrderId", DbType.String, orderId); database.AddInParameter(command, "GiftId", DbType.Int32, gift.GiftId); database.AddInParameter(command, "DistributorUserId", DbType.Int32, HiContext.Current.User.UserId); database.AddInParameter(command, "GiftName", DbType.String, gift.Name); database.AddInParameter(command, "CostPrice", DbType.Currency, gift.PurchasePrice); database.AddInParameter(command, "ThumbnailsUrl", DbType.String, gift.ThumbnailUrl40); database.AddInParameter(command, "Quantity", DbType.Int32, quantity); if (dbTran != null) { return (database.ExecuteNonQuery(command, dbTran) == 1); } return (database.ExecuteNonQuery(command) == 1); } }
public static bool DeleteGift(int giftId) { GiftInfo info2 = new GiftInfo(); info2.GiftId = giftId; GiftInfo gift = info2; return (PromotionsProvider.Instance().CreateUpdateDeleteGift(gift, DataProviderAction.Delete) == GiftActionStatus.Success); }
public static bool AddOrderGift(OrderInfo order, GiftInfo gift, int quantity) { bool flag; using (DbConnection connection = DatabaseFactory.CreateDatabase().CreateConnection()) { connection.Open(); DbTransaction dbTran = connection.BeginTransaction(); try { if (!SubsiteSalesProvider.Instance().AddOrderGift(order.OrderId, gift, quantity, dbTran)) { dbTran.Rollback(); return false; } bool flag2 = false; foreach (OrderGiftInfo info in order.Gifts) { if (info.GiftId == gift.GiftId) { flag2 = true; info.Quantity += quantity; } } if (!flag2) { OrderGiftInfo item = new OrderGiftInfo(); item.GiftId = gift.GiftId; item.OrderId = order.OrderId; item.GiftName = gift.Name; item.Quantity = quantity; item.CostPrice = gift.PurchasePrice; item.ThumbnailsUrl = gift.ThumbnailUrl40; order.Gifts.Add(item); } if (!SubsiteSalesProvider.Instance().UpdateOrderAmount(order, dbTran)) { dbTran.Rollback(); return false; } dbTran.Commit(); flag = true; } catch { dbTran.Rollback(); flag = false; } finally { connection.Close(); } } return flag; }
void LoadPageSearch(GiftInfo gift) { if (!string.IsNullOrEmpty(gift.Meta_Keywords)) { MetaTags.AddMetaKeywords(gift.Meta_Keywords, HiContext.Current.Context); } if (!string.IsNullOrEmpty(gift.Meta_Description)) { MetaTags.AddMetaDescription(gift.Meta_Description, HiContext.Current.Context); } if (!string.IsNullOrEmpty(gift.Title)) { PageTitle.AddTitle(gift.Title, HiContext.Current.Context); } else { PageTitle.AddTitle(gift.Name, HiContext.Current.Context); } }
public abstract GiftActionStatus CreateUpdateDeleteGift(GiftInfo gift, DataProviderAction action);
public static GiftActionStatus UpdateGift(GiftInfo gift) { Globals.EntityCoding(gift, true); return PromotionsProvider.Instance().CreateUpdateDeleteGift(gift, DataProviderAction.Update); }
public override GiftInfo GetMyGiftsDetails(int Id) { GiftInfo entity = new GiftInfo(); DbCommand sqlStringCommand = database.GetSqlStringCommand("select d_Name as [Name],d_Title as Title,d_Meta_Description as Meta_Description,d_Meta_Keywords as Meta_Keywords,d_NeedPoint as NeedPoint,GiftId,ShortDescription,Unit, LongDescription,CostPrice,ImageUrl, ThumbnailUrl40,ThumbnailUrl60,ThumbnailUrl100,ThumbnailUrl160, ThumbnailUrl180, ThumbnailUrl220, ThumbnailUrl310, ThumbnailUrl410, PurchasePrice,MarketPrice,IsDownLoad from vw_distro_Gifts where d_DistributorUserId=@DistributorUserId and GiftId=@Id"); database.AddInParameter(sqlStringCommand, "DistributorUserId", DbType.Int32, HiContext.Current.User.UserId); database.AddInParameter(sqlStringCommand, "Id", DbType.Int32, Id); using (IDataReader reader = database.ExecuteReader(sqlStringCommand)) { if (reader.Read()) { entity = DataMapper.PopulateGift(reader); } } Globals.EntityCoding(entity, false); return entity; }
public static bool DownLoadGift(GiftInfo giftInfo) { return SubsitePromotionsProvider.Instance().DownLoadGift(giftInfo); }
public override bool UpdateMyGifts(GiftInfo giftInfo) { DbCommand sqlStringCommand = database.GetSqlStringCommand("update distro_Gifts set [Name]=@Name,ShortDescription=@ShortDescription,Title=@Title,Meta_Description=@Meta_Description,Meta_Keywords=@Meta_Keywords,NeedPoint=@NeedPoint where GiftId=@Id and DistributorUserId=@DistributorUserId"); database.AddInParameter(sqlStringCommand, "Name", DbType.String, giftInfo.Name); database.AddInParameter(sqlStringCommand, "ShortDescription", DbType.String, giftInfo.ShortDescription); database.AddInParameter(sqlStringCommand, "Title", DbType.String, giftInfo.Title); database.AddInParameter(sqlStringCommand, "Meta_Description", DbType.String, giftInfo.Meta_Description); database.AddInParameter(sqlStringCommand, "Meta_Keywords", DbType.String, giftInfo.Meta_Keywords); database.AddInParameter(sqlStringCommand, "NeedPoint", DbType.Int32, giftInfo.NeedPoint); database.AddInParameter(sqlStringCommand, "Id", DbType.Int32, giftInfo.GiftId); database.AddInParameter(sqlStringCommand, "DistributorUserId", DbType.Int32, HiContext.Current.User.UserId); return (database.ExecuteNonQuery(sqlStringCommand) >= 1); }
public abstract bool DownLoadGift(GiftInfo giftinfo);
public abstract bool UpdateMyGifts(GiftInfo giftInfo);
public static bool UpdateMyGifts(GiftInfo giftInfo) { return SubsitePromotionsProvider.Instance().UpdateMyGifts(giftInfo); }
public static bool AddOrderGift(OrderInfo order, GiftInfo giftinfo, int quantity) { bool flag; ManagerHelper.CheckPrivilege(Privilege.EditOrders); using (DbConnection connection = DatabaseFactory.CreateDatabase().CreateConnection()) { connection.Open(); DbTransaction dbTran = connection.BeginTransaction(); try { SalesProvider provider = SalesProvider.Instance(); OrderGiftInfo item = new OrderGiftInfo(); item.OrderId = order.OrderId; item.Quantity = quantity; item.GiftName = giftinfo.Name; decimal costPrice = item.CostPrice; item.CostPrice = Convert.ToDecimal(giftinfo.CostPrice); item.GiftId = giftinfo.GiftId; item.ThumbnailsUrl = giftinfo.ThumbnailUrl40; bool flag2 = false; foreach (OrderGiftInfo info2 in order.Gifts) { if (giftinfo.GiftId == info2.GiftId) { flag2 = true; info2.Quantity = quantity; break; } } if (!flag2) { order.Gifts.Add(item); } if (!provider.AddOrderGift(order.OrderId, item, quantity, dbTran)) { dbTran.Rollback(); return false; } if (!provider.UpdateOrderAmount(order, dbTran)) { dbTran.Rollback(); return false; } dbTran.Commit(); flag = true; } catch { dbTran.Rollback(); flag = false; } finally { connection.Close(); } } if (flag) { EventLogs.WriteOperationLog(Privilege.EditOrders, string.Format(CultureInfo.InvariantCulture, "成功的为订单号为\"{0}\"的订单添加了礼品", new object[] { order.OrderId })); } return flag; }
public override bool DownLoadGift(GiftInfo gift) { DbCommand sqlStringCommand = database.GetSqlStringCommand("insert into distro_Gifts VALUES (@GiftId,@DistributorUserId,@Name,@ShortDescription,@Title,@Meta_Description,@Meta_Keywords,@NeedPoint)"); database.AddInParameter(sqlStringCommand, "GiftId", DbType.Int32, gift.GiftId); database.AddInParameter(sqlStringCommand, "DistributorUserId", DbType.Int32, HiContext.Current.User.UserId); database.AddInParameter(sqlStringCommand, "Name", DbType.String, gift.Name); database.AddInParameter(sqlStringCommand, "ShortDescription", DbType.String, gift.ShortDescription); database.AddInParameter(sqlStringCommand, "Title", DbType.String, gift.Title); database.AddInParameter(sqlStringCommand, "Meta_Description", DbType.String, gift.Meta_Description); database.AddInParameter(sqlStringCommand, "Meta_Keywords", DbType.String, gift.Meta_Keywords); database.AddInParameter(sqlStringCommand, "NeedPoint", DbType.Int32, gift.NeedPoint); return (database.ExecuteNonQuery(sqlStringCommand) >= 1); }
public static GiftInfo PopulateGift(IDataReader reader) { if (null == reader) { return null; } GiftInfo info = new GiftInfo(); info.GiftId = (int) reader["GiftId"]; info.Name = (DBNull.Value == reader["Name"]) ? null : ((string) reader["Name"]); info.ShortDescription = (DBNull.Value == reader["ShortDescription"]) ? null : ((string) reader["ShortDescription"]); info.Unit = (DBNull.Value == reader["Unit"]) ? null : ((string) reader["Unit"]); info.LongDescription = (DBNull.Value == reader["LongDescription"]) ? null : ((string) reader["LongDescription"]); info.Title = (DBNull.Value == reader["Title"]) ? null : ((string) reader["Title"]); info.Meta_Description = (DBNull.Value == reader["Meta_Description"]) ? null : ((string) reader["Meta_Description"]); info.Meta_Keywords = (DBNull.Value == reader["Meta_Keywords"]) ? null : ((string) reader["Meta_Keywords"]); if (DBNull.Value != reader["CostPrice"]) { info.CostPrice = new decimal?((decimal) reader["CostPrice"]); } if (DBNull.Value != reader["ImageUrl"]) { info.ImageUrl = (string) reader["ImageUrl"]; } if (DBNull.Value != reader["ThumbnailUrl40"]) { info.ThumbnailUrl40 = (string) reader["ThumbnailUrl40"]; } if (DBNull.Value != reader["ThumbnailUrl60"]) { info.ThumbnailUrl60 = (string) reader["ThumbnailUrl60"]; } if (DBNull.Value != reader["ThumbnailUrl100"]) { info.ThumbnailUrl100 = (string) reader["ThumbnailUrl100"]; } if (DBNull.Value != reader["ThumbnailUrl160"]) { info.ThumbnailUrl160 = (string) reader["ThumbnailUrl160"]; } if (DBNull.Value != reader["ThumbnailUrl180"]) { info.ThumbnailUrl180 = (string) reader["ThumbnailUrl180"]; } if (DBNull.Value != reader["ThumbnailUrl220"]) { info.ThumbnailUrl220 = (string) reader["ThumbnailUrl220"]; } if (DBNull.Value != reader["ThumbnailUrl310"]) { info.ThumbnailUrl310 = (string) reader["ThumbnailUrl310"]; } if (DBNull.Value != reader["ThumbnailUrl410"]) { info.ThumbnailUrl410 = (string) reader["ThumbnailUrl410"]; } if (DBNull.Value != reader["PurchasePrice"]) { info.PurchasePrice = (decimal) reader["PurchasePrice"]; } if (DBNull.Value != reader["MarketPrice"]) { info.MarketPrice = new decimal?((decimal) reader["MarketPrice"]); } info.NeedPoint = (int) reader["NeedPoint"]; info.IsDownLoad = (bool) reader["IsDownLoad"]; return info; }
public override GiftActionStatus CreateUpdateDeleteGift(GiftInfo gift, DataProviderAction action) { if (null == gift) { return GiftActionStatus.UnknowError; } DbCommand storedProcCommand = database.GetStoredProcCommand("cp_Gift_CreateUpdateDelete"); database.AddInParameter(storedProcCommand, "Action", DbType.Int32, (int)action); database.AddOutParameter(storedProcCommand, "Status", DbType.Int32, 4); if (DataProviderAction.Create != action) { database.AddInParameter(storedProcCommand, "GiftId", DbType.Int32, gift.GiftId); } else { database.AddOutParameter(storedProcCommand, "GiftId", DbType.Int32, 4); } if (DataProviderAction.Delete != action) { database.AddInParameter(storedProcCommand, "Name", DbType.String, gift.Name); database.AddInParameter(storedProcCommand, "ShortDescription", DbType.String, gift.ShortDescription); database.AddInParameter(storedProcCommand, "Unit", DbType.String, gift.Unit); database.AddInParameter(storedProcCommand, "LongDescription", DbType.String, gift.LongDescription); database.AddInParameter(storedProcCommand, "Title", DbType.String, gift.Title); database.AddInParameter(storedProcCommand, "Meta_Description", DbType.String, gift.Meta_Description); database.AddInParameter(storedProcCommand, "Meta_Keywords", DbType.String, gift.Meta_Keywords); database.AddInParameter(storedProcCommand, "CostPrice", DbType.Currency, gift.CostPrice); database.AddInParameter(storedProcCommand, "ImageUrl", DbType.String, gift.ImageUrl); database.AddInParameter(storedProcCommand, "ThumbnailUrl40", DbType.String, gift.ThumbnailUrl40); database.AddInParameter(storedProcCommand, "ThumbnailUrl60", DbType.String, gift.ThumbnailUrl60); database.AddInParameter(storedProcCommand, "ThumbnailUrl100", DbType.String, gift.ThumbnailUrl100); database.AddInParameter(storedProcCommand, "ThumbnailUrl160", DbType.String, gift.ThumbnailUrl160); database.AddInParameter(storedProcCommand, "ThumbnailUrl180", DbType.String, gift.ThumbnailUrl180); database.AddInParameter(storedProcCommand, "ThumbnailUrl220", DbType.String, gift.ThumbnailUrl220); database.AddInParameter(storedProcCommand, "ThumbnailUrl310", DbType.String, gift.ThumbnailUrl310); database.AddInParameter(storedProcCommand, "ThumbnailUrl410", DbType.String, gift.ThumbnailUrl410); database.AddInParameter(storedProcCommand, "PurchasePrice", DbType.Currency, gift.PurchasePrice); database.AddInParameter(storedProcCommand, "MarketPrice", DbType.Currency, gift.MarketPrice); database.AddInParameter(storedProcCommand, "NeedPoint", DbType.Int32, gift.NeedPoint); database.AddInParameter(storedProcCommand, "IsDownLoad", DbType.Boolean, gift.IsDownLoad); } database.ExecuteNonQuery(storedProcCommand); return (GiftActionStatus)((int)database.GetParameterValue(storedProcCommand, "Status")); }