public static DataTable QueryMQLog(string condition, out string exception)
{
exception = "";
try
{
TTRD_SET_MSG_LOG_Manager manager = new TTRD_SET_MSG_LOG_Manager();
return manager.LogQuery(condition);
}
catch (Exception ex)
{
exception = ex.Message;
xQuant.Log4.LogHelper.Write(xQuant.Log4.LogLevel.Error, string.Format("<MQMsgCommonHelper-QueryMQLog> Exception:{0}; StatkTrace:{1}.", ex.Message, ex.StackTrace));
return null;
}
}
/// <summary>
/// 把支付交易序号更新为资金流水号，只适用来账销账
/// </summary>
/// <param name="msgdata"></param>
/// <param name="paysn"></param>
/// <param name="hostflow"></param>
/// <param name="error"></param>
/// <param name="state"></param>
/// <param name="exception"></param>
/// <returns></returns>
public static int UpdateMQLog(MessageData msgdata, string paysn, string hostflow, string error, MsgLogState state, out string exception)
{
exception = "";
try
{
TTRD_SET_MSG_LOG log = new TTRD_SET_MSG_LOG();
log.GUID = msgdata.MessageID.ToString();
log.FLOW_NO = paysn;
log.USER_CODE = msgdata.TellerNO;
log.INS_ID = msgdata.OrgNO;
//log.IS_MUL_PKG = msgdata.IsMultiPackage ? "1" : "0";
log.HOSTFLOW_NO = hostflow;
log.MSGTYPE = msgdata.MsgBizType;
log.PLATFORMTYPE = (int)msgdata.TragetPlatform;
log.RESP_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
log.RECV_CONTENT = msgdata.CurrentRespPackage.PackageMessage;
log.STATE = (int)state;
if (!string.IsNullOrEmpty(error))
{
log.ERRINFO = error;
}
int count = 0;
using (TransactionScope trans = new TransactionScope(TransactionScopeOption.RequiresNew))
{
TTRD_SET_MSG_LOG_Manager manager = new TTRD_SET_MSG_LOG_Manager();
count = manager.LogUpdate(log);
trans.Complete();
}
return count;
}
catch (Exception ex)
{
exception = ex.Message;
xQuant.Log4.LogHelper.Write(xQuant.Log4.LogLevel.Error, string.Format("<MQMsgCommonHelper-UpdateMQLog> Exception:{0}; StatkTrace:{1}.", ex.Message, ex.StackTrace));
return 0;
//throw ex;
}
}
// 只适合更新日志状态
public static int UpdateMQLog(Guid guid, string error, MsgLogState state, out string exception)
{
exception = "";
try
{
TTRD_SET_MSG_LOG log = new TTRD_SET_MSG_LOG();
log.GUID = guid.ToString();
log.STATE = (int)state;
if (!string.IsNullOrEmpty(error))
{
log.ERRINFO = error;
}
int count = 0;
using (TransactionScope trans = new TransactionScope(TransactionScopeOption.RequiresNew))
{
TTRD_SET_MSG_LOG_Manager manager = new TTRD_SET_MSG_LOG_Manager();
count = manager.LogUpdate(log);
trans.Complete();
}
return count;
}
catch (Exception ex)
{
exception = ex.Message;
xQuant.Log4.LogHelper.Write(xQuant.Log4.LogLevel.Error, string.Format("<MQMsgCommonHelper-UpdateMQLog> Exception:{0}; StatkTrace:{1}.", ex.Message, ex.StackTrace));
return 0;
//throw ex;
}
}
public static int AddMQLog(MessageData msgdata, byte[] senddata, MsgLogState state, out string exception)
{
exception = "";
try
{
TTRD_SET_MSG_LOG log = new TTRD_SET_MSG_LOG();
log.GUID = msgdata.MessageID.ToString();
log.FLOW_NO = msgdata.BizMsgID??"";
log.USER_CODE = msgdata.TellerNO;
log.INS_ID = msgdata.OrgNO;
log.IS_MUL_PKG = msgdata.IsMultiPackage ? "1" : "0";
log.MSGTYPE = msgdata.MsgBizType;
log.PLATFORMTYPE = (int)msgdata.TragetPlatform;
log.SEND_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
log.SEND_CONTENT = senddata;
log.STATE = (int)state;
int count = 0;
using (TransactionScope trans = new TransactionScope(TransactionScopeOption.RequiresNew))
{
TTRD_SET_MSG_LOG_Manager manager = new TTRD_SET_MSG_LOG_Manager();
count = manager.LogInsert(log);
trans.Complete();
}
return count;
}
catch(Exception ex)
{
exception = ex.Message;
xQuant.Log4.LogHelper.Write(xQuant.Log4.LogLevel.Error, string.Format("<MQMsgCommonHelper-AddMQLog> Exception:{0}; StatkTrace:{1}.", ex.Message, ex.StackTrace));
return 0;
}
}