public DataTable FillGrid()
{
_sqlRequestSelect.SqlAnswer.datatable.Clear();
_data.Clear();
_sqlRequestSelect.SetParametrValue("@p_TypeScreen", ScreenType.ScreenTypeGrid);
_sqlRequestSelect.ComplexRequest(get_store_procedure, CommandType.StoredProcedure, null);
_data = _sqlRequestSelect.SqlAnswer.datatable;
return(_data);
}
public DataTable SetCategorySave(LocalRow localRow)
{
_sqlSave.SqlAnswer.datatable.Clear();
_table.Clear();
//p_TempTable
_sqlSave.SetParametrValue("@p_FlagTable", localRow.TempTable);
_sqlSave.SetParametrValue("@p_MassCategoryProduct", localRow.MassCategoryProduct);
_sqlSave.SetParametrValue("@p_MassCategoryIDProduct", localRow.MassCategoryIDProduct);
_sqlSave.SetParametrValue("@p_MassDescriptionProduct", localRow.MassCategoryDescriptionProduct);
_sqlSave.SetParametrValue("@p_MassCategoryProductDetails", localRow.MassCategoryProductDetails);
_sqlSave.SetParametrValue("@p_MassCategoryProductID", localRow.MassCategoryProductID);
_sqlSave.SetParametrValue("@p_MassCategoryIDProductDetails", localRow.MassCategoryIDProductDetails);
_sqlSave.SetParametrValue("@p_MassDescriptionProductDetails", localRow.MassDescriptionProductDetails);
_sqlSave.SetParametrValue("@p_MassCategoryRelay", localRow.MassCategoryRelay);
_sqlSave.SetParametrValue("@p_MassDescriptionRelay", localRow.MassCategoryIDRelay);
_sqlSave.SetParametrValue("@p_MassCategoryIDRelay", localRow.MassCategoryDescriptionRelay);
_sqlSave.SetParametrValue("@p_MassCategoryRelayDetails", localRow.MassCategoryRelayDetails);
_sqlSave.SetParametrValue("@p_MassCategoryRelayID", localRow.MassCategoryRelayID);
_sqlSave.SetParametrValue("@p_MassCategoryIDRelayDetails", localRow.MassCategoryIDRelayDetails);
_sqlSave.SetParametrValue("@p_MassDescriptionRelayDetails", localRow.MassDescriptionRelayDetails);
_sqlSave.ComplexRequest(_getSaveCategory, CommandType.StoredProcedure, null);
_table = _sqlSave.SqlAnswer.datatable;
return(_table);
}
public DataTable FillGridAllFilter()
{
_sqlRequestSelectFilters.SqlAnswer.datatable.Clear();
_data.Clear();
_sqlRequestSelectFilters.ComplexRequest(get_filters_procedure, CommandType.StoredProcedure, null);
_data = _sqlRequestSelectFilters.SqlAnswer.datatable;
return(_data);
}
public DataTable SelectCategoryRelay()
{
_sqlTreeViewRelaySting.SqlAnswer.datatable.Clear();
_table.Clear();
_sqlTreeViewRelaySting.ComplexRequest(_getSelectCategoryRelayTreeView, CommandType.StoredProcedure, null);
_table = _sqlTreeViewRelaySting.SqlAnswer.datatable;
return(_table);
}
public DataTable SelectCategory(Int32 _typetab)
{
_sqlSting.SqlAnswer.datatable.Clear();
_table.Clear();
_sqlSting.SetParametrValue("@p_typeTable", _typetab);
_sqlSting.ComplexRequest(_getSelectCategoryTable, CommandType.StoredProcedure, null);
_table = _sqlSting.SqlAnswer.datatable;
return(_table);
}
public DataTable Select(LocalFilter filterlocal)
{
_sqlSting.SqlAnswer.datatable.Clear();
_table.Clear();
_sqlSting.SetParametrValue("@p_rowcountpage", filterlocal.RowsCountPage);
_sqlSting.SetParametrValue("@p_pagecountrow", filterlocal.PageCountRows);
_sqlSting.ComplexRequest(_getSelectPurchaseTable, CommandType.StoredProcedure, null);
_table = _sqlSting.SqlAnswer.datatable;
return(_table);
}
public DataTable FillSummary(LocalFilter _localFilter)
{
_sqlRequestSelectSummary.SqlAnswer.datatable.Clear();
_data.Clear();
_sqlRequestSelectSummary.SetParametrValue("@p_TypeScreen", ScreenType.ScreenTypeGrid);
_sqlRequestSelectSummary.SetParametrValue("@p_Search", _localFilter.Search);
_sqlRequestSelectSummary.SetParametrValue("@p_CreatedUserID ", _localFilter.CreatedByUserID);
_sqlRequestSelectSummary.SetParametrValue("@p_LastModifiedUserID ", _localFilter.LastModifiedByUserID);
_sqlRequestSelectSummary.SetParametrValue("@p_Status", _localFilter.Status);
_sqlRequestSelectSummary.SetParametrValue("@p_Quantity_Min", _localFilter.QuantityMin);
_sqlRequestSelectSummary.SetParametrValue("@p_Quantity_Max ", _localFilter.QuantityMax);
_sqlRequestSelectSummary.SetParametrValue("@p_TagPriceVATRUS_Min", _localFilter.AmountMin);
_sqlRequestSelectSummary.SetParametrValue("@p_TagPriceVATRUS_Max ", _localFilter.AmountMax);
_sqlRequestSelectSummary.SetParametrValue("@p_FromCreatedDate ", _localFilter.FromCreatedDate);
_sqlRequestSelectSummary.SetParametrValue("@p_ToCreatedDate ", _localFilter.ToCreatedDate);
_sqlRequestSelectSummary.SetParametrValue("@p_FromLastModifiedDate ", _localFilter.FromLastModifiedDate);
_sqlRequestSelectSummary.SetParametrValue("@p_ToLastModifiedDate ", _localFilter.ToLastModifiedDate);
_sqlRequestSelectSummary.ComplexRequest(get_summary_procedure, CommandType.StoredProcedure, null);
_data = _sqlRequestSelectSummary.SqlAnswer.datatable;
return(_data);
}