public ItemDim get_ItemDim_1(Session session, string Name, short RowStatus)
{
try
{
ItemDim ID = session.FindObject <ItemDim>(
CriteriaOperator.And(
new BinaryOperator("Name", Name, BinaryOperatorType.Equal),
new BinaryOperator("RowStatus", RowStatus, BinaryOperatorType.Equal)
));
if (ID == null)
{
return(null);
}
return(ID);
}
catch (Exception) { return(null); }
}
public ItemDim GetItemDim(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);
ItemDim itemDim = session.FindObject <ItemDim>(criteria);
if (itemDim == null)
{
return(CreateItemDim(session, RefId));
}
return(itemDim);
}
catch
{
return(null);
}
}
public ItemDim CreateItemDim(Session session, Guid RefId)
{
try
{
NAS.DAL.Nomenclature.Item.Item item = session.GetObjectByKey <NAS.DAL.Nomenclature.Item.Item>(RefId);
if (item == null)
{
return(null);
}
ItemDim itemDim = new ItemDim(session);
itemDim.Code = item.Code;
itemDim.Description = item.Description;
itemDim.RefId = RefId;
itemDim.Name = item.Name;
itemDim.RowStatus = Constant.ROWSTATUS_ACTIVE;
itemDim.Save();
return(itemDim);
}
catch (Exception)
{
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)
{
}
}
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.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.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
}
