cyth_chage.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 cyth_chage : System.Web.UI.Page
{
    protected string thfs;
    public static string i = "strat";
    public static DateTime thsj;
    public static DateTime qdsj;
    public static DateTime jdsj;
    protected void MessageBox(string Message)
    {
        Response.Write("<script language='javascript'>alert('" + Message + "')</script>");
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        //this.SmartNavigation = true;
        this.Label1.Text = Session["ID"].ToString();
        
        SqlConnection conn = new SqlConnection((string)Application["connstr"]);
        try
        {
            conn.Open();
            SqlCommand cmd = new SqlCommand("cyth_scan2", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@id", Session["ID"]);
            SqlParameter pa1 = cmd.Parameters.Add("@thrq", SqlDbType.Char, 10);
            SqlParameter pa2 = cmd.Parameters.Add("@thjs", SqlDbType.Int);
            SqlParameter pa3 = cmd.Parameters.Add("@thr", SqlDbType.Char, 10);
            SqlParameter pa4 = cmd.Parameters.Add("@thfs", SqlDbType.Char, 10);
            SqlParameter pa5 = cmd.Parameters.Add("@hygs", SqlDbType.VarChar, 50);
            SqlParameter pa6 = cmd.Parameters.Add("@ddyfje", SqlDbType.Float);
            SqlParameter pa7 = cmd.Parameters.Add("@khdq", SqlDbType.Char, 10);
            SqlParameter pa8 = cmd.Parameters.Add("@qdsj", SqlDbType.Char, 10);
            SqlParameter pa9 = cmd.Parameters.Add("@qdr", SqlDbType.Char, 10);
            SqlParameter pa10 = cmd.Parameters.Add("@qdjs", SqlDbType.Int);
            SqlParameter pa11 = cmd.Parameters.Add("@bzsm", SqlDbType.VarChar, 100);
            SqlParameter pa12 = cmd.Parameters.Add("@jdrq", SqlDbType.Char, 10);
            SqlParameter pa13 = cmd.Parameters.Add("@thrid", SqlDbType.Int);
            SqlParameter pa14 = cmd.Parameters.Add("@qdrid", SqlDbType.Int);

            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;
            cmd.ExecuteNonQuery();
            this.Label1.Text = Session["ID"].ToString();
            this.TextBox1.Text = cmd.Parameters["@thrq"].Value.ToString();
            this.TextBox2.Text = cmd.Parameters["@thjs"].Value.ToString();
            this.DropDownList1.SelectedIndex = (int)cmd.Parameters["@thrid"].Value;
           // MessageBox(cmd.Parameters["@thrid"].Value.ToString());
            this.DropDownList2.SelectedIndex = (int)cmd.Parameters["@qdrid"].Value;
            if(cmd.Parameters["@thfs"].Value.ToString()=="铁快")
            {
                this.RadioButton1.Checked=true;
            }else if(cmd.Parameters["@thfs"].Value.ToString()=="铁慢")
            {
                this.RadioButton2.Checked=true;
            }
            else if (cmd.Parameters["@thfs"].Value.ToString() == "货运公司") 
            {
                this.RadioButton3.Checked = true;
            }
            else if (cmd.Parameters["@thfs"].Value.ToString() == "邮寄") 
            {
                this.RadioButton4.Checked = true;
            }
            this.TextBox4.Text = cmd.Parameters["@hygs"].Value.ToString();
            this.TextBox5.Text = cmd.Parameters["@ddyfje"].Value.ToString();
            this.TextBox6.Text = cmd.Parameters["@khdq"].Value.ToString();
            this.TextBox3.Text = cmd.Parameters["@qdsj"].Value.ToString();

            if ((int)cmd.Parameters["@qdjs"].Value == 0)
            {
                this.TextBox9.Text = "";
            }
            else
            {
                this.TextBox9.Text = cmd.Parameters["@qdjs"].Value.ToString();
            }
            this.TextBox10.Text = cmd.Parameters["@bzsm"].Value.ToString();
            this.TextBox7.Text = cmd.Parameters["@jdrq"].Value.ToString();
    }
    catch (Exception ex)
    {
        //MessageBox(ex.Message);
    }
    finally
    {
        if (ConnectionState.Open == conn.State)
            conn.Close();
    }
}
    protected void RadioButton2_CheckedChanged(object sender, EventArgs e)
    {

    }
    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 == "textBox1")
        //{
        //    this.Label2.Text = this.Calendar1.SelectedDate.Year.ToString() + month1 + day1;

        //}

        //else if (i == "textBox7")
        //{
        //    this.Label3.Text = this.Calendar1.SelectedDate.Year.ToString() + month1 + day1;
        //}

        //else if (i == "textBox11")
        //{
        //    this.Label4.Text = this.Calendar1.SelectedDate.Year.ToString() + month1 + day1;
        //}
        //Response.Cache.SetNoStore();
        //this.Calendar1.Visible = false;
        //i = "start";
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        i = "textBox1";
        //this.Calendar1.Visible = true;
    }
    protected void LinkButton2_Click(object sender, EventArgs e)
    {
        i = "textBox7";
        //this.Calendar1.Visible = true;
    }
    protected void LinkButton3_Click(object sender, EventArgs e)
    {
        i = "textBox11";
        //this.Calendar1.Visible = true;
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        //MessageBox(this.DropDownList2.Text.ToString());
        //MessageBox(this.DropDownList2.SelectedValue.ToString());

        if (RadioButton3.Checked == true && TextBox4.Text.Length == 0)
        {
            MessageBox("请输入货运公司名称！");

        }
        else
        {

            //if (DateTime.Compare(thsj, qdsj) > 0 && this.Label2.Text.Length != 0)
            //{
            //    MessageBox("清点时间出错！");
            //    this.Label2.Text = "";

            //}
            //else if (DateTime.Compare(qdsj, jdsj) > 0 && this.Label3.Text.Length != 0)
            //{
            //    MessageBox("交单时间出错！");
            //    this.Label3.Text = "";

            //}
            //else if (DateTime.Compare(thsj, jdsj) > 0 && this.Label3.Text.Length != 0)
            //{
            //    MessageBox("交单时间出错！");
            //}
            //else
            //{
                if (this.TextBox2.Text != this.TextBox9.Text && this.TextBox10.Text.Length == 0 && this.TextBox9.Text.Length != 0)
                {
                    MessageBox("提货件数与清点件数不符，请填写备注说明！");
                }
                else
                {
                    SqlConnection conn = new SqlConnection((string)Application["connstr"]);
                    try
                    {
                        conn.Open();
                        SqlCommand cmd = new SqlCommand("cyth_update", conn);
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.Add("@id", Session["ID"].ToString());
                        cmd.Parameters.Add("@thsj", TextBox1.Text);
                        cmd.Parameters.Add("@thjs", TextBox2.Text);
                        cmd.Parameters.Add("@thr", this.DropDownList1.Text);
                        if (RadioButton1.Checked == true)
                        {
                            thfs = "铁快";
                        }
                        else if (RadioButton2.Checked == true)
                        {
                            thfs = "铁慢";
                        }
                        else if (RadioButton3.Checked == true)
                        {
                            thfs = "货运公司";
                        }
                        else if (RadioButton4.Checked == true)
                        {
                            thfs = "邮寄";
                        }
                        cmd.Parameters.Add("@thfs", thfs);
                        cmd.Parameters.Add("@hygs", TextBox4.Text);
                        cmd.Parameters.Add("@ddyfje", TextBox5.Text);
                        cmd.Parameters.Add("@khdq", TextBox6.Text);
                        cmd.Parameters.Add("@qdsj", TextBox3.Text);
                        cmd.Parameters.Add("@qdr", this.DropDownList2.Text);
                        cmd.Parameters.Add("@qdjs", TextBox9.Text);
                        cmd.Parameters.Add("@bzsm", TextBox10.Text);
                        cmd.Parameters.Add("@jdrq", TextBox7.Text);
                        SqlParameter pa = cmd.Parameters.Add("@rs", SqlDbType.Int);
                       // SqlParameter pa1 = cmd.Parameters.Add("@id", SqlDbType.Char, 8);
                        pa.Direction = ParameterDirection.Output;
                       // pa1.Direction = ParameterDirection.Output;

                        //MessageBox(cmd.Parameters["@id"].Value.ToString());
                        cmd.ExecuteNonQuery();
                        if ((int)cmd.Parameters["@rs"].Value == 1)
                        {
                            MessageBox("修改成功！");
                            //Session["ID"] = cmd.Parameters["@id"].Value.ToString();

                            Response.Redirect("cyth_result.aspx");

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

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

    protected void TextBox3_TextChanged(object sender, EventArgs e)
    {
        

    }
    protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {

    }
    protected void LinkButton4_Click(object sender, EventArgs e)
    {
        
    }
    protected void DropDownList1_SelectedIndexChanged1(object sender, EventArgs e)
    {
        
        this.DropDownList1.Text = this.DropDownList1.SelectedValue;
        
    }
    protected void TextBox1_TextChanged(object sender, EventArgs e)
    {

    }
}