/// <summary>
/// Editbuttonlar için sadece id ve isim lazım boşuna entityi okumaya gerek yok "deger" parametresi bize adi gibi istenen değeri döndersin
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public static long Select(DataTable table, string fieldname, ref string deger)
{
long result = 0;
SimpleLookup lookup = new SimpleLookup();
lookup.StartPosition = FormStartPosition.CenterScreen;
dt = table;
lookup.grid.DataSource = dt;
if (lookup.grid.Columns.Contains("Id"))
lookup.grid.Columns["Id"].Visible = false;
if (CommandName == "EditButtonHasta2")
{
if (lookup.grid.Columns.Contains("AdiSoyadi"))
lookup.grid.Columns["AdiSoyadi"].Visible = false;
}
lookup.ShowDialog();
if (lookup.DialogResult == DialogResult.OK)
{
result = 0;
if (lookup.grid.CurrentRow != null && Convert.ToInt64(lookup.grid.CurrentRow.Cells["Id"].Value) > 0)
{
result = Convert.ToInt64(lookup.grid.CurrentRow.Cells["Id"].Value);
deger = lookup.grid.CurrentRow.Cells[fieldname].Value.ToString();
}
}
CommandName = string.Empty;
lookup.Dispose();
return result;
}
public static int Select(DataTable table)
{
int result = 0;
SimpleLookup lookup = new SimpleLookup();
lookup.StartPosition = FormStartPosition.CenterScreen;
lookup.grid.DataSource = table;
lookup.ShowDialog();
if (lookup.DialogResult == DialogResult.OK)
{
result = 0;
if (lookup.grid.CurrentRow != null && Convert.ToInt32(lookup.grid.CurrentRow.Cells["Id"].Value) > 0)
{
result = Convert.ToInt32(lookup.grid.CurrentRow.Cells["Id"].Value);
}
}
lookup.Dispose();
return result;
}
/// <summary>
/// Editbuttonlar için sadece id ve isim lazım boşuna entityi okumaya gerek yok "deger" parametresi bize adi gibi istenen değeri döndersin
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public static long Select(DataTable table, string fieldname, ref string deger)
{
long result = 0;
SimpleLookup lookup = new SimpleLookup();
lookup.StartPosition = FormStartPosition.CenterScreen;
dt = table;
lookup.grid.DataSource = dt;
if (lookup.grid.Columns.Contains("Id"))
{
lookup.grid.Columns["Id"].Visible = false;
}
if (CommandName == "EditButtonHasta2")
{
if (lookup.grid.Columns.Contains("AdiSoyadi"))
{
lookup.grid.Columns["AdiSoyadi"].Visible = false;
}
}
lookup.ShowDialog();
if (lookup.DialogResult == DialogResult.OK)
{
result = 0;
if (lookup.grid.CurrentRow != null && Convert.ToInt64(lookup.grid.CurrentRow.Cells["Id"].Value) > 0)
{
result = Convert.ToInt64(lookup.grid.CurrentRow.Cells["Id"].Value);
deger = lookup.grid.CurrentRow.Cells[fieldname].Value.ToString();
}
}
CommandName = string.Empty;
lookup.Dispose();
return(result);
}
public static int Select(DataTable table)
{
int result = 0;
SimpleLookup lookup = new SimpleLookup();
lookup.StartPosition = FormStartPosition.CenterScreen;
lookup.grid.DataSource = table;
lookup.ShowDialog();
if (lookup.DialogResult == DialogResult.OK)
{
result = 0;
if (lookup.grid.CurrentRow != null && Convert.ToInt32(lookup.grid.CurrentRow.Cells["Id"].Value) > 0)
{
result = Convert.ToInt32(lookup.grid.CurrentRow.Cells["Id"].Value);
}
}
lookup.Dispose();
return(result);
}
public static void AddEditbuttonCommands()
{
long id = 0;
string deger = string.Empty;
Utility.EditButtonCommands.Add("EditButtonCihazModeli",
new EditbuttonCommand(
delegate(object nesne)
{
id = SimpleTreeLookup.Select(Transaction.Instance.ExecuteSql("Select Id,Adi,Kodu,Tip from LookupTable where Aktif=1 and (isnull(Adi,'')) like @prm0", ((EditButton)nesne).Text.Trim() + "%"), "Adi", ref deger);
if (id > 0)
{
((EditButton)nesne).Id = id;
((EditButton)nesne).Text = deger;
}
else
{
((EditButton)nesne).Id = 0;
((EditButton)nesne).Text = "";
}
}));
Utility.EditButtonCommands.Add("EditButtonLokasyon",
new EditbuttonCommand(
delegate(object nesne)
{
id = SimpleTreeLookup.Select(Transaction.Instance.ExecuteSql("Select Id,Adi,Kodu from Lokasyon where Aktif=1 and (isnull(Adi,'')) like @prm0", ((EditButton)nesne).Text.Trim() + "%"), "Adi", ref deger);
if (id > 0)
{
((EditButton)nesne).Id = id;
((EditButton)nesne).Text = deger;
}
else
{
((EditButton)nesne).Id = 0;
((EditButton)nesne).Text = "";
}
}));
Utility.EditButtonCommands.Add("EditButtonCihaz",
new EditbuttonCommand(
delegate(object nesne)
{
id = SimpleTreeLookup.Select(Transaction.Instance.ExecuteSql("Select Id,Adi,Kodu from Cihaz where Aktif=1 and (isnull(Adi,'')) like @prm0", ((EditButton)nesne).Text.Trim() + "%"), "Adi", ref deger);
if (id > 0)
{
((EditButton)nesne).Id = id;
((EditButton)nesne).Text = deger;
}
else
{
((EditButton)nesne).Id = 0;
((EditButton)nesne).Text = "";
}
}));
Utility.EditButtonCommands.Add("EditButtonUlkeSec",
new EditbuttonCommand(
delegate(object nesne)
{
id = SimpleLookup.Select(Transaction.Instance.ExecuteSql("select Id,Adi as [Adı],Kodu from Ulke where aktif=1 and (isnull(Adi,'')) like @prm0", ((EditButton)nesne).Text.Trim() + "%"), "Adı", ref deger);
if (id > 0)
{
((EditButton)nesne).Id = id;
((EditButton)nesne).Text = deger;
}
else
{
((EditButton)nesne).Id = 0;
((EditButton)nesne).Text = "";
}
}));
Utility.EditButtonCommands.Add("EditButtonAdres",
new EditbuttonCommand(
delegate(object nesne)
{
id = SimpleTreeLookup.Select(Transaction.Instance.ExecuteSql("Select Id,TagAdresi from Adres where Aktif=1 and (isnull(TagAdresi,'')) like @prm0", ((EditButton)nesne).Text.Trim() + "%"), "TagAdresi", ref deger);
if (id > 0)
{
((EditButton)nesne).Id = id;
((EditButton)nesne).Text = deger;
}
else
{
((EditButton)nesne).Id = 0;
((EditButton)nesne).Text = "";
}
}));
// Utility.EditButtonCommands.Add("EditButtonAsiSec",
//new EditbuttonCommand(
//delegate(object nesne)
//{
// id = SimpleLookup.Select(Transaction.Instance.ExecuteSql("select Id,Adi as [Adı],Kodu from AsiTanim where aktif=1 and (isnull(Adi,'')) like @prm0", ((EditButton)nesne).Text.Trim() + "%"), "Adı", ref deger);
// if (id > 0)
// {
// ((EditButton)nesne).Id = id;
// ((EditButton)nesne).Text = deger;
// }
// else
// {
// ((EditButton)nesne).Id = 0;
// ((EditButton)nesne).Text = "";
// }
//}));
// Utility.EditButtonCommands.Add("EditButtonHasta",
//new EditbuttonCommand(
//delegate(object nesne)
//{
// id = SimpleLookup.Select(Transaction.Instance.ExecuteSql("Select Id,Adi+' '+Soyadi as [AdiSoyadi] from Hasta where (isnull(Adi+' '+Soyadi,'')) like @prm0", ((EditButton)nesne).Text.Trim() + "%"), "AdiSoyadi", ref deger);
// if (id > 0)
// {
// ((EditButton)nesne).Id = id;
// ((EditButton)nesne).Text = deger;
// }
// else
// {
// ((EditButton)nesne).Id = 0;
// ((EditButton)nesne).Text = "";
// }
//}));
// Utility.EditButtonCommands.Add("EditButtonDoktorSec",
// new EditbuttonCommand(
// delegate(object nesne)
// {
// id = SimpleLookup.Select(Transaction.Instance.ExecuteSql("select Id,Adi+' '+Soyadi as [AdiSoyadi] from Doktor where (isnull(Adi+' '+Soyadi,'')) like @prm0", ((EditButton)nesne).Text.Trim() + "%"), "AdiSoyadi", ref deger);
// if (id > 0)
// {
// ((EditButton)nesne).Id = id;
// ((EditButton)nesne).Text = deger;
// }
// else
// {
// ((EditButton)nesne).Id = 0;
// ((EditButton)nesne).Text = "";
// }
// }));
Utility.EditButtonCommands.Add("EditButtonIlSec",
new EditbuttonCommand(
delegate(object nesne)
{
id = SimpleLookup.Select(Transaction.Instance.ExecuteSql("select Id,Adi as [Adi] from il where Adi like @prm0", ((EditButton)nesne).Text.Trim() + "%"), "Adi", ref deger);
if (id > 0)
{
((EditButton)nesne).Id = id;
((EditButton)nesne).Text = deger;
}
else
{
((EditButton)nesne).Id = 0;
((EditButton)nesne).Text = "";
}
}));
// Utility.EditButtonCommands.Add("EditButtonHasta2",
//new EditbuttonCommand(
//delegate(object nesne)
//{
// SimpleLookup.CommandName = "EditButtonHasta2";
// id = SimpleLookup.Select(Transaction.Instance.ExecuteSql("Select Id,Adi+' '+Soyadi as [AdiSoyadi],CONVERT(NVarChar,TckNo) as TckNo,Adi,Soyadi from Hasta where (isnull(Adi+' '+Soyadi,'')) like @prm0", ((EditButton)nesne).Text.Trim() + "%"), "AdiSoyadi", ref deger);
// if (id > 0)
// {
// ((EditButton)nesne).Id = id;
// ((EditButton)nesne).Text = deger;
// }
// else
// {
// ((EditButton)nesne).Id = 0;
// ((EditButton)nesne).Text = "";
// }
//}));
}
