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 }
// 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 YearDim GetYearDim(Session session, string Name) { YearDim Year = null; try { CriteriaOperator criteria = new BinaryOperator("Name", Name, BinaryOperatorType.Equal); Year = session.FindObject <YearDim>(criteria); } catch (Exception) { throw; } return(Year); }
public YearDim CreateYearDim(Session session, short Year) { try { YearDim yearDim = new YearDim(session); yearDim.Description = "Năm " + Year.ToString(); yearDim.Name = Year.ToString(); yearDim.RowStatus = Constant.ROWSTATUS_ACTIVE; yearDim.Save(); return(yearDim); } catch (Exception) { return(null); } }
public YearDim get_YearDim(Session session, string Name, short RowStatus) { try { YearDim YD = session.FindObject <YearDim>( CriteriaOperator.And( new BinaryOperator("Name", Name, BinaryOperatorType.Equal), new BinaryOperator("RowStatus", RowStatus, BinaryOperatorType.Equal) )); if (YD == null) { return(null); } return(YD); } catch (Exception) { 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 void CreatYearDim(Session session, string Name, string Description) { try { CriteriaOperator criteria = new BinaryOperator("Name", Name, BinaryOperatorType.Equal); YearDim Year = session.FindObject <YearDim>(criteria); if (Year == null) { Year = new YearDim(session); Year.Name = Name; Year.Description = Description; Year.RowStatus = Constant.ROWSTATUS_ACTIVE; Year.Save(); } } catch (Exception) { throw; } }
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 YearDim GetYearDim(Session session, short Year) { try { CriteriaOperator criteria_RowStaus = new BinaryOperator("RowStatus", Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.Equal); CriteriaOperator criteria_Name = new BinaryOperator("Name", Year.ToString(), BinaryOperatorType.Equal); CriteriaOperator criteria = CriteriaOperator.And(criteria_Name, criteria_RowStaus); YearDim YearDim = session.FindObject <YearDim>(criteria); if (YearDim == null) { YearDim = new YearDim(session); YearDim.Description = Year.ToString(); YearDim.Name = Year.ToString(); YearDim.RowStatus = Constant.ROWSTATUS_ACTIVE; YearDim.Save(); } return(YearDim); } catch { return(null); } }
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) { } }
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 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 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 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 bool CreatETLJobLog(Session session, Guid jobId, string StateName, string StatusName, DateTime date) { bool res = true; try { DateTime nowTime = date; string currentDay = nowTime.Day.ToString(); string currentMonth = nowTime.Month.ToString(); string currentYear = nowTime.Year.ToString(); string currentHour = nowTime.Hour.ToString(); string currentMinute = nowTime.Minute.ToString(); DayDim day = GetDayDim(session, currentDay); if (day == null) { return(false); } MonthDim month = GetMonthDim(session, currentMonth); if (month == null) { return(false); } YearDim year = GetYearDim(session, currentYear); if (year == null) { return(false); } HourDim hour = GetHourDim(session, currentHour); if (hour == null) { return(false); } MinuteDim minute = GetMinuteDim(session, currentMinute); if (minute == null) { return(false); } ETLJobRunningState state = GetETLJobRunningState(session, StateName); if (state == null) { return(false); } ETLJobRunningStatus status = GetETLJobRunningStatus(session, StatusName); if (status == null) { return(false); } ETLJob job = session.GetObjectByKey <ETLJob>(jobId); if (job == null) { return(false); } ETLJobLog etlJobLog = new ETLJobLog(session); etlJobLog.ETLJobId = job; etlJobLog.DayDimId = day; etlJobLog.MinuteDimId = minute; etlJobLog.MonthDimId = month; etlJobLog.YearDimId = year; etlJobLog.HourDimId = hour; etlJobLog.ETLJobRunningStateId = state; etlJobLog.ETLJobRunningStatusId = status; etlJobLog.Save(); } catch (Exception) { return(false); throw; } return(res); }
public void LoadData() { WebModule.Accounting.Report.GeneralLedger generalLedger = new WebModule.Accounting.Report.GeneralLedger(); try { #region Parametter string account = this.GeneralLedgerAcc.Get("account_id").ToString(); int month = int.Parse(this.GeneralLedgerMonth.Get("month_id").ToString()); int year = int.Parse(this.GeneralLedgerYear.Get("year_id").ToString()); string asset = "VND"; //chua su dung gia tri nay neu co #endregion #region get value FinancialAccountDim FAD = BO.get_FinancialAccountDim(session, account, Utility.Constant.ROWSTATUS_ACTIVE); MonthDim MD = BO.get_MonthDimId(session, month.ToString(), Utility.Constant.ROWSTATUS_ACTIVE); YearDim YD = BO.get_YearDimId(session, year.ToString(), Utility.Constant.ROWSTATUS_ACTIVE); if (FAD != null && YD != null) { FinancialGeneralLedgerByYear_Fact fgly = BO.get_FinancialGeneralLedgerByYear_Fact_1(session, FAD.FinancialAccountDimId, YD.YearDimId, Utility.Constant.ROWSTATUS_ACTIVE); if (fgly != null) { #endregion #region gan label generalLedger.lblYear.Text = year.ToString(); generalLedger.lbl_Account.Text = account; if (fgly.BeginDebitBalance > 0) { generalLedger.lbl_beginDebit.Text = fgly.BeginDebitBalance.ToString("#,#"); } else { generalLedger.lbl_beginDebit.Text = "0"; } if (fgly.BeginCreditBalance > 0) { generalLedger.lbl_beginCredit.Text = fgly.BeginCreditBalance.ToString("#,#"); } else { generalLedger.lbl_beginCredit.Text = "0"; } #endregion #region GridView_header va DT_header GridView_header(FAD.FinancialAccountDimId); DataTable dt = DT_header(); #endregion #region do du lieu vao DataTable DT_RowGetValue(dt, FAD.FinancialAccountDimId, YD.YearDimId, fgly.BeginCreditBalance, fgly.BeginDebitBalance); #endregion #region Bindata vao Gridview xGridView.DataSource = dt; xGridView.DataBind(); #endregion } } } catch { } #region xuat report ASPxGridViewExporter1.GridViewID = "xGridView"; generalLedger.printableCC.PrintableComponent = new PrintableComponentLinkBase() { Component = ASPxGridViewExporter1 }; ReportViewerGLedger.Report = generalLedger; #endregion }
public void load_data() { WebModule.Accounting.Report.S04a4_DN S04a4_DN = new WebModule.Accounting.Report.S04a4_DN(); try { #region parametter string account = this.hS04a4dnAcc.Get("account_id").ToString(); int month = Int32.Parse(this.hS04a4dnMonth.Get("month_id").ToString()); int year = Int32.Parse(this.hS04a4dnYear.Get("year_id").ToString()); string owner = this.hS04a4dnOwnerOrg.Get("owner_id").ToString(); string asset = "VND";//chua su dung gia tri nay neu co t int lastmonth = 0; int lastyear = year; if (month == 1) { lastmonth = 12; lastyear = year - 1; } else { lastmonth = month - 1; } #endregion #region get Value FinancialAccountDim FAD = BO.get_FinancialAccountDim(session, account, Utility.Constant.ROWSTATUS_ACTIVE); MonthDim MD = BO.get_MonthDimId(session, month.ToString(), Utility.Constant.ROWSTATUS_ACTIVE); YearDim YD = BO.get_YearDimId(session, year.ToString(), Utility.Constant.ROWSTATUS_ACTIVE); //OwnerOrgDim OOD = BO.get_OwnerOrgDimId(session, owner, Utility.Constant.ROWSTATUS_ACTIVE); #endregion if (FAD == null || MD == null || YD == null) //|| OOD == null) { return; } #region gan label S04a4_DN.lbl_month.Text = month.ToString(); S04a4_DN.lbl_year.Text = year.ToString(); S04a4_DN.lbl_tk.Text = "Ghi Có các tài khoản " + account; //DiaryJournal_Fact djf = BO.get_DiaryJournal_Fact_1(session, FAD.FinancialAccountDimId, OOD.OwnerOrgDimId, MD.MonthDimId, YD.YearDimId); //if (djf != null && djf.BeginCreditBalance > 0) { S04a4_DN.lbl_BeginCreditBalance.Text = djf.BeginCreditBalance.ToString("#,#"); } else { S04a4_DN.lbl_BeginCreditBalance.Text = djf.BeginCreditBalance.ToString(); } //if (djf != null && djf.EndCreditBalance > 0) { S04a4_DN.lbl_EndCreditBalance.Text = djf.EndCreditBalance.ToString("#,#"); } else { S04a4_DN.lbl_EndCreditBalance.Text = djf.EndCreditBalance.ToString(); } double beginBalance = 0; double endBalance = 0; #region begin balance string sql = "" + "select sum(beginbalance) as beginbalance " + "from " + "(select distinct d.IssueDate, -b.Credit as beginbalance, e.Code, d.FinancialTransactionDimId " + "from DiaryJournal_Fact a, " + "DiaryJournal_Detail b, " + "FinancialAccountDim c, " + "FinancialTransactionDim d, " + "CorrespondFinancialAccountDim e " + "where a.DiaryJournal_FactId = b.DiaryJournal_FactId " + "and a.FinancialAccountDimId = c.FinancialAccountDimId " + "and b.FinancialTransactionDimId = d.FinancialTransactionDimId " + "and b.CorrespondFinancialAccountDimId = e.CorrespondFinancialAccountDimId " + "and c.Code like '" + account + "%' " + "and (month(d.IssueDate) <= " + lastmonth.ToString() + " and year(d.IssueDate) = " + lastyear.ToString() + " ) " + "and (b.Credit > 0) " + "and (len(e.Code) > 0 and e.Code != 'NAAN_DEFAULT')" + "and (b.FinancialAccountDimId is null) " + "and e.Code not in ('1','2','3','4','5','6','7','8') " + "union all " + "select distinct d.IssueDate, b.Debit as beginbalance, e.Name, d.FinancialTransactionDimId " + "from DiaryJournal_Fact a, " + "DiaryJournal_Detail b, " + "FinancialAccountDim c, " + "FinancialTransactionDim d, " + "CorrespondFinancialAccountDim e " + "where a.DiaryJournal_FactId = b.DiaryJournal_FactId " + "and a.FinancialAccountDimId = c.FinancialAccountDimId " + "and b.FinancialTransactionDimId = d.FinancialTransactionDimId " + "and b.CorrespondFinancialAccountDimId = e.CorrespondFinancialAccountDimId " + "and c.Code like '" + account + "%' " + "and (month(d.IssueDate) <= " + lastmonth.ToString() + " and year(d.IssueDate) = " + lastyear.ToString() + " ) " + "and (b.Debit > 0) " + "and (len(e.Code) > 0 and e.Code != 'NAAN_DEFAULT')" + "and (b.FinancialAccountDimId is null) " + "and e.Code not in ('1','2','3','4','5','6','7','8') " + "union all " + "select null as IssueDate, b.Debit as beginbalance, null as Name, null as FinancialTransactionDimId " + "from BalanceForwardTransaction a, GeneralJournal b, " + "Account c, AccountingPeriod d, [Transaction] e " + "where a.TransactionId = b.TransactionId " + "and b.AccountId = c.AccountId " + "and a.TransactionId = e.TransactionId " + "and d.AccountingPeriodId = e.AccountingPeriodId " + "and b.Debit > 0 " + "and c.Code like '" + account + "%' " + "and (month(d.FromDateTime) = 1" + " and year(d.FromDateTime) = " + year.ToString() + ") " + ") aa "; SelectedData seletectedData = session.ExecuteQuery(sql); foreach (var row in seletectedData.ResultSet) { foreach (var col in row.Rows) { if (col.Values[0] != null) { S04a4_DN.lbl_BeginCreditBalance.Text = String.Format("{0:#,#}", col.Values[0]); } } } #endregion #region endBalance sql = "" + "select sum(beginbalance) as beginbalance " + "from " + "(select distinct d.IssueDate, -b.Credit as beginbalance, e.Code, d.FinancialTransactionDimId " + "from DiaryJournal_Fact a, " + "DiaryJournal_Detail b, " + "FinancialAccountDim c, " + "FinancialTransactionDim d, " + "CorrespondFinancialAccountDim e " + "where a.DiaryJournal_FactId = b.DiaryJournal_FactId " + "and a.FinancialAccountDimId = c.FinancialAccountDimId " + "and b.FinancialTransactionDimId = d.FinancialTransactionDimId " + "and b.CorrespondFinancialAccountDimId = e.CorrespondFinancialAccountDimId " + "and c.Code like '" + account + "%' " + "and (month(d.IssueDate) <= " + month.ToString() + " and year(d.IssueDate) = " + year.ToString() + " ) " + "and (b.Credit > 0) " + "and (len(e.Code) > 0 and e.Code != 'NAAN_DEFAULT')" + "and (b.FinancialAccountDimId is null) " + "and e.Code not in ('1','2','3','4','5','6','7','8') " + "union all " + "select distinct d.IssueDate, b.Debit as beginbalance, e.Name, d.FinancialTransactionDimId " + "from DiaryJournal_Fact a, " + "DiaryJournal_Detail b, " + "FinancialAccountDim c, " + "FinancialTransactionDim d, " + "CorrespondFinancialAccountDim e " + "where a.DiaryJournal_FactId = b.DiaryJournal_FactId " + "and a.FinancialAccountDimId = c.FinancialAccountDimId " + "and b.FinancialTransactionDimId = d.FinancialTransactionDimId " + "and b.CorrespondFinancialAccountDimId = e.CorrespondFinancialAccountDimId " + "and c.Code like '" + account + "%' " + "and (month(d.IssueDate) <= " + month.ToString() + " and year(d.IssueDate) = " + year.ToString() + " ) " + "and (b.Debit > 0) " + "and (len(e.Code) > 0 and e.Code != 'NAAN_DEFAULT')" + "and (b.FinancialAccountDimId is null) " + "and e.Code not in ('1','2','3','4','5','6','7','8') " + "union all " + "select null as IssueDate, b.Debit as beginbalance, null as Name, null as FinancialTransactionDimId " + "from BalanceForwardTransaction a, GeneralJournal b, " + "Account c, AccountingPeriod d, [Transaction] e " + "where a.TransactionId = b.TransactionId " + "and b.AccountId = c.AccountId " + "and a.TransactionId = e.TransactionId " + "and d.AccountingPeriodId = e.AccountingPeriodId " + "and b.Debit > 0 " + "and c.Code like '" + account + "%' " + "and (month(d.FromDateTime) = 1" + " and year(d.FromDateTime) = " + year.ToString() + ") " + ") aa "; seletectedData = session.ExecuteQuery(sql); foreach (var row in seletectedData.ResultSet) { foreach (var col in row.Rows) { if (col.Values[0] != null) { S04a4_DN.lbl_EndCreditBalance.Text = String.Format("{0:#,#}", col.Values[0]); } } } #endregion #endregion #region GridView header và table báo cáo GridView_header(FAD.FinancialAccountDimId, MD.MonthDimId, YD.YearDimId); //, OOD.OwnerOrgDimId DataTable dt = DT_Header(FAD.FinancialAccountDimId, MD.MonthDimId, YD.YearDimId); //, OOD.OwnerOrgDimId #endregion #region tao dong STT ngang cho tung cot DT_STT(dt); #endregion #region do du lieu vao DataTable DT_rowgetvalue(dt, FAD.FinancialAccountDimId, MD.MonthDimId, YD.YearDimId); //, OOD.OwnerOrgDimId #endregion #region Binđât vao Gridview xGridView.DataSource = dt; xGridView.DataBind(); #endregion } catch { } #region xuat report GridViewExporter.GridViewID = "xGridView"; S04a4_DN.pccData.PrintableComponent = new PrintableComponentLinkBase() { Component = GridViewExporter }; S04a4dnReportViewer.Report = S04a4_DN; #endregion }
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 }
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.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 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 }