public Model.ReturnValue InitData(Model.ReturnValue returnValue)
{
int PageIndex = Common.TypeHelper.ObjectToInt(Request["PageIndex"], 0);
int PageSize = Common.TypeHelper.ObjectToInt(Request["PageSize"], 10);
string CheckInputText = Request["CheckInputText"];
string SearchOptionText = Request["SearchOptionText"];
//string StatusOptionText = Request["StatusOptionText"];
string PrizeOptionText = Request["PrizeOptionText"];
string OcrOptionText = Request["OcrOptionText"];
string StarTimeText = Request["StarTimeText"];
string EndTimeText = Request["EndTimeText"];
string OrderStatusType = Request["OrderStatusType"];
string sqlwhere = "";
if (string.IsNullOrEmpty(CheckInputText) == false && string.IsNullOrEmpty(SearchOptionText) == false)
{
sqlwhere += " and " + SearchOptionText + " like '%" + Common.ReplaceErorrSql.StripSQLInjection(CheckInputText) + "%'";
}
if (string.IsNullOrEmpty(OrderStatusType) == false && OrderStatusType != "1")
{
sqlwhere += " and a.States =" + (OrderStatusType == "2" ? "0" : OrderStatusType == "3" ? "1" : "-1") + "";
}
if (string.IsNullOrEmpty(PrizeOptionText) == false)
{
sqlwhere += " and a.Jx='" + PrizeOptionText + "'";
}
if (string.IsNullOrEmpty(OcrOptionText) == false && Request["GetType"] != "Export")
{
if (OcrOptionText == "是")
{
sqlwhere += " and ap.note is not null ";
}
else
{
sqlwhere += " and ap.note is null ";
}
}
if (string.IsNullOrEmpty(StarTimeText) == false)
{
sqlwhere += " and a.CreateTime >= '" + StarTimeText + " 00:00:00'";
}
if (string.IsNullOrEmpty(EndTimeText) == false)
{
sqlwhere += " and a.CreateTime <= '" + EndTimeText + " 23:59:59'";
}
if (Request["GetType"] == "Export")
{
string ExportData = string.IsNullOrEmpty(Request["ExportData"]) ? "" : Request["ExportData"].TrimEnd(',');
Common.NPOIHelper.ExportByWeb(OrderDal.GetVueExcelList(sqlwhere, ExportData, "", "OrderInfo", true), "", DateTime.Now.ToString("yyyyMMdd") + ".xlsx");
return(null);
}
else
{
DataTable OrderDt = OrderDal.GetList(sqlwhere, PageIndex, PageSize, true);
#region 查询订单红包是否过期
if (string.IsNullOrEmpty(Request["IsRefund"]) == false && Request["IsRefund"] == "是")
{
OrderDt.Columns.Add("isRefund", typeof(int));//消费者是否退款
for (int row = 0; row < OrderDt.Rows.Count; row++)
{
string Jx = OrderDt.Rows[row]["Jx"].ToString();
string HbOrderCode = OrderDt.Rows[row]["HbOrderCode"].ToString();
string SearchStatus = Common.SearchRedPack.SearchOrder(HbOrderCode);
OrderDt.Rows[row]["isRefund"] = (HbOrderCode.Length > 0 && (SearchStatus == "已退款" || SearchStatus == "发放失败")) ? 1 : 0;
}
}
#endregion
returnValue.EffectRows = OrderDal.GetCount(sqlwhere, "", true);//true 左连接小票表 非小票项目可不传
returnValue.ObjectValue = Common.JsonHelper.DataTableToJson(OrderDt);
}
return(returnValue);
}
