private void LoadReport(string path, List <ViewLateComer> _Employee) { string DateToFor = ""; if (DateFrom.Date.ToString("d") == DateTo.ToString("d")) { DateToFor = "Date : " + DateFrom.Date.ToString("d"); } else { DateToFor = "From : " + DateFrom.Date.ToString("d") + " To: " + DateTo.Date.ToString("d"); } string _Header = "Late In Report"; this.ReportViewer1.LocalReport.DisplayName = "LateIn Report"; ReportViewer1.ProcessingMode = ProcessingMode.Local; ReportViewer1.LocalReport.ReportPath = Server.MapPath(path); System.Security.PermissionSet sec = new System.Security.PermissionSet(System.Security.Permissions.PermissionState.Unrestricted); ReportViewer1.LocalReport.SetBasePermissionsForSandboxAppDomain(sec); IEnumerable <ViewLateComer> ie; ie = _Employee.AsQueryable(); ReportDataSource datasource1 = new ReportDataSource("DataSet1", ie); ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(datasource1); ReportParameter rp = new ReportParameter("Date", DateToFor, false); ReportParameter rp1 = new ReportParameter("Header", _Header, false); this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp, rp1 }); ReportViewer1.LocalReport.Refresh(); }
/// <summary> /// 取得查詢結果資料 /// </summary> /// <param name="vCreate_Date_From">入庫日期(起)</param> /// <param name="vCreate_Date_To">入庫日期(迄)</param> /// <param name="vTrea_Register_Id">金庫登記簿單號</param> /// <returns></returns> public List <TreasuryRegisterSearch> GetSearchList(string vCreate_Date_From, string vCreate_Date_To, string vTrea_Register_Id) { var result = new List <TreasuryRegisterSearch>(); DateTime DateFrom, DateTo; DateTime.TryParse(vCreate_Date_From, out DateFrom); if (DateTime.TryParse(vCreate_Date_To, out DateTo)) { DateTo = DateTo.DateToLatestTime(); } using (TreasuryDBEntities db = new TreasuryDBEntities()) { var _Open_Trea_Type = db.SYS_CODE.AsNoTracking().Where(x => x.CODE_TYPE == "OPEN_TREA_TYPE").ToList(); var _Regi_Status = db.SYS_CODE.AsNoTracking().Where(x => x.CODE_TYPE == "FORM_STATUS").ToList(); result = GetSearchModel(db.TREA_OPEN_REC.AsNoTracking() .Where(x => x.CREATE_DT >= DateFrom, !vCreate_Date_From.IsNullOrWhiteSpace()) .Where(x => x.CREATE_DT <= DateTo, !vCreate_Date_To.IsNullOrWhiteSpace()) .Where(x => x.TREA_REGISTER_ID == vTrea_Register_Id, !vTrea_Register_Id.IsNullOrWhiteSpace()) .AsEnumerable() , _Open_Trea_Type, _Regi_Status).ToList(); } return(result); }
private void pageHeader_Format(object sender, EventArgs e) { lblWarehouse.Text = Warehouse.ToString(); lblWBServiceProvider.Text = WBServiceProvider.ToString(); lblFromDate.Text = DateFrom.ToString(); lblToDate.Text = DateTo.ToString(); }
private void btnOK_Click(object sender, EventArgs e) { if (this.CompanyID.GetCheckedValues().Length == 0) { Mess.Info("Please select at least one company!"); CompanyID.ShowPopup(); return; } if (this.LocationID.GetCheckedValues().Length == 0) { Mess.Info("Please select at least one location!"); LocationID.ShowPopup(); return; } if (DateFrom.EditValue == null || DateFrom.DateTime == DateTime.MinValue) { Mess.Info("Please select a Period From!"); DateFrom.ShowPopup(); return; } if (DateTo.EditValue == null || DateTo.DateTime == DateTime.MinValue) { Mess.Info("Please select a Period To!"); DateTo.ShowPopup(); return; } this.DialogResult = System.Windows.Forms.DialogResult.Yes; this.Close(); }
public void onSaveClick() { if (Todo == null || mContentPage == null) { return; } Todo.From = DateFrom.Add(TimeFrom); Todo.To = DateTo.Add(TimeTo); if (Todo.From.CompareTo(Todo.To) > 0 || String.IsNullOrEmpty(Todo.Title)) { mContentPage.DisplayAlert("Warning", "1.Please enter \"Title\"\n" + "2.Time To > Date From", "OK"); return; } App.Database.SaveItemAsync(Todo); if (Todo.IsDone == true) { DependencyService.Get <IAlarm>().CancelAlarm(Todo); } else { DependencyService.Get <IAlarm>().SetAlarm(Todo); } mContentPage.Navigation.PopAsync(); }
public DataSet Select() { Command = CommandBuilder(@"select pi.id, pi.title, pi.datetime, pi.image, p.name as product from ProductImage as pi left join Product as p on pi.productId=p.id where pi.id>0"); if (!string.IsNullOrEmpty(Title)) { Command.CommandText += " and pi.title like @title"; Command.Parameters.AddWithValue("@title", "%" + Title + "%"); } if (ProductId > 0) { Command.CommandText += " and p.id like @product"; Command.Parameters.AddWithValue("@product", ProductId); } if (DateSearch) { Command.CommandText += " and pi.datetime between @date1 and @Date2"; Command.Parameters.AddWithValue("@date1", DateFrom.ToShortDateString()); Command.Parameters.AddWithValue("@date2", DateTo.ToShortDateString()); } return(ExecuteDS(Command)); }
public override string ToString(bool shortVariant, Pullenti.Morph.MorphLang lang = null, int lev = 0) { if (IsRelative && !shortVariant) { StringBuilder res = new StringBuilder(); res.Append(this.ToString(true, lang, lev)); Pullenti.Ner.Date.Internal.DateRelHelper.AppendToString2(this, res); return(res.ToString()); } string fr = (DateFrom == null ? null : DateFrom._ToString(shortVariant, lang, lev, 1)); string to = (DateTo == null ? null : DateTo._ToString(shortVariant, lang, lev, 2)); if (fr != null && to != null) { return(string.Format("{0} {1}", fr, (DateTo.Century > 0 && DateTo.Year == 0 ? to : to.ToLower()))); } if (fr != null) { return(fr.ToString()); } if (to != null) { return(to); } return(string.Format("{0} ? по ?", (lang.IsUa ? 'з' : 'с'))); }
private string BuildSubtitle() { string dateFormat = "dd.MM.yyyy HH:mm"; StringBuilder text = new StringBuilder("Период: "); text.Append(DateFrom.ToString(dateFormat) + " - "); text.Append(DateTo.ToString(dateFormat)); text.Append(", подразделение: "); text.Append(SelectedUnit.Name); if (LicensePlate.Trim().Length > 0) { text.Append(", номер т/с: "); text.Append(LicensePlate.Trim()); } if (Cargo.Trim().Length > 0) { text.Append(", груз: "); text.Append(Cargo.Trim()); } return(text.ToString()); }
public IEnumerable <ValidationResult> Validate(string instanceName, bool isRequired = false) { var result = new List <ValidationResult>(); if (DateFrom.YearMax == DateTime.Now.Year) { result.AddRange(DateFrom.ValidatePastDate($"{instanceName}.{nameof(DateFrom)}", true)); } else { result.AddRange(DateFrom.Validate($"{instanceName}.{nameof(DateFrom)}", true)); } if (DateTo.YearMax == DateTime.Now.Year) { result.AddRange(DateTo.ValidatePastDate($"{instanceName}.{nameof(DateTo)}", DateToRequired)); } else { result.AddRange(DateTo.Validate($"{instanceName}.{nameof(DateTo)}", DateToRequired)); } if ((DateToRequired || !DateTo.IsEmpty()) && (DateTo.ToDate() < DateFrom.ToDate())) { result.Add(new ValidationResult(string.Empty, new[] { $"{instanceName}.{nameof(DateTo)}" })); } return(result); }
public override bool CanBeEquals(Pullenti.Ner.Referent obj, Pullenti.Ner.Core.ReferentsEqualType typ) { DateRangeReferent dr = obj as DateRangeReferent; if (dr == null) { return(false); } if (DateFrom != null) { if (!DateFrom.CanBeEquals(dr.DateFrom, typ)) { return(false); } } else if (dr.DateFrom != null) { return(false); } if (DateTo != null) { if (!DateTo.CanBeEquals(dr.DateTo, typ)) { return(false); } } else if (dr.DateTo != null) { return(false); } return(true); }
//implemented methods public override void InputFormFields() { if (Data.TestWindowName != null) { TestWindowName.Wait(5).SendKeys(Data.TestWindowName); } if (Data.Subject != null) { SubjectSelect.Wait(3).SelectByText(Data.Subject); } if (Data.GradeLow != null) { GradeFromSelect.Wait(5); GradeFromSelect.Wait(5).SelectByText(Data.GradeLow); } if (Data.GradeHigh != null) { GradeToSelect.Wait(5); GradeToSelect.Wait(5).SelectByText(Data.GradeHigh); } if (Data.DateFrom != null) { DateFrom.Wait(5).SendKeys(Data.DateFrom); } if (Data.DateTo != null) { DateTo.Wait(5).SendKeys(Data.DateTo); } }
public DataSet Select() { Command = CommandBuilder(@"select L.id, L.name, L.contact, L.contactPerson, L.email, L.password, h.name as head, L.description, L.address, ct.name as city, cn.name as country, l2.name as employee, L.createDate from Ledger as L left join Head as h on L.headId = h.id left join ledger as l2 on l.employeeId = l2.id left join City as ct on L.cityid = ct.id left join country as cn on ct.countryId = cn.id where l.id>0"); if (!string.IsNullOrEmpty(Search)) { Command.CommandText += " and (l.name like @search or l.contact like @search or l.contactPerson like @search or l.email like @search or l.description like @search or l.address like @search)"; Command.Parameters.AddWithValue("@search", "%" + Search + "%"); } if (HeadId > 0) { Command.CommandText += " and (h.id like @head)"; Command.Parameters.AddWithValue("@head", "%" + HeadId + "%"); } if (DateSearch) { Command.CommandText += " and l.createDate between @date1 and @Date2"; Command.Parameters.AddWithValue("@date1", DateFrom.ToShortDateString()); Command.Parameters.AddWithValue("@date2", DateTo.ToShortDateString()); } return(ExecuteDS(Command)); }
public BaseChartWeekRequestModels() { //DateFrom = CommonHelper.GetFirstDayOfWeek(); //DateTo = DateFrom.AddDays(6); DateTo = DateTime.Now.AddDays(-1); DateFrom = DateTo.AddDays(-6); }
private void pageHeader_Format(object sender, EventArgs e) { lblWarehouse.Text = Warehouse.ToString(); lblShed.Text = Shed.ToString(); lblLIC.Text = LIC.ToString(); lblFromDate.Text = DateFrom.ToString(); lblToDate.Text = DateTo.ToString(); }
public XmlElement ToXmlElement(XmlHelper helper) { var xmlElement = helper.CreateElement(nameof(MonthYearPeriodModel).Replace("Model", string.Empty)); xmlElement.AppendChild(helper.CreateElement(nameof(DateFrom), DateFrom.ToXmlElement(helper))); xmlElement.AppendChild(helper.CreateElement(nameof(DateTo), DateTo.ToXmlElement(helper))); return(xmlElement); }
private void SaveDateSession() { List <string> list = Session["ReportSession"] as List <string>; list[0] = DateFrom.ToString("yyyy-MM-dd"); list[1] = DateTo.ToString("yyyy-MM-dd"); Session["ReportSession"] = list; }
//implemented methods public override void ClearForm() { TestWindowName.Clear(); SubjectSelect.Wait(3).SelectByText("All subjects"); GradeFromSelect.Wait(5).SelectByText(""); GradeToSelect.Wait(5).SelectByText(""); DateFrom.Clear(); DateTo.Clear(); }
public IDictionary <string, string> ToQueryStrings() { return(new Dictionary <string, string>() { { "to", DateTo.ToString("yyyy-MM-dd") }, { "from", DateFrom.ToString("yyyy-MM-dd") }, { "page", Page?.ToString() }, { "size", Size?.ToString() }, }); }
private string CreateDateString() { return(IsValid ? string.Join("", new List <string> { "1", DateFrom.ToSortString(), ((int)DateType).ToString(), DateTo.ToSortString() }) : string.Join("", new List <string> { "2", DatePhrase })); }
public override string ToString() { return($"[Type={Type}, " + $"DateFrom={DateFrom.ToString(CultureInfo.CurrentCulture)}, " + $"DateTo={DateTo.ToString(CultureInfo.CurrentCulture)}, " + $"Span={Span.ToString()}, " + $"HasTime={HasTime}, " + $"StartIndex={StartIndex}, " + $"EndIndex={EndIndex}]"); }
public override string ToString() { StringBuilder sb = new StringBuilder(); sb.AppendLine($"{EmpID}"); sb.AppendLine($"{ProjectID}"); sb.AppendLine($"{DateFrom.ToString("yyyy-MM-dd")}"); sb.AppendLine($"{DateTo.ToString("yyyy-MM-dd")}"); return(sb.ToString()); }
public override string ToString() { return(string.Format( "{0} - {1} {2} {3} {4} {5}", DateFrom.ToString("MMM d yyyy", CultureInfo.InvariantCulture), DateTo.ToString("MMM d yyyy", CultureInfo.InvariantCulture), RegistrationNo, Name, SourceID, InternalID )); } // ToString
public SummarizedData() { ExecuteCommand = new[] { AccessToken.Select(v => !string.IsNullOrWhiteSpace(v)), DateFrom.Select(v => !string.IsNullOrWhiteSpace(v)), DateTo.Select(v => !string.IsNullOrWhiteSpace(v)), } .CombineLatestValuesAreAllTrue() .ToReactiveCommand(false) .AddTo(Disposable); }
public override int GetHashCode() { unchecked { var hashCode = (int)DateType; hashCode = (hashCode * 397) ^ (DateFrom?.GetHashCode() ?? 0); hashCode = (hashCode * 397) ^ (DateTo?.GetHashCode() ?? 0); hashCode = (hashCode * 397) ^ (DatePhrase?.GetHashCode() ?? 0); hashCode = (hashCode * 397) ^ IsValid.GetHashCode(); hashCode = (hashCode * 397) ^ SortDate; return(hashCode); } }
private PDFCell GetPeriodPDFCell() { var dateFormat = new GetDateFormat().GetDateFormaDotNetById(DateFormatId); var pdfCell = new PDFCell { NameDefault = "PeriodName", NameDisplay = "Period: ", Value = DateFrom.ToString(dateFormat) + " - " + DateTo.ToString(dateFormat), }; return(pdfCell); }
public override IDAOFilter GetFilter() { IDataAccess da = SysAuditDat.ClassDataAccessor; IDAOFilter f = da.NewFilter(); f.AddWhere(new FilterDateFromTo(SysAuditColumns.Dt, DateFrom, DateTo.AddDays(1))); if (!string.IsNullOrEmpty(Tbl)) { Tbl = "%" + Tbl + "%"; f.AddWhere(new FilterString(SysAuditColumns.Tbl, Tbl, true)); } if (ID != 0) { //f.AddWhere(new FilterID(SysAuditColumns.TblID, ID)); f.AddWhere(new FilterCustom(string.Format("OpContent.value('/*[1]/@id', 'int') = {0}", ID))); } if (!string.IsNullOrEmpty(User)) { User = "******" + User + "%"; f.AddWhere(new FilterString(SysAuditColumns.Usr, User, true)); } if (!string.IsNullOrEmpty(Host)) { Host = "%" + Host + "%"; f.AddWhere(new FilterString(SysAuditColumns.ClientHost, Host, true)); } if (!string.IsNullOrEmpty(Application)) { Application = "%" + Application + "%"; f.AddWhere(new FilterString(SysAuditColumns.ClientApplication, Application, true)); } if (!string.IsNullOrEmpty(Server)) { Server = "%" + Server + "%"; f.AddWhere(new FilterString(SysAuditColumns.Srv, Server, true)); } if (!string.IsNullOrEmpty(Base)) { Base = "%" + Base + "%"; f.AddWhere(new FilterString(SysAuditColumns.Db, Base, true)); } return(f); }
public void NormalizeValues() { CourtOrganizationId = CourtOrganizationId.EmptyToNull(); DocumentDirectionId = DocumentDirectionId.EmptyToNull(); DocumentKindId = DocumentKindId.EmptyToNull(); DocumentGroupId = DocumentGroupId.EmptyToNull(); DocumentTypeId = DocumentTypeId.EmptyToNull(); DocumentNumber = DocumentNumber.EmptyToNull(); DocumentYear = DocumentYear.EmptyToNull(); DateTo = DateTo.MakeEndDate(); PersonName = PersonName.EmptyToNull(); PersonUIC = PersonUIC.EmptyToNull(); PersonRoleId = PersonRoleId.EmptyToNull(); }
private void BeginSearch() { try { string txtFrom = dateFrom.SelectedDate.ToString("yyyy-MM-dd"); string txtTo = DateTo.SelectedDate.AddDays(1).ToString("yyyy-MM-dd"); if (dateFrom.SelectedDate.Year == 9999) { //errlable.Text = "开始时间日期格式错误"; dateFrom.Focus(); return; } if (dateFrom.SelectedDate.Year == 9999) { //errlable.Text = "截止时间日期格式错误"; DateTo.Focus(); return; } if (dateFrom.SelectedDate > DateTime.Today) { dateFrom.SelectedDate = DateTime.Today; return; } if (DateTo.SelectedDate > DateTime.Today) { DateTo.SelectedDate = DateTime.Today; DateTo.Focus(); return; } if (dateFrom.SelectedDate > DateTo.SelectedDate) { errlable.Text = "开始时间不能大于截止时间"; dateFrom.Focus(); return; } FullQuery(txtFrom, txtTo); CaculatePageCount(); GridView1.PagerSettings.LastPageText = ViewState["pageCount"].ToString(); BindGrid(); } catch { errlable.Text = ""; } }
public async Task <decimal> CalculateFinalPriceAsync() { if (_carType == null || _settings == null) { using (var db = new CarRentalDatabase()) { _carType = _carType ?? await db.CarTypes.FirstOrDefaultAsync(x => x.Id == CarTypeId); _settings = _settings ?? await db.Settings.FirstOrDefaultAsync(); } } var days = (int)Math.Ceiling(DateTo.Subtract(DateFrom).TotalDays) + 1; var mileage = FinalMileage - InitialMileage; return(_carType.DayMultiplier * days * _settings.DayPrice + _carType.KilometerMultiplier * mileage * _settings.KilometerPrice); }
public async Task <IActionResult> OnGetAsync() { var isAuthorize = User.IsInRole(Constants.AdministratorRole) || User.IsInRole(Constants.ManagerRole); if (!isAuthorize) { return(new ChallengeResult()); } DateTo = DateTime.Today; DateFrom = DateTo.AddYears(-1); IncomeStatement = await GetIncomeStatementsListAsync(); return(Page()); }