/// <summary>
/// 更新一条数据
/// </summary>
public int Update(tbWebSet model)
{
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4),
new SqlParameter("@WebName", SqlDbType.NVarChar,100),
new SqlParameter("@WebUrl", SqlDbType.NVarChar,100),
new SqlParameter("@WebTel", SqlDbType.NVarChar,100),
new SqlParameter("@WebFax", SqlDbType.NVarChar,100),
new SqlParameter("@WebEmail", SqlDbType.NVarChar,50),
new SqlParameter("@WebCrod", SqlDbType.NVarChar,50),
new SqlParameter("@WebCopyright", SqlDbType.NVarChar,50),
new SqlParameter("@WebKeywords", SqlDbType.NVarChar,100),
new SqlParameter("@WebDescription", SqlDbType.NVarChar,300)};
parameters[0].Value = model.ID;
parameters[1].Value = model.WebName;
parameters[2].Value = model.WebUrl;
parameters[3].Value = model.WebTel;
parameters[4].Value = model.WebFax;
parameters[5].Value = model.WebEmail;
parameters[6].Value = model.WebCrod;
parameters[7].Value = model.WebCopyright;
parameters[8].Value = model.WebKeywords;
parameters[9].Value = model.WebDescription;
return dbhelper.ExcuteCommandReturnInt("tbWebSet_Update", CommandType.StoredProcedure, parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public tbWebSet GetModel(int ID)
{
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4)
};
parameters[0].Value = ID;
tbWebSet model = new tbWebSet();
DataSet ds = dbhelper.ExcuteSelectReturnDataSet("getModel_tbWebSet", CommandType.StoredProcedure, parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
model.WebName = ds.Tables[0].Rows[0]["WebName"].ToString();
model.WebUrl = ds.Tables[0].Rows[0]["WebUrl"].ToString();
model.WebTel = ds.Tables[0].Rows[0]["WebTel"].ToString();
model.WebFax = ds.Tables[0].Rows[0]["WebFax"].ToString();
model.WebEmail = ds.Tables[0].Rows[0]["WebEmail"].ToString();
model.WebCrod = ds.Tables[0].Rows[0]["WebCrod"].ToString();
model.WebCopyright = ds.Tables[0].Rows[0]["WebCopyright"].ToString();
model.WebKeywords = ds.Tables[0].Rows[0]["WebKeywords"].ToString();
model.WebDescription = ds.Tables[0].Rows[0]["WebDescription"].ToString();
return model;
}
else
{
return null;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
tbWebSet webset = new tbWebSet();
webset = wsbll.GetModel(1);
txtWebName.Text = webset.WebName;
txtWebUrl.Text = webset.WebUrl;
txtWebTel.Text = webset.WebTel;
txtWebCrod.Text = webset.WebCrod;
txtWebDescription.Text = webset.WebDescription;
txtWebKeywords.Text = webset.WebKeywords;
txtWebFax.Text = webset.WebFax;
txtWebEmail.Text = webset.WebEmail;
txtWebCopyright.Text = webset.WebCopyright;
}
}
protected void btn_Click(object sender, EventArgs e)
{
tbWebSet w = new tbWebSet()
{
ID = 1,
WebCopyright = txtWebCopyright.Text,
WebCrod = txtWebCrod.Text,
WebDescription = txtWebDescription.Text,
WebEmail = txtWebEmail.Text,
WebFax = txtWebFax.Text,
WebKeywords = txtWebKeywords.Text,
WebName = txtWebName.Text,
WebTel = txtWebTel.Text,
WebUrl = txtWebUrl.Text
};
if (wsbll.Update(w) != 0)
{
Response.Redirect("WebSetDetail.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
webset= wsbll.GetModel(1);
}
