//查询特定人的周报
public static DataTable getWeekScore(int emid)
{
Query q = WeekScore.Query();
q.AddWhere(WeekScore.Columns.EmployeeId, emid);
return(q.ExecuteDataSet().Tables[0]);
}
//查询指定Id的周报
public static DataTable getWk(int wkid)
{
Query q = WeekScore.Query();
q.AddWhere(WeekScore.Columns.WeekScoreId, wkid);
return(q.ExecuteDataSet().Tables[0]);
}
public static void DelDaysOfWk(int wkid)
{
Query q = DayScore.Query();
q.AddWhere(DayScore.Columns.WeekScoreId, wkid);
q.QueryType = QueryType.Delete;
q.Execute();
Query s = WeekScore.Query();
s.AddWhere(WeekScore.Columns.WeekScoreId, wkid);
s.QueryType = QueryType.Delete;
s.Execute();
}