//获得所有用户表 public static IList<userlogModel> GetInfoList() { List<userlogModel> modellist = new List<userlogModel>(); try { string sqlstring = "select * from userlog"; SqlDataReader datareader = CommonDB.ExecuteReader(CommonDB.CONN_STRING, CommandType.Text, sqlstring, null); while (datareader.Read()) { userlogModel model; int acconttype = -1; int.TryParse(datareader["UserAccontType"].ToString(), out acconttype); if (datareader["picture"] == null) { byte[] imagebt = (byte[]) datareader["picture"]; MemoryStream imagems = new MemoryStream(imagebt); model = new userlogModel(datareader["AccontName"].ToString(), datareader["AccontName"].ToString(), datareader["UserPassword"].ToString(), acconttype , datareader["TelNumber"].ToString(), datareader["College"].ToString(), datareader["Address"].ToString(), datareader["Profession"].ToString() , datareader["Name"].ToString(), imagems); } else { model = new userlogModel(datareader["AccontName"].ToString(), datareader["AccontName"].ToString(), datareader["UserPassword"].ToString(), acconttype , datareader["TelNumber"].ToString(), datareader["College"].ToString(), datareader["Address"].ToString(), datareader["Profession"].ToString() , datareader["Name"].ToString(), null); } modellist.Add(model); } } catch (Exception ex) { Console.WriteLine("AdminloanLogic GetModelList error!"); } return modellist; }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserName"] == null) { return; } userinfomodel = ReaderInfoOP.GetInfo(Session["UserName"].ToString().Trim()); if (userinfomodel.Imagefs != null) { System.Drawing.Image img = System.Drawing.Image.FromStream(userinfomodel.Imagefs); img.Save("images\\touxiang.bmp"); Image4.ImageUrl = "images\\touxiang.bmp"; } else { Image4.ImageUrl = "images\\morentouxiang.png"; pic.ImageUrl = "images\\morentouxiang.png"; } Label8.Text = userinfomodel.Name; Label9.Text = userinfomodel.AccontName; Label10.Text = userinfomodel.UserPassword; Label11.Text = userinfomodel.College; }