/// <summary>
/// 查找class_ID等于传入值的分类记录,返回一个M_IP_class实例
/// </summary>
/// <param name="class_ID"></param>
/// <returns></returns>
public M_IP_class searchClass(int class_ID)
{
M_IP_class m_ip_class = new M_IP_class();
DataTable dt = search_Class("*", " where class_ID=" + class_ID);
if (dt.Rows.Count > 0)
{
m_ip_class.class_ID = Convert.ToInt32(dt.Rows[0][0].ToString());
m_ip_class.class_name = dt.Rows[0][2].ToString();
m_ip_class.leadto_ID = Convert.ToInt32(dt.Rows[0][1].ToString());
}
return(m_ip_class);
}
public void updateClass(int class_ID, int leadto_ID, string class_name)
{
M_IP_class m_IP_class = new M_IP_class();
m_IP_class.class_ID = class_ID;
m_IP_class.class_name = class_name;
m_IP_class.leadto_ID = leadto_ID;
string sqlstr = "update ZL_IPclass set leadto_ID=@leadto_ID,class_name=@class_name where class_ID=@class_ID";
SqlParameter[] Parameters = new SqlParameter[] {
new SqlParameter("@leadto_ID", SqlDbType.Int),
new SqlParameter("@class_name", SqlDbType.NVarChar),
new SqlParameter("@class_ID", SqlDbType.Int)
};
Parameters[0].Value = m_IP_class.leadto_ID;
Parameters[1].Value = m_IP_class.class_name;
Parameters[2].Value = m_IP_class.class_ID;
SqlHelper.ExistsSql(sqlstr, Parameters);
}
protected void Page_Load(object sender, EventArgs e)
{
ZoomLa.Common.function.AccessRulo();
B_Admin badmin = new B_Admin();
if (!IsPostBack)
{
DataTable datatable = b_IPOperation.searchAllClass();
leadto_ID.DataSource = datatable;
leadto_ID.DataBind();
leadto_ID.Items.Insert(0, new ListItem("最高分类", "0"));
M_IP_class m_ip_class = new M_IP_class();
if (Request.QueryString["class_ID"] != null)
{
int n_class_ID = Convert.ToInt32(Request.QueryString["class_ID"].ToString());
m_ip_class = b_IPOperation.searchClass(n_class_ID);
}
class_ID.Text = m_ip_class.class_ID.ToString();
class_name.Text = m_ip_class.class_name;
leadto_ID.SelectedValue = m_ip_class.leadto_ID.ToString();
}
}
