/// <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(); } }