private void currency_frm_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F9)
{
dt = new DataTable();
dal = new DAL.DataAccessLayer();
string sql = "SELECT [currency_ID] as رقم_العملة ,[currency_Key] as اختصار ,[currency_name] as اسم_العملة ,[currency_name_e] as الاسم_الاجنبي FROM [trader_db].[dbo].[AM_Currency]";
//dt.Columns.RemoveAt(6);
//dt.Columns.RemoveAt(5);
//dt.Columns.RemoveAt(4);
//dt.Columns.RemoveAt(3);
PL.Am.Form_Search frm = new PL.Am.Form_Search(sql);
frm.MdiParent = this.MdiParent;
frm.ShowDialog();
//txt_id.Text = frm.dataGridView1.CurrentRow.Cells["رقم_المخزن"].Value.ToString();
//txt_A_N.Text = frm.dataGridView1.CurrentRow.Cells["اسم_المخزن"].Value.ToString();
//txt_by_user.Text = frm.dataGridView1.CurrentRow.Cells["py_user"].Value.ToString();
//txt_E_N.Text = frm.dataGridView1.CurrentRow.Cells["الاسم_بالاجنبي"].Value.ToString();
//txt_in_date.Text = frm.dataGridView1.CurrentRow.Cells["in_date"].Value.ToString();
//txt_edit_user.Text = frm.dataGridView1.CurrentRow.Cells["edit_user"].Value.ToString();
//txt_edit_date.Text = frm.dataGridView1.CurrentRow.Cells["edit_date"].Value.ToString();
}
}
private void search_data()
{
string sql = "SELECT " + txt_id.Tag.ToString() + " as الرقم ,[A_N] as الاسم ,[E_N] as الاسم_الاجنبي FROM [trader_db].[dbo]." + this.Tag.ToString();
PL.Am.Form_Search frm = new PL.Am.Form_Search(sql);
frm.ShowDialog();
txt_id.Text = frm.dataGridView1.CurrentRow.Cells["الرقم"].Value.ToString();
view_data();
}
private void search_data()
{
string sql = "SELECT [Type_ID] as الرقم ,[A_N] as الاسم,[E_N] as الاسم_الاجنبي FROM [trader_db].[dbo].[AC_Account_type]";
PL.Am.Form_Search frm = new PL.Am.Form_Search(sql);
frm.MdiParent = this.MdiParent;
frm.ShowDialog();
txt_id.Text = frm.dataGridView1.CurrentRow.Cells["الرقم"].Value.ToString();
view_data();
}
private void search_data()
{
string sql = " SELECT [Invontory_ID] as الرقم ,[Inventory_A_N] as الاسم,[Inventory_E_N] as الاسم_الاجنبي FROM [dbo].[INV_Inventorys] ";
//dt.Columns.RemoveAt(6);
//dt.Columns.RemoveAt(5);
//dt.Columns.RemoveAt(4);
//dt.Columns.RemoveAt(3);
PL.Am.Form_Search frm = new PL.Am.Form_Search(sql);
frm.ShowDialog();
txt_id.Text = frm.dataGridView1.CurrentRow.Cells["الرقم"].Value.ToString();
view_data();
}