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;
}
}
}
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;
}
}
}
private void BtnEkstraEkle_Click(object sender, EventArgs e)
{
ArsEdit edtStokKodu = new ArsEdit();
edtStokKodu.ArName = "STOK_ADI";
edtStokKodu.PrivateName = "STOK_KODU";
edtStokKodu.ArTag = ekstraTag;
ArsLabel lblStokKodu = new ArsLabel();
lblStokKodu.FullText = "Stok";
lblStokKodu.ArTag = ekstraTag;
lblStokKodu.ArFocusView = edtStokKodu;
ArsButton btnStokKodu = new ArsButton();
btnStokKodu.AfterGuide += StokAfterGuide;
btnStokKodu.ButtonType = EnmButtonType.Guide;
btnStokKodu.ArTag = ekstraTag;
btnStokKodu.ArControlView = edtStokKodu;
ekstraTag++;
btnStokKodu.SQLText = "SELECT STOK_KODU, STOK_ADI FROM [TBLSTOK]";
GuideField[] guideFieldList = new GuideField[2];
guideFieldList[0] = new GuideField();
guideFieldList[0].Name = "STOK_KODU";
guideFieldList[0].Text = "Stok Kodu";
guideFieldList[1] = new GuideField();
guideFieldList[1].Name = "STOK_ADI";
guideFieldList[1].Text = "Stok Adı";
btnStokKodu.GuideFieldList = guideFieldList;
ArsEdit edtStokTutar = new ArsEdit();
edtStokTutar.ArName = "STOK_TUTAR";
edtStokTutar.EditType = EnmEditType.Decimal;
edtStokTutar.ArFocusView = edtStokKodu;
edtStokTutar.ArTag = ekstraTag;
ArsLabel lblStokTutar = new ArsLabel();
lblStokTutar.FullText = "";
lblStokTutar.ArTag = ekstraTag;
lblStokTutar.ArFocusView = edtStokTutar;
ArsButton btnStokSil = new ArsButton();
btnStokSil.ButtonType = EnmButtonType.Delete;
btnStokSil.ArTag = ekstraTag;
btnStokSil.Click += EkstraSil;
btnStokSil.ArControlView = edtStokTutar;
ekstraTag++;
pnlRezervasyon.Controls.Add(edtStokKodu);
pnlRezervasyon.Controls.Add(lblStokKodu);
pnlRezervasyon.Controls.Add(btnStokKodu);
pnlRezervasyon.Controls.Add(edtStokTutar);
pnlRezervasyon.Controls.Add(lblStokTutar);
pnlRezervasyon.Controls.Add(btnStokSil);
lblStokTutar.Size = new Size(1, lblStokTutar.Size.Height);
edtStokTutar.Size = new Size(165, edtStokTutar.Size.Height);
pnlRezervasyon.Setup();
btnEkstraEkle.Location = new Point(btnEkstraEkle.Location.X, btnEkstraEkle.Location.Y + 25);
cbYazdir.Location = new Point(cbYazdir.Location.X, cbYazdir.Location.Y + 25);
BtnKaydet.Location = new Point(BtnKaydet.Location.X, BtnKaydet.Location.Y + 25);
BtnTemizle.Location = new Point(BtnTemizle.Location.X, BtnTemizle.Location.Y + 25);
if (Size.Height + 25 < Parent.Size.Height)
{
Size = new Size(Size.Width, Size.Height + 25);
}
edtStokKodu.Focus();
}
