private StreetInfoQuery GetStreetQuery()
{
StreetInfoQuery query = new StreetInfoQuery();
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["StreetName"]))
{
query.streetName = base.Server.UrlDecode(this.Page.Request.QueryString["StreetName"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["RegionCode"]))
{
query.regionCode = base.Server.UrlDecode(this.Page.Request.QueryString["RegionCode"]);
}
query.PageSize = this.pager.PageSize;
query.PageIndex = this.pager.PageIndex;
return(query);
}
private void BindData()
{
StreetInfoQuery query = this.GetStreetQuery();
DbQueryResult streetInfos = SalesHelper.GetStreetInfo(query);
//根据取出来的regionId获取完整的省市区名
DataTable dtStreet = (DataTable)streetInfos.Data;
dtStreet.Columns.Add("regionName");
foreach (DataRow row in dtStreet.Rows)
{
row["regionName"] = Hidistro.Entities.RegionHelper.GetFullRegion(Convert.ToInt32(row["regionCode"]), " ");
}
grdStreetsInfo.DataSource = streetInfos.Data;
grdStreetsInfo.DataBind();
this.pager.TotalRecords = streetInfos.TotalRecords;
this.pager1.TotalRecords = streetInfos.TotalRecords;
}
/// <summary>
/// 获取所有街道信息
/// </summary>
public DbQueryResult GetStreetInfo(StreetInfoQuery query)
{
StringBuilder builder = new StringBuilder();
builder.AppendFormat(" 1=1 ");
//已经绑定了的街道不允许重复绑定
if (query.isUserBind)
{
builder.AppendFormat("and ys.StreetId not in (select StreetId from YiHui_DistributorRegion) ");
}
if (query.streetName != null)
{
builder.AppendFormat(" And ys.streetName LIKE '%{0}%'", DataHelper.CleanSearchString(query.streetName));
}
if (query.regionCode != null)
{
builder.AppendFormat(" AND regionCode = '{0}'", query.regionCode);
}
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "YiHui_StreetInfo YS left join YiHui_DistributorRegion YDR on ys.StreetId = ydr.StreetId left join aspnet_Distributors AD on ydr.distributorId = ad.UserId left join aspnet_Members AM on ad.UserId=am.UserId", "ys.StreetId", builder.ToString(), "ys.*,ad.StoreName,am.UserName"));
}
private StreetInfoQuery GetStreetQuery()
{
StreetInfoQuery query = new StreetInfoQuery();
string streetNameStr = Globals.RequestQueryStr("StreetName");
if (!string.IsNullOrEmpty(streetNameStr))
{
query.streetName = Globals.RequestQueryStr("StreetName");
}
ManagerInfo currentManager = ManagerHelper.GetCurrentManager();
query.distributorId = currentManager.UserId;
query.SortOrder = Core.Enums.SortAction.Desc;
query.SortBy = "CreateTime";
query.PageSize = this.pager1.PageSize;
query.PageIndex = this.pager1.PageIndex;
return(query);
}
public static DbQueryResult GetScopeListByUserId(StreetInfoQuery query)
{
return((new DistributorsDao()).GetScopeListByUserId(query));
}
public static DbQueryResult GetStreetInfo(StreetInfoQuery query)
{
return(new ShippingModeDao().GetStreetInfo(query));
}
