test +TTLiU9QWtXiX9Wp5T21Kt5acUjFWcOAe1v1hGU9oIKLcIEp73vTnWkV0PFO2PYv3O5lQ00FQ/XiEc1Ywyx154vygaNldUKB4k3oxMnAMnve0PvCZ13ZjOJ9+cxhGKQqxO71iNxLcs1hGqXs8UzjPw== test box CREATEDATE,System.String CartonNO,System.String Grossweight,System.String LotNo,System.String MAXSN,System.String MINSN,System.String Netweight,System.String Numberofboxes,System.Int32 ProductCode,System.String ProductModel,System.String ProductName,System.String QTY,System.Int32 SN,System.String SrcBillNo,System.String billid,System.String boxSize,System.String 30 box test billid,,23,0 select * from ( SELECT distinct A. lotId,CartonNO,QTY,Numberofboxes,SN, d.name ProductCode,e.FNAME ProductName,d.PRODUCT_DESC ProductModel,b.LOT_NAME SrcBillNo,Convert(Char(10),GetDate(),120) CREATEDATE, CONVERT(varchar(100), GETDATE(), 112) LotNo,c.Netweight,c.Grossweight,c.boxSize FROM ( select lotId,CartonNO,count(serialNumber) QTY,Numberofboxes, (select Materialid+'-'+securitycodenew+'-'+Random from [Udit.Mms].[dbo].[Barcodesecuritycode](nolock) where Barcode=min(serialNumber) )+' to '+(select Materialid+'-'+securitycodenew+'-'+Random from [Udit.Mms].[dbo].[Barcodesecuritycode](nolock) where Barcode=max(serialNumber)) SN from [Udit.Mms].[dbo].[mms_coderuleHistory] (nolock) where lotId=@billid group by CartonNO,lotId,Numberofboxes ) A left join [dbo].[Boxinformation] (nolock) c on A.lotId=c.billID join [Udit.SFC].[dbo].[QS_LOTS](nolock) b on a.lotId=b.LOT_ID join [Udit.SFC].[dbo].[QS_PRODUCTS] (nolock) d on b.PRODUCT_ID=d.PRODUCT_ID join [Udit.Mms].[dbo].[v_erp_material](nolock) e on d.name=e.fnumber where e.FUSEORGID='100018' or e.FUSEORGID='100015' or e.FUSEORGID='100008' and A.CartonNO in (select value from SplitToTable({nums},',')) --where Netweight !='' ) a where CartonNO in (select value from SplitToTable({nums},',')) order by CartonNO boxnumber CartonNO,System.String securitycode,System.String SN,System.String 30 boxnumber test billid,,23,0 select * from ( select '666' securitycode,CartonNO,(b.Materialid+'-'+b.securitycodenew+'-'+b.Random) SN from [Udit.Mms].[dbo].[mms_coderuleHistory](nolock) a left join [Udit.Mms].[dbo].[Barcodesecuritycode] (nolock) b on a.serialNumber=b.Barcode where lotId=@billid and serialNumber is not null ) a order by SN ASC <关系 Ref="5" type="DataRelation" isKey="true"> 关系 CartonNO 关系 关系 CartonNO ,CartonNO,CartonNO,,System.String,_x007B_box.CartonNO_x007D_,False,False,False,True ,nums,nums,,System.String,,False,False,False,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_DateTimeType_x003E_DateAndTime_x003C__x002F_DateTimeType_x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_ValuesBinding_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_ EngineV2 5fa4460ef78746ae830b9ea4ed0ed23f None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,18.2,1 4 True Transparent 0,0.2,4,0.8 {boxnumber.SN} Arial,8,Bold,Pixel Black BarCode1 关系 boxnumber DataBand1 357bc19e76914f0997d068978a2c31d0 1,1,1,1 Page1 21 20.2 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,27.2 Transparent 0.4,5.4,18.2,21.8 SubReport1 357bc19e76914f0997d068978a2c31d0 True Transparent 0.2,1.2,4.4,1 {box.CartonNO} Arial,8,Bold,Pixel Black BarCode4 False Transparent 1.4,0.6,4,0.6 微软雅黑,8 07d64e7332a947d88f3f1e6e7f4b7f5e 0,0,0,0 Text1 {box.CartonNO} Black Expression Center Transparent 1.9,2.2,4,0.6 微软雅黑,8 6c4a10ea29a54dffbcaf960849781fef 0,0,0,0 Text2 {box.SrcBillNo} Black DataColumn Center Transparent 0.4,0.6,1,0.6 微软雅黑,8 685f7ae22b64403d95c9837dc4e7779e 0,0,0,0 Text3 箱号： Black Expression Center Transparent 0.2,2.2,1.6,0.6 微软雅黑,8 5c8aa36eab87464e8bbf1b4eaaa55c4d 0,0,0,0 Text4 订单编号： Black Expression Center Transparent 0.2,2.8,1.6,0.6 微软雅黑,8 d9e1709afb20443a9ca71f1c4f848d36 0,0,0,0 Text5 物料编码： Black Expression Center Transparent 0.2,3.4,1.6,0.6 微软雅黑,8 f0a3e4fc5a944e6ba75d8b56bc179323 0,0,0,0 Text6 规格型号： Black Expression Center Transparent 1.9,2.8,4,0.6 微软雅黑,8 93bd60d2832e4a1f9adc0d0561dcdd00 0,0,0,0 Text7 {box.ProductCode} Black ,,,,WordWrap=True,A=0 DataColumn Center Transparent 6.2,2.4,1.6,0.6 微软雅黑,8 e524fd17b969407caf03c76c47063712 0,0,0,0 Text9 物料名称： Black Expression Center Transparent 7.9,2.4,3.6,0.6 微软雅黑,8 3b4ab93cc21c4af1ab8554e0e7d1df43 0,0,0,0 Text10 {box.ProductName} Black ,,,,WordWrap=True,A=0 DataColumn Center True Transparent 13.2,1,4.4,1 {box.CartonNO} Arial,8,Bold,Pixel Black 18280ee3fadd4aed850dbc7a42e4d275 BarCode2 False Transparent 12.35,2,1,0.6 微软雅黑,8 37736c2cdab54ea6a392023253b0e199 0,0,0,0 Text11 QTY： Black Expression Center Transparent 12.4,2.6,1.2,0.6 微软雅黑,8 e088a0cb1ef8467789acbe1ae80b03d5 0,0,0,0 Text12 日期： Black Expression Center Transparent 12.4,3.2,1.2,0.6 微软雅黑,8 6e91e69e563f420eadc5aba18d54b8e0 0,0,0,0 Text13 净重： Black Expression Center Transparent 11.9,3.8,1.8,0.6 微软雅黑,8 3fe6426a10744b7fac00dd790c8a071e 0,0,0,0 Text14 外箱尺寸： Black Expression Center Transparent 12.2,4.4,1.4,0.6 微软雅黑,8 bf00929efe57467987ed2e909b403af7 0,0,0,0 Text15 流水号： Black Expression Center Transparent 15.45,2,1.8,0.6 微软雅黑,8 a571656312494f7da9e4461e0112c339 0,0,0,0 Text16 最小包装量： Black Expression Center Transparent 16,2.8,1.2,0.6 微软雅黑,8 8b63bbcc8b054cdcacc4ab28c2de3759 0,0,0,0 Text17 LOTNo： Black Expression Center Transparent 16.4,3.4,1,0.6 微软雅黑,8 868d3022d81d48809cec7f2ffaab75ed 0,0,0,0 Text18 毛重： Black Expression Center Transparent 13.7,2,1.2,0.6 微软雅黑,8 9c39fa84102747ef87de93920f9f1864 0,0,0,0 Text19 {box.QTY} Black DataColumn Center Transparent 13.7,2.6,2.2,0.6 微软雅黑,8 b3bc91c12814495992515c7388c71646 0,0,0,0 Text20 {box.CREATEDATE} Black DataColumn Center Transparent 13.7,3.2,2.2,0.6 微软雅黑,8 83303107cf464e9581e5180999ec05fa 0,0,0,0 Text21 {box.Netweight} Black DataColumn Center Transparent 13.7,3.8,2.2,0.6 微软雅黑,8 d4586f5431c7404cb8a616ef1a293c1a 0,0,0,0 Text22 {box.boxSize} Black DataColumn Center Transparent 13.9,4.5,4.8,0.8 微软雅黑,8 1e9e17d333284e53b389637d31722bb4 0,0,0,0 Text23 {box.SN} Black ,,,,WordWrap=True,A=0 DataColumn Transparent 17.3,2,1.2,0.6 微软雅黑,8 379076abae6a43d2875dfd657245437f 0,0,0,0 Text24 {box.Numberofboxes} Black DataColumn Center Transparent 17.3,2.8,1.8,0.6 微软雅黑,8 41a209872f5f47209ba16811e9f713cb 0,0,0,0 Text25 {box.LotNo} Black DataColumn Center Transparent 17.5,3.4,1.4,0.6 微软雅黑,8 ba16acea9cfc4a648d9a2815eafe8768 0,0,0,0 Text26 {box.Grossweight} Black DataColumn Center Transparent 1.9,3.5,9.2,1 微软雅黑,8 429d764cc87644b08b9f612b1253289a 0,0,0,0 Text8 {box.ProductModel} Black ,,,,WordWrap=True,A=0 DataColumn Transparent 7.8,4.6,2.4,0.6 微软雅黑,18 b0fedabb389f40ccb163a02cceab4afd 0,0,0,0 Text27 SN码 Black Expression Center Transparent 7.8,1,2.4,0.8 微软雅黑,18 98016c7400371adbe89a3150e9dc3a86 0,0,0,0 Text29 SN码 Black Expression Center box DataBand2 True a9723a8f6038436590cd5fa5c20a186b 1,1,1,1 Page2 29.7 21 A4 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 3/6/2020 3:58:59 PM 12/17/2019 4:10:05 PM c9f6d2ea58fc4357a18673b63052d9c3 Report Centimeters 2018.3.5.0 CSharp