repairfinishprint.aspx.cs

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

//文件名：RepairFinishPrint.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_RepairFinishPrint : System.Web.UI.Page
{
    private RepairManage_RepairFinishForm MyQueryForm;
    protected void Page_Load(object sender, EventArgs e)
    {//将查询结果输出到Excel文件中
        MyQueryForm = (RepairManage_RepairFinishForm)Context.Handler;
        this.Label1.Text = Session["MyServiceName"].ToString() + "家电修理完修凭证";
        this.Label3.Text = "维修编号：" + MyQueryForm.MyPrint维修编号;
        this.Label4.Text = "客户名称：" + MyQueryForm.MyPrint客户名称;
        this.Label6.Text = "修理结果：" + MyQueryForm.MyPrint修理结果;
        this.Label2.Text = "完修日期：" + MyQueryForm.MyPrint完修日期;
        this.TextBox1.Text = MyQueryForm.MyPrint补充说明;        
        DataTable MyTable = new DataTable();
        String MySQLConnectionString = ConfigurationManager.ConnectionStrings["MyServiceDBConnectionString"].ConnectionString;
        SqlConnection MyConnection = new SqlConnection(MySQLConnectionString);
        string MySQL = "SELECT * FROM [维修登记] WHERE ([维修编号]='" + MyQueryForm.MyPrint维修编号 + "')";
        MyConnection.Open();
        SqlDataAdapter MyAdatper = new SqlDataAdapter(MySQL, MyConnection);
        MyAdatper.Fill(MyTable);
        this.Label5.Text = "客户电话：" + MyTable.Rows[0][11].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();        
    }
}