protected override void AttachChildControls()
{
this.litAmount = (FormatedMoneyLabel)this.FindControl("litAmount");
this.litUsername = (System.Web.UI.WebControls.Literal) this.FindControl("litUsername");
this.litTrueName = (System.Web.UI.WebControls.Literal) this.FindControl("litTrueName");
this.litOrderCount = (System.Web.UI.WebControls.Literal) this.FindControl("litOrderCount");
this.litTelphone = (System.Web.UI.WebControls.Literal) this.FindControl("litTelphone");
this.litCreateTime = (System.Web.UI.WebControls.Literal) this.FindControl("litCreateTime");
this.litLastOrderTime = (System.Web.UI.WebControls.Literal) this.FindControl("litLastOrderTime");
PageTitle.AddSiteNameTitle("下级会员详情");
int userId = 0;
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["UserID"]))
{
int.TryParse(this.Page.Request.QueryString["UserID"], out userId);
}
SubMember mySubUser = MemberProcessor.GetMySubUser(userId);
if (mySubUser == null)
{
this.ShowMessage("错误的会员ID", false);
}
if (this.litAmount != null)
{
this.litAmount.Money = mySubUser.SubMemberSplittin;
}
this.litUsername.Text = mySubUser.UserName;
this.litTrueName.Text = mySubUser.RealName;
this.litOrderCount.Text = mySubUser.OrderNumber.ToString();
this.litTelphone.Text = mySubUser.CellPhone;
this.litCreateTime.Text = mySubUser.CreateDate.ToString("yyyy-MM-dd hh:mm:ss");
}
/// <summary>
/// member
/// </summary>
/// <param name="member"></param>
public void SetMember(SubMember member)
{
string userData = JsonConvert.SerializeObject(member);
FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket(1, member.Name_Member, DateTime.Now, DateTime.Now.AddMinutes(15), false, userData);
string enTicket = FormsAuthentication.Encrypt(authTicket);
HttpCookie usercookie = new HttpCookie("cookieMember", enTicket);
usercookie.Expires = DateTime.Now.AddYears(1);
usercookie.HttpOnly = true;
_context.Response.SetCookie(usercookie);
}
public ActionResult SignUp(SubMember sm)
{
if (sm.Password != sm.ConfirmPassword)
{
ViewBag.Error = "Mật khẩu và xác thực mật khẩu không khớp";
return(View());
}
else
{
sm.ID_Member = "" + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second;
sm.Password = FormsAuthentication.HashPasswordForStoringInConfigFile(sm.Password, "MD5");
db.Members.Add(AutoMapper.Mapper.Map <Member>(sm));
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult LogIn(Member me, string checkBox)
{
try
{
string password = FormsAuthentication.HashPasswordForStoringInConfigFile(me.Password, "MD5");
var member = db.Members.Where(m => m.Email == me.Email && m.Password == password).FirstOrDefault();
var admin = db.Admins.Where(m => m.Email == me.Email && m.Password == password).FirstOrDefault();
if (member != null)
{
SubMember sub = new SubMember();
sub.Email = member.Email;
sub.ID_Member = member.ID_Member;
sub.Name_Member = member.Name_Member;
sub.Phone_Member = member.Phone_Member;
if (checkBox == "on")
{
Xcookie.Instance.SetMember(sub);
}
else
{
Xsession.Member = sub;
}
if (Xsession.url == null)
{
Xsession.url = "Home";
}
return(RedirectToAction("Index", Xsession.url));
}
else
{
ViewBag.message = "Tên tài khoản hoặc mật khẩu không chính xác";
return(View());
}
}
catch (Exception e)
{
return(RedirectToAction("Login", "Account"));
}
}
// GET: Account
// Đăng nhập
public ActionResult LogIn(SubAdmin ss, SubMember sm)
{
string password = FormsAuthentication.HashPasswordForStoringInConfigFile(ss.Password, "MD5");
var member = db.Members.Where(o => o.Email == ss.Email && o.Password == password).FirstOrDefault();
var admin = db.Admins.Where(o => o.Email == sm.Email && o.Password == password).FirstOrDefault();
ViewBag.Message = null;
if (member != null)
{
if (sm.CheckBox == "on")
{
Xcookie.Instance.SetMember(AutoMapper.Mapper.Map <SubMember>(member));
return(RedirectToAction("Index", "Home"));
}
else
{
Xsession.Member = AutoMapper.Mapper.Map <SubMember>(member);
return(RedirectToAction("Index", "Home"));
}
}
else if (admin != null)
{
if (ss.CheckBox == "on")
{
Xcookie.Instance.SetAdmin(AutoMapper.Mapper.Map <SubAdmin>(admin));
return(RedirectToAction("Index", "Home", new { area = "Admin" }));
}
else
{
Xsession.Admin = AutoMapper.Mapper.Map <SubAdmin>(admin);
return(RedirectToAction("Index", "Home", new { area = "Admin" }));
}
}
else
{
ViewBag.Message = "Tên đăng nhập hoặc mật khẩu không chính xác";
}
return(View());
}
public SubMember GetMySubMember(int UserId)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendFormat("SELECT * , (SELECT SUM(Income) FROM Ecshop_SplittinDetails WHERE TradeType = 2 AND SubUserId = m.UserId) AS SubMemberSplittin, (SELECT SUM(Income) FROM Ecshop_SplittinDetails WHERE TradeType = 3 AND SubUserId = m.UserId) AS SubReferralSplittin, (SELECT COUNT(*) FROM Ecshop_SplittinDetails WHERE TradeType = 1 AND UserId = m.UserId) AS ReferralOrderNumber, (SELECT Top 1 TradeDate FROM Ecshop_SplittinDetails WHERE TradeType = 1 AND UserId = m.UserId ORDER BY JournalNumber DESC) AS LastReferralDate from vw_aspnet_Members m where UserId=" + UserId, new object[0]);
SubMember subMember = null;
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(stringBuilder.ToString());
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
subMember = new SubMember();
subMember.UserID = (int)dataReader["UserId"];
subMember.UserName = (string)dataReader["UserName"];
subMember.RealName = "";
if (dataReader["RealName"] != DBNull.Value)
{
subMember.RealName = (string)dataReader["RealName"];
}
if (dataReader["CreateDate"] != DBNull.Value)
{
subMember.CreateDate = (DateTime)dataReader["CreateDate"];
}
if (dataReader["CellPhone"] != DBNull.Value)
{
subMember.CellPhone = (string)dataReader["CellPhone"];
}
if (dataReader["SubMemberSplittin"] != DBNull.Value)
{
subMember.SubMemberSplittin = (decimal)dataReader["SubMemberSplittin"];
}
if (dataReader["OrderNumber"] != DBNull.Value)
{
subMember.OrderNumber = (int)dataReader["OrderNumber"];
}
}
}
return(subMember);
}
