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