ASP.NET网上售卡系统 第10页

ASP.NET网上售卡系统 第10页
private void btnSelect_Click(object sender, System.EventArgs e)
        {
            string strSelect = CleanString.htmlInputText( txtSelect.Text );
            string mySql="select * from Products Left Outer join Category on          Products.CID = Category.CID order by PID desc";
            string strClass = ddlClass.SelectedValue;
            if( strClass.Equals("-1") )
            {
                switch( ddlSelect.SelectedValue )
                {
                    case "0":
 mySql="select * from Products Left Outer join Category on Products.CID
 = Category.CID where PID like '%" + strSelect + "%' order by PID desc";
                        break;
                    case "1":
  mySql="select * from Products Left Outer join Category on   Products.CID
  = Category.CID where PName like '%" + strSelect + "%' order by PID desc";
                        break;  }
            }
            else
            {switch( ddlSelect.SelectedValue )
                {
                    case "0":
 mySql="select * from Products Left Outer join Category on Products.CID
 = Category.CID where Products.CID="+strClass+" and PID like '%"+strSelect     + "%' order by PID desc";
                        break;
                    case "1":
 mySql="select * from Products Left Outer join Category on Products.CID
= Category.CID where Products.CID=" + strClass + " and PName like '%" + strSelect + "%' order by PID desc";
                        break;}
            }
 mySqlPager.setAttribute( SqlPager1, "DataGrid1", mySql, "1000000-PID", 20);
        }
}
}
       仓库管理界面
 进入商品仓库管理界面可以查看商品的库存、当前销售量以及累计售出量。还可以按照商品编号、卡号以及出售状态查询商品库存情况。界面的下部显示查询结果管理员可以进行相应的编辑修改。代码从略。

图5.2.4  仓库管理界面图
       订单管理
 包括查看订单，整理订单和快钱对账。
查看定单管理模块是包含在admin中的orderList.apx程序实现的。查看定模块管理员可以通过定单编号、姓名、电子邮件三种不同的方式进行定单查询。整理定单模块是包含在admin中的orderTidy.apx程序实现的。管理员可以删除无效定单，为服务器减少无谓的资源浪费。
查询定单部分代码实现如下：
Private void OrderData Grid_ItemDataBound(sender, e)
        {
    if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.Altern  atingItem)
           {            
                string strOState = e.Item.Cells[3].Text;
                switch( strOState )
                {
                    case "0": strOState = "未付款";
                        break;
                    case "1": strOState = "完成";
                        break;
                    case "2": strOState = "停止";
                        break;
                    default: strOState = "其他";
                        break;
                }                                  
                e.Item.Cells[3].Text = strOState;
            }
        }
        private void btnSelect_Click(sender, e)
        {
            string strSelect = CleanString.htmlInputText( txtSelect.Text );
            string mySql="select * from [Order] order by OID desc";
            switch( ddlSelect.SelectedValue )
            {
                case "0":
    mySql="select * from [Order] where OID like '%"+ strSelect + "%' order by OID desc";
                    break;
                case "1":
           mySql="select * from [Order] where TName like '%" + strSelect 
                    break;
                case "2":

上一页  [1] [2] [3] [4] [5] [6] [7] [8] [9] [10]  ... 下一页  >> 

ASP.NET网上售卡系统 第10页下载如图片无法显示或论文不完整，请联系qq752018766