/// <summary>
/// 添加一个病历
/// </summary>
/// <param name="templateInfo"></param>
/// <returns></returns>
/// <summary>
public bool AddHisDetail(string strHisGid, string strTitle, string strDesc, string strDoctorGid, List <String> lstPic)
{
DataBaseHelper.BeginTransaction();
try
{
TMedicalHisDetail detail = new TMedicalHisDetail();
detail.DetailGid = Guid.NewGuid().ToString();
detail.HisID = strHisGid;
detail.DetailTitle = strTitle;
detail.DetailDescribe = strDesc;
detail.CreateUser = strDoctorGid;
List <TMedicalHisDetailPic> lstDetailPic = new List <TMedicalHisDetailPic>();
foreach (string strImgUrl in lstPic)
{
TMedicalHisDetailPic detailPic = new TMedicalHisDetailPic();
detailPic.DetailGid = detail.DetailGid;
detailPic.PicUrl = strImgUrl;
lstDetailPic.Add(detailPic);
}
Save(lstDetailPic);
Save <TMedicalHisDetail>(detail);
DataBaseHelper.CommitTransaction();
return(true);
}
catch
{
//事务回滚
DataBaseHelper.RollbackTransaction();
return(false);
}
}
/// <summary>
/// 删除病历
/// </summary>
/// <param name="templateId"></param>
/// <returns></returns>
public Boolean DeleteDetailByGId(String strDetailGid)
{
//开启事务
DataBaseHelper.BeginTransaction();
try
{
//查询模版动作信息
String strSql1 = "select * from T_Medical_HisDetail where Detail_Gid=@Detail_Gid and status = 1";
ParamMap param = ParamMap.newMap();
param.setParameter("Detail_Gid", strDetailGid);
List <TMedicalHisDetail> ttem = DataBaseHelper.FindBySql <TMedicalHisDetail>(strSql1, param);
strSql1 = "select * from T_Medical_HisDetailPic where Detail_Gid=@Detail_Gid and status =1";
ParamMap paramDetail = ParamMap.newMap();
paramDetail.setParameter("Detail_Gid", strDetailGid);
List <TMedicalHisDetailPic> lstDetailPic = DataBaseHelper.FindBySql <TMedicalHisDetailPic>(strSql1, paramDetail);
if (lstDetailPic != null && lstDetailPic.Count > 0)
{
List <String> lstDeletePic = new List <string>();
String strPicUrl = "";
foreach (TMedicalHisDetailPic mhp in lstDetailPic)
{
strPicUrl = "";
strPicUrl = mhp.PicUrl;
if (strPicUrl.Trim() != "")
{
lstDeletePic.Add(strPicUrl.Trim());
}
}
Zelo.Common.Common.ImageSave.DeletePic(lstDeletePic);
}
//Update(ttem);
DataBaseHelper.Remove(lstDetailPic);
//Update(ttem);
DataBaseHelper.Remove(ttem);
//提交事务
DataBaseHelper.CommitTransaction();
return(true);
}
catch
{
//事务回滚
DataBaseHelper.RollbackTransaction();
return(false);
}
}
/// <summary>
/// 添加一个病历
/// </summary>
/// <param name="templateInfo"></param>
/// <returns></returns>
/// <summary>
public bool UpdateHisDetail(string strDetailGid, string strTitle, string strDesc, string strDoctorGid, List <String> lstPic)
{
//开启事务
DataBaseHelper.BeginTransaction();
try
{
String strSql = "select * from T_Medical_HisDetail where DETAIL_GID=@DETAIL_GID AND Status =1";
ParamMap param = ParamMap.newMap();
param.setParameter("DETAIL_GID", strDetailGid);
TMedicalHisDetail detail = DataBaseHelper.FindOne <TMedicalHisDetail>(strSql, param);
if (detail != null)
{
detail.DetailTitle = strTitle != null ? strTitle : detail.DetailTitle;
detail.DetailDescribe = strDesc != null ? strDesc : detail.DetailDescribe;
detail.CreateUser = strDoctorGid != null?strDoctorGid:detail.CreateUser;
String strSql1 = "select * from T_Medical_HisDetailPic where Detail_Gid=@Detail_Gid and status =1";
ParamMap paramDetail = ParamMap.newMap();
paramDetail.setParameter("Detail_Gid", strDetailGid);
List <TMedicalHisDetailPic> lstDetailPic = DataBaseHelper.FindBySql <TMedicalHisDetailPic>(strSql1, paramDetail);
if (lstDetailPic != null && lstDetailPic.Count > 0)
{
List <String> lstDeletePic = new List <string>();
String strPicUrl = "";
foreach (TMedicalHisDetailPic mhp in lstDetailPic)
{
strPicUrl = "";
strPicUrl = mhp.PicUrl;
if (strPicUrl.Trim() != "")
{
lstDeletePic.Add(strPicUrl.Trim());
}
}
Zelo.Common.Common.ImageSave.DeletePic(lstDeletePic);
}
//Update(ttem);
DataBaseHelper.Remove(lstDetailPic);
lstDetailPic = new List <TMedicalHisDetailPic>();
///提交模版下的每个动作
foreach (string strImgUrl in lstPic)
{
TMedicalHisDetailPic detailPic = new TMedicalHisDetailPic();
detailPic.DetailGid = detail.DetailGid;
detailPic.PicUrl = strImgUrl;
lstDetailPic.Add(detailPic);
}
Update <TMedicalHisDetail>(detail);
Save(lstDetailPic);
//提交事务
DataBaseHelper.CommitTransaction();
return(true);
}
else
{
return(false);
}
}
catch
{
//事务回滚
DataBaseHelper.RollbackTransaction();
return(false);
}
}
/// <summary>
/// 删除病历夹
/// </summary>
/// <param name="strDoctorGid"></param>
/// <param name="strPatientGid"></param>
/// <param name="strSickness"></param>
/// <returns></returns>
public Boolean DeleteHisByGid(String strMedicalHisGid)
{
String strSql = "select * from T_Medical_His where HIS_GID=@HIS_GID and status = 1";
ParamMap param = ParamMap.newMap();
param.setParameter("HIS_GID", strMedicalHisGid);
TMedicalHis mh = DataBaseHelper.FindOne <TMedicalHis>(strSql, param);
if (mh != null)
{
//开启事务
DataBaseHelper.BeginTransaction();
try
{
String strSql1 = "select * from T_Medical_HisDetail where His_ID=@His_ID and status = 1";
param = ParamMap.newMap();
param.setParameter("His_ID", mh.HisGid);
List <TMedicalHisDetail> mht = DataBaseHelper.FindBySql <TMedicalHisDetail>(strSql1, param);
strSql1 = "select * from T_Medical_HisDetailPic where Detail_Gid IN (SELECT DETAIL_GID FROM T_Medical_HisDetail where His_ID=@His_ID and status = 1) and status =1";
ParamMap paramDetail = ParamMap.newMap();
paramDetail.setParameter("His_ID", mh.HisGid);
List <TMedicalHisDetailPic> lstDetailPic = DataBaseHelper.FindBySql <TMedicalHisDetailPic>(strSql1, paramDetail);
if (lstDetailPic != null && lstDetailPic.Count > 0)
{
List <String> lstDeletePic = new List <string>();
String strPicUrl = "";
foreach (TMedicalHisDetailPic mhp in lstDetailPic)
{
strPicUrl = "";
strPicUrl = mhp.PicUrl;
if (strPicUrl.Trim() != "")
{
lstDeletePic.Add(strPicUrl.Trim());
}
}
Zelo.Common.Common.ImageSave.DeletePic(lstDeletePic);
}
//new MedicalHisDetailService().DeleteDetailByGId(tem.HisGid)
if (lstDetailPic != null && lstDetailPic.Count > 0)
{
DataBaseHelper.Remove(lstDetailPic);
}
if (mht != null && mht.Count > 0)
{
DataBaseHelper.Remove(mht);
}
DataBaseHelper.Remove(mh);
//Update(ttem);
//Update<TTemplate>(tem);
//提交事务
DataBaseHelper.CommitTransaction();
return(true);
}
catch
{
//事务回滚
DataBaseHelper.RollbackTransaction();
return(false);
}
}
return(false);
}
