private void Addclock(HttpContext context) { string str = ""; AttendanceSheetEntity obj = new AttendanceSheetEntity(); obj.UserID = 11; obj.DepartmentID = 6; str = DateTime.Now.ToString("yyyy/MM/dd") + " 09:00:00";//上班时间 if (DateTime.Compare(DateTime.Now, Convert.ToDateTime(str)) < 0) { obj.AttendanceType = 1; } else { obj.AttendanceType = 2; } if (new AttendanceSheetBLL().GetInsertClock(obj)) { LoginHandler.contextResponseWrite(context, obj); } else { LoginHandler.contextResponseWrite(context, "clockfailed"); } //throw new NotImplementedException(); }
private static List <AttendanceSheetEntity> Commnuity(string sql, params SqlParameter[] parameter) { List <AttendanceSheetEntity> list = new List <AttendanceSheetEntity>(); SqlDataReader sdr = DBHelper.GetReader(sql, parameter); while (sdr.Read()) { AttendanceSheetEntity obj = new AttendanceSheetEntity() { }; obj.UserID = Convert.ToInt32(sdr["UserID"]); obj.DepartmentID = Convert.ToInt32(sdr["DepartmentID"]); obj.AttendanceID = Convert.ToInt32(sdr["AttendanceID"]); obj.AttendanceStartTime = Convert.ToDateTime(sdr["AttendanceStartTime"] is DBNull ? DateTime.MinValue : sdr["AttendanceStartTime"]); obj.AttendanceType = Convert.ToInt32(sdr["AttendanceType"]); obj.ClockTime = Convert.ToDateTime(sdr["ClockTime"] is DBNull ? DateTime.MinValue : sdr["ClockTime"]); obj.ClockOutTime = Convert.ToDateTime(sdr["ClockOutTime"] is DBNull ? DateTime.MinValue : sdr["ClockOutTime"]); obj.Workinghours = Convert.ToInt32(sdr["Workinghours"] is DBNull ? 0 : sdr["Workinghours"]); obj.Remake = Convert.ToString(sdr["Remake"] is DBNull ? "" : sdr["Remake"]); obj.Late = Convert.ToInt32(sdr["Late"] is DBNull ? 0 : sdr["Late"]); obj.Absenteeism = Convert.ToInt32(sdr["Absenteeism"] is DBNull ? 0 :sdr["Absenteeism"]); obj.CI_ID = Convert.ToInt32(sdr["CI_ID"]); obj.CI_Name = Convert.ToString(sdr["CI_Name"]); obj.DepartmentName = Convert.ToString(sdr["DepartmentName"]); obj.UserName = Convert.ToString(sdr["UserName"]); list.Add(obj); } return(list); }
/// <summary> /// 下班签到 /// </summary> /// <param name="obj">签到信息</param> /// <returns>bool</returns> public bool GetUPdateClock(AttendanceSheetEntity obj) { return(HRCMDemoDAL.AttendanceSheetDAL.UPdateClock(obj)); }
/// <summary> /// 上班签到 /// </summary> /// <param name="obj">签到信息</param> /// <returns>bool</returns> public bool GetInsertClock(AttendanceSheetEntity obj) { return(HRCMDemoDAL.AttendanceSheetDAL.InsertClock(obj)); }
/// <summary> /// 下班签到 /// </summary> /// <param name="obj">签到信息</param> /// <returns>bool</returns> public static bool UPdateClock(AttendanceSheetEntity obj) { string sql = "UPDATE v_attendance SET ClockOutTime = getdate(),Workinghours = " + obj.Workinghours + " ,AttendanceType=" + obj.AttendanceType + ",Late=" + obj.Late + ",Absenteeism=" + obj.Absenteeism + " WHERE day(AttendanceStartTime) = day(getdate()) and UserID =" + obj.UserID; return(DBHelper.UpdateOpera(sql)); }
/// <summary> /// 上班签到 /// </summary> /// <param name="obj">签到信息</param> /// <returns>bool</returns> public static bool InsertClock(AttendanceSheetEntity obj) { string sql = "insert AttendanceSheet values(getdate()," + obj.AttendanceType + "," + obj.UserID + "," + obj.DepartmentID + ",getdate(),null,null,null,null,null)"; return(DBHelper.UpdateOpera(sql)); }