/// <summary>
/// 用户注册_带绑卡
/// </summary>
/// <param name="info">用户信息</param>
/// <returns>0-成功 大于0-失败 小于0-异常</returns>
public int DB_UserRegisterBindCard(UserInfo info, out string msg)
{
msg = "";
int ret = -1;
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
try
{
bool isRegister = IsUserRegister(info.openid, out msg);
if (isRegister)
{
msg = "亲，您已注册！";
return(99);
}
bool _flag = false;
string insertText = _builder.GetUserRegisterBindCardSql(info.name, info.phone, info.idcardno, info.address, info.openid, info.headurl, info.cardno, info.patientid, info.usertype, out _flag, out msg);
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, insertText);
if (!_flag)
{
ret = 10;
return(ret);
}
int row = DbHelperOra.ExecuteSql(insertText, connection);
//row:影响的记录数
if (row <= 0)
{
ret = 99;
msg = "注册失败！";
}
else
{
ret = 0;
}
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
ret = -1;
return(ret);
}
finally
{
if (null != connection && ConnectionState.Open == connection.State)
{
connection.Close();
}
}
}
/// <summary>
/// 添加常用联系人
/// </summary>
/// <param name="info">用户信息</param>
/// <param name="linkInfo">常用联系人信息</param>
/// <returns>0-成功 大于0-失败 小于0-异常</returns>
public int DB_AddContacts(UserInfo info, out UserInfo linkInfo, out string msg)
{
msg = "";
linkInfo = new UserInfo();
int ret = -1;
string linkmanid = "";
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
try
{
bool _flag = false;
ret = DB_GetLinkmanid(info.openid, out linkmanid, out msg);
if (ret != 0)
{
ret = 03;
msg = "获取联系人ID失败！";
return(ret);
}
string insertText = _builder.GetAddContactsSql(info.openid, info.label, info.name, info.phone,
info.idcardno, info.address, linkmanid, out _flag, out msg);
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, insertText);
if (!_flag)
{
ret = 10;
return(ret);
}
ArrayList listSql = new ArrayList();
listSql.Add(insertText);
DbHelperOra.ExecuteSqlTran(listSql, connection);
linkInfo.label = info.label;
linkInfo.name = info.name;
linkInfo.linkmanid = linkmanid;
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
ret = -1;
return(ret);
}
finally
{
if (null != connection && ConnectionState.Open == connection.State)
{
connection.Close();
}
}
}
/// <summary>
/// 查询医生信息(按拼音）
/// </summary>
/// <param name="queryName">拼音代码或医生名称</param>
/// <param name="values">医生信息</param>
/// <param name="msg">出错信息</param>
/// <returns>0：成功 大于0：出错 小于0：异常</returns>
public int DB_ListDoctor(string queryName, out ArrayList values, out string msg)
{
msg = "";
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
try
{
int ret = -99;
string findId1 = _builder.QueryDoctorInfoSql(queryName);
dr = DbHelperOra.ExecuteReader(findId1, connection);
if (dr.HasRows)
{
values = new ArrayList();
while (dr.Read())
{
DoctorInfo pd = new DoctorInfo();
pd.dm = !dr.IsDBNull(0) ? dr.GetString(0) : "";
pd.xm = !dr.IsDBNull(1) ? dr.GetString(1) : "";
pd.jb = !dr.IsDBNull(2) ? dr.GetString(2) : "";
values.Add(pd);
}
ret = 0;
}
else
{
msg = "亲，没有记录";
values = null;
ret = 2;
}
dr.Close();
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
values = null;
return(-99);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
/// <summary>
/// 取消订单
/// </summary>
/// <param name="yylsh">医院流水号</param>
/// <param name="msg">出错信息</param>
/// <returns>0：成功 大于0：出错 小于0：异常</returns>
public int DB_CancelPredepositList(string openid, string patientname, string patientid, long yylsh, out string msg)
{
msg = "";
long _sjczzt = -99;
string _ztmc = "";
double _czje = 0;
int phoneOrderStatus = DB_AlipayStatusOrder(yylsh, out _sjczzt, out _ztmc, out _czje, out msg);
if (phoneOrderStatus == 1)
{
msg = "手机订单已完成，无法被修改";
return(22);
}
else if (phoneOrderStatus == -1)
{
msg = "手机订单已作废，无法被修改";
return(23);
}
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
try
{
int ret = -1;
//作废订单
string updateSql = _builder.CancelOrderSql(yylsh);
ArrayList listSql = new ArrayList();
listSql.Add(updateSql);
string logMsg = " yylsh = '" + yylsh + "' 。";
UtilLog.GetInstance().WriteOrderLog("取消订单成功: ", logMsg);
DbHelperOra.ExecuteSqlTran(listSql, connection);
msg = "订单作废成功";
ret = 00;
return(ret);
}
catch (Exception ex)
{
msg = GetExceptionInfo(ex);
return(-1);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
/// <summary>
/// 查看常用联系人ID
/// </summary>
/// <param name="openid">用户标识</param>
/// <param name="name">姓名</param>
/// <param name="idcardno">身份证号</param>
/// <returns>0-成功 大于0-失败 小于0-异常</returns>
private int DB_FindLinkmanid(string openid, string linkmanid, out string[] paramters, out string msg)
{
msg = "";
paramters = new string[2];
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
int ret = -1;
try
{
string result = "";
string findLinkmanidSql = "select linkmanid, name from ui_table where openid = '{0}' and linkmanid = '{1}'";
string[] _paramters = new string[2];
_paramters[0] = openid;
_paramters[1] = linkmanid;
result = string.Format(findLinkmanidSql, _paramters);
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, result);
dr = DbHelperOra.ExecuteReader(result, connection);
if (dr.Read())
{
paramters[0] = !dr.IsDBNull(0) ? dr.GetString(0) : "";
paramters[1] = !dr.IsDBNull(1) ? dr.GetString(1) : "";
}
if (null != dr)
{
dr.Close();
}
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
ret = -1;
return(ret);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
/// <summary>
/// 查看常用联系人ID
/// </summary>
/// <param name="openid">用户标识</param>
/// <param name="name">姓名</param>
/// <param name="idcardno">身份证号</param>
/// <returns>0-成功 大于0-失败 小于0-异常</returns>
private int DB_GetLinkmanid(string openid, out string linkmanid, out string msg)
{
msg = "";
linkmanid = "";
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
int ret = -1;
try
{
string result = "";
string getLinkmanidSql = "Select fun_get_linkmanid('{0}') From dual";
string[] _paramters = new string[1];
_paramters[0] = openid;
result = string.Format(getLinkmanidSql, _paramters);
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, result);
dr = DbHelperOra.ExecuteReader(result, connection);
if (dr.Read())
{
linkmanid = !dr.IsDBNull(0) ? dr.GetString(0) : "";
ret = 0;
}
if (null != dr)
{
dr.Close();
}
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
ret = -1;
return(ret);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
/// <summary>
/// 用户信息修改
/// </summary>
/// <param name="info">用户信息</param>
/// <param name="msg">成功、错误或异常信息</param>
/// <returns>0-成功 大于0-失败 小于0-异常</returns>
public int DB_ModifyInfo(UserInfo info, out string msg)
{
msg = "";
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
int ret = -1;
try
{
bool _flag = false;
string updateText = _builder.GetModifyLandSql(info.openid, info.name, info.phone, info.idcardno,
info.address, info.headurl, info.usertype, out _flag, out msg);
ArrayList listSql = new ArrayList();
listSql.Add(updateText);
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, updateText);
if (!_flag)
{
ret = 10;
return(ret);
}
DbHelperOra.ExecuteSqlTran(listSql, connection);
//ret:影响的记录数
msg = "修改用户信息成功";
ret = 0;
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
ret = -1;
return(ret);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
/// <summary>
/// 获取门诊充值信息
/// </summary>
/// <param name="patientid">病人ID</param>
/// <returns>0-成功 大于0-失败 小于0-异常</returns>
private int DB_GetMZCZInfo(string patientid, out UserJFInfo info, out string msg)
{
info = new UserJFInfo();
msg = "";
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
int ret = -1;
try
{
string findText = "select patientname, cardno, zhanghuzt, cardtype, idcardno, phone from ZFB_MENZHENKLB t where patientid = '" + patientid + "'";
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, findText);
dr = DbHelperOra.ExecuteReader(findText, connection);
if (dr.Read())
{
info.brxm = !dr.IsDBNull(0) ? dr.GetString(0) : "";
info.cardno = !dr.IsDBNull(1) ? dr.GetString(1) : "";
info.zhanghuzt = !dr.IsDBNull(2) ? Convert.ToString(dr.GetInt32(2)) : "";
info.cardtype = !dr.IsDBNull(3) ? dr.GetString(3) : "";
info.sfzh = !dr.IsDBNull(4) ? dr.GetString(4) : "";
info.lxdh = !dr.IsDBNull(5) ? dr.GetString(5) : "";
ret = 0;
}
else
{
msg = "医院端未找到，请核对信息后重试";
ret = 10;
}
return(ret);
}
catch (Exception ex)
{
msg = GetExceptionInfo(ex);
ret = -1;
return(ret);
}
finally
{
if (null != dr)
{
dr.Close();
}
if (null != connection && ConnectionState.Open == connection.State)
{
connection.Close();
}
}
}
/// <summary>
///
/// </summary>
/// <param name="sfid"></param>
/// <param name="values"></param>
/// <param name="msg"></param>
/// <returns></returns>
public int GetChuFangList(string sfid, out ArrayList values, out string msg)
{
int result = -1;
msg = "";
string sqlQuery = string.Format("select cflsh,cfje from yyy_chufang_tf where sfid='{0}'", sfid);
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
values = null;
try
{
dr = DbHelperOra.ExecuteReader(sqlQuery, connection);
if (dr.HasRows)
{
values = new ArrayList();
while (dr.Read())
{
ChuFangInfo entity = new ChuFangInfo();
entity.CFLSH = !dr.IsDBNull(0) ? dr.GetString(0) : " ";
entity.CFJE = !dr.IsDBNull(1) ? Convert.ToString(dr.GetDouble(1)) : " ";
values.Add(entity);
}
result = 1;
}
else
{
msg = "没有查找到记录";
result = 0;
}
dr.Close();
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
values = null;
return(-1);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
return(result);
}
private bool isUserbindcard(string openid, string cardno, string patientid, out string msg)
{
msg = "";
bool isbindcard = false;
string number = "";
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
try
{
string result = "";
string isUserbindcardSql = "select name, phone, idcardno, cardno, patientid from ZFB_TIANJIACYLXR where openid = '{0}' and cardno = '{1}' and patientid = '{2}'";
string[] _paramters = new string[3];
_paramters[0] = openid;
_paramters[1] = cardno;
_paramters[2] = patientid;
result = string.Format(isUserbindcardSql, _paramters);
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, result);
dr = DbHelperOra.ExecuteReader(result, connection);
if (dr.HasRows)
{
if (dr.Read())
{
number = !dr.IsDBNull(3) ? dr.GetString(3) : "";
}
isbindcard = true;
}
return(isbindcard);
}
catch (Exception ex)
{
msg = GetExceptionInfo(ex);
return(isbindcard);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
private bool IsUserRegister(string openid, out string msg)
{
msg = "";
bool isRegister = false;
string name = "";
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
try
{
string result = "";
string isUserRegisterSql = "select openid, name, idcardno from zfb_yonghuzc_bk where openid = '{0}'";
string[] _paramters = new string[1];
_paramters[0] = openid;
result = string.Format(isUserRegisterSql, _paramters);
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, result);
dr = DbHelperOra.ExecuteReader(result, connection);
if (dr.HasRows)
{
if (dr.Read())
{
name = !dr.IsDBNull(1) ? dr.GetString(1) : "";
}
isRegister = true;
}
return(isRegister);
}
catch (Exception ex)
{
msg = GetExceptionInfo(ex);
return(isRegister);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
/// <summary>
/// 获取缴费或退费联系人列表 （FY030101）
/// </summary>
/// <param name="openid"></param>
/// <param name="values"></param>
/// <param name="msg"></param>
/// <returns>1=获取成功、其他代表失败</returns>
public int QueryConnectPerson(string openid, out ArrayList values, out string msg)
{
int ret = -1;
values = new ArrayList();
msg = "";
string sqlQuery = string.Format("select linkmanid, label, name from ZFB_TIANJIACYLXR " +
"where openid = '{0}'", openid);
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
try
{
dr = DbHelperOra.ExecuteReader(sqlQuery, connection);
if (dr.HasRows)
{
ConnectPerson entity = new ConnectPerson();
entity.brid = !dr.IsDBNull(0) ? dr.GetString(0) : "";
entity.label = !dr.IsDBNull(1) ? dr.GetString(1) : "";
entity.name = !dr.IsDBNull(2) ? dr.GetString(2) : "";
values.Add(entity);
}
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
ret = -1;
return(ret);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
return(1);
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <param name="type"></param>
/// <param name="values"></param>
/// <param name="msg"></param>
/// <returns></returns>
public int QueryPatientInfo(string id, string type, out ArrayList values, out string msg)
{
values = new ArrayList();
msg = "";
int ret = -1;
string sqlQuery = string.Format(" select * from FY030102 where id={0} and type={1} ", id, type);
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
try
{
dr = DbHelperOra.ExecuteReader(sqlQuery, connection);
if (dr.HasRows)
{
ConnectPerson entity = new ConnectPerson();
entity.brid = !dr.IsDBNull(0) ? dr.GetString(0) : "";
entity.label = !dr.IsDBNull(1) ? dr.GetString(1) : "";
entity.name = !dr.IsDBNull(2) ? dr.GetString(2) : "";
values.Add(entity);
}
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
ret = -1;
return(ret);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
return(1);
}
/// <summary>
/// 通知病人就诊信息
/// </summary>
/// <param name="msg"></param>
/// <returns></returns>
public int DB_InformPatient(out ArrayList values, out string msg)
{
int ret = -1;
//1代表以预约
int Preengagestate = 1;
values = null;
msg = "";
values = new ArrayList();
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
try
{
bool _flag = false;
string interText = _builder.GetInformPatientSql(Preengagestate, out _flag, out msg);
if (!_flag)
{
return(10);
}
dr = DbHelperOra.ExecuteReader(interText, connection);
if (dr.HasRows)
{
if (dr.Read())
{
while (dr.Read())
{
InformPatientInfo ri = new InformPatientInfo();
ri.userid = !dr.IsDBNull(0) ? dr.GetString(0) : "";
ri.brxm = !dr.IsDBNull(1) ? dr.GetString(1) : "";
ri.ysxm = !dr.IsDBNull(2) ? dr.GetString(2) : "";
ri.jzdz = !dr.IsDBNull(3) ? dr.GetString(3) : "";
ri.jzsj = !dr.IsDBNull(4) ? dr.GetString(4) : "";
ri.jzrq = !dr.IsDBNull(5) ? dr.GetDateTime(5).ToString(AppUtils.DateTime_Format_All) : " ";
values.Add(ri);
}
msg = "获取成功";
}
ret = 0;
dr.Close();
return(ret);
}
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
values = null;
return(-1);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
return(ret);
}
/// <summary>
/// 核对未到账的充值缴费信息
/// </summary>
/// <param name="msg"></param>
/// <returns></returns>
public int DB_CheckInformation(out ArrayList values, out string msg)
{
int ret = -1;
//0代表以创建的订单
int ddzt = 0;
values = null;
msg = "";
values = new ArrayList();
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
try
{
bool _flag = false;
string interText = _builder.GetCheckInformationSql(ddzt, out _flag, out msg);
if (!_flag)
{
return(10);
}
long yylsh = 0;
dr = DbHelperOra.ExecuteReader(interText, connection);
if (dr.HasRows)
{
while (dr.Read())
{
CheckInformation ri = new CheckInformation();
yylsh = !dr.IsDBNull(0) ? dr.GetInt64(0) : 0;
ri.out_trade_no = StringHelper.YylshHasPrefix(yylsh);
ri.brlx = !dr.IsDBNull(1) ? Convert.ToString(dr.GetInt32(1)) : "";
if (ri.brlx == "1")
{
ri.patientid = !dr.IsDBNull(2) ? Convert.ToString(dr.GetInt64(2)) : "";
}
else if (ri.brlx == "2")
{
ri.inpatientno = !dr.IsDBNull(2) ? Convert.ToString(dr.GetInt64(2)) : "";
}
ri.patientname = !dr.IsDBNull(3) ? dr.GetString(3) : " ";
ri.money = !dr.IsDBNull(4) ? Convert.ToString(dr.GetDouble(4)) : " ";
ri.openid = !dr.IsDBNull(5) ? dr.GetString(5) : " ";
values.Add(ri);
}
msg = "获取成功";
}
ret = 0;
dr.Close();
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
values = null;
return(-1);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
/// <summary>
/// 查询剩余床位数
/// </summary>
/// <param name="list">床位信息</param>
/// <param name="msg">出错信息</param>
/// <returns>0：成功 大于0：出错 小于0：异常</returns>
public int DB_QueryRemainBeds(out ArrayList list, out string msg)
{
msg = "";
list = null;
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
try
{
bool _flag = false;
string sql = _builder.GetSqlRemaindBeds(out _flag, out msg);
if (!_flag)
{
return(10);
}
int ret = -1;
dr = DbHelperOra.ExecuteReader(sql, connection);
if (dr.HasRows)
{
list = new ArrayList();
while (dr.Read())
{
RemainBeds ri = new RemainBeds();
ri.bqmc = !dr.IsDBNull(0) ? dr.GetString(0) : "";
if (WebConfigParameter.HospitalName() == AppUtils.HOSPITALNAME.WZSYJXDSRMYY)
{
ri.sycw = ri.zdcws = !dr.IsDBNull(1) ? dr.GetInt32(1) : 0;
}
else
{
if (WebConfigParameter.HospitalName() == AppUtils.HOSPITALNAME.WZSDQRMYY ||
WebConfigParameter.HospitalName() == AppUtils.HOSPITALNAME.WZSCNXDYRMYY ||
WebConfigParameter.HospitalName() == AppUtils.HOSPITALNAME.WZSCNXFYBJYY ||
WebConfigParameter.HospitalName() == AppUtils.HOSPITALNAME.WZSTSXZYY)
{
ri.bqid = !dr.IsDBNull(1) ? dr.GetString(1) : "";
}
else
{
ri.bqid = !dr.IsDBNull(1) ? Convert.ToString(dr.GetInt64(1)) : "";
}
ri.zzrenshu = !dr.IsDBNull(2) ? dr.GetInt32(2) : 0;
if (WebConfigParameter.HospitalName() == AppUtils.HOSPITALNAME.WZSDQRMYY)
{
ri.zdcws = !dr.IsDBNull(3) ? Convert.ToInt32(dr.GetString(3)) : 0;
}
else
{
ri.zdcws = !dr.IsDBNull(3) ? dr.GetInt32(3) : 0;
}
ri.sycw = (ri.zdcws - ri.zzrenshu) > 0 ? (ri.zdcws - ri.zzrenshu) : 0;
if (WebConfigParameter.HospitalName() == AppUtils.HOSPITALNAME.WZSDEYY)
{
ri.sycw = -ri.zzrenshu;
}
}
list.Add(ri);
}
ret = 0;
}
else
{
list = null;
msg = "没有找到床位信息。";
ret = 1;
}
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
list = null;
msg = GetExceptionInfo(ex);
return(AppUtils.Default_Exception_Code);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
/// <summary>
/// 药品分页查询
/// </summary>
/// <param name="pNumber">所在页数</param>
/// <param name="pRows">每页显示条数</param>
/// <param name="values">药品信息</param>
/// <param name="msg">出错信息</param>
/// <returns>0：成功 大于0：出错 小于0：异常</returns>
public int DB_PageMedicine(int pNumber, int pRows, out ArrayList values, out string msg)
{
msg = "";
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
values = new ArrayList();
try
{
int ret = -99;
long maxrow;
long minrow;
General.CalculatePage(pNumber, pRows, out maxrow, out minrow);
bool _flag = false;
string findId1 = _builder.GetMedicinePage(maxrow, minrow, out _flag, out msg);
if (!_flag)
{
return(10);
}
dr = DbHelperOra.ExecuteReader(findId1, connection);
if (dr.HasRows)
{
while (dr.Read())
{
MedicineDetail pd = new MedicineDetail();
pd.lx = !dr.IsDBNull(0) ? dr.GetString(0) : "";
pd.mc = !dr.IsDBNull(1) ? dr.GetString(1) : "";
pd.dw = !dr.IsDBNull(2) ? dr.GetString(2) : "";
pd.gg = !dr.IsDBNull(3) ? dr.GetString(3) : "";
pd.cd = !dr.IsDBNull(4) ? dr.GetString(4) : "";
pd.jg = !dr.IsDBNull(5) ? dr.GetDouble(5) : 0;
values.Add(pd);
}
ret = 0;
}
else
{
msg = "亲，没有记录";
values = null;
ret = 2;
}
dr.Close();
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
values = null;
return(-1);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
/// <summary>
/// 收费项目查询(按拼音码）
/// </summary>
/// <param name="pydm">拼音代码</param>
/// <param name="values">收费信息</param>
/// <param name="msg">出错信息</param>
/// <returns>0：成功 大于0：出错 小于0：异常</returns>
public int DB_QueryCharge(string pydm, out ArrayList values, out string msg)
{
msg = "";
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
values = new ArrayList();
try
{
int ret = -1;
bool _flag = false;
string findId1 = _builder.GetChargeByPy(pydm, out _flag, out msg);
if (!_flag)
{
return(10);
}
dr = DbHelperOra.ExecuteReader(findId1, connection);
if (dr.HasRows)
{
while (dr.Read())
{
ChargeDetail pd = new ChargeDetail();
pd.lx = !dr.IsDBNull(0) ? dr.GetString(0) : "";
pd.mc = !dr.IsDBNull(1) ? dr.GetString(1) : "";
pd.dw = !dr.IsDBNull(2) ? dr.GetString(2) : "";
pd.jg = !dr.IsDBNull(3) ? dr.GetDouble(3) : 0;
values.Add(pd);
}
ret = 0;
}
else
{
msg = "亲，没有记录";
values = null;
ret = 2;
}
dr.Close();
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
values = null;
return(-99);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
/// <summary>
/// 门诊指引单
/// </summary>
/// <param name="jzxh">就诊序号</param>
/// <returns>0-成功 大于0-失败 小于0-异常</returns>
public int DB_mzSingleGuideAndTakeMedicine(string jzxh, out ArrayList values, out string msg)
{
msg = "";
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
int ret = -1;
values = new ArrayList();
try
{
bool _flag = false;
string findText = _builder.GetmzSingleGuideAndTakeMedicineSql(jzxh, out _flag, out msg);
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, findText);
if (!_flag)
{
ret = 10;
return(ret);
}
dr = DbHelperOra.ExecuteReader(findText, connection);
if (dr.HasRows)
{
while (dr.Read())
{
mzMedicalRecords ri = new mzMedicalRecords();
ri.cfxh = !dr.IsDBNull(0) ? dr.GetString(0) : "";
ri.fphm = !dr.IsDBNull(1) ? dr.GetString(1) : "";
ri.kfrq = !dr.IsDBNull(2) ? dr.GetString(2) : "";
ri.ksmc = !dr.IsDBNull(3) ? dr.GetString(3) : "";
ri.zynr = !dr.IsDBNull(4) ? dr.GetString(4) : "";
ri.zywz = !dr.IsDBNull(5) ? dr.GetString(5) : "";
ri.ysxm = !dr.IsDBNull(6) ? dr.GetString(6) : "";
ri.zjje = !dr.IsDBNull(7) ? dr.GetString(7) : "";
values.Add(ri);
}
ret = 0;
}
else
{
msg = "医院端未找到，请核对信息后重试";
ret = 10;
}
dr.Close();
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
ret = -1;
return(ret);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
/// <summary>
/// 一个检验报告单抬头信息
/// </summary>
/// <param name="doctadviseno">条码号</param>
/// <param name="msg">出错信息</param>
/// <returns>0：成功 大于0：出错 小于0：异常</returns>
public int DB_InspectionReportNameInformation(string doctadviseno, out AlipayReportInfo alipayReportInfo, out string msg)
{
msg = "";
alipayReportInfo = new AlipayReportInfo();
OracleConnection oracleConnection = new OracleConnection(WebConfigParameter.ConnectionHisString);
SqlConnection sqlConnection = new SqlConnection(WebConfigParameter.ConnectionLisString);
OracleDataReader dr = null;
SqlDataReader myReader = null;
int ret = -1;
try
{
bool _flag = false;
string sqlstr = "";
string oraclestr = "";
_builder.GetInspectionReportNameInformation(doctadviseno, out sqlstr, out oraclestr, out _flag, out msg);
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, sqlstr);
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, oraclestr);
if (!_flag)
{
return(10);
}
msg = "";
dr = DbHelperOra.ExecuteReader(oraclestr, oracleConnection);
if (null != dr && dr.HasRows)
{
if (dr.Read())
{
alipayReportInfo.doctadviseno = !dr.IsDBNull(0) ? dr.GetString(0) : "";
alipayReportInfo.requesttime = !dr.IsDBNull(1) ? dr.GetDateTime(1).ToString(AppUtils.DateTime_Format_All) : "";
alipayReportInfo.requester = !dr.IsDBNull(2) ? dr.GetString(2) : "";
alipayReportInfo.executetime = !dr.IsDBNull(3) ? dr.GetDateTime(3).ToString(AppUtils.DateTime_Format_All) : "";
alipayReportInfo.executer = !dr.IsDBNull(4) ? dr.GetString(4) : "";
alipayReportInfo.receivetime = !dr.IsDBNull(5) ? dr.GetDateTime(5).ToString(AppUtils.DateTime_Format_All) : "";
alipayReportInfo.receiver = !dr.IsDBNull(6) ? dr.GetString(6) : "";
alipayReportInfo.stayhospitalmode = !dr.IsDBNull(7) ? dr.GetString(7) : "";
alipayReportInfo.patientid = !dr.IsDBNull(8) ? dr.GetString(8) : "";
alipayReportInfo.section = !dr.IsDBNull(9) ? dr.GetString(9) : "";
alipayReportInfo.bedno = !dr.IsDBNull(10) ? dr.GetString(10) : "";
alipayReportInfo.patientname = !dr.IsDBNull(11) ? dr.GetString(11) : "";
alipayReportInfo.sex = !dr.IsDBNull(12) ? dr.GetString(12) : "";
alipayReportInfo.age = !dr.IsDBNull(13) ? dr.GetString(13) : "";
alipayReportInfo.diagnostic = !dr.IsDBNull(14) ? dr.GetString(14) : "";
alipayReportInfo.sampletype = !dr.IsDBNull(15) ? dr.GetString(15) : "";
alipayReportInfo.examinaim = !dr.IsDBNull(16) ? dr.GetString(16) : "";
alipayReportInfo.requestmode = !dr.IsDBNull(17) ? dr.GetString(17) : "";
alipayReportInfo.checker = !dr.IsDBNull(18) ? dr.GetString(18) : "";
alipayReportInfo.checktime = !dr.IsDBNull(19) ? dr.GetDateTime(19).ToString(AppUtils.DateTime_Format_All) : "";
alipayReportInfo.csyq = !dr.IsDBNull(20) ? dr.GetString(20) : "";
alipayReportInfo.profiletest = !dr.IsDBNull(21) ? dr.GetString(21) : "";
ret = 0;
}
return(ret);
}
if (!string.IsNullOrEmpty(WebConfigParameter.ConnectionLisString))
{
myReader = DbHelperSQL.ExecuteReader(sqlstr, sqlConnection);
if (null != myReader && myReader.HasRows)
{
if (myReader.Read())
{
alipayReportInfo.doctadviseno = !myReader.IsDBNull(0) ? myReader.GetString(0) : "";
alipayReportInfo.requesttime = !myReader.IsDBNull(1) ? myReader.GetDateTime(1).ToString(AppUtils.DateTime_Format_All) : "";
alipayReportInfo.requester = !myReader.IsDBNull(2) ? myReader.GetString(2) : "";
alipayReportInfo.executetime = !myReader.IsDBNull(3) ? myReader.GetDateTime(3).ToString(AppUtils.DateTime_Format_All) : "";
alipayReportInfo.executer = !myReader.IsDBNull(4) ? myReader.GetString(4) : "";
alipayReportInfo.receivetime = !myReader.IsDBNull(5) ? myReader.GetDateTime(5).ToString(AppUtils.DateTime_Format_All) : "";
alipayReportInfo.receiver = !myReader.IsDBNull(6) ? myReader.GetString(6) : "";
alipayReportInfo.stayhospitalmode = !myReader.IsDBNull(7) ? myReader.GetString(7) : "";
alipayReportInfo.patientid = !myReader.IsDBNull(8) ? myReader.GetString(8) : "";
alipayReportInfo.section = !myReader.IsDBNull(9) ? myReader.GetString(9) : "";
alipayReportInfo.bedno = !myReader.IsDBNull(10) ? myReader.GetString(10) : "";
alipayReportInfo.patientname = !myReader.IsDBNull(11) ? myReader.GetString(11) : "";
alipayReportInfo.sex = !myReader.IsDBNull(12) ? Convert.ToString(myReader.GetInt32(12)) : "";
if (alipayReportInfo.sex == "1")
{
alipayReportInfo.sex = "男";
}
else if (alipayReportInfo.sex == "2")
{
alipayReportInfo.sex = "女";
}
alipayReportInfo.age = !myReader.IsDBNull(13) ? Convert.ToString(myReader.GetDouble(13)) : "";
alipayReportInfo.diagnostic = !myReader.IsDBNull(14) ? myReader.GetString(14) : "";
alipayReportInfo.sampletype = !myReader.IsDBNull(15) ? myReader.GetString(15) : "";
alipayReportInfo.examinaim = !myReader.IsDBNull(16) ? myReader.GetString(16) : "";
alipayReportInfo.requestmode = !myReader.IsDBNull(17) ? myReader.GetString(17) : "";
alipayReportInfo.checker = !myReader.IsDBNull(18) ? myReader.GetString(18) : "";
alipayReportInfo.checktime = !myReader.IsDBNull(19) ? myReader.GetDateTime(19).ToString(AppUtils.DateTime_Format_All) : "";
alipayReportInfo.csyq = !myReader.IsDBNull(20) ? myReader.GetString(20) : "";
alipayReportInfo.profiletest = !myReader.IsDBNull(21) ? myReader.GetString(21) : "";
ret = 0;
}
}
}
else
{
msg = "未能找到报告单";
ret = 17;
}
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
return(AppUtils.Default_Exception_Code);
}
finally
{
if (null != dr)
{
dr.Close();
}
if (null != myReader)
{
myReader.Close();
}
oracleConnection.Close();
sqlConnection.Close();
}
}
/// <summary>
/// 根据报告单号查询报告详细
/// </summary>
/// <param name="bgdh">报告单号</param>
/// <param name="rds">报告信息</param>
/// <param name="msg">出错信息</param>
/// <returns>0：成功 大于0：出错 小于0：异常</returns>
public int DB_queryReportJCDetail(string bgdh, out ICollection <ReportDetail> rds, out string msg)
{
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
try
{
bool _flag = false;
string sql = _builder.GetReportJCDetailXM(bgdh, out _flag, out msg);
if (!_flag)
{
rds = new List <ReportDetail>();
return(10);
}
dr = DbHelperOra.ExecuteReader(sql, connection);
if (dr.HasRows)
{
rds = new List <ReportDetail>();
while (dr.Read())
{
ReportDetail rd = new ReportDetail();
rd.mc = !dr.IsDBNull(0) ? dr.GetString(0) : "";
rd.dw = !dr.IsDBNull(1) ? dr.GetString(1) : "";
rd.ckjg = !dr.IsDBNull(2) ? dr.GetString(2) : "";
rd.ts = !dr.IsDBNull(3) ? dr.GetString(3) : "";
rd.jg = !dr.IsDBNull(4) ? dr.GetString(4) : "";
rds.Add(rd);
}
msg = "找到报告明细";
return(0);
}
else
{
rds = null;
msg = "未找到报告详细内容";
return(2);
}
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
rds = null;
return(-2);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
/// <summary>
/// 一个化验报告单抬头信息
/// </summary>
/// <param name="doctadviseno">条码号</param>
/// <param name="msg">出错信息</param>
/// <returns>0：成功 大于0：出错 小于0：异常</returns>
public int DB_LaboratoryTestsReportNameInformation(string doctadviseno, out AlipayReportInfo alipayReportInfo, out string msg)
{
msg = "";
alipayReportInfo = new AlipayReportInfo();
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
int ret = -1;
try
{
bool _flag = false;
double number = Convert.ToDouble(doctadviseno);
string findText = _builder.GetLaboratoryTestsReportNameInformation(number, out _flag, out msg);
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, findText);
if (!_flag)
{
return(10);
}
msg = "";
dr = DbHelperOra.ExecuteReader(findText, connection);
if (null != dr && dr.HasRows)
{
if (dr.Read())
{
alipayReportInfo.doctadviseno = !dr.IsDBNull(0) ? Convert.ToString(dr.GetInt64(0)) : "";
alipayReportInfo.requesttime = !dr.IsDBNull(1) ? dr.GetDateTime(1).ToString(AppUtils.DateTime_Format_All) : "";
alipayReportInfo.requester = !dr.IsDBNull(2) ? dr.GetString(2) : "";
alipayReportInfo.executetime = !dr.IsDBNull(3) ? dr.GetDateTime(3).ToString(AppUtils.DateTime_Format_All) : "";
alipayReportInfo.executer = !dr.IsDBNull(4) ? dr.GetString(4) : "";
alipayReportInfo.receivetime = !dr.IsDBNull(5) ? dr.GetDateTime(5).ToString(AppUtils.DateTime_Format_All) : "";
alipayReportInfo.receiver = !dr.IsDBNull(6) ? dr.GetString(6) : "";
alipayReportInfo.stayhospitalmode = !dr.IsDBNull(7) ? dr.GetString(7) : "";
alipayReportInfo.patientid = !dr.IsDBNull(8) ? dr.GetString(8) : "";
alipayReportInfo.section = !dr.IsDBNull(9) ? dr.GetString(9) : "";
alipayReportInfo.bedno = !dr.IsDBNull(10) ? dr.GetString(10) : "";
alipayReportInfo.patientname = !dr.IsDBNull(11) ? dr.GetString(11) : "";
alipayReportInfo.sex = !dr.IsDBNull(12) ? dr.GetString(12) : "";
alipayReportInfo.age = !dr.IsDBNull(13) ? dr.GetString(13) : "";
alipayReportInfo.diagnostic = !dr.IsDBNull(14) ? dr.GetString(14) : "";
alipayReportInfo.sampletype = !dr.IsDBNull(15) ? dr.GetString(15) : "";
alipayReportInfo.examinaim = !dr.IsDBNull(16) ? dr.GetString(16) : "";
alipayReportInfo.requestmode = !dr.IsDBNull(17) ? dr.GetString(17) : "";
alipayReportInfo.checker = !dr.IsDBNull(18) ? dr.GetString(18) : "";
alipayReportInfo.checktime = !dr.IsDBNull(19) ? dr.GetDateTime(19).ToString(AppUtils.DateTime_Format_All) : "";
alipayReportInfo.csyq = !dr.IsDBNull(20) ? dr.GetString(20) : "";
alipayReportInfo.profiletest = !dr.IsDBNull(21) ? dr.GetString(21) : "";
ret = 0;
}
}
else
{
msg = "未能找到报告单";
ret = 17;
}
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
return(AppUtils.Default_Exception_Code);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
/// <summary>
/// 门诊就诊病历列表
/// </summary>
/// <param name="openid">用户标识</param>
/// <param name="values">返回信息</param>
/// <param name="msg">出错信息</param>
/// <returns>0：成功 大于0：出错 小于0：异常</returns>
public int DB_mzMedicalRecordsList(string patientid, out ArrayList values, out string msg)
{
msg = "";
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
int ret = -1;
values = new ArrayList();
try
{
bool _flag = false;
string findText = _builder.GetmzMedicalRecordsListSql(patientid, out _flag, out msg);
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, findText);
if (!_flag)
{
ret = 10;
return(ret);
}
dr = DbHelperOra.ExecuteReader(findText, connection);
while (dr.Read())
{
mzMedicalRecords ri = new mzMedicalRecords();
ri.jzxh = !dr.IsDBNull(0) ? dr.GetString(0) : "";
ri.jzrq = !dr.IsDBNull(1) ? dr.GetDateTime(1).ToString(AppUtils.DateTime_Format_All) : " ";
ri.ksmc = !dr.IsDBNull(2) ? dr.GetString(2) : "";
ri.ysxm = !dr.IsDBNull(3) ? dr.GetString(3) : "";
ri.zdxx = !dr.IsDBNull(4) ? dr.GetString(4) : "";
values.Add(ri);
}
if (values.Count > 0)
{
msg = "找到病人信息";
ret = 0;
}
else
{
msg = "医院端未找到，请核对信息后重试";
values = null;
ret = 10;
}
dr.Close();
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
ret = -1;
return(ret);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
/// <summary>
/// 一个检验报告单详细列表信息
/// </summary>
/// <param name="doctadviseno">条码号</param>
/// <param name="msg">出错信息</param>
/// <returns>0：成功 大于0：出错 小于0：异常</returns>
public int DB_InspectionReportResultsInformation(string doctadviseno, out AlipayInspectionReport alipayInspectionReport, out string msg)
{
msg = "";
alipayInspectionReport = new AlipayInspectionReport();
OracleConnection oracleConnection = new OracleConnection(WebConfigParameter.ConnectionHisString);
SqlConnection sqlConnection = new SqlConnection(WebConfigParameter.ConnectionLisString);
OracleDataReader dr = null;
SqlDataReader myReader = null;
int ret = -1;
try
{
bool _flag = false;
string sqlstr = "";
string oraclestr = "";
_builder.GetDInspectionReportResultsInformation(doctadviseno, out sqlstr, out oraclestr, out _flag, out msg);
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, sqlstr);
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, oraclestr);
if (!_flag)
{
return(10);
}
msg = "";
dr = DbHelperOra.ExecuteReader(oraclestr, oracleConnection);
if (null != dr && dr.HasRows)
{
if (dr.Read())
{
alipayInspectionReport.studyresult = !dr.IsDBNull(0) ? dr.GetString(0) : "";
alipayInspectionReport.diagresult = !dr.IsDBNull(1) ? dr.GetString(1) : "";
ret = 0;
}
return(ret);
}
if (!string.IsNullOrEmpty(WebConfigParameter.ConnectionLisString))
{
myReader = DbHelperSQL.ExecuteReader(sqlstr, sqlConnection);
if (null != myReader && myReader.HasRows)
{
if (myReader.Read())
{
alipayInspectionReport.studyresult = !myReader.IsDBNull(0) ? myReader.GetString(0) : "";
alipayInspectionReport.diagresult = !myReader.IsDBNull(1) ? myReader.GetString(1) : "";
ret = 0;
}
}
}
else
{
msg = "未能找到报告单";
ret = 17;
}
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
return(AppUtils.Default_Exception_Code);
}
finally
{
if (null != dr)
{
dr.Close();
}
if (null != myReader)
{
myReader.Close();
}
oracleConnection.Close();
sqlConnection.Close();
oracleConnection.Close();
sqlConnection.Close();
}
}
/// <summary>
/// 一个化验报告单详细列表信息
/// </summary>
/// <param name="doctadviseno">条码号</param>
/// <param name="msg">出错信息</param>
/// <returns>0：成功 大于0：出错 小于0：异常</returns>
public int DB_LaboratoryTestsReportDetailedListInformation(string doctadviseno, out ArrayList values, out string msg)
{
msg = "";
values = new ArrayList();
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
try
{
bool _flag = false;
double number = Convert.ToDouble(doctadviseno);
string findText = _builder.GetLaboratoryTestsReportDetailedListInformation(number, out _flag, out msg);
if (!_flag)
{
return(10);
}
int ret = -1;
msg = "";
dr = DbHelperOra.ExecuteReader(findText, connection);
if (null != dr && dr.HasRows)
{
while (dr.Read())
{
AlipayReportdetailInfo ri = new AlipayReportdetailInfo();
ri.jylx = !dr.IsDBNull(0) ? dr.GetString(0) : "";
ri.xmmc = !dr.IsDBNull(1) ? dr.GetString(1) : "";
ri.result = !dr.IsDBNull(2) ? dr.GetString(2) : "";
ri.hint = !dr.IsDBNull(3) ? dr.GetString(3) : "";
ri.jkfw = !dr.IsDBNull(4) ? dr.GetString(4) : "";
ri.xmdw = !dr.IsDBNull(5) ? dr.GetString(5) : "";
values.Add(ri);
}
ret = 0;
}
else
{
values = null;
msg = "未能找到报告单";
ret = 17;
}
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
values = null;
msg = GetExceptionInfo(ex);
return(AppUtils.Default_Exception_Code);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
/// <summary>
/// 电子病历内容
/// </summary>
/// <param name="jzxh">就诊序号</param>
/// <returns>0-成功 大于0-失败 小于0-异常</returns>
public int DB_ElectronicMedicalRecordt(string jzxh, out mzMedicalRecords ri, out string msg)
{
msg = "";
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
int ret = -1;
ri = new mzMedicalRecords();
try
{
bool _flag = false;
string findText = _builder.GetElectronicMedicalRecordtSql(jzxh, out _flag, out msg);
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, findText);
if (!_flag)
{
ret = 10;
return(ret);
}
dr = DbHelperOra.ExecuteReader(findText, connection);
if (dr.Read())
{
ri.mzzs = !dr.IsDBNull(0) ? dr.GetString(0) : "";
ri.xbs = !dr.IsDBNull(1) ? dr.GetString(1) : "";
ri.jws = !dr.IsDBNull(2) ? dr.GetString(2) : "";
ri.grs = !dr.IsDBNull(3) ? dr.GetString(3) : "";
ri.gms = !dr.IsDBNull(4) ? dr.GetString(4) : "";
ri.hys = !dr.IsDBNull(5) ? dr.GetString(5) : "";
ri.jzs = !dr.IsDBNull(6) ? dr.GetString(6) : "";
ri.tgjc = !dr.IsDBNull(7) ? dr.GetString(7) : "";
ri.fzjc = !dr.IsDBNull(8) ? dr.GetString(8) : "";
ri.clyj = !dr.IsDBNull(9) ? dr.GetString(9) : "";
ret = 0;
}
else
{
msg = "医院端未找到，请核对信息后重试";
ret = 10;
}
dr.Close();
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
msg = GetExceptionInfo(ex);
ret = -1;
return(ret);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
/// <summary>
/// 根据条形码或者报告单号报告明细
/// </summary>
/// <param name="code">条形码或者报告单号</param>
/// <param name="lx">号码类型 1：报告单号 2条码查询</param>
/// <param name="values">报告信息</param>
/// <param name="msg">出错信息</param>
/// <returns>0：成功 大于0：出错 小于0：异常</returns>
public int DB_queryReportJCListByCode(string code, string lx, string brxm, out ArrayList values, out string msg)
{
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
values = new ArrayList();
try
{
bool _flag = false;
string sql = _builder.GetSqlReportJCDetail(code, lx, brxm, out _flag, out msg);
if (!_flag)
{
return(10);
}
int ret = -99;
msg = "";
dr = DbHelperOra.ExecuteReader(sql, connection);
if (dr.HasRows)
{
while (dr.Read())
{
ReportInfo ri = new ReportInfo();
ri.bgdh = !dr.IsDBNull(0) ? dr.GetString(0) : "";
ri.sjmd = !dr.IsDBNull(1) ? dr.GetString(1) : "";
ri.cjsj = !dr.IsDBNull(2) ? dr.GetString(2) : "";
ri.sjr = !dr.IsDBNull(3) ? dr.GetString(3) : "";
ri.jysj = !dr.IsDBNull(4) ? dr.GetString(4) : "";
ri.jyr = !dr.IsDBNull(5) ? dr.GetString(5) : "";
ri.shr = !dr.IsDBNull(6) ? dr.GetString(6) : "";
ri.jzch = !dr.IsDBNull(7) ? dr.GetString(7) : "";
ri.zdjg = !dr.IsDBNull(8) ? dr.GetString(8) : "";
ri.bbmc = !dr.IsDBNull(9) ? dr.GetString(9) : "";
ri.mzbz = !dr.IsDBNull(10) ? dr.GetString(10) : "";
ri.dyjb = !dr.IsDBNull(11) ? dr.GetString(11) : "";
ri.bz = !dr.IsDBNull(12) ? dr.GetString(12) : "";
ri.hzbh = !dr.IsDBNull(13) ? dr.GetString(13) : "";
ri.sbm = !dr.IsDBNull(14) ? dr.GetString(14) : "";
ri.brxm = !dr.IsDBNull(15) ? dr.GetString(15) : "";
ri.jgmc = WebConfigParameter.HospitalChinaName();
ICollection <ReportDetail> rds;
string child_msg;
int rtDetail = DB_queryReportJCDetail(ri.bgdh, out rds, out child_msg);
if (rtDetail == 0)
{
ri.details = rds;
}
else
{
msg += "[单号" + ri.bgdh + "详细查询错误]" + child_msg + ";";
ret = 3;
}
values.Add(ri);
}
ret = 0;
}
else
{
values = null;
msg = "未能找到该编号的报告单，请检查编号";
ret = 2;
}
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
values = null;
msg = GetExceptionInfo(ex);
return(AppUtils.Default_Exception_Code);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
/// <summary>
/// 检验报告单列表
/// </summary>
/// <param name="name">姓名</param>
/// <param name="idcardno">身份证号</param>
/// <param name="msg">出错信息</param>
/// <returns>0：成功 大于0：出错 小于0：异常</returns>
public int DB_InspectionReportList(string name, string idcardno, out ArrayList values, out string msg)
{
string _oracleConStr = WebConfigParameter.ConnectionHisString;
string _sqlConStr = WebConfigParameter.ConnectionLisString;
values = new ArrayList();
OracleConnection oracleConnection = new OracleConnection(_oracleConStr);
SqlConnection sqlConnection = new SqlConnection(_sqlConStr);
OracleDataReader dr = null;
SqlDataReader myReader = null;
try
{
bool _flag = false;
string sqlstr = "";
string oraclestr = "";
_builder.GetInspectionReportList(name, idcardno, out sqlstr, out oraclestr, out _flag, out msg);
if (!_flag)
{
return(10);
}
int ret = -1;
msg = "";
if (!string.IsNullOrEmpty(_sqlConStr))
{
myReader = DbHelperSQL.ExecuteReader(sqlstr, sqlConnection);
if (null != myReader && myReader.HasRows)
{
while (myReader.Read())
{
AlipayReportList ri = new AlipayReportList();
ri.doctadviseno = !myReader.IsDBNull(0) ? myReader.GetString(0) : "";
ri.examinaim = !myReader.IsDBNull(1) ? myReader.GetString(1) : "";
ri.requesttime = !myReader.IsDBNull(2) ? myReader.GetDateTime(2).ToString(AppUtils.DateTime_Format_All) : "";
ri.requester = !myReader.IsDBNull(3) ? myReader.GetString(3) : "";
values.Add(ri);
}
}
}
dr = DbHelperOra.ExecuteReader(oraclestr, oracleConnection);
if (null != dr && dr.HasRows)
{
while (dr.Read())
{
AlipayReportList ri = new AlipayReportList();
ri.doctadviseno = !dr.IsDBNull(0) ? dr.GetString(0) : "";
ri.examinaim = !dr.IsDBNull(1) ? dr.GetString(1) : "";
ri.requesttime = !dr.IsDBNull(2) ? dr.GetDateTime(2).ToString(AppUtils.DateTime_Format_All) : "";
ri.requester = !dr.IsDBNull(3) ? dr.GetString(3) : "";
values.Add(ri);
}
}
if (values.Count > 0)
{
ret = 0;
}
else
{
values = null;
msg = "未能找到报告单";
ret = 17;
}
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
values = null;
msg = GetExceptionInfo(ex);
return(AppUtils.Default_Exception_Code);
}
finally
{
if (null != dr)
{
dr.Close();
}
if (null != myReader)
{
myReader.Close();
}
oracleConnection.Close();
sqlConnection.Close();
}
}
/// <summary>
/// 查询报告单列表(根据病人ID）
/// </summary>
/// <param name="brid">病人ID</param>
/// <param name="brlx">病人类型 1:门诊病人 2:住院病人</param>
/// <param name="values">报告单信息</param>
/// <param name="msg">出错信息</param>
/// <returns>0：成功 大于0：出错 小于0：异常</returns>
public int DB_queryReportJCListByBRID(string brid, string brlx, out ArrayList values, out string msg)
{
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
values = new ArrayList();
try
{
bool _flag = false;
string sql = _builder.GetSqlReportJCListForWzscnxdyrmyy(brid, brlx, out _flag, out msg);
if (!_flag)
{
return(10);
}
int ret = -1;
msg = "";
dr = DbHelperOra.ExecuteReader(sql, connection);
if (dr.HasRows)
{
while (dr.Read())
{
ReportInfo ri = new ReportInfo();
ri.bgdh = !dr.IsDBNull(0) ? dr.GetString(0) : "";
ri.sjmd = !dr.IsDBNull(1) ? dr.GetString(1) : "";
ri.jysj = !dr.IsDBNull(2) ? dr.GetString(2) : "";
ri.jgmc = WebConfigParameter.HospitalChinaName();
values.Add(ri);
}
ret = 0;
}
else
{
values = null;
msg = "未能找到报告单";
ret = 2;
}
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
values = null;
msg = GetExceptionInfo(ex);
return(AppUtils.Default_Exception_Code);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
/// <summary>
/// 化验报告单列表
/// </summary>
/// <param name="name">姓名</param>
/// <param name="idcardno">身份证号</param>
/// <param name="msg">出错信息</param>
/// <returns>0：成功 大于0：出错 小于0：异常</returns>
public int DB_AilpayQueryReport(string name, string idcardno, out ArrayList values, out string msg)
{
string _oracleConStr = WebConfigParameter.ConnectionHisString;
values = new ArrayList();
OracleConnection connection = new OracleConnection(_oracleConStr);
OracleDataReader dr = null;
try
{
bool _flag = false;
string sql = _builder.GetSqlAilpayReportList(name, idcardno, out _flag, out msg);
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, sql);
if (!_flag)
{
return(10);
}
int ret = -1;
msg = "";
dr = DbHelperOra.ExecuteReader(sql, connection);
if (null != dr && dr.HasRows)
{
while (dr.Read())
{
AlipayReportList ri = new AlipayReportList();
ri.doctadviseno = !dr.IsDBNull(0) ? Convert.ToString(dr.GetInt64(0)) : "";
ri.examinaim = !dr.IsDBNull(1) ? dr.GetString(1) : "";
ri.requesttime = !dr.IsDBNull(2) ? dr.GetDateTime(2).ToString(AppUtils.DateTime_Format_All) : "";
ri.requester = !dr.IsDBNull(3) ? dr.GetString(3) : "";
values.Add(ri);
}
ret = 0;
}
else
{
values = null;
msg = "未能找到报告单";
ret = 17;
}
return(ret);
}
catch (Exception ex)
{
UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
values = null;
msg = GetExceptionInfo(ex);
return(AppUtils.Default_Exception_Code);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}
