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