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