Ejemplo n.º 1
0
        protected void RunSqlQuery(SqlDataQueryContext ctx, out DataTable dataTbl, String sqlCmd, params DbParameter[] dbParmArr)
        {
            DbConnection  dbConn    = ctx.DbConnection;
            DbCommand     dbCmd     = dbConn.CreateCommand();
            DbDataAdapter dbAdapter = mS_DbObjFactory.CreateDataAdapter();

            try
            {
                dbCmd.CommandType = CommandType.Text;
                dbCmd.CommandText = sqlCmd;
                dbCmd.Parameters.AddRange(dbParmArr);

                dataTbl = new DataTable();

                dbAdapter.SelectCommand = dbCmd;
                dbAdapter.Fill(dataTbl);
            }
            finally
            {
                dbAdapter.Dispose();
                dbAdapter = null;
                dbCmd.Dispose();
                dbCmd = null;
            }
        }
        protected void RunSqlBulkInsert(SqlDataQueryContext ctx, String destTblName, DataTable srcDataTbl, IDictionary <String, String> colMapping)
        {
            DbConnection  dbConn    = ctx.DbConnection;
            SqlConnection sqlDbConn = ToSqlConnection(dbConn);
            SqlBulkCopy   sqlBcp    = null;

            try
            {
                sqlBcp = new SqlBulkCopy(sqlDbConn);

                sqlBcp.DestinationTableName = destTblName;
                if (colMapping != null)
                {
                    foreach (String srcCol in colMapping.Keys)
                    {
                        sqlBcp.ColumnMappings.Add(srcCol, colMapping[srcCol]);
                    }
                }
                sqlBcp.WriteToServer(srcDataTbl);
            }
            finally
            {
                if (sqlBcp != null)
                {
                    sqlBcp.Close();
                    sqlBcp = null;
                }
            }
        }
Ejemplo n.º 3
0
        public void RunQuery(Object argObj)
        {
            DbConnection dbConn = null;

            try
            {
                dbConn = mS_DbObjFactory.CreateConnection();
                dbConn.ConnectionString = GetConnectionString();

                dbConn.Open();

                SqlDataQueryContext ctx = new SqlDataQueryContext {
                    ArgObj = argObj, DbConnection = dbConn
                };

                RunQuery_Impl(ctx);
            }
            catch (DbException ex)
            {
                throw new Exception("Query failed.", ex);
            }
            finally
            {
                if (null != dbConn)
                {
                    if (dbConn.State == ConnectionState.Open)
                    {
                        dbConn.Close();
                    }
                    dbConn.Dispose();
                    dbConn = null;
                }
            }
        }
Ejemplo n.º 4
0
        protected void RunSqlInsert(SqlDataQueryContext ctx, String destTblName, DataTable dataTbl, params DbParameter[] dbParmArr)
        {
            if (dbParmArr.Where(p => String.IsNullOrEmpty(p.SourceColumn)).FirstOrDefault() != null)
            {
                throw new ArgumentException("There are one or more dbParam without SourceColumn name!");
            }

            String insertCmdStr = String.Format("insert into [{0}]({1}) values ({2});",
                                                destTblName,
                                                String.Join(",", dbParmArr.Select(p => String.Format("[{0}]", p.SourceColumn))),
                                                String.Join(",", dbParmArr.Select(p => p.ParameterName)));

            this.RunSqlInsert(ctx, dataTbl, insertCmdStr, dbParmArr);
        }
Ejemplo n.º 5
0
        protected void RunSqlCommand(SqlDataQueryContext ctx, String sqlCmd, params DbParameter[] dbParmArr)
        {
            DbConnection dbConn = ctx.DbConnection;
            DbCommand    dbCmd  = dbConn.CreateCommand();

            try
            {
                dbCmd.CommandType = CommandType.Text;
                dbCmd.CommandText = sqlCmd;
                dbCmd.Parameters.AddRange(dbParmArr);

                dbCmd.ExecuteNonQuery();
            }
            finally
            {
                dbCmd.Dispose();
                dbCmd = null;
            }
        }
Ejemplo n.º 6
0
        protected void RunSqlInsert(SqlDataQueryContext ctx, DataTable dataTbl, String insertCmd, params DbParameter[] dbParmArr)
        {
            DbConnection  dbConn      = ctx.DbConnection;
            DbCommand     dbInsertCmd = dbConn.CreateCommand();
            DbDataAdapter dbAdapter   = mS_DbObjFactory.CreateDataAdapter();

            try
            {
                dbInsertCmd.CommandType = CommandType.Text;
                dbInsertCmd.CommandText = insertCmd;
                dbInsertCmd.Parameters.AddRange(dbParmArr);
                dbAdapter.InsertCommand = dbInsertCmd;

                dbAdapter.Update(dataTbl);
            }
            finally
            {
                dbAdapter.Dispose();
                dbAdapter = null;
                dbInsertCmd.Dispose();
                dbInsertCmd = null;
            }
        }
Ejemplo n.º 7
0
 protected abstract void RunQuery_Impl(SqlDataQueryContext ctx);