public static TuyenBay GetTuyenBay(int maSBDi, int maSBDen) { string cmdText = String.Format("select * from TUYENBAY Where MaSBDi={0} and MaSBDen = {1}", maSBDi, maSBDen); DataTable dt = DataProvider.ExecuteReader(cmdText); if (dt != null && dt.Rows.Count > 0) { TuyenBay tb = new TuyenBay((int)dt.Rows[0]["MaTB"], DAL_SanBay.GetSanBay((int)dt.Rows[0]["MaSBDi"]), DAL_SanBay.GetSanBay((int)dt.Rows[0]["MaSBDen"])); return(tb); } return(null); }
public static List <CTCB> GetCTCBs(int maCB) { string cmdText = String.Format("select * from CTCB where MaCB = {0}", maCB); DataTable dt = DataProvider.ExecuteReader(cmdText); if (dt != null && dt.Rows.Count > 0) { List <CTCB> cTCB = new List <CTCB>(); for (int i = 0; i < dt.Rows.Count; i++) { CTCB ctcb = new CTCB((int)dt.Rows[i]["MaCB"], DAL_SanBay.GetSanBay((int)dt.Rows[i]["MaSBTG"]), (int)dt.Rows[i]["TGDung"], dt.Rows[i]["GhiChu"].ToString()); cTCB.Add(ctcb); } return(cTCB); } return(null); }
public static List <TuyenBay> SearchMaTB(string maTB) { string cmdText = String.Format("select * from TUYENBAY where MaTB like '%{0}%'", maTB == "" ? maTB : DataProvider.ConvertToInt(maTB)); DataTable dt = DataProvider.ExecuteReader(cmdText); if (dt != null && dt.Rows.Count > 0) { List <TuyenBay> TuyenBay = new List <TuyenBay>(); for (int i = 0; i < dt.Rows.Count; i++) { TuyenBay tb = new TuyenBay((int)dt.Rows[i]["MaTB"], DAL_SanBay.GetSanBay((int)dt.Rows[i]["MaSBDi"]), DAL_SanBay.GetSanBay((int)dt.Rows[i]["MaSBDen"])); TuyenBay.Add(tb); } return(TuyenBay); } return(null); }
public static List <TuyenBay> GetTuyenBays() { string cmdText = @"select * from TuyenBay"; DataTable dt = DataProvider.ExecuteReader(cmdText); if (dt != null && dt.Rows.Count > 0) { List <TuyenBay> TuyenBay = new List <TuyenBay>(); for (int i = 0; i < dt.Rows.Count; i++) { TuyenBay tb = new TuyenBay((int)dt.Rows[i]["MaTB"], DAL_SanBay.GetSanBay((int)dt.Rows[i]["MaSBDi"]), DAL_SanBay.GetSanBay((int)dt.Rows[i]["MaSBDen"])); TuyenBay.Add(tb); } return(TuyenBay); } return(null); }
public static List <TuyenBay> SearchTenSBDen(string tenSBDen) { string cmdText = String.Format("select * from TUYENBAY inner join SANBAY on MASBDEN = MASB where TENSB like N'%{0}%'", tenSBDen); DataTable dt = DataProvider.ExecuteReader(cmdText); if (dt != null && dt.Rows.Count > 0) { List <TuyenBay> TuyenBay = new List <TuyenBay>(); for (int i = 0; i < dt.Rows.Count; i++) { TuyenBay tb = new TuyenBay((int)dt.Rows[i]["MaTB"], DAL_SanBay.GetSanBay((int)dt.Rows[i]["MaSBDi"]), DAL_SanBay.GetSanBay((int)dt.Rows[i]["MaSBDen"])); TuyenBay.Add(tb); } return(TuyenBay); } return(null); }