62,052
社区成员
发帖
与我相关
我的任务
分享
protected void Page_Load(object sender, EventArgs e)
{
if (Session["administrator"] == null)
{
Response.Redirect("login.aspx");
}
string logid = Request.QueryString["id"];
string selectid = "select * from log where logid="+logid;
SqlConnection sqlconn = SQL.sqlconn();
sqlconn.Open();
SqlCommand editlogid = new SqlCommand(selectid,sqlconn);
SqlDataReader editlogid2 = editlogid.ExecuteReader();
editlogid2.Read();
title.Text = editlogid2["title"].ToString();
logcontent.Value = editlogid2["content"].ToString();
sort.Text = editlogid2["sort"].ToString();
source.Text = editlogid2["source"].ToString();
editlogid2.Close();
}
protected void addlog_Click(object sender, EventArgs e)
{
string logtilel = title.Text;
string content = logcontent.Value;
string logsort =sort.Text;
string sources = source.Text;
string Times =Convert.ToString( DateTime.Now);
if (logtilel == "这里写日志标题")
{
logtilel = "";
}
if (logtilel.Length<=0 || content.Length <= 0)
{
Message.Visible = true;
Message.Text = "日志标题与日志内容为必填内容,其中一项的值为空";
}
else
{
SqlConnection sqlconn = SQL.sqlconn();
sqlconn.Open();
string strsql = "Insert Into log(title,content,sort,source,issuancetime)Values('" + logtilel + "','" + content + "','" + logsort + "','" + sources + "','" + Times + "')";
SqlCommand myconn = new SqlCommand(strsql, sqlconn);
myconn.ExecuteNonQuery();
sqlconn.Close();
title.Text = "这里写日志标题";
logcontent.Value = "";
source.Text = "";
Message.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["administrator"] == null)
{
Response.Redirect("login.aspx");
}
if (!IsPostBack)
{
string logid = Request.QueryString["id"];
string selectid = "select * from log where logid=" + logid;
SqlConnection sqlconn = SQL.sqlconn();
sqlconn.Open();
SqlCommand editlogid = new SqlCommand(selectid, sqlconn);
SqlDataReader editlogid2 = editlogid.ExecuteReader();
editlogid2.Read();
title.Text = editlogid2["title"].ToString();
logcontent.Value = editlogid2["content"].ToString();
sort.Text = editlogid2["sort"].ToString();
source.Text = editlogid2["source"].ToString();
editlogid2.Close();
}
}