/// <summary>
/// 更新一条团购数据
/// </summary>
/// <param name="groupBuy">团购模型变量</param>
public static void UpdateGroupBuy(GroupBuyInfo groupBuy)
{
string sql = "UPDATE " + GroupBuyAccessHelper.TablePrefix + "GroupBuy SET [Name]=@name,[Photo]=@photo,[Description]=@description,[ProductID]=@productID,[StartDate]=@startDate,[EndDate]=@endDate,[Price]=@price,[MinCount]=@minCount,[MaxCount]=@maxCount,[EachNumber]=@eachNumber WHERE [ID]=" + groupBuy.ID.ToString();
OleDbParameter[] parameters =
{
new OleDbParameter("@name", OleDbType.VarWChar),
new OleDbParameter("@photo", OleDbType.VarWChar),
new OleDbParameter("@description", OleDbType.VarWChar),
new OleDbParameter("@productID", OleDbType.Integer),
new OleDbParameter("@startDate", OleDbType.VarWChar),
new OleDbParameter("@endDate", OleDbType.VarWChar),
new OleDbParameter("@price", OleDbType.Decimal),
new OleDbParameter("@minCount", OleDbType.Integer),
new OleDbParameter("@maxCount", OleDbType.Integer),
new OleDbParameter("@eachNumber", OleDbType.Integer)
};
parameters[0].Value = groupBuy.Name;
parameters[1].Value = groupBuy.Photo;
parameters[2].Value = groupBuy.Description;
parameters[3].Value = groupBuy.ProductID;
parameters[4].Value = groupBuy.StartDate;
parameters[5].Value = groupBuy.EndDate;
parameters[6].Value = groupBuy.Price;
parameters[7].Value = groupBuy.MinCount;
parameters[8].Value = groupBuy.MaxCount;
parameters[9].Value = groupBuy.EachNumber;
GroupBuyAccessHelper.ExecuteNonQuery(sql, parameters);
UploadBLL.UpdateUpload(TableID, 0, groupBuy.ID, Cookies.Admin.GetRandomNumber(false));
}
/// <summary>
/// 增加一条团购数据
/// </summary>
/// <param name="groupBuy">团购模型变量</param>
public static int AddGroupBuy(GroupBuyInfo groupBuy)
{
string sql = "INSERT INTO " + GroupBuyAccessHelper.TablePrefix + "GroupBuy([Name],[Photo],[Description],[ProductID],[StartDate],[EndDate],[Price],[MinCount],[MaxCount],[EachNumber]) VALUES (@name,@photo,@description,@productID,@startDate,@endDate,@price,@minCount,@maxCount,@eachNumber)";
OleDbParameter[] parameters =
{
new OleDbParameter("@name", OleDbType.VarWChar),
new OleDbParameter("@photo", OleDbType.VarWChar),
new OleDbParameter("@description", OleDbType.VarWChar),
new OleDbParameter("@productID", OleDbType.Integer),
new OleDbParameter("@startDate", OleDbType.VarWChar),
new OleDbParameter("@endDate", OleDbType.VarWChar),
new OleDbParameter("@price", OleDbType.Decimal),
new OleDbParameter("@minCount", OleDbType.Integer),
new OleDbParameter("@maxCount", OleDbType.Integer),
new OleDbParameter("@eachNumber", OleDbType.Integer)
};
parameters[0].Value = groupBuy.Name;
parameters[1].Value = groupBuy.Photo;
parameters[2].Value = groupBuy.Description;
parameters[3].Value = groupBuy.ProductID;
parameters[4].Value = groupBuy.StartDate;
parameters[5].Value = groupBuy.EndDate;
parameters[6].Value = groupBuy.Price;
parameters[7].Value = groupBuy.MinCount;
parameters[8].Value = groupBuy.MaxCount;
parameters[9].Value = groupBuy.EachNumber;
GroupBuyAccessHelper.ExecuteNonQuery(sql, parameters);
Object id = GroupBuyAccessHelper.ExecuteScalar("SELECT MAX([ID]) FROM " + GroupBuyAccessHelper.TablePrefix + "GroupBuy");
groupBuy.ID = Convert.ToInt32(id);
UploadBLL.UpdateUpload(TableID, 0, groupBuy.ID, Cookies.Admin.GetRandomNumber(false));
return(groupBuy.ID);
}