/// <summary> /// 构造一个MQ消息对象 /// </summary> /// <param name="message"></param> /// <param name="prod"></param> /// <returns></returns> private anyType2anyTypeMapEntry[] BuildMQMessage(OAMQMessage message) { var receiveTime = DateTime.Now; var paramList = new Dictionary <string, string>(); paramList.Add("syscode", ConfigurationManager.AppSettings["OA.SysCode"]); paramList.Add("flowid", message.ProcessID); paramList.Add("requestname", message.Title); paramList.Add("workflowname", message.Flowtype); paramList.Add("nodename", message.Nodename); paramList.Add("pcurl", SSOToolkit.Instance.GetAuthOAUrlWithSSO(message.PtpUrl.Trim(), message.Userid, message.FlowID)); if (message.Nodename == "填报人") { paramList.Add("appurl", ""); } else { var url = System.Configuration.ConfigurationManager.AppSettings["WebURL"]; paramList.Add("appurl", url + SSOToolkit.Instance.GetAuthOAUrlWithSSO(message.MobileUrl.Trim(), message.Userid, message.FlowID)); } //paramList.Add("appurl", SSOToolkit.Instance.GetAuthOAUrlWithSSO(message.MobileUrl.Trim(), message.Userid, message.FlowID)); paramList.Add("creator", message.Creator); paramList.Add("isremark", message.Flowmess.ToString()); paramList.Add("viewtype", "0"); paramList.Add("createdatetime", message.Createtime.ToString("yyyy-MM-dd HH:mm:ss")); paramList.Add("receiver", message.Userid); paramList.Add("receivedatetime", receiveTime.ToString("yyyy-MM-dd HH:mm:ss")); var array = paramList.Select(x => new Plugin.OAMessage.OAMessage.WebServices.anyType2anyTypeMapEntry() { key = x.Key, value = x.Value }).ToArray(); return(array); }
private anyType2anyTypeMapEntry[] BuildMQMessageDelete(OAMQMessage message) { var paramList = new Dictionary <string, string>(); paramList.Add("syscode", ConfigurationManager.AppSettings["OA.SysCode"]); paramList.Add("flowid", message.FlowID); paramList.Add("userid", message.Userid); var array = paramList.Select(x => new Plugin.OAMessage.OAMessage.WebServices.anyType2anyTypeMapEntry() { key = x.Key, value = x.Value }).ToArray(); return(array); }
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); }
public int Update(OAMQMessage message) { return(this.DataSource.Update(message)); }