private void Bind()
{
RedPagerActivityInfo redPagerActivityInfo = RedPagerActivityBrower.GetRedPagerActivityInfo(this.redpaperactivityid);
if (redPagerActivityInfo == null)
{
this.ShowMsg("代金券活动不存在！", false);
}
else
{
this.txtName.Text = redPagerActivityInfo.Name;
for (int i = 0; i < this.ddlCategoryId.Items.Count; i++)
{
if (this.ddlCategoryId.Items[i].Value == redPagerActivityInfo.CategoryId.ToString())
{
this.ddlCategoryId.Items[i].Selected = true;
break;
}
}
this.txtMinOrderAmount.Text = redPagerActivityInfo.MinOrderAmount.ToString("F2");
this.txtMaxGetTimes.Text = redPagerActivityInfo.MaxGetTimes.ToString();
this.txtItemAmountLimit.Text = redPagerActivityInfo.ItemAmountLimit.ToString("F2");
this.txtOrderAmountCanUse.Text = redPagerActivityInfo.OrderAmountCanUse.ToString("F2");
this.txtExpiryDays.Text = redPagerActivityInfo.ExpiryDays.ToString();
}
}
public bool CreateRedPagerActivity(RedPagerActivityInfo redpaperactivity)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO vshop_RedPagerActivity(Name,CategoryId,MinOrderAmount,MaxGetTimes,ItemAmountLimit,ExpiryDays,OrderAmountCanUse) VALUES(@Name,@CategoryId,@MinOrderAmount,@MaxGetTimes,@ItemAmountLimit,@ExpiryDays,@OrderAmountCanUse);select @@identity");
this.database.AddInParameter(sqlStringCommand, "Name", DbType.String, redpaperactivity.Name);
this.database.AddInParameter(sqlStringCommand, "CategoryId", DbType.Int32, redpaperactivity.CategoryId);
this.database.AddInParameter(sqlStringCommand, "MinOrderAmount", DbType.Decimal, redpaperactivity.MinOrderAmount);
this.database.AddInParameter(sqlStringCommand, "MaxGetTimes", DbType.Int32, redpaperactivity.MaxGetTimes);
if (redpaperactivity.OrderAmountCanUse <= redpaperactivity.ItemAmountLimit)
{
redpaperactivity.OrderAmountCanUse = redpaperactivity.ItemAmountLimit++;
}
this.database.AddInParameter(sqlStringCommand, "ItemAmountLimit", DbType.Decimal, redpaperactivity.ItemAmountLimit);
this.database.AddInParameter(sqlStringCommand, "ExpiryDays", DbType.Int32, redpaperactivity.ExpiryDays);
this.database.AddInParameter(sqlStringCommand, "OrderAmountCanUse", DbType.Decimal, redpaperactivity.OrderAmountCanUse);
return(Globals.ToNum(this.database.ExecuteScalar(sqlStringCommand)) > 0);
}
public RedPagerActivityInfo GetRedPagerActivityInfo(int redpaperactivityid)
{
if (redpaperactivityid <= 0)
{
return(null);
}
RedPagerActivityInfo info = null;
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(string.Format("SELECT * FROM vshop_RedPagerActivity where RedPagerActivityId={0}", redpaperactivityid));
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
if (reader.Read())
{
info = DataMapper.PopulateRedPagerActivityInfo(reader);
}
}
return(info);
}
public bool UpdateRedPagerActivity(RedPagerActivityInfo redpaperactivity)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("UPDATE vshop_RedPagerActivity SET Name=@Name,CategoryId=@CategoryId,MinOrderAmount=@MinOrderAmount,MaxGetTimes=@MaxGetTimes,ItemAmountLimit=@ItemAmountLimit,ExpiryDays=@ExpiryDays,OrderAmountCanUse=@OrderAmountCanUse WHERE RedPagerActivityId=@RedPagerActivityId");
this.database.AddInParameter(sqlStringCommand, "RedPagerActivityId", DbType.Int32, redpaperactivity.RedPagerActivityId);
this.database.AddInParameter(sqlStringCommand, "Name", DbType.String, redpaperactivity.Name);
this.database.AddInParameter(sqlStringCommand, "CategoryId", DbType.Int32, redpaperactivity.CategoryId);
this.database.AddInParameter(sqlStringCommand, "MinOrderAmount", DbType.Decimal, redpaperactivity.MinOrderAmount);
this.database.AddInParameter(sqlStringCommand, "MaxGetTimes", DbType.Decimal, redpaperactivity.MaxGetTimes);
this.database.AddInParameter(sqlStringCommand, "ItemAmountLimit", DbType.Decimal, redpaperactivity.ItemAmountLimit);
this.database.AddInParameter(sqlStringCommand, "ExpiryDays", DbType.Decimal, redpaperactivity.ExpiryDays);
if (redpaperactivity.OrderAmountCanUse <= redpaperactivity.ItemAmountLimit)
{
redpaperactivity.OrderAmountCanUse = redpaperactivity.ItemAmountLimit++;
}
this.database.AddInParameter(sqlStringCommand, "OrderAmountCanUse", DbType.Decimal, redpaperactivity.OrderAmountCanUse);
return(this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
private void LoadRedPagerActivityInfo()
{
RedPagerActivityInfo redPagerActivityInfo = RedPagerActivityBrower.GetRedPagerActivityInfo(this.m_redpaperactivityid);
if (redPagerActivityInfo == null)
{
this.ShowMsg("代金券活动不存在！", false);
return;
}
this.txtName.Text = redPagerActivityInfo.Name;
int num = 0;
while (true)
{
if (num >= this.ddlCategoryId.Items.Count)
{
break;
}
else if (this.ddlCategoryId.Items[num].Value == redPagerActivityInfo.CategoryId.ToString())
{
this.ddlCategoryId.Items[num].Selected = true;
break;
}
else
{
num++;
}
}
TextBox str = this.txtMinOrderAmount;
decimal minOrderAmount = redPagerActivityInfo.MinOrderAmount;
str.Text = minOrderAmount.ToString("F2");
this.txtMaxGetTimes.Text = redPagerActivityInfo.MaxGetTimes.ToString();
TextBox textBox = this.txtItemAmountLimit;
decimal itemAmountLimit = redPagerActivityInfo.ItemAmountLimit;
textBox.Text = itemAmountLimit.ToString("F2");
TextBox str1 = this.txtOrderAmountCanUse;
decimal orderAmountCanUse = redPagerActivityInfo.OrderAmountCanUse;
str1.Text = orderAmountCanUse.ToString("F2");
this.txtExpiryDays.Text = redPagerActivityInfo.ExpiryDays.ToString();
}
private void btn_Submint(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtName.Text.Trim()))
{
this.ShowMsg("名称不能为空", false);
}
else
{
decimal result = 0M;
int num2 = 0;
decimal num3 = 0M;
int num4 = 0;
decimal num5 = 0M;
RedPagerActivityInfo redpaperactivity = new RedPagerActivityInfo();
if (this.redpaperactivityid > 0)
{
redpaperactivity = RedPagerActivityBrower.GetRedPagerActivityInfo(this.redpaperactivityid);
}
if (redpaperactivity != null)
{
redpaperactivity.Name = this.txtName.Text.Trim();
redpaperactivity.CategoryId = int.Parse(this.ddlCategoryId.SelectedValue);
decimal.TryParse(this.txtMinOrderAmount.Text.Trim(), out result);
int.TryParse(this.txtMaxGetTimes.Text.Trim(), out num2);
decimal.TryParse(this.txtItemAmountLimit.Text.Trim(), out num3);
int.TryParse(this.txtExpiryDays.Text.Trim(), out num4);
decimal.TryParse(this.txtOrderAmountCanUse.Text.Trim(), out num5);
redpaperactivity.MinOrderAmount = result;
redpaperactivity.MaxGetTimes = num2;
redpaperactivity.ItemAmountLimit = num3;
redpaperactivity.ExpiryDays = num4;
redpaperactivity.OrderAmountCanUse = num5;
if (RedPagerActivityBrower.IsExistsMinOrderAmount(redpaperactivity.RedPagerActivityId, redpaperactivity.MinOrderAmount))
{
this.ShowMsg("已存在相同金额的代金券活动", false);
}
else if (this.redpaperactivityid > 0)
{
if (RedPagerActivityBrower.UpdateRedPagerActivity(redpaperactivity))
{
if (base.Request.QueryString["reurl"] != null)
{
this.ReUrl = base.Request.QueryString["reurl"].ToString();
}
this.ShowMsgAndReUrl("代金券活动修改成功", true, this.ReUrl);
}
else
{
this.ShowMsg("代金券活动修改失败", false);
}
}
else if (RedPagerActivityBrower.CreateRedPagerActivity(redpaperactivity))
{
this.ShowMsgAndReUrl("代金券活动新增成功", true, this.ReUrl);
}
else
{
this.ShowMsg("代金券活动新增失败", false);
}
}
else
{
this.ShowMsg("代金券活动不存在！", false);
}
}
}
private void btnSubmit_Click(object obj, EventArgs eventArg)
{
if (string.IsNullOrEmpty(this.txtName.Text.Trim()))
{
this.ShowMsg("名称不能为空", false);
return;
}
decimal num = new decimal(0);
int num1 = 0;
decimal num2 = new decimal(0);
int num3 = 0;
decimal num4 = new decimal(0);
RedPagerActivityInfo redPagerActivityInfo = new RedPagerActivityInfo();
if (this.m_redpaperactivityid > 0)
{
redPagerActivityInfo = RedPagerActivityBrower.GetRedPagerActivityInfo(this.m_redpaperactivityid);
}
if (redPagerActivityInfo == null)
{
this.ShowMsg("代金券活动不存在!", false);
return;
}
redPagerActivityInfo.Name = this.txtName.Text.Trim();
redPagerActivityInfo.CategoryId = int.Parse(this.ddlCategoryId.SelectedValue);
decimal.TryParse(this.txtMinOrderAmount.Text.Trim(), out num);
int.TryParse(this.txtMaxGetTimes.Text.Trim(), out num1);
decimal.TryParse(this.txtItemAmountLimit.Text.Trim(), out num2);
int.TryParse(this.txtExpiryDays.Text.Trim(), out num3);
decimal.TryParse(this.txtOrderAmountCanUse.Text.Trim(), out num4);
redPagerActivityInfo.MinOrderAmount = num;
redPagerActivityInfo.MaxGetTimes = num1;
redPagerActivityInfo.ItemAmountLimit = num2;
redPagerActivityInfo.ExpiryDays = num3;
redPagerActivityInfo.OrderAmountCanUse = num4;
if (RedPagerActivityBrower.IsExistsMinOrderAmount(redPagerActivityInfo.RedPagerActivityId, redPagerActivityInfo.MinOrderAmount))
{
this.ShowMsg("已存在相同金额的代金券活动", false);
return;
}
if (this.m_redpaperactivityid <= 0)
{
if (!RedPagerActivityBrower.CreateRedPagerActivity(redPagerActivityInfo))
{
this.ShowMsg("代金券活动新增失败", false);
return;
}
this.ShowMsgAndReUrl("代金券活动新增成功", true, this.ReUrl);
return;
}
if (!RedPagerActivityBrower.UpdateRedPagerActivity(redPagerActivityInfo))
{
this.ShowMsg("代金券活动修改失败", false);
return;
}
if (base.Request.QueryString["reurl"] != null)
{
this.ReUrl = base.Request.QueryString["reurl"].ToString();
}
this.ShowMsgAndReUrl("代金券活动修改成功", true, this.ReUrl);
}
public static bool CreateRedPagerActivity(RedPagerActivityInfo redpaperactivity)
{
return(new RedRedPagerActivityDao().CreateRedPagerActivity(redpaperactivity));
}
