public SiteMemberInfo MemberData(string UserName)
{
SiteMemberInfo sm = new SiteMemberInfo();
var path = @"..\..\..\TMS_App_CodeTests\TestData\ProviderTypeData_AddProviderType.csv";
var dt = CSVFileHelper.OpenCSV(path);
foreach (DataRow dr in dt.Rows)
{
string username = dr[0].ToString();
if (UserName == username)
{
sm.UserName = dr[0].ToString();
sm.UserPwd = dr[1].ToString();
sm.RealName = dr[2].ToString();
sm.HeadPicPath = dr[3].ToString();
sm.Sex = dr[4].ToString();
sm.MobileNum = dr[5].ToString();
sm.IDNum = dr[6].ToString();
sm.Email = dr[7].ToString();
sm.QQ = dr[8].ToString();
sm.WeChat = dr[9].ToString();
sm.TotalCost = Convert.ToDecimal(dr[10].ToString());
sm.TotalPoints = Convert.ToInt32(dr[11].ToString());
sm.UsedPoints = Convert.ToInt32(dr[12].ToString());
sm.AddTime = Convert.ToDateTime(dr[13].ToString());
sm.Remarks = dr[14].ToString();
sm.InviteNum = dr[15].ToString();
sm.InviterUserName = dr[16].ToString();
sm.InviterRealName = dr[17].ToString();
}
else
{
sm = null;
}
}
return(sm);
}
protected void btnReg_Click(object sender, EventArgs e)
{
string userName = tbUserName.Value.Trim();
string pwd1 = tbPwd1.Value.Trim();
string pwd2 = tbPwd2.Value.Trim();
string sex = "";
string inviteNum = tbInviteNum.Value.Trim();
string qq = "";
string weChat = "";
string mobile = "";
string realName = "";
if (userName.IsNullOrEmpty())
{
JsBox.Show("请输入用户名！");
return;
}
if (pwd1.IsNullOrEmpty())
{
JsBox.Show("请输入密码！");
return;
}
if (pwd2.IsNullOrEmpty())
{
JsBox.Show("请输入重复密码！");
return;
}
if (inviteNum.IsNullOrEmpty())
{
JsBox.Show("请输入邀请码！");
return;
}
if (pwd1 != pwd2)
{
JsBox.Show("两次输入的密码不一致！");
return;
}
var member = MemberBLL.Select(userName);
if (member != null)
{
JsBox.Show("该用户名已存在！请选择其他用户名！");
return;
}
var admin = SiteUserBLL.SelectUserByInviteNum(inviteNum);
if (admin == null)
{
JsBox.Show("邀请码不存在！");
return;
}
string pwd = MemberBLL.Encrypt(pwd1);
var model = new SiteMemberInfo();
model.AddTime = DateTime.Now;
model.Email = "";
model.HeadPicPath = "";
model.IDNum = "";
model.InviteNum = inviteNum;
model.InviterRealName = admin.RealName;
model.InviterUserName = admin.Name;
model.MobileNum = mobile;
model.QQ = qq;
model.RealName = realName;
model.Remarks = "";
model.Sex = sex;
model.TotalCost = 0M;
model.TotalPoints = 0;
model.UsedPoints = 0;
model.UserName = userName;
model.UserPwd = pwd;
model.WeChat = weChat;
MemberBLL.AddMember(model);
MemberInfo mi = new MemberInfo();
mi.InviteNum = inviteNum;
mi.RealName = "";
mi.UserName = userName;
MemberBLL.SetLoginInfo(mi);
MessageBox.Show("注册成功！", "MemberIndex.aspx");
}
/// <summary>
/// 支付成功后的处理，如果不是返回success，则表示处理失败，将记录在日志中
/// </summary>
/// <param name="orderNum"></param>
/// <param name="memberUserName"></param>
/// <param name="moneyPayed"></param>
/// <returns></returns>
public static bool PaySuccessHandler(string orderNum, string memberUserName, decimal moneyPayed, out string msg)
{
//支付成功后的处理
//更改订单的已支付额
//更改订单的状态为完成
//增加用户的点数
//记录用户的消费记录
msg = "";
bool success = false;
int points = Convert.ToInt32(moneyPayed);
string orderSql = "Update TravelOrder Set OrderStatus='" + OrderStatus.Finished + "',MoneyPayed=" + moneyPayed + " Where OrderNum='" + orderNum + "' And AddMemberName='" + memberUserName + "'";
using (DbConnection conn = Db.Helper.CreateConnection())
{
conn.ConnectionString = Db.Helper.ConnectionString;
conn.Open();
using (DbTransaction tran = conn.BeginTransaction(System.Data.IsolationLevel.Serializable))
{
try
{
SiteMemberInfo member = MemberBLL.Select(memberUserName, tran);
if (member == null)
{
msg = "用户不存在！";
return(false);
}
decimal oldTotalCost = member.TotalCost;
decimal newTotalCost = oldTotalCost + moneyPayed;
int oldTotalPoints = member.TotalPoints;
int newTotalPoints = oldTotalPoints + points;
member.TotalCost = newTotalCost;
member.TotalPoints = newTotalPoints;
CostHistoryInfo model = new CostHistoryInfo();
model.AddTime = DateTime.Now;
model.CostType = CostType.JoinGroup;
model.GoodsID = 0;
model.GoodsName = "";
model.GoodsNum = 0;
model.MoneyCost = moneyPayed;
model.OrderNum = orderNum;
model.PointsAfter = newTotalPoints;
model.PointsBefore = oldTotalPoints;
model.MoneyBefore = oldTotalCost;
model.MoneyAfter = newTotalCost;
model.PointsCost = points;
model.ExchangeStatus = "";
model.SendTime = GlobalSetting.MinTime;
model.FinishTime = GlobalSetting.MinTime;
model.ExpressName = "";
model.ExpressNum = "";
model.LinkAddress = "";
model.LinkMan = "";
model.LinkPhone = "";
model.Remarks = "";
model.UserName = memberUserName;
Db.Helper.ExecuteNonQuery(tran, orderSql);
MemberBLL.Update(member, tran);
MemberBLL.AddCostHistory(model, tran);
tran.Commit();
success = true;
}
catch (Exception ex)
{
msg = ex.Message;
tran.Rollback();
}
}
}
return(success);
}
public static int Update(SiteMemberInfo model, DbTransaction tran)
{
return(dal.Update(model, tran));
}
public static int Update(SiteMemberInfo model)
{
return(dal.Update(model));
}
public static int AddMember(SiteMemberInfo model)
{
return(dal.Add(model));
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string userName = tbUserName.Text.Trim();
string pwd1 = tbPwd1.Text.Trim();
string pwd2 = tbPwd2.Text.Trim();
string sex = ddlSex.SelectedValue;
string inviteNum = tbInviteNum.Text.Trim();
string qq = tbQQ.Text.Trim();
string weChat = tbWeChat.Text.Trim();
string mobile = tbMobile.Text.Trim();
string realName = tbRealName.Text.Trim();
string[] fields = { userName, pwd1, pwd2, inviteNum, realName, mobile };
string[] names = { "用户名", "密码", "重复密码", "邀请码", "真实姓名", "联系电话" };
if (fields.ValidateHasNullOrEmptyString(names))
{
return;
}
if (pwd1.ValidateIsNotEqualTo(pwd2, "两次输入的密码不一致！"))
{
return;
}
var member = MemberBLL.Select(userName);
if (member.ValidateIsNotNull("该用户名已存在！请选择其他用户名！"))
{
return;
}
var admin = SiteUserBLL.SelectUserByInviteNum(inviteNum);
if (admin.ValidateIsNull("邀请码不存在！"))
{
return;
}
string pwd = MemberBLL.Encrypt(pwd1);
var model = new SiteMemberInfo();
model.AddTime = DateTime.Now;
model.Email = "";
model.HeadPicPath = "";
model.IDNum = "";
model.InviteNum = inviteNum;
model.InviterRealName = admin.RealName;
model.InviterUserName = admin.Name;
model.MobileNum = mobile;
model.QQ = qq;
model.RealName = realName;
model.Remarks = "";
model.Sex = sex;
model.TotalCost = 0M;
model.TotalPoints = 0;
model.UsedPoints = 0;
model.UserName = userName;
model.UserPwd = pwd;
model.WeChat = weChat;
MemberBLL.AddMember(model);
MemberInfo mi = new MemberInfo();
mi.InviteNum = inviteNum;
mi.RealName = "";
mi.UserName = userName;
MemberBLL.SetLoginInfo(mi);
MessageBox.Show("注册成功！", "default.aspx");
}
