void bd()
{
if (BackDay > 0)
{
string sql = string.Format(" and FilesId=0 and DateStamp<={0} and IsBack=0", DateTime.Now.AddDays(-BackDay).ToString("yyyyMMdd"));
string stime = this.tbSt1.Text;
string etime = this.tbSt2.Text;
DateTime d = Convert.ToDateTime("2000-01-01");
if (stime != "")
{
string t1 = Common.TypeHelper.ObjectToDateTime(stime, d).ToShortDateString();
sql += " and a.CreateTime >= '" + t1 + " 00:00:00'";
}
if (etime != "")
{
string t2 = Common.TypeHelper.ObjectToDateTime(etime, d).ToShortDateString();
sql += " and a.CreateTime <= '" + t2 + " 23:59:59'";
}
AspNetPager1.PageSize = 10;
int count = OrderInfoDal.GetCount(sql, "");
AspNetPager1.RecordCount = count;
int page = AspNetPager1.CurrentPageIndex;
this.menuList.DataSource = OrderInfoDal.GetList(sql, page, AspNetPager1.PageSize);
this.menuList.DataBind();
}
}
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);
}
void bd()
{
string sql = "";
int status = Common.Fun.ConvertTo <int>(Request["status"], 100);
if (this.DropDownListName.SelectedValue != "选择搜索项" && string.IsNullOrEmpty(this.tbCheckName.Text) == false)
{
sql += " and " + this.DropDownListName.SelectedItem.Value + " like '%" + this.tbCheckName.Text + "%'";
}
if (status == 100)
{
if (this.ddlState.SelectedValue != "不限")
{
sql += " and a.States = " + Common.TypeHelper.ObjectToInt(this.ddlState.SelectedValue, 0);
}
}
else
{
sql += " and a.States = " + status;
}
if (this.ddlJx.SelectedValue != "不限")
{
sql += " and a.Jx = '" + this.ddlJx.SelectedItem.Value + "'";
}
if (this.ddlIsOCR.SelectedValue != "不限")
{
if (this.ddlIsOCR.SelectedValue == "是")
{
sql += " and ap.note is not null ";
}
else
{
sql += " and ap.note is null ";
}
}
string stime = this.tbSt1.Text;
string etime = this.tbSt2.Text;
DateTime d = Convert.ToDateTime("2000-01-01");
if (stime != "")
{
string t1 = Common.TypeHelper.ObjectToDateTime(stime, d).ToShortDateString();
sql += " and a.CreateTime >= '" + t1 + " 00:00:00'";
}
if (etime != "")
{
string t2 = Common.TypeHelper.ObjectToDateTime(etime, d).ToShortDateString();
sql += " and a.CreateTime <= '" + t2 + " 23:59:59'";
}
AspNetPager1.PageSize = 10;
int count = dal.GetCount(sql, "", true);//true 左连接小票表 非小票项目可不传
AspNetPager1.RecordCount = count;
int page = AspNetPager1.CurrentPageIndex;
this.menuList.DataSource = dal.GetList(sql, page, AspNetPager1.PageSize, true);
this.menuList.DataBind();
}
