private void A_FRM_Load(object sender, EventArgs e)
{
try
{
if (view)
{
con.OpenConection();
ds = con.select("select * from tb_Regulations_Prices ;", "tb_Regulations_Prices");
dt = ds.Tables[0];
DGV.DataSource = dt;
DGV.Columns[0].ReadOnly = true;
DGV.Columns[0].Width = 70;
DGV.Columns[0].HeaderText = "الكود";
DGV.Columns[1].HeaderText = "الاسم العربى ";
DGV.Columns[2].HeaderText = "الاسم اللاتينى";
DGV.Columns[3].HeaderText = "الحالة";
DGV.Columns[4].HeaderText = "أساسية";
DGV.Columns[5].HeaderText = "تاريخ البداية ";
DGV.Columns[6].HeaderText = "تاريخ الانتهاء";
}
else
{
con.OpenConection();
ds = con.select("select * from tb_Regulations_Prices ;", "tb_Regulations_Prices");
dt = ds.Tables[0];
DGV.DataSource = dt;
DGV.ReadOnly = true;
DGV.Columns[0].Width = 70;
DGV.Columns[0].HeaderText = "الكود";
DGV.Columns[1].HeaderText = "الاسم العربى ";
DGV.Columns[2].HeaderText = "الاسم اللاتينى";
DGV.Columns[3].Visible = false;
DGV.Columns[4].Visible = false;
DGV.Columns[5].Visible = false;
DGV.Columns[6].Visible = false;
C_Add.Visible = false;
C_Delete.Visible = false;
C_Save.Visible = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void A_FRM_Load(object sender, EventArgs e)
{
try
{
con.OpenConection();
ds = con.select("select * from tb_Patients_Categories ;", "tb_Patients_Categories");
dt = ds.Tables[0];
DGV.DataSource = dt;
if (view)
{
DGV.Columns[0].ReadOnly = true;
DGV.Columns[0].HeaderText = "الكود";
DGV.Columns[1].HeaderText = "الاسم العربى ";
DGV.Columns[2].HeaderText = "الاسم اللاتينى";
}
else
{
C_Add.Visible = false;
C_Delete.Visible = false;
C_Save.Visible = false;
DGV.ReadOnly = true;
DGV.Columns[0].HeaderText = "الكود";
DGV.Columns[1].HeaderText = "الاسم العربى ";
DGV.Columns[2].HeaderText = "الاسم اللاتينى";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void A_FRM_Operation_Skills_Desc_Load(object sender, EventArgs e)
{
con.OpenConection();
ds = con.select("select * from tb_Operations_Skills_Description;", "tb_Operations_Skills_Description");
if (view)
{
dt = ds.Tables[0];
DGV.DataSource = dt;
DGV.Columns[0].ReadOnly = true;
DGV.Columns[0].HeaderText = "الكود";
DGV.Columns[0].Width = 70;
DGV.Columns[1].HeaderText = "الاسم العربى ";
DGV.Columns[2].HeaderText = "الاسم اللاتينى";
DGV.Columns[3].HeaderText = "التوصيف الاساسى";
}
else
{
dt = ds.Tables[0];
DGV.DataSource = dt;
DGV.ReadOnly = true;
DGV.Columns[0].HeaderText = "الكود";
DGV.Columns[1].HeaderText = "الاسم العربى ";
DGV.Columns[2].HeaderText = "الاسم اللاتينى";
DGV.Columns[3].Visible = false;
DGV.Columns[0].Width = 70;
C_Add.Visible = false;
C_Delete.Visible = false;
C_Save.Visible = false;
}
}
private void A_FRM_Load(object sender, EventArgs e)
{
try
{
con.OpenConection();
ds = con.select("select CE_Id,CE_AName from tb_Contracting_Entities ;", "tb_Contracting_Entities");
DGV1.DataSource = ds.Tables[0];
DGV1.ReadOnly = true;
DGV1.Columns[0].Visible = false;
DGV1.Columns[0].HeaderText = "الكود";
DGV1.Columns[1].HeaderText = "الاسم العربى ";
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void txt_RP_id_TextChanged(object sender, EventArgs e)
{
con.OpenConection();
dt = con.selectt("select * from tb_Accommodation_Pricing where AP_RP_id = " + Convert.ToInt16(txt_RP_id.Text) + ";", "tb_Accommodation_Pricing");
ds1 = con.select("select AD_id,AD_Aname from tb_Accommodation_Degrees;", "tb_Accommodation_Dgree");
// dt = ds.Tables[0];
DGV.DataSource = dt;
DGV1.DataSource = ds1.Tables[0];
DGV1.Columns[0].ReadOnly = true;
DGV1.Columns[1].ReadOnly = true;
DGV1.Columns[0].HeaderText = "كود الاقامة";
DGV1.Columns[1].HeaderText = "درجة الاقامة";
DGV.Columns[0].Visible = false;
DGV.Columns[1].Visible = false;
DGV.Columns[2].Visible = false;
DGV.Columns[0].ReadOnly = true;
DGV.Columns[1].ReadOnly = true;
DGV.Columns[2].ReadOnly = true;
DGV.Columns[0].HeaderText = "الكود";
DGV.Columns[1].HeaderText = "كود الاقامة";
DGV.Columns[2].HeaderText = "كود اللائحة";
DGV.Columns[3].HeaderText = "إقامة المريض";
DGV.Columns[4].HeaderText = "المرافق على كرسى ";
DGV.Columns[5].HeaderText = "االمرافق على سرير";
DGV.Columns[6].HeaderText = "المتابعة الطبية";
//DGV.Columns[4].HeaderText = "طلب المطالبة";
if (dt.Rows.Count < ds1.Tables[0].Rows.Count)
{
int n = dt.Rows.Count;
int x = ds1.Tables[0].Rows.Count - dt.Rows.Count;
for (int j = 0; j < x; j++)
{
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
//int i = 1;
//if (DGV.Rows.Count > 1)
//{
// i = (int)DGV.Rows[DGV.Rows.Count - 2].Cells[0].Value;
// DGV.Rows[DGV.Rows.Count - 1].Cells[0].Value = (i + 1);
//}
//else
//{
// DGV.Rows[DGV.Rows.Count - 1].Cells[0].Value = (i);
//}
DGV.Rows[DGV.Rows.Count - 1].Cells[1].Value = DGV1.Rows[n + j].Cells[0].Value.ToString();
//MessageBox.Show(DGV1.Rows[DGV1.Rows.Count - 1].Cells[0].Value.ToString());
DGV.Rows[DGV.Rows.Count - 1].Cells[2].Value = txt_RP_id.Text;
}
}
}
private void A_FRM_Load(object sender, EventArgs e)
{
con.OpenConection();
ds = con.select("select * from tb_Access_Methods ;", "tb_Access_Methods");
dt = ds.Tables[0];
DGV.DataSource = dt;
DGV.Columns[0].ReadOnly = true;
DGV.Columns[0].HeaderText = "الكود";
DGV.Columns[1].HeaderText = "الاسم العربى ";
DGV.Columns[2].HeaderText = "الاسم اللاتينى";
}
private void A_FRM_Load(object sender, EventArgs e)
{
if (view)
{
con.OpenConection();
ds = con.select("select * from tb_Types_of_Entities ;", "tb_Types_of_Entities");
dt = ds.Tables[0];
DGV.DataSource = dt;
DGV.Columns[0].ReadOnly = true;
DGV.Columns[0].HeaderText = "الكود";
DGV.Columns[1].HeaderText = "الاسم العربى ";
DGV.Columns[2].HeaderText = "الاسم اللاتينى";
DGV.Columns[3].HeaderText = "الحالة";
DGV.Columns[4].HeaderText = "طلب المطالبة";
}
else
{
con.OpenConection();
ds = con.select("select * from tb_Types_of_Entities ;", "tb_Types_of_Entities");
dt = ds.Tables[0];
DGV.DataSource = dt;
DGV.ReadOnly = true;
DGV.Columns[0].HeaderText = "الكود";
DGV.Columns[1].HeaderText = "الاسم العربى ";
DGV.Columns[2].HeaderText = "الاسم اللاتينى";
DGV.Columns[3].Visible = false;
DGV.Columns[4].Visible = false;
C_Add.Visible = false;
C_Save.Visible = false;
C_Delete.Visible = false;
}
}
