protected void bindSpeSub()
{
int sub_id = Convert.ToInt32(ViewState["sub_id"].ToString());
spe_sub_model = spe_sub_bll.GetListById(sub_id);
ddl_item.Items.FindByValue(spe_sub_model.Special_id.ToString()).Selected = true;
txtTitle.Text = spe_sub_model.Sub_title;
txtPaixu.Text = spe_sub_model.Sub_paixu.ToString();
}
/// <summary>
/// 添加子栏目
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddSpeSub(YouthSpecialSub model)
{
int rows = dal.AddSpeSub(model);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加子栏目
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddSpeSub(YouthSpecialSub model)
{
StringBuilder str = new StringBuilder();
str.Append(" insert into special_sub ");
str.Append("(special_id,sub_title,sub_paixu)");
str.Append("values ");
str.Append("(@special_id,@sub_title,@sub_paixu)");
SqlParameter[] parameters =
{
new SqlParameter("@special_id", SqlDbType.Int, 8),
new SqlParameter("@sub_title", SqlDbType.NVarChar, 50),
new SqlParameter("@sub_paixu", SqlDbType.Int, 8)
};
parameters[0].Value = model.Special_id;
parameters[1].Value = model.Sub_title;
parameters[2].Value = model.Sub_paixu;
int rows = DbHelperSQL.ExecuteSql(str.ToString(), parameters);
return(rows);
}
/// <summary>
/// 编辑更新子栏目
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdSpeSub(YouthSpecialSub model)
{
StringBuilder str = new StringBuilder();
str.Append(" update special_sub set ");
str.Append(" special_id=@special_id,");
str.Append(" sub_title=@sub_title,");
str.Append(" sub_paixu=@sub_paixu ");
str.Append(" where sub_id=@sub_id ");
SqlParameter[] parameters =
{
new SqlParameter("@special_id", SqlDbType.Int, 8),
new SqlParameter("@sub_title", SqlDbType.NVarChar, 50),
new SqlParameter("@sub_paixu", SqlDbType.Int, 8),
new SqlParameter("@sub_id", SqlDbType.Int, 8)
};
parameters[0].Value = model.Special_id;
parameters[1].Value = model.Sub_title;
parameters[2].Value = model.Sub_paixu;
parameters[3].Value = model.Sub_id;
int rows = DbHelperSQL.ExecuteSql(str.ToString(), parameters);
return(rows);
}
