private void LisResultReOperation(DataTable dt) //用来判断进行插入修改操作
{
if (dt != null && dt.Rows.Count > 0)
{
//先删除，后插入
DeleteFromLisResultRe(dt.Rows[0]["ybh"].ToString(), dt.Rows[0]["jyrq"].ToString(),
dt.Rows[0]["yq"].ToString(), dt.Rows[0]["yybm"].ToString());
Form_lisBll form_lisbll = new Form_lisBll();
form_lisbll.Add(dt, "sql042", true);
}
}
private bool TjZtOperation(DataTable dtAll, DataRow drs, string jkdah, string sfzh, string ryxm)
{
Form_lisBll form_lisbll = new Form_lisBll();
//查询体检状态
string tjzt = "1";
DataRow[] dr_zt = dtAll.Select("xmdh='TJZT' and ybh='" + drs["ybh"].ToString() + "'");
if (dr_zt != null && dr_zt.Length > 0)
{
tjzt = dr_zt[0]["result"].ToString();
}
//体检状态信息
ArrayList TJRYXXList = save_T_JK_TJZT(jkdah, sfzh, ryxm,
drs["jyrq"].ToString(), TJClient.Common.Common.TJTYPE.健康体检表, TJClient.Common.Common.ZT.确定状态);
if (TJRYXXList != null && TJRYXXList.Count > 0)
{
DBAccess dbaccess = new DBAccess();
dbaccess.ExecuteNonQueryBySql(TJRYXXList);
}
return(true);
}
/// <summary>
/// 更新健康体检表
/// </summary>
/// <param name="dt_tjjgUpdate"></param>
/// <returns></returns>
public bool Update_jktj(DataTable dt_tjjgUpdate, string JKDAH, string jyrq_tem)
{
try
{
if (dt_tjjgUpdate == null || dt_tjjgUpdate.Columns.Count == 0 || dt_tjjgUpdate.Rows.Count == 0)
{
return(false);
}
if (dt_tjjgUpdate.Columns.Contains("D_GRDABH") == false)
{
DataColumn dtColumn = new DataColumn("D_GRDABH");
dtColumn.DefaultValue = JKDAH;
dt_tjjgUpdate.Columns.Add(dtColumn);
}
if (dt_tjjgUpdate.Columns.Contains("HAPPENTIME") == false)
{
DataColumn dtColumn = new DataColumn("HAPPENTIME");
dtColumn.DefaultValue = jyrq_tem;
dt_tjjgUpdate.Columns.Add(dtColumn);
}
if (dt_tjjgUpdate.Columns.Contains("czy") == false)
{
DataColumn dtColumn = new DataColumn("czy");
dtColumn.DefaultValue = UserInfo.userId;
dt_tjjgUpdate.Columns.Add(dtColumn);
}
if (dt_tjjgUpdate.Columns.Contains("gzz") == false)
{
DataColumn dtColumn = new DataColumn("gzz");
dtColumn.DefaultValue = UserInfo.gzz;
dt_tjjgUpdate.Columns.Add(dtColumn);
}
//体检结果是否已经存在
string Guid = "";
//true:新的Guid false:已经存在的Guid
bool GuidResult = true;
GuidResult = getNewGuid(out Guid, JKDAH, jyrq_tem);
Form_lisBll form_lisbll = new Form_lisBll();
if (dt_tjjgUpdate.Columns.Contains("guid") == false)
{
DataColumn dtColumn = new DataColumn("guid");
dtColumn.DefaultValue = Guid;
dt_tjjgUpdate.Columns.Add(dtColumn);
}
//体检结果
if (GuidResult == true)
{
//体检结果插入
form_lisbll.Add(dt_tjjgUpdate, "sql047");
}
else
{
//体检结果更新
dt_tjjgUpdate.AcceptChanges();
dt_tjjgUpdate.Rows[0]["guid"] = Guid;
form_lisbll.Upd(dt_tjjgUpdate, "sql048");
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取结果
/// </summary>
/// <returns></returns>
public DataTable dataRecive()
{
DataTable dt = null;
string errMsg = "";
try
{
if (yqDemo != null)
{
if (yqDemo.IsOpen(out errMsg) == false)
{
yqDemo.open(out errMsg);
}
dt = yqDemo.YQDataReturn(DateTime.Now.ToString("yyyy-MM-dd"), out errMsg);
}
else
{
if (yqxh.Trim().Length == 0)
{
timer_lis.Enabled = false;
//MessageBox.Show("请选择仪器！");
return(null);
}
if (yqDemo == null)
{
if (Common.getyqPath(yqxh).Length <= 0)
{
MessageBox.Show("仪器配置文件不存在!");
return(null);
}
string yqVersion = XmlRW.GetValueFormXML(Common.getyqPath(yqxh), "YQ_Version", "value");
yqDemo = LisFactory.LisCreate(yqVersion);
}
if (yqDemo.IsOpen(out errMsg) == false)
{
yqDemo.open(out errMsg);
}
dt = yqDemo.YQDataReturn(DateTime.Now.ToString("yyyy-MM-dd"), out errMsg);
}
//将取得的结果保存到数据库中
if (dt != null)
{
if (!dt.Columns.Contains("yybm"))
{
DataColumn dtcolumn = new DataColumn("yybm");
dtcolumn.DefaultValue = UserInfo.Yybm;
dt.Columns.Add(dtcolumn);
}
if (!dt.Columns.Contains("yq"))
{
DataColumn dtcolumn = new DataColumn("yq");
dtcolumn.DefaultValue = timer_lis;
dt.Columns.Add(dtcolumn);
}
Form_lisBll form_lisbll = new Form_lisBll();
form_lisbll.Add(dt, "sql042");
}
}
catch (Exception ex)
{
timer_lis.Enabled = false;
Jktj_lis.msgShow(ex.Message);
}
return(dt);
}
/// <summary>
/// 更新健康体检表
/// </summary>
/// <returns></returns>
public string updateLis_jktj(DataTable dtList_ryxx)
{
//没有需要同步的人员
if (dtList_ryxx == null || dtList_ryxx.Rows.Count == 0)
{
return("1");
}
try
{
Form_lisBll form_lisbll = new Form_lisBll();
string JKDAH = "";
string tjsj = "";
for (int i = 0; i < dtList_ryxx.Rows.Count; i++)
{
JKDAH = dtList_ryxx.Rows[i]["JKDAH"].ToString();
//获取人员的信息（条码号 条码类型）
string sqlWhere = string.Format(" and YLJGBM='{0}' and JKDAH='{1}' and nd='{2}' ", UserInfo.Yybm, JKDAH, DateTime.Now.Year.ToString());
DataTable dt_txmList = form_lisbll.GetMoHuList(sqlWhere, "sql_select_people_txm");
if (dt_txmList != null && dt_txmList.Rows.Count > 0)
{
//按照条码号同步lis信息
for (int j = 0; j < dt_txmList.Rows.Count; j++)
{
//按照条码号获取lis检验信息
string sqlWhereLis = string.Format(" and testno='{0}' ", dt_txmList.Rows[i]["TXMBH"].ToString());
DataTable dt_lis_reqresultList = form_lisbll.GetMoHuList(sqlWhereLis, "sql_select_lis_reqresult");
if (dt_lis_reqresultList != null && dt_lis_reqresultList.Rows.Count > 0)
{
//获取检验项目与健康体检表的项目对应关系
string yq = dt_lis_reqresultList.Rows[0]["instrument"].ToString();
tjsj = dt_lis_reqresultList.Rows[0]["resulttime"].ToString();
string sqlWhereLisItems = string.Format(" and (YQLX='' or YQLX is null or YQLX='{0}') and YLJGBM='{1}' ", yq, UserInfo.Yybm);
DataTable dt_LisItemsList = form_lisbll.GetMoHuList(sqlWhereLisItems, "sql_select_lis_reqresult");
if (dt_LisItemsList != null && dt_LisItemsList.Rows.Count > 0)
{
DataTable dt_tjjgUpdate = new DataTable();
dt_tjjgUpdate.Rows.Add();
//获取对应的数据值
for (int k = 0; k < dt_LisItemsList.Rows.Count; k++)
{
//lis结果
for (int m = 0; m < dt_lis_reqresultList.Rows.Count; m++)
{
if (dt_LisItemsList.Rows[k]["XMBM_LIS"].ToString().ToUpper().Equals(dt_lis_reqresultList.Rows[m]["itemno"].ToString().ToUpper()))
{
if (dt_tjjgUpdate.Columns.Contains(dt_LisItemsList.Rows[k]["XMBM"].ToString()) == false)
{
DataColumn dtColumn = new DataColumn(dt_LisItemsList.Rows[k]["XMBM"].ToString());
dtColumn.DefaultValue = dt_lis_reqresultList.Rows[m]["testresult"].ToString();
dt_tjjgUpdate.Columns.Add(dtColumn);
}
else
{
dt_tjjgUpdate.Rows[dt_tjjgUpdate.Rows.Count - 1][dt_LisItemsList.Rows[k]["XMBM"].ToString()] = dt_lis_reqresultList.Rows[m]["testresult"].ToString();
}
break;
}
}
}
//数据更新到健康体检结果中
Update_jktj(dt_tjjgUpdate, JKDAH, tjsj);
}
}
}
}
}
return("");
}
catch (Exception ex)
{
return(ex.Message);
}
}