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();
}
