public List <Entities.OAMQMessage> LoadList(int count)
{
List <OAMQMessage> list = new List <OAMQMessage>();
string senderCodeSQL = BPF.OAMQServices.OAMQBll.Instance.SendMode == 2 ? ",SenderCode" : "";
string oracleQuery = @"SELECT MessageId,
Sender,
Sendertime,
Flowtype,
FlowID,
Title,
Nodename,
PtpUrl,
Userid,
Creator,
Createtime,
Operatetime,
Flowmess,
Viewtype,
Status,
ErrorCount,
MessageCreateTime,
AllowMobile"
+ senderCodeSQL
+ @" FROM (SELECT MessageId,
Sender,
Sendertime,
Flowtype,
FlowID,
Title,
Nodename,
PtpUrl,
Userid,
Creator,
Createtime,
Operatetime,
Flowmess,
Viewtype,
Status,
ErrorCount,
MessageCreateTime,
AllowMobile"
+ senderCodeSQL
+ @" FROM OAMQMessages
WHERE Status = 0
ORDER BY Sendertime ASC)
WHERE ROWNUM <= " + count + @"
ORDER BY ROWNUM ASC ;";
DbCommand cmd = this.DbConnection.CreateCommand();
cmd.CommandText = oracleQuery;
DbDataAdapter dbDataAdapter = this.DbFactory.CreateDataAdapter();
dbDataAdapter.SelectCommand = cmd;
DataSet dataSet = new DataSet();
if (dbDataAdapter.Fill(dataSet) > 0 &&
dataSet.Tables != null &&
dataSet.Tables.Count > 0 &&
dataSet.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
OAMQMessage message = null;
System.Data.DataRow row = dataSet.Tables[0].Rows[i];
foreach (object o in row.ItemArray)
{
message = new OAMQMessage()
{
MessageId = DataTypeHelper.GetString(row["MessageId"]),
Sender = DataTypeHelper.GetString(row["Sender"]),
Sendertime = DataTypeHelper.GetDateTime(row["Sendertime"]),
Flowtype = DataTypeHelper.GetString(row["Flowtype"]),
FlowID = DataTypeHelper.GetString(row["FlowID"]),
Title = DataTypeHelper.GetString(row["Title"]),
Nodename = DataTypeHelper.GetString(row["Nodename"]),
PtpUrl = DataTypeHelper.GetString(row["PtpUrl"]),
Userid = DataTypeHelper.GetString(row["Userid"]),
Creator = DataTypeHelper.GetString(row["Creator"]),
Createtime = DataTypeHelper.GetDateTime(row["Createtime"]),
Operatetime = DataTypeHelper.GetDateTime(row["Operatetime"]),
Flowmess = DataTypeHelper.GetInt(row["Flowmess"]),
Viewtype = DataTypeHelper.GetInt(row["Viewtype"]),
Status = DataTypeHelper.GetInt(row["Status"]),
ErrorCount = DataTypeHelper.GetInt(row["ErrorCount"]),
MessageCreateTime = DataTypeHelper.GetDateTime(row["MessageCreateTime"]),
AllowMobile = DataTypeHelper.GetInt(row["AllowMobile"])
};
if (BPF.OAMQServices.OAMQBll.Instance.SendMode == 2)
{
message.SenderCode = DataTypeHelper.GetString(row["SenderCode"]);
}
}
list.Add(message);
}
}
return(list);
}