/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.userinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update userinfo set ");
strSql.Append("uname=@uname,");
strSql.Append("usex=@usex,");
strSql.Append("uage=@uage,");
strSql.Append("uphone=@uphone,");
strSql.Append("uemail=@uemail,");
strSql.Append("wid=@wid,");
strSql.Append("wname=@wname,");
strSql.Append("parameter1=@parameter1,");
strSql.Append("parameter2=@parameter2");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@uname", OleDbType.VarChar, 255),
new OleDbParameter("@usex", OleDbType.VarChar, 255),
new OleDbParameter("@uage", OleDbType.VarChar, 255),
new OleDbParameter("@uphone", OleDbType.VarChar, 255),
new OleDbParameter("@uemail", OleDbType.VarChar, 255),
new OleDbParameter("@wid", OleDbType.VarChar, 255),
new OleDbParameter("@wname", OleDbType.VarChar, 255),
new OleDbParameter("@parameter1", OleDbType.VarChar, 255),
new OleDbParameter("@parameter2", OleDbType.VarChar, 255),
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = model.uname;
parameters[1].Value = model.usex;
parameters[2].Value = model.uage;
parameters[3].Value = model.uphone;
parameters[4].Value = model.uemail;
parameters[5].Value = model.wid;
parameters[6].Value = model.wname;
parameters[7].Value = model.parameter1;
parameters[8].Value = model.parameter2;
parameters[9].Value = model.ID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void ShowInfo(int ID)
{
Maticsoft.BLL.userinfo bll = new Maticsoft.BLL.userinfo();
Maticsoft.Model.userinfo model = bll.GetModel(ID);
this.lblID.Text = model.ID.ToString();
this.txtuname.Text = model.uname;
this.txtusex.Text = model.usex;
this.txtuage.Text = model.uage;
this.txtuphone.Text = model.uphone;
this.txtuemail.Text = model.uemail;
this.txtwid.Text = model.wid;
this.txtwname.Text = model.wname;
this.txtparameter1.Text = model.parameter1;
this.txtparameter2.Text = model.parameter2;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.userinfo DataRowToModel(DataRow row)
{
Maticsoft.Model.userinfo model=new Maticsoft.Model.userinfo();
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["password"]!=null)
{
model.password=row["password"].ToString();
}
if(row["roleid"]!=null && row["roleid"].ToString()!="")
{
model.roleid=int.Parse(row["roleid"].ToString());
}
if(row["telephone"]!=null)
{
model.telephone=row["telephone"].ToString();
}
if(row["usersex"]!=null)
{
model.usersex=row["usersex"].ToString();
}
if(row["address"]!=null)
{
model.address=row["address"].ToString();
}
if(row["email"]!=null)
{
model.email=row["email"].ToString();
}
if(row["logintime"]!=null && row["logintime"].ToString()!="")
{
model.logintime=DateTime.Parse(row["logintime"].ToString());
}
if(row["createtime"]!=null && row["createtime"].ToString()!="")
{
model.createtime=DateTime.Parse(row["createtime"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.userinfo DataRowToModel(DataRow row)
{
Maticsoft.Model.userinfo model = new Maticsoft.Model.userinfo();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["uname"] != null)
{
model.uname = row["uname"].ToString();
}
if (row["usex"] != null)
{
model.usex = row["usex"].ToString();
}
if (row["uage"] != null)
{
model.uage = row["uage"].ToString();
}
if (row["uphone"] != null)
{
model.uphone = row["uphone"].ToString();
}
if (row["uemail"] != null)
{
model.uemail = row["uemail"].ToString();
}
if (row["wid"] != null)
{
model.wid = row["wid"].ToString();
}
if (row["wname"] != null)
{
model.wname = row["wname"].ToString();
}
if (row["parameter1"] != null)
{
model.parameter1 = row["parameter1"].ToString();
}
if (row["parameter2"] != null)
{
model.parameter2 = row["parameter2"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.userinfo DataRowToModel(DataRow row)
{
Maticsoft.Model.userinfo model=new Maticsoft.Model.userinfo();
if (row != null)
{
if(row["ID"]!=null && row["ID"].ToString()!="")
{
model.ID=int.Parse(row["ID"].ToString());
}
if(row["uname"]!=null)
{
model.uname=row["uname"].ToString();
}
if(row["usex"]!=null)
{
model.usex=row["usex"].ToString();
}
if(row["uage"]!=null)
{
model.uage=row["uage"].ToString();
}
if(row["uphone"]!=null)
{
model.uphone=row["uphone"].ToString();
}
if(row["uemail"]!=null)
{
model.uemail=row["uemail"].ToString();
}
if(row["wid"]!=null)
{
model.wid=row["wid"].ToString();
}
if(row["wname"]!=null)
{
model.wname=row["wname"].ToString();
}
if(row["parameter1"]!=null)
{
model.parameter1=row["parameter1"].ToString();
}
if(row["parameter2"]!=null)
{
model.parameter2=row["parameter2"].ToString();
}
}
return model;
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.userinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into userinfo(");
strSql.Append("uname,usex,uage,uphone,uemail,wid,wname,parameter1,parameter2)");
strSql.Append(" values (");
strSql.Append("@uname,@usex,@uage,@uphone,@uemail,@wid,@wname,@parameter1,@parameter2)");
OleDbParameter[] parameters =
{
new OleDbParameter("@uname", OleDbType.VarChar, 255),
new OleDbParameter("@usex", OleDbType.VarChar, 255),
new OleDbParameter("@uage", OleDbType.VarChar, 255),
new OleDbParameter("@uphone", OleDbType.VarChar, 255),
new OleDbParameter("@uemail", OleDbType.VarChar, 255),
new OleDbParameter("@wid", OleDbType.VarChar, 255),
new OleDbParameter("@wname", OleDbType.VarChar, 255),
new OleDbParameter("@parameter1", OleDbType.VarChar, 255),
new OleDbParameter("@parameter2", OleDbType.VarChar, 255)
};
parameters[0].Value = model.uname;
parameters[1].Value = model.usex;
parameters[2].Value = model.uage;
parameters[3].Value = model.uphone;
parameters[4].Value = model.uemail;
parameters[5].Value = model.wid;
parameters[6].Value = model.wname;
parameters[7].Value = model.parameter1;
parameters[8].Value = model.parameter2;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.userinfo GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,uname,usex,uage,uphone,uemail,wid,wname,parameter1,parameter2 from userinfo ");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = ID;
Maticsoft.Model.userinfo model = new Maticsoft.Model.userinfo();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.userinfo GetModel(int userid)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 userid,username,password,roleid,telephone,usersex,address,email,logintime,createtime from userinfo ");
strSql.Append(" where userid=@userid");
SqlParameter[] parameters = {
new SqlParameter("@userid", SqlDbType.Int,4)
};
parameters[0].Value = userid;
Maticsoft.Model.userinfo model=new Maticsoft.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;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtuname.Text.Trim().Length == 0)
{
strErr += "uname不能为空！\\n";
}
if (this.txtusex.Text.Trim().Length == 0)
{
strErr += "usex不能为空！\\n";
}
if (this.txtuage.Text.Trim().Length == 0)
{
strErr += "uage不能为空！\\n";
}
if (this.txtuphone.Text.Trim().Length == 0)
{
strErr += "uphone不能为空！\\n";
}
if (this.txtuemail.Text.Trim().Length == 0)
{
strErr += "uemail不能为空！\\n";
}
if (this.txtwid.Text.Trim().Length == 0)
{
strErr += "wid不能为空！\\n";
}
if (this.txtwname.Text.Trim().Length == 0)
{
strErr += "wname不能为空！\\n";
}
if (this.txtparameter1.Text.Trim().Length == 0)
{
strErr += "parameter1不能为空！\\n";
}
if (this.txtparameter2.Text.Trim().Length == 0)
{
strErr += "parameter2不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string uname = this.txtuname.Text;
string usex = this.txtusex.Text;
string uage = this.txtuage.Text;
string uphone = this.txtuphone.Text;
string uemail = this.txtuemail.Text;
string wid = this.txtwid.Text;
string wname = this.txtwname.Text;
string parameter1 = this.txtparameter1.Text;
string parameter2 = this.txtparameter2.Text;
Maticsoft.Model.userinfo model = new Maticsoft.Model.userinfo();
model.uname = uname;
model.usex = usex;
model.uage = uage;
model.uphone = uphone;
model.uemail = uemail;
model.wid = wid;
model.wname = wname;
model.parameter1 = parameter1;
model.parameter2 = parameter2;
Maticsoft.BLL.userinfo bll = new Maticsoft.BLL.userinfo();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.userinfo GetModel(int ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select ID,uname,usex,uage,uphone,uemail,wid,wname,parameter1,parameter2 from userinfo ");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters = {
new OleDbParameter("@ID", OleDbType.Integer,4)
};
parameters[0].Value = ID;
Maticsoft.Model.userinfo model=new Maticsoft.Model.userinfo();
DataSet ds=DbHelperOleDb.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.txtuname.Text.Trim().Length==0)
{
strErr+="uname不能为空！\\n";
}
if(this.txtusex.Text.Trim().Length==0)
{
strErr+="usex不能为空！\\n";
}
if(this.txtuage.Text.Trim().Length==0)
{
strErr+="uage不能为空！\\n";
}
if(this.txtuphone.Text.Trim().Length==0)
{
strErr+="uphone不能为空！\\n";
}
if(this.txtuemail.Text.Trim().Length==0)
{
strErr+="uemail不能为空！\\n";
}
if(this.txtwid.Text.Trim().Length==0)
{
strErr+="wid不能为空！\\n";
}
if(this.txtwname.Text.Trim().Length==0)
{
strErr+="wname不能为空！\\n";
}
if(this.txtparameter1.Text.Trim().Length==0)
{
strErr+="parameter1不能为空！\\n";
}
if(this.txtparameter2.Text.Trim().Length==0)
{
strErr+="parameter2不能为空！\\n";
}
if(strErr!="")
{
MessageBox.Show(this,strErr);
return;
}
int ID=int.Parse(this.lblID.Text);
string uname=this.txtuname.Text;
string usex=this.txtusex.Text;
string uage=this.txtuage.Text;
string uphone=this.txtuphone.Text;
string uemail=this.txtuemail.Text;
string wid=this.txtwid.Text;
string wname=this.txtwname.Text;
string parameter1=this.txtparameter1.Text;
string parameter2=this.txtparameter2.Text;
Maticsoft.Model.userinfo model=new Maticsoft.Model.userinfo();
model.ID=ID;
model.uname=uname;
model.usex=usex;
model.uage=uage;
model.uphone=uphone;
model.uemail=uemail;
model.wid=wid;
model.wname=wname;
model.parameter1=parameter1;
model.parameter2=parameter2;
Maticsoft.BLL.userinfo bll=new Maticsoft.BLL.userinfo();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功！","list.aspx");
}
