/// <summary>
/// 입력 버튼 이벤트
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnOK_Click(object sender, EventArgs e)
{
try
{
if (ITEM_CODE.Text.Length < 1 || BOM_QTY.Text.Length < 1 || BOM_USE_YN.Text.Length < 1 || BOM_AUTOREDUCE_YN.Text.Length < 1 || BOM_PLAN_YN.Text.Length < 1)
{
MessageBox.Show("필수 입력사항을 입력해주세요.");
return;
}
BOM_VO vo = new BOM_VO();
vo.BOM_CODE = code;
vo.BOM_PARENT_CODE = (BOM_PARENT_CODE.Text == "-") ? "-" : BOM_PARENT_CODE.SelectedValue.ToString();
vo.ITEM_CODE = ITEM_CODE.SelectedValue.ToString();
vo.BOM_QTY = (BOM_QTY.Text.Length < 1) ? 1 : int.Parse(BOM_QTY.Text);
vo.BOM_STARTDATE = BOM_STARTDATE.Value.ToShortDateString();
vo.BOM_ENDDATE = BOM_ENDDATE.Value.ToShortDateString();
vo.BOM_USE_YN = BOM_USE_YN.Text;
vo.BOM_LAST_MDFR = BOM_LAST_MDFR.Text;
vo.BOM_LAST_MDFY = BOM_LAST_MDFY.Value.ToShortDateString();
vo.BOM_AUTOREDUCE_YN = BOM_AUTOREDUCE_YN.Text;
vo.BOM_PLAN_YN = BOM_PLAN_YN.Text;
vo.BOM_REMARK = BOM_REMARK.Text;
BOMService item = new BOMService();
string result = item.SaveBOM(vo);
if (result == "C200")
{
MessageBox.Show("성공적으로 입력되었습니다.");
this.DialogResult = DialogResult.OK;
//this.Close();
}
else if (result == "C201")
{
MessageBox.Show("BOM이 중복되었습니다. 다시 입력해주세요");
}
}
catch (Exception err)
{
this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}");
}
}
public string SaveBOM(BOM_VO vo)
{
string result;
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = "SaveBOM";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@P_BOM_CODE", vo.BOM_CODE); //1
cmd.Parameters.AddWithValue("@P_BOM_PARENT_CODE", vo.BOM_PARENT_CODE); //2
cmd.Parameters.AddWithValue("@P_ITEM_CODE", vo.ITEM_CODE); //3
cmd.Parameters.AddWithValue("@P_BOM_QTY", vo.BOM_QTY); // 4
cmd.Parameters.AddWithValue("@P_BOM_STARTDATE", vo.BOM_STARTDATE); //5
cmd.Parameters.AddWithValue("@P_BOM_ENDDATE", vo.BOM_ENDDATE); //6
cmd.Parameters.AddWithValue("@P_BOM_USE_YN", vo.BOM_USE_YN); //7
cmd.Parameters.AddWithValue("@P_BOM_LAST_MDFR", vo.BOM_LAST_MDFR); //8
cmd.Parameters.AddWithValue("@P_BOM_LAST_MDFY", vo.BOM_LAST_MDFY); // 9
cmd.Parameters.AddWithValue("@P_BOM_AUTOREDUCE_YN", vo.BOM_AUTOREDUCE_YN); //10
cmd.Parameters.AddWithValue("@P_BOM_PLAN_YN", vo.BOM_PLAN_YN); //11
cmd.Parameters.AddWithValue("@P_BOM_REMARK", vo.BOM_REMARK); //12
cmd.Parameters.Add(new SqlParameter("@P_ReturnCode", SqlDbType.NVarChar, 5)); //13
cmd.Parameters["@P_ReturnCode"].Direction = ParameterDirection.Output;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
result = cmd.Parameters["@P_ReturnCode"].Value.ToString();
return(result);
}
}
catch (Exception err)
{
return(result = "C201");
}
}
/// <summary>
/// 업데이트 팝업 시 해당 코드이 정보를 뿌려주는 함수
/// </summary>
/// <param name="code"></param>
private void GetBOM(int code)
{
try
{
BOMService item = new BOMService();
BOM_VO vo = item.GetBOM(code);
BOM_PARENT_CODE.SelectedValue = vo.BOM_PARENT_CODE;
ITEM_CODE.SelectedValue = vo.ITEM_CODE;
BOM_QTY.Text = vo.BOM_QTY.ToString();
BOM_STARTDATE.Text = vo.BOM_STARTDATE;
BOM_ENDDATE.Text = vo.BOM_ENDDATE;
BOM_USE_YN.Text = vo.BOM_USE_YN;
BOM_LAST_MDFR.Text = vo.BOM_LAST_MDFR;
BOM_LAST_MDFY.Text = vo.BOM_LAST_MDFY;
BOM_AUTOREDUCE_YN.Text = vo.BOM_AUTOREDUCE_YN;
BOM_PLAN_YN.Text = vo.BOM_PLAN_YN;
BOM_REMARK.Text = vo.BOM_REMARK;
}
catch (Exception err)
{
this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}");
}
}
public string SaveBOM(BOM_VO vo)
{
BOMDAC dac = new BOMDAC();
return(dac.SaveBOM(vo));
}
