public async Task <bool> ContainsItemMatchingRoom(Classtime classtime)
{
ScanRequest scanRequest = new ScanRequest()
{
TableName = tableName,
Limit = 5,
ExpressionAttributeValues = new Dictionary <string, AttributeValue>()
{
{ ":v_" + ClasstimeAsString.building, new AttributeValue()
{
S = classtime.building
} },
{ ":v_" + ClasstimeAsString.roomNumber, new AttributeValue()
{
S = classtime.roomNumber
} }
},
FilterExpression = ClasstimeAsString.building + " = " + ":v_" + ClasstimeAsString.building
+ " and " + ClasstimeAsString.roomNumber + " = " + ":v_" + ClasstimeAsString.roomNumber
};
ScanResponse scanResponse = await dynamodbClient.ScanAsync(scanRequest);
return(scanResponse.Count > 0);
}
/// <summary>
/// 获取课表
/// </summary>
/// <param name="collegeid"></param>
/// <param name="classesid"></param>
/// <param name="week"></param>
/// <returns></returns>
public BaseResult GetAllClasstime(int teachersid, int collegeid, int classesid, int week)
{
List <Classtime> list = new List <Classtime>();
for (int i = 1; i <= 5; i++)
{
Classtime classtime = new Classtime();
switch (i)
{
case 1:
classtime.Lesson = "第一节课(上午1、2)";
break;
case 2:
classtime.Lesson = "第二节课(上午3、4)";
break;
case 3:
classtime.Lesson = "第三节课(下午1、2)";
break;
case 4:
classtime.Lesson = "第四节课(下午3、4)";
break;
case 5:
classtime.Lesson = "第五节课(下午5、6)";
break;
}
list.Add(classtime);
}
if (teachersid == 0 && collegeid == 0 && classesid == 0 && week == 0)
{
result.code = 0;
result.data = list;
return(result);
}
for (var a = 1; a <= 5; a++)
{
for (var b = 1; b <= 7; b++)
{
view_classtime_all temp;
if (teachersid == 0)
{
temp = dalClasstimeAll.ListByWhere(collegeid, classesid, week, b, a);
}
else
{
temp = dalClasstimeAll.ListByWhere(teachersid, b, a);
}
if (temp != null)
{
switch (b)
{
case 1:
list[a - 1].Mon = temp.courses_name + temp.teachers_name + "(" + temp.startweek + "-" + temp.endweek + ")";
break;
case 2:
list[a - 1].Tues = temp.courses_name + temp.teachers_name + "(" + temp.startweek + "-" + temp.endweek + ")";
break;
case 3:
list[a - 1].Wednes = temp.courses_name + temp.teachers_name + "(" + temp.startweek + "-" + temp.endweek + ")";
break;
case 4:
list[a - 1].Thurs = temp.courses_name + temp.teachers_name + "(" + temp.startweek + "-" + temp.endweek + ")";
break;
case 5:
list[a - 1].Fri = temp.courses_name + temp.teachers_name + "(" + temp.startweek + "-" + temp.endweek + ")";
break;
case 6:
list[a - 1].Sat = temp.courses_name + temp.teachers_name + "(" + temp.startweek + "-" + temp.endweek + ")";
break;
case 7:
list[a - 1].Sun = temp.courses_name + temp.teachers_name + "(" + temp.startweek + "-" + temp.endweek + ")";
break;
}
}
}
}
result.code = 0;
result.data = list;
return(result);
}
