test/Member/CoreEntity/DAL/PushPaidBackMsgDAL.cs

using CoreEntity.Entity;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Text;
using ZcPeng.PublicLibrary;

namespace CoreEntity.DAL
{
    public class PushPaidBackMsgDAL
    {

        public static List<PurOrderDTEx> GetPaidBackMsgDT(int BillNo)
        {
            var sql1 = "select A.*,B.AccountRealName as Contact,C.GoodsName,C.GoodsSpec,C.GoodsCode,C.Manufacturer" +
                           ",D.ApprovalNo,E.BusinessName from settledt A " +
                           " left join settlemt A1 on A1.BillNo = A.BillNo " +
                           " left join sup_Account B on B.PurStaffId = A1.SaleManId " +
                           " left join GoodsDoc C on C.EntId = A.EntId and C.GoodsId = A.GoodsId " +
                           " left join GoodsAttr D on D.GoodsId = C.GoodsId and D.EntId = C.EntId " +
                           " left join BusinessDoc E on  E.BusinessId = A1.RfId and A1.RfType=0 and E.EntId = A1.EntId " +
                           " where A.BillNo = @BillNo ";
            List<SqlParameter> param1 = new List<SqlParameter>(1);
            param1.Add(new SqlParameter("BillNo", BillNo));

            List<PurOrderDTEx> list = DataAccess.GetValues<PurOrderDTEx>(sql1, param1, out var msg);
            return list;
        }
        
    }
}