public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtUserName.Text.Trim().Length == 0)
{
strErr += "UserName不能为空！\\n";
}
if (this.txtUserPwd.Text.Trim().Length == 0)
{
strErr += "UserPwd不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int UserId = int.Parse(this.lblUserId.Text);
string UserName = this.txtUserName.Text;
string UserPwd = this.txtUserPwd.Text;
Shop.Model.UserManager model = new Shop.Model.UserManager();
model.UserId = UserId;
model.UserName = UserName;
model.UserPwd = UserPwd;
Shop.BLL.UserManager bll = new Shop.BLL.UserManager();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Shop.Model.UserManager model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update UserManager set ");
strSql.Append("UserName=@UserName,");
strSql.Append("UserPwd=@UserPwd");
strSql.Append(" where UserId=@UserId");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 50),
new SqlParameter("@UserPwd", SqlDbType.NVarChar, 50),
new SqlParameter("@UserId", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.UserPwd;
parameters[2].Value = model.UserId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Shop.Model.UserManager model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into UserManager(");
strSql.Append("UserName,UserPwd)");
strSql.Append(" values (");
strSql.Append("@UserName,@UserPwd)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 50),
new SqlParameter("@UserPwd", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.UserPwd;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
private void ShowInfo(int UserId)
{
Shop.BLL.UserManager bll = new Shop.BLL.UserManager();
Shop.Model.UserManager model = bll.GetModel(UserId);
this.lblUserId.Text = model.UserId.ToString();
this.txtUserName.Text = model.UserName;
this.txtUserPwd.Text = model.UserPwd;
}
public bool Update(Shop.Model.UserManager model, bool isPwdEdit)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update UserManager set ");
strSql.Append("UserName=@UserName");
if (isPwdEdit)
{
strSql.Append(",UserPwd=@UserPwd");
}
strSql.Append(" where UserId=@UserId");
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 50)
{
Value = model.UserName
},
new SqlParameter("@UserId", SqlDbType.Int, 4)
{
Value = model.UserId
}
};
if (isPwdEdit)
{
parameters.Add(new SqlParameter("@UserPwd", SqlDbType.NVarChar, 50)
{
Value = model.UserPwd
});
}
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters.ToArray());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
//验证码
if (Session["ValidateCode"] == null)
{
return;
}
if (Request["vcode"].Equals(Session["ValidateCode"].ToString()))
{
//用户名密码
Shop.Model.UserManager umModel = new Shop.Model.UserManager()
{
UserName = Request["uname"],
UserPwd = Shop.Common.DEncrypt.MD5Encrypt.EncryptString(Request["upwd"])
};
Shop.BLL.UserManager umBll = new Shop.BLL.UserManager();
int id = 0;
if (umBll.Exists(umModel, out id))
{
Session["ValidateCode"] = null;
umModel.UserId = id;
//标记登录成功
Session["UserModel"] = umModel;
Response.Redirect("Index.aspx");
}
else
{
Msg = "用户名或密码错误";
}
}
else
{
Msg = "验证码错误";
}
Session["ValidateCode"] = null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Shop.Model.UserManager DataRowToModel(DataRow row)
{
Shop.Model.UserManager model = new Shop.Model.UserManager();
if (row != null)
{
if (row["UserId"] != null && row["UserId"].ToString() != "")
{
model.UserId = int.Parse(row["UserId"].ToString());
}
if (row["UserName"] != null)
{
model.UserName = row["UserName"].ToString();
}
if (row["UserPwd"] != null)
{
model.UserPwd = row["UserPwd"].ToString();
}
}
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request["uname"]))
{
Shop.Model.UserManager umModel = new Shop.Model.UserManager()
{
UserName = Request["uname"],
UserPwd = Shop.Common.DEncrypt.MD5Encrypt.EncryptString(Request["upwd"])
};
Shop.BLL.UserManager umBll = new Shop.BLL.UserManager();
if (umBll.Add(umModel) > 0)
{
Response.Redirect("UserManagerList.aspx");
}
else
{
Msg = "添加失败，请稍候重试";
}
}
}
public bool Exists(Shop.Model.UserManager model, out int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from UserManager");
strSql.Append(" where UserName=@name and UserPwd=@pwd");
SqlParameter[] parameters =
{
new SqlParameter("@name", SqlDbType.NVarChar, 50)
{
Value = model.UserName
},
new SqlParameter("@pwd", model.UserPwd)
};
strSql = new StringBuilder("");
strSql.Append("select UserId from UserManager where UserName=@name and UserPwd=@pwd");
id = Convert.ToInt32(DbHelperSQL.GetSingle(strSql.ToString(), parameters));
return(DbHelperSQL.Exists(strSql.ToString(), parameters));
}
protected void Page_Load(object sender, EventArgs e)
{
Shop.BLL.UserManager umBll = new Shop.BLL.UserManager();
if (IsPostBack)//判断是否回传
{
//修改处理
bool isPwdEdit = false;
UMModel = new Shop.Model.UserManager()
{
UserId = int.Parse(Request["uid"]),
UserName = Request["uname"],
};
//判断密码是否修改
if (!Request["upwd"].Equals(Request["upwd2"]))
{
isPwdEdit = true;
UMModel.UserPwd = Shop.Common.DEncrypt.MD5Encrypt.EncryptString(Request["upwd"]);
}
if (umBll.Update(UMModel, isPwdEdit))
{
//弹出提示框，确定后跳转页面
Response.Write("<script language=javascript>alert('修改成功！即将跳转列表页');window.location = 'UserManagerList.aspx';</script>");
//Response.Redirect("UserManagerList.aspx");
//MsgBox("修改成功，将跳转列表页", "UserManagerList.aspx");
}
else
{
Response.Write("修改失败，请稍候重试");
}
}
else
{
//修改展示
int id = int.Parse(Request["id"]);//获取传递的id
UMModel = umBll.GetModel(id);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Shop.Model.UserManager GetModel(int UserId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 UserId,UserName,UserPwd from UserManager ");
strSql.Append(" where UserId=@UserId");
SqlParameter[] parameters =
{
new SqlParameter("@UserId", SqlDbType.Int, 4)
};
parameters[0].Value = UserId;
Shop.Model.UserManager model = new Shop.Model.UserManager();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public bool Exists(Shop.Model.UserManager model, out int id)
{
return(dal.Exists(model, out id));
}
public bool Update(Shop.Model.UserManager model, bool isPwdEdit)
{
return(dal.Update(model, isPwdEdit));
}
