//public static List<StatusReport> GetStatusReport(string smsid, DateTime sendTime) //{ // string tableName = "SMSStatusReport_" + sendTime.ToString("yyyyMMdd"); // string sql = "select * from " + tableName + " where SMSID=@SMSID"; // var r = DBHelper.Instance.Query<StatusReport>(sql, new { SMSID = smsid }); // return r; //} /// <summary> /// 必须包含SMSID SendTime, page,rows 四个参数 /// 可选参数 Succeed,Number /// </summary> /// <param name="qp"></param> /// <returns></returns> public static QueryResult <StatusReport> GetStatusReport(QueryParams qp) { string tableName = "SMSStatusReport_" + qp.get("SendTime").ToString(); string sql = "select * from " + tableName + " where SMSID=@SMSID"; //添加各种查询条件 ParamList pl = DBHelper.Instance.GetParamList(qp); if (pl.isnotnull("Succeed")) { sql += " and Succeed=@Succeed"; } if (pl.isnotnull("Number")) { sql += " and Number=@Number"; } var rs = DBHelper.Instance.GetResultSet <StatusReport>(sql, "SerialNumber", pl); return(DBHelper.Instance.ToQueryResult(rs)); }