Exemplo n.º 1
0
        protected virtual void AppendKeyWheres(SqlCommandBuilder sql, TableMapping mapping, object idparams)
        {
            Table          table      = mapping.Table;
            ISqlParameters parameters = new MappingParameters(mapping, idparams);
            var            column     = table.Keys;
            int            index      = 0;

            column.ForEach(key =>
            {
                if (index > 0)
                {
                    sql.AppendCommandText(" and ");
                }
                index++;

                string paramName = EscapeParamName(key.Name);

                sql.AppendCommandText(EscapeIdentifier(key.Name))
                .AppendCommandText("=")
                .AppendCommandText(string.Format(NamedParameterFormat, paramName));

                object value;
                if (parameters.TryResolve(key.Name, out value))
                {
                    sql.AddCommandParameter(paramName, value);
                }
                else
                {
                    throw new FoxOneException(string.Format("parameter value of primary key '{0}' not found", key.Name));
                }
            });
        }
Exemplo n.º 2
0
        public ISqlCommand CreateInsertCommand(TableMapping mapping, object entity)
        {
            ISqlParameters    parameters = new MappingParameters(mapping, entity);
            SqlCommandBuilder sql        = new SqlCommandBuilder();

            StringBuilder names  = new StringBuilder();
            StringBuilder values = new StringBuilder();

            int index = 0;

            mapping.InsertColumns.ForEach(col =>
            {
                //自增长列不需要作为插入的字段
                if (!col.IsAutoIncrement)
                {
                    object value;

                    //TODO : 如果该字段没有找到对应的参数,则不作为插入的字段?
                    if (parameters.TryResolve(col.Name, out value))
                    {
                        if (index > 0)
                        {
                            names.Append(",");
                            values.Append(",");
                        }
                        index++;

                        string paramName = EscapeParamName(col.Name);

                        names.Append(EscapeIdentifier(col.Name));
                        values.Append(string.Format(NamedParameterFormat, paramName));

                        sql.AddCommandParameter(paramName, value);
                    }
                }
            });

            sql.AppendCommandText(INSERT_COMMAND)
            .AppendCommandText(EscapeTableName(mapping.Table.Name))
            .AppendCommandText(" (")
            .AppendCommandText(names.ToString())
            .AppendCommandText(") Values (")
            .AppendCommandText(values.ToString())
            .AppendCommandText(")");

            return(sql.ToCommand());
        }
Exemplo n.º 3
0
        public ISqlCommand CreateUpdateCommand(TableMapping mapping, object entity, string[] fields, bool inclusive)
        {
            ISqlParameters    parameters = new MappingParameters(mapping, entity);
            SqlCommandBuilder sql        = new SqlCommandBuilder();

            sql.AppendCommandText(UPDATE_COMMAND)
            .AppendCommandText(EscapeTableName(mapping.Table.Name))
            .AppendCommandText(" Set ");

            int index = 0;

            mapping.UpdateColumns.ForEach(col =>
            {
                //更新时忽略主键字段
                if (!col.IsKey && (null == fields || fields.Length == 0 || (inclusive && contains(col, fields)) || !inclusive && !contains(col, fields)))
                {
                    object value;

                    if (parameters.TryResolve(col.Name, out value))
                    {
                        if (index > 0)
                        {
                            sql.AppendCommandText(",");
                        }
                        index++;

                        string paramName = EscapeParamName(col.Name);

                        sql.AppendCommandText(EscapeIdentifier(col.Name))
                        .AppendCommandText("=")
                        .AppendCommandText(string.Format(NamedParameterFormat, paramName));

                        sql.AddCommandParameter(paramName, value);
                    }
                }
            });

            sql.AppendCommandText(WHERE_STATEMENT);

            AppendKeyWheres(sql, mapping, entity);

            return(sql.ToCommand());
        }