public Tuan_dv_TauThuyenModel GetTauThuyenById(string ma)
{
DataTable dt = Tuan_dv_DataAccess.ExecQuery("Select * from tauthuyen where ma='" + ma + "'").Tables[0];
Tuan_dv_TauThuyenModel sv = new Tuan_dv_TauThuyenModel();
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
sv.ma = dr[0].ToString();
sv.tentau = dr[1].ToString();
sv.MMSI = dr[2].ToString();
sv.maloaitau = dr[3].ToString();
sv.taitrong = dr[4].ToString() == "" ? -1 : int.Parse(dr[4].ToString());
sv.maquocgia = dr[5].ToString();
sv.image = dr[6].ToString();
}
return(sv);
}
public DataSet layDanhSachQuocGia()
{
return(Tuan_dv_DataAccess.ExecQuery("select * from quocgia"));
}
public DataSet layDanhSachLoaiTau()
{
return(Tuan_dv_DataAccess.ExecQuery("select ma,tenloaitau from loaitau"));
}
public DataSet layDanhSachTau()
{
return(Tuan_dv_DataAccess.ExecQuery("select t.ma as MaTau,tentau as TenTau,l.tenloaitau as LoaiTau,q.tenquocgia from tauthuyen t left join loaitau l on t.maloaitau = l.ma left join quocgia q on t.maquocgia = q.ma"));
}