protected void Page_Load(object sender, EventArgs e) { if (Tools.CookieHelper.GetCookie("CN_ID") == "" || Tools.CookieHelper.GetCookie("CN_ID") == null) { Response.Redirect("../../login.aspx"); } if (!IsPostBack) { string id = Request.QueryString["id"].ToString(); manager = Manager.GetModel(Convert.ToInt32(id)); username.Value = manager.UserName; phonenum.Value = manager.phonenum; //works.Value = manager.works; states.Value = manager.states; reper.Value = manager.repair; selerol(); if (manager.isAdmin == 1) { admin.Checked = true; } else { admin.Checked = false; } //string[] re = manager.repair.Split(','); //for (int i = 0; i < re.Length; i++) //{ // int j = Convert.ToInt32(re[i]); // URole.Items[1].Selected=true; //} } }
public EPReper.Model.Manager GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,username,isAdmin,repair,phonenum,works,states from Manager "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4) }; parameters[0].Value = id; EPReper.Model.Manager model = new EPReper.Model.Manager(); DataSet ds = DbHelper.ExecuteDataSet(CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = ds.Tables[0].Rows[0]["id"].ToString(); } if (ds.Tables[0].Rows[0]["username"] != null && ds.Tables[0].Rows[0]["username"].ToString() != "") { model.UserName = ds.Tables[0].Rows[0]["username"].ToString(); } if (ds.Tables[0].Rows[0]["isAdmin"] != null && ds.Tables[0].Rows[0]["isAdmin"].ToString() != "") { model.isAdmin = Convert.ToInt32(ds.Tables[0].Rows[0]["isAdmin"].ToString()); } if (ds.Tables[0].Rows[0]["repair"] != null && ds.Tables[0].Rows[0]["repair"].ToString() != "") { model.repair = ds.Tables[0].Rows[0]["repair"].ToString(); } if (ds.Tables[0].Rows[0]["phonenum"] != null && ds.Tables[0].Rows[0]["phonenum"].ToString() != "") { model.phonenum = ds.Tables[0].Rows[0]["phonenum"].ToString(); } if (ds.Tables[0].Rows[0]["works"] != null && ds.Tables[0].Rows[0]["works"].ToString() != "") { model.works = ds.Tables[0].Rows[0]["works"].ToString(); } if (ds.Tables[0].Rows[0]["states"] != null && ds.Tables[0].Rows[0]["states"].ToString() != "") { model.states = ds.Tables[0].Rows[0]["states"].ToString(); } return model; } else { return null; } }