public ActionResult Edit(Tender_ModelCustomer1 tender_modelcustomer1) { if (ModelState.IsValid) { db.Entry(tender_modelcustomer1).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); } ViewBag.EmpGonggaoID = new SelectList(db.Bemp_GongGaos, "BGid", "BGid", tender_modelcustomer1.EmpGonggaoID); return View(tender_modelcustomer1); }
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); }
public ActionResult Create(Tender_ModelCustomer1 tender_modelcustomer1,string LunciLab="") { if (ModelState.IsValid) { int ttid = db.Bemp_GongGaos.Single(n => n.BGid == tender_modelcustomer1.EmpGonggaoID).GongGaoId; //**2014/4/1** isSmall = isSmallByid(ttid); //********** end ********** Tender_ModelManage1 modelM = db.Tender_ModelManage1.Single(m => m.Tid == ttid); Tender_ModelCustomer1 tender_modelcustomer2 = db.Tender_ModelCustomer1.Single(m => m.EmpGonggaoID == tender_modelcustomer1.EmpGonggaoID); switch (LunciLab) { case "": break; case "一": if (TimeSpan.Parse(modelM.BeginTime1) <= System.DateTime.Now.TimeOfDay&&System.DateTime.Now.TimeOfDay <= TimeSpan.Parse(modelM.EndTime1)) { if (tender_modelcustomer2.PriceOne > 0) { return Content("每轮只能报价一次!"); } //Bemp_GongGao bempG1 = db.Bemp_GongGaos.Single(n => n.BGid == tender_modelcustomer1.EmpGonggaoID); tender_modelcustomer2.bemp_Gonggao.PayType = tender_modelcustomer1.bemp_Gonggao.PayType; tender_modelcustomer2.bemp_Gonggao.HandDate = tender_modelcustomer1.bemp_Gonggao.HandDate; tender_modelcustomer2.PriceOne = tender_modelcustomer1.PriceThree; db.Entry(tender_modelcustomer2).State = EntityState.Modified; db.Configuration.ValidateOnSaveEnabled = false; db.SaveChanges(); db.Configuration.ValidateOnSaveEnabled =true; return Content("投标完成!"); } break; case "二": if (TimeSpan.Parse(modelM.BeginTime2) <= System.DateTime.Now.TimeOfDay && System.DateTime.Now.TimeOfDay <= TimeSpan.Parse(modelM.EndTime2)) { if (tender_modelcustomer2.PriceTwo > 0) { //ceshi 要删掉 //tender_modelcustomer2.bemp_Gonggao.PayType = tender_modelcustomer1.bemp_Gonggao.PayType; //db.Entry(tender_modelcustomer2).State = EntityState.Modified; //db.Configuration.ValidateOnSaveEnabled = false; //db.SaveChanges(); //db.Configuration.ValidateOnSaveEnabled = true; return Content("每轮只能报价一次!"); } if(isSmall) { if (tender_modelcustomer2.PriceOne != 0 && tender_modelcustomer1.PriceThree >= tender_modelcustomer2.PriceOne) { return Content("投标价格必须小于上一轮"); } }else { if (tender_modelcustomer2.PriceOne != 0 && tender_modelcustomer1.PriceThree <= tender_modelcustomer2.PriceOne) { return Content("投标价格必须大于上一轮"); } } tender_modelcustomer2.PriceTwo = tender_modelcustomer1.PriceThree; tender_modelcustomer2.bemp_Gonggao.PayType = tender_modelcustomer1.bemp_Gonggao.PayType; tender_modelcustomer2.bemp_Gonggao.HandDate = tender_modelcustomer1.bemp_Gonggao.HandDate; db.Entry(tender_modelcustomer2).State = EntityState.Modified; db.Configuration.ValidateOnSaveEnabled = false; db.SaveChanges(); db.Configuration.ValidateOnSaveEnabled = true; return Content("投标完成!"); } break; case "三": if (TimeSpan.Parse(modelM.BeginTime3) <= System.DateTime.Now.TimeOfDay && System.DateTime.Now.TimeOfDay <= TimeSpan.Parse(modelM.EndTime3)) { if (tender_modelcustomer2.PriceThree > 0) { return Content("每轮只能报价一次!"); } if(isSmall) { if ((tender_modelcustomer2.PriceTwo != 0 && tender_modelcustomer1.PriceThree >= tender_modelcustomer2.PriceTwo) || (tender_modelcustomer2.PriceOne != 0 && tender_modelcustomer1.PriceThree >= tender_modelcustomer2.PriceOne)) { return Content("投标价格必须小于上一轮"); } }else { if ((tender_modelcustomer2.PriceTwo != 0 && tender_modelcustomer1.PriceThree <= tender_modelcustomer2.PriceTwo) || (tender_modelcustomer2.PriceOne != 0 && tender_modelcustomer1.PriceThree <= tender_modelcustomer2.PriceOne)) { return Content("投标价格必须大于上一轮"); } } tender_modelcustomer2.PriceThree = tender_modelcustomer1.PriceThree; tender_modelcustomer2.bemp_Gonggao.PayType = tender_modelcustomer1.bemp_Gonggao.PayType; tender_modelcustomer2.bemp_Gonggao.HandDate = tender_modelcustomer1.bemp_Gonggao.HandDate; db.Entry(tender_modelcustomer2).State = EntityState.Modified; db.Configuration.ValidateOnSaveEnabled = false; db.SaveChanges(); db.Configuration.ValidateOnSaveEnabled = true; return Content("投标完成!"); } else { return Content("投标未开始"); } //db.Entry(tender_modelcustomer1).State = EntityState.Modified; break; } return Content("投标未开始~!"); //db.SaveChanges(); } ViewBag.EmpGonggaoID = new SelectList(db.Bemp_GongGaos, "BGid", "BGid", tender_modelcustomer1.EmpGonggaoID); return View(tender_modelcustomer1); }