wb/Admin/PurOrder/Show.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;
using Maticsoft.Common;
namespace OA.Web.PurOrder
{
    public partial class Show : Page
    {
        /// <summary>
        /// 权限验证
        /// </summary>
        public string opn = "";
        public OA.Model.PurOrder d = new Model.PurOrder();
        public DataTable dtpro = null;

        protected void Page_Load(object sender, EventArgs e)
        {
            opn = Com.Tool.StringConvert(Request["edit"]);
            d.id = Com.Tool.parseInt(Request["id"]);
            d = Com.Opn.Get<OA.Model.PurOrder>(d);
            //  string sql = string.Format("select tid,saleprice,shoppurchprice,suppurchprice,num,stuff((select ','+CONVERT(varchar, shopid) from PurOrder_Pro m  with(nolock) where id=m.id for xml path('')), 1, 1, '') as shopids  from  PurOrder_Pro with(nolock)   where pur_code ='{0}' group by tid,saleprice,shoppurchprice,suppurchprice,num ", d.pur_code);
            string sql = string.Format("select tid,saleprice,shoppurchprice,suppurchprice,num from  PurOrder_Pro with(nolock) where pur_code ='{0}'    group by tid,saleprice,shoppurchprice,suppurchprice,num ", d.pur_code);

            dtpro = Com.Sql.getTable(sql);

        }


    }
}