private void FacilitieInfoPop_Load(object sender, EventArgs e) { txtModifyTime.Text = string.Format("{0:yyyy-MM-dd HH:mm:ss}", today); //콤보박스 바인딩 { service = new CommonCodeService(); list = service.GetCommonCodeAll(); { //사용유무 var mCode = (from item in list where item.common_type == "user_flag" select item).ToList(); ComboUtil.ComboBinding <CommonVO>(cboIsUsed, mCode, "common_value", "common_name"); } { var mCode = (from item in list where item.common_type == "user_flag" select item).ToList(); mCode.Reverse(); ComboUtil.ComboBinding <CommonVO>(cboIsOS, mCode, "common_value", "common_name"); } R_service = new ResourceService(); var Fatory_list = R_service.GetFactoryAll(); var WH1 = (from wh1 in Fatory_list where wh1.facility_class == "창고" select wh1).ToList(); ComboUtil.ComboBinding <FactoryDB_VO>(cboUseWH, WH1, "factory_id", "factory_name", "미선택"); var WH2 = (from wh1 in Fatory_list where wh1.facility_class == "창고" select wh1).ToList(); ComboUtil.ComboBinding <FactoryDB_VO>(cboOkWH, WH2, "factory_id", "factory_name", "미선택"); var WH3 = (from wh1 in Fatory_list where wh1.facility_class == "창고" select wh1).ToList(); ComboUtil.ComboBinding <FactoryDB_VO>(cboNgWH, WH3, "factory_id", "factory_name", "미선택"); } if (mode == EditMode.Update) { MachineVO vo = this.VO; lblID.Text = VO.m_id.ToString(); lblGrCodeID.Text = VO.mgrade_id.ToString(); txtMgrade_code.Text = VO.mgrade_code; txtCodeFacility.Text = VO.m_code; txtNameFacility.Text = VO.m_name; cboUseWH.Text = VO.m_use_sector; cboOkWH.Text = VO.m_ok_sector; cboNgWH.Text = VO.m_ng_sector; cboIsUsed.Text = VO.m_yn; cboIsOS.Text = VO.m_os_yn; txtModifier.Text = VO.m_uadmin; txtModifyTime.Text = VO.m_udate; txtCheck.Text = VO.m_check; txtComment.Text = VO.m_comment; } }
/// <summary> /// MachineVO로 선언한 vo에 각 text의 내용을 담아서 DAC단의 파라미터로 전달 /// 결과를 Bool 타입으로 받아서 True/False시 확인/오류 메세지 출력 /// 작성자: 최현호 / 작성일: 210210 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnEdit_Click(object sender, EventArgs e) { #region 등록 및 수정 try { if (label1.Text == "설비정보 등록") { MachineVO vo = new MachineVO { m_info = txtMInfo.Text, m_name = txtMName.Text, m_comment = txtComment.Text, m_yn = cbYN.Text, }; bool result = service.CHH_MachineInsert(vo); if (result) { MessageBox.Show(Properties.Resources.msgOK); this.Close(); } else { MessageBox.Show(Properties.Resources.msgError); } } else if (label1.Text == "설비정보 수정") { MachineVO vo = new MachineVO { m_id = int.Parse(lblID.Text), m_info = txtMInfo.Text, m_name = txtMName.Text, m_comment = txtComment.Text, m_yn = cbYN.Text, m_uadmin = LoginVO.user.Name, m_udate = DateTime.Now.ToShortDateString() }; bool result = service.CHH_MachineUpdate(vo); if (result) { MessageBox.Show(Properties.Resources.msgOK); this.Close(); } else { MessageBox.Show(Properties.Resources.msgError); } } } catch (Exception err) { MessageBox.Show(err.Message); } #endregion }
//수정 public FacilitieInfoPop(EditMode editMode, MachineVO VO) { InitializeComponent(); if (editMode == EditMode.Update) { mode = EditMode.Update; this.Text = "설비정보 수정"; this.VO = VO; } if (editMode == EditMode.Input) { mode = EditMode.Input; this.Text = "설비정보 추가"; } }
public bool CHH_MachineInsert(MachineVO vo) { string sql = @"insert into TBL_MACHINE(m_info, m_name, m_comment, m_yn) values (@m_info, @m_name, @m_comment, @m_yn)"; using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@m_info", vo.m_info); cmd.Parameters.AddWithValue("@m_name", vo.m_name); cmd.Parameters.AddWithValue("@m_comment", vo.m_comment); cmd.Parameters.AddWithValue("@m_yn", vo.m_yn); int iRowAffect = cmd.ExecuteNonQuery(); conn.Close(); return(iRowAffect > 0); } }
public static void MachineNameBinding(ComboBox cbo, List <MachineVO> list, bool blankItem = true, string blankText = "") { var codeList = (from item in list select item).ToList(); if (blankItem) { MachineVO blank = new MachineVO { m_id = null, m_name = blankText }; codeList.Insert(0, blank); } cbo.DisplayMember = "m_name"; cbo.ValueMember = "m_id"; cbo.DataSource = codeList; }
public bool CHH_MachineUpdate(MachineVO vo) { string sql = @"update TBL_MACHINE set m_info = @m_info, m_name = @m_name, m_comment = @m_comment, m_yn = @m_yn, m_uadmin = @m_uadmin, m_udate = @m_udate where m_id = @m_id"; using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@m_info", vo.m_info); cmd.Parameters.AddWithValue("@m_name", vo.m_name); cmd.Parameters.AddWithValue("@m_comment", vo.m_comment); cmd.Parameters.AddWithValue("@m_yn", vo.m_yn); cmd.Parameters.AddWithValue("@m_uadmin", vo.m_uadmin); cmd.Parameters.AddWithValue("@m_udate", vo.m_udate); cmd.Parameters.AddWithValue("@m_id", vo.m_id); int iRowAffect = cmd.ExecuteNonQuery(); conn.Close(); return(iRowAffect > 0); } }
public bool UpdateMachine(MachineVO VO) { using (SqlCommand cmd = new SqlCommand()) { string sql = "UpdateMachine"; cmd.Connection = new SqlConnection(this.ConnectionString); cmd.CommandText = sql; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection.Open(); cmd.Parameters.AddWithValue("@m_id", VO.m_id); cmd.Parameters.AddWithValue("@mgrade_id", VO.mgrade_id); cmd.Parameters.AddWithValue("@m_code", VO.m_code); cmd.Parameters.AddWithValue("@m_name", VO.m_name); cmd.Parameters.AddWithValue("@m_use_sector", VO.m_use_sector); cmd.Parameters.AddWithValue("@m_ok_sector", VO.m_ok_sector); if (VO.m_ng_sector == "") { SqlParameter param1 = new SqlParameter("@m_ng_sector", SqlDbType.NVarChar); param1.Value = DBNull.Value; cmd.Parameters.Add(param1); } else { cmd.Parameters.AddWithValue("@m_ng_sector", VO.m_ng_sector); } cmd.Parameters.AddWithValue("@m_os_yn", VO.m_os_yn); cmd.Parameters.AddWithValue("@m_check", VO.m_check); cmd.Parameters.AddWithValue("@m_comment", VO.m_comment); cmd.Parameters.AddWithValue("@m_yn", VO.m_yn); cmd.Parameters.AddWithValue("@m_uadmin", VO.m_uadmin); cmd.Parameters.AddWithValue("@m_udate", VO.m_udate); var successRow = cmd.ExecuteNonQuery(); cmd.Connection.Close(); return(successRow > 0); } }
private void btnUpdate_Click(object sender, EventArgs e) { try { if (lblID2.Text == "") { SetBottomStatusLabel("선택된 설비가 없습니다"); MessageBox.Show("변경할 설비를 선택해주세요"); return; } else { if (dataGridView2.Rows.Count > 0) { DataGridViewRow rows = dataGridView2.CurrentRow; MachineVO VO = new MachineVO(); VO.m_id = Convert.ToInt32(rows.Cells[0].Value.ToString()); VO.mgrade_code = rows.Cells[2].Value.ToString(); VO.mgrade_id = Convert.ToInt32(rows.Cells[1].Value); VO.m_code = rows.Cells[3].Value.ToString(); VO.m_name = rows.Cells[4].Value.ToString(); VO.m_use_sector = rows.Cells[5].Value.ToString(); VO.m_ok_sector = rows.Cells[6].Value.ToString(); if (rows.Cells[7].Value == null) { VO.m_ng_sector = ""; } else { VO.m_ng_sector = rows.Cells[7].Value.ToString(); } VO.m_yn = rows.Cells[11].Value.ToString(); VO.m_os_yn = rows.Cells[8].Value.ToString(); VO.m_uadmin = rows.Cells[12].Value.ToString(); VO.m_udate = string.Format("{0:yyyy-MM-dd HH:mm:ss}", today); if (rows.Cells[9].Value == null) { VO.m_check = ""; } else { VO.m_check = rows.Cells[9].Value.ToString(); } VO.m_comment = rows.Cells[10].Value.ToString(); FacilitieInfoPop frm = new FacilitieInfoPop(FacilitieInfoPop.EditMode.Update, VO); if (frm.ShowDialog() == DialogResult.OK) { LoadData(); SetBottomStatusLabel("설비 정보 수정 성공"); MessageBox.Show("설비 정보 수정 성공"); } } } } catch (Exception err) { LoggingUtility.GetLoggingUtility(err.Message, Level.Error); } }
public bool CHH_MachineUpdate(MachineVO vo) { MachineDAC dac = new MachineDAC(); return(dac.CHH_MachineUpdate(vo)); }
public bool CHH_MachineInsert(MachineVO vo) { MachineDAC dac = new MachineDAC(); return(dac.CHH_MachineInsert(vo)); }
private void btnSave_Click(object sender, EventArgs e) { try { #region if (txtCodeFacility.Text == "") { MessageBox.Show("설비코드을 입력해주세요"); this.DialogResult = DialogResult.None; return; } else if (txtNameFacility.Text == "") { MessageBox.Show("설비명을 입력해주세요"); this.DialogResult = DialogResult.None; return; } if (cboUseWH.SelectedIndex == 0) { MessageBox.Show("소진창고를 선택해주세요"); this.DialogResult = DialogResult.None; return; } else if (cboOkWH.SelectedIndex == 0) { MessageBox.Show("양품창고를 선택해주세요"); this.DialogResult = DialogResult.None; return; } if (cboNgWH.SelectedIndex == 0) { cboNgWH.Text = ""; } #endregion MachineVO VO = new MachineVO(); VO.mgrade_id = Convert.ToInt32(lblGrCodeID.Text); VO.mgrade_code = txtMgrade_code.Text; VO.m_code = txtCodeFacility.Text; VO.m_name = txtNameFacility.Text; VO.m_use_sector = cboUseWH.Text; VO.m_ok_sector = cboOkWH.Text; VO.m_ng_sector = cboNgWH.Text; VO.m_yn = cboIsUsed.Text; VO.m_os_yn = cboIsOS.Text; VO.m_uadmin = txtModifier.Text; VO.m_udate = txtModifyTime.Text; VO.m_check = txtCheck.Text; VO.m_comment = txtComment.Text; //등록 if (mode == EditMode.Input) { bool bResult = R_service.InsertMachine(VO); if (bResult) { MessageBox.Show("등록성공"); this.DialogResult = DialogResult.OK; } else { MessageBox.Show("등록실패"); this.DialogResult = DialogResult.None; } } else if (mode == EditMode.Update) { VO.m_id = Convert.ToInt32(lblID.Text); bool bResult = R_service.UpdateMachine(VO); if (bResult) { MessageBox.Show("수정성공"); this.DialogResult = DialogResult.OK; } else { MessageBox.Show("수정실패"); this.DialogResult = DialogResult.None; } } } catch (NullReferenceException err) { MessageBox.Show("입력되지 않은값이 있습니다, 다시 확인해주세요", "입력확인", MessageBoxButtons.OK, MessageBoxIcon.Error); this.DialogResult = DialogResult.None; return; } catch (Exception err) { string str = err.Message; } }
public bool UpdateMachine(MachineVO VO) { return(dac.UpdateMachine(VO)); }
public bool InsertMachine(MachineVO VO) { return(dac.InsertMachine(VO)); }