public IHttpActionResult SendMessage(dynamic model) { WebApi_BLL.T_System_Messages tsmbll = new WebApi_BLL.T_System_Messages(); WebApi_Model.T_System_Messages message = (WebApi_Model.T_System_Messages)Newtonsoft.Json.JsonConvert.DeserializeObject(model, typeof(WebApi_Model.T_System_Messages)); int id = tsmbll.Add(message); message.IsView = 0; message.IsDelete = 0; message.PostDate = DateTime.Now; message.MessageID = id; return(Ok(ReturnJsonResult.GetJsonResult(1, "OK", JsonConvert.SerializeObject(message)))); }
public IHttpActionResult ViewMessage(int UID, int MessageID) { WebApi_BLL.T_System_Messages tsmbll = new WebApi_BLL.T_System_Messages(); WebApi_Model.T_System_Messages message = tsmbll.GetModel(MessageID); if (message != null && message.ToUID == UID) { message.IsView = 1; tsmbll.Update(message); } else { return(Ok(ReturnJsonResult.GetJsonResult(-1, "Error", JsonConvert.SerializeObject("无法找到消息!")))); } return(Ok(ReturnJsonResult.GetJsonResult(1, "OK", JsonConvert.SerializeObject(message)))); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebApi_Model.T_System_Messages model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_System_Messages set "); strSql.Append("MessageTitle=@MessageTitle,"); strSql.Append("MessageContent=@MessageContent,"); strSql.Append("ToUID=@ToUID,"); strSql.Append("LinkURL=@LinkURL,"); strSql.Append("IsView=@IsView,"); strSql.Append("PostDate=@PostDate,"); strSql.Append("IsDelete=@IsDelete"); strSql.Append(" where MessageID=@MessageID"); SqlParameter[] parameters = { new SqlParameter("@MessageTitle", SqlDbType.NVarChar, 100), new SqlParameter("@MessageContent", SqlDbType.NVarChar, 500), new SqlParameter("@ToUID", SqlDbType.Int, 4), new SqlParameter("@LinkURL", SqlDbType.NVarChar, 150), new SqlParameter("@IsView", SqlDbType.Int, 4), new SqlParameter("@PostDate", SqlDbType.DateTime), new SqlParameter("@IsDelete", SqlDbType.Int, 4), new SqlParameter("@MessageID", SqlDbType.Int, 4) }; parameters[0].Value = model.MessageTitle; parameters[1].Value = model.MessageContent; parameters[2].Value = model.ToUID; parameters[3].Value = model.LinkURL; parameters[4].Value = model.IsView; parameters[5].Value = model.PostDate; parameters[6].Value = model.IsDelete; parameters[7].Value = model.MessageID; int rows = DBHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebApi_Model.T_System_Messages DataRowToModel(DataRow row) { WebApi_Model.T_System_Messages model = new WebApi_Model.T_System_Messages(); if (row != null) { if (row["MessageID"] != null && row["MessageID"].ToString() != "") { model.MessageID = int.Parse(row["MessageID"].ToString()); } if (row["MessageTitle"] != null) { model.MessageTitle = row["MessageTitle"].ToString(); } if (row["MessageContent"] != null) { model.MessageContent = row["MessageContent"].ToString(); } if (row["ToUID"] != null && row["ToUID"].ToString() != "") { model.ToUID = int.Parse(row["ToUID"].ToString()); } if (row["LinkURL"] != null) { model.LinkURL = row["LinkURL"].ToString(); } if (row["IsView"] != null && row["IsView"].ToString() != "") { model.IsView = int.Parse(row["IsView"].ToString()); } if (row["PostDate"] != null && row["PostDate"].ToString() != "") { model.PostDate = DateTime.Parse(row["PostDate"].ToString()); } if (row["IsDelete"] != null && row["IsDelete"].ToString() != "") { model.IsDelete = int.Parse(row["IsDelete"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(WebApi_Model.T_System_Messages model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_System_Messages("); strSql.Append("MessageTitle,MessageContent,ToUID,LinkURL,IsView,PostDate,IsDelete)"); strSql.Append(" values ("); strSql.Append("@MessageTitle,@MessageContent,@ToUID,@LinkURL,@IsView,@PostDate,@IsDelete)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MessageTitle", SqlDbType.NVarChar, 100), new SqlParameter("@MessageContent", SqlDbType.NVarChar, 500), new SqlParameter("@ToUID", SqlDbType.Int, 4), new SqlParameter("@LinkURL", SqlDbType.NVarChar, 150), new SqlParameter("@IsView", SqlDbType.Int, 4), new SqlParameter("@PostDate", SqlDbType.DateTime), new SqlParameter("@IsDelete", SqlDbType.Int, 4) }; parameters[0].Value = model.MessageTitle; parameters[1].Value = model.MessageContent; parameters[2].Value = model.ToUID; parameters[3].Value = model.LinkURL; parameters[4].Value = model.IsView; parameters[5].Value = model.PostDate; parameters[6].Value = model.IsDelete; object obj = DBHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebApi_Model.T_System_Messages GetModel(int MessageID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 MessageID,MessageTitle,MessageContent,ToUID,LinkURL,IsView,PostDate,IsDelete from T_System_Messages "); strSql.Append(" where MessageID=@MessageID"); SqlParameter[] parameters = { new SqlParameter("@MessageID", SqlDbType.Int, 4) }; parameters[0].Value = MessageID; WebApi_Model.T_System_Messages model = new WebApi_Model.T_System_Messages(); DataSet ds = DBHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }