//获得所有用户表
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;
}
