using System; using System.Configuration; using System.Data; using System.Data.OracleClient; using System.Collections; ...... ...... ...... public static int ExecuteDataTable(DataTable dt) { //创建一个连接对象 using (OracleConnection connection = new OracleConnection(ConnectionString)) { OracleDataAdapter OracleAdapter = new OracleDataAdapter(); //#region 查询 //OracleAdapter.SelectCommand = new OracleCommand(); //OracleAdapter.SelectCommand.CommandType = CommandType.Text; //OracleAdapter.SelectCommand.CommandText = "SELECT JSDM,JSMC,JSMS,SCBS,JSLXDM FROM HT_YHJS "; //OracleAdapter.SelectCommand.Connection = connection; //#endregion #region 添加 string insertSql = "INSERT INTO HT_YHJS (JSDM,JSMC,JSMS,JSLXDM) VALUES (:JSDM,:JSMC,:JSMS,:JSLXDM)"; OracleAdapter.InsertCommand = new OracleCommand(); OracleAdapter.InsertCommand.CommandType = CommandType.Text; OracleAdapter.InsertCommand.CommandText = insertSql; OracleParameter[] insertParms = { new OracleParameter(":JSDM", OracleType.VarChar, 6, "JSDM"), new OracleParameter(":JSMC", OracleType.VarChar, 20, "JSMC"), new OracleParameter(":JSMS", OracleType.VarChar, 120, "JSMS"), new OracleParameter(":JSLXDM", OracleType.Char, 10, "JSLXDM") }; OracleAdapter.InsertCommand.Parameters.AddRange(insertParms); OracleAdapter.InsertCommand.Connection = connection; #endregion #region 更新 string updateSql = "UPDATE HT_YHJS SET JSMC=:JSMC, JSMS=:JSMS, JSLXDM=:JSLXDM WHERE JSDM=:JSDM"; OracleAdapter.UpdateCommand = new OracleCommand(); OracleAdapter.UpdateCommand.CommandType = CommandType.Text; OracleAdapter.UpdateCommand.CommandText = updateSql; OracleParameter[] updateParms = { new OracleParameter(":JSMC", OracleType.VarChar, 20 , "JSMC"), new OracleParameter(":JSMS", OracleType.VarChar, 120, "JSMS"), new OracleParameter(":JSLXDM", OracleType.Char, 10, "JSLXDM"), new OracleParameter(":JSDM", OracleType.VarChar, 6, "JSDM") }; updateParms[0].IsNullable = false; OracleAdapter.UpdateCommand.Parameters.AddRange(updateParms); OracleAdapter.UpdateCommand.Connection = connection; #endregion #region 删除 string deleteSql = "DELETE FROM HT_YHJS WHERE JSDM=:JSDM"; OracleParameter[] deleteParms = { new OracleParameter(":JSDM", OracleType.VarChar, 6,"JSDM") }; OracleAdapter.DeleteCommand = new OracleCommand(); OracleAdapter.DeleteCommand.CommandType = CommandType.Text; OracleAdapter.DeleteCommand.CommandText = deleteSql; OracleAdapter.DeleteCommand.Parameters.AddRange(deleteParms); OracleAdapter.DeleteCommand.Connection = connection; #endregion int r = OracleAdapter.Update(dt); dt.AcceptChanges(); return r; } |