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 + "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;日期：" + 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
    }
}