public override void ProcessMessage()
{
OutObject = new TIJIANCXSQ_OUT();
string zhengJianHM = InObject.ZHENGJIANHM.ToUpper(); //证件号码
string tiJianBM = InObject.TIJIANBM; //体检编码
string shengQingLX = InObject.SHENQINGLX; //申请类型
#region 基础入参判断
if (string.IsNullOrEmpty(zhengJianHM))
{
throw new Exception("证件号码不能为空！");
}
if (string.IsNullOrEmpty(tiJianBM))
{
throw new Exception("体检编码不能为空！");
}
if (string.IsNullOrEmpty(shengQingLX))
{
shengQingLX = "1";
}
#endregion
#region 报告状态确认
string tjbgdzt = ConfigurationManager.AppSettings["TJBGFFZT"].ToString();
if (string.IsNullOrEmpty(tjbgdzt))
{
tjbgdzt = "6";
}
string tiJianBaoGaoZTSql = "select * from tj_dengjixx_view where tijianbm = '{0}' and tijiandzt in ({1})";
DataTable dtTiJianBaoGaoZT = DBVisitorTiJian.ExecuteTable(string.Format(tiJianBaoGaoZTSql, tiJianBM, tjbgdzt, zhengJianHM));
if (dtTiJianBaoGaoZT == null || dtTiJianBaoGaoZT.Rows.Count <= 0)
{
throw new Exception("该体检还未出报告！");
}
#endregion
#region 检查是否已经提交申请
string tiJianChaXunSQSql = "select * from TJ_JK_SHENQINGDAN_view where tijianbm = '{0}' and ZHENGJIANBM = '{1}' and shenqingdlx = '{2}' ";
DataTable dtTiJianChaXunSQ = DBVisitorTiJian.ExecuteTable(string.Format(tiJianChaXunSQSql, tiJianBM, zhengJianHM, shengQingLX));
if (dtTiJianChaXunSQ != null && dtTiJianChaXunSQ.Rows.Count > 0)
{
throw new Exception("该体检单已提交了查询申请，请等待审核！");
}
#endregion
#region 写入申请信息
string shenQingDID = DBVisitorTiJian.ExecuteScalar("select JK_SHENQINGDAN.Nextval from dual").ToString();
string tiJiaoTiJianSQSql = "insert into tj_jk_shenqingdan(shenqingdid,shenqingdlx,zhengjianbm,tijianbm,zhuangtai,shengqingren,shengqingrq) values ('{0}','{1}','{2}','{3}',0,'{4}',sysdate)";
DBVisitorTiJian.ExecuteNonQuery(string.Format(tiJiaoTiJianSQSql, shenQingDID, shengQingLX, zhengJianHM, tiJianBM, InObject.BASEINFO.CAOZUOYDM));
#endregion
}
