public IList <S05HGroupModel> GetReportS05H(XtraForm frmParent, GlobalVariable commonVariable, ReportSharpHelper oRsTool) { try { IList <S05HModel> list = null; S05HGroupModel s05HGroup = new S05HGroupModel(); var amountType = GlobalVariable.AmountTypeViewReport; var currencyCode = GlobalVariable.CurrencyViewReport; var reportDate = _globalVariable.PostedDate; var isTotalBandInNewPage = false; if (!oRsTool.IsRefresh) { using (var frmParam = new FrmB01H()) { if (frmParam.ShowDialog() == DialogResult.OK) { GlobalVariable.FromDate = DateTime.Parse(frmParam.FromDate); GlobalVariable.ToDate = DateTime.Parse(frmParam.ToDate); isTotalBandInNewPage = frmParam.IsTotalBandInNewPage; list = Model.GetS05HWithStoreProdure(commonVariable.ReportList.ProcedureName, GlobalVariable.FromDate.ToShortDateString(), GlobalVariable.ToDate.ToShortDateString(), currencyCode, amountType); } else { return(null); } } } else { list = Model.GetS05HWithStoreProdure(commonVariable.ReportList.ProcedureName, GlobalVariable.FromDate.ToShortDateString(), GlobalVariable.ToDate.ToShortDateString(), currencyCode, amountType); } if (list != null && list.Count > 0) { foreach (var obj in list.ToList()) { if (obj.ClosingCredit == 0 && obj.ClosingDebit == 0 && obj.MovementAccumCredit == 0 && obj.MovementAccumDebit == 0 && obj.MovementCredit == 0 && obj.MovementDebit == 0 && obj.OpeningCredit == 0 && obj.OpeningDebit == 0) { list.Remove(obj); } } s05HGroup.GroupA = list.Where(w => !w.AccountCode.StartsWith("0")).ToList() ?? new List <S05HModel>(); s05HGroup.GroupB = list.Where(w => w.AccountCode.StartsWith("0")).ToList() ?? new List <S05HModel>(); if (!oRsTool.Parameters.ContainsKey("IsTotalBandInNewPage")) { oRsTool.Parameters.Add("IsTotalBandInNewPage", isTotalBandInNewPage); } if (!oRsTool.Parameters.ContainsKey("CompanyProvince")) { oRsTool.Parameters.Add("CompanyProvince", _globalVariable.CompanyProvince); } if (!oRsTool.Parameters.ContainsKey("ReportDate")) { oRsTool.Parameters.Add("ReportDate", reportDate); } if (amountType == 1) { if (!oRsTool.Parameters.ContainsKey("CurrencyCodeUnit")) { oRsTool.Parameters.Add("CurrencyCodeUnit", "Đơn vị tính (qui đổi): " + currencyCode); } } else { if (!oRsTool.Parameters.ContainsKey("CurrencyCodeUnit")) { oRsTool.Parameters.Add("CurrencyCodeUnit", "Đơn vị tính (nguyên tệ): " + currencyCode); } } if (!oRsTool.Parameters.ContainsKey("FromDate")) { oRsTool.Parameters.Add("FromDate", GlobalVariable.FromDate.ToShortDateString()); } if (!oRsTool.Parameters.ContainsKey("ToDate")) { oRsTool.Parameters.Add("ToDate", GlobalVariable.ToDate.ToShortDateString()); } //decimal TotalOpeningCredit = list.Where(x => x.Grade == 1).Sum(x => x.OpeningCredit); //decimal TotalOpeningDebit = list.Where(x => x.Grade == 1).Sum(x => x.OpeningDebit); //decimal TotalMovementAccumCredit = list.Where(x => x.Grade == 1).Sum(x => x.MovementAccumCredit); //decimal TotalMovementAccumDebit = list.Where(x => x.Grade == 1).Sum(x => x.MovementAccumDebit); //decimal TotalMovementCredit = list.Where(x => x.Grade == 1).Sum(x => x.MovementCredit); //decimal TotalMovementDebit = list.Where(x => x.Grade == 1).Sum(x => x.MovementDebit); //decimal TotalClosingCredit = list.Where(x => x.Grade == 1).Sum(x => x.ClosingCredit); //decimal TotalClosingDebit = list.Where(x => x.Grade == 1).Sum(x => x.ClosingDebit); decimal TotalOpeningCredit = s05HGroup.GroupA.Where(x => x.Grade == 1).Sum(x => x.OpeningCredit); decimal TotalOpeningDebit = s05HGroup.GroupA.Where(x => x.Grade == 1).Sum(x => x.OpeningDebit); decimal TotalMovementAccumCredit = s05HGroup.GroupA.Where(x => x.Grade == 1).Sum(x => x.MovementAccumCredit); decimal TotalMovementAccumDebit = s05HGroup.GroupA.Where(x => x.Grade == 1).Sum(x => x.MovementAccumDebit); decimal TotalMovementCredit = s05HGroup.GroupA.Where(x => x.Grade == 1).Sum(x => x.MovementCredit); decimal TotalMovementDebit = s05HGroup.GroupA.Where(x => x.Grade == 1).Sum(x => x.MovementDebit); decimal TotalClosingCredit = s05HGroup.GroupA.Where(x => x.Grade == 1).Sum(x => x.ClosingCredit); decimal TotalClosingDebit = s05HGroup.GroupA.Where(x => x.Grade == 1).Sum(x => x.ClosingDebit); if (!oRsTool.Parameters.ContainsKey("TotalMovementCredit")) { oRsTool.Parameters.Add("TotalMovementCredit", TotalMovementCredit); } if (!oRsTool.Parameters.ContainsKey("TotalMovementDebit")) { oRsTool.Parameters.Add("TotalMovementDebit", TotalMovementDebit); } if (!oRsTool.Parameters.ContainsKey("TotalClosingCredit")) { oRsTool.Parameters.Add("TotalClosingCredit", TotalClosingCredit); } if (!oRsTool.Parameters.ContainsKey("TotalClosingDebit")) { oRsTool.Parameters.Add("TotalClosingDebit", TotalClosingDebit); } if (!oRsTool.Parameters.ContainsKey("TotalOpeningCredit")) { oRsTool.Parameters.Add("TotalOpeningCredit", TotalOpeningCredit); } if (!oRsTool.Parameters.ContainsKey("TotalOpeningDebit")) { oRsTool.Parameters.Add("TotalOpeningDebit", TotalOpeningDebit); } if (!oRsTool.Parameters.ContainsKey("TotalMovementAccumCredit")) { oRsTool.Parameters.Add("TotalMovementAccumCredit", TotalMovementAccumCredit); } if (!oRsTool.Parameters.ContainsKey("TotalMovementAccumDebit")) { oRsTool.Parameters.Add("TotalMovementAccumDebit", TotalMovementAccumDebit); } TotalOpeningCredit = s05HGroup.GroupB.Where(x => x.Grade == 1).Sum(x => x.OpeningCredit); TotalOpeningDebit = s05HGroup.GroupB.Where(x => x.Grade == 1).Sum(x => x.OpeningDebit); TotalMovementAccumCredit = s05HGroup.GroupB.Where(x => x.Grade == 1).Sum(x => x.MovementAccumCredit); TotalMovementAccumDebit = s05HGroup.GroupB.Where(x => x.Grade == 1).Sum(x => x.MovementAccumDebit); TotalMovementCredit = s05HGroup.GroupB.Where(x => x.Grade == 1).Sum(x => x.MovementCredit); TotalMovementDebit = s05HGroup.GroupB.Where(x => x.Grade == 1).Sum(x => x.MovementDebit); TotalClosingCredit = s05HGroup.GroupB.Where(x => x.Grade == 1).Sum(x => x.ClosingCredit); TotalClosingDebit = s05HGroup.GroupB.Where(x => x.Grade == 1).Sum(x => x.ClosingDebit); if (!oRsTool.Parameters.ContainsKey("TotalMovementCreditGroupB")) { oRsTool.Parameters.Add("TotalMovementCreditGroupB", TotalMovementCredit); } if (!oRsTool.Parameters.ContainsKey("TotalMovementDebitGroupB")) { oRsTool.Parameters.Add("TotalMovementDebitGroupB", TotalMovementDebit); } if (!oRsTool.Parameters.ContainsKey("TotalClosingCreditGroupB")) { oRsTool.Parameters.Add("TotalClosingCreditGroupB", TotalClosingCredit); } if (!oRsTool.Parameters.ContainsKey("TotalClosingDebitGroupB")) { oRsTool.Parameters.Add("TotalClosingDebitGroupB", TotalClosingDebit); } if (!oRsTool.Parameters.ContainsKey("TotalOpeningCreditGroupB")) { oRsTool.Parameters.Add("TotalOpeningCreditGroupB", TotalOpeningCredit); } if (!oRsTool.Parameters.ContainsKey("TotalOpeningDebitGroupB")) { oRsTool.Parameters.Add("TotalOpeningDebitGroupB", TotalOpeningDebit); } if (!oRsTool.Parameters.ContainsKey("TotalMovementAccumCreditGroupB")) { oRsTool.Parameters.Add("TotalMovementAccumCreditGroupB", TotalMovementAccumCredit); } if (!oRsTool.Parameters.ContainsKey("TotalMovementAccumDebitGroupB")) { oRsTool.Parameters.Add("TotalMovementAccumDebitGroupB", TotalMovementAccumDebit); } } else { return(new List <S05HGroupModel>()); } return(new List <S05HGroupModel> { s05HGroup }); } catch (Exception ex) { XtraMessageBox.Show("Lỗi ở chỗ này " + ex.InnerException + ex.Message + ex.StackTrace); return(null); } }
public IList <AdvancePaymentModel> GetReportAdvancePayment(XtraForm frmParent, GlobalVariable commonVariable, ReportSharpHelper oRsTool) { try { IList <AdvancePaymentModel> list = null; var amountType = GlobalVariable.AmountTypeViewReport; var currencyCode = GlobalVariable.CurrencyViewReport; var reportDate = _globalVariable.PostedDate; var isTotalBandInNewPage = false; var accountType = 0; if (!oRsTool.IsRefresh) { using (var frmParam = new FrmB01H()) { if (frmParam.ShowDialog() == DialogResult.OK) { GlobalVariable.FromDate = DateTime.Parse(frmParam.FromDate); GlobalVariable.ToDate = DateTime.Parse(frmParam.ToDate); isTotalBandInNewPage = frmParam.IsTotalBandInNewPage; accountType = frmParam.AccountType; list = Model.GetAdvancePaymentWithStoreProdure(commonVariable.ReportList.ProcedureName, GlobalVariable.FromDate.ToShortDateString(), GlobalVariable.ToDate.ToShortDateString(), GlobalVariable.CurrencyViewReport, GlobalVariable.AmountTypeViewReport, accountType); } } } else { list = Model.GetAdvancePaymentWithStoreProdure(commonVariable.ReportList.ProcedureName, GlobalVariable.FromDate.ToShortDateString(), GlobalVariable.ToDate.ToShortDateString(), GlobalVariable.CurrencyViewReport, GlobalVariable.AmountTypeViewReport, accountType); } if (list != null && list.Count > 0) { if (!oRsTool.Parameters.ContainsKey("IsTotalBandInNewPage")) { oRsTool.Parameters.Add("IsTotalBandInNewPage", isTotalBandInNewPage); } //if (!oRsTool.Parameters.ContainsKey("AmountType")) // oRsTool.Parameters.Add("AmountType", amountType); if (!oRsTool.Parameters.ContainsKey("CompanyProvince")) { oRsTool.Parameters.Add("CompanyProvince", _globalVariable.CompanyProvince); } if (!oRsTool.Parameters.ContainsKey("ReportDate")) { oRsTool.Parameters.Add("ReportDate", reportDate); } if (amountType == 1) { if (!oRsTool.Parameters.ContainsKey("CurrencyCodeUnit")) { oRsTool.Parameters.Add("CurrencyCodeUnit", "Đơn vị tính (qui đổi): " + currencyCode); } } else { if (!oRsTool.Parameters.ContainsKey("CurrencyCodeUnit")) { oRsTool.Parameters.Add("CurrencyCodeUnit", "Đơn vị tính (nguyên tệ): " + currencyCode); } } if (!oRsTool.Parameters.ContainsKey("FromDate")) { oRsTool.Parameters.Add("FromDate", GlobalVariable.FromDate.ToShortDateString()); } if (!oRsTool.Parameters.ContainsKey("ToDate")) { oRsTool.Parameters.Add("ToDate", GlobalVariable.ToDate.ToShortDateString()); } } return(list); } catch (Exception ex) { XtraMessageBox.Show("Lỗi ở chỗ này " + ex.InnerException + ex.Message + ex.StackTrace); return(null); } }
/// <summary> /// Bảng cân đối tài khoản /// Gets the report B01 h. /// </summary> /// <param name="reportParameter">The report parameter.</param> /// <param name="oRsTool">The o rs tool.</param> /// <returns> /// IList<B01HModel>. /// </returns> public IList <B01HModel> GetReportB01H(ReportParameter reportParameter, ReportSharpHelper oRsTool) { try { IList <B01HModel> list = null; var amountType = GlobalVariable.AmountTypeViewReport; var currencyCode = GlobalVariable.CurrencyViewReport; var reportDate = GlobalVariable.PostedDate; GlobalVariable.IsDisplayNewLicenseInfo = false; var ReportID = ""; var accountingBooksType = GlobalVariable.AccountingBooksType; switch (accountingBooksType) { case 0: ReportID = "S03-H"; break; case 1: ReportID = "S01-H"; break; case 2: ReportID = "S02c-H"; break; case 3: ReportID = "S03-H"; break; } if (!oRsTool.IsRefresh) { using (var frmParam = new FrmB01H()) { if (frmParam.ShowDialog() == DialogResult.OK) { var startDate = new DateTime(DateTime.Parse(frmParam.FromDate).Year, 1, 1); var fromDate = DateTime.Parse(frmParam.FromDate); var toDate = DateTime.Parse(frmParam.ToDate); var budgetSourceId = frmParam.BudgetSourceId; var budgetChapterCode = frmParam.BudgetChapterCode; var budgetSubKindItem = frmParam.BudgetSubKindItemCode; var iAccountGrade = frmParam.AccountGrade; var isSummarySource = frmParam.IsSummarySource; var isSummaryChapter = string.IsNullOrEmpty(budgetChapterCode); var isSummarySubKindItem = string.IsNullOrEmpty(budgetSubKindItem); var pIsPrintMonth13 = frmParam.IsPrintMonth13; var pIsAddDataMonth13 = frmParam.IsAddDataMonth13; var pIsPrintAccountDetailByBudgetSource = frmParam.IsSummarySource; var pIsPrintAccountDecided = frmParam.IsPrintAccountDecided; list = Model.GetReportB01H(startDate, fromDate, toDate, budgetSourceId, budgetChapterCode, budgetSubKindItem, iAccountGrade, isSummarySource, isSummaryChapter, isSummarySubKindItem, pIsPrintMonth13, pIsAddDataMonth13, pIsPrintAccountDetailByBudgetSource, pIsPrintAccountDecided, amountType, currencyCode); if (list != null && list.Count > 0) { foreach (var obj in list.ToList()) { if (obj.ClosingCredit == 0 && obj.ClosingDebit == 0 && obj.MovementAccumCredit == 0 && obj.MovementAccumDebit == 0 && obj.MovementCredit == 0 && obj.MovementDebit == 0 && obj.OpeningCredit == 0 && obj.OpeningDebit == 0) { list.Remove(obj); } } if (!oRsTool.Parameters.ContainsKey("IsPrintMonth13")) { var isPrintMonth13 = pIsPrintMonth13 ? "Tháng chỉnh lý quyết toán" : ConvertDateToStringForReport(fromDate, toDate); oRsTool.Parameters.Add("IsPrintMonth13", isPrintMonth13); } if (!oRsTool.Parameters.ContainsKey("IsSummaryBudgetChapterCode")) { oRsTool.Parameters.Add("IsSummaryBudgetChapterCode", isSummaryChapter ? 1 : 0); } if (!oRsTool.Parameters.ContainsKey("CompanyProvince")) { oRsTool.Parameters.Add("CompanyProvince", string.IsNullOrEmpty(GlobalVariable.CompanyProvince) ? string.Empty : GlobalVariable.CompanyProvince); } if (!oRsTool.Parameters.ContainsKey("ReportDate")) { oRsTool.Parameters.Add("ReportDate", reportDate); } if (amountType == 1) { if (!oRsTool.Parameters.ContainsKey("CurrencyCodeUnit")) { oRsTool.Parameters.Add("CurrencyCodeUnit", "Đơn vị tính (qui đổi): " + currencyCode); } } else { if (!oRsTool.Parameters.ContainsKey("CurrencyCodeUnit")) { oRsTool.Parameters.Add("CurrencyCodeUnit", "Đơn vị tính (nguyên tệ): " + currencyCode); } } if (!oRsTool.Parameters.ContainsKey("FromDate")) { oRsTool.Parameters.Add("FromDate", fromDate.ToShortDateString()); } if (!oRsTool.Parameters.ContainsKey("ToDate")) { oRsTool.Parameters.Add("ToDate", toDate.ToShortDateString()); } if (!oRsTool.Parameters.ContainsKey("ReportID")) { oRsTool.Parameters.Add("ReportID", ReportID); } //tài khoản trong bảng var totalOpeningCredit = list.Where(x => x.Grade == 1 && x.AccountCategory == 1).Sum(x => x.OpeningCredit); var totalOpeningDebit = list.Where(x => x.Grade == 1 && x.AccountCategory == 1).Sum(x => x.OpeningDebit); var totalMovementAccumCredit = list.Where(x => x.Grade == 1 && x.AccountCategory == 1).Sum(x => x.MovementAccumCredit); var totalMovementAccumDebit = list.Where(x => x.Grade == 1 && x.AccountCategory == 1).Sum(x => x.MovementAccumDebit); var totalMovementCredit = list.Where(x => x.Grade == 1 && x.AccountCategory == 1).Sum(x => x.MovementCredit); var totalMovementDebit = list.Where(x => x.Grade == 1 && x.AccountCategory == 1).Sum(x => x.MovementDebit); var totalClosingCredit = list.Where(x => x.Grade == 1 && x.AccountCategory == 1).Sum(x => x.ClosingCredit); var totalClosingDebit = list.Where(x => x.Grade == 1 && x.AccountCategory == 1).Sum(x => x.ClosingDebit); //Tài khoản ngoài bảng (AnhNT) var totalOpeningCredit2 = list.Where(x => x.Grade == 1 && x.AccountCategory != 1).Sum(x => x.OpeningCredit); var totalOpeningDebit2 = list.Where(x => x.Grade == 1 && x.AccountCategory != 1).Sum(x => x.OpeningDebit); var totalMovementAccumCredit2 = list.Where(x => x.Grade == 1 && x.AccountCategory != 1).Sum(x => x.MovementAccumCredit); var totalMovementAccumDebit2 = list.Where(x => x.Grade == 1 && x.AccountCategory != 1).Sum(x => x.MovementAccumDebit); var totalMovementCredit2 = list.Where(x => x.Grade == 1 && x.AccountCategory != 1).Sum(x => x.MovementCredit); var totalMovementDebit2 = list.Where(x => x.Grade == 1 && x.AccountCategory != 1).Sum(x => x.MovementDebit); var totalClosingCredit2 = list.Where(x => x.Grade == 1 && x.AccountCategory != 1).Sum(x => x.ClosingCredit); var totalClosingDebit2 = list.Where(x => x.Grade == 1 && x.AccountCategory != 1).Sum(x => x.ClosingDebit); //------------------------------------------- //Parameter tài khoản trong bảng if (!oRsTool.Parameters.ContainsKey("TotalMovementCredit")) { oRsTool.Parameters.Add("TotalMovementCredit", totalMovementCredit == 0 ? 0 : totalMovementCredit); } if (!oRsTool.Parameters.ContainsKey("TotalMovementDebit")) { oRsTool.Parameters.Add("TotalMovementDebit", totalMovementDebit == 0 ? 0 : totalMovementDebit); } if (!oRsTool.Parameters.ContainsKey("TotalClosingCredit")) { oRsTool.Parameters.Add("TotalClosingCredit", totalClosingCredit == 0 ? 0 : totalClosingCredit); } if (!oRsTool.Parameters.ContainsKey("TotalClosingDebit")) { oRsTool.Parameters.Add("TotalClosingDebit", totalClosingDebit == 0 ? 0 : totalClosingDebit); } if (!oRsTool.Parameters.ContainsKey("TotalOpeningCredit")) { oRsTool.Parameters.Add("TotalOpeningCredit", totalOpeningCredit == 0 ? 0 : totalOpeningCredit); } if (!oRsTool.Parameters.ContainsKey("TotalOpeningDebit")) { oRsTool.Parameters.Add("TotalOpeningDebit", totalOpeningDebit == 0 ? 0 : totalOpeningDebit); } if (!oRsTool.Parameters.ContainsKey("TotalMovementAccumCredit")) { oRsTool.Parameters.Add("TotalMovementAccumCredit", totalMovementAccumCredit == 0 ? 0 : totalMovementAccumCredit); } if (!oRsTool.Parameters.ContainsKey("TotalMovementAccumDebit")) { oRsTool.Parameters.Add("TotalMovementAccumDebit", totalMovementAccumDebit == 0 ? 0 : totalMovementAccumDebit); } //Parameter tài khoản ngoài bảng if (!oRsTool.Parameters.ContainsKey("TotalMovementCredit2")) { oRsTool.Parameters.Add("TotalMovementCredit2", totalMovementCredit2 == 0 ? 0 : totalMovementCredit2); } if (!oRsTool.Parameters.ContainsKey("TotalMovementDebit2")) { oRsTool.Parameters.Add("TotalMovementDebit2", totalMovementDebit2 == 0 ? 0 : totalMovementDebit2); } if (!oRsTool.Parameters.ContainsKey("TotalClosingCredit2")) { oRsTool.Parameters.Add("TotalClosingCredit2", totalClosingCredit2 == 0 ? 0 : totalClosingCredit2); } if (!oRsTool.Parameters.ContainsKey("TotalClosingDebit2")) { oRsTool.Parameters.Add("TotalClosingDebit2", totalClosingDebit2 == 0 ? 0 : totalClosingDebit2); } if (!oRsTool.Parameters.ContainsKey("TotalOpeningCredit2")) { oRsTool.Parameters.Add("TotalOpeningCredit2", totalOpeningCredit2 == 0 ? 0 : totalOpeningCredit2); } if (!oRsTool.Parameters.ContainsKey("TotalOpeningDebit2")) { oRsTool.Parameters.Add("TotalOpeningDebit2", totalOpeningDebit2 == 0 ? 0 : totalOpeningDebit2); } if (!oRsTool.Parameters.ContainsKey("TotalMovementAccumCredit2")) { oRsTool.Parameters.Add("TotalMovementAccumCredit2", totalMovementAccumCredit2 == 0 ? 0 : totalMovementAccumCredit2); } if (!oRsTool.Parameters.ContainsKey("TotalMovementAccumDebit2")) { oRsTool.Parameters.Add("TotalMovementAccumDebit2", totalMovementAccumDebit2 == 0 ? 0 : totalMovementAccumDebit2); } } } } } return(list); } catch (Exception ex) { XtraMessageBox.Show("Lỗi ở chỗ này " + ex.InnerException + ex.Message + ex.StackTrace); return(null); } }