Exemple #1
0
        private void Repair_Load(object sender, EventArgs e)
        {
            DataGridViewCheckBoxColumn column = new DataGridViewCheckBoxColumn();

            column.HeaderText = "Select";
            column.Name       = "Select";
            column.Visible    = true;

            dgvRepairDevice.Columns.Add(column);
            dgvRepairDevice.Columns["Select"].DisplayIndex = 0;

            DataGridViewCheckBoxColumn column2 = new DataGridViewCheckBoxColumn();

            column2.HeaderText = "Select";
            column2.Name       = "Select";
            column2.Visible    = true;

            dgvAddingDevice.Columns.Add(column2);
            dgvAddingDevice.Columns["Select"].DisplayIndex = 0;

            //rdrYesUse.Checked = true;


            //dgvListDevice.Columns.Add("Ma_TS_Repair", "Vật tư cần sửa chữa");
            LoadComboboxData load = new LoadComboboxData();

            load.LoadDataType(cbType_Repair);
            //load.LoadDataType(cbType_Add);
            LoadTypeMaterial();
        }
Exemple #2
0
        private void Revoke_Load(object sender, EventArgs e)
        {
            DataGridViewCheckBoxColumn column = new DataGridViewCheckBoxColumn();

            column.HeaderText = "Select";
            column.Name       = "Select";
            column.Visible    = true;

            dataGridView1.Columns.Add(column);
            dataGridView1.Columns["Select"].DisplayIndex = 0;
            dataGridView2.AllowUserToAddRows             = false;

            con.Open();
            string            strcbStatus = "SELECT * FROM Status";
            OracleCommand     cmdStatus   = new OracleCommand(strcbStatus, con);
            OracleDataAdapter daStatus    = new OracleDataAdapter(cmdStatus);
            DataTable         dtStatus    = new DataTable();

            daStatus.Fill(dtStatus);
            cbStatus.DataSource    = dtStatus;
            cbStatus.DisplayMember = "Ten_tinh_trang";
            cbStatus.ValueMember   = "Ma_tinh_trang";
            cmdStatus.ExecuteNonQuery();
            con.Close();

            LoadComboboxData comboboxData = new LoadComboboxData();

            comboboxData.LoadDataType(cbTypeLV2);
        }
Exemple #3
0
        private void LoadTypeDevice()
        {
            LoadComboboxData loadCombobox = new LoadComboboxData();

            loadCombobox.LoadDataType1(cbType1);
            loadCombobox.LoadDataType(cbTypeLV2);
            loadCombobox.LoadDataType1(cbTypeLevel1);

            string strQuerryType = "SELECT a.Ma_loai, a.Ten_loai, b.Ten_loai " +
                                   "FROM Loai_TS_cap2 a " +
                                   " INNER JOIN Loai_TS_cap1 b ON a.Phan_loai = b.Ma_loai ORDER BY a.Ma_loai ASC";
            OracleDataAdapter daQuerryType = new OracleDataAdapter(strQuerryType, con);
            DataTable         table        = new DataTable();

            daQuerryType.Fill(table);
            dgvShow.DataSource            = table;
            dgvShow.Columns[0].HeaderText = "Mã Số";
            dgvShow.Columns[1].HeaderText = "Loại Thiết Bị";
            dgvShow.Columns[2].HeaderText = "Phân Loại Tài Sản";

            string            strQuerryUnit = "select * from Unit";
            OracleDataAdapter daQuerryUnit  = new OracleDataAdapter(strQuerryUnit, con);
            DataTable         dtUnit        = new DataTable();

            daQuerryUnit.Fill(dtUnit);
            dgvUnit.DataSource            = dtUnit;
            dgvUnit.Columns[0].HeaderText = "Mã đơn vị";
            dgvUnit.Columns[1].HeaderText = "Đơn vị tính";

            string            QuerryModel = "select a.model_code, a.model, b.ten_loai, b.ma_loai from model a inner join loai_ts_cap2 b on a.type_code = b.ma_loai order by to_number(a.model_code)";
            OracleDataAdapter daModel     = new OracleDataAdapter(QuerryModel, con);
            DataTable         dtModel     = new DataTable();

            daModel.Fill(dtModel);
            dgvModel.DataSource            = dtModel;
            dgvModel.Columns[1].HeaderText = "Model";

            cbTypeLV2.Enabled    = false;
            txtModelName.Enabled = false;
            btnAddModel.Enabled  = false;

            if (Login.username == "an.do")
            {
                btnXoa.Enabled = true;
            }
            else if (Login.username != "an.do")
            {
                btnXoa.Visible = false;
            }
        }
Exemple #4
0
        private void Borrow_Load(object sender, EventArgs e)
        {
            LoadComboboxData loadCombobox1 = new LoadComboboxData();

            loadCombobox1.LoadDataType(cbType);
            loadCombobox1.LoadDataStatus(cbStatus);

            DataGridViewCheckBoxColumn column = new DataGridViewCheckBoxColumn();

            column.Name       = "Select";
            column.HeaderText = "Select";
            dgvQuerry.Columns.Add(column);
            dgvQuerry.Columns["Select"].DisplayIndex = 0;
            dgvQuerry.AllowUserToAddRows             = false;
            dgvSelected.AllowUserToAddRows           = false;

            rdST.Checked = true;

            btnTransfer.Enabled = false;
        }