private void SirketListe()
{
ArsSQLQry qrySirketList = new ArsSQLQry();
qrySirketList.artezQry = true;
qrySirketList.SQLText = "SELECT SIRKET_ADI, DBYIL FROM [TBLSIRKET] ORDER BY DBYIL DESC";
qrySirketList.Open();
if (qrySirketList.Found())
{
SIRKET.ClearItems();
string selectedSirket = ArsLibrary.GetLineCFG(System.Environment.MachineName + " Şirket");
int selectedIndex = 0;
for (int i = 0; i < qrySirketList.DataCount(); i++)
{
if (qrySirketList.GetString("SIRKET_ADI") == selectedSirket)
{
selectedIndex = i;
}
SIRKET.AddItem(qrySirketList.GetString("SIRKET_ADI"), qrySirketList.GetString("DBYIL"));
qrySirketList.Next();
}
SIRKET.SelectedIndex = selectedIndex;
}
}
private void SirketDegistir_Load(object sender, EventArgs e)
{
if (cariAktar)
{
btnKaydet.Text = "Aktar";
}
ArsSQLQry qrySirketList = new ArsSQLQry();
qrySirketList.artezQry = true;
qrySirketList.SQLText = "SELECT SIRKET_ADI, DBYIL FROM [TBLSIRKET] ORDER BY DBYIL DESC";
qrySirketList.Open();
if (qrySirketList.Found())
{
SIRKET.ClearItems();
string selectedSirket = ArsLibrary.GetLineCFG(System.Environment.MachineName + " Şirket");
int selectedIndex = 0;
for (int i = 0; i < qrySirketList.DataCount(); i++)
{
if (qrySirketList.GetString("SIRKET_ADI") == selectedSirket)
{
selectedIndex = i;
}
SIRKET.AddItem(qrySirketList.GetString("SIRKET_ADI"), qrySirketList.GetString("DBYIL"));
qrySirketList.Next();
}
SIRKET.SelectedIndex = selectedIndex;
}
SIRKET.SetString(ArsLibrary.dbName);
}
