private void Create()
        {
            string  Year       = Request["Year"];
            string  Month      = Request["Month"];
            string  day        = Request["day"];
            string  SignType   = Request["SignType"];
            string  ProjectId  = Request["ProjectId"];
            string  UserId     = Request["UserId"];
            string  UserName   = Request["UserName"];
            string  Attachment = Request["Attachment"];
            string  Remark     = Request["Remark"];
            string  Id         = Request["Id"];
            Project ProEnt     = Project.Find(ProjectId);

            //查询是否存在该项目该年此月份的考勤
            sql = @"select * from NCRL_SP..ProjectAttendance where Year='" + Convert.ToInt32(Year) + "' and Month='" + Convert.ToInt32(Month) + "' and ProjectId='" + ProjectId + "'";
            DataTable dt = DataHelper.QueryDataTable(sql);

            //查询是否存在该部门本该年此月份的考勤
            sql = @"select Id from NCRL_SP..DeptAttendance where Year='" + Convert.ToInt32(Year) + "'and Month='" + Convert.ToInt32(Month) + "' and BelongDeptId ='" + ProEnt.BelongDeptId + "'";
            DataTable da = DataHelper.QueryDataTable(sql);

            //查询本公司是否存在该年此月份的考勤
            sql = @"select  * from NCRL_SP..CmpAttendance where Year='" + Convert.ToInt32(Year) + "'and Month='" + Convert.ToInt32(Month) + "'";
            DataTable ca = DataHelper.QueryDataTable(sql);

            if (string.IsNullOrEmpty(Id))
            {
                if (dt.Rows.Count > 0)
                {
                    return;
                }
                Pent                = new ProjectAttendance();
                Pent.Attachment     = Attachment;
                Pent.Remark         = Remark;
                Pent.ProjectId      = ProjectId;
                Pent.ProjectName    = ProEnt.ProjectName;
                Pent.Year           = Convert.ToInt32(Year);
                Pent.Month          = Convert.ToInt32(Month);
                Pent.PManagerId     = ProEnt.PManagerId;
                Pent.PManagerName   = ProEnt.PManagerName;
                Pent.BelongDeptId   = ProEnt.BelongDeptId;
                Pent.BelongDeptName = ProEnt.BelongDeptName;
                Pent.CreateId       = WebPortalService.CurrentUserInfo.UserID;
                Pent.CreateName     = WebPortalService.CurrentUserInfo.Name;
                Pent.CreateTime     = DateTime.Now;
                Pent.DoCreate();
                if (da.Rows.Count <= 0)
                {
                    dent                = new DeptAttendance();
                    dent.Year           = Convert.ToInt32(Year);
                    dent.Month          = Convert.ToInt32(Month);
                    dent.BelongDeptId   = Pent.BelongDeptId;
                    dent.BelongDeptName = Pent.BelongDeptName;
                    dent.DoCreate();
                }
                if (ca.Rows.Count <= 0)
                {
                    cent       = new CmpAttendance();
                    cent.Year  = Convert.ToInt32(Year);
                    cent.Month = Convert.ToInt32(Month);
                    cent.DoCreate();
                }
            }
            else
            {
                Pent = ProjectAttendance.Find(Id);
                if (Pent.Attachment != Attachment || Pent.Remark != Remark)
                {
                    Pent.Attachment = Attachment;
                    Pent.Remark     = Remark;
                    Pent.DoUpdate();
                }
            }

            sql = "select * from NCRL_SP..ProjectAttendanceDetail where UserId='" + UserId + "'and CONVERT(varchar(10), AttendanceDate,120)='" + Convert.ToDateTime(Year + "-" + Month + "-" + day).ToString("yyyy-MM-dd") + "' and ProjectAttendanceId<>'" + Id + "' or ProjectAttendanceId is null ";
            IList <EasyDictionary> dicss = DataHelper.QueryDictList(sql);

            if (dicss.Count > 0)
            {
                ents = ProjectAttendanceDetail.Find(dicss[0].Get <string>("Id"));
                ents.AttendanceType = SignType;
                if (!string.IsNullOrEmpty(Id))
                {
                    ents.ProjectAttendanceId = Id;
                }
                else
                {
                    ents.ProjectAttendanceId = Pent.Id;
                }
                ents.Description = "";
                ents.DoUpdate();

                if (!string.IsNullOrEmpty(Id))
                {
                    Response.Write("{success:  true  ,id:'" + Id + "'}");
                    Response.End();
                    return;
                }
                Response.Write("{success:  true  ,id:'" + Pent.Id + "'}");
                Response.End();
                return;
            }

            sql   = "select * from NCRL_SP..ProjectAttendanceDetail where UserId='" + UserId + "'and CONVERT(varchar(10), AttendanceDate,120)='" + Convert.ToDateTime(Year + "-" + Month + "-" + day).ToString("yyyy-MM-dd") + "' and ProjectAttendanceId='" + Id + "'";
            dicss = DataHelper.QueryDictList(sql);
            if (dicss.Count > 0)
            {
                ents = ProjectAttendanceDetail.Find(dicss[0].Get <string>("Id"));
                if (ents.AttendanceType != SignType)
                {
                    ents.AttendanceType = SignType;
                }
                else
                {
                    sql = "delete NCRL_SP..ProjectAttendanceDetail where  UserId='" + UserId + "'and CONVERT(varchar(10), AttendanceDate,120)='" + Convert.ToDateTime(Year + "-" + Month + "-" + day).ToString("yyyy-MM-dd") + "' and ProjectAttendanceId='" + Id + "'";
                    DataHelper.ExecSql(sql);
                    Response.Write("{success:  true  ,id:'" + Id + "'}");
                    Response.End();
                    return;
                }
                ents.CreateTime = System.DateTime.Now;
                ents.DoUpdate();
            }
            else
            {
                ents          = new ProjectAttendanceDetail();
                ents.UserId   = UserId;
                ents.UserName = UserName;
                if (!string.IsNullOrEmpty(Id))
                {
                    ents.ProjectAttendanceId = Id;
                }
                else
                {
                    ents.ProjectAttendanceId = Pent.Id;
                }
                ents.AttendanceType = SignType;
                ents.AttendanceDate = Convert.ToDateTime(Year + "-" + Month + "-" + day);
                ents.CreateId       = WebPortalService.CurrentUserInfo.UserID;
                ents.CreateName     = WebPortalService.CurrentUserInfo.Name;
                ents.CreateTime     = DateTime.Now;
                ents.DoCreate();
            }
            if (!string.IsNullOrEmpty(Id))
            {
                Response.Write("{success:  true  ,id:'" + Id + "'}");
                Response.End();
                return;
            }
            Response.Write("{success:  true  ,id:'" + Pent.Id + "'}");
            Response.End();
        }
        private void Create()
        {
            string Year     = Request["Year"];
            string Month    = Request["Month"];
            string day      = Request["day"];
            string UserId   = Request["UserId"];
            string UserName = Request["UserName"];
            string SignType = Request["SignType"];

            sql  = "select * from NCRL_SP..CmpAttendance where Year =" + Year + " and Month= " + Month;
            Cmps = DataHelper.QueryDictList(sql);
            string ComId;

            if (Cmps.Count <= 0)
            {
                Cent       = new CmpAttendance();
                Cent.Year  = Convert.ToInt32(Year);
                Cent.Month = Convert.ToInt32(Month);
                Cent.DoCreate();
                ComId = Cent.Id;
            }
            else
            {
                ComId = Cmps[0].Get <string>("Id");
            }
            sql = "select * from NCRL_SP..ProjectAttendanceDetail where UserId='" + UserId + "'and CONVERT(varchar(10), AttendanceDate,120)='" + Convert.ToDateTime(Year + "-" + Month + "-" + day).ToString("yyyy-MM-dd") + "' and ProjectAttendanceId='" + ComId + "'";
            IList <EasyDictionary> dicss = DataHelper.QueryDictList(sql);

            if (dicss.Count > 0)
            {
                Pdent = ProjectAttendanceDetail.Find(dicss[0].Get <string>("Id"));
                if (Pdent.AttendanceType != SignType)
                {
                    Pdent.AttendanceType = SignType;
                }
                else
                {
                    sql = "delete NCRL_SP..ProjectAttendanceDetail where  UserId='" + UserId + "'and CONVERT(varchar(10), AttendanceDate,120)='" + Convert.ToDateTime(Year + "-" + Month + "-" + day).ToString("yyyy-MM-dd") + "' and ProjectAttendanceId='" + ComId + "'";
                    DataHelper.ExecSql(sql);
                    return;
                }

                Pdent.CreateTime = System.DateTime.Now;
                Pdent.DoUpdate();
            }
            else
            {
                Pdent                     = new ProjectAttendanceDetail();
                Pdent.UserId              = UserId;
                Pdent.UserName            = UserName;
                Pdent.ProjectAttendanceId = ComId;
                Pdent.AttendanceType      = SignType;
                Pdent.AttendanceDate      = Convert.ToDateTime(Year + "-" + Month + "-" + day);
                Pdent.CreateId            = WebPortalService.CurrentUserInfo.UserID;
                Pdent.CreateName          = WebPortalService.CurrentUserInfo.Name;
                Pdent.CreateTime          = DateTime.Now;
                Pdent.Description         = "非项目人员考勤";
                Pdent.DoCreate();
            }
            Response.Write("{success:  true  ,ComId:'" + ComId + "'}");
            Response.End();
        }