Exemple #1
0
        /// <summary>
        /// 新增工时
        /// </summary>
        /// <param name="weList"></param>
        /// <param name="userId"></param>
        /// <returns></returns>
        public bool AddWorkEntry(List <sdk_work_entry> weList, long userId)
        {
            var bll = new TimeOffPolicyBLL();
            tst_timeoff_balance_dal balDal = new tst_timeoff_balance_dal();
            long batchId = dal.GetNextId("seq_entry_batch");

            foreach (var we in weList)
            {
                we.id             = dal.GetNextIdCom();
                we.create_time    = Tools.Date.DateHelper.ToUniversalTimeStamp();
                we.update_time    = we.create_time;
                we.create_user_id = userId;
                we.update_user_id = userId;
                we.batch_id       = batchId;

                dal.Insert(we);
                OperLogBLL.OperLogAdd <sdk_work_entry>(we, we.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SDK_WORK_ENTRY, "新增工时");

                if (we.task_id == (long)CostCode.Sick)  // 病假需要在假期余额表添加记录
                {
                    bll.UpdateTimeoffBalance(we.resource_id.Value, Tools.Date.DateHelper.TimeStampToUniversalDateTime(we.start_time.Value), (CostCode)we.task_id);
                    //var balance = bll.UpdateTimeoffBalance((long)we.resource_id, Tools.Date.DateHelper.TimeStampToDateTime((long)we.start_time), 0 - (decimal)we.hours_billed);
                    //tst_timeoff_balance bal = new tst_timeoff_balance();
                    //bal.object_id = we.id;
                    //bal.object_type_id = 2214;
                    //bal.task_id = we.task_id;
                    //bal.resource_id = (long)we.resource_id;
                    //bal.balance = balance - (decimal)we.hours_billed;
                    //balDal.Insert(bal);
                }
            }

            return(true);
        }
Exemple #2
0
        /// <summary>
        /// 删除工时
        /// </summary>
        /// <param name="batchId"></param>
        /// <param name="userId"></param>
        /// <returns></returns>
        public bool DeleteWorkEntry(long batchId, long userId)
        {
            var weList = dal.FindListBySql($"select * from sdk_work_entry where batch_id={batchId} and delete_time=0");

            if (weList.Count == 0)
            {
                return(false);
            }

            int  type;
            long id;

            if (!GetWorkEntryType(batchId, out type, out id))
            {
                return(false);
            }

            bool rtn     = true;
            var  bll     = new TimeOffPolicyBLL();
            var  taskbll = new TaskBLL();
            tst_timeoff_balance_dal balDal = new tst_timeoff_balance_dal();
            string reason;

            foreach (var we in weList)
            {
                if (type == 1)  // 常规工时
                {
                    we.delete_time    = Tools.Date.DateHelper.ToUniversalTimeStamp();
                    we.delete_user_id = userId;
                    dal.Update(we);
                    OperLogBLL.OperLogDelete <sdk_work_entry>(we, we.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SDK_WORK_ENTRY, "删除工时");

                    if (we.task_id == (long)CostCode.Sick)  // 病假需要在假期余额表删除记录
                    {
                        bll.UpdateTimeoffBalance(we.resource_id.Value, Tools.Date.DateHelper.TimeStampToUniversalDateTime(we.start_time.Value), (CostCode)we.task_id);
                        //var balance = bll.UpdateTimeoffBalance((long)we.resource_id, Tools.Date.DateHelper.TimeStampToDateTime((long)we.start_time), (decimal)we.hours_billed);
                        //balDal.ExecuteSQL($"delete from tst_timeoff_balance where object_id={we.id}");
                    }
                }
                else if (type == 2) // 休假请求
                {
                    bll.CancleTimeoffRequest(we.timeoff_request_id.Value, userId);
                }
                else    // 任务工时和工单工时
                {
                    if (!taskbll.DeleteEntry(we.id, userId, out reason))
                    {
                        rtn = false;
                    }
                }
            }

            return(rtn);
        }
Exemple #3
0
        /// <summary>
        /// 删除工时表
        /// </summary>
        /// <param name="startDate"></param>
        /// <param name="resourceId"></param>
        /// <param name="userId"></param>
        /// <returns></returns>
        public bool DeleteWorkEntryReport(DateTime startDate, long resourceId, long userId)
        {
            sdk_work_entry_report_dal rptDal = new sdk_work_entry_report_dal();
            var find = rptDal.FindSignleBySql <sdk_work_entry_report>($"select * from sdk_work_entry_report where resource_id={resourceId} and start_date='{startDate}' and delete_time=0");

            if (find != null && find.status_id != (int)DicEnum.WORK_ENTRY_REPORT_STATUS.HAVE_IN_HAND)
            {
                return(false);
            }

            var weList = GetWorkEntryListByStartDate(startDate, resourceId);

            if (weList.Count == 0)
            {
                return(false);
            }

            var bll = new TimeOffPolicyBLL();
            tst_timeoff_balance_dal balDal = new tst_timeoff_balance_dal();

            //var weList = GetWorkEntryByBatchId(batchId);
            //if (weList.Count == 0)
            //    return true;
            //if (weList[0].approve_and_post_user_id != null) // 已审批提交不能删除
            //    return false;

            foreach (var we in weList)
            {
                we.delete_time    = Tools.Date.DateHelper.ToUniversalTimeStamp();
                we.delete_user_id = userId;
                dal.Update(we);
                OperLogBLL.OperLogDelete <sdk_work_entry>(we, we.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SDK_WORK_ENTRY, "删除工时");

                if (we.task_id == (long)CostCode.Sick)  // 病假需要在假期余额表删除记录
                {
                    bll.UpdateTimeoffBalance(we.resource_id.Value, Tools.Date.DateHelper.TimeStampToUniversalDateTime(we.start_time.Value), (CostCode)we.task_id);
                    //var balance = bll.UpdateTimeoffBalance((long)we.resource_id, Tools.Date.DateHelper.TimeStampToDateTime((long)we.start_time), (decimal)we.hours_billed);
                    //balDal.ExecuteSQL($"delete from tst_timeoff_balance where object_id={we.id}");
                }
            }

            if (find != null)
            {
                find.delete_time    = Tools.Date.DateHelper.ToUniversalTimeStamp();
                find.delete_user_id = userId;
                rptDal.Update(find);
                OperLogBLL.OperLogDelete <sdk_work_entry_report>(find, find.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SDK_WORK_RECORD, "删除工时表");
            }
            return(true);
        }
Exemple #4
0
        /// <summary>
        /// 根据选择的日期获取相应类名,
        /// </summary>
        public string ReturnClassName(DateTime chooseDate, DateTime thisDay, long userId)
        {
            // 过期 Overlap
            // 有待办 预定~  Important
            // 今天 Today
            // 本月天数无信息 ""
            string className = "";

            if (thisDay.Year != chooseDate.Year || thisDay.Month != chooseDate.Month)
            {
                className += "Overlap ";
            }
            if (thisDay.Year == DateTime.Now.Year && thisDay.Month == DateTime.Now.Month && thisDay.Day == DateTime.Now.Day)
            {
                className += "Today ";
            }
            var dBll    = new DispatchBLL();
            var appList = dBll.GetAppByResDate(userId, thisDay);

            if (appList != null && appList.Count > 0)
            {
                className += "Important";
                return(className);
            }
            var todoList = new ActivityBLL().GetToListByResDate(userId, thisDay);

            if (todoList != null && todoList.Count > 0)
            {
                className += "Important";
                return(className);
            }
            var callList = new TicketBLL().GetCallByResDate(userId, thisDay);

            if (callList != null && callList.Count > 0)
            {
                className += "Important";
                return(className);
            }
            var timeList = new TimeOffPolicyBLL().GetTimeOffByResDate(userId, thisDay);

            if (timeList != null && timeList.Count > 0)
            {
                className += "Important";
                return(className);
            }
            return(className);
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            var  bll = new TimeOffPolicyBLL();
            long id;
            long resId;

            if (!long.TryParse(Request.QueryString["resId"], out resId))
            {
                Response.End();
                return;
            }
            if (long.TryParse(Request.QueryString["id"], out id))
            {
                plcAss = new DAL.tst_timeoff_policy_resource_dal().FindById(id);
            }
            policyList = bll.GetPolicyList();

            if (IsPostBack)
            {
                DateTime effDate = DateTime.Parse(Request.Form["effDate"]);
                if (plcAss == null)
                {
                    long plcId = long.Parse(Request.Form["plc"]);
                    bll.AddEditTimeoffResource(0, resId, plcId, effDate, LoginUserId);
                }
                else
                {
                    if (effDate < plcAss.effective_date)
                    {
                        bll.AddEditTimeoffResource(plcAss.id, resId, plcAss.timeoff_policy_id, effDate, LoginUserId);
                    }
                }
                Response.Write("<script>window.close();self.opener.location.reload();</script>");
                Response.End();
            }
        }
Exemple #6
0
        /// <summary>
        /// 编辑工时
        /// </summary>
        /// <param name="weList">编辑后的工时列表</param>
        /// <param name="batchId"></param>
        /// <param name="userId"></param>
        /// <returns></returns>
        public bool EditWorkEntry(List <sdk_work_entry> weList, long batchId, long userId)
        {
            var bll = new TimeOffPolicyBLL();
            tst_timeoff_balance_dal balDal = new tst_timeoff_balance_dal();
            var weListOld = GetWorkEntryByBatchId(batchId);

            if (weListOld[0].approve_and_post_user_id != null) // 已审批提交不能编辑
            {
                return(false);
            }

            foreach (var we in weListOld)
            {
                if (weList.Exists(_ => _.start_time == we.start_time))  // 原工时被编辑
                {
                    var weOld  = dal.FindById(we.id);
                    var weEdit = weList.Find(_ => _.start_time == we.start_time);
                    we.internal_notes = weEdit.internal_notes;
                    we.summary_notes  = weEdit.summary_notes;
                    we.hours_worked   = weEdit.hours_worked;
                    we.hours_billed   = weEdit.hours_billed;
                    we.update_time    = Tools.Date.DateHelper.ToUniversalTimeStamp();
                    we.update_user_id = userId;
                    var desc = OperLogBLL.CompareValue <sdk_work_entry>(weOld, we);
                    if (!string.IsNullOrEmpty(desc))
                    {
                        dal.Update(we);
                        OperLogBLL.OperLogUpdate(desc, we.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SDK_WORK_ENTRY, "编辑工时");

                        if (we.task_id == (long)CostCode.Sick && we.hours_worked != weOld.hours_worked)  // 病假需要在假期余额表修改记录
                        {
                            bll.UpdateTimeoffBalance(we.resource_id.Value, Tools.Date.DateHelper.TimeStampToUniversalDateTime(we.start_time.Value), (CostCode)we.task_id);
                            //var balance = bll.UpdateTimeoffBalance((long)we.resource_id, Tools.Date.DateHelper.TimeStampToDateTime((long)we.start_time), (decimal)weOld.hours_billed - (decimal)we.hours_billed);
                            //var bal = balDal.FindSignleBySql<tst_timeoff_balance>($"select * from tst_timeoff_balance where object_id={we.id}");
                            //bal.balance = bal.balance + ((decimal)we.hours_billed - (decimal)weOld.hours_billed);
                            //balDal.Update(bal);
                        }
                    }
                    weList.Remove(weEdit);
                }
                else    // 原工时被删除
                {
                    we.delete_time    = Tools.Date.DateHelper.ToUniversalTimeStamp();
                    we.delete_user_id = userId;
                    dal.Update(we);
                    OperLogBLL.OperLogDelete <sdk_work_entry>(we, we.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SDK_WORK_ENTRY, "编辑工时删除");

                    if (we.task_id == (long)CostCode.Sick)  // 病假需要在假期余额表删除记录
                    {
                        bll.UpdateTimeoffBalance(we.resource_id.Value, Tools.Date.DateHelper.TimeStampToUniversalDateTime(we.start_time.Value), (CostCode)we.task_id);
                        //var balance = bll.UpdateTimeoffBalance((long)we.resource_id, Tools.Date.DateHelper.TimeStampToDateTime((long)we.start_time), (decimal)we.hours_billed);
                        //balDal.ExecuteSQL($"delete from tst_timeoff_balance where object_id={we.id}");
                    }
                }
            }
            foreach (var we in weList)  // 剩余需要新增
            {
                we.id             = dal.GetNextIdCom();
                we.batch_id       = batchId;
                we.resource_id    = weListOld[0].resource_id;
                we.cost_code_id   = weListOld[0].cost_code_id;
                we.task_id        = weListOld[0].task_id;
                we.create_time    = Tools.Date.DateHelper.ToUniversalTimeStamp();
                we.update_time    = we.create_time;
                we.create_user_id = userId;
                we.update_user_id = userId;

                dal.Insert(we);
                OperLogBLL.OperLogAdd <sdk_work_entry>(we, we.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SDK_WORK_ENTRY, "编辑工时新增");

                if (we.task_id == (long)CostCode.Sick)  // 病假需要在假期余额表添加记录
                {
                    bll.UpdateTimeoffBalance(we.resource_id.Value, Tools.Date.DateHelper.TimeStampToUniversalDateTime(we.start_time.Value), (CostCode)we.task_id);
                    //var balance = bll.UpdateTimeoffBalance((long)we.resource_id, Tools.Date.DateHelper.TimeStampToDateTime((long)we.start_time), 0 - (decimal)we.hours_billed);
                    //tst_timeoff_balance bal = new tst_timeoff_balance();
                    //bal.object_id = we.id;
                    //bal.object_type_id = 2214;
                    //bal.task_id = we.task_id;
                    //bal.balance = balance + (decimal)we.hours_billed;
                    //balDal.Insert(bal);
                }
            }

            return(true);
        }
Exemple #7
0
        private bool saveop             = false;//保存状态
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!long.TryParse(Request.QueryString["id"], out id))
            {
                Response.End();
                return;
            }
            if (Request.QueryString["op"] != null)
            {
                op = Request.QueryString["op"].ToString();
            }
            if (!IsPostBack)
            {
                var user = UserInfoBLL.GetUserInfo(id);
                this.username.Text = user.name;
                //常规tab页
                //下拉框
                Bind();
                if (id > 0)
                {//改成修改界面
                    var resourcedata = urbll.GetSysResourceSingle(id);
                    var userdata     = urbll.GetSysUserSingle(id);
                    param.sys_res  = resourcedata;
                    param.sys_user = userdata;
                    if (resourcedata.avatar != null && !string.IsNullOrEmpty(resourcedata.avatar.ToString()))
                    {
                        avatarPath = resourcedata.avatar.ToString();
                    }
                    if (!string.IsNullOrEmpty(resourcedata.date_display_format_id.ToString()))//数据库存在日期格式
                    {
                        this.DateFormat.SelectedValue = resourcedata.date_display_format_id.ToString();
                    }
                    if (!string.IsNullOrEmpty(resourcedata.number_display_format_id.ToString()))//数据库存在数值格式
                    {
                        this.NumberFormat.SelectedValue = resourcedata.number_display_format_id.ToString();
                    }
                    if (!string.IsNullOrEmpty(resourcedata.time_display_format_id.ToString()))//数据库存在时间格式
                    {
                        this.TimeFormat.SelectedValue = resourcedata.time_display_format_id.ToString();
                    }
                    this.first_name.Text    = resourcedata.first_name;
                    this.last_name.Text     = resourcedata.last_name;
                    this.resource_name.Text = resourcedata.name;
                    if (resourcedata.title != null)
                    {
                        this.title.Text = resourcedata.title;
                    }
                    if (!string.IsNullOrEmpty(resourcedata.suffix_id.ToString())) //数据库存在称谓
                    {
                        this.NameSuffix.SelectedValue = resourcedata.suffix_id.ToString();
                    }
                    if (!string.IsNullOrEmpty(resourcedata.sex.ToString()))//数据库存在性别
                    {
                        this.Sex.SelectedValue = resourcedata.sex.ToString();
                    }
                    if (resourcedata.location_id != null && !string.IsNullOrEmpty(resourcedata.location_id.ToString()))
                    {//办公地址
                        this.Position.SelectedValue = resourcedata.location_id.ToString();
                    }
                    if (resourcedata.office_phone != null)//办公电话
                    {
                        this.office_phone.Text = resourcedata.office_phone.ToString();
                    }
                    if (resourcedata.home_phone != null)//家庭电话
                    {
                        this.home_phone.Text = resourcedata.home_phone.ToString();
                    }
                    if (resourcedata.mobile_phone != null && !string.IsNullOrEmpty(resourcedata.mobile_phone.ToString()))//移动电话
                    {
                        this.mobile_phone.Text = resourcedata.mobile_phone.ToString();
                    }
                    this.email.Text = resourcedata.email.ToString();                                          //邮箱地址
                    this.EmailType.SelectedValue = resourcedata.email_type_id.ToString();                     //邮箱类型
                    if (resourcedata.email1 != null && !string.IsNullOrEmpty(resourcedata.email1.ToString())) //附加邮箱
                    {
                        this.email1.Text = resourcedata.email1.ToString();
                    }
                    if (resourcedata.email2 != null && !string.IsNullOrEmpty(resourcedata.email2.ToString()))
                    {
                        this.email2.Text = resourcedata.email2.ToString();
                    }
                    if (resourcedata.email1_type_id != null && !string.IsNullOrEmpty(resourcedata.email1_type_id.ToString()))//附加邮箱类型
                    {
                        this.EmailType1.SelectedValue = resourcedata.email1_type_id.ToString();
                    }
                    if (resourcedata.email2_type_id != null && !string.IsNullOrEmpty(resourcedata.email2_type_id.ToString()))
                    {
                        this.EmailType2.SelectedValue = resourcedata.email2_type_id.ToString();
                    }

                    this.name.Text = string.IsNullOrEmpty(userdata.name) ? "" : userdata.name.ToString();//用户名
                    //if (resourcedata.is_active > 0)//是否激活
                    //    this.ACTIVE.Checked = true;
                    this.ACTIVE.Checked = resourcedata.is_active == 1;

                    if (resourcedata.security_level_id != null && !string.IsNullOrEmpty(resourcedata.security_level_id.ToString()))//权限级别
                    {
                        this.Security_Level.SelectedValue = resourcedata.security_level_id.ToString();
                    }
                    //this.password.Text = userdata.password.ToString();
                    //this.password2.Text= userdata.password.ToString();
                    //if (resourcedata.can_edit_skills > 0)//编辑技能
                    //    this.CanEditSkills.Checked = true;
                    //if (resourcedata.can_manage_kb_articles > 0)//编辑或删除知识库文章
                    //    this.CanManagekbarticles.Checked = true;
                    //if (resourcedata.allow_send_bulk_email > 0)//允许员工群发邮件
                    //    this.AllowSendbulkemail.Checked = true;
                    //if (resourcedata.required_to_submit_timesheets > 0)//不要求用户提交工时表
                    //    this.IsRequiredtosubmittimesheets.Checked = true;

                    this.CanEditSkills.Checked                = resourcedata.can_edit_skills == 1;
                    this.CanManagekbarticles.Checked          = resourcedata.can_manage_kb_articles == 1;
                    this.AllowSendbulkemail.Checked           = resourcedata.allow_send_bulk_email == 1;
                    this.IsRequiredtosubmittimesheets.Checked = resourcedata.required_to_submit_timesheets == 1;

                    if (resourcedata.outsource_security_role_type_id != null && !string.IsNullOrEmpty(resourcedata.outsource_security_role_type_id.ToString()))//外部权限
                    {
                        this.Outsource_Security.SelectedValue = resourcedata.outsource_security_role_type_id.ToString();
                    }



                    if (resourcedata.type_id != null)
                    {
                        type_id.SelectedValue = resourcedata.type_id.Value.ToString();
                    }
                    if (resourcedata.payroll_type_id != null)
                    {
                        payroll_type_id.SelectedValue = resourcedata.payroll_type_id.Value.ToString();
                    }
                    if (resourcedata.hire_date != null)
                    {
                        hire_date.Text = resourcedata.hire_date.Value.ToString("yyyy-MM-dd");
                    }
                    time_sheet_start_date.Text = resourcedata.time_sheet_start_date.ToString("yyyy-MM-dd");
                    if (resourcedata.payroll_identifier != null)
                    {
                        payroll_identifier.Text = resourcedata.payroll_identifier;
                    }
                    if (resourcedata.accounting_reference_id != null)
                    {
                        accounting_reference_id.Text = resourcedata.accounting_reference_id;
                    }
                    var resAvlb = urbll.GetResourceAvailability(id);
                    if (resAvlb != null)
                    {
                        monday.Text    = resAvlb.monday == null ? "0.00" : resAvlb.monday.Value.ToString();
                        tuesday.Text   = resAvlb.tuesday == null ? "0.00" : resAvlb.tuesday.Value.ToString();
                        wednesday.Text = resAvlb.wednesday == null ? "0.00" : resAvlb.wednesday.Value.ToString();
                        thursday.Text  = resAvlb.thursday == null ? "0.00" : resAvlb.thursday.Value.ToString();
                        friday.Text    = resAvlb.friday == null ? "0.00" : resAvlb.friday.Value.ToString();
                        saturday.Text  = resAvlb.saturday == null ? "0.00" : resAvlb.saturday.Value.ToString();
                        sunday.Text    = resAvlb.sunday == null ? "0.00" : resAvlb.sunday.Value.ToString();
                        total.Value    = resAvlb.total == null ? "0.00" : resAvlb.total.Value.ToString();
                        goal.Text      = resAvlb.goal == null ? "0.00" : resAvlb.goal.Value.ToString();
                        if (resAvlb.travel_restrictions_id != null)
                        {
                            travel_restrictions_id.SelectedValue = resAvlb.travel_restrictions_id.Value.ToString();
                        }
                    }
                    var policy = urbll.GetResourceTimeoffPolicy(id);
                    if (policy != null)
                    {
                        timeoff_policy_id.SelectedValue = policy.timeoff_policy_id.ToString();
                        effective_date.Text             = policy.effective_date.ToString("yyyy-MM-dd");
                        timeoff_policy_id.Enabled       = false;
                        effective_date.ReadOnly         = true;
                    }
                    var time1 = urbll.GetResAdddtionalTime(id, DateTime.Now.Year);
                    if (time1 != null)
                    {
                        TextBox1.Text = time1.time_vacation == null ? "0.000" : time1.time_vacation.Value.ToString();
                        TextBox2.Text = time1.time_personal == null ? "0.000" : time1.time_personal.Value.ToString();
                        TextBox3.Text = time1.time_sick == null ? "0.000" : time1.time_sick.Value.ToString();
                        TextBox4.Text = time1.time_float == null ? "0.000" : time1.time_float.Value.ToString();
                    }
                    var time2 = urbll.GetResAdddtionalTime(id, DateTime.Now.Year + 1);
                    if (time2 != null)
                    {
                        TextBox5.Text = time2.time_vacation == null ? "0.000" : time2.time_vacation.Value.ToString();
                        TextBox6.Text = time2.time_personal == null ? "0.000" : time2.time_personal.Value.ToString();
                        TextBox7.Text = time2.time_sick == null ? "0.000" : time2.time_sick.Value.ToString();
                        TextBox8.Text = time2.time_float == null ? "0.000" : time2.time_float.Value.ToString();
                    }
                }
            }
            else
            {
                avatarPath = SavePic();//保存头像
            }

            var tmoffBll = new TimeOffPolicyBLL();

            timeoffYear1 = tmoffBll.GetResourceTimeoffTotal(id, DateTime.Now.Year);
            timeoffYear2 = tmoffBll.GetResourceTimeoffTotal(id, DateTime.Now.Year + 1);
        }
Exemple #8
0
        private void Bind()
        {
            var dic = new UserResourceBLL().GetDownList();

            // 日期格式
            this.DateFormat.DataTextField  = "show";
            this.DateFormat.DataValueField = "val";
            this.DateFormat.DataSource     = dic.FirstOrDefault(_ => _.Key == "DateFormat").Value;
            this.DateFormat.DataBind();
            // DateFormat.Items.Insert(0, new ListItem() { Value = "0", Text = "   ", Selected = true });
            //数字格式
            this.NumberFormat.DataTextField  = "show";
            this.NumberFormat.DataValueField = "val";
            this.NumberFormat.DataSource     = dic.FirstOrDefault(_ => _.Key == "NumberFormat").Value;
            NumberFormat.DataBind();
            // NumberFormat.Items.Insert(0, new ListItem() { Value = "0", Text = "   ", Selected = true });
            //TimeFormat时间格式
            this.TimeFormat.DataTextField  = "show";
            this.TimeFormat.DataValueField = "val";
            this.TimeFormat.DataSource     = dic.FirstOrDefault(_ => _.Key == "TimeFormat").Value;
            TimeFormat.DataBind();
            // TimeFormat.Items.Insert(0, new ListItem() { Value = "0", Text = "   ", Selected = true });
            //EmailType50
            this.EmailType.DataTextField  = "show";
            this.EmailType.DataValueField = "val";
            this.EmailType.DataSource     = dic.FirstOrDefault(_ => _.Key == "EmailType").Value;
            EmailType.DataBind();
            EmailType.Items.Insert(0, new ListItem()
            {
                Value = "0", Text = "   ", Selected = true
            });
            this.EmailType1.DataTextField  = "show";
            this.EmailType1.DataValueField = "val";
            this.EmailType1.DataSource     = dic.FirstOrDefault(_ => _.Key == "EmailType").Value;
            EmailType1.DataBind();
            EmailType1.Items.Insert(0, new ListItem()
            {
                Value = "0", Text = "   ", Selected = true
            });
            this.EmailType2.DataTextField  = "show";
            this.EmailType2.DataValueField = "val";
            this.EmailType2.DataSource     = dic.FirstOrDefault(_ => _.Key == "EmailType").Value;
            EmailType2.DataBind();
            EmailType2.Items.Insert(0, new ListItem()
            {
                Value = "0", Text = "   ", Selected = true
            });
            //Sex49
            this.Sex.DataTextField  = "show";
            this.Sex.DataValueField = "val";
            this.Sex.DataSource     = dic.FirstOrDefault(_ => _.Key == "Sex").Value;
            Sex.DataBind();
            Sex.Items.Insert(0, new ListItem()
            {
                Value = "0", Text = "   ", Selected = true
            });
            //NameSuffix
            this.NameSuffix.DataTextField  = "show";
            this.NameSuffix.DataValueField = "val";
            this.NameSuffix.DataSource     = dic.FirstOrDefault(_ => _.Key == "NameSuffix").Value;
            NameSuffix.DataBind();
            NameSuffix.Items.Insert(0, new ListItem()
            {
                Value = "0", Text = "   ", Selected = true
            });
            //Prefix前缀
            //Prefix.Items.Insert(0, new ListItem() { Value = "0", Text = "   ", Selected = true });
            //Prefix.Items.Insert(1, new ListItem() { Value = "1", Text = "Mr." });
            //Prefix.Items.Insert(2, new ListItem() { Value = "2", Text = "Mrs." });
            //Prefix.Items.Insert(3, new ListItem() { Value = "3", Text = "Ms." });
            //主要位置  location_id

            this.Position.DataTextField  = "name";
            this.Position.DataValueField = "id";
            this.Position.DataSource     = dic.FirstOrDefault(_ => _.Key == "Position").Value;
            Position.DataBind();
            Position.Items.Insert(0, new ListItem()
            {
                Value = "0", Text = "   ", Selected = true
            });
            Position.Items.Insert(1, new ListItem()
            {
                Value = "1", Text = "总部"
            });
            //授权tab页

            //权限等级
            //this.Security_Level
            this.Security_Level.DataTextField  = "name";
            this.Security_Level.DataValueField = "id";
            this.Security_Level.DataSource     = dic.FirstOrDefault(_ => _.Key == "Security_Level").Value;
            Security_Level.DataBind();
            Security_Level.Items.Insert(0, new ListItem()
            {
                Value = "0", Text = "   ", Selected = true
            });
            //外包权限
            //this.Outsource_Security
            this.Outsource_Security.DataTextField  = "show";
            this.Outsource_Security.DataValueField = "val";
            this.Outsource_Security.DataSource     = dic.FirstOrDefault(_ => _.Key == "Outsource_Security").Value;
            Outsource_Security.DataBind();
            Outsource_Security.Items.Insert(0, new ListItem()
            {
                Value = "0", Text = "   ", Selected = true
            });

            //员工类型
            var genBll  = new GeneralBLL();
            var resType = genBll.GetDicValues(GeneralTableEnum.RESOURCE_TYPE);

            type_id.DataTextField  = "show";
            type_id.DataValueField = "val";
            type_id.DataSource     = resType;
            type_id.DataBind();

            //薪资类型
            var payType = genBll.GetDicValues(GeneralTableEnum.PAYROLL_TYPE);

            payroll_type_id.DataTextField  = "show";
            payroll_type_id.DataValueField = "val";
            payroll_type_id.DataSource     = payType;
            payroll_type_id.DataBind();

            hire_date.Text             = DateTime.Now.ToString("yyyy-MM-dd");
            time_sheet_start_date.Text = DateTime.Now.ToString("yyyy-MM-dd");

            var tmoffBll = new TimeOffPolicyBLL();
            // 休假方案
            var policyList = tmoffBll.GetPolicyList();

            timeoff_policy_id.DataTextField  = "name";
            timeoff_policy_id.DataValueField = "id";
            timeoff_policy_id.DataSource     = policyList;
            timeoff_policy_id.DataBind();
            timeoff_policy_id.Items.Insert(0, new ListItem()
            {
                Value = "0", Text = "", Selected = true
            });

            // 出差限度
            var travelRest = genBll.GetDicValues(GeneralTableEnum.TRAVEL_RESTRICTIONS);

            travel_restrictions_id.DataTextField  = "show";
            travel_restrictions_id.DataValueField = "val";
            travel_restrictions_id.DataSource     = travelRest;
            travel_restrictions_id.DataBind();
        }