Пример #1
0
    public void OnAChange(Object sender, EventArgs e)
    {
        DataSet     a = new DataSet();
        DataAdapter c;
        datacontrol b = (datacontrol)Session["database"];
        Driver      d = (Driver)Session["driver"];

        if (StateList.SelectedItem.Text == "当前合同")
        {
            c = b.getContract();
        }
        else if (StateList.SelectedItem.Text == "有效合同")
        {
            c = b.getOkContract();
        }
        else if (StateList.SelectedItem.Text == "所有合同")
        {
            c = b.getAllContract();
        }
        else
        {
            c = null;
        }
        try
        {
            c.Fill(a);
            Contractgride.DataSource = a;
            Contractgride.DataBind();
        }
        catch (System.Data.SQLite.SQLiteException)
        {
            Response.Write("<script>alert('没有当前合同');</script>");
        }
    }
Пример #2
0
        public void OnSreach(object sender, EventArgs e)
        {
            DataAdapter c;
            //数据库绑定


            DataSet     b = new DataSet();
            datacontrol a = (datacontrol)Session["database"];

            c = a.getContract();
            try
            {
                c.Fill(b);
                this.acarGrid.DataSource = b;
                this.acarGrid.DataBind();
            }
            catch (System.Data.SQLite.SQLiteException)
            {
                Response.Write("<script>alert('没有执行合同的车辆');</script>");
            }
        }