public DataTable DT_getvalueDebit(int FinancialAccountDimId, int YearDimId) { try { DataTable dt = DT_header(); DataTable dt_xp_all = DT_xp_ALL(FinancialAccountDimId, YearDimId, true, true, true, false); if (dt_xp_all == null || dt == null) { return(null); } foreach (DataColumn dc_all in dt_xp_all.Columns) { DataRow dr = dt.NewRow(); CorrespondFinancialAccountDim Corr = BO.get_CorrespondFinancialAccountDim_1(session, int.Parse(dc_all.ColumnName), Utility.Constant.ROWSTATUS_ACTIVE); FinancialGeneralLedgerByYear_Fact FGLY = BO.get_FinancialGeneralLedgerByYear_Fact_1(session, FinancialAccountDimId, YearDimId, Utility.Constant.ROWSTATUS_ACTIVE); #region if (Corr != null) { foreach (DataColumn dc in dt.Columns) { if (dc.ColumnName.Equals("TK")) { dr[dc.ColumnName] = Corr.Code; } if (!dc.ColumnName.Equals("TK")) { for (int i = 1; i <= 12; i++) { if (FGLY != null && dc.ColumnName.Equals(i.ToString())) { FinancialGeneralLedgerByMonth FGLM = BO.get_FinancialGeneralLedgerByMonth_Debit(session, FGLY.FinancialGeneralLedgerByYear_FactId, int.Parse(dc_all.ColumnName), i, Utility.Constant.ROWSTATUS_ACTIVE); MonthDim MD = BO.get_MonthDimId(session, i.ToString(), Utility.Constant.ROWSTATUS_ACTIVE); if (FGLM != null && MD != null) { if (FGLM.DebitSum > 0) { dr[dc.ColumnName] = sumAcc(FGLM.CorrespondFinancialAccountDimId.Code, FGLM.FinancialGeneralLedgerByYear_FactId.FinancialGeneralLedgerByYear_FactId, MD.MonthDimId, false); } else { dr[dc.ColumnName] = 0; } } } } } } dt.Rows.Add(dr); } #endregion } return(dt); } catch (Exception) { return(null); } }
public FinancialGeneralLedgerByMonth get_FinancialGeneralLedgerByMonth(Session session, int FinancialGeneralLedgerByMonthId, short RowStatus) { try { FinancialGeneralLedgerByMonth FGLM = session.FindObject <FinancialGeneralLedgerByMonth>( CriteriaOperator.And( new BinaryOperator("FinancialGeneralLedgerByMonthId", FinancialGeneralLedgerByMonthId, BinaryOperatorType.Equal), new BinaryOperator("RowStatus", RowStatus, BinaryOperatorType.Equal) )); if (FGLM == null) { return(null); } return(FGLM); } catch (Exception) { throw; } }
public FinancialGeneralLedgerByMonth get_FinancialGeneralLedgerByMonth_Debit(Session session, int FinancialGeneralLedgerByYear_FactId, int CorrespondFinancialAccountDimId, int MonthDimId, short RowStatus) { try { FinancialGeneralLedgerByMonth FGLM = session.FindObject <FinancialGeneralLedgerByMonth>( CriteriaOperator.And( new BinaryOperator("FinancialGeneralLedgerByYear_FactId", FinancialGeneralLedgerByYear_FactId, BinaryOperatorType.Equal), new BinaryOperator("CorrespondFinancialAccountDimId", CorrespondFinancialAccountDimId, BinaryOperatorType.Equal), new BinaryOperator("MonthDimId", MonthDimId, BinaryOperatorType.Equal), new BinaryOperator("RowStatus", RowStatus, BinaryOperatorType.Equal), new BinaryOperator("DebitSum", 0, BinaryOperatorType.Greater) )); if (FGLM == null) { return(null); } return(FGLM); } catch (Exception) { throw; } }