private void buttonDelete_Click(object sender, EventArgs e) //삭제 버튼
{
try
{
//선택된 값 삭제
//id(pk)값 가지고 삭제
int id = Int32.Parse(dataGridViewSelect.Rows[dataGridViewSelect.CurrentCellAddress.Y].Cells[0].Value.ToString());
//MessageBox.Show("" + id);
//삭제 쿼리 보내기
string query = "DELETE FROM 일일업무등록 WHERE id = " + id;
DBManager.GetInstance().DBquery(query);
MessageBox.Show("삭제되었습니다.");
//화면 닦이는지 확인
gridView.SettingGridView();
}
catch
{
MessageBox.Show("선택후 진행해 주세요");
}
}
public void SettingValue() //gridview 전부 출력
{
gridView = new GridViewManager(dataGridViewSelect); // gridview 세팅
string query = "Select id AS '번호'," +
"(SELECT name FROM Employee WHERE 등록자id=identification) AS 등록자" +
",날짜,부서,업무종류,업무내용,SUBSTR(시작시간,12) AS 시작시간,SUBSTR(종료시간,12) AS 종료시간 FROM 일일업무등록,업무마스터 WHERE 업무마스터id=업무번호";
gridView.SettingSelect(query); //select 세팅
gridView.SettingGridView(); // gridview 그려주기
//컬럼 사이즈 설정
dataGridViewSelect.Columns[0].FillWeight = 50;
dataGridViewSelect.Columns[3].FillWeight = 80;
dataGridViewSelect.Columns[5].FillWeight = 250;
//dataGridView1.Columns[6].Visible = false; // 화면에 보여주고 싶지 않은 칼럼 지정
}
private void TodayWorkSaveChange_FormClosed(object sender, FormClosedEventArgs e)
{
//폼 닫힘
//gridview 새로 그리기
gridView.SettingGridView();
}