complainprint.aspx.cs

小区物业管理系统源代码,密码:123456,

//文件名：ComplainPrint.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_ComplainPrint : 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 MyComplainTable = new DataTable();
        MyAdapter.Fill(MyComplainTable);
        this.Label3.Text = "投诉编号：" + MyID;
        this.Label4.Text = "楼栋名称：" + MyComplainTable.Rows[0][1].ToString();
        this.Label5.Text = "业主编号：" + MyComplainTable.Rows[0][2].ToString();
        this.Label6.Text = "业主姓名：" + MyComplainTable.Rows[0][3].ToString();
        DateTime MyDate = (DateTime)MyComplainTable.Rows[0][4];
        this.Label7.Text = "投诉日期：" + MyDate.ToShortDateString();
        this.Label8.Text = "接待人员：" + MyComplainTable.Rows[0][5].ToString();
        this.Label9.Text = "投诉主题：" + MyComplainTable.Rows[0][6].ToString();
        this.TextBox1.Text = MyComplainTable.Rows[0][7].ToString();
        MyDate = (DateTime)MyComplainTable.Rows[0][8];
        this.Label10.Text = "处理日期：" + MyDate.ToShortDateString();
        this.Label11.Text = "处理人员：" + MyComplainTable.Rows[0][9].ToString();
        this.Label12.Text = "处理意见：" + MyComplainTable.Rows[0][10].ToString();
        this.TextBox2.Text = MyComplainTable.Rows[0][11].ToString();
        this.TextBox3.Text = MyComplainTable.Rows[0][12].ToString();
        this.Label13.Text = "补充说明：" + MyComplainTable.Rows[0][13].ToString();
    }
}