public SchoolFellow getOne(int id) { string sql = "select top 10 RealName,Sex,HeadPicture,Birthday,Email,QQ,Handset,Address,WorkPlace,SpecialityName,Graduation,ClassName from T_User " + "where UserID=@id"; SqlParameter p = new SqlParameter("@id", id); DataTable dt = DbHelperSQL.Query(sql, p).Tables[0]; Console.WriteLine(dt.Rows[0][1]); if (dt != null) { DataRow row = dt.Rows[0]; SchoolFellow schoolFellow = new SchoolFellow( id, row["RealName"].ToString(), row["Sex"].ToString(), row["SpecialityName"].ToString(), row["ClassName"].ToString(), row["HeadPicture"].ToString(), row["Graduation"].ToString(), row["WorkPlace"].ToString(), row["Address"].ToString(), row["Handset"].ToString(), row["Email"].ToString(), row["Birthday"].ToString(), row["QQ"].ToString()); Console.WriteLine(schoolFellow.ToString()); Console.WriteLine("------" + DateTime.Now.ToString() + "-------"); Console.WriteLine(sql); Console.WriteLine(schoolFellow.ToString()); return(schoolFellow); } return(null); }
public List <SchoolFellow> getSchoolFellowsList(Stream data) { StreamReader reader = new StreamReader(data, Encoding.UTF8); string json = reader.ReadToEnd(); Console.WriteLine(json); JavaScriptSerializer js = new JavaScriptSerializer(); SchoolFellow list = js.Deserialize <SchoolFellow>(json); Console.WriteLine(list.ToString()); List <SchoolFellow> jsonbackLists = new getList().GetList(list); Console.WriteLine("------" + DateTime.Now.ToString() + "-------"); foreach (SchoolFellow stu in jsonbackLists) { Console.WriteLine(stu.RealName + "---" + stu.Address + "---" + stu.Sex + "---" + stu.SpecialityName); } return(jsonbackLists); }