protected void EditSchedulerHistory_Click(object sender, DirectEventArgs e) { int id; if (!int.TryParse(hdfKeyRecord.Text, out id) || id <= 0) { return; } var schedulerHistory = SchedulerHistoryServices.GetById(id); if (schedulerHistory != null) { cbxScheduler.SelectedItem.Text = schedulerHistory.SchedulerName; txtDescription.Text = schedulerHistory.Description; chkHasError.Checked = schedulerHistory.HasError; txtErrorMessage.Text = schedulerHistory.ErrorMessage; txtErrorDescription.Text = schedulerHistory.ErrorDescription; txtStartTime.SelectedDate = schedulerHistory.StartTime; txtEndTime.SelectedDate = schedulerHistory.EndTime; } // show window btnUpdate.Show(); btnUpdateClose.Hide(); wdTimeSheetRule.Title = @"Cập nhật quản lý lịch sử tiến trình"; wdTimeSheetRule.Show(); }
public override void Excute(string args) { // create history _schedulerHistory = SchedulerHistoryServices.Create(Id, Name.ToUpper(), false, string.Empty, string.Empty, DateTime.Now, DateTime.MaxValue); // start process if (_schedulerHistory == null) { return; } // log start SchedulerLogServices.Create(_schedulerHistory.Id, "START"); try { // progress DoTaskSample("TaskSample InProgress"); } catch (Exception ex) { // log exception SchedulerLogServices.Create(_schedulerHistory.Id, "EXCEPTION: {0}".FormatWith(ex.ToString())); } finally { // log end SchedulerLogServices.Create(_schedulerHistory.Id, "END"); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void AddOrUpdateSchedulerLog(object sender, DirectEventArgs e) { btnAddAndCloseLog.Show(); btnUpdateLog.Hide(); ResetForm(); txtSchedulerHistory.Text = SchedulerHistoryServices.GetFieldValueById(Convert.ToInt32(hdfKeyRecord.Text), "Description"); wdSchedulerLogManagement.Show(); }
private void Update() { try { var util = new Util(); if (string.IsNullOrEmpty(hdfKeyRecord.Text)) { return; } var schedulerHistory = SchedulerHistoryServices.GetById(Convert.ToInt32(hdfKeyRecord.Text)); if (schedulerHistory == null) { return; } int schedulerId; if (int.TryParse(cbxScheduler.SelectedItem.Value, out schedulerId)) { schedulerHistory.SchedulerId = schedulerId; } if (!string.IsNullOrEmpty(txtDescription.Text)) { schedulerHistory.Description = txtDescription.Text.Trim(); } schedulerHistory.HasError = chkHasError.Checked; if (!string.IsNullOrEmpty(txtErrorMessage.Text)) { schedulerHistory.ErrorMessage = txtErrorMessage.Text.Trim(); } if (!string.IsNullOrEmpty(txtErrorDescription.Text)) { schedulerHistory.ErrorDescription = txtErrorDescription.Text.Trim(); } if (!util.IsDateNull(txtStartTime.SelectedDate)) { schedulerHistory.StartTime = txtStartTime.SelectedDate; } if (!util.IsDateNull(txtEndTime.SelectedDate)) { schedulerHistory.EndTime = txtEndTime.SelectedDate; } SchedulerHistoryServices.Update(schedulerHistory); } catch (Exception ex) { Dialog.Alert("Có lỗi xảy ra trong quá trình cập nhật: {0}".FormatWith(ex.Message)); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="directEventArgs"></param> protected void Delete(object sender, DirectEventArgs directEventArgs) { try { if (!int.TryParse(hdfKeyRecord.Text, out var id) || id <= 0) { return; } SchedulerHistoryServices.Delete(id); gridScheduleHistory.Reload(); RM.RegisterClientScriptBlock("Grid_Reload", "ReloadGrid();"); } catch (Exception ex) { Dialog.Alert("Có lỗi xảy ra trong quá trình xóa: {0}".FormatWith(ex.Message)); } }
public override void Excute(string args) { // create history var schedulerHistory = SchedulerHistoryServices.Create(Id, Name.ToUpper(), false, string.Empty, string.Empty, DateTime.Now, DateTime.MaxValue); // start process if (schedulerHistory == null) { return; } // log start SchedulerLogServices.Create(schedulerHistory.Id, "START"); // Chạy 0:05 ngày 1 hàng tháng var month = DateTime.Now.Month; var year = DateTime.Now.Year; //Tao ngay phep mac dinh cho tat ca nhan vien var condition = @"WorkStatusId = (select top 1 Id from cat_WorkStatus where Name like N'{0}')".FormatWith(ConstStatusWorking); var listRecords = hr_RecordServices.GetAll(condition); foreach (var item in listRecords) { //tạo mới bảng phép var leave = new hr_AnnualLeaveConfigure() { RecordId = item.Id, AnnualLeaveDay = ConstLeaveDay, CreatedDate = DateTime.Now, Year = DateTime.Now.Year, AllowUseFirstYear = false, AllowUsePreviousYear = false, ExpiredDate = null, }; hr_AnnualLeaveConfigureServices.Create(leave); } SchedulerLogServices.Create(schedulerHistory.Id, "END"); }
private void Insert() { try { var util = new Util(); var schedulerHistory = new SchedulerHistory(); int schedulerId; if (int.TryParse(cbxScheduler.SelectedItem.Value, out schedulerId)) { schedulerHistory.SchedulerId = schedulerId; } if (!string.IsNullOrEmpty(txtDescription.Text)) { schedulerHistory.Description = txtDescription.Text.Trim(); } schedulerHistory.HasError = chkHasError.Checked; if (!string.IsNullOrEmpty(txtErrorMessage.Text)) { schedulerHistory.ErrorMessage = txtErrorMessage.Text.Trim(); } if (!string.IsNullOrEmpty(txtErrorDescription.Text)) { schedulerHistory.ErrorDescription = txtErrorDescription.Text.Trim(); } if (!util.IsDateNull(txtStartTime.SelectedDate)) { schedulerHistory.StartTime = txtStartTime.SelectedDate; } if (!util.IsDateNull(txtEndTime.SelectedDate)) { schedulerHistory.EndTime = txtEndTime.SelectedDate; } SchedulerHistoryServices.Create(schedulerHistory); } catch (Exception ex) { Dialog.Alert("Có lỗi xảy ra trong quá trình thêm mới: {0}".FormatWith(ex.Message)); } }
public override void Excute(string args) { // create history var schedulerHistory = SchedulerHistoryServices.Create(Id, Name.ToUpper(), false, string.Empty, string.Empty, DateTime.Now, DateTime.MaxValue); // start process if (schedulerHistory == null) { return; } // log start SchedulerLogServices.Create(schedulerHistory.Id, "START"); // Chạy 0:05 ngày 1 hàng tháng var month = !string.IsNullOrEmpty(GetArgValue("-m")) ? Convert.ToInt32(GetArgValue("-m")) : DateTime.Now.Month; var year = !string.IsNullOrEmpty(GetArgValue("-y")) ? Convert.ToInt32(GetArgValue("-y")) : DateTime.Now.Year; var groupWorkShiftId = !string.IsNullOrEmpty(GetArgValue("-groupWorkShiftId")) ? Convert.ToInt32(GetArgValue("-groupWorkShiftId")) : 0; //get all detail workShift var order = " [StartDate] ASC "; var lstWorkShift = TimeSheetWorkShiftController.GetAll(null, false, groupWorkShiftId, null, null, null, null, month, year, order, null); var listWorkShiftIds = lstWorkShift.Select(ws => ws.Id).ToList(); if (listWorkShiftIds.Count > 0) { TimeSheetEventController.DeleteByCondition(listWorkShiftIds, null, null, null, TimeSheetAdjustmentType.Default); } //get all employee in group var listEmployeeGroupWorkShift = TimeSheetEmployeeGroupWorkShiftController.GetAll(null, null, null, groupWorkShiftId, null, null); //list recordId var listRecordIds = listEmployeeGroupWorkShift.Select(gws => gws.RecordId).Distinct().ToList(); //get symbolId undefined GetSymbolUndefined(); //get symbolId unleave GetSymbolUnLeave(); //create new timeSheet for employee foreach (var recordId in listRecordIds) { //get timeSheetCode by recordId var timeSheetCodeCondition = " [RecordId] = {0} ".FormatWith(recordId) + " AND [IsActive] = 1 "; var listTimeSheetCodes = hr_TimeSheetCodeServices.GetAll(timeSheetCodeCondition); if (listTimeSheetCodes.Count > 0) { //ma cham cong var timeSheetCodes = string.Join(",", listTimeSheetCodes.Select(t => t.Code).ToList()); var arrTimeSheetCode = FormatList(timeSheetCodes); //serial may cham cong var machineIds = listTimeSheetCodes.Select(tc => tc.MachineId).ToList(); var machineCondition = Constant.ConditionDefault; machineCondition += " AND [Id] IN ({0})".FormatWith(string.Join(",", machineIds)); var machines = hr_TimeSheetMachineService.GetAll(machineCondition); var serialNumbers = string.Join(",", machines.Select(t => t.SerialNumber).ToList()); var arrSerialNumber = FormatList(serialNumbers); foreach (var workShiftModel in lstWorkShift) { //calculate timeSheet CalculateTimeSheet(workShiftModel, recordId, string.Join(",", arrTimeSheetCode), string.Join(",", arrSerialNumber)); } } } SchedulerLogServices.Create(schedulerHistory.Id, "END"); }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void storeSchedulerHistoryLog_OnRefreshData(object sender, StoreRefreshDataEventArgs e) { storeSchedulerHistoryLog.DataSource = SchedulerHistoryServices.GetAll(); storeSchedulerHistoryLog.DataBind(); }
public override void Excute(string args) { // create history var schedulerHistory = SchedulerHistoryServices.Create(Id, Name.ToUpper(), false, string.Empty, string.Empty, DateTime.Now, DateTime.MaxValue); // start process if (schedulerHistory == null) { return; } // log start SchedulerLogServices.Create(schedulerHistory.Id, "START"); //get param var payrollId = !string.IsNullOrEmpty(GetArgValue("-payrollId")) ? Convert.ToInt32(GetArgValue("-payrollId")) : 0; var columnCode = GetArgValue("-column"); var symbol = GetArgValue("-symbol"); var symbolArr = symbol.Split(','); if (string.IsNullOrEmpty(columnCode)) { return; } var boardList = sal_PayrollServices.GetById(payrollId); //Lay danh sach nhan vien tu bang luong var conditionPayroll = " [SalaryBoardId] = {0} ".FormatWith(payrollId); var salaryInfos = hr_SalaryBoardInfoServices.GetAll(conditionPayroll); foreach (var salaryInfo in salaryInfos) { //Kiem tra column dong da duoc tao chua, neu chua co thi tao moi khong thi cap nhat lai var conditionBoardDynamic = Constant.ConditionDefault; conditionBoardDynamic += " AND [RecordId] = {0} ".FormatWith(salaryInfo.RecordId) + " AND [ColumnCode] = '{0}' ".FormatWith(columnCode); var dynamic = hr_SalaryBoardDynamicColumnService.GetByCondition(conditionBoardDynamic); if (dynamic != null) { // get value GetValueDynamicColumn(boardList, salaryInfo, symbolArr, columnCode, dynamic); //update hr_SalaryBoardDynamicColumnService.Update(dynamic); } else { //create var colDynamic = new hr_SalaryBoardDynamicColumn() { RecordId = salaryInfo.RecordId, SalaryBoardId = payrollId, ColumnCode = columnCode, CreatedDate = DateTime.Now }; //set value GetValueDynamicColumn(boardList, salaryInfo, symbolArr, columnCode, colDynamic); //create hr_SalaryBoardDynamicColumnService.Create(colDynamic); } } SchedulerLogServices.Create(schedulerHistory.Id, "END"); }