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