/// <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); }
/// <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); }
/// <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); }
/// <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(); } }
/// <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); }
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); }
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(); }