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); }