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