private void pbDel_Click(object sender, EventArgs e) { if (G.Authority == "D") { return; } if (!cbNo.Checked) { lblMsg.Text = "삭제할 전표번호를 체크해 주세요."; return; } string sNo = tbNo.Text; if (string.IsNullOrEmpty(sNo)) { lblMsg.Text = "저장된 전표번호만 삭제할 수 있습니다."; return; } DialogResult dr = MessageBox.Show("전표번호 : " + sNo + "\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.No) { return; } MariaCRUD m = new MariaCRUD(); string sql = "delete from tb_delivery_main where deli_id = '" + sNo + "'"; string msg = string.Empty; m.dbCUD(sql, ref msg); if (msg != "OK") { MessageBox.Show("전표번호 : '" + sNo + "'\r\r이미 타 업무에서 사용중인 전표번호이므로,\r삭제할 수 없습니다."); return; } string sROrderNo = tbROderNo.Text; if (!string.IsNullOrEmpty(sROrderNo)) { sql = "update tb_rorder_sub set deli_flag = 0 where rorder_id = '" + sROrderNo + "'"; m.dbCUD(sql, ref msg); } m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, sNo + " " + tbProject.Text); ListSearch1(); ListInit(); }
private void FacilityImageSave(string _fid) { MariaCRUD m = new MariaCRUD(); string sql = string.Empty; string msg = string.Empty; if (!string.IsNullOrEmpty(txtPath.Text) && pbFacilityImage.Image != null) { UInt32 FileSize; byte[] rawData; FileStream fs; MySqlConnection con = new MySqlConnection(G.conStr); MySqlCommand cmd = new MySqlCommand(); try { fs = new FileStream(@txtPath.Text, FileMode.Open, FileAccess.Read); FileSize = (UInt32)fs.Length; rawData = new byte[FileSize]; fs.Read(rawData, 0, (int)FileSize); fs.Close(); con.Open(); sql = "UPDATE tb_machinecard SET machine_image = @File, image_size = @FileSize WHERE machine_id = " + _fid; cmd.Connection = con; cmd.CommandText = sql; cmd.Parameters.AddWithValue("@File", rawData); cmd.Parameters.AddWithValue("@FileSize", FileSize); cmd.ExecuteNonQuery(); } catch (MySqlException ex) { MessageBox.Show("Error " + ex.Number + " has occurred: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } finally { con.Close(); } } else if (string.IsNullOrEmpty(txtPath.Text) && pbFacilityImage.Image == null) { sql = "UPDATE tb_machinecard SET machine_image = NULL, image_size = 0 WHERE machine_id = " + _fid; m.dbCUD(sql, ref msg); if (msg != "OK") { MessageBox.Show(msg); return; } } }
private void Save(string flag) { lblMsg.Text = ""; string sQty = tbQty.Text.Replace(",", "").Trim(); if (string.IsNullOrEmpty(sQty)) { lblMsg.Text = "수량을 입력해 주세요."; tbQty.Focus(); return; } string sDate = dtpDate.Value.ToString("yyyy-MM-dd"); string sDepot = cbDepot.SelectedValue.ToString(); string sql = "update tb_prod_order " + "set rorder_date = '" + sDate + "', order_qty = " + sQty + ", prod_flag = " + flag + " where job_no = '" + jobNo + "' and proc_no = " + procNo; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } if (flag == "1") { sql = "insert into tb_prod_done (job_no, pos, done_date, prod_id, add_name, add_size, rorder_id, rorder_seq, proc_std, done_qty, contents, depot, enter_man) " + "select p.job_no, '" + G.Pos + "','" + sDate + "', p.prod_id, p.add_name, p.add_size, p.rorder_id, p.rorder_seq, p.proc_std, " + sQty + ", p.ment, '" + sDepot + "','" + G.UserID + "' " + "from tb_prod_order p where p.job_no = '" + jobNo + "' and p.proc_no = " + procNo; } else { sql = "delete from tb_prod_done where job_no = '" + jobNo + "'"; } m = new MariaCRUD(); m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } parentWin.ListSearch(); parentWin.dataGridViewY.CurrentCell = parentWin.dataGridViewY[0, rowIndex]; parentWin.dataGridViewY.CurrentCell.Selected = true; this.DialogResult = DialogResult.OK; }
private void pbDel_Click(object sender, EventArgs e) { int index = 0; string sNo = string.Empty; string sSeq = string.Empty; string sName = string.Empty; string sGroup = string.Empty; string sDate = string.Empty; string sKind = string.Empty; try { index = dataGridView1.CurrentRow.Index; sNo = dataGridView1.Rows[index].Cells[0].Value.ToString(); sSeq = dataGridView1.Rows[index].Cells[4].Value.ToString(); sName = dataGridView1.Rows[index].Cells[2].Value.ToString(); sGroup = dataGridView1.Rows[index].Cells[3].Value.ToString(); sDate = dataGridView1.Rows[index].Cells[5].Value.ToString(); sKind = dataGridView1.Rows[index].Cells[6].Value.ToString(); if (dataGridView1.Rows[index].Selected != true) { MessageBox.Show("삭제 정보가 선택되지 않았습니다.", this.lblTitle.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } catch (NullReferenceException) { MessageBox.Show("삭제 정보가 선택되지 않았습니다.", this.lblTitle.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } DialogResult dr = MessageBox.Show(sName + "(" + sGroup + ")\r" + sDate + " " + sKind + "\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.No) { return; } MariaCRUD m = new MariaCRUD(); string sql = "delete from tb_machine_repair where machine_id = '" + sNo + "' and seq = " + sSeq; string msg = string.Empty; m.dbCUD(sql, ref msg); if (msg != "OK") { MessageBox.Show(msg); return; } m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, sName + "(" + sGroup + ") " + sDate + " " + sKind); ListSearch(); }
private void pbSave_Click(object sender, EventArgs e) { lblMsg.Text = ""; string sName = tbName.Text.Trim(); string sCeo = tbCeo.Text.Trim(); string sHomePage = tbHomePage.Text.Trim(); string sBusiNo = tbBusiNo.Text.Trim(); string sBubinNo = tbBubinNo.Text.Trim(); string sUpTae = tbUpTae.Text.Trim(); string sJongMong = tbJongMong.Text.Trim(); string sPostNo = tbPostNo.Text.Trim(); string sAddr1 = tbAddr1.Text.Trim(); string sAddr2 = tbAddr2.Text.Trim(); string sTel = tbTel.Text.Trim(); string sFax = tbFax.Text.Trim(); string sStartTime = mtbJobStartTime.Text.Trim(); if (string.IsNullOrEmpty(sName)) { lblMsg.Text = "회사공식명을 입력해 주세요."; tbName.Focus(); return; } if (sStartTime == ":") { sStartTime = "00:00"; } if (sStartTime.Length != 5) { lblMsg.Text = "작업시작시간을 확인해 주세요."; mtbJobStartTime.Focus(); return; } sStartTime = sStartTime + ":00"; string sql = "update tb_sys_pos " + "set pos_name = '" + sName + "', ceo = '" + sCeo + "', homepage = '" + sHomePage + "', busi_no = '" + sBusiNo + "', bubin_no = '" + sBubinNo + "', uptae = '" + sUpTae + "', jongmog = '" + sJongMong + "', post_no = '" + sPostNo + "', address1 = '" + sAddr1 + "', address2 = '" + sAddr2 + "', tel = '" + sTel + "', fax = '" + sFax + "', job_starttime = TIME_TO_SEC('" + sStartTime + "'), enter_dt = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "', enter_man = '" + G.UserID + "' " + "where pos = 'A'"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } lblMsg.Text = "저장되었습니다."; }
private void Save() { lblMsg.Text = ""; if (tbProd.Tag == null) { lblMsg.Text = "품목명을 선택해 주세요."; lblProd.Focus(); return; } string sProd = tbProd.Tag.ToString(); string sQty = tbQty.Text.Replace(",", "").Trim(); if (String.IsNullOrEmpty(sQty)) { lblMsg.Text = "조정수량을 입력해 주세요."; tbQty.Focus(); return; } string sDate = dtpDate.Value.ToString("yyyy-MM-dd"); string sDepot = cbDepot.SelectedValue.ToString(); string sKind = cbKind.SelectedValue.ToString(); string sContents = tbContents.Text.Trim(); string sql = string.Empty; string msg = string.Empty; MariaCRUD m = new MariaCRUD(); sql = "insert into tb_stock_move (pos, move_date, depot, prod_id, move_kind, move_qty, contents, enter_man) " + "values('" + G.Pos + "','" + sDate + "','" + sDepot + "','" + sProd + "','" + sKind + "'," + sQty + ",'" + sContents + "','" + G.UserID + "')"; m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } parentWin.ListSearch(); for (int i = 0; i < parentWin.dataGridView1.Rows.Count; i++) { if (parentWin.dataGridView1.Rows[i].Cells[2].Value.ToString() == sProd) { parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, i]; parentWin.dataGridView1.CurrentCell.Selected = true; break; } } this.DialogResult = DialogResult.OK; }
private void pbSave_Click(object sender, EventArgs e) { lblMsg.Text = "잠시 기다려 주세요."; int rowCnt = dataGridView2.RowCount; string id = lblID.Text; if (rowCnt < 1) { return; } if (string.IsNullOrEmpty(id)) { return; } MariaCRUD m = new MariaCRUD(); string sql = "delete from tb_sys_authority where user_id = '" + id + "'"; string msg = string.Empty; m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } string menuID; for (int i = 0; i < rowCnt; i++) { if (dataGridView2.Rows[i].Cells[0].Value.ToString() == "O") { menuID = dataGridView2.Rows[i].Cells[1].Value.ToString(); sql = "insert into tb_sys_authority values ('" + id + "','KO','" + menuID + "')"; m.dbCUD(sql, ref msg); } } lblMsg.Text = "저장되었습니다."; }
private void pbDel_Click(object sender, EventArgs e) { if (G.Authority == "D") { return; } if (!cbNo.Checked) { lblMsg.Text = "삭제할 수주번호를 체크해 주세요."; return; } string sNo = tbNo.Text; if (string.IsNullOrEmpty(sNo)) { lblMsg.Text = "저장된 수주번호만 삭제할 수 있습니다."; return; } DialogResult dr = MessageBox.Show("수주번호 : " + sNo + "\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.No) { return; } MariaCRUD m = new MariaCRUD(); string sql = "delete from tb_rorder_main where rorder_id = '" + sNo + "'"; string msg = string.Empty; m.dbCUD(sql, ref msg); if (msg != "OK") { MessageBox.Show(msg); return; } //string sEstimateNo = tbEstimateNo.Text; //if (!string.IsNullOrEmpty(sEstimateNo)) //{ // sql = "update tb_estimate_main set rorder_flag = 0 where estimate_id = '" + sEstimateNo + "'"; // m.dbCUD(sql, ref msg); // sql = "update tb_estimate_sub set rorder_flag = 0 where estimate_id = '" + sEstimateNo + "'"; // m.dbCUD(sql, ref msg); //} m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, sNo + " " + tbCust.Text); ListSearch1(); ListInit(); }
private void pbDel_Click(object sender, EventArgs e) { lblMsg.Text = ""; int index = 0; string sID = string.Empty; string sName = string.Empty; string sModel = string.Empty; try { index = dataGridView1.CurrentRow.Index; sID = dataGridView1.Rows[index].Cells[0].Value.ToString(); sName = dataGridView1.Rows[index].Cells[2].Value.ToString(); sModel = dataGridView1.Rows[index].Cells[3].Value.ToString(); if (dataGridView1.Rows[index].Selected != true) { MessageBox.Show("삭제 정보가 선택되지 않았습니다.", this.lblTitle.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } catch (NullReferenceException) { MessageBox.Show("삭제 정보가 선택되지 않았습니다.", this.lblTitle.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } DialogResult dr = MessageBox.Show(sName + "\r" + sModel + "\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.No) { return; } MariaCRUD m = new MariaCRUD(); string sql = "delete from tb_machinecard where machine_id = " + sID; string msg = string.Empty; m.dbCUD(sql, ref msg); if (msg != "OK") { MessageBox.Show(msg); return; } m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, sName + " " + sModel); ListSearch(); MachineInit(); }
private void pbDel_Click(object sender, EventArgs e) { int index = 0; string sDate = string.Empty; string sDepot = string.Empty; string sProd = string.Empty; string sProdName = string.Empty; try { index = dataGridView1.CurrentRow.Index; sDate = udY.Value.ToString() + "-12-31"; sDepot = cbDepot.SelectedValue.ToString(); sProd = dataGridView1.Rows[index].Cells[1].Value.ToString(); sProdName = dataGridView1.Rows[index].Cells[3].Value.ToString(); if (dataGridView1.Rows[index].Selected != true) { MessageBox.Show("삭제 정보가 선택되지 않았습니다.", this.lblTitle.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } catch (NullReferenceException) { MessageBox.Show("삭제 정보가 선택되지 않았습니다.", this.lblTitle.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } DialogResult dr = MessageBox.Show(sProdName + "\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.No) { return; } MariaCRUD m = new MariaCRUD(); string sql = "delete from tb_gi_pdclose where pos = '" + G.Pos + "' and close_date = '" + sDate + "' and depot = '" + sDepot + "' and prod_id = '" + sProd + "'"; string msg = string.Empty; m.dbCUD(sql, ref msg); if (msg != "OK") { MessageBox.Show(msg); return; } m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, udY.Value.ToString() + " " + sProdName); ListSearch(); }
private void pbDel_Click(object sender, EventArgs e) { int index = 0; string sID = string.Empty; string sDate = string.Empty; string sCustName = string.Empty; try { index = dataGridView1.CurrentRow.Index; sID = dataGridView1.Rows[index].Cells[0].Value.ToString(); sDate = DateTime.Parse(dataGridView1.Rows[index].Cells[5].Value.ToString()).ToString("yyyy-MM-dd"); sCustName = dataGridView1.Rows[index].Cells[2].Value.ToString(); if (dataGridView1.Rows[index].Selected != true) { MessageBox.Show("삭제 정보가 선택되지 않았습니다.", this.lblTitle.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } catch (NullReferenceException) { MessageBox.Show("삭제 정보가 선택되지 않았습니다.", this.lblTitle.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } DialogResult dr = MessageBox.Show(sID + "\r" + sDate + "\r" + sCustName + "\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.No) { return; } MariaCRUD m = new MariaCRUD(); string sql = "delete from tb_qc_claim where claim_id = " + sID; string msg = string.Empty; m.dbCUD(sql, ref msg); if (msg != "OK") { MessageBox.Show(msg); return; } m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, sID + " " + sDate + " " + sCustName); ListSearch(); }
private void pbSave_Click(object sender, EventArgs e) { lblMsg.Text = ""; if (G.Authority == "D") { return; } if (dataGridView2.Rows.Count < 1) { lblMsg.Text = "구성품 리스트가 존재하지 않습니다."; return; } dataGridView2.CurrentCell = dataGridView2[0, 0]; string sql = string.Empty; string msg = string.Empty; MariaCRUD m = new MariaCRUD(); string sProdID = string.Empty; string sMaterialID = string.Empty; string sQty = string.Empty; int iCnt = 0; for (int i = 0; i < dataGridView2.RowCount; i++) { sProdID = dataGridView2.Rows[i].Cells[1].Value.ToString(); sMaterialID = dataGridView2.Rows[i].Cells[2].Value.ToString(); sQty = dataGridView2.Rows[i].Cells[6].Value.ToString(); if (string.IsNullOrEmpty(sQty)) { sQty = "0"; } sql = "update tb_gi_bom set config_qty = " + sQty + " where prod_id = '" + sProdID + "' and material_id = '" + sMaterialID + "'"; m.dbCUD(sql, ref msg); iCnt++; } m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, sProdID + " " + iCnt.ToString() + "건"); lblMsg.Text = "저장되었습니다."; }
private void pbDel_Click(object sender, EventArgs e) { if (G.Authority == "D") { return; } if (dataGridView1.RowCount <= 0) { lblMsg.Text = "삭제할 검사 건이 선택되지 않았습니다."; return; } if (dataGridView1[8, 0].Value == null || string.IsNullOrEmpty(dataGridView1[8, 0].Value.ToString())) { lblMsg.Text = "저장되지 않은 검사 건입니다."; return; } string sNo = dataGridView1[8, 0].Value.ToString(); string sCust = dataGridViewList.Rows[dataGridViewList.CurrentRow.Index].Cells[3].Value.ToString(); DialogResult dr = MessageBox.Show("거래처명 : " + sCust + "\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.No) { return; } MariaCRUD m = new MariaCRUD(); string sql = "delete from tb_qc_final where rorder_id = '" + sNo + "'"; string msg = string.Empty; m.dbCUD(sql, ref msg); if (msg != "OK") { MessageBox.Show(msg); return; } dataGridViewList[7, dataGridViewList.CurrentRow.Index].Value = 0; m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, sNo + " " + sCust); ListInit(); lblMsg.Text = "삭제되었습니다."; }
private void lblDel_Click(object sender, EventArgs e) { try { string sNo = tbNo.Text; DialogResult dr = MessageBox.Show("입고번호 : " + sNo + "\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.No) { return; } MariaCRUD m = new MariaCRUD(); string sql = "update tb_purchase_mat " + "set putch_flag = 0, in_date = null, in_qty = 0, amount = 0, vat = 0, depot = null, contents = null, enter_dt2 = null, enter_man2 = null" + " where purch_id = '" + sNo + "'"; string msg = string.Empty; m.dbCUD(sql, ref msg); if (msg != "OK") { MessageBox.Show(msg); return; } m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, sNo + " 입고정보"); parentWin.ListSearch(); for (int i = 0; i < parentWin.dataGridView1.Rows.Count - 1; i++) { if (parentWin.dataGridView1.Rows[i].Cells[0].Value.ToString() == sNo) { parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[1, i]; parentWin.dataGridView1.CurrentCell.Selected = true; break; } } this.DialogResult = DialogResult.OK; } catch (InvalidOperationException) { return; } }
private void Save() { lblMsg.Text = ""; if (string.IsNullOrEmpty(cbUser.Text)) { lblMsg.Text = "운전자가 선택되지 않았습니다."; cbUser.Focus(); return; } string sDate = dtpDate2.Value.ToString("yyyy-MM-dd"); string sUser = cbUser.SelectedValue.ToString(); string sQty = tbGdQty.Text.Replace(",", "").Trim(); if (string.IsNullOrEmpty(sQty)) { sQty = "0"; } string sDT1 = dtpDate1.Value.ToString("yyyy-MM-dd HH:mm:ss"); string sDT2 = dtpDate2.Value.ToString("yyyy-MM-dd HH:mm:ss"); string sql = "update tb_prod_result " + "set prod_date = '" + sDate + "', user_id = '" + sUser + "', gd_qty = " + sQty + ", jobtime_start = '" + sDT1 + "', jobtime_finish = '" + sDT2 + "'" + " where job_no = '" + tbJobNo.Text + "' and proc_no = " + lblProc.Tag.ToString() + " and machine_id = " + tbMachine.Tag.ToString(); string msg = string.Empty; MariaCRUD m = new MariaCRUD(); m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, tbJobNo.Text + " " + lblProc.Text + " " + tbMachine.Text); parentWin.ListSearch(); parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[2, rowIndex]; parentWin.dataGridView1.Rows[rowIndex].Selected = true; this.DialogResult = DialogResult.OK; }
private void btnDel_Click(object sender, EventArgs e) { DialogResult dr = MessageBox.Show("해당 첨부파일은 영구 삭제됩니다.\r\r삭제 작업을 진행 하시겠습니까?", "첨부파일[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.No) { return; } MariaCRUD m = new MariaCRUD(); string msg = string.Empty; MySqlConnection con = new MySqlConnection(G.conStr); try { con.Open(); string sql = "UPDATE tb_rorder_sub SET doc1 = NULL, doc1_size = 0, doc1_name = null WHERE rorder_id = '" + sNo + "' and rorder_seq = " + sSeq; m.dbCUD(sql, ref msg); if (msg != "OK") { MessageBox.Show(msg); return; } parentWin.dataGridView1.Rows[rowIdx].Cells[23].Value = Properties.Resources.clipB; parentWin.dataGridView1.Rows[rowIdx].Cells[22].Value = ""; this.Close(); } catch (MySqlException ex) { MessageBox.Show("Error " + ex.Number + " has occurred: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } finally { con.Close(); } }
private void btnSave_Click(object sender, EventArgs e) { if (lbNgList.SelectedValue == null || string.IsNullOrEmpty(lbNgList.SelectedValue.ToString())) { lblMsg.Text = "불량항목이 선택되지 않았습니다."; lbNgList.Focus(); return; } string sItem = lbNgList.SelectedValue.ToString(); string sQty = tbQty.Text.Replace(",", "").Trim(); if (string.IsNullOrEmpty(sQty)) { sQty = "0"; } if (sQty == "0") { lblMsg.Text = "불량수량을 확인해 주세요."; tbQty.Focus(); return; } MariaCRUD m = new MariaCRUD(); string msg = string.Empty; string sql = "update tb_prod_result set ng_qty = " + sQty + ", ng_item = '" + sItem + "' where job_no = '" + jobNo + "' and proc_no = " + procNo + " and machine_id = " + facID; m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } parentWin.tbNgQty.Tag = lbNgList.SelectedValue.ToString(); parentWin.tbNgQty.Text = tbQty.Text; parentWin.lblMsg.Text = "불량보고 되었습니다."; this.DialogResult = DialogResult.OK; }
private void Save() { lblMsg.Text = ""; string sProd = tbCode.Text; string sDanga = tbDanga.Text.Replace(",", "").Trim(); if (string.IsNullOrEmpty(sDanga)) { sDanga = "0"; } string msg = string.Empty; MariaCRUD m = new MariaCRUD(); string sql = "update tb_gi_product set stock_money = " + sDanga + " where prod_id = '" + sProd + "'"; m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } parentWin.ListSearch(); for (int i = 0; i < parentWin.dataGridView1.Rows.Count; i++) { if (parentWin.dataGridView1.Rows[i].Cells[2].Value.ToString() == sProd) { parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, i]; parentWin.dataGridView1.CurrentCell.Selected = true; break; } } this.DialogResult = DialogResult.OK; }
private void Save(string flag) { lblMsg.Text = ""; string sQty = tbQty.Text.Replace(",", "").Trim(); if (string.IsNullOrEmpty(sQty)) { lblMsg.Text = "수량을 입력해 주세요."; tbQty.Focus(); return; } string sDate = dtpDate.Value.ToString("yyyy-MM-dd"); string sMent = tbMent.Text.Trim(); string sql = "update tb_prod_order " + "set rorder_date = '" + sDate + "', order_qty = " + sQty + ", ment = '" + sMent + "', prod_flag = " + flag + " where job_no = '" + jobNo + "' and proc_no = " + procNo; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } parentWin.ListSearch(); parentWin.dataGridViewX.CurrentCell = parentWin.dataGridViewX[0, rowIndex]; parentWin.dataGridViewX.CurrentCell.Selected = true; this.DialogResult = DialogResult.OK; }
// private void dataGridView2_DragDrop(object sender, DragEventArgs e) { if (dragTag != 3) { return; } if (dataGridView1.CurrentCell == null || dataGridView1.CurrentCell.RowIndex < 0) { return; } if (e.Effect == DragDropEffects.Copy) { int index = dataGridView1.CurrentCell.RowIndex; string sPCode = dataGridView1.Rows[index].Cells[1].Value.ToString(); string sMCode = (string)e.Data.GetData(DataFormats.StringFormat); string sql = "insert into tb_gi_bom (prod_id, material_id, config_qty) " + "values('" + sPCode + "', '" + sMCode + "', 1)"; string msg = string.Empty; MariaCRUD m = new MariaCRUD(); m.dbCUD(sql, ref msg); if (msg != "OK") { MessageBox.Show(msg); return; } ListSearch2(sPCode); ListSearch3(sPCode); } }
private void Save() { lblMsg.Text = ""; if (string.IsNullOrEmpty(machineID)) { lblMsg.Text = "설비정보를 확인해 주세요."; lblSelect.Focus(); return; } string sDate = dtpDate.Value.ToString("yyyy-MM-dd"); string sKind = cbKind.Text.Substring(0, 1); string sGoal = tbGoal.Text.Trim(); string sResult = tbResult.Text.Trim(); string sMan = tbMan.Text.Trim(); string sMoeny = tbMoney.Text.Replace(",", "").Trim(); if (string.IsNullOrEmpty(sMoeny)) { sMoeny = "NULL"; } string sContents = tbContents.Text.Trim(); string sql = string.Empty; string msg = string.Empty; MariaCRUD m = new MariaCRUD(); if (lblTitle.Text.Substring(lblTitle.Text.Length - 4, 4) == "[추가]") { seq = getSeq(machineID); sql = "insert into tb_machine_repair (machine_id, seq, repair_date, repair_kind, repair_goal, repair_result, repair_man, repair_money, contents, enter_man) " + "values(" + machineID + "," + seq + ",'" + sDate + "'," + sKind + ",'" + sGoal + "','" + sResult + "','" + sMan + "'," + sMoeny + ",'" + sContents + "','" + G.UserID + "')"; m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } lblMsg.Text = "저장되었습니다."; parentWin.ListSearch(); for (int i = 0; i < parentWin.dataGridView1.Rows.Count - 1; i++) { if (parentWin.dataGridView1.Rows[i].Cells[0].Value.ToString() == machineID && DateTime.Parse(parentWin.dataGridView1.Rows[i].Cells[5].Value.ToString()).ToString("yyyy-MM-dd") == sDate && parentWin.dataGridView1.Rows[i].Cells[6].Value.ToString().Substring(0, 1) == sKind) { parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[1, i]; parentWin.dataGridView1.CurrentCell.Selected = true; break; } } machineID = string.Empty; seq = string.Empty; tbHo.Text = string.Empty; tbName.Text = string.Empty; tbModel.Text = string.Empty; tbModel.Tag = string.Empty; tbGoal.Text = string.Empty; tbResult.Text = string.Empty; tbMan.Text = string.Empty; tbMoney.Text = string.Empty; tbContents.Text = string.Empty; tbGoal.Focus(); } else { sql = "update tb_machine_repair " + "set repair_date = '" + sDate + "', repair_kind = '" + sKind + "', repair_goal = '" + sGoal + "', repair_result = '" + sResult + "', repair_man = '" + sMan + "', repair_money = " + sMoeny + ", contents = '" + sContents + "'" + " where machine_id = " + machineID + " and seq = " + seq; m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, machineID + "-" + seq + " " + tbName.Text + " " + tbModel.Text); parentWin.ListSearch(); parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[1, rowIndex]; parentWin.dataGridView1.Rows[rowIndex].Selected = true; this.DialogResult = DialogResult.OK; } }
private void Save() { lblMsg.Text = ""; string sProdName = tbProdName.Text.Trim(); if (String.IsNullOrEmpty(sProdName)) { lblMsg.Text = "품목명을 입력해 주세요."; tbProdName.Focus(); return; } string sGubun = cbGubun.Text.Substring(0, 1); string sKind = cbKind.SelectedValue.ToString(); string sSize = tbSize.Text.Trim(); string sUnit = tbUnit.Text.Trim(); string sUnitSub = tbUnitSub.Text.Trim(); string sStockFlag = "1"; if (ckbStockFlag.Checked) { sStockFlag = "0"; } string sUseFlag = "O"; if (ckbUseFlag.Checked) { sUseFlag = "X"; } string sql = string.Empty; string msg = string.Empty; MariaCRUD m = new MariaCRUD(); if (lblTitle.Text.Substring(lblTitle.Text.Length - 4, 4) == "[추가]") { //입력한 품목명이 중복인지 확인.. if (isProdName(sGubun, sProdName)) { lblMsg.Text = "이미 존재하는 품목명입니다."; tbProdName.Focus(); return; } prodCode = getProdCode(sGubun); sql = "insert into tb_gi_product (gubun, prod_id, prod_kind, prod_name, prod_size, unit, unit_sub, stock_flag, use_flag, enter_man) " + "values('" + sGubun + "','" + prodCode + "','" + sKind + "','" + sProdName + "','" + sSize + "','" + sUnit + "','" + sUnitSub + "'," + sStockFlag + ",'" + sUseFlag + "','" + G.UserID + "')"; m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } lblMsg.Text = "저장되었습니다."; parentWin.tbSearch.Text = ""; if (sGubun == "A") { parentWin.rbA.Checked = true; } else if (sGubun == "B") { parentWin.rbB.Checked = true; } else if (sGubun == "C") { parentWin.rbC.Checked = true; } else if (sGubun == "D") { parentWin.rbD.Checked = true; } else { parentWin.rbZ.Checked = true; } parentWin.ListSearch(); for (int i = 0; i < parentWin.dataGridView1.Rows.Count; i++) { if (parentWin.dataGridView1.Rows[i].Cells[1].Value.ToString() == prodCode) { parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, i]; parentWin.dataGridView1.CurrentCell.Selected = true; break; } } tbProdName.Text = string.Empty; tbSize.Text = string.Empty; tbProdName.Focus(); } else { sql = "update tb_gi_product " + "set prod_kind = '" + sKind + "', prod_name = '" + sProdName + "', prod_size = '" + sSize + "', unit = '" + sUnit + "', unit_sub = '" + sUnitSub + "', stock_flag = " + sStockFlag + ", use_flag = '" + sUseFlag + "'" + " where prod_id = '" + prodCode + "'"; m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, prodCode + " " + sProdName); parentWin.ListSearch(); parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, rowIndex]; parentWin.dataGridView1.Rows[rowIndex].Selected = true; this.DialogResult = DialogResult.OK; } }
private void Save() { lblMsg.Text = ""; if (tbProd.Tag == null) { lblMsg.Text = "자재명을 선택해 주세요."; lblProd.Focus(); return; } string sProd = tbProd.Tag.ToString(); string sQty = tbQty.Text.Replace(",", "").Trim(); if (String.IsNullOrEmpty(sQty)) { lblMsg.Text = "소모량을 입력해 주세요."; tbQty.Focus(); return; } string sDate = dtpDate.Value.ToString("yyyy-MM-dd"); string sDepot = cbDepot.SelectedValue.ToString(); string sql = string.Empty; string msg = string.Empty; MariaCRUD m = new MariaCRUD(); if (lblTitle.Text.Substring(lblTitle.Text.Length - 4, 4) == "[추가]") { sql = "insert into tb_material_use (pos, prod_date, prod_id, use_qty, depot, enter_man) " + "values('" + G.Pos + "','" + sDate + "','" + sProd + "'," + sQty + ",'" + sDepot + "','" + G.UserID + "')"; m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } lblMsg.Text = "저장되었습니다."; sql = @"select use_id from tb_material_use order by use_id desc limit 1"; m = new MariaCRUD(); string com = m.dbRonlyOne(sql, ref msg).ToString(); parentWin.ListSearch(); for (int i = 0; i < parentWin.dataGridView1.Rows.Count; i++) { if (parentWin.dataGridView1.Rows[i].Cells[0].Value != null && !string.IsNullOrEmpty(parentWin.dataGridView1.Rows[i].Cells[0].Value.ToString()) && parentWin.dataGridView1.Rows[i].Cells[0].Value.ToString() == com) { parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[1, i]; parentWin.dataGridView1.CurrentCell.Selected = true; break; } } tbProd.Tag = null; tbProd.Text = string.Empty; tbQty.Text = string.Empty; lblMsg.Focus(); } else { sql = "update tb_material_use " + "set prod_date = '" + sDate + "', prod_id = '" + sProd + "', use_qty = " + sQty + ", depot = '" + sDepot + "'" + " where use_id = " + useID; m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, useID + " " + sDate + " " + sProd); parentWin.ListSearch(); parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[1, rowIndex]; parentWin.dataGridView1.Rows[rowIndex].Selected = true; this.DialogResult = DialogResult.OK; } }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } if (dataGridView1.Rows.GetLastRow(DataGridViewElementStates.Visible) == e.RowIndex) { return; } if (e.ColumnIndex == 0) { P1Z02_USER_SUB sub = new P1Z02_USER_SUB(); sub.lblTitle.Text = sub.lblTitle.Text + "[수정]"; sub.parentWin = this; sub.ShowDialog(); } else if (e.ColumnIndex == 6) { int index = 0; string userID = string.Empty; string userName = string.Empty; try { index = dataGridView1.CurrentRow.Index; userID = dataGridView1.Rows[index].Cells[0].Value.ToString(); userName = dataGridView1.Rows[index].Cells[1].Value.ToString(); if (dataGridView1.Rows[index].Selected != true) { return; } } catch (NullReferenceException) { return; } if (string.IsNullOrEmpty(userID)) { return; } DialogResult dr = MessageBox.Show(userName + "\r\r선택된 사용자의 암호를 초기화(1234) 하시겠습니까?", this.lblTitle.Text + "[암호초기화]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.No) { return; } string InitPwd = new MyClass().EncryptSHA512("1234"); string sql = "update tb_sys_user set pwd = '" + InitPwd + "' where user_id = '" + userID + "'"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; m.dbCUD(sql, ref msg); if (msg != "OK") { MessageBox.Show(msg); } } else { return; } }
private void pbSave_Click(object sender, EventArgs e) { lblMsg.Text = ""; if (G.Authority == "D") { return; } if (dataGridView2.RowCount == 0) { return; } try { dataGridView2.CurrentCell = dataGridView2[1, 0]; } catch (InvalidOperationException) { return; } int iCnt1 = 0, iCnt2 = 0; DateTime result; for (int i = 0; i < dataGridView2.RowCount; i++) { if (dataGridView2.Rows[i].Cells[5].Value == null || string.IsNullOrEmpty(dataGridView2.Rows[i].Cells[5].Value.ToString()) || !DateTime.TryParse(dataGridView2.Rows[i].Cells[5].Value.ToString(), out result)) { iCnt1++; } if (dataGridView2.Rows[i].Cells[7].Value == null || string.IsNullOrEmpty(dataGridView2.Rows[i].Cells[7].Value.ToString())) { iCnt2++; } } if (iCnt1 > 0) { lblMsg.Text = "생산일자를 확인해 주세요."; return; } if (iCnt2 > 0) { lblMsg.Text = "지시수량을 확인해 주세요."; return; } // string sLogNo = dataGridView2.Rows[0].Cells[0].Value.ToString(); string sProcNo = string.Empty; string sDate = string.Empty; string sJobPart = string.Empty; string sOrderQty = string.Empty; string sMent = string.Empty; string sql = string.Empty; string msg = string.Empty; MariaCRUD m = new MariaCRUD(); for (int i = 0; i < dataGridView2.RowCount; i++) { sProcNo = dataGridView2.Rows[i].Cells[1].Value.ToString(); sDate = DateTime.Parse(dataGridView2.Rows[i].Cells[5].Value.ToString().Trim()).ToString("yyyy-MM-dd"); sJobPart = dataGridView2.Rows[i].Cells[6].Value.ToString().Substring(0, 1); sOrderQty = dataGridView2.Rows[i].Cells[7].Value.ToString().Trim(); sMent = dataGridView2.Rows[i].Cells[8].Value.ToString().Trim(); sql = "update tb_prod_order set rorder_date = '" + sDate + "', job_part = '" + sJobPart + "', order_qty = " + sOrderQty + ", ment = '" + sMent + "' where job_no = '" + sLogNo + "' and proc_no = " + sProcNo; m.dbCUD(sql, ref msg); } m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, sLogNo); lblMsg.Text = "저장되었습니다."; }
private void btnSave_Click(object sender, EventArgs e) { if (lbNgList.SelectedValue == null || string.IsNullOrEmpty(lbNgList.SelectedValue.ToString())) { lblMsg.Text = "불량항목이 선택되지 않았습니다."; lbNgList.Focus(); return; } string sItem = lbNgList.SelectedValue.ToString(); string sQty = tbQty.Text.Replace(",", "").Trim(); if (string.IsNullOrEmpty(sQty)) { sQty = "0"; } if (sQty == "0") { lblMsg.Text = "불량수량을 확인해 주세요."; tbQty.Focus(); return; } MariaCRUD m = new MariaCRUD(); string msg = string.Empty; string sql = "update tb_prod_result set ng_qty = " + sQty + ", ng_item = '" + sItem + "' where job_no = '" + jobNo + "' and proc_no = " + procNo + " and machine_id = " + facID; m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } DateTime dtDate = DateTime.Parse(parentWin.dtpDate.Value.ToString("yyyy-MM-dd")); string sPart = parentWin.cbPart.Text.Substring(0, 1); if (sGroup == "A") { parentWin.sP_ProdResult_QueryATableAdapter.Fill(parentWin.dataSetP1C.SP_ProdResult_QueryA, dtDate, sPart, sGroup); } else if (sGroup == "B") { parentWin.sP_ProdResult_QueryBTableAdapter.Fill(parentWin.dataSetP1C.SP_ProdResult_QueryB, dtDate, sPart, sGroup); } else if (sGroup == "C") { parentWin.sP_ProdResult_QueryCTableAdapter.Fill(parentWin.dataSetP1C.SP_ProdResult_QueryC, dtDate, sPart, sGroup); } else if (sGroup == "D") { parentWin.sP_ProdResult_QueryDTableAdapter.Fill(parentWin.dataSetP1C.SP_ProdResult_QueryD, dtDate, sPart, sGroup); } else if (sGroup == "E") { parentWin.sP_ProdResult_QueryETableAdapter.Fill(parentWin.dataSetP1C.SP_ProdResult_QueryE, dtDate, sPart, sGroup); } Label parentMsg = parentWin.Controls.Find("lblMsg" + sGroup, true).FirstOrDefault() as Label; DataGridView dataGridView = parentWin.Controls.Find("dataGridView" + sGroup, true).FirstOrDefault() as DataGridView; int rowIndex = 0; for (int i = 0; i < dataGridView.Rows.Count; i++) { if (dataGridView.Rows[i].Cells[0].Value.ToString() == jobNo && dataGridView.Rows[i].Cells[1].Value.ToString() == facID && dataGridView.Rows[i].Cells[20].Value.ToString() == procNo) { dataGridView.CurrentCell = dataGridView[3, i]; dataGridView.CurrentCell.Selected = true; rowIndex = i; break; } } parentWin.SettingValues(sGroup, rowIndex); parentMsg.Text = "불량보고 되었습니다."; this.DialogResult = DialogResult.OK; }
private void Save() { lblMsg.Text = ""; string sInQty = tbInQty.Text.Replace(",", "").Trim(); string sAmount = tbAmount.Text.Replace(",", "").Trim(); if (string.IsNullOrEmpty(sInQty)) { lblMsg.Text = "입고수량을 입력해 주세요."; tbInQty.Focus(); return; } if (string.IsNullOrEmpty(sAmount)) { lblMsg.Text = "매입액을 입력해 주세요."; tbAmount.Focus(); return; } string sNo = tbNo.Text; string sInDate = dtpInDate.Value.ToString("yyyy-MM-dd"); string sVat = tbVat.Text.Replace(",", "").Trim(); if (string.IsNullOrEmpty(sVat)) { sVat = "0"; } string sDepot = cbDepot.SelectedValue.ToString(); string sBigo = tbBigo.Text.Trim(); string msg = string.Empty; MariaCRUD m = new MariaCRUD(); string sql = "update tb_purchase_mat " + "set putch_flag = 1, in_date = '" + sInDate + "', in_qty = " + sInQty + ", amount = " + sAmount + ", vat = " + sVat + ", depot = '" + sDepot + "', contents = '" + sBigo + "', enter_dt2 = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "', enter_man2 = '" + G.UserID + "'" + " where purch_id = '" + sNo + "'"; m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } if (lblDel.Visible) { m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, sNo + " " + sInDate); } parentWin.ListSearch(); for (int i = 0; i < parentWin.dataGridView1.Rows.Count - 1; i++) { if (parentWin.dataGridView1.Rows[i].Cells[0].Value.ToString() == sNo) { parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[1, i]; parentWin.dataGridView1.CurrentCell.Selected = true; break; } } this.DialogResult = DialogResult.OK; }
private void pbSave_Click(object sender, EventArgs e) { lblMsg.Text = ""; string sHo = tbHo.Text.Trim(); string sName = tbName.Text.Trim(); if (String.IsNullOrEmpty(sHo)) { lblMsg.Text = "호기를 입력해 주세요."; tbHo.Focus(); return; } if (String.IsNullOrEmpty(sName)) { lblMsg.Text = "설비명을 입력해 주세요."; tbName.Focus(); return; } string sID = lblID.Text.Substring(6, lblID.Text.Length - 6); string sModel = cbGroup.SelectedValue.ToString(); string sMadeCom = tbMadeCom.Text.Trim(); string sMadeDate = tbMadeDate.Text.Trim(); string sBuyCom = tbBuyCom.Text.Trim(); string sBuyDate = tbBuyDate.Text.Trim(); string sMoney = tbMoney.Text.Replace(",", "").Trim(); if (string.IsNullOrEmpty(sMoney)) { sMoney = "NULL"; } string sLocation = tbLocation.Text.Trim(); string sCharge = cbCharge.Text.Trim(); string sAsCom = tbAsCom.Text.Trim(); string sSpec = tbSpec.Text.Trim(); string sIP = tbIP.Text.Trim(); string sql = string.Empty; string msg = string.Empty; MariaCRUD m = new MariaCRUD(); if (Int32.Parse(sID) == 0) //추가 { if (isExist(G.Pos, sHo, sName, sModel)) { lblMsg.Text = "이미 존재하는 설비정보입니다."; lblID.Focus(); return; } sql = "insert into tb_machinecard " + "(pos, model_no, machine_name, machine_no, made_com, made_date, buy_com, buy_date, buy_money, location, charge, as_com, machine_spec, ip, enter_man) " + "values('" + G.Pos + "','" + sModel + "','" + sName + "','" + sHo + "','" + sMadeCom + "','" + sMadeDate + "','" + sBuyCom + "','" + sBuyDate + "'," + sMoney + ",'" + sLocation + "','" + sCharge + "','" + sAsCom + "','" + sSpec + "','" + sIP + "','" + G.UserID + "')"; m.dbCUD(sql, ref msg); if (msg != "OK") { MessageBox.Show(msg); return; } ListSearch(); lblMsg.Text = "저장되었습니다."; for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { if (dataGridView1.Rows[i].Cells[1].Value.ToString() == sHo && dataGridView1.Rows[i].Cells[2].Value.ToString() == sName && dataGridView1.Rows[i].Cells[3].Value.ToString() == sModel) { dataGridView1.CurrentCell = dataGridView1[1, i]; dataGridView1.CurrentCell.Selected = true; sID = dataGridView1.Rows[i].Cells[0].Value.ToString(); lblID.Text = "관리No. " + sID; break; } } } else //수정 { sql = "update tb_machinecard " + "set model_no = '" + sModel + "', machine_name = '" + sName + "', machine_no = '" + sHo + "', made_com = '" + sMadeCom + "', made_date = '" + sMadeDate + "', buy_com = '" + sBuyCom + "', buy_date = '" + sBuyDate + "', buy_money = " + sMoney + ", location = '" + sLocation + "', charge = '" + sCharge + "', as_com = '" + sAsCom + "', machine_spec = '" + sSpec + "', ip = '" + sIP + "'" + " where machine_id = " + sID; m.dbCUD(sql, ref msg); if (msg != "OK") { MessageBox.Show(msg); return; } m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, sID + " " + sHo + " " + sName + " " + sModel); ListSearch(); lblMsg.Text = "저장되었습니다."; for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { if (dataGridView1.Rows[i].Cells[0].Value.ToString() == sID) { dataGridView1.CurrentCell = dataGridView1[1, i]; dataGridView1.CurrentCell.Selected = true; break; } } } FacilityImageSave(sID); txtPath.Text = ""; }
private void Save() { lblMsg.Text = ""; string sItem = tbItem.Text.Trim(); if (String.IsNullOrEmpty(sItem)) { lblMsg.Text = "항목명을 입력해 주세요."; tbKind.Focus(); return; } string sCode = tbCode.Text; string sContents = tbContents.Text.Trim(); string sql = string.Empty; string msg = string.Empty; MariaCRUD m = new MariaCRUD(); if (lblTitle.Text.Substring(lblTitle.Text.Length - 4, 4) == "[추가]") { //입력한 거래처명이 중복인지 확인.. if (isCommonItem(kind, sItem)) { lblMsg.Text = "이미 존재하는 항목명입니다."; tbItem.Focus(); return; } sql = "insert into tb_gi_common (co_kind, co_code, co_item, contents) " + "values('" + kind + "','" + sCode + "','" + sItem + "','" + sContents + "')"; m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } lblMsg.Text = "저장되었습니다."; parentWin.ListSearch(); for (int i = 0; i < parentWin.dataGridView1.Rows.Count; i++) { if (parentWin.dataGridView1.Rows[i].Cells[3].Value.ToString() == sCode) { parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, i]; parentWin.dataGridView1.CurrentCell.Selected = true; break; } } tbCode.Text = getCommonCode(kind); tbItem.Text = string.Empty; tbContents.Text = string.Empty; tbItem.Focus(); } else { sql = "update tb_gi_common " + "set co_item = '" + sItem + "', contents = '" + sContents + "'" + " where co_kind = '" + kind + "' and co_code = '" + sCode + "'"; m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, tbKind.Text + " " + sCode); parentWin.ListSearch(); parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, rowIndex]; parentWin.dataGridView1.Rows[rowIndex].Selected = true; this.DialogResult = DialogResult.OK; } }
private void pbDel_Click(object sender, EventArgs e) { lblMsg.Text = ""; if (G.Authority == "D") { return; } if (dataGridView1.RowCount == 0) { return; } int index = 0; string sLotNo = string.Empty; try { index = dataGridView1.CurrentRow.Index; sLotNo = dataGridView1.Rows[index].Cells[1].Value.ToString(); if (dataGridView1.Rows[index].Selected != true) { MessageBox.Show("삭제 정보가 선택되지 않았습니다.", this.lblTitle.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } catch (NullReferenceException) { MessageBox.Show("삭제 정보가 선택되지 않았습니다.", this.lblTitle.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } DialogResult dr = MessageBox.Show("LotNo. : " + sLotNo + "\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.No) { return; } string sql = @"select count(job_no) from tb_prod_result where job_no = '" + sLotNo + "'"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; string com = m.dbRonlyOne(sql, ref msg).ToString(); if (msg == "OK" && Int32.Parse(com) > 0) { MessageBox.Show("실적처리된 Lot번호는 삭제할 수 없습니다."); return; } sql = "delete from tb_prod_order where job_no = '" + sLotNo + "'"; m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, sLotNo); ListSearch(); }