Exemple #1
0
        public void Initialized()
        {
            BaseBs objBs = new BaseBs();

            daysDIff = Convert.ToInt32((DateTime.Now - Convert.ToDateTime("01/01/2016")).TotalDays).ToString();
            DN01     = objBs.HomeKPIBs.GetMonth(1).ToList().Select(x => x.DNLastMonthCount).Sum();
            DN02     = objBs.HomeKPIBs.GetMonth(2).ToList().Select(x => x.DNLastMonthCount).Sum();
            DN03     = objBs.HomeKPIBs.GetMonth(3).ToList().Select(x => x.DNLastMonthCount).Sum();
            DN04     = objBs.HomeKPIBs.GetMonth(4).ToList().Select(x => x.DNLastMonthCount).Sum();
            DN05     = objBs.HomeKPIBs.GetMonth(5).ToList().Select(x => x.DNLastMonthCount).Sum();
            DN06     = objBs.HomeKPIBs.GetMonth(6).ToList().Select(x => x.DNLastMonthCount).Sum();
            DN07     = objBs.HomeKPIBs.GetMonth(7).ToList().Select(x => x.DNLastMonthCount).Sum();
            DN08     = objBs.HomeKPIBs.GetMonth(8).ToList().Select(x => x.DNLastMonthCount).Sum();
            DN09     = objBs.HomeKPIBs.GetMonth(9).ToList().Select(x => x.DNLastMonthCount).Sum();
            DN10     = objBs.HomeKPIBs.GetMonth(10).ToList().Select(x => x.DNLastMonthCount).Sum();
            DN11     = objBs.HomeKPIBs.GetMonth(11).ToList().Select(x => x.DNLastMonthCount).Sum();
            DN12     = objBs.HomeKPIBs.GetMonth(12).ToList().Select(x => x.DNLastMonthCount).Sum();

            SH01 = objBs.HomeKPIBs.GetMonth(1).ToList().Select(x => x.shipmentLastMonthCount).Sum();
            SH02 = objBs.HomeKPIBs.GetMonth(2).ToList().Select(x => x.shipmentLastMonthCount).Sum();
            SH03 = objBs.HomeKPIBs.GetMonth(3).ToList().Select(x => x.shipmentLastMonthCount).Sum();
            SH04 = objBs.HomeKPIBs.GetMonth(4).ToList().Select(x => x.shipmentLastMonthCount).Sum();
            SH05 = objBs.HomeKPIBs.GetMonth(5).ToList().Select(x => x.shipmentLastMonthCount).Sum();
            SH06 = objBs.HomeKPIBs.GetMonth(6).ToList().Select(x => x.shipmentLastMonthCount).Sum();
            SH07 = objBs.HomeKPIBs.GetMonth(7).ToList().Select(x => x.shipmentLastMonthCount).Sum();
            SH08 = objBs.HomeKPIBs.GetMonth(8).ToList().Select(x => x.shipmentLastMonthCount).Sum();
            SH09 = objBs.HomeKPIBs.GetMonth(9).ToList().Select(x => x.shipmentLastMonthCount).Sum();
            SH10 = objBs.HomeKPIBs.GetMonth(10).ToList().Select(x => x.shipmentLastMonthCount).Sum();
            SH11 = objBs.HomeKPIBs.GetMonth(11).ToList().Select(x => x.shipmentLastMonthCount).Sum();
            SH12 = objBs.HomeKPIBs.GetMonth(12).ToList().Select(x => x.shipmentLastMonthCount).Sum();

            Year                   = DateTime.Now.Year.ToString();
            DNLastMonthCount       = objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.DNLastMonthCount).Sum().ToString();
            shipmentLastMonthCount = objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.shipmentLastMonthCount).Sum().ToString();
            DNThisMonthCount       = objBs.HomeKPIBs.GetMonth(DateTime.Now.Month).ToList().Select(x => x.DNLastMonthCount).Sum().ToString();
            shipmentThisMonthCount = objBs.HomeKPIBs.GetMonth(DateTime.Now.Month).ToList().Select(x => x.shipmentLastMonthCount).Sum().ToString();

            AcceptLastMonthCount   = objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.AcceptLastMonthCount).Sum().ToString();
            AcceptLastMonthPending = objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.AcceptPendingCount).Sum().ToString();
            AcceptLastMonthOntime  = objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.AcceptOntimeCount).Sum().ToString();
            AcceptLastMonthDelay   = objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.AcceptDelayCount).Sum().ToString();
            AcceptLastMonthPercent = ((Convert.ToDouble(objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.AcceptOntimeCount).Sum()) / Convert.ToDouble(objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.AcceptLastMonthCount).Sum())) * 100).ToString();

            TenderLastMonthCount   = objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.TenderLastMonthCount).Sum().ToString();
            TenderLastMonthPending = objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.TenderPendingCount).Sum().ToString();
            TenderLastMonthOntime  = objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.TenderOntimeCount).Sum().ToString();
            TenderLastMonthDelay   = objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.TenderDelayCount).Sum().ToString();
            TenderLastMonthPercent = ((Convert.ToDouble(objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.TenderOntimeCount).Sum()) / Convert.ToDouble(objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.TenderLastMonthCount).Sum())) * 100).ToString();

            DeliveryLastMonthCount   = objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.DeliveryLastMonthCount).Sum().ToString();
            DeliveryLastMonthPending = objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.DeliveryPendingCount).Sum().ToString();
            DeliveryLastMonthOntime  = objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.DeliveryOntimeCount).Sum().ToString();
            DeliveryLastMonthDelay   = objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.DeliveryDelayCount).Sum().ToString();
            DeliveryLastMonthPercent = ((Convert.ToDouble(objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.DeliveryOntimeCount).Sum()) / Convert.ToDouble(objBs.HomeKPIBs.GetLastMonth().ToList().Select(x => x.DeliveryLastMonthCount).Sum())) * 100).ToString();
        }
Exemple #2
0
        public JsonResult JsonRole()
        {
            BaseBs objBs = new BaseBs();
            var    q     = from r in objBs.tuserBs.GetAll()
                           select new
            {
                Id   = r.UserId,
                Name = r.UserEmail
            };

            return(Json(q, JsonRequestBehavior.AllowGet));
        }
Exemple #3
0
 public HomeController()
 {
     db = new BaseBs();
 }
Exemple #4
0
 public DropDownList()
 {
     objBs = new BaseBs();
 }
Exemple #5
0
 public BaseController()
 {
     objBs = new BaseBs();
 }
Exemple #6
0
 public PostController()
 {
     db = new BaseBs();
 }