示例#1
0
        //查询特定人的周报
        public static DataTable getWeekScore(int emid)
        {
            Query q = WeekScore.Query();

            q.AddWhere(WeekScore.Columns.EmployeeId, emid);
            return(q.ExecuteDataSet().Tables[0]);
        }
示例#2
0
        //查询指定Id的周报
        public static DataTable getWk(int wkid)
        {
            Query q = WeekScore.Query();

            q.AddWhere(WeekScore.Columns.WeekScoreId, wkid);
            return(q.ExecuteDataSet().Tables[0]);
        }
示例#3
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();
        }