/// <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));
}
