private void Initialize()
{
List <string> Product_List = ProductID.Split(',').ToList();
Db2HoldReason.Conditions = string.Format("where lot_type='Production' and prodspec_id in ('{2}') and claim_time between '{0}' and '{1}'", StartTime.ToString("yyyy-MM-dd HH:mm:ss"), EndTime.ToString("yyyy-MM-dd HH:mm:ss"), string.Join("','", Product_List));
var Models = Db2HoldReason.GetEntities().EntityList;
//if (Models.Count == 0) return;
//lotCount
int lotCount = Models.Select(s => s.Lot_ID).Distinct().Count();
//所有Hold数据
var HoldModels = Models.Where(w => w.Hold_Type != "" && w.Ope_Category.Substring(w.Ope_Category.Length - 4) == "Hold");
//5码的Hold数据
var HoldModels_5 = HoldModels.Where(w => w.Hold_Reason_Code.Length == 5);
//4码的hold数据
var HoldModels_4 = HoldModels.Where(w => w.Hold_Reason_Code.Length == 4);
List <FRPD> PD_List = new List <FRPD>();
if (HoldModels_4.Count() > 0)
{
PDCatcher.Conditions = string.Format("where pd_id in ('{0}')", string.Join("','", HoldModels_4.Select(s => s.PD_ID)));
PD_List = PDCatcher.GetEntities().EntityList.ToList();
}
var Departments = DepartmentCatcher.GetEntities().EntityList;
foreach (var department in Departments)
{
//对每个部门计算该部门对应的hold list
var list5 = HoldModels_5.Where(w => w.Hold_Reason_Code.Substring(0, 1) == department.Code_ID);
var list4 = HoldModels_4.Where(w => PD_List.Where(p => p.Department == department.Code_ID).DefaultIfEmpty().Select(s => s.PD_ID).Contains(w.PD_ID));
var list = list4.Union(list5);
List <ReqRpt014DepartmentTableEntity> l = new List <ReqRpt014DepartmentTableEntity>();
if (list.Count() == 0) //如果没有元素，则不进行查找
{
DepartmentModels.Add(new ReqRpt014DepartmentTableModel(l)
{
Department = department.Description
});
continue;
}
//如果存在元素，则进行下去
var ReasonList = list.GroupBy(g => g.Hold_Reason_Code).Select(s => new { Hold_Reason_Code = s.Key, Hold_Count = s.Count() });
foreach (var item in ReasonList)
{
ReqRpt014DepartmentTableEntity tableEntity = new ReqRpt014DepartmentTableEntity()
{
HoldCode = item.Hold_Reason_Code, HoldRate = item.Hold_Count / lotCount, LotCount = list.Where(w => w.Hold_Reason_Code == item.Hold_Reason_Code).Select(s => s.Lot_ID).Distinct().Count()
};
l.Add(tableEntity);
}
DepartmentModels.Add(new ReqRpt014DepartmentTableModel(l)
{
Department = department.Description
});
}
//by product部分
foreach (string prod in Product_List)
{
var list = HoldModels.Where(s => s.ProdSpec_ID == prod);
List <ReqRpt014ProductTableEntity> l = new List <ReqRpt014ProductTableEntity>();
if (list is null) //如果没有元素，则不进行查找
{
ProductModels.Add(new ReqRpt014ProductTableModel(l)
{
ProductID = prod
});
continue;
}
//如果存在元素，则进行下去
var ReasonList = list.GroupBy(g => g.Hold_Reason_Code).Select(s => new { Hold_Reason_Code = s.Key, HoldCount = s.Count() });
foreach (var item in ReasonList)
{
ReqRpt014ProductTableEntity tableEntity = new ReqRpt014ProductTableEntity()
{
HoldCode = item.Hold_Reason_Code, HoldRate = item.HoldCount / lotCount, LotCount = list.Where(w => w.Hold_Reason_Code == item.Hold_Reason_Code).Select(s => s.Lot_ID).Distinct().Count()
};
l.Add(tableEntity);
}
ProductModels.Add(new ReqRpt014ProductTableModel(l)
{
ProductID = prod
});
}
}