Exemple #1
0
        /// <summary>
        /// 查询该表信息
        /// </summary>
        /// <param name="where">指定的查询条件</param>
        /// <param name="prams">对字符串进行映射</param>
        /// <param name="fields">要查询的字段</param>
        /// <returns><see cref="DataTable"/>对象</returns>
        public DataTable Get(string where, object prams, params string[] fields)
        {
            if (fields == null || fields.Length == 0)
            {
                throw new ArgumentException("在准备修改表的时候发生异常,键值对集合为空!", "错误提示:");
            }
            StringBuilder key = new StringBuilder();

            foreach (string field in fields)
            {
                key.AppendFormat("[{0}],", field);
            }

            string commandText = string.Format("SELECT {0} FROM {1} {2}", key.ToString(0, key.Length - 1), this.TableName, DbHelperExensions.WhereStr(where));

            DataSet dataSet = Database.ExecuteDataset(commandText, prams);

            if (!dataSet.IsEmpty())
            {
                return(dataSet.Tables[0]);
            }
            return(null);
        }
Exemple #2
0
        /// <summary>
        /// 修改数据
        /// </summary>
        /// <param name="keyValues">修改的键值对集合</param>
        /// <param name="where">指定的修改的条件</param>
        public int Update(Dictionary <string, object> keyValues, string where)
        {
            if (keyValues == null || keyValues.Count == 0)
            {
                throw new ArgumentException("在准备修改表的时候发生异常,键值对集合为空!", "错误提示:");
            }

            //StringBuilder stringBuilder = new StringBuilder();

            //List<DbParameter> parms = new List<DbParameter>();

            //foreach (KeyValuePair<string, object> keyValue in keyValues)
            //{
            //    stringBuilder.AppendFormat("[{0}] = @{0},", keyValue.Key);

            //    parms.Add(Database.MakeInParam(keyValue.Key, keyValue.Value));
            //}

            //stringBuilder.Remove(stringBuilder.Length - 1, 1);

            List <DbParameter> parms = Database.GetUpdateParams(keyValues, out string strsql);

            string commandText = string.Format("UPDATE {0} SET {1} {2}", this.TableName, strsql, DbHelperExensions.WhereStr(where));

            return(Database.ExecuteNonQuery(CommandType.Text, commandText, parms.ToArray()));
        }
Exemple #3
0
        /// <summary>
        /// 查询该表信息
        /// </summary>
        /// <param name="where">指定的查询条件</param>
        /// <param name="prams">对字符串进行映射</param>
        /// <returns><see cref="DataTable"/>对象</returns>
        public DataTable Get(string where, object prams)
        {
            string commandText = string.Format("SELECT * FROM {0} {1}", this.TableName, DbHelperExensions.WhereStr(where));

            DataSet dataSet = Database.ExecuteDataset(commandText, prams);

            if (!dataSet.IsEmpty())
            {
                return(dataSet.Tables[0]);
            }
            return(null);
        }
Exemple #4
0
        /// <summary>
        /// 删除该表数据
        /// </summary>
        /// <param name="where">指定的删除条件</param>
        /// <param name="prams">对字符串进行映射</param>
        /// <returns>受影响行数</returns>
        public int Delete(string where, object prams)
        {
            string commandText = string.Format("DELETE FROM {0} {1}", this.TableName, DbHelperExensions.WhereStr(where));

            return(Database.ExecuteNonQuery(commandText, prams));
        }