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));
}
