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 string getCustCode() { string sql = @"select UF_CustCodeGenerator('A')"; 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 getProcessNo(string _kind) { string sql = @"select UF_ProcessNoGenerator('" + _kind + "')"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; return(m.dbRonlyOne(sql, ref msg).ToString()); }
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 = ""; 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 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(); }
protected void ufConnection() { lblMsg.Text = ""; string empPwd = tbPWD.Text.Trim(); if (String.IsNullOrEmpty(empPwd)) { lblMsg.Text = "패스워드를 입력하세요."; tbPWD.Focus(); return; } G.UserID = cbID.SelectedValue.ToString(); string sql = @"select po.pos, po.com_name, po.pos_name, us.user_name, us.pwd, us.authority " + "from tb_sys_user us inner join tb_sys_pos po on us.pos = po.pos " + "where us.user_id = '" + G.UserID + "'"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; DataTable table = m.dbDataTable(sql, ref msg); if (msg != "OK") { MessageBox.Show(msg); return; } DataRow[] row = table.Select(); string strPwd; if (row.Length > 0) { strPwd = row[0][4].ToString(); if (new MyClass().EncryptSHA512(empPwd) != strPwd) { lblMsg.Text = "패스워드가 정확하지 않습니다."; tbPWD.Focus(); return; } G.Pos = row[0][0].ToString(); G.ComName = row[0][1].ToString(); G.PosName = row[0][2].ToString(); G.UserName = row[0][3].ToString(); G.Authority = row[0][5].ToString(); WriteRegistry(G.UserID); m.TransLogCreate(G.Authority, G.UserID, "I", "FormLogin", "Login", "로그인"); this.DialogResult = DialogResult.OK; } }
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) { 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 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 sNo = string.Empty; string sCustName = string.Empty; string sProdName = string.Empty; string sAddName = string.Empty; try { index = dataGridView1.CurrentRow.Index; sNo = dataGridView1.Rows[index].Cells[0].Value.ToString(); sCustName = dataGridView1.Rows[index].Cells[3].Value.ToString(); sProdName = dataGridView1.Rows[index].Cells[5].Value.ToString(); sAddName = 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(sNo + "\r" + sCustName + "\r(" + sProdName + "-" + sAddName + ")\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.No) { return; } MariaCRUD m = new MariaCRUD(); string sql = "delete from tb_purchase_toll 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 + " " + sCustName + " (" + sProdName + "-" + sAddName + ")"); ListSearch(); }
private void P1A04_PROCESS_SUB_Load(object sender, EventArgs e) { lblMsg.Text = ""; string sql = @"select co_code, co_item from tb_gi_common where co_kind = 'D' order by co_code"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; DataTable table = m.dbDataTable(sql, ref msg); if (msg == "OK") { cbKind.DataSource = table; cbKind.ValueMember = "co_code"; cbKind.DisplayMember = "co_item"; } cbKind.SelectedIndex = parentWin.cbStd.SelectedIndex; if (lblTitle.Text.Substring(lblTitle.Text.Length - 4, 4) == "[추가]") { cbGroup.Text = "A.CNC"; this.ActiveControl = tbName; } else { rowIndex = parentWin.dataGridView1.CurrentCell.RowIndex; procStd = parentWin.dataGridView1.Rows[rowIndex].Cells[0].Value.ToString(); procNo = parentWin.dataGridView1.Rows[rowIndex].Cells[2].Value.ToString(); tbNo.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[2].Value.ToString(); tbName.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[3].Value.ToString(); tbTool.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[4].Value.ToString(); string sTime = parentWin.dataGridView1.Rows[rowIndex].Cells[5].Value.ToString(); if (!string.IsNullOrEmpty(sTime)) { tbTime.Text = float.Parse(parentWin.dataGridView1.Rows[rowIndex].Cells[5].Value.ToString()).ToString("0.0"); } cbGroup.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[6].Value.ToString(); string sFinal = parentWin.dataGridView1.Rows[rowIndex].Cells[7].Value.ToString(); if (sFinal == "O") { ckFinalFlag.Checked = true; } cbKind.Enabled = false; tbNo.Enabled = false; this.ActiveControl = tbName; } }
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 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 void P1ED03_QC_AS_SUB_Load(object sender, EventArgs e) { lblMsg.Text = ""; string sql = @"select user_id, user_name from tb_sys_user where authority in ('B','C') and user_flag = 1 order by user_name"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; DataTable table = m.dbDataTable(sql, ref msg); if (msg == "OK") { cbCharge.DataSource = table; cbCharge.ValueMember = "user_id"; cbCharge.DisplayMember = "user_name"; } if (lblTitle.Text.Substring(lblTitle.Text.Length - 4, 4) == "[추가]") { cbState.SelectedIndex = 1; //처리중 cbCharge.SelectedValue = G.UserID; this.ActiveControl = lblDeliID; } else { try { rowIndex = parentWin.dataGridView1.CurrentCell.RowIndex; tbNo.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[0].Value.ToString(); cbState.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[12].Value.ToString(); tbDeli.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[13].Value.ToString(); tbQty.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[4].Value.ToString(); dtpClaimDate.Value = DateTime.Parse(parentWin.dataGridView1.Rows[rowIndex].Cells[5].Value.ToString()); tbClaimContents.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[6].Value.ToString(); dtpActionDate.Value = DateTime.Parse(parentWin.dataGridView1.Rows[rowIndex].Cells[7].Value.ToString()); tbActionContents.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[8].Value.ToString(); tbMoney.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[9].Value.ToString(); cbCharge.SelectedValue = parentWin.dataGridView1.Rows[rowIndex].Cells[10].Value.ToString(); this.ActiveControl = btnSave; } catch (FormatException) { return; } } }
private void P1A05_STOCK_MOVE_SUB_Load(object sender, EventArgs e) { lblMsg.Text = ""; string sql = @"select co_code, co_item from tb_gi_common where co_kind = 'B' order by co_code"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; DataTable table = m.dbDataTable(sql, ref msg); if (msg == "OK") { cbDepot.DataSource = table; cbDepot.ValueMember = "co_code"; cbDepot.DisplayMember = "co_item"; } cbDepot.SelectedIndex = parentWin.cbDepot.SelectedIndex; sql = @"select co_code, co_item from tb_gi_common where co_kind = 'E' order by co_code"; m = new MariaCRUD(); table = m.dbDataTable(sql, ref msg); if (msg == "OK") { cbKind.DataSource = table; cbKind.ValueMember = "co_code"; cbKind.DisplayMember = "co_item"; } if (lblTitle.Text.Substring(lblTitle.Text.Length - 4, 4) == "[추가]") { this.ActiveControl = tbQty; } else { rowIndex = parentWin.dataGridView1.CurrentCell.RowIndex; moveID = parentWin.dataGridView1.Rows[rowIndex].Cells[0].Value.ToString(); dtpDate.Value = DateTime.Parse(parentWin.dataGridView1.Rows[rowIndex].Cells[1].Value.ToString()); tbProd.Tag = parentWin.dataGridView1.Rows[rowIndex].Cells[2].Value.ToString(); tbProd.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[5].Value.ToString(); cbKind.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[8].Value.ToString(); tbQty.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[9].Value.ToString(); tbContents.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[10].Value.ToString(); this.ActiveControl = btnSave; } }
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 P1A01_CUSTOMER_SUB_Load(object sender, EventArgs e) { lblMsg.Text = ""; string sql = @"select saleman from tb_gi_customer where use_flag = 'O' group by saleman order by saleman"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; DataTable table = m.dbDataTable(sql, ref msg); if (msg == "OK") { cbSaleMan.DataSource = table; cbSaleMan.ValueMember = "saleman"; cbSaleMan.DisplayMember = "saleman"; } if (lblTitle.Text.Substring(lblTitle.Text.Length - 4, 4) == "[추가]") { this.ActiveControl = tbCustName; cbGubun.SelectedIndex = 0; } else { rowIndex = parentWin.dataGridView1.CurrentCell.RowIndex; custCode = parentWin.dataGridView1.Rows[rowIndex].Cells[1].Value.ToString(); tbCustName.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[3].Value.ToString(); tbCeo.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[7].Value.ToString(); cbGubun.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[4].Value.ToString(); tbBusiNo.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[6].Value.ToString(); cbSaleMan.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[20].Value.ToString(); tbPostNo.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[11].Value.ToString(); tbAddr1.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[12].Value.ToString(); tbAddr2.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[13].Value.ToString(); tbTel.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[15].Value.ToString(); tbFax.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[16].Value.ToString(); tbCustMan.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[17].Value.ToString(); tbHp.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[18].Value.ToString(); tbContents.Text = parentWin.dataGridView1.Rows[rowIndex].Cells[21].Value.ToString(); if (parentWin.dataGridView1.Rows[rowIndex].Cells[22].Value.ToString() == "X") { cbFlag.Checked = true; } this.ActiveControl = btnSave; } }
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 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 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 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 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 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 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 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 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 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 void P1A04_PROCESS_Load(object sender, EventArgs e) { string sql = @"select co_code, co_item from tb_gi_common where co_kind = 'D' order by co_code"; MariaCRUD m = new MariaCRUD(); string msg = string.Empty; DataTable table = m.dbDataTable(sql, ref msg); if (msg == "OK") { cbStd.DataSource = table; cbStd.ValueMember = "co_code"; cbStd.DisplayMember = "co_item"; cbStd.SelectedIndex = 0; } this.ActiveControl = cbStd; }