private void MyInitForUpdate()
{
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from CatMenu order by Orders asc";
conn.Open();
SqlDataReader rd1 = cmd.ExecuteReader();
CatMenuName.DataSource = rd1;
CatMenuName.DataValueField = "ID";
CatMenuName.DataTextField = "CatMenuName";
CatMenuName.DataBind();
rd1.Close();
string sql = "select * from SubMenu order by Orders asc,ID desc;select * from SubMenu where ID = @ID";
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@ID", Convert.ToInt16(Request["ID"]));
SqlDataReader rd = cmd.ExecuteReader();
// string CatID = rd["CatID"].ToString();
rd.NextResult();
if (rd.Read())
{
SubMenuName.Text = rd["SubMenuName"].ToString();
Orders.Text = rd["Orders"].ToString();
Href.Text = rd["Href"].ToString();
string CatMenuID = rd["CatMenuID"].ToString();
if (CatMenuName.Items.FindByValue(CatMenuID) != null)
{
CatMenuName.ClearSelection();
CatMenuName.Items.FindByValue(CatMenuID).Selected = true;
}
}
//读取单选框所选择的信息
int valid = Convert.ToInt32(rd["Valid"]);
if (valid == 1)
{
true1.Checked = true;
}
else
{
false1.Checked = true;
}
rd.Close();
conn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["RoleID"] == null || Session["UserID"] == null)
{
Util.ShowMessage("用户登录超时，请重新登录！", "Login2.aspx");
}
else
{
int RoleID = Convert.ToInt16(Session["RoleID"].ToString());
if (RoleID > 1)
{
Util.ShowMessage("对不起，你无权访问该页面！", "User_Center.aspx");
}
else
{
LabelUserID.Text = Request.QueryString["ID"];
CatMenuName.Focus();
if (!String.IsNullOrEmpty(Request["ID"]))
{
using (SqlConnection conn = new DB().GetConnection())
{
SqlCommand cmd = conn.CreateCommand();
string sql = "select * from CatMenu order by valid desc;select * from CatMenu where ID = @ID";
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@ID", Convert.ToInt16(Request["ID"]));
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
rd.NextResult();
if (rd.Read())
{
CatMenuName.Text = rd["CatMenuName"].ToString();
Href.Text = rd["Href"].ToString();
Orders.Text = rd["Orders"].ToString();
//读取单选框所选择的信息
int valid = Convert.ToInt32(rd["Valid"]);
if (valid == 1)
{
true1.Checked = true;
}
else
{
false1.Checked = true;
}
}
rd.Close();
conn.Close();
}
}
//using (sqlconnection conn = new db().getconnection())
//{
// string sql = "select * from Cats order by ID desc";
// SqlCommand cmd = new SqlCommand(sql, conn);
// conn.Open();
// SqlDataReader rd = cmd.ExecuteReader();
// cmd.Parameters.AddWithValue("@ID", Label1.Text);
// rd = cmd.ExecuteReader();
// if (rd.Read())
// {
// int valid = Convert.ToInt32(rd["Valid"]);
// if (valid == 1)
// {
// true1.Checked = true;
// }
// else
// {
// false1.Checked = true;
// }
}
}
}
}
