public string AddOrUpdate(EventPromoAdditionalPrice model)
{
model.Replace4MySQL();
StringBuilder sql = new StringBuilder();
try
{
if (model.row_id == 0)
{
sql.Append(@"insert into event_promo_additional_price(event_name,event_desc,event_start,event_end,event_type,event_id,site_id,create_user,create_time,modify_user,modify_time,user_condition_id,condition_type,quantity,amount,num_limit,group_id,device,event_status)");
sql.AppendFormat(" values('{0}','{1}','{2}','{3}','{4}','{5}'", model.event_name, model.event_desc, Common.CommonFunction.DateTimeToString(model.event_start), Common.CommonFunction.DateTimeToString(model.event_end), model.event_type, model.event_id);
sql.AppendFormat(",'{0}','{1}','{2}','{3}','{4}','{5}','{6}',{7},{8},{9},{10}", model.site_id, model.create_user, Common.CommonFunction.DateTimeToString(model.create_time), model.modify_user, Common.CommonFunction.DateTimeToString(model.modify_time), model.user_condition_id, model.condition_type, model.quantity, model.amount, model.num_limit, model.group_id);
sql.AppendFormat(",'{0}','{1}');select @@identity;", model.device, model.event_status);
}
else
{
sql.AppendFormat("update event_promo_additional_price set event_name='{0}',event_desc='{1}',event_start='{2}',event_end='{3}',event_type='{4}',", model.event_name, model.event_desc, Common.CommonFunction.DateTimeToString(model.event_start), Common.CommonFunction.DateTimeToString(model.event_end), model.event_type);
sql.AppendFormat(" site_id='{0}',modify_user='******',modify_time='{2}',user_condition_id='{3}',condition_type='{4}',", model.site_id, model.modify_user, Common.CommonFunction.DateTimeToString(model.modify_time), model.user_condition_id, model.condition_type);
sql.AppendFormat(" device='{0}',event_status='{1}',quantity={2},amount={3},num_limit={4},group_id={5},event_id='{6}' where row_id='{7}';", model.device, model.event_status, model.quantity, model.amount, model.num_limit, model.group_id,model.event_id, model.row_id);
}
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception("EventPromoAdditionalPriceDao-->AddOrUpdate-->" + ex.Message, ex);
}
}
public List<EventPromoAdditionalPriceQuery> GetList(EventPromoAdditionalPrice model, out int count)
{
count = 0;
model.Replace4MySQL();
StringBuilder sbStrAll = new StringBuilder();
StringBuilder sbStrJoin = new StringBuilder();
StringBuilder sbStrPage = new StringBuilder();
StringBuilder sbWhr = new StringBuilder();
try
{
sbStrAll.Append("SELECT ep.row_id,ep.modify_user,ep.event_id,ep.group_id,ep.event_name,ep.event_start,ep.event_end,mu.user_username,ep.event_desc,ep.site_id,ep.condition_type,ep.device,ep.user_condition_id,ep.quantity,ep.amount,ep.num_limit,ep.event_status ");
sbStrJoin.Append(" FROM event_promo_additional_price AS ep LEFT JOIN manage_user mu ON ep.modify_user=mu.user_id where 1=1 ");
if (!string.IsNullOrEmpty(model.event_id))
{
model.event_id = model.event_id.Replace(",", "\',\'");
sbWhr.AppendFormat(" and ep.event_id in ('{0}') ", model.event_id);
}
if (!string.IsNullOrEmpty(model.event_name))
{
sbWhr.AppendFormat(" and ep.event_name like N'%{0}%'", model.event_name);
}
if (model.IsPage)
{
count = int.Parse(access.getDataTable("select count(ep.event_id)" + sbStrJoin.ToString() + sbWhr.ToString()).Rows[0][0].ToString());
sbWhr.AppendFormat(" limit {0},{1}", model.Start, model.Limit);
}
return access.getDataTableForObj<EventPromoAdditionalPriceQuery>(sbStrAll.ToString() + sbStrJoin.ToString() + sbWhr.ToString());
}
catch (Exception ex)
{
throw new Exception("EventPromoAdditionalPriceDao-->GetList-->" + ex.Message + sbStrAll.ToString() + sbStrJoin.ToString(), ex);
}
}
public List<EventPromoAdditionalPriceQuery> GetList(EventPromoAdditionalPrice model,out int total)
{
try
{
return dao.GetList(model,out total);
}
catch (Exception ex)
{
throw new Exception("EventPromoAdditionalPriceMgr-->GetList-->" + ex.Message, ex);
}
}
public string UpdateActive(EventPromoAdditionalPrice model)
{
StringBuilder sql = new StringBuilder();
try
{
model.Replace4MySQL();
sql.AppendFormat("set sql_safe_updates = 0;update event_promo_additional_price set event_status ='{0}', modify_user='******',modify_time='{2}' where event_id = '{3}';set sql_safe_updates = 1;", model.event_status, model.modify_user, Common.CommonFunction.DateTimeToString(model.modify_time), model.event_id);
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception("EventPromoAdditionalPriceDao-->UpdateActive-->" + ex.Message + sql.ToString(), ex);
}
}
//保存活動
public bool SaveEventPromoAdditionalPrice(EventPromoAdditionalPrice model, List<EventPromoAdditionalPriceProduct> models, string condiType)
{
ArrayList _list = new ArrayList();
MySqlCommand mySqlCmd = new MySqlCommand();
MySqlConnection mySqlConn = new MySqlConnection(conn);
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;
if (model.row_id == 0)//新增
{
model.event_type = "AD";
model.create_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
model.create_time = DateTime.Now;
mySqlCmd.CommandText = dao.AddOrUpdate(model);
model.row_id =Convert.ToInt32(mySqlCmd.ExecuteScalar());
model.modify_user = model.create_user;
model.modify_time = model.create_time;
model.event_id = Common.CommonFunction.GetEventId(model.event_type, model.row_id.ToString());
_list.Add(dao.AddOrUpdate(model));
//處理輔表
EventPromoAdditionalPriceProductDao _epgDao = new EventPromoAdditionalPriceProductDao(conn);
foreach (EventPromoAdditionalPriceProduct item in models)
{
item.group_id = model.group_id;
item.create_user = model.create_user;
item.create_time = model.create_time;
item.modify_user = item.create_user;
item.modify_time = item.create_time;
_list.Add(_epgDao.AddOrUpdate(item));
}
//處理輔表活動商品設定
_list.AddRange(InsertCondiType(model, condiType));
}
else//編輯
{
model.event_type = "AD";
model.modify_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
model.modify_time = DateTime.Now;
model.event_id = Common.CommonFunction.GetEventId(model.event_type, model.row_id.ToString());
_list.Add(dao.AddOrUpdate(model));
EventPromoAdditionalPriceProductDao _epdDao = new EventPromoAdditionalPriceProductDao(conn);
string row_ids = "";
foreach (EventPromoAdditionalPriceProduct item in models)
{
item.modify_user = model.modify_user;
item.modify_time = model.modify_time;
_list.Add(_epdDao.AddOrUpdate(item));
if (item.row_id != 0)
{
row_ids = row_ids + item.row_id + ",";
}
}
row_ids = row_ids.TrimEnd(',');
var row_id = row_ids.Split(',');
EventPromoAdditionalPriceProductQuery product = new EventPromoAdditionalPriceProductQuery();
product.group_id = model.group_id;
List<EventPromoAdditionalPriceProductQuery> product_models = _epdDao.GetList(product);
string del_row_ids = string.Empty;//存放本次刪除的
foreach (EventPromoAdditionalPriceProduct item in product_models)
{
if (!row_id.Contains(item.row_id.ToString()))
{
del_row_ids = del_row_ids + item.row_id.ToString() + ",";
}
}
if (!string.IsNullOrEmpty(del_row_ids))
{
del_row_ids = del_row_ids.TrimEnd(',');
_list.Add(_epdDao.Delete(model.group_id.ToString(), del_row_ids));
}
//處理輔表活動商品設定
EventPromoBrandDao _epbDao = new EventPromoBrandDao(conn);
_list.Add(_epbDao.Delete(model.event_id));
EventPromoCategoryDao _epcateDao = new EventPromoCategoryDao(conn);
_list.Add(_epcateDao.Delete(model.event_id));
EventPromoClassDao _epclassDao = new EventPromoClassDao(conn);
_list.Add(_epclassDao.Delete(model.event_id));
EventPromoPaymentDao _eppayDao = new EventPromoPaymentDao(conn);
_list.Add(_eppayDao.Delete(model.event_id));
EventPromoShoppingcartDao _epcartDao = new EventPromoShoppingcartDao(conn);
_list.Add(_epcartDao.Delete(model.event_id));
EventPromoProductDao _epproDao = new EventPromoProductDao(conn);
_list.Add(_epproDao.Delete(model.event_id));
_list.AddRange(InsertCondiType(model, condiType));
}
for (int i = 0; i < _list.Count; i++)
{
mySqlCmd.CommandText = _list[i].ToString();
mySqlCmd.ExecuteNonQuery();
}
mySqlCmd.Transaction.Commit();
return true;
}
catch (Exception ex)
{
mySqlCmd.Transaction.Rollback();
return false;
throw new Exception("EventPromoAdditionalPriceMgr-->SaveEventPromoAdditionalPrice" + ex.Message, ex);
}
finally
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Open)
{
mySqlConn.Close();
}
}
}
public bool UpdateActive(EventPromoAdditionalPrice model)
{
ArrayList _list = new ArrayList();
try
{
_list.Add(dao.UpdateActive(model));
//處理輔表活動商品設定
if (model.condition_type == 1)
{
EventPromoBrandDao _epbDao = new EventPromoBrandDao(conn);
_list.Add(_epbDao.UpdateActive(new EventPromoBrand { event_status = model.event_status, modify_user = model.modify_user, modify_time = model.modify_time, event_id = model.event_id }));
}
else if (model.condition_type == 2)
{
EventPromoCategoryDao _epcateDao = new EventPromoCategoryDao(conn);
_list.Add(_epcateDao.UpdateActive(new EventPromoCategory { event_status = model.event_status, modify_user = model.modify_user, modify_time = model.modify_time, event_id = model.event_id }));
}
else if (model.condition_type == 3)
{
EventPromoClassDao _epclassDao = new EventPromoClassDao(conn);
_list.Add(_epclassDao.UpdateActive(new EventPromoClass { event_status = model.event_status, modify_user = model.modify_user, modify_time = model.modify_time, event_id = model.event_id }));
}
else if (model.condition_type == 4)
{
EventPromoProductDao _epproDao = new EventPromoProductDao(conn);
_list.Add(_epproDao.UpdateActive(new EventPromoProduct { event_status = model.event_status, modify_user = model.modify_user, modify_time = model.modify_time, event_id = model.event_id }));
}
else if (model.condition_type == 5)
{
EventPromoShoppingcartDao _epcartDao = new EventPromoShoppingcartDao(conn);
_list.Add(_epcartDao.UpdateActive(new EventPromoShoppingcart { event_status = model.event_status, modify_user = model.modify_user, modify_time = model.modify_time, event_id = model.event_id }));
}
else if (model.condition_type == 6)
{
EventPromoPaymentDao _eppayDao = new EventPromoPaymentDao(conn);
_list.Add(_eppayDao.UpdateActive(new EventPromoPayment { event_status = model.event_status, modify_user = model.modify_user, modify_time = model.modify_time, event_id = model.event_id }));
}
MySqlDao _mySqlDao = new MySqlDao(conn);
return _mySqlDao.ExcuteSqls(_list);
}
catch (Exception ex)
{
throw new Exception("EventPromoAdditionalPriceMgr-->UpdateActive" + ex.Message, ex);
}
}
//商品設定
public ArrayList InsertCondiType(EventPromoAdditionalPrice model, string condiType)
{
ArrayList _list = new ArrayList();
if (!string.IsNullOrEmpty(condiType))
{
var arryType = condiType.Split(',');
if (model.condition_type == 1)//按品牌
{
foreach (string iType in arryType)
{
EventPromoBrand epb = new EventPromoBrand();
epb.event_type = model.event_type;
epb.site_id = model.site_id;
epb.brand_id = Convert.ToInt32(iType);
epb.event_id = model.event_id;
epb.event_status = model.event_status;
epb.create_user = model.create_user;
epb.create_time = model.create_time;
epb.modify_user = epb.create_user;
epb.modify_time = epb.create_time;
epb.event_start = model.event_start;
epb.event_end = model.event_end;
EventPromoBrandDao _epbDao = new EventPromoBrandDao(conn);
_list.Add(_epbDao.AddOrUpdate(epb));
}
}
else if (model.condition_type == 2)//類別
{
foreach (string iType in arryType)
{
EventPromoCategory epcate = new EventPromoCategory();
epcate.event_type = model.event_type;
epcate.site_id = model.site_id;
epcate.category_id = Convert.ToInt32(iType);
epcate.event_id = model.event_id;
epcate.event_status = model.event_status;
epcate.create_user = model.create_user;
epcate.create_time = model.create_time;
epcate.modify_user = epcate.create_user;
epcate.modify_time = epcate.create_time;
epcate.event_start = model.event_start;
epcate.event_end = model.event_end;
EventPromoCategoryDao _epcateDao = new EventPromoCategoryDao(conn);
_list.Add(_epcateDao.AddOrUpdate(epcate));
}
}
else if (model.condition_type == 3)//館別
{
foreach (string iType in arryType)
{
EventPromoClass epclass = new EventPromoClass();
epclass.event_type = model.event_type;
epclass.site_id = model.site_id;
epclass.class_id = Convert.ToInt32(iType);
epclass.event_id = model.event_id;
epclass.event_status = model.event_status;
epclass.create_user = model.create_user;
epclass.create_time = model.create_time;
epclass.modify_user = epclass.create_user;
epclass.modify_time = epclass.create_time;
epclass.event_start = model.event_start;
epclass.event_end = model.event_end;
EventPromoClassDao _epclassDao = new EventPromoClassDao(conn);
_list.Add(_epclassDao.AddOrUpdate(epclass));
}
}
else if (model.condition_type == 4)//商品
{
foreach (string iType in arryType)
{
var arryPro = iType.Split('&');
EventPromoProduct eppro = new EventPromoProduct();
eppro.event_type = model.event_type;
eppro.site_id = model.site_id;
eppro.product_id = Convert.ToInt32(arryPro[0]);
eppro.product_num_limit = Convert.ToInt32(arryPro[1]);
eppro.event_id = model.event_id;
eppro.event_status = model.event_status;
eppro.create_user = model.create_user;
eppro.create_time = model.create_time;
eppro.modify_user = eppro.create_user;
eppro.modify_time = eppro.create_time;
eppro.event_start = model.event_start;
eppro.event_end = model.event_end;
EventPromoProductDao _epproDao = new EventPromoProductDao(conn);
_list.Add(_epproDao.AddOrUpdate(eppro));
}
}
else if (model.condition_type == 5)//購物車
{
foreach (string iType in arryType)
{
EventPromoShoppingcart epcart = new EventPromoShoppingcart();
epcart.event_type = model.event_type;
//epcart.site_id = epaGift.site_id;
epcart.cart_id = Convert.ToInt32(iType);
epcart.event_id = model.event_id;
epcart.event_status = model.event_status;
epcart.create_user = model.create_user;
epcart.create_time = model.create_time;
epcart.modify_user = epcart.create_user;
epcart.modify_time = epcart.create_time;
epcart.event_start = model.event_start;
epcart.event_end = model.event_end;
EventPromoShoppingcartDao _epcartDao = new EventPromoShoppingcartDao(conn);
_list.Add(_epcartDao.AddOrUpdate(epcart));
}
}
else if (model.condition_type == 6)//付款方式
{
foreach (string iType in arryType)
{
EventPromoPayment eppay = new EventPromoPayment();
eppay.event_type = model.event_type;
eppay.site_id = model.site_id;
eppay.payment_id = Convert.ToInt32(iType);
eppay.event_id = model.event_id;
eppay.event_status = model.event_status;
eppay.create_user = model.create_user;
eppay.create_time = model.create_time;
eppay.modify_user = eppay.create_user;
eppay.modify_time = eppay.create_time;
eppay.event_start = model.event_start;
eppay.event_end = model.event_end;
EventPromoPaymentDao _eppayDao = new EventPromoPaymentDao(conn);
_list.Add(_eppayDao.AddOrUpdate(eppay));
}
}
}
return _list;
}
public JsonResult UpdateActiveAdditionalPrice()
{
try
{
int currentUser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
int activeValue = Convert.ToInt32(Request.Params["active"]);
if (Convert.ToInt32(Request.Params["mo_user"]) == currentUser && activeValue == 1)
{
return Json(new { success = "stop" });
}
else
{
string event_id = Request.Params["event_id"].ToString();
EventPromoAdditionalPrice model = new EventPromoAdditionalPrice();
model.modify_user = currentUser;
model.modify_time = DateTime.Now;
model.event_id = event_id;
model.event_status = activeValue;
model.condition_type = Convert.ToInt32(Request.Params["type"]);
epapMgr = new EventPromoAdditionalPriceMgr(mySqlConnectionString);
if (epapMgr.UpdateActive(model))
{
return Json(new { success = "true" });
}
else
{
return Json(new { success = "false" });
}
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
return Json(new { success = "false" });
}
}