//当日签到信息分页
private void Selectclockpage(HttpContext context)
{
user = (UserInfoEntity)context.Session["getuser"];
int pageindex = Convert.ToInt32(context.Request["offset"]);
int pagesize = Convert.ToInt32(context.Request["limit"]);
string username = context.Request["username"];
int count = 0;
List <AttendanceSheetEntity> clocklist = new AttendanceSheetBLL().GetSelectbyPage(pageindex, pagesize, user.DepartmentID.ToString(), ref count);
if (username != "")
{
var list = from o in clocklist
where o.UserName.Contains(username)
select new
{
CI_ID = o.CI_ID,
UserID = o.UserID,
AttendanceID = o.AttendanceID,
UserName = o.UserName,
ClockTime = o.ClockTime,
ClockOutTime = o.ClockOutTime,
remake = o.Remake,
CI_Name = o.CI_Name
};
var json = new
{
total = list.Count(),
rows = list
};
LoginHandler.contextResponseWrite(context, json);
}
else
{
var list = from o in clocklist
select new
{
CI_ID = o.CI_ID,
UserID = o.UserID,
AttendanceID = o.AttendanceID,
UserName = o.UserName,
ClockTime = o.ClockTime,
ClockOutTime = o.ClockOutTime,
remake = o.Remake,
CI_Name = o.CI_Name
};
var json = new
{
total = count,
rows = list
};
LoginHandler.contextResponseWrite(context, json);
}
//throw new NotImplementedException();
}
//复合查询签到信息分页
private void Selectclockwatchpage(HttpContext context)
{
user = (UserInfoEntity)context.Session["getuser"];
int pageindex = Convert.ToInt32(context.Request["offset"]);
int pagesize = Convert.ToInt32(context.Request["limit"]);
string deptid = context.Request["deptid"];
string startdate = context.Request["starttime"];
string enddate = context.Request["endtime"];
string str = "";
int count = 0;
if (user.RoleID == 1)
{
if (deptid != "-1" && deptid != "")
{
str += " and DepartmentID = " + deptid + "";
}
//if (startdate != "" || enddate != "")
//{
// str += " AND year(AttendanceStartTime) = year('"+Convert.ToDateTime(startdate)+ "') AND month(AttendanceStartTime) = month('"+ Convert.ToDateTime(startdate) +"') AND day(AttendanceStartTime) = day('"+ Convert.ToDateTime(startdate) +"')";
//}
if (startdate != "" && enddate != "")
{
str += " AND AttendanceStartTime BETWEEN '" + Convert.ToDateTime(startdate) + "' AND '" + Convert.ToDateTime(enddate) + "'";
}
List <AttendanceSheetEntity> clocklist = new AttendanceSheetBLL().GetSelectClockListPage(pageindex, pagesize, str, ref count);
var list = from o in clocklist
select new
{
CI_ID = o.CI_ID,
AttendanceStartTime = o.AttendanceStartTime,
UserID = o.UserID,
AttendanceID = o.AttendanceID,
UserName = o.UserName,
ClockTime = o.ClockTime,
ClockOutTime = o.ClockOutTime,
remake = o.Remake,
CI_Name = o.CI_Name
};
var json = new
{
total = count,
rows = list
};
LoginHandler.contextResponseWrite(context, json);
}
else
{
LoginHandler.contextResponseWrite(context, "selectfailed");
}
//throw new NotImplementedException();
}
//查询当前当月的打卡信息
private void SelectByid(HttpContext context)
{
List <AttendanceSheetEntity> list = new AttendanceSheetBLL().GetSelectAll(user.UserID.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString());
var json = from o in list
select new
{
time = o.AttendanceStartTime.ToString("yyyy-MM-dd"),
Morning = o.ClockTime.ToString("HH:mm"),
Afternoon = o.ClockOutTime.ToString("HH:mm"),
state = o.AttendanceType,
count = list.Count
};
LoginHandler.contextResponseWrite(context, json);
}
//查询当月的打卡信息
private void SelectByUserid(HttpContext context)
{
DateTime time = Convert.ToDateTime(context.Request["time"]);
string userid = context.Request["id"];
List <AttendanceSheetEntity> list = new AttendanceSheetBLL().GetSelectAll(userid.ToString(), time.Year.ToString(), time.Month.ToString());
var json = from o in list
//where o.Late > 0
select new
{
time = o.AttendanceStartTime,
cd = o.Late,
zt = o.Absenteeism
};
LoginHandler.contextResponseWrite(context, json);
}
//上个月签到情况
private void SelectByDate1(HttpContext context)
{
int month = Convert.ToInt32(context.Request["Month"]);
int year = Convert.ToInt32(context.Request["Year"]);
List <AttendanceSheetEntity> list = new AttendanceSheetBLL().GetSelectAll(user.UserID.ToString(), (year).ToString(), (month).ToString());
var json = from o in list
select new
{
time = o.AttendanceStartTime.ToString("yyyy-MM-dd"),
Morning = o.ClockTime.ToString("HH:mm"),
Afternoon = o.ClockOutTime.ToString("HH:mm"),
state = o.AttendanceType,
count = list.Count
};
LoginHandler.contextResponseWrite(context, json);
//throw new NotImplementedException();
}
//第一次上班打卡
private void Addclockone(HttpContext context)
{
AttendanceSheetEntity obj = new AttendanceSheetBLL().SelectbyUserId(user.UserID.ToString());
if (obj.ClockTime != DateTime.MinValue && obj.ClockOutTime != DateTime.MinValue)
{
LoginHandler.contextResponseWrite(context, "todayclocked");
}
else if (obj.ClockTime != DateTime.MinValue && obj.ClockOutTime == DateTime.MinValue)
{
LoginHandler.contextResponseWrite(context, "hasclock");
}
else
{
obj.UserID = user.UserID;
obj.DepartmentID = user.DepartmentID;
if ((Convert.ToDateTime(DateTime.Now.ToString("HH:mm")) <= Convert.ToDateTime("09:00")))
{
obj.AttendanceType = 1;
}
else if ((Convert.ToDateTime(DateTime.Now.ToString("HH:mm")) >= Convert.ToDateTime("17:00")))
{
obj.AttendanceType = 4;
obj.Absenteeism = 0;
}
else
{
obj.AttendanceType = 2;
TimeSpan t = Convert.ToDateTime("09:00") - (Convert.ToDateTime(DateTime.Now.ToString("HH:mm")));
obj.Late = (int)t.TotalMinutes;
}
if (new AttendanceSheetBLL().GetInsertClock(obj))
{
LoginHandler.contextResponseWrite(context, obj.AttendanceType);
}
else
{
LoginHandler.contextResponseWrite(context, "clockfailed");
}
//throw new NotImplementedException();
}
}
//第二次下班打卡
private void Updateclocktwo(HttpContext context)
{
AttendanceSheetEntity obj = new AttendanceSheetBLL().SelectbyUserId(user.UserID.ToString());
TimeSpan workinghours = (DateTime.Now - obj.ClockTime);
obj.Workinghours = (int)workinghours.Hours;//工作时长
if (Convert.ToDateTime(obj.ClockTime.ToString("HH:mm")) >= Convert.ToDateTime("17:00"))
{
obj.AttendanceType = 4;
obj.Absenteeism = 0;
}
else if (obj.ClockOutTime != DateTime.MinValue)
{
LoginHandler.contextResponseWrite(context, "hasclock");
}
else if (Convert.ToDateTime(DateTime.Now.ToString("HH:mm")) <= Convert.ToDateTime("17:00"))
{
obj.AttendanceType = 3;//早退
TimeSpan t = Convert.ToDateTime("17:00") - (Convert.ToDateTime(DateTime.Now.ToString("HH:mm")));
obj.Absenteeism = (int)t.TotalMinutes;
}
else if (Convert.ToDateTime(DateTime.Now.ToString("HH:mm")) >= Convert.ToDateTime("17:00"))
{
obj.AttendanceType = 1;//正常下班
}
if (new AttendanceSheetBLL().GetUPdateClock(obj))
{
LoginHandler.contextResponseWrite(context, obj.AttendanceType);
}
else
{
LoginHandler.contextResponseWrite(context, "clockfailed");
}
//throw new NotImplementedException();
}
private void SelectByid(HttpContext context)
{
object json = new AttendanceSheetBLL().GetSelectAll("11", "2019", "7");
LoginHandler.contextResponseWrite(context, json);
}
