/// <summary> /// 데이터 그리드 바인딩 /// </summary> private void DataGridViewBinding1() { dgv1.DataSource = null; ReorderService service = new ReorderService(); dgv1.DataSource = service.GetCOM(); }
private void DataGridViewBinding2() { dgv2.DataSource = null; ReorderService service = new ReorderService(); dgv2.DataSource = service.GetWarehousingWait(); }
private void DataGridViewBinding2() { dgv2.DataSource = null; ReorderService service = new ReorderService(); dt = service.GetReorderItem(); dgv2.DataSource = dt; }
private void button1_Click(object sender, EventArgs e) { int a = 0; dgv2.EndEdit(); ReorderService service = new ReorderService(); foreach (DataGridViewRow item in dgv2.Rows) { if (Convert.ToBoolean(item.Cells[1].Value) == true) { a++; if (item.Cells[10].Value == null) { MessageBox.Show("발주할 품목의 수량을 입력해주세요"); return; } } } if (a == 0) { MessageBox.Show("발주할 품목을 선택해주세요"); return; } REORDER_VO vo = new REORDER_VO(); vo.REORDER_DATE = DateTime.Now; vo.REORDER_STATE = "발주"; vo.MANAGER_ID = LoginInfo.UserInfo.LI_ID; int su = 0; foreach (DataGridViewRow item in dgv2.Rows) { if (Convert.ToBoolean(item.Cells[1].Value) == true) { vo.REORDER_DATE_IN = DateTime.Now.AddDays(Convert.ToInt32(item.Cells[15].Value)); vo.REORDER_COM_DLVR = item.Cells[3].Value.ToString(); vo.REORDER_TYP = (item.Cells[4].Value.ToString().Length < 1) ?"정량" : item.Cells[4].Value.ToString(); vo.REORDER_QTY = Convert.ToInt32(item.Cells[11].Value); vo.ITEM_CODE = item.Cells[5].Value.ToString(); vo.COM_CODE = item.Cells[2].Value.ToString(); vo.SALES_Work_Order_ID = item.Cells[14].Value.ToString(); if (service.insertREORDER(vo)) { ; } { su++; } } } if (su > 0) { MessageBox.Show("발주가 완료 되었습니다."); this.Close(); } }
private void button2_Click(object sender, EventArgs e) { int a = 0; dgv2.EndEdit(); ReorderService service = new ReorderService(); foreach (DataGridViewRow item in dgv2.Rows) { if (Convert.ToBoolean(item.Cells[1].Value) == true) { a++; if (item.Cells[9].Value == null) { MessageBox.Show("입고할 품목의 수량을 입력해주세요"); return; } } } if (a == 0) { MessageBox.Show("입고할 품목을 선택해주세요"); return; } REORDERDETATILS_VO vo = new REORDERDETATILS_VO(); ITEM_VO vo2 = new ITEM_VO(); int su = 0; foreach (DataGridViewRow item in dgv2.Rows) { if (Convert.ToBoolean(item.Cells[1].Value) == true) { vo2.ITEM_QTY_UNIT = Convert.ToInt32(item.Cells[8].Value); vo2.ITEM_CODE = item.Cells[3].Value.ToString(); vo2.ITEM_INCOME_YN = item.Cells[13].Value.ToString(); vo2.ITEM_WRHS_IN = (item.Cells[14].Value == null) ? "R-01" : item.Cells[14].Value.ToString(); vo.REORDER_DETAIL_QTY_GOOD = Convert.ToInt32(item.Cells[9].Value); vo.REORDER = Convert.ToInt32(item.Cells[2].Value); string id = item.Cells[15].Value.ToString(); if (service.insertREORDERDETATILS(vo, vo2, id)) { ; } { su++; } } } if (su > 0) { DataGridViewBinding2(); MessageBox.Show("입고대기가 완료 되었습니다."); } }
private void DataGridViewBinding2() { try { COMPANY.DataSource = null; ReorderService service = new ReorderService(); COMPANY.DataSource = service.Inspection2(); } catch (Exception err) { this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}"); } }
public void Search(object sender, EventArgs e) { if (((FrmMAIN)this.MdiParent).ActiveMdiChild == this) { string day1 = sday.Value.ToShortDateString(); string day2 = eday.Value.ToShortDateString(); string code1 = COM_CODE_OUT.Text; string name = textBox1.Text; string reorder = REORDER_CODE.Text; string cod2 = COM_CODE_IN.Text; ReorderService service = new ReorderService(); dgv1.DataSource = service.SPGetWarehousingWait(day1, day2, code1, name, reorder, cod2); } }
private void button1_Click(object sender, EventArgs e) { try { int a = 0; int bqty = 0; int gqty = 0; int reorder = 0; int reorderD = 0; string code = ""; string id = ""; COMPANY.EndEdit(); ReorderService service = new ReorderService(); foreach (DataGridViewRow item in COMPANY.Rows) { if (Convert.ToBoolean(item.Cells[1].Value) == true) { if (item.Cells[11].Value == null) { bqty = 0; } else { bqty = Convert.ToInt32(item.Cells[11].Value); } gqty = Convert.ToInt32(item.Cells[10].Value); bqty = Convert.ToInt32(item.Cells[11].Value); reorder = Convert.ToInt32(item.Cells[2].Value); reorderD = Convert.ToInt32(item.Cells[3].Value); code = item.Cells[7].Value.ToString(); id = item.Cells[12].Value.ToString(); service.insertInspection(gqty, bqty, reorder, reorderD, code, id); a++; } } if (a == 0) { MessageBox.Show("검사할 발주를 선택해주세요"); return; } DataGridViewBinding2(); MessageBox.Show("검사가 완료 되었습니다."); Reset(null, null); } catch (Exception err) { this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}"); } }
/// <summary> /// 조회 버튼 이벤드 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void Search(object sender, EventArgs e) { if (((FrmMAIN)this.MdiParent).ActiveMdiChild == this) { ReorderService service = new ReorderService(); dgvReorder.DataSource = null; dgvReorder.DataSource = service.GetSearchREORDER( sday.Value.ToShortDateString() , eday.Value.ToShortDateString() , (COM_CODE_OUT.Text.Length < 1) ? "" : COM_CODE_OUT.Text , (ITEM_CODE.Text.Length < 1) ? "" : ITEM_CODE.SelectedValue.ToString() , REORDER_STATE.Text , REORDER_CODE.Text , (COM_CODE_IN.Text.Length < 1) ? "": COM_CODE_IN.Text);; } }
private void dgv1_CellContentClick(object sender, DataGridViewCellEventArgs e) { dgv1.EndEdit(); StringBuilder sb = new StringBuilder(); foreach (DataGridViewRow item in dgv1.Rows) { if (Convert.ToBoolean(item.Cells[1].Value) == true) { sb.Append("'" + item.Cells[2].Value.ToString() + "',"); } } if (sb.ToString().Length < 1) { return; } ReorderService service = new ReorderService(); dgv2.DataSource = service.GetReorderItem2(sb.ToString().TrimEnd(',')); }
private void button1_Click(object sender, EventArgs e) { dgvReorder.EndEdit(); StringBuilder sb = new StringBuilder(); int cnt = 0; //품목 선택후 List를 전달 foreach (DataGridViewRow item in dgvReorder.Rows) { if (Convert.ToBoolean(item.Cells[1].Value)) { if (item.Cells[5].Value.ToString() != "발주") { MessageBox.Show("발주 상태만 취소 가능합니다."); return; } sb.Append(item.Cells[2].Value.ToString() + "@"); cnt++; } } if (sb.Length < 1) { MessageBox.Show("취소할 항목을 선택하여 주십시오."); return; } sb.Remove(sb.Length - 1, 1); if (MessageBox.Show($"총 {cnt}개의 항목의 삭제 하시겠습니까?", "삭제", MessageBoxButtons.YesNo) == DialogResult.Yes) { ReorderService item = new ReorderService(); if (item.DeleteREORDER(sb.ToString())) { ; } { MessageBox.Show($"총 {cnt}개 발주가 삭제되었습니다."); DataGridViewBinding(); } } }
public void Search(object sender, EventArgs e) { if (((FrmMAIN)this.MdiParent).ActiveMdiChild == this) { try { string day1 = sday.Value.ToShortDateString(); string day2 = eday.Value.ToShortDateString(); string com = REORDER_COM.Text; string name = ITEMNAME.Text; string inspect = INSPECT.Text; string code = REORDER_CODE.Text; ReorderService service = new ReorderService(); dgv1.DataSource = null; dgv1.DataSource = service.SP_Inspection(day1, day2, com, name, inspect, code); } catch (Exception err) { this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}"); } } }
private void button2_Click(object sender, EventArgs e) { dgvReorder.EndEdit(); StringBuilder sb = new StringBuilder(); int cnt = 0; //품목 선택후 List를 전달 foreach (DataGridViewRow item in dgvReorder.Rows) { if (Convert.ToBoolean(item.Cells[1].Value)) { sb.Append(item.Cells[2].Value.ToString() + "@"); cnt++; } } if (sb.Length < 1) { MessageBox.Show("납기일을 변경할 항목을 선택하여 주십시오."); return; } sb.Remove(sb.Length - 1, 1); if (MessageBox.Show($"총 {cnt}개의 항목의 납기일을 변경 하시겠습니까?", "변경", MessageBoxButtons.YesNo) == DialogResult.Yes) { FrmReorderSearchPopUp frm = new FrmReorderSearchPopUp(); if (frm.ShowDialog() == DialogResult.OK) { ReorderService item = new ReorderService(); if (item.UpDateREORDER(frm.day, LoginInfo.UserInfo.LI_ID, sb.ToString())) { ; } { MessageBox.Show($"총 {cnt}개 의 납기일이 변경되었습니다."); DataGridViewBinding(); } } } }
/// <summary> /// 데이터 그리드 바인딩 /// </summary> private void DataGridViewBinding() { ReorderService item = new ReorderService(); dgvReorder.DataSource = item.SelectREORDER(); }
private void button2_Click(object sender, EventArgs e) { ReorderService service = new ReorderService(); dgv2.DataSource = service.GetSearchReorder2(ITEM_COM_REORDER.Text, ITEM_NAEM.Text); }