MZ@ !L!This program cannot be run in DOS mode. $PELba" 0h  @TO   H.textf h `.rsrcj@@.reloc n@BH+Y( **u* *rp*{ *:( } *0$u ,( { { o +*v {= )UUZ( { o X*0Mr p%{ -q -&+ o ( *{ *:( } *0$u ,( { { o +*v / )UUZ( { o X*0Mr'p%{ -q -&+ o ( *{ *:( } *0$u ,( { { o +*v X )UUZ( { o X*0MrUp%{ -q -&+ o ( *{ *:( } *0$u ,( { { o +*v )= )UUZ( { o X*0Mr{p%{ -q -&+ o ( *02s rpo &o %so +*03s rpo &o %s o +*0Zs rc po &(!  ,rd po &r po &o %s" o +*0s r po &r po# o$ o% r p(& ,*r pr po# o$ r p(' o &+r po &r+ po &o o( rm po) %r po# o$ s o* +*0s r po+  ,V%r p%r po# o$ %rp%r po# o$ %rp(, o &+T%rp%r po# o$ %rp%r po# o$ %rp(, o &o o( r;po) %r po# o$ s o* +*0B s rypo &o %r po# o$ s o- +*0Bs rpo &o %r po# o$ s o +*0Bs rpo &o %r po# o$ s o +*0Bs r(!po &o %r po# o$ s o +*0Bs rq"po &o %r po# o$ s o +*03s r^$po &o %s. o +*>r&po/ &*Br&po0 &*Rr&ps o1 &*0 s r&po &rp,po# o$ rx,p(2 , r|,po &rp,po# o$ r,p(2 , r,po &rp,po# o$ r,p(2 , r,po &rp,po# o$ r,p(2 , r,po &o o( r-po) %r po3 s4 o5 &s %rR-p%{!%r 3p%{!%r3p%{!%rO4po6 (7 (8 o &o o o9 +*0Hs r7pr8p(' o &o %r po3 s4 o +*03s r:po &o %s o +*0s r po+  ,*r>pr po+ "r0@p(: o &+(rApr po+ "r0@p(: o &o o( r0Cpo) %r po3 s4 o* +*>rZCpo/ &*rpCprCp(: %so; &*03 s rCpo &o %s o- +*r:DprCp(' %so; &*#{Gz?}#Q?}#?}( *BSJB v4.0.30319l #~x #Strings@D#USU#GUIDU#BlobW 3"/>;0  -,-pLe\0sA ] vQ \  .msfs ~ ssII+I AIWI I!'!('!'!'```P X cc Phf \m lu  c Ph \-!l5!D!ct!Ph!\!l!"c4"PhT"\"l""c "Ph #\ p#Pq #q #/qX$@y$%8&&&('x' 'q"(e$(&((v)@(S+)/(*q2h*4+7-+9X+;+=+?G G      G `G  )19AIQYaiqy ';;DPL\'`$(','4'x<=D7\z\ Het iLJ ,Thz\'7 =C IP !. ...#.+*.3*.;*.C.K0.S*.[*.cH.kr.s@AC{C`ac{c{#{_{ ` @`+Rp  4Yiy 1 W"R B .<>f__AnonymousType0<>f__AnonymousType1`1<>f__AnonymousType2`1<>f__AnonymousType3`1<>f__AnonymousType4`1EqualityComparer`1GetInt32set_DatadatadbmscorlibCloud.PublicSystem.Collections.Genericget_vipuser_idget_idget_openidi__Fieldi__Fieldi__Fieldi__FieldIsNullOrWhiteSpaceGetHashCodeDbPageTablePageExecTempTableget_MainTempTableDoubleget_group_nameAppendLinewhereDbBaseUpdateinstall_ratelogistics_ratetax_rateDebuggerBrowsableStateDeleteCompilerGeneratedAttributeGuidAttributeDebuggableAttributeDebuggerBrowsableAttributeComVisibleAttributeAssemblyTitleAttributeAssemblyTrademarkAttributeTargetFrameworkAttributeDebuggerHiddenAttributeAssemblyFileVersionAttributeAssemblyConfigurationAttributeAssemblyDescriptionAttributeCompilationRelaxationsAttributeAssemblyProductAttributeAssemblyCopyrightAttributeDebuggerDisplayAttributeAssemblyCompanyAttributeRuntimeCompatibilityAttributeExecuteget_ValuevalueSystem.Runtime.VersioningToStringGetStringobjGetHomeImageUrlLinkS001.WeiXin.DataAccess.dllset_SqlGetHomeImageUrlfile_urlQueryItemSystemTrimGetPDFOrderMainSystem.ReflectionGetGoodsImageSubInfoGetGoodsTypeSubInfoGetGoodsSizeSubInfoGetGoodsOrderSubInfoGetGoodsColorSubInfoGetGoodsSubInfoGetGoodsOrderImageInfoGetGoodsTypeInfoGetGoodsSearchInfoGetGoodsOrderInfoAddLogisticsInfoDeleteLogisticsInfoSaveLogisticsInfoGetLogisticsInfoAddGoodsConllectInfoDeleteGoodsConllectInfoGetGoodsConllectInfoDeleteGoodsCartInfoGetGoodsTypeAssortInfoobj_vipj__TParj__TParj__TParj__TParIFormatProviderStringBuilderDAOrderCloudParameter.ctorSystem.DiagnosticsSystem.Runtime.InteropServicesSystem.Runtime.CompilerServicesDebuggingModesEqualsS001.WeiXin.DataAccessConcatFormatDbObjectGetget_DefaultptInsertSystem.TextDbArrayset_PrimaryKeyPageQueryDbFactoryop_Equalityop_InequalityCloud.Public.EntityCloudParamEntity{ }{{ id = {0} }}-{{ group_name = {0} }}%{{ openid = {0} }}-{{ vipuser_id = {0} }} SELECT CAST(a.id AS VARCHAR(30)) AS id,a.image_url,type_name,a.st_text,a.islogo, a.autoplay,a.interval,a.duration,isjump,a.styleid,CAST(ISNULL(b.id,'') AS VARCHAR(30)) AS style_id, CAST(c.id AS VARCHAR(30)) AS st_type_id,c.lookid AS st_type_lookid, c.name AS st_type_name,c.group_name AS st_type_group_name,c.image_url AS st_type_image_url FROM dbo.b_home_image AS a LEFT JOIN b_style AS b ON a.styleid = b.styleid LEFT JOIN b_looksub as c on b.st_type = c.id ORDER BY a.showorder SELECT CAST(a.id AS VARCHAR(30)) AS id,a.code,ISNULL(istext,0) AS istext,link_url,a.isvideo,link_text,isbold,iscenter, col_number,a.showorder,margin_top,margin_bottom,a.styleid,CAST(ISNULL(b.id,'') AS VARCHAR(30)) AS style_id, CAST(c.id AS VARCHAR(30)) AS st_type_id,c.lookid AS st_type_lookid, c.name AS st_type_name,c.group_name AS st_type_group_name,c.image_url AS st_type_image_url FROM b_home_link AS a LEFT JOIN b_style AS b ON a.styleid = b.styleid LEFT JOIN b_looksub as c on b.st_type = c.id WHERE a.code = @id ORDER BY a.code,a.showorder,ISNULL(CAST(a.isvideo AS INT), 99) SELECT CAST(a.id AS VARCHAR(30)) AS id,a.lookid,a.name,a.group_name,image_url FROM dbo.b_looksub AS a WHERE a.code = '1007'=AND a.group_name = @group_nameIORDER BY a.showorder,a.lookid,a.name SELECT CAST(b.id AS VARCHAR(30)) AS id,a.st_type,MAX(b.group_name) AS group_name, MAX(b.name) AS st_type_name,MAX(a.styleid) AS styleid,a.s_name FROM dbo.b_style AS a INNER JOIN b_looksub AS b ON a.st_type = b.id WHERE a.states = 2 search)AND a.s_name LIKE '%%'AND 1 = 2AGROUP BY b.id,a.st_type,a.s_name7st_type_name,styleid,s_nameid isVip SELECT CAST(a.id AS VARCHAR(30)) AS id,a.styleid,a.s_name,a.x_price,a.vip_price,a.isvideo, a.graphic,a.image_url,a.cr_date,a.showorder FROM dbo.b_style AS a WHERE a.st_type = @id AND a.states = 2 AND a.s_name LIKE '%M%' UNION ALL SELECT CAST(a.id AS VARCHAR(30)) AS id,a.styleid,a.s_name,a.x_price,a.vip_price,a.isvideo, a.graphic,a.image_url,a.cr_date,a.showorder FROM dbo.b_style AS a INNER JOIN b_style_type AS b ON a.id = b.style_id WHERE b.type_id = @id AND a.states = 2 AND a.s_name LIKE '%A%' AND a.st_type != b.type_id SELECT CAST(a.id AS VARCHAR(30)) AS id,a.styleid,a.s_name,a.x_price, a.isvideo,a.graphic,a.image_url,a.cr_date,a.showorder FROM dbo.b_style AS a WHERE a.st_type = @id AND a.states = 2 AND a.s_name LIKE '%5%' UNION ALL SELECT CAST(a.id AS VARCHAR(30)) AS id,a.styleid,a.s_name,a.x_price,a.isvideo, a.graphic,a.image_url,a.cr_date,a.showorder FROM dbo.b_style AS a INNER JOIN b_style_type AS b ON a.id = b.style_id WHERE b.type_id = @id AND a.states = 2 AND a.s_name LIKE '%=%' AND a.st_type != b.type_id=showorder,cr_date DESC,styleidC IF OBJECT_ID('tempdb..#temp')<>0 drop table #temp SELECT TOP 1 CAST(a.id AS VARCHAR(30)) AS id,a.styleid,a.s_name,a.x_price,a.vip_price,isvideo,graphic, a.comment,a.sell_day,0 AS retail_nums,a.image_url INTO #temp FROM dbo.b_style AS a WHERE a.id = @id ORDER BY a.cr_date DESC,a.styleid --/}.U UPDATE a SET a.retail_nums = ISNULL(b.retail_nums,0) FROM #temp AS a INNER JOIN ( SELECT SUM(nums) AS retail_nums FROM u_retail AS a INNER JOIN u_retailsub AS b ON a.id = b.code INNER JOIN b_clothing AS c ON b.clothing_id = c.id INNER JOIN #temp AS d ON c.style_id = d.id WHERE a.sure > 0 ) AS b ON 1 = 1 SELECT * FROM #temp SELECT CAST(b.id AS VARCHAR(100)) AS id,b.colorid,b.color_name,a.image_url FROM dbo.b_stylesubc AS a INNER JOIN dbo.b_color AS b ON a.color_id = b.id WHERE a.style_id = @id AND a.states = 1 AND EXISTS(SELECT TOP 1 1 FROM dbo.b_clothing AS t1 WHERE t1.style_id = a.style_id AND t1.color_id = a.color_id) ORDER BY b.showorder,b.colorid,b.color_name SELECT CAST(b.id AS VARCHAR(100)) AS id,b.sizeid,b.size_name FROM dbo.b_stylesubs AS a INNER JOIN dbo.b_size AS b ON a.size_id = b.id WHERE a.style_id = @id AND a.states = 1 AND EXISTS(SELECT TOP 1 1 FROM dbo.b_clothing AS t1 WHERE t1.style_id = a.style_id AND t1.size_id = a.size_id) ORDER BY b.showorder,b.sizeid,b.size_nameG SELECT CAST(a.id AS VARCHAR(100)) AS id,a.image_url FROM dbo.b_styleimage AS a WHERE a.style_id = @id AND ISNULL(a.image_url,'') != '' ORDER BY a.cr_date DESC SELECT CAST(b.id AS VARCHAR(30)) AS id,b.styleid,b.s_name,b.x_price,b.vip_price,b.image_url FROM dbo.b_stylepair AS a INNER JOIN dbo.b_style AS b ON a.pair_id = b.id WHERE a.style_id = @id AND b.states = 2 ORDER BY b.cr_date DESC,b.styleid' SELECT CAST(a.id AS VARCHAR(30)) AS id,name,a.st_mobtel,a.st_area,a.st_address,a.st_lable,a.param_default FROM dbo.b_logistics AS a WHERE a.vipuser_id = (SELECT TOP 1 id FROM dbo.vip_user AS a WHERE a.weixin_openid = @openid) ORDER BY a.param_default DESC,a.cr_date DESCdbo.b_logistics SELECT CAST(a.id AS VARCHAR(50)) AS id,a.code,a.cr_date, CASE WHEN ISNULL(a.states, 0) = 1 THEN '_N>k' WHEN ISNULL(a.states, 0) = 2 THEN '_S'' WHEN ISNULL(a.states, 0) = 3 THEN '_6e'' WHEN ISNULL(a.states, 0) = 4 THEN '][b' END AS states_text,a.online_order,pay_date, comment,exp_number,take_address,take_area,take_name,take_mobtel,sure_date, CAST(a.islogistics AS INT) AS islogistics,CAST(a.isinstall AS INT) AS isinstall,CAST(a.istax AS INT) AS istax, ISNULL(a.rebate_rate, 0) AS rebate_rate,ISNULL(CAST(a.isout AS INT), 0) AS isout FROM dbo.u_retail AS a WHERE a.vipuser_id = @vipuser_id AND ISNULL(a.states, 0) <> 0 AND ISNULL(a.states, 0) <> -99cur1!AND a.states = 12!AND a.states = 23!AND a.states = 34!AND a.states = 4Asure_date DESC,cr_date DESC,code IF OBJECT_ID('tempdb..#temp')<>0 DROP TABLE #temp SELECT CAST(b.id AS VARCHAR(100)) AS id,MAX(b.code) AS code, MAX(b.states_text) AS states_text,MAX(b.cr_date) AS cr_date, MAX(ISNULL(b.online_order,'')) AS online_order,MAX(pay_date) AS pay_date, MAX(exp_number) AS exp_number, MAX(take_address) AS take_address,MAX(take_area) AS take_area, MAX(b.comment) AS comment,MAX(sure_date) AS sure_date, MAX(take_name) AS take_name,MAX(take_mobtel) AS take_mobtel, SUM(a.nums) AS znums,MAX(b.islogistics) AS islogistics,MAX(b.isinstall) AS isinstall,MAX(b.istax) AS istax, ROUND(SUM(a.nums * a.s_price) + CASE WHEN MAX(b.islogistics) = 1 THEN SUM(a.nums * a.s_price) *  ELSE 0 END + CASE WHEN MAX(b.isinstall) = 1 THEN SUM(a.nums * a.s_price) * ELSE 0 END + CASE WHEN MAX(b.istax) = 1 THEN SUM(a.nums * a.s_price) * ELSE 0 END, 2) AS spsums, MAX(b.isout) AS isout, CAST(ISNULL(CAST(SUM(a.nums * a.s_price * ISNULL(b.rebate_rate, 0)) AS NUMERIC(18, 2)) / 100, 0) AS NUMERIC(18, 2)) AS rebate_sums INTO #temp FROM dbo.u_retailsub AS a INNER JOIN {0} AS b ON a.code = b.id GROUP BY b.id ORDER BY sure_date DESC,cr_date DESC,code SELECT * FROM #tempk IF OBJECT_ID('tempdb..#temp') <> 0 DROP TABLE #temp SELECT a.id INTO #temp FROM dbo.u_retail AS a WHERE a.vipuser_id = @vipuser_id SELECT a.code AS id,b.style_id, '' + '/' + MAX(c.image_url) AS image_url,MAX(c.s_name) AS s_name FROM dbo.u_retailsub AS a INNER JOIN dbo.b_clothing AS b ON a.clothing_id = b.id INNER JOIN dbo.b_style AS c ON b.style_id = c.id INNER JOIN #temp AS d ON a.code = d.id GROUP BY a.code,b.style_id# SELECT CAST(a.id AS VARCHAR(40)) AS id, CAST(c.id AS VARCHAR(40)) AS style_id,c.styleid,c.s_name, CAST(d.id AS VARCHAR(40)) AS color_id,d.colorid,d.color_name, CAST(e.id AS VARCHAR(40)) AS size_id,e.sizeid,e.size_name, a.nums,a.s_price,c.image_url FROM dbo.u_retailsub AS a INNER JOIN dbo.b_clothing AS b ON a.clothing_id = b.id INNER JOIN dbo.b_style AS c ON b.style_id = c.id INNER JOIN dbo.b_color AS d ON b.color_id = d.id INNER JOIN dbo.b_size AS e ON b.size_id = e.id WHERE a.code = @ids SELECT CAST(a.id AS VARCHAR(100)) AS id,CAST(b.id AS VARCHAR(100)) AS style_id,b.styleid,b.s_name, b.x_price,b.isvideo,b.graphic,b.image_url,b.cr_date,b.comment,c.group_name,'q' AS isVip FROM dbo.u_conllect AS a INNER JOIN dbo.b_style AS b ON a.style_id = b.id INNER JOIN b_looksub AS c ON b.st_type = c.id WHERE b.states = 2 AND a.vipuser_id = @vipuser_id SELECT CAST(a.id AS VARCHAR(100)) AS id,CAST(b.id AS VARCHAR(100)) AS style_id,b.styleid,b.s_name, b.x_price,b.vip_price,b.isvideo,b.graphic,b.image_url,b.cr_date,b.comment,c.group_name,')cr_date DESC,styleidu_conllectIDELETE FROM u_conllect WHERE id IN (){SELECT code,a.cr_date FROM dbo.u_retail AS a WHERE a.id = @idKDELETE FROM u_retailsub WHERE id IN (V\M@;      Q  qq   yaY a Y  aYae  ee am m   aae  Y z\V4     Y] e]ei e]emi m]mi Y]i ] ] ] Y]m e]em m](TWrapNonExceptionThrowsS001.WeiXin.DataAccessCopyright © 2021)$dcfa3b6e-a68e-41ad-9801-386e5009243c 1.0.0.0G.NETFramework,Version=v4.0TFrameworkDisplayName.NET Framework 4!\{ }TType+\{ id = {id} }TType;\{ group_name = {group_name} }TType3\{ openid = {openid} }TType;\{ vipuser_id = {vipuser_id} }TTypebagRSDSNT&܅D:\Project\iShop3\项目源码\WeChatCode\WeChatCode\Code\01 接口\S001.WeiXin.DataAccess\obj\Debug\S001.WeiXin.DataAccess.pdb| _CorDllMainmscoree.dll% 0HX4VS_VERSION_INFO?DVarFileInfo$TranslationStringFileInfo000004b0Comments"CompanyNameVFileDescriptionS001.WeiXin.DataAccess0FileVersion1.0.0.0VInternalNameS001.WeiXin.DataAccess.dllHLegalCopyrightCopyright 2021*LegalTrademarks^OriginalFilenameS001.WeiXin.DataAccess.dllNProductNameS001.WeiXin.DataAccess4ProductVersion1.0.0.08Assembly Version1.0.0.0 6