/// <summary> /// 加载一个区域信息 /// </summary> /// <param name="sysNo"></param> /// <returns></returns> public static AreaInfo LoadArea(int sysNo) { AreaInfoQueryFilter queryFilter = new AreaInfoQueryFilter() { PageIndex = 0, PageSize = int.MaxValue, DistrictSysNo = sysNo, }; return(CommonDA.QueryArea(queryFilter).ResultList.FirstOrDefault()); }
/// <summary> /// 获取城市下面所有区域 /// </summary> /// <param name="citySysNo"></param> /// <returns></returns> public static List <AreaInfo> GetAllDistrict(int citySysNo) { AreaInfoQueryFilter queryFilter = new AreaInfoQueryFilter() { PageIndex = 0, PageSize = int.MaxValue, CitySysNo = citySysNo, }; return(CommonDA.QueryArea(queryFilter).ResultList); }
/// <summary> /// 获取所有省份 /// </summary> /// <returns></returns> public static List <AreaInfo> GetAllProvince() { AreaInfoQueryFilter queryFilter = new AreaInfoQueryFilter() { PageIndex = 0, PageSize = int.MaxValue, OnlyProvince = true, }; return(CommonDA.QueryArea(queryFilter).ResultList); }
/// <summary> /// 获取省份下面所有城市 /// </summary> /// <param name="provinceSysNo"></param> /// <returns></returns> public static List <AreaInfo> GetAllCity(string provinceSysNo) { AreaInfoQueryFilter queryFilter = new AreaInfoQueryFilter() { PageIndex = 0, PageSize = int.MaxValue, OnlyCity = true, ProvinceSysNo = provinceSysNo, }; return(CommonDA.QueryArea(queryFilter).ResultList); }
/// <summary> /// 查询区域 /// </summary> /// <param name="queryFilter"></param> /// <returns></returns> public static QueryResult <AreaInfo> QueryArea(AreaInfoQueryFilter queryFilter) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("QueryArea"); using (var sqlBuilder = new DynamicQuerySqlBuilder(command.CommandText, command, queryFilter, string.IsNullOrEmpty(queryFilter.SortFields) ? "a.SysNo ASC" : queryFilter.SortFields)) { if (queryFilter.DistrictSysNo.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.SysNo", DbType.Int32, "@AreaSysNo", QueryConditionOperatorType.Equal, queryFilter.DistrictSysNo.Value); } if (queryFilter.CitySysNo.HasValue) { sqlBuilder.ConditionConstructor.BeginGroupCondition(QueryConditionRelationType.AND); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.CitySysNo", DbType.Int32, "@CitySysNo", QueryConditionOperatorType.Equal, queryFilter.CitySysNo.Value); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "a.SysNo", DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, queryFilter.CitySysNo.Value); sqlBuilder.ConditionConstructor.EndGroupCondition(); } if (!string.IsNullOrEmpty(queryFilter.ProvinceSysNo)) { //sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.ProvinceSysNo", DbType.Int32, "@ProvinceSysNo", QueryConditionOperatorType.Equal, queryFilter.ProvinceSysNo.Value); sqlBuilder.ConditionConstructor.AddSubQueryCondition(QueryConditionRelationType.AND, "a.ProvinceSysNo", QueryConditionOperatorType.In, queryFilter.ProvinceSysNo); } if (queryFilter.Status.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.Status", DbType.Int32, "@AreaSysNo", QueryConditionOperatorType.Equal, queryFilter.Status.Value); } if (queryFilter.OnlyProvince) { sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "a.ProvinceSysNo IS NULL"); } if (queryFilter.OnlyCity) { sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "a.CitySysNo IS NULL"); sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "a.ProvinceSysNo IS NOT NULL"); } //if (queryFilter.OnlyDistrict) //{ // sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, "a.CitySysNo IS NOT NULL"); //} command.CommandText = sqlBuilder.BuildQuerySql(); List <AreaInfo> resultList = command.ExecuteEntityList <AreaInfo>(); int totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount")); return(new QueryResult <AreaInfo>() { PageInfo = new PageInfo() { PageIndex = queryFilter.PageIndex, PageSize = queryFilter.PageSize, TotalCount = totalCount, SortBy = queryFilter.SortFields }, ResultList = resultList }); } }
public static void SetMultipleSettingValue(List <FreeShippingChargeRuleInfo> list) { if (HasElements(list)) { AreaInfoQueryFilter queryFilter = new AreaInfoQueryFilter() { PageIndex = 0, PageSize = int.MaxValue, OnlyProvince = true, }; List <AreaInfo> allProvinceList = CommonDA.QueryArea(queryFilter).ResultList; int totalCount; List <PayTypeInfo> allPayTypeList = CommonDA.GetAllPayType(); foreach (var item in list) { if (HasElements(item.ShipAreaSettingValue) && HasElements(allProvinceList)) { foreach (var simpleObj in item.ShipAreaSettingValue) { var p = allProvinceList.Find(x => x.SysNo.ToString() == simpleObj.ID); if (p != null) { simpleObj.Name = p.ProvinceName; } } } if (HasElements(item.PayTypeSettingValue) && HasElements(allPayTypeList)) { foreach (var simpleObj in item.PayTypeSettingValue) { var p = allPayTypeList.Find(x => x.SysNo.ToString() == simpleObj.ID); if (p != null) { simpleObj.Name = p.PayTypeName; } } } if (!item.IsGlobal) { LoadRuleProductSettingValue(item); } } } }
public static QueryResult <AreaInfo> QueryArea(AreaInfoQueryFilter queryFilter) { return(CommonDA.QueryArea(queryFilter)); }