/// <summary> /// 更改活動狀態 /// </summary> /// <param name="store">點數抵用的Model</param> /// <returns></returns> public int UpdateActive(PromotionsDeductRate store) { StringBuilder sb = new StringBuilder(); store.Replace4MySQL(); sb.AppendFormat("update `promotions_deduct_rate` AS `PDR` set `PDR`.`active` ={0},PDR.modified='{1}',PDR.muser={2} where `PDR`.`id`={3}", store.active,CommonFunction.DateTimeToString(store.modified),store.muser, store.id); try { return _access.execCommand(sb.ToString()); } catch (Exception ex) { throw new Exception("PromotionsDeductRateDao-->UpdateActive-->" + ex.Message + sb.ToString(), ex); } }
/// <summary> /// 刪除數據 /// </summary> /// <returns></returns> public HttpResponseBase Delete() { string jsonStr = String.Empty; _promDRate = new PromotionsDeductRateMgr(mySqlConnectionString); PromotionsDeductRate query = new PromotionsDeductRate(); if (!String.IsNullOrEmpty(Request.Params["rowid"])) { try { foreach (string rid in Request.Params["rowid"].ToString().Split('|')) { if (!string.IsNullOrEmpty(rid)) { query.id = Convert.ToInt32(rid); _promDRate.Delete(query); } } jsonStr = "{success:true}"; } 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); jsonStr = "{success:true}"; } } this.Response.Clear(); this.Response.Write(jsonStr); this.Response.End(); return this.Response; }
/// <summary> /// 更改活動使用狀態 /// </summary> /// <returns>數據庫操作結果</returns> public JsonResult UpdateActive() { try { string currentUser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString(); string muser = Request.Params["muser"]; int activeValue = Convert.ToInt32(Request.Params["active"]); if (currentUser == muser && activeValue == 1) { return Json(new { success = "stop" }); } _promDRate = new PromotionsDeductRateMgr(mySqlConnectionString); PromotionsDeductRate model = new PromotionsDeductRate(); if (!string.IsNullOrEmpty(Request.Params["id"])) { model.id = Convert.ToInt32(Request.Params["id"]); } model.active = Convert.ToBoolean(activeValue); model.muser = int.Parse(currentUser); model.modified = DateTime.Now; if (_promDRate.UpdateActive(model) > 0) { return Json(new { success = "true", msg = "" }); } else { return Json(new { success = "false", msg = "" }); } } 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", msg = "" }); } }
/// <summary> /// 編輯時獲取到某行的數據 /// </summary> /// <returns></returns> public HttpResponseBase GetOneModelPage() { string json = string.Empty; try { PromotionsDeductRate PDR = new PromotionsDeductRate(); _promDRate = new PromotionsDeductRateMgr(mySqlConnectionString); if (!string.IsNullOrEmpty(Request.Params["rowid"])) { PDR.id = Convert.ToInt32(Request.Params["rowid"].ToString()); } PDR = _promDRate.GetMOdel(PDR.id); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; //listUser是准备转换的对象 json = "{success:true,data:" + JsonConvert.SerializeObject(PDR, Formatting.Indented, timeConverter) + "}"; } 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); json = "{success:false}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
/// <summary> /// 修改功能 PromotionsAmountFare /// </summary> /// <param name="model"></param> /// <returns></returns> protected HttpResponseBase UpdatePromotionsDeductRate(PromotionsDeductRate model) { string json = string.Empty; try { _promDRate.Update(model); json = "{success:true}";//返回json數據 } 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); json = "{success:false}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
/// <summary> /// 保存前臺新增或者修改的數據 /// </summary> /// <returns></returns> public HttpResponseBase Save() { PromotionsDeductRate model = new PromotionsDeductRate(); model.muser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; model.modified = DateTime.Now; //判斷是否能夠獲取到rowid if (String.IsNullOrEmpty(Request.Params["rowid"])) { model.created = model.modified; model.kuser = model.muser; try { model.amount = Convert.ToInt32(Request.Params["amount"]); } catch (Exception) { model.amount = 0; } try { model.end = Convert.ToDateTime(Request.Params["end"]); } catch (Exception) { model.end = DateTime.Now; } if (Request.Params["group_id"].ToString() != "") { try//group_id { model.group_id = Convert.ToInt32(Request.Params["group_id"].ToString()); } catch (Exception) { model.group_id = 0; } model.condition_id = 0; } else if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0") { try//condition_id { model.condition_id = Convert.ToInt32(Request.Params["condition_id"].ToString()); } catch (Exception) { model.condition_id = 0; } model.group_id = 0; } try { model.start = Convert.ToDateTime(Request.Params["startdate"]); } catch (Exception) { model.start = DateTime.Now; } try { model.bonus_type = Convert.ToInt32(Request.Params["bonus_type"]); } catch (Exception) { model.bonus_type = 0; } try { model.rate = Convert.ToInt32(Request.Params["rate"]); } catch (Exception) { model.rate = 0; } try { model.name = Request.Params["name"]; } catch (Exception) { model.name = ""; } try { model.dollar = Convert.ToInt32(Request.Params["dollar"]); } catch (Exception) { model.dollar = 0; } try { model.point = Convert.ToInt32(Request.Params["point"]); } catch (Exception) { model.point = 0; } //todo:對model進行賦值 return InsertPromotionsDeductRate(model);//如果獲取不到則進行新增 } else { _promDRate = new PromotionsDeductRateMgr(mySqlConnectionString); model.id = Convert.ToInt32(Request.Params["rowid"].ToString()); PromotionsDeductRate PDR = _promDRate.GetMOdel(model.id); try { model.amount = Convert.ToInt32(Request.Params["amount"]); } catch (Exception) { model.amount = PDR.amount; } try { model.end = Convert.ToDateTime(Request.Params["end"]); } catch (Exception) { model.end = PDR.end; } try { model.bonus_type = Convert.ToInt32(Request.Params["bonus_type"]); } catch (Exception) { model.bonus_type = 0; } if (Request.Params["group_id"].ToString() != "") { try//group_id { model.group_id = Convert.ToInt32(Request.Params["group_id"].ToString()); } catch (Exception) { model.group_id = PDR.group_id; } model.condition_id = 0; } else if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0") { try//condition_id { model.condition_id = Convert.ToInt32(Request.Params["condition_id"].ToString()); } catch (Exception) { model.condition_id = PDR.condition_id; } model.group_id = 0; } try { model.start = Convert.ToDateTime(Request.Params["startdate"]); } catch (Exception) { model.start = PDR.start; } try { model.rate = Convert.ToInt32(Request.Params["rate"]); } catch (Exception) { model.rate = PDR.rate; } try { model.name = Request.Params["name"]; } catch (Exception) { model.name = PDR.name; } try { model.dollar = Convert.ToInt32(Request.Params["dollar"]); } catch (Exception) { model.dollar = PDR.dollar; } try { model.point = Convert.ToInt32(Request.Params["point"]); } catch (Exception) { model.point = PDR.point; } model.active = false; return UpdatePromotionsDeductRate(model); } }