public static double LayGiaTheoMaThucDon(int maTD) { double gia; string sql = string.Format("select Gia from Gia where MaThucDon = {0}", maTD); DataTable dt = new DataTable(); dt = SqlDataAccessHelper.ExecuteQuery(sql); if (dt.Rows.Count > 0) { gia = double.Parse(dt.Rows[0]["Gia"].ToString()); } else { gia = 0; } return(gia); }
public static List <ThucDonDTO> LayDSThucDonTheoMaLoai(int maLoai) { List <ThucDonDTO> _ds = new List <ThucDonDTO>(); string sql = "select * from ThucDon where MaLoai = " + maLoai; DataTable dt = SqlDataAccessHelper.ExecuteQuery(sql); for (int i = 0; i < dt.Rows.Count; i++) { ThucDonDTO td = new ThucDonDTO(); td.MaTD = int.Parse(dt.Rows[i]["MaThucDon"].ToString()); td.MaLoai = int.Parse(dt.Rows[i]["MaLoai"].ToString()); td.TenTD = dt.Rows[i]["TenThucDon"].ToString(); td.DonViTinh = dt.Rows[i]["DonViTinh"].ToString(); _ds.Add(td); } return(_ds); }
//Rút trích dữ liêu: select public static List <ChiTietGoiMonDTO> LayDSCTGMTuMaGoiMon(int maGoiMon) { List <ChiTietGoiMonDTO> _ds = new List <ChiTietGoiMonDTO>(); string sql = "select * from ChiTietGoiMon where MaGoiMon = " + maGoiMon; DataTable dt = SqlDataAccessHelper.ExecuteQuery(sql); for (int i = 0; i < dt.Rows.Count; i++) { ChiTietGoiMonDTO ctgm = new ChiTietGoiMonDTO(); ctgm.MaCTGoiMon = int.Parse(dt.Rows[i]["MaCTGoiMon"].ToString()); ctgm.MaGoiMon = int.Parse(dt.Rows[i]["MaGoiMon"].ToString()); ctgm.MaTD = int.Parse(dt.Rows[i]["MaThucDon"].ToString()); ctgm.DonGia = double.Parse(dt.Rows[i]["DonGia"].ToString()); ctgm.SoLuong = int.Parse(dt.Rows[i]["SoLuong"].ToString()); _ds.Add(ctgm); } return(_ds); }
//Rút trích dữ liêu: select public static List <NguoiDungDTO> LayDSNguoiDung() { List <NguoiDungDTO> _ds = new List <NguoiDungDTO>(); string sql = "select * from NguoiDung"; DataTable dt = SqlDataAccessHelper.ExecuteQuery(sql); for (int i = 0; i < dt.Rows.Count; i++) { NguoiDungDTO nd = new NguoiDungDTO(); nd.MaND = int.Parse(dt.Rows[i]["MaND"].ToString()); nd.TenDN = dt.Rows[i]["TenDN"].ToString(); nd.MatKhau = dt.Rows[i]["MatKhau"].ToString(); nd.HoTen = dt.Rows[i]["HoTen"].ToString(); nd.Quyen = dt.Rows[i]["Quyen"].ToString(); _ds.Add(nd); } return(_ds); }