public static void ArsQryToPanel(ArsPanel pnl, ArsSQLQry qry) { foreach (Control control in pnl.Controls) { switch (control) { case ArsEdit _: ArsEdit editControl = (control as ArsEdit); switch (editControl.EditType) { case EnmEditType.String: editControl.SetDataStr(qry.GetString(editControl.ArName)); break; case EnmEditType.Numeric: editControl.SetDataStr(qry.GetDouble(editControl.ArName).ToString()); break; case EnmEditType.Decimal: editControl.SetDataStr(qry.GetDouble(editControl.ArName).ToString()); break; default: editControl.SetDataStr(qry.GetString(editControl.ArName)); break; } break; case ArsMaskEdit _: ArsMaskEdit maskEditControl = (control as ArsMaskEdit); switch (maskEditControl.EditType) { case EnmMaskEditType.Phone: maskEditControl.SetDataStr(qry.GetString(maskEditControl.ArName)); break; default: maskEditControl.SetDataStr(qry.GetString(maskEditControl.ArName)); break; } break; case ArsDateTime _: ArsDateTime dateControl = (control as ArsDateTime); dateControl.SetDataStr(qry.GetString(dateControl.ArName)); break; case ArsComboBox _: ArsComboBox comboControl = (control as ArsComboBox); comboControl.SetString(qry.GetString(comboControl.ArName)); if (comboControl.Items.Count == 0) { comboControl.LoadString = qry.GetString(comboControl.ArName); } break; case ArsCheck _: ArsCheck checkControl = (control as ArsCheck); if (qry.GetString(checkControl.ArName) == checkControl.CheckedValue) { checkControl.Checked = true; } else { checkControl.Checked = false; } if (!checkControl.Checked && qry.GetString(checkControl.ArName) == "True") { checkControl.Checked = true; } break; } } }