protected void Page_Load(object sender, EventArgs e)
{
Spread.Model.contant modelContant = new Spread.Model.contant();
//bll.Get_Config(rwc);
string pathurl = Server.MapPath(ConfigurationManager.AppSettings["WebSetpath"].ToString());
webset = bll.loadConfig(pathurl);
}
/// <summary>
/// 查询绑定公司的信息
/// </summary>
/// <param name="model"></param>
public void BindData( )
{
Spread.Model.contant model = new Spread.Model.contant();
model = bll.model();
this.TextName.Text = model.ContName;
this.txtaddres.Text = model.ContAddres;
this.txtImgUrl.Text = model.ContImage;
this.FCKeditor.Value = model.Contcont;
}
public int getid()
{
Spread.Model.contant model = new Spread.Model.contant();
int id;
model = bll.model();
id = model.ID;
return id;
}
protected void btnSave_Click(object sender, EventArgs e)
{
Spread.Model.contant model = new Spread.Model.contant();
//修改公司信息
model.ContName = this.TextName.Text;
model.ContAddres = this.txtaddres.Text;
model.ContImage = this.txtImgUrl.Text;
model.Contcont = FCKeditor.Value;
model.ID = getid ();
bll.update(model);
Response.Write("<script>alert('更新信息成功！！')</script>");
}
/// <summary>
/// 获取公司信息返回实体对象
/// </summary>
public Spread.Model.contant GetModel()
{
Spread.Model.contant model = new Spread.Model.contant();
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,ContName,ContAddres,ContImage,Contcont,Hits from contant ");
SqlParameter[] parameters = {
new SqlParameter ("@ID",SqlDbType.Int),
new SqlParameter("@ContName", SqlDbType.NVarChar,30),
new SqlParameter("@ContAddres", SqlDbType.NVarChar,50),
new SqlParameter("@ContImage", SqlDbType.NVarChar,250),
new SqlParameter("@Contcont", SqlDbType.NVarChar,12500),
new SqlParameter("@Hits", SqlDbType.Int)};
parameters[0].Value = model.ID;
parameters[1].Value = model.ContName;
parameters[2].Value = model.ContAddres;
parameters[3].Value = model.ContImage;
parameters[4].Value = model.Contcont;
parameters[5].Value = model.Hits;
DataSet ds = DbHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.ID = Convert.ToInt32( ds.Tables[0].Rows[0]["ID"].ToString());
model.ContName = ds.Tables[0].Rows[0]["ContName"].ToString();
model.ContAddres = ds.Tables[0].Rows[0]["ContAddres"].ToString();
model.ContImage = ds.Tables[0].Rows[0]["ContImage"].ToString();
model.Contcont = ds.Tables[0].Rows[0]["Contcont"].ToString();
model.Hits = Convert.ToInt32(ds.Tables[0].Rows[0]["Hits"].ToString());
return model;
}
else
{
return null;
}
}
