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("삭제에 실패하였습니다.");
}
}
