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();
}
}
