308 lines
17 KiB
C#
308 lines
17 KiB
C#
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Web;
|
|||
|
|
using System.Web.UI;
|
|||
|
|
using System.Web.UI.WebControls;
|
|||
|
|
using System.Text;
|
|||
|
|
using System.Data;
|
|||
|
|
using System.Data.SqlClient;
|
|||
|
|
namespace Mtxfw.shop
|
|||
|
|
{
|
|||
|
|
public partial class Member_users_add : Mtxfw.Utility.MemberBase
|
|||
|
|
{
|
|||
|
|
public Mtxfw.DAL.user_info daoUser = new Mtxfw.DAL.user_info();
|
|||
|
|
public Mtxfw.Utility.Config config = new Mtxfw.Utility.Config();
|
|||
|
|
protected String pid, cid, qid;
|
|||
|
|
protected override void OnLoad(EventArgs e)
|
|||
|
|
{
|
|||
|
|
base.OnLoad(e);
|
|||
|
|
|
|||
|
|
if (!IsPostBack)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
Page.Title = "绑定VIP会员 - " + config.webName;
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
Btn_Update.Click += Update_Info;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
protected String GetProvince()
|
|||
|
|
{
|
|||
|
|
StringBuilder sb = new StringBuilder();
|
|||
|
|
Mtxfw.DAL.province daoPro = new Mtxfw.DAL.province();
|
|||
|
|
System.Data.DataSet Ds = daoPro.GetCacheList("", "1=1 Order by Id Asc", "Province");
|
|||
|
|
System.Data.DataTable Dt = (Ds != null && Ds.Tables[0] != null) ? Ds.Tables[0] : null;
|
|||
|
|
foreach (System.Data.DataRow Dr in Dt.Rows)
|
|||
|
|
{
|
|||
|
|
sb.Append("<option value=\"" + Dr["ProvinceID"] + "\">" + Dr["ProvinceName"] + "</option>\r\n");
|
|||
|
|
}
|
|||
|
|
return sb.ToString();
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
protected void Update_Info(object s, EventArgs ex)
|
|||
|
|
{
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
bool b = true;
|
|||
|
|
Text_card.Text = Text_card.Text.Trim();
|
|||
|
|
Text_UserName.Text = Text_UserName.Text.Trim();
|
|||
|
|
Text_Password.Text = Text_Password.Text.Trim();
|
|||
|
|
//Text_Password2.Text = Text_Password2.Text.Trim();
|
|||
|
|
//Text_conform_Password2.Text = Text_conform_Password2.Text.Trim();
|
|||
|
|
if (String.IsNullOrEmpty(Text_card.Text) || String.IsNullOrEmpty(Text_Password.Text))
|
|||
|
|
{
|
|||
|
|
if (String.IsNullOrEmpty(Text_card.Text))
|
|||
|
|
{
|
|||
|
|
b = false;
|
|||
|
|
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>alert('请输入您的卡号！');</script>");
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
b = false;
|
|||
|
|
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>alert('请输入您的卡号密码！');</script>");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
if (!daoUser.IsExistsCarAndPassword(Text_card.Text, Mtxfw.Utility.Security.EncryptString(Text_Password.Text)))
|
|||
|
|
{
|
|||
|
|
b = false;
|
|||
|
|
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>alert('您的卡号不存在或者卡号密码不正确，请换一个再试！');</script>");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
if (String.IsNullOrEmpty(Text_UserName.Text))
|
|||
|
|
{
|
|||
|
|
b = false;
|
|||
|
|
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>alert('请输入用户名！');</script>");
|
|||
|
|
}
|
|||
|
|
Mtxfw.Model.user_info umodel = daoUser.GetModel(Text_card.Text);
|
|||
|
|
if (umodel != null)
|
|||
|
|
{
|
|||
|
|
if (umodel.uLevel6 == 0)
|
|||
|
|
{
|
|||
|
|
b = false;
|
|||
|
|
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>alert('卡号已经激活过了，请换一个再试！');</script>");
|
|||
|
|
}
|
|||
|
|
if (umodel.Id == Card)
|
|||
|
|
{
|
|||
|
|
b = false;
|
|||
|
|
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>alert('邀请人不能是自己！');</script>");
|
|||
|
|
}
|
|||
|
|
if (b)
|
|||
|
|
{
|
|||
|
|
if (!String.IsNullOrEmpty(Text_UserName.Text))
|
|||
|
|
{
|
|||
|
|
if (daoUser.IsExists(Text_UserName.Text) && umodel.UserName != Text_UserName.Text)
|
|||
|
|
{
|
|||
|
|
b = false;
|
|||
|
|
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>alert('用户名已被其它用户占用，请换一个再试！');</script>");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
if (b)
|
|||
|
|
{
|
|||
|
|
if (String.IsNullOrEmpty(Text_RealName.Text))
|
|||
|
|
{
|
|||
|
|
b = false;
|
|||
|
|
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>alert('请输入真实姓名！');</script>");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
if (b)
|
|||
|
|
{
|
|||
|
|
if (!String.IsNullOrEmpty(Text_Phone.Text))
|
|||
|
|
{
|
|||
|
|
if (!System.Text.RegularExpressions.Regex.IsMatch(Text_Phone.Text.Trim(), @"^[1]+[3,4,5,8]+\d{9}"))
|
|||
|
|
{
|
|||
|
|
b = false;
|
|||
|
|
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>alert('手机号码格式填写不正确，只能输入11位数字！');</script>");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
b = false;
|
|||
|
|
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>alert('请输入手机号码！');</script>");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
if (b)
|
|||
|
|
{
|
|||
|
|
if (!String.IsNullOrEmpty(Text_Email.Text))
|
|||
|
|
{
|
|||
|
|
if (daoUser.IsExistsEmail(Text_Email.Text))
|
|||
|
|
{
|
|||
|
|
b = false;
|
|||
|
|
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>alert('您的Email已被其它用户占用，请换一个再试！');</script>");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
int ContactID = Card;
|
|||
|
|
string ContactIDS = "";
|
|||
|
|
|
|||
|
|
SqlDataReader dr = daoUser.GetUserName(ContactID);
|
|||
|
|
if (dr.HasRows)
|
|||
|
|
{
|
|||
|
|
if (dr.Read())
|
|||
|
|
{
|
|||
|
|
ContactID = int.Parse(dr["Id"].ToString());
|
|||
|
|
ContactIDS = dr["ContactIDS"].ToString();
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
dr.Close();
|
|||
|
|
|
|||
|
|
|
|||
|
|
if (b)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
|
|||
|
|
if (IFStores > 0)
|
|||
|
|
{
|
|||
|
|
if (umodel.IFStores > 0)
|
|||
|
|
{
|
|||
|
|
umodel.MemberCard = Text_card.Text;
|
|||
|
|
umodel.UserName = Text_UserName.Text;
|
|||
|
|
umodel.Password = Mtxfw.Utility.Security.EncryptString(Text_Password.Text);
|
|||
|
|
umodel.Password2 = umodel.Password;
|
|||
|
|
|
|||
|
|
umodel.Phone = Text_Phone.Text;
|
|||
|
|
umodel.Email = Text_Email.Text;
|
|||
|
|
|
|||
|
|
umodel.ContactID = ContactID;
|
|||
|
|
if (ContactIDS == "")
|
|||
|
|
{
|
|||
|
|
umodel.ContactIDS = "," + ContactID.ToString() + ",";
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
umodel.ContactIDS = ContactIDS + ContactID.ToString() + ",";
|
|||
|
|
}
|
|||
|
|
daoUser.Update(umodel);
|
|||
|
|
//审核通过
|
|||
|
|
daoUser.UpdateuLevel("uLevel6", 0, umodel.Id);
|
|||
|
|
daoUser.UpdatePassword("regtime", DateTime.Now.ToString(), umodel.Id);
|
|||
|
|
|
|||
|
|
Double money = 0.00;
|
|||
|
|
Double umoney28 = 0.00;
|
|||
|
|
if (umodel.ContactID > 0)
|
|||
|
|
{
|
|||
|
|
Model.user_Results_jl2 mjl2 = new Model.user_Results_jl2();
|
|||
|
|
string UserName = "";
|
|||
|
|
string strUserName = new DAL.user_info().Getzd("UserName", "UserState='正常' And ID=" + umodel.ContactID).ToString();
|
|||
|
|
if (strUserName != "")
|
|||
|
|
{
|
|||
|
|
UserName = strUserName;
|
|||
|
|
}
|
|||
|
|
string strumoney28 = new DAL.user_info().Getzd("(umoney28-umoney29) as umoney28", "UserState='正常' And ID=" + umodel.ContactID).ToString();
|
|||
|
|
if (strumoney28 != "")
|
|||
|
|
{
|
|||
|
|
umoney28 = Convert.ToDouble(strumoney28);
|
|||
|
|
mjl2 = new Model.user_Results_jl2();
|
|||
|
|
money = umodel.umoney20 * 0.1;
|
|||
|
|
mjl2.MemberId = umodel.ContactID;
|
|||
|
|
mjl2.MemberId2 = umodel.Id;
|
|||
|
|
mjl2.Addmoney = money;
|
|||
|
|
mjl2.Cutmoney = 0;
|
|||
|
|
mjl2.Totalmoney = umoney28 + money;
|
|||
|
|
mjl2.addtime = DateTime.Now;
|
|||
|
|
mjl2.BZContent = "绑定" + umodel.UserName + "增加" + money;
|
|||
|
|
mjl2.PayID = "";
|
|||
|
|
mjl2.OrdersIDs = "";
|
|||
|
|
mjl2.OrdersID = 0;
|
|||
|
|
mjl2.utype = 0;
|
|||
|
|
mjl2.utype2 = 0;
|
|||
|
|
mjl2.Seef = -1;
|
|||
|
|
mjl2.seeftime = DateTime.Now;
|
|||
|
|
new DAL.user_Results_jl2().Add(mjl2);
|
|||
|
|
daoUser.UpdateMoney("umoney28", money, umodel.ContactID);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
string strpContactID = daoUser.Getzd("ContactID", "UserState='正常' And Id=" + umodel.ContactID).ToString();
|
|||
|
|
if (strpContactID != "")
|
|||
|
|
{
|
|||
|
|
int pContactID = Convert.ToInt32(strpContactID);
|
|||
|
|
if (pContactID > 0)
|
|||
|
|
{
|
|||
|
|
strumoney28 = new DAL.user_info().Getzd("(umoney28-umoney29) as umoney28", "UserState='正常' And ID=" + pContactID).ToString();
|
|||
|
|
if (strumoney28 != "")
|
|||
|
|
{
|
|||
|
|
umoney28 = Convert.ToDouble(strumoney28);
|
|||
|
|
money = umodel.umoney20 * 0.03;
|
|||
|
|
mjl2 = new Model.user_Results_jl2();
|
|||
|
|
mjl2.MemberId = pContactID;
|
|||
|
|
mjl2.MemberId2 = umodel.Id;
|
|||
|
|
mjl2.Addmoney = money;
|
|||
|
|
mjl2.Cutmoney = 0;
|
|||
|
|
mjl2.Totalmoney = umoney28 + money;
|
|||
|
|
mjl2.addtime = DateTime.Now;
|
|||
|
|
mjl2.BZContent = UserName + "绑定" + umodel.UserName + "增加" + money;
|
|||
|
|
mjl2.PayID = "";
|
|||
|
|
mjl2.OrdersIDs = "";
|
|||
|
|
mjl2.OrdersID = 0;
|
|||
|
|
mjl2.utype = 0;
|
|||
|
|
mjl2.utype2 = 0;
|
|||
|
|
mjl2.Seef = -1;
|
|||
|
|
mjl2.seeftime = DateTime.Now;
|
|||
|
|
new DAL.user_Results_jl2().Add(mjl2);
|
|||
|
|
daoUser.UpdateMoney("umoney28", money, pContactID);
|
|||
|
|
}
|
|||
|
|
strpContactID = daoUser.Getzd("ContactID", "UserState='正常' And Id=" + pContactID).ToString();
|
|||
|
|
if (strpContactID != "")
|
|||
|
|
{
|
|||
|
|
pContactID = Convert.ToInt32(strpContactID);
|
|||
|
|
if (pContactID > 0)
|
|||
|
|
{
|
|||
|
|
strumoney28 = new DAL.user_info().Getzd("(umoney28-umoney29) as umoney28", "UserState='正常' And ID=" + pContactID).ToString();
|
|||
|
|
if (strumoney28 != "")
|
|||
|
|
{
|
|||
|
|
money = umodel.umoney20 * 0.02;
|
|||
|
|
mjl2 = new Model.user_Results_jl2();
|
|||
|
|
mjl2.MemberId = pContactID;
|
|||
|
|
mjl2.MemberId2 = umodel.Id;
|
|||
|
|
mjl2.Addmoney = money;
|
|||
|
|
mjl2.Cutmoney = 0;
|
|||
|
|
mjl2.Totalmoney = umoney28 + money;
|
|||
|
|
mjl2.addtime = DateTime.Now;
|
|||
|
|
mjl2.BZContent = UserName + "绑定" + umodel.UserName + "增加" + money;
|
|||
|
|
mjl2.PayID = "";
|
|||
|
|
mjl2.OrdersIDs = "";
|
|||
|
|
mjl2.OrdersID = 0;
|
|||
|
|
mjl2.utype = 0;
|
|||
|
|
mjl2.utype2 = 0;
|
|||
|
|
mjl2.Seef = -1;
|
|||
|
|
mjl2.seeftime = DateTime.Now;
|
|||
|
|
new DAL.user_Results_jl2().Add(mjl2);
|
|||
|
|
daoUser.UpdateMoney("umoney28", money, pContactID);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>alert('恭喜您，绑定成功！');location.replace('/Member_users.aspx');</script>");
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>alert('您的卡号不是VIP会员，绑定错误！');location.replace('/Member_users.aspx');</script>");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>alert('您的权限不足，绑定错误！');location.replace('/Member_users.aspx');</script>");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>alert('您的卡号不存在，请换一个再试！');</script>");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
catch
|
|||
|
|
{
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
}
|