public static List <OnlineOrder> ExportQueryPage(OnlineOrderCondition condition)
{
if (condition == null)
{
throw new ArgumentNullException("condition");
}
IOnlineOrder factory = OnlineOrderFactory.GetFactory();
return(factory.ExportQueryPage(condition));
}
private OnlineOrderCondition GetOnlineOrderCondition()
{
DateTime start = DateTime.Now.Date;
DateTime sTime;
if (!string.IsNullOrWhiteSpace(Request.Params["StartTime"]) && DateTime.TryParse(Request.Params["StartTime"], out sTime))
{
start = sTime;
}
DateTime end = DateTime.Now;
DateTime eTime;
if (!string.IsNullOrWhiteSpace(Request.Params["EndTime"]) && DateTime.TryParse(Request.Params["EndTime"], out eTime))
{
end = eTime;
}
OnlineOrderCondition condition = new OnlineOrderCondition();
if (string.IsNullOrWhiteSpace(Request.Params["CompanyId"]))
{
throw new MyException("获取单位编号失败");
}
condition.CompanyId = Request.Params["CompanyId"].ToString();
if (!string.IsNullOrWhiteSpace(Request.Params["ParkingId"]) && Request.Params["ParkingId"].ToString() != "-1")
{
condition.ParkingId = Request.Params["ParkingId"].ToString();
}
if (!string.IsNullOrWhiteSpace(Request.Params["ExternalPKID"]) && Request.Params["ExternalPKID"].ToString() != "-1")
{
condition.ExternalPKID = Request.Params["ExternalPKID"].ToString();
}
condition.PaymentChannel = PaymentChannel.AliPay;
condition.Start = start;
condition.End = end;
string messgage = string.Empty;
if (!string.IsNullOrWhiteSpace(Request.Params["OrderId"]))
{
condition.OrderId = Request.Params["OrderId"].ToString();
}
if (!string.IsNullOrWhiteSpace(Request.Params["PlateNo"]))
{
condition.PlateNo = Request.Params["PlateNo"].ToString();
}
if (!string.IsNullOrWhiteSpace(Request.Params["Status"]) && Request.Params["Status"].ToString() != "-1")
{
condition.Status = (OnlineOrderStatus)int.Parse(Request.Params["Status"].ToString());
}
if (!string.IsNullOrWhiteSpace(Request.Params["OrderType"]) && Request.Params["OrderType"].ToString() != "-1")
{
condition.Ordertype = (OnlineOrderType)int.Parse(Request.Params["OrderType"].ToString());
}
return(condition);
}
public static List <OnlineOrder> QueryPage(OnlineOrderCondition condition, int pageIndex, int pageSize, out int recordTotalCount)
{
if (condition == null)
{
throw new ArgumentNullException("condition");
}
IOnlineOrder factory = OnlineOrderFactory.GetFactory();
return(factory.QueryPage(condition, pageIndex, pageSize, out recordTotalCount));
}
public List <OnlineOrder> QueryAll(OnlineOrderCondition condition)
{
StringBuilder sql = new StringBuilder();
sql.Append("SELECT o.*,w.NickName as PayerNickName FROM OnlineOrder o left join WX_Info w on o.PayAccount=w.OpenID");
sql.Append(" WHERE o.OrderTime>=@STARTCREATETIME AND o.OrderTime<=@ENDCREATETIME and o.PaymentChannel=@PaymentChannel and o.CompanyID=@CompanyID");
using (DbOperator dbOperator = ConnectionManager.CreateReadConnection())
{
dbOperator.AddParameter("STARTCREATETIME", condition.Start.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperator.AddParameter("ENDCREATETIME", condition.End.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperator.AddParameter("PaymentChannel", (int)condition.PaymentChannel);
dbOperator.AddParameter("CompanyID", condition.CompanyId);
if (!string.IsNullOrEmpty(condition.OrderId))
{
sql.Append(" AND o.OrderId=@OrderId");
dbOperator.AddParameter("OrderId", condition.OrderId);
}
if (!string.IsNullOrWhiteSpace(condition.ExternalPKID))
{
sql.Append(" AND o.ExternalPKID=@ExternalPKID");
dbOperator.AddParameter("ExternalPKID", condition.ExternalPKID);
}
if (!string.IsNullOrEmpty(condition.PlateNo))
{
sql.Append(" AND o.PlateNo LIKE @PlateNo");
dbOperator.AddParameter("PlateNo", "%" + condition.PlateNo + "%");
}
if (condition.Ordertype.HasValue)
{
sql.Append(" AND o.OrderType=@OrderType");
dbOperator.AddParameter("OrderType", (int)condition.Ordertype);
}
if (condition.Status.HasValue)
{
sql.Append(" AND o.Status=@Status");
dbOperator.AddParameter("Status", (int)condition.Status);
}
if (!string.IsNullOrEmpty(condition.ParkingId))
{
sql.Append(" AND o.PKID=@PKID");
dbOperator.AddParameter("PKID", condition.ParkingId);
}
sql.Append(" order by OrderId DESC");
List <OnlineOrder> models = new List <OnlineOrder>();
using (DbDataReader dr = dbOperator.ExecuteReader(sql.ToString()))
{
while (dr.Read())
{
models.Add(DataReaderToModel <OnlineOrder> .ToModel(dr));
}
}
return(models);
}
}
public List <OnlineOrder> ExportQueryPage(OnlineOrderCondition condition)
{
List <OnlineOrder> onlineOrder = new List <OnlineOrder>();
string strSql = string.Format(@"SELECT o.*,w.NickName as PayerNickName FROM OnlineOrder o left join WX_Info w on o.PayAccount=w.OpenID
WHERE o.OrderTime>=@STARTCREATETIME AND o.OrderTime<=@ENDCREATETIME and o.PaymentChannel=@PaymentChannel and o.CompanyID=@CompanyID");
using (DbOperator dbOperator = ConnectionManager.CreateReadConnection())
{
dbOperator.AddParameter("STARTCREATETIME", condition.Start.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperator.AddParameter("ENDCREATETIME", condition.End.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperator.AddParameter("PaymentChannel", (int)condition.PaymentChannel);
dbOperator.AddParameter("CompanyID", condition.CompanyId);
if (!string.IsNullOrEmpty(condition.OrderId))
{
strSql += " AND o.OrderId=@OrderId";
dbOperator.AddParameter("OrderId", condition.OrderId);
}
if (!string.IsNullOrWhiteSpace(condition.ExternalPKID))
{
strSql += " AND o.ExternalPKID=@ExternalPKID";
dbOperator.AddParameter("ExternalPKID", condition.ExternalPKID);
}
if (!string.IsNullOrEmpty(condition.PlateNo))
{
strSql += " AND o.PlateNo LIKE @PlateNo";
dbOperator.AddParameter("PlateNo", "%" + condition.PlateNo + "%");
}
if (condition.Ordertype.HasValue)
{
strSql += " AND o.OrderType=@OrderType";
dbOperator.AddParameter("OrderType", (int)condition.Ordertype);
}
if (condition.Status.HasValue)
{
strSql += " AND o.Status=@Status";
dbOperator.AddParameter("Status", (int)condition.Status);
}
if (!string.IsNullOrEmpty(condition.ParkingId))
{
strSql += " AND o.PKID=@PKID";
dbOperator.AddParameter("PKID", condition.ParkingId);
}
using (DbDataReader reader = dbOperator.ExecuteReader(strSql))
{
while (reader.Read())
{
onlineOrder.Add(DataReaderToModel <OnlineOrder> .ToModel(reader));
}
}
return(onlineOrder);
}
}
