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