/// <summary>
/// 患者信息表
/// </summary>
/// <param name="DealRecordID"></param>
/// <param name="VehicleNo"></param>
/// <returns></returns>
public bool GetSuffererData(string DealRecordID, string VehicleNo, string XZBM)
{
bool Vehicle = false;
try
{
string sql = "select lsh from HZXXB t where lsh='" + DealRecordID + "'and clbh='" + VehicleNo + "' and xzbm='" + XZBM + "'";
object obj = DBHelperOracle.GetSingle(sql);
if (obj != null)
{
Vehicle = true;
}
}
catch (Exception ex)
{
LOG.LogHelper.WriteLog("GetSuffererDataData", ex);
}
return(Vehicle);
}
/// <summary>
/// 查询受理记录是否存在
/// </summary>
/// <param name="DealRecordID"></param>
/// <returns></returns>
public bool GetBoolDealData(string DealRecordID, string XZBM)
{
bool DealData = false;
try
{
string sql = "select lsh from sljlb t where lsh='" + DealRecordID + "' and xzbm='" + XZBM + "'";
object obj = DBHelperOracle.GetSingle(sql);
if (obj != null)
{
DealData = true;
}
}
catch (Exception ex)
{
LOG.LogHelper.WriteLog("GetBoolDealData", ex);
}
return(DealData);
}
/// <summary>
/// 查询车辆信息是否存在
/// </summary>
/// <param name="VehicleCode"></param>
/// <param name="Mobile"></param>
/// <returns></returns>
public bool GetBoolVehicleData(string clbh, string XZBM)
{
bool Vehicle = false;
try
{
string sql = "select clbh from clxxb where clbh='" + clbh + "' and xzbm='" + XZBM + "'";
object obj = DBHelperOracle.GetSingle(sql);
if (obj != null)
{
Vehicle = true;
}
}
catch (Exception ex)
{
LOG.LogHelper.WriteLog("GetBoolVehicleData", ex);
}
return(Vehicle);
}
/// <summary>
/// 查询人员信息是否存在
/// </summary>
/// <param name="VehicleCode"></param>
/// <returns></returns>
public bool GetBoolSysUserData(string UserName, string XZBM)
{
bool SysUser = false;
try
{
string sql = "select xm from xtryb t where rybh='" + UserName + "' and xzbm='" + XZBM + "'";
object obj = DBHelperOracle.GetSingle(sql);
if (obj != null)
{
SysUser = true;
}
}
catch (Exception ex)
{
LOG.LogHelper.WriteLog("GetBoolSysUserData", ex);
}
return(SysUser);
}
/// <summary>
/// 查询车辆编号
/// </summary>
/// <param name="DealRecordID">流水号</param>
/// <param name="Mobile">手机号</param>
/// <returns></returns>
public string GetVehicleNo(string Mobile, string XZBM)
{
string clbh = "";
try
{
string sql = "select clbh from clxxb where CZDH='" + Mobile + "' and xzbm='" + XZBM + "'";
object obj = DBHelperOracle.GetSingle(sql);
if (obj != null)
{
clbh = obj.ToString();
}
}
catch (Exception ex)
{
LOG.LogHelper.WriteLog("GetVehicleNo", ex);
}
return(clbh);
}