|
|
using NetLibrary.Data;
|
|
|
using System;
|
|
|
using System.Collections.Generic;
|
|
|
using System.Data;
|
|
|
using System.Linq;
|
|
|
using System.Web;
|
|
|
using System.Web.Services;
|
|
|
using TradeData;
|
|
|
using NetLibrary;
|
|
|
using TradeModel;
|
|
|
using NetLibrary.Express;
|
|
|
using System.Web.Script.Serialization;
|
|
|
using NetLibrary.ReportPrint;
|
|
|
using NetLibrary.OnlineTrade;
|
|
|
using System.Text;
|
|
|
|
|
|
namespace TradeManage.SysManage
|
|
|
{
|
|
|
/// <summary>
|
|
|
/// OA_Manage 的摘要说明
|
|
|
/// </summary>
|
|
|
[WebService(Namespace = "http://tempuri.org/")]
|
|
|
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
|
|
|
[System.ComponentModel.ToolboxItem(false)]
|
|
|
// 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消注释以下行。
|
|
|
[System.Web.Script.Services.ScriptService]
|
|
|
public class OA_Manage : System.Web.Services.WebService
|
|
|
{
|
|
|
|
|
|
[WebMethod]
|
|
|
public string HelloWorld()
|
|
|
{
|
|
|
return "Hello World";
|
|
|
}
|
|
|
#region 保存请假
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public string SaveLeave(OA_Leave model)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
if (model.InDate == null)
|
|
|
model.InDate = DateTime.Now;
|
|
|
|
|
|
if (model.LeaveType == "运动(生理假)")
|
|
|
{
|
|
|
if (obj.CheckLeave(model.InUserId.GetValueOrDefault(0), model.SDate.Value) > 0) return "本月运动假已经请过了，不能申请";
|
|
|
}
|
|
|
//if (model.LeaveType == "心情假")
|
|
|
//{
|
|
|
// if (obj.CheckLeaveM(model) > 0) return -2;
|
|
|
//}
|
|
|
//if (model.LeaveType == "年假")
|
|
|
//{
|
|
|
// if (obj.CheckLeaveN(model) > 0) return -3;
|
|
|
//}
|
|
|
string messdata = "提交成功";
|
|
|
if (model.SDate != null)
|
|
|
{
|
|
|
if (model.SDate <= DateTime.Now || model.SDate.Value.ToString("yyyy-MM-dd") == DateTime.Today.ToString("yyyy-MM-dd"))
|
|
|
{
|
|
|
messdata = "提交成功，以后请假请注意必须提早一天请假";
|
|
|
}
|
|
|
}
|
|
|
int a = obj.SaveLeave(model);
|
|
|
string Content = model.InName + "有一个请假" + model.Days +model.DaysUint+"申请需要你审批,请尽快在请假管理里审批";
|
|
|
JC_OpenMess mess=new JC_OpenMess();
|
|
|
if(model.DeptUserId>0)
|
|
|
mess.UserId=model.DeptUserId;
|
|
|
else if(model.CompanyUserId>0)
|
|
|
mess.UserId=model.CompanyUserId;
|
|
|
else if (model.ManageUserId > 0)
|
|
|
mess.UserId = model.ManageUserId;
|
|
|
mess.UserType="p";
|
|
|
mess.Content=Content;
|
|
|
mess.IsRead=0;
|
|
|
mess.OpenDate=DateTime.Now;
|
|
|
|
|
|
BaseService.SaveOpenMess(mess);
|
|
|
return messdata;
|
|
|
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#region 保存加班
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public int SaveWorkAdd(OA_WorkAdd model)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
if (model.InDate == null)
|
|
|
model.InDate = DateTime.Now;
|
|
|
|
|
|
int a = obj.SaveWorkAdd(model);
|
|
|
string Content = model.InName + "有一个加申请需要你审批,请尽快在加班管理里审批";
|
|
|
JC_OpenMess mess = new JC_OpenMess();
|
|
|
if (model.DeptUserId > 0)
|
|
|
mess.UserId = model.DeptUserId;
|
|
|
else if (model.CompanyUserId > 0)
|
|
|
mess.UserId = model.CompanyUserId;
|
|
|
mess.UserType = "p";
|
|
|
mess.Content = Content;
|
|
|
mess.IsRead = 0;
|
|
|
mess.OpenDate = DateTime.Now;
|
|
|
|
|
|
BaseService.SaveOpenMess(mess);
|
|
|
return a;
|
|
|
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 请假
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public OA_Leave GetLeaveModel(int Id)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
OA_Leave model = null;
|
|
|
|
|
|
model = obj.GetLeaveModel(Id);
|
|
|
|
|
|
return model;
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 删除加班
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public void DeleteWorkAdd(int Id)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
|
|
|
|
|
|
var obj = new BaseService();
|
|
|
obj.DeleteWorkAdd(Id);
|
|
|
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 删除请假
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public void DeleteLeave(int Id)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
obj.DeleteLeave(Id);
|
|
|
|
|
|
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 加班
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public OA_WorkAdd GetWorkAddModel(int Id)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
OA_WorkAdd model = null;
|
|
|
|
|
|
model = obj.GetWorkAddModel(Id);
|
|
|
|
|
|
return model;
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 保存请假部门审批
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public int SaveLeaveDeptCheck(OA_Leave model)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
if (model.DeptAgree == 0)
|
|
|
{
|
|
|
model.State = 2;
|
|
|
model.CompanyUserId = null;
|
|
|
}
|
|
|
int a = obj.SaveLeaveCheck(model);
|
|
|
|
|
|
|
|
|
int UserId = 0;
|
|
|
|
|
|
string MessContent = "";
|
|
|
if (model.State == 1)
|
|
|
{
|
|
|
|
|
|
|
|
|
UserId = model.CompanyUserId.Value;
|
|
|
|
|
|
MessContent = model.InName + "有一个请假" + model.Days +model.DaysUint + "申请需要你审批,请尽快在请假管理里审批";
|
|
|
}
|
|
|
else if (model.State == 2)
|
|
|
{
|
|
|
UserId = model.InUserId.Value;
|
|
|
if (model.DeptAgree == 1)
|
|
|
{
|
|
|
|
|
|
MessContent = "部门经理已经批准了你的请假申请";
|
|
|
}
|
|
|
else
|
|
|
if (model.DeptAgree == 0)
|
|
|
{
|
|
|
|
|
|
MessContent = "部门经理没有同意你的请假申请";
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
JC_OpenMess mess = new JC_OpenMess();
|
|
|
|
|
|
mess.UserId = UserId;
|
|
|
mess.UserType = "p";
|
|
|
mess.Content = MessContent;
|
|
|
mess.IsRead = 0;
|
|
|
mess.OpenDate = DateTime.Now;
|
|
|
|
|
|
BaseService.SaveOpenMess(mess);
|
|
|
//if (model.Days>4&&model.DaysUint=="天")
|
|
|
//{
|
|
|
// JC_OpenMess mess1 = new JC_OpenMess();
|
|
|
|
|
|
// mess1.UserId = 1;
|
|
|
// mess1.UserType = "p";
|
|
|
// mess1.Content = MessContent;
|
|
|
// mess1.IsRead = 0;
|
|
|
// mess1.OpenDate = DateTime.Now;
|
|
|
|
|
|
// BaseService.SaveOpenMess(mess1);
|
|
|
//}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
return a;
|
|
|
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 保存加班部门审批
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public int SaveWorkAddDeptCheck(OA_WorkAdd model)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
|
|
|
int a = obj.SaveWorkAddCheck(model);
|
|
|
|
|
|
|
|
|
int UserId = 0;
|
|
|
|
|
|
string MessContent = "";
|
|
|
if (model.State == 1)
|
|
|
{
|
|
|
|
|
|
|
|
|
UserId = model.CompanyUserId.Value;
|
|
|
|
|
|
MessContent = model.InName + "有一个加班申请需要你审批,请尽快在加班管理里审批";
|
|
|
}
|
|
|
else if (model.State == 2)
|
|
|
{
|
|
|
UserId = model.InUserId.Value;
|
|
|
if (model.DeptAgree == 1)
|
|
|
{
|
|
|
|
|
|
MessContent = "部门经理已经批准了你的一个加班" + model.Days + "小时的申请";
|
|
|
}
|
|
|
else
|
|
|
if (model.DeptAgree == 0)
|
|
|
{
|
|
|
|
|
|
MessContent = "部门经理没有同意你的一个加班" + model.Days + "小时的申请";
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
JC_OpenMess mess = new JC_OpenMess();
|
|
|
|
|
|
mess.UserId = UserId;
|
|
|
mess.UserType = "p";
|
|
|
mess.Content = MessContent;
|
|
|
mess.IsRead = 0;
|
|
|
mess.OpenDate = DateTime.Now;
|
|
|
|
|
|
BaseService.SaveOpenMess(mess);
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
return a;
|
|
|
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 保存加班公司审批
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public int SaveWorkAddCompanyCheck(OA_WorkAdd model)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
|
|
|
model.State = 2;
|
|
|
int a = obj.SaveWorkAddCompanyCheck(model);
|
|
|
|
|
|
|
|
|
int UserId = 0;
|
|
|
|
|
|
string MessContent = "";
|
|
|
UserId = model.InUserId.Value;
|
|
|
if (model.CompanyAgree == 1)
|
|
|
{
|
|
|
|
|
|
MessContent = "领导批准了你的一个加班申请";
|
|
|
}
|
|
|
else
|
|
|
if (model.CompanyAgree == 0)
|
|
|
{
|
|
|
|
|
|
MessContent = "领导没有同意你的一个加班申请";
|
|
|
}
|
|
|
|
|
|
|
|
|
JC_OpenMess mess = new JC_OpenMess();
|
|
|
|
|
|
mess.UserId = UserId;
|
|
|
mess.UserType = "p";
|
|
|
mess.Content = MessContent;
|
|
|
mess.IsRead = 0;
|
|
|
mess.OpenDate = DateTime.Now;
|
|
|
|
|
|
BaseService.SaveOpenMess(mess);
|
|
|
|
|
|
|
|
|
return a;
|
|
|
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 批量保存请假公司审批
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public string SaveLeaveCompanyCheckList(string userlist)
|
|
|
{
|
|
|
var UserName = Session["Name"].ToString();
|
|
|
int UserId = Convert.ToInt32(Session["UserId"]);
|
|
|
string[] inuser = userlist.Trim(',').Split(',');
|
|
|
string str="";
|
|
|
var obj = new BaseService();
|
|
|
for (int i = 0; i < inuser.Length; i++)
|
|
|
{
|
|
|
OA_Leave model = new OA_Leave();
|
|
|
model.InUserId =Convert.ToInt32( inuser[i]);
|
|
|
model.CompanyUserId = UserId;
|
|
|
model.CompanyAgree = 1;
|
|
|
model.CompanyOption = "<font color='Red'>" + "准假" + "</font><br/><br/><br/><br/>签名：" + UserName + " 日期：" + DateTime.Now;
|
|
|
int result = obj.SaveCompanyCheckUser(model);
|
|
|
if (result <= 0) str += "失败：" + inuser[i];
|
|
|
}
|
|
|
|
|
|
if (str == "")
|
|
|
return "成功";
|
|
|
else return str;
|
|
|
}
|
|
|
#endregion
|
|
|
#region 保存请假公司审批
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public int SaveLeaveCompanyCheck(OA_Leave model)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
|
|
|
model.State = 2;
|
|
|
int a = obj.SaveCompanyCheck(model);
|
|
|
|
|
|
|
|
|
int UserId = 0;
|
|
|
|
|
|
string MessContent = "";
|
|
|
UserId = model.InUserId.Value;
|
|
|
if (model.CompanyAgree == 1)
|
|
|
{
|
|
|
|
|
|
MessContent = "领导批准了你的一个请假" + model.Days +model.DaysUint+ "的申请";
|
|
|
}
|
|
|
else
|
|
|
if (model.CompanyAgree == 0)
|
|
|
{
|
|
|
|
|
|
MessContent = "领导没有同意你的一个请假" + model.Days + model.DaysUint +"的申请";
|
|
|
}
|
|
|
|
|
|
|
|
|
JC_OpenMess mess = new JC_OpenMess();
|
|
|
|
|
|
mess.UserId = UserId;
|
|
|
mess.UserType = "p";
|
|
|
mess.Content = MessContent;
|
|
|
mess.IsRead = 0;
|
|
|
mess.OpenDate = DateTime.Now;
|
|
|
|
|
|
BaseService.SaveOpenMess(mess);
|
|
|
|
|
|
|
|
|
return a;
|
|
|
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 保存请假公司审批
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public int SaveLeaveCompanyCheck2(OA_Leave model)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
|
|
|
// model.State = 2;
|
|
|
if (model.CompanyAgree == 0)
|
|
|
{
|
|
|
model.State = 2;
|
|
|
model.ManageUserId = null;
|
|
|
}
|
|
|
int a = obj.SaveCompanyCheck1(model);
|
|
|
|
|
|
|
|
|
int UserId = 0;
|
|
|
|
|
|
|
|
|
UserId = model.InUserId.Value;
|
|
|
string MessContent = "";
|
|
|
if (model.State == 1)
|
|
|
{
|
|
|
|
|
|
|
|
|
UserId = model.ManageUserId.Value;
|
|
|
|
|
|
MessContent = model.InName + "有一个请假" + model.Days + model.DaysUint +"申请需要你审批,请尽快在请假管理里审批";
|
|
|
}
|
|
|
else if (model.State == 2)
|
|
|
{
|
|
|
UserId = model.InUserId.Value;
|
|
|
if (model.CompanyAgree == 1)
|
|
|
{
|
|
|
|
|
|
MessContent = "副总已经批准了你的请假申请";
|
|
|
}
|
|
|
else
|
|
|
if (model.CompanyAgree == 0)
|
|
|
{
|
|
|
|
|
|
MessContent = "副总没有同意你的请假申请";
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
JC_OpenMess mess = new JC_OpenMess();
|
|
|
|
|
|
mess.UserId = UserId;
|
|
|
mess.UserType = "p";
|
|
|
mess.Content = MessContent;
|
|
|
mess.IsRead = 0;
|
|
|
mess.OpenDate = DateTime.Now;
|
|
|
|
|
|
BaseService.SaveOpenMess(mess);
|
|
|
|
|
|
|
|
|
return a;
|
|
|
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 保存请假总经理审批
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public int SaveLeaveManageCheck(OA_Leave model)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
|
|
|
model.State = 2;
|
|
|
|
|
|
int a = obj.SaveMangeCheck(model);
|
|
|
|
|
|
|
|
|
int UserId = 0;
|
|
|
|
|
|
string MessContent = "";
|
|
|
UserId = model.InUserId.Value;
|
|
|
if (model.ManageAgree == 1)
|
|
|
{
|
|
|
|
|
|
MessContent = "总经理批准了你的一个请假" + model.Days +model.DaysUint+ "的申请";
|
|
|
}
|
|
|
else
|
|
|
if (model.ManageAgree == 0)
|
|
|
{
|
|
|
|
|
|
MessContent = "总经理没有同意你的一个请假" + model.Days +model.DaysUint+ "的申请";
|
|
|
}
|
|
|
|
|
|
|
|
|
JC_OpenMess mess = new JC_OpenMess();
|
|
|
|
|
|
mess.UserId = UserId;
|
|
|
mess.UserType = "p";
|
|
|
mess.Content = MessContent;
|
|
|
mess.IsRead = 0;
|
|
|
mess.OpenDate = DateTime.Now;
|
|
|
|
|
|
BaseService.SaveOpenMess(mess);
|
|
|
|
|
|
|
|
|
return a;
|
|
|
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#region 分页查询请假列表
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
|
|
|
public JsonModel<List<OA_Leave>> GetListOA_Leave(int Type, int State, string LeaveType, DateTime? Sdate, DateTime? Edate, string Title, int PageIndex, int PageSize)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
|
|
|
int UserId = Convert.ToInt32(Session["UserId"]);
|
|
|
var obj = new BaseService();
|
|
|
|
|
|
RefParameterCollection Param = new RefParameterCollection();
|
|
|
|
|
|
|
|
|
string Sort = "Id desc";
|
|
|
if (State > -1)
|
|
|
Param.Add("State", "=", State, DbType.Int32);
|
|
|
if (LeaveType!="0")
|
|
|
Param.Add("LeaveType", "=", LeaveType, DbType.Int32);
|
|
|
|
|
|
if (Title != "")
|
|
|
{
|
|
|
Param.Add("(InName", "like", Title, DbType.String);
|
|
|
Param.Add("Reason", "like", Title, "or", ")", DbType.String);
|
|
|
}
|
|
|
if (Type == 0)
|
|
|
{
|
|
|
|
|
|
Param.Add("(InUserId", "=", UserId, DbType.Int32);
|
|
|
Param.Add("ManageUserId", "=", UserId, "or", DbType.Int32);
|
|
|
Param.Add("DeptUserId", "=", UserId, "or", DbType.Int32);
|
|
|
Param.Add("CompanyUserId", "=", UserId, "or", ")", DbType.Int32);
|
|
|
|
|
|
|
|
|
}
|
|
|
else
|
|
|
if (Type == 1)
|
|
|
{
|
|
|
Param.Add("InUserId", "=", UserId, DbType.Int32);
|
|
|
|
|
|
|
|
|
}
|
|
|
else
|
|
|
if (Type == 2)
|
|
|
{
|
|
|
if (UserId == 1)
|
|
|
{
|
|
|
Param.Add("ManageUserId", "=", UserId, DbType.Int32);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
Param.Add("(DeptUserId", "=", UserId, "or", DbType.Int32);
|
|
|
Param.Add("CompanyUserId", "=", UserId, "or", ")", DbType.Int32);
|
|
|
}
|
|
|
|
|
|
}
|
|
|
if (Sdate != null)
|
|
|
Param.Add("SDate", ">=", Sdate, DbType.DateTime);
|
|
|
if (Edate != null)
|
|
|
Param.Add("EDate", "<", Edate.Value.AddDays(1), DbType.DateTime);
|
|
|
JsonModel<List<OA_Leave>> resultModel = new JsonModel<List<OA_Leave>>();
|
|
|
|
|
|
int RowCount = 0;
|
|
|
|
|
|
|
|
|
resultModel.DataSource = obj.GetListOA_Leave(Param, PageIndex, PageSize, Sort, out RowCount);
|
|
|
|
|
|
resultModel.RowCount = RowCount;
|
|
|
if (resultModel.DataSource != null)
|
|
|
{
|
|
|
foreach (var models in resultModel.DataSource)
|
|
|
{
|
|
|
|
|
|
if (models.DeptUserId == UserId && models.State == 0)
|
|
|
{
|
|
|
models.DoState = "审批";
|
|
|
|
|
|
}
|
|
|
else if (models.CompanyUserId == UserId && models.State < 2)
|
|
|
{
|
|
|
models.DoState = "审批";
|
|
|
|
|
|
}
|
|
|
else if (models.ManageUserId == UserId && models.State < 2)
|
|
|
{
|
|
|
models.DoState = "审批";
|
|
|
|
|
|
}
|
|
|
else
|
|
|
models.DoState = "查看";
|
|
|
|
|
|
}
|
|
|
}
|
|
|
|
|
|
return resultModel;
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 分页查询加班列表
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
|
|
|
public JsonModel<List<OA_WorkAdd>> GetListOA_WorkAdd(int Type, int State, DateTime? Sdate, DateTime? Edate, string Title, int PageIndex, int PageSize)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
|
|
|
int UserId = Convert.ToInt32(Session["UserId"]);
|
|
|
var obj = new BaseService();
|
|
|
|
|
|
RefParameterCollection Param = new RefParameterCollection();
|
|
|
|
|
|
|
|
|
string Sort = "Id desc";
|
|
|
if (State > -1)
|
|
|
Param.Add("State", "=", State, DbType.Int32);
|
|
|
|
|
|
if (Title != "")
|
|
|
{
|
|
|
Param.Add("(InName", "like", Title, DbType.String);
|
|
|
Param.Add("Reason", "like", Title, "or", ")", DbType.String);
|
|
|
}
|
|
|
if (Type == 0)
|
|
|
{
|
|
|
Param.Add("(InUserId", "=", UserId, DbType.Int32);
|
|
|
Param.Add("DeptUserId", "=", UserId, "or", DbType.Int32);
|
|
|
Param.Add("CompanyUserId", "=", UserId, "or", ")", DbType.Int32);
|
|
|
|
|
|
}
|
|
|
else
|
|
|
if (Type == 1)
|
|
|
{
|
|
|
Param.Add("InUserId", "=", UserId, DbType.Int32);
|
|
|
|
|
|
|
|
|
}
|
|
|
else
|
|
|
if (Type == 2)
|
|
|
{
|
|
|
|
|
|
Param.Add("(DeptUserId", "=", UserId, "or", DbType.Int32);
|
|
|
Param.Add("CompanyUserId", "=", UserId, "or", ")", DbType.Int32);
|
|
|
|
|
|
}
|
|
|
if (Sdate != null)
|
|
|
Param.Add("SDate", ">=", Sdate, DbType.DateTime);
|
|
|
if (Edate != null)
|
|
|
Param.Add("EDate", "<", Edate.Value.AddDays(1), DbType.DateTime);
|
|
|
JsonModel<List<OA_WorkAdd>> resultModel = new JsonModel<List<OA_WorkAdd>>();
|
|
|
|
|
|
int RowCount = 0;
|
|
|
|
|
|
|
|
|
resultModel.DataSource = obj.GetListOA_WorkAdd(Param, PageIndex, PageSize, Sort, out RowCount);
|
|
|
|
|
|
resultModel.RowCount = RowCount;
|
|
|
if (resultModel.DataSource != null)
|
|
|
{
|
|
|
foreach (var models in resultModel.DataSource)
|
|
|
{
|
|
|
|
|
|
if (models.DeptUserId == UserId && models.State == 0)
|
|
|
{
|
|
|
models.DoState = "审批";
|
|
|
|
|
|
}
|
|
|
else if (models.CompanyUserId == UserId && models.State < 2)
|
|
|
{
|
|
|
models.DoState = "审批";
|
|
|
|
|
|
}
|
|
|
else
|
|
|
models.DoState = "查看";
|
|
|
|
|
|
}
|
|
|
}
|
|
|
|
|
|
return resultModel;
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 查请假负责人
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
|
|
|
public List<OA_DeptCharge> GetLeaveCharge(int UserId)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
|
|
|
var obj = new BaseService();
|
|
|
|
|
|
|
|
|
var list = obj.GetLeaveCharge(UserId);
|
|
|
|
|
|
return list;
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 查副总经理
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
|
|
|
public List<OA_DeptCharge> GetLeaveMasterCharge()
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
|
|
|
var list = obj.GetLeaveMasterCharge();
|
|
|
|
|
|
return list;
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 请假统计
|
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public List<OA_Leave> GetLeaveCount(DateTime? SDate, DateTime? EDate,string LeaveType,int CheckState)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
if (EDate != null)
|
|
|
EDate = EDate.Value.AddDays(1);
|
|
|
var list = obj.GetLeaveCount(SDate, EDate,LeaveType, CheckState);
|
|
|
|
|
|
return list;
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 请假统计
|
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public List<OA_Leave> GetLeaveCountInfo(int UserId, DateTime? SDate, DateTime? EDate, string LeaveType, int CheckState)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
if (EDate != null)
|
|
|
EDate = EDate.Value.AddDays(1);
|
|
|
var list = obj.GetLeaveCountInfo(UserId, SDate, EDate,LeaveType, CheckState);
|
|
|
|
|
|
return list;
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#region 未审批请假统计
|
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public List<OA_Leave> GetNoLeaveCount(DateTime? SDate, DateTime? EDate, string LeaveType, int CheckState)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
int UserId = Convert.ToInt32(Session["UserId"]);
|
|
|
var obj = new BaseService();
|
|
|
if (EDate != null)
|
|
|
EDate = EDate.Value.AddDays(1);
|
|
|
var list = obj.GetNoLeaveCount(UserId, SDate, EDate, LeaveType, CheckState);
|
|
|
|
|
|
return list;
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 未审批请假统计
|
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public List<OA_Leave> GetNoReLeave(int UserId, DateTime? SDate, DateTime? EDate, string LeaveType, int CheckState)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
if (EDate != null)
|
|
|
EDate = EDate.Value.AddDays(1);
|
|
|
var list = obj.GetNoReLeave(UserId, SDate, EDate, LeaveType, CheckState);
|
|
|
|
|
|
return list;
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 加班统计
|
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public List<OA_WorkAdd> GetWorkAddCount(DateTime? SDate, DateTime? EDate, int CheckState)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
if (EDate != null)
|
|
|
EDate = EDate.Value.AddDays(1);
|
|
|
var list = obj.GetWorkAddCount(SDate, EDate, CheckState);
|
|
|
|
|
|
return list;
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 加班统计
|
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public List<OA_WorkAdd> GetWorkAddCountInfo(int UserId, DateTime? SDate, DateTime? EDate, int CheckState)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
if (EDate != null)
|
|
|
EDate = EDate.Value.AddDays(1);
|
|
|
var list = obj.GetWorkAddCountInfo(UserId, SDate, EDate, CheckState);
|
|
|
|
|
|
return list;
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 工资单
|
|
|
|
|
|
#region 导出工资单模版
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public string ExportSalary()
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
|
|
|
DataTable dt = new DataTable();
|
|
|
dt.Columns.Add("姓名", typeof(string));
|
|
|
dt.Columns.Add("项目1", typeof(string));
|
|
|
dt.Columns.Add("项目2", typeof(string));
|
|
|
dt.Columns.Add("项目3", typeof(string));
|
|
|
dt.Columns.Add("项目4", typeof(string));
|
|
|
dt.Columns.Add("项目5", typeof(string));
|
|
|
dt.Columns.Add("合计", typeof(string));
|
|
|
|
|
|
DataRow dr = null;
|
|
|
Random r = new Random();
|
|
|
|
|
|
for (int i = 0; i < 9; i++)
|
|
|
{
|
|
|
dr = dt.NewRow();
|
|
|
|
|
|
dr["姓名"] = "教师00" + (i + 1).ToString();
|
|
|
dr["项目1"] = Convert.ToDouble(r.Next(0, 100));
|
|
|
dr["项目2"] = Convert.ToDouble(r.Next(0, 100));
|
|
|
dr["项目3"] = Convert.ToDouble(r.Next(0, 100));
|
|
|
dr["项目4"] = Convert.ToDouble(r.Next(0, 100));
|
|
|
dr["项目5"] = Convert.ToDouble(r.Next(0, 100));
|
|
|
dr["合计"] = Convert.ToDouble(dr["项目1"]) + Convert.ToDouble(dr["项目2"]) + Convert.ToDouble(dr["项目3"]) + Convert.ToDouble(dr["项目4"]) + Convert.ToDouble(dr["项目5"]);
|
|
|
|
|
|
dt.Rows.Add(dr);
|
|
|
}
|
|
|
|
|
|
TableColumnCollection listColumns = new TableColumnCollection();
|
|
|
listColumns.Add("姓名", "姓名", DbType.String, "");
|
|
|
listColumns.Add("项目1", "项目1", DbType.String, "");
|
|
|
listColumns.Add("项目2", "项目2", DbType.String, "");
|
|
|
listColumns.Add("项目3", "项目3", DbType.String, "");
|
|
|
listColumns.Add("项目4", "项目4", DbType.String, "");
|
|
|
listColumns.Add("项目5", "项目5", DbType.String, "");
|
|
|
listColumns.Add("合计", "合计", DbType.String, "");
|
|
|
|
|
|
return new MicrosoftExcel().Export(dt, listColumns);
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#region 导入某个月工资单
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public string ImportSalary(string FileName, int SYear, int SMonth, string SalaryName, int SendSMS, int Hj)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
if (string.IsNullOrEmpty(FileName) == true) return "要导入的文件路径不能为空";
|
|
|
string ServerFileName = AppDomain.CurrentDomain.BaseDirectory + FileName;
|
|
|
if (System.IO.File.Exists(ServerFileName) == false) return "要导入的文件路径不存在";
|
|
|
|
|
|
try
|
|
|
{
|
|
|
|
|
|
MicrosoftExcel excel = new MicrosoftExcel();
|
|
|
DataTable tb = excel.ImportExcel(ServerFileName);
|
|
|
BaseService obj = new BaseService();
|
|
|
string error = "";
|
|
|
if (tb == null || tb.Columns.Count <= 1)
|
|
|
{
|
|
|
error = "导入模板不正确，模板第一行必须为姓名和工资项目，请重新下载模板导入";
|
|
|
return error;
|
|
|
}
|
|
|
if (tb != null && tb.Rows.Count > 0)
|
|
|
{
|
|
|
if (tb.Columns.Count > 0 && tb.Columns[0].ColumnName.Replace(" ", "").Contains("姓名") == false)
|
|
|
{
|
|
|
error = "导入模板的第一列必须为 姓名 列，请重新下载模板导入";
|
|
|
return error;
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
DateTime sdate = DateTime.Now;
|
|
|
obj.deleteSalaryName(SalaryName);//删除原先数据
|
|
|
int tempcount = 0;
|
|
|
for (int j = 0; j < tb.Rows.Count; j++)
|
|
|
{
|
|
|
string UserName = tb.Rows[j][0].ToString().Trim().Replace(" ", "");
|
|
|
if(tb.Rows[j][0].ToString().Trim().Replace(" ", "").Contains("姓名")&&j!=0)
|
|
|
{
|
|
|
tempcount = j;
|
|
|
continue;
|
|
|
|
|
|
}
|
|
|
//obj.IsSalaryName(UserName, SalaryName);//删除原先数据
|
|
|
string name = "";
|
|
|
|
|
|
for (int i = 1; i < tb.Columns.Count; i++)
|
|
|
{
|
|
|
if(tb.Rows[j][0].ToString().Trim().Replace(" ", "")=="")
|
|
|
{
|
|
|
continue;
|
|
|
}
|
|
|
GZ_SalaryInfo model = new GZ_SalaryInfo();
|
|
|
model.InDate = sdate;
|
|
|
model.SYear = SYear;
|
|
|
model.SDate = sdate;
|
|
|
model.SMonth = SMonth;
|
|
|
//if(Hj==0)
|
|
|
//model.UserIndex=1;
|
|
|
//else
|
|
|
model.UserIndex = 0;
|
|
|
//if (i == tb.Columns.Count - 1 && Hj == 1)
|
|
|
// model.UserIndex = 1;
|
|
|
//else
|
|
|
// if (i == tb.Columns.Count - 1 && Hj == 0)
|
|
|
// model.UserIndex = 2;
|
|
|
model.InUserId = Convert.ToInt32(Session["UserId"]);
|
|
|
model.InUserName = Session["Name"].ToString();
|
|
|
model.ItemIndex = i;
|
|
|
if (tempcount==0)
|
|
|
model.ItemName = tb.Columns[i].ColumnName.Trim().Replace(" ", "");
|
|
|
else
|
|
|
model.ItemName = tb.Rows[tempcount][i].ToString().Trim().Replace(" ", "");
|
|
|
|
|
|
model.SalaryName = SalaryName;
|
|
|
model.UserName = tb.Rows[j][0].ToString().Trim().Replace(" ", "");
|
|
|
if (name == model.UserName)
|
|
|
{
|
|
|
continue;
|
|
|
}
|
|
|
if (tb.Rows[j][i].ToString().Trim() != "")
|
|
|
{
|
|
|
try
|
|
|
{
|
|
|
model.ItemValue = Convert.ToDecimal(tb.Rows[j][i].ToString().Trim());
|
|
|
}
|
|
|
catch
|
|
|
{
|
|
|
error += model.UserName + "的【" + model.ItemName + "】值不是数字格式，请确定该项数值是否填写正确<br/>";
|
|
|
}
|
|
|
}
|
|
|
else
|
|
|
model.ItemValue = 0;
|
|
|
|
|
|
int id = obj.SaveSalaryInfo(model);
|
|
|
if (id == -1)
|
|
|
{
|
|
|
name = model.UserName;
|
|
|
error += "名字【" + model.UserName + "】的在数据库中不存在，请确定名字是否平台员工名字一致，注意名字中间是否有空格<br/>";
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
if (error == "")
|
|
|
error = "数据导入成功";
|
|
|
else
|
|
|
error += "其它教师数据均导入成功<br/>";
|
|
|
|
|
|
}
|
|
|
|
|
|
return error;
|
|
|
}
|
|
|
catch (Exception e)
|
|
|
{
|
|
|
return "导入失败;" + e.Message.ToString() + "请确定导入模块是否正确,或者重新下载模块导入";
|
|
|
}
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
|
|
|
#region 查询单个用户
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public string GZ_GetOneUser(int SYear, int SMonth, string PassWord)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
int UserId = Convert.ToInt32(Session["UserId"]);
|
|
|
|
|
|
int checkdata = obj.IsUser(UserId, PassWord);
|
|
|
if (checkdata <=0)
|
|
|
{
|
|
|
return "密码不正确！";
|
|
|
}
|
|
|
|
|
|
string html = "";
|
|
|
|
|
|
if (SMonth > 0)
|
|
|
{
|
|
|
var list = obj.GetMySalaryInfoList(SYear, SMonth, UserId);
|
|
|
if (list != null && list.Count>0)
|
|
|
{
|
|
|
|
|
|
html += "<table border='1' cellpadding='0' cellspacing='0' style='width:99%;' class='tableAll'><tr><td colspan='" + list.Count + "'>" + list[0].SalaryName + "</td></tr><tr>";
|
|
|
string tr1 = "<tr>";
|
|
|
string tr2 = "<tr>";
|
|
|
foreach (var md in list)
|
|
|
{
|
|
|
tr1 += "<td class='f1' style='background-color:lightgray'>" + md.ItemName + "</td>";
|
|
|
if (md.ItemName == "总计")
|
|
|
{
|
|
|
string total = list.Where(o => o.UserId == md.UserId && o.ItemName != "总计" && o.ItemIndex < 13 && o.ItemName != "社保公司缴纳").Sum(o => o.ItemValue).ToString();
|
|
|
tr2 += "<td>" + total + "</td>";
|
|
|
}
|
|
|
else
|
|
|
tr2 += "<td>" + md.ItemValue + "</td>";
|
|
|
|
|
|
}
|
|
|
tr1 += "</tr>";
|
|
|
tr2 += "</tr>";
|
|
|
html+=tr1+tr2+"</table>";
|
|
|
}
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
var ylist = obj.GetAllSalaryYear(UserId,SYear);
|
|
|
if (ylist != null)
|
|
|
{
|
|
|
foreach(var ymd in ylist)
|
|
|
{
|
|
|
var list = obj.GetMySalaryInfoList(ymd.SYear.Value, ymd.SMonth.Value, UserId);
|
|
|
if (list != null&& list.Count>0)
|
|
|
{
|
|
|
html += "<table border='1' cellpadding='0' cellspacing='0' style='width:99%;' class='tableAll'><tr><td colspan='" + list.Count + "'>" + list[0].SalaryName + "</td></tr><tr>";
|
|
|
string tr1 = "<tr>";
|
|
|
string tr2 = "<tr>";
|
|
|
foreach (var md in list)
|
|
|
{
|
|
|
tr1 += "<td class='f1' style='background-color:lightgray'>" + md.ItemName + "</td>";
|
|
|
if (md.ItemName == "总计")
|
|
|
{
|
|
|
string total = list.Where(o => o.UserId == md.UserId && o.ItemName != "总计" && o.ItemIndex < 13 && o.ItemName != "社保公司缴纳").Sum(o => o.ItemValue).ToString();
|
|
|
tr2 += "<td>" + total + "</td>";
|
|
|
}
|
|
|
else
|
|
|
tr2 += "<td>" + md.ItemValue + "</td>";
|
|
|
|
|
|
}
|
|
|
tr1 += "</tr>";
|
|
|
tr2 += "</tr>";
|
|
|
html += tr1 + tr2 + "</table>";
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
return html;
|
|
|
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 查询
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public string GZ_GetAllUser(int SYear, int SMonth)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
|
|
|
|
|
|
string shtml = "";
|
|
|
var obj = new BaseService();
|
|
|
if (SMonth > 0)
|
|
|
{
|
|
|
var list = obj.GetAllSalaryInfoList(SYear, SMonth);
|
|
|
int userid = 0;
|
|
|
if (list != null && list.Count > 0)
|
|
|
{
|
|
|
|
|
|
string tr1 = "";
|
|
|
string tr2 = "";
|
|
|
foreach (var md in list)
|
|
|
{
|
|
|
if (userid != md.UserId)
|
|
|
{
|
|
|
if (userid > 0)
|
|
|
{
|
|
|
tr1 += "</tr>";
|
|
|
tr2 += "</tr>";
|
|
|
shtml += tr1 + tr2 + "</table>";
|
|
|
}
|
|
|
shtml += "<table border='1' cellpadding='0' cellspacing='0' style='width:99%;' class='tableAll'><tr><td colspan='" + list.Count + "'>" +md.UserName + "</td></tr><tr>";
|
|
|
tr1 = "<tr>";
|
|
|
tr2 = "<tr>";
|
|
|
}
|
|
|
tr1 += "<td class='f1' style='background-color:lightgray'>" + md.ItemName + "</td>";
|
|
|
if (md.ItemName=="总计")
|
|
|
{
|
|
|
string total = list.Where(o => o.UserId == md.UserId && o.ItemName != "总计" && o.ItemIndex < 13 && o.ItemName != "社保公司缴纳").Sum(o => o.ItemValue).ToString();
|
|
|
tr2 += "<td>" + total + "</td>";
|
|
|
}
|
|
|
else
|
|
|
tr2 += "<td>" + md.ItemValue + "</td>";
|
|
|
|
|
|
|
|
|
userid = md.UserId.Value;
|
|
|
}
|
|
|
tr1 += "</tr>";
|
|
|
tr2 += "</tr>";
|
|
|
shtml += tr1 + tr2 + "</table>";
|
|
|
}
|
|
|
}
|
|
|
|
|
|
|
|
|
return shtml;
|
|
|
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#region 查询我的工资
|
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public List<GZ_SalaryInfo> GetAllSalaryInfoList(int SYear, int SMonth, int EYear, int EMonth)
|
|
|
{
|
|
|
var obj = new BaseService();
|
|
|
|
|
|
var list = obj.GetAllSalaryInfoList(SYear, SMonth, EYear, EMonth);
|
|
|
|
|
|
return list;
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#region 导出我的工资
|
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public string ExcelDataST(int SYear, int SMonth, int EYear, int EMonth)
|
|
|
{
|
|
|
var obj = new BaseService();
|
|
|
int UserId = Convert.ToInt32(Session["UserId"]);
|
|
|
|
|
|
var list = obj.ExcelDataST(UserId, SYear, SMonth, EYear, EMonth);
|
|
|
List<GZ_Excel> param = new List<GZ_Excel>();
|
|
|
|
|
|
for (int i = 0; i < list.Count; i++)
|
|
|
{
|
|
|
GZ_Excel model = new GZ_Excel();
|
|
|
|
|
|
model.SalaryName = list[i].SalaryName;
|
|
|
model.Gwgz = list[i].ItemValue;
|
|
|
model.Xjgz = list[++i].ItemValue;
|
|
|
model.Jh = list[++i].ItemValue;
|
|
|
model.Jhljt = list[++i].ItemValue;
|
|
|
model.Sbbt = list[++i].ItemValue;
|
|
|
model.Gfbzrt = list[++i].ItemValue;
|
|
|
model.Shbt = list[++i].ItemValue;
|
|
|
model.Gwjt = list[++i].ItemValue;
|
|
|
model.Jglbt = list[++i].ItemValue;
|
|
|
model.Txfbt = list[++i].ItemValue;
|
|
|
model.Yfhj = list[++i].ItemValue;
|
|
|
model.Dkkhj = list[++i].ItemValue;
|
|
|
model.Kgjj = list[++i].ItemValue;
|
|
|
model.Kylj = list[++i].ItemValue;
|
|
|
model.Ksbj = list[++i].ItemValue;
|
|
|
model.Kybj = list[++i].ItemValue;
|
|
|
model.Sdshj = list[++i].ItemValue;
|
|
|
model.Sfhj = list[++i].ItemValue;
|
|
|
|
|
|
param.Add(model);
|
|
|
|
|
|
}
|
|
|
|
|
|
TableColumnCollection listColumns = new TableColumnCollection();
|
|
|
listColumns.Add("SalaryName", "工资单标题", DbType.String, "");
|
|
|
listColumns.Add("Gwgz", "薪级工资", DbType.Decimal, "");
|
|
|
listColumns.Add("Xjgz", "岗位工资", DbType.Decimal, "");
|
|
|
listColumns.Add("Jh", "教护10%", DbType.Decimal, "");
|
|
|
listColumns.Add("Jhljt", "教护龄津贴", DbType.Decimal, "");
|
|
|
listColumns.Add("Sbbt", "社保补贴", DbType.Decimal, "");
|
|
|
listColumns.Add("Gfbzrt", "国发班主任贴", DbType.Decimal, "");
|
|
|
listColumns.Add("Shbt", "生活补贴", DbType.Decimal, "");
|
|
|
listColumns.Add("Gwjt", "岗位津贴", DbType.Decimal, "");
|
|
|
listColumns.Add("Jglbt", "教工龄补贴", DbType.Decimal, "");
|
|
|
listColumns.Add("Txfbt", "通讯费补贴", DbType.Decimal, "");
|
|
|
listColumns.Add("Yfhj", "应发合计", DbType.Decimal, "");
|
|
|
listColumns.Add("Dkkhj", "代扣款合计", DbType.Decimal, "");
|
|
|
listColumns.Add("Kgjj", "扣公积金", DbType.Decimal, "");
|
|
|
listColumns.Add("Kylj", "扣养老金", DbType.Decimal, "");
|
|
|
listColumns.Add("Ksbj", "扣失保金", DbType.Decimal, "");
|
|
|
listColumns.Add("Kybj", "扣医保金", DbType.Decimal, "");
|
|
|
listColumns.Add("Sdshj", "所得税合计", DbType.Decimal, "");
|
|
|
listColumns.Add("Sfhj", "实发合计", DbType.Decimal, "");
|
|
|
|
|
|
|
|
|
MicrosoftExcel obj2 = new MicrosoftExcel();
|
|
|
return obj2.Export(param, listColumns);
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
|
|
|
|
|
|
#region 查询我的工资
|
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public List<GZ_SalaryInfo> GetUserSalaryInfoList(string salaryname)
|
|
|
{
|
|
|
var obj = new BaseService();
|
|
|
|
|
|
var list = obj.GetUserSalaryInfoList(salaryname);
|
|
|
decimal TotalValue = 0;
|
|
|
if (list != null && list.Count > 0)
|
|
|
{
|
|
|
foreach (var model in list)
|
|
|
{
|
|
|
if (model.ItemValue <= 0)
|
|
|
{
|
|
|
model.TotalGZ = "不计入总计";
|
|
|
|
|
|
}
|
|
|
else
|
|
|
model.TotalGZ = model.ItemValue.Value.ToString();
|
|
|
if (model.ItemValue != null)
|
|
|
TotalValue += model.ItemValue.Value;
|
|
|
|
|
|
}
|
|
|
list[0].TotalValue = TotalValue;
|
|
|
}
|
|
|
return list;
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#region 导出一期工资单
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public string ExcelSalary(string salaryname)
|
|
|
{
|
|
|
var obj = new BaseService();
|
|
|
List<GZ_SalaryInfo> list = obj.ExcelSalary(salaryname);
|
|
|
|
|
|
List<GZ_Excel> param = new List<GZ_Excel>();
|
|
|
|
|
|
for (int i = 0; i < list.Count; i++)
|
|
|
{
|
|
|
GZ_Excel model = new GZ_Excel();
|
|
|
|
|
|
model.UserName = list[i].UserName;
|
|
|
model.Gwgz = list[i].ItemValue;
|
|
|
model.Xjgz = list[++i].ItemValue;
|
|
|
model.Jh = list[++i].ItemValue;
|
|
|
model.Jhljt = list[++i].ItemValue;
|
|
|
model.Sbbt = list[++i].ItemValue;
|
|
|
model.Gfbzrt = list[++i].ItemValue;
|
|
|
model.Shbt = list[++i].ItemValue;
|
|
|
model.Gwjt = list[++i].ItemValue;
|
|
|
model.Jglbt = list[++i].ItemValue;
|
|
|
model.Txfbt = list[++i].ItemValue;
|
|
|
model.Yfhj = list[++i].ItemValue;
|
|
|
model.Dkkhj = list[++i].ItemValue;
|
|
|
model.Kgjj = list[++i].ItemValue;
|
|
|
model.Kylj = list[++i].ItemValue;
|
|
|
model.Ksbj = list[++i].ItemValue;
|
|
|
model.Kybj = list[++i].ItemValue;
|
|
|
model.Sdshj = list[++i].ItemValue;
|
|
|
model.Sfhj = list[++i].ItemValue;
|
|
|
|
|
|
param.Add(model);
|
|
|
|
|
|
}
|
|
|
|
|
|
TableColumnCollection listColumns = new TableColumnCollection();
|
|
|
listColumns.Add("UserName", "姓名", DbType.String, "");
|
|
|
listColumns.Add("Gwgz", "薪级工资", DbType.Decimal, "");
|
|
|
listColumns.Add("Xjgz", "岗位工资", DbType.Decimal, "");
|
|
|
listColumns.Add("Jh", "教护10%", DbType.Decimal, "");
|
|
|
listColumns.Add("Jhljt", "教护龄津贴", DbType.Decimal, "");
|
|
|
listColumns.Add("Sbbt", "社保补贴", DbType.Decimal, "");
|
|
|
listColumns.Add("Gfbzrt", "国发班主任贴", DbType.Decimal, "");
|
|
|
listColumns.Add("Shbt", "生活补贴", DbType.Decimal, "");
|
|
|
listColumns.Add("Gwjt", "岗位津贴", DbType.Decimal, "");
|
|
|
listColumns.Add("Jglbt", "教工龄补贴", DbType.Decimal, "");
|
|
|
listColumns.Add("Txfbt", "通讯费补贴", DbType.Decimal, "");
|
|
|
listColumns.Add("Yfhj", "应发合计", DbType.Decimal, "");
|
|
|
listColumns.Add("Dkkhj", "代扣款合计", DbType.Decimal, "");
|
|
|
listColumns.Add("Kgjj", "扣公积金", DbType.Decimal, "");
|
|
|
listColumns.Add("Kylj", "扣养老金", DbType.Decimal, "");
|
|
|
listColumns.Add("Ksbj", "扣失保金", DbType.Decimal, "");
|
|
|
listColumns.Add("Kybj", "扣医保金", DbType.Decimal, "");
|
|
|
listColumns.Add("Sdshj", "所得税合计", DbType.Decimal, "");
|
|
|
listColumns.Add("Sfhj", "实发合计", DbType.Decimal, "");
|
|
|
|
|
|
|
|
|
MicrosoftExcel obj2 = new MicrosoftExcel();
|
|
|
return obj2.Export(param, listColumns);
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
#endregion
|
|
|
|
|
|
|
|
|
#region 查询我的工资
|
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public List<GZ_SalaryInfo> GetMySalaryInfoList(int SYear, int SMonth, int EYear, int EMonth)
|
|
|
{
|
|
|
var obj = new BaseService();
|
|
|
int UserId = Convert.ToInt32(Session["UserId"]);
|
|
|
var list = obj.GetMySalaryInfoList(UserId, SYear, SMonth, EYear, EMonth);
|
|
|
|
|
|
decimal TotalValue = 0;
|
|
|
|
|
|
if (list != null && list.Count > 0)
|
|
|
{
|
|
|
foreach (var model in list)
|
|
|
{
|
|
|
if (model.ItemValue <= 0)
|
|
|
{
|
|
|
model.TotalGZ = "不计入总计";
|
|
|
|
|
|
}
|
|
|
else
|
|
|
model.TotalGZ = model.ItemValue.Value.ToString();
|
|
|
if (model.ItemValue != null)
|
|
|
TotalValue += model.ItemValue.Value;
|
|
|
|
|
|
}
|
|
|
list[0].TotalValue = TotalValue;
|
|
|
}
|
|
|
|
|
|
return list;
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 查询我的工资
|
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public string GetSalaryModel(string SalaryName)
|
|
|
{
|
|
|
var obj = new BaseService();
|
|
|
int UserId = Convert.ToInt32(Session["UserId"]);
|
|
|
var list = obj.GetSalaryModel(UserId, SalaryName);
|
|
|
string html = "";
|
|
|
if (list != null && list.Count > 0)
|
|
|
{
|
|
|
for (int i = 0; i < list.Count; i++)
|
|
|
{
|
|
|
if ((i + 1) == list.Count && (i + 1) % 2 == 1)
|
|
|
{
|
|
|
html += "<tr><td style='width: 80px;' class='f1'>" + list[i].ItemName + "：</td><td>" + list[i].ItemValue.Value.ToString() + "</td><td></td><td></td></tr>";
|
|
|
|
|
|
}
|
|
|
else
|
|
|
if ((i + 1) % 2 == 1)
|
|
|
{
|
|
|
html += "<tr><td style='width: 80px;' class='f1'>" + list[i].ItemName + "：</td><td>" + list[i].ItemValue.Value.ToString() + "</td>";
|
|
|
|
|
|
|
|
|
}
|
|
|
else if ((i + 1) % 2 == 0)
|
|
|
{
|
|
|
html += "<td style='width: 80px;' class='f1'>" + list[i].ItemName + "：</td><td>" + list[i].ItemValue.Value.ToString() + "</td></tr>";
|
|
|
}
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
return html;
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 查询我的工资
|
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public string GetUserSalaryModel(int UserId, string SalaryName)
|
|
|
{
|
|
|
var obj = new BaseService();
|
|
|
|
|
|
var list = obj.GetSalaryModel(UserId, SalaryName);
|
|
|
string html = "";
|
|
|
if (list != null && list.Count > 0)
|
|
|
{
|
|
|
html = "<tr><td colspan='4'>" + list[0].UserName + "【" + list[0].SalaryName + "】</td>";
|
|
|
for (int i = 0; i < list.Count; i++)
|
|
|
{
|
|
|
if ((i + 1) == list.Count && (i + 1) % 2 == 1)
|
|
|
{
|
|
|
html += "<tr><td style='width: 80px;' class='f1'>" + list[i].ItemName + "：</td><td>" + list[i].ItemValue.Value.ToString() + "</td><td></td><td></td></tr>";
|
|
|
|
|
|
}
|
|
|
else
|
|
|
if ((i + 1) % 2 == 1)
|
|
|
{
|
|
|
html += "<tr><td style='width: 80px;' class='f1'>" + list[i].ItemName + "：</td><td>" + list[i].ItemValue.Value.ToString() + "</td>";
|
|
|
|
|
|
|
|
|
}
|
|
|
else if ((i + 1) % 2 == 0)
|
|
|
{
|
|
|
html += "<td style='width: 80px;' class='f1'>" + list[i].ItemName + "：</td><td>" + list[i].ItemValue.Value.ToString() + "</td></tr>";
|
|
|
}
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
return html;
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
#region 删除工资
|
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public void deleteSalaryName(string SalaryName)
|
|
|
{
|
|
|
var obj = new BaseService();
|
|
|
|
|
|
obj.deleteSalaryName(SalaryName);
|
|
|
|
|
|
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#endregion 工资单
|
|
|
|
|
|
#region 预约情况
|
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public List<FR_OrderRecord> GetMeetList(int RoomId)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
|
|
|
var list = obj.GetRoomList(RoomId);
|
|
|
|
|
|
return list;
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#region 保存会议室预约
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public int SaveRoom(FR_OrderRecord model)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
var obj = new BaseService();
|
|
|
int UserId = Convert.ToInt32(Session["UserId"]);
|
|
|
model.InTime = DateTime.Now;
|
|
|
model.UserId = UserId;
|
|
|
|
|
|
int a = obj.SaveOrderRecord(model);
|
|
|
|
|
|
|
|
|
return a;
|
|
|
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#region 删除预约
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
public void DeleteRoom(int ID)
|
|
|
{
|
|
|
Pages.Login(this.Session);
|
|
|
|
|
|
|
|
|
var obj = new BaseService();
|
|
|
obj.DeleteOrder(ID);
|
|
|
|
|
|
|
|
|
}
|
|
|
#endregion
|
|
|
}
|
|
|
}
|
