更新表单数据，按照时间判断

   // string sql = "UPDATE i_D002033Clockin a  JOIN i_D002033attendanceDetail s ON MONTH(s.dateTime) = MONTH(a.Checkinperiod) and day(s.dateTime) = day(a.Checkinperiod) and year(s.dateTime) = year(a.Checkinperiod) SET timeWork = Checkinperiod WHERE Checkintype= '下班打卡' and MONTH (Checkinperiod) = '3'";
        // System.Data.DataTable  dt = this.Request.Engine.Query.QueryTable(sql, null);
// string sql = "UPDATE i_D002033attendanceDetail SET overtimehours = '0',status=1 WHERE MONTH (dateTime) = '3' and  overtimehours is null or overtimehours = ''";

根据时间判断 2张表 数据合并 更新

根据时间判断更新状态