public bool insertREORDER(REORDER_VO vo)
{
bool Result = false;
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = $@"INSERT INTO Reorder(REORDER_DATE, REORDER_DATE_IN,REORDER_COM_DLVR, REORDER_TYP,REORDER_QTY,REORDER_STATE,ITEM_CODE,COM_CODE, MANAGER_ID,SALES_Work_Order_ID)
VALUES(@REORDER_DATE, @REORDER_DATE_IN,@REORDER_COM_DLVR, @REORDER_TYP,@REORDER_QTY,@REORDER_STATE,@ITEM_CODE,@COM_CODE, @MANAGER_ID,@SALES_Work_Order_ID) ";
cmd.Parameters.AddWithValue("@REORDER_DATE", vo.REORDER_DATE);
cmd.Parameters.AddWithValue("@REORDER_DATE_IN", vo.REORDER_DATE_IN);
cmd.Parameters.AddWithValue("@REORDER_COM_DLVR", vo.REORDER_COM_DLVR);
cmd.Parameters.AddWithValue("@REORDER_TYP", vo.REORDER_TYP);
cmd.Parameters.AddWithValue("@REORDER_QTY", vo.REORDER_QTY);
cmd.Parameters.AddWithValue("@REORDER_STATE", vo.REORDER_STATE);
cmd.Parameters.AddWithValue("@ITEM_CODE", vo.ITEM_CODE);
cmd.Parameters.AddWithValue("@COM_CODE", vo.COM_CODE);
cmd.Parameters.AddWithValue("@MANAGER_ID", vo.MANAGER_ID);
cmd.Parameters.AddWithValue("@SALES_Work_Order_ID", vo.SALES_Work_Order_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 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();
}
}
internal bool insertREORDER(REORDER_VO vo)
{
REORDERDAC dac = new REORDERDAC();
return(dac.insertREORDER(vo));
}
