public HttpResponseMessage PostNotification(PsNotification Item) { int ret = repository.PsNotificationSetData(pclsCache, Item.AccepterID, Item.NotificationType, Item.Title, Item.Description, Item.SendTime, Item.SenderID, Item.Status, Item.Redundance, Item.piUserId, Item.piTerminalName, Item.piTerminalIP, Item.piDeviceType); return new ExceptionHandler().SetData(Request, ret); }
/// <summary> /// 根据Status取数据——SYF 20151215 /// </summary> /// <param name="pclsCache"></param> /// <param name="AccepterID"></param> /// <param name="NotificationType"></param> /// <param name="Status"></param> /// <returns></returns> public List<PsNotification> PsNotificationGetDataByStatus(DataConnection pclsCache, string AccepterID, string NotificationType, string Status) { if (Status == "{Status}") Status = "-1"; List<PsNotification> list = new List<PsNotification>(); CacheCommand cmd = null; CacheDataReader cdr = null; try { if (!pclsCache.Connect()) { //MessageBox.Show("Cache数据库连接失败"); return null; } cmd = new CacheCommand(); cmd = Ps.Notification.GetDataByStatus(pclsCache.CacheConnectionObject); cmd.Parameters.Add("AccepterID", CacheDbType.NVarChar).Value = AccepterID; cmd.Parameters.Add("NotificationType", CacheDbType.NVarChar).Value = NotificationType; cmd.Parameters.Add("Status", CacheDbType.NVarChar).Value = Status; cdr = cmd.ExecuteReader(); while (cdr.Read()) { PsNotification NewLine = new PsNotification(); NewLine.AccepterID = cdr["AccepterID"].ToString(); NewLine.NotificationType = cdr["NotificationType"].ToString(); NewLine.SortNo = cdr["SortNo"].ToString(); NewLine.Title = cdr["Title"].ToString(); NewLine.Description = cdr["Description"].ToString(); NewLine.SendTime = cdr["SendTime"].ToString(); NewLine.SenderID = cdr["SenderID"].ToString(); NewLine.SenderName = cdr["SenderName"].ToString(); NewLine.Status = cdr["Status"].ToString(); list.Add(NewLine); } return list; } catch (Exception ex) { HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "MessageMethod.PsNotificationGetDataByStatus", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); return null; } finally { if ((cdr != null)) { cdr.Close(); cdr.Dispose(true); cdr = null; } if ((cmd != null)) { cmd.Parameters.Clear(); cmd.Dispose(); cmd = null; } pclsCache.DisConnect(); } }