public string Update(PromotionsAmountReduce model)
{
try
{
return _promoAmountReduceDao.Update(model);
}
catch (Exception ex)
{
throw new Exception("PromotionsAmountReduceMgr-->Update-->" + ex.Message, ex);
}
}
public string Save(PromotionsAmountReduce model)
{
model.Replace4MySQL();
StringBuilder sql = new StringBuilder();
try
{
sql.Append(" insert into promotions_amount_reduce(id,name,delivery_store,group_id,type,amount,quantity,start,end,created,active,status)");
sql.AppendFormat(" values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}');",
model.id, model.name, model.delivery_store, model.group_id, model.type, model.amount,
model.quantity, CommonFunction.DateTimeToString(model.start), CommonFunction.DateTimeToString(model.end),
CommonFunction.DateTimeToString(model.created), model.active, model.status);
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception("PromotionsAmountReduceDao-->Save-->" + ex.Message + sql.ToString(), ex);
}
}
public string Update(PromotionsAmountReduce model)
{
model.Replace4MySQL();
StringBuilder sql = new StringBuilder();
try
{
sql.Append(" update promotions_amount_reduce set ");
sql.AppendFormat(" name='{0}',delivery_store='{1}',group_id='{2}',type='{3}',amount='{4}',quantity='{5}',",
model.name, model.delivery_store, model.group_id, model.type, model.amount, model.quantity);
sql.AppendFormat(" start='{0}',end='{1}',updatetime='{2}',active='{3}',status='{4}'", CommonFunction.DateTimeToString(model.start),
CommonFunction.DateTimeToString(model.end),
CommonFunction.DateTimeToString(model.updatetime), model.active, model.status);
sql.AppendFormat(" where id='{0}';", model.id);
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception("PromotionsAmountReduceDao-->Update-->" + ex.Message + sql.ToString(), ex);
}
}
/// <summary>
/// 修改狀態
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateActive(PromotionsAmountFareQuery model)
{
int i = 0;
MySqlCommand mySqlCmd = new MySqlCommand();
MySqlConnection mySqlConn = new MySqlConnection(connStr);
StringBuilder sql = new StringBuilder();
try
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Closed)
{
mySqlConn.Open();
}
mySqlCmd.Connection = mySqlConn;
mySqlCmd.Transaction = mySqlConn.BeginTransaction();
mySqlCmd.CommandType = System.Data.CommandType.Text;
sql.Append(_prodPromoDao.DeleteProdProm(model.event_id));//先刪除在新增當active=0時照樣刪除只有active=1時才新增
if (model.active)
{
ProductCategorySet querySet = new ProductCategorySet();
querySet.Category_Id = Convert.ToUInt32(model.category_id);
ProductCategorySetDao _setDao = new ProductCategorySetDao(connStr);
List<ProductCategorySet> lmodelSet = _setDao.Query(querySet);
foreach (ProductCategorySet item in lmodelSet)
{
ProdPromo ppmodel = new ProdPromo();
ppmodel.product_id = Convert.ToInt32(item.Product_Id);
ppmodel.event_id = model.event_id;
ppmodel.event_type = model.event_type;
ppmodel.event_desc = model.event_desc;
ppmodel.start = model.start;
ppmodel.end = model.end;
ppmodel.page_url = model.category_link_url;
if (model.group_id == 0 && model.condition_id == 0)
{
ppmodel.user_specified = 0;
}
else
{
ppmodel.user_specified = 1;
}
ppmodel.kuser = model.muser;
ppmodel.kdate = model.modified;
ppmodel.muser = model.muser;
ppmodel.mdate = model.modified;
ppmodel.status = model.status;
sql.Append(_prodPromoDao.SaveProdProm(ppmodel));
}
}
if (model.id != 0)
{
sql.Append(UpdatePromoFare(model));
PromotionsAmountReduce parModel = new PromotionsAmountReduce();
parModel.id = model.id;
parModel.name = model.name;
parModel.delivery_store = model.delivery_store;
parModel.group_id = model.group_id;
parModel.type = model.type;
parModel.amount = model.amount;
parModel.quantity = model.quantity;
parModel.start = model.start;
parModel.end = model.end;
parModel.created = model.created;
parModel.updatetime = model.modified;
parModel.active = model.active ? 1 : 0;
parModel.status = model.status;
sql.Append(_promAmountReduceDao.Update(parModel));
}
mySqlCmd.CommandText = sql.ToString();
i += mySqlCmd.ExecuteNonQuery();
mySqlCmd.Transaction.Commit();
}
catch (Exception ex)
{
mySqlCmd.Transaction.Rollback();
throw new Exception("PromotionsAmountFareDao-->UpdateActive-->" + ex.Message + sql.ToString(), ex);
}
finally
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Open)
{
mySqlConn.Close();
}
}
return i;
}
public int Update(PromotionsAmountFareQuery model, string oldEventId)
{
int i = 0;
MySqlCommand mySqlCmd = new MySqlCommand();
MySqlConnection mySqlConn = new MySqlConnection(connStr);
StringBuilder sbExSql = new StringBuilder();
try
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Closed)
{
mySqlConn.Open();
}
mySqlCmd.Connection = mySqlConn;
mySqlCmd.Transaction = mySqlConn.BeginTransaction();
mySqlCmd.CommandType = System.Data.CommandType.Text;
StringBuilder sqlf = new StringBuilder();
mySqlCmd.CommandText = _prodPromoDao.DeleteProdProm(model.event_id);
sbExSql.Append(mySqlCmd.CommandText);
mySqlCmd.ExecuteNonQuery();//刪除ProdPromo
mySqlCmd.CommandText = _promoAllDao.DelPromAll(model.event_id);
sbExSql.Append(_promoAllDao.DelPromAll(mySqlCmd.CommandText));
mySqlCmd.ExecuteNonQuery();//刪除PromAll
if (model.allClass == 0)
{
//刪除全館商品
ProductCategorySet qgSet = new ProductCategorySet();
qgSet.Category_Id = model.category_id;
qgSet.Product_Id = 999999;//全館商品刪除 id=999999
//根據category_id刪除product_category_set表數據
mySqlCmd.CommandText = _prodCateSetDao.DelProdCateSetByCPID(qgSet);
sbExSql.Append(mySqlCmd.CommandText);
mySqlCmd.ExecuteNonQuery();//刪除全館別商品999999
if (model.brand_id != 0)//當品牌不為空時講該品牌下的所有商品加入set表
{
sqlf.Append(_prodCateSetDao.DeleteProdCateSet(model.category_id));
mySqlCmd.CommandText = sqlf.ToString();
sbExSql.Append(mySqlCmd.CommandText);
mySqlCmd.ExecuteNonQuery();
sqlf.Clear();
QueryVerifyCondition query = new QueryVerifyCondition();//根據條件從product表中獲取符合條件的商品并添加到set和prodprom表中
query.brand_id = Convert.ToUInt32(model.brand_id);//品牌
query.site_ids = model.site;
query.combination = 1;
PromotionsMaintainDao _promoMainDao = new PromotionsMaintainDao(connStr);
query.IsPage = false;
int totalCount = 0;
List<QueryandVerifyCustom> qvcList = _promoMainDao.GetProList(query, out totalCount);
List<uint> categorysetProduct = new List<uint>();
foreach (QueryandVerifyCustom qvcItem in qvcList)
{
if (categorysetProduct.Contains(qvcItem.product_id))
{
continue;
}
categorysetProduct.Add(qvcItem.product_id);
ProductCategorySet pcsModel = new ProductCategorySet();
pcsModel.Product_Id = qvcItem.product_id;
pcsModel.Brand_Id = Convert.ToUInt32(model.brand_id);
pcsModel.Category_Id = model.category_id;
//刪除已有的 新增異動的
sqlf.Append(_prodCateSetDao.SaveProdCategorySet(pcsModel));
}
}
if (!string.IsNullOrEmpty(sqlf.ToString()))
{
mySqlCmd.CommandText = sqlf.ToString();
sbExSql.Append(mySqlCmd.CommandText);
mySqlCmd.ExecuteNonQuery();
sqlf.Clear();
}
}
else//全館時
{
sqlf.Clear();
sqlf.AppendFormat(_prodCateSetDao.DeleteProdCateSet(model.category_id));
ProductCategorySet pcs = new ProductCategorySet();
pcs.Category_Id = model.category_id;
pcs.Product_Id = 999999;
pcs.Brand_Id = 0;
sqlf.Append(_prodCateSetDao.SaveProdCategorySet(pcs));
mySqlCmd.CommandText = sqlf.ToString();
sbExSql.Append(_promoAllDao.DeletePromAll(mySqlCmd.CommandText));
mySqlCmd.ExecuteNonQuery();
}
sqlf.Clear();
PromoAll pamodel = new PromoAll();
pamodel.event_id = model.event_id;
pamodel.event_type = model.event_type;
pamodel.category_id = Convert.ToInt32(model.category_id);
pamodel.startTime = model.start;
pamodel.end = model.end;
pamodel.status = model.status;
pamodel.kuser = model.kuser;
pamodel.kdate = model.created;
pamodel.muser = model.muser;
pamodel.mdate = model.modified;
pamodel.product_id = model.product_id;
pamodel.class_id = model.class_id;
pamodel.brand_id = model.brand_id;
sqlf.AppendFormat(_promoAllDao.SavePromAll(pamodel));
ProductCategoryDao _categoryDao = new ProductCategoryDao(connStr);
ProductCategory pcmodel = _categoryDao.GetModelById(Convert.ToUInt32(model.category_id));
pcmodel.category_id = Convert.ToUInt32(model.category_id);
pcmodel.category_name = model.name;
pcmodel.banner_image = model.banner_image;
pcmodel.category_link_url = model.category_link_url;
pcmodel.category_father_id = model.category_father_id;
pcmodel.category_updatedate = (uint)BLL.gigade.Common.CommonFunction.GetPHPTime(model.modified.ToString());
pcmodel.category_display = Convert.ToUInt32(model.status);
sqlf.AppendFormat(_cateDao.UpdateProdCate(pcmodel));
PromotionsAmountReduce parModel = new PromotionsAmountReduce();
parModel.id = model.id;
parModel.name = model.name;
parModel.delivery_store = model.delivery_store;
parModel.group_id = model.group_id;
parModel.type = model.type;
parModel.amount = model.amount;
parModel.quantity = model.quantity;
parModel.start = model.start;
parModel.end = model.end;
parModel.updatetime = model.modified;
parModel.created = model.created;
parModel.active = model.active ? 1 : 0;
parModel.status = model.status;
sqlf.AppendFormat(_promAmountReduceDao.Update(parModel));
mySqlCmd.CommandText = sqlf + UpdatePromoFare(model);
i += mySqlCmd.ExecuteNonQuery();
mySqlCmd.Transaction.Commit();
}
catch (Exception ex)
{
mySqlCmd.Transaction.Rollback();
throw new Exception("PromotionsAmountFareDao-->Update-->sql:" + sbExSql.ToString() + ex.Message, ex);
}
finally
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Open)
{
mySqlConn.Close();
}
}
return i;
}
