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