public void Them(clsDuLieuPP ptDLPP)
{
daClient dC = new daClient();
dC.Tao();
using (var db = new LiteDatabase(dC.TenFileDuLieuPP))
{
var col = db.GetCollection <clsDuLieuPP>(dC.BangDuLieuPP);
if (ptDLPP.ID == 0)
{
try
{
ptDLPP.ID = col.Max() + 1;
}
catch
{
ptDLPP.ID = 1;
}
ptDLPP.DaTruyen = false;
col.Insert(ptDLPP);
col.EnsureIndex(x => x.ID);
}
else
{
col.Update(ptDLPP.ID, ptDLPP);
}
}
}
public void Them(clsLan ptLan)
{
daClient dC = new daClient();
dC.Tao();
using (var db = new LiteDatabase(dC.TenFileLogLay))
{
var col = db.GetCollection <clsLan>(dC.BangLanLay);
if (ptLan.ID == 0)
{
try
{
ptLan.ID = col.Max() + 1;
}
catch
{
ptLan.ID = 1;
}
col.Insert(ptLan);
col.EnsureIndex(x => x.ID);
}
else
{
col.Update(ptLan.ID, ptLan);
}
}
}
public List <bCauHinh> Doc()
{
daClient dC = new daClient();
dC.Tao();
var db = new LiteDatabase(dC.TenFileNVPP);
var col = db.GetCollection <bCauHinh>(dC.BangDanhMuc);
return(col.FindAll().OrderBy(x => x.Ma).ToList());
}
public void XoaTatCa()
{
daClient dC = new daClient();
dC.Tao();
using (var db = new LiteDatabase(dC.TenFileDuLieuPP))
{
var col = db.GetCollection <clsDuLieuPP>(dC.BangDuLieuPP);
col.Delete(x => x.DaTruyen == true);
db.Shrink();
}
}
public void Xoa(DateTime rNgay)
{
daClient dC = new daClient();
dC.Tao();
using (var db = new LiteDatabase(dC.TenFileDuLieuPP))
{
var col = db.GetCollection <clsDuLieuPP>(dC.BangDuLieuPP);
col.Delete(x => x.NgayPhatHanh.Value <= daTienIch.CuoiNgay(rNgay) && x.DaTruyen == true);
db.Shrink();
}
}
public List <clsDuLieuPP> LayDanhSachChuaTruyen()
{
daClient dC = new daClient();
dC.Tao();
List <clsDuLieuPP> lstPP = new List <clsDuLieuPP>();
using (var db = new LiteDatabase(dC.TenFileDuLieuPP))
{
var col = db.GetCollection <clsDuLieuPP>(dC.BangDuLieuPP);
lstPP = col.Find(x => x.DaTruyen == false).ToList();
}
return(lstPP);
}
public clsDuLieuPP Tim(string rTranID)
{
daClient dC = new daClient();
dC.Tao();
clsDuLieuPP _kqtim = new clsDuLieuPP();
using (var db = new LiteDatabase(dC.TenFileDuLieuPP))
{
var col = db.GetCollection <clsDuLieuPP>(dC.BangDuLieuPP);
_kqtim = col.FindOne(x => x.TranID == rTranID);
}
return(_kqtim);
}
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 DataTable BaoCao(DateTime rNgay)
{
//Dich vu
List <bCauHinh> lstDV = new List <bCauHinh>();
daDanhMucNVPP dDM = new daDanhMucNVPP();
lstDV = dDM.Doc();
//===========
daClient dC = new daClient();
dC.Tao();
List <clsDuLieuPP> lstPPThu = new List <clsDuLieuPP>();
List <clsDuLieuPP> lstPPChi = new List <clsDuLieuPP>();
List <clsBaoCaoPP> lst = new List <clsBaoCaoPP>();
clsBaoCaoPP bc;
using (var db = new LiteDatabase(dC.TenFileDuLieuPP))
{
var col = db.GetCollection <clsDuLieuPP>(dC.BangDuLieuPP);
foreach (bCauHinh dm in lstDV)
{
lstPPThu = col.Find(x => x.NgayPhatHanh.Value.ToShortDateString() == rNgay.ToShortDateString() && x.PAC.Trim() == dm.Ma && (x.InvokedFrom == "THU" || x.InvokedFrom == "NORMAL")).ToList();
lstPPChi = col.Find(x => x.NgayPhatHanh.Value.ToShortDateString() == rNgay.ToShortDateString() && x.PAC.Trim() == dm.Ma && x.InvokedFrom == "CHI").ToList();
bc = new clsBaoCaoPP();
bc.Ma = dm.Ma;
bc.Ten = dm.GiaTri;
bc.Thu = lstPPThu.Sum(t => t.TranAmount.Value);
bc.Chi = lstPPChi.Sum(c => c.TranAmount.Value);
if (bc.Thu != 0 || bc.Chi != 0)
{
lst.Add(bc);
}
}
}
return(daTienIch.ToDataTable(lst));
}