private void btnedit_Click(object sender, EventArgs e)
{
m_connectToAccess = new ConnectToAccess(deFaultpath, "CavityLibrary");
if (this.groBcavitydim.Enabled == true)
{
foreach (Control ctr in this.groBcavitydim.Controls) //输入孔的尺寸参数
{
if (ctr is TextBox)
{
//TextBox ctr1=new ctr as TextBox;
if ((ctr as TextBox).Text.Length != 0)
{
string sqlupdate = "update " + indexname + " set " + (ctr as TextBox).Name + "='" + (ctr as TextBox).Text + "' where 编码 ='" + codingname + "'";
if (m_connectToAccess.UpdateInformation(sqlupdate))
{
}
;
}
}
}
foreach (Control ctr in this.groBThread.Controls) //输入螺纹的参数信息
{
if (ctr is TextBox)
{
//TextBox ctr1=new ctr as TextBox;
if ((ctr as TextBox).Text.Length != 0)
{
string sqlupdate = "update " + indexname + " set " + (ctr as TextBox).Name + "='" + (ctr as TextBox).Text + "' where 编码 ='" + codingname + "'";
if (m_connectToAccess.UpdateInformation(sqlupdate))
{
}
;
}
}
}
}
if (groBcarvalve.Enabled == true)
{
foreach (Control ctr in this.groBcarvalve.Controls) //输入油孔的参数信息
{
if (ctr is TextBox)
{
//TextBox ctr1=new ctr as TextBox;
if ((ctr as TextBox).Text.Length != 0)
{
string sqlupdate = "update " + indexname + " set " + (ctr as TextBox).Name + "='" + (ctr as TextBox).Text + "' where 编码 ='" + codingname + "'";
if (m_connectToAccess.UpdateInformation(sqlupdate))
{
}
;
}
}
}
}
if (groBfacedim.Enabled == true)
{
}
MessageBox.Show("修改参数成功！");
}
private void AddNewGrouFaceDim()//创建一个新的油孔位置信息表
{
string sqlcreate = @"CREATE TABLE " + codenumber + "Footprint(ID AUTOINCREMENT,油孔名称 TEXT(50),Dia" + codename + " TEXT(50),X" + codename + " TEXT(50),Y" + codename + " TEXT(50))";
m_connectToAccess.CreateTable(sqlcreate);
foreach (DataGridViewRow dr in dataGridViewdim.Rows)
{
dataGridViewdim.AllowUserToAddRows = false;
string sqlupdate1 = "update " + IndexName + " set " + dr.Cells[0].Value.ToString() + "dmax='" + dr.Cells[1].Value.ToString() + "' where 编码 ='" + codename + "'";
if (m_connectToAccess.UpdateInformation(sqlupdate1))
{
}
;
string sqlupdate2 = "update " + IndexName + " set " + dr.Cells[0].Value.ToString() + "coordX='" + dr.Cells[2].Value.ToString() + "' where 编码 ='" + codename + "'";
if (m_connectToAccess.UpdateInformation(sqlupdate2))
{
}
;
string sqlupdate3 = "update " + IndexName + " set " + dr.Cells[0].Value.ToString() + "coordY='" + dr.Cells[3].Value.ToString() + "' where 编码 ='" + codename + "'";
if (m_connectToAccess.UpdateInformation(sqlupdate3))
{
}
;
string sqlinsert = "insert into " + codenumber + "Footprint(油孔名称,Dia" + codename + ",X" + codename + ",Y" + codename + ") values('" + dr.Cells[0].Value.ToString() + "','" + dr.Cells[1].Value.ToString() + "','" + dr.Cells[2].Value.ToString() + "','" + dr.Cells[3].Value.ToString() + "')";
if (m_connectToAccess.InsertInformation(sqlinsert))
{
MessageBox.Show("坐标位置信息添加成功");
}
}
}
private void EditPortNet(string oldNet, string newNet, string portName)
{
m_connectToAccess = new ConnectToAccess(deFaultpath, "项目数据库");
string update = "update NETList set " + oldNet + "='' where PortName ='" + portName + "'";
if (m_connectToAccess.UpdateInformation(update))
{
}
;
string updatenew = "update NETList set " + newNet + "='" + portName + "' where PortName ='" + portName + "'";
if (m_connectToAccess.UpdateInformation(updatenew))
{
}
;
}
private void btnsave_Click(object sender, EventArgs e)
{
IndexName = cmbIndexName.Text.ToString();
codenumber = combcodenumber.Text.ToString();
codename = tb1.Text.ToString();
string sql = "insert into " + IndexName + "(索引编号,编码) values('" + codenumber + "','" + codename + "')";
m_connectToAccess = new ConnectToAccess(deFaultpath, "CavityLibrary");
if (m_connectToAccess.InsertInformation(sql))
{
foreach (Control ctr in this.groBcavitydim.Controls) //输入孔的尺寸参数
{
if (ctr is TextBox)
{
//TextBox ctr1=new ctr as TextBox;
if ((ctr as TextBox).Text.Length != 0)
{
string sqlupdate = "update " + IndexName + " set " + (ctr as TextBox).Name + "='" + (ctr as TextBox).Text + "' where 编码 ='" + codename + "'";
if (m_connectToAccess.UpdateInformation(sqlupdate))
{
}
;
}
}
}
foreach (Control ctr in this.groBThread.Controls) //输入螺纹的参数信息
{
if (ctr is TextBox)
{
//TextBox ctr1=new ctr as TextBox;
if ((ctr as TextBox).Text.Length != 0)
{
string sqlupdate = "update " + IndexName + " set " + (ctr as TextBox).Name + "='" + (ctr as TextBox).Text + "' where 编码 ='" + codename + "'";
if (m_connectToAccess.UpdateInformation(sqlupdate))
{
}
;
}
}
}
foreach (Control ctr in this.groBcarvalve.Controls) //输入油孔的参数信息
{
if (ctr is TextBox)
{
//TextBox ctr1=new ctr as TextBox;
if ((ctr as TextBox).Text.Length != 0)
{
string sqlupdate = "update " + IndexName + " set " + (ctr as TextBox).Name + "='" + (ctr as TextBox).Text + "' where 编码 ='" + codename + "'";
if (m_connectToAccess.UpdateInformation(sqlupdate))
{
}
;
}
}
}
if (groBfacedim.Enabled == true) //输入安装面的油孔位置信息
{
int i = 0;
while (i < combcodenumber.Items.Count && combcodenumber.Text.ToString() != combcodenumber.Items[i].ToString())
{
i++;
}
if (combcodenumber.Text.ToString() == combcodenumber.Items[i].ToString())
{
EditGrouFaceDim();
}
else
{
AddNewGrouFaceDim();
}
}
MessageBox.Show("插入新元件成功");
}
}