public InventoryDim get_InventoryDim_1(Session session, string Name, short RowStatus)
{
try
{
InventoryDim IDim = session.FindObject <InventoryDim>(
CriteriaOperator.And(
new BinaryOperator("Name", Name, BinaryOperatorType.Equal),
new BinaryOperator("RowStatus", RowStatus, BinaryOperatorType.Equal)
));
if (IDim == null)
{
return(null);
}
return(IDim);
}
catch (Exception) { return(null); }
}
public InventoryDim GetInventoryDim(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);
InventoryDim inventoryDim = session.FindObject <InventoryDim>(criteria);
if (inventoryDim == null)
{
return(CreateInventoryDim(session, RefId));
}
return(inventoryDim);
}
catch
{
return(null);
}
}
public InventoryDim CreateInventoryDim(Session session, Guid RefId)
{
try
{
NAS.DAL.Nomenclature.Inventory.Inventory inventory = session.GetObjectByKey <NAS.DAL.Nomenclature.Inventory.Inventory>(RefId);
if (inventory == null)
{
return(null);
}
InventoryDim inventoryDim = new InventoryDim(session);
inventoryDim.Code = inventory.Code;
inventoryDim.Description = inventory.Description;
inventoryDim.RefId = RefId;
inventoryDim.Name = inventory.Name;
inventoryDim.RowStatus = Constant.ROWSTATUS_ACTIVE;
inventoryDim.Save();
return(inventoryDim);
}
catch (Exception)
{
return(null);
}
}
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
}
