private HSDeclareQuery GetHSDeclareQuery()
{
HSDeclareQuery HSDeclareQuery = new HSDeclareQuery();
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["OperationUserName"]))
{
HSDeclareQuery.OperationUserName = base.Server.UrlDecode(this.Page.Request.QueryString["OperationUserName"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ShipOrderNumber"]))
{
HSDeclareQuery.ShipOrderNumber = base.Server.UrlDecode(this.Page.Request.QueryString["ShipOrderNumber"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["startDate"]))
{
HSDeclareQuery.FromDate = new System.DateTime?(System.Convert.ToDateTime(this.Page.Request.QueryString["startDate"]));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["endDate"]))
{
HSDeclareQuery.ToDate = new System.DateTime?(System.Convert.ToDateTime(this.Page.Request.QueryString["endDate"]));
}
HSDeclareQuery.Page.SortBy = "OrderDate";
HSDeclareQuery.Page.SortOrder = SortAction.Asc;
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["searchkey"]))
{
HSDeclareQuery.OrderId = Globals.UrlDecode(this.Page.Request.QueryString["searchkey"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["WMSStatus"]))
{
HSDeclareQuery.WMSStatus = Globals.UrlDecode(this.Page.Request.QueryString["WMSStatus"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["DeclareStatus"]))
{
HSDeclareQuery.DeclareStatus = Globals.UrlDecode(this.Page.Request.QueryString["DeclareStatus"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["OutNoSearchText"]))
{
HSDeclareQuery.OutNo = Globals.UrlDecode(this.Page.Request.QueryString["OutNoSearchText"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["LogisticsNoSearchText"]))
{
HSDeclareQuery.LogisticsNo = Globals.UrlDecode(this.Page.Request.QueryString["LogisticsNoSearchText"]);
}
HSDeclareQuery.Page.PageIndex = this.pager.PageIndex;
HSDeclareQuery.Page.PageSize = this.pager.PageSize;
SiteSettings masterSettings = SettingsManager.GetMasterSettings(true);
if (masterSettings == null)
{
HSDeclareQuery.SuspensionTime = 0;
}
HSDeclareQuery.SuspensionTime = masterSettings.SuspensionTime;
return(HSDeclareQuery);
}
public void BindHSDeclare()
{
HSDeclareQuery HSDeclareQuery = this.GetHSDeclareQuery();
DbQueryResult HSDeclare = HSCodeHelper.GetHSDeclare(HSDeclareQuery);
this.dlstHSDeclare.DataSource = HSDeclare.Data;
this.dlstHSDeclare.DataBind();
this.SetSearchControl();
this.pager.TotalRecords = HSDeclare.TotalRecords;
this.pager1.TotalRecords = HSDeclare.TotalRecords;
}
public static DbQueryResult GetHSDeclare(HSDeclareQuery query)
{
return(new HSCodeDao().GetHSDeclare(query));
}
public DbQueryResult GetHSDeclare(HSDeclareQuery query)
{
StringBuilder stringBuilder = new StringBuilder();
Pagination page = query.Page;
if (!string.IsNullOrEmpty(query.OrderId))
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" OrderId LIKE '%{0}%'", DataHelper.CleanSearchString(query.OrderId));
}
if (query.FromDate.HasValue)
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" OrderDate >='{0}'", DataHelper.GetSafeDateTimeFormat(query.FromDate.Value));
}
if (query.ToDate.HasValue)
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" OrderDate <='{0}'", DataHelper.GetSafeDateTimeFormat(query.ToDate.Value));
}
page.SortBy = "OrderDate";
page.SortOrder = EcShop.Core.Enums.SortAction.Desc;
if (!string.IsNullOrEmpty(query.DeclareStatus) && query.DeclareStatus != "-1")
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" DeclareStatus = {0} ", int.Parse(query.DeclareStatus.ToString()));
//按申报状态来控制排序
if (query.DeclareStatus.ToString() == "0" || query.DeclareStatus.ToString() == "4" || query.DeclareStatus.ToString() == "1" || query.DeclareStatus.ToString() == "3")
{
page.SortBy = "OrderDate";
page.SortOrder = EcShop.Core.Enums.SortAction.Asc;
}
}
if (!string.IsNullOrEmpty(query.WMSStatus) && query.WMSStatus != "-1")
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
if (query.WMSStatus == "1")//放行
{
stringBuilder.AppendFormat(" isSendWMS = 2 ");
}
else
{
stringBuilder.AppendFormat(" isSendWMS = 1 and DeclareStatus = 2 ");
}
}
if (!string.IsNullOrEmpty(query.OperationUserName))
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" DeclareName LIKE '%{0}%'", DataHelper.CleanSearchString(query.OperationUserName));
}
if (!string.IsNullOrEmpty(query.OutNo))
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" OutNo LIKE '%{0}%'", DataHelper.CleanSearchString(query.OutNo));
}
if (!string.IsNullOrEmpty(query.LogisticsNo))
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" LogisticsNo LIKE '%{0}%'", DataHelper.CleanSearchString(query.LogisticsNo));
}
if (!string.IsNullOrEmpty(query.ShipOrderNumber))
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" ShipOrderNumber LIKE '%{0}%'", DataHelper.CleanSearchString(query.ShipOrderNumber));
}
if (query.SuspensionTime != null && query.SuspensionTime != 0)
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" DATEADD(MINUTE,{0},PayDate) <GETDATE()", query.SuspensionTime);
}
return(DataHelper.PagingByRownumber(page.PageIndex, page.PageSize, page.SortBy, page.SortOrder, page.IsCount, "vw_Ecshop_OrderHS_Declare ", "HS_Docking_ID", (stringBuilder.Length > 0) ? stringBuilder.ToString() : null, "*"));
//return DataHelper.PagingByTopsort(page.PageIndex, page.PageSize, page.SortBy, page.SortOrder, page.IsCount, "vw_Ecshop_OrderHS_Declare", "HS_Docking_ID", stringBuilder.ToString(), "*");
}
