// timer event
private void AutoReadEPC_Elapsed(object sender, ElapsedEventArgs e)
{
mutex.WaitOne();
if (reader == null)
{
reader = new UHFReaderHelper();
reader.Connect();
}
if ((reader.isConnected == 1) || ((reader.isConnected == -1) && (reader.Connect())))
{
if (reader.ReadEPC() != "")
{
user = DAL.InStock.getMemDetailByID(reader.ReadEPC().Replace("A", ""));
if (textBox_name.InvokeRequired && textBox_balance.InvokeRequired)
{
Action <string> balActionDel = (string x) => {
this.textBox_balance.Text = x;
};
this.textBox_balance.Invoke(balActionDel, user.balance.ToString());
Action <string> nameActionDel = (x) => { this.textBox_name.Text = x.ToString(); };
this.textBox_name.Invoke(nameActionDel, user.name.ToString());
}
else
{
this.textBox_balance.Text = user.balance.ToString();
this.textBox_name.Text = user.name.ToString();
}
ReadEPCThread.Enabled = false;
mutex.ReleaseMutex();
return;
}
}
mutex.ReleaseMutex();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] != null)
{
user = Session["user"] as MODEL.UserInfo;
}
else
{
Response.Redirect("Login.aspx");
}
}
public void ProcessRequest(HttpContext context)
{
//context.Response.ContentType = "text/plain";
//context.Response.Write("Hello World");
string state = context.Request["state"];
BLL.AttendanceSheet_BLL attendanceSheet_BLL = new BLL.AttendanceSheet_BLL();
MODEL.UserInfo user = HttpContext.Current.Session["user"] as MODEL.UserInfo;
if (state == "select")
{
string UserID = user.UserID;
string d1 = context.Request["d1"];
string d2 = context.Request["d2"];
DataTable dt = attendanceSheet_BLL.selectRecord(UserID, d1, d2);
string j = JsonConvert.SerializeObject(dt);
context.Response.Write(j);
}
else if (state == "selectIs")
{
string AttendanceStartTime = context.Request["AttendanceStartTime"];
string UserID = user.UserID;
if (attendanceSheet_BLL.selectIs(AttendanceStartTime, UserID))
{
context.Response.Write('0');
}
else
{
context.Response.Write('1');
}
}
else if (state == "add1")
{
string UserID = user.UserID;
string AttendanceType = context.Request["AttendanceType"];
if (attendanceSheet_BLL.add1(UserID, AttendanceType))
{
context.Response.Write('0');
}
}
else if (state == "add2")
{
string UserID = user.UserID;
string AttendanceStartTime = context.Request["AttendanceStartTime"];
string AttendanceType = context.Request["AttendanceType"];
if (attendanceSheet_BLL.add2(UserID, AttendanceStartTime, AttendanceType))
{
context.Response.Write('0');
}
}
}
public void ProcessRequest(HttpContext context)
{
//context.Response.ContentType = "text/plain";
//context.Response.Write("Hello World");
string state = context.Request["state"];
BLL.AttendanceSheet_BLL attendanceSheet_BLL = new BLL.AttendanceSheet_BLL();
MODEL.UserInfo user = HttpContext.Current.Session["user"] as MODEL.UserInfo;
if (state == "select")
{
string j = JsonConvert.SerializeObject(BLL.PaySlip_BLL.selectPaySlip(user.UserID));
context.Response.Write(j);
}
}
public void ProcessRequest(HttpContext context)
{
string state = context.Request["state"];
BLL.OvertineCheck_BLL overtineCheck_BLL = new BLL.OvertineCheck_BLL();
BLL.Leave_BLL leave_BLL = new BLL.Leave_BLL();
MODEL.UserInfo user = HttpContext.Current.Session["user"] as MODEL.UserInfo;
//context.Response.ContentType = "text/plain";
//context.Response.Write("Hello World");
if (state == "audit")
{
string Audit = context.Request["Audit"];
string AuditRemarks = context.Request["AuditRemarks"];
MODEL.OvertineCheck overtineCheck = new MODEL.OvertineCheck();
overtineCheck.LeaveID = context.Request["LeaveID"];
if (user.RoleID == "2")//部门经理
{
overtineCheck.DepartmentalAudit = Audit;
overtineCheck.DepartmentalAuditRemarks = AuditRemarks;
}
else if (user.RoleID == "4")//人事经理
{
overtineCheck.GeneralManagerAudit = Audit;
overtineCheck.GeneralManagerAuditRemarks = AuditRemarks;
}
else if (user.RoleID == "5")//总经理
{
overtineCheck.ManagerAudit = Audit;
overtineCheck.ManagerAuditRemarks = AuditRemarks;
}
if (overtineCheck_BLL.AuditOvertineCheck(overtineCheck))
{
leave_BLL.updateAuditLeave(overtineCheck.LeaveID);
context.Response.Write("1");
}
}
}
public void ProcessRequest(HttpContext context)
{
BLL.UserInfo_BLL userinfo_Bll = new BLL.UserInfo_BLL();
//context.Response.ContentType = "text/plain";
//context.Response.Write("Hello World");
string state = context.Request["state"];
if (state == "login")
{
MODEL.UserInfo userinfo = new MODEL.UserInfo();
userinfo.LoginName = context.Request.Form["LoginName"];
userinfo.LoginPwd = context.Request.Form["LoginPwd"];
DataTable dt = userinfo_Bll.Login(userinfo);
if (dt.Rows.Count > 0)
{
MODEL.UserInfo user = new MODEL.UserInfo();
user.UserID = dt.Rows[0]["UserID"].ToString();
user.DepartmentID = dt.Rows[0]["DepartmentID"].ToString();
user.RoleID = dt.Rows[0]["RoleID"].ToString();
user.UserNumber = dt.Rows[0]["UserNumber"].ToString();
user.LoginName = dt.Rows[0]["LoginName"].ToString();
user.LoginPwd = dt.Rows[0]["LoginPwd"].ToString();
user.UserName = dt.Rows[0]["UserName"].ToString();
user.UserAge = dt.Rows[0]["UserAge"].ToString();
user.UserSex = dt.Rows[0]["UserSex"].ToString();
user.UserTel = dt.Rows[0]["UserTel"].ToString();
user.UserAddress = dt.Rows[0]["UserAddress"].ToString();
user.UserIphone = dt.Rows[0]["UserIphone"].ToString();
user.UserRemarks = dt.Rows[0]["UserRemarks"].ToString();
user.UserStatr = dt.Rows[0]["UserStatr"].ToString();
user.EntryTime = dt.Rows[0]["EntryTime"].ToString();
user.DimissionTime = dt.Rows[0]["DimissionTime"].ToString();
user.BasePay = dt.Rows[0]["BasePay"].ToString();
HttpContext.Current.Session["user"] = user;
////创建身份票据
//FormsAuthentication.SetAuthCookie(dt.Rows[0]["LoginName"].ToString(),false);
context.Response.Write("1");
}
else
{
context.Response.Write("0");
}
}
else if (state == "select")
{
string UserName = context.Request["UserNameTxt"];
string DepartmentID = context.Request["DepartmentID"];
int offset = Convert.ToInt32(context.Request["offset"]);
int pageSize = Convert.ToInt32(context.Request["pageSize"]);
string count;
DataTable dt = userinfo_Bll.selectUserInfo(UserName, DepartmentID, offset, pageSize, out count);
var rs = new { total = count, rows = dt };
string r = JsonConvert.SerializeObject(rs);
context.Response.Write(r);
}
else if (state == "AddUpdate")
{
string jsonStr = context.Request["user"];
MODEL.UserInfo userInfo = JsonConvert.DeserializeObject <MODEL.UserInfo>(jsonStr);
if (userInfo.UserID != "0")
{
if (userinfo_Bll.UpdataUserInfo(userInfo))
{
context.Response.Write("2");
}
}
else
{
if (userinfo_Bll.AddUserInfo(userInfo))
{
context.Response.Write("1");
}
}
}
else if (state == "del")
{
if (userinfo_Bll.DelUserInfo(context.Request["userid"]))
{
context.Response.Write("1");
}
}
else if (state == "batchdel")
{
if (userinfo_Bll.batchDelUserInfo(context.Request["userid"]))
{
context.Response.Write("1");
}
}
else if (state == "updataPwd")
{
//string a = context.Request["lLoginPwd"];
//var rs = new { valid = false};
//context.Response.Write(JsonConvert.SerializeObject(rs));
string lLoginPwd = context.Request["lLoginPwd"];
string newLoginPwd = context.Request["newLoginPwd"];
string cLoginPwd = context.Request["cLoginPwd"];
MODEL.UserInfo user = HttpContext.Current.Session["user"] as MODEL.UserInfo;
if (lLoginPwd != user.LoginPwd)
{
context.Response.Write("0");
}
else
{
if (userinfo_Bll.updataPwd(user.UserID, newLoginPwd))
{
context.Response.Write("1");
}
}
}
else if (state == "selMy")
{
MODEL.UserInfo user = HttpContext.Current.Session["user"] as MODEL.UserInfo;
context.Response.Write(JsonConvert.SerializeObject(user));
}
else if (state == "updataMy")
{
MODEL.UserInfo user = JsonConvert.DeserializeObject <MODEL.UserInfo>(context.Request["User"]);
if (userinfo_Bll.UpdataMyUserInfo(user))
{
HttpContext.Current.Session["user"] = user;
context.Response.Write("1");
}
}
else if (state == "selectColleague")
{
string UserName = context.Request["UserNameTxt"];
string DepartmentID = (HttpContext.Current.Session["user"] as MODEL.UserInfo).DepartmentID;
int offset = Convert.ToInt32(context.Request["offset"]);
int pageSize = Convert.ToInt32(context.Request["pageSize"]);
string count;
DataTable dt = userinfo_Bll.selectUserInfo(UserName, DepartmentID, offset, pageSize, out count);
var rs = new { total = count, rows = dt };
string r = JsonConvert.SerializeObject(rs);
context.Response.Write(r);
}
}
/// <summary>
/// 请假申请
/// </summary>
/// <param name="leave"></param>
/// <returns></returns>
public bool ApplicationLeave(MODEL.Leave leave, MODEL.UserInfo user)
{
MODEL.OvertineCheck overtineCheck = new MODEL.OvertineCheck();
overtineCheck.LeaveID = Leave_dal.ApplicationLeave(leave);
overtineCheck.userID = user.UserID;
overtineCheck.ApproverType = "2";
if (user.RoleID == "1" && user.DepartmentID != "10") //普通员工
{
if (Convert.ToInt32(leave.LeaveDays) < 3)
{
//只需要部门经理审核
overtineCheck.DepartmentalAudit = "3";
}
else if (Convert.ToInt32(leave.LeaveDays) >= 3 && Convert.ToInt32(leave.LeaveDays) <= 5)
{
//需要部门经理和人事经理审核
overtineCheck.DepartmentalAudit = "3";
overtineCheck.GeneralManagerAudit = "3";
}
else
{
//需要总经理,部门经理,人事经理审核
overtineCheck.DepartmentalAudit = "3";
overtineCheck.GeneralManagerAudit = "3";
overtineCheck.ManagerAudit = "3";
}
}
else if (user.DepartmentID == "10" && user.RoleID != "4") //人事部员工
{
//需要人事经理审核
if (Convert.ToInt32(leave.LeaveDays) < 3)
{
overtineCheck.GeneralManagerAudit = "3";
}
else
{
overtineCheck.GeneralManagerAudit = "3";
overtineCheck.ManagerAudit = "3";
}
}
else if (user.RoleID == "2") //部门经理
{
if (Convert.ToInt32(leave.LeaveDays) < 3)
{
//只需要人事经理审核
overtineCheck.GeneralManagerAudit = "3";
}
else
{
overtineCheck.GeneralManagerAudit = "3";
overtineCheck.ManagerAudit = "3";
}
}
else if (user.RoleID == "4") //人事经理
{
overtineCheck.ManagerAudit = "3";
}
return(OvertineCheck_dal.AddOvertineCheck(overtineCheck));
}
/// <summary>
/// 查询审批列表
/// </summary>
/// <param name="offset"></param>
/// <param name="pageSize"></param>
/// <param name="LeaveStartTime"></param>
/// <param name="LeaveEndTime"></param>
/// <param name="user"></param>
/// <param name="count"></param>
/// <returns></returns>
public DataTable selectAuditLeave(int offset, int pageSize, string LeaveStartTime, string LeaveEndTime, MODEL.UserInfo user, out string count)
{
return(Leave_dal.selectAuditLeave(offset, pageSize, LeaveStartTime, LeaveEndTime, user, out count));
}
/// <summary>
/// 查询审批列表
/// </summary>
/// <param name="offset"></param>
/// <param name="pageSize"></param>
/// <param name="LeaveStartTime"></param>
/// <param name="LeaveEndTime"></param>
/// <param name="user"></param>
/// <param name="count"></param>
/// <returns></returns>
public DataTable selectAuditLeave(int offset, int pageSize, string LeaveStartTime, string LeaveEndTime, MODEL.UserInfo user, out string count)
{
string where = "";
if (user.RoleID == "2")
{
where += " and DepartmentalAudit = 3 and UserInfo.DepartmentID = " + user.DepartmentID;
}
else if (user.RoleID == "4")
{
where += " and (DepartmentalAudit = 1 or DepartmentalAudit = 0) and GeneralManagerAudit = 3 and RoleID != " + user.RoleID;
}
else if (user.RoleID == "5")
{
where += " and ManagerAudit =3 and (GeneralManagerAudit = 1 or GeneralManagerAudit =0) ";
}
string sql = "select * from (select ROW_NUMBER() over(order by Leave.LeaveTime desc) rowindex,Leave.*,UserInfo.UserName,UserInfo.UserTel,Department.DepartmentName from Leave inner join UserInfo on Leave.UserID = UserInfo.UserID inner join Department on UserInfo.DepartmentID=Department.DepartmentID inner join OvertineCheck on Leave.LeaveID = OvertineCheck.LeaveID where 1 = 1 " + where + ") a where rowindex between " + (offset + 1) + " and " + (pageSize + offset) + " order by LeaveTime desc";
#region 查询行数
string sql2 = " select COUNT(Leave.LeaveID) from Leave inner join UserInfo on Leave.UserID = UserInfo.UserID inner join OvertineCheck on Leave.LeaveID = OvertineCheck.LeaveID where 1=1 " + where;
count = (DBHelper.GetSelect(sql2)).Rows[0][0].ToString();
#endregion
return(DBHelper.GetSelect(sql));
}
/// <summary>
/// 查询请假记录
/// </summary>
/// <returns></returns>
public DataTable selectLeaveLoc(int offset, int pageSize, string LeaveStartTime, string LeaveEndTime, MODEL.UserInfo user, out string count)
{
string where = "";
if (!string.IsNullOrEmpty(user.UserName))
{
where += " and UserName like '%" + user.UserName + "%' ";
}
if (!string.IsNullOrEmpty(user.DepartmentID))
{
where += " and UserInfo.DepartmentID = " + user.DepartmentID;
}
string sql = "select * from (select ROW_NUMBER() over(order by Leave.LeaveTime desc) rowindex,Leave.*,UserInfo.UserName,UserInfo.UserTel,Department.DepartmentName from Leave inner join UserInfo on Leave.UserID = UserInfo.UserID inner join Department on UserInfo.DepartmentID=Department.DepartmentID where 1 = 1 " + where + " ) a where rowindex between " + (offset + 1) + " and " + (pageSize + offset) + " order by LeaveID desc";
#region 查询行数
string sql2 = " select COUNT(LeaveID) from Leave inner join UserInfo on Leave.UserID = UserInfo.UserID where LeaveState = 1 " + where;
count = (DBHelper.GetSelect(sql2)).Rows[0][0].ToString();
#endregion
return(DBHelper.GetSelect(sql));
}
/// <summary>
/// 查询请假申请
/// </summary>
/// <returns></returns>
public DataTable selectLeave(int offset, int pageSize, string LeaveStartTime, string LeaveEndTime, MODEL.UserInfo user, out string count)
{
string where = "";
where += " and Leave.UserID = " + user.UserID;
//if (user.RoleID == "1" || user.RoleID == "3")
//{
//}
//else if(user.RoleID == "2")
//{
// where += " and DepartmentID = " + user.DepartmentID;
//}
string sql = "select * from ( select ROW_NUMBER() over(order by LeaveID desc) rowindex ,* from (select Leave.*,UserInfo.UserName,UserInfo.UserTel from Leave inner join UserInfo on Leave.UserID = UserInfo.UserID where 1=1 " + where + ") a inner join (select * from CategoryItems where C_Category ='LeaveState') b on a.LeaveState = b.CI_ID) c inner join OvertineCheck on c.LeaveID = OvertineCheck.LeaveID where rowindex between " + (offset + 1) + " and " + (pageSize + offset) + " order by c.LeaveID desc";
#region 查询行数
string sql2 = " select COUNT(LeaveID) from Leave inner join UserInfo on Leave.UserID = UserInfo.UserID where 1=1 " + where;
count = (DBHelper.GetSelect(sql2)).Rows[0][0].ToString();
#endregion
return(DBHelper.GetSelect(sql));
}
