public override GroupBuyInfo GetGroupBuy(int groupBuyId)
{
GroupBuyInfo info = null;
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM distro_GroupBuy WHERE GroupBuyId=@GroupBuyId AND DistributorUserId=@DistributorUserId;SELECT * FROM distro_GroupBuyCondition WHERE GroupBuyId=@GroupBuyId AND DistributorUserId=@DistributorUserId");
this.database.AddInParameter(sqlStringCommand, "GroupBuyId", DbType.Int32, groupBuyId);
this.database.AddInParameter(sqlStringCommand, "DistributorUserId", DbType.Int32, HiContext.Current.SiteSettings.UserId.Value);
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
if (reader.Read())
{
info = DataMapper.PopulateGroupBuy(reader);
}
reader.NextResult();
while (reader.Read())
{
GropBuyConditionInfo item = new GropBuyConditionInfo {
Count = (int)reader["Count"],
Price = (decimal)reader["Price"]
};
info.GroupBuyConditions.Add(item);
}
}
return(info);
}
public override GroupBuyInfo GetProductGroupBuyInfo(int productId)
{
GroupBuyInfo info = null;
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_GroupBuy WHERE ProductId=@ProductId AND Status = @Status; SELECT * FROM Hishop_GroupBuyCondition WHERE GroupBuyId=(SELECT GroupBuyId FROM Hishop_GroupBuy WHERE ProductId=@ProductId AND Status = @Status)");
this.database.AddInParameter(sqlStringCommand, "ProductId", DbType.Int32, productId);
this.database.AddInParameter(sqlStringCommand, "Status", DbType.Int32, 1);
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
if (reader.Read())
{
info = DataMapper.PopulateGroupBuy(reader);
}
reader.NextResult();
while (reader.Read())
{
GropBuyConditionInfo item = new GropBuyConditionInfo();
item.Count = (int)reader["Count"];
item.Price = (decimal)reader["Price"];
if (info != null)
{
info.GroupBuyConditions.Add(item);
}
}
}
return(info);
}
public GroupBuyInfo GetGroupBuy(int groupBuyId)
{
GroupBuyInfo info = null;
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM vw_Hishop_GroupBuy WHERE GroupBuyId=@GroupBuyId;SELECT * FROM Hishop_GroupBuyCondition WHERE GroupBuyId=@GroupBuyId");
this.database.AddInParameter(sqlStringCommand, "GroupBuyId", DbType.Int32, groupBuyId);
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
if (reader.Read())
{
info = DataMapper.PopulateGroupBuy(reader);
}
reader.NextResult();
while (reader.Read())
{
GropBuyConditionInfo item = new GropBuyConditionInfo
{
Count = (int)reader["Count"],
Price = (decimal)reader["Price"]
};
info.GroupBuyConditions.Add(item);
}
}
return(info);
}
public override GroupBuyInfo GetProductGroupBuyInfo(int productId)
{
GroupBuyInfo groupBuyInfo = null;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM distro_GroupBuy WHERE ProductId=@ProductId AND DistributorUserId=@DistributorUserId AND Status = @Status; SELECT * FROM distro_GroupBuyCondition WHERE GroupBuyId=(SELECT GroupBuyId FROM distro_GroupBuy WHERE ProductId=@ProductId AND DistributorUserId=@DistributorUserId AND Status=@Status)");
this.database.AddInParameter(sqlStringCommand, "ProductId", System.Data.DbType.Int32, productId);
this.database.AddInParameter(sqlStringCommand, "DistributorUserId", System.Data.DbType.Int32, HiContext.Current.SiteSettings.UserId.Value);
this.database.AddInParameter(sqlStringCommand, "Status", System.Data.DbType.Int32, 1);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
groupBuyInfo = DataMapper.PopulateGroupBuy(dataReader);
}
dataReader.NextResult();
while (dataReader.Read())
{
GropBuyConditionInfo gropBuyConditionInfo = new GropBuyConditionInfo();
gropBuyConditionInfo.Count = (int)dataReader["Count"];
gropBuyConditionInfo.Price = (decimal)dataReader["Price"];
if (groupBuyInfo != null)
{
groupBuyInfo.GroupBuyConditions.Add(gropBuyConditionInfo);
}
}
}
return(groupBuyInfo);
}
public override GroupBuyInfo GetGroupBuy(int groupBuyId)
{
GroupBuyInfo groupBuyInfo = null;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_GroupBuy WHERE GroupBuyId=@GroupBuyId;SELECT * FROM Hishop_GroupBuyCondition WHERE GroupBuyId=@GroupBuyId");
this.database.AddInParameter(sqlStringCommand, "GroupBuyId", System.Data.DbType.Int32, groupBuyId);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
groupBuyInfo = DataMapper.PopulateGroupBuy(dataReader);
}
dataReader.NextResult();
while (dataReader.Read())
{
GropBuyConditionInfo gropBuyConditionInfo = new GropBuyConditionInfo();
gropBuyConditionInfo.Count = (int)dataReader["Count"];
gropBuyConditionInfo.Price = (decimal)dataReader["Price"];
groupBuyInfo.GroupBuyConditions.Add(gropBuyConditionInfo);
}
}
return(groupBuyInfo);
}
protected void btnUpdateGroupBuy_Click(object sender, EventArgs e)
{
int num;
int num2;
decimal num3;
GroupBuyInfo info3 = new GroupBuyInfo();
info3.GroupBuyId = groupBuyId;
GroupBuyInfo groupBuy = info3;
string str = string.Empty;
if (dropGroupBuyProduct.SelectedValue > 0)
{
if ((SubsitePromoteHelper.GetGroupBuy(groupBuyId).ProductId != dropGroupBuyProduct.SelectedValue.Value) && SubsitePromoteHelper.ProductGroupBuyExist(dropGroupBuyProduct.SelectedValue.Value))
{
ShowMsg("已经存在此商品的团购活动，并且活动正在进行中", false);
return;
}
groupBuy.ProductId = dropGroupBuyProduct.SelectedValue.Value;
}
else
{
str = str + Formatter.FormatErrorMessage("请选择团购商品");
}
if (!calendarEndDate.SelectedDate.HasValue)
{
str = str + Formatter.FormatErrorMessage("请选择结束日期");
}
else
{
groupBuy.EndDate = calendarEndDate.SelectedDate.Value;
}
if (!string.IsNullOrEmpty(txtNeedPrice.Text))
{
decimal num4;
if (decimal.TryParse(txtNeedPrice.Text.Trim(), out num4))
{
groupBuy.NeedPrice = num4;
}
else
{
str = str + Formatter.FormatErrorMessage("违约金填写格式不正确");
}
}
if (int.TryParse(txtMaxCount.Text.Trim(), out num))
{
groupBuy.MaxCount = num;
}
else
{
str = str + Formatter.FormatErrorMessage("限购数量不能为空，只能为整数");
}
groupBuy.Content = Globals.HtmlEncode(txtContent.Text);
GropBuyConditionInfo item = new GropBuyConditionInfo();
if (int.TryParse(txtCount.Text.Trim(), out num2))
{
item.Count = num2;
}
else
{
str = str + Formatter.FormatErrorMessage("团购满足数量不能为空，只能为整数");
}
if (decimal.TryParse(txtPrice.Text.Trim(), out num3))
{
item.Price = num3;
}
else
{
str = str + Formatter.FormatErrorMessage("团购价格不能为空，只能为数值类型");
}
groupBuy.GroupBuyConditions.Add(item);
if (groupBuy.MaxCount < groupBuy.GroupBuyConditions[0].Count)
{
str = str + Formatter.FormatErrorMessage("限购数量必须大于等于满足数量 ");
}
if (!string.IsNullOrEmpty(str))
{
ShowMsg(str, false);
}
else if (SubsitePromoteHelper.UpdateGroupBuy(groupBuy))
{
ShowMsg("编辑团购活动成功", true);
}
else
{
ShowMsg("编辑团购活动失败", true);
}
}
private void btnUpdateGroupBuy_Click(object sender, EventArgs e)
{
int num2;
int num3;
decimal num4;
GroupBuyInfo groupBuy = new GroupBuyInfo
{
GroupBuyId = this.groupBuyId
};
string str = string.Empty;
if (this.dropGroupBuyProduct.SelectedValue > 0)
{
if ((PromoteHelper.GetGroupBuy(this.groupBuyId).ProductId != this.dropGroupBuyProduct.SelectedValue.Value) && PromoteHelper.ProductGroupBuyExist(this.dropGroupBuyProduct.SelectedValue.Value))
{
this.ShowMsg("已经存在此商品的团购活动，并且活动正在进行中", false);
return;
}
groupBuy.ProductId = this.dropGroupBuyProduct.SelectedValue.Value;
}
else
{
str = str + Formatter.FormatErrorMessage("请选择团购商品");
}
if (!this.calendarStartDate.SelectedDate.HasValue)
{
str = str + Formatter.FormatErrorMessage("请选择开始日期");
}
if (!this.calendarEndDate.SelectedDate.HasValue)
{
str = str + Formatter.FormatErrorMessage("请选择结束日期");
}
else
{
groupBuy.EndDate = this.calendarEndDate.SelectedDate.Value.AddHours((double)this.HourDropDownList1.SelectedValue.Value);
if ((DateTime.Compare(groupBuy.EndDate, DateTime.Now) <= 0) && (groupBuy.Status == GroupBuyStatus.UnderWay))
{
str = str + Formatter.FormatErrorMessage("结束日期必须要晚于今天日期");
}
else if (DateTime.Compare(this.calendarStartDate.SelectedDate.Value.AddHours((double)this.drophours.SelectedValue.Value), groupBuy.EndDate) >= 0)
{
str = str + Formatter.FormatErrorMessage("开始日期必须要早于结束日期");
}
else
{
groupBuy.StartDate = this.calendarStartDate.SelectedDate.Value.AddHours((double)this.drophours.SelectedValue.Value);
}
}
if (!string.IsNullOrEmpty(this.txtNeedPrice.Text))
{
decimal num;
if (decimal.TryParse(this.txtNeedPrice.Text.Trim(), out num))
{
groupBuy.NeedPrice = num;
}
else
{
str = str + Formatter.FormatErrorMessage("违约金填写格式不正确");
}
}
if (int.TryParse(this.txtMaxCount.Text.Trim(), out num2))
{
groupBuy.MaxCount = num2;
}
else
{
str = str + Formatter.FormatErrorMessage("限购数量不能为空，只能为整数");
}
groupBuy.Content = this.txtContent.Text;
GropBuyConditionInfo item = new GropBuyConditionInfo();
if (int.TryParse(this.txtCount.Text.Trim(), out num3))
{
item.Count = num3;
}
else
{
str = str + Formatter.FormatErrorMessage("团购满足数量不能为空，只能为整数");
}
if (decimal.TryParse(this.txtPrice.Text.Trim(), out num4))
{
item.Price = num4;
}
else
{
str = str + Formatter.FormatErrorMessage("团购价格不能为空，只能为数值类型");
}
groupBuy.GroupBuyConditions.Add(item);
if (groupBuy.MaxCount < groupBuy.GroupBuyConditions[0].Count)
{
str = str + Formatter.FormatErrorMessage("限购数量必须大于等于满足数量 ");
}
if (!string.IsNullOrEmpty(str))
{
this.ShowMsg(str, false);
}
else if (PromoteHelper.UpdateGroupBuy(groupBuy))
{
this.ShowMsg("编辑团购活动成功", true);
}
else
{
this.ShowMsg("编辑团购活动失败", true);
}
}
private void btnUpdateGroupBuy_Click(object sender, System.EventArgs e)
{
GroupBuyInfo groupBuyInfo = new GroupBuyInfo();
groupBuyInfo.GroupBuyId = this.groupBuyId;
string text = string.Empty;
if (this.dropGroupBuyProduct.SelectedValue > 0)
{
GroupBuyInfo groupBuy = SubsitePromoteHelper.GetGroupBuy(this.groupBuyId);
if (groupBuy.ProductId != this.dropGroupBuyProduct.SelectedValue.Value && SubsitePromoteHelper.ProductGroupBuyExist(this.dropGroupBuyProduct.SelectedValue.Value))
{
this.ShowMsg("已经存在此商品的团购活动，并且活动正在进行中", false);
return;
}
groupBuyInfo.ProductId = this.dropGroupBuyProduct.SelectedValue.Value;
}
else
{
text += Formatter.FormatErrorMessage("请选择团购商品");
}
if (!this.calendarEndDate.SelectedDate.HasValue)
{
text += Formatter.FormatErrorMessage("请选择结束日期");
}
else
{
groupBuyInfo.EndDate = this.calendarEndDate.SelectedDate.Value.AddHours((double)this.HourDropDownList1.SelectedValue.Value);
if (System.DateTime.Compare(groupBuyInfo.EndDate, System.DateTime.Now) <= 0 && groupBuyInfo.Status == GroupBuyStatus.UnderWay)
{
text += Formatter.FormatErrorMessage("结束日期必须要晚于今天日期");
}
else
{
if (System.DateTime.Compare(this.calendarStartDate.SelectedDate.Value.AddHours((double)this.drophours.SelectedValue.Value), groupBuyInfo.EndDate) >= 0)
{
text += Formatter.FormatErrorMessage("开始日期必须要早于结束日期");
}
else
{
groupBuyInfo.StartDate = this.calendarStartDate.SelectedDate.Value.AddHours((double)this.drophours.SelectedValue.Value);
}
}
}
if (!string.IsNullOrEmpty(this.txtNeedPrice.Text))
{
decimal needPrice;
if (decimal.TryParse(this.txtNeedPrice.Text.Trim(), out needPrice))
{
groupBuyInfo.NeedPrice = needPrice;
}
else
{
text += Formatter.FormatErrorMessage("违约金填写格式不正确");
}
}
int maxCount;
if (int.TryParse(this.txtMaxCount.Text.Trim(), out maxCount))
{
groupBuyInfo.MaxCount = maxCount;
}
else
{
text += Formatter.FormatErrorMessage("限购数量不能为空，只能为整数");
}
groupBuyInfo.Content = Globals.HtmlEncode(this.txtContent.Text);
GropBuyConditionInfo gropBuyConditionInfo = new GropBuyConditionInfo();
int count;
if (int.TryParse(this.txtCount.Text.Trim(), out count))
{
gropBuyConditionInfo.Count = count;
}
else
{
text += Formatter.FormatErrorMessage("团购满足数量不能为空，只能为整数");
}
decimal price;
if (decimal.TryParse(this.txtPrice.Text.Trim(), out price))
{
gropBuyConditionInfo.Price = price;
}
else
{
text += Formatter.FormatErrorMessage("团购价格不能为空，只能为数值类型");
}
groupBuyInfo.GroupBuyConditions.Add(gropBuyConditionInfo);
if (groupBuyInfo.MaxCount < groupBuyInfo.GroupBuyConditions[0].Count)
{
text += Formatter.FormatErrorMessage("限购数量必须大于等于满足数量 ");
}
if (!string.IsNullOrEmpty(text))
{
this.ShowMsg(text, false);
return;
}
if (SubsitePromoteHelper.UpdateGroupBuy(groupBuyInfo))
{
this.ShowMsg("编辑团购活动成功", true);
return;
}
this.ShowMsg("编辑团购活动失败", true);
}
private void btnAddGroupBuy_Click(object sender, EventArgs e)
{
int num;
int num2;
decimal num3;
GroupBuyInfo groupBuy = new GroupBuyInfo();
string str = string.Empty;
if (this.dropGroupBuyProduct.SelectedValue > 0)
{
if (PromoteHelper.ProductGroupBuyExist(this.dropGroupBuyProduct.SelectedValue.Value))
{
this.ShowMsg("已经存在此商品的团购活动，并且活动正在进行中", false);
return;
}
groupBuy.ProductId = this.dropGroupBuyProduct.SelectedValue.Value;
}
else
{
str = str + Formatter.FormatErrorMessage("请选择团购商品");
}
if (!this.calendarEndDate.SelectedDate.HasValue)
{
str = str + Formatter.FormatErrorMessage("请选择结束日期");
}
else
{
groupBuy.EndDate = this.calendarEndDate.SelectedDate.Value;
}
if (!string.IsNullOrEmpty(this.txtNeedPrice.Text))
{
decimal num4;
if (decimal.TryParse(this.txtNeedPrice.Text.Trim(), out num4))
{
groupBuy.NeedPrice = num4;
}
else
{
str = str + Formatter.FormatErrorMessage("违约金填写格式不正确");
}
}
if (int.TryParse(this.txtMaxCount.Text.Trim(), out num))
{
groupBuy.MaxCount = num;
}
else
{
str = str + Formatter.FormatErrorMessage("限购数量不能为空，只能为整数");
}
GropBuyConditionInfo item = new GropBuyConditionInfo();
if (int.TryParse(this.txtCount.Text.Trim(), out num2))
{
item.Count = num2;
}
else
{
str = str + Formatter.FormatErrorMessage("团购满足数量不能为空，只能为整数");
}
if (decimal.TryParse(this.txtPrice.Text.Trim(), out num3))
{
item.Price = num3;
}
else
{
str = str + Formatter.FormatErrorMessage("团购价格不能为空，只能为数值类型");
}
groupBuy.GroupBuyConditions.Add(item);
if (groupBuy.MaxCount < groupBuy.GroupBuyConditions[0].Count)
{
str = str + Formatter.FormatErrorMessage("限购数量必须大于等于满足数量 ");
}
if (!string.IsNullOrEmpty(str))
{
this.ShowMsg(str, false);
}
else
{
groupBuy.Content = this.txtContent.Text;
if (PromoteHelper.AddGroupBuy(groupBuy))
{
this.ShowMsg("添加团购活动成功", true);
}
else
{
this.ShowMsg("添加团购活动失败", true);
}
}
}
