protected void Page_Load(object sender, EventArgs e)
{
string userid = Request.QueryString["userId"]; //从地址栏获取传过来的值
if (!IsPostBack) //回传提交，如果不是第一次执行，则不走这段代码
{
mdluser = blluser.GetModel(int.Parse(userid));
TBusername.Text = mdluser.userLoginName;
TBuserTrue.Text = mdluser.userTrueName;
TBuserpwd.Text = mdluser.userPass;
TBuserEmail.Text = mdluser.userEmail;
TBuserTel.Text = mdluser.userTel;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(rr2.Model.userInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update userInfo set ");
strSql.Append("userLoginName=@userLoginName,");
strSql.Append("userTrueName=@userTrueName,");
strSql.Append("userPass=@userPass,");
strSql.Append("userEmail=@userEmail,");
strSql.Append("userTel=@userTel,");
strSql.Append("flag=@flag,");
strSql.Append("ext1=@ext1,");
strSql.Append("ext2=@ext2,");
strSql.Append("ext3=@ext3");
strSql.Append(" where userId=@userId");
SqlParameter[] parameters =
{
new SqlParameter("@userLoginName", SqlDbType.VarChar, 50),
new SqlParameter("@userTrueName", SqlDbType.VarChar, 50),
new SqlParameter("@userPass", SqlDbType.VarChar, 30),
new SqlParameter("@userEmail", SqlDbType.VarChar, 50),
new SqlParameter("@userTel", SqlDbType.VarChar, 20),
new SqlParameter("@flag", SqlDbType.Int, 4),
new SqlParameter("@ext1", SqlDbType.VarChar, 200),
new SqlParameter("@ext2", SqlDbType.VarChar, 200),
new SqlParameter("@ext3", SqlDbType.VarChar, 200),
new SqlParameter("@userId", SqlDbType.Int, 4)
};
parameters[0].Value = model.userLoginName;
parameters[1].Value = model.userTrueName;
parameters[2].Value = model.userPass;
parameters[3].Value = model.userEmail;
parameters[4].Value = model.userTel;
parameters[5].Value = model.flag;
parameters[6].Value = model.ext1;
parameters[7].Value = model.ext2;
parameters[8].Value = model.ext3;
parameters[9].Value = model.userId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void ShowInfo(int userId)
{
rr2.BLL.userInfo bll = new rr2.BLL.userInfo();
rr2.Model.userInfo model = bll.GetModel(userId);
this.lbluserId.Text = model.userId.ToString();
this.txtuserLoginName.Text = model.userLoginName;
this.txtuserTrueName.Text = model.userTrueName;
this.txtuserPass.Text = model.userPass;
this.txtuserEmail.Text = model.userEmail;
this.txtuserTel.Text = model.userTel;
this.txtflag.Text = model.flag.ToString();
this.txtext1.Text = model.ext1;
this.txtext2.Text = model.ext2;
this.txtext3.Text = model.ext3;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public rr2.Model.userInfo DataRowToModel(DataRow row)
{
rr2.Model.userInfo model = new rr2.Model.userInfo();
if (row != null)
{
if (row["userId"] != null && row["userId"].ToString() != "")
{
model.userId = int.Parse(row["userId"].ToString());
}
if (row["userLoginName"] != null)
{
model.userLoginName = row["userLoginName"].ToString();
}
if (row["userTrueName"] != null)
{
model.userTrueName = row["userTrueName"].ToString();
}
if (row["userPass"] != null)
{
model.userPass = row["userPass"].ToString();
}
if (row["userEmail"] != null)
{
model.userEmail = row["userEmail"].ToString();
}
if (row["userTel"] != null)
{
model.userTel = row["userTel"].ToString();
}
if (row["flag"] != null && row["flag"].ToString() != "")
{
model.flag = int.Parse(row["flag"].ToString());
}
if (row["ext1"] != null)
{
model.ext1 = row["ext1"].ToString();
}
if (row["ext2"] != null)
{
model.ext2 = row["ext2"].ToString();
}
if (row["ext3"] != null)
{
model.ext3 = row["ext3"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(rr2.Model.userInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into userInfo(");
strSql.Append("userLoginName,userTrueName,userPass,userEmail,userTel,flag,ext1,ext2,ext3)");
strSql.Append(" values (");
strSql.Append("@userLoginName,@userTrueName,@userPass,@userEmail,@userTel,@flag,@ext1,@ext2,@ext3)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@userLoginName", SqlDbType.VarChar, 50),
new SqlParameter("@userTrueName", SqlDbType.VarChar, 50),
new SqlParameter("@userPass", SqlDbType.VarChar, 30),
new SqlParameter("@userEmail", SqlDbType.VarChar, 50),
new SqlParameter("@userTel", SqlDbType.VarChar, 20),
new SqlParameter("@flag", SqlDbType.Int, 4),
new SqlParameter("@ext1", SqlDbType.VarChar, 200),
new SqlParameter("@ext2", SqlDbType.VarChar, 200),
new SqlParameter("@ext3", SqlDbType.VarChar, 200)
};
parameters[0].Value = model.userLoginName;
parameters[1].Value = model.userTrueName;
parameters[2].Value = model.userPass;
parameters[3].Value = model.userEmail;
parameters[4].Value = model.userTel;
parameters[5].Value = model.flag;
parameters[6].Value = model.ext1;
parameters[7].Value = model.ext2;
parameters[8].Value = model.ext3;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
protected void Button1_Click(object sender, EventArgs e)
{
rr2.Model.userInfo curuser = new rr2.Model.userInfo();
curuser.userLoginName = TBusername.Text;
curuser.userTrueName = TBuserTrue.Text;
curuser.userPass = TBuserpwd.Text;
curuser.userEmail = TBuserEmail.Text;
curuser.userTel = TBuserTel.Text;
curuser.flag = int.Parse(DropDownList1.SelectedValue);
int jg = new rr2.BLL.userInfo().Add(curuser);
if (jg == 0)
{
LblTishi.Text = "注册失败，请检查数据完整性";
}
else
{
LblTishi.Text = "注册成功！！";
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public rr2.Model.userInfo GetModel(int userId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 userId,userLoginName,userTrueName,userPass,userEmail,userTel,flag,ext1,ext2,ext3 from userInfo ");
strSql.Append(" where userId=@userId");
SqlParameter[] parameters =
{
new SqlParameter("@userId", SqlDbType.Int, 4)
};
parameters[0].Value = userId;
rr2.Model.userInfo model = new rr2.Model.userInfo();
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 void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtuserLoginName.Text.Trim().Length == 0)
{
strErr += "userLoginName不能为空！\\n";
}
if (this.txtuserTrueName.Text.Trim().Length == 0)
{
strErr += "userTrueName不能为空！\\n";
}
if (this.txtuserPass.Text.Trim().Length == 0)
{
strErr += "userPass不能为空！\\n";
}
if (this.txtuserEmail.Text.Trim().Length == 0)
{
strErr += "userEmail不能为空！\\n";
}
if (this.txtuserTel.Text.Trim().Length == 0)
{
strErr += "userTel不能为空！\\n";
}
if (!PageValidate.IsNumber(txtflag.Text))
{
strErr += "flag格式错误！\\n";
}
if (this.txtext1.Text.Trim().Length == 0)
{
strErr += "ext1不能为空！\\n";
}
if (this.txtext2.Text.Trim().Length == 0)
{
strErr += "ext2不能为空！\\n";
}
if (this.txtext3.Text.Trim().Length == 0)
{
strErr += "ext3不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int userId = int.Parse(this.lbluserId.Text);
string userLoginName = this.txtuserLoginName.Text;
string userTrueName = this.txtuserTrueName.Text;
string userPass = this.txtuserPass.Text;
string userEmail = this.txtuserEmail.Text;
string userTel = this.txtuserTel.Text;
int flag = int.Parse(this.txtflag.Text);
string ext1 = this.txtext1.Text;
string ext2 = this.txtext2.Text;
string ext3 = this.txtext3.Text;
rr2.Model.userInfo model = new rr2.Model.userInfo();
model.userId = userId;
model.userLoginName = userLoginName;
model.userTrueName = userTrueName;
model.userPass = userPass;
model.userEmail = userEmail;
model.userTel = userTel;
model.flag = flag;
model.ext1 = ext1;
model.ext2 = ext2;
model.ext3 = ext3;
rr2.BLL.userInfo bll = new rr2.BLL.userInfo();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
