Car/LogsInfo.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Car
{
    public partial class LogsInfo : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack) 
            {
                DataTable dt = new BLL.Models.Car().GetContentInfo(int.Parse(Request["InfoID"].ToString()),"Logs");
                Literal1.Text = dt.Rows[0]["Content"].ToString();
                Literal3.Text = dt.Rows[0]["Title"].ToString();
                Literal4.Text = DBUtility.DbHelperSQL.GetSingle("select UserName from UserTable where InfoID = " + dt.Rows[0]["UserInfoID"].ToString()).ToString();
                DBUtility.DbHelperSQL.ExecuteSql("update LogsInfo set Flag = 1 where LogID = '"+dt.Rows[0]["LogID"].ToString()+"' and UserInfoID = "+Session["InfoID"].ToString());
                Literal5.Text = DateTime.Parse(dt.Rows[0]["AddDate"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
                DataTable d = DBUtility.DbHelperSQL.Query("select * from LogsInfo where LogID = '" + dt.Rows[0]["LogID"].ToString() + "'").Tables[0];
                for (int i = 0; i < d.Rows.Count; i++) 
                {
                    Literal2.Text += "<div class=\"ccc\" data-value=\"" + d.Rows[i]["UserInfoID"].ToString() + "\">" + DBUtility.DbHelperSQL.GetSingle("select UserName from UserTable where InfoID = '" + d.Rows[i]["UserInfoID"].ToString() + "'").ToString() + "</div>";
                }
            }
        }
    }
}