khfw_updata.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_update : System.Web.UI.Page
{
    public static string i = "strat";
    public static DateTime jzjsyclrq;
    public static DateTime fhrq;
    public static DateTime ecclrq;
    public static DateTime efhrq;
    public static DateTime ffrzrq;
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection((string)Application["connstr"]);
        try
        {
            conn.Open();
            SqlCommand cmd = new SqlCommand("khfw_return", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@cythid", Session["cythid"].ToString());
            SqlParameter pa1 = cmd.Parameters.Add("@qlr", SqlDbType.VarChar, 20);
            SqlParameter pa2 = cmd.Parameters.Add("@sf", SqlDbType.VarChar, 20);
            SqlParameter pa3 = cmd.Parameters.Add("@zddh", SqlDbType.VarChar, 20);
            SqlParameter pa4 = cmd.Parameters.Add("@uno", SqlDbType.Char, 8);
            SqlParameter pa5 = cmd.Parameters.Add("@unit", SqlDbType.VarChar, 100);
            SqlParameter pa6 = cmd.Parameters.Add("@zdrq", SqlDbType.Char, 8);
            SqlParameter pa7 = cmd.Parameters.Add("@jzjsyclrq", SqlDbType.Char, 8);
            SqlParameter pa8 = cmd.Parameters.Add("@fhrq", SqlDbType.Char, 8);
            SqlParameter pa9 = cmd.Parameters.Add("@bz", SqlDbType.VarChar, 200);
            SqlParameter pa10 = cmd.Parameters.Add("@ecclrq", SqlDbType.Char, 8);
            SqlParameter pa11 = cmd.Parameters.Add("@efhrq", SqlDbType.Char, 8);
            SqlParameter pa12 = cmd.Parameters.Add("@zzcljg", SqlDbType.VarChar, 200);
            SqlParameter pa13 = 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;
            cmd.ExecuteNonQuery();
            this.Label1.Text = Session["cythid"].ToString();
           // this.DropDownList1.SelectedIndex = (int)cmd.Parameters["@qlr"].Value;
            this.TextBox2.Text = cmd.Parameters["@sf"].Value.ToString();
            this.TextBox1.Text = cmd.Parameters["@zddh"].Value.ToString();
            this.Label2.Text = cmd.Parameters["@uno"].Value.ToString();
            this.Label9.Text = cmd.Parameters["@unit"].Value.ToString();
            this.TextBox5.Text = cmd.Parameters["@zdrq"].Value.ToString();
            this.TextBox6.Text = cmd.Parameters["@jzjsyclrq"].Value.ToString();
            this.TextBox7.Text = cmd.Parameters["@fhrq"].Value.ToString();
            this.TextBox3.Text = cmd.Parameters["@bz"].Value.ToString();
            this.TextBox8.Text = cmd.Parameters["@ecclrq"].Value.ToString();
            this.TextBox9.Text = cmd.Parameters["@efhrq"].Value.ToString();
            this.TextBox4.Text = cmd.Parameters["@zzcljg"].Value.ToString();
            this.TextBox10.Text = cmd.Parameters["@ffrzrq"].Value.ToString();
        }
        catch (Exception ex)
        {
            MessageBox(ex.Message);
        }
        finally
        {
            if (ConnectionState.Open == conn.State)
                conn.Close();
        }
    }
    protected void MessageBox(string Message)
    {
        Response.Write("<script language='javascript'>alert('" + Message + "')</script>");
    }
 
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection((string)Application["connstr"]);
        try
        {
            conn.Open();
            SqlCommand cmd = new SqlCommand("return_sales", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@dno", this.TextBox1.Text);
            SqlParameter pa = cmd.Parameters.Add("@uno", SqlDbType.Char, 8);
            SqlParameter pa1 = cmd.Parameters.Add("@unit", SqlDbType.Char, 100);
            SqlParameter pa2 = cmd.Parameters.Add("@rs", SqlDbType.Int);
            pa.Direction = ParameterDirection.Output;
            pa1.Direction = ParameterDirection.Output;
            pa2.Direction = ParameterDirection.Output;

            cmd.ExecuteNonQuery();
            if ((int)cmd.Parameters["@rs"].Value == 1)
            {

                this.Label2.Text = cmd.Parameters["@uno"].Value.ToString();
                this.Label9.Text = cmd.Parameters["@unit"].Value.ToString();

            }
            else
            {
                MessageBox("制单单号输入错误！");
            }



        }
        catch (Exception ex)
        {
            MessageBox(ex.Message);
        }
        finally
        {
            if (ConnectionState.Open == conn.State)
                conn.Close();
        }

    }
    protected void LinkButton2_Click(object sender, EventArgs e)
    {
        i = "lb2";
        //this.Calendar1.Visible = true;
    }
    protected void LinkButton3_Click(object sender, EventArgs e)
    {
        i = "lb3";
        //this.Calendar1.Visible = true;
    }
    protected void LinkButton4_Click(object sender, EventArgs e)
    {
        i = "lb4";
        //this.Calendar1.Visible = true;
    }
    protected void LinkButton5_Click(object sender, EventArgs e)
    {
        i = "lb5";
        //this.Calendar1.Visible = true;
    }
    protected void LinkButton6_Click(object sender, EventArgs e)
    {
         i = "lb6";
        //this.Calendar1.Visible = true;
    
    }
    protected void Calendar1_SelectionChanged(object sender, EventArgs e)
    {
        string day1;
        string month1;


        //if (this.Calendar1.SelectedDate.Day < 10)
        //{
        //    string a = this.Calendar1.SelectedDate.Day.ToString();
        //    day1 = "0" + a;

        //}
        //else
        //{
        //    day1 = this.Calendar1.SelectedDate.Day.ToString();
        //}

        //if (this.Calendar1.SelectedDate.Month < 10)
        //{
        //    string b = this.Calendar1.SelectedDate.Month.ToString();
        //    month1 = "0" + b;
        //}
        //else
        //{
        //    month1 = this.Calendar1.SelectedDate.Day.ToString();
        //}
        //if (i == "lb2")
        //{
        //    this.Label4.Text = this.Calendar1.SelectedDate.Year.ToString() + month1 + day1;
        //    jzjsyclrq = this.Calendar1.SelectedDate;

        //}
        //else if (i == "lb3")
        //{
        //    this.Label5.Text = this.Calendar1.SelectedDate.Year.ToString() + month1 + day1;
        //    fhrq = this.Calendar1.SelectedDate;
        //}
        //else if (i == "lb4")
        //{
        //    this.Label6.Text = this.Calendar1.SelectedDate.Year.ToString() + month1 + day1;
        //    ecclrq = this.Calendar1.SelectedDate;
        //}
        //else if (i == "lb5")
        //{
        //    this.Label7.Text = this.Calendar1.SelectedDate.Year.ToString() + month1 + day1;
        //    efhrq = this.Calendar1.SelectedDate;
        //}
        //else if (i == "lb6")
        //{
        //    this.Label8.Text = this.Calendar1.SelectedDate.Year.ToString() + month1 + day1;
        //    ffrzrq = this.Calendar1.SelectedDate;
        //}
        //this.Calendar1.Visible = false;
        //i = "start";
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection((string)Application["connstr"]);
        try
        {
            conn.Open();
            SqlCommand cmd = new SqlCommand("khfw_updata", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@cythid", Label1.Text);
            cmd.Parameters.Add("@qlr", this.DropDownList1.SelectedValue);
            cmd.Parameters.Add("@sf", this.TextBox2.Text);
            cmd.Parameters.Add("@zddh", this.TextBox1.Text);
            cmd.Parameters.Add("@uno", this.Label2.Text);
            cmd.Parameters.Add("@unit", this.Label9.Text);
            cmd.Parameters.Add("@zdrq", this.TextBox5.Text);
            cmd.Parameters.Add("@jzjsyclrq", TextBox6.Text);
            cmd.Parameters.Add("@fhrq", this.TextBox7.Text);
            cmd.Parameters.Add("@bz", TextBox3.Text);
            cmd.Parameters.Add("@ecclrq", this.TextBox8.Text);
            cmd.Parameters.Add("@efhrq", TextBox9.Text);
            cmd.Parameters.Add("@zzcljg", this.TextBox4.Text);
            cmd.Parameters.Add("@ffrzrq", this.TextBox10.Text);
            SqlParameter pa = cmd.Parameters.Add("@rs", SqlDbType.Int);
            pa.Direction = ParameterDirection.Output;
            cmd.ExecuteNonQuery();

            if ((int)cmd.Parameters["@rs"].Value == 1)
            {
                MessageBox("修改成功！");
                Session["cythid"] = this.Label1.Text.ToString();
                Response.Redirect("khfw_result.aspx");

            }
            else
            {
                MessageBox("修改失败，请重试！");
            }

        }
        catch (Exception ex)
        {
            MessageBox(ex.StackTrace);
        }
        finally
        {
            if (ConnectionState.Open == conn.State)
                conn.Close();
        }
    }
}