/// <summary>
/// 初始化
/// </summary>
/// <param name="KeyName">键名称(此键必须为可排序且上下条数是以该键的排序所得)</param>
/// <param name="KeyValue">键的值</param>
/// <param name="Table">表名称</param>
/// <param name="Where">附加条件语句,不设置请设置为null</param>
public PreNext(string KeyName, string KeyValue, string Table, string Where)
{
_KeyName = DBCommon.Replace(KeyName);
_Table = DBCommon.Replace(Table);
_KeyValue = KeyValue;
_Where = string.IsNullOrEmpty(Where) ? "" : Where;
_KeyStr = "";
}
/// <summary>
/// 返回一个数据表
/// </summary>
/// <param name="SqlString">要执行的语句或过程</param>
/// <param name="StoredProcedure">是否为存储过程</param>
/// <param name="Parames">参数列表</param>
public virtual DataTable GetDataTable(string SqlString, bool StoredProcedure, IDbDataParameter[] Parames)
{
return(DBCommon.IDataReaderToDataTable(GetCommand(SqlString, StoredProcedure, Parames).ExecuteReader(CommandBehavior.SequentialAccess)));
}
/// <summary>
/// SQL注入过滤
/// </summary>
/// <param name="input">要过滤的数据</param>
public virtual string InjectReplace(string input)
{
return(DBCommon.Replace(input));
}
/// <summary>
/// 进行字段赋值处理
/// </summary>
/// <param name="Fields">字段</param>
protected virtual string RepField(string Fields)
{
return(string.IsNullOrEmpty(Fields) ? "*" : DBCommon.Replace(Fields));
}
