private void btnAdd_Click(object sender, EventArgs e) { PartsAdd frmPartsAdd = new PartsAdd(((MainForm)MdiParent).dbCtrl.sqlConn); frmPartsAdd.Text = btnAdd.Text; frmPartsAdd.btnSave.Text = "저 장"; frmPartsAdd.ckBoxIsUse.Enabled = false; frmPartsAdd.ckBoxNewAdd.Enabled = false; frmPartsAdd.cbBoxCategory1.SelectedIndex = 0; frmPartsAdd.cbBoxCategory2.SelectedIndex = 0; if (frmPartsAdd.ShowDialog() == DialogResult.OK) { ((MainForm)MdiParent).dbCtrl.SendQuery("INSERT INTO [Parts] (" + "[PartVendorID] " + ",[PartCategory1] " + ",[PartCategory2] " + ",[PartsCode] " + ",[PartNumber] " + ",[PartName] " + ",[PartManufacture] " + ",[PartDrawingNumber] " + ",[PartMakerPN] " + ",[PartUnit] " + ",[PartUnitPrice] " + ",[PartUnitPriceType] " + ",[PartNeedParts] " + ",[PartMakerPNRV] " + ",[PartDeliveryPeriod]) VALUES ( " + frmPartsAdd.VendorID + "," + frmPartsAdd.cbBoxCategory1.SelectedIndex + "," + frmPartsAdd.cbBoxCategory2.SelectedIndex + "," + "'" + frmPartsAdd.textBox_code.Text + "'," + "'" + frmPartsAdd.txtBoxPartNumber.Text + "'," + "'" + frmPartsAdd.txtBoxPartName.Text + "'," + "'" + frmPartsAdd.txtBoxManufacture.Text + "'," + "'" + frmPartsAdd.txtBoxDrawingNumber.Text + "'," + "'" + frmPartsAdd.txtBoxMakerPN.Text + "'," + "'" + frmPartsAdd.txtBoxUnit.Text + "'," + "'" + frmPartsAdd.txtBoxUnitPrice.Text + "'," + "'" + frmPartsAdd.comboBox_moneyType.SelectedIndex + "'," + "'" + frmPartsAdd.textBox_partsForMechine.Text + "'," + "'" + frmPartsAdd.textBox_Revision.Text + "'," + "'" + frmPartsAdd.txtBoxDeliveryDate.Text + "' " + " )"); PartsTable(); } }
private void btnModify_Click(object sender, EventArgs e) { if (dataGridParts.CurrentRow == null) { return; } PartsAdd frmPartsModify = new PartsAdd(((MainForm)MdiParent).dbCtrl.sqlConn); frmPartsModify.Text = btnAdd.Text; frmPartsModify.btnSave.Text = "수 정"; frmPartsModify.ckBoxIsUse.Enabled = true; frmPartsModify.ckBoxNewAdd.Enabled = true; int curRow = dataGridParts.CurrentRow.Index; frmPartsModify.ckBoxIsUse.Checked = (Convert.ToBoolean(dataGridParts["자재ID", curRow].Value)) ? true : false; frmPartsModify.VendorID = Convert.ToInt16(dataGridParts["공급자ID", curRow].Value); frmPartsModify.cbBoxCategory1.Text = dataGridParts["구분1", curRow].Value.ToString(); if (frmPartsModify.cbBoxCategory1.Text == "상용품") { frmPartsModify.cbBoxCategory1.SelectedIndex = 0; } else if (frmPartsModify.cbBoxCategory1.Text == "가공품") { frmPartsModify.cbBoxCategory1.SelectedIndex = 1; } else if (frmPartsModify.cbBoxCategory1.Text == "소모품") { frmPartsModify.cbBoxCategory1.SelectedIndex = 2; } else { frmPartsModify.cbBoxCategory1.SelectedIndex = 3; } frmPartsModify.cbBoxCategory2.Text = dataGridParts["구분2", curRow].Value.ToString(); if (frmPartsModify.cbBoxCategory2.Text == "Frame and Utility") { frmPartsModify.cbBoxCategory2.SelectedIndex = 0; } else if (frmPartsModify.cbBoxCategory2.Text == "Chamber and Hotzone") { frmPartsModify.cbBoxCategory2.SelectedIndex = 1; } else if (frmPartsModify.cbBoxCategory2.Text == "Vacuum") { frmPartsModify.cbBoxCategory2.SelectedIndex = 2; } else if (frmPartsModify.cbBoxCategory2.Text == "Control Pack") { frmPartsModify.cbBoxCategory2.SelectedIndex = 3; } else if (frmPartsModify.cbBoxCategory2.Text == "Driving Module") { frmPartsModify.cbBoxCategory2.SelectedIndex = 4; } else { frmPartsModify.cbBoxCategory2.SelectedIndex = 5; } frmPartsModify.textBox_code.Text = dataGridParts["코드", curRow].Value.ToString(); frmPartsModify.txtBoxPartNumber.Text = dataGridParts["자재NO.", curRow].Value.ToString(); frmPartsModify.txtBoxPartName.Text = dataGridParts["자재명", curRow].Value.ToString(); frmPartsModify.txtBoxVendor.Text = dataGridParts["공급업체", curRow].Value.ToString(); frmPartsModify.txtBoxManufacture.Text = dataGridParts["제조업체", curRow].Value.ToString(); frmPartsModify.txtBoxDrawingNumber.Text = dataGridParts["도면번호", curRow].Value.ToString(); frmPartsModify.txtBoxMakerPN.Text = dataGridParts["Maker P/N", curRow].Value.ToString(); frmPartsModify.txtBoxUnit.Text = dataGridParts["단위", curRow].Value.ToString(); frmPartsModify.txtBoxUnitPrice.Text = dataGridParts["단가", curRow].Value.ToString(); if (dataGridParts[15, curRow].Value.ToString().Equals("원")) { frmPartsModify.comboBox_moneyType.SelectedIndex = 0; } else { frmPartsModify.comboBox_moneyType.SelectedIndex = 1; } frmPartsModify.txtBoxDeliveryDate.Text = dataGridParts["납품기간", curRow].Value.ToString(); frmPartsModify.textBox_partsForMechine.Text = dataGridParts["한대당 필요 갯수", curRow].Value.ToString(); frmPartsModify.textBox_Revision.Text = dataGridParts["도면Revision", curRow].Value.ToString(); if (frmPartsModify.ShowDialog() == DialogResult.OK) { if (frmPartsModify.ckBoxNewAdd.Checked) { ((MainForm)MdiParent).dbCtrl.SendQuery("INSERT INTO [Parts] (" + "[PartVendorID] " + ",[PartCategory1] " + ",[PartCategory2] " + ",[PartsCode] " + ",[PartNumber] " + ",[PartName] " + ",[PartManufacture] " + ",[PartDrawingNumber] " + ",[PartMakerPN] " + ",[PartUnit] " + ",[PartUnitPrice] " + ",[PartUnitPriceType] " + ",[PartCurrentQuantity] " + ",[PartNeedParts] " + ",[PartMakerPNRV] " + ",[PartDeliveryPeriod]) VALUES ( " + frmPartsModify.VendorID + "," + frmPartsModify.cbBoxCategory1.SelectedIndex + "," + frmPartsModify.cbBoxCategory2.SelectedIndex + "," + "'" + frmPartsModify.textBox_code.Text + "'," + "'" + frmPartsModify.txtBoxPartNumber.Text + "'," + "'" + frmPartsModify.txtBoxPartName.Text + "'," + "'" + frmPartsModify.txtBoxManufacture.Text + "'," + "'" + frmPartsModify.txtBoxDrawingNumber.Text + "'," + "'" + frmPartsModify.txtBoxMakerPN.Text + "'," + "'" + frmPartsModify.txtBoxUnit.Text + "'," + frmPartsModify.txtBoxUnitPrice.Text + ", 0, " + "'" + frmPartsModify.comboBox_moneyType.SelectedIndex + "'," + "'" + frmPartsModify.textBox_partsForMechine.Text + "'," + "'" + frmPartsModify.textBox_Revision.Text + "'," + "'" + frmPartsModify.txtBoxDeliveryDate.Text + "' " + " )"); } else { ((MainForm)MdiParent).dbCtrl.SendQuery("UPDATE [Parts] SET " + "[PartModifyDate] = GETDATE() " + ",[PartVendorID] = " + frmPartsModify.VendorID + ",[PartCategory1] = " + frmPartsModify.cbBoxCategory1.SelectedIndex + ",[PartCategory2] = " + frmPartsModify.cbBoxCategory2.SelectedIndex + ",[PartsCode] = '" + frmPartsModify.textBox_code.Text + "'" + ",[PartNumber] = '" + frmPartsModify.txtBoxPartNumber.Text + "'" + ",[PartName] = '" + frmPartsModify.txtBoxPartName.Text + "'" + ",[PartManufacture] = '" + frmPartsModify.txtBoxManufacture.Text + "'" + ",[PartDrawingNumber] = '" + frmPartsModify.txtBoxDrawingNumber.Text + "'" + ",[PartMakerPN] = '" + frmPartsModify.txtBoxMakerPN.Text + "'" + ",[PartUnit] = '" + frmPartsModify.txtBoxUnit.Text + "'" + ",[PartUnitPrice] = " + ReStringMoney(frmPartsModify.txtBoxUnitPrice.Text) + ",[PartUnitPriceType] =" + frmPartsModify.comboBox_moneyType.SelectedIndex + ",[PartDeliveryPeriod] = '" + frmPartsModify.txtBoxDeliveryDate.Text + "'" + ",[PartNeedParts] = " + frmPartsModify.textBox_partsForMechine.Text + ",[PartMakerPNRV] = '" + frmPartsModify.textBox_Revision.Text + "'" + ",[PartIsUse] = " + ((frmPartsModify.ckBoxIsUse.Checked) ? 1 : 0).ToString() + " " + "WHERE [PartID] = " + dataGridParts[0, curRow].Value.ToString()); } PartsTable(); } }