//result:1同意0拒绝
public static bool setAttendanceApplyStatus(int id, int result, int approvalUserId, String reason = "")
{
String tel = "";
using (DataClassesEduDataContext dc = new DataClassesEduDataContext())
{
dc.AttendanceApprovalSubmit(id, result, ref tel);
if(!String.IsNullOrEmpty(reason))
{
var history = dc.KQ_AttendanceApprovalHistory.Where(h => h.attendanceId == id && h.userid == approvalUserId);
if(history.Count()==1)
{
KQ_AttendanceApprovalHistory h = history.Single();
h.reason = reason;
dc.SubmitChanges();
}
}
if (!String.IsNullOrEmpty(tel))
{
v_KQ_Attendance kq = dc.v_KQ_Attendance.Where(u => u.Id == id).Single();
string approvalyes="http://wx.nbyzzj.cn/approval.php?attendId="+id+"%26result=1%26approvalId="+kq.ApprovalId;
string approvalno = "http://wx.nbyzzj.cn/approval.php?attendId=" + id + "%26&result=0";
string message = "您有一条待审批的请假申请，请假人：" + kq.username + " ，请假类型：" + kq.applytype + "，请假时间从：" + kq.starttime.ToString() + "到：" + kq.endtime.ToString() + ",事由：" + kq.reason + ",请您审批，(不同意需在电脑审批)同意点以下链接：" + approvalyes;
//+"。不同意点：" + approvalno;
//tel = "13486689106";
BLL.pub.PubClass.sendSMS(tel, message);
}
return true;
/*
KQ_Attendance kq = dc.KQ_Attendance.Where(o => o.Id == id).Single();
if (kq.stepNow == kq.stepCount)
{
kq.status = status;
Users user = dc.Users.Where(u => u.Key == kq.userid).Single();
string message = "您的请假申请已处理，审批人：" + kq.ApprovalName + " 审批结果：" + status;
if (!String.IsNullOrEmpty(user.changhao))
BLL.pub.PubClass.sendSMS(user.changhao, message);
}else
{
kq.stepNow += 1;
kq.status = "审批中";
int headmasterId = (int)dc.Department.Where(d => d.Name == kq.dept).Single().HeadmasterId;
Users user = dc.Users.Where(u => u.Key == headmasterId).Single();
String headmasterName = user.TrueName;
kq.ApprovalId = headmasterId;
kq.ApprovalName = headmasterName;
t_User_Task task = new t_User_Task();
task.createtime = kq.applyTime;
task.url = "/Application/KQ/Attendance/MyApproval.aspx";
task.description = "您有一条请假申请待审批";
task.isClick = false;
dc.t_User_Task.InsertOnSubmit(task);
string message = "您有一条待审批的请假申请：" + kq.username + " " + kq.reason;
if(!String.IsNullOrEmpty(user.changhao))
BLL.pub.PubClass.sendSMS(user.changhao, message);
}
dc.SubmitChanges();
return true;
* */
}
}