using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using ABC.KetNoi;

namespace ABC
{
   public class DuLieu
    {
        public static DataSet List_Nhom_NCC, List_NCC, List_NCC_Tra;
        public static DataSet List_Nhom_KhachHang, List_KhachHang;
        public static DataSet List_Nhom_Hang, List_Hang;
        public static DataSet List_NhanVien;

        public static DataTable Le_chuaLuu, Le_chuaLuu_sx, Le_daluu, Le_tatca;

        public static DataSet List_NhapSi_DaLuu, List_NhapSi_ChuaLuu, List_NhapSi_KiemTra;
        public static DataSet List_NhapLe_HoaDon, List_NhapLe_ChiTiet;
        public static DataSet BaoCao_ToaSi, BaoCao_SoBaoCao_Si_Bien, BaoCao_SoBaoCao_Si_Tra;
        public static DataSet ToaLe_Full;//Table : HoaDon , Table:ChiTiet
        public static DataSet BaoCaoLe;
        public static DataSet BaoCaoSi_Le;
        public static DataSet BaoCao_TheoKhachHang, BaoCao_TheoThuongLai, BaoCao_ChiTiet_Theo_KH,BaoCa_DoanhSo;
        public static DataTable BaoCao_ChiTiet_Theo_KH_mau;

        public static DataSet NhapLe_List_NCC, NhapLe_List_Ca;
        public static string Le_ID;
        public static string Le_KyTu;
        public static decimal Le_SoHD;
        public static string Le_Tbl_KhachHang_ID;
        public static string Le_Tbl_KhachHang_Name;
        public static decimal Le_TienMat;
        public static string Le_ID_NCC;
        public static string Le_Tbl_NCC_Name;
        public static string Le_Toa;
        public static decimal Le_TongTien;
        public static decimal tongtienmat_nhaple_baoca, tongtienno_nhaple_baoca;

       
        public static string KyTu;
        //cong no
        public static DataSet ChiTiet_TraNo, CongNo_1Ngay, CongNo_1Ngay_NVCan, CongNo_1Ngay_1kh;
        public static DataSet CongNo_1Ngay_Sot, CongNo_1Ngay_Ket, CongNo_1Ngay_Lu, CongNo_1Ngay_Cat, CongNo_1Ngay_Bom;
        //Toa
        public static string User_case;
        public static DataSet QuanLyduLieu;
        public static DataSet QuanLyduLieu_group;
        public static DataSet QuanLyToa, QuanLyToa_gop, ThongKeToa_ChiTiet, ThongKeToa_tonghop,ThongKeToan_chuyentientoa;
        //
        public static DataSet DS_Toa_XML;

        public static DataSet Toa_dieukien;
        //thiet lap toa
       // public static int from_show = 0;
        public static string Ma_Toa;
       //// public static int So_Toa;
       // public static string KyTuToa;
       // public static int Ngay_hienthi_Toa,Tungay_toa,Denngay_toa;
       // public static string Ngay_hienthi_Toa_text,tungay_toa_text,DenNgay_toa_text;
       // public static string ID_NCC_Toa, Ten_NCC_Toa;
       // public static string GhiChu_Toa;
        //Du lieu lam tao
       // public static DataSet T_DL_TatCa;
       // public static DataSet T_DL_MoiNhap;       
        public static DataSet T_DL_TatCa_Group_Ngay_LoaiCa_Gia;
        public static DataSet T_DL_TatCa_Group_Ngay_LoaiCa;
            //    //thong tin toa
        public static string  TINHTRANG;
        public static decimal TKHIEN;
        public static decimal TIEN;
        public static decimal TNUOC;
        public static decimal TUNG;
        public static decimal TXE;
        public static decimal TKY;

        public static string TEN_THEM1;
        public static string TEN_THEM2;
        public static string TEN_THEM3;
        public static decimal TTHEM1;
        public static decimal TTHEM2;
        public static decimal TTHEM3;

        public static decimal TTHANG;
        public static decimal TongchiPhi,ChiPhikhac;

        public static decimal T_HH,PhaiTra;
      

        public static string  x1,x2,x3,trangthai;


        public static decimal _SLG, _DSG, _GiaG;
        public static decimal _SLT, _DST, _GiaT, _GiaT_cophi;
        public static decimal _SLLech, _DSLech, _GiaLech;
        public static int  ngattrang;
        public static string tien_chu;
        public static DataRow Dr_gia;
        public static void LuuLuocSu(string TaiKhoan,string MaForm,string DuLieuCu,string DuLieuMoi,string HanhDong)
        {
            DateTime ngay = new DateTime(1900, 1, 1);
            int soNgay = (DateTime.Now - ngay).Days;
            Class_KetNoi cls = new Class_KetNoi();
            string sql = "sp_LuocSu_NhanVien_Insert ";
            sql += "'" + soNgay + "',";
            sql += "N'" +TaiKhoan + "',";
            sql += "N'" + MaForm  + "',";
            sql += "N'" + DuLieuCu + "',";
            sql += "N'" + DuLieuMoi + "',";
            sql += "N'" + HanhDong + "'";
            cls.T_exc(sql);
        }
    }
}
