/// <summary> /// 检测手机验证码,10分钟内有效|存数据库|可换浏览器验证|未验证成功不会取消|必须手机与验证码同时匹配 /// </summary> public static CommonReturn CheckVaildCode(string mobile, string code, string source) { B_Safe_Mobile mobBll = new B_Safe_Mobile(); M_Safe_Mobile model = mobBll.SelLastModel(mobile); if (string.IsNullOrEmpty(mobile)) { return(CommonReturn.Failed("手机号码不能为空")); } if (string.IsNullOrEmpty(code)) { return(CommonReturn.Failed("验证码不能为空")); } if (model == null) { return(CommonReturn.Failed("验证码信息不存在")); } if (model.ZStatus != 0) { return(CommonReturn.Failed("验证码无效")); } if ((DateTime.Now - model.CDate > TimeSpan.FromMinutes(10))) { return(CommonReturn.Failed("验证码过期")); } if (!model.VCode.Equals(code)) { return(CommonReturn.Failed("手机验证码不匹配")); } DBCenter.UpdateSQL(model.TbName, "ZStatus=99", "ID=" + model.ID); return(CommonReturn.Success()); }
public int Product_OP(string ids) { string action = RequestEx["a"]; if (string.IsNullOrEmpty(ids)) { return(Failed); } switch (action) { case "order": //排序本店商品 { M_Store_Info storeMod = storeBll.SelModelByUser(mu.UserID); DataTable dt = JsonConvert.DeserializeObject <DataTable>(Request.Form["list"]); foreach (DataRow dr in dt.Rows) { int id = DataConvert.CLng(dr["ID"]); int orderID = DataConvert.CLng(dr["order"]); if (orderID < 0) { orderID = 0; } DBCenter.UpdateSQL("ZL_Commodities", "ComModelID=" + orderID, "ID=" + id + " AND UserShopID=" + storeMod.ID); } } break; default: proBll.setproduct(action, ids); break; } return(Success); }
//结算,到订单页再生成AllMoney protected void NextStep_Click(object sender, EventArgs e) { //AJAX就先检测一遍,未登录则弹窗 B_User.CheckIsLogged(Request.RawUrl); M_UserInfo mu = buser.GetLogin(); //提交前同步一次,避免即时登录造成的cart中id未与用户关联 CartDT = cartBll.SelByCartID(CartCookID, mu.UserID, ProClass); //从数据库中获取 //获取所有购物车的记录,更新信息 for (int i = 0; i < CartDT.Rows.Count; i++) { // //Additional {\"age\":\"\",\"weight\":\"\",\"type\":\"\"} DataRow dr = CartDT.Rows[i]; string id = dr["id"].ToString(); dr["Additional"] = JsonHelper.GetJson( new string[] { "age", "weight", "type" }, new string[] { Request.Form["age_" + id], Request.Form["weight_" + id], Request.Form["type_" + id] }); dr["UserID"] = mu.UserID; string set = "UserID=" + mu.UserID + ",Additional=@addon"; List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter("addon", dr["Additional"].ToString()) }; DBCenter.UpdateSQL("ZL_Cart", set, "ID=" + dr["ID"], sp); } string ids = Request.Form["prochk"]; Response.Redirect("GetOrderInfo.aspx?ids=" + ids + "&ProClass=" + ProClass);//"#none" }
/// <summary> /// 双卡激活 /// </summary> public bool DoubleActivation(string card1, string card2, int uid) { if (card1 == card2) { return(false); } //不能传入同一个卡号 M_Card cardMod1 = SelectNum(card1); M_Card cardMod2 = SelectNum(card2); if (cardMod1.CardNum == string.Empty || cardMod2.CardNum == string.Empty) { return(false); } //卡号不存在 if (cardMod1.ActivateState == 1 || cardMod2.ActivateState == 1) { return(false); } //已被使用 if (cardMod1.CircumscribeTime < DateTime.Now || cardMod2.CircumscribeTime < DateTime.Now) { return(false); } //已过期 string set = "StartTime = @time , ActivateState = 1 , ActivateUserID = " + uid; string where = "CardNum = @card1 OR CardNum = @card2"; List <SqlParameter> sp = new List <SqlParameter>(); sp.Add(new SqlParameter("time", DateTime.Now.ToString())); sp.Add(new SqlParameter("card1", card1)); sp.Add(new SqlParameter("card2", card2)); return(DBCenter.UpdateSQL(TbName, set, where, sp)); }
public ContentResult PubInfo_API() { string action = GetParam("action"); int pubId = DataConvert.CLng(GetParam("pubid")); string ids = GetParam("ids"); SafeSC.CheckIDSEx(ids); M_Pub pubMod = pubBll.SelReturnModel(pubId); if (pubMod == null) { throw new Exception("未指定互动模型"); } switch (action) { case "del": DBCenter.DelByIDS(pubMod.PubTableName, "ID", ids); break; case "audit": DBCenter.UpdateSQL(pubMod.PubTableName, "PubStart=1", "ID IN (" + ids + ")"); break; case "cancel": DBCenter.UpdateSQL(pubMod.PubTableName, "PubStart=0", "ID IN (" + ids + ")"); break; } return(Content(Success.ToString())); }
protected void Ignore_Btn_Click(object sender, EventArgs e) { int Mid = DataConvert.CLng(Mid_Hid.Value); DBCenter.UpdateSQL("ZL_Logo_Design", "ZStatus=99", "ID=" + Mid); Response.Redirect(Request.RawUrl); }
/// <summary> /// 确认或拒绝好友申请 /// </summary> public void SureApply(int id, ConStatus status) { B_User_Friend friBll = new B_User_Friend(); switch (status) { case ConStatus.Reject: break; case ConStatus.Audited: //通过申请,将其加为好友 M_User_FriendApply model = SelReturnModel(id); if (!friBll.IsFriend(model.UserID, model.TUserID)) { friBll.Insert(new M_User_Friend() { UserID = model.UserID, TUserID = model.TUserID, ZStatus = (int)ConStatus.Audited, FType = 0 }); } break; } DBCenter.UpdateSQL(TbName, "ZStatus=" + (int)status, "ID=" + id); }
public int DelByUID(int uid) { int count = DBCenter.Count(TbName, "CUser = "******" AND Status != " + ((int)ConStatus.Recycle)); DBCenter.UpdateSQL(TbName, "Status=" + ((int)ConStatus.Recycle), "CUser=" + uid); return(count); }
/// <summary> /// 移除用户,用法同于AddMember /// </summary> /// <param name="ids">需移除的用户</param> public void DelMember(string ids, int gid, int flag = 0) { SafeSC.CheckDataEx(ids); string uids = "", uids2 = "", set = ""; M_Plat_Group model = SelReturnModel(gid); switch (flag) { case 0: //管理员与成员 uids = function.RemoveRepeat(model.MemberIDS, ids); uids2 = function.RemoveRepeat(model.ManageIDS, ids); set = "MemberIDS= '" + uids + "',ManageIDS='" + uids2 + "'"; break; case 1: uids = function.RemoveRepeat(model.MemberIDS, ids); set = "MemberIDS= '" + uids + "'"; break; case 2: uids = function.RemoveRepeat(model.ManageIDS, ids); set = "ManageIDS= '" + uids + "'"; break; } DBCenter.UpdateSQL(TbName, set, "ID=" + gid); }
public IActionResult Sort_API() { //tbname,字段规则 string orderStr = DataConvert.CStr(RequestEx["orderStr"]).Trim(','); if (string.IsNullOrEmpty(orderStr)) { return(Content(Failed.ToString())); } string[] orderArr = orderStr.Split(','); foreach (string item in orderArr) { int id = DataConvert.CLng(item.Split(':')[0]); int order = DataConvert.CLng(item.Split(':')[1]); switch (TbName.ToLower()) { case "commonmodel": DBCenter.UpdateSQL(TableName, "OrderID=" + order, "GeneralID=" + id); break; case "product": DBCenter.UpdateSQL(TableName, "OrderID=" + order, "ID=" + id); break; case "modelfield": DBCenter.UpdateSQL(TableName, "OrderID=" + order, "FieldID=" + id); break; } } return(Content(Success.ToString())); }
public IActionResult DrawBack_Add() { M_OrderList orderMod = orderBll.SelReturnModel(Mid); if (!DrawBackCheck(orderMod, ref err)) { return(WriteErr(err)); } string text = RequestEx["Back_T"]; if (text.Length < 10) { return(WriteErr("退款说明最少需十个字符")); } //------------------------ M_Order_Back backMod = new M_Order_Back(); backMod.OrderID = orderMod.id; backMod.OrderBak = JsonConvert.SerializeObject(orderMod); backMod.UserRemind = text; backMod.UserID = mu.UserID; backMod.ID = backBll.Insert(backMod); DBCenter.UpdateSQL(orderMod.TbName, "BackID=" + backMod.ID + ",OrderStatus=" + (int)M_OrderList.StatusEnum.DrawBack, "ID=" + orderMod.id); return(Content("<script>top.location=top.location;</script>")); }
protected void Save_Btn_Click(object sender, EventArgs e) { M_UserInfo mu = buser.GetLogin(); M_CommonData storeMod = ExHelper.Store2_User(); M_WX_APPID appMod = new M_WX_APPID(); if (DataConvert.CLng(storeMod.SpecialID) > 0) { appMod = appBll.SelReturnModel(DataConvert.CLng(storeMod.SpecialID)); } appMod.Alias = storeMod.Title; appMod.APPID = AppID_T.Text.Trim(); if (QCode_UP.HasFile) { QCode_UP.SaveFile(); appMod.QRCode = QCode_UP.FileUrl.Replace("/UploadFiles/", "");; } appMod.WxNo = WXNo_T.Text.Trim(); appMod.Secret = Secret_T.Text.Trim(); appMod.OrginID = OrginID.Text.Trim(); appMod.Pay_AccountID = Pay_Account.Text.Trim(); appMod.Pay_Key = Pay_Key.Text.Trim(); if (appMod.ID > 0) { appBll.UpdateByID(appMod); } else { appMod.ID = appBll.Insert(appMod); storeMod.SpecialID = appMod.ID.ToString(); DBCenter.UpdateSQL("ZL_Store_Reg", "StoreStyleID=" + appMod.ID, "ID=" + storeMod.ItemID); } function.WriteSuccessMsg("操作成功"); }
protected void Page_Load(object sender, EventArgs e) { ExHelper.CheckUserAuth("cash"); if (!IsPostBack) { M_UserInfo mu = buser.GetLogin(); Regular_RPT.DataSource = ExHelper.Store_MoneyRegular(mu.SiteID); Regular_RPT.DataBind(); if (Mid > 0) { suMod = suBll.SelModelByUid(Mid, mu.SiteID); if (suMod == null) { function.WriteErrMsg("你无权操作该用户"); } client = buser.SelReturnModel(Mid); if (string.IsNullOrEmpty(suMod.CardNo)) { suMod.CardNo = cdBll.GetCardNo(mu.SiteID.ToString()); DBCenter.UpdateSQL(suMod.TbName, "CardNo='" + suMod.CardNo + "'", "ID=" + suMod.ID); } CardNo.Text = suMod.CardNo; CardPurse.Text = client.Purse.ToString("F2"); } else { suMod.HoneyName = "未选择"; op_tr.Visible = false; op_tr2.Visible = false; } } }
protected void RPT_ItemCommand(object source, RepeaterCommandEventArgs e) { M_UserInfo mu = buser.GetLogin(); switch (e.CommandName) { case "return": { if (StoreID < 1) { HttpContext.Current.Response.Write("<script>alert('请扫描商户二维码进行还伞操作')</script>"); } int oid = DataConvert.CLng(e.CommandArgument); M_OrderList orderMod = orderBll.SelReturnModel(oid); if (orderMod.OrderStatus != 0) { HttpContext.Current.Response.Write("<script>alert('订单状态不正确')</script>"); } if (orderMod.Userid != mu.UserID) { HttpContext.Current.Response.Write("<script>alert('你无权操作该订单')</script>"); } orderMod.Settle = StoreID; DBCenter.UpdateSQL("ZL_OrderInfo", "Settle=" + StoreID + ",OrderStatus=" + (int)M_OrderList.StatusEnum.DrawBack, "ID=" + oid); HttpContext.Current.Response.Write("<script>alert('还伞提交成功,请等待商户确认')</script>"); } break; } MyBind(); }
/// <summary> /// 0:正常状态 /// 1:用户回收站 /// 2:用户彻底删除|管理员删除订单时,返还优惠卷,并删除支付单 ///(仅可操作未完成支付的支付单) /// </summary> public bool CancelOrder(M_OrderList orderMod) { B_Payment payBll = new B_Payment(); M_Payment payMod = payBll.SelModelByOrder(orderMod); //支付单不存在,或状态不为未支付,则忽略 if (payMod == null) { return(false); } //返还优惠卷 if (!string.IsNullOrEmpty(payMod.ArriveDetail)) { B_Arrive avBll = new B_Arrive(); M_Arrive avMod = avBll.SelReturnModel(DataConvert.CLng(payMod.ArriveDetail)); if (avMod != null && avMod.State == 10) { avMod.State = 1; avMod.UseRemind = "订单[" + orderMod.OrderNo + "]取消,返还优惠卷"; avBll.GetUpdate(avMod); } } //返回积分,需计算积分的值 if (payMod.UsePoint > 0) { } DBCenter.UpdateSQL(payMod.TbName, "Status=" + (int)M_Payment.PayStatus.NoPay + ",MoneyTrue=0,IsDel=1", "PaymentID=" + payMod.PaymentID); return(true); }
public bool LikeTie(int id, int uid, int action, string field = "LikeIDS") { //需测试是否支持Replace if (uid < 1) { return(false); } string suid = "'," + uid + ",'"; switch (field) { case "ColledIDS": break; default: field = "LikeIDS"; break; } string set = ""; switch (action) { case 1: //增加 set = string.Format("{0} = {0}+" + suid, field); break; case 2: //移除 set = string.Format("{0} = REPLACE(REPLACE({0}," + suid + ",','),',,',',')", field); break; } return(DBCenter.UpdateSQL(TbName, set, "ID=" + id)); }
//------------------------全局逻辑 /// <summary> /// 进入购物车页面时触发,整理用户购物车中的商品 /// </summary> public static void UpdateUidByCartID(string cartid, M_UserInfo mu, bool isDel = true) { //用户未登录或CartID为空,则不处理逻辑 if (string.IsNullOrEmpty(cartid) || mu.IsNull) { return; } List <SqlParameter> spList = new List <SqlParameter>() { new SqlParameter("cartid", cartid), new SqlParameter("uname", mu.UserName) }; //更新掉CartID与UserID,使其在未登录购物车中不可见 DBCenter.UpdateSQL("ZL_Cart", "UserID=" + mu.UserID + ",CartID='',Username=@uname", "Cartid=@cartid AND (UserID=0 OR UserID IS NULL)", spList); if (isDel)//避免购物车提交的同时删除,造成商品丢失Bug { //按ProID分组取最大值,移除重复与小于其的(JD逻辑) string delSql = "DELETE FROM ZL_Cart WHERE UserID=" + mu.UserID + " AND ID NOT IN ({0})"; string selMax = "SELECT MIN(B.ID) FROM " + "(SELECT ProID,max(Pronum) AS Pronum FROM ZL_Cart WHERE UserID=" + mu.UserID + " GROUP BY ProID)T" + " LEFT JOIN ZL_Cart B ON T.ProID=B.ProID AND T.Pronum=B.Pronum WHERE B.UserID=" + mu.UserID + " GROUP BY B.ProID"; delSql = string.Format(delSql, selMax); SqlHelper.ExecuteSql(delSql); } }
/// <summary> /// 购物车中有则增加数量,否则添加记录 /// </summary> public int AddModel(M_Cart model) { if (string.IsNullOrEmpty(model.Cartid) && model.userid < 1) { return(0); } List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter("cartid", model.Cartid) }; string where = "ProID=" + model.ProID; if (model.userid > 0) { where += " AND UserID=" + model.userid; } else { where += " AND CartID=@cartid"; } DataTable dt = DBCenter.SelWithField("ZL_Cart", "ID,Pronum", where, "", sp); if (dt.Rows.Count > 0) { int id = Convert.ToInt32(dt.Rows[0]["ID"]); DBCenter.UpdateSQL(TbName, "Pronum=" + (Convert.ToInt32(dt.Rows[0]["Pronum"]) + model.Pronum), "ID=" + id); return(id); } else { return(insert(model)); } }
public void UpdateStatus(string cmd, string ids) { if (string.IsNullOrEmpty(ids)) { return; } int status = 1; switch (cmd) { case "stop": status = 0; break; case "back": status = -1; break; case "normal": status = 1; break; } SafeSC.CheckIDSEx(ids); DBCenter.UpdateSQL(strTableName, "isAudit=" + status, PK + " IN(" + ids + ")"); }
public int Insert(M_WX_ReplyMsg model) { if (model.IsDefault == 1) { DBCenter.UpdateSQL(TbName, "IsDefault=0", "Appid=" + model.AppId + " AND ID!=" + model.ID); } return(Sql.insertID(TbName, model.GetParameters(model), BLLCommon.GetParas(model), BLLCommon.GetFields(model))); }
public void UpdateProParent(M_Shop_GroupPro model) { DBCenter.UpdateSQL("ZL_Commodities", "ParentID=0", "ParentID=" + model.ID); if (!string.IsNullOrEmpty(model.ProIDS)) { DBCenter.UpdateSQL("ZL_Commodities", "ParentID=" + model.ID, "ID IN (" + StrHelper.PureIDSForDB(model.ProIDS) + ")"); } }
public bool UpdateByID(M_WX_ReplyMsg model) { if (model.IsDefault == 1) { DBCenter.UpdateSQL(TbName, "IsDefault=0", "Appid=" + model.AppId + " AND ID!=" + model.ID); } return(Sql.UpdateByIDs(TbName, PK, model.ID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters(model))); }
public int Insert(M_WX_ReplyMsg model) { if (model.IsDefault == 1) { DBCenter.UpdateSQL(TbName, "IsDefault=0", "Appid=" + model.AppId + " AND ID!=" + model.ID); } return(DBCenter.Insert(model)); }
/// <summary> /// 更改管理员锁定状态(不包含超管) /// </summary> /// <param name="ids"></param> /// <param name="islock">true:1锁定</param> /// <returns></returns> public bool LockAdmin(string ids, bool islock) { SafeSC.CheckIDSEx(ids); int isLocked = islock ? 1 : 0; DBCenter.UpdateSQL(tbName, "IsLock=" + isLocked, "AdminID IN(" + ids + ") AND AdminID!=1", null); return(true); }
public bool UpdateByID(M_WX_ReplyMsg model) { if (model.IsDefault == 1) { DBCenter.UpdateSQL(TbName, "IsDefault=0", "Appid=" + model.AppId + " AND ID!=" + model.ID); } return(DBCenter.UpdateByID(model, model.ID)); }
public void ChangePassed(string ids, int status) { if (string.IsNullOrEmpty(ids)) { return; } DBCenter.UpdateSQL(strTableName, "Passed=" + status, PK + " IN (" + ids + ")"); }
/// <summary> /// 根据回贴,更新主题贴数据(不用SQL查询,性能消耗过大) /// </summary> /// <param name="model"></param> public void UpdateR_Info(M_Guest_Bar model) { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter("uname", model.CUName), new SqlParameter("time", DateTime.Now) }; DBCenter.UpdateSQL(TbName, "R_CUser="******",R_CUName=@uname,R_CDate=@time", "ID=" + model.Pid, sp); }
public void Reconvery(string nids) { if (string.IsNullOrEmpty(nids)) { return; } SafeSC.CheckIDSEx(nids); DBCenter.UpdateSQL(TbName, "ZStatus=99", "NodeID IN (" + nids + ")"); }
public void UpdateStatus(string ids, int status) { if (string.IsNullOrEmpty(ids)) { return; } SafeSC.CheckIDSEx(ids); DBCenter.UpdateSQL(TbName, "ZStatus=" + status, "ID IN (" + ids + ")"); }
public void UpdateModelTemplate(int NodeID, int ModelID, string ModelTemplate) { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter("Template", ModelTemplate) }; DBCenter.UpdateSQL("ZL_Node_ModelTemplate", "Template=@Template", "NodeID=" + NodeID + " and ModelID=" + ModelID, sp); }