Ejemplo n.º 1
0
        private MySqlCommand CreateInsertCommand()
        {
            if (this._insertCmd != null)
            {
                return(this._insertCmd);
            }
            MySqlCommand  mySqlCommand   = this.CreateBaseCommand();
            StringBuilder stringBuilder  = new StringBuilder();
            StringBuilder stringBuilder2 = new StringBuilder();

            foreach (Object o in this._schema.Rows)
            {
                DataRow dataRow = (DataRow)o;
                string  text    = (string)dataRow["BaseTableName"];
                if (text != null && text.Length != 0)
                {
                    string text2 = this.Quote((string)dataRow["ColumnName"]);
                    if (MySqlCommandBuilder.IncludedInInsert(dataRow))
                    {
                        if (stringBuilder.Length > 0)
                        {
                            stringBuilder.Append(", ");
                            stringBuilder2.Append(", ");
                        }
                        MySqlParameter mySqlParameter = this.CreateParameter(dataRow, false);
                        mySqlCommand.Parameters.Add(mySqlParameter);
                        stringBuilder.Append(text2);
                        stringBuilder2.Append(mySqlParameter.ParameterName);
                    }
                }
            }
            mySqlCommand.CommandText = string.Concat(new string[]
            {
                "INSERT INTO ",
                this.TableName,
                " (",
                stringBuilder.ToString(),
                ")  VALUES (",
                stringBuilder2.ToString(),
                ")"
            });
            MySqlCommand expr_151 = mySqlCommand;

            expr_151.CommandText = expr_151.CommandText + "; " + this.CreateFinalSelect(true);
            this._insertCmd      = mySqlCommand;
            return(mySqlCommand);
        }