public bool insertREORDERDETATILS(REORDERDETATILS_VO vo, ITEM_VO vo2, string id) { bool Result = false; try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = new SqlConnection(this.ConnectionString); cmd.CommandText = $@"SP_insertREORDERDETATILS"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@P_REORDER_DETAIL_QTY_GOOD", vo.REORDER_DETAIL_QTY_GOOD); cmd.Parameters.AddWithValue("@P_REORDER_CODE", vo.REORDER); cmd.Parameters.AddWithValue("@P_REORDER_QTY", vo2.ITEM_QTY_UNIT); cmd.Parameters.AddWithValue("@P_ITEM_INCOME_YN", vo2.ITEM_INCOME_YN); cmd.Parameters.AddWithValue("@P_ITEM_CODE", vo2.ITEM_CODE); cmd.Parameters.AddWithValue("@P_ITEM_WRHS_IN", vo2.ITEM_WRHS_IN); cmd.Parameters.AddWithValue("@P_SALES_WORK_ORDER_ID", id); cmd.Connection.Open(); int iResult = cmd.ExecuteNonQuery(); cmd.Connection.Close(); return((iResult > 0) ? true : false); } } catch (Exception err) { string msg = err.Message; return(Result); } }
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("입고대기가 완료 되었습니다."); } }
internal bool insertREORDERDETATILS(REORDERDETATILS_VO vo, ITEM_VO vo2, string id) { REORDERDAC dac = new REORDERDAC(); return(dac.insertREORDERDETATILS(vo, vo2, id)); }