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]); }