public static void ArsPanelToQry(ArsPanel pnl, ArsSQLQry qry) { foreach (Control control in pnl.Controls) { switch (control) { case ArsEdit _: ArsEdit editControl = (control as ArsEdit); if (editControl.ArName == "REC_ID") { continue; } switch (editControl.EditType) { case EnmEditType.String: qry.SetString(editControl.ArName, editControl.GetDataStr()); break; case EnmEditType.Numeric: qry.SetInt(editControl.ArName, Convert.ToInt32(editControl.GetDataStr())); break; case EnmEditType.Decimal: qry.SetDouble(editControl.ArName, Convert.ToDouble(editControl.GetDataStr())); break; default: qry.SetString(editControl.ArName, editControl.GetDataStr()); break; } break; case ArsMaskEdit _: ArsMaskEdit maskEditControl = (control as ArsMaskEdit); switch (maskEditControl.EditType) { case EnmMaskEditType.Phone: qry.SetString(maskEditControl.ArName, maskEditControl.GetDataStr()); break; default: qry.SetString(maskEditControl.ArName, maskEditControl.GetDataStr()); break; } break; case ArsDateTime _: ArsDateTime dateControl = (control as ArsDateTime); if (dateControl.DateTimeType == EnmDateTimeType.Date) { qry.SetDate(dateControl.ArName, dateControl.GetDataStr()); } else if (dateControl.DateTimeType == EnmDateTimeType.Time) { qry.SetString(dateControl.ArName, dateControl.GetDataStr()); } break; case ArsComboBox _: ArsComboBox comboControl = (control as ArsComboBox); qry.SetString(comboControl.ArName, comboControl.GetString()); break; case ArsCheck _: ArsCheck checkControl = (control as ArsCheck); if (checkControl.Checked) { qry.SetString(checkControl.ArName, checkControl.CheckedValue); } else { qry.SetString(checkControl.ArName, checkControl.UnCheckedValue); } break; } } }