public void GetResendMessages()
{
try
{
String condition = "M_STATE='1'";
TTRD_AIDSYS_MSG_LOG_Manager manager = new TTRD_AIDSYS_MSG_LOG_Manager();
DataTable table = manager.LogQuery(condition);
foreach (DataRow row in table.Rows)
{
try
{
MessageData data = new MessageData();
data.MessageID = new Guid(row["M_ID"].ToString());
data.BizMsgID = row["M_SERIALNO"].ToString();
data.FirstTime = Convert.ToDateTime(row["M_SENDDATE"].ToString());
data.TragetPlatform = (PlatformType)Convert.ToInt32(row["M_PLATTYPE"].ToString());
data.IsMultiPackage = Convert.ToInt32(row["M_ISSINGLE"]) != 1;
data.ReqPackageList.Enqueue(new PackageData(Convert.ToInt16(row["M_SUBID"]), (byte[])row["M_S_CONTENT"]));
_msgList.Add(data);
}
catch (Exception)
{
continue;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private void RecordDB(String result, MessageData msg)
{
if (msg != null)
{
TTRD_AIDSYS_MSG_LOG logrow = new TTRD_AIDSYS_MSG_LOG();
logrow.M_ID = msg.MessageID.ToString();
logrow.M_ERROR = result;
logrow.M_STATE = "1";
logrow.M_S_CONTENT = msg.CurrentReqPackage.PackageMessage;
logrow.M_SUBID = msg.CurrentReqPackage.PackageID;
logrow.M_SERIALNO = msg.BizMsgID;
logrow.M_ISSINGLE = msg.IsMultiPackage ? "0" : "1";
logrow.M_PLATTYPE = (int)msg.TragetPlatform;
logrow.M_SENDDATE = msg.FirstTime.ToString("yyyy-MM-dd HH:mm:ss");
TTRD_AIDSYS_MSG_LOG_Manager manager = new TTRD_AIDSYS_MSG_LOG_Manager();
manager.LogInsert(logrow);
}
}
public static String RetrieveDBTypeFromDB(Guid msgid)
{
try
{
if (msgid != Guid.Empty)
{
TTRD_AIDSYS_MSG_LOG_Manager manager = new TTRD_AIDSYS_MSG_LOG_Manager();
StringBuilder sb = new StringBuilder();
sb.AppendFormat("M_ID={0}", msgid.ToString());
DataTable table = manager.LogQuery(sb.ToString());
if (table != null && table.Rows.Count == 1)
{
return table.Rows[0]["MsgDataType"].ToString();
}
}
}
catch (Exception)
{
return String.Empty;
}
return String.Empty;
}
private void UpdateLogDB( MessageData msg)
{
TTRD_AIDSYS_MSG_LOG logrow = new TTRD_AIDSYS_MSG_LOG();
logrow.M_ID = msg.MessageID.ToString();
logrow.M_STATE = "0";
TTRD_AIDSYS_MSG_LOG_Manager manager = new TTRD_AIDSYS_MSG_LOG_Manager();
manager.LogUpdate(logrow);
return;
}
private void DBActionTest(MessageData msgdata)
{
String ouno = textBoxOrgNO.Text.TrimStart();
String tellno = textBoxTellerNO.Text.TrimStart();
String internalID = textBoxInternalID.Text.TrimStart();
TTRD_AIDSYS_MSG_LOG row = new TTRD_AIDSYS_MSG_LOG();
row.M_ID = msgdata.MessageID.ToString();
row.M_S_CONTENT = msgdata.CurrentReqPackage.PackageMessage;
row.M_ISSINGLE = msgdata.IsMultiPackage ? "0" : "1";
row.M_ERROR = "Test DB msg";
row.M_SENDDATE = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
row.M_STATE = "1";
row.M_SUBID = 1;
row.I_ID = ouno;
row.U_ID = tellno;
row.M_PLATTYPE = (int)msgdata.TragetPlatform;
TTRD_AIDSYS_MSG_LOG_Manager manager = new TTRD_AIDSYS_MSG_LOG_Manager();
manager.LogInsert(row);
}
