static public void XuatQuyTienMat(string ChungTuID, DateTime dtNgayChungTu, decimal dcSoTien, string strPhanLoai,
string strGhiChu)
{
dbControl = new QlShop();
QuyTienMat item = null;
using (TransactionScope TSCope = new TransactionScope())
{
if (dbControl.QuyTienMats.FirstOrDefault(p => DbFunctions.TruncateTime(p.Ngay_ThaoTac) == DbFunctions.TruncateTime(dtNgayChungTu)) == null)
{
item = new QuyTienMat();
item.Ngay_ThaoTac = DateTime.Now;
item.NgayChungTu = DateTime.Now;
item.PhanLoai = "KC";
item.TienDauKy = 0;
item.TienNhap = QuyTienMatController.TienTrongQuyHienTai();
item.TienXuat = 0;
item.GhiChu = "Kết chuyển tiền qua ngày";
dbControl.QuyTienMats.Add(item);
}
item = new QuyTienMat();
item.ChungTu_ID = ChungTuID;
item.NgayChungTu = dtNgayChungTu;
item.PhanLoai = strPhanLoai;
item.GhiChu = strGhiChu;
item.TienNhap = 0;
item.TienXuat = dcSoTien;
item.TienDauKy = TienTrongQuyHienTai();
item.TienCuoiKy = item.TienDauKy - item.TienXuat;
item.Ngay_ThaoTac = DateTime.Now;
dbControl.QuyTienMats.Add(item);
dbControl.SaveChanges();
TSCope.Complete();
}
}
static public QuyTienMat LayTrangThaiQuy(DateTime dtNgay)
{
DataTable tblReturn = SqlHelper.ExecuteDataset(Utility.GetConnectString(), CommandType.StoredProcedure, "QuyTienMat_LayTrangThai").Tables[0];
if ((tblReturn != null) && (tblReturn.Rows.Count != 0))
{
QuyTienMat item = new QuyTienMat();
item.ChungTu_ID = tblReturn.Rows[0]["ChungTu_ID"].ToString();
item.NgayChungTu = (DateTime)tblReturn.Rows[0]["NgayChungTu"];
item.PhanLoai = tblReturn.Rows[0]["PhanLoai"].ToString();
item.TienDauKy = Convert.ToDecimal(tblReturn.Rows[0]["TienDauKy"].ToString());
item.TienNhap = Convert.ToDecimal(tblReturn.Rows[0]["TienNhap"].ToString());
item.TienXuat = Convert.ToDecimal(tblReturn.Rows[0]["TienXuat"].ToString());
item.TienCuoiKy = Convert.ToDecimal(tblReturn.Rows[0]["TienCuoiKy"].ToString());
return(item);
}
else
{
return(null);
}
}
