/// <summary>
/// 2010/11/25更新，上面那个方法不用了
/// </summary>
/// <param name="siteMember"></param>
/// <returns></returns>
public static int Add(SiteMember siteMember)
{
string strSQL = "INSERT INTO Members(UserName,UserPwd,Email,CreateDateTime,IsPass,Company,Phone,RealName,Fax,InterestProduct,IsReceiveNewProductEmail) VALUES(@UserName,@UserPwd,@Email,GETDATE(),@IsPass,@Company,@Phone,@RealName,@Fax,@InterestProduct,@IsReceiveNewProductEmail);SELECT @@IDENTITY;";
SqlParameter[] parms =
{
new SqlParameter("UserName", SqlDbType.VarChar),
new SqlParameter("UserPwd", SqlDbType.VarChar),
new SqlParameter("Email", SqlDbType.VarChar),
new SqlParameter("IsPass", SqlDbType.Int),
new SqlParameter("Company", SqlDbType.VarChar),
new SqlParameter("Phone", SqlDbType.VarChar),
new SqlParameter("RealName", SqlDbType.VarChar),
new SqlParameter("Fax", SqlDbType.VarChar),
new SqlParameter("InterestProduct", SqlDbType.VarChar),
new SqlParameter("IsReceiveNewProductEmail", SqlDbType.Int),
};
parms[0].Value = siteMember.UserName;
parms[1].Value = siteMember.UserPwd;
parms[2].Value = siteMember.Email;
parms[3].Value = siteMember.IsPass == true ? 1 : 0;
parms[4].Value = siteMember.Company;
parms[5].Value = siteMember.Phone;
parms[6].Value = siteMember.RealName;
parms[7].Value = siteMember.Fax;
parms[8].Value = siteMember.InterestProduct;
parms[9].Value = siteMember.IsReceiveNewProductEmail == true ? 1 : 0;
int userId = Convert.ToInt32(Goodspeed.Library.Data.SQLPlus.ExecuteScalar(CommandType.Text, strSQL, parms));
return(userId);
}
void btnReg_Click(object sender, EventArgs e)
{
//判断用户名是否存在,判断Email是否存在
SiteMember siteMember = new SiteMember();
if (siteMember.Exists(this.txtUserName.Text, this.txtEmail.Text))
{
this.ltMsg.Text = "用户名或Email已存在!";
return;
}
//审核通过（普通用户）
siteMember.Company = this.txtCompany.Text;
siteMember.Email = this.txtEmail.Text;
siteMember.Fax = this.txtFax.Text;
siteMember.InterestProduct = this.txtInterestProduct.Text;
siteMember.IsPass = true;
siteMember.IsReceiveNewProductEmail = this.cbResive.Checked;
siteMember.Phone = this.txtPhone.Text;
siteMember.RealName = this.txtRealName.Text;
siteMember.UserName = this.txtUserName.Text;
siteMember.UserPwd = this.txtPwd.Text;
int userId = siteMember.Update();
//Update UserRole
Roles.AddUsersToRole(new string[] { siteMember.UserName }, "SiteMember");
this.ltMsg.Text = "注册成功!";
}
/// <summary>
/// 2010/11/25 更新
/// </summary>
/// <param name="siteMember"></param>
/// <returns></returns>
public static int Update(SiteMember siteMember)
{
string strSQL = "UPDATE Members SET Email = @Email,Company = @Company,Phone = @Phone,RealName = @RealName,Fax = @Fax,InterestProduct = @InterestProduct,IsReceiveNewProductEmail = @IsReceiveNewProductEmail,UserPwd = @UserPwd WHERE UserId = @UserID";
SqlParameter[] parms =
{
new SqlParameter("Email", SqlDbType.VarChar),
new SqlParameter("Company", SqlDbType.VarChar),
new SqlParameter("Phone", SqlDbType.VarChar),
new SqlParameter("RealName", SqlDbType.VarChar),
new SqlParameter("Fax", SqlDbType.VarChar),
new SqlParameter("InterestProduct", SqlDbType.VarChar),
new SqlParameter("IsReceiveNewProductEmail", SqlDbType.Int),
new SqlParameter("UserId", SqlDbType.Int),
new SqlParameter("UserPwd", SqlDbType.VarChar),
};
parms[0].Value = siteMember.Email;
parms[1].Value = siteMember.Company;
parms[2].Value = siteMember.Phone;
parms[3].Value = siteMember.RealName;
parms[4].Value = siteMember.Fax;
parms[5].Value = siteMember.InterestProduct;
parms[6].Value = siteMember.IsReceiveNewProductEmail == true ? 1 : 0;
parms[7].Value = siteMember.UserId;
parms[8].Value = siteMember.UserPwd;
Goodspeed.Library.Data.SQLPlus.ExecuteNonQuery(CommandType.Text, strSQL, parms);
return(siteMember.UserId);
}
/// <summary>
/// Method wired from Global.asax.cs to represent the first call into the ASA Application stack. Any calls before this event may have unexpected behaviors.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public static void ApplicationRequestStart(Object sender, EventArgs e)
{
if (HttpContext.Current != null &&
HttpContext.Current.Handler != null &&
HttpContext.Current.Handler.GetType() == typeof(MvcHandler)) //Order of operation on this if statement is very specific. Using && ensures if eval will abort before doing anything that causes an exception
{
//We do logging a bit different here to keep the debug logs from having a bunch of irrelvant information about requests that were skipped by the main application.
//This is due to the fact that the event hook we use is fired by ALL requests coming to IIS but we only care about working with the ones for MVC.
//This method is our PRE-Load area for any data or processes we want to handle at the beginning of every request headed for the MVC application,
//TODO: This should likely fire its own event that allows other developers to extend from rather than extending directly into a loader critical for core-site components.
String logMethodName = ".ApplicationRequestStart(Object sender, EventArgs e) - ";
_log.Debug(logMethodName + "Begin Method");
_log.Info(logMethodName + "======= Starting ApplicationRequest " + HttpContext.Current.Request.RawUrl + " ========");
Guid requestId = Guid.NewGuid();
if (HttpContext.Current.Items["SiteMember"] == null)
{
_log.Debug(logMethodName + "No SiteMember in context, loading");
SiteMember member = null;
member = IntegrationLoader.LoadDependency <ISiteMembership>("siteMembership").GetMember();
HttpContext.Current.Items["SiteMember"] = member;
}
_log.Debug(logMethodName + "End Method");
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.btn_Update.Click += new EventHandler(btn_Update_Click);
sm = new SiteMember(User.Identity.Name);
if (!Page.IsPostBack)
{
Init();
}
}
public ActionResult MyAccount()
{
var member = Membership.GetUser(User.Identity.Name);
var model = new SiteMember {
UserName = member.UserName,
Email = member.Email
};
return(View(model));
}
protected void Page_Load(object sender, EventArgs e)
{
this.btnSave.Click += new EventHandler(btnSave_Click);
if (!Page.IsPostBack)
{
SiteMember sm = new SiteMember(User.Identity.Name);
this.txtEmail.Text = sm.Email;
}
}
private SelfReportedLoanListModel RemoveInvalidLoansFromList(SelfReportedLoanListModel srList)
{
//get Id of the member currently logged-in
SiteMember sm = IntegrationLoader.LoadDependency <ISiteMembership>("siteMembership").GetMember();
string individualId = "";
if (sm != null && sm.Profile != null && sm.Profile.Id != null)
{
individualId = sm.Profile.Id.ToString();
_log.Debug(string.Format("SiteMember.Profile.Id = {0}", individualId));
}
List <string> invalidLoanIdList = new List <string>();
//get list of current SRL's for the member logged-in
if (!string.IsNullOrEmpty(individualId))
{
SelfReportedLoanListModel srListFromDB = GetSelfReportedLoans(individualId);
foreach (SelfReportedLoanModel srl in srList.Loans)
{
if (!string.IsNullOrEmpty(srl.LoanSelfReportedEntryId) && srListFromDB != null)//only care about loans being updated here.
{
bool foundValidLoan = false;
foreach (SelfReportedLoanModel srlFromDB in srListFromDB.Loans)
{
if (srl.LoanSelfReportedEntryId == srlFromDB.LoanSelfReportedEntryId)
{
foundValidLoan = true;
break;
}
}
// if a loan attempting to be updated by user isn't in DB, then user is tampering. Remove that loan from the update list.
if (!foundValidLoan)
{
invalidLoanIdList.Add(srl.LoanSelfReportedEntryId);
_log.Warn(string.Format("User attempted to save loan information that did not belong to them. User = {0}, LoanSelfReportedEntryId = {1}",
individualId, srl.LoanSelfReportedEntryId));
}
}
}
foreach (string str in invalidLoanIdList)
{
SelfReportedLoanModel srl = srList.Loans.Find(l => l.LoanSelfReportedEntryId == str);
if (srl != null)
{
srList.Loans.Remove(srl);
}
}
}
return(srList);
}
void Init()
{
sm = new SiteMember(User.Identity.Name);
this.txtCompany.Text = sm.Company;
this.txtEmail.Text = sm.Email;
this.txtFax.Text = sm.Fax;
this.txtInterestProduct.Text = sm.InterestProduct;
this.txtPhone.Text = sm.Phone;
this.txtRealName.Text = sm.RealName;
this.cbResive.Checked = sm.IsReceiveNewProductEmail;
}
void btn_Update_Click(object sender, EventArgs e)
{
SiteMember sm = new SiteMember(User.Identity.Name);
if (sm.UserPwd != this.txtOldPwd.Text)
{
this.ltMsg.Text = "旧密码不正确,请重新输入!";
return;
}
sm.UserPwd = this.txtConfirmNewPwd.Text;
sm.Update();
this.ltMsg.Text = "修改成功,请牢记!";
}
void btnSave_Click(object sender, EventArgs e)
{
SiteMember sm = new SiteMember(User.Identity.Name);
if (sm.UserPwd != this.txtUserPwd.Text)
{
this.ltMsg.Text = "您的旧密码不匹配,请重试";
return;
}
sm.UserPwd = this.txtNewConfirmUserPwd.Text;
sm.Update();
this.ltMsg.Text = "已更新";
}
void btnSave_Click(object sender, EventArgs e)
{
SiteMember sm = new SiteMember(userId);
sm.IsPass = cbIsPass.Checked;
sm.Update();
DataRow dr = MemberManage.GetUserInfo(userId);
if (cbIsPass.Checked)
{
Roles.AddUsersToRoles(new string[] { dr["UserName"].ToString() }, new string[] { "Admin" });
}
}
void btnSave_Click(object sender, EventArgs e)
{
SiteMember sm = new SiteMember(User.Identity.Name);
if (!sm.ExistsEmail(this.txtNewEmail.Text))
{
sm.Email = txtNewEmail.Text;
sm.Update();
this.ltMsg.Text = "已更新";
}
else
{
this.ltMsg.Text = "此Email已存在,请选择其他Email";
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.btnSave.Click += new EventHandler(btnSave_Click);
userId = CECRequest.GetQueryInt("userid", 0);
if (!Page.IsPostBack)
{
if (userId > 0)
{
sm = new SiteMember(userId);
if (sm != null)
{
this.txtUserName.Text = sm.UserName;
this.cbIsPass.Checked = sm.IsPass;
}
}
}
}
void btnRegister_Click(object sender, EventArgs e)
{
if (MemberManage.Exists(this.txtUserName.Text, this.txtUserEmail.Text))
{
this.ltMsg.Text = "用户名或Email已存在";
return;
}
SiteMember sm = new SiteMember();
sm.Email = this.txtUserEmail.Text;
sm.UserName = this.txtUserName.Text;
sm.UserPwd = this.txtConfirmUserPwd.Text;
int i = sm.Update();
if (i > 0)
{
this.ltMsg.Text = "用户已经创建,请等待审核!";
}
}
void btnLogin_Click(object sender, EventArgs e)
{
if (MemberManage.Validator(this.txtUserName.Text, this.txtUserPwd.Text))
{
SiteMember sm = new SiteMember(this.txtUserName.Text);
if (!sm.IsPass)
{
this.ltMsg.Text = "您还没有通过审核或帐号已禁用";
}
else
{
Login(this.txtUserName.Text, this.txtUserPwd.Text);
Response.Redirect(string.Format("{0}pagesadmin/index.aspx", ResolveUrl("~")));
}
}
else
{
this.ltMsg.Text = "用户名或密码错误!";
}
}
private bool IsSRLForPersonLoggedIn(string srlId)
{
bool srlBelongsToPersonLoggedIn = false;
//get Id of the member currently logged-in
SiteMember sm = IntegrationLoader.LoadDependency <ISiteMembership>("siteMembership").GetMember();
string individualId = "";
if (sm != null && sm.Profile != null && sm.Profile.Id != null)
{
individualId = sm.Profile.Id.ToString();
}
//get list of current SRL's for the member logged-in
if (!string.IsNullOrEmpty(individualId))
{
SelfReportedLoanListModel srListFromDB = GetSelfReportedLoans(individualId);
if (!string.IsNullOrEmpty(srlId) && srListFromDB != null)//only care about loans being updated here.
{
foreach (SelfReportedLoanModel srlFromDB in srListFromDB.Loans)
{
if (srlId == srlFromDB.LoanSelfReportedEntryId)
{
srlBelongsToPersonLoggedIn = true;
break;
}
}
if (!srlBelongsToPersonLoggedIn)
{
_log.Warn(string.Format("User attempted to save loan information that did not belong to them. User = {0}, LoanSelfReportedEntryId = {1}", individualId, srlId));
}
}
else if (string.IsNullOrEmpty(srlId))
{
srlBelongsToPersonLoggedIn = true;
}
}
return(srlBelongsToPersonLoggedIn);
}
void btn_Ok_Click(object sender, EventArgs e)
{
//-1，说明没有此用户名名
//0，说明有此用户名，但是Email错误
//1，说明正确
int i = MemberManage.FindPwd(this.txtUserName.Text, this.txtEmail.Text);
if (i == -1)
{
this.ltMsg.Text = "用户名不存在!";
return;
}
if (i == 0)
{
this.ltMsg.Text = "Email不正确!";
return;
}
SiteMember sm = new SiteMember(this.txtUserName.Text);
this.ltMsg.Text = string.Format("请牢记您的密码：{0}，并尽快更新!", sm.UserPwd);
}
public ActionResult UpdateAccount(SiteMember model)
{
if (ModelState.IsValid)
{
try
{
var updatePasswordSuccessful = true;
var member = Membership.GetUser(model.UserName);
member.Email = model.Email;
Membership.UpdateUser(member);
if (!string.IsNullOrEmpty(model.NewPassword))
{
updatePasswordSuccessful = member.ChangePassword(model.OldPassword, model.NewPassword);
}
if (!updatePasswordSuccessful)
{
ModelState.AddModelError("Error", "The old password was not recognized.");
}
else
{
//This is the collection that we use to pass data back
//on redirect.
TempData.Add("Success", "Your account has been updated successfully.");
}
return(RedirectToCurrentUmbracoPage());
}
catch (Exception ex)
{
LogHelper.Error(this.GetType(), "Account Creation Error", ex);
ModelState.AddModelError("Error", "We are sorry, but the system encountered an error. Please try again.");
}
}
return(CurrentUmbracoPage());
}
static void Main(string[] args)
{
#region 596
/*
* foreach (int n in YieldNaturalNumber.Next(100000))
* {
* Console.WriteLine(n);
* }*/
#endregion 596
#region 597
/*
* Person person = new Person();
*
* person.Name = "My";
* person.Age = 16;*/
#endregion 597
SiteMember member = new SiteMember();
member.GetMarried = true;
Console.WriteLine(member.GetMarried);
}
