/// <summary> /// /// </summary> /// <returns>數據庫操作結果</returns> public JsonResult UpdateActive() { string currentUser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString(); string muser = string.Empty; int activeValue = Convert.ToInt32(Request.Params["active"]); if (!string.IsNullOrEmpty(Request.Params["muser"])) { muser = (Request.Params["muser"]); } if (currentUser == muser && activeValue == 1) { return Json(new { success = "stop" }); } _promopairMgr = new PromoPairMgr(mySqlConnectionString); int id = Convert.ToInt32(Request.Params["id"]); PromoPairQuery model = _promopairMgr.Select(id); model.category_link_url = _produCateMgr.GetModelById(Convert.ToUInt32(model.category_id)).category_link_url; model.active = Convert.ToBoolean(activeValue); model.event_id = CommonFunction.GetEventId(model.event_type, model.id.ToString()); model.muser = currentUser; model.modified = DateTime.Now; if (_promopairMgr.UpdateActive(model) > 0) { return Json(new { success = "true", msg = "" }); } else { return Json(new { success = "false", msg = "" }); } }
public HttpResponseBase SaveOne() { string jsonStr = String.Empty; try { PromoPair model = new PromoPair(); _promopairMgr = new PromoPairMgr(mySqlConnectionString); model.event_type = "P1"; model.event_name = Request.Params["name"].ToString(); model.event_desc = Request.Params["desc"].ToString(); model.kuser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString(); model.created = DateTime.Now; model.muser = model.kuser; model.modified = model.created; model.id = _promopairMgr.Save(model); // _promopairMgr.Save(model); System.Data.DataTable dt = _promopairMgr.Select(model); //_promopairMgr.Select(query); if (dt.Rows.Count > 0) { jsonStr = "{success:true,id:" + dt.Rows[0]["id"] + ",cateID:" + dt.Rows[0]["category_id"] + ",cate_red:" + dt.Rows[0]["cate_red"] + ",cate_green:" + dt.Rows[0]["cate_green"] + "}"; } else { jsonStr = "{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); jsonStr = "{success:false}"; } this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; }