private void button2_Click(object sender, EventArgs e) { try { dgv2.EndEdit(); INSTACKService service = new INSTACKService(); foreach (DataGridViewRow item in dgv2.Rows) { if (Convert.ToBoolean(item.Cells[1].Value) && item.Cells[10].Value != null) { int qty = Convert.ToInt32(item.Cells[10].Value); string code = item.Cells[2].Value.ToString(); string wrhsin = item.Cells[13].Value.ToString(); string id = item.Cells[14].Value.ToString(); string wrhsout = item.Cells[15].Value.ToString(); service.INSERT_instack(qty, wrhsin, wrhsout, code, id); MessageBox.Show("자재가 불출되었습니다."); } } dgv2.DataSource = null; } catch (Exception err) { this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}"); } }
/// <summary> /// 데이터 그리드 바인딩 /// </summary> private void DataGridViewBinding() { dgv1.DataSource = null; INSTACKService service = new INSTACKService(); dgv1.DataSource = service.INSTACDataTable(); }
/// <summary> /// 데이터 그리드 바인딩 /// </summary> private void DataGridViewBinding() { try { dgv1.DataSource = null; INSTACKService service = new INSTACKService(); dgv1.DataSource = service.ReceivingSearch(); } 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 wrhs = (WRHS.Text.Length < 1) ? "": WRHS.SelectedValue.ToString(); string name = ITEM.Text; string typ = TYP.Text; string level = ITEM_MANAGER.Text; string itemtyp = ITEM_TYP.Text; INSTACKService service = new INSTACKService(); dgv1.DataSource = service.INSTACDataTable(day1, day2, wrhs, name, typ, level, itemtyp); } }
public void Search(object sender, EventArgs e) { try { if (((FrmMAIN)this.MdiParent).ActiveMdiChild == this) { string day = sday.Value.ToShortDateString(); string name = ITEMENAME.Text; string typ = ITEM_TYP.Text; string wrhs = (WRHS.Text.Length < 1) ? "" : WRHS.SelectedValue.ToString(); string qty = QTY.Text; string level = ITEM_MANAGE_LEVEL.Text; INSTACKService service = new INSTACKService(); dgv1.DataSource = null; dgv1.DataSource = service.SP_ReceivingSearch(day, name, typ, wrhs, qty, level); } } catch (Exception err) { this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}"); } }