多表联立查询左连接查询
public static List<Model.TDoctor> GetAllDoctor(string Dpmtid)
{
string sql = “select t2.Dpmtid,t2.Dpmtname,t1.Did,t1.Dname,t1.Dremark,t1.Dsex,t1.Dsprice,t1.Dtel,t1.DType from TDoctor t1 left join TDepartment t2 on t1.Dpmtid=t2.Dpmtid where t2.Dpmtid=@Dpmtid”;
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@Dpmtid",Dpmtid),
};
SqlDataReader reader = DBHelper.ExecuteReader(sql,System.Data.CommandType.Text,paras);
List<Model.TDoctor> lst = new List<Model.TDoctor>();
while (reader.Read())
{
Model.TDoctor dd = new Model.TDoctor
{
Did = Convert.ToInt32(reader[“Did”]),
Dname = reader[“Dname”].ToString(),
Dpmtid = Convert.ToInt32(reader[“Dpmtid”]),
Dsex = Convert.ToInt32(reader[“Dsex”]),
Dtel = reader[“Dtel”].ToString(),
Dpmtname = reader[“Dpmtname”].ToString(),
Dremark = reader[“Dremark”].ToString(),
Dsprice=reader[“Dsprice”].ToString(),
DType=Convert.ToInt32(reader[“DType”]),
};
lst.Add(dd);
}
return lst;
}