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);
}
}
}
}
}
