Пример #1
0
 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);
 }
Пример #2
0
        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;
            }
        }
Пример #3
0
        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);
            }
        }
Пример #4
0
		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>"));
		}
Пример #5
0
        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;
        }
Пример #6
0
 /// <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);
         }
     }
 }
Пример #7
0
		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
            }
Пример #9
0
 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);
        }
Пример #11
0
        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})");
        }
Пример #12
0
 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;
 }
Пример #13
0
        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);
        }
Пример #14
0
 public DataBoundCalendarHeader(DateTime VisibleDate)
 {
     _dataItem = new System.Collections.Generic.Dictionary<string, DateTime>();
     _prevMonth = VisibleDate.AddMonths(-1);
     _currMonth = VisibleDate;
     _nextMonth = VisibleDate.AddMonths(1);
 }
Пример #15
0
        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());

            }
        }
Пример #16
0
        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
            }
Пример #19
0
        /// <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;
        }
Пример #20
0
 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);
 }
Пример #21
0
 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]);
 }
Пример #22
0
        /// <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;
        }
Пример #23
0
 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);
 }
Пример #24
0
 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;
 }
Пример #25
0
        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>");
            //}
        }
Пример #26
0
        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;
Пример #28
0
 void SwitchMonth(int Direction)
 {
     if (Direction < 0)
     {
         date = date.AddMonths(-1);
     }
     else
     {
         date = date.AddMonths(1);
     }
 }
Пример #29
0
 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;
 }
Пример #30
0
        /// <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());
        }
Пример #32
0
		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();
		}
Пример #33
0
        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;
        }
Пример #34
0
        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);
        }
Пример #35
0
        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
            });
        }
Пример #36
0
  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());
  }
Пример #37
0
 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));
 }
Пример #38
0
 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);
 }
Пример #39
0
 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));
 }
Пример #40
0
 public void setFecha(int Mes, int Dia, int Hora)
 {
     Fecha = new System.DateTime();
     Fecha.AddMonths(Mes);
     Fecha.AddDays(Dia);
     Fecha.AddHours(Hora);
 }
Пример #41
0
        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("Книга успешно выдана.");
         }
     }
 }
Пример #43
0
        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);
        }
Пример #44
0
 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");
     }
 }
Пример #45
0
        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);
        }
Пример #46
0
    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);
    }
Пример #47
0
        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);
        }
Пример #48
0
    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;
    }
Пример #49
0
        /// <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");
     }
 }
Пример #51
0
        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);
 }
Пример #53
0
        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();
        }
Пример #54
0
 /// <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);
        }
Пример #56
0
 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);
     }
 }
Пример #57
0
        /// <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);
        }
Пример #58
0
        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);
            }
        }
Пример #59
0
        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));
        }