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> GetList(SchoolFellow schoolFellow)
{
List <SqlParameter> pms = new List <SqlParameter>();
List <string> sqls = new List <string>();
string sql = "select top 10 UserID, RealName,Sex,HeadPicture,Birthday,Email,QQ,Handset,Address,CollegeName,SpecialityName,Graduation,ClassName from T_User";
if (!string.IsNullOrEmpty(schoolFellow.RealName))
{
pms.Add(new SqlParameter("@RealName", schoolFellow.RealName));
sqls.Add("RealName like " + "'%" + schoolFellow.RealName + "%'");
}
if (!string.IsNullOrEmpty(schoolFellow.SpecialityName))
{
pms.Add(new SqlParameter("@SpecialityName", schoolFellow.SpecialityName));
sqls.Add("SpecialityName like " + "'%" + schoolFellow.SpecialityName + "%'");
}
if (!string.IsNullOrEmpty(schoolFellow.ClassName))
{
pms.Add(new SqlParameter("@ClassName", schoolFellow.ClassName));
sqls.Add("ClassName like " + "'%" + schoolFellow.ClassName + "%'");
}
if (!string.IsNullOrEmpty(schoolFellow.Graduation))
{
pms.Add(new SqlParameter("@Graduation", schoolFellow.Graduation));
sqls.Add("Graduation like " + "'%" + schoolFellow.Graduation + "%'");
}
if (!string.IsNullOrEmpty(schoolFellow.WorkPlace))
{
pms.Add(new SqlParameter("@WorkPlace", schoolFellow.WorkPlace));
sqls.Add("WorkPlace like " + "'%" + schoolFellow.WorkPlace + "%'");
}
if (!string.IsNullOrEmpty(schoolFellow.Address))
{
pms.Add(new SqlParameter("@Address", schoolFellow.Address));
sqls.Add("Address like " + "'%" + schoolFellow.Address + "%'");
}
if (sqls.Count > 0)
{
sql += " where " + string.Join(" and ", sqls.ToArray());
}
Console.WriteLine(sql);
DataTable data = DbHelperSQL.Query(sql, pms.ToArray()).Tables[0];
List <SchoolFellow> list = (List <SchoolFellow>) ModelConvertHelper <SchoolFellow> .ConvertToModel(data);
return(list);
}
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);
}
