public string InsertSQL() { String sql = "insert into workorder (productorder,type,scheduledate,lenth,width," + "thickness,gross,done,undone,completedate,machinecode,worker,worth,remark,status,receivedate,grosswidth) " + "values ('{0}','{1}','{2}',{3},{4},{5},{6},{7},{8},'{9}','{10}','{11}',{12},'{13}',{14},'{15}',{16})"; return(String.Format(sql, ProductOrder, Type, ScheduleDate.ToString("yyyy-MM-dd"), Length.ToString(), Width.ToString(), Thickness.ToString(), Gross.ToString(), Done.ToString(), Undo.ToString(), CompleteDate.ToString("yyyy-MM-dd"), MachineCode, Worker, Worth.ToString(), Remark, Status.ToString(), ReceiveDate.ToString("yyyy-MM-dd HH:mm:ss"), GrossWidth.ToString())); }
public string UndateSQL() { String sql = "update workorder set productorder = '{0}',type = '{1}',scheduledate='{2}',lenth={3},width = {4}," + "thickness={5},gross={6},done={7},undone={8},completedate='{9}',machinecode='{10}',worker='{11}'," + "worth={12},remark='{13}',status={14} ,receivedate = '{15}',grosswidth = {16} where id = {17} "; return(String.Format(sql, ProductOrder, Type, ScheduleDate.ToString("yyyy-MM-dd"), Length.ToString(), Width.ToString(), Thickness.ToString(), Gross.ToString(), Done.ToString(), Undo.ToString(), CompleteDate.ToString("yyyy-MM-dd"), MachineCode, Worker, Worth.ToString(), Remark, Status.ToString(), ReceiveDate.ToString("yyyy-MM-dd HH:mm:ss"), GrossWidth.ToString(), id.ToString())); }
} // Fill public override string ToString() { return(string.Format( "LoanID: {0}, Schedule: {1} at {2}, Transaction: {3} at {4}, Delay: {5}", LoanID, ScheduleID, ScheduleDate.ToString("d/MMM/yyyy H:mm:ss", CultureInfo.InvariantCulture), TransactionID, TransactionTime.ToString("d/MMM/yyyy H:mm:ss", CultureInfo.InvariantCulture), Delay )); } // ToString
protected async void SelectCallback(PatientUI p) { Scheduler.patient = p; Scheduler.MRN = p.MRN; Scheduler.ScheduleTime = ScheduleDate.ToString(); Console.WriteLine(Scheduler.patient.Firstname); Console.WriteLine(Scheduler.MRN); Console.WriteLine(Scheduler.ScheduleTime); //We need to save the schedule here to the database await ScheduleService.Update(Scheduler); StateHasChanged(); }
public override async System.Threading.Tasks.Task ExecuteLoadSchedulesCommand() { if (IsBusy) { return; } if (!IsRefreshing) { IsBusy = true; } try { if (!Users.Any()) { var lookups = await DataService.GetLookups(1000); lookups.Users.ForEach(u => Users.Add(u)); } ScheduleDateFormatted = ScheduleDate.ToShortDateString(); OnPropertyChanged("ScheduleDateFormatted"); Schedules.Clear(); var items = await DataService.GetItemsAsync <Schedule>($"schedules?start={ScheduleDate.ToString("MM-dd-yyyy")}&end={ScheduleDate.ToString("MM-dd-yyyy")}{(CanManageSchedule ? "" : "&assigned=true")}"); NoSchedules = !items.Data.Any(); OnPropertyChanged("NoSchedules"); this.WeekUnpublished = false; foreach (var item in items.Data.OrderBy(d => d.User == null ? "zzzzzz" : d.User.FirstName)) { if (item.UserId != null && !item.PublishedValue) { this.WeekUnpublished = true; } var displayItem = new DisplayItem(); scheduleToDisplayItem(displayItem, item); Schedules.Add(displayItem); } } catch (Exception ex) { IsBusy = false; IsRefreshing = false; ExceptionHelper.ShowException(ex); } finally { IsBusy = false; IsRefreshing = false; } }
public override async System.Threading.Tasks.Task ExecuteLoadSchedulesCommand() { await runTask(async() => { if (!Users.Any()) { Users.Add(new User() { FirstName = "(All)", UserId = _allGuid }); Users.Add(new User() { FirstName = "(Unassigned)", UserId = _unassignedGuid }); Users.Add(new User() { FirstName = "(Assigned)", UserId = _assignedGuid }); var lookups = await DataService.GetLookups(4); lookups.Users.ForEach(u => Users.Add(u)); Shifts.Add(new Shift() { ShiftName = "(All)", ShiftId = _allGuid }); lookups.Shifts.ForEach(s => Shifts.Add(s)); Tasks.Add(new Task() { TaskName = "(All)", TaskId = _allGuid }); lookups.Tasks.ForEach(t => Tasks.Add(t)); } Schedules.Clear(); var items = await DataService.GetItemsAsync <Schedule>($"schedules?start={ScheduleDate.ToString("MM-dd-yyyy")}&end={ScheduleDate.AddDays(6).ToString("MM-dd-yyyy")}"); NoSchedules = !items.Data.Any(); this.WeekUnpublished = false; foreach (var item in items.Data.OrderBy(d => d.ScheduleDateValue).ThenBy(d => d.StartTimeValue).ThenBy(d => d.User == null ? "aaaaaaa" : d.User.FirstName)) { if (item.UserId != null && !item.PublishedValue) { this.WeekUnpublished = true; } _weekSchedules = items.Data; if (SelectedUser != null && SelectedUser.UserIdValue != _allGuid) { if (SelectedUser.UserIdValue == _unassignedGuid && item.User != null) { continue; } if (SelectedUser.UserIdValue == _assignedGuid && item.User == null) { continue; } if (SelectedUser.UserIdValue != _assignedGuid && SelectedUser.UserIdValue != _unassignedGuid && SelectedUser.UserIdValue != item.UserIdValue) { continue; } } if (SelectedShift != null && SelectedShift.ShiftIdValue != _allGuid && SelectedShift.ShiftIdValue != item.ShiftIdValue) { continue; } if (SelectedTask != null && SelectedTask.TaskIdValue != _allGuid && SelectedTask.TaskIdValue != item.TaskIdValue) { continue; } var displayItem = new DisplayItem(); scheduleToDisplayItem(displayItem, item); Schedules.Add(displayItem); } OnPropertyChanged("WeekUnpublished"); return(items); }); OnPropertyChanged("NoSchedules"); }