private void item_chk_del() { ComInfo comInfo = new ComInfo(); DialogResult msgOk = comInfo.deleteConfrim("제품검사항목", txt_item_nm.Text.ToString() + "-" + cmb_item_flow.SelectedValue.ToString()); if (msgOk == DialogResult.No) { return; } wnDm wDm = new wnDm(); int rsNum = wDm.deleteItemChk(txt_item_cd2.Text.ToString()); if (rsNum == 0) { resetSetting2(); item_list(); MessageBox.Show("성공적으로 삭제하였습니다."); } else if (rsNum == 1) { MessageBox.Show("삭제에 실패하였습니다."); } }
private void output_del() { ComInfo comInfo = new ComInfo(); DialogResult msgOk = comInfo.deleteConfrim("반품등록삭제", txt_return_date.Text.ToString() + " - " + txt_retrun_cd.Text.ToString()); if (msgOk == DialogResult.No) { return; } wnDm wDm = new wnDm(); int rsNum = wDm.반품등록삭제(txt_return_date.Text.ToString(), txt_retrun_cd.Text.ToString()); if (rsNum == 0) { resetSetting(); MessageBox.Show("성공적으로 삭제하였습니다."); } else if (rsNum == 1) { MessageBox.Show("삭제에 실패하였습니다."); } }
private void plan_del() { ComInfo comInfo = new ComInfo(); DialogResult msgOk = comInfo.deleteConfrim("견적서", txt_esti_date.Text.ToString() + " - " + txt_esti_cd.Text.ToString()); if (msgOk == DialogResult.No) { return; } wnDm wDm = new wnDm(); int rsNum = wDm.deleteEstimate(txt_esti_date.Text.ToString(), txt_esti_cd.Text.ToString()); if (rsNum == 0) { resetSetting(); esti_list(estiGrid, "where A.ESTI_DATE >= '" + start_date.Text.ToString() + "' and A.ESTI_DATE <= '" + end_date.Text.ToString() + "'"); MessageBox.Show("성공적으로 삭제하였습니다."); } else if (rsNum == 1) { MessageBox.Show("삭제에 실패하였습니다."); } }
private void order_del() { ComInfo comInfo = new ComInfo(); DialogResult msgOk = comInfo.deleteConfrim("발주서", txt_order_date.Text.ToString() + " - " + txt_order_cd.Text.ToString()); if (msgOk == DialogResult.No) { return; } wnDm wDm = new wnDm(); int rsNum = wDm.deleteOrder(txt_order_date.Text.ToString(), txt_order_cd.Text.ToString()); if (rsNum == 0) { resetSetting(); StringBuilder sb = new StringBuilder(); sb.AppendLine("and A.ORDER_DATE >= '" + start_date.Text.ToString() + "' and A.ORDER_DATE <= '" + end_date.Text.ToString() + "'"); string str = queryStr(sb.ToString()); order_list(orderGrid, str); MessageBox.Show("성공적으로 삭제하였습니다."); } else if (rsNum == 1) { MessageBox.Show("삭제에 실패하였습니다."); } }
private void raw_del() { wnDm wDm = new wnDm(); DataTable dt = wDm.select_all_rawCd(txt_raw_mat_cd.Text.ToString()); if (dt != null && dt.Rows.Count > 0) { MessageBox.Show("해당 자재의 사용내역이 남아있어서 삭제할 수 없습니다."); return; } ComInfo comInfo = new ComInfo(); DialogResult msgOk = comInfo.deleteConfrim("원자재", txt_raw_mat_nm.Text.ToString()); if (msgOk == DialogResult.No) { return; } int rsNum = wDm.deleteRaw(txt_raw_mat_cd.Text.ToString()); if (rsNum == 0) { resetSetting(); raw_list(); MessageBox.Show("성공적으로 삭제하였습니다."); } else if (rsNum == 1) { MessageBox.Show("삭제에 실패하였습니다."); } }
private void jumun_del() { ComInfo comInfo = new ComInfo(); DialogResult msgOk = comInfo.deleteConfrim("주문서", txt_jumun_date.Text.ToString() + " - " + txt_jumun_cd.Text.ToString()); if (msgOk == DialogResult.No) { return; } if (chk_complete_yn.Checked == true && chk_complete_yn.Enabled == false) { MessageBox.Show("이미 납품된 주문서는 삭제할 수 없습니다."); return; } wnDm wDm = new wnDm(); int rsNum = wDm.deleteJumun(txt_jumun_date.Text.ToString(), txt_jumun_cd.Text.ToString()); if (rsNum == 0) { resetSetting(); jumun_list(); MessageBox.Show("성공적으로 삭제하였습니다."); } else if (rsNum == 1) { MessageBox.Show("삭제에 실패하였습니다."); } }
private void output_del() { ComInfo comInfo = new ComInfo(); DialogResult msgOk = comInfo.deleteConfrim("이슈", txt_이슈일자.Text.ToString() + " - " + txt_out_cd.Text.ToString()); if (msgOk == DialogResult.No) { return; } if (txt_jang_cd == null || txt_jang_cd.Text == null) { txt_jang_cd.Text = ""; } wnDm wDm = new wnDm(); int rsNum = wDm.delete이슈(txt_이슈일자.Text.ToString(), txt_out_cd.Text.ToString()); if (rsNum == 0) { resetSetting(); output_list(dgv등록이슈, "where convert(varchar(10), A.INTIME, 120) = convert(varchar(10), getDate(), 120) "); output_list(outputGrid, "where A.OUTPUT_DATE >= '" + txt_start_date.Text.ToString() + "' and A.OUTPUT_DATE <= '" + txt_end_date.Text.ToString() + "'"); MessageBox.Show("성공적으로 삭제하였습니다."); //int rsNum2 = wDm.updateStRaw(inputRmGrid); //if (rsNum2 == 0) //{ // resetSetting(); // input_list(tdInputGrid, "where convert(varchar(10), A.INTIME, 120) = convert(varchar(10), getDate(), 120) "); // input_list(inputGrid, "where A.INPUT_DATE >= '" + start_date.Text.ToString() + "' and A.INPUT_DATE <= '" + end_date.Text.ToString() + "'"); //} //else if (rsNum == 1) //{ // MessageBox.Show("저장에 실패하였습니다"); //} //else //{ // MessageBox.Show("Exception 에러"); //} } else if (rsNum == 1) { MessageBox.Show("삭제에 실패하였습니다."); } }
private void btnDelete_Click(object sender, EventArgs e) { ComInfo comInfo = new ComInfo(); DialogResult msgOk = comInfo.deleteConfrim("공정등록", txt_lot_no.Text.ToString()); if (msgOk == DialogResult.No) { return; } wnDm wDm = new wnDm(); int rsNum = wDm.deleteWorkFlow(txt_lot_no.Text.ToString()); if (rsNum == 0) { flow_cnt = 0; //해당 공정 카운트 리셋 btnFlow.Enabled = false; btnDelete.Enabled = false; txt_lot_no.Text = ""; txt_item_nm.Text = ""; txt_item_cd.Text = ""; txt_spec.Text = ""; txt_work_date.Text = ""; txt_inst_amt.Text = "0"; txt_char_amt.Text = "0"; txt_pack_amt.Text = "0"; for (int i = 0; i < flow_cnt; i++) { lbl_flow_cd[i].Text = ""; lbl_flow_nm[i].Text = ""; lbl_flow_pr_type[i].Text = ""; lbl_flow_seq[i].Text = ""; } //btn[flow_cnt - 1].Visible = false; for (int i = 0; i < max_flow_cnt; i++) { dgv[i].Rows.Clear(); //GridView 초기화 } gridList(); MessageBox.Show("성공적으로 삭제하였습니다."); } }
private void raw_del() { ComInfo comInfo = new ComInfo(); DialogResult msgOk = comInfo.deleteConfrim("원자재", txt_raw_mat_nm.Text.ToString()); if (msgOk == DialogResult.No) { return; } wnDm wDm = new wnDm(); int rsNum = wDm.deleteRaw(txt_raw_mat_cd.Text.ToString()); if (rsNum == 0) { resetSetting(); raw_list(); MessageBox.Show("성공적으로 삭제하였습니다."); } else if (rsNum == 1) { MessageBox.Show("삭제에 실패하였습니다."); } }