public GeneralDataProviderItem GetCurrentItem(FormPositioningEnum Positioning, bool UpdateFromUI)
{
GeneralDataProviderItem Item;
if (!IsPostBack && GetStartFilterPosition() != "")
{
DataProvider.FiltroAtual = DataProvider.StartFilter;
DataSet ds = DataProvider.SelectAllItems();
DataRow[] drs = ds.Tables[0].Select(GetStartFilterPosition().Replace("N'", "'"));
if (drs.Length > 0)
{
DataProvider.PageNumber = ds.Tables[0].Rows.IndexOf(drs[0]) + 1;
Item = DataProvider.SelectItem(true, DataProvider.PageNumber, FormPositioningEnum.None, UpdateFromUI);
}
else
{
Item = DataProvider.SelectItem(true, PageNumber, Positioning, UpdateFromUI);
}
}
else
{
Item = DataProvider.SelectItem(true, PageNumber, Positioning, UpdateFromUI);
}
return(Item);
}
protected void PageShow(FormPositioningEnum Positioning, bool ShouldClearFields, bool RebindGrid, bool UpdateFromUI)
{
if (PageState == FormStateEnum.Navigation && CanView)
{
DisableEnableContros(false); // Habilita Enable ou Disable dos controles da tela
}
if (PageOperations.None)
{
if (PageHolder != null)
{
PageHolder.Visible = false;
}
DefinePageContent(null);
InitializeAlias(null);
FillAuxiliarTables();
ShowFormulas();
return;
}
bool IsInsertig = (PageState == FormStateEnum.Insert);
GeneralDataProviderItem Item;
if (!IsInsertig)
{
Item = GetCurrentItem(Positioning, UpdateFromUI);
if (Item == null && OpenInEditMode && !IsPostBack && PageState == FormStateEnum.Edit && CanView)
{
PageState = FormStateEnum.Navigation;
PageShow(FormPositioningEnum.First);
return;
}
// Para tabelas que sejam do tipo "Par??metros" vamos verificar se existe um registro.
// Caso n??o exista nenhum registro, iremos inserir um com valores default.
if (TableParameters.ToString().ToLower().Equals("true") && Item == null)
{
Item = GetDataProviderItem(DataProvider);
foreach (FieldBase Field in Item.Fields.Values)
{
if (Field is IntegerField || Field is LongField || Field is DecimalField)
{
Field.Value = 0;
}
if (Field is TextField || Field is DateField || Field is MemoField)
{
Field.Value = " ";
}
if (Field is BooleanField)
{
Field.Value = false;
}
if (Field is DateField)
{
Field.Value = new DateTime(1901, 01, 01);
}
}
DataProvider.InsertItem(Item);
Item = DataProvider.SelectItem(PageNumber, Positioning);
}
SetOldParameters(Item);
DefinePageContent(Item);
if (Item != null && PageOperations.AllowRead)
{
if (!CanView)
{
ClearFields();
ShowInitialValues();
ShowFormulas();
}
}
else
{
ClearFields();
InitializeAlias(Item);
FillAuxiliarTables();
ShowInitialValues();
ShowFormulas();
}
}
if (IsInsertig || (DataProvider.PageCount == 0 && sWhere == "" && PageInsert) || (!CanView && PageInsert))
{
PageState = FormStateEnum.Insert;
DataProvider.PageNumber = PageNumber; // guarda o n??mero do registro para, caso cancelar a inclus??o, recuperar depois
Item = GetDataProviderItem(DataProvider);
ClearFields(ShouldClearFields);
//vamos reposicionar o item para atualizar formulas, etc etc etc etc etc ...
DataProvider.LocateRecord(Item);
}
if (DataProvider.PageCount > 0 || PageState == FormStateEnum.Insert)
{
SetStateGrid();
}
CreateHiddenFields();
if (RebindGrid)
{
GridRebind();
}
if (Positioning != FormPositioningEnum.Current && Positioning != FormPositioningEnum.None)
{
if (IsPostBack)
{
ResetDataList();
ResetRepeaterList();
}
}
}
protected void PageShow(FormPositioningEnum Positioning, bool ShouldClearFields, bool RebindGrid)
{
PageShow(Positioning, ShouldClearFields, RebindGrid, true);
}
protected void PageShow(FormPositioningEnum Positioning, bool ShouldClearFields)
{
PageShow(Positioning, ShouldClearFields, true);
}
public GeneralDataProviderItem GetCurrentItem(FormPositioningEnum Positioning, bool UpdateFromUI)
{
return(DataProvider.SelectItem(true, MainProvider.DataProvider.PageNumber, Positioning, UpdateFromUI));
}
/// <summary>
/// Carrega a pagina com os dados necess??rios
/// </summary>
protected void PageShow(FormPositioningEnum Positioning)
{
PageShow(Positioning, true);
}
public GeneralDataProviderItem GetCurrentItem(FormPositioningEnum Positioning, bool UpdateFromUI)
{
return(null);
}
public GeneralDataProviderItem SelectItem(bool ShouldLocateRecord, int CurrentPageNumber, FormPositioningEnum Positioning, bool UpdateFromUI)
{
//Zerando todos os parametros antes de usar novamente pois estava pegando os parametros dos selects feitos anteriormente
Select.Parameters.Clear();
string selectList = "";
Item = BasePage.GetDataProviderItem(this);
//vamos igualar os objetos de DAO para a mesma transacao
Select.Dao = Dao;
Count.Dao = Dao;
foreach (FieldBase Field in Item.Fields.Values)
{
string FieldName = Field.Name;
selectList += Select.Dao.PoeColAspas(FieldName) + ",";
}
Select.SqlQuery.Replace("{SQL_Select}", selectList.TrimEnd(','));
SetParameters((TableCommand)Select, ParameterType.Select, (Positioning == FormPositioningEnum.Current), this);
SetWhere(FiltroAtual);
PageCount = ExecuteCount();
switch (Positioning)
{
case FormPositioningEnum.None:
PageNumber = CurrentPageNumber;
break;
case FormPositioningEnum.Current:
PageNumber = CurrentPageNumber;
break;
case FormPositioningEnum.First:
PageNumber = 1;
break;
case FormPositioningEnum.Previous:
PageNumber = CurrentPageNumber - 1;
break;
case FormPositioningEnum.Next:
PageNumber = CurrentPageNumber + 1;
break;
case FormPositioningEnum.Last:
PageNumber = PageCount;
break;
default:
PageNumber = CurrentPageNumber;
break;
}
if (PageNumber < 1)
{
PageNumber = 1;
}
if (PageNumber > PageCount)
{
this.PageNumber = PageCount;
}
DataSet ds = null;
if (PageCount > 0)
{
if (Positioning == FormPositioningEnum.Current)
{
ds = ExecuteSelect(0, 1);
}
else
{
ds = ExecuteSelect(PageNumber - 1, 1);
}
}
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
foreach (string Key in Item.Fields.Keys)
{
FieldBase Field = Item.Fields[Key];
string FieldName = Field.Name;
string format = (Item.Fields[Key].FieldType == FieldType.Date ? Select.DateFormat : "");
Item.Fields[Key].SetValue(dr[FieldName], format);
}
if (ShouldLocateRecord)
{
LocateRecord(Item, UpdateFromUI);
}
return(Item);
}
else
{
PageNumber = 0;
return(null);
}
}
public GeneralDataProviderItem SelectItem(bool ShouldLocateRecord, int CurrentPageNumber, FormPositioningEnum Positioning)
{
return(SelectItem(ShouldLocateRecord, CurrentPageNumber, Positioning, true));
}
/// <summary>
/// Efetua o select no banco de acordo com o filtro e numero da pagina
/// </summary>
/// <returns>Retorna item com o conteudo da celula que retornou no select</returns>
public GeneralDataProviderItem SelectItem(int CurrentPageNumber, FormPositioningEnum Positioning)
{
return(SelectItem(true, CurrentPageNumber, Positioning));
}
public GeneralDataProviderItem SelectItem(int CurrentPageNumber, FormPositioningEnum Positioning, bool ForceRelation)
{
return(SelectItem(CurrentPageNumber, Positioning, ForceRelation, BasePage.GetDataProviderItem(this)));
}
