/// <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;
}