連鎖中心配送系統：銷售統計管理[1]

    ——此文章摘自《ASPNET +SQL Server網絡應用系統開發案例精解》定價￥　特價￥ 詳細>>http://tracklinktechcn/?m_id=dangdang&a_id=A&l=&l_type= width= height= border= nosave>

    ．連鎖店銷售信息的查看

    單擊統計分析即可進入銷售統計管理界面STManagerDep_Prodaspx如圖所示

http://developcsaicn/dotnet_ASP/images/jpg>
圖  銷售統計管理界面

    DataGrid控件用來向管理員展示已有的連鎖店銷售信息STManagerDep_Prodaspxcs核心代碼及其解釋如下
    private void Page_Load(object sender SystemEventArgs e)
    {
             if(Session[STNickName] != null)
             {
                       //獲得數據庫連接字符串
                       string STconnection = ConfigurationSettingsAppSettings[strconnection];
                       STconn = new SqlConnection(STconnection);
                       if(!IsPostBack)
                       {
                                //自定義BindGrid ()方法加載連鎖店銷售的信息
                                BindGrid();
                       }
             }
             else
             {
                       ResponseRedirect(/Indexaspx);
             }
    }
    //加載連鎖店銷售的信息
    public void BindGrid()
    {
             //創建查詢連鎖店銷售信息的sql語句
             string STstrsql=select STSaleIDSTDepSTDepNameSTProdNameSTSaleSTSaleNum STSaleSTStartTime STSaleSTEndTime from STSaleSTDepSTProd where STSaleSTProdID = STProdSTProdID and STSaleSTDepID = STDepSTDepID;
             //創建SqlDataAdapter的實例
             SqlDataAdapter STsda=new SqlDataAdapter(STstrsqlSTconn);
             //創建DataSet的實例
             DataSet STds=new DataSet();
             //將信息填充到DataSet

right>[]  [http://developcsaicn/dotnet_ASP/htm>]  [http://developcsaicn/dotnet_ASP/htm>]  [http://developcsaicn/dotnet_ASP/htm>]  [http://developcsaicn/dotnet_ASP/htm>]  [http://developcsaicn/dotnet_ASP/htm>]  [http://developcsaicn/dotnet_ASP/htm>]  

From:http://tw.wingwit.com/Article/program/net/201311/15500.html