数据库 oracle 函数

        static OracleConnection mQracleConnecting = null;
        public static OracleConnection QracleConnecting
        {
            get
            {
                try
                {
                    if(mQracleConnecting ==null)
                        mQracleConnecting = new OracleConnection(jksg);
                    if (mQracleConnecting.State != ConnectionState.Open)
                        mQracleConnecting.Open();
                    return mQracleConnecting;
                }
                catch (Exception)
                {
                    return null;
                }
            }

        }

        public static DataTable DBGetDataTable(string sql,string conn)
        {
            DataTable dataSet = new DataTable();
            OracleDataAdapter OraDA = new OracleDataAdapter(sql, conn);
            OraDA.Fill(dataSet);
            return dataSet;
        }
        public static DataTable DBGetDataTable(string sql, OracleConnection conn)
        {
            DataTable dataSet = new DataTable();
            OracleDataAdapter OraDA = new OracleDataAdapter(sql, conn);
            OraDA.Fill(dataSet);
            return dataSet;
        }


        // 执行SQL语句,返回所影响的行数   
        public static int ExecuteSQL(string sql)
        {
            int Cmd = 0;
            OracleCommand command = new OracleCommand(sql, QracleConnecting);
            try
            {
                Cmd = command.ExecuteNonQuery();
            }
            catch
            {
            }
            return Cmd;
        } 

        public static int ExecuteSQL_Update(string sql)
        {
            OracleDataAdapter OraDA = new OracleDataAdapter(sql, QracleConnecting);
            return OraDA.UpdateCommand.ExecuteNonQuery();
        }
        public static int ExecuteSQL_Insert(string sql)
        {
            OracleDataAdapter OraDA = new OracleDataAdapter(sql, QracleConnecting);
            return OraDA.InsertCommand.ExecuteNonQuery();
        }

 

2.存储obj，这里默认的为 EF 框架出来的类相似，表名为类名，字段是列名

public string GetInsertstring(object item)
        {
            string sql = "INSERT INTO {2} ({0}) VALUES ({1})";

            var members = item.GetType().GetProperties();
            var classname = item.GetType().Name;
            string mems="";
            string values="";
            foreach(var me in members)
            {
                mems += me.Name +",";
                var val =me.GetValue(item);

                if (me.PropertyType == typeof(System.DateTime))
                {
                    if (val == null)
                    {
                        values += ",";
                        continue;
                    }
                    System.DateTime time = (System.DateTime)val;
                    values += "TO_DATE('" + time.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-mm-dd hh24:mi:ss'),";
                }
                else if (me.PropertyType == typeof(string))
                {
                    if (val == null)
                    {
                        values += "'',";
                        continue;
                    }
                    values += "'" +val.ToString()+"',";
                }
                else
                {
                    if (val == null)
                    {
                        values += ",";
                        continue;
                    }
                    values += val.ToString() + ",";
                }
            }
            mems= mems.Substring(0,mems.Length-1);
            values = values.Substring(0, values.Length - 1);
            sql= string.Format(sql, mems, values,classname);
            return sql;
        }