public DataTable Danh_Sach_Tai_Khoan(string A) { string sql = "SELECT TEN_TAI_KHOAN FROM TAI_KHOAN WHERE TEN_TAI_KHOAN ='" + A + "'"; DataTable tb = K.Tai_Du_lieu(sql); return(tb); }
public DataTable Danh_Sach_Ngay_Lam(string A, string M, string Y) { string sql = "SELECT MA_GIO_LAM, NGAY_LAM,GIO_LAM FROM GIO_LAM WHERE MA_NHAN_VIEN='" + A + "' AND MONTH(NGAY_LAM)='" + M + "' AND YEAR(NGAY_LAM)='" + Y + "'"; DataTable tb = K.Tai_Du_lieu(sql); return(tb); }
public string GetMa(string sql) { DataTable tb = K.Tai_Du_lieu(sql); if (tb.Rows.Count > 0) { string str = tb.Rows[0][0].ToString(); return(str); } else { return(""); } }
public DataTable DS_Luong() { string sql = "SELECT MA_NHAN_VIEN,TEN_NHAN_VIEN,GIOI_TINH,NGAY_SINH,TEN_BO_PHAN,LUONG_CO_BAN FROM NHAN_VIEN WHERE MA_NHAN_VIEN != 'NV000'"; DataTable tb = K.Tai_Du_lieu(sql); return(tb); }
public DataTable DS_KhachHang() { string sql = "SELECT MA_KHACH_HANG, HO_TEN, GIOI_TINH ,NGAY_SINH, SO_DIEN_THOAI, SCMND, DIEM_TICH_LUY, EMAIL, DIA_CHI FROM KHACH_HANG WHERE MA_KHACH_HANG !='KH000'"; DataTable DSKH = K.Tai_Du_lieu(sql); return(DSKH); }
public DataTable Tat_Ca_Tai_khoan() { string sql = " SELECT TK.MA_NHAN_VIEN, TK.TEN_TAI_KHOAN, NV.TEN_NHAN_VIEN, NV.GIOI_TINH,NV.NGAY_SINH,NV.TEN_BO_PHAN,NV.SO_DIEN_THOAI,NV.DIA_CHI, TK.MAT_KHAU FROM NHAN_VIEN NV, TAI_KHOAN TK WHERE NV.MA_NHAN_VIEN=TK.MA_NHAN_VIEN AND NV.MA_NHAN_VIEN !='NV000'"; DataTable tb = K.Tai_Du_lieu(sql); return(tb); }
public DataTable DS_NhanVien() { string sql = "SELECT MA_NHAN_VIEN,TEN_NHAN_VIEN,GIOI_TINH,NGAY_SINH,TEN_BO_PHAN,SO_DIEN_THOAI,SCMND,EMAIL,DIA_CHI,LUONG_CO_BAN FROM NHAN_VIEN WHERE MA_NHAN_VIEN !='NV000'"; DataTable tb = K.Tai_Du_lieu(sql); return(tb); }
public string Ngay() { DateTime A = DateTime.Now; string Ngay = string.Format("{0:MM/dd/yyyy}", A); string sql = "SELECT SUM(TONG_TIEN) FROM HOA_DON WHERE NGAY_TAO='" + Ngay + "' "; DataTable B = K.Tai_Du_lieu(sql); if (B.Rows.Count > 0) { string str = B.Rows[0][0].ToString(); return(str); } else { string str = "000000"; return(str); } }
public DataTable DS_SanPham() { string sql = "SELECT MA_SAN_PHAM,TEN_SAN_PHAM,KHOI_LUONG_NHAP,GIA_NHAP_VAO,GIA_BAN_RA,NGAY_DONG_GOI,NGAY_HET_HAN,NHA_CUNG_CAP,NOI_XUAT_XU FROM KHO_SAN_PHAM WHERE MA_SAN_PHAM !='SP000'"; DataTable DSSP = K.Tai_Du_lieu(sql); return(DSSP); }