public static bool CapNhatChiTietGoiMonTheoMaGoiMon(ChiTietGoiMonDTO ctgm) { bool kq; string sql = string.Format("update ChiTietGoiMon set MaThucDon = {0), SoLuong = {1} where MaGoiMon where MaGoiMon = {2}", ctgm.MaTD, ctgm.SoLuong, ctgm.MaGoiMon); kq = SqlDataAccessHelper.ExecuteNonQuery(sql); return(kq); }
public static bool ThemChiTietGoiMon(ChiTietGoiMonDTO ctgm) { bool kq; ctgm.MaCTGoiMon = MaTuTang(); string sql = string.Format("insert into ChiTietGoiMon values ({0}, {1}, {2}, {3}, {4})", ctgm.MaCTGoiMon, ctgm.MaGoiMon, ctgm.MaTD, ctgm.DonGia, ctgm.SoLuong); kq = SqlDataAccessHelper.ExecuteNonQuery(sql); return(kq); }
//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); }
public static bool ThemChiTietGoiMon(ChiTietGoiMonDTO ctgm) { bool kq = ChiTietGoiMonDAO.ThemChiTietGoiMon(ctgm); return(kq); }