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