public DataSet GetChargeInfo()
{
string[] ParaName = { };
string[] ParaValue = { };
DataSet ds = ExecuteSql.ExeParaSqlForDataSet("SELECT ChargeType.ID AS CID,VehicleType.ID AS VID,TypeName,DayCost,NightCost,Monthly,FreeTime FROM VehicleType LEFT OUTER JOIN ChargeType ON VehicleType.TypeCode = ChargeType.VehicleType", ParaName, ParaValue);
return(ds);
}
/// <summary>
/// 摘要：对数据进行分页
/// </summary>
/// <param name="dataSetSql">查询语句（包括列名、表等信息，支持表关联）</param>
/// <param name="where">条件组，二维数据【0】为包括字段名的语句段模板，【1】为取值</param>
/// <param name="orderByColumn">排序列，二维数据【0】为字段名，【1】为ASC（升序）或DESC（降序）</param>
/// <param name="rowBegin">排序后数据集的行开始索引</param>
/// <param name="rowEnd">排序后数据集的行结束索引</param>
/// <returns></returns>
public override DataTable GetDataSet(string dataSetSql, List <string[]> where, List <string[]> orderByColumn, int rowBegin, int rowEnd)
{
string stCmd = "SELECT * FROM (SELECT ROW_NUMBER() Over(order by {0}) as MB,y.* FROM (" + dataSetSql + " {1}) y ) t WHERE MB>{2} and MB<={3}";
string stOrderby = ConstructOrderBy(orderByColumn);
List <string> para = new List <string>();
List <object> value = new List <object>();
string stWhere = ConstructWhere(where, out para, out value);
if (where.Count == 0)
{
stCmd = string.Format(stCmd, stOrderby, "", rowBegin, rowEnd);
}
else
{
stCmd = string.Format(stCmd, stOrderby, " where " + stWhere, rowBegin, rowEnd);
}
return(ExecuteSql.ExeParaSqlForDataSet(stCmd, para, value).Tables[0]);
}
