//获取要修改的数据
        public ActionResult GetEditInfo()
        {
            long id = Convert.ToInt64(Request["id"]);
            int  sd = Convert.ToInt32(Request["state"]);

            if (sd == 0)
            {
                var    temp = T_jxzztjbService.LoadEntities(x => x.ID == id).FirstOrDefault();
                jxInfo ji   = new jxInfo();
                ji.ID            = temp.ID;
                ji.Addtime       = temp.Addtime;
                ji.Wtime         = temp.Wtime;
                ji.ImgName_ID    = temp.ImgName_ID;
                ji.UPslt_ID      = temp.UPslt_ID;
                ji.Seb_number_ID = temp.Seb_number_ID;
                ji.ImgNumber     = temp.ImgNumber;
                ji.Iint          = temp.Iint;
                ji.Slt_kg        = temp.Slt_kg;
                ji.Slt_hege      = temp.Slt_hege;
                ji.Slt_hegeNo    = temp.Slt_hegeNo;
                ji.Slt_Feipin    = temp.Slt_Feipin;
                ji.Slt_BFB       = temp.Slt_BFB;
                ji.StupTime      = temp.StupTime;
                ji.OverTime      = temp.OverTime;
                ji.ThisHaveTime  = temp.ThisHaveTime;
                ji.HaveTime      = temp.HaveTime;
                ji.UpBumen_id    = temp.UpBumen_id;
                ji.del           = temp.del_f;
                ji.RestYesOrNo   = temp.RestYesOrNo;
                ji.WorkHours     = temp.WorkHours;
                ji.LjName        = temp.Seb_Number.Ttext;
                return(Json(ji, JsonRequestBehavior.AllowGet));
            }
            else
            {
                var    temp = T_jgzztjbService.LoadEntities(x => x.ID == id).FirstOrDefault();
                jgInfo ji   = new jgInfo();
                ji.ID           = temp.ID;
                ji.Addtime      = temp.Addtime;
                ji.Wtime        = temp.Wtime;
                ji.ImgName_ID   = temp.ImgName_ID;
                ji.UPslt_ID     = temp.UPslt_ID;
                ji.ImgNumber    = temp.ImgNumber;
                ji.Iint         = temp.Iint;
                ji.Slt_kg       = temp.Slt_kg;
                ji.Slt_hege     = temp.Slt_hege;
                ji.Slt_hegeNo   = temp.Slt_hegeNo;
                ji.Slt_Feipin   = temp.Slt_Feipin;
                ji.Slt_BFB      = temp.Slt_BFB;
                ji.StupTime     = temp.StupTime;
                ji.OverTime     = temp.OverTime;
                ji.ThisHaveTime = temp.ThisHaveTime;
                ji.HaveTime     = temp.HaveTime;
                ji.UpBumen_id   = temp.UpBumen_id;
                ji.del          = temp.del_f;
                ji.RestYesOrNo  = temp.RestYesOrNo;
                ji.WorkHours    = temp.WorkHours;
                return(Json(ji, JsonRequestBehavior.AllowGet));
            }
        }
        //删除日报基础信息
        public ActionResult delDayExcel()
        {
            long id    = Convert.ToInt64(Request["id"]);
            int  state = Convert.ToInt32(Request["state"]);

            if (state == 0)
            {
                var temp = T_jgzztjbService.LoadEntities(x => x.ID == id).FirstOrDefault();
                if (temp != null)
                {
                    temp.del_f = false;
                    T_jgzztjbService.EditEntity(temp);
                    return(Json(new { ret = "ok" }, JsonRequestBehavior.AllowGet));
                }
                else
                {
                    return(Json(new { ret = "no", msg = "数据库中无此条数据" }, JsonRequestBehavior.AllowGet));
                }
            }
            else
            {
                var temp = T_jxzztjbService.LoadEntities(x => x.ID == id).FirstOrDefault();
                if (temp != null)
                {
                    temp.del_f = false;
                    T_jxzztjbService.EditEntity(temp);
                    return(Json(new { ret = "ok" }, JsonRequestBehavior.AllowGet));
                }
                else
                {
                    return(Json(new { ret = "no", msg = "数据库中无此条数据" }, JsonRequestBehavior.AllowGet));
                }
            }
        }
        //获取统计数据
        public ActionResult GetStatisticsInfo()
        {
            var bolID = Request["bolID"] == null?0: Convert.ToInt32(Request["bolID"]);

            if (bolID != 0)
            {
                int bumenID = Request["bmID"] == null ? 0 : Convert.ToInt32(Request["bmID"]);
                #region 个人日统计表
                if (bolID == 9)
                {
                    DateTime excelDate = Convert.ToDateTime(Request["excelDate"]);
                    if (bumenID == 26)
                    {
                        var temp = T_jxzztjbService.LoadEntities(x => x.Wtime == excelDate && x.del_f == true).DefaultIfEmpty().ToList();
                        if (temp != null && temp[0] != null)
                        {
                            List <jsxtCls> tList = new List <jsxtCls>();
                            foreach (var a in temp)
                            {
                                jsxtCls jc = new jsxtCls();
                                jc.ID            = a.ID;
                                jc.Addtime       = a.Addtime;
                                jc.Wtime         = a.Wtime;
                                jc.ImgName_ID    = a.Seb_Number1.Ttext;
                                jc.UPslt_ID      = a.User_Person_slt.UserInfo.PerSonName;
                                jc.Seb_number_ID = a.Seb_Number.Ttext;
                                jc.ImgNumber     = a.ImgNumber;
                                jc.Iint          = a.Iint;
                                jc.Slt_kg        = a.Slt_kg;
                                jc.Slt_BFB       = a.Slt_BFB;
                                jc.Slt_Feipin    = a.Slt_Feipin;
                                jc.Slt_hege      = a.Slt_hege;
                                jc.Slt_hegeNo    = a.Slt_hegeNo;
                                jc.StupTime      = a.StupTime;
                                jc.OverTime      = a.OverTime;
                                jc.ThisHaveTime  = a.ThisHaveTime;
                                jc.HaveTime      = a.HaveTime;
                                jc.WorkHours     = a.WorkHours;
                                jc.UpBumen_id    = a.BumenInfoSet.Name;
                                jc.RestYesOrNo   = a.RestYesOrNo;
                                jc.Wage_slt      = a.User_Person_slt.Wage_slt;
                                jc.HoursWage     = a.User_Person_slt.HoursWage;
                                jc.Job_Name      = a.User_Person_slt.Job_Name;
                                jc.SumHoursWage  = jc.WorkHours * jc.HoursWage;
                                tList.Add(jc);
                            }
                            return(Json(tList, JsonRequestBehavior.AllowGet));
                        }
                        return(Json(null, JsonRequestBehavior.AllowGet));
                    }
                    else
                    {
                        var temp = T_jgzztjbService.LoadEntities(x => x.Wtime == excelDate && x.del_f == true).DefaultIfEmpty().ToList();
                        if (temp != null && temp[0] != null)
                        {
                            List <jsxtCls> tList = new List <jsxtCls>();
                            foreach (var a in temp)
                            {
                                jsxtCls jc = new jsxtCls();
                                jc.ID           = a.ID;
                                jc.Addtime      = a.Addtime;
                                jc.Wtime        = a.Wtime;
                                jc.ImgName_ID   = a.Seb_Number.Ttext;
                                jc.UPslt_ID     = a.User_Person_slt.UserInfo.PerSonName;
                                jc.ImgNumber    = a.ImgNumber;
                                jc.Iint         = a.Iint;
                                jc.Slt_kg       = a.Slt_kg;
                                jc.Slt_BFB      = a.Slt_BFB;
                                jc.Slt_Feipin   = a.Slt_Feipin;
                                jc.Slt_hege     = a.Slt_hege;
                                jc.Slt_hegeNo   = a.Slt_hegeNo;
                                jc.StupTime     = a.StupTime;
                                jc.OverTime     = a.OverTime;
                                jc.ThisHaveTime = a.ThisHaveTime;
                                jc.HaveTime     = a.HaveTime;
                                jc.WorkHours    = a.WorkHours;
                                jc.UpBumen_id   = a.BumenInfoSet.Name;
                                jc.RestYesOrNo  = a.RestYesOrNo;
                                jc.Wage_slt     = a.User_Person_slt.Wage_slt;
                                jc.HoursWage    = a.User_Person_slt.HoursWage;
                                jc.Job_Name     = a.User_Person_slt.Job_Name;
                                jc.SumHoursWage = jc.WorkHours * jc.HoursWage;
                                tList.Add(jc);
                            }
                            return(Json(tList, JsonRequestBehavior.AllowGet));
                        }
                        return(Json(null, JsonRequestBehavior.AllowGet));
                    }
                }
                #endregion
                else
                {
                    DateTime dtStart = Convert.ToDateTime(Request["monthExcel"]);
                    DateTime dtEnd   = dtStart.AddMonths(1).AddDays(-1 * (dtStart.Day));
                    #region 个人月报表
                    if (bolID == 10)
                    {
                        var monthCount = DateTime.DaysInMonth(dtStart.Year, dtStart.Month);
                        if (bumenID == 26)
                        {
                            var temp = T_jxzztjbService.LoadEntities(x => x.Wtime >= dtStart && x.Wtime <= dtEnd && x.del_f == true).DefaultIfEmpty().ToList();
                            if (temp != null && temp[0] != null)
                            {
                                var tdata = temp.GroupBy(x => x.UPslt_ID).Select(x => new GRmouth
                                {
                                    ID           = x.First().UPslt_ID,
                                    UPslt_ID     = x.First().User_Person_slt.UserInfo.PerSonName,
                                    Iint         = x.Sum(g => g.Iint),
                                    Slt_kg       = x.Sum(g => g.Slt_kg),
                                    Slt_Feipin   = x.Sum(g => g.Slt_Feipin),
                                    Slt_hege     = x.Sum(g => g.Slt_hege),
                                    Slt_hegeNo   = x.Sum(g => g.Slt_hegeNo),
                                    ThisHaveTime = x.Sum(g => g.ThisHaveTime),
                                    HaveTime     = x.Sum(g => g.HaveTime),
                                    Wage_slt     = x.First().User_Person_slt.Wage_slt,
                                    Job_Name     = x.First().User_Person_slt.Job_Name,
                                    RestYesOrNo  = monthCount - temp.Where(g => g.UPslt_ID == x.First().UPslt_ID).GroupBy(z => new { z.UPslt_ID, z.Wtime }).Count() + x.Sum(k => k.RestYesOrNo == 0 ? 0.5 : 0),
                                    HoursWage    = x.First().User_Person_slt.HoursWage,
                                    SumHoursWage = x.Sum(g => g.WorkHours * g.User_Person_slt.HoursWage),
                                    WorkHours    = x.Sum(g => g.WorkHours)
                                });
                                return(Json(tdata, JsonRequestBehavior.AllowGet));
                            }
                            return(Json(null, JsonRequestBehavior.AllowGet));
                        }
                        else
                        {
                            var temp = T_jgzztjbService.LoadEntities(x => x.Wtime >= dtStart && x.Wtime <= dtEnd && x.del_f == true).DefaultIfEmpty().ToList();
                            if (temp != null && temp[0] != null)
                            {
                                var tdata = temp.GroupBy(x => x.UPslt_ID).Select(x => new GRmouth
                                {
                                    ID           = x.First().UPslt_ID,
                                    UPslt_ID     = x.First().User_Person_slt.UserInfo.PerSonName,
                                    Iint         = x.Sum(g => g.Iint),
                                    Slt_kg       = x.Sum(g => g.Slt_kg),
                                    Slt_Feipin   = x.Sum(g => g.Slt_Feipin),
                                    Slt_hege     = x.Sum(g => g.Slt_hege),
                                    Slt_hegeNo   = x.Sum(g => g.Slt_hegeNo),
                                    ThisHaveTime = x.Sum(g => g.ThisHaveTime),
                                    HaveTime     = x.Sum(g => g.HaveTime),
                                    Wage_slt     = x.First().User_Person_slt.Wage_slt,
                                    Job_Name     = x.First().User_Person_slt.Job_Name,
                                    RestYesOrNo  = monthCount - temp.Where(g => g.UPslt_ID == x.First().UPslt_ID).GroupBy(z => new { z.UPslt_ID, z.Wtime }).Count() + x.Sum(k => k.RestYesOrNo == 0?0.5:0),
                                    HoursWage    = x.First().User_Person_slt.HoursWage,
                                    SumHoursWage = x.Sum(g => g.WorkHours * g.User_Person_slt.HoursWage),
                                    WorkHours    = x.Sum(g => g.WorkHours)
                                });
                                return(Json(tdata, JsonRequestBehavior.AllowGet));
                            }
                            return(Json(null, JsonRequestBehavior.AllowGet));
                        }
                    }
                    #endregion
                    #region 车间月统计表
                    else if (bolID == 11)//车间月汇报表
                    {
                        var            temp  = T_jxzztjbService.LoadEntities(x => x.Wtime >= dtStart && x.Wtime <= dtEnd && x.UpBumen_id == bumenID && x.del_f == true).DefaultIfEmpty().ToList();
                        var            temp2 = T_jgzztjbService.LoadEntities(x => x.Wtime >= dtStart && x.Wtime <= dtEnd && x.UpBumen_id == bumenID && x.del_f == true).DefaultIfEmpty().ToList();
                        List <CJExcel> tList = new List <CJExcel>();
                        if (temp != null && temp[0] != null)
                        {
                            foreach (var a in temp)
                            {
                                CJExcel cje = new CJExcel();
                                cje.WorkTime   = a.Wtime;
                                cje.PersonName = a.User_Person_slt.UserInfo.PerSonName;
                                cje.WorkType   = a.User_Person_slt.Job_Name;
                                cje.HoursWage  = a.User_Person_slt.HoursWage;
                                cje.UpBumen    = a.BumenInfoSet.Name;
                                cje.WorkInfo   = a.Seb_Number1.Ttext;
                                cje.WorkHours  = a.WorkHours;
                                cje.SumMoney   = cje.WorkHours * cje.HoursWage;
                                tList.Add(cje);
                            }
                        }
                        if (temp2 != null && temp2[0] != null)
                        {
                            foreach (var a in temp2)
                            {
                                CJExcel cje = new CJExcel();
                                cje.WorkTime   = a.Wtime;
                                cje.PersonName = a.User_Person_slt.UserInfo.PerSonName;
                                cje.WorkType   = a.User_Person_slt.Job_Name;
                                cje.HoursWage  = a.User_Person_slt.HoursWage;
                                cje.UpBumen    = a.BumenInfoSet.Name;
                                cje.WorkInfo   = a.Seb_Number.Ttext;
                                cje.WorkHours  = a.WorkHours;
                                cje.SumMoney   = cje.WorkHours * cje.HoursWage;
                                tList.Add(cje);
                            }
                        }
                        tList = tList.OrderBy(x => x.WorkTime).ToList();
                        return(Json(tList, JsonRequestBehavior.AllowGet));
                    }
                    #endregion
                    #region 公司月统计表
                    else if (bolID == 12)//公司月总结表
                    {
                        var            temp  = T_jxzztjbService.LoadEntities(x => x.Wtime >= dtStart && x.Wtime <= dtEnd && x.del_f == true).DefaultIfEmpty().ToList();
                        var            temp2 = T_jgzztjbService.LoadEntities(x => x.Wtime >= dtStart && x.Wtime <= dtEnd && x.del_f == true).DefaultIfEmpty().ToList();
                        List <GSExcel> temp1 = new List <GSExcel>();
                        if (temp != null && temp[0] != null)
                        {
                            temp1 = temp.GroupBy(x => x.UpBumen_id).Select(x => new GSExcel {
                                UpBumen = x.First().BumenInfoSet.Name, SumHours = x.Sum(g => g.WorkHours), SumMoney = x.Sum(g => g.User_Person_slt.HoursWage * g.WorkHours)
                            }).ToList();
                        }
                        List <GSExcel> temp3 = new List <GSExcel>();
                        if (temp2 != null && temp2[0] != null)
                        {
                            temp3 = temp2.GroupBy(x => x.UpBumen_id).Select(x => new GSExcel {
                                UpBumen = x.First().BumenInfoSet.Name, SumHours = x.Sum(g => g.WorkHours), SumMoney = x.Sum(g => g.User_Person_slt.HoursWage * g.WorkHours)
                            }).ToList();
                        }
                        temp1.AddRange(temp3);
                        return(Json(temp1, JsonRequestBehavior.AllowGet));
                    }
                    #endregion
                    #region 轨枕月统计表
                    else if (bolID == 13)//轨枕月总结表
                    {
                        int id = 0;
                        if (bumenID == 41)
                        {
                            id = 26;
                            var             temp  = T_jxzztjbService.LoadEntities(x => x.Wtime >= dtStart && x.Wtime <= dtEnd && x.UpBumen_id == bumenID && x.User_Person_slt.UserInfo.BuMenID == id && x.del_f == true).DefaultIfEmpty().ToList();
                            List <GZXExcel> temp1 = new List <GZXExcel>();
                            if (temp != null && temp[0] != null)
                            {
                                temp1 = temp.GroupBy(x => x.Seb_Number1.Ttext).Select(x => new GZXExcel {
                                    UpBumen = x.Key, SumHours = x.Sum(g => g.WorkHours), SumMoney = x.Sum(g => g.WorkHours * g.User_Person_slt.HoursWage)
                                }).ToList();
                                return(Json(temp1, JsonRequestBehavior.AllowGet));
                            }
                            return(Json(null, JsonRequestBehavior.AllowGet));
                        }
                        else
                        {
                            id = 43;
                            var             temp2 = T_jgzztjbService.LoadEntities(x => x.Wtime >= dtStart && x.Wtime <= dtEnd && x.UpBumen_id == bumenID && x.User_Person_slt.UserInfo.BuMenID == id && x.del_f == true).DefaultIfEmpty().ToList();
                            List <GZXExcel> temp3 = new List <GZXExcel>();
                            if (temp2 != null && temp2[0] != null)
                            {
                                temp3 = temp2.GroupBy(x => x.Seb_Number.Ttext).Select(x => new GZXExcel {
                                    UpBumen = x.Key, SumHours = x.Sum(g => g.WorkHours), SumMoney = x.Sum(g => g.WorkHours * g.User_Person_slt.HoursWage)
                                }).ToList();
                                return(Json(temp3, JsonRequestBehavior.AllowGet));
                            }
                            return(Json(null, JsonRequestBehavior.AllowGet));
                        }
                    }
                    #endregion
                    else
                    {
                        return(Json(null, JsonRequestBehavior.AllowGet));
                    }
                }
            }
            else
            {
                ActionResult ar = Getdata();
                return(ar);
            }
        }