/// <summary> /// 根据ID得到一个对象实体 /// </summary> public List <AdminSiteNewsModel> GetTop3ModelListByUserID(int userid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 3 ID, IsUrgent, IsTop, STitle, SContent, SendUserID, SendUserName, ReceiveUserID, ReceiveUserName, SStatus, SAddTime "); strSql.Append(" from AdminSiteNews "); strSql.Append(" where ReceiveUserID=@userID AND SStatus IN (1,2) "); strSql.Append(" ORDER BY IsTop DESC,ID DESC "); SqlParameter[] parameters = { new SqlParameter("@userID", SqlDbType.Int) }; parameters[0].Value = userid; List <AdminSiteNewsModel> list = new List <AdminSiteNewsModel>(); DataSet ds = helper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow item in ds.Tables[0].Rows) { AdminSiteNewsModel model = new AdminSiteNewsModel(); if (item["ID"].ToString() != "") { model.ID = int.Parse(item["ID"].ToString()); } if (item["IsUrgent"].ToString() != "") { model.IsUrgent = int.Parse(item["IsUrgent"].ToString()); } if (item["IsTop"].ToString() != "") { model.IsTop = int.Parse(item["IsTop"].ToString()); } model.STitle = item["STitle"].ToString(); model.SContent = item["SContent"].ToString(); if (item["SendUserID"].ToString() != "") { model.SendUserID = int.Parse(item["SendUserID"].ToString()); } model.SendUserName = item["SendUserName"].ToString(); if (item["ReceiveUserID"].ToString() != "") { model.ReceiveUserID = int.Parse(item["ReceiveUserID"].ToString()); } model.ReceiveUserName = item["ReceiveUserName"].ToString(); if (item["SStatus"].ToString() != "") { model.SStatus = int.Parse(item["SStatus"].ToString()); } if (item["SAddTime"].ToString() != "") { model.SAddTime = DateTime.Parse(item["SAddTime"].ToString()); } list.Add(model); } } return(list); }
/// <summary> /// 根据ID得到一个对象实体 /// </summary> public AdminSiteNewsModel GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID, IsUrgent, IsTop, STitle, SContent, SendUserID, SendUserName, ReceiveUserID, ReceiveUserName, SStatus, SAddTime "); strSql.Append(" from AdminSiteNews "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int) }; parameters[0].Value = ID; AdminSiteNewsModel model = new AdminSiteNewsModel(); DataSet ds = helper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["IsUrgent"].ToString() != "") { model.IsUrgent = int.Parse(ds.Tables[0].Rows[0]["IsUrgent"].ToString()); } if (ds.Tables[0].Rows[0]["IsTop"].ToString() != "") { model.IsTop = int.Parse(ds.Tables[0].Rows[0]["IsTop"].ToString()); } model.STitle = ds.Tables[0].Rows[0]["STitle"].ToString(); model.SContent = ds.Tables[0].Rows[0]["SContent"].ToString(); if (ds.Tables[0].Rows[0]["SendUserID"].ToString() != "") { model.SendUserID = int.Parse(ds.Tables[0].Rows[0]["SendUserID"].ToString()); } model.SendUserName = ds.Tables[0].Rows[0]["SendUserName"].ToString(); if (ds.Tables[0].Rows[0]["ReceiveUserID"].ToString() != "") { model.ReceiveUserID = int.Parse(ds.Tables[0].Rows[0]["ReceiveUserID"].ToString()); } model.ReceiveUserName = ds.Tables[0].Rows[0]["ReceiveUserName"].ToString(); if (ds.Tables[0].Rows[0]["SStatus"].ToString() != "") { model.SStatus = int.Parse(ds.Tables[0].Rows[0]["SStatus"].ToString()); } if (ds.Tables[0].Rows[0]["SAddTime"].ToString() != "") { model.SAddTime = DateTime.Parse(ds.Tables[0].Rows[0]["SAddTime"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 根据用户ID得到对应的系统公告 /// </summary> public static List <AdminSiteNewsModel> GetModelListByUserID(int userid, int topnum = 100) { StringBuilder strSql = new StringBuilder(); strSql.Append("select TOP " + topnum); strSql.Append(" ID, IsUrgent, IsTop, STitle, SContent, SendUserID, SendUserName, ReceiveUserID, ReceiveUserName, SStatus,case SStatus when 1 then '发布' when 2 then '已阅' when 3 then '已删除' end as SStatusName , SAddTime "); strSql.Append(" from AdminSiteNews "); strSql.Append(" where ReceiveUserID IN (" + userid.ToString() + ",0) "); strSql.Append(" ORDER BY IsUrgent DESC,IsTop DESC,ID DESC "); List <AdminSiteNewsModel> list = new List <AdminSiteNewsModel>(); DataSet ds = helper.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow item in ds.Tables[0].Rows) { AdminSiteNewsModel model = new AdminSiteNewsModel(); if (item["ID"].ToString() != "") { model.ID = int.Parse(item["ID"].ToString()); } if (item["IsUrgent"].ToString() != "") { model.IsUrgent = int.Parse(item["IsUrgent"].ToString()); } if (item["IsTop"].ToString() != "") { model.IsTop = int.Parse(item["IsTop"].ToString()); } model.STitle = item["STitle"].ToString(); model.SContent = item["SContent"].ToString(); if (item["SendUserID"].ToString() != "") { model.SendUserID = int.Parse(item["SendUserID"].ToString()); } model.SendUserName = item["SendUserName"].ToString(); if (item["ReceiveUserID"].ToString() != "") { model.ReceiveUserID = int.Parse(item["ReceiveUserID"].ToString()); } model.ReceiveUserName = item["ReceiveUserName"].ToString(); if (item["SStatus"].ToString() != "") { model.SStatus = int.Parse(item["SStatus"].ToString()); } if (item["SAddTime"].ToString() != "") { model.SAddTime = DateTime.Parse(item["SAddTime"].ToString()); } model.SStatusName = item["SStatusName"].ToString(); list.Add(model); } } return(list); }
public ActionResult addnotice(AdminSiteNewsModel addmodel) { if (addmodel == null) { return(RedirectToAction("Index", "SysNotice", new { area = "AdminArea" })); } SessionLoginModel user = Session[AppContent.SESSION_LOGIN_NAME] as SessionLoginModel; if (user == null) { return(RedirectToAction("Index", "Login", new { area = "" })); } addmodel.SendUserID = user.User.ID; addmodel.SendUserName = user.User.UserName; addmodel.SStatus = 1; addmodel.ReceiveUserID = 0; addmodel.ReceiveUserName = "******"; int id = bll.AddAdminSiteNew(addmodel); return(RedirectToAction("Index", "SiteMsg", new { area = "AdminArea" })); }
/// <summary> /// 增加一条数据 /// </summary> public int AddAdminSiteNew(AdminSiteNewsModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AdminSiteNews("); strSql.Append("STitle,SContent,SendUserID,SendUserName,ReceiveUserID,ReceiveUserName,SStatus,SAddTime"); strSql.Append(") values ("); strSql.Append("@STitle,@SContent,@SendUserID,@SendUserName,@ReceiveUserID,@ReceiveUserName,1,GETDATE()"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@STitle", SqlDbType.NVarChar), new SqlParameter("@SContent", SqlDbType.NVarChar), new SqlParameter("@SendUserID", SqlDbType.Int), new SqlParameter("@SendUserName", SqlDbType.NVarChar), new SqlParameter("@ReceiveUserID", SqlDbType.Int), new SqlParameter("@ReceiveUserName", SqlDbType.NVarChar), new SqlParameter("@SStatus", SqlDbType.Int) }; parameters[0].Value = model.STitle; parameters[1].Value = model.SContent; parameters[2].Value = model.SendUserID; parameters[3].Value = model.SendUserName; parameters[4].Value = model.ReceiveUserID; parameters[5].Value = model.ReceiveUserName; object obj = helper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int AddAdminSiteNew(AdminSiteNewsModel model) { return(dal.AddAdminSiteNew(model)); }