コード例 #1
0
 /// <summary>
 /// 列表
 /// </summary>
 /// <returns></returns>
 protected string GetList()
 {
     ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
     ShowShop.BLL.Order.ConsignMent bll = new ShowShop.BLL.Order.ConsignMent();
     ChangeHope.DataBase.DataByPage dataPage = bll.GetList();
     //第一步先添加表头
     table.AddHeadCol("", "<input type=\"checkbox\" id=\"chkAll\" onclick=\"CheckAll(this.form)\" alt=\"全选/取消\" />选择");
     table.AddHeadCol("", "订单号");
     table.AddHeadCol("", "类型");
     table.AddHeadCol("", "客户名");
     table.AddHeadCol("", "快递公司");
     table.AddHeadCol("", "快递单号");
     table.AddHeadCol("", "操作人");
     table.AddHeadCol("", "经手人");
     table.AddHeadCol("", "是否签收");
     table.AddRow();
     //添加表的内容
     if (dataPage.DataReader != null)
     {
         while (dataPage.DataReader.Read())
         {
             table.AddCol("<input ID=\"cBox\" type=\"checkbox\" value=\"" + dataPage.DataReader["id"].ToString() + "\" />");
             table.AddCol(dataPage.DataReader["orderid"].ToString());
             table.AddCol(dataPage.DataReader["consignmenttype"].ToString() == "1" ? "退货" : "发货");
             table.AddCol(dataPage.DataReader["username"].ToString());
             table.AddCol(dataPage.DataReader["expresscompany"].ToString());
             table.AddCol(dataPage.DataReader["expressoddnumbers"].ToString());
             table.AddCol(dataPage.DataReader["notename"].ToString());
             table.AddCol(dataPage.DataReader["consignmentpeople"].ToString());
             table.AddCol(string.Format("<img src='../images/{0}.gif' alt=''/>", dataPage.DataReader["received"].ToString()));
             table.AddRow();
         }
     }
     string view = table.GetTable() + dataPage.PageToolBar;
     dataPage.Dispose();
     dataPage = null;
     return view;
 }
コード例 #2
0
        protected string GetConsignList(string orderId)
        {
            ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
            //发货
            ShowShop.BLL.Order.ConsignMent Bll = new ShowShop.BLL.Order.ConsignMent();
            ChangeHope.DataBase.DataByPage pageData = Bll.GetList(" 1=1 and orderid='" + orderId + "'");

            //第一步先添加表头
            table.AddHeadCol("", "客户名称");
            table.AddHeadCol("", "交易时间");
            table.AddHeadCol("", "快递公司");
            table.AddHeadCol("", "快递单号");
            table.AddHeadCol("", "经办人");
            table.AddHeadCol("", "备注/说明");
            table.AddHeadCol("", "类型");
            table.AddRow();
            //添加发退货记录的内容
            if (pageData.DataReader != null)
            {
                while (pageData.DataReader.Read())
                {
                    table.AddCol(pageData.DataReader["username"].ToString());
                    table.AddCol(pageData.DataReader["consignmentdate"].ToString());
                    table.AddCol(pageData.DataReader["expresscompany"].ToString());
                    table.AddCol(pageData.DataReader["expressoddnumbers"].ToString());
                    table.AddCol(pageData.DataReader["consignmentpeople"].ToString());
                    table.AddCol(pageData.DataReader["remark"].ToString());
                    table.AddCol(pageData.DataReader["consignmenttype"].ToString() == "0" ? "发货" : "退货");
                    table.AddRow();
                }
            }
            string view = table.GetTable() + pageData.PageToolBar;
            pageData.Dispose();
            pageData = null;
            return view;
        }