public static string FormatDateTime(DataAvail.Data.DbContext.IDbContextWhereFormatter WhereFormatter, string Where, string[] DateTimeColumns)
{
System.Text.StringBuilder sb = new StringBuilder(Where);
int i = 0;
foreach (string dtField in DateTimeColumns)
{
int fIndex = sb.ToString().IndexOf(i == 0 ? dtField : " " + dtField, i);
while (fIndex != -1)
{
string str = sb.ToString();
fIndex += dtField.Length;
//Find first alphabetic character after field's name
char ch = str.ToCharArray().Skip(fIndex).FirstOrDefault(p => char.IsNumber(p));
if (ch != char.MinValue)
{
int dtValF = str.IndexOf(ch, fIndex);
if (dtValF != -1)
{
int dtValE = sb.Length;
//Find first not null & not numeric
ch = str.ToCharArray().Skip(dtValF).FirstOrDefault(p => char.IsLetter(p));
if (ch != char.MinValue)
dtValE = str.IndexOf(ch, dtValF);
//Substitute invariant value by formatted one
string dtVal = str.Substring(dtValF, dtValE - dtValF);
System.DateTime dt;
if (System.DateTime.TryParse(dtVal, System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out dt))
{
sb.Remove(dtValF, dtValE - dtValF);
sb.Insert(dtValF, WhereFormatter.Format(dt) + " ");
i = dtValF;
fIndex = sb.ToString().IndexOf(dtField, i);
continue;
}
}
}
fIndex = -1;
}
}
return sb.ToString();
}
internal XGNavButtonCommandItemStub(DevExpress.XtraEditors.ControlNavigator ControlNavigator, DevExpress.XtraEditors.NavigatorButton NavigatorButton, DataAvail.Controllers.Commands.ControllerCommandTypes CommandType)
: base(CommandType)
{
ControlNavigator.ButtonClick += new DevExpress.XtraEditors.NavigatorButtonClickEventHandler(ControlNavigator_ButtonClick);
_navigatorButton = NavigatorButton;
}
public DataAvail.XtraMenu.IXtraMenuButton this[DataAvail.XtraMenu.XtraMenuButtonType ButtonType]
{
get
{
return _buttons.SingleOrDefault(p => p.ButtonType == ButtonType);
}
}
protected virtual void OnXtraContainerCreated(DataAvail.XtraEditors.ObjectCreatedEventArgs args)
{
if (XtraContainerCreated != null)
{
XtraContainerCreated(this, args);
}
}
internal MenuItemStub(DataAvail.XtraMenu.IXtraMenuButton MenuButton, DataAvail.Controllers.Commands.ControllerCommandTypes CommandType)
: base(CommandType)
{
_menuButton = MenuButton;
_menuButton.ButtonClick += new EventHandler(_menuButton_ButtonClick);
}
internal DXBarButtonCommandItem(DataAvail.XtraBinding.Controllers.Commands.ControllerCommandTypes Type, DevExpress.XtraBars.BarButtonItem BarButtonItem)
: base(Type)
{
_barButtonItem = BarButtonItem;
_barButtonItem.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(_barButtonItem_ItemClick);
}
internal void UpdateProperties(DataAvail.XtraBindings.Calculator.ObjectProperties ObjectProperties)
{
foreach (var i in Items.Where(p=>p.Value.ExtBindingProperties != null))
{
i.Value.ExtBindingProperties.Reset(_controller.TableContext[i.Key.Name], ObjectProperties);
}
}
public DataAdapterAsync(System.Data.IDbConnection DbConnection,
DataAvail.Data.Function.Function Delete,
DataAvail.Data.Function.Function Update,
DataAvail.Data.Function.Function Insert)
: base(DbConnection, Delete, Update, Insert)
{
}
protected virtual void OnXtraSearchContainerCreating(DataAvail.XtraEditors.ObjectCreatingEventArgs args)
{
if (XtraSearchContainerCreating != null)
{
XtraSearchContainerCreating(this, args);
}
}
private static AppShellInitializerResult Initialize(
string ModelFileName,
string ModelViewFileName,
string ModelSecFileName,
DataAvail.XtraBinding.Calculator.IObjectCalculatorManager ObjectCalulatorManager)
{
System.Data.DataSet dataSet = BuildMetadata(ModelFileName);
XtraBindingControllerProvider controllerProvider = BuildControllerProvider(dataSet, ObjectCalulatorManager);
DataAvail.XtraBinding.Controllers.Controller.controllerContext = new ControllerContext(controllerProvider);
XOApplication xopCol = BuildStorage(ModelFileName, ModelViewFileName, ModelSecFileName, dataSet);
/*nimpl
InitializeControllersContext(xopCol);
FillStorage(dataSet, controllerProvider, xopCol);
InitializeAppApperance(xopCol.AppContext.ModelViewApp.AppMisc);
return new AppShellInitializerResult(xopCol.AppContext, DataAvail.XtraBinding.Controllers.Controller.controllerContext.Controllers);
*/
return null;
}
public XtraFormMenuButton(DevExpress.XtraBars.BarButtonItem BarButtonItem, DataAvail.XtraMenu.XtraMenuButtonType ButtonType)
{
_barButtonItem = BarButtonItem;
_buttonType = ButtonType;
BarButtonItem.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(BarButtonItem_ItemClick);
}
internal AppFieldContext(DataAvail.XOP.AppContext.AppItemContext AppItemContext, DataAvail.XtraObjectProperties.XtraFieldProperties XtraFieldProperties, DataAvail.XOP.ModelSecurity.ModelSecField ModelSecField)
{
_appItemContext = AppItemContext;
_xtraFieldProperties = XtraFieldProperties;
_modelSecField = ModelSecField;
}
internal XtraBinding Clone(DataAvail.XtraBindings.XtraBindingContainer ParentXtraBindingContainer)
{
XtraBindingChild xtraBindingChild = new XtraBindingChild(DataSource, xtraBindingOperation, new XtraBindingChildProperties(ParentXtraBindingContainer,
_xtraBindingChildProperties.parentObjectName, _xtraBindingChildProperties.parentFieldName,
_xtraBindingChildProperties.childObjectName, _xtraBindingChildProperties.fkFieldName));
return xtraBindingChild;
}
public XtraContainerFieldProperties(string FieldName, System.Type Type, DataAvail.XtraObjectProperties.XtraFieldProperties FieldProperties)
{
this.type = Type;
this.fieldProperties = FieldProperties;
this.fieldName = FieldName;
}
protected override void OnXtraSearchContainerCreating(DataAvail.XtraEditors.ObjectCreatingEventArgs args)
{
base.OnXtraSearchContainerCreating(args);
if (args.Object == null)
{
args.Object = new DataAvail.DX.XtraSearcherContainer.XtraSearchContainer(Controller);
}
}
protected override void OnXtraGridCreating(DataAvail.XtraEditors.ObjectCreatingEventArgs args)
{
base.OnXtraGridCreating(args);
if (args.Object == null)
{
args.Object = new DataAvail.DX.XtraGrid.XtraGrid((DataAvail.Controllers.Controller)args.controller);
}
}
public XtraListForm(DataAvail.Controllers.Controller Controller)
: base(Controller, false)
{
OnSerializationNameChanged();
Controller.ListUIFocusSearch += new EventHandler(Controller_ListUIFocusSearch);
Controller.ListUIFocusList += new EventHandler(Controller_ListUIFocusList);
}
internal CountrollerUI(DataAvail.XtraForm.XtraForm Form)
{
_form = Form;
_form.KeyPreview = true;
_form.KeyDown += new System.Windows.Forms.KeyEventHandler(_form_KeyDown);
Form.DataBound += new EventHandler(Form_DataBound);
}
protected override object CreateFieldControl(DataAvail.XtraContainerBuilder.XtraContainerBuilderControlType ControlType, XOFieldContext FieldContext)
{
/*
if (ControlType != DataAvail.XtraContainerBuilder.XtraContainerBuilderControlType.Custom)
return new DevExpress.XtraGrid.Columns.GridColumn();
else
return null;
*/
return new DevExpress.XtraGrid.Columns.GridColumn();
}
public IObjectCalculator GetObjectCalculator(DataAvail.XObject.XOTable XOTable)
{
switch (XOTable.Name)
{
case "DEAL":
return new DealCalculator();
case "CONTACT":
return new ContactCalculator();
default:
return ObjectCalculatorManager.DefaultObjectCalculator;
}
}
internal LookUpCommandItem(
LookUpEdit LookUpEdit,
DevExpress.XtraEditors.Controls.EditorButton Button,
DataAvail.Controllers.Commands.ControllerCommandTypes CommandType
) :
base(
LookUpEdit,
LookUpEdit.AppFieldContext,
LookUpEdit.DxEdit,
Button,
CommandType)
{
}
internal void Reset(XOFieldContext Field, DataAvail.XtraBindings.Calculator.ObjectProperties ObjectProperties)
{
this._field = Field;
_objectProperties = ObjectProperties;
BindingDefaultProperties.Reset(Field);
this.ControlProperties.ReadOnly = GetReadOnly();
this.ControlProperties.BackColor = GetBackColor();
this.ControlProperties.DataSource = GetDataSource();
this.ControlProperties.DataSourceFilter = GetDataSourceFilter();
this.ControlProperties.Mask = GetMask();
}
public XtraBindingOperation(object DataSource, DataAvail.Data.DataAdapter.IDataAdapter DataAdapter, Calculator.IObjectCalculator ObjectCalculator)
{
_dataSource = DataSource;
dataAdapter = DataAdapter;
_objectCalculator = ObjectCalculator;
_isAsync = dataAdapter is DataAvail.Data.DataAdapter.IDataAdapterAsync;
if (_isAsync)
{
((DataAvail.Data.DataAdapter.IDataAdapterAsync)dataAdapter).EndFill += new DataAvail.Data.DataAdapter.DataSyncAdapterEndFillHandler(XtraBindingOperation_EndFill);
}
}
public XtraFormController(DataAvail.Controllers.Controller Controller, bool ItemForm)
{
_controller = Controller;
_isItemUI = ItemForm;
if (ItemForm)
{
Controller.ItemInitializeUI += new EventHandler(Controller_InitializeUI);
}
else
{
Controller.ListInitializeUI += new EventHandler(Controller_InitializeUI);
}
this.IsAutoSerialize = false;
}
protected override object CreateFieldControl(DataAvail.XtraContainerBuilder.XtraContainerBuilderControlType ControlType, XOFieldContext AppFieldContext)
{
switch (ControlType)
{
case DataAvail.XtraContainerBuilder.XtraContainerBuilderControlType.Text:
return new DataAvail.DX.XtraSearcherEditors.TextSearchEdit(AppFieldContext);
case DataAvail.XtraContainerBuilder.XtraContainerBuilderControlType.Numeric:
return new DataAvail.DX.XtraSearcherEditors.TextSearchEdit(AppFieldContext);
case DataAvail.XtraContainerBuilder.XtraContainerBuilderControlType.Date:
return new DataAvail.DX.XtraSearcherEditors.DateRangeSearchEdit(AppFieldContext);
case DataAvail.XtraContainerBuilder.XtraContainerBuilderControlType.Combo:
return new DataAvail.DX.XtraSearcherEditors.LookUpSearchEdit(AppFieldContext);
case DataAvail.XtraContainerBuilder.XtraContainerBuilderControlType.Custom:
return base.CreateFieldControl(ControlType, AppFieldContext);
}
return null;
}
internal ButtonCommandItem(
DataAvail.XtraEditors.IXtraEdit XtraEdit,
XOFieldContext AppFieldContext,
DevExpress.XtraEditors.ButtonEdit ButtonEdit,
DevExpress.XtraEditors.Controls.EditorButton Button,
DataAvail.Controllers.Commands.ControllerCommandTypes CommandType) :
base(CommandType)
{
_xtraEdit = XtraEdit;
_appFieldContext = AppFieldContext;
_buttonEdit = ButtonEdit;
_button = Button;
_buttonEdit.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(Properties_ButtonClick);
}
public DataAvail.XtraBinding.Controllers.IControllerUI Create(DataAvail.XtraBinding.Controllers.Controller Controller, bool ItemUI)
{
if (ItemUI)
{
DataAvail.DX.XtraReportForm.XtraReportForm reportForm = new DataAvail.DX.XtraReportForm.XtraReportForm((DataAvail.XtraBinding.Controllers.Controller)Controller);
return new CountrollerUI(reportForm);
}
else
{
DataAvail.DX.XtraListForm.XtraListForm listForm = new DataAvail.DX.XtraListForm.XtraListForm((DataAvail.XtraBinding.Controllers.Controller)Controller);
if (Controller.TableContext.IsDefaultContext)
{
listForm.MdiParent = this._mdiParent;
}
return new CountrollerUI(listForm);
}
}
public XtraReportForm(DataAvail.Controllers.Controller Controller)
: base(Controller, true)
{
OnSerializationNameChanged();
}
protected override bool ItemSelect(DataAvail.Controllers.Commands.IControllerCommandItem CommandItem)
{
_result = this.XtraBinding.GetCurrentItemValue(_valueFieldName);
return this.Commands.Execute(DataAvail.Controllers.Commands.ControllerCommandTypes.ListClose);
}
internal XtraBindingControllerProvider(System.Data.DataSet DataSet, DataAvail.XtraBinding.Calculator.IObjectCalculatorManager ObjectCalculatorManager)
{
_dataSet = DataSet;
_objectCalculatorManager = ObjectCalculatorManager;
}
