/// <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> /// 保存前臺新增或者修改的數據 /// </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); } }