public static DateTime NextFullMoon(DateTime fromDate) { if (calcNext(fromDate.Year, fromDate.Month, fromDate.Day) == new DateTime()) return calcNext(fromDate.AddMonths(1).Year, fromDate.AddMonths(1).Month, 1); else return calcNext(fromDate.Year, fromDate.Month, fromDate.Day); }
public List<Tuple<string, string, decimal>> GetCycleSummary(int monthAgo) { DateTime cycleStart = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1); cycleStart = cycleStart.AddMonths(-monthAgo); DateTime cycleEnd = cycleStart.AddMonths(1); using (ShowcaseDB db = new ShowcaseDB()) { var l = (from e in db.Expenses where e.TransactionDate >= cycleStart && e.TransactionDate < cycleEnd group e by e.Category into grp orderby grp.Key select new { grp.Key, grp }).ToList(); //var l2 = from cc in CategoryCharToName.Keys // join c in l on cc equals c.Key into g // from c in g.DefaultIfEmpty() // select Tuple.Create(cc, CategoryCharToName[cc], c != null ? c.grp.Sum(e => e.Amount) : 0); var ret = l.Select(g => Tuple.Create<string, string, decimal>(g.Key, CategoryCharToName[g.Key], g.grp.Sum(e => e.Amount))).ToList(); if (ret.Count == 0) ret.Add(Tuple.Create("1", CategoryCharToName["1"], 0M)); return ret; } }
public ActionResult Index() { var startDate = new DateTime(DateTime.UtcNow.Year, DateTime.UtcNow.Month, 1); using (var dbContext = new ReportingContext()) { var buildSummary = GetLastBuildSummary(dbContext); var viewModel = new HomeViewModel { Builds = buildSummary, CoverageStat = new ModuleCoverageForABuild(), Challenges = ComputeChallengesSummary(dbContext, startDate, startDate.AddMonths(1)), }; var mainProjectName = ConfigurationManager.AppSettings["MainProjectName"]; var lastBuild = !string.IsNullOrEmpty(mainProjectName) ? buildSummary.FirstOrDefault(i => i.ActualBuild.Definition == mainProjectName) : buildSummary.FirstOrDefault(); if (lastBuild != null) { var coverages = lastBuild.ActualBuild.CoverageCollection.OrderBy(i => (i.BlocksCovered * 100) / (i.BlocksNotCovered + i.BlocksCovered)).ToArray(); viewModel.CoverageStat.Modules = string.Join(", ", coverages.Select(i => i.Name.Replace(".dll", string.Empty).Replace(".exe", string.Empty))); viewModel.CoverageStat.Coverages = string.Join(", ", coverages.Select(i => (i.BlocksCovered * 100) / (i.BlocksNotCovered + i.BlocksCovered))); } viewModel.ShootBoxBuilds = GetLastBuilds(dbContext, startDate, startDate.AddMonths(1)).ToArray(); return View(viewModel); } }
void gen(PlaceHolder Stats, Log.Items item) { Query q = new Query(); q.ExtraSelectElements.Add("Count", "SUM([Log].[Count])"); q.ExtraSelectElements.Add("Day", "DATENAME(DW,[Log].[Date])"); q.QueryCondition = new Q(Log.Columns.Item, item); q.GroupBy = new GroupBy("DATENAME(DW,[Log].[Date])"); q.Columns = new ColumnSet(); LogSet ls = new LogSet(q); Dictionary<DayOfWeek, double> weight = new Dictionary<DayOfWeek, double>(); int total = 0; foreach (Log l in ls) { total += (int)l.ExtraSelectElements["Count"]; } foreach (Log l in ls) { double fraction = (double)(int)l.ExtraSelectElements["Count"] / (double)total; switch ((string)l.ExtraSelectElements["Day"]) { case "Monday": weight[DayOfWeek.Monday] = fraction; break; case "Tuesday": weight[DayOfWeek.Tuesday] = fraction; break; case "Wednesday": weight[DayOfWeek.Wednesday] = fraction; break; case "Thursday": weight[DayOfWeek.Thursday] = fraction; break; case "Friday": weight[DayOfWeek.Friday] = fraction; break; case "Saturday": weight[DayOfWeek.Saturday] = fraction; break; case "Sunday": weight[DayOfWeek.Sunday] = fraction; break; default: break; } } Stats.Controls.Add(new LiteralControl("<table><tr><td>Month</td><td>Year</td><td>Weight</td><td>Actual pages</td><td>Weighted pages</td></tr>")); for (DateTime dtMonth = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(-12); dtMonth <= new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); dtMonth = dtMonth.AddMonths(1)) { try { double monthWeight = 0.0; for (DateTime dtDay = dtMonth; dtDay < dtMonth.AddMonths(1) && dtDay < DateTime.Today; dtDay = dtDay.AddDays(1)) { monthWeight += weight[dtDay.DayOfWeek]; } Query qMonth = new Query(); qMonth.ExtraSelectElements.Add("Count", "SUM([Log].[Count])"); qMonth.QueryCondition = new And( new Q(Log.Columns.Item, item), new Q(Log.Columns.Date, QueryOperator.GreaterThanOrEqualTo, dtMonth), new Q(Log.Columns.Date, QueryOperator.LessThan, dtMonth.AddMonths(1)), new Q(Log.Columns.Date, QueryOperator.LessThan, DateTime.Today)); qMonth.Columns = new ColumnSet(); LogSet lsMonth = new LogSet(qMonth); int actualPages = (int)lsMonth[0].ExtraSelectElements["Count"]; double pagesPerWeek = (double)actualPages / monthWeight; double pagesPerMonth = pagesPerWeek * 4.345238095; Stats.Controls.Add(new LiteralControl("<tr><td>" + dtMonth.ToString("MMM") + "</td><td>" + dtMonth.Year + "</td><td>" + monthWeight.ToString("0.00") + "</td><td>" + actualPages.ToString("0") + "</td><td>" + pagesPerMonth.ToString("0") + "</td></tr>")); // Stats.Controls.Add(new LiteralControl( + " " + + " is " + + " weeks. " + + " pages per week.<br>")); } catch { } } Stats.Controls.Add(new LiteralControl("</table>")); }
public static DateTime AddPeriodToDate(DateTime utcDate, Periods period) { switch(period) { case Periods.FiveYears: return utcDate.AddYears(5); case Periods.Forever: return DateTime.MaxValue; case Periods.OneMonth: return utcDate.AddMonths(1); case Periods.OneTime: return utcDate; case Periods.OneWeek: return utcDate.AddDays(7); case Periods.OneYear: return utcDate.AddYears(1); case Periods.SixMonths: return utcDate.AddMonths(6); case Periods.ThirtyDays: return utcDate.AddDays(30); case Periods.ThreeMonths: return utcDate.AddMonths(3); case Periods.TwoWeeks: return utcDate.AddDays(14); case Periods.TwoYears: return utcDate.AddYears(2); case Periods.Unknown: return utcDate; } return utcDate; }
/// <summary> /// 1.统计上月访问量,存入表LoginCount /// 2.删除本月之前的12个月的访问ip信息, /// </summary> public void DealLoginInfo() { //当前月的初始日期 DateTime firstDayOfThisMonth= new DateTime(DateTime.Now.Year,DateTime.Now.Month,1); DateTime start; DateTime end; int loginInfoCount; for (var i = 1; i <= 12; i++) //处理过去一年的登录记录 { start = firstDayOfThisMonth.AddMonths(-i); end = firstDayOfThisMonth.AddMonths(-i + 1) ; if (this.LoginInfoService.GetCount(end) == 0) //当前月之前不存在任何登陆记录,则退出循环 { break; } loginInfoCount = this.LoginInfoService.GetCount(start,end); if (loginInfoCount != 0) { //统计该月访问来量,存入LoginCount表 MonthLoginCount monthLoginCount = new MonthLoginCount { Count = loginInfoCount, YearMonth = start }; this.MonthLoginCountService.AddMonthLoginCount(monthLoginCount); //然后删除该月份记录 IEnumerable<LoginInfo> loginInfos = this.LoginInfoService.GetLoginInfoByTime(start,end); this.LoginInfoService.DeleteLoginInfos(loginInfos); } } }
public List<MonthlyTemp> CreateWeatherData() { var time = new DateTime(2004, 1, 1); var result = new List<MonthlyTemp>(); Random r = new Random(); for (int i = 0; i < 5; i++) { for (int a = 0; a < 3; a++) { result.Add(new MonthlyTemp(time, r.Next(0, 10))); time = time.AddMonths(1); } for (int a = 0; a < 3; a++) { result.Add(new MonthlyTemp(time, r.Next(10, 20))); time = time.AddMonths(1); } for (int a = 0; a < 3; a++) { result.Add(new MonthlyTemp(time, r.Next(20, 30))); time = time.AddMonths(1); } for (int a = 0; a < 3; a++) { result.Add(new MonthlyTemp(time, r.Next(10, 20))); time = time.AddMonths(1); } } return result; }
public void CanCalculateRecurrenceSet() { #region Arrange var validStartDateTime = new DateTime(2014, 1, 31); const int validMonthsBetweenOccurrences = 2; DateTime validEndDateTime = validStartDateTime.AddMonths(9); var validDayOfMonthMonthlyRecurrence = new DayOfMonthMonthlyRecurrence(validStartDateTime, validMonthsBetweenOccurrences, validEndDateTime); var expectedRecurrenceSet = new List<DateTime> { validStartDateTime, // 1/31/2014 (January) validStartDateTime.AddMonths(2), // 3/31/2014 (March) validStartDateTime.AddMonths(4), // 5/31/2014 (May) validStartDateTime.AddMonths(6) // 7/31/2014 (July) // no 9/31/2014 (September) because September only has 30 days so its skipped }; #endregion #region Act IEnumerable<DateTime> recurrenceSet = validDayOfMonthMonthlyRecurrence.CalculateRecurrenceSet(); #endregion #region Assert Assert.IsTrue(expectedRecurrenceSet.SequenceEqual(recurrenceSet)); #endregion }
public static DateTime Add(DatePartType datePart, long add, DateTime dt) { switch (datePart) { case DatePartType.Year: return dt.AddYears ((int)add); case DatePartType.Quarter: return dt.AddMonths ((int)add * 3); case DatePartType.Month: return dt.AddMonths ((int)add); case DatePartType.Day: case DatePartType.DayOfYear: case DatePartType.DayOfWeek: return dt.AddDays (add); case DatePartType.Hour: return dt.AddHours (add); case DatePartType.Minute: return dt.AddMinutes (add); case DatePartType.Second: return dt.AddSeconds (add); case DatePartType.MilliSecond: return dt.AddMilliseconds (add); case DatePartType.MicroSecond: return dt.AddTicks (add * TimeSpan.TicksPerMillisecond / 1000); case DatePartType.NanoSecond: return dt.AddTicks (add * TimeSpan.TicksPerMillisecond / 1000000); default: throw new InvalidOperationException (string.Format ("Unknown DatePart type '{0}'", datePart)); } }
/// <summary> /// Should forcast using 12 months data, falling back to 6 month if unavailable /// //ForcastSlope = _ForcastVals[0]; //ForcastIntercept = _ForcastVals[1]; //ForcastValue = _ForcastVals[2]; //ForcastRangeUpperBount = _ForcastVals[3]; /// </summary> /// <param name="SKUID"></param> private double[] Forcast(int SkuId, DateTime EndDate) { StatusMonContext db = new StatusMonContext(); List<double> SalesData; double[] xdata; double[] ydata; DateTime EndDate12 = EndDate.AddMonths(-12); DateTime EndDate6 = EndDate.AddMonths(-6); int date = (EndDate.Date.Year * 12 + EndDate.Date.Month); //Test if 12 Month of Data Exists if (db.SalesOrderDetails.Where(o => o.SalesOrder.OrderDate <= EndDate12).Count() > 0) { SalesData = MonthlySalesD(SkuId, EndDate.AddMonths(-11), EndDate); xdata = new double[] { date - 11, date - 10, date - 9, date - 8, date - 7, date - 6, date - 5, date - 4, date - 3, date - 2, date - 1, date }; //12 Months! } else if (db.SalesOrderDetails.Where(o => o.SalesOrder.OrderDate.Date <= EndDate6).Count() > 0) { //6 Months SalesData = MonthlySalesD(SkuId, EndDate.AddMonths(-5), EndDate); xdata = new double[] { date - 5, date - 4, date - 3, date - 2, date - 1, date }; //Actual Values are nominal } else { //Not enough Data to forcast accurately db.Dispose(); return new double[] { 0, 0, 0, 0}; } db.Dispose(); ydata = SalesData.ToArray(); return Linear.Forcast(date + 1, xdata, ydata); }
public static string GenerateDatePeriodTimexWithDiff(DateObject beginDate, ref DateObject endDate, string durationUnit) { var diff = 0; switch (durationUnit) { case Constants.TimexWeek: diff = Constants.WeekDayCount - (beginDate.DayOfWeek == 0 ? Constants.WeekDayCount : (int)beginDate.DayOfWeek); endDate = beginDate.AddDays(diff); break; case Constants.TimexMonthFull: endDate = DateObject.MinValue.SafeCreateFromValue(beginDate.Year, beginDate.Month, 1); endDate = endDate.AddMonths(1).AddDays(-1); diff = endDate.Day - beginDate.Day + 1; break; case Constants.TimexYear: endDate = DateObject.MinValue.SafeCreateFromValue(beginDate.Year, 12, 1); endDate = endDate.AddMonths(1).AddDays(-1); diff = endDate.DayOfYear - beginDate.DayOfYear + 1; break; } var durationTimex = Constants.GeneralPeriodPrefix + diff + Constants.TimexDay; return($"({DateTimeFormatUtil.LuisDate(beginDate)},{DateTimeFormatUtil.LuisDate(endDate)},{durationTimex})"); }
public static bool IsYellow(DateTime inputDate) { var thisMonthStartDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); var legitimateStartDate = thisMonthStartDate.AddMonths(-2); var legitimateEndDate = thisMonthStartDate.AddMonths(-1); return inputDate >= legitimateStartDate && inputDate < legitimateEndDate; }
public DataTable DBTableSpaceLineNumberDetail(int Year,int Month,int BussID) { DateTime Start = new DateTime(Year, Month, 1); string sql = string.Format(@"select d.DeviceName,db.DeviceName DBName, ditem.DeviceName tableSpaceName,gro.* , sy.maxval as symaxval,sy.minval as syminval,sy.avgval as syavgval from ( select deviceno,channelno,round(AVG(monitorvalue),2) avgval ,max(monitorvalue) maxval ,min(monitorvalue) minval from ReportTemp where channelno=22603 and MonitorTime >='{0} 00:00:00' and MonitorTime <='{1} 23:59:59' group by deviceno,channelno ) as gro inner join t_DevItemList ditem on ditem.DeviceID= gro.deviceno inner join t_Bussiness bus on ditem.ParentDevID=bus.Id and bus.parentid={2} inner join t_Device db on db.DeviceID= bus.Id inner join t_Device d on d.DeviceID= bus.ParentId left join ( select deviceno,channelno,round(AVG(monitorvalue),2) avgval ,max(monitorvalue) maxval ,min(monitorvalue) minval from ReportTemp where channelno=22603 and MonitorTime >='{3} 00:00:00' and MonitorTime <='{4} 23:59:59' group by deviceno,channelno ) as sy on sy.deviceno= gro.deviceno and sy.channelno= gro.channelno order by deviceno,channelno", Start.ToString("yyyy-MM-dd") , Start.AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd") , BussID , Start.AddMonths(-1).ToString("yyyy-MM-dd") , Start.AddDays(-1).ToString("yyyy-MM-dd")); return db.ExecuteQuery(sql); }
public DataBoundCalendarHeader(DateTime VisibleDate) { _dataItem = new System.Collections.Generic.Dictionary<string, DateTime>(); _prevMonth = VisibleDate.AddMonths(-1); _currMonth = VisibleDate; _nextMonth = VisibleDate.AddMonths(1); }
public static DateTime IncrementDate(this TimePeriod period, DateTime date, int amount) { switch (period) { case TimePeriod.Millisecond: return date.AddMilliseconds(amount); case TimePeriod.Second: return date.AddSeconds(amount); case TimePeriod.Minute: return date.AddMinutes(amount); case TimePeriod.Hour: return date.AddHours(amount); case TimePeriod.Day: return date.AddDays(amount); case TimePeriod.Month: return date.AddMonths(amount); case TimePeriod.Quarter: return date.AddMonths(amount * 3); case TimePeriod.Half: return date.AddMonths(amount * 6); case TimePeriod.Year: return date.AddYears(amount); default: throw new Exception("Unknown period: " + period.ToString()); } }
public override DateTime Next(DateTime time, out bool changed) { changed = false; if (Values.Count < 1) { return time; } if (Type == CGtd.DATES_TYPE_EACH) { return time.AddMonths(Values[0]); } if (Type == CGtd.DATES_TYPE_WHEN) { int idx = time.Month; int tmp = NextValue(idx, changed); if (tmp > 0) { return time.AddMonths(tmp); } if (tmp < 0) { changed = true; return time.AddYears(1).AddMonths(Values[0] - idx); } } return time; }
public JsonResult NextMonth(int no, int locationId) { today = today.AddDays(no); GetDate(); GetMonth(); period = string.Format("{0}{1}", today.Year, bulan); var previousMonth = string.Format("{0}{1}", today.AddMonths(-1).Year, ConvertMonth(today.AddMonths(-1))); var twoBeforeMonth = string.Format("{0}{1}", today.AddMonths(-2).Year, ConvertMonth(today.AddMonths(-2))); IList<TenantSubterminalMonthlySales> monthlySales = subTerminalRepo.FindTenantSubTerminalMonthlySaleByPeriod(period, locationId); IList<TenantSubterminalMonthlySales> monthlyPreviousSales = subTerminalRepo.FindTenantSubTerminalMonthlySaleByPeriod(previousMonth, locationId); IList<TenantSubterminalMonthlySales> monthlyTwoBeforeSales = subTerminalRepo.FindTenantSubTerminalMonthlySaleByPeriod(twoBeforeMonth, locationId); SalesAmountMonth salesAmount = new SalesAmountMonth() { CompanyName = monthlySales[0].CompanyName, LocationId = locationId, TotalSaleIDRCurrentMonth = subTerminalRepo.TotalTenanSubTerminalSalePerMonth(monthlySales).ToString("N"), TotalSaleIDROneMonthBefore = monthlyPreviousSales.Sum<TenantSubterminalMonthlySales>(y => y.MonthlyTotalSalePerTenan).ToString("N"), TotalSaleIDRTwoMonthBefore = monthlyTwoBeforeSales.Sum<TenantSubterminalMonthlySales>(y => y.MonthlyTotalSalePerTenan).ToString("N"), Transactiondate = today.ToString("MMMM yyyy"), OneMonthBefore = today.AddMonths(-1).ToString("MMMM yyyy"), TwoMonthBefore = today.AddMonths(-2).ToString("MMMM yyyy"), TotalSaleUSDCurrentMonth = monthlySales.Sum<TenantSubterminalMonthlySales>(y => y.MonthlyTotalSalesPerTenantInUSD).ToString("N"), TotalSaleUSDOneMonthBefore = monthlyPreviousSales.Sum<TenantSubterminalMonthlySales>(y => y.MonthlyTotalSalesPerTenantInUSD).ToString("N"), TotalSaleUSDTwoMonthBefore = monthlyTwoBeforeSales.Sum<TenantSubterminalMonthlySales>(y => y.MonthlyTotalSalesPerTenantInUSD).ToString("N"), }; return Json(salesAmount, JsonRequestBehavior.AllowGet); }
public void CalculatedRecurrenceSetPagingWorks() { #region Arrange var validStartDateTime = new DateTime(2014, 1, 31); const int validMonthsBetweenOccurrences = 2; DateTime validEndDateTime = validStartDateTime.AddMonths(9); var validDayOfMonthMonthlyRecurrence = new DayOfMonthMonthlyRecurrence(validStartDateTime, validMonthsBetweenOccurrences, validEndDateTime); var expectedRecurrenceSet = new List<DateTime> { validStartDateTime.AddMonths(2), // 3/31/2014 (March) validStartDateTime.AddMonths(4) // 5/31/2014 (May) }; #endregion #region Act const int validSkip = 1; const int validTake = 2; IEnumerable<DateTime> recurrenceSet = validDayOfMonthMonthlyRecurrence.CalculateRecurrenceSet( validSkip, validTake); #endregion #region Assert Assert.IsTrue(expectedRecurrenceSet.SequenceEqual(recurrenceSet)); #endregion }
/// <summary> /// 根据当前还款时间和还款周期,计算下一个还款时间 /// </summary> /// <param name="thisPaymentDate">当前还款时间</param> /// <param name="paymentCircle">还款周期</param> /// <returns>一个还款时间</returns> public static DateTime GetNextPaymentDate(DateTime thisPaymentDate, PaymentTermTypes paymentCircle) { DateTime nextPaymentDate = DateTime.MinValue; switch (paymentCircle) { case PaymentTermTypes.Daily: nextPaymentDate = thisPaymentDate.AddDays(1); break; case PaymentTermTypes.Weekly: nextPaymentDate = thisPaymentDate.AddDays(7); break; case PaymentTermTypes.DoubleWeekly: nextPaymentDate = thisPaymentDate.AddDays(14); break; case PaymentTermTypes.DoubleMonthly: nextPaymentDate = thisPaymentDate.AddMonths(2); break; case PaymentTermTypes.Quarterly: nextPaymentDate = thisPaymentDate.AddMonths(3); break; case PaymentTermTypes.SemiYearly: nextPaymentDate = thisPaymentDate.AddMonths(6); break; case PaymentTermTypes.Annual: nextPaymentDate = thisPaymentDate.AddYears(1); break; case PaymentTermTypes.Monthly: default: nextPaymentDate = thisPaymentDate.AddMonths(1); break; } //贷款还款日期的时间精度仅仅控制到日,不对时分秒控制 return nextPaymentDate.Date; }
public DepositTotalsModel() { var today = Util.Now.Date; var first = new DateTime(today.Year, today.Month, 1); if (today.Day < 8) first = first.AddMonths(-1); Dt1 = first; Dt2 = first.AddMonths(1).AddDays(-1); }
protected override void CalculateSeries(int firstIndex, int lastIndex) { if (firstIndex > lastIndex) return; DateTime dateTime1 = this.parentSeries.GetDateTime(firstIndex); DateTime dateTime2 = this.parentSeries.GetDateTime(lastIndex); for (DateTime DateTime = new DateTime(dateTime1.Year, dateTime1.Month, 1); DateTime <= dateTime2; DateTime = DateTime.AddMonths(1)) this.series.Add(DateTime, this.parentSeries[DateTime.AddMonths(1).AddTicks(-1L), EIndexOption.Prev]); }
/// <summary> /// Gets the next available date for an autoOrder starting with the provided date. /// </summary> /// <param name="date">The original start date</param> /// <returns>The nearest available start date for an autoOrder</returns> public static DateTime GetNextAvailableAutoOrderStartDate(DateTime date) { // Ensure we are not returning a day of 29, 30 or 31. if (date.Day > 28) { date = new DateTime(date.AddMonths(1).Year, date.AddMonths(1).Month, 1).Date; } return date; }
protected void Button4_Click(object sender, System.EventArgs e) { System.DateTime now = System.DateTime.Now; this.calToDate.SelectedDate = new System.DateTime?(now); this.calFromDate.SelectedDate = new System.DateTime?(now.AddMonths(-1)); this.ToDate = now.ToString("yyyy-MM-dd"); this.FromDate = now.AddMonths(-1).ToString("yyyy-MM-dd"); this.lastDay = 30; this.ReloadManagerLogs(true); }
public TotalsByFundModel() { var today = Util.Now.Date; var first = new DateTime(today.Year, today.Month, 1); if (today.Day < 8) first = first.AddMonths(-1); Dt1 = first; Dt2 = first.AddMonths(1).AddDays(-1); Online = 2; }
protected void ddlMonth_SelectedIndexChanged(object sender, EventArgs e) { DateTime beginDate = new DateTime(DateTime.Now.Year, int.Parse(ddlMonth.SelectedValue), 1); DateTime endDate = new DateTime(beginDate.AddMonths(1).Year, beginDate.AddMonths(1).Month, 1); DateTime pastDate = new DateTime(beginDate.AddDays(-1).Year, beginDate.AddDays(-1).Month, 1); txtBeginDate.Text = beginDate.ToShortDateString(); txtEndDate.Text = endDate.AddDays(-1).ToShortDateString(); txtPastBeginDate.Text = pastDate.ToShortDateString(); txtPastEndDate.Text = pastDate.AddMonths(1).AddDays(-1).ToShortDateString(); this.lblTime.Text = "月" + "[" + beginDate.ToShortDateString() + " - " + endDate.AddDays(-1).ToShortDateString() + "]"; this.lblPastPlanYear.Text = pastDate.Year.ToString(); lblPastPlanPeriod.Text = pastDate.Month.ToString(); this.lblPastPlanPeroidType.Text = "月"; this.lblCurrentPlanYear.Text = beginDate.Year.ToString(); this.lblCurrentPlanPeroid.Text = beginDate.Month.ToString(); this.lblCurrentPlanPeroidType.Text = "月"; //this.lblPastPlan.Text = pastDate.Year.ToString() + "年" + pastDate.Month.ToString() + "月计划"; this.lblConclusion.Text = pastDate.Year.ToString() + "年" + pastDate.Month.ToString() + "月总结"; //this.lblCurrentPlan.Text = beginDate.Year.ToString() + "年" + beginDate.Month.ToString() + "月计划"; ActiveRecord.Model.Plan plan = new ActiveRecord.Model.Plan().Find(ddlPlanObjectType.SelectedValue, ddlPlanPeriodType.SelectedValue, lblCurrentPlanYear.Text, lblCurrentPlanPeroid.Text, Server.UrlDecode(Request.Cookies["UserName"].Value)); if (plan != null)//本月计划 { this.FCKeditor3.Value = plan.PlanContent; } else { this.FCKeditor3.Value = ""; } //if (plan.PlanBeginDate > DateTime.Now || plan.PlanEndDate < DateTime.Now) //{ // Response.Write("<script laguage='javascript'>setFckEditor3ReadOnly();</script>"); //} //上月总结 plan = new ActiveRecord.Model.Plan().Find(ddlPlanObjectType.SelectedValue, ddlPlanPeriodType.SelectedValue, lblPastPlanYear.Text, int.Parse(lblPastPlanPeriod.Text).ToString(), Server.UrlDecode(Request.Cookies["UserName"].Value)); if (plan != null)//上月总结 { this.FCKeditor2.Value = plan.PlanConclusion; this.past_plan_content.InnerHtml = plan.PlanContent;//上月计划 } else { this.FCKeditor2.Value = ""; this.past_plan_content.InnerHtml = ""; } //if (plan.PlanBeginDate > DateTime.Now || plan.PlanEndDate < DateTime.Now) //{ // Response.Write("<script laguage='javascript'>setFckEditor2ReadOnly();</script>"); //} }
private void Generar() { string UltimoPeriodo=""; pgbProgreso.Value = 0; pgbProgreso.Minimum = 0; pgbProgreso.Visible = true; DateTime StartDate = new DateTime(int.Parse(this.mtbDesde.Text.Substring(0, 4)),int.Parse( this.mtbDesde.Text.Substring(5, 2)), 1); DateTime EndDate = new DateTime(int.Parse(this.mtbHasta.Text.Substring(0, 4)), int.Parse(this.mtbHasta.Text.Substring(5, 2)), 1); //Calculo diferencia de meses para utilizar en la barra de progreso pgbProgreso.Maximum = Math.Abs((EndDate.Month - StartDate.Month) + 12 * (EndDate.Year - StartDate.Year)); int MonthInterval = 1; PeriodosImplement oPeriodoImplement = new PeriodosImplement(); SysConfigImplement oSysConfigImplement = new SysConfigImplement(); sys_configuracion oSysUltimoPeriodo = new sys_configuracion(); oSysUltimoPeriodo = oSysConfigImplement.GetByNombre("UltimoPeriodo"); UltimoPeriodo = oSysUltimoPeriodo.valor; //voy sumando meses hasta llegar a iguales fechas while (StartDate.AddMonths(MonthInterval) <= EndDate) { StartDate = StartDate.AddMonths(MonthInterval); periodos oPeriodo = new periodos(); oPeriodo.id_periodo = StartDate.Date.ToString("yyyyMMdd").Substring(0,6); DateTime PrimerVencimiento = DateTime.Parse(oPeriodo.id_periodo.Substring(0, 4) + "/" + oPeriodo.id_periodo.Substring(4, 2)+"/" + this.txtPrimerVenc.Text); // incremento el dia mientra no sea fin de semana(se puede agregar para feriados - primer vencimiento while (PrimerVencimiento.DayOfWeek == DayOfWeek.Saturday || PrimerVencimiento.DayOfWeek == DayOfWeek.Sunday) { PrimerVencimiento=PrimerVencimiento.Date.AddDays(1); } DateTime segundoVencimiento = PrimerVencimiento.Date.AddDays(int.Parse(this.txtDiasEntre.Text)); // incremento el dia mientra no sea fin de semana(se puede agregar para feriados - segundo vencimiento while (segundoVencimiento.DayOfWeek == DayOfWeek.Saturday || segundoVencimiento.DayOfWeek == DayOfWeek.Sunday) { segundoVencimiento = segundoVencimiento.Date.AddDays(1); } oPeriodo.fecha_primer_venc = PrimerVencimiento; oPeriodo.fecha_segundo_venc = segundoVencimiento; oPeriodo.fecha_tercer_venc = null; oPeriodo.fecha_facturacion = null; oPeriodo.facturado = false; oPeriodoImplement.Save(oPeriodo); UltimoPeriodo=oPeriodo.id_periodo; pgbProgreso.Value += 1; } if (oSysUltimoPeriodo.valor != UltimoPeriodo) { oSysUltimoPeriodo.valor = UltimoPeriodo; oSysConfigImplement.Update(oSysUltimoPeriodo); MessageBox.Show("La Generación se realizo Exitosamente"); Inicializar(); } else { MessageBox.Show("La Generación fue nula"); } }
protected void Page_Load(object sender, EventArgs e) { Query q = new Query(); q.ExtraSelectElements.Add("Sum", "SUM([Invoice].[Price])"); q.ExtraSelectElements.Add("Day", "DATENAME(DW,[Invoice].[CreatedDateTime])"); q.QueryCondition = new And( new Q(Invoice.Columns.Type, Invoice.Types.Invoice), new Q(Invoice.Columns.Price, QueryOperator.LessThan, 1000.0)); q.GroupBy = new GroupBy("DATENAME(DW,[Invoice].[CreatedDateTime])"); q.Columns = new ColumnSet(); InvoiceSet ins = new InvoiceSet(q); Dictionary<DayOfWeek, decimal> weight = new Dictionary<DayOfWeek, decimal>(); decimal total = 0.0m; foreach (Invoice i in ins) { total += (decimal)i.ExtraSelectElements["Sum"]; } foreach (Invoice i in ins) { decimal fraction = (decimal)i.ExtraSelectElements["Sum"] / total; switch ((string)i.ExtraSelectElements["Day"]) { case "Monday": weight[DayOfWeek.Monday] = fraction; break; case "Tuesday": weight[DayOfWeek.Tuesday] = fraction; break; case "Wednesday": weight[DayOfWeek.Wednesday] = fraction; break; case "Thursday": weight[DayOfWeek.Thursday] = fraction; break; case "Friday": weight[DayOfWeek.Friday] = fraction; break; case "Saturday": weight[DayOfWeek.Saturday] = fraction; break; case "Sunday": weight[DayOfWeek.Sunday] = fraction; break; default: break; } } Stats.Controls.Add(new LiteralControl("<table><tr><td>Month</td><td>Year</td><td>Weight</td><td>Actual revenue</td><td>Weighted revenue</td></tr>")); for (DateTime dtMonth = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(-12); dtMonth <= new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); dtMonth = dtMonth.AddMonths(1)) { try { decimal monthWeight = 0.0m; for (DateTime dtDay = dtMonth; dtDay < dtMonth.AddMonths(1) && dtDay < DateTime.Today; dtDay = dtDay.AddDays(1)) { monthWeight += weight[dtDay.DayOfWeek]; } Query qMonth = new Query(); qMonth.ExtraSelectElements.Add("Count", "SUM([Invoice].[Price])"); qMonth.QueryCondition = new And( new Q(Invoice.Columns.BuyerType, BuyerType), new Q(Invoice.Columns.CreatedDateTime, QueryOperator.GreaterThanOrEqualTo, dtMonth), new Q(Invoice.Columns.CreatedDateTime, QueryOperator.LessThan, dtMonth.AddMonths(1)), new Q(Invoice.Columns.CreatedDateTime, QueryOperator.LessThan, DateTime.Today)); qMonth.Columns = new ColumnSet(); InvoiceSet isMonth = new InvoiceSet(qMonth); decimal actualRevenue = (decimal)isMonth[0].ExtraSelectElements["Count"]; decimal revenuePerWeek = actualRevenue / monthWeight; decimal revenuePerMonth = revenuePerWeek * 4.345238095m;
void SwitchMonth(int Direction) { if (Direction < 0) { date = date.AddMonths(-1); } else { date = date.AddMonths(1); } }
public static CalendarYear CreateCalendarYear() { var today = DateTime.Today; var yearStart = new DateTime(today.Year, 1, 1); var year = new CalendarYear(today.Year); for (int i = 0; i < 12; i++) { year.Blocks.Add(CreateBlock(yearStart.AddMonths(i), yearStart.AddMonths(i + 1).AddDays(-1))); } AssignBaseObjectProperties(year); return year; }
/// <summary> /// Function that averages a series based on a defined Time-Interval /// </summary> /// <param name="s">Input Series</param> /// <param name="tInterval">Averaging Time-Interval</param> /// <returns></returns> public static Series Average(Series s, TimeInterval tInterval) { Series rval = s.Clone(); if (s.Count == 0) return rval; // Define starting date of averaging process DateTime t = new DateTime(s[0].DateTime.Year, s[0].DateTime.Month, s[0].DateTime.Day, s[0].DateTime.Hour, 0, 0); // Find which averaging process to accomplish if (tInterval == TimeInterval.Daily) { // Define series time-interval rval.TimeInterval = TimeInterval.Daily; // Loop through the dates while (t < s[s.Count - 1].DateTime.Date) { // Get the series subset based on the averaging time-interval Series sTemp = s.Subset(t, t.AddDays(1)); // Average the values of the subset DoAverage(rval, t, sTemp); // Increment DateTime by averaging time-interval t = t.AddDays(1); } } // Ditto on the other processes below else if (tInterval == TimeInterval.Monthly) { rval.TimeInterval = TimeInterval.Monthly; while (t < s[s.Count - 1].DateTime.Date) { Series sTemp = s.Subset(t, t.AddMonths(1)); DoAverage(rval, t, sTemp); t = t.AddMonths(1); } } else if (tInterval == TimeInterval.Hourly) { rval.TimeInterval = TimeInterval.Hourly; while (t < s.MaxDateTime) { Series sTemp = Math.Subset(s, new DateRange(t, t.AddHours(1)), false); DoAverage(rval, t, sTemp); t = t.AddHours(1); } } else { throw new Exception("Time Interval " + tInterval.ToString() + " not supported!"); } return rval; }
public void EndOfMonth() { var end = new DateTime(2011, 1, 31); Assert.AreEqual(end, end.AddDays(-2).EndOfMonth()); Assert.AreEqual(end, new DateTime(2011, 1, 1).EndOfMonth()); Assert.AreEqual(end, end.EndOfMonth()); Assert.AreEqual(new DateTime(2012, 2, 29), new DateTime(2012, 2, 1).EndOfMonth()); Assert.AreNotEqual(end, end.AddMonths(1).EndOfMonth()); Assert.AreNotEqual(end, end.AddMonths(-1).EndOfMonth()); }
protected void Generate(object sender, EventArgs eventArgs) { DateTime issueDate = new DateTime(long.Parse(IssueDrop.SelectedValue)); DateTime min = new DateTime(issueDate.AddMonths(-1).Year, issueDate.AddMonths(-1).Month, 10); DateTime max = new DateTime(issueDate.AddMonths(1).Year, issueDate.AddMonths(1).Month, 1).AddDays(-1); Query q = new Query(); q.TableElement = Bobs.Event.VenueAllJoin; q.QueryCondition = new And( new Q(Bobs.Event.Columns.DateTime, QueryOperator.GreaterThanOrEqualTo, min), new Q(Bobs.Event.Columns.DateTime, QueryOperator.LessThanOrEqualTo, max), placeQ ); EventSet es = new EventSet(q); Response.Clear(); Response.ContentType = "application/csv"; foreach (Bobs.Event e in es) { Response.Write(""); Response.Write("[venue id?]" + "\t");//MMV09299 Response.Write(e.Venue.Place.Name + "\t");//London Response.Write(e.Venue.Place.Name + "\t");//london Response.Write(e.Venue.Capacity.ToString("#,##0") + "\t");//[capacity] Response.Write("[venue address 1]" + "\t");//Old QueenÕs Head Response.Write("[venue address 2]" + "\t");//44 Essex Road, N1 Response.Write("[event id?]" + "\t");//MMN09724 Response.Write((e.Brands.Count > 0 ? e.Brands[0].Name.TruncateWithDots(30) : e.Name.TruncateWithDots(30)) + "\t");//Apocalypso Response.Write(e.DateTime.ToString("dddd") + "\t");//Friday Response.Write("[start-time]" + "\t");//8pm Response.Write("[end-time]" + "\t");//2am Response.Write("[price]" + "\t");//£4 Response.Write("[phone]" + "\t");//020 7354 9993 Response.Write("[???]" + "\t");//[???] Response.Write("[web address]" + "\t");//www.theoldqueenshead.com Response.Write("[main brand description]" + "\t");//Electro and indie dance at this party boozer. Response.Write("[mixmag offer]" + "\t");//HALF PRICE Response.Write(e.DateTime.ToString("dd/mm/yyyy") + "\t");//29/05/2009 Response.Write(e.DateTime.ToString("d/m") + "\t");//29/5 Response.Write(e.ShortDetailsHtml.Replace("\r", string.Empty).Replace("\n", string.Empty).TruncateWithDots(40) + "\t");//Dekker & Johan Response.Write("[???]" + "\t");//[???] Response.Write("[???]" + "\t");//[???] Response.Write("[???]" + "\t");//[???] Response.Write("[locality?]");//Angel Response.Write("\n"); } Response.Flush(); Response.Close(); Response.End(); }
internal static bool ValidRelativeMonthYear(MonthYear input, int lowerBound, MonthYearUnit lowerUnit, RangeBoundaryType lowerBoundType, int upperBound, MonthYearUnit upperUnit, RangeBoundaryType upperBoundType) { DateTime now = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); DateTime lowerDate = DateTime.MinValue; DateTime upperDate = DateTime.MaxValue; DateTime inputDate = new DateTime(input.Year, input.Month, 1); switch (lowerUnit) { case MonthYearUnit.Month: lowerDate = now.AddMonths(lowerBound * -1); break; case MonthYearUnit.Year: lowerDate = now.AddYears(lowerBound * -1); break; } switch (upperUnit) { case MonthYearUnit.Month: upperDate = now.AddMonths(upperBound); break; case MonthYearUnit.Year: upperDate = now.AddYears(upperBound); break; } //default the bound check to true - if lowerBoundType is Ignore, no test will be performed. bool lowerBoundOk = true; if (lowerBoundType == RangeBoundaryType.Inclusive) { lowerBoundOk = inputDate.CompareTo(lowerDate) >= 0; } else if (lowerBoundType == RangeBoundaryType.Exclusive) { lowerBoundOk = inputDate.CompareTo(lowerDate) > 0; } //default the bound check to true - if upperBoundType is Ignore, no test will be performed. bool upperBoundOk = true; if (upperBoundType == RangeBoundaryType.Inclusive) { upperBoundOk = inputDate.CompareTo(upperDate) <= 0; } else if (upperBoundType == RangeBoundaryType.Exclusive) { upperBoundOk = inputDate.CompareTo(upperDate) < 0; } return lowerBoundOk && upperBoundOk; }
private DateTimeResolutionResult ParseWeekOfMonth(string text, DateObject referenceDate) { var ret = new DateTimeResolutionResult(); var trimedText = text.Trim().ToLowerInvariant(); var match = this.config.WeekOfMonthRegex.Match(trimedText); if (!(match.Success && match.Length == text.Length)) { return(ret); } var cardinalStr = match.Groups["cardinal"].Value; var monthStr = match.Groups["month"].Value; var noYear = false; int year; int cardinal; if (this.config.IsLastCardinal(cardinalStr)) { cardinal = 5; } else { cardinal = this.config.CardinalMap[cardinalStr]; } int month; if (string.IsNullOrEmpty(monthStr)) { var swift = this.config.GetSwiftDayOrMonth(trimedText); month = referenceDate.AddMonths(swift).Month; year = referenceDate.AddMonths(swift).Year; } else { month = this.config.MonthOfYear[monthStr]; year = referenceDate.Year; noYear = true; } ret = GetWeekOfMonth(cardinal, month, year, referenceDate, noYear); return(ret); }
public JsonResult CalGetDaysAge(string datebirth) { DateTime dtpDateOfBirth = Convert.ToDateTime(datebirth); List <PatientOPD> add = new List <Models.Patient.PatientOPD>(); PatientOPD obj = new Models.Patient.PatientOPD(); DateTime dtToday = new System.DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0); DateTime dtBeforeDate = new System.DateTime(dtpDateOfBirth.Year, dtpDateOfBirth.Month, dtpDateOfBirth.Day, 0, 0, 0); int Year = 0; int Month = 0; int Day = 0; dtBeforeDate = dtBeforeDate.AddYears(1); while (dtToday >= dtBeforeDate) { dtBeforeDate = dtBeforeDate.AddYears(1); Year++; } dtBeforeDate = new System.DateTime(dtpDateOfBirth.Year, dtpDateOfBirth.Month, dtpDateOfBirth.Day, 0, 0, 0); dtBeforeDate = dtBeforeDate.AddMonths(1); while (dtToday >= dtBeforeDate) { dtBeforeDate = dtBeforeDate.AddMonths(1); Month++; } dtBeforeDate = new System.DateTime(dtpDateOfBirth.Year, dtpDateOfBirth.Month, dtpDateOfBirth.Day, 0, 0, 0); dtBeforeDate = dtBeforeDate.AddMonths(Month); var a = dtBeforeDate; //if(a== getTime()) //{ //} TimeSpan diffResult = dtToday.Date - dtBeforeDate.Date; int TotalDay = Convert.ToInt32(diffResult.TotalDays); int TotalMonth = Month % 12; obj.day = TotalDay.ToString(); obj.Month = TotalMonth.ToString(); obj.year = Year.ToString(); add.Add(obj); return(new JsonResult { Data = add, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
void Start() { modificacion = FindObjectOfType <ValoresDefecto>(); print(modificacion.Valor1); Myformat = @"dd/MMM/yyyy"; prueba = "12/04/2021"; valor = "11/05/2021"; DropdownItemSelected1(Municipio); DropdownItemSelected2(Estrato); Municipio.onValueChanged.AddListener(delegate { DropdownItemSelected1(Municipio); }); Estrato.onValueChanged.AddListener(delegate { DropdownItemSelected2(Estrato); }); FactorMultiplicacion.GetComponent <TMP_InputField>().text = "1"; FactorMultiplicacionReactiva.GetComponent <TMP_InputField>().text = "1"; Hasta = System.DateTime.Parse(prueba); Desde = System.DateTime.Parse(valor); Resultado = Desde.Subtract(Hasta); suspencion = Desde.AddDays(21); FechaPago = Desde.AddMonths(-1); print(Hasta.ToString(@Myformat)); print(Hasta.ToString("MMMM")); print(Resultado.ToString("%d")); print(suspencion.ToString(@Myformat)); print(Desde.ToString(@Myformat)); print(FechaPago.ToString(@Myformat)); print((FechaPago.ToString("MMM")).ToUpper()); }
public static string GetMonthTime() { System.DateTime now = System.DateTime.Now; System.DateTime bgDate = now.AddDays((double)(1 - now.Day)); System.DateTime enDate = bgDate.AddMonths(1).AddDays(-1.0); return(Fetch.GetTimeByDate(bgDate, enDate)); }
public static System.DateTime GetStartDayOfWeeks(int year, int month, int index) { System.DateTime result; if (year < 1600 || year > 9999) { result = System.DateTime.MinValue; } else if (month < 0 || month > 12) { result = System.DateTime.MinValue; } else if (index < 1) { result = System.DateTime.MinValue; } else { System.DateTime dateTime = new System.DateTime(year, month, 1); int num = 7; if (System.Convert.ToInt32(dateTime.DayOfWeek.ToString("d")) > 0) { num = System.Convert.ToInt32(dateTime.DayOfWeek.ToString("d")); } System.DateTime dateTime2 = dateTime.AddDays((double)(1 - num)).AddDays((double)(index * 7)); if ((dateTime2 - dateTime.AddMonths(1)).Days > 0) { result = System.DateTime.MinValue; } else { result = dateTime2; } } return(result); }
public static string GetLastMonthTime() { System.DateTime now = System.DateTime.Now; System.DateTime bgDate = System.Convert.ToDateTime(now.AddMonths(-1).ToString("yyyy-MM-01")); System.DateTime enDate = System.Convert.ToDateTime(now.ToString("yyyy-MM-01")); return(Fetch.GetTimeByDate(bgDate, enDate)); }
public void setFecha(int Mes, int Dia, int Hora) { Fecha = new System.DateTime(); Fecha.AddMonths(Mes); Fecha.AddDays(Dia); Fecha.AddHours(Hora); }
protected void Page_Load(object sender, EventArgs e) { Response.Expires = -1; if (!Page.IsPostBack) { //if (Request.QueryString["periodoVer"] != null && Request.QueryString["periodoVer"]!=String.Empty) //{ // periodoVerSupp = Request.QueryString["periodoVer"]; // System.DateTime now = System.DateTime.Now; // CultureInfo ci = new CultureInfo("en-US"); // string dataProxVer = (now.AddYears(Convert.ToInt32(periodoVerSupp))).ToString("dd/MM/yyyy", ci); // this.data.Text = dataProxVer; // this.hd_data.Value = dataProxVer; //} System.DateTime now = System.DateTime.Now; CultureInfo ci = new CultureInfo("en-US"); this.data.Text = (now.AddMonths(6)).ToString("dd/MM/yyyy", ci); this.hd_data.Value = this.data.Text; if (Request.QueryString["stato"] == "V") { this.lb_intestazione.Text = "Registra dati verifica"; this.lb_verifica.Visible = true; this.ddl_verifica.Visible = true; this.hd_verifica.Value = this.ddl_verifica.SelectedValue.ToString(); } } }
public void IssueBook(int VisitorId, int BookId, System.DateTime CurrentDate) { VisitorId = Visitors.FindIndex(x => x.GetId() == VisitorId); BookId = Books.FindIndex(x => x.GetId() == BookId); if (IsBookLimitReached(VisitorId)) { ThrowString("Данный посетитель уже имеет максимально допустимое количество книг."); } else { if (!Books[BookId].isAvailable()) { ThrowString("Данная книга уже выдана."); } else { var Book = Books[BookId]; // Выдать на один месяц Book.Issue(CurrentDate, CurrentDate.AddMonths(1)); Books[BookId] = Book; Visitors[VisitorId].GiveBook(Book); ThrowString("Книга успешно выдана."); } } }
public static void FormatedDate(string monthname, int iyear, out DateTime startdate, out DateTime enddate) { int imonth = GetMonthFromName(monthname); startdate = new System.DateTime(iyear, imonth, 1); enddate = startdate.AddMonths(1).AddDays(-1); }
public void Login(object sender, System.EventArgs e) { try { ActiveUp.Net.Mail.Imap4Client imap4Client = new ActiveUp.Net.Mail.Imap4Client(); imap4Client.Connect((string)Application["server\uFFFD"], System.Convert.ToInt32(Application["port\uFFFD"])); System.Web.Security.FormsAuthentication.SetAuthCookie(iLogin.Text + "|\uFFFD" + iPassword.Text, false); imap4Client.Login(iLogin.Text, iPassword.Text); Session.Add("login\uFFFD", iLogin.Text); Session.Add("imapobject\uFFFD", imap4Client); System.Web.HttpCookie httpCookie = new System.Web.HttpCookie("login\uFFFD", iLogin.Text); System.DateTime dateTime = System.DateTime.Now; httpCookie.Expires = dateTime.AddMonths(2); Response.Cookies.Add(httpCookie); Visible = false; EnableViewState = false; // ((_Default)Page).SetWebmailLanguage(null, null); //BoundMailboxContent.BoundTopNavigation.Enable(); //BoundMailboxContent.BoundTree.LoadTrees(); //BoundMailboxContent.BoundTopNavigation.LoadList(); //BoundMailboxContent.LoadMailbox(Application["startfolder\uFFFD"].ToString(), true); } catch (System.Exception e1) { Visible = true; EnableViewState = true; iLogin.Text = System.String.Empty; // Page.RegisterStartupScript("ShowError\uFFFD", "<script>ShowErrorDialog('\uFFFD" + Language.Get(Server.MapPath("languages/\uFFFD"), Application["defaultlanguage\uFFFD"].ToString()).Words[96].ToString() + "','\uFFFD" + System.Text.RegularExpressions.Regex.Escape(e1.Message + e1.StackTrace).Replace("'\uFFFD", "\\'\uFFFD") + "');</script>\uFFFD"); Page.RegisterStartupScript("ShowError\uFFFD", "<script>ShowErrorDialog('\uFFFD" + Language.Get(Server.MapPath("languages/"), Application["defaultlanguage\uFFFD"].ToString()).Words[96].ToString() + "','\uFFFD" + System.Text.RegularExpressions.Regex.Escape(e1.Message + e1.StackTrace).Replace("'\uFFFD", "\\'\uFFFD") + "');</script>\uFFFD"); } }
public static DateObject OffsetDateObject(DateObject date, int offset, DatePeriodTimexType timexType) { DateObject result; switch (timexType) { case DatePeriodTimexType.ByYear: result = date.AddYears(offset); break; case DatePeriodTimexType.ByMonth: result = date.AddMonths(offset); break; case DatePeriodTimexType.ByWeek: result = date.AddDays(7 * offset); break; case DatePeriodTimexType.ByDay: result = date.AddDays(offset); break; default: result = date; break; } return(result); }
public Remember GenerateRemember() { remember = new Remember(); remember.SetLatLng(Input.location.lastData); remember.SetNumThinke(0); remember.SetThinkTag(null); remember.SetState("Free"); if (string.Equals(this.gameObject.name, PICTUREIMAGE)) { remember.SetTypeMedia(IMAGE); } else { remember.SetTypeMedia(VIDEO); } System.DateTime dateBirth = new System.DateTime(); dateBirth.AddYears(1996); dateBirth.AddMonths(01); dateBirth.AddDays(27); remember.SetMedia(File.ReadAllBytes(path)); remember.SetUserPublished(new User("*****@*****.**", "paolo", 0, "xedodu", "Paolo", "Vigorito", 0, 0, dateBirth, "Student", "Female", remember.GetMedia())); remember.SetDateInsert(System.DateTime.Now.ToUniversalTime()); return(remember); }
private static DateTimeResolutionResult GetDateResult(string unitStr, string numStr, System.DateTime referenceDate, bool future) { System.DateTime date; var ret = new DateTimeResolutionResult(); int futureOrPast = future ? 1 : -1; switch (unitStr) { case "D": date = referenceDate.AddDays(double.Parse(numStr) * futureOrPast); break; case "W": date = referenceDate.AddDays(7 * double.Parse(numStr) * futureOrPast); break; case "MON": date = referenceDate.AddMonths(Convert.ToInt32(double.Parse(numStr)) * futureOrPast); break; case "Y": date = referenceDate.AddYears(Convert.ToInt32(double.Parse(numStr)) * futureOrPast); break; default: return(ret); } ret.Timex = $"{FormatUtil.LuisDate(date)}"; ret.FutureValue = ret.PastValue = date; ret.Success = true; return(ret); }
public static void GetMonthArrayFromDate(DateTime dtStart, DateTime dtEnd, ref string[] strResult, ref DateTime[] dtArray, ref DateTime[] dtMonthStart, ref DateTime[] dtMonthEnd) { if (dtStart > dtEnd) { return; } string[] month = { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "July", "Aug", "Sep", "Oct", "Nov", "Dec" }; //the DateTime Begin System.DateTime dt1 = dtStart; //the DateTime End System.DateTime dt2 = dtEnd; //the Month Count of the Interval int nMonthCount = (dt2.Year - dt1.Year) * 12 + (dt2.Month - dt1.Month + 1); //the string array to return strResult = new string[nMonthCount]; dtArray = new DateTime[nMonthCount]; dtMonthStart = new DateTime[nMonthCount]; dtMonthEnd = new DateTime[nMonthCount]; //assign the value of the string array System.DateTime dt = dt1; for (int i = 0; i < nMonthCount; i++) { dt = dt1.AddMonths(i); dtArray[i] = new DateTime(dt.Year, dt.Month, 1); strResult[i] = month[dt.Month - 1] + " " + dt.Year.ToString(); dtMonthStart[i] = GetFirstDayOfMonth(dtArray[i]); dtMonthEnd[i] = GetLastDayOfMonth(dtArray[i]); } dtMonthStart[0] = dtStart; dtMonthEnd[nMonthCount - 1] = dtEnd; }
/// <summary> Limit a date's resolution. For example, the date <code>1095767411000</code> /// (which represents 2004-09-21 13:50:11) will be changed to /// <code>1093989600000</code> (2004-09-01 00:00:00) when using /// <code>Resolution.MONTH</code>. /// /// </summary> /// <param name="resolution">The desired resolution of the date to be returned /// </param> /// <returns> the date with all values more precise than <code>resolution</code> /// set to 0 or 1, expressed as milliseconds since January 1, 1970, 00:00:00 GMT /// </returns> public static long Round(long time, Resolution resolution) { System.Globalization.Calendar cal = new System.Globalization.GregorianCalendar(); // {{Aroush}} do we care about 'cal' // protected in JDK's prior to 1.4 //cal.setTimeInMillis(time); System.DateTime dt = new System.DateTime(time); if (resolution == Resolution.YEAR) { dt = dt.AddMonths(1 - dt.Month); dt = dt.AddDays(1 - dt.Day); dt = dt.AddHours(0 - dt.Hour); dt = dt.AddMinutes(0 - dt.Minute); dt = dt.AddSeconds(0 - dt.Second); dt = dt.AddMilliseconds(0 - dt.Millisecond); } else if (resolution == Resolution.MONTH) { dt = dt.AddDays(1 - dt.Day); dt = dt.AddHours(0 - dt.Hour); dt = dt.AddMinutes(0 - dt.Minute); dt = dt.AddSeconds(0 - dt.Second); dt = dt.AddMilliseconds(0 - dt.Millisecond); } else if (resolution == Resolution.DAY) { dt = dt.AddHours(0 - dt.Hour); dt = dt.AddMinutes(0 - dt.Minute); dt = dt.AddSeconds(0 - dt.Second); dt = dt.AddMilliseconds(0 - dt.Millisecond); } else if (resolution == Resolution.HOUR) { dt = dt.AddMinutes(0 - dt.Minute); dt = dt.AddSeconds(0 - dt.Second); dt = dt.AddMilliseconds(0 - dt.Millisecond); } else if (resolution == Resolution.MINUTE) { dt = dt.AddSeconds(0 - dt.Second); dt = dt.AddMilliseconds(0 - dt.Millisecond); } else if (resolution == Resolution.SECOND) { dt = dt.AddMilliseconds(0 - dt.Millisecond); } else if (resolution == Resolution.MILLISECOND) { // don't cut off anything } else { throw new System.ArgumentException("unknown resolution " + resolution); } return(dt.Ticks); }
private void DateTime_Load(object sender, EventArgs e) { System.DateTime nowtime = System.DateTime.Now; for (int i = 0; i < 12; i++) { nowtime = nowtime.AddMonths(1); labelmonth.Text = nowtime.ToString("MMMM"); } }
private System.DateTime GetStartYearEndDateMd(System.DateTime start, System.DateTime end) { var dt = new System.DateTime(start.Year, start.Month, end.Day, end.Hour, end.Minute, end.Second, end.Millisecond); if (dt < start) { dt = dt.AddMonths(1); } return(dt); }
public static System.DateTime CalculatePrevMonthStartDate(System.DateTime startDate) { System.DateTime newDate = startDate.AddMonths(-1); if (newDate.Day > 22) { newDate = newDate.AddMonths(1); } newDate = CalculateMonthFirstDate(newDate); return(newDate); }
static void Main(string[] args) { System.DateTime d1 = System.DateTime.Now; Console.WriteLine(d1); d1 = d1.AddDays(10); Console.WriteLine(d1); d1 = d1.AddMinutes(20); Console.WriteLine(d1); d1 = d1.AddMonths(-1); Console.WriteLine(d1); d1 = d1.AddMonths(1); Console.WriteLine(d1); System.DateTime d2 = System.DateTime.Now; Console.WriteLine(d1.Subtract(d2).Days); TimeSpan t2 = new TimeSpan(16, 00, 00); Console.WriteLine(t2); TimeSpan t3 = new TimeSpan(00, 30, 00); Console.WriteLine(t3); TimeSpan t4 = t2 - t3; Console.WriteLine(t4); TimeSpan t5 = t2 + t3; Console.WriteLine(t5); //***************************************************************** // //***************************************************************** System.Console.ReadLine(); }
/// <summary> /// 获取当前年份中最大的一个月的日期时间值 /// </summary> /// <param name="date"></param> /// <returns></returns> public static DateTime GetMaxMonth(this System.DateTime date) { if (date.Month == 12) { return(date); } else { return(date.AddMonths((12 - date.Month))); } }
public static DateObject SafeCreateFromValue(this DateObject datetime, int year, int month, int day) { if (IsValidDate(year, month, day)) { datetime = datetime.AddYears(year - datetime.Year); datetime = datetime.AddMonths(month - datetime.Month); datetime = datetime.AddDays(day - datetime.Day); } return(datetime); }
private void vIncrementaData(ref System.DateTime dtData, mdlEsquemaPagamento.UnidadeTempo enumUnidadeTempo, int nIncremento) { if (enumUnidadeTempo == mdlEsquemaPagamento.UnidadeTempo.Dia) { dtData = dtData.AddDays(nIncremento); } else { dtData = dtData.AddMonths(nIncremento); } }
/// <summary> Limit a date's resolution. For example, the date <c>1095767411000</c> /// (which represents 2004-09-21 13:50:11) will be changed to /// <c>1093989600000</c> (2004-09-01 00:00:00) when using /// <c>Resolution.MONTH</c>. /// /// </summary> /// <param name="time">The time in milliseconds (not ticks).</param> /// <param name="resolution">The desired resolution of the date to be returned /// </param> /// <returns> the date with all values more precise than <c>resolution</c> /// set to 0 or 1, expressed as milliseconds since January 1, 1970, 00:00:00 GMT /// </returns> public static long Round(long time, Resolution resolution) { var dt = new System.DateTime(time * TimeSpan.TicksPerMillisecond); if (resolution == Resolution.YEAR) { dt = dt.AddMonths(1 - dt.Month); dt = dt.AddDays(1 - dt.Day); dt = dt.AddHours(0 - dt.Hour); dt = dt.AddMinutes(0 - dt.Minute); dt = dt.AddSeconds(0 - dt.Second); dt = dt.AddMilliseconds(0 - dt.Millisecond); } else if (resolution == Resolution.MONTH) { dt = dt.AddDays(1 - dt.Day); dt = dt.AddHours(0 - dt.Hour); dt = dt.AddMinutes(0 - dt.Minute); dt = dt.AddSeconds(0 - dt.Second); dt = dt.AddMilliseconds(0 - dt.Millisecond); } else if (resolution == Resolution.DAY) { dt = dt.AddHours(0 - dt.Hour); dt = dt.AddMinutes(0 - dt.Minute); dt = dt.AddSeconds(0 - dt.Second); dt = dt.AddMilliseconds(0 - dt.Millisecond); } else if (resolution == Resolution.HOUR) { dt = dt.AddMinutes(0 - dt.Minute); dt = dt.AddSeconds(0 - dt.Second); dt = dt.AddMilliseconds(0 - dt.Millisecond); } else if (resolution == Resolution.MINUTE) { dt = dt.AddSeconds(0 - dt.Second); dt = dt.AddMilliseconds(0 - dt.Millisecond); } else if (resolution == Resolution.SECOND) { dt = dt.AddMilliseconds(0 - dt.Millisecond); } else if (resolution == Resolution.MILLISECOND) { // don't cut off anything } else { throw new System.ArgumentException("unknown resolution " + resolution); } return(dt.Ticks); }
private void UpdateMonth(int MonthsToAdd) { MonthChangedEventArgs ev = new MonthChangedEventArgs(); ev.OldDisplayStartDate = _DisplayStartDate; this.DisplayStartDate = _DisplayStartDate.AddMonths(MonthsToAdd); ev.NewDisplayStartDate = _DisplayStartDate; if (OnMonthChanged != null) { OnMonthChanged(ev); } }
public DataSet GetOnlineStreamGameInfoList(string year, string month, string day, string hour) { string sqlQuery; if (day == "-1") { System.DateTime dateTime = System.Convert.ToDateTime(year + "-" + month + "-01"); System.DateTime dateTime2 = dateTime.AddMonths(1); sqlQuery = string.Concat(new string[] { "select * from OnLineStreamInfo where InsertDateTime>'", dateTime.ToString(), "' and InsertDateTime<'", dateTime2.ToString(), "' order by InsertDateTime asc" }); } else { if (hour == "-1") { string str = string.Concat(new string[] { year, "-", month, "-", day }); sqlQuery = "select * from OnLineStreamInfo where convert(varchar(10),InsertDateTime,120)='" + str + "' order by InsertDateTime asc"; } else { string text = string.Concat(new string[] { year, "-", month, "-", day }); sqlQuery = string.Concat(new string[] { "select * from OnLineStreamInfo where convert(varchar(10),InsertDateTime,120)='", text, "' and datepart(hh,InsertDateTime)='", hour, "' order by InsertDateTime asc" }); } } return(this.aidePlatformData.GetOnLineStreamInfoList(sqlQuery)); }
public ActionResult DateOfBirthCal(DateTime DateOfBirth) { DateTime dtToday = new System.DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0); DateTime dtBeforeDate = new System.DateTime(DateOfBirth.Year, DateOfBirth.Month, DateOfBirth.Day, 0, 0, 0); int Year = 0; int Month = 0; int Day = 0; dtBeforeDate = dtBeforeDate.AddYears(1); while (dtToday >= dtBeforeDate) { dtBeforeDate = dtBeforeDate.AddYears(1); Year++; } dtBeforeDate = new System.DateTime(DateOfBirth.Year, DateOfBirth.Month, DateOfBirth.Day, 0, 0, 0); dtBeforeDate = dtBeforeDate.AddMonths(1); while (dtToday >= dtBeforeDate) { dtBeforeDate = dtBeforeDate.AddMonths(1); Month++; } dtBeforeDate = new System.DateTime(DateOfBirth.Year, DateOfBirth.Month, DateOfBirth.Day, 0, 0, 0); dtBeforeDate = dtBeforeDate.AddMonths(Month); TimeSpan diffResult = dtToday.Date - dtBeforeDate.Date; int TotalDay = Convert.ToInt32(diffResult.TotalDays); int TotalMonth = Month % 12; obj1.Day = TotalDay.ToString(); obj1.Month = TotalMonth.ToString(); obj1.Years = Year.ToString(); return(Json(obj1)); }