public void ChangeCompleteTagToOne(Expression <Func <BCB_CHECKFLOW, bool> > func)
{
BCB_CHECKFLOW bCB_CHECKFLOW = dal.GetBy(func);
if (bCB_CHECKFLOW.COMPLETETAG != "1")
{
bCB_CHECKFLOW.COMPLETETAG = "1";
}
}
public int UpdateIfNotCompleted(System.Linq.Expressions.Expression <Func <BCB_CHECKFLOW, bool> > func)
{
BCB_CHECKFLOW bCB_CHECKFLOW = db.BCB_CHECKFLOW.Where(func).FirstOrDefault();
if (bCB_CHECKFLOW.COMPLETETAG != "1")
{
bCB_CHECKFLOW.COMPLETETAG = "1";
}
return(db.SaveChanges());
}
public BCB_CHECKFLOW GetBy(System.Linq.Expressions.Expression <Func <BCB_CHECKFLOW, bool> > func)
{
BCB_CHECKFLOW bCB_CHECKFLOW = db.BCB_CHECKFLOW.Where(func).FirstOrDefault();
return(bCB_CHECKFLOW);
}
/// <summary>
/// 批量更新
/// </summary>
/// <param name="listVW_DIME_RESULT"></param>
/// <returns></returns>
public static Dictionary <string, List <string> > batchUpdate(List <VW_DIME_RESULT> listVW_DIME_RESULT, List <BCD_ITEMQUALDESC> listALLBCD_ITEMQUALDESC, List <BCD_ITEM> listALLBCD_ITEM)
{
BCB_CHECKSUBBLL bCB_CHECKSUBBLL = new BCB_CHECKSUBBLL();
BCB_CHECKFLOWBLL bCB_CHECKFLOWBLL = new BCB_CHECKFLOWBLL();
BCD_GROUPBLL bCD_GROUPBLL = new BCD_GROUPBLL();
BCD_ITEMBLL bCD_ITEMBLL = new BCD_ITEMBLL();
BCB_GROUPCONCLUSIONBLL bCB_GROUPCONCLUSIONBLL = new BCB_GROUPCONCLUSIONBLL();
var queryByCheckCode = (from p in listVW_DIME_RESULT group p by p.CHECKCODE into g select g).ToList();
Dictionary <string, List <string> > dicResult = new Dictionary <string, List <string> >();//key为小组GUID，value为体检编号
foreach (var item in queryByCheckCode)
{
BCB_CHECKMAIN bCB_CHECKMAIN = new BCB_CHECKMAINBLL().GetBy(a => a.CHECKCODE == item.Key);
List <string> listGROUPGUID = new List <string>();
int completeTag = 0;
if (bCB_CHECKMAIN != null)
{
int.TryParse(bCB_CHECKMAIN.COMPLETETAG, out completeTag);
}
if (bCB_CHECKMAIN == null || completeTag > 1)
{
Console.WriteLine(string.Format("未查询到编号为:{0}的人员信息", item.Key));
continue;
}
List <BCB_CHECKFLOW> listBCB_CHECKFLOW = bCB_CHECKFLOWBLL.GetListBy(u => u.MAINGUID == bCB_CHECKMAIN.GUID);
if (listBCB_CHECKFLOW.Count > 0)
{
for (int i = 0; i < listBCB_CHECKFLOW.Count; i++)
{
string groupGUID = listBCB_CHECKFLOW[i].GROUPGUID;
}
}
foreach (VW_DIME_RESULT vw_dime_result in item.ToList())
{
int itemId = 0;
int.TryParse(vw_dime_result.ITEMEID, out itemId);
if (itemId != 0)
{
BCD_ITEM bCD_ITEM = listALLBCD_ITEM.Where(u => u.ID == itemId).FirstOrDefault();
//= new BCD_ITEMBLL().GetBy(a => a.ID == itemId);
//if (bCD_ITEM!=null&&listRevertBCB_CHECKFLOW.Where(u => u.GROUPGUID == bCD_ITEM.GROUPGUID).Count() > 0)
//{
// continue;
//}
BCB_CHECKSUB bCB_CHECKSUB = bCB_CHECKSUBBLL.GetBy(a => a.ITEMGUID == bCD_ITEM.GUID && a.MAINGUID == bCB_CHECKMAIN.GUID);
if (bCB_CHECKSUB == null)
{
continue;
}
BCB_CHECKFLOW bCB_CHECKFLOW = bCB_CHECKFLOWBLL.GetBy(a => a.MAINGUID == bCB_CHECKMAIN.GUID && a.GROUPGUID == bCB_CHECKSUB.GROUPGUID);
if (bCB_CHECKFLOW == null)
{
Console.WriteLine(string.Format("未查询到主表GUID为{0},小组GUID为{1}的流程表信息", bCB_CHECKMAIN.GUID, bCB_CHECKSUB.GROUPGUID));
continue;
}
if (bCB_CHECKFLOW.COMPLETETAG == "1" && vw_dime_result.cp_uncheckflag == 0)
{
continue;
}
if (bCB_CHECKSUB != null)
{
if (!listGROUPGUID.Contains(bCB_CHECKFLOW.GROUPGUID))
{
listGROUPGUID.Add(bCB_CHECKFLOW.GROUPGUID);
}
if (!dicResult.ContainsKey(bCB_CHECKFLOW.GROUPGUID))
{
dicResult.Add(bCB_CHECKFLOW.GROUPGUID, new List <string> {
item.Key
});
}
else if (!dicResult[bCB_CHECKFLOW.GROUPGUID].Contains(item.Key))
{
dicResult[bCB_CHECKFLOW.GROUPGUID].Add(item.Key);
}
bCB_CHECKSUB.RESULT = vw_dime_result.RESULT;
double result = 0;
if (double.TryParse(bCB_CHECKSUB.RESULT, out result))
{
//定量
bCB_CHECKSUB.PASSTAG = (result >= bCB_CHECKSUB.REFVALMIN && result <= bCB_CHECKSUB.REFVALMAX) ? "1" : "0";
}
else
{
//定性
List <BCD_ITEMQUALDESC> listBCD_ITEMQUALDESC = new BCD_ITEMQUALDESCBLL().GetListBy(u => u.ITEMGUID == bCB_CHECKSUB.ITEMGUID && u.PASS == "1");
bCB_CHECKSUB.PASSTAG = "0";
foreach (var description in listBCD_ITEMQUALDESC)
{
if (description.DESCRIPTION == bCB_CHECKSUB.RESULT)
{
bCB_CHECKSUB.PASSTAG = "1";
break;
}
}
}
bCB_CHECKSUB.DOCTORNAME = vw_dime_result.DOCTORNAME;
bCB_CHECKSUB.DATECHECK = vw_dime_result.DATECHECK;
bCB_CHECKSUB.RECHECKDOCTORNAME = vw_dime_result.RECHECKDOCTORNAME;
bCB_CHECKSUB.RECHECKDATE = vw_dime_result.RECHECKDATE;
}
}
}
bCB_CHECKSUBBLL.SaveChanges();
#region 更新流程表完成标记
//更新流程表完成标记
List <string> updatedGroupGUID = new List <string>();
foreach (var groupGUID in listGROUPGUID.Distinct())
{
BCD_GROUP bCD_GROUP = bCD_GROUPBLL.GetBy(u => u.GUID == groupGUID);
if (bCD_GROUP == null)
{
Console.WriteLine(string.Format("未查询到GUID为{0}的小组", groupGUID));
continue;
}
if (bCD_GROUP.ISPRECONDITION == "1")
{
continue;
}
List <BCB_CHECKSUB> listBCB_CHECKSUB = bCB_CHECKSUBBLL.GetListBy(u => u.MAINGUID == bCB_CHECKMAIN.GUID && u.GROUPGUID == groupGUID);
bool allCompleted = true;
foreach (var checksub in listBCB_CHECKSUB)
{
if (string.IsNullOrEmpty(checksub.RESULT))
{
allCompleted = false;
break;
}
}
bool isPreconditionComplete = true;
if (bCD_GROUP != null)
{
if (bCD_GROUP.NEEDPRECONDITION == "1")
{
BCD_GROUP preCondition = bCD_GROUPBLL.GetBy(u => u.GUID == bCD_GROUP.PRECONDITION);
if (preCondition == null)
{
Console.WriteLine(string.Format("未查询到{0}对应的前置小组", bCD_GROUP.GROUPNAME));
}
else
{
BCB_CHECKFLOW bCB_CHECKFLOW = new BCB_CHECKFLOWBLL().GetBy(u => u.GROUPGUID == preCondition.GUID && u.MAINGUID == bCB_CHECKMAIN.GUID);
if (bCB_CHECKFLOW != null)
{
if (bCB_CHECKFLOW.COMPLETETAG != "1")
{
isPreconditionComplete = false;
}
}
}
}
}
if (allCompleted && isPreconditionComplete)
{
updatedGroupGUID.Add(groupGUID);
}
}
new BCB_CHECKFLOWBLL().UpdateByMainGUIDANDGroupGUID(bCB_CHECKMAIN.GUID, updatedGroupGUID.Distinct().ToList());
#endregion
//更新小组结论
foreach (var groupGUID in updatedGroupGUID.Distinct().ToList())
{
List <BCBCHECKSUB> listBCBCHECKSUB = new List <BCBCHECKSUB>();
List <BCB_CHECKSUB> list = bCB_CHECKSUBBLL.GetListBy(u => u.GROUPGUID == groupGUID && u.MAINGUID == bCB_CHECKMAIN.GUID);
foreach (var BCB_CHECKSUB in list)
{
BCBCHECKSUB temp = new BCBCHECKSUB();
temp.BCB_CHECKSUB = BCB_CHECKSUB;
temp.BCDITEM = new BCDITEM
{
BCD_ITEM = bCD_ITEMBLL.GetBy(u => u.GUID == BCB_CHECKSUB.ITEMGUID)
};
listBCBCHECKSUB.Add(temp);
}
if (list.Count > 0)
{
string result = ResultGenerator.GenerateResult(listBCBCHECKSUB, listALLBCD_ITEMQUALDESC);
BCB_GROUPCONCLUSION bCB_GROUPCONCLUSION = bCB_GROUPCONCLUSIONBLL.GetBy(u => u.MAINGUID == bCB_CHECKMAIN.GUID && u.GROUPGUID == groupGUID);
if (bCB_GROUPCONCLUSION == null)
{
bCB_GROUPCONCLUSION = new BCB_GROUPCONCLUSION();
bCB_GROUPCONCLUSION.GUID = Guid.NewGuid().ToString();
bCB_GROUPCONCLUSION.MAINGUID = bCB_CHECKMAIN.GUID;
bCB_GROUPCONCLUSION.GROUPGUID = groupGUID;
bCB_GROUPCONCLUSION.CONSLUSION = result;
bCB_GROUPCONCLUSION.TIMECREATE = DateTime.Now;
bCB_GROUPCONCLUSIONBLL.Add(bCB_GROUPCONCLUSION);
}
else
{
bCB_GROUPCONCLUSION.MAINGUID = bCB_CHECKMAIN.GUID;
bCB_GROUPCONCLUSION.CONSLUSION = result;
bCB_GROUPCONCLUSIONBLL.SaveChanges();
}
}
}
List <BCB_GROUPCONCLUSION> listBCB_GROUPCONCLUSION = bCB_GROUPCONCLUSIONBLL.GetListBy(u => u.MAINGUID == bCB_CHECKMAIN.GUID);
StringBuilder sbResult = new StringBuilder(1024);
foreach (var bCB_GROUPCONCLUSION in listBCB_GROUPCONCLUSION)
{
if (!string.IsNullOrEmpty(bCB_GROUPCONCLUSION.CONSLUSION) && bCB_GROUPCONCLUSION.CONSLUSION != "未见明显异常")
{
sbResult.AppendFormat("[{0}]{1}", bCD_GROUPBLL.GetBy(u => u.GUID == bCB_GROUPCONCLUSION.GROUPGUID).GROUPNAME, bCB_GROUPCONCLUSION.CONSLUSION);
sbResult.Append(Environment.NewLine);
}
}
if (string.IsNullOrEmpty(sbResult.ToString()))
{
sbResult.Append("所检项目未见明显异常");
}
else
{
sbResult.Append("其余所检项目未见明显异常");
}
//更新主表完成标记
bool isAllPassed = bCB_CHECKSUBBLL.IsAllPassed(u => u.MAINGUID == bCB_CHECKMAIN.GUID);
int j = new BCB_CHECKMAINBLL().UpdateAfterUpload(bCB_CHECKMAIN.GUID, isAllPassed, sbResult.ToString().Trim());
//int j = new BCB_CHECKMAINBLL().UpdateIfAllCompleted(bCB_CHECKMAIN.GUID, isAllPassed, sbResult.ToString().Trim(), targetConnString);
}
return(dicResult);
}