public static YF.Mode.Doctor getDoctor(int id)//得到一个对象
{
YF.Mode.Doctor user = new Mode.Doctor();
string strsql = "select * from _doctor where docnum='" + id + "'";
DataTable dataTable = YF.MsSqlHelper.YFMsSqlHelper.Query(strsql).Tables[0];
if (dataTable.Rows.Count != 0)
{
user.Id = int.Parse(dataTable.Rows[0]["docnum"].ToString());
user.Name = dataTable.Rows[0]["docname"].ToString();
user.Age = dataTable.Rows[0]["age"].ToString();
user.Job = dataTable.Rows[0]["job"].ToString();
user.Room = dataTable.Rows[0]["room"].ToString();
}
return(user);
}
public static List <YF.Mode.Doctor> DttolistD(DataTable dt)//把对象构建成一个list
{
List <YF.Mode.Doctor> list = new List <Mode.Doctor>();
for (int i = 0; i < dt.Rows.Count; i++)
{
YF.Mode.Doctor user = new Mode.Doctor();
user.Id = int.Parse(dt.Rows[i]["docnum"].ToString());
user.Name = dt.Rows[i]["docname"].ToString();
user.Age = dt.Rows[i]["age"].ToString();
user.Job = dt.Rows[i]["job"].ToString();
user.Room = dt.Rows[i]["room"].ToString();
list.Add(user);
}
return(list);
}
