public DataTable DocDuLieuChuyenHoan() { daCauHinh dCH = new daCauHinh(); dCH.Lay((int)daCauHinh.eCauHinh.Mã_Bưu_Cục); if (dCH.CauHinh != null) { MaBuuCuc = dCH.CauHinh.GiaTri; } daBuuGui dBG = new daBuuGui(); dBG.SoHieuBuuCuc = MaBuuCuc; dBG.Ngay = Ngay; dBG.TuNgay = Ngay; dBG.DenNgay = Ngay; dCH.Lay((int)daCauHinh.eCauHinh.Đường_Dẫn_BCCP); if (dCH.CauHinh != null) { dBG.FileConfigBCCP = dCH.CauHinh.GiaTri; } return(dBG.DanhSachBuuGui_ChuyenHoan()); }
public void DocDuLieuPhatHanh() { daCauHinh dCH = new daCauHinh(); dCH.Lay((int)daCauHinh.eCauHinh.Mã_Bưu_Cục); if (dCH.CauHinh != null) { MaBuuCuc = dCH.CauHinh.GiaTri; } daBuuGui dBG = new daBuuGui(); dBG.SoHieuBuuCuc = MaBuuCuc; dBG.Ngay = NgayPhatHanh; dCH.Lay((int)daCauHinh.eCauHinh.Đường_Dẫn_BCCP); if (dCH.CauHinh != null) { dBG.FileConfigBCCP = dCH.CauHinh.GiaTri; } BangDuLieu = dBG.DanhSachBuuGui(); dCH.CauHinh.GiaTri = dBG.ChuoiKetNoiChay; dCH.CauHinh.ID = (int)daCauHinh.eCauHinh._Chuỗi_Kết_nối_Chạy; dCH.CauHinh.Ma = "ChuoiKetNoiBCCP"; dCH.Them(); }
public DataTable DocDuLieuPhanBuuTa() { daCauHinh dCH = new daCauHinh(); dCH.Lay((int)daCauHinh.eCauHinh.Mã_Bưu_Cục); if (dCH.CauHinh != null) { MaBuuCuc = dCH.CauHinh.GiaTri; } daBuuGui dBG = new daBuuGui(); dBG.SoHieuBuuCuc = MaBuuCuc; dBG.Ngay = Ngay; dCH.Lay((int)daCauHinh.eCauHinh.Đường_Dẫn_BCCP); if (dCH.CauHinh != null) { dBG.FileConfigBCCP = dCH.CauHinh.GiaTri; } if (Ca == 1) { return(dBG.DanhSachBuuGui_COD_DongBuuTa_CaSang()); } else { return(dBG.DanhSachBuuGui_COD_DongBuuTa_CaChieu()); } }
public void DocVaGhiDuLieu() { string rTenFile = ""; daCauHinh dCH = new daCauHinh(); dCH.Lay(dCH.TimMaThamSo((int)daCauHinh.eCauHinh.Đường_Dẫn_Paypost)); if (dCH.CauHinh != null) { rTenFile = dCH.CauHinh.GiaTri; } rTenFile = rTenFile + "\\TRANSACTION"; List <string> dsThuMuc; daThuMuc dTM = new daThuMuc(); dsThuMuc = dTM.TimThuMucCoDuLieu(rTenFile); DateTime _NgayPhatHanh = DateTime.Now; string _rTenFileDL = ""; for (int i = 0; i < dsThuMuc.Count; i++) { _rTenFileDL = rTenFile + "\\" + dsThuMuc[i] + "\\" + _NgayPhatHanh.ToString("yyyyMMdd") + ".log"; if (KiemTraCoTonTaiFile(_rTenFileDL)) { DocGhi(_rTenFileDL, _NgayPhatHanh); } } }
public void DocVaThem() { //Doc trong bccp daCauHinh dCH = new daCauHinh(); daLayBangCuoc dLay = new daLayBangCuoc(); dCH.Lay((int)daCauHinh.eCauHinh.Đường_Dẫn_BCCP); if (dCH.CauHinh != null) { dLay.FileConfigBCCP = dCH.CauHinh.GiaTri; } DataTable dt; dt = dLay.LayDSdichVu(); //============== if (dt.Rows.Count > 0) { using (var db = new LiteDatabase(dCli.TenFileDichVu)) { var col = db.GetCollection <clsDichVu>(dCli.BangDichVu); col.Delete(x => x.MaNhom == "BCCP"); int _ID; try { _ID = col.Max(); } catch { _ID = 0; } _ID = _ID + 1; clsDichVu pDV; DataRow dr; for (int i = 0; i < dt.Rows.Count; i++) { dr = dt.Rows[i]; pDV = new clsDichVu(); pDV.Ma = dr["ServiceCode"] == DBNull.Value ? "" : dr["ServiceCode"].ToString(); pDV.Ten = dr["ServiceName"] == DBNull.Value ? "" : dr["ServiceName"].ToString(); pDV.MaNhom = dr["ServiceTypeCode"] == DBNull.Value ? "" : dr["ServiceTypeCode"].ToString(); pDV.STTsx = i; pDV.ID = _ID + i; col.Insert(pDV); } col.EnsureIndex(x => x.ID); db.Shrink(); } } }
public void LayDanhMuc() { string rTenFile = ""; daCauHinh dCH = new daCauHinh(); dCH.Lay(dCH.TimMaThamSo((int)daCauHinh.eCauHinh.Đường_Dẫn_Paypost)); if (dCH.CauHinh != null) { rTenFile = dCH.CauHinh.GiaTri; } rTenFile = rTenFile + "\\PAYPOST DICTIONARY\\PROVIDER_ACNT.DIC"; object[] obj; IFormatter formatter = new BinaryFormatter(); if (File.Exists(rTenFile)) { Stream stream = new FileStream(rTenFile, System.IO.FileMode.Open, FileAccess.Read, FileShare.None); obj = (object[])formatter.Deserialize(stream); stream.Close(); daClient dC = new daClient(); dC.Tao(); var db = new LiteDatabase(dC.TenFileNVPP); var col = db.GetCollection <bCauHinh>(dC.BangDanhMuc); bCauHinh pt; string[] str; int n = 0; for (int i = 0; i < obj.Length; i++) { str = obj[i].ToString().Split(';'); if (str[2] != "6") { pt = new bCauHinh(); n = n + 1; pt.ID = n; pt.Ma = str[3].Trim(); pt.GiaTri = str[4].Trim(); col.Insert(pt); } } col.EnsureIndex(x => x.ID); } }
public void DocVaGhiDuLieu(DateTime rTuNgay, DateTime rDenNgay) { daDuLieuPayPost dDLPP = new daDuLieuPayPost(); dDLPP.XoaTatCa(); string rTenFile = ""; daCauHinh dCH = new daCauHinh(); dCH.Lay(dCH.TimMaThamSo((int)daCauHinh.eCauHinh.Đường_Dẫn_Paypost)); if (dCH.CauHinh != null) { rTenFile = dCH.CauHinh.GiaTri; } rTenFile = rTenFile + "\\TRANSACTION"; List <string> dsThuMuc; daThuMuc dTM = new daThuMuc(); dsThuMuc = dTM.TimThuMucCoDuLieu(rTenFile); DateTime _NgayPhatHanh;// = DateTime.Now; string _rTenFileDL = ""; int i; _NgayPhatHanh = rTuNgay; while (_NgayPhatHanh <= rDenNgay) { for (i = 0; i < dsThuMuc.Count; i++) { _rTenFileDL = rTenFile + "\\" + dsThuMuc[i] + "\\" + _NgayPhatHanh.ToString("yyyyMMdd") + ".log"; if (KiemTraCoTonTaiFile(_rTenFileDL)) { DocGhi(_rTenFileDL, _NgayPhatHanh); } } _NgayPhatHanh = _NgayPhatHanh.AddDays(1); } }
public void DocVaGhiDuLieu_LuuGiu() { string rTenFile = ""; daCauHinh dCH = new daCauHinh(); dCH.Lay(dCH.TimMaThamSo((int)daCauHinh.eCauHinh.Đường_Dẫn_Paypost)); if (dCH.CauHinh != null) { rTenFile = dCH.CauHinh.GiaTri; } rTenFile = rTenFile + "\\TRANSACTION"; dCH.Lay(dCH.TimMaThamSo((int)daCauHinh.eCauHinh.Tên_Đăng_nhập_Paypost)); if (dCH.CauHinh != null) { rTenFile = rTenFile + "\\" + dCH.CauHinh.GiaTri; } DateTime _NgayPhatHanh = DateTime.Now; rTenFile = rTenFile + "\\" + _NgayPhatHanh.ToString("yyyyMMdd") + ".log"; if (KiemTraCoTonTaiFile(rTenFile)) { Transactions transactions = null; try { transactions = ObjectXMLSerializer <Transactions> .Load(rTenFile, SerializedFormat.Binary); } catch { transactions = new Transactions(); transactions.Transaction = new PAYPOST.LOG.Transaction[0]; } Transaction[] array = new Transaction[transactions.Transaction.Length]; transactions.Transaction.CopyTo(array, 0); daDuLieuPayPost dDLPP = new daDuLieuPayPost(); clsDuLieuPP ptPP = new clsDuLieuPP(); Transaction dlDoc; for (int i = 0; i < array.Length; i++) { dlDoc = array[i]; ptPP = dDLPP.Tim(dlDoc.TranID); if (ptPP != null) { if (ptPP.TranTime != dlDoc.TranTime) { ptPP.DaTruyen = false; dDLPP.Them(ptPP); } } else { ptPP = new clsDuLieuPP(); ptPP.NgayPhatHanh = _NgayPhatHanh; ptPP.TranTime = dlDoc.TranTime; ptPP.TranCat = dlDoc.TranCat; ptPP.InvokedFrom = dlDoc.InvokedFrom; ptPP.TranID = dlDoc.TranID; ptPP.PAC = dlDoc.PAC; ptPP.AccountID = dlDoc.AccountID; ptPP.TranAmount = dlDoc.TranAmount; ptPP.SenderName = dlDoc.SenderName; ptPP.AddInfo1 = dlDoc.AddInfo1; ptPP.AddInfo2 = dlDoc.AddInfo2; ptPP.AddInfo3 = dlDoc.AddInfo3; ptPP.AddInfo4 = dlDoc.AddInfo4; ptPP.AddInfo5 = dlDoc.AddInfo5; ptPP.AddInfo6 = dlDoc.AddInfo6; ptPP.AddInfo7 = dlDoc.AddInfo7; ptPP.AddInfo8 = dlDoc.AddInfo8; ptPP.Fee = dlDoc.Fee; ptPP.Add_Info_Fee_01 = dlDoc.Add_Info_Fee_01; ptPP.Add_Info_Fee_02 = dlDoc.Add_Info_Fee_02; ptPP.Add_Info_Fee_03 = dlDoc.Add_Info_Fee_03; ptPP.Add_Info_Fee_04 = dlDoc.Add_Info_Fee_04; ptPP.Add_Info_Fee_05 = dlDoc.Add_Info_Fee_05; dDLPP.Them(ptPP); } Ghi(ptPP, null); } } }