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));
}
//
// 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));
}
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("投标未开始"));
}
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));
}
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()));
}
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());
}
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));
}
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(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());
}