public void serch_gridView() { Pegi mypegi = new Pegi(); List <Dictionary <String, String> > pegi_values = new List <Dictionary <string, string> >(); // List 배열값 pegi_values = mypegi.serch(item_name_serch.Text, pegi_date_serch.Text, pegi_date_serch2.Text); pegiGridView.Rows.Clear(); foreach (Dictionary <string, string> pegi_pegi in pegi_values) { rowIdw = pegiGridView.Rows.Add(); row = pegiGridView.Rows[rowIdw]; row.Cells["column1"].Value = pegi_pegi["item_code"].ToString(); row.Cells["column2"].Value = pegi_pegi["item_name"].ToString(); row.Cells["column3"].Value = pegi_pegi["item_samt"].ToString(); row.Cells["column4"].Value = pegi_pegi["pegi_date"].ToString(); row.Cells["column5"].Value = pegi_pegi["pegi_cnt"].ToString(); } }
private void confirmBtn_Click(object sender, EventArgs e) { //입력,수정,삭제시 값 물어보기. if (pegi_code.Text == "") { MessageBox.Show("물품코드를 입력해주세요."); return; } else if (pegi_date.Text == "") { MessageBox.Show("출고일자를 입력해주세요."); return; } else if (pegi_cnt.Text == "") { MessageBox.Show("출고량을 입력해주세요."); return; } else if (pegi_sau.Text == "") { MessageBox.Show("사유를 입력해주세요."); return; } Pegi mypegi = new Pegi(); Dictionary <String, String> pegi_value = make_pegi_values(); if (code_value == "I") { mypegi.insert(pegi_value, item_samt.Text); } else if (code_value == "C") { //현재 재고량 넘겨주기 mypegi.update(pegi_value, item_samt.Text); } else if (code_value == "D") { mypegi.delete(pegi_code.Text, pegi_date.Text, item_samt.Text); } clear(); serch_gridView(); btnValue2(); }
public void renderImage(String pegi_id) { Pegi mypegi = new Pegi(); Dictionary <String, byte[]> img_value = new Dictionary <string, byte[]>(); img_value = mypegi.checking_pegi_img(pegi_id); if (img_value == null) { pictureBox1.Image = null; } else { pictureBox1.Image = new Bitmap(new MemoryStream(img_value["img"])); } }
private void pegiGridView_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { pegi_code.Text = pegiGridView.Rows[e.RowIndex].Cells["Column1"].Value.ToString(); item_name.Text = pegiGridView.Rows[e.RowIndex].Cells["Column2"].Value.ToString(); item_samt.Text = pegiGridView.Rows[e.RowIndex].Cells["Column3"].Value.ToString(); pegi_date.Text = pegiGridView.Rows[e.RowIndex].Cells["Column4"].Value.ToString(); pegi_cnt.Text = pegiGridView.Rows[e.RowIndex].Cells["Column5"].Value.ToString(); String pegiCode = pegiGridView.Rows[e.RowIndex].Cells["Column1"].Value.ToString(); Pegi mypegi = new Pegi(); renderImage(pegiCode); }
//이벤트가 비슷하면 묶기 private void change_deleteBtn_Click(object sender, EventArgs e) { // 아이디 체크후 값 뿌려주기. Pegi mypegi = new Pegi(); Dictionary <String, String> pegi_value = new Dictionary <string, string>(); pegi_value = mypegi.checking_pegiID(pegi_code.Text); if (pegi_value == null) { MessageBox.Show("아이디가 존재 하지 않습니다."); return; } else { //아이디 뿌리기 pegi_date.Text = pegi_value["pegi_date"].ToString(); pegi_cnt.Text = pegi_value["pegi_cnt"].ToString(); pegi_sau.Text = pegi_value["pegi_sau"].ToString(); //이미지 뿌리기 renderImage(pegi_code.Text); } Button check_type = (Button)sender; if (check_type.Text == "수정") { code_value = "C"; } else { code_value = "D"; } btnValue(); }