private void btnAdd_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FrmDBMtChild frmAdd = new FrmDBMtChild();
frmAdd.Text = "增加数据库";
if (frmAdd.ShowDialog() == DialogResult.OK)
{
string strIns = "INSERT INTO BASE_ZT_DB (ZTID, SYSTYPE, DBTYPE, SERVER, USERNAME, PASSWORD, DBNAME) VALUES "
+ "(:ZTID, :SYSTYPE, :DBTYPE, :SERVER, :USERNAME, :PASSWORD, :DBNAME)";
cmd = new OracleCommand(strIns, Con);
Adapter.InsertCommand = cmd;
Adapter.InsertCommand.Parameters.Add(new OracleParameter("ZTID", OracleType.VarChar, 20, "ZTID"));
Adapter.InsertCommand.Parameters.Add(new OracleParameter("SYSTYPE", OracleType.VarChar, 20, "SYSTYPE"));
Adapter.InsertCommand.Parameters.Add(new OracleParameter("DBTYPE", OracleType.VarChar, 100, "DBTYPE"));
Adapter.InsertCommand.Parameters.Add(new OracleParameter("SERVER", OracleType.VarChar, 20, "SERVER"));
Adapter.InsertCommand.Parameters.Add(new OracleParameter("USERNAME", OracleType.VarChar, 20, "USERNAME"));
Adapter.InsertCommand.Parameters.Add(new OracleParameter("PASSWORD", OracleType.VarChar, 20, "PASSWORD"));
Adapter.InsertCommand.Parameters.Add(new OracleParameter("DBNAME", OracleType.VarChar, 100, "DBNAME"));
DataRow newRow = dt.NewRow();
newRow["ZTID"] = frmAdd.getZT();
newRow["SYSTYPE"] = frmAdd.getSysType();
newRow["DBTYPE"] = frmAdd.getDBType();
newRow["SERVER"] = frmAdd.getServer();
newRow["USERNAME"] = frmAdd.getUser();
newRow["PASSWORD"] = frmAdd.getPass();
newRow["DBNAME"] = frmAdd.getDBName();
dt.Rows.Add(newRow);
Adapter.Update(ds, "BASE_ZT_DB");
this.FrmDBMt_Load(sender, e);
}
}
