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