/// <summary> /// 获取用户能显示的市?查看的范围 /// 由于底层数据可以市,所以需要能选上层的省才可以 /// </summary> /// <returns>市列表</returns> public List <BaseAreaEntity> GetUserCity(string userId, string provinceId, string permissionId) { string tableName = this.UserInfo.SystemCode + "PermissionScope"; provinceId = SecretUtil.SqlSafe(provinceId); List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BasePermissionScopeEntity.FieldResourceCategory, BaseUserEntity.TableName)); parameters.Add(new KeyValuePair <string, object>(BasePermissionScopeEntity.FieldResourceId, userId)); parameters.Add(new KeyValuePair <string, object>(BasePermissionScopeEntity.FieldPermissionId, permissionId)); parameters.Add(new KeyValuePair <string, object>(BasePermissionScopeEntity.FieldEnabled, 1)); parameters.Add(new KeyValuePair <string, object>(BasePermissionScopeEntity.FieldDeletionStateCode, 0)); BasePermissionScopeManager permissionScopeManager = new BasePermissionScopeManager(this.DbHelper, this.UserInfo, tableName); string[] areaIds = permissionScopeManager.GetProperties(parameters, BasePermissionScopeEntity.FieldTargetId); for (int i = 0; i < areaIds.Length; i++) { areaIds[i] = areaIds[i].Substring(0, 4) + "00"; } parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseAreaEntity.FieldParentId, provinceId)); parameters.Add(new KeyValuePair <string, object>(BaseAreaEntity.FieldId, areaIds)); parameters.Add(new KeyValuePair <string, object>(BaseAreaEntity.FieldEnabled, 1)); parameters.Add(new KeyValuePair <string, object>(BaseAreaEntity.FieldDeletionStateCode, 0)); return(this.GetList <BaseAreaEntity>(parameters, BaseAreaEntity.FieldSortCode)); }
public List <BaseAreaEntity> GetDistrict(string cityId) { cityId = SecretUtil.SqlSafe(cityId); // string commandText = "SELECT * FROM BaseArea WHERE ((ParentId = '" + cityId + "' AND Layer = 3) OR (Id = '" + cityId + "' AND Layer = 3)) AND Enabled = 1 AND DeletionStateCode = 0 ORDER BY SortCode"; // string where = "((ParentId = '" + cityId + "' AND Layer = 3) OR (Id = '" + cityId + "' AND Layer = 3)) AND Enabled = 1 AND DeletionStateCode = 0"; // return this.GetList<BaseAreaEntity>(where); List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseItemDetailsEntity.FieldParentId, cityId)); parameters.Add(new KeyValuePair <string, object>(BaseItemDetailsEntity.FieldEnabled, 1)); parameters.Add(new KeyValuePair <string, object>(BaseItemDetailsEntity.FieldDeletionStateCode, 0)); return(this.GetList <BaseAreaEntity>(parameters, BaseItemDetailsEntity.FieldSortCode)); }
/// <summary> /// 获取用户能显示的县?查看的范围 /// 由于底层数据可以县,所以需要能选上层的省才可以 /// </summary> /// <returns>县列表</returns> public List <BaseAreaEntity> GetUserDistrict(string userId, string cityId, string permissionId) { string tableName = this.UserInfo.SystemCode + "PermissionScope"; cityId = SecretUtil.SqlSafe(cityId); List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BasePermissionScopeEntity.FieldResourceCategory, BaseUserEntity.TableName)); parameters.Add(new KeyValuePair <string, object>(BasePermissionScopeEntity.FieldResourceId, userId)); parameters.Add(new KeyValuePair <string, object>(BasePermissionScopeEntity.FieldPermissionId, permissionId)); parameters.Add(new KeyValuePair <string, object>(BasePermissionScopeEntity.FieldEnabled, 1)); parameters.Add(new KeyValuePair <string, object>(BasePermissionScopeEntity.FieldDeletionStateCode, 0)); BasePermissionScopeManager permissionScopeManager = new BasePermissionScopeManager(this.DbHelper, this.UserInfo, tableName); string[] areaIds = permissionScopeManager.GetProperties(parameters, BasePermissionScopeEntity.FieldTargetId); string where = BaseAreaEntity.FieldId + " IN (" + BaseBusinessLogic.ObjectsToList(areaIds) + ") AND ((ParentId = '" + cityId + "' AND Layer = 6) OR (Id = '" + cityId + "' AND Layer = 6)) AND Enabled = 1 AND DeletionStateCode = 0 "; return(this.GetList <BaseAreaEntity>(where)); }