public string GetCompanyStatById(string cid, string bd, string ed)
{
BidContext bc = new BidContext();
DataTable dt = bc.GetCompanyStatById(cid, bd, ed);
return(JsonHelper.DataTableToJSON(dt));
}
public string GetCompanyBidDetail(string cid)
{
BidContext bc = new BidContext();
DataTable dt = bc.GetCompanyBidDetail(cid);
return(JsonHelper.DataTableToJSON(dt));
}
public string GetBidingApproveDetail(string bid)
{
BidContext bc = new BidContext();
DataTable dt = bc.GetBidingApproveDetail(bid);
return(JsonHelper.DataTableToJSON(dt));
}
public string GetBidApplicationAuditComment(string bid)
{
BidContext bc = new BidContext();
DataTable dt = bc.GetBidApplicationAuditComment(bid);
return(JsonHelper.DataTableToJSON(dt));
}
public ActionResult BidDetail(string pid)
{
ViewBag.SecondMenu = MenuHelper.GetSecondMenu("Bidings", Session["RoleId"].ToString());
if (pid == null)
{
return(View("Login"));
}
ViewBag.pid = pid;
BidContext bc = new BidContext();
DataTable dt = bc.GetBidDetail(pid);
DataRow dr = dt.Rows[0];
ViewBag.Name = dr["Name"].ToString();
ViewBag.Location = dr["Location"].ToString();
ViewBag.Content = dr["Content"].ToString();
ViewBag.Type = dr["ProjType"].ToString();
ViewBag.Publisher = dr["Publisher"].ToString();
ViewBag.BidingNum = dr["BidingNum"].ToString();
ViewBag.ApplyDate = dr["ApplyDate"].ToString();
ViewBag.OpenDate = dr["OpenDate"].ToString();
ViewBag.ProjDescription = dr["ProDescription"].ToString();
ViewBag.Content = dr["Content"].ToString();
//单位反馈
dt = bc.GetBidingCompanys(pid);
var joinC = (from c in dt.AsEnumerable()
where c.Field <int>("CompanyResponse") == 1
select new { id = c["id"].ToString(), name = c["Name"].ToString() }).ToList();
var noJoinC = (from c in dt.AsEnumerable()
where c.Field <int>("CompanyResponse") == 2
select new { id = c["id"].ToString(), name = c["Name"].ToString() }).ToList();
var noResponseC = (from c in dt.AsEnumerable()
where c.Field <int>("CompanyResponse") == 0
select new { id = c["id"].ToString(), name = c["Name"].ToString() }).ToList();
ViewBag.joinNum = joinC.Count;
ViewBag.noJoinNum = noJoinC.Count;
ViewBag.noResponseNum = noResponseC.Count;
StringBuilder cHtml = new StringBuilder();
foreach (var c in joinC)
{
cHtml.Append("<span><a href='/Companys/Details?id=" + c.id + "' target='_blank'>" + c.name + "</a></span>");
}
ViewBag.JoinCompanys = cHtml.ToString();
cHtml.Clear();
foreach (var c in noJoinC)
{
cHtml.Append("<span><a href='/Companys/Details?id=" + c.id + "' target='_blank'>" + c.name + "</a></span>");
}
ViewBag.NoJoinCompanys = cHtml.ToString();
cHtml.Clear();
foreach (var c in noResponseC)
{
cHtml.Append("<span><a href='/Companys/Details?id=" + c.id + "' target='_blank'>" + c.name + "</a></span>");
}
ViewBag.NoResponseCompanys = cHtml.ToString();
return(View());
}
public string GetBidApplicationTransferInfo(string bid)
{
BidContext bc = new BidContext();
DataTable dt = bc.GetBidApplicationTransferInfo(bid);
return(JsonHelper.DataTableToJSON(dt));
}
public void RemoveBidingCompany()
{
string pid = Request["pid"].ToString();
string cid = Request["cid"].ToString();
BidContext bc = new BidContext();
bc.RemoveBidingCompany(pid, cid);
}
public string GetCompanyStat()
{
string cId = Request["cId"].ToString();
BidContext bc = new BidContext();
DataTable dt = bc.GetCompanyBidDetail(cId);
return(JsonHelper.DataTableToJSON(dt));
}
public ActionResult BidingApplicationDetail(string bid)
{
if (bid == null)
{
return(View("/Login"));
}
BidContext bc = new BidContext();
DataTable dt = bc.GetBidDetail(bid);
DataRow dr = dt.Rows[0];
ViewBag.Name = dr["Name"].ToString();
ViewBag.Location = dr["Location"].ToString();
ViewBag.Content = dr["Content"].ToString();
ViewBag.Type = dr["Type"].ToString();
ViewBag.Publisher = dr["Publisher"].ToString();
ViewBag.BidingNum = dr["BidingNum"].ToString();
ViewBag.ApplyDate = dr["ApplyDate"].ToString();
ViewBag.OpenDate = dr["OpenDate"].ToString();
ViewBag.PublishDate = dr["PublishDate"].ToString();
ViewBag.ProjDescription = dr["ProjDescription"].ToString();
dt = bc.GetBidingCompanys(bid);
var joinC = (from c in dt.AsEnumerable()
where c.Field <int>("CompanyResponse") == 1
select new { name = c["CompanyName"].ToString() }).ToList();
var noJoinC = (from c in dt.AsEnumerable()
where c.Field <int>("CompanyResponse") == 2
select new { name = c["CompanyName"].ToString() }).ToList();
var noResponseC = (from c in dt.AsEnumerable()
where c.Field <int>("CompanyResponse") == 0
select new { name = c["CompanyName"].ToString() }).ToList();
ViewBag.joinNum = joinC.Count;
ViewBag.noJoinNum = noJoinC.Count;
ViewBag.noResponseNum = noResponseC.Count;
StringBuilder cHtml = new StringBuilder();
foreach (var c in joinC)
{
cHtml.Append("<span>" + c.name + "</span>");
}
ViewBag.JoinCompanys = cHtml.ToString();
cHtml.Clear();
foreach (var c in noJoinC)
{
cHtml.Append("<span>" + c.name + "</span>");
}
ViewBag.NoJoinCompanys = cHtml.ToString();
cHtml.Clear();
foreach (var c in noResponseC)
{
cHtml.Append("<span>" + c.name + "</span>");
}
ViewBag.NoResponseCompanys = cHtml.ToString();
return(View());
}
public ActionResult GetCompanyBidDetails()
{
string cId = Request["cId"].ToString();
BidContext bc = new BidContext();
bc.GetCompanyBidDetail(cId);
return(View());
}
public string ProcessBidApplication()
{
string operation = Request["operation"].ToString();
string comment = Request["comment"] ?? "";
BidContext bc = new BidContext();
bool suc = bc.ProcessBidApplication(operation, comment);
return(suc.ToString());
}
public string AddBid()
{
var db = new BidContext();
db.Bids.Add(new Bid {
BidTitle = "标题"
});
db.SaveChanges();
return("success");
}
public static BidsModel GetMaxBidOfAuction(string id, BidContext context)
{
List <BidsModel> bids = context.Bids.Where(x => x.AuctionId == id).ToList();
if (bids.Count > 0)
{
BidsModel bm = bids.MaxBy(x => x.Value);
return(bm);
}
else
{
return(null);
}
}
public static string SetWinnerID(Auction auc)
{
BidContext bc = new BidContext();
BidsModel bm = GetMaxBidOfAuction(auc.Id, bc);
if (bm != null)
{
return(bm.AuctionId);
}
else
{
return(null);
}
}
public ActionResult StatisticDetail(string cid, string bd, string ed)
{
ViewBag.cid = cid;
BidContext bc = new BidContext();
DataTable dt = bc.GetCompanyStatById(cid, bd, ed);
if (dt.Rows.Count > 0)
{
ViewBag.Name = dt.Rows[0]["Name"].ToString();
ViewBag.Total = (int.Parse(dt.Rows[0]["JoinBiding"].ToString()) + int.Parse(dt.Rows[0]["NoJoin"].ToString()) + int.Parse(dt.Rows[0]["NoResponse"].ToString())).ToString();
ViewBag.JoinBiding = dt.Rows[0]["JoinBiding"].ToString();
ViewBag.NoJoin = dt.Rows[0]["NoJoin"].ToString();
ViewBag.NoResponse = dt.Rows[0]["NoResponse"].ToString();
ViewBag.NoWin = dt.Rows[0]["NoWin"].ToString();
ViewBag.Win = dt.Rows[0]["Win"].ToString();
ViewBag.TotalAmount = dt.Rows[0]["TotalAmount"].ToString();
}
return(View());
}
public static void RefreshDB()
{
AuctionContext ac = new AuctionContext();
BidContext bc = new BidContext();
foreach (Auction item in ac.Auctions)
{
if (DateTime.Now >= item.DateCreated.AddDays(item.ExpiresIn))
{
item.IsEnded = true;
item.WinnerId = ExtensionMethods.SetWinnerID(item);
}
BidsModel MaxBid = ExtensionMethods.GetMaxBidOfAuction(item.Id, bc, item);
if (MaxBid != null)
{
item.EndingPrice = MaxBid.Value;
}
}
ac.SaveChanges();
}
// GET: MobileInviteBiding
public ActionResult Index()
{
ViewBag.Token = Request["token"].ToString();
ViewBag.CompanyId = Request["cid"].ToString();
ViewBag.ProjId = Request["pid"].ToString();
BidContext bc = new BidContext();
string responnse = bc.GetCompanyResponse(ViewBag.ProjId, ViewBag.CompanyId);
if (responnse == "0")
{
ViewBag.btn = "<li><a href='#' class='bid-redbtn' onclick='response(2)'>不参加</a></li>" +
"<li><a href= '#' class='bid-greenbtn' onclick='response(1)'>参加</a></li>";
}
if (responnse == "2")
{
ViewBag.btn = "<li><a href= 'javascript:;' class='bid-clickafterbtn' style='color:red'>不参加</a></li>";
}
if (responnse == "1")
{
ViewBag.btn = "<li><a href= 'javascript:;' class='bid-clickafterbtn' style='color:red'>已参加</a></li>";
}
return(View());
}
public static bool CheckIfAuctionExist(string id, BidContext bidContext)
{
return(bidContext.Auctions.Any(x => x.Id == id));
}
public string GetBidings(string pageSize, string pageIndex, string pname)
{
BidContext bc = new BidContext();
return(bc.GetAllBids(pageSize, pageIndex, pname, Session["UserId"].ToString()));
}
public Bidding(BidContext context)
{
_context = context;
}
public string GetBidingApproves(string pageSize, string pageIndex, string pname, string status)
{
BidContext bc = new BidContext();
return(bc.GetBidingApproves(Session["UserId"].ToString(), pageSize, pageIndex, pname, status));
}
public string GetCompaniesStatistic(string pageSize, string pageIndex, string pname, string bdate, string edate)
{
BidContext bc = new BidContext();
return(bc.GetCompanyStats(pageSize, pageIndex, pname, bdate, edate));
}
public string GetBidApplications(string pageSize, string pageIndex)
{
BidContext bc = new BidContext();
return(bc.GetBidApplications(pageSize, pageIndex));
}
//
// GET: /Test/
public ActionResult Index()
{
var db = new BidContext();
return(View());
}
public ActionResult BidingApproveDetail(string pid)
{
ViewBag.ProjId = pid;
ViewBag.UserId = Session["UserId"].ToString();
ViewBag.RoleId = Session["RoleId"].ToString();
ViewBag.status = Request["status"].ToString();
if (pid == null)
{
return(View("/Login"));
}
ViewBag.pid = pid;
BidContext bc = new BidContext();
DataTable dt = bc.GetBidDetail(pid);
DataRow dr = dt.Rows[0];
ViewBag.Name = dr["Name"].ToString();
ViewBag.Location = dr["Location"].ToString();
ViewBag.Content = dr["Content"].ToString();
ViewBag.Type = dr["ProjType"].ToString();
ViewBag.Publisher = dr["Publisher"].ToString();
ViewBag.BidingNum = dr["BidingNum"].ToString();
ViewBag.ApplyDate = dr["ApplyDate"].ToString();
ViewBag.OpenDate = dr["OpenDate"].ToString();
ViewBag.PublishDate = dr["PublishDate"].ToString();
ViewBag.ProjDescription = dr["ProDescription"].ToString();
ViewBag.Content = dr["Content"].ToString();
//单位反馈
dt = bc.GetBidingCompanys(pid);
var joinC = (from c in dt.AsEnumerable()
where c.Field <int>("CompanyResponse") == 1
select new { id = c["id"].ToString(), name = c["Name"].ToString() }).ToList();
var noJoinC = (from c in dt.AsEnumerable()
where c.Field <int>("CompanyResponse") == 2
select new { id = c["id"].ToString(), name = c["Name"].ToString() }).ToList();
var noResponseC = (from c in dt.AsEnumerable()
where c.Field <int>("CompanyResponse") == 0
select new { id = c["id"].ToString(), name = c["Name"].ToString() }).ToList();
//单位反馈-单位显示框
StringBuilder comHtml = new StringBuilder();
foreach (var c in joinC)
{
comHtml.Append("<span><a href='/Companys/Details?id=" + c.id + "' target='_blank' >" + c.name + "</a></span>");
}
ViewBag.JoinCompanys = comHtml.ToString();
comHtml.Clear();
foreach (var c in noJoinC)
{
comHtml.Append("<span><a href='/Companys/Details?id=" + c.id + "' target='_blank'>" + c.name + "</a></span>");
}
ViewBag.NoJoinCompanys = comHtml.ToString();
comHtml.Clear();
foreach (var c in noResponseC)
{
comHtml.Append("<span><a href='/Companys/Details?id=" + c.id + "' target='_blank'>" + c.name + "</a></span>");
}
ViewBag.NoResponseCompanys = comHtml.ToString();
StringBuilder cHtml = new StringBuilder();
if (Session["RoleId"].ToString() == "2")
{
if (Request["status"].ToString() == "1")
{
string removebtn = "";
removebtn = "<i><img src='/img/icon-del.png' onclick=\"removeCompany('{0}')\"></i>";
ViewBag.InviteCompanyBtn = @"<a href='javascript:;' class='js-cancle-meet' id='invitebtn' onclick='inviteCompanys()' title='邀标'><i class='meet-icon icon-cancel icon-yb'>邀标</i></a>";
ViewBag.addCompanysbtn = "<tr class='form-tr detail-user-con tr-border ifortd'>" +
"<td class='form-lable label2'>" +
"<span style ='color:#008cd6' > 参与单位：</span>" +
"</td>" +
"<td>" +
"<div class='detail-user'>" +
//"<button type='submit' style=''>" +
"<a href='#' onclick=\"ShowDiv()\" class='add-qy' style='width: 80px;color: #fff'>" +
"<img src='/img/icon-add3.png' style='vertical-align: middle' alt=''>添加企业" +
"</a>" +
//"</button>" +
"</div>" +
"</td >" +
"</tr>";
//参与单位-单位显示框
dt = bc.GetBidingCompanys(pid);
cHtml.Append("<tr class='form-tr detail-user-con invitejoincom'><td colspan='2'><div class='detail-user-list1' style='overflow: auto;'><div class='meet-user-span' id='inviteCompany'>");
for (int i = 0; i < dt.Rows.Count; i++)
{
var cid = "company" + dt.Rows[i]["id"].ToString();
cHtml.Append("<span id='" + cid + "'><a href='/Companys/Details?id=" + dt.Rows[i]["id"].ToString() + "' target='_blank'>" + dt.Rows[i]["Name"].ToString() + "</a>" + string.Format(removebtn, cid) + "</span>");
}
cHtml.Append(@"</div></div></td></tr>");
ViewBag.inviteJoinCompanys = cHtml.ToString();
}
else
{
ViewBag.InviteCompanyBtn = "";
ViewBag.addCompanysbtn = " <tr class='form-tr detail-user-con tr-border ifortd'>" +
"<td class='form-lable label2'>" +
"<span style ='color:#008cd6' > 参与单位：</span>" +
"</td>" +
"<td>" +
"<div class='detail-user'>" +
"</div>" +
"</td >" +
"</tr>";
//参与单位-单位显示框
dt = bc.GetBidingCompanys(pid);
cHtml.Append("<tr class='form-tr detail-user-con invitejoincom'><td colspan='2'><div class='detail-user-list1' style='overflow: auto;'><div class='meet-user-span' id='inviteCompany'>");
for (int i = 0; i < dt.Rows.Count; i++)
{
var cid = "company" + dt.Rows[i]["id"].ToString();
cHtml.Append("<span id='" + cid + "'>" + dt.Rows[i]["Name"].ToString() + "</span>");
}
cHtml.Append(@"</div></div></td></tr>");
ViewBag.inviteJoinCompanys = cHtml.ToString();
}
ViewBag.comjion = @"<tr class='form-tr detail-user-con tr-border ifortd'>" +
"<td class='form-lable label2'>" +
"<span style = 'color: #008cd6'> 单位反馈：</span>" +
"</td>" +
"<td>" +
"<div class='detail-user'>" +
"<a class='meet-btn medium-btn active'>参加<span>" + joinC.Count + "</span></a>" +
"<a class='meet-btn medium-btn'>不参加<span>" + noJoinC.Count + "</span></a>" +
"<a class='meet-btn medium-btn'>未响应<span>" + noResponseC.Count + "</span></a>" +
"</div>" +
"</td>" +
"</tr>";
ViewBag.ResponseCompanysHtml = @"<tr class='form-tr detail-user-con'>" +
"<td colspan ='2' >" +
"<div class='detail-user-list detail-user-list6' style='overflow: auto;'>" +
"<div class='meet-user-span' style='display: block;'>" + ViewBag.JoinCompanys + "</div>" +
"<div class='meet-user-span'>" + ViewBag.NoJoinCompanys + "</div>" +
"<div class='meet-user-span'>" + ViewBag.NoResponseCompanys + "</div>" +
"</div>" +
"</td>" +
"</tr>";
}
else if (Session["RoleId"].ToString() == "1" || Session["RoleId"].ToString() == "3")
{
//参与单位-单位显示框
dt = bc.GetBidingCompanys(pid);
cHtml.Append("<tr class='form-tr detail-user-con invitejoincom'><td colspan='2'><div class='detail-user-list1' style='overflow: auto;'><div class='meet-user-span' id='inviteCompany'>");
for (int i = 0; i < dt.Rows.Count; i++)
{
var cid = "company" + dt.Rows[i]["id"].ToString();
cHtml.Append("<span id='" + cid + "'>" + dt.Rows[i]["Name"].ToString() + "</span>");
}
cHtml.Append(@"</div></div></td></tr>");
ViewBag.inviteJoinCompanys = cHtml.ToString();
ViewBag.InviteCompanyBtn = "";
ViewBag.addCompanysbtn = "<tr class='form-tr detail-user-con tr-border ifortd'>" +
"<td class='form-lable label2'>" +
"<span style ='color:#008cd6' > 参与单位：</span>" +
"</td>" +
"<td>" +
"<div class='detail-user'>" +
"</div>" +
"</td >" +
"</tr>";
ViewBag.comjion = @"<tr class='form-tr detail-user-con tr-border ifortd'>" +
"<td class='form-lable label2'>" +
"<span style = 'color: #008cd6'> 单位反馈：</span>" +
"</td>" +
"<td>" +
"<div class='detail-user'>" +
"<a class='meet-btn medium-btn active'>参加<span>" + joinC.Count + "</span></a>" +
"<a class='meet-btn medium-btn'>不参加<span>" + noJoinC.Count + "</span></a>" +
"<a class='meet-btn medium-btn'>未响应<span>" + noResponseC.Count + "</span></a>" +
"</div>" +
"</td>" +
"</tr>";
ViewBag.ResponseCompanysHtml = @"<tr class='form-tr detail-user-con'>" +
"<td colspan ='2' >" +
"<div class='detail-user-list detail-user-list6' style='overflow: auto;'>" +
"<div class='meet-user-span' style='display: block;'>" + ViewBag.JoinCompanys + "</div>" +
"<div class='meet-user-span'>" + ViewBag.NoJoinCompanys + "</div>" +
"<div class='meet-user-span'>" + ViewBag.NoResponseCompanys + "</div>" +
"</div>" +
"</td>" +
"</tr>";
}
else
{
ViewBag.inviteJoinCompanys = "";
ViewBag.InviteCompanyBtn = "";
ViewBag.addCompanysbtn = "";
ViewBag.comjion = "";
ViewBag.ResponseCompanysHtml = "";
}
//判断审核通过按钮显示与隐藏
//if (Session["RoleId"].ToString() == "2")
//{
// if (joinC.Count < 5){
// ViewBag.approvebtn = "";
// }else
// {
// ViewBag.approvebtn = @"<div class='deal-apply-btn deal-apply-btn2'>
// <a class='meet-btn big-btn blue-btn js-deal green-btn blue-btn2' onclick='approveApplication()'>审核通过</a>
// </div>";
// }
//}else
//{
ViewBag.approvebtn = @"<div class='deal-apply-btn deal-apply-btn2'>
<a class='meet-btn big-btn blue-btn js-deal green-btn blue-btn2' onclick='approveApplication()'>审核通过</a>
</div>";
//}
return(View());
}
// GET: MobileBid
//[VerifyMobileLoginFilter]
public ActionResult Index(string pid)
{
if (!string.IsNullOrEmpty(Request["lcode"]))
{
string code = Request["lcode"].ToString();
ViewBag.UserId = Request["userid"].ToString();
SqlParameter[] paras = new SqlParameter[2];
paras[0] = new SqlParameter("@uid", ViewBag.UserId);
paras[1] = new SqlParameter("@code", code);
string s = DBHelper.ExecuteSP("CheckLoginStatus", paras).Tables[0].Rows[0][0].ToString();
if (s == "1")
{
Session["UserId"] = Request["userid"].ToString();
}
else
{
Response.Redirect("/MobileLogin");
}
}
else if (Session["UserId"] != null)
{
ViewBag.UserId = Session["UserId"].ToString();
}
else
{
Response.Redirect("/MobileLogin");
}
if (pid == null)
{
return(View("\\MobileLogin"));
}
ViewBag.pid = pid;
BidContext bc = new BidContext();
DataTable dt = bc.GetBidDetail(pid);
DataRow dr = dt.Rows[0];
ViewBag.Name = dr["Name"].ToString();
ViewBag.Location = dr["Location"].ToString();
ViewBag.Content = dr["Content"].ToString();
ViewBag.Type = dr["ProjType"].ToString();
ViewBag.Publisher = dr["Publisher"].ToString();
ViewBag.BidingNum = dr["BidingNum"].ToString();
ViewBag.ApplyDate = dr["ApplyDate"].ToString();
ViewBag.OpenDate = dr["OpenDate"].ToString();
ViewBag.PublishDate = dr["PublishDate"].ToString();
ViewBag.ProjDescription = dr["ProDescription"].ToString();
ViewBag.Content = dr["Content"].ToString();
if (Session["RoleId"].ToString() == "2" && Request["status"].ToString() == "1")
{
ViewBag.InviteCompanyBtn = @"<a href='javascript:;' class='js-cancle-meet' id='invitebtn' onclick='inviteCompanys()' title='邀标'><i class='meet-icon icon-cancel icon-yb'>邀标</i></a>";
ViewBag.addCompanysbtn = "<button type='submit' class='add-qy' style='width: 80px;'>" +
"<a href='#' onclick=\"ShowDiv('MyDiv','fade')\" style='color: #fff'>" +
"<img src='/img/icon-add3.png' style='vertical-align: middle' alt=''>添加企业" +
"</a></button>";
}
else
{
ViewBag.InviteCompanyBtn = "";
ViewBag.addCompanysbtn = "";
}
//单位反馈
dt = bc.GetBidingCompanys(pid);
var joinC = (from c in dt.AsEnumerable()
where c.Field <int>("CompanyResponse") == 1
select new { id = c["id"].ToString(), name = c["Name"].ToString() }).ToList();
//单位反馈-单位显示框
StringBuilder comHtml = new StringBuilder();
foreach (var c in joinC)
{
comHtml.Append("<li id='" + c.id + "'>" + c.name + "</li>");
}
ViewBag.JoinCompanys = comHtml.ToString();
return(View());
}
