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" }); } }