Exemplo n.º 1
0
        private Boolean ExecuteSQL(string commandStr)
        {
            string tableName  = "";
            string operation  = "";
            bool   autoInsert = false;

            SQLHandler.ParseTable(commandStr, ref tableName, ref operation);
            QueryResult query = new QueryResult(); //Declare a struct to record the query.

            ThreadHandler.LockThread();            // Lock the thread here
            for (int attempts = 0; attempts < 5; attempts++)
            {
                try
                {
                    if (Log.Count > 200)
                    {
                        Log.Dequeue();
                    }
                    using (SqlConnection connction = new SqlConnection(IntData.DestConn))
                    {
                        query.Command = commandStr;
                        connction.Open();
                        if (query.Command.Length > IntData.AUTO_INSERT_STR.Length)
                        {
                            if (query.Command.Substring(query.Command.Length - IntData.AUTO_INSERT_STR.Length, IntData.AUTO_INSERT_STR.Length) == IntData.AUTO_INSERT_STR)
                            {
                                query.Command = query.Command.Substring(0, query.Command.Length - IntData.AUTO_INSERT_STR.Length);
                                autoInsert    = true;
                            }
                        }
                        SqlCommand command = new SqlCommand(query.Command, connction);
                        query.Result             = command.BeginExecuteNonQuery();
                        query.ExecuteTime        = SqlLocker(query.Result);
                        query.Completed          = true;
                        query.AffectedRecordsets = command.EndExecuteNonQuery(query.Result);
                        Log.Enqueue(query.Command);//Queue the query.
                        if (autoInsert && query.AffectedRecordsets == 0)
                        {
                            command.CommandText      = SQLHandler.GenerateInsert(query.Command);
                            query.Result             = command.BeginExecuteNonQuery();
                            query.ExecuteTime        = SqlLocker(query.Result);
                            query.IsAutoInsert       = true;
                            query.Completed          = true;
                            query.AffectedRecordsets = command.EndExecuteNonQuery(query.Result);
                            Log.Enqueue(query.Command);//Queue the qurey.
                        }
                    }
                    break;
                }
                catch (Exception ex)
                {
                    query.Completed = false;
                    query.Command  += "\t Error:" + ex.Message;
                    Log.Enqueue(query.Command);
                    query.RetryCount++;
                }
            }
            //insert log here
            ThreadHandler.ReleaseThread(); // Release the thread here
            return(true);
        }