khfw_dh_result.aspx.cs

退书管理系统

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class kehufuwu_khfw_dh_result : System.Web.UI.Page
{
    protected void MessageBox(string Message)
    {
        Response.Write("<script language='javascript'>alert('" + Message + "')</script>");
    }
    public string k;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["cythid"] == null)
        {
            if (Session["cythid"] != null)
            {
                k = "1";
                this.Label1.Text = Session["cythid"].ToString();
            }
        }
        else
        {
            k = "2";
            string x = Request.QueryString["cythid"];
            int xx = Convert.ToInt32(x);
            Session["cythid"] = x;
            this.Label1.Text = Session["cythid"].ToString();
        }
        SqlConnection conn = new SqlConnection((string)Application["connstr"]);
        try
        {
            conn.Open();
            SqlCommand cmd = new SqlCommand("khfw_dh_result", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@cythid", Session["cythid"].ToString());
            SqlParameter pa1 = cmd.Parameters.Add("@thrq", SqlDbType.Char,8);
            SqlParameter pa2 = cmd.Parameters.Add("@thjs", SqlDbType.Int);
            SqlParameter pa3 = cmd.Parameters.Add("@thr", SqlDbType.VarChar, 20);
            SqlParameter pa4 = cmd.Parameters.Add("@thfs", SqlDbType.VarChar,10);
            SqlParameter pa5 = cmd.Parameters.Add("@hygs", SqlDbType.VarChar, 200);
            SqlParameter pa6 = cmd.Parameters.Add("@ddyfje", SqlDbType.Float);
            SqlParameter pa7 = cmd.Parameters.Add("@sf", SqlDbType.VarChar,20);
            SqlParameter pa8 = cmd.Parameters.Add("@qdsj", SqlDbType.Char,8);
            SqlParameter pa9 = cmd.Parameters.Add("@qdr", SqlDbType.VarChar, 20);
            SqlParameter pa10 = cmd.Parameters.Add("@qdjs", SqlDbType.Int);
            SqlParameter pa11 = cmd.Parameters.Add("@bzsm", SqlDbType.VarChar,500);
            SqlParameter pa12 = cmd.Parameters.Add("@jdrq", SqlDbType.Char,8);
            SqlParameter pa13 = cmd.Parameters.Add("@zddh", SqlDbType.VarChar,20);
            SqlParameter pa14 = cmd.Parameters.Add("@qlr", SqlDbType.VarChar, 20);
            SqlParameter pa15 = cmd.Parameters.Add("@unit", SqlDbType.VarChar, 100);
            SqlParameter pa16 = cmd.Parameters.Add("@uno", SqlDbType.Char, 8);
            SqlParameter pa17 = cmd.Parameters.Add("@zdrq", SqlDbType.Char,8);
            SqlParameter pa18 = cmd.Parameters.Add("@jzjsyclrq", SqlDbType.Char, 8);
            SqlParameter pa19 = cmd.Parameters.Add("@fhrq", SqlDbType.Char, 8);
            SqlParameter pa20 = cmd.Parameters.Add("@bz", SqlDbType.VarChar,200);
            SqlParameter pa21 = cmd.Parameters.Add("@ecclrq", SqlDbType.Char, 8);
            SqlParameter pa22 = cmd.Parameters.Add("@efhrq", SqlDbType.Char, 8);
            SqlParameter pa23 = cmd.Parameters.Add("@zzcljg", SqlDbType.VarChar,200);
            SqlParameter pa24 = cmd.Parameters.Add("@ffrzrq", SqlDbType.Char, 8);
            pa1.Direction = ParameterDirection.Output;
            pa2.Direction = ParameterDirection.Output;
            pa3.Direction = ParameterDirection.Output;
            pa4.Direction = ParameterDirection.Output;
            pa5.Direction = ParameterDirection.Output;
            pa6.Direction = ParameterDirection.Output;
            pa7.Direction = ParameterDirection.Output;
            pa8.Direction = ParameterDirection.Output;
            pa9.Direction = ParameterDirection.Output;
            pa10.Direction = ParameterDirection.Output;
            pa11.Direction = ParameterDirection.Output;
            pa12.Direction = ParameterDirection.Output;
            pa13.Direction = ParameterDirection.Output;
            pa14.Direction = ParameterDirection.Output;
            pa15.Direction = ParameterDirection.Output;
            pa16.Direction = ParameterDirection.Output;
            pa17.Direction = ParameterDirection.Output;
            pa18.Direction = ParameterDirection.Output;
            pa19.Direction = ParameterDirection.Output;
            pa20.Direction = ParameterDirection.Output;
            pa21.Direction = ParameterDirection.Output;
            pa22.Direction = ParameterDirection.Output;
            pa23.Direction = ParameterDirection.Output;
            pa24.Direction = ParameterDirection.Output;
            cmd.ExecuteNonQuery();
            this.Label1.Text = Session["cythid"].ToString();
            this.Label2.Text = cmd.Parameters["@thrq"].Value.ToString();
            this.Label3.Text = cmd.Parameters["@thjs"].Value.ToString()+"件";
            this.Label4.Text = cmd.Parameters["@thr"].Value.ToString();
            this.Label5.Text = cmd.Parameters["@thfs"].Value.ToString();
            this.Label6.Text = cmd.Parameters["@hygs"].Value.ToString();
            this.Label7.Text = cmd.Parameters["@sf"].Value.ToString();
            this.Label8.Text = cmd.Parameters["@qdsj"].Value.ToString();
            this.Label9.Text = cmd.Parameters["@qdr"].Value.ToString();
            this.Label10.Text = cmd.Parameters["@qdjs"].Value.ToString()+"件";
            this.Label11.Text = cmd.Parameters["@bzsm"].Value.ToString();
            this.Label12.Text = cmd.Parameters["@jdrq"].Value.ToString();
            this.Label13.Text = cmd.Parameters["@zddh"].Value.ToString();
            this.Label14.Text = cmd.Parameters["@qlr"].Value.ToString();
            this.Label15.Text = cmd.Parameters["@unit"].Value.ToString();
            this.Label16.Text = cmd.Parameters["@uno"].Value.ToString();
            this.Label17.Text = cmd.Parameters["@zdrq"].Value.ToString();
            this.Label18.Text = cmd.Parameters["@jzjsyclrq"].Value.ToString();
            this.Label19.Text = cmd.Parameters["@fhrq"].Value.ToString();
            this.Label20.Text = cmd.Parameters["@bz"].Value.ToString();
            this.Label21.Text = cmd.Parameters["@ecclrq"].Value.ToString();
            this.Label22.Text = cmd.Parameters["@efhrq"].Value.ToString();
            this.Label23.Text = cmd.Parameters["@zzcljg"].Value.ToString();
            this.Label24.Text = cmd.Parameters["@ffrzrq"].Value.ToString();
            this.Label25.Text = cmd.Parameters["@ddyfje"].Value.ToString()+"元";
        }
        catch (Exception ex)
        {
            MessageBox(ex.Message);
        }
        finally
        {
            if (ConnectionState.Open == conn.State)
                conn.Close();
        }

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (k == "1")
        {
            Response.Redirect("khfw_dh_search.aspx");
        }else if(k=="2")
        {
            Response.Redirect("khfw_dh_list.aspx");
        }
    }
}