/// <summary> /// 执行增删改SQL语句。 /// </summary> /// <param name="sql">增删改SQL语句。</param> /// <param name="param">SQL语句参数。</param> public void Execute(string sql, object param = null) { var command = CommandCache.GetCommand(sql, param); commands.Add(command); }
/// <summary> /// 执行查询SQL语句,返回指定类型的标量。 /// </summary> /// <typeparam name="T">标量类型。</typeparam> /// <param name="sql">查询SQL语句。</param> /// <param name="param">SQL语句参数。</param> /// <returns>指定类型的标量。</returns> public T Scalar <T>(string sql, object param = null) { var command = CommandCache.GetCommand(sql, param); return((T)database.Scalar(command)); }
/// <summary> /// 根据表名及参数删除数据。 /// </summary> /// <param name="tableName">表名。</param> /// <param name="parameters">命令参数字典。</param> public void Delete(string tableName, Dictionary <string, object> parameters) { var command = CommandCache.GetDeleteCommand(tableName, parameters); commands.Add(command); }
/// <summary> /// 根据表名及参数修改数据。 /// </summary> /// <param name="tableName">表名。</param> /// <param name="keyFields">主键字段名,多个用“,”分割。</param> /// <param name="parameters">命令参数字典。</param> public void Update(string tableName, string keyFields, Dictionary <string, object> parameters) { var command = CommandCache.GetUpdateCommand(tableName, keyFields, parameters); commands.Add(command); }
/// <summary> /// 根据表名及参数查询数据表。 /// </summary> /// <param name="tableName">表名。</param> /// <param name="parameters">命令参数字典。</param> /// <returns>数据表。</returns> public DataTable SelectTable(string tableName, Dictionary <string, object> parameters) { var command = CommandCache.GetSelectCommand(tableName, parameters); return(database.Query(command)); }
/// <summary> /// 执行查询SQL语句,返回数据表。 /// </summary> /// <param name="sql">查询SQL语句。</param> /// <param name="param">SQL语句参数。</param> /// <returns>数据表。</returns> public DataTable QueryTable(string sql, object param = null) { var command = CommandCache.GetCommand(sql, param); return(database.Query(command)); }
/// <summary> /// 删除实体对象。 /// </summary> /// <typeparam name="T">实体类型。</typeparam> /// <param name="entity">实体对象。</param> public void Delete <T>(T entity) where T : EntityBase { var command = CommandCache.GetDeleteCommand(entity); commands.Add(command); }