public string getname()
{
string sql = "select Name from Employee where username='******'";
string Name = OperateDB.getExecuteScalar(sql);
return(Name);
}
private static string getemailnum(string Name)
{
string sql1 = string.Format(@"SELECT COUNT(*) AS Expr1
FROM Email
WHERE (Meetname = '{0}') AND (Status = '未读')", Name);
string s = OperateDB.getExecuteScalar(sql1);
return(s);
}
private void bing1()
{
string UserName = Session["UserName"].ToString();
string sql = "select id from UserInfo where UserName='******'";
int id = Convert.ToInt32(OperateDB.getExecuteScalar(sql));
string sql1 = "select top 5 * from Calendar where id=" + id + " order by CalendarID desc";
DataSet ds = OperateDB.ExecuteDataSet(sql1);
this.DataList1.DataSource = ds.Tables[0];
this.DataList1.DataBind();
}
public string getRemark()
{
string html = "";
string sql1 = "select top 5 * from NewsRemark where NewID in (select newsid from News where UserID=(select Employeeid from Employee where username='******')) order by Pubdate desc";
SqlConnection con1 = new SqlConnection(ConfigurationManager.AppSettings["Connection"]);
con1.Open();
SqlCommand com1 = new SqlCommand(sql1, con1);
SqlDataReader dr1 = com1.ExecuteReader();
List <remark> remarklist = new List <remark>();
while (dr1.Read())
{
remark re = new remark();
string sql = "select username from Employee where Employeeid=" + dr1["UserID"];
re.username = OperateDB.getExecuteScalar(sql);
sql = "select title from News where NewsID=" + dr1["NewID"];
re.title = OperateDB.getExecuteScalar(sql);
re.content = dr1["content"].ToString();
re.time = dr1["Pubdate"].ToString();
remarklist.Add(re);
}
foreach (var item in remarklist)
{
html += string.Format(@"<li class='in'>
<img src='images/anonymous.png' alt='' class='avatar'>
<div class='message'>
<span class='arrow'></span>
<a class='name' href='#'>{0}</a>
<span class='datetime'>at {1}</span>
<span class='body'>
{2}
</span>
</div>
</li>", item.username, item.time, item.content);
}
return(html);
}
