コード例 #1
0
ファイル: frm_jorclose.cs プロジェクト: ahmed154/sol_view
        public frm_jorclose(pro_view.fld_PL.fld_Login.frm_main frm_Main)
        {
            frm_main = frm_Main;

            InitializeComponent();


            bl.company_id = frm_main.com_companies.SelectedValue.ToString();
            ds            = bl.Select();

            com_oldfyear.ValueMember   = "id";
            com_oldfyear.DisplayMember = "aname";
            com_oldfyear.DataSource    = ds.Tables["tbl_oldfyear"];
            if (ds.Tables["tbl_oldfyear"].Rows.Count > 1)
            {
                com_oldfyear.SelectedValue = ds.Tables["tbl_oldfyear"].Rows[1]["id"];
            }

            com_newfyear.ValueMember   = "id";
            com_newfyear.DisplayMember = "aname";
            com_newfyear.DataSource    = ds.Tables["tbl_newfyear"];
        }
コード例 #2
0
        public frm_Stu_Search(pro_view.fld_PL.fld_Login.frm_main frm_Main, TextBox t)
        {
            InitializeComponent();

            frm_main            = frm_Main;
            txt_dgv_search.Text = t.Text;

            #region dgv_parents_search
            dgv_stu_search.AutoGenerateColumns = false;

            var id = new DataGridViewTextBoxColumn();
            id.Name             = "id";
            id.HeaderText       = "المسلسل";
            id.DataPropertyName = "id";
            id.AutoSizeMode     = DataGridViewAutoSizeColumnMode.None;
            id.Width            = 100;
            dgv_stu_search.Columns.Add(id);

            var f_parent_id = new DataGridViewTextBoxColumn();
            f_parent_id.Name             = "f_parent_id";
            f_parent_id.HeaderText       = "رقم هوية الاب";
            f_parent_id.DataPropertyName = "f_parent_id";
            f_parent_id.AutoSizeMode     = DataGridViewAutoSizeColumnMode.None;
            f_parent_id.Width            = 100;
            dgv_stu_search.Columns.Add(f_parent_id);

            var f_aname = new DataGridViewTextBoxColumn();
            f_aname.Name             = "f_aname";
            f_aname.HeaderText       = "اسم الاب";
            f_aname.DataPropertyName = "f_aname";
            f_aname.AutoSizeMode     = DataGridViewAutoSizeColumnMode.None;
            f_aname.Width            = 100;
            dgv_stu_search.Columns.Add(f_aname);

            var f_mobile1 = new DataGridViewTextBoxColumn();
            f_mobile1.Name             = "f_mobile1";
            f_mobile1.HeaderText       = "جوال الاب";
            f_mobile1.DataPropertyName = "f_mobile1";
            f_mobile1.AutoSizeMode     = DataGridViewAutoSizeColumnMode.None;
            f_mobile1.Width            = 100;
            dgv_stu_search.Columns.Add(f_mobile1);

            var m_parent_id = new DataGridViewTextBoxColumn();
            m_parent_id.Name             = "m_parent_id";
            m_parent_id.HeaderText       = "رقم هويةالام";
            m_parent_id.DataPropertyName = "m_parent_id";
            m_parent_id.AutoSizeMode     = DataGridViewAutoSizeColumnMode.None;
            m_parent_id.Width            = 100;
            dgv_stu_search.Columns.Add(m_parent_id);

            var m_aname = new DataGridViewTextBoxColumn();
            m_aname.Name             = "m_aname";
            m_aname.HeaderText       = "اسم الام";
            m_aname.DataPropertyName = "m_aname";
            m_aname.AutoSizeMode     = DataGridViewAutoSizeColumnMode.None;
            m_aname.Width            = 100;
            dgv_stu_search.Columns.Add(m_aname);

            var m_mobile1 = new DataGridViewTextBoxColumn();
            m_mobile1.Name             = "m_mobile1";
            m_mobile1.HeaderText       = "جوال الام";
            m_mobile1.DataPropertyName = "m_mobile1";
            m_mobile1.AutoSizeMode     = DataGridViewAutoSizeColumnMode.None;
            m_mobile1.Width            = 100;
            dgv_stu_search.Columns.Add(m_mobile1);

            module.company_id = frm_main.com_companies.SelectedValue.ToString();
            module.selecttype = "Select_All";

            ds = module.Select();
            ds.Tables[0].DefaultView.RowFilter = "id like'%" + t.Text + "%' or f_parent_id like '%" + t.Text + "%' or f_aname like '%" + t.Text + "%' or f_mobile1 like '%" + t.Text + "%'";
            dgv_stu_search.Rows.Clear();

            foreach (DataRowView r in ds.Tables[0].DefaultView)
            {
                dgv_stu_search.Rows.Add(r["id"], r["f_parent_id"], r["f_aname"], r["f_mobile1"], r["m_parent_id"], r["m_aname"], r["m_mobile1"]);
            }

            dgv_stu_search.ClearSelection();
        }