Esempio n. 1
0
        /// <summary>
        /// 执行UPDATE[对象式参数],返回受影响行数,发生异常返回-999
        /// </summary>
        /// <returns></returns>
        public int Update <Q>(string sqlhalf, Q paraentity)
        {
            string sql = DBMO.AutoCmptUpdateSql(sqlhalf, this.paraPrefixChar);

            this.InItCmd <Q>(sql, paraentity);
            return(this.SelectNon());
        }
Esempio n. 2
0
        /// <summary>
        /// 执行UPDATE[字典式参数],返回受影响行数,发生异常返回-999
        /// </summary>
        public int Update(string sqlhalf, Dictionary <string, object> parasdict)
        {
            string sql = DBMO.AutoCmptUpdateSql(sqlhalf, this.paraPrefixChar);

            this.InItCmd(sql, parasdict);
            return(this.SelectNon());
        }
Esempio n. 3
0
        /// <summary>
        /// 执行INSERT[对象式参数],返回受影响行数,发生异常返回-999
        /// </summary>
        public int Insert <Q>(string insertHalf, Q paraentity)
        {
            string sql = DBMO.AutoCmptInsertSql(insertHalf, this.paraPrefixChar);

            this.InItCmd <Q>(sql, paraentity);
            return(this.SelectNon());
        }
Esempio n. 4
0
        /// <summary>
        /// 执行UPDATE[数组式参数],返回受影响行数,发生异常返回-999
        /// <para>UPDATE语句不需要写SET部分.写出要赋值的字段.程序将自动补齐SET部分否则出错</para>
        /// <para>例: update tab (col1,col2,...) where id=1</para>
        /// </summary>
        public int Update(string sqlhalf, params object[] paras)
        {
            string sql = DBMO.AutoCmptUpdateSql(sqlhalf, this.paraPrefixChar);

            this.InItCmd(sql, paras);
            return(this.SelectNon());
        }
Esempio n. 5
0
        /// <summary>
        /// 执行INSERT[字典式参数],返回受影响行数,发生异常返回-999
        /// </summary>
        public int Insert(string insertHalf, Dictionary <string, object> parasdict)
        {
            string sql = DBMO.AutoCmptInsertSql(insertHalf, this.paraPrefixChar);

            this.InItCmd(sql, parasdict);
            return(this.SelectNon());
        }