//查询特定人的周报 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(); }