ownerrepairprint.aspx.cs

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

//文件名：OwnerRepairPrint.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_OwnerRepairPrint : 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 MyRepairTable = new DataTable();
        MyAdapter.Fill(MyRepairTable);
        this.Label3.Text = "维修编号：" + MyID;
        this.Label4.Text = "楼栋名称：" + MyRepairTable.Rows[0][1].ToString();
        this.Label5.Text = "业主编号：" + MyRepairTable.Rows[0][2].ToString();
        this.Label6.Text = "业主姓名：" + MyRepairTable.Rows[0][3].ToString();
        DateTime MyDate = (DateTime)MyRepairTable.Rows[0][4];
        this.Label8.Text = "报修日期：" + MyDate.ToShortDateString();
        this.Label7.Text = "接待人员：" + MyRepairTable.Rows[0][5].ToString();
        this.TextBox1.Text = MyRepairTable.Rows[0][6].ToString();
        this.Label9.Text ="处理意见："+ MyRepairTable.Rows[0][7].ToString();
        MyDate = (DateTime)MyRepairTable.Rows[0][8];
        this.Label10.Text = "修理日期：" + MyDate.ToShortDateString();
        this.Label11.Text = "修理人员：" + MyRepairTable.Rows[0][9].ToString();
        this.Label12.Text = "修理费用：" + MyRepairTable.Rows[0][10].ToString() + "元";
        this.Label14.Text = "材料费用：" + MyRepairTable.Rows[0][11].ToString() + "元";
        this.Label13.Text = "费用合计：" + MyRepairTable.Rows[0][12].ToString()+"元";     
        this.TextBox2.Text = MyRepairTable.Rows[0][13].ToString();
        this.TextBox3.Text = MyRepairTable.Rows[0][14].ToString();
    }
}