protected void btnUpdate_Click(object sender, EventArgs e)
{
SolutionCategoryBll scbll = new SolutionCategoryBll();
int scenceId = int.Parse(lblSenceId.Text);
int cateId = int.Parse(lblCateId.Text);
SolutionCategoryModel scmodel = scbll.GetModel(scenceId, cateId);
if (scmodel == null)
{
scmodel = new SolutionCategoryModel();
scmodel.CateId = cateId;
scmodel.SenceId = scenceId;
}
scmodel.IsShow = chkIsShow.Checked;
scmodel.Remark = txtRemark.Text.Trim();
scmodel.Position = txtPosition.Text.Trim();
string fullurl, shorturl, message;
if (CommonImageUpload.Upload(this.fulImage, out fullurl, out shorturl, out message))
{
scmodel.CateImage = shorturl;
}
scbll.Save(scmodel);
SaveCateConditions();
Response.Redirect("ShowClassicalScence.aspx?id=" + scenceId,true);
}
/// <summary>
/// ����ʵ�������
/// </summary>
public SolutionCategoryModel ReaderBind(IDataReader dataReader)
{
SolutionCategoryModel model=new SolutionCategoryModel();
object ojb;
ojb = dataReader["SenceId"];
if(ojb != null && ojb != DBNull.Value)
{
model.SenceId=(int)ojb;
}
ojb = dataReader["CateId"];
if(ojb != null && ojb != DBNull.Value)
{
model.CateId=(int)ojb;
}
model.CateImage= dataReader["CateImage"].ToString();
model.Remark=dataReader["Remark"].ToString();
model.Position=dataReader["Position"].ToString();
model.CateName = dataReader["catename"].ToString();
ojb = dataReader["IsShow"];
if(ojb != null && ojb != DBNull.Value)
{
model.IsShow=(bool)ojb;
}
return model;
}
/// <summary>
/// ����һ������
/// </summary>
public void Save(SolutionCategoryModel model)
{
DbCommand dbCommand = dbw.GetStoredProcCommand("UP_slCategory_Save");
dbw.AddInParameter(dbCommand, "SenceId", DbType.Int32, model.SenceId);
dbw.AddInParameter(dbCommand, "CateId", DbType.Int32, model.CateId);
dbw.AddInParameter(dbCommand, "CateImage", DbType.AnsiString, model.CateImage);
dbw.AddInParameter(dbCommand, "Remark", DbType.AnsiString, model.Remark);
dbw.AddInParameter(dbCommand, "Position", DbType.AnsiString, model.Position);
dbw.AddInParameter(dbCommand, "IsShow", DbType.Boolean, model.IsShow);
dbw.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// ����һ������
/// </summary>
public void Save(SolutionCategoryModel model)
{
dal.Save(model);
}