/// <summary>
/// W/O 저장하는 이벤트
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnOK_Click(object sender, EventArgs e)
{
//유효값 확인
bool bQTY = txtOrderQTY.Text.Length > 0;
bool bWO = txtWO.Text.Trim().Length > 0;
if (!(bQTY || bWO))
{
MessageBox.Show("필수값을 입력해주세요.", "필수값 입력 확인", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//전달 vo 생성
SALES_WORK_VO vo = new SALES_WORK_VO();
vo.SALES_ID = 0; //등록
if (InsertOrUpdate == 2)
{
vo.SALES_ID = int.Parse(txtID.Text); //수정
}
vo.SALES_Work_Order_ID = txtWO.Text.Trim();
vo.SO_PurchaseOrder = txtPO.Text.Trim();
vo.COM_CODE = cboCOM.SelectedValue.ToString();
vo.SALES_COM_CODE = cboCOM2.SelectedValue.ToString();
vo.SALES_DUEDATE = dtpDueDate.Value.ToShortDateString();
vo.ITEM_CODE = cboItem.SelectedValue.ToString();
vo.SALES_QTY = int.Parse(txtOrderQTY.Text);
if (txtOutQTY.Text.Trim().Length < 1)
{
txtOutQTY.Text = "0";
}
vo.SALES_Out_QTY = int.Parse(txtOutQTY.Text);
if (txtNoQTY.Text.Trim().Length < 1)
{
txtNoQTY.Text = "0";
}
vo.SALES_NO_QTY = int.Parse(txtNoQTY.Text);
vo.SALES_MKT = cboMarket.Text;
vo.SALES_Order_TYPE = cboOrderTyp.Text;
vo.SALES_REMARK = txtRemark.Text;
//서비스호출
SalesService service = new SalesService();
Message msg = service.InsertOrUpdateSalesWork(vo);
if (msg.IsSuccess)
{
MessageBox.Show(msg.ResultMessage);
this.Close();
}
else
{
MessageBox.Show(msg.ResultMessage);
return;
}
}
//영업마스터 생성
private void btnMaster_Click(object sender, EventArgs e)
{
if (dgvSalesMaster.Rows.Count > 0)
{
Message msg = new TEAM3FINALVO.Message();
//DB에 저장
for (int i = 0; i < RList.Count; i++)
{
//전달 vo 생성
SALES_WORK_VO vo1 = new SALES_WORK_VO();
vo1.SALES_ID = 0; //등록
vo1.SALES_Work_Order_ID = RList[i].SALES_Work_Order_ID;
vo1.SO_PurchaseOrder = "";
vo1.COM_CODE = RList[i].COM_CODE;
vo1.SALES_COM_CODE = RList[i].SALES_COM_CODE;
vo1.SALES_DUEDATE = RList[i].SALES_DUEDATE;
vo1.ITEM_CODE = RList[i].ITEM_CODE;
vo1.SALES_QTY = RList[i].SALES_QTY;
vo1.SALES_Out_QTY = 0;
vo1.SALES_NO_QTY = 0;
vo1.SALES_MKT = RList[i].SALES_MKT;
vo1.SALES_Order_TYPE = RList[i].SALES_Order_TYPE;
vo1.SALES_REMARK = "";
//서비스호출
SalesService service = new SalesService();
msg = service.InsertOrUpdateSalesWork(vo1);
}
if (msg.IsSuccess)
{
MessageBox.Show("생성되었습니다.", "생성 확인", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("생성에 실패하였습니다.", "생성 실패", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("생성할 영업마스터가 존재하지않습니다.", "영업마스터 확인", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// 엑셀 파일 읽어와서 등록하는 메서드
/// </summary>
private void GetExcelFile()
{
if (openFileName.Length > 1)
{
Excel.Application xlApp = null;
Excel.Workbook xlWorkBook = null;
Excel.Worksheet xlWorkSheet = null;
DataTable dt = new DataTable();
try
{
list.Clear();
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(openFileName);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
Excel.Range range = xlWorkSheet.UsedRange;
object[,] data = range.Value;
for (int i = 1; i < range.Columns.Count; i++)
{
dt.Columns.Add(data[1, i].ToString(), typeof(string));
}
for (int r = 2; r <= range.Rows.Count; r++)
{
DataRow dr = dt.Rows.Add();
for (int c = 1; c < range.Columns.Count; c++)
{
if (c == 1)
{
dr[c - 1] = r - 1;
}
else
{
dr[c - 1] = data[r, c];
}
}
}
xlWorkBook.Close(true);
xlApp.Quit();
if (dt.Rows.Count > 0)
{
//DB에 저장
for (int i = 0; i < dt.Rows.Count; i++)
{
//전달 vo 생성
SALES_WORK_VO vo = new SALES_WORK_VO();
vo.SALES_ID = 0; //등록
vo.SALES_Work_Order_ID = (dt.Rows[i][1] != null) ? dt.Rows[i][1].ToString() : "";
vo.SO_PurchaseOrder = "";
vo.COM_CODE = (dt.Rows[i][2] != null) ? dt.Rows[i][2].ToString() : "";
vo.SALES_COM_CODE = (dt.Rows[i][3] != null) ? dt.Rows[i][3].ToString() : "";
vo.SALES_DUEDATE = (dt.Rows[i][8] != null) ? DateTime.ParseExact(dt.Rows[i][8].ToString(), "yyyy-MM-dd tt hh:mm:ss", null, System.Globalization.DateTimeStyles.AssumeLocal).ToString("yyyy-MM-dd HH:mm:ss") : "";
vo.ITEM_CODE = (dt.Rows[i][6] != null) ? dt.Rows[i][6].ToString() : "";
vo.SALES_QTY = (dt.Rows[i][7] != null) ? Convert.ToInt32(dt.Rows[i][7]) : 0;
vo.SALES_Out_QTY = 0;
vo.SALES_NO_QTY = 0;
vo.SALES_MKT = (dt.Rows[i][4] != null) ? dt.Rows[i][4].ToString() : "";
vo.SALES_Order_TYPE = (dt.Rows[i][5] != null) ? dt.Rows[i][5].ToString() : "";
vo.SALES_REMARK = "";
list.Add(vo);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (xlApp != null)
{
ReleaseExcelObject(xlWorkSheet);
ReleaseExcelObject(xlWorkBook);
ReleaseExcelObject(xlApp);
}
this.DialogResult = DialogResult.OK;
}
}
}
public Message InsertOrUpdateSalesWork(SALES_WORK_VO vo)
{
SalesDAC dac = new SalesDAC();
return(dac.InsertOrUpdateSalesWork(vo));
}
/// <summary>
/// W/O 저장 메서드
/// </summary>
/// <param name="vo"></param>
/// <returns></returns>
public Message InsertOrUpdateSalesWork(SALES_WORK_VO vo)
{
try
{
string sql = "SP_SaveSalesWork";
using (SqlConnection conn = new SqlConnection(this.ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@P_SALES_ID", vo.SALES_ID);
cmd.Parameters.AddWithValue("@P_SALES_Work_Order_ID", vo.SALES_Work_Order_ID);
cmd.Parameters.AddWithValue("@P_SALES_Out_QTY", vo.SALES_Out_QTY);
cmd.Parameters.AddWithValue("@P_SALES_MKT", vo.SALES_MKT);
cmd.Parameters.AddWithValue("@P_SALES_DUEDATE", vo.SALES_DUEDATE);
cmd.Parameters.AddWithValue("@P_SALES_QTY", vo.SALES_QTY);
cmd.Parameters.AddWithValue("@P_SALES_NO_QTY", vo.SALES_NO_QTY);
cmd.Parameters.AddWithValue("@P_SALES_Order_TYPE", vo.SALES_Order_TYPE);
cmd.Parameters.AddWithValue("@P_SALES_COM_CODE", vo.SALES_COM_CODE);
cmd.Parameters.AddWithValue("@P_SALES_REMARK", vo.SALES_REMARK);
cmd.Parameters.AddWithValue("@P_COM_CODE", vo.COM_CODE);
cmd.Parameters.AddWithValue("@P_ITEM_CODE", vo.ITEM_CODE);
cmd.Parameters.AddWithValue("@P_SO_PurchaseOrder", vo.SO_PurchaseOrder);
cmd.Parameters.Add(new SqlParameter("@P_ReturnCode", System.Data.SqlDbType.NVarChar, 5));
cmd.Parameters["@P_ReturnCode"].Direction = System.Data.ParameterDirection.Output;
cmd.ExecuteNonQuery();
conn.Close();
string result = cmd.Parameters["@P_ReturnCode"].Value.ToString();
Message message = new Message();
if (result == "S01")
{
message.IsSuccess = true;
message.ResultMessage = "성공적으로 등록되었습니다.";
}
else if (result == "S02")
{
message.IsSuccess = true;
message.ResultMessage = "성공적으로 수정되었습니다.";
}
else if (result == "S03")
{
message.IsSuccess = false;
message.ResultMessage = "이미 존재하는 W/O입니다.";
}
else if (result == "S00")
{
message.IsSuccess = false;
message.ResultMessage = "잘못된 실행입니다.";
}
return(message);
}
}
}
catch (Exception err)
{
return(new Message(err));
}
}
