public KHACHHANG GetByMaKhachHang(string maKH) { var KH = new QuanLyQuanAnDbContext().Database.SqlQuery <KHACHHANG>("select * from KHACHHANG where MAKHACHHANG='" + maKH + "'").First(); KH.GetThongTinAccount(); return(KH); }
public int TinhTongSoTienLuongChuaThanhToan() { try { double S = new QuanLyQuanAnDbContext().Database.SqlQuery <double>("Sp_NHANVIEN_TinhTongSoTienLuongChuaThanhToan @maNhanVien='" + MANHANVIEN + "'").First(); return((int)S); } catch { return(0); } }
public static List <NUOCGIAIKHAT> GetAllNuocGiaiKhat() { var list = new QuanLyQuanAnDbContext().Database.SqlQuery <NUOCGIAIKHAT>("select * from NUOCGIAIKHAT").ToList(); foreach (var item in list) { item.GetAllRefInfo(); } return(list); }
public static List <NHANVIEN> GetAllConHoatDong() { var list = new QuanLyQuanAnDbContext().Database.SqlQuery <NHANVIEN>("select * from NHANVIEN where TRANGTHAI=1").ToList(); foreach (var item in list) { item.GetAllRefInfo(); } return(list); }
public static List <MONAN> GetAllMonAn() { var list = new QuanLyQuanAnDbContext().Database.SqlQuery <MONAN>("select * from MONAN").ToList(); foreach (var item in list) { item.GetAllRefInfo(); } return(list); }
public static List <NGUYENLIEU> GetAllNguyenLieu() { List <NGUYENLIEU> list = new QuanLyQuanAnDbContext().Database.SqlQuery <NGUYENLIEU>("Select * from NGUYENLIEU").ToList(); foreach (var item in list) { item.GetAllRefInfo(); } return(list); }
public List <MATHANG> GetAllNuocGiaiKhat_MonAn() { List <MATHANG> list = new QuanLyQuanAnDbContext().Database.SqlQuery <MATHANG>("Sp_MATHANG_GetAll_NuocGiaiKhat_MonAn").ToList(); foreach (MATHANG item in list) { item.GetInforMatHang(); } return(list); }
public static List <MENUMONAN> GetAll() { var list = new QuanLyQuanAnDbContext().Database.SqlQuery <MENUMONAN>("select * from MENUMONAN inner join MATHANG on MATHANG.MAMATHANG=MENUMONAN.MAMONAN order by TRANGTHAI DESC, TENMATHANG ASC").ToList(); foreach (var item in list) { item.GetAllRefInfo(); } return(list); }
public string GetTrangThaiThanhToanLuongHomNay() { string date = DateTime.Now.ToString("yyyy/MM/dd"); int dem = new QuanLyQuanAnDbContext().Database.SqlQuery <int>("select count(*) from CHAMCONGNHANVIEN where NGAYCHAMCONG='" + date + "' and MANHANVIEN='" + MANHANVIEN + "'").First(); if (dem > 0) { return("Đã chấm công"); } else { return("Chưa chấm công"); } }
public static List <LOAIMATHANG> GetAllLoaiMatHangNhap() { List <LOAIMATHANG> list = new QuanLyQuanAnDbContext().Database.SqlQuery <LOAIMATHANG>("Sp_LOAIMATHANG_GetAllLoaiMatHangNhap").ToList(); return(list); }