/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="pagination">分页，排序参数</param>
/// <param name="keyword">检索关键字</param>
/// <returns></returns>
public List <ProfileGrading_TypeContracts> GetList(Pagination pagination, string keyword, ProfileGradeBasicDataEnum type)
{
StringBuilder strsql = new StringBuilder();
strsql.Append("SELECT * FROM ProfileGrading_Type_Rlation WHERE ProfileGradeBasicType=" + (int)type);
KeyValuePair <string, string>[] grading_TypeRlationList = GTypeR.dbcontext.Database.SqlQuery <ProfileGrading_Type_RlationEntity>(strsql.ToString()).Select(d => new KeyValuePair <string, string>(d.ProfileGradingTypeId, d.ProfileGradeType)).ToArray();
var expression = ExtLinq.True <ProfileGrading_TypeEntity>();
for (int i = 0; i < grading_TypeRlationList.Length; i++)
{
var idWhere = grading_TypeRlationList[i].Key.ToString();
if (i == 0)
{
expression = expression.And(t => t.F_Id.Contains(idWhere));
}
else
{
expression = expression.Or(t => t.F_Id.Contains(idWhere));
}
}
if (grading_TypeRlationList.Length <= 0)
{
expression = expression = expression.And(t => t.F_Id == "-1");
}
if (!string.IsNullOrEmpty(keyword))
{
expression = expression.And(t => t.Name.Contains(keyword));
}
return(GType.FindList(expression, pagination).Select(d => new ProfileGrading_TypeContracts()
{
F_Id = d.F_Id,
Name = d.Name,
Grade = d.Grade,
AssociatedClassifyStr = grading_TypeRlationList.SingleOrDefault(f => f.Key == d.F_Id).Value
}).ToList());
}
public static List <ProfileScoringClassifyEntryType> GetGradeType(ProfileGradeBasicDataEnum baseData)
{
if (_gradeAssociatedEntryList == null)
{
_gradeAssociatedEntryList = new List <ProfileScoringClassifyEntryType>();
}
_gradeAssociatedEntryList.Clear();
switch (baseData)
{
case ProfileGradeBasicDataEnum.道路:
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.特级道路);
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.一级道路);
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.二级道路);
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.级道路);
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.背街小巷);
break;
case ProfileGradeBasicDataEnum.垃圾箱房:
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.沿街箱房);
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.非沿街箱房);
break;
case ProfileGradeBasicDataEnum.压缩站:
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.沿街压缩站);
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.非沿街压缩站);
break;
case ProfileGradeBasicDataEnum.公厕:
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.一类公厕);
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.二类公厕);
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.类公厕);
break;
case ProfileGradeBasicDataEnum.沿街垃圾收集设施:
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.废物箱);
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.沿街垃圾桶);
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.倒粪站小便池);
break;
case ProfileGradeBasicDataEnum.环卫车辆:
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.机扫车);
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.冲洗车);
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.清运车);
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.电动机具);
break;
case ProfileGradeBasicDataEnum.绿化:
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.绿化带);
break;
case ProfileGradeBasicDataEnum.绿色账户小区:
_gradeAssociatedEntryList.Add(ProfileScoringClassifyEntryType.绿色账户小区);
break;
default:
break;
}
return(_gradeAssociatedEntryList);
}
