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