showfahuo.aspx.cs

asp.net 的某物流管理系统 MIS 系统

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.OleDb;

public partial class include_Showhuo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            if (Session["Leaveword"].ToString() != "pass")
            {
                Response.Redirect("../Default.aspx");
            }

        }
        catch
        {
            Response.Redirect("../Default.aspx");
        }
       
        if (!Page.IsPostBack)
        {
            Bindgridview();
            Tianchong();
            Addsiji();
            Yundanhao();
        }
    }
    //填充下拉菜单
    private void Tianchong()
    {
        drpMonth.Items.Clear();
        drpMonth1.Items.Clear();
        drpDay.Items.Clear();
        drpDay1.Items.Clear();
        for (int i = 1; i < 13; i++)
        {
            drpMonth.Items.Add(new ListItem(i.ToString(), i.ToString()));
            drpMonth1.Items.Add(new ListItem(i.ToString(), i.ToString()));
        }
        for (int i = 1; i < 32; i++)
        {
            drpDay.Items.Add(new ListItem(i.ToString(), i.ToString()));
            drpDay1.Items.Add(new ListItem(i.ToString(), i.ToString()));
        }
    }
   
    
   
    protected void HuoGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        HuoGridView.PageIndex = e.NewPageIndex;
        Bindgridview();
    }
    //绑定控件
    private void Bindgridview()
    {
        DataSet ds = Gethuo();
        HuoGridView.DataSource = ds.Tables["aa"].DefaultView;
        HuoGridView.DataBind();
    }
   
    //取收货信息
    public DataSet Gethuo()
    {
        string myConnectionString = ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING1"].ConnectionString + Server.MapPath("~") + ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING2"].ConnectionString;
        OleDbConnection myConnection = new OleDbConnection(myConnectionString);
        string cmdText = "SELECT * FROM Huowu WHERE FaID=0 ORDER BY Createdate DESC";
        DataSet ds = new DataSet();
        OleDbDataAdapter da = new OleDbDataAdapter(cmdText, myConnection);
        try
        {
            myConnection.Open();
            da.Fill(ds, "aa");
        }
        catch (OleDbException ex)
        {
            throw new Exception(ex.Message, ex);
        }
        finally
        {
            myConnection.Close();
        }
        return ds;
    }
    public DataSet Gethuobydate(string str1,string str2)
    {
        string myConnectionString = ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING1"].ConnectionString + Server.MapPath("~") + ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING2"].ConnectionString;
        OleDbConnection myConnection = new OleDbConnection(myConnectionString);
        string cmdText = "SELECT * FROM Huowu WHERE Createdate>=CDate('" + str1 + "')" + "AND Createdate<=CDate('" + str2 + "') AND FaID=0 ORDER BY Createdate DESC";
        DataSet ds = new DataSet();
        OleDbDataAdapter da = new OleDbDataAdapter(cmdText, myConnection);
        try
        {
            myConnection.Open();
            da.Fill(ds, "aa");
        }
        catch (OleDbException ex)
        {
            throw new Exception(ex.Message, ex);
        }
        finally
        {
            myConnection.Close();
        }
        return ds;
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        Response.Write("<Script>window.open('Inputhuo.aspx','','width=540,height=240');</Script>");
    }
    protected void LinkButton2_Click(object sender, EventArgs e)
    {
        Bindgridview();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string date01 = drpYear.SelectedValue.ToString() + "-" + drpMonth.SelectedValue.ToString() + "-" + drpDay.SelectedValue.ToString();
        string date02 = drpYear1.SelectedValue.ToString() + "-" + drpMonth1.SelectedValue.ToString() + "-" + drpDay1.SelectedValue.ToString();
        DataSet ds = Gethuobydate(date01, date02);
        HuoGridView.DataSource = ds.Tables["aa"].DefaultView;
        HuoGridView.DataBind();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        string ordernum = lblYundan.Text.ToString().Trim();
        string jieren = txtJieren.Text.ToString().Trim();
        string jiehua = txtJiedian.Text.ToString().Trim();
        string jiezhen = txtJiezhen.Text.ToString().Trim();
        string siming = txtSiming.Text.ToString().Trim();
        string sihua = txtSihua.Text.ToString().Trim();
        string sidi = txtSidi.Text.ToString().Trim();
        string beizhu = txtBeizhu.Text.ToString().Trim();
        string jiezhi = txtJiezhi.Text.ToString().Trim();
        string chepai = drpSelect.SelectedValue.ToString();
        if (drpSelect.SelectedIndex == 0)
        {
            Response.Write("<Script>alert('请选择车辆，在选择之前必须先要添加车辆')</Script>");
            return;
        }
        if (jieren.Length < 1)
        {
            Response.Write("<Script>alert('接货人必须填写')</Script>");
            return;
        }
        foreach (GridViewRow row in HuoGridView.Rows)
        {
            CheckBox dirCheck = (CheckBox)row.FindControl("chkHuowu");
            if (dirCheck != null)
            {
                if (dirCheck.Checked == true)
                {
                    Updatefahuo(Int32.Parse(HuoGridView.DataKeys[row.RowIndex].Value.ToString()));
                }
                
            }
        }
        Addorder(ordernum, jieren, jiehua, jiezhen,jiezhi,chepai, siming, sihua, sidi, beizhu);
        Bindgridview();
        Response.Write("<Script>alert('生成成功！')</Script>");
        Clearstr();
    }
    //清空输入
    private void Clearstr()
    {
        txtBeizhu.Text = "";
        txtJiedian.Text = "";
        txtJieren.Text = "";
        txtJiezhen.Text = "";
        txtJiezhi.Text = "";
        txtSidi.Text = "";
        txtSihua.Text = "";
        txtSiming.Text = "";
        drpSelect.SelectedIndex = 0;
    }
    //生成发货表单到数据库
    private void Addorder(string sOrdernum, string sJieren, string sJiehua, string sJiezhen,string sJiezhi,string sChepai, string sSiming, string sSihua, string sSidi, string sBeizhu)
    {
        string myConnectionString = ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING1"].ConnectionString + Server.MapPath("~") + ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING2"].ConnectionString;
        OleDbConnection myConnection = new OleDbConnection(myConnectionString);
        string cmdText = "INSERT INTO Myorder(Ordernum,Jieren,Jiehua,Jiezhen,Jiezhi,Chepai,Siming,Sihua,Sidi,Beizhu,Createdate)VALUES('" +
            sOrdernum + "','" +
            sJieren + "','" +
            sJiehua + "','" +
            sJiezhen + "','" +
            sJiezhi+"','"+
            sChepai+"','"+
            sSiming + "','" +
            sSihua + "','" +
            sSidi + "','" +
            sBeizhu + "',Now())";
        OleDbCommand myCommand = new OleDbCommand(cmdText, myConnection);
        try
        {
            myConnection.Open();
            myCommand.ExecuteNonQuery();
        }
        catch (OleDbException ex)
        {
            throw new Exception(ex.Message, ex);
        }
        finally
        {
            myConnection.Close();
        }
    }

    //按选择添加发货数据到数据库
    private void Updatefahuo(int nHuowuID)
    {
        string myConnectionString = ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING1"].ConnectionString + Server.MapPath("~") + ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING2"].ConnectionString;
        OleDbConnection myConnection = new OleDbConnection(myConnectionString);
        string cmdText = "UPDATE Huowu SET FaID=1,Fadate=Now(),Ordernum='"+lblYundan.Text.ToString()+"' WHERE HuowuID=" + nHuowuID;
        OleDbCommand myCommand = new OleDbCommand(cmdText, myConnection);
        try
        {
            myConnection.Open();
            myCommand.ExecuteNonQuery();
        }
        catch (OleDbException ex)
        {
            throw new Exception(ex.Message, ex);
        }
        finally
        {
            myConnection.Close();
        }
    }
    //取车辆信息
    public DataSet Getche()
    {
        string myConnectionString = ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING1"].ConnectionString + Server.MapPath("~") + ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING2"].ConnectionString;
        OleDbConnection myConnection = new OleDbConnection(myConnectionString);
        string cmdText = "SELECT * FROM Che WHERE ShowID=1 ORDER BY Createdate DESC";
        DataSet ds = new DataSet();
        OleDbDataAdapter da = new OleDbDataAdapter(cmdText, myConnection);
        try
        {
            myConnection.Open();
            da.Fill(ds, "aa");
        }
        catch (OleDbException ex)
        {
            throw new Exception(ex.Message, ex);
        }
        finally
        {
            myConnection.Close();
        }
        return ds;
    }
    //按ID取司机信息
    public OleDbDataReader GetsijibyID(int nCheID)
    {
        string myConnectionString = ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING1"].ConnectionString + Server.MapPath("~") + ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING2"].ConnectionString;
        OleDbConnection myConnection = new OleDbConnection(myConnectionString);
        string cmdText = "SELECT * FROM Che WHERE CheID=" + nCheID;
        OleDbCommand myCommand = new OleDbCommand(cmdText, myConnection);
        OleDbDataReader dr = null;
        try
        {
            myConnection.Open();
            dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
        }
        catch (OleDbException ex)
        {
            throw new Exception(ex.Message, ex);
        }
        return dr;
    }
    //填充司机列表
    private void Addsiji()
    {
        drpSelect.Items.Clear();
        drpSelect.Items.Add(new ListItem("请选择车辆", "请选择车辆"));
        DataSet ds = Getche();
        for (int i = 0; i < ds.Tables["aa"].DefaultView.Count; i++)
        {
            drpSelect.Items.Add(new ListItem("[车牌:]"+ds.Tables["aa"].Rows[i][1].ToString() + " [司机:]" + ds.Tables["aa"].Rows[i][5].ToString(), ds.Tables["aa"].Rows[i][0].ToString()));
        }
    }
    //生成运单号
    private void Yundanhao()
    {
        lblYundan.Text = System.DateTime.Now.Year.ToString() + System.DateTime.Now.Month.ToString() +
            System.DateTime.Now.Day.ToString() + System.DateTime.Now.Hour.ToString() +
            System.DateTime.Now.Minute.ToString() + System.DateTime.Now.Second.ToString();
    }
    protected void drpSelect_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (drpSelect.SelectedValue.ToString() == "请选择车辆")
        {
            txtSidi.Text = "";
            txtSihua.Text = "";
            txtSiming.Text = "";
            return;
        }
        OleDbDataReader dr = GetsijibyID(Int32.Parse(drpSelect.SelectedValue.ToString()));
        if (dr.Read())
        {
            txtSiming.Text = dr["Xingming"].ToString();
            txtSihua.Text=dr["Shouji"].ToString();
            txtSidi.Text=dr["Suodi"].ToString();
            dr.Close();
        }
    }
}