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