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

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

    ．連鎖店銷售統計信息的查看

    單擊統計分析即可進入用戶管理界面STSaleaspx同樣此處統計的是用戶所有的連鎖店銷售情況如圖所示

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

    此界面實現的兩個功能一是展示本連鎖店的銷售信息二是向自己連鎖店內添加產品信息

    用來統計連鎖店銷售情況的代碼如下
    //加載自己連鎖店銷售產品的統計信息
    public void BindGrid()
    {
             string STNickName = Session[STNickName]ToString();
             string STstrsql=select STSaleIDSTDepSTDepNameSTProdNameSTSaleSTSaleNum STSaleSTStartTime STSaleSTEndTime from STSaleSTDepSTProdSTUser where STSaleSTProdID = STProdSTProdID and STSaleSTDepID = STDepSTDepID and STUserSTDepID = STDepSTDepID and STUserSTNickName = + STNickName + ;
             SqlDataAdapter STsda=new SqlDataAdapter(STstrsqlSTconn);
             DataSet STds=new DataSet();
             STsdaFill(STds);
             STmyGridDataSource = STds;
             STmyGridDataBind();
    }
    用來向本連鎖店添加產品信息的代碼如下
    private void ST_ok_Click(object sender SystemEventArgs e)
    {
             if(ST_ProdSelectedItemValue != )
             {
                       string STDepID = Session[STDepID]ToString();
                     
                       //創建數據庫SqlCommand對象
                       SqlCommand STcmd =new SqlCommand(insert_STSale_STconn);
                       //獲取存儲過程名
                       STcmdCommandType=CommandTypeStoredProcedure;
                       //向SqlCommand對象添加參數

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

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