protected void init() { string sql = "select * from role_info where state='启用' order by paixu"; DataSet ds = DB.ExecuteSqlDataSet(sql, null); SystemTool.bindDropDownList_0(ddljiaose, ds.Tables[0], "id", "roleName", "--请选择--"); }
private void BindData() { string sql = "select * from jihualeixing"; DataSet ds = DB.ExecuteSqlDataSet(sql, null); SystemTool.bindDropDownList_0(ddl_jihualeixing, ds.Tables[0], "mingcheng", "mingcheng", ""); sql = "select * from dianshangpingtai"; ds = DB.ExecuteSqlDataSet(sql, null); SystemTool.bindDropDownList_0(ddl_dianshangpingtai, ds.Tables[0], "mingcheng", "mingcheng", ""); sql = "select * from fukuanfangshi"; ds = DB.ExecuteSqlDataSet(sql, null); SystemTool.bindDropDownList_0(ddl_fukuanfangshi, ds.Tables[0], "mingcheng", "mingcheng", ""); sql = "select * from jiaohuodidian"; ds = DB.ExecuteSqlDataSet(sql, null); SystemTool.bindDropDownList_0(ddl_jiaohuodidian, ds.Tables[0], "mingcheng", "mingcheng", ""); sql = "select * from wuzishuxing"; ds = DB.ExecuteSqlDataSet(sql, null); SystemTool.bindDropDownList_0(ddl_wuzishuxing, ds.Tables[0], "mingcheng", "mingcheng", ""); sql = "select * from zijinlaiyuan"; ds = DB.ExecuteSqlDataSet(sql, null); SystemTool.bindDropDownList_0(ddl_zijinlaiyuan, ds.Tables[0], "mingcheng", "mingcheng", ""); }