eventprint.aspx.cs

来自「小区物业管理系统源代码,密码:123456,」· CS 代码 · 共 38 行

//文件名：EventPrint.aspx.cs
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class CommunityManage_EventPrint : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {//显示突发事件信息表
        string MyID = this.Request.Params["MyID"].ToString();
        if (Session["MyCommunityName"] != null)
        {
            this.Label1.Text = Session["MyCommunityName"].ToString() + "突发事件信息表";
        }
        this.Label2.Text = "打印日期：" + DateTime.Now.ToShortDateString();
        string MyConnectionString = ConfigurationManager.ConnectionStrings["MyCommunityDBConnectionString"].ConnectionString; ;
        string MySQL = "Select * From 突发事件 WHERE 事件编号 LIKE '" + MyID + "'";
        SqlDataAdapter MyAdapter = new SqlDataAdapter(MySQL, MyConnectionString);
        DataTable MyEventTable = new DataTable();
        MyAdapter.Fill(MyEventTable);
        this.Label3.Text = "事件编号：" + MyID;
        DateTime MyDate = (DateTime)MyEventTable.Rows[0][1];
        this.Label4.Text = "发生日期：" + MyDate.ToShortDateString();
        this.Label5.Text = "处理人员：" + MyEventTable.Rows[0][2].ToString();
        this.Label6.Text = "事件主题：" + MyEventTable.Rows[0][3].ToString();
        this.TextBox1.Text = MyEventTable.Rows[0][4].ToString();
        this.TextBox2.Text = MyEventTable.Rows[0][5].ToString();
        this.Label17.Text = "补充说明：" + MyEventTable.Rows[0][6].ToString();
    }
}