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; } }