repairassignprint.aspx.cs

ASP.NET 2.0 C# +MYSQL 家电维修管理系统 功能还算齐全

//文件名：RepairAssignPrint.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 RepairManage_RepairAssignPrint : System.Web.UI.Page
{
    private RepairManage_RepairAssignForm MyQueryForm;
    protected void Page_Load(object sender, EventArgs e)
    {//将查询结果输出到Excel文件中
        MyQueryForm = (RepairManage_RepairAssignForm)Context.Handler;
        String MyID = MyQueryForm.MyPrintID;
        this.Label1.Text = Session["MyServiceName"].ToString() + "家电修理派修工单";
        this.Label3.Text = "维修编号：" + MyID;
        this.Label4.Text = "客户名称：" + MyQueryForm.MyPrintClient;
        this.Label10.Text = "派修员工：" + MyQueryForm.MyPrintEmployee;
        this.Label13.Text = "补充说明：" + MyQueryForm.MyPrintComment;
        this.Label2.Text = "派修日期：" + MyQueryForm.MyPrintDate;

        DataTable MyTable = new DataTable();
        String MySQLConnectionString = ConfigurationManager.ConnectionStrings["MyServiceDBConnectionString"].ConnectionString;
        SqlConnection MyConnection = new SqlConnection(MySQLConnectionString);
        string MySQL = "SELECT * FROM [维修登记] WHERE ([维修编号]='" + MyQueryForm.MyPrintID + "')";
        MyConnection.Open();
        SqlDataAdapter MyAdatper = new SqlDataAdapter(MySQL, MyConnection);
        MyAdatper.Fill(MyTable);
        this.Label5.Text = "客户电话：" + MyTable.Rows[0][11].ToString();
        this.Label6.Text = "维修方式：" + MyTable.Rows[0][16].ToString();
        this.Label7.Text = "产品品牌：" + MyTable.Rows[0][4].ToString();
        this.Label8.Text = "产品型号：" + MyTable.Rows[0][5].ToString();
        this.Label12.Text = "机身号码：" + MyTable.Rows[0][6].ToString();
        this.TextBox1.Text = MyTable.Rows[0][13].ToString();
        this.Label14.Text = "保修情况：" + MyTable.Rows[0][12].ToString();
    }
}