/// <summary> /// 表单初始化 /// </summary> private void InitForm() { entFreeLeaveDaySet = new T_HR_FREELEAVEDAYSET(); entFreeLeaveDaySet.FREELEAVEDAYSETID = System.Guid.NewGuid().ToString().ToUpper(); if (LeaveTypeSet == null) { LeaveTypeSet = new T_HR_LEAVETYPESET(); } entFreeLeaveDaySet.T_HR_LEAVETYPESET = LeaveTypeSet; //权限控制 entFreeLeaveDaySet.OWNERCOMPANYID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; entFreeLeaveDaySet.OWNERDEPARTMENTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID; entFreeLeaveDaySet.OWNERPOSTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].PostID; entFreeLeaveDaySet.OWNERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID; //2010年2月11日, 11:37:35,目前暂未实现登录部分,人员相关数据为假定值 entFreeLeaveDaySet.CREATEDATE = DateTime.Now; entFreeLeaveDaySet.CREATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID; entFreeLeaveDaySet.UPDATEDATE = System.DateTime.Now; entFreeLeaveDaySet.UPDATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID; //页面初始化加载的临时数据 entFreeLeaveDaySet.MINIMONTH = decimal.Parse("0"); entFreeLeaveDaySet.MAXMONTH = decimal.Parse("0"); entFreeLeaveDaySet.LEAVEDAYS = decimal.Parse("0"); entFreeLeaveDaySet.ISPERFECTATTENDANCEFACTOR = "1";//默认为否 entFreeLeaveDaySet.OFFESTTYPE = "0"; this.DataContext = entFreeLeaveDaySet; }
/// <summary> /// 表单初始化 /// </summary> private void InitForm() { entLeaveTypeSet = new T_HR_LEAVETYPESET(); entLeaveTypeSet.LEAVETYPESETID = System.Guid.NewGuid().ToString().ToUpper(); entLeaveTypeSet.ISFREELEAVEDAY = "1"; //权限控制 entLeaveTypeSet.OWNERCOMPANYID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; entLeaveTypeSet.OWNERDEPARTMENTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID; entLeaveTypeSet.OWNERPOSTID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].PostID; entLeaveTypeSet.OWNERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID; //2010年2月11日, 11:37:35,目前暂未实现登录部分,人员相关数据为假定值 entLeaveTypeSet.CREATEDATE = DateTime.Now; entLeaveTypeSet.CREATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID; entLeaveTypeSet.UPDATEDATE = System.DateTime.Now; entLeaveTypeSet.UPDATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID; //页面初始化加载的临时数据 entLeaveTypeSet.FINETYPE = "0"; entLeaveTypeSet.MAXDAYS = decimal.Parse("0"); entLeaveTypeSet.SEXRESTRICT = "2"; rbNoLimit.IsChecked = true; this.DataContext = entLeaveTypeSet; }
/// <summary> /// 编辑 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void btnLTEdit_Click(object sender, RoutedEventArgs e) { string strLeaveTypeSetID = string.Empty; if (dgLTList.SelectedItems == null) { ComfirmWindow.ConfirmationBox(Utility.GetResourceStr("CONFIRMINFO"), Utility.GetResourceStr("SELECTERROR", "EDIT"), Utility.GetResourceStr("CONFIRMBUTTON")); return; } if (dgLTList.SelectedItems.Count == 0) { ComfirmWindow.ConfirmationBox(Utility.GetResourceStr("CONFIRMINFO"), Utility.GetResourceStr("SELECTERROR", "EDIT"), Utility.GetResourceStr("CONFIRMBUTTON")); return; } T_HR_LEAVETYPESET ent = dgLTList.SelectedItems[0] as T_HR_LEAVETYPESET; strLeaveTypeSetID = ent.LEAVETYPESETID.ToString(); LeaveTypeSetForm formLeaveTypeSet = new LeaveTypeSetForm(FormTypes.Edit, strLeaveTypeSetID); EntityBrowser entBrowser = new EntityBrowser(formLeaveTypeSet); formLeaveTypeSet.MinWidth = 630; formLeaveTypeSet.MinHeight = 600; entBrowser.FormType = FormTypes.Edit; entBrowser.ReloadDataEvent += new EntityBrowser.refreshGridView(entBrowser_ReloadDataEvent); entBrowser.Show <string>(DialogMode.Default, SMT.SAAS.Main.CurrentContext.Common.ParentLayoutRoot, "", (result) => { }); }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void btnLTDelete_Click(object sender, RoutedEventArgs e) { string strID = ""; if (dgLTList.SelectedItems == null) { ComfirmWindow.ConfirmationBox(Utility.GetResourceStr("CONFIRMINFO"), Utility.GetResourceStr("SELECTERROR", "DELETE"), Utility.GetResourceStr("CONFIRMBUTTON")); return; } if (dgLTList.SelectedItems.Count == 0) { ComfirmWindow.ConfirmationBox(Utility.GetResourceStr("CONFIRMINFO"), Utility.GetResourceStr("SELECTERROR", "DELETE"), Utility.GetResourceStr("CONFIRMBUTTON")); return; } foreach (object ovj in dgLTList.SelectedItems) { T_HR_LEAVETYPESET ent = ovj as T_HR_LEAVETYPESET; string Result = ""; if (ent != null) { strID = ent.LEAVETYPESETID; ComfirmWindow delComfirm = new ComfirmWindow(); delComfirm.OnSelectionBoxClosed += (obj, result) => { clientAtt.RemoveLeaveTypeSetAsync(strID); }; delComfirm.SelectionBox(Utility.GetResourceStr("DELETECONFIRM"), Utility.GetResourceStr("DELETEALTER"), ComfirmWindow.titlename, Result); } } }
/// <summary> /// 根据主键索引,获得指定的假期记录以便查看编辑 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void clientAtt_GetLeaveTypeSetByIDCompleted(object sender, GetLeaveTypeSetByIDCompletedEventArgs e) { if (e.Error == null) { entLeaveTypeSet = e.Result; this.DataContext = entLeaveTypeSet; cbxkLeaveTypeValue.IsEnabled = false; cbxEntryRestrict.IsChecked = false; if (entLeaveTypeSet.ENTRYRESTRICT == (Convert.ToInt32(IsChecked.Yes) + 1).ToString()) { cbxEntryRestrict.IsChecked = true; } toolbar1.IsEnabled = false; dataPager.IsEnabled = false; if (entLeaveTypeSet.FINETYPE == (Convert.ToInt32(LeaveFineType.Free) + 1).ToString()) { toolbar1.IsEnabled = true; dataPager.IsEnabled = true; } CheckIsFreeLeave(); BindGrid(); SetToolBar(); } else { Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr(e.Error.Message)); } loadbar.Stop(); }
public FreeLeaveDaySetForm(FormTypes formtype, string strFreeLeaveDaySetID, T_HR_LEAVETYPESET entLeaveTypeSet) { FormType = formtype; FreeLeaveDaySetID = strFreeLeaveDaySetID; LeaveTypeSet = entLeaveTypeSet; InitializeComponent(); this.Loaded += new RoutedEventHandler(FreeLeaveDaySetForm_Loaded); }
/// <summary> /// 效验提交的表单 /// </summary> /// <param name="entFreeLeaveDaySet"></param> /// <returns></returns> private void CheckSubmitForm(out bool flag) { flag = false; if (lkLeaveTypeName.DataContext == null) { Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("LEAVETYPESET"), string.Format(Utility.GetResourceStr("REQUIRED"), Utility.GetResourceStr("LEAVETYPESET"))); flag = false; return; } else { T_HR_LEAVETYPESET entLeaveTypeSet = lkLeaveTypeName.DataContext as T_HR_LEAVETYPESET; if (string.IsNullOrEmpty(entLeaveTypeSet.LEAVETYPESETID)) { Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("LEAVETYPESET"), string.Format(Utility.GetResourceStr("REQUIRED"), Utility.GetResourceStr("LEAVETYPESET"))); flag = false; return; } flag = true; entFreeLeaveDaySet.T_HR_LEAVETYPESET = entLeaveTypeSet; } if (nudMaxMonth.Value == 0) { nudMaxMonth.Value = dmaxMonth; entFreeLeaveDaySet.MAXMONTH = dmaxMonth; } double dLimitMinMonth = 0, dLimitMaxMonth = 0; dLimitMinMonth = nudMiniMonth.Value; dLimitMaxMonth = nudMaxMonth.Value; if (dLimitMinMonth > dLimitMaxMonth) { Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("FREELEAVEDAYSET_MAXMONTH"), Utility.GetResourceStr("DATECOMPARE", "FREELEAVEDAYSET_MAXMONTH, FREELEAVEDAYSET_MINIMONTH")); flag = false; return; } entFreeLeaveDaySet.ISPERFECTATTENDANCEFACTOR = (Convert.ToInt32(IsChecked.No) + 1).ToString(); if (cbxIsPerfectAttendanceFactor.IsChecked.Value == true) { entFreeLeaveDaySet.ISPERFECTATTENDANCEFACTOR = (Convert.ToInt32(IsChecked.Yes) + 1).ToString(); } if (!flag) { return; } if (FormType == FormTypes.Edit) { entFreeLeaveDaySet.UPDATEDATE = DateTime.Now; entFreeLeaveDaySet.UPDATEUSERID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID; } }
/// <summary> /// 校验输入的查询条件 /// </summary> /// <param name="strLeaveTypeSetID"></param> /// <param name="strIsFactor"></param> private void CheckInputFilter(ref string strLeaveTypeSetID) { if (lkLeaveTypeName.SelectItem != null) { T_HR_LEAVETYPESET entLeaveTypeSet = lkLeaveTypeName.SelectItem as T_HR_LEAVETYPESET; if (!string.IsNullOrEmpty(entLeaveTypeSet.LEAVETYPESETID)) { strLeaveTypeSetID = entLeaveTypeSet.LEAVETYPESETID; } } }
/// <summary> /// 添加职员信息转存到银行 /// </summary> private void AddLeaveItemToList() { Dictionary <string, string> cols = new Dictionary <string, string>(); cols.Add("VACATIONNAME", "LEAVETYPENAME"); cols.Add("FINETYPE", "FINETYPE,LEAVEFINETYPE,DICTIONARYCONVERTER"); cols.Add("LEAVEMAXDAYS", "MAXDAYS"); StringBuilder strfilter = new StringBuilder(); ObservableCollection <object> objArgs = new ObservableCollection <object>(); strfilter.Append(" ISFREELEAVEDAY == @0"); objArgs.Add((Convert.ToInt32(IsChecked.Yes) + 1).ToString()); LookupForm lookup = new LookupForm(SMT.Saas.Tools.OrganizationWS.EntityNames.LeaveTypeSet, typeof(T_HR_LEAVETYPESET[]), cols, strfilter.ToString(), objArgs); lookup.SelectedClick += (o, ev) => { T_HR_LEAVETYPESET ent = lookup.SelectedObj as T_HR_LEAVETYPESET; if (ent != null) { T_HR_LEAVETYPESET entView = ent; ObservableCollection <T_HR_LEAVETYPESET> entList = new ObservableCollection <T_HR_LEAVETYPESET>(); if (dgLeaveSetlist.ItemsSource != null) { entList = dgLeaveSetlist.ItemsSource as ObservableCollection <T_HR_LEAVETYPESET>; bool flag = false; flag = IsContainsEntity(entList, entView); if (flag) { return; } } entList.Add(entView); dgLeaveSetlist.ItemsSource = entList; } }; lookup.Show <string>(DialogMode.Default, SMT.SAAS.Main.CurrentContext.Common.ParentLayoutRoot, "", (result) => { }); }
/// <summary> /// 显示选中项的假期标准详细内容 /// </summary> private void ShowLeaveTypeSetForm() { if (dgLTList.ItemsSource == null) { entLeaveTypeSet = new T_HR_LEAVETYPESET(); this.DataContext = entLeaveTypeSet; BindFreeLeaveDaySet(); return; } if (dgLTList.SelectedItems.Count == 0) { IEnumerable <T_HR_LEAVETYPESET> entList = dgLTList.ItemsSource as IEnumerable <T_HR_LEAVETYPESET>; entLeaveTypeSet = entList.FirstOrDefault(); } else { entLeaveTypeSet = dgLTList.SelectedItems[0] as T_HR_LEAVETYPESET; } if (entLeaveTypeSet != null) { this.DataContext = entLeaveTypeSet; switch (entLeaveTypeSet.SEXRESTRICT) { case "0": tbSexRestrict.Text = Utility.GetResourceStr("GRIL"); break; case "1": tbSexRestrict.Text = Utility.GetResourceStr("MAN"); break; case "2": tbSexRestrict.Text = Utility.GetResourceStr("NOLIMIT"); break; default: tbSexRestrict.Text = string.Empty; break; } BindFreeLeaveDaySet(); } }
/// <summary> /// 删除Grid中的指定项 /// </summary> private void DelLeaveItemFromList() { if (dgLeaveSetlist.SelectedItems == null) { ComfirmWindow.ConfirmationBox(Utility.GetResourceStr("CONFIRMINFO"), Utility.GetResourceStr("SELECTERROR", "DELETE"), Utility.GetResourceStr("CONFIRMBUTTON")); return; } if (dgLeaveSetlist.SelectedItems.Count == 0) { ComfirmWindow.ConfirmationBox(Utility.GetResourceStr("CONFIRMINFO"), Utility.GetResourceStr("SELECTERROR", "DELETE"), Utility.GetResourceStr("CONFIRMBUTTON")); return; } //ObservableCollection<SMT.Saas.Tools.OrganizationWS.T_HR_FREELEAVEDAYSET> entList = Utility.Clone<ObservableCollection<SMT.Saas.Tools.OrganizationWS.T_HR_FREELEAVEDAYSET>>(dgLeaveSetlist.ItemsSource as ObservableCollection<SMT.Saas.Tools.OrganizationWS.T_HR_FREELEAVEDAYSET>); ObservableCollection <T_HR_LEAVETYPESET> entList = dgLeaveSetlist.ItemsSource as ObservableCollection <T_HR_LEAVETYPESET>; ObservableCollection <T_HR_LEAVETYPESET> entTemps = new ObservableCollection <T_HR_LEAVETYPESET>(); for (int i = 0; i < dgLeaveSetlist.SelectedItems.Count; i++) { entTemps.Add(dgLeaveSetlist.SelectedItems[i] as T_HR_LEAVETYPESET); } int iSel = entTemps.Count; for (int i = 0; i < iSel; i++) { T_HR_LEAVETYPESET entTemp = entTemps[i] as T_HR_LEAVETYPESET; for (int j = 0; j < entList.Count; j++) { if (entList[j].LEAVETYPESETID == entTemp.LEAVETYPESETID) { entList.RemoveAt(j); } } } dgLeaveSetlist.ItemsSource = entList; }
/// <summary> /// 考勤方案查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> //private void lkAttendanceSolutionName_FindClick(object sender, EventArgs e) //{ // Dictionary<string, string> cols = new Dictionary<string, string>(); // cols.Add("ATTENDANCESOLUTIONID", "ATTENDANCESOLUTIONID"); // cols.Add("ATTENDANCESOLUTIONNAME", "ATTENDANCESOLUTIONNAME"); // LookupForm lookup = new LookupForm(SMT.Saas.Tools.OrganizationWS.EntityNames.AttendanceSolution, // typeof(T_HR_ATTENDANCESOLUTION[]), cols); // lookup.SelectedClick += (o, ev) => // { // T_HR_ATTENDANCESOLUTION ent = lookup.SelectedObj as T_HR_ATTENDANCESOLUTION; // if (ent != null) // { // lkAttendanceSolutionName.DataContext = ent; // } // }; // // lookup.Show<string>(DialogMode.Default, SMT.SAAS.Main.CurrentContext.Common.ParentLayoutRoot, "", (result) =>{}); //} /// <summary> /// 请假类型查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void lkLeaveTypeName_FindClick(object sender, EventArgs e) { Dictionary <string, string> cols = new Dictionary <string, string>(); cols.Add("VACATIONNAME", "LEAVETYPENAME"); cols.Add("FINETYPE", "FINETYPE"); cols.Add("LEAVEMAXDAYS", "MAXDAYS"); LookupForm lookup = new LookupForm(SMT.Saas.Tools.OrganizationWS.EntityNames.LeaveTypeSet, typeof(T_HR_LEAVETYPESET[]), cols); lookup.SelectedClick += (o, ev) => { T_HR_LEAVETYPESET ent = lookup.SelectedObj as T_HR_LEAVETYPESET; if (ent != null) { lkLeaveTypeName.DataContext = ent; } }; lookup.Show <string>(DialogMode.Default, SMT.SAAS.Main.CurrentContext.Common.ParentLayoutRoot, "", (result) => {}); }
/// <summary> /// 根据查询条件,调用WCF服务获取数据,以便加载数据列表 /// </summary> private void BindGrid() { int pageCount = 0; string filter = ""; //string filter2 = ""; System.Collections.ObjectModel.ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); string startDate = string.Empty, recorderDate = string.Empty, employeeID = string.Empty, leaveTypeSetID = string.Empty;//起始时间和结束时间 if (lkEmpName.DataContext != null) { SMT.Saas.Tools.PersonnelWS.T_HR_EMPLOYEE ent = lkEmpName.DataContext as SMT.Saas.Tools.PersonnelWS.T_HR_EMPLOYEE; if (!string.IsNullOrEmpty(ent.EMPLOYEEID)) { employeeID = ent.EMPLOYEEID; if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "EMPLOYEEID==@" + paras.Count().ToString(); paras.Add(ent.EMPLOYEEID); } } if (this.lkLeaveTypeName.DataContext != null) { T_HR_LEAVETYPESET entLeaveType = this.lkLeaveTypeName.DataContext as T_HR_LEAVETYPESET; leaveTypeSetID = entLeaveType.LEAVETYPESETID; if (!string.IsNullOrEmpty(entLeaveType.LEAVETYPESETID)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "T_HR_LEAVETYPESET.LEAVETYPESETID==@" + paras.Count().ToString(); paras.Add(entLeaveType.LEAVETYPESETID); } } startDate = nuYear.Value.ToString() + "-" + startMonth.Value.ToString() + "-1"; recorderDate = endYear.Value.ToString() + "-" + (nuMonth.Value + 1).ToString() + "-1"; if (nuMonth.Value == 12) { recorderDate = (endYear.Value + 1).ToString() + "-1-1"; } if (DateTime.Parse(startDate) <= DateTime.Parse("1900-1-1")) { startDate = string.Empty; } if (DateTime.Parse(recorderDate) <= DateTime.Parse("1900-1-1")) { recorderDate = string.Empty; } //起始时间 //if (!string.IsNullOrEmpty(startDate)) //{ // if (!string.IsNullOrEmpty(filter)) // { // filter += " and "; // } // filter += "STARTDATETIME>=@" + paras.Count().ToString(); // paras.Add(Convert.ToDateTime(startDate)); //} ////结束时间 //if (!string.IsNullOrEmpty(recorderDate)) //{ // if (!string.IsNullOrEmpty(filter)) // { // filter += " and "; // } // filter += "ENDDATETIME<@" + paras.Count().ToString(); // paras.Add(Convert.ToDateTime(recorderDate)); //} if (toolbar1.cbxCheckState.SelectedItem != null) { T_SYS_DICTIONARY entDic = toolbar1.cbxCheckState.SelectedItem as T_SYS_DICTIONARY; Checkstate = entDic.DICTIONARYVALUE.ToString(); } client.EmployeeLeaveRecordPagedAsync(dataPager.PageIndex, dataPager.PageSize, "STARTDATETIME", filter, paras, pageCount, Checkstate, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, startDate, recorderDate, employeeID, leaveTypeSetID); loadbar.Start(); }
public string ModifyLeaveTypeSet(T_HR_LEAVETYPESET entLTRd) { using (LeaveTypeSetBLL bllLeaveTypeSet = new LeaveTypeSetBLL()) { return bllLeaveTypeSet.ModifyLeaveTypeSet(entLTRd); } }
/// <summary> /// 导出 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void btnOutExcel_Click(object sender, RoutedEventArgs e) { //ExportToCSV.ExportDataGridSaveAs(dgEmpLeaveRdList); dialog.DefaultExt = ".xls"; dialog.Filter = "MS Excel Files|*.xls"; dialog.FilterIndex = 1; result = dialog.ShowDialog(); if (result.Value == true) { int pageCount = 0; string filter = ""; //string filter2 = ""; System.Collections.ObjectModel.ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); string startDate = string.Empty, recorderDate = string.Empty, employeeID = string.Empty, leaveTypeSetID = string.Empty;//起始时间和结束时间 if (lkEmpName.DataContext != null) { SMT.Saas.Tools.PersonnelWS.T_HR_EMPLOYEE ent = lkEmpName.DataContext as SMT.Saas.Tools.PersonnelWS.T_HR_EMPLOYEE; if (!string.IsNullOrEmpty(ent.EMPLOYEEID)) { employeeID = ent.EMPLOYEEID; if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "EMPLOYEEID==@" + paras.Count().ToString(); paras.Add(ent.EMPLOYEEID); } } if (this.lkLeaveTypeName.DataContext != null) { T_HR_LEAVETYPESET entLeaveType = this.lkLeaveTypeName.DataContext as T_HR_LEAVETYPESET; leaveTypeSetID = entLeaveType.LEAVETYPESETID; if (!string.IsNullOrEmpty(entLeaveType.LEAVETYPESETID)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "T_HR_LEAVETYPESET.LEAVETYPESETID==@" + paras.Count().ToString(); paras.Add(entLeaveType.LEAVETYPESETID); } } startDate = nuYear.Value.ToString() + "-" + startMonth.Value.ToString() + "-1"; recorderDate = endYear.Value.ToString() + "-" + (nuMonth.Value + 1).ToString() + "-1"; if (nuMonth.Value == 12) { recorderDate = (endYear.Value + 1).ToString() + "-1-1"; } if (DateTime.Parse(startDate) <= DateTime.Parse("1900-1-1")) { startDate = string.Empty; } if (DateTime.Parse(recorderDate) <= DateTime.Parse("1900-1-1")) { recorderDate = string.Empty; } //起始时间 if (!string.IsNullOrEmpty(startDate)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "STARTDATETIME>=@" + paras.Count().ToString(); paras.Add(Convert.ToDateTime(startDate)); } //结束时间 if (!string.IsNullOrEmpty(recorderDate)) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += "ENDDATETIME<@" + paras.Count().ToString(); paras.Add(Convert.ToDateTime(recorderDate)); } if (toolbar1.cbxCheckState.SelectedItem != null) { T_SYS_DICTIONARY entDic = toolbar1.cbxCheckState.SelectedItem as T_SYS_DICTIONARY; Checkstate = entDic.DICTIONARYVALUE.ToString(); } client.ExportEmployeeLeaveRecordReportsAsync(1, int.MaxValue, "STARTDATETIME", filter, paras, pageCount, Checkstate, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, startDate, recorderDate, employeeID, leaveTypeSetID); loadbar.Start(); } }
/// <summary> /// 初始化五四三八数据 /// </summary> public void InitYouth() { try { var ents = from ent in dal.GetObjects <T_HR_ATTENDANCESOLUTION>() where ent.CHECKSTATE == "2" orderby ent.CREATEDATE ascending select ent; SMT.Foundation.Log.Tracer.Debug("总数量为:" + ents.Count().ToString()); int intCount = 0; foreach (var ent in ents) { //if (ent.ATTENDANCESOLUTIONID == "1214E853-3536-456F-BBC9-66A059A903A6") //{ // continue; //} #region 八 T_HR_LEAVETYPESET typeset = new T_HR_LEAVETYPESET(); typeset.LEAVETYPESETID = Guid.NewGuid().ToString(); typeset.LEAVETYPENAME = ent.ATTENDANCESOLUTIONNAME + "三八妇女节"; typeset.LEAVETYPEVALUE = "13"; typeset.ISFREELEAVEDAY = "2"; typeset.MAXDAYS = (decimal)0.53; typeset.FINETYPE = "1"; typeset.SEXRESTRICT = "0"; typeset.ENTRYRESTRICT = "1"; typeset.OWNERCOMPANYID = ent.OWNERCOMPANYID; typeset.OWNERDEPARTMENTID = ent.OWNERDEPARTMENTID; typeset.OWNERPOSTID = ent.OWNERPOSTID; typeset.OWNERID = ent.OWNERID; typeset.CREATEDATE = DateTime.Now; typeset.UPDATEDATE = DateTime.Now; typeset.UPDATEUSERID = ent.OWNERID; typeset.CREATECOMPANYID = ent.OWNERCOMPANYID; typeset.CREATEDEPARTMENTID = ent.OWNERDEPARTMENTID; typeset.CREATEPOSTID = ent.OWNERPOSTID; typeset.CREATEUSERID = ent.OWNERID; typeset.REMARK = "系统产生三八妇女节"; var entExist = from ent1 in dal.GetObjects <T_HR_LEAVETYPESET>() where ent1.LEAVETYPEVALUE == "13" && ent1.OWNERCOMPANYID == ent.OWNERCOMPANYID select ent1; LeaveTypeSetBLL bllLeaveTypeSet = new LeaveTypeSetBLL(); if (entExist.Count() == 0) { string aaa = bllLeaveTypeSet.AddLeaveTypeSet(typeset); if (aaa == "{SAVESUCCESSED}") { SMT.Foundation.Log.Tracer.Debug(ent.ATTENDANCESOLUTIONNAME + "产生了三八节"); } else { SMT.Foundation.Log.Tracer.Debug(ent.ATTENDANCESOLUTIONNAME + "没有产生三八节"); continue; } } else { typeset = entExist.FirstOrDefault(); } //int iii = dal.Add(typeset); //if (iii > 0) //{ // SMT.Foundation.Log.Tracer.Debug(ent.ATTENDANCESOLUTIONNAME +"产生了三八节"); //} //dal.SaveContextChanges(); //dal.AddToContext(typeset); T_HR_FREELEAVEDAYSET freeTypeSet = new T_HR_FREELEAVEDAYSET(); freeTypeSet.FREELEAVEDAYSETID = Guid.NewGuid().ToString(); freeTypeSet.T_HR_LEAVETYPESET = typeset; //freeTypeSet.T_HR_LEAVETYPESETReference.EntityKey = //new System.Data.EntityKey("TM_SaaS_OA_EFModelContext.T_HR_LEAVETYPESET", "LEAVETYPESETID", typeset.LEAVETYPESETID); freeTypeSet.MINIMONTH = 0; freeTypeSet.MAXMONTH = 9999; freeTypeSet.LEAVEDAYS = (decimal)0.53; freeTypeSet.ISPERFECTATTENDANCEFACTOR = "1"; freeTypeSet.OFFESTTYPE = "1"; freeTypeSet.OWNERCOMPANYID = ent.OWNERCOMPANYID; freeTypeSet.OWNERDEPARTMENTID = ent.OWNERDEPARTMENTID; freeTypeSet.OWNERPOSTID = ent.OWNERPOSTID; freeTypeSet.OWNERID = ent.OWNERID; freeTypeSet.CREATEDATE = DateTime.Now; freeTypeSet.UPDATEDATE = DateTime.Now; freeTypeSet.UPDATEUSERID = ent.OWNERID; freeTypeSet.CREATECOMPANYID = ent.OWNERCOMPANYID; freeTypeSet.CREATEDEPARTMENTID = ent.OWNERDEPARTMENTID; freeTypeSet.CREATEPOSTID = ent.OWNERPOSTID; freeTypeSet.CREATEUSERID = ent.OWNERID; freeTypeSet.REMARK = "系统产生三八妇女节带薪假"; //dal.AddToContext(freeTypeSet); FreeLeaveDaySetBLL bllFreeLeaveDaySet = new FreeLeaveDaySetBLL(); string aa2 = bllFreeLeaveDaySet.AddFreeLeaveDaySet(freeTypeSet); if (aa2 == "{SAVESUCCESSED}") { SMT.Foundation.Log.Tracer.Debug(ent.ATTENDANCESOLUTIONNAME + "产生了带薪假三八节"); } else { SMT.Foundation.Log.Tracer.Debug(ent.ATTENDANCESOLUTIONNAME + "没有产生带薪假三八节"); continue; } T_HR_ATTENDFREELEAVE attendFree = new T_HR_ATTENDFREELEAVE(); attendFree.ATTENDFREELEAVEID = Guid.NewGuid().ToString(); var entSol = from ent11 in dal.GetObjects <T_HR_ATTENDANCESOLUTION>() where ent11.ATTENDANCESOLUTIONID == ent.ATTENDANCESOLUTIONID select ent11; attendFree.T_HR_ATTENDANCESOLUTION = entSol.FirstOrDefault(); var entSet = from ent11 in dal.GetObjects <T_HR_LEAVETYPESET>() where ent11.LEAVETYPESETID == typeset.LEAVETYPESETID select ent11; attendFree.T_HR_LEAVETYPESET = entSet.FirstOrDefault(); attendFree.REMARK = "自动产生三八节"; attendFree.CREATEDATE = DateTime.Now; attendFree.UPDATEDATE = DateTime.Now; attendFree.CREATEUSERID = ent.OWNERID; attendFree.UPDATEUSERID = ent.OWNERID; string bbb = AddAttendFreeLeave(attendFree); if (bbb == "{SAVESUCCESSED}") { SMT.Foundation.Log.Tracer.Debug(ent.ATTENDANCESOLUTIONNAME + "产生了三八节,和考勤方案关联了"); } else { SMT.Foundation.Log.Tracer.Debug(ent.ATTENDANCESOLUTIONNAME + "没有@@@@@@产生三八节,和考勤方案关联了"); continue; } #endregion #region 五四 T_HR_LEAVETYPESET typesetYouth = new T_HR_LEAVETYPESET(); typesetYouth.LEAVETYPESETID = Guid.NewGuid().ToString(); typesetYouth.LEAVETYPENAME = ent.ATTENDANCESOLUTIONNAME + "五四青年节"; typesetYouth.LEAVETYPEVALUE = "12"; typesetYouth.ISFREELEAVEDAY = "2"; typesetYouth.MAXDAYS = (decimal)0.53; typesetYouth.FINETYPE = "1"; typesetYouth.SEXRESTRICT = "2"; typesetYouth.ENTRYRESTRICT = "1"; typesetYouth.OWNERCOMPANYID = ent.OWNERCOMPANYID; typesetYouth.OWNERDEPARTMENTID = ent.OWNERDEPARTMENTID; typesetYouth.OWNERPOSTID = ent.OWNERPOSTID; typesetYouth.OWNERID = ent.OWNERID; typesetYouth.CREATEDATE = DateTime.Now; typesetYouth.UPDATEDATE = DateTime.Now; typesetYouth.UPDATEUSERID = ent.OWNERID; typesetYouth.CREATECOMPANYID = ent.OWNERCOMPANYID; typesetYouth.CREATEDEPARTMENTID = ent.OWNERDEPARTMENTID; typesetYouth.CREATEPOSTID = ent.OWNERPOSTID; typesetYouth.CREATEUSERID = ent.OWNERID; typesetYouth.REMARK = "系统产生五四青年节"; //dal.AddToContext(typesetYouth); var entExistYouth = from ent1 in dal.GetObjects <T_HR_LEAVETYPESET>() where ent1.LEAVETYPEVALUE == "12" && ent1.OWNERCOMPANYID == ent.OWNERCOMPANYID select ent1; if (entExistYouth.Count() == 0) { string bbb1 = bllLeaveTypeSet.AddLeaveTypeSet(typesetYouth); if (bbb1 == "{SAVESUCCESSED}") { SMT.Foundation.Log.Tracer.Debug(ent.ATTENDANCESOLUTIONNAME + "产生了五四青年节"); } else { SMT.Foundation.Log.Tracer.Debug(ent.ATTENDANCESOLUTIONNAME + "没有####产生五四青年节"); continue; } } else { typesetYouth = entExistYouth.FirstOrDefault(); } T_HR_FREELEAVEDAYSET freeTypeSetYouth = new T_HR_FREELEAVEDAYSET(); freeTypeSetYouth.FREELEAVEDAYSETID = Guid.NewGuid().ToString(); freeTypeSetYouth.T_HR_LEAVETYPESET = typesetYouth; //freeTypeSetYouth.T_HR_LEAVETYPESETReference.EntityKey = //new System.Data.EntityKey("TM_SaaS_OA_EFModelContext.T_HR_LEAVETYPESET", "LEAVETYPESETID", typesetYouth.LEAVETYPESETID); freeTypeSetYouth.MINIMONTH = 0; freeTypeSetYouth.MAXMONTH = 9999; freeTypeSetYouth.LEAVEDAYS = (decimal)0.53; freeTypeSetYouth.ISPERFECTATTENDANCEFACTOR = "1"; freeTypeSetYouth.OFFESTTYPE = "1"; freeTypeSetYouth.OWNERCOMPANYID = ent.OWNERCOMPANYID; freeTypeSetYouth.OWNERDEPARTMENTID = ent.OWNERDEPARTMENTID; freeTypeSetYouth.OWNERPOSTID = ent.OWNERPOSTID; freeTypeSetYouth.OWNERID = ent.OWNERID; freeTypeSetYouth.CREATEDATE = DateTime.Now; freeTypeSetYouth.UPDATEDATE = DateTime.Now; freeTypeSetYouth.UPDATEUSERID = ent.OWNERID; freeTypeSetYouth.CREATECOMPANYID = ent.OWNERCOMPANYID; freeTypeSetYouth.CREATEDEPARTMENTID = ent.OWNERDEPARTMENTID; freeTypeSetYouth.CREATEPOSTID = ent.OWNERPOSTID; freeTypeSetYouth.CREATEUSERID = ent.OWNERID; freeTypeSetYouth.REMARK = "系统产生五四青年节带薪假"; //dal.AddToContext(freeTypeSetYouth); string bb2 = bllFreeLeaveDaySet.AddFreeLeaveDaySet(freeTypeSetYouth); if (bb2 == "{SAVESUCCESSED}") { SMT.Foundation.Log.Tracer.Debug(ent.ATTENDANCESOLUTIONNAME + "产生了带薪假五四青年节"); } else { SMT.Foundation.Log.Tracer.Debug(ent.ATTENDANCESOLUTIONNAME + "没有&&&产生带薪假五四青年节"); continue; } T_HR_ATTENDFREELEAVE attendFreeYouth = new T_HR_ATTENDFREELEAVE(); attendFreeYouth.ATTENDFREELEAVEID = Guid.NewGuid().ToString(); attendFreeYouth.T_HR_ATTENDANCESOLUTION = ent; attendFreeYouth.T_HR_LEAVETYPESET = typesetYouth; //attendFreeYouth.T_HR_LEAVETYPESETReference.EntityKey = // new System.Data.EntityKey("TM_SaaS_OA_EFModelContext.T_HR_LEAVETYPESET", "LEAVETYPESETID", typesetYouth.LEAVETYPESETID); attendFreeYouth.REMARK = "自动产生五四青年节"; attendFreeYouth.CREATEDATE = DateTime.Now; attendFreeYouth.UPDATEDATE = DateTime.Now; attendFreeYouth.CREATEUSERID = ent.OWNERID; attendFreeYouth.UPDATEUSERID = ent.OWNERID; string cc = AddAttendFreeLeave(attendFreeYouth); if (cc == "{SAVESUCCESSED}") { SMT.Foundation.Log.Tracer.Debug(ent.ATTENDANCESOLUTIONNAME + "产生了五四节,和考勤方案关联了"); } else { SMT.Foundation.Log.Tracer.Debug(ent.ATTENDANCESOLUTIONNAME + "没有********了五四节,和考勤方案关联了"); continue; } #endregion SMT.Foundation.Log.Tracer.Debug(ent.ATTENDANCESOLUTIONNAME + "执行完了"); intCount += 1; SMT.Foundation.Log.Tracer.Debug("执行了:" + intCount.ToString()); } } catch (Exception ex) { SMT.Foundation.Log.Tracer.Debug("初始化五四三八出现错误" + ex.ToString()); } }
/// <summary> /// 显示选中项的假期标准详细内容 /// </summary> private void ShowLeaveTypeSetForm() { if (dgLTList.ItemsSource == null) { entLeaveTypeSet = new T_HR_LEAVETYPESET(); this.DataContext = entLeaveTypeSet; BindFreeLeaveDaySet(); return; } if (dgLTList.SelectedItems.Count == 0) { IEnumerable<T_HR_LEAVETYPESET> entList = dgLTList.ItemsSource as IEnumerable<T_HR_LEAVETYPESET>; entLeaveTypeSet = entList.FirstOrDefault(); } else { entLeaveTypeSet = dgLTList.SelectedItems[0] as T_HR_LEAVETYPESET; } if (entLeaveTypeSet != null) { this.DataContext = entLeaveTypeSet; switch (entLeaveTypeSet.SEXRESTRICT) { case "0": tbSexRestrict.Text = Utility.GetResourceStr("GRIL"); break; case "1": tbSexRestrict.Text = Utility.GetResourceStr("MAN"); break; case "2": tbSexRestrict.Text = Utility.GetResourceStr("NOLIMIT"); break; default: tbSexRestrict.Text = string.Empty; break; } BindFreeLeaveDaySet(); } }
/// <summary> /// 检测DataGrid是否存在重复记录 /// </summary> /// <param name="entList"></param> /// <param name="entView"></param> /// <returns></returns> private bool IsContainsEntity(ObservableCollection<T_HR_LEAVETYPESET> entList, T_HR_LEAVETYPESET entView) { bool flag = false; var q = from item in entList where item.LEAVETYPENAME == entView.LEAVETYPENAME select item; if (q.Count() == 0) { return flag; } flag = true; return flag; }
/// <summary> /// 检测DataGrid是否存在重复记录 /// </summary> /// <param name="entList"></param> /// <param name="entView"></param> /// <returns></returns> private bool IsContainsEntity(ObservableCollection <T_HR_LEAVETYPESET> entList, T_HR_LEAVETYPESET entView) { bool flag = false; var q = from item in entList where item.LEAVETYPENAME == entView.LEAVETYPENAME select item; if (q.Count() == 0) { return(flag); } flag = true; return(flag); }
/// <summary> /// 根据主键索引,获得指定的假期记录以便查看编辑 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void clientAtt_GetLeaveTypeSetByIDCompleted(object sender, GetLeaveTypeSetByIDCompletedEventArgs e) { if (e.Error == null) { entLeaveTypeSet = e.Result; this.DataContext = entLeaveTypeSet; cbxkLeaveTypeValue.IsEnabled = false; cbxEntryRestrict.IsChecked = false; if (entLeaveTypeSet.ENTRYRESTRICT == (Convert.ToInt32(IsChecked.Yes) + 1).ToString()) { cbxEntryRestrict.IsChecked = true; } toolbar1.IsEnabled = false; dataPager.IsEnabled = false; if (entLeaveTypeSet.FINETYPE == (Convert.ToInt32(LeaveFineType.Free) + 1).ToString()) { toolbar1.IsEnabled = true; dataPager.IsEnabled = true; } CheckIsFreeLeave(); BindGrid(); SetToolBar(); if (!string.IsNullOrEmpty(entLeaveTypeSet.SEXRESTRICT)) { string strSex = entLeaveTypeSet.SEXRESTRICT; if (strSex == "0") { rbWomen.IsChecked = true; } if (strSex == "1") { rbMan.IsChecked = true; } if (strSex == "2") { rbNoLimit.IsChecked = true; } } else { rbNoLimit.IsChecked = true; } } else { Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr(e.Error.Message)); } loadbar.Stop(); }
/// <summary> /// 根据主键索引,删除带薪假设置信息(注:暂定为物理删除) /// </summary> /// <param name="strVacationId">主键索引</param> /// <returns></returns> public string DeleteFreeLeaveDaySet(string strFreeLeaveDaySetId) { string strMsg = string.Empty; try { if (string.IsNullOrEmpty(strFreeLeaveDaySetId)) { return("{REQUIREDFIELDS}"); } bool flag = false; StringBuilder strFilter = new StringBuilder(); List <string> objArgs = new List <string>(); strFilter.Append(" FREELEAVEDAYSETID == @0"); objArgs.Add(strFreeLeaveDaySetId); FreeLeaveDaySetDAL dalFreeLeaveDaySet = new FreeLeaveDaySetDAL(); flag = dalFreeLeaveDaySet.IsExistsRd(strFilter.ToString(), objArgs.ToArray()); if (!flag) { return("{NOTFOUND}"); } T_HR_FREELEAVEDAYSET entDel = dalFreeLeaveDaySet.GetFreeLeaveDaySetRdByMultSearch(strFilter.ToString(), objArgs.ToArray()); T_HR_LEAVETYPESET delSet = entDel.T_HR_LEAVETYPESET; dalFreeLeaveDaySet.Delete(entDel); //删除后修改员工带薪假期中的最大天数 if (delSet != null) { var entSet = from ent in dal.GetObjects <T_HR_LEAVETYPESET>() where ent.LEAVETYPESETID == entDel.T_HR_LEAVETYPESET.LEAVETYPESETID select ent; var entFreeSets = from ent in dal.GetObjects <T_HR_FREELEAVEDAYSET>().Include("T_HR_LEAVETYPESET") where ent.T_HR_LEAVETYPESET.LEAVETYPESETID == delSet.LEAVETYPESETID select ent; if (entFreeSets != null) { if (entFreeSets.Count() > 0) { var maxDays = entFreeSets.Max(s => s.LEAVEDAYS); var maxFrees = entFreeSets.ToList().OrderByDescending(s => s.LEAVEDAYS); T_HR_FREELEAVEDAYSET maxFree = maxFrees.FirstOrDefault(); BatchModifyEmployeeFreeLeaveRecords(maxFree, maxFree); } else { //修改为t_hr_leavetypeset中的天数 if (delSet.LEAVETYPEVALUE != (Convert.ToInt32(Common.LeaveTypeValue.AdjustLeave) + 1).ToString() && delSet.LEAVETYPEVALUE != (Convert.ToInt32(Common.LeaveTypeValue.AnnualLeave) + 1).ToString()) { try { DateTime dtNow = DateTime.Now; //格式化为当前年份 //dtNow = DateTime.Parse(dtNow.Year.ToString() + "-01-01"); var ents = from ent in dal.GetObjects <T_HR_EMPLOYEELEVELDAYCOUNT>() where ent.LEAVETYPESETID == delSet.LEAVETYPESETID && ent.EFFICDATE.Value.Year >= dtNow.Year select ent; if (ents.Count() > 0) { foreach (var ent in ents) { ent.REMARK += "原来为:" + ent.DAYS.ToString() + ";修改后重新设置天数:" + entDel.LEAVEDAYS.ToString(); ent.DAYS = delSet.MAXDAYS; dal.UpdateFromContext(ent); } int intResult = dal.SaveContextChanges(); if (intResult > 0) { SMT.Foundation.Log.Tracer.Debug("公共假期类型:" + delSet.LEAVETYPENAME + "修改带薪假天数成功"); } else { SMT.Foundation.Log.Tracer.Debug("公共假期类型:" + delSet.LEAVETYPENAME + "修改带薪假天数失败"); } } } catch (Exception ex) { SMT.Foundation.Log.Tracer.Debug("公共假期类型:" + delSet.LEAVETYPENAME + "修改带薪假天数出现错误:" + ex.ToString()); } } } } } strMsg = "{DELETESUCCESSED}"; } catch (Exception ex) { strMsg = ex.Message.ToString(); } return(strMsg); }