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