public static KQ_Attendance getTopAttendRecordByUserid(int userid)
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.KQ_Attendance.Where(k => k.userid == userid).OrderByDescending(o=>o.Id).Take(1).Single();
}
}
public static List<v_KQ_SpecialRemark> databind()
{
using(DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.v_KQ_SpecialRemark.ToList();
}
}
public static List<sp_Attend_getHistoryResult> getAttendHistory(int attendId)
{
using(DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.sp_Attend_getHistory(attendId).ToList();
}
}
public static List<Department> getDepartments()
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.Department.ToList();
}
}
public static t_GZL_Actor getActorById(int id)
{
using(DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.t_GZL_Actor.Where(a => a.actorId == id).Single();
}
}
public static List<v_Deparment_Headmaster> get_vDepartments()
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.v_Deparment_Headmaster.ToList();
}
}
public static List<t_Sys> databind()
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.t_Sys.ToList();
}
}
public static t_GZL_Rout getRoutById(int id)
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.t_GZL_Rout.Where(r => r.routId == id).Single();
}
}
public static List<v_TeacherGroup> getGroups()
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.v_TeacherGroup.ToList();
}
}
public static List<v_User_Role> getRolesByUserId(int id)
{
using(DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.v_User_Role.Where(u => u.Key == id).ToList();
}
}
public static List<Roles> getRoles()
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.Roles.ToList();
}
}
public static KQ_Attendance getAttendanceById(int id)
{
using(DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.KQ_Attendance.Where(k => k.Id == id).Single();
}
}
public static List<v_Role_Users> getUsersInRole(int roleid)
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.v_Role_Users.Where(r => r.rolekey == roleid).ToList();
}
}
public static List<t_User_Task> getRoutTask(int userid)
{
using(DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.t_User_Task.Where(u => u.userid == userid && u.isClick == false).Take(4).ToList();
}
}
public static List<v_TeacherGroupUsers> getTeacherGroupUsersByGroupId(int id)
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.v_TeacherGroupUsers.Where(u => u.TeacherGroupId == id).ToList();
}
}
public static t_GZL_Item getItemById(int id)
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.t_GZL_Item.Where(i => i.ItemId == id).Single();
}
}
public static List<DayPunchCardUser> getStatiscNullByBetweenTime(DateTime start, DateTime end, char type, byte status)
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
if (type == '1')
{
var bb = from user in dc.Users
where user.UserType == '1' &&
!(from kq in dc.KQ_PunchCardRecords where kq.PunchCardType == type && kq.Time > start && kq.Time < end select kq.PunchCardUserId).Contains(user.Key)
&& !(from at in dc.KQ_Attendance where at.starttime <= start.AddHours(8) && at.endtime >= start.AddHours(8) select at.userid).Contains(user.Key)
select new DayPunchCardUser { 工号 = user.JobNumber, 姓名 = user.TrueName, 电话长号 = user.changhao, 电话短号 = user.duanhao, 序号 = (user.orderNo == null) ? 0 : (int)user.orderNo };
return bb.OrderBy(a => a.序号).ToList<DayPunchCardUser>();
}
if (type == '2')
{
var bb = from user in dc.Users
where user.UserType == '1' &&
!(from kq in dc.KQ_PunchCardRecords where kq.PunchCardType == type && kq.Time > start && kq.Time < end select kq.PunchCardUserId).Contains(user.Key)
&& !(from at in dc.KQ_Attendance where at.starttime <= start.AddHours(16) && at.endtime >= start.AddHours(16) select at.userid).Contains(user.Key)
select new DayPunchCardUser { 工号 = user.JobNumber, 姓名 = user.TrueName, 电话长号 = user.changhao, 电话短号 = user.duanhao, 序号 = (user.orderNo == null) ? 0 : (int)user.orderNo };
return bb.OrderBy(a => a.序号).ToList<DayPunchCardUser>();
}
return null;
}
}
public static List<v_Deparment_Leader> getDepartmentLeadersByDepartmentId(int id)
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.v_Deparment_Leader.Where(d=>d.DepartmentId == id).ToList();
}
}
public static List<t_GZL_Actor> getActorsByRoutId(int routid)
{
using(DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.t_GZL_Actor.Where(a => a.routId == routid).OrderBy(u=>u.sortNo).ToList();
}
}
public static Department getDepartmentById(int id)
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.Department.Where(u => u.ID == id).Single();
}
}
public static List<t_Menu>getMenuBySysid(int sysid,int userid)
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
var menusParent = (from m in dc.t_Menu.Where(u => u.sysId == sysid && u.parentId == 0)
join menuRole in dc.t_Menu_Role
on m.Id equals menuRole.MenuKey
join role in dc.Roles
on menuRole.RoleKey equals role.Key
join userRole in dc.User_Role
on role.Key equals userRole.RoleKey
join user in dc.Users.Where(u => u.Key == userid)
on userRole.UserKey equals user.Key
select m).Distinct();
var menuChild = (from m in dc.t_Menu
join menuParent in dc.t_Menu.Where(u=>u.sysId == sysid && u.parentId == 0)
on m.parentId equals menuParent.Id
join menuRole in dc.t_Menu_Role
on m.Id equals menuRole.MenuKey
join role in dc.Roles
on menuRole.RoleKey equals role.Key
join userRole in dc.User_Role
on role.Key equals userRole.RoleKey
join user in dc.Users.Where(u => u.Key == userid)
on userRole.UserKey equals user.Key
select m).Distinct();
return menusParent.Union(menuChild).ToList();
// return menus.Distinct().ToList();
// return dc.t_Menu.Where(m => m.sysId == sysid && m.parentId == 0).OrderBy(o=>o.Id).ToList();
}
}
public static int getTaskNumByUserId(int userid)
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.t_User_Task.Where(u => u.userid == userid && u.isClick == false).Count();
}
}
public static Roles getRolesById(int id)
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.Roles.Where(u => u.Key == id).Single();
}
}
public static t_Teacher_Group getTeacherGroupById(int id)
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.t_Teacher_Group.Where(u => u.Id == id).Single();
}
}
public static bool applyItem(String itemid,String username,int actorUserId)
{
try
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
t_GZL_Item item = dc.t_GZL_Item.Where(i => i.ItemId == Convert.ToInt32(itemid)).Single();
t_GZL_TaskList task = dc.t_GZL_TaskList.Where(t => t.itemGuid == item.itemGuid).Single();
t_GZL_Actor actor = dc.t_GZL_Actor.Where(a => a.actorId == task.actorId).Single();
int sortNo = (int)actor.sortNo;
var actor_next = dc.t_GZL_Actor.Where(a => a.routId == actor.routId && a.sortNo == sortNo + 1);
if (actor_next.Count() != 0)//还有下一步流程
{
task.actorId = actor_next.Single().actorId;
item.State = "待审批"; //修改任务状态
t_GZL_TaskHistory history = new t_GZL_TaskHistory();//插入历史记录
history.actorId = actor.actorId;
history.createDate = System.DateTime.Now;
history.itemGuid = item.itemGuid;
history.itemId = item.ItemId;
history.operatorName = username;
history.operatorUserId = item.ApplyUserId;
history.action = "送审";
dc.t_GZL_TaskHistory.InsertOnSubmit(history);
var has_actuser = dc.t_GZL_actorUser.Where(u => u.actorId == task.actorId && u.itemGuid == item.itemGuid && u.operateUserId == actorUserId && u.taskId == task.taskId);
if (has_actuser != null && has_actuser.Count() > 0)
{ }
else//第一次申请则插入执行人，否则用原有
{
t_GZL_actorUser actUser = new t_GZL_actorUser();//插入下一步执行的人
actUser.actorId = task.actorId;
actUser.itemGuid = item.itemGuid;
actUser.itemId = item.ItemId;
actUser.operateUserId = actorUserId;
actUser.taskId = task.taskId;
dc.t_GZL_actorUser.InsertOnSubmit(actUser);
}
t_User_Task userTask = new t_User_Task();//插入下一步执行人的任务，用于提醒
userTask.description = "您有一个待审批的采购项目";
userTask.isClick = false;
userTask.url = "/Application/GZL/CG/ApplyApprove.aspx";
userTask.createtime = DateTime.Now;
userTask.userid = actorUserId;
dc.t_User_Task.InsertOnSubmit(userTask);
dc.SubmitChanges();
return true;
}
else
return false;
}
}catch (Exception ex)
{
throw new Exception("送审错误："+ ex.Message);
}
}
public static List<v_WorkPlan> getSchoolWorkPlan()
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
DateTime dt = DateTime.Now; //当前时间
return dc.v_WorkPlan.Where(w => w.type == '1' && w.year == dt.Year && w.month == dt.Month).ToList();
}
}
public static List<t_GZL_Rout> getRoutList()
{
using(DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.t_GZL_Rout.ToList();
}
}
public static bool deleteRoleById(String id)
{
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
dc.DeleteRoles(Convert.ToInt32(id));
return true;
}
}
public static List<v_GZL_MyTaskList> getTaskListByUserid(int userid)
{
using(DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.v_GZL_MyTaskList.Where(l => l.operateUserId == userid && l.ItemType == "采购单").ToList();
}
}
public static v_KQ_Attendance getAttendanceDetail(int id)
{
using(DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
return dc.v_KQ_Attendance.Where(u => u.Id == id).Single();
}
}
