示例#1
0
        private void LoadConsultData()
        {
            ConsultInfoService dac = new ConsultInfoService();
            DataSet            ds  = dac.GetAll();

            ConsultGrid.DataSource = ds.Tables[0];
            dac.Dispose();
        }
示例#2
0
        private void LoadData()
        {
            ConsultInfoService service = new ConsultInfoService();

            dt = service.GetStudentConsult(lblStudentID.Text);
            ConsultGrid.DataSource = service.GetStudentConsult(lblStudentID.Text);
            service.Dispose();
            //dt = new DataTable();

            this.bindingSource1.DataSource = dt;
        }
示例#3
0
        private void ToolStripButton1_Click(object sender, EventArgs e)
        {
            ConsultInfoService service = new ConsultInfoService();

            try
            {
                DataRow[] insRows = dt.Select(null, null, DataViewRowState.Added);
                foreach (DataRow dr in insRows)
                {
                    ConsultInfoVO item = SetConsultInfoVo1(dr);
                    service.Insert(item, lblStudentID.Text);
                }
                DataRow[] upsRows = dt.Select(null, null, DataViewRowState.ModifiedCurrent);

                foreach (DataRow dr in upsRows)
                {
                    ConsultInfoVO item = SetConsultInfoVo(dr);
                    service.Update(item, lblStudentID.Text);
                }

                DataRow[] delRows = dt.Select(null, null, DataViewRowState.Deleted);

                foreach (DataRow dr in delRows)
                {
                    ConsultInfoVO item = SetDelConsultInfoVo(dr);
                    service.Delete(item, lblStudentID.Text);
                }

                MaterialMessageBox.Show("저장완료", "확인", MessageBoxButtons.OK);
            }
            catch (InvalidCastException)
            {
                MaterialMessageBox.Show("항목을 입력해주세요", "경고", MessageBoxButtons.OK);
            }
            catch (Exception err2)
            {
                MaterialMessageBox.Show(err2.Message, "경고", MessageBoxButtons.OK);
            }
            finally
            {
                service.Dispose();
            }
        }
示例#4
0
        private void LoadConsultList()
        {
            ConsultGrid.AutoGenerateColumns = false;
            ConsultGrid.AllowUserToAddRows  = false;
            ConsultGrid.SelectionMode       = DataGridViewSelectionMode.FullRowSelect;
            ConsultGrid.RowHeadersWidth     = 15;
            ConsultGrid.ColumnHeadersHeight = 30;
            ConsultGrid.ColumnHeadersDefaultCellStyle.Font = new Font("Segoe UI", 11.5F);
            ConsultGrid.RowsDefaultCellStyle.Font          = new Font("Segoe UI", 9.5F);
            ConsultGrid.DefaultCellStyle.WrapMode          = DataGridViewTriState.True;
            ConsultGrid.AutoSizeRowsMode    = DataGridViewAutoSizeRowsMode.AllCells;
            ConsultGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;

            UtilityClass.AddNewColumnToDataGridView(ConsultGrid, "상담번호", "consult_id", false, 10);
            UtilityClass.AddNewColumnToDataGridView(ConsultGrid, "상담날짜", "consult_date", true, 100);
            UtilityClass.AddNewColumnToDataGridView(ConsultGrid, "상담내용", "consult_details", true, 150);
            UtilityClass.AddNewColumnToDataGridView(ConsultGrid, "조치사항", "others", true, 150);
            ConsultInfoService service = new ConsultInfoService();

            ConsultGrid.DataSource = service.GetStudentConsult(lblStudentID.Text);
            ConsultGrid.ClearSelection();
            service.Dispose();
        }