private string transProcessNo(string _kind, string _no) { string sql = @"select min(s.proc_no) from tb_gi_process s where s.proc_std = '" + _kind + "' and proc_no > " + _no; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; object maxVal = m.dbRonlyOne(sql, ref msg); if (msg != "OK" || maxVal == null || string.IsNullOrEmpty(maxVal.ToString())) { return(getProcessNo(_kind)); } sql = @"select max(s.proc_no) from tb_gi_process s where s.proc_std = '" + _kind + "' and proc_no < " + _no; m = new MariaCRUD(); object minVal = m.dbRonlyOne(sql, ref msg); if (msg != "OK" || minVal == null || string.IsNullOrEmpty(minVal.ToString())) { minVal = 0; } int q = Int32.Parse(minVal.ToString()) + (Int32.Parse(maxVal.ToString()) - Int32.Parse(minVal.ToString())) / 2; return(q.ToString()); }
private string getCode() { string sql = @"select UF_ClaimNoGenerator()"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; return m.dbRonlyOne(sql, ref msg).ToString(); }
private string getUserID() { string sql = @"select UF_UserIDGenerator()"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; return(m.dbRonlyOne(sql, ref msg).ToString()); }
private string getCommonCode(string _kind) { string sql = @"select UF_CommonCodeGenerator('" + _kind + "')"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; return(m.dbRonlyOne(sql, ref msg).ToString()); }
private string getProdCode(string _gubun) { string sql = @"select UF_ProdCodeGenerator('" + _gubun + "')"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; return(m.dbRonlyOne(sql, ref msg).ToString()); }
private string getDeliNo() { string sql = @"select UF_DeliveryNoGenerator('" + G.Pos + "')"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; return(m.dbRonlyOne(sql, ref msg).ToString()); }
private string getROrderSeq(string sNo) { string sql = @"select UF_ROrderSeqGenerator('" + sNo + "')"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; return(m.dbRonlyOne(sql, ref msg).ToString()); }
private void FormLogin_Load(object sender, EventArgs e) { //if (!IsRunningAsAdministrator()) //{ // ProcessStartInfo processStartInfo = new ProcessStartInfo(Assembly.GetEntryAssembly().CodeBase); // { // var withBlock = processStartInfo; // withBlock.UseShellExecute = true; // withBlock.Verb = "runas"; // Process.Start(processStartInfo); // Application.Exit(); // } //} // timer1.Start(); lblMsg.Text = ""; string sql = @"select com_name from tb_sys_pos where pos = 'A'"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; string com = m.dbRonlyOne(sql, ref msg).ToString(); if (msg == "OK") { lblCompany.Text = com; } else { lblCompany.Text = ""; } sql = @"select user_id, concat(user_name, if(authority='B',' (관리자)','')) as user_name from tb_sys_user where user_flag = 1 order by authority, user_id"; DataTable table = m.dbDataTable(sql, ref msg); if (msg == "OK") { cbID.DataSource = table; cbID.ValueMember = "user_id"; cbID.DisplayMember = "user_name"; } string ID = string.Empty; if (ReadRegistry(ref ID)) { cbID.SelectedValue = ID; } }
private bool isExist(string _pos, string _ho, string _name, string _group) { string sql = @"select machine_id from tb_machinecard where pos = '" + _pos + "' and machine_no = '" + _ho + "' and machine_name = '" + _name + "' and model_no = '" + _group + "'"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; object id = m.dbRonlyOne(sql, ref msg); if (msg == "OK" && id != null) { return(true); } else { return(false); } }
private bool isCommonItem(string _kind, string _item) { string sql = @"select co_code from tb_gi_common where co_kind = '" + _kind + "' and co_item = '" + _item + "'"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; object id = m.dbRonlyOne(sql, ref msg); if (msg == "OK" && id != null) { return(true); } else { return(false); } }
private bool isUserID(string ID) { string sql = @"select user_id from tb_sys_user where user_id = '" + ID + "'"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; object id = m.dbRonlyOne(sql, ref msg); if (msg == "OK" && id != null) { return(true); } else { return(false); } }
private void pbLogo_Click(object sender, EventArgs e) { string sql = "select homepage from tb_sys_pos where pos = '" + G.Pos + "'"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; string url = m.dbRonlyOne(sql, ref msg).ToString(); if (msg == "OK" && !string.IsNullOrEmpty(url)) { if (!url.Contains("http")) { url = "http://" + url; } System.Diagnostics.Process.Start(url); } }
private bool isProdName(string _gubun, string _prodName) { string sql = @"select prod_id from tb_gi_product where gubun = '" + _gubun + "' and prod_name = '" + _prodName + "'"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; object id = m.dbRonlyOne(sql, ref msg); if (msg == "OK" && id != null) { return(true); } else { return(false); } }
private bool isCustName(string _custName) { string sql = @"select cust_id from tb_gi_customer where fullname = '" + _custName + "' or abbname = '" + _custName + "'"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; object id = m.dbRonlyOne(sql, ref msg); if (msg == "OK" && id != null) { return(true); } else { return(false); } }
private bool isPdCloseExist(string _pos, string _date, string _depot, string _prod) { string sql = @"select prod_id from tb_gi_pdclose where pos = '" + _pos + "' and close_date = '" + _date + "' and depot = '" + _depot + "' and prod_id = '" + _prod + "'"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; object id = m.dbRonlyOne(sql, ref msg); if (msg == "OK" && id != null) { return(true); } else { return(false); } }
private bool isExist(string _kind, string _no) { string sql = @"select proc_no from tb_gi_process where proc_std = '" + _kind + "' and proc_no = " + _no; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; object id = m.dbRonlyOne(sql, ref msg); if (msg == "OK" && id != null) { return(true); } else { return(false); } }
private void pbPrint_Click(object sender, EventArgs e) { lblMsg.Text = ""; string sNo = tbNo.Text; if (string.IsNullOrEmpty(sNo)) { lblMsg.Text = "저장된 출하건만 명세서 출력이 가능합니다."; return; } sP_Delivery_PrintTableAdapter.Fill(dataSetP1B.SP_Delivery_Print, sNo); string sql = @"select sum(amount+vat) from tb_delivery_sub where deli_id = '" + sNo + "'"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; long lTotAmount = long.Parse(m.dbRonlyOne(sql, ref msg).ToString()); // string reportFileName = "SmartMES_SinMyung.Reports.P1B05_DELIVERY.rdlc"; string reportParm1 = "합계금액 : "; reportParm1 = reportParm1 + new MyClass().Number2Hangle(lTotAmount) + " 원정"; ViewReport_V viewReport = new ViewReport_V(); viewReport.reportViewer1.ProcessingMode = ProcessingMode.Local; viewReport.reportViewer1.LocalReport.ReportEmbeddedResource = reportFileName; ReportParameter rp1 = new ReportParameter("ReportParameter1", reportParm1); viewReport.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp1 }); ReportDataSource rds = new ReportDataSource("DataSet1", sPDeliveryPrintBindingSource); viewReport.reportViewer1.LocalReport.DataSources.Add(rds); viewReport.reportViewer1.LocalReport.Refresh(); viewReport.ShowDialog(); }
private void btnOk_Click(object sender, EventArgs e) { lblMsg.Text = ""; string sql = @"select count(*) from tb_prod_result " + "where job_no = '" + tbJobNo.Text + "' and jobtime_finish is not null"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; string com = m.dbRonlyOne(sql, ref msg).ToString(); if (msg == "OK" && Int32.Parse(com) > 0) { Save("1"); } else { lblMsg.Text = "생산 진행중인 LotNo.로 생산종료할 수 없습니다."; return; } }
private string getSeq(string _mid) { string sql = @"select seq from tb_machine_repair where machine_id = " + _mid + " order by seq desc limit 1"; MariaCRUD m = new MariaCRUD(); try { string msg = string.Empty; string seq = m.dbRonlyOne(sql, ref msg).ToString(); seq = (Int32.Parse(seq) + 1).ToString(); return(seq); } catch (NullReferenceException) { return("1"); } }
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; } if (sQty.Substring(0, 1) == "-") { DialogResult dr = MessageBox.Show("0보다 적은 수량을 입력했습니다.\r\r조정수량을 저장하시겠습니까?", this.lblTitle.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.No) { 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(); if (lblTitle.Text.Substring(lblTitle.Text.Length - 4, 4) == "[추가]") { 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; } lblMsg.Text = "저장되었습니다."; sql = @"select move_id from tb_stock_move order by move_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.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; tbContents.Text = string.Empty; lblMsg.Focus(); } else { sql = "update tb_stock_move " + "set move_date = '" + sDate + "', depot = '" + sDepot + "', prod_id = '" + sProd + "', move_kind = '" + sKind + "', move_qty = " + sQty + ", contents = '" + sContents + "'" + " where move_id = " + moveID; m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, moveID + " " + sDate + " " + sProd); parentWin.ListSearch(); parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[1, rowIndex]; parentWin.dataGridView1.Rows[rowIndex].Selected = true; this.DialogResult = DialogResult.OK; } }
private void btnBatch_Click(object sender, EventArgs e) { lblMsg.Text = ""; if (dataGridView1.RowCount < 1) { return; } int iCnt = 0; int iNoCnt = 0; string sSujuNo = string.Empty; for (int i = 0; i < dataGridView1.RowCount; i++) { if (dataGridView1.Rows[i].Cells[4].Value != null && dataGridView1.Rows[i].Cells[4].Value.ToString() == "1") { iCnt++; if (iCnt == 1) { sSujuNo = dataGridView1.Rows[i].Cells[0].Value.ToString(); } else if (sSujuNo != dataGridView1.Rows[i].Cells[0].Value.ToString()) { iNoCnt++; } } } if (iCnt < 1) { MessageBox.Show("작업지시대상이 선택되지 않았습니다."); return; } if (iNoCnt > 0) { MessageBox.Show("동일 수주건만 선택 가능합니다."); return; } // string sql; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; string sProc = cbProcStd.SelectedValue.ToString(); string sDate = dtpDate.Value.ToString("yyyy-MM-dd"); string sProd = string.Empty; string sName = string.Empty; string sSize = string.Empty; string sSujuSeq = string.Empty; string sPart = cbPart.Text.Substring(0, 1); string sQty = string.Empty; string sSujuQty = sQty; string sqlQty; MariaCRUD mQty; string msgQty = string.Empty; string com; for (int i = 0; i < dataGridView1.RowCount; i++) { if (dataGridView1.Rows[i].Cells[4].Value != null && dataGridView1.Rows[i].Cells[4].Value.ToString() == "1") { sSujuNo = dataGridView1.Rows[i].Cells[0].Value.ToString(); sProd = dataGridView1.Rows[i].Cells[6].Value.ToString(); sName = dataGridView1.Rows[i].Cells[8].Value.ToString(); sSize = dataGridView1.Rows[i].Cells[9].Value.ToString(); sSujuSeq = dataGridView1.Rows[i].Cells[5].Value.ToString(); sQty = dataGridView1.Rows[i].Cells[10].Value.ToString(); // sqlQty = "select qty from vw_rorder where rorder_id = '" + sSujuNo + "' and rorder_seq = " + sSujuSeq; mQty = new MariaCRUD(); com = mQty.dbRonlyOne(sqlQty, ref msgQty).ToString(); if (msgQty == "OK") { sSujuQty = com; } // sql = "insert into tb_prod_order (job_no, proc_no, pos, lot_date, prod_id, add_name, add_size, rorder_id, rorder_seq, proc_std, rorder_date, job_part, order_qty, enter_man) " + "select '" + getCode() + "',p.proc_no,'" + G.Pos + "','" + sDate + "','" + sProd + "','" + sName + "','" + sSize + "','" + sSujuNo + "'," + sSujuSeq + ",'" + sProc + "','" + sDate + "','" + sPart + "'," + sSujuQty + " - ifnull((select sum(v.gd_qty) from vw_production v where v.rorder_id = '" + sSujuNo + "' and v.rorder_seq = " + sSujuSeq + " and v.proc_no = p.proc_no),0),'" + G.UserID + "' " + "from tb_gi_process p where p.proc_std = '" + sProc + "' order by p.proc_no"; //m = new MariaCRUD(); m.dbCUD(sql, ref msg); if (msg != "OK") { lblMsg.Text = msg; return; } // } } parentWin.ListSearch(); this.Dispose(); }
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 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(); }
private void Save() { lblMsg.Text = ""; if (tbProd.Tag == null) { lblMsg.Text = "품목명을 선택해 주세요."; lblProd.Focus(); return; } string sQty = tbQty.Text.Replace(",", "").Trim(); if (string.IsNullOrEmpty(sQty)) { lblMsg.Text = "지시수량을 입력해 주세요."; tbQty.Focus(); return; } string sDate = dtpDate.Value.ToString("yyyy-MM-dd"); string sPart = cbPart.Text.Substring(0, 1); string sProd = tbProd.Tag.ToString(); string sName = tbName.Text.Trim(); string sSize = tbSize.Text.Trim(); string sProc = cbProcStd.SelectedValue.ToString(); string sJobNo = getCode(); string sSujuQty = sQty; if (string.IsNullOrEmpty(rorderSeq)) { rorderSeq = "null"; } else { string sqlQty = "select qty from vw_rorder where rorder_id = '" + rorderID + "' and rorder_seq = " + rorderSeq; MariaCRUD mQty = new MariaCRUD(); string msgQty = string.Empty; string com = mQty.dbRonlyOne(sqlQty, ref msgQty).ToString(); if (msgQty == "OK") { sSujuQty = com; } } string sql = "insert into tb_prod_order (job_no, proc_no, pos, lot_date, prod_id, add_name, add_size, rorder_id, rorder_seq, proc_std, rorder_date, job_part, order_qty, enter_man) " + "select '" + sJobNo + "',p.proc_no,'" + G.Pos + "','" + sDate + "','" + sProd + "','" + sName + "','" + sSize + "','" + rorderID + "'," + rorderSeq + ",'" + sProc + "','" + sDate + "','" + sPart + "'," + sSujuQty + " - ifnull((select sum(v.gd_qty) from vw_production v where v.rorder_id = '" + rorderID + "' and v.rorder_seq = " + rorderSeq + " and v.proc_no = p.proc_no),0),'" + G.UserID + "' " + "from tb_gi_process p where p.proc_std = '" + sProc + "' order by p.proc_no"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; 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[1].Value.ToString() == sJobNo) { parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, i]; parentWin.dataGridView1.CurrentCell.Selected = true; parentWin.LotSearch(sJobNo); break; } } tbJobNo.Text = getCode(); tbProd.Tag = null; tbProd.Text = string.Empty; tbName.Text = string.Empty; tbSize.Text = string.Empty; tbQty.Text = string.Empty; }
private void btnStart_Click(object sender, EventArgs e) { string sql = @"select max(idle_seq) from tb_prod_idle where job_no = '" + jobNo + "' and proc_no = " + procNo + " and machine_id = " + facID; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; seq = m.dbRonlyOne(sql, ref msg).ToString(); if (msg != "OK" || string.IsNullOrEmpty(seq)) { seq = "1"; } else { seq = (Int32.Parse(seq) + 1).ToString(); } string sItem = lbIdleList.SelectedValue.ToString(); string sStart = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); sql = "insert into tb_prod_idle (job_no, proc_no, machine_id, idle_seq, idle_item, idle_start, enter_man) " + "values('" + jobNo + "'," + procNo + "," + facID + "," + seq + ",'" + sItem + "','" + sStart + "','" + G.UserID + "')"; m.dbCUD(sql, ref msg); if (msg != "OK") { this.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 lblMsg = 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); lblMsg.Text = "비가동시작되었습니다."; this.DialogResult = DialogResult.OK; }