コード例 #1
0
ファイル: usermod.aspx.cs プロジェクト: huaminglee/Code
        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;
                //}

            }
        }
コード例 #2
0
ファイル: Manager.cs プロジェクト: huaminglee/Code
        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;
            }
        }