コード例 #1
0
ファイル: ArsLibrary.cs プロジェクト: EmreBHDR/ArsLib
        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;
                }
            }
        }
コード例 #2
0
ファイル: ArsLibrary.cs プロジェクト: EmreBHDR/ArsLib
        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;
                }
            }
        }