public int EmailUpdate(long ID, string strname, string stremail) { if (strname != "") { if (stremail.Trim() == "") { return(-1); } if (!Shove._String.Valid.isEmail(stremail)) { return(-2); } DataTable dt = new DAL.Tables.T_Users().Open("ID", "SiteID=" + ID + " and [Name] = '" + Shove._Web.Utility.FilteSqlInfusion(strname) + "'", ""); Users users = new Users(ID); users.ID = (long)dt.Rows[0]["ID"]; users.Name = strname; users.Email = stremail; string strDescription = ""; int id = users.EditByID(ref strDescription); if (id == 0) { return(-3); } } return(1); }
private void BindData() { DataTable dt = new DAL.Tables.T_UnionLinkScale().Open("ID,UnionID,SiteLinkPID,BonusScale", "UnionID=" + _User.ID, "SiteLinkPID"); DataTable dtLink = new DAL.Tables.T_Users().Open("distinct [Memo]", "Memo<>'' and CpsID=" + _User.cps.ID, "[Memo]"); double scale = _Site.SiteOptions["BonusScale"].ToDouble(0.02); for (int i = 0; i < dtLink.Rows.Count; i++) { string pid = dtLink.Rows[i][0].ToString(); DataRow[] drList = dt.Select("SiteLinkPID='" + pid + "'"); if (drList.Length == 0) { DataRow dr = dt.NewRow(); dr["ID"] = 0; dr["UnionID"] = _User.cps.ID; dr["SiteLinkPID"] = pid; dr["BonusScale"] = scale; dt.Rows.Add(dr); } } DataTable dtTemp = GetNewDataTable(dt, "SiteLinkPID like '%" + tbPID.Text.Trim() + "%'"); PF.DataGridBindData(g, dtTemp, gPager); }
/// <summary> /// 获得用户名 /// </summary> /// <param name="_userId">用户ID</param> /// <returns>用户名</returns> protected string GetUserName(object _userId) { string userId = _userId.ToString(); DataTable dt = new DAL.Tables.T_Users().Open("Name", "id = " + userId, ""); return(dt.Rows[0][0].ToString()); }
protected void Page_Load(object sender, EventArgs e) { AjaxPro.Utility.RegisterTypeForAjax(typeof(Home_Room_BindBankCard), this.Page); if (!IsPostBack) { if (User != null) { DataTable dt = new DAL.Tables.T_Users().Open("SecurityQuestion ,SecurityAnswer", "SiteID = " + _Site.ID.ToString() + " and ID=" + _User.ID.ToString() + "", ""); if (dt == null || string.IsNullOrEmpty(dt.Rows[0]["SecurityQuestion"].ToString())) { tbNewQF.Visible = true; divAnswer.Visible = false; } else { tbNewQF.Visible = false; divAnswer.Visible = true; } } BindData(); ddlQuestion.DataSource = DataCache.SecurityQuestions; ddlQuestion.DataBind(); } }
private void BindData() { DataTable dt = new DAL.Tables.T_Users().Open("ID,SiteID ,Name ,RealityName, IDCardNumber ,Email ,QQ,Telephone , Mobile ,isCanLogin ,Reason", "SiteID = " + _Site.ID.ToString() + "and isCanLogin= 0", ""); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", "Admin_Admin_UserLogOut"); return; } DataTable dtData = dt.Clone(); DataRow[] drs; if (rbUser.Checked) { drs = dt.Select("Reason is not null"); } else { drs = dt.Select("Reason is null"); } foreach (DataRow dr in drs) { dtData.Rows.Add(dr.ItemArray); } PF.DataGridBindData(g, dtData, gPager); }
protected void btnAdd_Click(object sender, EventArgs e) { string UserName = Shove._Web.Utility.FilteSqlInfusion(tbName.Text.Trim()); if (UserName == "") { Shove._Web.JavaScript.Alert(this.Page, "请输入名人用户名!"); return; } int order = Shove._Convert.StrToInt(tbOrder.Text.Trim(), -1); if (order < 0) { Shove._Web.JavaScript.Alert(this.Page, "顺序输入非法!"); return; } DataTable dt = new DAL.Tables.T_Users().Open("ID", "Name='" + UserName + "'", ""); if (dt == null || dt.Rows.Count == 0) { Shove._Web.JavaScript.Alert(this.Page, "不存在" + UserName + "用户!"); return; } dt = new DAL.Tables.T_Personages().Open("ID", "UserName='******' and LotteryID=" + Shove._Web.Utility.FilteSqlInfusion(ddlLotteries.SelectedValue) + " and ID<>" + Shove._Web.Utility.FilteSqlInfusion(hidID.Value) + "", ""); if (dt != null && dt.Rows.Count > 0) { Shove._Web.JavaScript.Alert(this.Page, UserName + "已经是" + ddlLotteries.SelectedItem.Text + "的名人了!"); return; } DAL.Tables.T_Personages p = new DAL.Tables.T_Personages(); p.Order.Value = order; p.UserName.Value = UserName; p.LotteryID.Value = ddlLotteries.SelectedValue; p.IsShow.Value = cbisShow.Checked; long l = p.Update("ID =" + Shove._Web.Utility.FilteSqlInfusion(hidID.Value)); if (l > 0) { Shove._Web.Cache.ClearCache("Admin_Personages"); Shove._Web.JavaScript.Alert(this, "修改成功", "Personages.aspx?LotteryID=" + ddlLotteries.SelectedValue); } else { Shove._Web.JavaScript.Alert(this, "修改失败"); } }
protected void btnSafeSetNext_Click(object sender, EventArgs e) { string Question = ddlQuestion.SelectedValue; if (tbOAnswer.Text.Trim() != _User.SecurityAnswer) { Shove._Web.JavaScript.Alert(this.Page, "原安全问题回答错误"); return; } if (Question == "自定义问题") { Question = Shove._Web.Utility.FilteSqlInfusion(tbMyQuestion.Text.Trim()); if (Question == "") { Shove._Web.JavaScript.Alert(this.Page, "请输入安全问题"); return; } Question = "自定义问题|" + Question; } else { Question = ddlQuestion.SelectedValue; } string Answer = Shove._Web.Utility.FilteSqlInfusion(tbAnswer.Text.Trim()); if (Answer == "") { Shove._Web.JavaScript.Alert(this.Page, "请输入答案"); return; } DAL.Tables.T_Users user = new DAL.Tables.T_Users(); user.SecurityQuestion.Value = Question; user.SecurityAnswer.Value = Answer; long Result = user.Update("ID=" + _User.ID.ToString()); if (Result < 0) { Shove._Web.JavaScript.Alert(this.Page, "设置安全问题失败"); return; } Response.Write("<script type='text/javascript'>alert('设置安全问题成功。请注意安全保护问题是最重要的安全凭证,为了您的安全,请牢牢记住您的安全保护问题。');</script>"); ShowOrHiddenPanel(2); }
protected void Page_Load(object sender, EventArgs e) { BuyID = Shove._Convert.StrToLong(Shove._Web.Utility.GetRequest("BuyID"), 0); if (_User != null) { DAL.Tables.T_Users us = new DAL.Tables.T_Users(); us.Freeze.Value = 9; us.Update("ID=" + _User.ID); Balance = _User.Balance.ToString(); UserName = _User.Name.ToString(); Freeze = _User.Freeze.ToString() == "0" ? "9" : _User.Freeze.ToString(); } }
protected bool CheckInput() { string name = tbUserName.Text; if (!PF.CheckUserName(name)) { Shove._Web.JavaScript.Alert(this.Page, "对不起用户名中含有禁止使用的字符"); return(false); } if (Shove._String.GetLength(name) < 5 || Shove._String.GetLength(name) > 16) { Shove._Web.JavaScript.Alert(this.Page, "用户名长度在 5-16 个英文字符或数字、中文 3-8 之间。"); return(false); } if (tbPassword.Text != tbPwd.Text) { Shove._Web.JavaScript.Alert(this.Page, "两次密码输入不一致,请仔细检查。"); return(false); } if (tbPassword.Text.Length < 6 || tbPassword.Text.Length > 16) { Shove._Web.JavaScript.Alert(this.Page, "密码长度必须在 6-16 位之间。"); return(false); } DataTable dt = new DAL.Tables.T_Users().Open("ID", "Name='" + Shove._Web.Utility.FilteSqlInfusion(name) + "'", ""); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.GetType().BaseType.FullName); return(false); } if (dt.Rows.Count > 0) { Shove._Web.JavaScript.Alert(this.Page, "用户名已存在!"); return(false); } return(true); }
private void BindUsers() { string Key = "CPS_Default_BindUsers"; DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(Key); if (dt == null) { dt = new DAL.Tables.T_Users().Open("top 6 Name,Bonus", "Bonus > 0", "Bonus desc"); Shove._Web.Cache.SetCache(Key, 600); } Repeater1.DataSource = dt; Repeater1.DataBind(); }
private void GetUserName(string uid) { DataTable dtUser = new DAL.Tables.T_Users().Open("ID,Name", "[ID] = " + uid, ""); if (dtUser == null) { this.lbUserName.Text = "无法获取用户信息"; return; } else { this.lbUserName.Text = dtUser.Rows[0][1] + ""; this.userId.Value = dtUser.Rows[0][0].ToString(); } }
public int CheckUserName(long siteid, string name) { if (!PF.CheckUserName(name)) { return(-1); } DataTable dt = new DAL.Tables.T_Users().Open("ID", "SiteID=" + siteid + " and [Name] = '" + Shove._Web.Utility.FilteSqlInfusion(name) + "'", ""); if (dt != null && dt.Rows.Count > 0) { return(-2); } return(0); }
public string BindQuestion(long siteid, string customQuestion, string name) { string content = ""; string strQuestion = customQuestion.Trim(); string strName = name.Trim(); if (strName == "") { return(""); } if (strQuestion == "") { return(""); } string strSecurityQuestion = ""; DataTable dt = new DAL.Tables.T_Users().Open("SecurityQuestion", "SiteID=" + siteid + " and [Name] = '" + Shove._Web.Utility.FilteSqlInfusion(strName) + "'", ""); if (dt.Rows.Count > 0) { strSecurityQuestion = dt.Rows[0]["SecurityQuestion"].ToString(); } else { return(""); } if (strSecurityQuestion == "") { return(""); } if (strQuestion.Equals(strSecurityQuestion)) { return(strQuestion); } else { string[] strArray = strSecurityQuestion.Split('|'); if (strArray != null) { if (strArray.Length > 0) { content = strArray[1].ToString(); } } } return(content); }
private void BindData() { lbName.Text = _User.Name; labName.Text = _User.Name; //tbQQ.Text = _User.QQ; DataTable dt = new DAL.Tables.T_Users().Open("IsQQValided", "ID=" + _User.ID.ToString(), ""); if (dt == null || dt.Rows.Count == 0) { return; } if (Shove._Convert.StrToBool(dt.Rows[0]["IsQQValided"].ToString(), false)) { labQQ.Text = _User.QQ.Length > 3 ? (_User.QQ.Substring(0, 3) + "********") : _User.QQ; lbStatus.Text = "您已经绑定"; } else { labBindState.Text = "(未绑定)"; lbStatus.Text = "您一旦绑定"; } if (_User.SecurityQuestion.StartsWith("自定义问题|")) { lbQuestion.Text = _User.SecurityQuestion.Remove(0, 6); } else { lbQuestion.Text = _User.SecurityQuestion; } if (lbQuestion.Text == "") { lbQuestionInfo.Text = "设置安全保护问题"; } else { lbQuestionInfo.Text = "修改安全保护问题"; } }
private void BindDataForUser() { DataTable dt = new DAL.Tables.T_Users().Open("[ID], [Name]", "SiteID = " + _Site.ID.ToString() + " and [ID] in (select distinct UserID from T_CompetencesOfUsers union all select distinct UserID from T_UserInGroups)", "[ID]"); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", "Admin_SchemeList"); return; } ddlUser.Items.Add(new ListItem("全部操作员", "-1")); foreach (DataRow dr in dt.Rows) { ddlUser.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString())); } ddlUser.SelectedIndex = 0; }
private void BindUsers() { string Key = "CPS_Default_BindUsers"; DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(Key); if (dt == null) { dt = new DAL.Tables.T_Users().Open("top 9 Name,Bonus", "Bonus > 0", "Bonus desc"); if (dt == null) { return; } Shove._Web.Cache.SetCache(Key, 3600); } StringBuilder sb = new StringBuilder(); sb.Append("<table width=\"96%\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">"); for (int i = 0; i < dt.Rows.Count; i++) { sb.Append("<tr>") .Append("<td width=\"12%\" height=\"24\" align=\"center\">") .Append("<img src=\"images/num_" + (i + 1).ToString() + ".gif\" width=\"13\" height=\"13\" />") .Append("</td>") .Append("<td width=\"57%\" height=\"24\">") .Append(dt.Rows[i]["Name"].ToString()) .Append("</td>") .Append("<td width=\"31%\" height=\"24\">") .Append(Shove._Convert.StrToDouble(dt.Rows[i]["Bonus"].ToString(), 0).ToString("N")) .Append("元</td>") .Append("</tr>"); } sb.Append("</table>"); tdUsers.InnerHtml = sb.ToString(); }
public int CheckUserName(string name) { if (!PF.CheckUserName(name)) { return(-1); } DataTable dt = new DAL.Tables.T_Users().Open("ID", "Name = '" + Shove._Web.Utility.FilteSqlInfusion(name) + "'", ""); if (dt != null && dt.Rows.Count > 0) { return(-2); } if (Shove._String.GetLength(name) < 5 || Shove._String.GetLength(name) > 16) { return(-3); } return(0); }
protected void btnDownload_Click(object sender, EventArgs e) { DataTable dt = new DAL.Tables.T_Users().Open("", "", "[ID]"); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.Page.GetType().BaseType.FullName); return; } string FileName = "T_Users.xls"; HttpResponse response = Page.Response; response.AppendHeader("Content-Disposition", "attachment;filename=" + FileName); Response.ContentType = "application/ms-excel"; response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312"); foreach (DataColumn dc in dt.Columns) { response.Write(dc.ColumnName + "\t"); } response.Write("\n"); foreach (DataRow dr in dt.Rows) { for (int i = 0; i < dt.Columns.Count; i++) { response.Write(dr[i].ToString() + "\t"); } response.Write("\n"); } response.End(); }
private void SendSystemMessage() { DataTable dt = new DAL.Tables.T_Users().Open("", "SiteID = " + _Site.ID.ToString() + " and Mobile <> ''", ""); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", "Admin_SendEmail"); return; } int CountOK = 0, CountFail = 0; //发送计数统计 string SendResult = ""; //发送结果 foreach (DataRow dr in dt.Rows) { if (PF.SendSMS(_Site, -1, dr["Mobile"].ToString(), tbContent.Text.Trim()) < 0) { CountFail++; SendResult += "用户 " + dr["Name"].ToString() + " 发送错误!<br />"; } else { CountOK++; SendResult += "用户 " + dr["Name"].ToString() + " 发送成功。<br />"; } } labSendResult.Text = "发送结果:成功 " + CountOK.ToString() + " 个,失败 " + CountFail.ToString() + " 个。<br />" + SendResult; if (CountFail == 0) { tbAim.Text = ""; tbContent.Text = ""; cbSystemMessage.Checked = false; } }
protected void EmptyQuestn_Click(object sender, EventArgs e) { long SiteID = Shove._Convert.StrToLong(tbSiteID.Text, -1); long UserID = Shove._Convert.StrToLong(tbUserID.Text, -1); if ((SiteID < 1) || (UserID < 1)) { PF.GoError(ErrorNumber.Unknow, "参数错误", "Admin_UserDetail"); return; } Users tu = new Users(SiteID)[SiteID, UserID]; if (tu.ID < 1) { PF.GoError(ErrorNumber.Unknow, "用户不存在", "Admin_UserDetail"); return; } DAL.Tables.T_Users user = new DAL.Tables.T_Users(); user.SecurityQuestion.Value = ""; user.SecurityAnswer.Value = ""; long Result = user.Update("ID=" + UserID); if (Result < 0) { Shove._Web.JavaScript.Alert(this.Page, "清空安全问题失败"); return; } Shove._Web.JavaScript.Alert(this.Page, "清空安全问题成功"); }
private void BindData() { lbUserName.Text = "*".PadLeft(_User.Name.Length - 1, '*') + _User.Name.Substring(_User.Name.Length - 1); if (_User.RealityName != "") { this.tbRealityName.Visible = false; this.lbRealityName.Visible = true; this.lbRealityName.Text = "*".PadLeft(_User.RealityName.Length - 1, '*') + _User.RealityName.Substring(_User.RealityName.Length - 1); this.lbIsRealityNameValided.Text = "已绑定"; } else { this.tbRealityName.Visible = true; this.lbRealityName.Visible = false; this.tbRealityName.Text = "***"; this.lbIsRealityNameValided.Text = "未绑定"; } ddlCity.City_id = _User.CityID; rbSexM.Checked = (_User.Sex == "男"); rbSexW.Checked = (_User.Sex != "男"); tbBirthday.Text = _User.BirthDay.ToShortDateString(); tbAddress.Text = _User.Address; tbEmail.Text = _User.Email; try { if (_User.isMobileValided) { lbMobile.Text = _User.Mobile.Substring(0, 3) + "*****" + _User.Mobile.Substring(8, 3); } } catch { } DataTable dt = new DAL.Tables.T_Users().Open("IsQQValided", "ID=" + _User.ID.ToString(), ""); if (dt == null || dt.Rows.Count == 0) { return; } bool IsQQValided = Shove._Convert.StrToBool(dt.Rows[0]["IsQQValided"].ToString(), false); if (IsQQValided) { lbQQ.Text = _User.QQ.Length > 3 ? (_User.QQ.Substring(0, 3) + "********") : _User.QQ; } lbIsEmailValided.Text = (_User.isEmailValided ? "<font color='red'>已激活</font>" : "未激活") + " <a href='UserEmailBind.aspx'>申请激活或修改激活</a>"; labIsMobileVailded.Text = (_User.isMobileValided ? "<font color='red'>已绑定</font>" : "未绑定") + " <a href='UserMobileBind.aspx'>申请绑定或修改绑定</a>"; lbQQValided.Text = (IsQQValided ? "<font color='red'>已绑定</font>" : "未绑定") + " <a href='UserQQBind.aspx'>申请绑定或修改绑定</a>"; dt = new DAL.Tables.T_Banks().Open("", "", "[Order]"); if (_User.SecurityQuestion.StartsWith("自定义问题|")) { lbQuestion.Text = _User.SecurityQuestion.Remove(0, 6); } else { lbQuestion.Text = _User.SecurityQuestion; } if (lbQuestion.Text == "") { lbQuestionInfo.Text = "设置安全保护问题"; } else { lbQuestionInfo.Text = "修改安全保护问题"; } try { if (_User.IDCardNumber.Length == 15) { lbIdCardNumber.Visible = true; tbIdIDCardNumber.Visible = false; lbIdCardNumber.Text = _User.IDCardNumber.Substring(0, 6) + "*****" + _User.IDCardNumber.Substring(10, 4); lbIsIdCardNumberValided.Text = "已绑定"; } else { lbIdCardNumber.Visible = true; tbIdIDCardNumber.Visible = false; lbIdCardNumber.Text = _User.IDCardNumber.Substring(0, 6) + "********" + _User.IDCardNumber.Substring(14, 4); lbIsIdCardNumberValided.Text = "已绑定"; } } catch { lbIdCardNumber.Visible = false; tbIdIDCardNumber.Visible = true; lbIdCardNumber.Text = ""; lbIsIdCardNumberValided.Text = "未绑定"; } hdIDCardNumber.Value = lbIdCardNumber.Text; }
protected void btnAdd_Click(object sender, EventArgs e) { string UserName = tbName.Text.Trim(); if (UserName == "") { Shove._Web.JavaScript.Alert(this.Page, "请输入名人用户名!"); return; } int order = Shove._Convert.StrToInt(tbOrder.Text.Trim(), -1); if (order < 0) { Shove._Web.JavaScript.Alert(this.Page, "顺序输入非法!"); return; } DataTable dt = new DAL.Tables.T_Users().Open("ID", "Name='" + UserName + "'", ""); if (dt == null || dt.Rows.Count == 0) { Shove._Web.JavaScript.Alert(this.Page, "不存在" + UserName + "用户!"); return; } int UserID = 0; // 获取用户ID try { UserID = Shove._Convert.StrToInt(dt.Rows[0]["ID"].ToString(), 0); } catch { UserID = 0; } dt = new DAL.Tables.T_Personages().Open("ID", "UserName='******' and LotteryID=" + Shove._Web.Utility.FilteSqlInfusion(ddlLotteries.SelectedValue) + "", ""); if (dt != null && dt.Rows.Count > 0) { Shove._Web.JavaScript.Alert(this.Page, UserName + "已经是" + ddlLotteries.SelectedItem.Text + "的名人了!"); return; } DAL.Tables.T_Personages p = new DAL.Tables.T_Personages(); p.UserID.Value = UserID; p.Order.Value = order; p.UserName.Value = UserName; p.LotteryID.Value = ddlLotteries.SelectedValue; p.IsShow.Value = cbisShow.Checked; p.IsRecommend.Value = cbIsRecommend.Checked; if (cbIsRecommend.Checked) { Shove.Database.MSSQL.ExecuteNonQuery("update T_Personages set IsRecommend = 0"); // 清楚缓存 Shove._Web.Cache.ClearCache("DataCache_CelebrityHall_Recommends"); } long l = p.Insert(); if (l >= 0) { Shove._Web.Cache.ClearCache("Admin_Personages"); Shove._Web.Cache.ClearCache("DataCache_CelebrityHall_Collects"); Shove._Web.Cache.ClearCache("DataCache_CelebrityHall_Star"); Shove._Web.Cache.ClearCache("DataCache_CelebrityHall_Recommends"); Shove._Web.JavaScript.Alert(this, "添加成功", "Personages.aspx?LotteryID=" + ddlLotteries.SelectedValue); } else { Shove._Web.JavaScript.Alert(this, "添加失败"); } }
protected void btnOK_Click(object sender, EventArgs e) { if (tbName.Text.Trim() == "") { Shove._Web.JavaScript.Alert(this.Page, "请输入用户名。"); return; } if (string.IsNullOrEmpty(tbRealityName.Text.Trim())) { Shove._Web.JavaScript.Alert(this.Page, "请输入真实姓名。"); return; } if (CheckCode.Visible) { if (tbCheckCode.Text.Trim() == "") { Shove._Web.JavaScript.Alert(this.Page, "请输入验证码!"); return; } else { if (!ShoveCheckCode1.Valid(tbCheckCode.Text.Trim())) { Shove._Web.JavaScript.Alert(this.Page, "验证码输入有误!"); return; } } } System.Threading.Thread.Sleep(500); Sites site = new Sites()[Shove._Web.Utility.GetUrlWithoutHttp()]; if (site == null) { return; } long CpsID = -1; string URL = new FirstUrl().Get(); if (!URL.StartsWith("http://")) { URL = "http://" + URL; URL = URL.Split('?'.ToString().ToCharArray())[0]; } DataTable dt = new DAL.Tables.T_Cps().Open("id, [ON], [Name]", "SiteID = " + _Site.ID.ToString() + " and DomainName = '" + URL + "' or DomainName='" + Shove._Web.Utility.GetUrl() + "'", ""); if ((dt != null) && (dt.Rows.Count > 0)) { if (Shove._Convert.StrToBool(dt.Rows[0]["ON"].ToString(), false)) { CpsID = Shove._Convert.StrToLong(dt.Rows[0]["ID"].ToString(), -1); } } string Password = GetRandPassword(); Users user = new Users(site.ID); user.Name = tbName.Text.Trim(); user.RealityName = tbRealityName.Text.Trim(); user.Password = Password; user.PasswordAdv = Password; user.CityID = 1; user.Email = labAccount.Text.Trim(); user.ComeFrom = 4; user.UserType = 2; user.CpsID = CpsID; user.CommenderID = -1; string ReturnDescription = ""; if (user.Add(ref ReturnDescription) < 0) { Shove._Web.JavaScript.Alert(this.Page, ReturnDescription + "用户添加失败"); return; } DAL.Tables.T_Users T_Users = new DAL.Tables.T_Users(); T_Users.AlipayName.Value = labAccount.Text; T_Users.AlipayID.Value = hidUserID.Value; T_Users.isAlipayNameValided.Value = true; T_Users.Update("[ID] = " + user.ID.ToString()); user.LoginDirect(ref ReturnDescription); this.Response.Redirect("UserRegSuccess.aspx", true); }
/// <summary> /// 提交事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnPwd_Click(object sender, EventArgs e) { string strUserName = Shove._Web.Utility.GetRequest("tbUserName"); if (strUserName == "") { Shove._Web.JavaScript.Alert(this, "用户名不能为空。"); return; } string strAnswer = Shove._Web.Utility.GetRequest("tbAnswer"); string strTrueName = Shove._Web.Utility.GetRequest("TrueName"); string strCardNO = Shove._Web.Utility.GetRequest("cardNO"); if (strAnswer == "" && strTrueName == "" && strCardNO == "") { Shove._Web.JavaScript.Alert(this, "真实姓名、问题答案、省份证号码至少填一项!"); return; } string strChekID = Shove._Web.Utility.GetRequest("chekID"); if (strChekID == "1") { string strEmailAccounts = Shove._Web.Utility.GetRequest("EmailAccounts"); if (strEmailAccounts == "") { Shove._Web.JavaScript.Alert(this, "邮箱地址不能为空。"); return; } if (!Shove._String.Valid.isEmail(strEmailAccounts)) { Shove._Web.JavaScript.Alert(this, "邮箱地址格式不正确。"); return; } DataTable dt = new DAL.Tables.T_Users().Open("", "Name = '" + strUserName + "' and Email = '" + strEmailAccounts + "'", ""); if (dt == null || dt.Rows.Count < 1) { Shove._Web.JavaScript.Alert(this, "用户名或邮箱不正确。"); return; } if (!Shove._Convert.StrToBool(dt.Rows[0]["isEmailValided"].ToString(), false)) { Shove._Web.JavaScript.Alert(this, "您的邮箱当前还没有激活,不能使用密码找回功能,请联系客服人员帮你找回密码,谢谢合作。"); return; } if (strAnswer != "") { string answer = dt.Rows[0]["SecurityAnswer"].ToString(); if (!strAnswer.Trim().Equals(answer.Trim())) { Shove._Web.JavaScript.Alert(this, "回答问题不正确。"); return; } } if (strTrueName != "") { string strNames = dt.Rows[0]["RealityName"].ToString(); if (!strTrueName.Trim().Equals(strNames.Trim())) { Shove._Web.JavaScript.Alert(this, "真实姓名不正确。"); return; } } if (strCardNO != "") { string CardNumber = dt.Rows[0]["IDCardNumber"].ToString(); if (!strCardNO.Trim().Equals(CardNumber.Trim())) { Shove._Web.JavaScript.Alert(this, "身份证号码不正确。"); return; } } string password = RandPwd(); Users user = new Users(_Site.ID); user.ID = (long)dt.Rows[0]["ID"]; user.Name = strUserName; user.Password = password; string key = Shove._Security.Encrypt.EncryptString(PF.GetCallCert(), dt.Rows[0]["ID"].ToString() + "," + DateTime.Now.ToString()); //key进行md5加密后转成16进制后得到一个32位的密文 MD5CryptoServiceProvider md5 = new MD5CryptoServiceProvider(); string sign = BitConverter.ToString(md5.ComputeHash(Encoding.UTF8.GetBytes(key))).Replace("-", ""); key = sign.Substring(0, 16) + key + sign.Substring(16, 16); string url = Shove._Web.Utility.GetUrl() + "/UserLogin.aspx?key=" + key; StringBuilder sb = new StringBuilder(); sb.Append("<div style='font-weight:bold;'>尊敬的" + _Site.Name + "客户(").Append(strUserName).Append("):</div>") .Append("<div>您好!</div>") .Append("<div>系统已收到您的密码找回:<em style='color:red;'>" + password + " </em> <a href='").Append(url).Append("' target='_top'>").Append(url).Append("</a>登录您的帐号密码</div>") .Append("<div>为了您的安全,该邮件通知地址将在 24 小时后失效,谢谢合作。</div>") .Append("<div>此邮件由系统发出,请勿直接回复!</div>") .Append("<div>免费客服电话:<%=_Site.ServiceTelephone %></div>") .Append("<div>意见收集与提交:[email protected]</div>") .Append("<div>").Append(Shove._Web.Utility.GetUrlWithoutHttp()).Append(" 版权所有(C) 2008-2009</div>"); int Result = PF.SendEmail(_Site, strEmailAccounts, "密码找回通知信", sb.ToString()); if (Result < 0) { new Log("System").Write(this.GetType().FullName + "发送邮件密码失败"); } else { string strDescription = ""; int id = user.EditByID(ref strDescription); if (id == 0) { Shove._Web.JavaScript.Alert(this, "邮件密码发送成功!请查收后登录!"); } else { Shove._Web.JavaScript.Alert(this, strDescription); } } } else { //手机验证 string strUserMobile = Shove._Web.Utility.GetRequest("tbUserMobile"); if (strUserMobile == "") { Shove._Web.JavaScript.Alert(this, "手机号码不能为空。"); return; } if (!Shove._String.Valid.isMobile(strUserMobile)) { Shove._Web.JavaScript.Alert(this, "手机格式不正确。"); return; } DataTable dt = new DAL.Tables.T_Users().Open("", "Name = '" + strUserName + "' and Mobile = '" + strUserMobile + "'", ""); if (dt == null || dt.Rows.Count < 1) { Shove._Web.JavaScript.Alert(this, "用户名或手机号码不正确。"); return; } if (!Shove._Convert.StrToBool(dt.Rows[0]["isMobileValided"].ToString(), false)) { Shove._Web.JavaScript.Alert(this, "您的手机当前还没有绑定,不能使用密码找回功能,请联系客服人员帮你找回密码,谢谢合作。"); return; } if (strAnswer != "") { string answer = dt.Rows[0]["SecurityAnswer"].ToString(); if (!strAnswer.Trim().Equals(answer.Trim())) { Shove._Web.JavaScript.Alert(this, "回答问题不正确。"); return; } } if (strTrueName != "") { string strNames = dt.Rows[0]["RealityName"].ToString(); if (!strTrueName.Trim().Equals(strNames.Trim())) { Shove._Web.JavaScript.Alert(this, "真实姓名不正确。"); return; } } if (strCardNO != "") { string CardNumber = dt.Rows[0]["IDCardNumber"].ToString(); if (!strCardNO.Trim().Equals(CardNumber.Trim())) { Shove._Web.JavaScript.Alert(this, "身份证号码不正确。"); return; } } string password = RandPwd(); Users user = new Users(_Site.ID); user.ID = (long)dt.Rows[0]["ID"]; user.Name = strUserName; user.Password = password; StringBuilder strSB = new StringBuilder(); strSB.Append("尊敬的" + _Site.Name + "客户(" + strUserName + "):").Append("帐号密码找回:" + password); int Result = PF.SendSMS(_Site, user.ID, strUserMobile, strSB.ToString()); if (Result < 0) { new Log("System").Write(this.GetType().FullName + "发送手机密码短信失败"); } else { string strDescription = ""; int id = user.EditByID(ref strDescription); if (id == 0) { Shove._Web.JavaScript.Alert(this, "手机短信密码发送成功!请查收后登录!"); } else { Shove._Web.JavaScript.Alert(this, strDescription); } } } }
protected void btnOK_Click(object sender, EventArgs e) { string Question = ddlQuestion.SelectedValue; if (trOldQue.Visible == true) { if (tbOAnswer.Text.Trim() != _User.SecurityAnswer) { Shove._Web.JavaScript.Alert(this.Page, "原安全问题回答错误"); return; } } if (Question == "自定义问题") { Question = Shove._Web.Utility.FilteSqlInfusion(tbMyQuestion.Text.Trim()); if (Question == "") { Shove._Web.JavaScript.Alert(this.Page, "请输入安全问题"); return; } Question = "自定义问题|" + Question; } else { Question = ddlQuestion.SelectedValue; } string Answer = Shove._Web.Utility.FilteSqlInfusion(tbAnswer.Text.Trim()); if (Answer == "") { Shove._Web.JavaScript.Alert(this.Page, "请输入答案"); return; } DAL.Tables.T_Users user = new DAL.Tables.T_Users(); user.SecurityQuestion.Value = Question; user.SecurityAnswer.Value = Answer; long Result = user.Update("ID=" + _User.ID.ToString()); if (Result < 0) { Shove._Web.JavaScript.Alert(this.Page, "设置安全问题失败"); return; } //修改验证状态 DAL.Tables.T_UserEditQuestionAnswer T_QF = new DAL.Tables.T_UserEditQuestionAnswer(); string ReturnDescription = ""; T_QF.QuestionAnswerState.Value = 1; Result = T_QF.Update("UserID=" + _User.ID); if (Result < 0) { PF.GoError(-1, ReturnDescription, this.GetType().FullName); return; } Response.Write("<script type='text/javascript'>alert('设置安全问题成功。请注意安全保护问题是最重要的安全凭证,为了您的安全,请牢牢记住您的安全保护问题。');window.location='" + this.hdFromUrl.Value + "'</script>"); Response.End(); }
protected void btnOK_Click(object sender, EventArgs e) { if (tbName.Text.Trim() == "") { Shove._Web.JavaScript.Alert(this.Page, "请输入用户名。"); return; } if (tbPassword.Text == "") { Shove._Web.JavaScript.Alert(this.Page, "请输入用户密码。"); return; } if (tbPassword.Text.Length < 6) { Shove._Web.JavaScript.Alert(this.Page, "用户密码长度不足 6 位。"); return; } if (tbPassword.Text != tbPassword2.Text) { Shove._Web.JavaScript.Alert(this.Page, "输入的两次密码不一致。"); return; } System.Threading.Thread.Sleep(500); Sites site = new Sites()[Shove._Web.Utility.GetUrlWithoutHttp()]; if (site == null) { return; } string RealityName = Shove._Web.Utility.GetRequest("real_name").Trim(); Users user = new Users(site.ID); user.Name = tbName.Text.Trim(); user.RealityName = RealityName; user.Password = tbPassword.Text.Trim(); user.PasswordAdv = tbPassword.Text.Trim(); user.CityID = 1; user.Email = labAccount.Text.Trim(); user.UserType = 1; user.CommenderID = -1; string ReturnDescription = ""; if (user.Add(ref ReturnDescription) < 0) { Shove._Web.JavaScript.Alert(this.Page, ReturnDescription + "用户添加失败"); return; } Alipay.Gateway.Member member = new Alipay.Gateway.Member(); DAL.Tables.T_Users T_Users = new DAL.Tables.T_Users(); T_Users.AlipayID.Value = tbAlipayID.Text; T_Users.AlipayName.Value = labAccount.Text; T_Users.isAlipayNameValided.Value = true; T_Users.Update("[ID] = " + user.ID.ToString()); user.LoginDirect(ref ReturnDescription); this.Response.Redirect("../../Index.aspx", true); }
protected void Page_Load(object sender, EventArgs e) { AjaxPro.Utility.RegisterTypeForAjax(typeof(Home_Room_Receive), this.Page); if (this.Request.QueryString.Count < 1) { Shove._Web.JavaScript.Alert(this.Page, "接口调用失败,请重新登录。", "../../Index.aspx"); return; } string alipayNotifyURL = "http://notify.alipay.com/trade/notify_query.do?"; string partner = so["MemberSharing_Alipay_UserNumber"].ToString(""); //卖家商户号 alipayNotifyURL = alipayNotifyURL + "partner=" + partner + "¬ify_id=" + Request.QueryString["notify_id"]; //获取支付宝ATN返回结果,true是正确的订单信息,false 是无效的 string responseTxt = Get_Http(alipayNotifyURL, 120000); if (responseTxt == "false") { Shove._Web.JavaScript.Alert(this.Page, "接口调用失败,请重新登录。", "../../Index.aspx"); return; } if (Shove._Web.WebConfig.GetAppSettingsBool("DebugUserControl", false)) { tbName.Text = "为了设计页面而进入调试状态,本控件的功能并不运行"; return; } string key = so["MemberSharing_Alipay_MD5"].ToString(""); //partner 的对应交易安全校验码(必须填写)和alipay.cs文件中值是一样的 string _input_charset = "utf-8"; int i; String[] requestarr = Request.QueryString.AllKeys; //进行排序; string[] Sortedstr = Shove.Alipay.Alipay.BubbleSort(requestarr); //构造待md5摘要字符串 ; StringBuilder prestr = new StringBuilder(); for (i = 0; i < Sortedstr.Length; i++) { if (String.IsNullOrEmpty(Sortedstr[i])) { continue; } if (Request.QueryString[Sortedstr[i]] != "" && Sortedstr[i] != "sign" && Sortedstr[i] != "sign_type" && Sortedstr[i].ToLower() != "pn") { if (i == Sortedstr.Length - 1) { prestr.Append(Sortedstr[i] + "=" + Request.QueryString[Sortedstr[i]]); } else { prestr.Append(Sortedstr[i] + "=" + Request.QueryString[Sortedstr[i]] + "&"); } } } prestr.Append(key); //生成Md5摘要; string mysign = Shove.Alipay.Alipay.GetMD5(prestr.ToString(), _input_charset); string sign = (Request.QueryString["sign"] == null ? "" : Request.QueryString["sign"].ToString()); string Success = (Request.QueryString["is_success"] == null ? "" : Request.QueryString["is_success"].ToString().ToUpper()); string User_id = (Request.QueryString["user_id"] == null ? "" : Request.QueryString["user_id"].ToString()); string Email = (Request.QueryString["email"] == null ? "" : Request.QueryString["email"].ToString()); //获得用户EMail string User_Type = (Request.QueryString["user_type"] == null ? "" : Request.QueryString["user_type"].ToString()); string User_Status = (Request.QueryString["user_status"] == null ? "" : Request.QueryString["user_status"].ToString()); string Firm_Name = (Request.QueryString["firm_name"] == null ? "" : Request.QueryString["firm_name"].ToString()); string Real_Name = (Request.QueryString["real_name"] == null ? "" : Request.QueryString["real_name"].ToString()); string Cert_NO = (Request.QueryString["cert_no"] == null ? "" : Request.QueryString["cert_no"].ToString()); //获得证件号码 string Cert_Type = (Request.QueryString["cert_type"] == null ? "" : Request.QueryString["cert_type"].ToString()); string Gender = (Request.QueryString["gender"] == null ? "" : Request.QueryString["gender"].ToString()); string Province = (Request.QueryString["province"] == null ? "" : Request.QueryString["province"].ToString()); string City = (Request.QueryString["city"] == null ? "" : Request.QueryString["city"].ToString()); string Address = (Request.QueryString["address"] == null ? "" : Request.QueryString["address"].ToString()); string Zip = (Request.QueryString["zip"] == null ? "" : Request.QueryString["zip"].ToString()); string Phone = (Request.QueryString["phone"] == null ? "" : Request.QueryString["phone"].ToString()); string Mobile = (Request.QueryString["mobile"] == null ? "" : Request.QueryString["mobile"].ToString()); string Is_Bank_Auth = (Request.QueryString["is_bank_auth"] == null ? "" : Request.QueryString["is_bank_auth"].ToString()); string Is_Mobile_Auth = (Request.QueryString["is_mobile_auth"] == null ? "" : Request.QueryString["is_mobile_auth"].ToString()); string Is_Id_Auth = (Request.QueryString["is_id_auth"] == null ? "" : Request.QueryString["is_id_auth"].ToString()); //****************************************************************************** if (mysign != sign) //验证支付发过来的消息,签名是否正确(防止有伪造消息) { PF.GoError(ErrorNumber.Unknow, "您不是有效的支付宝会员不能登录本站,请您注册成为本站会员,再登录,谢谢!(-1001)", this.GetType().FullName); return; } if (Success != "T") { PF.GoError(ErrorNumber.Unknow, "您不是有效的支付宝会员不能登录本站,请您注册成为本站会员,再登录,谢谢!(-1002)", this.GetType().FullName); return; } //处理数据 if (String.IsNullOrEmpty(User_id)) { PF.GoError(ErrorNumber.Unknow, "您不是有效的支付宝会员不能登录本站,请您注册成为本站会员,再登录,谢谢!(-1003)", this.GetType().FullName); return; } Sites site = new Sites()[Shove._Web.Utility.GetUrlWithoutHttp()]; if (site == null) { PF.GoError(ErrorNumber.Unknow, "会员数据校验错误。", this.GetType().FullName); return; } if (_User != null && Shove._Web.Cache.GetCache("BindAlipay_" + _User.ID.ToString()) != null) { string AlipayRealityName = ""; long AlipayMemberID = new Alipay.Gateway.Member().Query(Email, ref AlipayRealityName); if (AlipayMemberID < 0) { Shove._Web.JavaScript.Alert(this.Page, "输入的账号在支付宝网站验证失败(不存在账号或者网络通讯故障," + AlipayMemberID.ToString() + "),请重新填写一个账号名称。"); return; } if (Real_Name != _User.RealityName && AlipayRealityName != _User.RealityName && _User.RealityName != "") { Shove._Web.JavaScript.Alert(this.Page, "您输入的支付宝账号的真实姓名与您在本站注册时提供的真实姓名不一致,请更换新的支付宝帐号进行绑定,谢谢!", "Login.aspx"); return; } Shove._Web.Cache.ClearCache("BindAlipay_" + _User.ID.ToString()); System.Threading.Thread.Sleep(500); Users tu = new Users(_Site.ID); _User.Clone(tu); _User.AlipayID = AlipayMemberID.ToString(); _User.AlipayName = Email; _User.RealityName = AlipayRealityName; _User.isAlipayNameValided = true; string ReturnDescription = ""; if (_User.EditByID(ref ReturnDescription) < 0) { tu.Clone(_User); Shove._Web.JavaScript.Alert(this.Page, ReturnDescription); return; } Shove._Web.JavaScript.Alert(this.Page, "支付宝绑定成功!", "BindAlipay.aspx"); } DAL.Tables.T_Users t_users = new DAL.Tables.T_Users(); DataTable dt = t_users.Open("[ID], [Name]", "SiteID = " + site.ID.ToString() + " and AlipayID = '" + Shove._Web.Utility.FilteSqlInfusion(User_id) + "'", "[ID]"); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.GetType().FullName); return; } if (!IsPostBack) { labAccount.Text = Email; labAccount2.Text = Email; if (dt.Rows.Count < 1) { // 不存在,注册为新会员 tbAlipayID.Text = User_id; tbName.Text = Email.Split('@')[0]; //tbIDCardNumber.Text = Cert_NO; Script = "btn_CheckUserName('" + tbName.Text + "')"; btnSelect.Enabled = false; tableSelect.Visible = false; return; } else if (dt.Rows.Count == 1) { long UserID = Shove._Convert.StrToLong(dt.Rows[0]["ID"].ToString(), -1); if (UserID < 0) { PF.GoError(ErrorNumber.Unknow, "会员数据校验错误。", this.GetType().FullName); return; } Users user = new Users(site.ID)[site.ID, UserID]; if (user == null) { PF.GoError(ErrorNumber.Unknow, "会员数据校验错误。", this.GetType().FullName); return; } string ReturnDescription = ""; if (user.LoginDirect(ref ReturnDescription) < 0) { PF.GoError(ErrorNumber.Unknow, ReturnDescription, this.GetType().FullName); return; } Response.Redirect("../../Index.aspx", true); return; } // 绑定了多个用户 tableRegister.Visible = false; btnOK.Enabled = false; tableSelect.Visible = true; btnSelect.Enabled = true; Shove.ControlExt.FillDropDownList(ddlName, dt, "Name", "ID"); ddlName.SelectedIndex = 0; } }
protected void btnReg_Click(object sender, EventArgs e) { System.Threading.Thread.Sleep(500); string name = Shove._Web.Utility.FilteSqlInfusion(tbFormUserName.Text.Trim()); string email = Shove._Web.Utility.FilteSqlInfusion(tbEmail.Text.Trim()); if (name == "") { Shove._Web.JavaScript.Alert(this, "用户名不能为空。"); return; } if (email == "") { Shove._Web.JavaScript.Alert(this, "邮箱地址不能为空。"); return; } if (!Shove._String.Valid.isEmail(email)) { Shove._Web.JavaScript.Alert(this, "邮箱地址格式不正确。"); return; } if (tbRegCheckCode.Text.Trim() == "") { Shove._Web.JavaScript.Alert(this.Page, "请输入验证码!"); return; } string RegCode = tbRegCheckCode.Text.Trim().ToLower(); if (Shove._Web.Cache.GetCacheAsString("CheckCode_" + Request.Cookies["ASP.NET_SessionId"].Value, "") != Shove._Security.Encrypt.MD5(PF.GetCallCert() + RegCode)) { Shove._Web.JavaScript.Alert(this.Page, "验证码输入错误,请重新输入!"); return; } DataTable dt = new DAL.Tables.T_Users().Open("", "Name = '" + name + "' and Email = '" + email + "'", ""); if (dt == null || dt.Rows.Count < 1) { Shove._Web.JavaScript.Alert(this, "用户名或邮箱不正确。"); return; } if (!Shove._Convert.StrToBool(dt.Rows[0]["isEmailValided"].ToString(), false)) { Shove._Web.JavaScript.Alert(this, "您的邮箱当前还没有激活,不能使用密码找回功能,请联系客服人员帮你找回密码,谢谢合作。"); return; } string key = Shove._Security.Encrypt.EncryptString(PF.GetCallCert(), dt.Rows[0]["ID"].ToString() + "," + DateTime.Now.ToString()); //key进行md5加密后转成16进制后得到一个32位的密文 MD5CryptoServiceProvider md5 = new MD5CryptoServiceProvider(); string sign = BitConverter.ToString(md5.ComputeHash(Encoding.UTF8.GetBytes(key))).Replace("-", ""); key = sign.Substring(0, 16) + key + sign.Substring(16, 16); string url = Shove._Web.Utility.GetUrl() + "/Home/Room/ResetPassword.aspx?key=" + key; StringBuilder sb = new StringBuilder(); sb.Append("<div style='font-weight:bold;'>尊敬的" + _Site.Name + "客户(").Append(name).Append("):</div>") .Append("<div>您好!</div>") .Append("<div>系统已收到您的密码找回申请,请点击链接<a href='").Append(url).Append("' target='_top'>").Append(url).Append("</a>重设您的密码。</div>") .Append("<div>为了您的安全,该邮件通知地址将在 24 小时后失效,谢谢合作。</div>") .Append("<div>此邮件由系统发出,请勿直接回复!</div>") .Append("<div>").Append(Shove._Web.Utility.GetUrlWithoutHttp()).Append(" 版权所有(C) 2008-2009</div>"); int Result = PF.SendEmail(_Site, email, "密码找回通知信", sb.ToString()); if (Result < 0) { new Log("System").Write(this.GetType().FullName + "发送邮件失败"); return; } // 修改客户端Html提示 top_tishi.InnerHtml = "<div class=\"top_ok\"><img src=\"/Images/btn_regyes.gif\" /> 系统已收到您的密码找回申请,为了您的安全,该邮件通知地址将在 24 小时后失效,谢谢合作。</div>"; this.tbEmail.ReadOnly = true; this.tbEmail.Text = ""; this.tbFormUserName.ReadOnly = true; this.tbRegCheckCode.Text = ""; this.tbRegCheckCode.ReadOnly = true; Shove._Web.JavaScript.Alert(this.Page, "系统已发送邮件到您的邮箱中"); }
protected void btnReg_Click(object sender, EventArgs e) { if (tbRegCheckCode.Text.Trim() == "") { Shove._Web.JavaScript.Alert(this.Page, "请输入验证码!"); return; } string RegCode = tbRegCheckCode.Text.Trim().ToLower(); if (Shove._Web.Cache.GetCacheAsString("CheckCode_" + Request.Cookies["ASP.NET_SessionId"].Value, "") != Shove._Security.Encrypt.MD5(PF.GetCallCert() + RegCode)) { Shove._Web.JavaScript.Alert(this.Page, "验证码输入错误,请重新输入!"); return; } long CpsID = -1; long CommenderID = -1; string Memo = ""; FirstUrl firstUrl = new FirstUrl(); string URL = firstUrl.Get(); if (!URL.StartsWith("http://")) { URL = "http://" + URL; URL = URL.Split('?'.ToString().ToCharArray())[0]; } DataTable dt = new DAL.Tables.T_Cps().Open("id, [ON], [Name]", "SiteID = " + _Site.ID.ToString() + " and( DomainName = '" + URL + "' or DomainName='" + Shove._Web.Utility.GetUrl() + "')", ""); if (Shove._Convert.StrToLong(firstUrl.CpsID, -1) > 0) //读取第一次访问页面时保存的CPS ID { CpsID = Shove._Convert.StrToLong(firstUrl.CpsID, -1); } else if ((dt != null) && (dt.Rows.Count > 0)) { CpsID = Shove._Convert.StrToLong(dt.Rows[0]["ID"].ToString(), -1); Memo = firstUrl.PID;//联盟商推广URL的PID } System.Threading.Thread.Sleep(500); string Name = TBUserName.Text.Trim(); string Password = TBPwdOne.Text.Trim(); string Password2 = TBPwdTwo.Text.Trim(); string Email = TBUserMail.Text.Trim(); string RealityName = tbRealityName.Text.Trim(); string Mobile = TBMobile.Text.Trim(); Users user = new Users(_Site.ID); user.Name = Name; user.Password = Password; user.Email = Email; user.RealityName = RealityName; user.UserType = 2; user.Mobile = Mobile; if (!string.IsNullOrEmpty(hidCity.Value)) { DataTable dtCity = new DAL.Views.V_Citys().Open("ID", "City='" + hidCity.Value.Substring(0, hidCity.Value.Length - 1) + "'", ""); if (dtCity != null && dtCity.Rows.Count == 1) { user.CityID = Shove._Convert.StrToInt(dtCity.Rows[0]["ID"].ToString(), 1); } } dt = new DAL.Tables.T_Users().Open("", "id=" + Shove._Web.Utility.GetRequest("CID") + " and Name='" + Shove._Web.Utility.GetRequest("CN") + "'", ""); if ((dt != null) && (dt.Rows.Count == 1)) { CommenderID = Shove._Convert.StrToLong(Shove._Web.Utility.GetRequest("CID"), -1); } user.CommenderID = CommenderID; user.CpsID = CpsID; user.Memo = Memo; string ReturnDescription = ""; int Result = user.Add(ref ReturnDescription); if (Result < 0) { new Log("Users").Write("会员注册不成功:" + ReturnDescription); Shove._Web.JavaScript.Alert(this, ReturnDescription); return; } Result = user.Login(ref ReturnDescription); if (Result < 0) { new Log("Users").Write("注册成功后登录失败:" + ReturnDescription); Shove._Web.JavaScript.Alert(this, ReturnDescription); return; } Response.Redirect("Home/Room/UserRegSuccess.aspx"); }
private void Betting() // 解析,投注 { DAL.Tables.T_SmsBettings t_SmsBettings = new DAL.Tables.T_SmsBettings(); DataTable dt = t_SmsBettings.Open(ConnectionString, "", "HandleResult = 0", "[ID]"); if (dt == null) { msg.Send("Read SMS fail."); log.Write("Read SMS fail."); return; } foreach (DataRow dr in dt.Rows) { string ID = dr["ID"].ToString(); string Mobile = dr["From"].ToString().Trim(); string Content = Shove._Convert.ToDBC(dr["Content"].ToString()).Trim(); if ((Mobile == "") || (Content == "")) { t_SmsBettings.HandleResult.Value = -1; t_SmsBettings.HandleDescription.Value = "短信格式错误(1000)"; t_SmsBettings.Update(ConnectionString, "[ID] = " + ID); continue; } string[] Contents = Content.Split(';'); if ((Contents == null) || (Contents.Length != 6)) { t_SmsBettings.HandleResult.Value = -1; t_SmsBettings.HandleDescription.Value = "短信格式错误(1001)"; t_SmsBettings.Update(ConnectionString, "[ID] = " + ID); continue; } // 1;501;1;1;010203040506+01|010203040506+01;#2 站点ID;玩法ID;总份数;认购份数;号码|号码;#倍数 long SiteID = Shove._Convert.StrToLong(Contents[0], -1); if (SiteID < 0) { t_SmsBettings.HandleResult.Value = -1; t_SmsBettings.HandleDescription.Value = "短信格式错误(1002)"; t_SmsBettings.Update(ConnectionString, "[ID] = " + ID); continue; } if (new DAL.Tables.T_Sites().GetCount(ConnectionString, "[ID] = " + SiteID.ToString()) < 0) { t_SmsBettings.HandleResult.Value = -1; t_SmsBettings.HandleDescription.Value = "短信格式错误(1003)"; t_SmsBettings.Update(ConnectionString, "[ID] = " + ID); continue; } #region 投注 if (!Contents[5].StartsWith("#")) { t_SmsBettings.HandleResult.Value = -1; t_SmsBettings.HandleDescription.Value = "短信格式错误(1004)"; t_SmsBettings.Update(ConnectionString, "[ID] = " + ID); continue; } int PlayTypeID = Shove._Convert.StrToInt(Contents[1], -1); int Share = Shove._Convert.StrToInt(Contents[2], -1); int BuyShare = Shove._Convert.StrToInt(Contents[3], -1); string LotteryNumber = Contents[4].Trim(); int Multiple = Shove._Convert.StrToInt(Contents[5].Substring(1, Contents[5].Length - 1), -1); if ((PlayTypeID < 0) || (BuyShare < 0) || (Share < BuyShare) || (LotteryNumber == "") || (Multiple < 0)) { t_SmsBettings.HandleResult.Value = -1; t_SmsBettings.HandleDescription.Value = "短信格式错误(1005)"; t_SmsBettings.Update(ConnectionString, "[ID] = " + ID); continue; } // 根据手机获取用户 DataTable dtUsers = new DAL.Tables.T_Users().Open(ConnectionString, "[ID], Balance", "SiteID = " + SiteID.ToString() + " and Mobile = '" + Mobile + "' and isMobileValided = 1", ""); if ((dtUsers == null) || (dtUsers.Rows.Count != 1)) { t_SmsBettings.HandleResult.Value = -1; t_SmsBettings.HandleDescription.Value = "用户不存在(1006)"; t_SmsBettings.Update(ConnectionString, "[ID] = " + ID); continue; } long UserID = Shove._Convert.StrToLong(dtUsers.Rows[0]["ID"].ToString(), -1); double Balance = Shove._Convert.StrToDouble(dtUsers.Rows[0]["Balance"].ToString(), 0); if (UserID < 0) { t_SmsBettings.HandleResult.Value = -1; t_SmsBettings.HandleDescription.Value = "用户不存在(1007)"; t_SmsBettings.Update(ConnectionString, "[ID] = " + ID); continue; } // 获取彩种、同时也校验了玩法 DataTable dtLottery = new DAL.Tables.T_PlayTypes().Open(ConnectionString, "LotteryID, Price, MaxMultiple", "[ID] = " + PlayTypeID.ToString(), ""); if ((dtLottery == null) || (dtLottery.Rows.Count < 1)) { t_SmsBettings.HandleResult.Value = -1; t_SmsBettings.HandleDescription.Value = "短信格式错误(1008)"; t_SmsBettings.Update(ConnectionString, "[ID] = " + ID); continue; } int LotteryID = Shove._Convert.StrToInt(dtLottery.Rows[0]["LotteryID"].ToString(), -1); double Price = Shove._Convert.StrToDouble(dtLottery.Rows[0]["Price"].ToString(), -1); int MaxMultiple = Shove._Convert.StrToInt(dtLottery.Rows[0]["MaxMultiple"].ToString(), -1); if ((LotteryID < 0) || (Price < 2) || (Multiple > MaxMultiple)) { t_SmsBettings.HandleResult.Value = -1; t_SmsBettings.HandleDescription.Value = "短信格式错误(10090)"; t_SmsBettings.Update(ConnectionString, "[ID] = " + ID); continue; } // 校验投注号码,计算注数、金额 int Num = 0; LotteryNumber = GetLotteryNumber(LotteryID, PlayTypeID, LotteryNumber, ref Num); if (Num < 1) { t_SmsBettings.HandleResult.Value = -1; t_SmsBettings.HandleDescription.Value = "投注号码错误(1010)"; t_SmsBettings.Update(ConnectionString, "[ID] = " + ID); continue; } double Money = Num * Price * Multiple; // 获取期号 DataTable dtIsuse = new DAL.Tables.T_Isuses().Open(ConnectionString, "top 1 [ID]", "LotteryID = " + LotteryID.ToString() + " and GetDate() between StartTime and dbo.F_GetIsuseSystemEndTime([ID], " + PlayTypeID.ToString() + ") and IsOpened = 0", ""); if ((dtIsuse == null) || (dtIsuse.Rows.Count < 1)) { t_SmsBettings.HandleResult.Value = -1; t_SmsBettings.HandleDescription.Value = "奖期未开启(1011)"; t_SmsBettings.Update(ConnectionString, "[ID] = " + ID); continue; } long IsuseID = Shove._Convert.StrToLong(dtIsuse.Rows[0]["ID"].ToString(), -1); if (IsuseID < 0) { t_SmsBettings.HandleResult.Value = -1; t_SmsBettings.HandleDescription.Value = "奖期未开启(1012)"; t_SmsBettings.Update(ConnectionString, "[ID] = " + ID); continue; } // 校验余额 if (Balance < Money) { t_SmsBettings.HandleResult.Value = -1; t_SmsBettings.HandleDescription.Value = "投注卡账户余额不足(1013)"; t_SmsBettings.Update(ConnectionString, "[ID] = " + ID); continue; } // 投注 string ReturnDescription = ""; long SchemeID = InitiateScheme(SiteID, UserID, IsuseID, PlayTypeID, "本方案由用户手动编写短信代码投注(系统)", "短信ID:" + ID + "\r\n短信内容:" + Content, LotteryNumber, "", Multiple, Money, 0, Share, BuyShare, "", 0, ref ReturnDescription); if (SchemeID < 0) { t_SmsBettings.HandleResult.Value = -1; t_SmsBettings.HandleDescription.Value = ReturnDescription + "(1015)"; t_SmsBettings.Update(ConnectionString, "[ID] = " + ID); continue; } t_SmsBettings.SchemeID.Value = SchemeID; t_SmsBettings.HandleResult.Value = 1; t_SmsBettings.Update(ConnectionString, "[ID] = " + ID); #endregion } }
public void ClearanceStatistics_Challenge_Save() { // 查询擂台方案表 DataTable dt1 = new DAL.Tables.T_ChallengeSaveScheme().Open(ConnectionString, "ID, LotteryNumber,SchemeNumber,InitiateUserID,PlayTypeID,1 as Multiple", " not exists(select ID from T_BuyWays where T_ChallengeSaveScheme.ID = T_BuyWays.SchemeID and Type = 3)", ""); if (dt1 == null) { new Log("System").Write("T_Schemes表繁忙,请稍候再读"); return; } if (dt1.Rows.Count < 1) { return; } string InitiateUserID = ""; string LotteryNumber = ""; string SchemeNumber = ""; int SchemeLength = 0; int PlayTypeID = 0; string BuyWays = ""; DataTable dtMatch1 = null; DataRow[] drMatch1 = null; foreach (DataRow dr in dt1.Rows) { LotteryNumber = dr["LotteryNumber"].ToString(); PlayTypeID = Shove._Convert.StrToInt(dr["PlayTypeID"].ToString(), 7201); SchemeNumber = dr["SchemeNumber"].ToString(); SchemeLength = LotteryNumber.Split(';').Length; if (SchemeLength < 3) { new Log("System").Write("方案内容错误");//写错误日志 continue; } BuyWays = GetPassWay(LotteryNumber); string BuyNumber = LotteryNumber.Trim().Split(';')[1].ToString(); string Numbers = BuyNumber.Substring(1, BuyNumber.Length - 1).Substring(0, BuyNumber.Length - 2).ToString().Trim(); int GamesNumber = Numbers.Split('|').Length; //选择场次 string Locate = ""; string[] Matchs = new string[GamesNumber]; string[] BuyResutl = new string[GamesNumber]; string Matchids1 = ""; string Result1 = ""; int GamesNumber1 = 0; for (int i = 0; i < GamesNumber; i++) { Locate = Numbers.Split('|')[i]; Matchs[i] = Locate.Substring(0, Locate.IndexOf('(')); BuyResutl[i] = Locate.Substring(Locate.IndexOf('(') + 1, (Locate.IndexOf(')') - Locate.IndexOf('(') - 1)); Matchids1 += Locate.Substring(0, Locate.IndexOf('(')) + ","; } if (Matchids1.EndsWith(",")) { Matchids1 = Matchids1.Substring(0, Matchids1.Length - 1); } if (string.IsNullOrEmpty(Matchids1)) { continue; } dtMatch1 = new DAL.Tables.T_Match().Open(ConnectionString, "ID,SPFResult, BQCResult, ZJQSResult, ZQBFResult", "id in (" + Matchids1 + ") and isnull(SPFResult, '') <> '' and IsOpened = 1", ""); // 查询字段 if (dtMatch1 == null) { new Log("System").Write("T_Match表繁忙,请稍候再读");// 写日志 continue; } if (dtMatch1.Rows.Count < 1) { new Log("System").Write("T_Match表没数据"); // 写日志 continue; } if (dtMatch1.Rows.Count != Matchids1.Split(',').Length) { continue; } string MatchResult = " "; #region 循环比较赛果 for (int j = 0; j < Matchs.Length; j++) { drMatch1 = dtMatch1.Select("ID=" + Matchs[j]); if (drMatch1.Length < 1) { continue; } switch (PlayTypeID) { case 7201: Result1 = drMatch1[0]["SPFResult"].ToString(); MatchResult = Get7201(Result1); break; case 7204: Result1 = drMatch1[0]["BQCResult"].ToString(); MatchResult = Get7204(Result1); break; case 7203: Result1 = drMatch1[0]["ZJQSResult"].ToString(); MatchResult = Get7203(Result1); break; case 7202: Result1 = drMatch1[0]["ZQBFResult"].ToString(); MatchResult = Get7202(Result1); break; default: break; } if (BuyResutl[j].Contains(MatchResult)) { GamesNumber1++; //命中场次 } // 比较赛果 } #endregion string CanonicalNumber = ""; int count1 = 0; DataTable dtMatch2 = null; DataRow[] drMatch2 = null; string Result2 = ""; int num = 0; int count2 = 0; string Locate2 = ""; string Matchids2 = ""; double WinMoney = 0; double T_WinMoney = 0; string[] strs = LotteryNumber.Split('\r'); string[] LotteryNumbers = null; if (strs.Length < 1) { continue; } foreach (string str in strs) { if (string.IsNullOrEmpty(str.Replace("\n", "").Replace("\r", ""))) { continue; } LotteryNumbers = new Lottery()[72].ToSingle(str, ref CanonicalNumber, PlayTypeID); if (LotteryNumbers.Length < 1) { continue; } bool IsWin = true; count1 = LotteryNumbers.Length; //注数 for (int k = 0; k < count1; k++) { IsWin = true; num = LotteryNumbers[k].Split('|').Length; string[] Screenings = new string[num]; string[] LocateBuyResult = new string[num]; Matchids2 = " "; for (int l = 0; l < num; l++) { Locate2 = LotteryNumbers[k].Split(';')[1].Substring(1, LotteryNumbers[k].Split(';')[1].Length - 2).Split('|')[l]; Screenings[l] = Locate2.Substring(0, Locate2.IndexOf('(')); LocateBuyResult[l] = Locate2.Substring(Locate2.IndexOf('(') + 1, (Locate2.IndexOf(')') - Locate2.IndexOf('(') - 1)); Matchids2 += Locate2.Substring(0, Locate2.IndexOf('(')) + ","; } if (Matchids2.EndsWith(",")) { Matchids2 = Matchids2.Substring(0, Matchids2.Length - 1); } if (string.IsNullOrEmpty(Matchids2)) { continue; } dtMatch2 = new DAL.Tables.T_Match().Open(ConnectionString, "ID,SPFResult, BQCResult, ZJQSResult, ZQBFResult, SPFBonus, BQCBonus, ZJQSBonus, ZQBFBonus", "id in (" + Matchids2 + ")", ""); // 查询字段 if (dtMatch2 == null) { new Log("System").Write("T_Match表繁忙,请稍候再读");// 写日志 continue; } if (dtMatch2.Rows.Count < 1) { new Log("System").Write("T_Match表没数据");// 写日志 continue; } string MatchResult2 = ""; for (int m = 0; m < Screenings.Length; m++) { drMatch2 = dtMatch2.Select("ID=" + Screenings[m]); if (drMatch2.Length < 1) { continue; } switch (PlayTypeID) { case 7201: Result2 = drMatch2[0]["SPFResult"].ToString(); MatchResult2 = Get7201(Result2); T_WinMoney = Shove._Convert.StrToDouble(drMatch2[0]["SPFBonus"].ToString(), 0); break; case 7204: Result2 = drMatch2[0]["BQCResult"].ToString(); MatchResult2 = Get7204(Result2); T_WinMoney = Shove._Convert.StrToDouble(drMatch2[0]["BQCBonus"].ToString(), 0); break; case 7203: Result2 = drMatch2[0]["ZJQSResult"].ToString(); MatchResult2 = Get7203(Result2); T_WinMoney = Shove._Convert.StrToDouble(drMatch2[0]["ZJQSBonus"].ToString(), 0); break; case 7202: Result2 = drMatch2[0]["ZQBFResult"].ToString(); MatchResult2 = Get7202(Result2); T_WinMoney = Shove._Convert.StrToDouble(drMatch2[0]["ZQBFBonus"].ToString(), 0); break; default: break; } if (!LocateBuyResult[m].Equals(MatchResult2)) { IsWin = false; continue; } else if (BuyWays.Equals("单关")) { WinMoney += T_WinMoney * Shove._Convert.StrToInt(dr["Multiple"].ToString(), 1); } } if (IsWin) { count2++; //中奖注数 } } } InitiateUserID = dr["InitiateUserID"].ToString(); DataTable users = new DAL.Tables.T_Users().Open(ConnectionString, "Name", "ID =" + InitiateUserID, ""); if (users == null) { new Log("System").Write("T_Users表繁忙,请稍候再读"); return; } if (users.Rows.Count < 1) { new Log("System").Write("T_Users表没数据"); continue; } string Name = users.Rows[0]["Name"].ToString(); DAL.Tables.T_BuyWays bw = new DAL.Tables.T_BuyWays(); bw.SchemeID.Value = Shove._Convert.StrToLong(dr["ID"].ToString(), 0); bw.SchemeNumber.Value = SchemeNumber; bw.Name.Value = Name; bw.PlayTypeID.Value = PlayTypeID; bw.Count1.Value = count1; bw.BuyWays.Value = BuyWays; bw.Count2.Value = count2; bw.GameNumber.Value = GamesNumber; bw.GameNumber2.Value = GamesNumber1; bw.Rate.Value = GamesNumber1 * 1.00 / GamesNumber * 1.00; bw.UserID.Value = InitiateUserID; bw.Type.Value = 3; long Result = bw.Insert(ConnectionString); if (Result < 0) { new Log("System").Write("BuyWays数据表插入数据不成功"); } } }