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