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); }