//判断,这是辣眼睛的烂代码 private void btn_dl_yes_Click(object sender, EventArgs e) { if (tb_dl_No.Text.Trim() == "") { return; } if (tb_dl_name.Text.Trim() == "") { return; } //从数据库中检测是否有同名的 var dr = rwh.OpenSelectSqlStr("select pNo from PCBs where pNo = '" + tb_dl_No.Text.Trim() + "'"); if (dr != null) { label_dl_info1.Text = "此编号已存在"; return; } dr = rwh.OpenSelectSqlStr("select pName from PCBs where pName = '" + tb_dl_name.Text.Trim() + "'"); if (dr != null) { label_dl_info2.Text = "此名称已存在"; return; } rwh.Close(); //需要在PCBs表中添加 //这就是新的 rwh.RunSqlStr("insert into PCBs " + "(pNo," + "pName," + "elementTableName," + "createDate," + "modifyDate," + "OtherInfo)" + " values(" + "'" + tb_dl_No.Text.Trim() + "'," + "'" + tb_dl_name.Text.Trim() + "'," + "'" + tb_dl_name.Text.Trim() + "'," + "'" + DateTime.Now + "'," + "'" + DateTime.Now + "'," + "'" + tb_otherInfo.Text.Trim() + "')"); rwh.RunSqlStr("CREATE TABLE " + tb_dl_name.Text.Trim() + " (_id AUTOINCREMENT PRIMARY KEY , " + "eName varchar(255) NOT NULL ," + "eWeihao varchar(255), eCount SmallInt)"); Close(); }
//向pcb的元件列表中添加新的元件 internal void AddEleMentToPcb(string selectElementName) { if (selectElementName == "") { return; } var pName = lb_pcb.SelectedItem.ToString(); var eName = selectElementName; //首先查询数据库中是否有重复的元件 var dr = rwh.OpenSelectSqlStr("select * from " + pName + " where eName = '" + eName + "'"); if (dr != null) { MessageBox.Show("此元件已添加"); return; } rwh.Close(); rwh.RunSqlStr(" insert into " + pName + " (eName ,eWeihao,eCount) " + "values( '" + eName + "', '未知',0)"); UpDatePcbElementPanel(); }