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(), "*"); }