public void RefreshFormat( ) { DataFormatProvider.FieldFormat format = DataFormatProvider.FieldFormat.Date; switch (formatType) { case ABCDateFormat.Date: format = DataFormatProvider.FieldFormat.Date; break; case ABCDateFormat.DateAndTime: format = DataFormatProvider.FieldFormat.DateAndTime; break; case ABCDateFormat.Month: format = DataFormatProvider.FieldFormat.Month; break; case ABCDateFormat.MonthAndYear: format = DataFormatProvider.FieldFormat.MonthAndYear; break; case ABCDateFormat.Time: format = DataFormatProvider.FieldFormat.Time; break; case ABCDateFormat.Year: format = DataFormatProvider.FieldFormat.Year; break; } DataFormatProvider.ABCFormatInfo formatInfo = DataFormatProvider.GetFormatInfo(format); // this.Properties.Appearance.TextOptions.HAlignment=DevExpress.Utils.HorzAlignment.Far; this.Properties.DisplayFormat.FormatType = formatInfo.FormatInfo.FormatType; this.Properties.DisplayFormat.FormatString = formatInfo.FormatInfo.FormatString; this.Properties.EditFormat.FormatType = formatInfo.FormatInfo.FormatType; this.Properties.EditFormat.FormatString = formatInfo.FormatInfo.FormatString; this.Properties.Mask.UseMaskAsDisplayFormat = true; this.Properties.Mask.EditMask = formatInfo.FormatInfo.FormatString; this.Properties.Mask.MaskType = formatInfo.MaskType; }
public void GetSearchQuery(ABCHelper.ConditionBuilder strBuilder, Control current) { if (current is ISearchControl) { String strResult = ((ISearchControl)current).SearchString; if (String.IsNullOrWhiteSpace(strResult) == false) { strBuilder.AddCondition(strResult); } } else if (current is IABCBindableControl) { System.Reflection.PropertyInfo proInfo = current.GetType().GetProperty((current as IABCBindableControl).BindingProperty); if (proInfo != null) { object objValue = proInfo.GetValue(current, null); if (objValue != null) { String strType = DataStructureProvider.GetCodingType((current as IABCBindableControl).TableName, (current as IABCBindableControl).DataMember); if (strType == "int" || strType == "Nullable<int>" || strType == "double" || strType == "Nullable<double>" || strType == "bool" || strType == "Nullable<bool>") { strBuilder.AddCondition(String.Format(" [{0}] = {1} ", (current as IABCBindableControl).DataMember, objValue)); } if (strType == "String" || strType == "Nullable<String>") { strBuilder.AddCondition(String.Format(" [{0}] LIKE '%{1}%' ", (current as IABCBindableControl).DataMember, objValue.ToString())); } if (strType == "Guid" || strType == "Nullable<Guid>") { strBuilder.AddCondition(String.Format(" [{0}] = '{1}' ", (current as IABCBindableControl).DataMember, objValue.ToString())); } if (strType == "DateTime" || strType == "Nullable<DateTime>") { DataFormatProvider.FieldFormat format = DataFormatProvider.FieldFormat.None; DataFormatProvider.ABCFormatInfo formatInfo = DataFormatProvider.GetFormatInfo((current as IABCBindableControl).TableName, (current as IABCBindableControl).DataMember); if (formatInfo != null) { format = formatInfo.ABCFormat; } if (format == DataFormatProvider.FieldFormat.None) { format = DataFormatProvider.FieldFormat.Date; } DateTime dtValue1 = DateTime.MinValue; DateTime dtValue2 = DateTime.MaxValue; if (objValue is DateTime) { dtValue1 = Convert.ToDateTime(objValue); } if (objValue is Nullable <DateTime> && (objValue as Nullable <DateTime>).HasValue) { dtValue1 = (objValue as Nullable <DateTime>).Value; } if (format == DataFormatProvider.FieldFormat.Month || format == DataFormatProvider.FieldFormat.MonthAndYear) { dtValue1 = new DateTime(dtValue1.Year, dtValue1.Month, 1); dtValue2 = dtValue1.AddMonths(1).AddSeconds(-30); } else if (format == DataFormatProvider.FieldFormat.Year) { dtValue1 = new DateTime(dtValue1.Year, 1, 1); dtValue2 = dtValue1.AddYears(1).AddSeconds(-30); } else { dtValue1 = new DateTime(dtValue1.Year, dtValue1.Month, dtValue1.Day); dtValue2 = dtValue1; } String strFrom = TimeProvider.GenCompareDateTime((current as IABCBindableControl).DataMember, ">=", dtValue1); String strTo = TimeProvider.GenCompareDateTime((current as IABCBindableControl).DataMember, "<=", dtValue2); strBuilder.AddCondition(String.Format(" ( {0} AND {1} ) ", strFrom, strTo)); } } } } foreach (Control ctrl in current.Controls) { GetSearchQuery(strBuilder, ctrl); } }
public static List <Type> GetControlTypes(String strTableName, String strFieldName) { List <Type> lstTypes = new List <Type>(); String[] strArr = strFieldName.Split(':'); if (strArr.Length <= 0) { return(lstTypes); } if (strArr.Length == 1) { #region Level 1 String strFieldNameTemp = strArr[0]; String strTableNameTemp = strTableName; if (DataStructureProvider.IsForeignKey(strTableNameTemp, strFieldNameTemp)) { #region Foreign Key lstTypes.Add(typeof(ABCLookUpEdit)); lstTypes.Add(typeof(ABCTextEdit)); lstTypes.Add(typeof(ABCGridLookUpEdit)); lstTypes.Add(typeof(ABCRadioGroup)); lstTypes.Add(typeof(ABCCheckedListBox)); if (DataStructureProvider.GetTableNameOfForeignKey(strTableNameTemp, strFieldNameTemp) == "GEPeriods") { lstTypes.Add(typeof(ABCPeriodEdit)); } #endregion } else { String strEnumName = DataConfigProvider.TableConfigList[strTableNameTemp].FieldConfigList[strFieldNameTemp].AssignedEnum; if (String.IsNullOrWhiteSpace(strEnumName) == false && EnumProvider.EnumList.ContainsKey(strEnumName)) { #region Enum lstTypes.Add(typeof(ABCLookUpEdit)); lstTypes.Add(typeof(ABCRadioGroup)); lstTypes.Add(typeof(ABCCheckedListBox)); #endregion } else { #region Common String strType = DataStructureProvider.GetCodingType(strTableNameTemp, strFieldNameTemp); if (strType == "DateTime" || strType == "Nullable<DateTime>") { lstTypes.Add(typeof(ABCDateEdit)); lstTypes.Add(typeof(ABCTimeEdit)); lstTypes.Add(typeof(ABCMonthYearEdit)); } if (strType == "int" || strType == "Nullable<int>") { lstTypes.Add(typeof(ABCTextEdit)); lstTypes.Add(typeof(ABCSpinEdit)); DataFormatProvider.ABCFormatInfo formatInfo = DataFormatProvider.GetFormatInfo(strTableNameTemp, strFieldNameTemp); if (formatInfo != null) { if (formatInfo.ABCFormat == DataFormatProvider.FieldFormat.Year) { lstTypes.Add(typeof(ABCYearEdit)); } if (formatInfo.ABCFormat == DataFormatProvider.FieldFormat.Month || formatInfo.ABCFormat == DataFormatProvider.FieldFormat.MonthAndYear) { lstTypes.Add(typeof(ABCMonthEdit)); } } } if (strType == "String" || strType == "Nullable<String>") { lstTypes.Add(typeof(ABCTextEdit)); lstTypes.Add(typeof(ABCLabel)); lstTypes.Add(typeof(ABCMemoEdit)); lstTypes.Add(typeof(ABCMemoExEdit)); lstTypes.Add(typeof(ABCRichEditControl)); } if (strType == "double" || strType == "decimal" || strType == "Nullable<double>" || strType == "Nullable<decimal>") { lstTypes.Add(typeof(ABCTextEdit)); lstTypes.Add(typeof(ABCSpinEdit)); lstTypes.Add(typeof(ABCCalcEdit)); } if (strType == "bool" || strType == "Nullable<bool>") { lstTypes.Add(typeof(ABCCheckEdit)); lstTypes.Add(typeof(ABCCheckPanel)); lstTypes.Add(typeof(ABCRadioGroup)); // lstTypes.Add( typeof( ABCCheckedListBox ) ); } #endregion } } lstTypes.Add(typeof(ABCSearchControl)); #endregion } else { #region Level n String strFieldNameTemp = String.Empty; String strTableNameTemp = strTableName; for (int i = 0; i < strArr.Length; i++) { strFieldNameTemp = strArr[i]; if (DataStructureProvider.IsForeignKey(strTableNameTemp, strFieldNameTemp) == false) { break; } strTableNameTemp = DataStructureProvider.GetTableNameOfForeignKey(strTableNameTemp, strFieldNameTemp); } String strType = DataStructureProvider.GetCodingType(strTableNameTemp, strFieldNameTemp); if (strType == "DateTime" || strType == "Nullable<DateTime>") { lstTypes.Add(typeof(ABCDateEdit)); lstTypes.Add(typeof(ABCTimeEdit)); } if (strType == "int" || strType == "double" || strType == "decimal" || strType == "Nullable<int>" || strType == "Nullable<double>" || strType == "Nullable<decimal>") { lstTypes.Add(typeof(ABCTextEdit)); lstTypes.Add(typeof(ABCLabel)); } if (strType == "String" || strType == "Nullable<String>") { lstTypes.Add(typeof(ABCTextEdit)); lstTypes.Add(typeof(ABCLabel)); lstTypes.Add(typeof(ABCMemoEdit)); lstTypes.Add(typeof(ABCRichEditControl)); } if (strType == "bool" || strType == "Nullable<bool>") { lstTypes.Add(typeof(ABCCheckEdit)); lstTypes.Add(typeof(ABCCheckPanel)); } #endregion } return(lstTypes); }