public Message SalesCancel(SalesEndState_VO vo, string id)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = "SP_SalesCancel";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@P_SALES_WORK_ORDER_ID", vo.SALES_WORK_ORDER_ID);
cmd.Parameters.AddWithValue("@P_ITEM_CODE", vo.ITEM_CODE);
cmd.Parameters.AddWithValue("@P_WO_LAST_MDFR", id);
cmd.Parameters.Add(new SqlParameter("@P_ReturnCode", System.Data.SqlDbType.NVarChar, 5));
cmd.Parameters["@P_ReturnCode"].Direction = System.Data.ParameterDirection.Output;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
string result = cmd.Parameters["@P_ReturnCode"].Value.ToString();
Message message = new Message();
if (result == "S01")
{
message.IsSuccess = true;
message.ResultMessage = "성공하였습니다.";
}
else if (result == "S00")
{
message.IsSuccess = false;
message.ResultMessage = "실패하였습니다.";
}
return(message);
}
}
private void btnMOVE_Click(object sender, EventArgs e)
{
dgvSalesEnd.EndEdit();
int cnt = 0;
//체크가 되었는지 확인
foreach (DataGridViewRow item in dgvSalesEnd.Rows)
{
if (Convert.ToBoolean(item.Cells[0].Value))
{
cnt++;
}
}
if (cnt == 1)
{
if (MessageBox.Show("마감처리 하시겠습니까?", "매출마감", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
SalesEndState_VO vo = new SalesEndState_VO();
vo.SALES_WORK_ORDER_ID = dgvSalesEnd.CurrentRow.Cells[1].Value.ToString();
vo.SALES_COM_CODE = dgvSalesEnd.CurrentRow.Cells[3].Value.ToString();
vo.ITEM_CODE = dgvSalesEnd.CurrentRow.Cells[4].Value.ToString();
vo.SALES_DUEDATE = dgvSalesEnd.CurrentRow.Cells[6].Value.ToString();
vo.SALES_QTY = Convert.ToInt32(dgvSalesEnd.CurrentRow.Cells[7].Value);
vo.SALES_TTL = Convert.ToInt32(dgvSalesEnd.CurrentRow.Cells[10].Value);
SalesEndService service = new SalesEndService();
Message msg = service.SalesRecord(vo, LoginInfo.UserInfo.LI_NAME);
if (msg.IsSuccess)
{
MessageBox.Show(msg.ResultMessage);
this.DialogResult = DialogResult.OK;
GetSalesEnd();
}
else
{
MessageBox.Show(msg.ResultMessage);
return;
}
}
}
else
{
MessageBox.Show("하나의 항목씩만 가능합니다.");
return;
}
}
private void btnSalesCancel_Click(object sender, EventArgs e)
{
dgvSalesEndState.EndEdit();
int cnt = 0;
foreach (DataGridViewRow item in dgvSalesEndState.Rows)
{
if (Convert.ToBoolean(item.Cells[0].Value))
{
cnt++;
}
}
if (cnt == 1)
{
if (MessageBox.Show("마감취소 하시겠습니까?", "마감취소", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
SalesEndState_VO vo = new SalesEndState_VO();
vo.SALES_WORK_ORDER_ID = dgvSalesEndState.CurrentRow.Cells[1].Value.ToString();
vo.ITEM_CODE = dgvSalesEndState.CurrentRow.Cells[4].Value.ToString();
SalesEndService service = new SalesEndService();
Message msg = service.SalesCancel(vo, LoginInfo.UserInfo.LI_NAME);
if (msg.IsSuccess)
{
MessageBox.Show(msg.ResultMessage);
this.DialogResult = DialogResult.OK;
GetSalesEndState();
}
else
{
MessageBox.Show(msg.ResultMessage);
return;
}
}
}
else
{
MessageBox.Show("하나의 항목씩만 가능합니다.");
return;
}
}
public Message SalesCancel(SalesEndState_VO vo, string id)
{
SalesEndDAC dac = new SalesEndDAC();
return(dac.SalesCancel(vo, id));
}
public Message SalesRecord(SalesEndState_VO vo, string name)
{
SalesEndDAC dac = new SalesEndDAC();
return(dac.SalesRecord(vo, name));
}
