/// <summary>
/// 得到开标项目
/// </summary>
/// <param name="ht"></param>
/// <returns></returns>
private Dictionary<int, IList<ProductReport>> GetOpenProject(Hashtable ht)
{
Dictionary<int, IList<ProductReport>> dict = new Dictionary<int, IList<ProductReport>>();
DOpenProjectDao dpDao = new DOpenProjectDao();
DOpenMedicineDao dmDao = new DOpenMedicineDao();
IList<DOpenProject> list = dpDao.GetProjectByProductQuery(ht);
if (list.Count > 0)
{
var a = (from c in list select c.OID).ToList();
if (a.Count() > 0)
{
long[] projectoids = new long[a.Count()];
for (int i = 0; i < projectoids.Length; i++)
{
projectoids[i] = a[i];
}
ht.Add("projectids", projectoids);
}
IList<DOpenMedicine> listDetail = dmDao.GetProductQuery(ht);
int total = dmDao.GetProductQueryCount(ht);
List<ProductReport> listPR = new List<ProductReport>();
foreach (DOpenMedicine d in listDetail)
{
DOpenProject project = (from p in list where p.OID == d.ProjectOID select p).First();
ProductReport pr = new ProductReport();
pr.ProjectOID = (int)project.OID;
pr.OpenDate = project.OpenDate;
pr.BiddingPrice = 0;
pr.Unit = d.Unit;
pr.ChineseSpecification = d.ChineseSpecification;
pr.City = project.Provice;
pr.CommonName = d.CommonName;
pr.Formulation = d.Formulation;
pr.Material = d.Material;
pr.Package = d.Packaging;
pr.ProductEnterprise = d.ProductEnterprise;
pr.ProjectIntroduction = project.ProjectIntroduction;
pr.TenderPrice = GetTenderPrice(d);
listPR.Add(pr);
}
dict.Add(total, listPR.OrderByDescending(p => p.OpenDate).ToList());
}
return dict;
}
/// <summary>
/// 得到中标项目
/// </summary>
/// <param name="ht"></param>
/// <returns></returns>
private Dictionary<int, IList<ProductReport>> GetBidProject(Hashtable ht)
{
Dictionary<int, IList<ProductReport>> dict = new Dictionary<int, IList<ProductReport>>();
DBiddingProjectDao dpDao = new DBiddingProjectDao();
DBiddingMedicineDao dmDao = new DBiddingMedicineDao();
IList<DBiddingProject> list = dpDao.GetProjectByProductQuery(ht);
if (list.Count > 0)
{
var a = (from c in list select c.OID).ToList();
if (a.Count == 0)
{
IList<ProductReport> ilist = new List<ProductReport>();
dict.Add(0, ilist);
return dict;
}
long[] projectoids = new long[a.Count()];
for (int i = 0; i < projectoids.Length; i++)
{
projectoids[i] = a[i];
}
ht.Add("projectids", projectoids);
IList<DBiddingMedicine> listDetail = dmDao.GetProductQuery(ht);
int total = dmDao.GetProductQueryCount(ht);
List<ProductReport> listPR = new List<ProductReport>();
foreach (DBiddingMedicine d in listDetail)
{
DBiddingProject project = (from p in list where p.OID == d.ProjectOID select p).First();
ProductReport pr = new ProductReport();
pr.ProjectOID = (int)project.OID;
pr.BidDate = project.BidDate;
pr.BiddingPrice = GetBiddingPrice(d);
pr.ChineseSpecification = d.ChineseSpecification;
pr.City = project.Provice;
pr.CommonName = d.CommonName;
pr.Formulation = d.Formulation;
pr.Material = d.Material;
pr.Package = d.Packaging;
pr.Unit = d.Unit;
pr.ConvertCoefficient = d.ConvertCoefficient;
pr.QualityLevel = d.QualityLevel;
pr.ProductEnterprise = d.ProductEnterprise;
pr.ProjectIntroduction = project.ProjectIntroduction;
listPR.Add(pr);
}
dict.Add(total, listPR);
}
return dict;
}
