/// <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()); }
/// <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()); }
/// <summary> /// 执行INSERT[数组式参数],返回受影响行数,发生异常返回-999 /// <para>INSERT语句不需要写VALUES部分.程序将自动补上,否则出错.</para> /// <para>例: insert into tab(col1,col2,..) </para> /// </summary> public int Insert(string sqlhalf, params object[] paras) { string sql = DBMO.AutoCmptInsertSql(sqlhalf, this.paraPrefixChar); this.InItCmd(sql, paras); return(this.SelectNon()); }