private void btnCreate_Click(object sender, EventArgs e) { if (txtdefname.Text.Trim().Length < 1 || txtdefcomment.Text.Trim().Length < 1) { MessageBox.Show("필수항목을 채워주세요"); return; } try { if (headName == "불량유형추가") { ComboItemVO def = new ComboItemVO { common_name = txtdefname.Text, common_value = txtdefcomment.Text }; DefService service = new DefService(); bool bResult = service.DefInsert(def); if (bResult) { MessageBox.Show("새로운 불량유형 등록하였습니다"); this.Close(); } else { MessageBox.Show("등록에 실패하셨습니다"); } } else if (headName == "불량유형수정") { ComboItemVO def = new ComboItemVO { common_id = common_id, common_name = txtdefname.Text, common_value = txtdefcomment.Text }; DefService service = new DefService(); bool bResult = service.DefUpdate(def); if (bResult) { MessageBox.Show("불량유형을 수정하였습니다"); this.Close(); } else { MessageBox.Show("수정에 실패하셨습니다"); } } } catch (Exception err) { MessageBox.Show(err.Message); } }
public bool DefInsert(ComboItemVO def) { string sql = @"insert into TBL_COMMON_CODE(common_type, common_name, common_value) values('불량유형', @common_name, @common_value)"; int iRowAffect = 0; using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@common_name", def.common_name); cmd.Parameters.AddWithValue("@common_value", def.common_value); iRowAffect = cmd.ExecuteNonQuery(); Dispose(); } return(iRowAffect > 0); }
public static void ComboBinding(ComboBox cbo, List <ComboItemVO> list, string gubun, bool blankItem = true, string blankText = "") { var codeList = (from item in list where item.Gubun.Equals(gubun) select item).ToList(); if (blankItem) { ComboItemVO blank = new ComboItemVO { Code = "", CodeName = blankText }; codeList.Insert(0, blank); } cbo.DisplayMember = "CodeName"; cbo.ValueMember = "Code"; cbo.DataSource = codeList; }
public bool DefUpdate(ComboItemVO def) { string sql = @"update TBL_COMMON_CODE set common_name = @common_name, common_value = @common_value where common_id = @common_id"; int iRowAffect = 0; using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@common_id", def.common_id); cmd.Parameters.AddWithValue("@common_name", def.common_name); cmd.Parameters.AddWithValue("@common_value", def.common_value); iRowAffect = cmd.ExecuteNonQuery(); Dispose(); } return(iRowAffect > 0); }
/// <summary> /// 콤보박스 바인딩 /// </summary> /// <param name="cbo"></param> /// <param name="list"></param> /// <param name="gubun"></param> /// <param name="blankItem"></param> /// <param name="blankText"></param> public static void ComboBinding(ComboBox cbo, List <ComboItemVO> list, string gubun, bool blankItem = true, string blankText = "") { //common_id, common_type, common_name, common_value var codeList = (from item in list where item.common_type.Equals(gubun) select item).ToList(); if (blankItem) { ComboItemVO blank = new ComboItemVO { common_id = null, common_name = blankText }; codeList.Insert(0, blank); } cbo.DisplayMember = "common_name"; cbo.ValueMember = "common_id"; cbo.DataSource = codeList; }
public bool DefUpdate(ComboItemVO def) { WorkOrderDAC dac = new WorkOrderDAC(); return(dac.DefUpdate(def)); }
public bool DefInsert(ComboItemVO def) { WorkOrderDAC dac = new WorkOrderDAC(); return(dac.DefInsert(def)); }