/// <summary> /// 增加,移除ColledIDS中的该用户ID /// </summary> /// <action>1:增加,2移除</action> public bool UpdateColled(int uid, int id, int action) { string ids = DBCenter.ExecuteScala(TbName, "ColledIDS", "ID=" + id).ToString(); switch (action) { case 1: //增加 ids = StrHelper.AddToIDS(ids, uid.ToString()); break; case 2: //移除 ids = StrHelper.RemoveToIDS(ids, uid.ToString()); break; } return(DBCenter.UpdateSQL(TbName, "ColledIDS='" + ids + "'", "ID=" + id)); }
//protected void Search_Btn_Click(object sender, EventArgs e) //{ // Response.Redirect("/Plat/Blog/?Skey=" + Main_Skey_T.Text.Trim()); //} private void GetNotify(M_User_Plat upMod) { //用户登录,检测有消息则提示 B_Common_Notify comBll = new B_Common_Notify(); DataTable dt = comBll.Blog_SelMy(upMod.UserID); foreach (DataRow dr in dt.Rows)//移除rows中的值,并添加已读列表 { B_User_Notify.Add(dr["Title"].ToString(), dr["Content"].ToString(), upMod.UserID.ToString()); string rece = StrHelper.RemoveToIDS(dr["ReceUsers"].ToString(), upMod.UserID.ToString()); string readed = StrHelper.AddToIDS(dr["ReadedUsers"].ToString(), upMod.UserID.ToString()); List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter("rece", rece), new SqlParameter("readed", readed) }; DBCenter.UpdateSQL("ZL_Common_Notify", "ReadedUsers=@readed,ReceUsers=@rece", "ID=" + dr["ID"], sp); } }
public IActionResult ReqRepair_Add() { int Cid = DataConverter.CLng(RequestEx["cid"]); M_CartPro cartMod = cartBll.SelReturnModel(Cid); if (repBll.SelByCartID(Cid) != null) { return(WriteErr("该商品已申请售后,不可重复申请!", "MyOrderRepair")); } //---------------------- M_Order_Repair repairMod = new M_Order_Repair(); repairMod.Deailt = RequestEx["Deailt"]; repairMod.CretType = RequestEx["cret"]; repairMod.ReProType = DataConverter.CLng(RequestEx["ReProType_Hid"]); repairMod.TakeProCounty = RequestEx["province_dp"] + " " + RequestEx["city_dp"] + " " + RequestEx["county_dp"]; repairMod.TakeProAddress = RequestEx["TakeProAddress"]; repairMod.ReProCounty = RequestEx["reprovince_dp"] + " " + RequestEx["recity_dp"] + " " + RequestEx["recounty_dp"]; repairMod.ReProAddress = RequestEx["ReProAddress"]; repairMod.UserName = RequestEx["UserName"]; repairMod.Phone = RequestEx["Phone"]; repairMod.ProImgs = RequestEx["Attach_Hid"]; repairMod.ProID = cartMod.ProID; repairMod.OrderNO = orderBll.SelReturnModel(cartMod.Orderlistid).OrderNo; repairMod.ServiceType = RequestEx["ServicesType_Hid"]; repairMod.UserID = mu.UserID; repairMod.CartID = cartMod.ID; repairMod.ProNum = DataConverter.CLng(RequestEx["ProNum"]); //---------------------- if (repairMod.ProNum > cartMod.Pronum) { return(WriteErr("退换商品数量不能大于购买数量")); } repBll.Insert(repairMod); cartMod.AddStatus = StrHelper.AddToIDS(cartMod.AddStatus, repairMod.ServiceType); cartBll.UpdateByID(cartMod); return(WriteOK("添加成功!", "MyOrderRepair")); }
public string AddManager(string uids, int structID, string op = "add") { SafeSC.CheckIDSEx(uids); if (structID < 1 || string.IsNullOrEmpty(uids)) { return(""); } M_Structure strMod = SelReturnModel(structID); if (op.Equals("add")) { strMod.ManagerIDS = StrHelper.AddToIDS(strMod.ManagerIDS, uids.Split(',')); } else { strMod.ManagerIDS = StrHelper.RemoveRepeat(strMod.ManagerIDS.Split(','), uids.Split(',')); } string sql = "UPDATE " + TbName + " SET ManagerIDS=@uids WHERE ID=" + structID; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("uids", strMod.ManagerIDS) }; SqlHelper.ExecuteNonQuery(CommandType.Text, sql, sp); return(strMod.ManagerIDS); }
public void Share_Add() { int OrderID = DataConvert.CLng(Request.QueryString["OrderID"]); int cartid = DataConverter.CLng(Request.Form["cart_rad"]); //购买时间与商品信息也需要写入 M_CartPro cartProMod = cartProBll.SelReturnModel(cartid); cartProMod.AddStatus = StrHelper.AddToIDS(cartProMod.AddStatus, "comment");//换为枚举 M_Order_Share shareMod = new M_Order_Share(); shareMod.Title = Request.Form["Title_T"]; shareMod.MsgContent = Request.Form["MsgContent_T"]; shareMod.UserID = mu.UserID; shareMod.IsAnonymous = string.IsNullOrEmpty(Request.Form["IsHideName"])? 1 : 0; shareMod.Score = DataConverter.CLng(Request.Form["star_hid"]); if (shareMod.Score > 5) { shareMod.Score = 5; } shareMod.Imgs = Request.Form["Attach_Hid"]; shareMod.Labels = ""; shareMod.OrderID = cartProMod.Orderlistid; shareMod.ProID = cartProMod.ProID; shareMod.OrderDate = cartProMod.Addtime; shareBll.Insert(shareMod); cartProBll.UpdateByID(cartProMod); DataTable dt = cartProBll.SelForRPT(OrderID, "comment"); if (dt.Rows.Count < 1) { function.WriteSuccessMsg("评价成功,将跳转至商品页", orderCom.GetShopUrl(cartProMod.StoreID, cartProMod.ProID)); return; //返回商品页,或对应的商品页 } else { function.WriteErrMsg("评价成功"); } }
//会员特选商品逻辑 private void IsUserProduct(M_Product proMod, string olduids, string newuids) { #region 特选商品 //有更改则执行特选商品 string uids = StrHelper.IDS_GetChange(olduids, newuids);//uprouids_old_hid.Value, uprouids_hid.Value if (!string.IsNullOrEmpty(uids)) { //1,目标表中可能无数据 //2,只对变更部分操作 //目的:会员可知道自己有哪些商品,商品处也可知道可有哪些特选 string[] add = uids.Split('|')[0].Split(','); string[] remove = uids.Split('|')[1].Split(','); foreach (string id in add) { int uid = DataConvert.CLng(id); if (uid < 1) { continue; } M_User_BindPro bindMod = bindBll.SelModelByUid(uid); if (bindMod == null) { bindMod = new M_User_BindPro() { UserID = uid }; } bindMod.ProIDS = StrHelper.AddToIDS(bindMod.ProIDS, proMod.ID.ToString()); if (bindMod.ID > 0) { bindBll.UpdateByID(bindMod); } else { bindBll.Insert(bindMod); } } foreach (string id in remove) { int uid = DataConvert.CLng(id); if (uid < 1) { continue; } M_User_BindPro bindMod = bindBll.SelModelByUid(uid); if (bindMod == null) { bindMod = new M_User_BindPro() { UserID = uid }; } bindMod.ProIDS = StrHelper.RemoveToIDS(bindMod.ProIDS, proMod.ID.ToString()); if (bindMod.ID > 0) { bindBll.UpdateByID(bindMod); } else { bindBll.Insert(bindMod); } } } #endregion }
public ActionResult QuestAPI() { string action = Request["action"] ?? ""; int qid = DataConverter.CLng(Request["qid"]); int qtype = DataConverter.CLng(Request["qtype"]); string qids = (Request["qids"] ?? "").Trim(','); while (qids.Contains(",,")) { qids.Replace(",,", ","); } int result = Failed; M_Temp tempMod = new M_Temp(); switch (action) { case "cart_add": //试题篮 tempMod = GetCartByUid(mu.UserID); tempMod.Str1 = StrHelper.AddToIDS(tempMod.Str1, qid.ToString()); AddORUpdate(tempMod); result = Success; break; case "cart_adds": if (string.IsNullOrEmpty(qids)) { break; } tempMod = GetCartByUid(mu.UserID); foreach (string q in qids.Split(',')) { if (string.IsNullOrEmpty(q)) { continue; } tempMod.Str1 = StrHelper.AddToIDS(tempMod.Str1, q); } AddORUpdate(tempMod); result = Success; break; case "cart_remove": tempMod = GetCartByUid(mu.UserID); tempMod.Str1 = StrHelper.RemoveToIDS(tempMod.Str1, qid.ToString()); AddORUpdate(tempMod); result = Success; break; case "cart_clear": tempMod = GetCartByUid(mu.UserID); tempMod.Str1 = ""; AddORUpdate(tempMod); result = Success; break; case "collect_add": //试题收藏与移除 break; case "collect_remove": break; } return(Content(result.ToString())); }