public FinancialItemInventorySummary_Fact get_FinancialItemInventorySummary_Fact(Session session, int FinancialItemInventorySummary_FactId, short RowStatus)
{
try
{
FinancialItemInventorySummary_Fact FIISF = session.FindObject <FinancialItemInventorySummary_Fact>(
CriteriaOperator.And(
new BinaryOperator("FinancialItemInventorySummary_FactId", FinancialItemInventorySummary_FactId, BinaryOperatorType.Equal),
new BinaryOperator("RowStatus", RowStatus, BinaryOperatorType.Equal)
));
if (FIISF == null)
{
return(null);
}
return(FIISF);
}
catch (Exception) { return(null); }
}
public DataTable DT_getValue(int FinancialAccountDimId, int InventoryDimId, int OwnerOrgDimId, int ItemDimId, int MonthDimId, int YearDimId, int UnitDimId)
{
try
{
int stt = 1;
DataTable dt = DT_header();
DataTable dt_xp_FIISF = DT_xp_getValue(FinancialAccountDimId, InventoryDimId, OwnerOrgDimId, ItemDimId, UnitDimId, MonthDimId, YearDimId, true, false);
CorrespondFinancialAccountDim CFAD = BO.get_CorrespondFinancialAccountDim(session, "NAAN_DEFAULT", Utility.Constant.ROWSTATUS_ACTIVE);
if (dt_xp_FIISF != null && dt != null && CFAD != null)
{
DataRow dr = dt.NewRow();
#region (1)
foreach (DataColumn dc in dt.Columns)
{
foreach (DataColumn dc_FII in dt_xp_FIISF.Columns)
{
FinancialItemInventorySummary_Fact FIIS = BO.get_FinancialItemInventorySummary_Fact(session, int.Parse(dc_FII.ColumnName.ToString()), Utility.Constant.ROWSTATUS_ACTIVE);
if (dc.ColumnName.Equals("STT"))
{
dr[dc.ColumnName] = stt;
}
if (dc.ColumnName.Equals("diengiai"))
{
dr[dc.ColumnName] = "Số dư đầu tháng";
}
if (dc.ColumnName.Equals("soluongT"))
{
dr[dc.ColumnName] = FIIS.BeginBalanceItem;
}
if (dc.ColumnName.Equals("thanhtienT"))
{
dr[dc.ColumnName] = FIIS.BeginDebitBalance;
}
}
}
dt.Rows.Add(dr);
stt++;
#endregion
#region (2)
foreach (DataColumn dc_all in dt_xp_FIISF.Columns)
{
DataTable dt_xp_IIBA = DT_getInventoryCommandDimId(int.Parse(dc_all.ColumnName.ToString()));
if (dt_xp_IIBA != null)
{
foreach (DataColumn dt_IIBA in dt_xp_IIBA.Columns)
{
XPCollection <ItemInventoryByArtifact> IIBA_xp = BO.get_xp_InventoryByArtifact_1(session, int.Parse(dc_all.ColumnName.ToString()), int.Parse(dt_IIBA.ColumnName.ToString()), Utility.Constant.ROWSTATUS_ACTIVE);
if (IIBA_xp != null)
{
foreach (ItemInventoryByArtifact IIBA in IIBA_xp)
{
if (!IIBA.CorrespondFinancialAccountDimId.CorrespondFinancialAccountDimId.Equals(CFAD.CorrespondFinancialAccountDimId))
{
dr = dt.NewRow();
foreach (DataColumn dc in dt.Columns)
{
if (dc.ColumnName.Equals("STT"))
{
dr[dc.ColumnName] = stt;
}
if (dc.ColumnName.Equals("sohieu"))
{
dr[dc.ColumnName] = IIBA.InventoryCommandDimId.Code;
}
if (dc.ColumnName.Equals("ngaythang"))
{
dr[dc.ColumnName] = String.Format("{0:d}", IIBA.InventoryCommandDimId.IssueDate);
}
if (dc.ColumnName.Equals("diengiai"))
{
dr[dc.ColumnName] = IIBA.InventoryCommandDimId.Description;
}
if (dc.ColumnName.Equals("taikhoandoixung"))
{
dr[dc.ColumnName] = IIBA.CorrespondFinancialAccountDimId.Code;
}
if (dc.ColumnName.Equals("dongia"))
{
dr[dc.ColumnName] = IIBA.Price;
}
if (IIBA.CreditItemSum > 0)
{
if (dc.ColumnName.Equals("soluongN"))
{
dr[dc.ColumnName] = IIBA.CreditItemSum;
}
if (dc.ColumnName.Equals("thanhtienN"))
{
dr[dc.ColumnName] = IIBA.CreditSum;
}
}
if (IIBA.DebitItemSum > 0)
{
if (dc.ColumnName.Equals("soluongX"))
{
dr[dc.ColumnName] = IIBA.DebitItemSum;
}
if (dc.ColumnName.Equals("thanhtienX"))
{
dr[dc.ColumnName] = IIBA.DebitSum;
}
}
if (dc.ColumnName.Equals("soluongT"))
{
dr[dc.ColumnName] = IIBA.CurrentBalanceItem;
}
if (dc.ColumnName.Equals("thanhtienT"))
{
dr[dc.ColumnName] = IIBA.CurrentBalance;
}
}
dt.Rows.Add(dr);
stt++;
}
}
}
}
}
}
#endregion
#region (3)
dr = dt.NewRow();
foreach (DataColumn dc in dt.Columns)
{
foreach (DataColumn dc_FII in dt_xp_FIISF.Columns)
{
FinancialItemInventorySummary_Fact FIIS = BO.get_FinancialItemInventorySummary_Fact(session, int.Parse(dc_FII.ColumnName.ToString()), Utility.Constant.ROWSTATUS_ACTIVE);
if (dc.ColumnName.Equals("STT"))
{
dr[dc.ColumnName] = stt;
}
if (dc.ColumnName.Equals("diengiai"))
{
dr[dc.ColumnName] = "Số dư cuối tháng";
}
if (dc.ColumnName.Equals("soluongT"))
{
dr[dc.ColumnName] = FIIS.EndBalanceItem;
}
if (dc.ColumnName.Equals("thanhtienT"))
{
dr[dc.ColumnName] = FIIS.EndDebitBalance;
}
}
}
dt.Rows.Add(dr);
#endregion
}
return(dt);
}
catch (Exception) { return(null); }
}
