public void LoadData()
{
WebModule.Accounting.Report.S04a6_DN s04a6_dn = new WebModule.Accounting.Report.S04a6_DN();
string FinancialAccountDim_Code = "151";
int MonthDim = Int32.Parse(this.hs04a6dnMonth.Get("month_Name").ToString());
int YearDim = Int32.Parse(this.hs04a6dnYear.Get("year_Name").ToString());
string OwnerOrgDim = "QUASAPHARCO";
#region get value
FinancialAccountDim FAD = BO.get_FinancialAccountDim(session, FinancialAccountDim_Code, Utility.Constant.ROWSTATUS_ACTIVE);
MonthDim MD = BO.get_MonthDimId(session, MonthDim.ToString(), Utility.Constant.ROWSTATUS_ACTIVE);
YearDim YD = BO.get_YearDimId(session, YearDim.ToString(), Utility.Constant.ROWSTATUS_ACTIVE);
OwnerOrgDim OOD = BO.get_OwnerOrgDimId(session, OwnerOrgDim, Utility.Constant.ROWSTATUS_ACTIVE);
if (FAD == null || MD == null || YD == null || OOD == null)
{
return;
}
#endregion
s04a6_dn.lblMonth.Text = MD.Name;
s04a6_dn.lblYear.Text = YD.Name;
try
{
#region tao cac cot header table
Gridview_header(FAD.FinancialAccountDimId, OOD.OwnerOrgDimId, MD.MonthDimId, YD.YearDimId);
DataTable dt = DT_Header(FAD.FinancialAccountDimId, OOD.OwnerOrgDimId, MD.MonthDimId, YD.YearDimId);
#endregion
#region tao dong STT ngang cho tung cot
DT_STT(dt);
#endregion
#region do du lieu vao DataTable
DT_getRowValue(dt, FAD.FinancialAccountDimId, OOD.OwnerOrgDimId, MD.MonthDimId, YD.YearDimId);
#endregion
#region BindData vao GridView
xGridView.DataSource = dt;
xGridView.DataBind();
#endregion
}
catch (Exception) { }
#region xuat report
GridViewExporter.GridViewID = "xGridView";
s04a6_dn.printableCC.PrintableComponent = new PrintableComponentLinkBase()
{
Component = GridViewExporter
};
ReportViewers04a6.Report = s04a6_dn;
#endregion
}
public void LoadDiaryJournal(Session session, DJ_Fact DiaryJournalFact)
{
try
{
//Get OwnerOrgDim => ownerOrgDim
#region OwnerOrgDim
Organization ownerOrg = session.GetObjectByKey <Organization>(DiaryJournalFact.OwnerOrg);
if (DiaryJournalFact.OwnerOrg == Guid.Empty || ownerOrg == null)
{
CriteriaOperator criteria_RowStatus = new BinaryOperator("RowStatus", Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.GreaterOrEqual);
CriteriaOperator criteria_Code = new BinaryOperator("Code", "QUASAPHARCO", BinaryOperatorType.Equal);
CriteriaOperator criteria = CriteriaOperator.And(criteria_Code, criteria_RowStatus);
OwnerOrgDim ownerOrgDim = session.FindObject <OwnerOrgDim>(criteria);
}
else
{
CriteriaOperator criteria_RowStatus = new BinaryOperator("RowStatus", Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.GreaterOrEqual);
CriteriaOperator criteria_RefId = new BinaryOperator("RefId", ownerOrg.OrganizationId, BinaryOperatorType.Equal);
CriteriaOperator criteria = CriteriaOperator.And(criteria_RefId, criteria_RowStatus);
OwnerOrgDim ownerOrgDim = session.FindObject <OwnerOrgDim>(criteria);
if (ownerOrgDim == null)
{
ownerOrgDim = new OwnerOrgDim(session);
ownerOrgDim.Code = ownerOrg.Code;
ownerOrgDim.Description = ownerOrg.Description;
ownerOrgDim.Name = ownerOrg.Name;
ownerOrgDim.RefId = ownerOrg.OrganizationId;
ownerOrgDim.RowStatus = Constant.ROWSTATUS_ACTIVE;
ownerOrgDim.Save();
}
}
#endregion
//Get MonthDim
#region MonthDim
#endregion
//Get YearDim
#region YearDim
#endregion
//Get FinancialAccountDim
#region FinancialAccountDim
#endregion
//Find Exist Fact
#region Find Fact
#endregion
//If Exist
#region Exist Fact
#endregion
//If Not Exist
#region Not Exist Fact
#endregion
}
catch (Exception)
{
return;
}
}
// danh sách cột gridview
public List <string> column_gridview()
{
List <string> column_gridview = new List <string>();
#region tham số truyền
int month = Int32.Parse(this.hS04b3DN_month.Get("month_id").ToString());
int year = Int32.Parse(this.hS04b3DN_year.Get("year_id").ToString());
string owner = "QUASAPHARCO";
#endregion
#region Id
MonthDim MonthDimId = session.FindObject <MonthDim>(CriteriaOperator.Parse(String.Format("Name='{0}'", month)));
YearDim YearDimId = session.FindObject <YearDim>(CriteriaOperator.Parse(String.Format("Name='{0}'", year)));
OwnerOrgDim OwnerOrgDimId = session.FindObject <OwnerOrgDim>(CriteriaOperator.Parse(String.Format("Code='{0}'", owner)));
#endregion
XPCollection <FinancialActualPriceSummary_Fact> collec_fact =
new XPCollection <FinancialActualPriceSummary_Fact>(session, CriteriaOperator.Parse(
String.Format("MonthDimId='{0}' AND "
+ "YearDimId='{1}' AND "
+ "OwnerOrgDimId='{2}' AND "
+ "RowStatus='1'",
MonthDimId.MonthDimId,
YearDimId.YearDimId,
OwnerOrgDimId.OwnerOrgDimId
)));
if (collec_fact.Count != 0)
{
foreach (FinancialActualPriceSummary_Fact each_fact in collec_fact)
{
if (each_fact.FinancialAccountDimId.Code != "152" &&
each_fact.FinancialAccountDimId.Code.Substring(0, 3) == "152")
{
if (!column_gridview.Contains(each_fact.FinancialAccountDimId.Code))
{
column_gridview.Add(each_fact.FinancialAccountDimId.Code);
}
}
if (each_fact.FinancialAccountDimId.Code != "153" &&
each_fact.FinancialAccountDimId.Code.Substring(0, 3) == "153")
{
if (!column_gridview.Contains(each_fact.FinancialAccountDimId.Code))
{
column_gridview.Add(each_fact.FinancialAccountDimId.Code);
}
}
}
}
column_gridview.Sort();
return(column_gridview);
}
public FinancialSupplierLiabilitySummary_Fact GetFinnancialSupplierLiabilitySummaryFact(
Session session,
Guid OwnerOrgId,
Guid SupplierOrgId,
DateTime IssueDate,
string FinancialAccountCode)
{
FinancialSupplierLiabilitySummary_Fact result = null;
try
{
Util util = new Util();
OwnerOrgDim ownerOrgDim = util.GetXpoObjectByFieldName <OwnerOrgDim, Guid>(session, "RefId", OwnerOrgId, BinaryOperatorType.Equal);
SupplierOrgDim supplierOrgDim = util.GetXpoObjectByFieldName <SupplierOrgDim, Guid>(session, "RefId", SupplierOrgId, BinaryOperatorType.Equal);
MonthDim monthDim = util.GetXpoObjectByFieldName <MonthDim, string>(session, "Name", IssueDate.Month.ToString(), BinaryOperatorType.Equal);
YearDim yearDim = util.GetXpoObjectByFieldName <YearDim, string>(session, "Name", IssueDate.Year.ToString(), BinaryOperatorType.Equal);
FinancialAccountDim financialAccountDim = util.GetXpoObjectByFieldName <FinancialAccountDim, string>(session, "Code", FinancialAccountCode, BinaryOperatorType.Equal);
if (ownerOrgDim == null || supplierOrgDim == null || monthDim == null || yearDim == null || financialAccountDim == null)
{
return(null);
}
else
{
FinancialSupplierLiabilitySummary_Fact a = null;
CriteriaOperator criteria_RowStatus = new BinaryOperator("RowStatus", Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.GreaterOrEqual);
CriteriaOperator criteria_OwnerOrg = new BinaryOperator("OwnerOrgDimId", ownerOrgDim, BinaryOperatorType.Equal);
CriteriaOperator criteria_SupplierOrg = new BinaryOperator("SupplierOrgDimId", supplierOrgDim, BinaryOperatorType.Equal);
CriteriaOperator criteria_Month = new BinaryOperator("MonthDimId", monthDim, BinaryOperatorType.Equal);
CriteriaOperator criteria_Year = new BinaryOperator("YearDimId", yearDim, BinaryOperatorType.Equal);
CriteriaOperator criteria_AccountCode = new BinaryOperator("FinancialAccountDimId", financialAccountDim, BinaryOperatorType.Equal);
CriteriaOperator criteria = CriteriaOperator.And(criteria_RowStatus, criteria_OwnerOrg, criteria_SupplierOrg, criteria_Month, criteria_Year, criteria_AccountCode);
FinancialSupplierLiabilitySummary_Fact fact = session.FindObject <FinancialSupplierLiabilitySummary_Fact>(criteria);
if (fact == null)
{
return(null);
}
{
result = fact;
}
}
}
catch (Exception)
{
return(result);
}
return(result);
}
public OwnerOrgDim get_OwnerOrgDim(Session session, string Code, short RowStatus)
{
try
{
OwnerOrgDim OOD = session.FindObject <OwnerOrgDim>(
CriteriaOperator.And(
new BinaryOperator("Code", Code, BinaryOperatorType.Equal),
new BinaryOperator("RowStatus", RowStatus, BinaryOperatorType.Equal)
));
if (OOD == null)
{
return(null);
}
return(OOD);
}
catch (Exception) { return(null); }
}
public OwnerOrgDim GetOwnerOrgDim(Session session, Guid RefId)
{
try
{
CriteriaOperator criteria_RowStaus = new BinaryOperator("RowStatus", Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.Equal);
CriteriaOperator criteria_RefId = new BinaryOperator("RefId", RefId, BinaryOperatorType.Equal);
CriteriaOperator criteria = CriteriaOperator.And(criteria_RefId, criteria_RowStaus);
OwnerOrgDim ownerOrgDim = session.FindObject <OwnerOrgDim>(criteria);
if (ownerOrgDim == null)
{
return(CreateOwnerOrgDim(session, RefId));
}
return(ownerOrgDim);
}
catch
{
return(null);
}
}
private FinancialSalesOrManufactureExpenseSummary_Fact GetFinancialSalesOrManufactureExpenseSummary(
Session session,
Guid OwnerOrgId,
DateTime IssueDate
)
{
FinancialSalesOrManufactureExpenseSummary_Fact result = null;
try
{
Util util = new Util();
OwnerOrgDim ownerOrgDim = util.GetXpoObjectByFieldName <OwnerOrgDim, Guid>(session, "RefId", OwnerOrgId, BinaryOperatorType.Equal);
MonthDim monthDim = util.GetXpoObjectByFieldName <MonthDim, string>(session, "Name", IssueDate.Month.ToString(), BinaryOperatorType.Equal);
YearDim yearDim = util.GetXpoObjectByFieldName <YearDim, string>(session, "Name", IssueDate.Year.ToString(), BinaryOperatorType.Equal);
if (ownerOrgDim == null || monthDim == null || yearDim == null)
{
return(null);
}
else
{
CriteriaOperator criteria_RowStatus = new BinaryOperator("RowStatus", Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.GreaterOrEqual);
CriteriaOperator criteria_OwnerOrg = new BinaryOperator("OwnerOrgDimId", ownerOrgDim, BinaryOperatorType.Equal);
CriteriaOperator criteria_Month = new BinaryOperator("MonthDimId", monthDim, BinaryOperatorType.Equal);
CriteriaOperator criteria_Year = new BinaryOperator("YearDimId", yearDim, BinaryOperatorType.Equal);
CriteriaOperator criteria = CriteriaOperator.And(criteria_RowStatus, criteria_OwnerOrg, criteria_Month, criteria_Year);
FinancialSalesOrManufactureExpenseSummary_Fact fact = session.FindObject <FinancialSalesOrManufactureExpenseSummary_Fact>(criteria);
if (fact == null)
{
return(null);
}
result = fact;
}
}
catch (Exception)
{
return(result);
}
return(result);
}
public FinancialOnTheWayBuyingGoodSummary CreateFinancialOnTheWayBuyingGoodSummary(Session session,
Guid OwnerOrgId,
DateTime IssueDate,
string FinancialAccountCode)
{
FinancialOnTheWayBuyingGoodSummary result = new FinancialOnTheWayBuyingGoodSummary(session);
try
{
ETLAccountingBO accountingBO = new ETLAccountingBO();
FinancialAccountDim accountDim = accountingBO.GetFinancialAccountDim(session, FinancialAccountCode);
DimBO dimBO = new DimBO();
MonthDim monthDim = dimBO.GetMonthDim(session, (short)IssueDate.Month);
YearDim yearDim = dimBO.GetYearDim(session, (short)IssueDate.Year);
OwnerOrgDim ownOrgDim = dimBO.GetOwnerOrgDim(session, OwnerOrgId);
result.BeginBalance = 0;
result.FinancialAccountDimId = accountDim != null ? accountDim : accountingBO.CreateFinancialAccountDim(session, FinancialAccountCode);
result.MonthDimId = monthDim != null ? monthDim : dimBO.CreateMonthDim(session, (short)IssueDate.Month);
result.YearDimId = yearDim != null ? yearDim : dimBO.CreateYearDim(session, (short)IssueDate.Year);
result.OwnerOrgDimId = ownOrgDim != null ? ownOrgDim : dimBO.CreateOwnerOrgDim(session, OwnerOrgId);
result.RowStatus = Constant.ROWSTATUS_ACTIVE;
if (result.FinancialAccountDimId == null || result.MonthDimId == null || result.YearDimId == null || result.OwnerOrgDimId == null)
{
return(null);
}
var date = new DateTime(IssueDate.Year, IssueDate.Month, 1);
FinancialOnTheWayBuyingGoodSummary previousSummary = GetFinancialOnTheWayBuyingGoodSummary(session,
OwnerOrgId, date.AddMonths(-1), FinancialAccountCode);
if (previousSummary != null)
{
result.BeginBalance = previousSummary.EndBalance;
}
result.Save();
return(result);
}
catch (Exception)
{
return(null);
}
}
//TK header (f & c)
public List <string> list_header()
{
#region tham số truyền
int month = Int32.Parse(this.hS04b4DN_month.Get("month_id").ToString());
int year = Int32.Parse(this.hS04b4DN_year.Get("year_id").ToString());
string owner = "QUASAPHARCO";
//string asset = "";
#endregion
List <string> list_header = new List <string>();
MonthDim md = session.FindObject <MonthDim>(CriteriaOperator.Parse(String.Format("Name='{0}'", month)));
YearDim yd = session.FindObject <YearDim>(CriteriaOperator.Parse(String.Format("Name='{0}'", year)));
OwnerOrgDim ood = session.FindObject <OwnerOrgDim>(CriteriaOperator.Parse(String.Format("Code='{0}'",
owner)));
int CorrespondFinancialAccountDimId_default = CorrespondFinancialAccountDim.GetDefault(session,
CorrespondFinancialAccountDimEnum.NAAN_DEFAULT).CorrespondFinancialAccountDimId;
if (md != null && yd != null && ood != null)
{
// chung
FinancialSalesOrManufactureExpenseSummary_Fact FinancialFact_General =
session.FindObject <FinancialSalesOrManufactureExpenseSummary_Fact>(
CriteriaOperator.Parse(String.Format("MonthDimId='{0}' AND YearDimId='{1}' AND "
+ "OwnerOrgDimId='{2}' AND RowStatus='1'",
md.MonthDimId,
yd.YearDimId,
ood.OwnerOrgDimId)));
// 154 621 622 623 627 631
support_list_header("154", FinancialFact_General, CorrespondFinancialAccountDimId_default, list_header);
support_list_header("621", FinancialFact_General, CorrespondFinancialAccountDimId_default, list_header);
support_list_header("622", FinancialFact_General, CorrespondFinancialAccountDimId_default, list_header);
support_list_header("623", FinancialFact_General, CorrespondFinancialAccountDimId_default, list_header);
support_list_header("627", FinancialFact_General, CorrespondFinancialAccountDimId_default, list_header);
support_list_header("631", FinancialFact_General, CorrespondFinancialAccountDimId_default, list_header);
//
}
list_header.Sort();
return(list_header);
}
public OwnerOrgDim CreateOwnerOrgDim(Session session, Guid RefId)
{
try
{
Organization ownerOrg = session.GetObjectByKey <Organization>(RefId);
if (ownerOrg == null)
{
return(null);
}
OwnerOrgDim ownerOrgDim = new OwnerOrgDim(session);
ownerOrgDim.Code = ownerOrg.Code;
ownerOrgDim.Description = ownerOrg.Description;
ownerOrgDim.RefId = RefId;
ownerOrgDim.Name = ownerOrg.Name;
ownerOrgDim.RowStatus = Constant.ROWSTATUS_ACTIVE;
ownerOrgDim.Save();
return(ownerOrgDim);
}
catch (Exception)
{
return(null);
}
}
public List <string> header_debit_correspond()
{
List <string> debit_correspond = new List <string>();
#region tham số
int month = Int32.Parse(this.hS04b6DN_month.Get("month_id").ToString());
int year = Int32.Parse(this.hS04b6DN_year.Get("year_id").ToString());
string owner = "QUASAPHARCO";
string fAccount = this.hS04b6dnAccount.Get("account_id").ToString();
#endregion
#region object
MonthDim md = session.FindObject <MonthDim>(CriteriaOperator.Parse(String.Format("Name='{0}'", month)));
YearDim yd = session.FindObject <YearDim>(CriteriaOperator.Parse(String.Format("Name='{0}'", year)));
OwnerOrgDim ood = session.FindObject <OwnerOrgDim>(CriteriaOperator.Parse(String.Format("Code='{0}'",
owner)));
int CorrespondFinancialAccountDimId_default = CorrespondFinancialAccountDim.GetDefault(session,
CorrespondFinancialAccountDimEnum.NAAN_DEFAULT).CorrespondFinancialAccountDimId;
string rowStatusActive = Utility.Constant.ROWSTATUS_ACTIVE.ToString();
#endregion
//// tk 142
XPCollection <FinancialAccountDim> f_c_FinancialAccountDim = new XPCollection <FinancialAccountDim>(session,
CriteriaOperator.Parse(String.Format("Code like '{0}%' AND RowStatus='{1}'", fAccount, rowStatusActive)));
if (f_c_FinancialAccountDim.Count != 0)
{
foreach (FinancialAccountDim each_tk in f_c_FinancialAccountDim)
{
if (md != null && yd != null && ood != null)
{
FinancialPrepaidExpenseSummary_Fact FinancialSummary_Fact =
session.FindObject <FinancialPrepaidExpenseSummary_Fact>(CriteriaOperator.Parse(
String.Format("MonthDimId='{0}' AND "
+ "YearDimId='{1}' AND "
+ "OwnerOrgDimId='{2}' AND "
+ "FinancialAccountDimId='{3}' AND "
+ "RowStatus='{4}'",
md.MonthDimId,
yd.YearDimId,
ood.OwnerOrgDimId,
each_tk.FinancialAccountDimId,
rowStatusActive
)));
if (FinancialSummary_Fact != null)
{
XPCollection <FinancialPrepaidExpenseDetail> collec_detail =
new XPCollection <FinancialPrepaidExpenseDetail>(session, CriteriaOperator.Parse(
String.Format("FinancialPrepaidExpenseSummary_FactId='{0}' AND "
+ "Debit>0 AND "
+ "CorrespondFinancialAccountDimId!='{1}' AND "
+ "RowStatus='{2}'",
FinancialSummary_Fact.FinancialPrepaidExpenseSummary_FactId,
CorrespondFinancialAccountDimId_default,
rowStatusActive
)));
if (collec_detail.Count != 0)
{
foreach (FinancialPrepaidExpenseDetail each_detail in collec_detail)
{
if (!debit_correspond.Contains(each_detail.CorrespondFinancialAccountDimId.Code))
{
debit_correspond.Add(each_detail.CorrespondFinancialAccountDimId.Code);
}
}
}
}
}
}
}
////
debit_correspond.Sort();
return(debit_correspond);
}
public void load_data()
{
WebModule.Accounting.Report.S04b6_DN s04b6_dn = new Report.S04b6_DN();
#region tham số truyền
int month = Int32.Parse(this.hS04b6DN_month.Get("month_id").ToString());
int year = Int32.Parse(this.hS04b6DN_year.Get("year_id").ToString());
string owner = "QUASAPHARCO";
string fAccount = this.hS04b6dnAccount.Get("account_id").ToString();
//string asset = "";
#endregion
if (fAccount != "142" && fAccount != "242" && fAccount != "335")
{
return;
}
s04b6_dn.xrMonth.Text = month.ToString();
s04b6_dn.xrYear.Text = year.ToString();
if (fAccount == "142" || fAccount == "242")
{
s04b6_dn.xrTitle.Text = String.Format("Tập hợp chi phí trả trước (TK {0})", fAccount);
}
if (fAccount == "335")
{
s04b6_dn.xrTitle.Text = String.Format("Tập hợp chi phí phải trả (TK {0})", fAccount);
}
try
{
#region object
MonthDim md = session.FindObject <MonthDim>(CriteriaOperator.Parse(String.Format("Name='{0}'", month)));
YearDim yd = session.FindObject <YearDim>(CriteriaOperator.Parse(String.Format("Name='{0}'", year)));
OwnerOrgDim ood = session.FindObject <OwnerOrgDim>(CriteriaOperator.Parse(String.Format("Code='{0}'",
owner)));
int CorrespondFinancialAccountDimId_default = CorrespondFinancialAccountDim.GetDefault(session,
CorrespondFinancialAccountDimEnum.NAAN_DEFAULT).CorrespondFinancialAccountDimId;
string rowStatusActive = Utility.Constant.ROWSTATUS_ACTIVE.ToString();
XPCollection <FinancialAccountDim> f_c_FinancialAccountDim = new XPCollection <FinancialAccountDim>(session,
CriteriaOperator.Parse(String.Format("Code like '{0}%' AND RowStatus='{1}'", fAccount, rowStatusActive)));
#endregion
#region header và table báo cáo
grid_header();
DataTable datatable = table_pri();
#endregion
#region all row list_transaction
List <int> list_transaction = new List <int>();
if (f_c_FinancialAccountDim.Count != 0)
{
foreach (FinancialAccountDim each_tk in f_c_FinancialAccountDim)
{
if (md != null && yd != null && ood != null)
{
FinancialPrepaidExpenseSummary_Fact FinancialSummary_Fact =
session.FindObject <FinancialPrepaidExpenseSummary_Fact>(CriteriaOperator.Parse(
String.Format("MonthDimId='{0}' AND "
+ "YearDimId='{1}' AND "
+ "OwnerOrgDimId='{2}' AND "
+ "FinancialAccountDimId='{3}' AND "
+ "RowStatus='{4}'",
md.MonthDimId,
yd.YearDimId,
ood.OwnerOrgDimId,
each_tk.FinancialAccountDimId,
rowStatusActive
)));
if (FinancialSummary_Fact != null)
{
////
XPCollection <FinancialPrepaidExpenseDetail> collec_detail_credit =
new XPCollection <FinancialPrepaidExpenseDetail>(session, CriteriaOperator.Parse(
String.Format("FinancialPrepaidExpenseSummary_FactId='{0}' AND "
+ "Credit>0 AND "
+ "CorrespondFinancialAccountDimId!='{1}' AND "
+ "RowStatus='{2}'",
FinancialSummary_Fact.FinancialPrepaidExpenseSummary_FactId,
CorrespondFinancialAccountDimId_default,
rowStatusActive
)));
if (collec_detail_credit.Count != 0)
{
foreach (FinancialPrepaidExpenseDetail each_detail in collec_detail_credit)
{
if (!list_transaction.Contains(each_detail.FinancialTransactionDimId.FinancialTransactionDimId))
{
list_transaction.Add(each_detail.FinancialTransactionDimId.FinancialTransactionDimId);
}
}
}
////
XPCollection <FinancialPrepaidExpenseDetail> collec_detail_debit =
new XPCollection <FinancialPrepaidExpenseDetail>(session, CriteriaOperator.Parse(
String.Format("FinancialPrepaidExpenseSummary_FactId='{0}' AND "
+ "Debit>0 AND "
+ "CorrespondFinancialAccountDimId!='{1}' AND "
+ "RowStatus='{2}'",
FinancialSummary_Fact.FinancialPrepaidExpenseSummary_FactId,
CorrespondFinancialAccountDimId_default,
rowStatusActive
)));
if (collec_detail_debit.Count != 0)
{
foreach (FinancialPrepaidExpenseDetail each_detail in collec_detail_debit)
{
if (!list_transaction.Contains(each_detail.FinancialTransactionDimId.FinancialTransactionDimId))
{
list_transaction.Add(each_detail.FinancialTransactionDimId.FinancialTransactionDimId);
}
}
}
}
}
}
}
#endregion
#region đổ dữ liệu
#region dòng số dư đầu tháng
DataRow dr = datatable.NewRow();
dr["dien_giai"] = "Kỳ trước chuyển sang";
double no_dau = 0, co_dau = 0;
if (f_c_FinancialAccountDim.Count != 0)
{
foreach (FinancialAccountDim each_tk in f_c_FinancialAccountDim)
{
if (md != null && yd != null && ood != null)
{
FinancialPrepaidExpenseSummary_Fact FinancialSummary_Fact =
session.FindObject <FinancialPrepaidExpenseSummary_Fact>(CriteriaOperator.Parse(
String.Format("MonthDimId='{0}' AND "
+ "YearDimId='{1}' AND "
+ "OwnerOrgDimId='{2}' AND "
+ "FinancialAccountDimId='{3}' AND "
+ "RowStatus='{4}'",
md.MonthDimId,
yd.YearDimId,
ood.OwnerOrgDimId,
each_tk.FinancialAccountDimId,
rowStatusActive
)));
if (FinancialSummary_Fact != null)
{
no_dau += (double)FinancialSummary_Fact.BeginDebitBalance;
co_dau += (double)FinancialSummary_Fact.BeginCreditBalance;
}
}
}
}
dr["no_dau"] = no_dau;
dr["co_dau"] = co_dau;
datatable.Rows.Add(dr);
#endregion
int STTu = 1;
// từng dòng
foreach (int each_row in list_transaction)
{
#region
FinancialTransactionDim transaction = session.FindObject <FinancialTransactionDim>(
CriteriaOperator.Parse(String.Format("FinancialTransactionDimId='{0}' AND "
+ "RowStatus='{1}'",
each_row,
rowStatusActive
)));
//
dr = datatable.NewRow();
dr["stt"] = STTu++;
dr["dien_giai"] = transaction.Description;
#endregion
//từng cột
#region credit correspond
double cong_no = 0;
foreach (string header_column in header_credit_correspond())
{
double cell = 0;
//
CorrespondFinancialAccountDim CorrespondId = session.FindObject <CorrespondFinancialAccountDim>(
CriteriaOperator.Parse(String.Format("Code='{0}'", header_column)));
//
if (f_c_FinancialAccountDim.Count != 0)
{
foreach (FinancialAccountDim each_tk in f_c_FinancialAccountDim)
{
if (md != null && yd != null && ood != null)
{
FinancialPrepaidExpenseSummary_Fact FinancialSummary_Fact =
session.FindObject <FinancialPrepaidExpenseSummary_Fact>(CriteriaOperator.Parse(
String.Format("MonthDimId='{0}' AND "
+ "YearDimId='{1}' AND "
+ "OwnerOrgDimId='{2}' AND "
+ "FinancialAccountDimId='{3}' AND "
+ "RowStatus='{4}'",
md.MonthDimId,
yd.YearDimId,
ood.OwnerOrgDimId,
each_tk.FinancialAccountDimId,
rowStatusActive
)));
if (FinancialSummary_Fact != null)
{
XPCollection <FinancialPrepaidExpenseDetail> collec_detail_credit =
new XPCollection <FinancialPrepaidExpenseDetail>(session, CriteriaOperator.Parse(
String.Format("FinancialPrepaidExpenseSummary_FactId='{0}' AND "
+ "Credit>0 AND "
+ "CorrespondFinancialAccountDimId!='{1}' AND "
+ "RowStatus='{2}' AND "
+ "FinancialTransactionDimId='{3}' AND "
+ "CorrespondFinancialAccountDimId='{4}'",
FinancialSummary_Fact.FinancialPrepaidExpenseSummary_FactId,
CorrespondFinancialAccountDimId_default,
rowStatusActive,
each_row,
CorrespondId.CorrespondFinancialAccountDimId
)));
if (collec_detail_credit.Count != 0)
{
foreach (FinancialPrepaidExpenseDetail each_detail in collec_detail_credit)
{
cell += (double)each_detail.Credit;
cong_no += (double)each_detail.Credit;
}
}
}
}
}
}
//
dr[header_column + "_co"] = cell;
}
dr["cong_no"] = cong_no;
#endregion
// từng cột
#region debit correspond
double cong_co = 0;
foreach (string header_column in header_debit_correspond())
{
double cell = 0;
//
CorrespondFinancialAccountDim CorrespondId = session.FindObject <CorrespondFinancialAccountDim>(
CriteriaOperator.Parse(String.Format("Code='{0}'", header_column)));
//
if (f_c_FinancialAccountDim.Count != 0)
{
foreach (FinancialAccountDim each_tk in f_c_FinancialAccountDim)
{
if (md != null && yd != null && ood != null)
{
FinancialPrepaidExpenseSummary_Fact FinancialSummary_Fact =
session.FindObject <FinancialPrepaidExpenseSummary_Fact>(CriteriaOperator.Parse(
String.Format("MonthDimId='{0}' AND "
+ "YearDimId='{1}' AND "
+ "OwnerOrgDimId='{2}' AND "
+ "FinancialAccountDimId='{3}' AND "
+ "RowStatus='{4}'",
md.MonthDimId,
yd.YearDimId,
ood.OwnerOrgDimId,
each_tk.FinancialAccountDimId,
rowStatusActive
)));
if (FinancialSummary_Fact != null)
{
XPCollection <FinancialPrepaidExpenseDetail> collec_detail_debit =
new XPCollection <FinancialPrepaidExpenseDetail>(session, CriteriaOperator.Parse(
String.Format("FinancialPrepaidExpenseSummary_FactId='{0}' AND "
+ "Debit>0 AND "
+ "CorrespondFinancialAccountDimId!='{1}' AND "
+ "RowStatus='{2}' AND "
+ "FinancialTransactionDimId='{3}' AND "
+ "CorrespondFinancialAccountDimId='{4}'",
FinancialSummary_Fact.FinancialPrepaidExpenseSummary_FactId,
CorrespondFinancialAccountDimId_default,
rowStatusActive,
each_row,
CorrespondId.CorrespondFinancialAccountDimId
)));
if (collec_detail_debit.Count != 0)
{
foreach (FinancialPrepaidExpenseDetail each_detail in collec_detail_debit)
{
cell += (double)each_detail.Debit;
cong_co += (double)each_detail.Debit;
}
}
}
}
}
}
dr[header_column + "_no"] = cell;
}
dr["cong_co"] = cong_co;
#endregion
datatable.Rows.Add(dr);
}
#endregion
#region dòng cộng
dr = datatable.NewRow();
dr["dien_giai"] = "Tổng cộng";
int column_count = datatable.Columns.Count - 3;
int row_count = datatable.Rows.Count - 1;
for (int c = 2; c <= column_count; c++)
{
double sumT = 0;
for (int r = 1; r <= row_count; r++)
{
double tt;
double.TryParse(datatable.Rows[r][c].ToString(), out tt);
sumT += tt;
}
dr[datatable.Columns[c]] = sumT;
}
//
double no_cuoi = 0;
if (f_c_FinancialAccountDim.Count != 0)
{
foreach (FinancialAccountDim each_tk in f_c_FinancialAccountDim)
{
if (md != null && yd != null && ood != null)
{
FinancialPrepaidExpenseSummary_Fact FinancialSummary_Fact =
session.FindObject <FinancialPrepaidExpenseSummary_Fact>(CriteriaOperator.Parse(
String.Format("MonthDimId='{0}' AND "
+ "YearDimId='{1}' AND "
+ "OwnerOrgDimId='{2}' AND "
+ "FinancialAccountDimId='{3}' AND "
+ "RowStatus='{4}'",
md.MonthDimId,
yd.YearDimId,
ood.OwnerOrgDimId,
each_tk.FinancialAccountDimId,
rowStatusActive
)));
no_cuoi += (double)FinancialSummary_Fact.EndDebitBalance;
}
}
}
//
dr["no_cuoi"] = no_cuoi;
datatable.Rows.Add(dr);
#endregion
#region out gridview
GridView_S04b6DN.DataSource = datatable;
GridView_S04b6DN.DataBind();
#endregion
}
catch { }
#region export report
s04b6_dn.printableCC_S04b6DN.PrintableComponent = new PrintableComponentLinkBase()
{
Component = GridViewExporter_S04b6DN
};
ReportViewer_S04b6DN.Report = s04b6_dn;
#endregion
}
public void load_data()
{
WebModule.Accounting.Report.S11_DN s11_dn = new Report.S11_DN();
#region tham số truyền
int month = Int32.Parse(this.hS11DN_month.Get("month_id").ToString());
int year = Int32.Parse(this.hS11DN_year.Get("year_id").ToString());
string owner = "QUASAPHARCO";
string fAccount = this.hS11dnAccount.Get("account_id").ToString();
//string asset = "";
short rowstatus = Utility.Constant.ROWSTATUS_ACTIVE;
#endregion
#region display report
s11_dn.xrTaiKhoan.Text = String.Format("Tài khoản: {0}", fAccount);
s11_dn.xrTime.Text = String.Format("Tháng {0} năm {1}", month, year);
#endregion
try
{
#region object
MonthDim md = session.FindObject <MonthDim>(CriteriaOperator.Parse(
String.Format("Name='{0}' AND RowStatus='{1}'", month, rowstatus)));
YearDim yd = session.FindObject <YearDim>(CriteriaOperator.Parse(
String.Format("Name='{0}' AND RowStatus='{1}'", year, rowstatus)));
OwnerOrgDim ood = session.FindObject <OwnerOrgDim>(CriteriaOperator.Parse(
String.Format("Code='{0}' AND RowStatus='{1}'", owner, rowstatus)));
FinancialAccountDim accountDim = session.FindObject <FinancialAccountDim>(CriteriaOperator.Parse(
String.Format("Code='{0}' AND RowStatus='{1}'", fAccount, rowstatus)));
XPCollection <FinancialItemInventorySummary_Fact> Summary_Fact;
#endregion
#region header và table báo cáo
grid_header();
DataTable datatable = table_pri();
#endregion
#region list hàng hóa
List <string> items = new List <string>();
if (md != null && yd != null && ood != null && accountDim != null)
{
Summary_Fact =
new XPCollection <FinancialItemInventorySummary_Fact>(session, CriteriaOperator.Parse(
String.Format("MonthDimId='{0}' AND "
+ "YearDimId='{1}' AND "
+ "OwnerOrgDimId='{2}' AND "
+ "RowStatus='{3}' AND "
+ "FinancialAccountDimId='{4}'",
md.MonthDimId,
yd.YearDimId,
ood.OwnerOrgDimId,
rowstatus,
accountDim.FinancialAccountDimId
)));
if (Summary_Fact.Count != 0)
{
foreach (FinancialItemInventorySummary_Fact each_Fact in Summary_Fact)
{
if (!items.Contains(String.Format("{0}|{1}", each_Fact.ItemDimId.Code, each_Fact.UnitDimId.Code)))
{
items.Add(String.Format("{0}|{1}", each_Fact.ItemDimId.Code, each_Fact.UnitDimId.Code));
}
}
}
}
#endregion
#region đổ dữ liệu
DataRow dr;
// từng dòng
int STT = 1;
foreach (string item in items)
{
string itemCode = item.Split('|')[0];
string unitCode = item.Split('|')[1];
ItemDim itemDim = session.FindObject <ItemDim>(CriteriaOperator.Parse(
String.Format("Code='{0}'", itemCode)));
UnitDim unitDim = session.FindObject <UnitDim>(CriteriaOperator.Parse(
String.Format("Code='{0}'", unitCode)));
dr = datatable.NewRow();
dr["stt"] = STT++;
dr["ten"] = String.Format("{0} ({1})", itemDim.Name, unitDim.Name);
if (md != null && yd != null && ood != null && itemDim != null && unitDim != null && accountDim != null)
{
Summary_Fact =
new XPCollection <FinancialItemInventorySummary_Fact>(session, CriteriaOperator.Parse(
String.Format("MonthDimId='{0}' AND "
+ "YearDimId='{1}' AND "
+ "OwnerOrgDimId='{2}' AND "
+ "RowStatus='{3}' AND "
+ "ItemDimId='{4}' AND "
+ "UnitDimId='{5}' AND "
+ "FinancialAccountDimId='{6}'",
md.MonthDimId,
yd.YearDimId,
ood.OwnerOrgDimId,
rowstatus,
itemDim.ItemDimId,
unitDim.UnitDimId,
accountDim.FinancialAccountDimId
)));
if (Summary_Fact.Count != 0)
{
double debit_sum = 0, credit_sum = 0, begin = 0, end = 0;
foreach (FinancialItemInventorySummary_Fact each_fact in Summary_Fact)
{
begin += (double)each_fact.BeginDebitBalance;
debit_sum += (double)each_fact.DebitSum;
credit_sum += (double)each_fact.CreditSum;
end += (double)each_fact.EndDebitBalance;
}
dr["ton_dau"] = begin;
dr["nhap"] = debit_sum;
dr["xuat"] = credit_sum;
dr["ton_cuoi"] = end;
}
}
datatable.Rows.Add(dr);
}
#endregion
#region dòng cộng
dr = datatable.NewRow();
dr["ten"] = "Cộng";
int column_count = datatable.Columns.Count - 1;
int row_count = datatable.Rows.Count - 1;
for (int c = 2; c <= column_count; c++)
{
double sumT = 0;
for (int r = 1; r <= row_count; r++)
{
double tt;
double.TryParse(datatable.Rows[r][c].ToString(), out tt);
sumT += tt;
}
dr[datatable.Columns[c]] = sumT;
}
datatable.Rows.Add(dr);
#endregion
#region out gridview
GridView_S11DN.DataSource = datatable;
GridView_S11DN.DataBind();
#endregion
}
catch { }
#region export report
s11_dn.printableCC_S11DN.PrintableComponent = new PrintableComponentLinkBase()
{
Component = GridViewExporter_S11DN
};
ReportViewer_S11DN.Report = s11_dn;
#endregion
}
public void load_data()
{
WebModule.Accounting.Report.S04b4_DN s04b4_dn = new Report.S04b4_DN();
#region tham số truyền
int month = Int32.Parse(this.hS04b4DN_month.Get("month_id").ToString());
int year = Int32.Parse(this.hS04b4DN_year.Get("year_id").ToString());
string owner = "QUASAPHARCO";
//string asset = "";
#endregion
s04b4_dn.xrMonth.Text = month.ToString();
s04b4_dn.xrYear.Text = year.ToString();
#region object
MonthDim md = session.FindObject <MonthDim>(CriteriaOperator.Parse(String.Format("Name='{0}'", month)));
YearDim yd = session.FindObject <YearDim>(CriteriaOperator.Parse(String.Format("Name='{0}'", year)));
OwnerOrgDim ood = session.FindObject <OwnerOrgDim>(CriteriaOperator.Parse(String.Format("Code='{0}'",
owner)));
int CorrespondFinancialAccountDimId_default = CorrespondFinancialAccountDim.GetDefault(session,
CorrespondFinancialAccountDimEnum.NAAN_DEFAULT).CorrespondFinancialAccountDimId;
FinancialSalesOrManufactureExpenseSummary_Fact FinancialFact_General = null;
#endregion
#region header và table báo cáo
grid_header();
DataTable datatable = table_pri();
#endregion
#region all row
List <string> all_row_f_c = new List <string>();
if (md != null && yd != null && ood != null)
{
// chung
FinancialFact_General =
session.FindObject <FinancialSalesOrManufactureExpenseSummary_Fact>(
CriteriaOperator.Parse(String.Format("MonthDimId='{0}' AND YearDimId='{1}' AND "
+ "OwnerOrgDimId='{2}' AND RowStatus='1'",
md.MonthDimId,
yd.YearDimId,
ood.OwnerOrgDimId)));
// f & c
all_row_f_c.AddRange(support_find_row_TK(FinancialFact_General, "154"));
all_row_f_c.AddRange(support_find_row_TK(FinancialFact_General, "621"));
all_row_f_c.AddRange(support_find_row_TK(FinancialFact_General, "622"));
all_row_f_c.AddRange(support_find_row_TK(FinancialFact_General, "623"));
all_row_f_c.AddRange(support_find_row_TK(FinancialFact_General, "627"));
all_row_f_c.AddRange(support_find_row_TK(FinancialFact_General, "631"));
//
}
#endregion
#region đổ dữ liệu
int STTu = 1;
// từng dòng
foreach (string each_row in all_row_f_c)
{
#region
FinancialAccountDim fFinancialAccountDim = session.FindObject <FinancialAccountDim>(
CriteriaOperator.Parse(String.Format("Code='{0}'", each_row.Substring(0, 3))));
//
DataRow dr = datatable.NewRow();
if (each_row == "154" || each_row == "621" || each_row == "622" || each_row == "623" ||
each_row == "627" || each_row == "631")
{
dr["stt"] = STTu++;
}
FinancialAccountDim get_Description = session.FindObject <FinancialAccountDim>(
CriteriaOperator.Parse(String.Format("Code='{0}'", each_row)));
if (each_row == "154" || each_row == "621" || each_row == "622" || each_row == "623" ||
each_row == "627" || each_row == "631")
{
dr["tk_no"] = String.Format("TK {0} - {1}", each_row, get_Description.Description);
}
else
{
dr["tk_no"] = get_Description.Description;
}
#endregion
double sum_CPTT = 0;
// từng cột
foreach (string each_column in list_header())
{
#region
int TK_column_CorrespondFinancialAccountDimId = session.FindObject <CorrespondFinancialAccountDim>(
CriteriaOperator.Parse(String.Format("Code='{0}'", each_column))).CorrespondFinancialAccountDimId;
////
if (md != null && yd != null && ood != null)
{
// only
FinancialFact_General =
session.FindObject <FinancialSalesOrManufactureExpenseSummary_Fact>(
CriteriaOperator.Parse(String.Format("MonthDimId='{0}' AND YearDimId='{1}' AND "
+ "OwnerOrgDimId='{2}' AND RowStatus='1'",
md.MonthDimId,
yd.YearDimId,
ood.OwnerOrgDimId)));
if (FinancialFact_General != null && fFinancialAccountDim != null)
{
SalesOrManufactureExpenseByGroup SalesByGroup = session.FindObject <
SalesOrManufactureExpenseByGroup>(CriteriaOperator.Parse(
String.Format("FinancialSalesOrManufactureExpenseSummary_FactId='{0}' AND "
+ "FinancialAccountDimId='{1}' AND RowStatus='1'",
FinancialFact_General.FinancialSalesOrManufactureExpenseSummary_FactId,
fFinancialAccountDim.FinancialAccountDimId
)));
if (SalesByGroup != null)
{
//tìm tập hợp của tài khoản cha, con với từng tk header
XPCollection <FinancialSalesOrManufactureExpenseDetail> all_detail =
new XPCollection <FinancialSalesOrManufactureExpenseDetail>(session,
CriteriaOperator.Parse(String.Format("SalesOrManufactureExpenseByGroupId='{0}' AND "
+ "CorrespondFinancialAccountDimId='{1}' AND "
+ "Credit>0 AND "
+ "RowStatus='1'",
SalesByGroup.SalesOrManufactureExpenseByGroupId,
TK_column_CorrespondFinancialAccountDimId
)));
if (all_detail.Count != 0)
{
if (each_row == "154" || each_row == "621" || each_row == "622" || each_row == "623" ||
each_row == "627" || each_row == "631")
{
double sum_fFinancialAccountDim = 0;
foreach (FinancialSalesOrManufactureExpenseDetail each_detail in all_detail)
{
// tổng
sum_fFinancialAccountDim += (double)each_detail.Credit;
//chi phí thực tế
sum_CPTT += (double)each_detail.Credit;
}
dr[each_column] = sum_fFinancialAccountDim;
}
else
{
double cell = 0;
foreach (FinancialSalesOrManufactureExpenseDetail each_detail in all_detail)
{
if (each_row == each_detail.FinancialAccountDimId.Code)
{
cell += (double)each_detail.Credit;
//chi phí thực tế
sum_CPTT += (double)each_detail.Credit;
}
}
dr[each_column] = cell;
}
}
if (each_row == "154" || each_row == "621" || each_row == "622" || each_row == "623" ||
each_row == "627" || each_row == "631")
{
dr["cong_tt"] = SalesByGroup.SumExpense;
}
else
{
dr["cong_tt"] = sum_CPTT;
}
}
}
}
////
#endregion
}
datatable.Rows.Add(dr);
}
#endregion
#region dòng cộng
DataRow dr_c = datatable.NewRow();
dr_c["tk_no"] = "CỘNG";
List <string> all_column = list_header();
all_column.Add("cong_tt");
foreach (string each_column in all_column)
{
double sum = 0;
try
{
sum += (from DataRow dr1 in datatable.Rows where dr1["stt"].Equals("1") select(double) dr1[each_column]).FirstOrDefault();
}
catch { }
try
{
sum += (from DataRow dr1 in datatable.Rows where dr1["stt"].Equals("2") select(double) dr1[each_column]).FirstOrDefault();
}
catch
{ }
try
{
sum += (from DataRow dr1 in datatable.Rows where dr1["stt"].Equals("3") select(double) dr1[each_column]).FirstOrDefault();
}
catch
{ }
try
{
sum += (from DataRow dr1 in datatable.Rows where dr1["stt"].Equals("4") select(double) dr1[each_column]).FirstOrDefault();
}
catch
{ }
try
{
sum += (from DataRow dr1 in datatable.Rows where dr1["stt"].Equals("5") select(double) dr1[each_column]).FirstOrDefault();
}
catch
{ }
try
{
sum += (from DataRow dr1 in datatable.Rows where dr1["stt"].Equals("6") select(double) dr1[each_column]).FirstOrDefault();
}
catch
{ }
dr_c[each_column] = sum;
}
datatable.Rows.Add(dr_c);
#endregion
#region out gridview
GridView_S04b4DN.DataSource = datatable;
GridView_S04b4DN.DataBind();
#endregion
#region export report
s04b4_dn.printableCC_S04b4DN.PrintableComponent = new PrintableComponentLinkBase()
{
Component = GridViewExporter_S04b4DN
};
ReportViewer_S04b4DN.Report = s04b4_dn;
#endregion
}
public void load_data()
{
WebModule.Accounting.Report.S04b8_DN s04b8_dn = new Report.S04b8_DN();
#region tham số truyền
int month = Int32.Parse(this.hS04b8DN_month.Get("month_id").ToString());
int year = Int32.Parse(this.hS04b8DN_year.Get("year_id").ToString());
string owner = "QUASAPHARCO";
string fAccount = this.hS04b8dnAccount.Get("account_id").ToString();
//string asset = "";
#endregion
if (fAccount != "155" && fAccount != "156" && fAccount != "158")
{
return;
}
try
{
#region object
MonthDim md = session.FindObject <MonthDim>(CriteriaOperator.Parse(String.Format("Name='{0}'", month)));
YearDim yd = session.FindObject <YearDim>(CriteriaOperator.Parse(String.Format("Name='{0}'", year)));
OwnerOrgDim ood = session.FindObject <OwnerOrgDim>(CriteriaOperator.Parse(String.Format("Code='{0}'",
owner)));
int CorrespondFinancialAccountDimId_default = CorrespondFinancialAccountDim.GetDefault(session,
CorrespondFinancialAccountDimEnum.NAAN_DEFAULT).CorrespondFinancialAccountDimId;
string rowStatusActive = Utility.Constant.ROWSTATUS_ACTIVE.ToString();
XPCollection <FinancialAccountDim> f_c_FinancialAccountDim = new XPCollection <FinancialAccountDim>(session,
CriteriaOperator.Parse(String.Format("Code like '{0}%' AND RowStatus='{1}'", fAccount, rowStatusActive)));
#endregion
#region display label report
s04b8_dn.xrMonth.Text = month.ToString();
s04b8_dn.xrYear.Text = year.ToString();
if (fAccount == "155")
{
s04b8_dn.xrTitle.Text = String.Format("Thành phẩm (TK {0})", fAccount);
}
if (fAccount == "156")
{
s04b8_dn.xrTitle.Text = String.Format("Hàng hóa (TK {0})", fAccount);
}
if (fAccount == "158")
{
s04b8_dn.xrTitle.Text = String.Format("Hàng hóa kho bảo thuế (TK {0})", fAccount);
}
// số dư đẩu và cuối kì
double no_dau_ki = 0, no_cuoi_ki = 0;
if (f_c_FinancialAccountDim.Count != 0)
{
foreach (FinancialAccountDim each_tk in f_c_FinancialAccountDim)
{
if (md != null && yd != null && ood != null)
{
GoodsInInventorySummary_Fact FinancialSummary_Fact =
session.FindObject <GoodsInInventorySummary_Fact>(CriteriaOperator.Parse(
String.Format("MonthDimId='{0}' AND "
+ "YearDimId='{1}' AND "
+ "OwnerOrgDimId='{2}' AND "
+ "FinancialAccountDimId='{3}' AND "
+ "RowStatus='{4}'",
md.MonthDimId,
yd.YearDimId,
ood.OwnerOrgDimId,
each_tk.FinancialAccountDimId,
rowStatusActive
)));
if (FinancialSummary_Fact != null)
{
no_dau_ki += (double)FinancialSummary_Fact.BeginDebitBalance;
no_cuoi_ki += (double)FinancialSummary_Fact.EndDebitBalance;
}
}
}
}
s04b8_dn.xrdauki.Text = String.Format("{0:#,#}", no_dau_ki);
s04b8_dn.xrCuoiKi.Text = String.Format("{0:#,#}", no_cuoi_ki);
#endregion
#region header và table báo cáo
grid_header();
DataTable datatable = table_pri();
#endregion
#region all row list_inventory
List <int> list_inventory = new List <int>();
if (f_c_FinancialAccountDim.Count != 0)
{
foreach (FinancialAccountDim each_tk in f_c_FinancialAccountDim)
{
if (md != null && yd != null && ood != null)
{
GoodsInInventorySummary_Fact GoodsSummary_Fact =
session.FindObject <GoodsInInventorySummary_Fact>(CriteriaOperator.Parse(
String.Format("MonthDimId='{0}' AND "
+ "YearDimId='{1}' AND "
+ "OwnerOrgDimId='{2}' AND "
+ "FinancialAccountDimId='{3}' AND "
+ "RowStatus='{4}'",
md.MonthDimId,
yd.YearDimId,
ood.OwnerOrgDimId,
each_tk.FinancialAccountDimId,
rowStatusActive
)));
if (GoodsSummary_Fact != null)
{
////
XPCollection <GoodsInInventoryDetail> collec_detail =
new XPCollection <GoodsInInventoryDetail>(session, CriteriaOperator.Parse(
String.Format("GoodsInInventorySummary_FacftId='{0}' AND "
+ "Credit>0 AND "
+ "CorrespondFinancialAccountDimId!='{1}' AND "
+ "RowStatus='{2}'",
GoodsSummary_Fact.GoodsInInventorySummary_FactId,
CorrespondFinancialAccountDimId_default,
rowStatusActive
)));
if (collec_detail.Count != 0)
{
foreach (GoodsInInventoryDetail each_detail in collec_detail)
{
if (!list_inventory.Contains(each_detail.InventoryCommandDimId.InventoryCommandDimId))
{
list_inventory.Add(each_detail.InventoryCommandDimId.InventoryCommandDimId);
}
}
}
////
collec_detail =
new XPCollection <GoodsInInventoryDetail>(session, CriteriaOperator.Parse(
String.Format("GoodsInInventorySummary_FacftId='{0}' AND "
+ "Debit>0 AND "
+ "CorrespondFinancialAccountDimId!='{1}' AND "
+ "RowStatus='{2}'",
GoodsSummary_Fact.GoodsInInventorySummary_FactId,
CorrespondFinancialAccountDimId_default,
rowStatusActive
)));
if (collec_detail.Count != 0)
{
foreach (GoodsInInventoryDetail each_detail in collec_detail)
{
if (!list_inventory.Contains(each_detail.InventoryCommandDimId.InventoryCommandDimId))
{
list_inventory.Add(each_detail.InventoryCommandDimId.InventoryCommandDimId);
}
}
}
}
}
}
}
#endregion
#region đổ dữ liệu
DataRow dr;
int STTu = 1;
// từng dòng
foreach (int each_row in list_inventory)
{
#region object Inventory
InventoryCommandDim inventory = session.FindObject <InventoryCommandDim>(
CriteriaOperator.Parse(String.Format("InventoryCommandDimId='{0}' AND "
+ "RowStatus='{1}'",
each_row,
rowStatusActive
)));
#endregion
dr = datatable.NewRow();
dr["stt"] = STTu++;
dr["so_hieu"] = inventory.Code;
dr["ngay_thang"] = String.Format("{0:dd/MM/yyyy}", inventory.IssueDate);
dr["dien_giai"] = inventory.Description;
// từng cột
#region credit correspond
double cong_no_TT = 0;
foreach (string header_column in header_credit_correspond())
{
double cell = 0, quantity = 0;;
//
CorrespondFinancialAccountDim CorrespondId = session.FindObject <CorrespondFinancialAccountDim>(
CriteriaOperator.Parse(String.Format("Code='{0}'", header_column)));
//
if (f_c_FinancialAccountDim.Count != 0)
{
foreach (FinancialAccountDim each_tk in f_c_FinancialAccountDim)
{
if (md != null && yd != null && ood != null)
{
GoodsInInventorySummary_Fact GoodsSummary_Fact =
session.FindObject <GoodsInInventorySummary_Fact>(CriteriaOperator.Parse(
String.Format("MonthDimId='{0}' AND "
+ "YearDimId='{1}' AND "
+ "OwnerOrgDimId='{2}' AND "
+ "FinancialAccountDimId='{3}' AND "
+ "RowStatus='{4}'",
md.MonthDimId,
yd.YearDimId,
ood.OwnerOrgDimId,
each_tk.FinancialAccountDimId,
rowStatusActive
)));
if (GoodsSummary_Fact != null)
{
XPCollection <GoodsInInventoryDetail> collec_detail_credit =
new XPCollection <GoodsInInventoryDetail>(session, CriteriaOperator.Parse(
String.Format("GoodsInInventorySummary_FacftId='{0}' AND "
+ "Credit>0 AND "
+ "CorrespondFinancialAccountDimId!='{1}' AND "
+ "RowStatus='{2}' AND "
+ "InventoryCommandDimId='{3}' AND "
+ "CorrespondFinancialAccountDimId='{4}'",
GoodsSummary_Fact.GoodsInInventorySummary_FactId,
CorrespondFinancialAccountDimId_default,
rowStatusActive,
each_row,
CorrespondId.CorrespondFinancialAccountDimId
)));
if (collec_detail_credit.Count != 0)
{
foreach (GoodsInInventoryDetail each_detail in collec_detail_credit)
{
cell += (double)each_detail.Credit;
cong_no_TT += (double)each_detail.Credit;
quantity += each_detail.Quantity;
}
}
}
}
}
}
//
dr[header_column + "_SL_co"] = quantity;
dr[header_column + "_TT_co"] = cell;
}
dr["cong_no_TT"] = cong_no_TT;
#endregion
// từng cột
#region debit correspond
double cong_co_TT = 0;
foreach (string header_column in header_debit_correspond())
{
double cell = 0, quantity = 0;
//
CorrespondFinancialAccountDim CorrespondId = session.FindObject <CorrespondFinancialAccountDim>(
CriteriaOperator.Parse(String.Format("Code='{0}'", header_column)));
//
if (f_c_FinancialAccountDim.Count != 0)
{
foreach (FinancialAccountDim each_tk in f_c_FinancialAccountDim)
{
if (md != null && yd != null && ood != null)
{
GoodsInInventorySummary_Fact GoodsSummary_Fact =
session.FindObject <GoodsInInventorySummary_Fact>(CriteriaOperator.Parse(
String.Format("MonthDimId='{0}' AND "
+ "YearDimId='{1}' AND "
+ "OwnerOrgDimId='{2}' AND "
+ "FinancialAccountDimId='{3}' AND "
+ "RowStatus='{4}'",
md.MonthDimId,
yd.YearDimId,
ood.OwnerOrgDimId,
each_tk.FinancialAccountDimId,
rowStatusActive
)));
if (GoodsSummary_Fact != null)
{
XPCollection <GoodsInInventoryDetail> collec_detail_debit =
new XPCollection <GoodsInInventoryDetail>(session, CriteriaOperator.Parse(
String.Format("GoodsInInventorySummary_FacftId='{0}' AND "
+ "Debit>0 AND "
+ "CorrespondFinancialAccountDimId!='{1}' AND "
+ "RowStatus='{2}' AND "
+ "InventoryCommandDimId='{3}' AND "
+ "CorrespondFinancialAccountDimId='{4}'",
GoodsSummary_Fact.GoodsInInventorySummary_FactId,
CorrespondFinancialAccountDimId_default,
rowStatusActive,
each_row,
CorrespondId.CorrespondFinancialAccountDimId
)));
if (collec_detail_debit.Count != 0)
{
foreach (GoodsInInventoryDetail each_detail in collec_detail_debit)
{
cell += (double)each_detail.Debit;
cong_co_TT += (double)each_detail.Debit;
quantity += each_detail.Quantity;
}
}
}
}
}
}
dr[header_column + "_SL_no"] = quantity;
dr[header_column + "_TT_no"] = cell;
}
dr["cong_co_TT"] = cong_co_TT;
#endregion
datatable.Rows.Add(dr);
}
#endregion
#region dòng cộng
dr = datatable.NewRow();
dr["dien_giai"] = "Cộng";
int column_count = datatable.Columns.Count - 1;
int row_count = datatable.Rows.Count - 1;
for (int c = 4; c <= column_count; c++)
{
double sumT = 0;
for (int r = 1; r <= row_count; r++)
{
double tt;
double.TryParse(datatable.Rows[r][c].ToString(), out tt);
sumT += tt;
}
dr[datatable.Columns[c]] = sumT;
}
datatable.Rows.Add(dr);
#endregion
#region out gridview
GridView_S04b8DN.DataSource = datatable;
GridView_S04b8DN.DataBind();
#endregion
}
catch { }
#region export report
s04b8_dn.printableCC_S04b8DN.PrintableComponent = new PrintableComponentLinkBase()
{
Component = GridViewExporter_S04b8DN
};
ReportViewer_S04b8DN.Report = s04b8_dn;
#endregion
}
public void Load_Data()
{
WebModule.Accounting.Report.S10_DN s10dn = new WebModule.Accounting.Report.S10_DN();
try
{
#region Parameter
string account = this.hs10dnAcc.Get("account_id").ToString();
int month = int.Parse(this.hs10dnMonth.Get("month_id").ToString());
int year = int.Parse(this.hs10dnYear.Get("year_id").ToString());
string unitDim = this.hs10dnUnitDim.Get("unit_id").ToString();
string item = this.hs10dnItem.Get("Item_id").ToString();
string inventory = this.hs10dnInventory.Get("Inventory_id").ToString();
string OwnerOrg = "QUASAPHARCO";
#endregion
#region Select *
FinancialAccountDim FAD = BO.get_FinancialAccountDim(session, account, Utility.Constant.ROWSTATUS_ACTIVE);
MonthDim MD = BO.get_MonthDim(session, month.ToString(), Utility.Constant.ROWSTATUS_ACTIVE);
YearDim YD = BO.get_YearDim(session, year.ToString(), Utility.Constant.ROWSTATUS_ACTIVE);
ItemDim ID = BO.get_ItemDim_1(session, item, Utility.Constant.ROWSTATUS_ACTIVE);
InventoryDim InDim = BO.get_InventoryDim_1(session, inventory, Utility.Constant.ROWSTATUS_ACTIVE);
UnitDim UD = BO.get_UnitDim(session, unitDim, Utility.Constant.ROWSTATUS_ACTIVE);
OwnerOrgDim OOD = BO.get_OwnerOrgDim(session, OwnerOrg, Utility.Constant.ROWSTATUS_ACTIVE);
#endregion
#region label
s10dn.lbl_Inventory.Text = inventory;
s10dn.lbl_Item.Text = item;
s10dn.lbl_year.Text = year.ToString();
s10dn.lbl_account.Text = account;
s10dn.lbl_unitDim.Text = unitDim;
#endregion
#region GridView_header vao DataTable
GridView_header();
DataTable dt = DT_header();
#endregion
if (FAD == null || MD == null || YD == null || ID == null || InDim == null || UD == null || OOD == null)
{
return;
}
#region do du lieu vao DataTable
DT_rowgetvalue(dt, FAD.FinancialAccountDimId, InDim.InventoryDimId, OOD.OwnerOrgDimId, ID.ItemDimId, MD.MonthDimId, YD.YearDimId, UD.UnitDimId);
#endregion
#region do du lieu vao DataTable
xGridView.DataSource = dt;
xGridView.DataBind();
#endregion
}
catch { }
#region xuat Report
xGridViewExporter.GridViewID = "xGridView";
s10dn.printableCC.PrintableComponent = new PrintableComponentLinkBase()
{
Component = xGridViewExporter
};
ReportViewerS10.Report = s10dn;
#endregion
}
public void LoadData()
{
WebModule.Accounting.Report.S04b11_DN s04b11_dn = new WebModule.Accounting.Report.S04b11_DN();
try
{
string FinancialAccountDim_Code = "131";
int MonthDim = int.Parse(this.hs04b11dnMonth.Get("month_Name").ToString());
int YearDim = int.Parse(this.hs04b11dnYear.Get("year_Name").ToString());
string OwnerOrgDim = "QUASAPHARCO";
#region get_value
FinancialAccountDim FAD = BO.get_FinancialAccountDimId(session, FinancialAccountDim_Code, Utility.Constant.ROWSTATUS_ACTIVE);
MonthDim MD = BO.get_MonthDimId(session, MonthDim.ToString(), Utility.Constant.ROWSTATUS_ACTIVE);
YearDim YD = BO.get_YearDimId(session, YearDim.ToString(), Utility.Constant.ROWSTATUS_ACTIVE);
OwnerOrgDim OOD = BO.get_OwnerOrgDimId(session, OwnerOrgDim, Utility.Constant.ROWSTATUS_ACTIVE);
#endregion
if (MD == null || YD == null || OOD == null)
{
return;
}
if (int.Parse(MD.Name.ToString()) < 10)
{
s04b11_dn.lbthang.Text = "0" + MD.Name;
}
s04b11_dn.lbthang.Text = MD.Name;
s04b11_dn.lbnam.Text = YD.Name;
#region tao header
gridview_header(FAD.FinancialAccountDimId, OOD.OwnerOrgDimId, MD.MonthDimId, YD.YearDimId);
DataTable dt = DT_Header(FAD.FinancialAccountDimId, OOD.OwnerOrgDimId, MD.MonthDimId, YD.YearDimId);
#endregion
#region dòng STT cột
DT_STT(dt);
#endregion
#region do du lieu
DT_getRowValue(dt, FAD.FinancialAccountDimId, OOD.OwnerOrgDimId, MD.MonthDimId, YD.YearDimId);
//DT_getvalue(FAD.FinancialAccountDimId, OOD.OwnerOrgDimId, MD.MonthDimId, YD.YearDimId);
#endregion
#region bind data vào gridview
xGridView.DataSource = dt;
xGridView.DataBind();
#endregion
}
catch { }
#region xuất report
xGridViewExporter.GridViewID = "xGridView";
s04b11_dn.printableCC.PrintableComponent = new PrintableComponentLinkBase()
{
Component = xGridViewExporter
};
ReportViewerS04b11.Report = s04b11_dn;
#endregion
}
public void CreateFinancialRevenueByItem(Session session,
Guid _BillId,
Guid _CustomerOrgId,
Guid _OwnerOrgId,
Item _Item,
Unit _Unit,
int Day,
int Month,
int Year,
string _AssetDim)
{
FinancialRevenueByItem_Fact result = new FinancialRevenueByItem_Fact(session);
try
{
SalesInvoice invoice = session.GetObjectByKey <SalesInvoice>(_BillId);
if (!Util.IsExistXpoObject <InvoiceDim>(session, "RefId", _BillId))
{
InvoiceDim invoiceDim = new InvoiceDim(session);
invoiceDim.RefId = _BillId;
invoiceDim.Code = invoice.Code;
invoiceDim.Name = "";
invoiceDim.Description = "";
invoiceDim.IssueDate = invoice.IssuedDate;
invoiceDim.RowStatus = Constant.ROWSTATUS_ACTIVE;
invoiceDim.Save();
}
if (!Util.IsExistXpoObject <DayDim>(session, "Name", Day.ToString()))
{
DayDim dayDim = new DayDim(session);
dayDim.Description = Day.ToString();
dayDim.Name = Day.ToString();
dayDim.RowStatus = Constant.ROWSTATUS_ACTIVE;
dayDim.Save();
}
if (!Util.IsExistXpoObject <MonthDim>(session, "Name", Month.ToString()))
{
MonthDim MonthDim = new MonthDim(session);
MonthDim.Description = Month.ToString();
MonthDim.Name = Month.ToString();
MonthDim.RowStatus = Constant.ROWSTATUS_ACTIVE;
MonthDim.Save();
}
if (!Util.IsExistXpoObject <YearDim>(session, "Name", Year.ToString()))
{
YearDim YearDim = new YearDim(session);
YearDim.Description = Year.ToString();
YearDim.Name = Year.ToString();
YearDim.RowStatus = Constant.ROWSTATUS_ACTIVE;
YearDim.Save();
}
if (!Util.IsExistXpoObject <FinancialAssetDim>(session, "Name", _AssetDim))
{
FinancialAssetDim assetDim = new FinancialAssetDim(session);
assetDim.Name = _AssetDim;
assetDim.Description = _AssetDim;
assetDim.RowStatus = Constant.ROWSTATUS_ACTIVE;
assetDim.Save();
}
if (!Util.IsExistXpoObject <ItemDim>(session, "RefId", _Item.ItemId))
{
ItemDim itemDim = new ItemDim(session);
itemDim.RefId = _Item.ItemId;
itemDim.Code = _Item.Code;
itemDim.Name = _Item.Name;
itemDim.Description = _Item.Description;
itemDim.RowStatus = Constant.ROWSTATUS_ACTIVE;
itemDim.Save();
}
if (!Util.IsExistXpoObject <UnitDim>(session, "RefId", _Unit.UnitId))
{
UnitDim unitDim = new UnitDim(session);
unitDim.RefId = _Unit.UnitId;
unitDim.Code = _Unit.Code;
unitDim.Name = _Unit.Name;
unitDim.Description = _Unit.Description;
unitDim.RowStatus = Constant.ROWSTATUS_ACTIVE;
unitDim.Save();
}
if (!Util.IsExistXpoObject <CustomerOrgDim>(session, "RefId", _CustomerOrgId))
{
Organization customerOrg = session.GetObjectByKey <Organization>(_CustomerOrgId);
if (customerOrg != null)
{
CustomerOrgDim customerOrgDim = new CustomerOrgDim(session);
customerOrgDim.RefId = _CustomerOrgId;
customerOrgDim.Code = customerOrg.Code;
customerOrgDim.Name = customerOrg.Name;
customerOrgDim.Description = customerOrg.Description;
customerOrgDim.RowStatus = Constant.ROWSTATUS_ACTIVE;
customerOrgDim.Save();
}
}
if (!Util.IsExistXpoObject <OwnerOrgDim>(session, "RefId", _OwnerOrgId))
{
Organization ownerOrg = session.GetObjectByKey <Organization>(_OwnerOrgId);
if (ownerOrg != null)
{
OwnerOrgDim ownerOrgDim = new OwnerOrgDim(session);
ownerOrgDim.RefId = _OwnerOrgId;
ownerOrgDim.Code = ownerOrg.Code;
ownerOrgDim.Name = ownerOrg.Name;
ownerOrgDim.Description = ownerOrg.Description;
ownerOrgDim.RowStatus = Constant.ROWSTATUS_ACTIVE;
ownerOrgDim.Save();
}
}
Util util = new Util();
result.InvoiceDimId = util.GetXpoObjectByFieldName <InvoiceDim, Guid>(session, "RefId", _BillId, DevExpress.Data.Filtering.BinaryOperatorType.Equal);
result.FinancialAssetDimId = Util.getXpoObjectByName <FinancialAssetDim>(session, _AssetDim);
result.DayDimId = Util.getXpoObjectByName <DayDim>(session, Day.ToString());
result.MonthDimId = Util.getXpoObjectByName <MonthDim>(session, Month.ToString());
result.YearDimId = Util.getXpoObjectByName <YearDim>(session, Year.ToString());
result.ItemDimId = util.GetXpoObjectByFieldName <ItemDim, string>(session, "Code", _Item.Code, DevExpress.Data.Filtering.BinaryOperatorType.Equal);
result.UnitDimId = util.GetXpoObjectByFieldName <UnitDim, string>(session, "Code", _Unit.Code, DevExpress.Data.Filtering.BinaryOperatorType.Equal);
result.CustomerOrgDimId = util.GetXpoObjectByFieldName <CustomerOrgDim, Guid>(session, "RefId", _CustomerOrgId, DevExpress.Data.Filtering.BinaryOperatorType.Equal);
result.OwnerOrgDimId = util.GetXpoObjectByFieldName <OwnerOrgDim, Guid>(session, "RefId", _OwnerOrgId, DevExpress.Data.Filtering.BinaryOperatorType.Equal);
result.Save();
}
catch (Exception)
{
}
}
private void load_data()
{
WebModule.Accounting.Report.S12_DN s12_dn = new Report.S12_DN();
#region truyền data
int month = Int32.Parse(this.hS12DN_month.Get("month_id").ToString());
int year = Int32.Parse(this.hS12DN_year.Get("year_id").ToString());
string owner = "QUASAPHARCO";
short rowStatus = Utility.Constant.ROWSTATUS_ACTIVE;
string item = this.hs12dnItem.Get("Item_id").ToString(); //"ACAPELLA S";
string unit = "Thùng";
#endregion
#region display report
s12_dn.xrDate.Text = String.Format("Ngày lập thẻ: {0:dd/MM/yyyy}", DateTime.Now);
s12_dn.xrNumber.Text = "Tờ số: ..............";
s12_dn.xrName.Text = String.Format("Tên, nhãn hiệu, quy cách vật tư: {0}", item);
s12_dn.xrUnit.Text = String.Format("Đơn vị tính: {0}", unit);
s12_dn.xrCode.Text = "Mã số: ................";
#endregion
#region object
MonthDim monthDim = session.FindObject <MonthDim>(CriteriaOperator.Parse(String.Format(
"Name='{0}' AND RowStatus='{1}'", month, rowStatus)));
YearDim yearDim = session.FindObject <YearDim>(CriteriaOperator.Parse(String.Format(
"Name='{0}' AND RowStatus='{1}'", year, rowStatus)));
ItemDim itemDim = session.FindObject <ItemDim>(CriteriaOperator.Parse(String.Format(
"Name='{0}' AND RowStatus='{1}'", item, rowStatus)));
UnitDim unitDim = session.FindObject <UnitDim>(CriteriaOperator.Parse(String.Format(
"Code='{0}' AND RowStatus='{1}'", unit, rowStatus)));
OwnerOrgDim ownerOrgDim = session.FindObject <OwnerOrgDim>(CriteriaOperator.Parse(
String.Format("Code='{0}' AND RowStatus='{1}'", owner, rowStatus)));
int CorrespondFinancialAccountDimId_default = CorrespondFinancialAccountDim.GetDefault(session,
CorrespondFinancialAccountDimEnum.NAAN_DEFAULT).CorrespondFinancialAccountDimId;
#endregion
#region header và dataTable
grid_header();
DataTable datatable = table_pri();
#endregion
#region row
XPCollection <ItemInventoryByArtifact> ItemArtifacts =
new XPCollection <ItemInventoryByArtifact>(session, CriteriaOperator.Parse(
String.Format("RowStatus='{0}' AND CorrespondFinancialAccountDimId='{1}'",
rowStatus, CorrespondFinancialAccountDimId_default)));
DataRow dr;
if (ItemArtifacts.Count != 0)
{
int STT = 1;
foreach (ItemInventoryByArtifact fact in ItemArtifacts)
{
if (itemDim != null && unitDim != null && ownerOrgDim != null)
{
if (fact.FinancialItemInventorySummary_FactId.ItemDimId.Code == itemDim.Code &&
fact.FinancialItemInventorySummary_FactId.UnitDimId.Code == unitDim.Code &&
fact.FinancialItemInventorySummary_FactId.OwnerOrgDimId.Code == ownerOrgDim.Code &&
fact.FinancialItemInventorySummary_FactId.RowStatus == rowStatus &&
fact.FinancialItemInventorySummary_FactId.MonthDimId.MonthDimId == monthDim.MonthDimId &&
fact.FinancialItemInventorySummary_FactId.YearDimId.YearDimId == yearDim.YearDimId)
{
dr = datatable.NewRow();
dr["stt"] = STT++;
//dr["date"] = String.Format("");
if (fact.InventoryCommandDimId.Code.Contains("ICMD"))
{
dr["nhap_dau"] = fact.InventoryCommandDimId.Code;
}
if (fact.InventoryCommandDimId.Code.Contains("OUTCMD"))
{
dr["xuat_dau"] = fact.InventoryCommandDimId.Code;
}
dr["dien_giai"] = fact.InventoryCommandDimId.Description;
dr["date_nhap_xuat"] = String.Format("{0:dd/MM/yyyy}", fact.InventoryCommandDimId.IssueDate);
dr["nhap_cuoi"] = fact.FinancialItemInventorySummary_FactId.DebitItemSum;
dr["xuat_cuoi"] = fact.FinancialItemInventorySummary_FactId.CreditItemSum;
dr["ton_cuoi"] = fact.CurrentBalanceItem;
datatable.Rows.Add(dr);
}
}
}
}
#endregion
#region dòng cộng
dr = datatable.NewRow();
dr["dien_giai"] = "Cộng";
int column_count = datatable.Columns.Count - 2;
int row_count = datatable.Rows.Count - 1;
for (int c = 6; c <= column_count; c++)
{
double sumT = 0;
for (int r = 1; r <= row_count; r++)
{
double tt;
double.TryParse(datatable.Rows[r][c].ToString(), out tt);
sumT += tt;
}
dr[datatable.Columns[c]] = sumT;
}
datatable.Rows.Add(dr);
#endregion
#region out gridview
GridView_S12DN.DataSource = datatable;
GridView_S12DN.DataBind();
#endregion
#region export report
s12_dn.printableCC_S12DN.PrintableComponent =
new PrintableComponentLinkBase()
{
Component = GridViewExporter_S12DN
};
ReportViewer_S12DN.Report = s12_dn;
#endregion
}
