private void ShowInfo(int u_ID)
{
WalleProject.BLL.t_user bll = new WalleProject.BLL.t_user();
WalleProject.Model.t_user model = bll.GetModel(u_ID);
this.txtu_address.Text = model.u_address;
this.txtu_creaditsLogID.Text = model.u_creaditsLogID.ToString();
this.lblu_ID.Text = model.u_ID.ToString();
this.txtu_nickName.Text = model.u_nickName;
this.txtu_birthDate.Text = model.u_birthDate.ToString();
this.txtu_name.Text = model.u_name;
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(WalleProject.Model.t_user model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_user(");
strSql.Append("u_address,u_lastLoginDate,u_creaditsLogID,u_registrationDate,u_nickName,u_category,u_birthDate,u_state,u_passWord,u_integral,u_creditGrade,u_name,u_pic_ID,u_phone)");
strSql.Append(" values (");
strSql.Append("@u_address,@u_lastLoginDate,@u_creaditsLogID,@u_registrationDate,@u_nickName,@u_category,@u_birthDate,@u_state,@u_passWord,@u_integral,@u_creditGrade,@u_name,@u_pic_ID,@u_phone)");
MySqlParameter[] parameters =
{
new MySqlParameter("@u_address", MySqlDbType.VarChar, 50),
new MySqlParameter("@u_lastLoginDate", MySqlDbType.DateTime),
new MySqlParameter("@u_creaditsLogID", MySqlDbType.Int32, 10),
new MySqlParameter("@u_registrationDate", MySqlDbType.Date),
new MySqlParameter("@u_nickName", MySqlDbType.VarChar, 10),
new MySqlParameter("@u_category", MySqlDbType.VarChar, 10),
new MySqlParameter("@u_birthDate", MySqlDbType.Date),
new MySqlParameter("@u_state", MySqlDbType.VarChar, 10),
new MySqlParameter("@u_passWord", MySqlDbType.VarChar, 10),
new MySqlParameter("@u_integral", MySqlDbType.Int32, 10),
new MySqlParameter("@u_creditGrade", MySqlDbType.VarChar, 10),
new MySqlParameter("@u_name", MySqlDbType.VarChar, 10),
new MySqlParameter("@u_pic_ID", MySqlDbType.Int32, 10),
new MySqlParameter("@u_phone", MySqlDbType.VarChar, 20)
};
parameters[0].Value = model.u_address;
parameters[1].Value = model.u_lastLoginDate;
parameters[2].Value = model.u_creaditsLogID;
parameters[3].Value = model.u_registrationDate;
parameters[4].Value = model.u_nickName;
parameters[5].Value = model.u_category;
parameters[6].Value = model.u_birthDate;
parameters[7].Value = model.u_state;
parameters[8].Value = model.u_passWord;
parameters[9].Value = model.u_integral;
parameters[10].Value = model.u_creditGrade;
parameters[11].Value = model.u_name;
parameters[12].Value = model.u_pic_ID;
parameters[13].Value = model.u_phone;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void ShowInfo(int u_ID)
{
WalleProject.BLL.t_user bll = new WalleProject.BLL.t_user();
WalleProject.Model.t_user model = bll.GetModel(u_ID);
this.lblu_address.Text = model.u_address;
this.lblu_lastLoginDate.Text = string.Format("{0:yyyy-MM-dd}", model.u_lastLoginDate);
this.lblu_creaditsLogID.Text = model.u_creaditsLogID.ToString();
this.lblu_registrationDate.Text = model.u_registrationDate.ToString();
this.lblu_ID.Text = model.u_ID.ToString();
this.lblu_nickName.Text = model.u_nickName;
this.lblu_category.Text = model.u_category;
this.lblu_birthDate.Text = string.Format("{0:yyyy-MM-dd}", model.u_birthDate);
this.lblu_state.Text = model.u_state;
this.lblu_integral.Text = model.u_integral.ToString();
this.lblu_creditGrade.Text = model.u_creditGrade;
this.lblu_name.Text = model.u_name;
}
/// <summary>
/// 通过电话号码得到一个对象实体
/// </summary>
public WalleProject.Model.t_user GetModel(String phone)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select u_phone,u_address,u_lastLoginDate,u_creaditsLogID,u_registrationDate,u_ID,u_nickName,u_category,u_birthDate,u_state,u_passWord,u_integral,u_creditGrade,u_name,u_pic_ID from t_user ");
strSql.Append(" where u_phone=@u_phone");
MySqlParameter[] parameters =
{
new MySqlParameter("@u_phone", MySqlDbType.String)
};
parameters[0].Value = phone;
WalleProject.Model.t_user model = new WalleProject.Model.t_user();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtu_address.Text.Trim().Length == 0)
{
strErr += "u_address不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtu_lastLoginDate.Text))
{
strErr += "u_lastLoginDate格式错误！\\n";
}
if (!PageValidate.IsNumber(txtu_creaditsLogID.Text))
{
strErr += "u_creaditsLogID格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtu_registrationDate.Text))
{
strErr += "u_registrationDate格式错误！\\n";
}
if (this.txtu_nickName.Text.Trim().Length == 0)
{
strErr += "u_nickName不能为空！\\n";
}
if (this.txtu_category.Text.Trim().Length == 0)
{
strErr += "u_category不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtu_birthDate.Text))
{
strErr += "u_birthDate格式错误！\\n";
}
if (this.txtu_state.Text.Trim().Length == 0)
{
strErr += "u_state不能为空！\\n";
}
if (this.txtu_passWord.Text.Trim().Length == 0)
{
strErr += "u_passWord不能为空！\\n";
}
if (!PageValidate.IsNumber(txtu_integral.Text))
{
strErr += "u_integral格式错误！\\n";
}
if (this.txtu_creditGrade.Text.Trim().Length == 0)
{
strErr += "u_creditGrade不能为空！\\n";
}
if (this.txtu_name.Text.Trim().Length == 0)
{
strErr += "u_name不能为空！\\n";
}
if (!PageValidate.IsNumber(txtu_pic_ID.Text))
{
strErr += "u_pic_ID格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string u_address = this.txtu_address.Text;
DateTime u_lastLoginDate = DateTime.Parse(this.txtu_lastLoginDate.Text);
int u_creaditsLogID = int.Parse(this.txtu_creaditsLogID.Text);
DateTime u_registrationDate = DateTime.Parse(this.txtu_registrationDate.Text);
string u_nickName = this.txtu_nickName.Text;
string u_category = this.txtu_category.Text;
DateTime u_birthDate = DateTime.Parse(this.txtu_birthDate.Text);
string u_state = this.txtu_state.Text;
string u_passWord = this.txtu_passWord.Text;
int u_integral = int.Parse(this.txtu_integral.Text);
string u_creditGrade = this.txtu_creditGrade.Text;
string u_name = this.txtu_name.Text;
int u_pic_ID = int.Parse(this.txtu_pic_ID.Text);
WalleProject.Model.t_user model = new WalleProject.Model.t_user();
model.u_address = u_address;
model.u_lastLoginDate = u_lastLoginDate;
model.u_creaditsLogID = u_creaditsLogID;
model.u_registrationDate = u_registrationDate;
model.u_nickName = u_nickName;
model.u_category = u_category;
model.u_birthDate = u_birthDate;
model.u_state = u_state;
model.u_passWord = u_passWord;
model.u_integral = u_integral;
model.u_creditGrade = u_creditGrade;
model.u_name = u_name;
model.u_pic_ID = u_pic_ID;
WalleProject.BLL.t_user bll = new WalleProject.BLL.t_user();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WalleProject.Model.t_user DataRowToModel(DataRow row)
{
WalleProject.Model.t_user model = new WalleProject.Model.t_user();
if (row != null)
{
if (row["u_address"] != null)
{
model.u_address = row["u_address"].ToString();
}
if (row["u_phone"] != null)
{
model.u_phone = row["u_phone"].ToString();
}
if (row["u_lastLoginDate"] != null && row["u_lastLoginDate"].ToString() != "")
{
model.u_lastLoginDate = DateTime.Parse(row["u_lastLoginDate"].ToString());
}
if (row["u_creaditsLogID"] != null && row["u_creaditsLogID"].ToString() != "")
{
model.u_creaditsLogID = int.Parse(row["u_creaditsLogID"].ToString());
}
if (row["u_registrationDate"] != null && row["u_registrationDate"].ToString() != "")
{
model.u_registrationDate = DateTime.Parse(row["u_registrationDate"].ToString());
}
if (row["u_ID"] != null && row["u_ID"].ToString() != "")
{
model.u_ID = int.Parse(row["u_ID"].ToString());
}
if (row["u_nickName"] != null)
{
model.u_nickName = row["u_nickName"].ToString();
}
if (row["u_category"] != null)
{
model.u_category = row["u_category"].ToString();
}
if (row["u_birthDate"] != null && row["u_birthDate"].ToString() != "")
{
model.u_birthDate = DateTime.Parse(row["u_birthDate"].ToString());
}
if (row["u_state"] != null)
{
model.u_state = row["u_state"].ToString();
}
if (row["u_passWord"] != null)
{
model.u_passWord = row["u_passWord"].ToString();
}
if (row["u_integral"] != null && row["u_integral"].ToString() != "")
{
model.u_integral = int.Parse(row["u_integral"].ToString());
}
if (row["u_creditGrade"] != null)
{
model.u_creditGrade = row["u_creditGrade"].ToString();
}
if (row["u_name"] != null)
{
model.u_name = row["u_name"].ToString();
}
if (row["u_pic_ID"] != null && row["u_pic_ID"].ToString() != "")
{
model.u_pic_ID = int.Parse(row["u_pic_ID"].ToString());
}
}
return(model);
}
protected void btn_Login_Click1(object sender, EventArgs e)
{
if ((Session["PassErrorCountAdmin"] != null) && (Session["PassErrorCountAdmin"].ToString() != ""))
{
int PassErroeCount = Convert.ToInt32(Session["PassErrorCountAdmin"]);
if (PassErroeCount > 3)
{
input_userName.Enabled = true;
input_passWord.Enabled = true;
btn_Login.Enabled = false;
this.lblMsg.Text = "对不起，你错误登录了三次，系统登录锁定！";
return;
}
}
Console.WriteLine(Session["CheckCode"]);
#region 检查验证码
if ((Session["CheckCode"] != null) && (Session["CheckCode"].ToString() != ""))
{
if (Session["CheckCode"].ToString().ToLower() != this.CheckCode.Value.ToLower())
{
this.lblMsg.Text = "输入的验证码有误！";
Session["CheckCode"] = null;
return;
}
else
{
this.lblMsg.Text = "";
Session["CheckCode"] = null;
string userName = Maticsoft.Common.PageValidate.InputText(input_userName.Text.Trim(), 30);
string Password = MD5Enctypt.MD5.Md5Encrypt(Maticsoft.Common.PageValidate.InputText(input_passWord.Text.Trim(), 30));
bool isNumber = Maticsoft.Common.PageValidate.IsNumber(userName);
//验证登录信息，如果验证通过则返回当前用户对象的安全上下文信息
// AccountsPrincipal newUser = AccountsPrincipal.ValidateLogin(userName, Password);
BLL.t_user user = new BLL.t_user();
if (isNumber)
{
if (user.Exists(int.Parse(userName)))
{
if (user.IsLogin(int.Parse(userName), Password))
{
WalleProject.Model.t_user _user = new WalleProject.Model.t_user();
_user = user.GetModel(int.Parse(userName));
_user.u_lastLoginDate = DateTime.Now;
if (new BLL.t_user().Update(_user))
{
Session["UserInfo"] = _user;
if (this.chk_remenberMe.Checked)
{
HttpCookie cookie = new HttpCookie("USER_NAME");
cookie.Value = input_userName.Text;
Response.Cookies.Add(cookie);
}
Response.Redirect("../User/Default.aspx?id=1");
}
}
else
{
this.lblMsg.Text = "您输入的密码不正确！";
Response.Write("<script>alert('您输入的密码不正确!')</script>");
}
}
else
{
this.lblMsg.Text = "您输入的用户名不存在！";
Response.Write("<script> alert('您输入的用户名不存在!')</script>");
}
}
}
}
else
{
Response.Redirect("../User/UserLogin.aspx");
}
#endregion
#region
/*
if (newUser == null)//登录信息不对
{
this.lblMsg.Text = "登陆失败： " + userName;
if ((Session["PassErrorCountAdmin"] != null) && (Session["PassErrorCountAdmin"].ToString() != ""))
{
int PassErroeCount = Convert.ToInt32(Session["PassErrorCountAdmin"]);
Session["PassErrorCountAdmin"] = PassErroeCount + 1;
}
else
{
Session["PassErrorCountAdmin"] = 1;
}
}
else
{
//根据用户对象的上下文得到用户对象信息，用于得到其他信息
User currentUser = new LTP.Accounts.Bus.User(newUser);
//if (currentUser.UserType != "AA")
//{
// this.lblMsg.Text = "你非管理员用户，你没有权限登录后台系统！";
// return;
//}
//把当前用户对象实例赋给Context.User，这样做将会把完整的用户信息加载到ASP.NET提供的验证体系中
Context.User = newUser;
//验证当前用户密码
if (((SiteIdentity)User.Identity).TestPassword(Password) == 0)
{
this.lblMsg.Text = "你的密码无效！";
if ((Session["PassErrorCountAdmin"] != null) && (Session["PassErrorCountAdmin"].ToString() != ""))
{
int PassErroeCount = Convert.ToInt32(Session["PassErrorCountAdmin"]);
Session["PassErrorCountAdmin"] = PassErroeCount + 1;
}
else
{
Session["PassErrorCountAdmin"] = 1;
}
}
else
{
//保存当前用户对象信息
FormsAuthentication.SetAuthCookie(userName, false);
Session["UserInfo"] = currentUser;
Session["Style"] = currentUser.Style;
if (Session["returnPage"] != null)
{
string returnpage = Session["returnPage"].ToString();
Session["returnPage"] = null;
Response.Redirect(returnpage);
}
else
{
Response.Redirect("main.htm");
}
}
}*/
#endregion
}
