public static void SetControlFormat(Control control, String strTableName, String strFieldString) { if (control is DevExpress.XtraEditors.BaseEdit && control is IDontNeedFormatControl == false) { DevExpress.XtraEditors.BaseEdit editControl = control as DevExpress.XtraEditors.BaseEdit; ABCFormatInfo formatInfo = GetFormatInfo(strTableName, strFieldString); if (formatInfo != null) { editControl.Properties.Appearance.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; editControl.Properties.DisplayFormat.FormatType = FormatType.None; editControl.Properties.DisplayFormat.FormatString = String.Empty; editControl.Properties.EditFormat.FormatType = FormatType.None; editControl.Properties.EditFormat.FormatString = String.Empty; if (editControl.Properties is DevExpress.XtraEditors.Repository.RepositoryItemTextEdit) { (editControl.Properties as DevExpress.XtraEditors.Repository.RepositoryItemTextEdit).Mask.UseMaskAsDisplayFormat = true; (editControl.Properties as DevExpress.XtraEditors.Repository.RepositoryItemTextEdit).Mask.EditMask = formatInfo.EditMask; (editControl.Properties as DevExpress.XtraEditors.Repository.RepositoryItemTextEdit).Mask.MaskType = formatInfo.MaskType; } else { editControl.Properties.DisplayFormat.FormatType = formatInfo.FormatInfo.FormatType; editControl.Properties.DisplayFormat.FormatString = formatInfo.FormatInfo.FormatString; editControl.Properties.EditFormat.FormatType = formatInfo.FormatInfo.FormatType; editControl.Properties.EditFormat.FormatString = formatInfo.FormatInfo.FormatString; } } } }
private void FieldLinkClearValues(Control.ControlCollection ctrls) { if (ctrls != null) { foreach (Control ctrl in ctrls) { if (ctrl != null) { if (!string.IsNullOrEmpty(ctrl.Name)) { if (_hfields.ContainsKey(ctrl.Name)) { FieldInfo fi = (FieldInfo)_hfields[ctrl.Name]; if (fi != null && !string.IsNullOrEmpty(fi.dbfieldname)) { fi.value = null; if (ctrl is DevExpress.XtraEditors.BaseEdit) { DevExpress.XtraEditors.BaseEdit lue = (DevExpress.XtraEditors.BaseEdit)ctrl; lue.EditValue = DBNull.Value; } } } } if (ctrl.Controls != null) { FieldLinkClearValues(ctrl.Controls); } } } } }
private void view_ShownEditor(object sender, EventArgs e) { if (((GridView)sender).FocusedColumn.FieldName == "CheckedInGrid") { _chkView = ((GridView)sender); _chkEditor = ((GridView)sender).ActiveEditor; _chkEditor.EditValueChanged += new EventHandler(ColumnEdit_EditValueChanged); } }
private void view_HiddenEditor(object sender, EventArgs e) { if (_chkEditor != null) { _chkEditor.EditValueChanged -= new EventHandler(ColumnEdit_EditValueChanged); _chkEditor = null; _chkView = null; } }
private void FieldLinkSetSaveState(Control.ControlCollection ctrls) { if (ctrls != null) { foreach (Control ctrl in ctrls) { if (ctrl != null) { if (!string.IsNullOrEmpty(ctrl.Name)) { if (_hfields.ContainsKey(ctrl.Name)) { FieldInfo fi = (FieldInfo)_hfields[ctrl.Name]; if (fi != null) { ((DevExpress.XtraEditors.BaseEdit)ctrl).Properties.ReadOnly = true; ctrl.BackColor = System.Drawing.Color.FromKnownColor(System.Drawing.KnownColor.Control); DevExpress.XtraEditors.BaseEdit edit = (DevExpress.XtraEditors.BaseEdit)ctrl; fi.value = edit.EditValue; #region Setting specified table row with new value if (_dataset != null) { if (fi.tableindex >= 0 && fi.tableindex < _dataset.Tables.Count) { DataTable dt = _dataset.Tables[fi.tableindex]; if (dt.Columns.Contains(fi.dbfieldname)) { if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; if (this._gridview != null) { dr = dt.Rows[this._gridview.GetFocusedDataSourceRowIndex()]; } dr[fi.dbfieldname] = edit.EditValue == null ? DBNull.Value : edit.EditValue; } } } } #endregion } } } if (ctrl.Controls != null) { FieldLinkSetSaveState(ctrl.Controls); } } } } }
private void luPart_EditValueChanged(object sender, EventArgs e) { DevExpress.XtraEditors.BaseEdit edit = gridView1.ActiveEditor; switch (gridView1.FocusedColumn.FieldName) { case "DG003": string str = getPart.Select("GS07='" + edit.EditValue + "'") [0] ["GS10"].ToString( ); gridView1.SetFocusedRowCellValue(gridView1.Columns ["DG006"], str); break; } }
public void BaseEdit_SetEditValue(DevExpress.XtraEditors.BaseEdit baseEdit, object value) { if (baseEdit.InvokeRequired) { baseEdit.Invoke(new Action(() => { baseEdit.EditValue = value; })); } else { baseEdit.EditValue = value; } }
private void lupPro_EditValueChanged(object sender, System.EventArgs e) { DevExpress.XtraEditors.BaseEdit edit = bandedGridView1.ActiveEditor; switch (bandedGridView1.FocusedColumn.FieldName) { case "CI012": if (edit.EditValue != null) { _ci.CI002 = tablePro.Select("CI012='" + edit.EditValue + "'") [0] ["CI002"].ToString( ); _ci.CI003 = tablePro.Select("CI012='" + edit.EditValue + "'") [0] ["CI003"].ToString( ); _ci.CI004 = tablePro.Select("CI012='" + edit.EditValue + "'") [0] ["CI004"].ToString( ); string sl = tablePro.Select("CI012='" + edit.EditValue + "'") [0] ["CI019"].ToString( ); bandedGridView1.SetFocusedRowCellValue(bandedGridView1.Columns ["CI002"], _ci.CI002); bandedGridView1.SetFocusedRowCellValue(bandedGridView1.Columns ["CI003"], _ci.CI003); bandedGridView1.SetFocusedRowCellValue(bandedGridView1.Columns ["CI004"], _ci.CI004); bandedGridView1.SetFocusedRowCellValue(bandedGridView1.Columns ["CI019"], sl); } break; } }
private void FieldValidate(Control.ControlCollection ctrls, ref int number, ref Control first, ref ArrayList mandatories) { if (ctrls != null) { foreach (Control ctrl in ctrls) { if (ctrl != null) { if (!string.IsNullOrEmpty(ctrl.Name)) { if (_hfields.ContainsKey(ctrl.Name)) { FieldInfo fi = (FieldInfo)_hfields[ctrl.Name]; if (fi != null) { if (ctrl is DevExpress.XtraEditors.BaseEdit) { DevExpress.XtraEditors.BaseEdit edit = (DevExpress.XtraEditors.BaseEdit)ctrl; if (fi.ismandatory && (edit.EditValue == null || edit.EditValue == DBNull.Value || Convert.ToString(edit.EditValue) == "")) { number++; if (first == null) { first = ctrl; } mandatories.Add(string.Format("{0}. {1}", number, ((DevExpress.XtraEditors.BaseEdit)ctrl).ToolTipTitle)); } } } } } if (ctrl.Controls != null) { FieldValidate(ctrl.Controls, ref number, ref first, ref mandatories); } } } } }
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { DevExpress.XtraEditors.BaseEdit edit = gridView1.ActiveEditor; switch (gridView1.FocusedColumn.FieldName) { case "CO007": txtCriResu.Text = CO007.SummaryItem.SummaryValue.ToString( ); break; case "CO008": txtGraResu.Text = CO008.SummaryItem.SummaryValue.ToString( ); break; case "CO009": txtSinResu.Text = CO009.SummaryItem.SummaryValue.ToString( ); break; case "CO003": if (edit.Text != null) { DataTable dt = _bll.getSam(_co.CO003); if (dt != null && dt.Rows.Count > 0) { _co.CO004 = string.IsNullOrEmpty(dt.Rows [0] ["CL003"].ToString( )) == true ? 0 : Convert.ToInt32(dt.Rows [0] ["CL003"].ToString( )); //gridView1 . SetRowCellValue ( e . RowHandle ,gridView1 . Columns [ "CO004" ] ,dt . Rows [ 0 ] [ "CL003" ] . ToString ( ) ); txtGraYes.Text = dt.Rows [0] ["CL004"].ToString( ); txtGraNo.Text = dt.Rows [0] ["CL005"].ToString( ); txtSinYes.Text = dt.Rows [0] ["CL006"].ToString( ); txtSinNo.Text = dt.Rows [0] ["CL007"].ToString( ); } } txtCriResu.Text = CO007.SummaryItem.SummaryValue.ToString( ); txtGraResu.Text = CO008.SummaryItem.SummaryValue.ToString( ); txtSinResu.Text = CO009.SummaryItem.SummaryValue.ToString( ); break; } }
private void gridView1_ShownEditor(object sender, EventArgs e) { try { if (gridView1.GetFocusedDataRow() == null) // IF NO 'NEXT' DATA ROW -- you gota create it { InitDtTempTableDataRow(); // CREATE AND ADD THE NEW NEXT DATA ROW INTO THE DATA TABLE gridView1.GetFocusedDataRow(); // Focus on the new row just added here gridView1.ShowEditor(); // Show the NEW ROW && CELL'S EDITOR } ROW = gridView1.FocusedRowHandle; // CLASS VAR SET HERE - the focused row handle - grid/gridview index COL = gridView1.FocusedColumn; // CLASS VAR SET HERE - the grid/gridview column deXEdit = gridView1.ActiveEditor; // CLASS VAR SET HERE - A pointer to the active editor tenKeypadControl11.CurrentValue = (Convert.ToString(dtTempTable.Rows[ROW][COL.AbsoluteIndex]) == "0" ? "" : Convert.ToString(dtTempTable.Rows[ROW][COL.AbsoluteIndex])); } catch (Exception exctp) { Trace.WriteLine(string.Format("gridView1_ShownEditor. TRY {ERROR} EXCEPTION MESSAGE = {0} ", exctp.Message)); Trace.WriteLine(string.Format("gridView1_ShownEditor. TRY {ERROR} EXCEPTION STACK TRACE = {0} ", exctp.StackTrace)); return; } }
public override void MainControl_Leave(object sender, EventArgs e) { if (GetGridStatu() != SingleForm.GridStatu.gsBrowse) { base.MainControl_Leave(sender, e); DevExpress.XtraEditors.BaseEdit edit = (sender as DevExpress.XtraEditors.BaseEdit); if (edit.Text.Trim() == "") { return; } string[] xADMMJ = null; string[] xParam = null; Dictionary <DevExpress.XtraEditors.BaseControl, int> xReturnFileds = new Dictionary <DevExpress.XtraEditors.BaseControl, int>(); if (edit.Name == "XN001") { xADMMJ = new string[] { "POSXC", "001" }; xParam = new string[] { edit.Text }; xReturnFileds.Add(XN001C, 0); } else if (edit.Name == "XN003") { if (XN002.EditValue.ToString() == "1") { xADMMJ = new string[] { "POSXL", "002" }; xParam = new string[] { XN001.Text, XN003.EditValue.ToString() }; } else if (XN002.EditValue.ToString() == "2") { xADMMJ = new string[] { "POSXB", "001" }; xParam = new string[] { XN001.Text, XN003.EditValue.ToString() }; } xReturnFileds.Add(XN003C, 1); } LeaveCheckMainFunc(edit, xADMMJ, xParam, xReturnFileds); } }
public static void SetDefaultChildAppreance(Control inSender) { foreach (Control oSender in inSender.Controls) { if (oSender.Controls.Count > 1) { SetDefaultChildAppreance(oSender); if (oSender is DevExpress.XtraGrid.GridControl) { DevExpress.XtraGrid.GridControl oGrid = oSender as DevExpress.XtraGrid.GridControl; if (oGrid.Views.Count > 0) { for (int i = 0; i < oGrid.Views.Count; i++) { DevExpress.XtraGrid.Views.Grid.GridView gv = oGrid.Views[i] as DevExpress.XtraGrid.Views.Grid.GridView; if (gv != null) { SetDefaultGridViewAppreance(gv); } } } } } else { if (oSender.Parent is DevExpress.XtraEditors.CalcEdit || oSender is DevExpress.XtraEditors.ButtonEdit || oSender is DevExpress.XtraEditors.ComboBoxEdit || oSender.Parent is DevExpress.XtraEditors.DateEdit || oSender.Parent is DevExpress.XtraEditors.SpinEdit || oSender.Parent.Parent is DevExpress.XtraGrid.GridControl) { DevExpress.XtraEditors.BaseEdit oSetCtrl = oSender as DevExpress.XtraEditors.BaseEdit; if (oSetCtrl != null) { oSetCtrl.Font = new System.Drawing.Font("Tahoma", 10, System.Drawing.FontStyle.Bold); //oSetCtrl.Font = new System.Drawing.Font("Tahoma", 10, System.Drawing.FontStyle.Regular); oSetCtrl.Properties.Appearance.BackColor = System.Drawing.Color.White; //oSetCtrl.Properties.AppearanceFocused.BackColor = System.Drawing.Color.Moccasin; //oSetCtrl.Properties.AppearanceFocused.BackColor = System.Drawing.Color.FromArgb(197, 217, 241); //Dark Blue //oSetCtrl.Properties.AppearanceFocused.BackColor = System.Drawing.Color.LemonChiffon; oSetCtrl.Properties.AppearanceFocused.BackColor = System.Drawing.Color.FromArgb(255, 238, 153); //à¢ÕÂÇẺ SAP oSetCtrl.Properties.AppearanceDisabled.BackColor = System.Drawing.SystemColors.ActiveBorder; oSetCtrl.Properties.AppearanceDisabled.ForeColor = System.Drawing.Color.Black; } if (oSender.Parent is DevExpress.XtraEditors.CalcEdit || oSender.Parent is DevExpress.XtraEditors.DateEdit || oSender.Parent is DevExpress.XtraEditors.SpinEdit || oSender is DevExpress.XtraEditors.ComboBoxEdit || oSender is DevExpress.XtraEditors.CalcEdit || oSender is DevExpress.XtraEditors.DateEdit || oSender is DevExpress.XtraEditors.SpinEdit) { oSetCtrl.KeyDown += new KeyEventHandler(txtSpin_KeyDown); } } else if (oSender is System.Windows.Forms.Label) { System.Windows.Forms.Label oSetCtrl = oSender as System.Windows.Forms.Label; if (oSetCtrl != null) { bool bllIsUnderLine = oSetCtrl.Font.Underline; bool bllIsItalic = oSetCtrl.Font.Italic; bool bllIsStrikeout = oSetCtrl.Font.Strikeout; System.Drawing.FontStyle fs = System.Drawing.FontStyle.Bold; if (oSetCtrl.Font.Underline) { fs = fs | System.Drawing.FontStyle.Underline; } if (oSetCtrl.Font.Italic) { fs = fs | System.Drawing.FontStyle.Italic; } if (oSetCtrl.Font.Strikeout) { fs = fs | System.Drawing.FontStyle.Strikeout; } oSetCtrl.Font = new System.Drawing.Font("Tahoma", 10, fs); //oSetCtrl.Font = new System.Drawing.Font("Tahoma", 10, System.Drawing.FontStyle.Regular); } } } //this.pgfMainEdit.AppearancePage.HeaderActive.BackColor = System.Drawing.Color.White; //this.pgfMainEdit.AppearancePage.HeaderActive.BackColor2 = System.Drawing.Color.SkyBlue; //this.pgfMainEdit.AppearancePage.HeaderActive.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(222))); //this.pgfMainEdit.AppearancePage.HeaderActive.GradientMode = System.Drawing.Drawing2D.LinearGradientMode.Vertical; //this.pgfMainEdit.AppearancePage.HeaderActive.Options.UseBackColor = true; //this.pgfMainEdit.AppearancePage.HeaderActive.Options.UseFont = true; //this.pgfMainEdit.AppearancePage.PageClient.BackColor = System.Drawing.Color.SkyBlue; //this.pgfMainEdit.AppearancePage.PageClient.Options.UseBackColor = true; //this.pgfMainEdit.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.NoBorder; } }
private void InitForm() { // 'LayoutControl1.RestoreLayoutFromXml("") DevExpress.XtraLayout.LayoutControlItem d_LayoutItem_new = new DevExpress.XtraLayout.LayoutControlItem(); DevExpress.XtraLayout.LayoutControlItem d_LayoutItem_old = new DevExpress.XtraLayout.LayoutControlItem(); DevExpress.XtraEditors.BaseEdit d_textedit = new DevExpress.XtraEditors.BaseEdit(); int d_row = 0; int d_column = 0; LayoutControlGroup1.AllowCustomizeChildren = false; string[,][] d_controllist = InitFormByXML(ref d_row, ref d_column); if (d_controllist == null) { d_controllist = InitFormNOTByXML(); d_row = 4; d_column = 4; } for (int i = 0; i < d_row; i++) { for (int j = 0; i < d_column; i++) { string[] d_control = d_controllist[i, j]; if (d_control.Length > 1) { d_LayoutItem_new = new DevExpress.XtraLayout.LayoutControlItem(); if (d_control[2] == "TextEdit") { d_textedit = new DevExpress.XtraEditors.TextEdit(); } else { d_textedit = new DevExpress.XtraEditors.ComboBoxEdit(); d_textedit.GotFocus += new EventHandler(TextChangeDmb_ComboBoxEdit_GotFocus); } if (d_control[3] == "true") { d_textedit.Properties.ReadOnly = true; } else { d_textedit.Properties.ReadOnly = false; } d_textedit.Name = d_control[1].ToString().ToLower() + "-" + d_control[2].ToString(); d_LayoutItem_new.Name = d_control[1].ToString().ToLower() + "-LayoutControlItem"; d_LayoutItem_new.Control = d_textedit; d_LayoutItem_new.Text = d_control[0]; if (d_LayoutItem_old == null) { d_LayoutItem_new = LayoutControlGroup1.AddItem(d_LayoutItem_new); } else { d_LayoutItem_new = LayoutControlGroup1.AddItem(d_LayoutItem_new, d_LayoutItem_old, DevExpress.XtraLayout.Utils.InsertType.Right); } d_LayoutItem_old = d_LayoutItem_new; } } d_LayoutItem_old = null; } int d_Height = 0; foreach (DevExpress.XtraLayout.LayoutControlItem d_LayoutItem in LayoutControlGroup1.Items) { d_LayoutItem.Size = new System.Drawing.Size(Width / d_column, d_LayoutItem.Size.Height); d_Height += d_LayoutItem.Size.Height; } DevExpress.XtraLayout.LayoutControlGroup d_report = new DevExpress.XtraLayout.LayoutControlGroup(); d_report = LayoutControl1.Root.AddGroup(); d_report.Text = "报告信息"; d_LayoutItem_new = new DevExpress.XtraLayout.LayoutControlItem(); //'d_LayoutItem_new = LayoutControlGroup1.AddItem(); reportinfo_RichTextBox = new HISItemText.HISItemText(); reportinfo_RichTextBox.Name = "reportinfo_RichTextBox"; d_LayoutItem_new.Control = reportinfo_RichTextBox; d_LayoutItem_new.Text = "诊断描述:"; // 'd_LayoutItem_new.Size = new Drawing.Size(Width, (Height - d_Height / 3) / 2); d_LayoutItem_new.AppearanceItemCaption.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Top; d_LayoutItem_new = d_report.AddItem(d_LayoutItem_new); d_LayoutItem_old = new DevExpress.XtraLayout.LayoutControlItem(); // 'd_LayoutItem_new = LayoutControlGroup1.AddItem reportend_RichTextBox = new HISItemText.HISItemText(); reportend_RichTextBox.Name = "reportend_RichTextBox"; d_LayoutItem_old.Control = reportend_RichTextBox; d_LayoutItem_old.Text = "诊断结论:"; d_LayoutItem_old.AppearanceItemCaption.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Top; // 'd_LayoutItem_old.Size = new Drawing.Size(Width, (Height - d_Height / 3) / 2); d_LayoutItem_old = d_report.AddItem(d_LayoutItem_old, d_LayoutItem_new, DevExpress.XtraLayout.Utils.InsertType.Bottom); }
private void repositoryItemComboBox1_EditValueChanged(object sender, EventArgs e) { DevExpress.XtraEditors.BaseEdit edit = gridView2.ActiveEditor; if (gridView2.FocusedColumn.FieldName == "GS71") { string result = string.Empty; switch (edit.EditValue.ToString()) { case "成品委外": result = "R_195"; break; case "热转印": result = "R_196"; break; case "装运.代理": result = "R_243"; break; case "胶合板": result = "R_338"; break; case "密度板": result = "R_338"; break; case "木材": result = "R_341"; break; case "车木件": result = "R_342"; break; case "铁件": result = "R_343"; break; case "塑料件": result = "R_347"; break; case "喷漆工资": result = "R_519.495"; break; case "油漆款": result = "R_519.339"; break; case "滚漆款": result = "R_519.344"; break; case "包装材料": result = "R_349.347"; break; case "/": result = "/"; break; } gridView2.SetFocusedRowCellValue("GS70", result); } }
public void SetSefOwnerEdit(DevExpress.XtraEditors.BaseEdit edit) { this.SetOwnerEdit(edit); }
/// <summary> /// 为控件赋值 /// </summary> /// <param name="dr"></param> /// <returns></returns> protected bool SetControlData(DataRow dr) { try { List <Control> listControl = DSCommon.FindControl(panelControlMain); foreach (Control ctrl in listControl) { string fieldName = ctrl.Name; if (!dr.Table.Columns.Contains(fieldName)) { continue; //跳过不在表中的控件 } object fieldValue = dr[fieldName]; if (ctrl is Label) { ((Label)ctrl).Text = fieldValue == null ? null : fieldValue.ToString(); } else if (ctrl is TextBox) { TextBox tb = (TextBox)ctrl; tb.Text = fieldValue == null ? null : fieldValue.ToString(); if (dbOperaType == DbOperateType.View) { tb.ReadOnly = true; } } else if (ctrl is ComboBox) { ComboBox cb = (ComboBox)ctrl; cb.SelectedItem = fieldValue; } else if (ctrl is DevExpress.XtraEditors.DateEdit) { DevExpress.XtraEditors.DateEdit de = (DevExpress.XtraEditors.DateEdit)ctrl; de.EditValue = fieldValue; if (dbOperaType == DbOperateType.View) { de.ReadOnly = true; } } else if (ctrl is DevExpress.XtraEditors.LabelControl) { ((DevExpress.XtraEditors.LabelControl)ctrl).Text = fieldValue.ToString(); } else if (ctrl is DevExpress.XtraEditors.BaseEdit) { DevExpress.XtraEditors.BaseEdit be = (DevExpress.XtraEditors.BaseEdit)ctrl; be.EditValue = fieldValue; if (dbOperaType == DbOperateType.View) { be.ReadOnly = true; } } else { } } string[] other = { "province_id", "city_id", "eare_id" }; foreach (string item in other) { Control ctrl = listControl.Find((Control x) => x.Name == item); if (ctrl != null) { if (ctrl is DevExpress.XtraEditors.BaseEdit) { ((DevExpress.XtraEditors.BaseEdit)ctrl).EditValue = dr[item].ToString(); } } } return(true); } catch (Exception ex) { return(false); } }
private void FieldLinkSetValues(Control.ControlCollection ctrls) { if (ctrls != null) { foreach (Control ctrl in ctrls) { if (ctrl != null) { if (!string.IsNullOrEmpty(ctrl.Name)) { if (_hfields.ContainsKey(ctrl.Name)) { FieldInfo fi = (FieldInfo)_hfields[ctrl.Name]; if (fi != null && !string.IsNullOrEmpty(fi.dbfieldname)) { try { object value = fi.value; DataRow dr = null; if (_gridview != null) { #region Getting focused row from gridview if (_gridview.Columns.ColumnByFieldName(fi.dbfieldname.ToUpper()) != null) { dr = _gridview.GetFocusedDataRow(); } #endregion } else { #region Getting specified table row if (_dataset != null) { if (fi.tableindex >= 0 && fi.tableindex < _dataset.Tables.Count) { DataTable dt = _dataset.Tables[fi.tableindex]; if (dt.Columns.Contains(fi.dbfieldname)) { if (dt.Rows.Count > 0) { dr = dt.Rows[0]; } } } } #endregion } if (dr != null) { value = dr[fi.dbfieldname]; } #region Setting control values if (value == null || value == DBNull.Value) { if (ctrl is DevExpress.XtraEditors.BaseEdit) { DevExpress.XtraEditors.BaseEdit lue = (DevExpress.XtraEditors.BaseEdit)ctrl; lue.EditValue = DBNull.Value; } } else { string ctrltype = ctrl.GetType().Name; switch (ctrltype) { case "CalcEdit": ((DevExpress.XtraEditors.CalcEdit)ctrl).Value = EServ.Shared.Static.ToDecimal(value); break; case "SpinEdit": ((DevExpress.XtraEditors.SpinEdit)ctrl).Value = EServ.Shared.Static.ToDecimal(value); break; case "DateEdit": ((DevExpress.XtraEditors.DateEdit)ctrl).DateTime = EServ.Shared.Static.ToDateTime(value); break; case "TimeEdit": ((DevExpress.XtraEditors.TimeEdit)ctrl).Time = EServ.Shared.Static.ToDateTime(value); break; case "TextEdit": case "MRUEdit": case "MemoEdit": case "MemoExEdit": case "ComboBoxEdit": case "CheckedComboBoxEdit": ctrl.Text = Convert.ToString(value); break; case "LookUpEdit": DevExpress.XtraEditors.LookUpEdit lue = (DevExpress.XtraEditors.LookUpEdit)ctrl; DataTable dt = null; #region Casting DataTable/DataView into DataTable if (lue.Properties.DataSource is DataView) { DataView dv = (DataView)lue.Properties.DataSource; dt = dv.Table; } else { dt = (DataTable)lue.Properties.DataSource; } #endregion if (dt != null && dt.Columns.Count > 0) { #region Get data type of ValueMember column Type totype = typeof(string); if (string.IsNullOrEmpty(lue.Properties.ValueMember)) { totype = dt.Columns[0].DataType; } else { if (dt.Columns.Contains(lue.Properties.ValueMember)) { totype = dt.Columns[lue.Properties.ValueMember].DataType; } } #endregion #region Converting value into data type value = EServ.Shared.Static.ConvToType(totype, value); #endregion } lue.EditValue = value; break; case "CheckEdit": ((DevExpress.XtraEditors.CheckEdit)ctrl).Checked = EServ.Shared.Static.ToBool(value); break; case "PictureEdit": using (MemoryStream ms = new MemoryStream((byte[])value)) { ((DevExpress.XtraEditors.PictureEdit)ctrl).Image = System.Drawing.Image.FromStream(ms); } break; case "ImageEdit": using (MemoryStream ms = new MemoryStream((byte[])value)) { ((DevExpress.XtraEditors.ImageEdit)ctrl).Image = System.Drawing.Image.FromStream(ms); } break; default: ctrl.Text = EServ.Shared.Static.ToStr(value); break; } } #endregion } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } } } if (ctrl.Controls != null) { FieldLinkSetValues(ctrl.Controls); } } } } }