public CheckInformation GetCheckInformation()
{
DirectoryInfo dirinfo = new DirectoryInfo(InPath);
FileInfo[] files;
if (dirinfo.Exists)
{
files = dirinfo.GetFiles("*.xml");
if (files.Length > 0)
{
FileComparer fc = new FileComparer();
Array.Sort(files, fc);
CheckInformation info = CheckInformation.LoadFromXmlFile(files[0].FullName);
return(info);
}
else
{
return(new CheckInformation()
{
LoadSuccess = false, ExceptionMessage = "存放客户信息的路径里无客户信息文件。 " + InPath
});
}
}
else
{
return(new CheckInformation()
{
LoadSuccess = false, ExceptionMessage = "存放客户信息的文件夹不存在，请核对配置文件或者启动参数的路径是否正确。 " + InPath
});
}
}
/// <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();
}
}
