/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(myhouse.Model.Worker model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_worker set ");
strSql.Append("wname=@wname,");
strSql.Append("wsex=@wsex,");
strSql.Append("wphoto=@wphoto,");
strSql.Append("wpassword=@wpassword,");
strSql.Append("wtel=@wtel,");
strSql.Append("wemail=@wemail,");
strSql.Append("wadress=@wadress,");
strSql.Append("wtype=@wtype");
strSql.Append(" where wid=@wid");
SqlParameter[] parameters =
{
new SqlParameter("@wname", SqlDbType.Char, 12),
new SqlParameter("@wsex", SqlDbType.Char, 4),
new SqlParameter("@wphoto", SqlDbType.VarChar, 100),
new SqlParameter("@wpassword", SqlDbType.VarChar, 50),
new SqlParameter("@wtel", SqlDbType.Char, 13),
new SqlParameter("@wemail", SqlDbType.VarChar, 30),
new SqlParameter("@wadress", SqlDbType.VarChar, 50),
new SqlParameter("@wtype", SqlDbType.Char, 4),
new SqlParameter("@wid", SqlDbType.Int, 4),
new SqlParameter("@wcard", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.wname;
parameters[1].Value = model.wsex;
parameters[2].Value = model.wphoto;
parameters[3].Value = model.wpassword;
parameters[4].Value = model.wtel;
parameters[5].Value = model.wemail;
parameters[6].Value = model.wadress;
parameters[7].Value = model.wtype;
parameters[8].Value = model.wid;
parameters[9].Value = model.wcard;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void ShowInfo(int wid)
{
myhouse.BLL.WorkerService bll = new myhouse.BLL.WorkerService();
myhouse.Model.Worker model = bll.GetModel(wid);
this.lblwid.Text = model.wid.ToString();
this.txtwname.Text = model.wname;
this.txtwsex.Text = model.wsex;
this.txtwphoto.Text = model.wphoto;
this.lblwcard.Text = model.wcard;
this.txtwpassword.Text = model.wpassword;
this.txtwtel.Text = model.wtel;
this.txtwemail.Text = model.wemail;
this.txtwadress.Text = model.wadress;
this.txtwtype.Text = model.wtype;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public myhouse.Model.Worker DataRowToModel(DataRow row)
{
myhouse.Model.Worker model = new myhouse.Model.Worker();
if (row != null)
{
if (row["wid"] != null && row["wid"].ToString() != "")
{
model.wid = int.Parse(row["wid"].ToString());
}
if (row["wname"] != null)
{
model.wname = row["wname"].ToString();
}
if (row["wsex"] != null)
{
model.wsex = row["wsex"].ToString();
}
if (row["wphoto"] != null)
{
model.wphoto = row["wphoto"].ToString();
}
if (row["wcard"] != null)
{
model.wcard = row["wcard"].ToString();
}
if (row["wpassword"] != null)
{
model.wpassword = row["wpassword"].ToString();
}
if (row["wtel"] != null)
{
model.wtel = row["wtel"].ToString();
}
if (row["wemail"] != null)
{
model.wemail = row["wemail"].ToString();
}
if (row["wadress"] != null)
{
model.wadress = row["wadress"].ToString();
}
if (row["wtype"] != null)
{
model.wtype = row["wtype"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(myhouse.Model.Worker model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_worker(");
strSql.Append("wname,wsex,wphoto,wcard,wpassword,wtel,wemail,wadress,wtype)");
strSql.Append(" values (");
strSql.Append("@wname,@wsex,@wphoto,@wcard,@wpassword,@wtel,@wemail,@wadress,@wtype)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@wname", SqlDbType.Char, 12),
new SqlParameter("@wsex", SqlDbType.Char, 4),
new SqlParameter("@wphoto", SqlDbType.VarChar, 100),
new SqlParameter("@wcard", SqlDbType.VarChar, 20),
new SqlParameter("@wpassword", SqlDbType.VarChar, 50),
new SqlParameter("@wtel", SqlDbType.Char, 13),
new SqlParameter("@wemail", SqlDbType.VarChar, 30),
new SqlParameter("@wadress", SqlDbType.VarChar, 50),
new SqlParameter("@wtype", SqlDbType.Char, 4)
};
parameters[0].Value = model.wname;
parameters[1].Value = model.wsex;
parameters[2].Value = model.wphoto;
parameters[3].Value = model.wcard;
parameters[4].Value = model.wpassword;
parameters[5].Value = model.wtel;
parameters[6].Value = model.wemail;
parameters[7].Value = model.wadress;
parameters[8].Value = model.wtype;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public myhouse.Model.Worker GetModel(int wid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 wid,wname,wsex,wphoto,wcard,wpassword,wtel,wemail,wadress,wtype from t_worker ");
strSql.Append(" where wid=@wid");
SqlParameter[] parameters =
{
new SqlParameter("@wid", SqlDbType.Int, 4)
};
parameters[0].Value = wid;
myhouse.Model.Worker model = new myhouse.Model.Worker();
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.txtwname.Text.Trim().Length == 0)
{
strErr += "wname不能为空！\\n";
}
if (this.txtwsex.Text.Trim().Length == 0)
{
strErr += "wsex不能为空！\\n";
}
if (this.txtwphoto.Text.Trim().Length == 0)
{
strErr += "wphoto不能为空！\\n";
}
if (this.txtwcard.Text.Trim().Length == 0)
{
strErr += "wcard不能为空！\\n";
}
if (this.txtwpassword.Text.Trim().Length == 0)
{
strErr += "wpassword不能为空！\\n";
}
if (this.txtwtel.Text.Trim().Length == 0)
{
strErr += "wtel不能为空！\\n";
}
if (this.txtwemail.Text.Trim().Length == 0)
{
strErr += "wemail不能为空！\\n";
}
if (this.txtwadress.Text.Trim().Length == 0)
{
strErr += "wadress不能为空！\\n";
}
if (this.txtwtype.Text.Trim().Length == 0)
{
strErr += "wtype不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string wname = this.txtwname.Text;
string wsex = this.txtwsex.Text;
string wphoto = this.txtwphoto.Text;
string wcard = this.txtwcard.Text;
string wpassword = this.txtwpassword.Text;
string wtel = this.txtwtel.Text;
string wemail = this.txtwemail.Text;
string wadress = this.txtwadress.Text;
string wtype = this.txtwtype.Text;
myhouse.Model.Worker model = new myhouse.Model.Worker();
model.wname = wname;
model.wsex = wsex;
model.wphoto = wphoto;
model.wcard = wcard;
model.wpassword = wpassword;
model.wtel = wtel;
model.wemail = wemail;
model.wadress = wadress;
model.wtype = wtype;
myhouse.BLL.WorkerService bll = new myhouse.BLL.WorkerService();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
