/// <summary>
/// 添加多瓶装活动规则.
/// </summary>
/// <param name="promoteMuchBottledRule">
/// Promote_MuchBottled_Rule的对象实例.
/// </param>
/// <returns>
/// 多瓶装活动规则的编号.
/// </returns>
public int Insert(Promote_MuchBottled_Rule promoteMuchBottledRule)
{
if (promoteMuchBottledRule == null)
{
throw new ArgumentNullException("promoteMuchBottledRule");
}
var parameters = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"MuchBottledID",
SqlDbType.Int,
promoteMuchBottledRule.MuchBottledID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Name",
SqlDbType.NVarChar,
promoteMuchBottledRule.Name,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Quantity",
SqlDbType.Int,
promoteMuchBottledRule.Quantity,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"UnitPrice",
SqlDbType.Float,
promoteMuchBottledRule.UnitPrice,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"DiscountAmount",
SqlDbType.Float,
promoteMuchBottledRule.DiscountAmount,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"TotalMoney",
SqlDbType.Float,
promoteMuchBottledRule.TotalMoney,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"ImageUrl",
SqlDbType.NVarChar,
promoteMuchBottledRule.ImageUrl,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsDefault",
SqlDbType.Bit,
promoteMuchBottledRule.IsDefault,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"ReferenceID",
SqlDbType.Int,
null,
ParameterDirection.Output)
};
this.SqlServer.ExecuteNonQuery(
CommandType.StoredProcedure,
"sp_Promote_MuchBottled_Rule_Insert",
parameters,
null);
return (int)parameters.Find(parameter => parameter.ParameterName == "ReferenceID").Value;
}
/// <summary>
/// 更新多瓶装促销规则.
/// </summary>
/// <param name="promoteMuchBottledRule">
/// Promote_MuchBottled_Rule的对象实例.
/// </param>
public void Update(Promote_MuchBottled_Rule promoteMuchBottledRule)
{
if (promoteMuchBottledRule == null)
{
throw new ArgumentNullException("promoteMuchBottledRule");
}
var parameters = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"ID",
SqlDbType.Int,
promoteMuchBottledRule.ID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Name",
SqlDbType.NVarChar,
promoteMuchBottledRule.Name,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Quantity",
SqlDbType.Int,
promoteMuchBottledRule.Quantity,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"UnitPrice",
SqlDbType.Float,
promoteMuchBottledRule.UnitPrice,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"DiscountAmount",
SqlDbType.Float,
promoteMuchBottledRule.DiscountAmount,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"TotalMoney",
SqlDbType.Float,
promoteMuchBottledRule.TotalMoney,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"ImageUrl",
SqlDbType.NVarChar,
promoteMuchBottledRule.ImageUrl,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"IsDefault",
SqlDbType.Bit,
promoteMuchBottledRule.IsDefault,
ParameterDirection.Input)
};
this.sqlServer.ExecuteNonQuery(
CommandType.StoredProcedure,
"sp_Promote_MuchBottled_Rule_Update",
parameters,
null);
}
public void ModifyMuchBottled(
string muchBottledID,
bool isOnlinePayment,
string endTime,
bool isDisplayTime,
double goujiuPrice,
string property,
string number,
string price,
string imgstr,
string isDefault)
{
try
{
var promoteMuchbottled = new Promote_MuchBottled
{
ID = int.Parse(muchBottledID),
EmployeeID = this.SystemUserSession.EmployeeID,
IsOnlinePayment = isOnlinePayment,
EndTime = DateTime.Parse(endTime),
IsDisplayTime = isDisplayTime
};
this.promoteMuchBottledService = new PromoteMuchBottledService();
this.promoteMuchBottledService.Update(promoteMuchbottled);
var ruleName = property.Split(',');
var ruleNum = number.Split(',');
var rulePrice = price.Split(',');
var ruleisDefault = isDefault.Split(',');
var ruleImg = imgstr.Split(',');
this.promoteMuchBottledRuleService = new PromoteMuchBottledRuleService();
var promoteMuchBottledRuleList =
this.promoteMuchBottledRuleService.QueryByMuchBottledID(int.Parse(muchBottledID));
var promoteMuchBottledRule = new Promote_MuchBottled_Rule();
for (int i = 0; i < promoteMuchBottledRuleList.Count; i++)
{
if (ruleName[i].Trim() != string.Empty)
{
promoteMuchBottledRule.ID = promoteMuchBottledRuleList[i].ID;
promoteMuchBottledRule.Name = ruleName[i].Trim();
promoteMuchBottledRule.Quantity = int.Parse(ruleNum[i].Trim());
promoteMuchBottledRule.UnitPrice = double.Parse(rulePrice[i].Trim());
promoteMuchBottledRule.TotalMoney = promoteMuchBottledRule.UnitPrice
* promoteMuchBottledRule.Quantity;
promoteMuchBottledRule.DiscountAmount = (goujiuPrice - int.Parse(rulePrice[i].Trim()))
* int.Parse(ruleNum[i].Trim());
promoteMuchBottledRule.IsDefault = ruleisDefault[i] == "1";
promoteMuchBottledRule.ImageUrl = ruleImg[i];
this.promoteMuchBottledRuleService.Modify(promoteMuchBottledRule);
}
}
if (promoteMuchBottledRuleList.Count < ruleName.Length)
{
for (int i = promoteMuchBottledRuleList.Count; i < ruleName.Length; i++)
{
if (ruleName[i].Trim() != string.Empty)
{
promoteMuchBottledRule.Name = ruleName[i].Trim();
promoteMuchBottledRule.Quantity = int.Parse(ruleNum[i].Trim());
promoteMuchBottledRule.UnitPrice = double.Parse(rulePrice[i].Trim());
promoteMuchBottledRule.TotalMoney = promoteMuchBottledRule.UnitPrice
* promoteMuchBottledRule.Quantity;
promoteMuchBottledRule.DiscountAmount = (goujiuPrice - int.Parse(rulePrice[i].Trim()))
* int.Parse(ruleNum[i].Trim());
promoteMuchBottledRule.IsDefault = ruleisDefault[i] == "1";
promoteMuchBottledRule.ImageUrl = ruleImg[i];
promoteMuchBottledRule.ID = this.promoteMuchBottledRuleService.Add(promoteMuchBottledRule);
}
}
} // 如果修改的数量大于已存在的数量则添加新的规则
}
catch (Exception exception)
{
Response.Write("修改失败！");
throw new Exception(exception.Message, exception);
}
Response.Write("修改成功！");
}
/// <summary>
/// 添加多瓶装促销的规则.
/// </summary>
/// <param name="muchBottledID">
/// 多瓶装活动的编号.
/// </param>
/// <param name="goujiuPrice">
/// 商品购酒网价格.
/// </param>
/// <param name="property">
/// 活动的规则名称列表.
/// </param>
/// <param name="number">
/// 活动的规则数量列表.
/// </param>
/// <param name="price">
/// 活动规则促销价格列表.
/// </param>
/// <param name="imgstr">
/// 缩略图列表.
/// </param>
/// <param name="isDefault">
/// 是否默认列表
/// </param>
public void AddMuchBottledRule(
int muchBottledID,
double goujiuPrice,
string property,
string number,
string price,
string imgstr,
string isDefault)
{
var ruleName = property.Split(',');
var ruleNum = number.Split(',');
var rulePrice = price.Split(',');
var ruleisDefault = isDefault.Split(',');
var ruleImg = imgstr.Split(',');
var promoteMuchBottledRule = new Promote_MuchBottled_Rule { MuchBottledID = muchBottledID };
for (int i = 0; i < ruleName.Length; i++)
{
if (ruleName[i].Trim() != string.Empty)
{
promoteMuchBottledRule.Name = ruleName[i].Trim();
promoteMuchBottledRule.Quantity = int.Parse(ruleNum[i].Trim());
promoteMuchBottledRule.UnitPrice = double.Parse(rulePrice[i].Trim());
promoteMuchBottledRule.TotalMoney = promoteMuchBottledRule.UnitPrice
* promoteMuchBottledRule.Quantity;
promoteMuchBottledRule.DiscountAmount = (goujiuPrice - int.Parse(rulePrice[i].Trim()))
* int.Parse(ruleNum[i].Trim());
promoteMuchBottledRule.IsDefault = ruleisDefault[i] == "1";
promoteMuchBottledRule.ImageUrl = "Images/pro/" + ruleImg[i];
this.promoteMuchBottledRuleService = new PromoteMuchBottledRuleService();
promoteMuchBottledRule.ID = this.promoteMuchBottledRuleService.Add(promoteMuchBottledRule);
}
}
}
/// <summary>
/// 更新多瓶装促销规则.
/// </summary>
/// <param name="promoteMuchBottledRule">
/// Promote_MuchBottled_Rule的对象实例.
/// </param>
public void Modify(Promote_MuchBottled_Rule promoteMuchBottledRule)
{
this.promoteMuchBottledRuleDA.Update(promoteMuchBottledRule);
}
/// <summary>
/// 添加多瓶装活动规则.
/// </summary>
/// <param name="promoteMuchBottledRule">
/// Promote_MuchBottled_Rule的对象实例.
/// </param>
/// <returns>
/// 多瓶装活动规则的编号.
/// </returns>
public int Add(Promote_MuchBottled_Rule promoteMuchBottledRule)
{
return this.promoteMuchBottledRuleDA.Insert(promoteMuchBottledRule);
}