public JsonResult UpStatus() { 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" }); } string musers = string.Empty; string rids=string.Empty; string rid = Request.Params["id"]; if (!string.IsNullOrEmpty(Request.Params["musers"])) { musers = Request.Params["musers"]; string[] muser1 = musers.TrimEnd(',').Split(','); List<int> num = new List<int>(); for (int i = 0; i < muser1.Length; i++) { if (muser1[i] != currentUser || activeValue==0) { num.Add(i); } } if(num.Count==0) { return Json(new { success = "stop" }); } string[] rids1 = rid.TrimEnd(',').Split(','); for (int i = 0; i < num.Count; i++) { rids += rids1[num[i]] + ","; } } _procateMgr = new ProductCategoryMgr(connectionString); ProdPromoQuery store = new ProdPromoQuery(); store.rids = rids.TrimEnd(',') == "" ? rid.TrimEnd(',') : rids.TrimEnd(','); store.muser = currentUser; store.mdate = DateTime.Now; store.status = activeValue; if (_procateMgr.UpStatus(store) > 0) { return Json(new { success = "true", msg = "" }); } else { return Json(new { success = "false", msg = "" }); } }
public int UpStatus(ProdPromoQuery store) { try { return _cateDao.UpStatus(store); } catch (Exception ex) { throw new Exception("ProductCategoryMgr-->UpStatus->" + ex.Message, ex); } }
/// <summary> /// 更改活動状态 /// </summary> /// <param name="store">ProdPromo</param> /// <returns>受影响行数</returns> public int UpStatus(ProdPromoQuery store) { StringBuilder sbSql = new StringBuilder(); try { sbSql.AppendFormat(@"update prod_promo set `status`='{0}',mdate='{1}',muser='******' where rid in ({3})",store.status,Common.CommonFunction.DateTimeToString(store.mdate),store.muser,store.rids); return _access.execCommand(sbSql.ToString()); } catch (Exception ex) { throw new Exception("ProductCategoryDao-->UpStatus-->" + ex.Message + sbSql.ToString(), ex); } }