예제 #1
0
 public ActionResult Edit(Bemp_GongGao bemp_gonggao)
 {
     if (ModelState.IsValid)
     {
         db.Entry(bemp_gonggao).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.UserId    = new SelectList(db.BEmplyees, "EmpID", "NumberEmp", bemp_gonggao.UserId);
     ViewBag.GongGaoId = new SelectList(db.Tender_GongGaos, "TaskID", "SN", bemp_gonggao.GongGaoId);
     return(View(bemp_gonggao));
 }
예제 #2
0
        //
        // GET: /Bemp_GongGao/Edit/5

        public ActionResult Edit(int id = 0)
        {
            Bemp_GongGao bemp_gonggao = db.Bemp_GongGaos.Find(id);

            if (bemp_gonggao == null)
            {
                return(HttpNotFound());
            }
            ViewBag.UserId    = new SelectList(db.BEmplyees, "EmpID", "NumberEmp", bemp_gonggao.UserId);
            ViewBag.GongGaoId = new SelectList(db.Tender_GongGaos, "TaskID", "SN", bemp_gonggao.GongGaoId);
            return(View(bemp_gonggao));
        }
예제 #3
0
        public ActionResult Create(Tender_ModelCustomer2 tender_modelcustomer21)
        {
            if (ModelState.IsValid)
            {
                int ttid = db.Bemp_GongGaos.Single(n => n.BGid == tender_modelcustomer21.EmpGonggaoID).GongGaoId;
                isSmall = isSmallByid(ttid);

                Tender_ModelManage2   modelM = db.Tender_ModelManage2.Single(m => m.Tid == ttid);
                Tender_ModelCustomer2 tender_modelcustomer2 = db.Tender_ModelCustomer2.Single(m => m.EmpGonggaoID == tender_modelcustomer21.EmpGonggaoID);

                if (TimeSpan.Parse(modelM.BeginTime) <= System.DateTime.Now.TimeOfDay && TimeSpan.Parse(modelM.EndTime) >= System.DateTime.Now.TimeOfDay)
                {
                    if (isSmall)
                    {
                        if (tender_modelcustomer2.PriceLost != 0 && tender_modelcustomer2.PriceLost <= tender_modelcustomer21.PriceLost)
                        {
                            return(Content("价格必须小于上次报价~!"));
                        }
                    }
                    else
                    {
                        if (tender_modelcustomer2.PriceLost != 0 && tender_modelcustomer2.PriceLost >= tender_modelcustomer21.PriceLost)
                        {
                            return(Content("价格必须大于上次报价~!"));
                        }
                    }

                    tender_modelcustomer2.PriceLost             = tender_modelcustomer21.PriceLost;
                    tender_modelcustomer2.bemp_Gonggao.PayType  = tender_modelcustomer21.bemp_Gonggao.PayType;
                    tender_modelcustomer2.bemp_Gonggao.HandDate = tender_modelcustomer21.bemp_Gonggao.HandDate;
                    Bemp_GongGao bemp = tender_modelcustomer2.bemp_Gonggao;

                    db.Entry(tender_modelcustomer2).State  = EntityState.Modified;
                    db.Configuration.ValidateOnSaveEnabled = false;
                    db.SaveChanges();
                    db.Configuration.ValidateOnSaveEnabled = true;
                    return(Content("投标完成!"));
                }
                else if (TimeSpan.Parse(modelM.BeginTime) > System.DateTime.Now.TimeOfDay)
                {
                    return(Content("投标未开始"));
                }
                else
                {
                    return(Content("投标已结束"));
                }
            }


            return(Content("投标未开始"));
        }
예제 #4
0
        public ActionResult LoadData(int id = 0)
        {
            Tender_CustomerData data    = new Tender_CustomerData();
            Bemp_GongGao        empGong = db.Bemp_GongGaos.Include(m => m.Tender_GongGaos).Single(m => m.BGid == id);

            isSmall         = isSmallByid(empGong.GongGaoId);
            ViewBag.IsSmall = isSmall;

            Tender_ModelManage2 modelM = db.Tender_ModelManage2.Single(m => m.Tid == empGong.GongGaoId);

            data.StrServ       = "";
            data.PriceShangLow = 0;
            if ((TimeSpan.Parse(modelM.BeginTime) <= System.DateTime.Now.TimeOfDay && System.DateTime.Now.TimeOfDay <= TimeSpan.Parse(modelM.EndTime)))
            {
                data.EndTime = Convert.ToDateTime((TimeSpan.Parse(modelM.EndTime) - System.DateTime.Now.TimeOfDay).ToString()).ToString("HH:mm:ss");
                try
                {
                    if (db.Tender_ModelCustomer2.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceLost > 0).Count() > 0)
                    {
                        if (isSmall)
                        {
                            data.PriceShangLow = db.Tender_ModelCustomer2.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceLost > 0).Min(m => m.PriceLost);
                        }
                        else
                        {
                            data.PriceShangLow = db.Tender_ModelCustomer2.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceLost > 0).Max(m => m.PriceLost);
                        }

                        if (db.Tender_ModelCustomer2.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceLost == data.PriceShangLow).Count() > 1)
                        {
                            data.StrServ = "请注意,此刻有多家供应商报出了相同的最低价。";
                        }
                    }
                }catch (Exception ex)
                { }



                data.TimeXia = modelM.BeginTime;
            }

            return(Json(data, JsonRequestBehavior.AllowGet));
        }
예제 #5
0
        public ActionResult Index(int id = 0)
        {
            var tender_mcust = db.Tender_ModelCustomer2.Include(t => t.bemp_Gonggao).Where(mc => mc.bemp_Gonggao.GongGaoId == id);

            isSmall = isSmallByid(id);
            //第一次加载 生成客户初始数据
            if (tender_mcust.Count() <= 0)
            {
                List <Bemp_GongGao> list = db.Bemp_GongGaos.Include(b => b.bemplyees).Where(m => m.GongGaoId == id && m.IsPassShen != null && m.IsPassShen == true).ToList();
                if (list.Count > 0)
                {
                    lock (this)
                    {
                        foreach (Bemp_GongGao bemp in list)
                        {
                            Tender_ModelCustomer2 cust = new Tender_ModelCustomer2();
                            cust.UserName     = bemp.bemplyees.NumberEmp;
                            cust.LinkMan      = bemp.bemplyees.LinkMan;
                            cust.LinkType     = bemp.bemplyees.LinkType;
                            cust.EmpGonggaoID = bemp.BGid;
                            cust.PriceLost    = 0;

                            db.Tender_ModelCustomer2.Add(cust);
                            //li.Add(cust);
                            db.Configuration.ValidateOnSaveEnabled = false;
                            db.SaveChanges();
                            db.Configuration.ValidateOnSaveEnabled = true;
                        }
                    }
                }
            }

            //找每轮最低价
            tender_mcust   = db.Tender_ModelCustomer2.Include(t => t.bemp_Gonggao).Where(mc => mc.bemp_Gonggao.GongGaoId == id);
            ViewBag.PriceD = 0;

            tender_mcust = db.Tender_ModelCustomer2.Include(t => t.bemp_Gonggao).Where(mc => mc.bemp_Gonggao.GongGaoId == id && mc.PriceLost > 0);
            if (tender_mcust.Count() > 0)
            {
                if (isSmall)
                {
                    ViewBag.PriceD = tender_mcust.Min(m => m.PriceLost);
                }
                else
                {
                    ViewBag.PriceD = tender_mcust.Max(m => m.PriceLost);
                }
            }

            if (isSmall)
            {
                foreach (Tender_ModelCustomer2 custVar in tender_mcust.ToList <Tender_ModelCustomer2>())
                {
                    Bemp_GongGao bgong = db.Bemp_GongGaos.Find(custVar.EmpGonggaoID);
                    if (bgong.LostPrice == null || (custVar.PriceLost != 0 && bgong.LostPrice > custVar.PriceLost))
                    {
                        bgong.LostPrice       = custVar.PriceLost;
                        db.Entry(bgong).State = EntityState.Modified;

                        db.SaveChanges();
                    }
                }
            }
            else
            {
                foreach (Tender_ModelCustomer2 custVar in tender_mcust.ToList <Tender_ModelCustomer2>())
                {
                    Bemp_GongGao bgong = db.Bemp_GongGaos.Find(custVar.EmpGonggaoID);
                    if (bgong.LostPrice == null || (custVar.PriceLost != 0 && bgong.LostPrice < custVar.PriceLost))
                    {
                        bgong.LostPrice       = custVar.PriceLost;
                        db.Entry(bgong).State = EntityState.Modified;

                        db.SaveChanges();
                    }
                }
            }
            ViewBag.IsSmall = isSmall;
            tender_mcust    = db.Tender_ModelCustomer2.Include(t => t.bemp_Gonggao).Where(mc => mc.bemp_Gonggao.GongGaoId == id);
            return(View(tender_mcust.ToList()));
        }
예제 #6
0
        public ActionResult Create(int id = 0)
        {
            ViewBag.EmpGonggaoID = new SelectList(db.Bemp_GongGaos, "BGid", "BGid");

            if (id != 0)
            {
                Bemp_GongGao empGong = null;
                try
                {
                    empGong         = db.Bemp_GongGaos.Include(m => m.Tender_GongGaos).Single(m => m.BGid == id && m.IsPassShen != null && m.IsPassShen == true);
                    isSmall         = isSmallByid(empGong.GongGaoId);
                    ViewBag.IsSmall = isSmall;
                }catch (Exception ex)
                {
                    return(Content("不能访问,可能审核未通过"));
                }


                Tender_ModelManage2 modelM = null;
                if (db.Tender_ModelManage2.Where(m => m.Tid == empGong.GongGaoId).Count() > 0)
                {
                    modelM = db.Tender_ModelManage2.Single(m => m.Tid == empGong.GongGaoId);
                }


                if (modelM == null)
                {
                    return(Content("投标未开始"));
                }



                if (modelM.DateToday.Date < System.DateTime.Now.Date)
                {
                    return(Content("投标已结束~!"));
                }
                if (modelM.DateToday.Date > System.DateTime.Now.Date)
                {
                    return(Content("投标未开始~!"));
                }

                TimeSpan tsEnd;
                if (TimeSpan.TryParse(modelM.EndTime, out tsEnd))
                {
                    if (tsEnd <= System.DateTime.Now.TimeOfDay)
                    {
                        return(Content("投标已结束"));
                    }
                }
                else
                {
                    return(Content("投标未开始"));
                }

                TimeSpan tsBegin;
                if (TimeSpan.TryParse(modelM.BeginTime, out tsBegin))
                {
                }
                else
                {
                    return(Content("投标未开始"));
                }
                if (empGong != null)
                {
                    Tender_ModelCustomer2 cust;
                    cust = db.Tender_ModelCustomer2.Include(m => m.bemp_Gonggao.Tender_GongGaos).Single(m => m.EmpGonggaoID == empGong.BGid);
                    if (cust == null)
                    {
                        return(Content("请联系管理"));
                    }

                    cust.PriceUnit       = modelM.PriceUnit;
                    db.Entry(cust).State = EntityState.Modified;
                    db.Configuration.ValidateOnSaveEnabled = false;
                    db.SaveChanges();
                    db.Configuration.ValidateOnSaveEnabled = true;

                    ViewBag.TimeXia = modelM.BeginTime;
                    if (tsBegin <= System.DateTime.Now.TimeOfDay && System.DateTime.Now.TimeOfDay <= tsEnd)
                    {
                        ViewBag.Jieshu = Convert.ToDateTime((tsEnd - System.DateTime.Now.TimeOfDay).ToString()).ToString("HH:mm:ss");

                        if (db.Tender_ModelCustomer2.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceLost > 0).Count() > 0)
                        {
                            if (isSmall)
                            {
                                ViewBag.ShangDi = db.Tender_ModelCustomer2.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceLost > 0).Min(m => m.PriceLost);
                            }
                            else
                            {
                                ViewBag.ShangDi = db.Tender_ModelCustomer2.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceLost > 0).Max(m => m.PriceLost);
                            }
                        }
                    }

                    return(View(cust));
                }
            }
            return(View());
        }
예제 #7
0
        public ActionResult LoadData(int id = 0)
        {
            Tender_CustomerData data = new Tender_CustomerData();

            data.StrServ       = "";
            data.PriceShang    = 0;
            data.PriceShangLow = 0;
            Bemp_GongGao empGong = db.Bemp_GongGaos.Include(m => m.Tender_GongGaos).Single(m => m.BGid == id);

            isSmall         = isSmallByid(empGong.GongGaoId);
            ViewBag.IsSmall = isSmall;
            Tender_ModelManage1 modelM = db.Tender_ModelManage1.Single(m => m.Tid == empGong.GongGaoId);

            if (empGong != null)
            {
                Tender_ModelCustomer1 cust;
                cust = db.Tender_ModelCustomer1.Include(m => m.bemp_Gonggao.Tender_GongGaos).Single(m => m.EmpGonggaoID == empGong.BGid);


                if ((!string.IsNullOrEmpty(modelM.BeginTime1)) && (!string.IsNullOrEmpty(modelM.EndTime1)) && TimeSpan.Parse(modelM.EndTime1) >= System.DateTime.Now.TimeOfDay)
                {
                    data.Lunci   = "一 未开始";
                    data.TimeXia = modelM.BeginTime1;
                    if ((TimeSpan.Parse(modelM.BeginTime1) <= System.DateTime.Now.TimeOfDay && System.DateTime.Now.TimeOfDay <= TimeSpan.Parse(modelM.EndTime1)))
                    {
                        //第一轮进行中
                        data.Lunci         = "一";
                        data.EndTime       = Convert.ToDateTime((TimeSpan.Parse(modelM.EndTime1) - System.DateTime.Now.TimeOfDay).ToString()).ToString("HH:mm:ss");
                        data.PriceShang    = 0;
                        data.PriceShangLow = 0;
                        data.TimeXia       = modelM.BeginTime2;
                    }
                    //第一轮未开始
                }
                else if ((!string.IsNullOrEmpty(modelM.BeginTime2)) && (!string.IsNullOrEmpty(modelM.EndTime2)) && (TimeSpan.Parse(modelM.EndTime1) <= System.DateTime.Now.TimeOfDay && System.DateTime.Now.TimeOfDay <= TimeSpan.Parse(modelM.EndTime2)))
                {
                    data.Lunci      = "二 未开始";
                    data.PriceShang = cust.PriceOne;
                    if (db.Tender_ModelCustomer1.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceOne > 0).Count() > 0)
                    {
                        if (isSmall)
                        {
                            data.PriceShangLow = db.Tender_ModelCustomer1.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceOne > 0).Min(m => m.PriceOne);
                        }
                        else
                        {
                            data.PriceShangLow = db.Tender_ModelCustomer1.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceOne > 0).Max(m => m.PriceOne);
                        }

                        if (db.Tender_ModelCustomer1.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceOne == data.PriceShangLow).Count() > 1)
                        {
                            data.StrServ = "请注意,此刻有多家供应商报出了相同的最低价。";
                        }
                    }
                    else
                    {
                        data.PriceShangLow = 0;
                    }
                    data.TimeXia = modelM.BeginTime2;
                    if ((TimeSpan.Parse(modelM.BeginTime2) <= System.DateTime.Now.TimeOfDay && System.DateTime.Now.TimeOfDay <= TimeSpan.Parse(modelM.EndTime2)))
                    {
                        //第二轮进行中
                        data.Lunci   = "二";
                        data.EndTime = Convert.ToDateTime((TimeSpan.Parse(modelM.EndTime2) - System.DateTime.Now.TimeOfDay).ToString()).ToString("HH:mm:ss");
                        data.TimeXia = modelM.BeginTime3;
                    }
                    //第二轮未开始
                }
                else if ((!string.IsNullOrEmpty(modelM.BeginTime3)) && (!string.IsNullOrEmpty(modelM.EndTime3)) && (TimeSpan.Parse(modelM.EndTime2) <= System.DateTime.Now.TimeOfDay && System.DateTime.Now.TimeOfDay <= TimeSpan.Parse(modelM.EndTime3)))
                {
                    data.Lunci      = "三 未开始";
                    data.PriceShang = cust.PriceTwo;
                    data.TimeXia    = modelM.BeginTime3;
                    if (db.Tender_ModelCustomer1.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceTwo > 0).Count() > 0)
                    {
                        if (isSmall)
                        {
                            data.PriceShangLow = db.Tender_ModelCustomer1.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceTwo > 0).Min(m => m.PriceTwo);
                        }
                        else
                        {
                            data.PriceShangLow = db.Tender_ModelCustomer1.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceTwo > 0).Max(m => m.PriceTwo);
                        }

                        if (db.Tender_ModelCustomer1.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceTwo == data.PriceShangLow).Count() > 1)
                        {
                            data.StrServ = "请注意,此刻有多家供应商报出了相同的最低价。";
                        }
                    }
                    else
                    {
                        data.PriceShangLow = 0;
                    }

                    if ((TimeSpan.Parse(modelM.BeginTime3) <= System.DateTime.Now.TimeOfDay && System.DateTime.Now.TimeOfDay <= TimeSpan.Parse(modelM.EndTime3)))
                    {
                        //第三轮进行中
                        data.Lunci   = "三";
                        data.EndTime = Convert.ToDateTime((TimeSpan.Parse(modelM.EndTime3) - System.DateTime.Now.TimeOfDay).ToString()).ToString("HH:mm:ss");
                        data.TimeXia = "";
                    }
                }
                //Tender_ModelCustomer1 cust;
                //var qv = db.Tender_ModelCustomer1.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.EmpGonggaoID == empGong.BGid);
                //if (qv.Count() > 0)
                //{
                //    cust = db.Tender_ModelCustomer1.Include(m => m.bemp_Gonggao.Tender_GongGaos).Single(m => m.EmpGonggaoID == empGong.BGid);
                //    if (cust.PriceThree != null && cust.PriceThree > 0)
                //    {
                //        return Content("此项目已投标~!");
                //    }
                //    else if (cust.PriceTwo != null && cust.PriceTwo > 0)
                //    {
                //        data.Lunci = "三";
                //        data.TimeXia=modeM.BeginTime3;
                //        TimeSpan ts;
                //        if(TimeSpan.TryParse(modeM.BeginTime3,out ts))
                //        {
                //            if (ts <= System.DateTime.Now.TimeOfDay.Add(new TimeSpan(0,0,2)))
                //            {
                //                data.EndTime = (TimeSpan.Parse(modeM.EndTime3) - System.DateTime.Now.TimeOfDay).ToString("C");
                //            }
                //        }
                //        data.PriceShang = cust.PriceTwo;
                //        data.PriceShangLow = db.Tender_ModelCustomer1.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId).Max(m => m.PriceTwo);

                //    }
                //    else if (cust.PriceOne != null && cust.PriceOne > 0)
                //    {
                //        ViewBag.Lunci = "二";
                //        ViewBag.Jieshu = System.DateTime.Now.TimeOfDay.ToString();
                //        ViewBag.Shanglun = cust.PriceTwo;
                //        ViewBag.ShangDi = "";
                //    }
                //    else
                //    {

                //        ViewBag.Lunci = "一";
                //        ViewBag.Jieshu = System.DateTime.Now.TimeOfDay.ToString();
                //        ViewBag.Shanglun = cust.PriceTwo;
                //        ViewBag.ShangDi = "";
                //    }
                //}
                //else
                //{

                //    if (modeM != null)
                //    {
                //        try
                //        {


                //            data.Lunci = "一";
                //            data.TimeXia = modeM.BeginTime3;
                //            TimeSpan ts;
                //            if (TimeSpan.TryParse(modeM.BeginTime3, out ts))
                //            {
                //                if (ts <= System.DateTime.Now.TimeOfDay.Add(new TimeSpan(0, 0, 2)))
                //                {
                //                    data.EndTime = (TimeSpan.Parse(modeM.EndTime3) - System.DateTime.Now.TimeOfDay).ToString("C");
                //                }
                //            }
                //        }
                //        catch (Exception ex)
                //        { return Content(ex.Message + " " + modeM.BeginTime1 + " " + System.DateTime.Now.TimeOfDay + " " + System.DateTime.Now.ToShortTimeString()); }

                //        cust = new Tender_ModelCustomer1();
                //        cust.bemp_Gonggao = empGong;
                //    }
                //    else
                //    {

                //        data.Lunci = "一";
                //    }

                //}
            }

            return(Json(data, JsonRequestBehavior.AllowGet));
        }
예제 #8
0
        public ActionResult Index(int id = 0)
        {
            isSmall = isSmallByid(id);
            var tender_mcust = db.Tender_ModelCustomer1.Include(t => t.bemp_Gonggao).Where(mc => mc.bemp_Gonggao.GongGaoId == id);

            //第一次加载 生成客户初始数据
            if (tender_mcust.Count() <= 0)
            {
                List <Bemp_GongGao> list = db.Bemp_GongGaos.Include(b => b.bemplyees).Where(m => m.GongGaoId == id && m.IsPassShen != null && m.IsPassShen == true).ToList();
                if (list.Count > 0)
                {
                    //List<Tender_ModelCustomer1> li = new List<Tender_ModelCustomer1>();
                    lock (this)
                    {
                        foreach (Bemp_GongGao bemp in list)
                        {
                            Tender_ModelCustomer1 cust = new Tender_ModelCustomer1();
                            cust.UserName     = bemp.bemplyees.NumberEmp;
                            cust.LinkMan      = bemp.bemplyees.LinkMan;
                            cust.LinkType     = bemp.bemplyees.LinkType;
                            cust.EmpGonggaoID = bemp.BGid;
                            cust.PriceOne     = 0;
                            cust.PriceTwo     = 0;
                            cust.PriceThree   = 0;
                            if (db.Tender_ModelCustomer1.Where(m => m.EmpGonggaoID == bemp.BGid).Count() <= 0)
                            {
                                db.Tender_ModelCustomer1.Add(cust);
                            }
                            //li.Add(cust);
                            db.Configuration.ValidateOnSaveEnabled = false;
                            db.SaveChanges();
                            db.Configuration.ValidateOnSaveEnabled = true;
                        }
                    }
                }
            }


            //找每轮最低价
            //tender_mcust = db.Tender_ModelCustomer1.Include(t => t.bemp_Gonggao).Where(mc => mc.bemp_Gonggao.GongGaoId == id);

            ViewBag.PriceD1 = ViewBag.PriceD2 = ViewBag.PriceD3 = 0;

            tender_mcust = db.Tender_ModelCustomer1.Include(t => t.bemp_Gonggao).Where(mc => mc.bemp_Gonggao.GongGaoId == id && mc.PriceOne > 0);
            if (tender_mcust.Count() > 0)
            {
                if (isSmall)
                {
                    ViewBag.PriceD1 = tender_mcust.Min(m => m.PriceOne);
                }
                else
                {
                    ViewBag.PriceD1 = tender_mcust.Max(m => m.PriceOne);
                }
            }


            tender_mcust = db.Tender_ModelCustomer1.Include(t => t.bemp_Gonggao).Where(mc => mc.bemp_Gonggao.GongGaoId == id && mc.PriceTwo > 0);
            if (tender_mcust.Count() > 0)
            {
                if (isSmall)
                {
                    ViewBag.PriceD2 = tender_mcust.Min(m => m.PriceTwo);
                }
                else
                {
                    ViewBag.PriceD2 = tender_mcust.Max(m => m.PriceTwo);
                }
            }


            tender_mcust = db.Tender_ModelCustomer1.Include(t => t.bemp_Gonggao).Where(mc => mc.bemp_Gonggao.GongGaoId == id && mc.PriceThree > 0);
            if (tender_mcust.Count() > 0)
            {
                if (isSmall)
                {
                    ViewBag.PriceD3 = tender_mcust.Min(m => m.PriceThree);
                }
                else
                {
                    ViewBag.PriceD3 = tender_mcust.Max(m => m.PriceThree);
                }
            }



            //重新取数
            tender_mcust = db.Tender_ModelCustomer1.Include(t => t.bemp_Gonggao).Where(mc => mc.bemp_Gonggao.GongGaoId == id);

            if (isSmall)
            {
                //循环找最低价
                foreach (Tender_ModelCustomer1 custVar in tender_mcust.ToList <Tender_ModelCustomer1>())
                {
                    Bemp_GongGao bgong = db.Bemp_GongGaos.Find(custVar.EmpGonggaoID);
                    var          v1    = custVar.PriceOne != 0 ? custVar.PriceOne : 9999999999;
                    var          v2    = custVar.PriceTwo != 0 ? custVar.PriceTwo : 9999999999;
                    var          v3    = custVar.PriceThree != 0 ? custVar.PriceThree : 9999999999;
                    bgong.LostPrice = (v1 < v2 ? v1 : v2) < v3 ? (v1 < v2 ? v1 : v2) : v3;
                    if (bgong.LostPrice != 9999999999)
                    {
                        db.Entry(bgong).State = EntityState.Modified;
                        db.Configuration.ValidateOnSaveEnabled = false;
                        db.SaveChanges();
                        db.Configuration.ValidateOnSaveEnabled = true;
                    }
                    else
                    {
                        bgong.LostPrice = 0;
                    }
                }
            }
            else
            {
                //循环找最高价
                foreach (Tender_ModelCustomer1 custVar in tender_mcust.ToList <Tender_ModelCustomer1>())
                {
                    Bemp_GongGao bgong = db.Bemp_GongGaos.Find(custVar.EmpGonggaoID);
                    var          v1    = custVar.PriceOne;
                    var          v2    = custVar.PriceTwo;
                    var          v3    = custVar.PriceThree;
                    bgong.LostPrice = (v1 > v2 ? v1 : v2) > v3 ? (v1 > v2 ? v1 : v2) : v3;
                    if (bgong.LostPrice != 0)
                    {
                        db.Entry(bgong).State = EntityState.Modified;
                        db.Configuration.ValidateOnSaveEnabled = false;
                        db.SaveChanges();
                        db.Configuration.ValidateOnSaveEnabled = true;
                    }
                    else
                    {
                        bgong.LostPrice = 0;
                    }
                }
            }

            ViewBag.IsSmall = isSmall;

            return(View(tender_mcust));
        }
예제 #9
0
        public ActionResult Create(int id = 0)
        {
            ViewBag.EmpGonggaoID = new SelectList(db.Bemp_GongGaos, "BGid", "BGid");
            if (id != 0)
            {
                Bemp_GongGao empGong = null;
                try
                {
                    empGong = db.Bemp_GongGaos.Include(m => m.Tender_GongGaos).Single(m => m.BGid == id && m.IsPassShen != null && m.IsPassShen == true);

                    isSmall         = isSmallByid(empGong.GongGaoId);
                    ViewBag.IsSmall = isSmall;
                }catch (Exception ex)
                {
                    return(Content("不能投标,您可能审核未通过。"));
                }

                Tender_ModelManage1 modelM = db.Tender_ModelManage1.Single(m => m.Tid == empGong.GongGaoId);

                if (modelM == null)
                {
                    return(Content("投标未开始"));
                }

                TimeSpan tsEnd3;
                if (TimeSpan.TryParse(modelM.EndTime3, out tsEnd3))
                {
                    if (tsEnd3 <= System.DateTime.Now.TimeOfDay)
                    {
                        return(Content("投标已结束"));
                    }
                }

                if (modelM.DateToday.Date < System.DateTime.Now.Date)
                {
                    return(Content("投标已结束~!"));
                }
                if (modelM.DateToday.Date > System.DateTime.Now.Date)
                {
                    return(Content("投标未开始~!"));
                }
                if (empGong != null)
                {
                    Tender_ModelCustomer1 cust;
                    cust = db.Tender_ModelCustomer1.Include(m => m.bemp_Gonggao.Tender_GongGaos).Single(m => m.EmpGonggaoID == empGong.BGid);
                    if (cust == null)
                    {
                        return(Content("请联系管理"));
                        //cust=new Tender_ModelCustomer1();
                        //cust.EmpGonggaoID=id;
                        //cust.PriceUnit = modelM.PriceUnit;
                        //cust.LinkMan=empGong
                        //db.Tender_ModelCustomer1.Add(cust);

                        //db.SaveChanges();
                    }
                    cust.PriceUnit       = modelM.PriceUnit;
                    db.Entry(cust).State = EntityState.Modified;
                    db.Configuration.ValidateOnSaveEnabled = false;
                    db.SaveChanges();
                    db.Configuration.ValidateOnSaveEnabled = true;

                    if ((!string.IsNullOrEmpty(modelM.BeginTime1)) && (!string.IsNullOrEmpty(modelM.EndTime1)) && TimeSpan.Parse(modelM.EndTime1) >= System.DateTime.Now.TimeOfDay)
                    {
                        ViewBag.Lunci   = "一 未开始";
                        ViewBag.TimeXia = modelM.BeginTime1;
                        if ((TimeSpan.Parse(modelM.BeginTime1) <= System.DateTime.Now.TimeOfDay && System.DateTime.Now.TimeOfDay <= TimeSpan.Parse(modelM.EndTime1)))
                        {
                            //第一轮进行中
                            ViewBag.Lunci    = "一";
                            ViewBag.Jieshu   = Convert.ToDateTime((TimeSpan.Parse(modelM.EndTime1) - System.DateTime.Now.TimeOfDay).ToString()).ToString("HH:mm:ss");
                            ViewBag.Shanglun = "";
                            ViewBag.ShangDi  = "";
                            ViewBag.TimeXia  = modelM.BeginTime2;
                        }
                        //第一轮未开始
                        ViewBag.TimeXia = modelM.BeginTime1;
                    }
                    else if ((!string.IsNullOrEmpty(modelM.BeginTime2)) && (!string.IsNullOrEmpty(modelM.EndTime2)) && (TimeSpan.Parse(modelM.EndTime1) <= System.DateTime.Now.TimeOfDay && System.DateTime.Now.TimeOfDay <= TimeSpan.Parse(modelM.EndTime2)))
                    {
                        ViewBag.Lunci    = "二 未开始";
                        ViewBag.Shanglun = cust.PriceOne;
                        if (db.Tender_ModelCustomer1.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceOne > 0).Count() > 0)
                        {
                            if (isSmall)
                            {
                                ViewBag.ShangDi = db.Tender_ModelCustomer1.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceOne > 0).Min(m => m.PriceOne);
                            }
                            else
                            {
                                ViewBag.ShangDi = db.Tender_ModelCustomer1.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceOne > 0).Max(m => m.PriceOne);
                            }
                        }
                        else
                        {
                            ViewBag.ShangDi = "";
                        }
                        ViewBag.TimeXia = modelM.BeginTime2;
                        if ((TimeSpan.Parse(modelM.BeginTime2) <= System.DateTime.Now.TimeOfDay && System.DateTime.Now.TimeOfDay <= TimeSpan.Parse(modelM.EndTime2)))
                        {
                            //第二轮进行中
                            ViewBag.Lunci  = "二";
                            ViewBag.Jieshu = Convert.ToDateTime((TimeSpan.Parse(modelM.EndTime2) - System.DateTime.Now.TimeOfDay).ToString()).ToString("HH:mm:ss");

                            ViewBag.TimeXia = modelM.BeginTime3;
                        }
                        //第二轮未开始
                    }
                    else if ((!string.IsNullOrEmpty(modelM.BeginTime3)) && (!string.IsNullOrEmpty(modelM.EndTime3)) && (TimeSpan.Parse(modelM.EndTime2) <= System.DateTime.Now.TimeOfDay && System.DateTime.Now.TimeOfDay <= TimeSpan.Parse(modelM.EndTime3)))
                    {
                        ViewBag.Lunci    = "三 未开始";
                        ViewBag.Shanglun = cust.PriceTwo;
                        ViewBag.TimeXia  = modelM.BeginTime3;
                        if (db.Tender_ModelCustomer1.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceTwo > 0).Count() > 0)
                        {
                            if (isSmall)
                            {
                                ViewBag.ShangDi = db.Tender_ModelCustomer1.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceTwo > 0).Min(m => m.PriceTwo);
                            }
                            else
                            {
                                ViewBag.ShangDi = db.Tender_ModelCustomer1.Include(m => m.bemp_Gonggao.Tender_GongGaos).Where(m => m.bemp_Gonggao.GongGaoId == empGong.GongGaoId && m.PriceTwo > 0).Max(m => m.PriceTwo);
                            }
                        }
                        else
                        {
                            ViewBag.ShangDi = "";
                        }

                        if ((TimeSpan.Parse(modelM.BeginTime3) <= System.DateTime.Now.TimeOfDay && System.DateTime.Now.TimeOfDay <= TimeSpan.Parse(modelM.EndTime3)))
                        {
                            //第三轮进行中
                            ViewBag.Lunci   = "三";
                            ViewBag.Jieshu  = Convert.ToDateTime((TimeSpan.Parse(modelM.EndTime3) - System.DateTime.Now.TimeOfDay).ToString()).ToString("HH:mm:ss");
                            ViewBag.TimeXia = "";
                        }
                    }
                    else
                    {
                        return(Content("投标已结束。。。"));
                    }
                    //if (qv.Count()>0)
                    //{
                    //    cust = qv.ElementAt(0);


                    //    if (cust.PriceThree != null && cust.PriceThree > 0)
                    //    {
                    //        return Content("此项目已投标~!");
                    //    }
                    //    else if (cust.PriceTwo != null && cust.PriceTwo > 0)
                    //    {
                    //        ViewBag.Lunci = "三";
                    //        ViewBag.Jieshu = System.DateTime.Now.TimeOfDay.ToString();
                    //        ViewBag.Shanglun = cust.PriceTwo;
                    //        ViewBag.ShangDi = "";
                    //    }
                    //    else if (cust.PriceOne != null && cust.PriceOne > 0)
                    //    {
                    //        ViewBag.Lunci = "二";
                    //        ViewBag.Jieshu = System.DateTime.Now.TimeOfDay.ToString();
                    //        ViewBag.Shanglun = cust.PriceTwo;
                    //        ViewBag.ShangDi = "";
                    //    }
                    //    else
                    //    {

                    //        ViewBag.Lunci = "一";
                    //        ViewBag.Jieshu = System.DateTime.Now.TimeOfDay.ToString();
                    //        ViewBag.Shanglun = cust.PriceTwo;
                    //        ViewBag.ShangDi = "";
                    //    }
                    //}
                    //else
                    //{

                    //    if (modeM != null)
                    //    {
                    //        try
                    //        {
                    //            TimeSpan tsp = TimeSpan.Parse("10:35:00");
                    //            ViewBag.Lunci = "一";
                    //            ViewBag.Jieshu = tsp;
                    //            ViewBag.Shanglun = "";
                    //            ViewBag.ShangDi = "";
                    //        }
                    //        catch(Exception ex)
                    //        { return Content(ex.Message +" "+ modeM.BeginTime1+" "+System.DateTime.Now.TimeOfDay+" "+System.DateTime.Now.ToShortTimeString()); }

                    //        cust = new Tender_ModelCustomer1();
                    //        cust.bemp_Gonggao = empGong;
                    //        cust.EmpGonggaoID = empGong.BGid;
                    //    }
                    //    else
                    //    {

                    //        ViewBag.Lunci = "未开始";
                    //        cust = new Tender_ModelCustomer1();
                    //        cust.bemp_Gonggao = empGong;
                    //    }

                    //}

                    return(View(cust));
                }
            }

            return(View());
        }