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