| New file |
| | |
| | | 2024/1/15 15:52:47 æå°sql:select * from h_v_IF_POInStockBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(100016479000000000) order by hmainid desc |
| | | |
| | | 2024/1/15 15:52:47 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022; |
| | | |
| | | 2024/1/15 15:52:47 ReportDataSet:0 |
| | | |
| | | 2024/1/15 15:52:55 æå°sql:select * from h_v_IF_POInStockBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(100016479000000000) order by hmainid desc |
| | | |
| | | 2024/1/15 15:52:55 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022; |
| | | |
| | | 2024/1/15 15:52:55 ReportDataSet:0 |
| | | |
| | | 2024/1/15 15:53:08 æå°sql:select * from h_v_IF_POInStockBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(100016479000000000,100015491000000000) order by hmainid desc |
| | | |
| | | 2024/1/15 15:53:08 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022; |
| | | |
| | | 2024/1/15 15:53:08 ReportDataSet:0 |
| | | |
| | | 2024/1/15 15:53:29 æå°sql:select * from h_v_IF_POOrderBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(47500100249) order by hmainid desc |
| | | |
| | | 2024/1/15 15:53:29 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022; |
| | | |
| | | 2024/1/15 15:53:29 ReportDataSet:1 |
| | | |
| | | 2024/1/15 15:53:45 æå°sql:select * from h_v_IF_POOrderBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(47500100249) order by hmainid desc |
| | | |
| | | 2024/1/15 15:53:45 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022; |
| | | |
| | | 2024/1/15 15:53:45 ReportDataSet:1 |
| | | |
| | | 2024/1/15 15:54:46 æå°sql:select * from h_v_IF_POOrderBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(47500100249) order by hmainid desc |
| | | |
| | | 2024/1/15 15:54:46 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022; |
| | | |
| | | 2024/1/15 15:54:46 ReportDataSet:1 |
| New file |
| | |
| | | 2024/1/16 8:47:13 æå°sql:select * from h_v_IF_POOrderBillList where cast( hmainid as bigint)*POWER(10,8)+hsubid in(47500100249) order by hmainid desc |
| | | |
| | | 2024/1/16 8:47:13 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022; |
| | | |
| | | 2024/1/16 8:47:13 ReportDataSet:1 |
| | | |
| | | 2024/1/16 9:24:38 æå°sql:select max(åæ®å·)åæ®å·,max(é¨é¨)é¨é¨,max(æ¥æ)æ¥æ,ç©æä»£ç ,max(ç©æåç§°)ç©æåç§°,è§æ ¼åå·,sum(æ°é)æ°é,max(计éåä½)计éåä½,max(ä¾åºå)ä¾åºå from h_v_IF_POInStockBackBillList where hmainid=100002 group by ç©æä»£ç ,è§æ ¼åå· order by åæ®å· |
| | | |
| | | 2024/1/16 9:24:38 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022; |
| | | |
| | | 2024/1/16 9:24:38 ReportDataSet:1 |
| | | |
| | | 2024/1/16 9:27:52 æå°sql:select max(åæ®å·)åæ®å·,max(é¨é¨)é¨é¨,max(æ¥æ)æ¥æ,ç©æä»£ç ,max(ç©æåç§°)ç©æåç§°,è§æ ¼åå·,sum(æ°é)æ°é,max(计éåä½)计éåä½,max(ä¾åºå)ä¾åºå from h_v_IF_POInStockBackBillList where hmainid=1515 group by ç©æä»£ç ,è§æ ¼åå· order by åæ®å· |
| | | |
| | | 2024/1/16 9:27:52 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022; |
| | | |
| | | 2024/1/16 9:27:52 ReportDataSet:1 |
| | | |
| | | 2024/1/16 9:28:03 æå°sql:select max(åæ®å·)åæ®å·,max(é¨é¨)é¨é¨,max(æ¥æ)æ¥æ,ç©æä»£ç ,max(ç©æåç§°)ç©æåç§°,è§æ ¼åå·,sum(æ°é)æ°é,max(计éåä½)计éåä½,max(ä¾åºå)ä¾åºå from h_v_IF_POInStockBackBillList where hmainid=1515 group by ç©æä»£ç ,è§æ ¼åå· order by åæ®å· |
| | | |
| | | 2024/1/16 9:28:03 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022; |
| | | |
| | | 2024/1/16 9:28:03 ReportDataSet:1 |
| | | |
| | | 2024/1/16 9:37:14 æå°sql:select max(åæ®å·)åæ®å·,max(é¨é¨)é¨é¨,max(æ¥æ)æ¥æ,ç©æä»£ç ,max(ç©æåç§°)ç©æåç§°,è§æ ¼åå·,sum(æ°é)æ°é,max(计éåä½)计éåä½,max(ä¾åºå)ä¾åºå from h_v_IF_POInStockBackBillList where hmainid=100002 group by ç©æä»£ç ,è§æ ¼åå· order by åæ®å· |
| | | |
| | | 2024/1/16 9:37:15 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022; |
| | | |
| | | 2024/1/16 9:37:15 ReportDataSet:1 |
| | |
| | | <Content Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\HBarPlanPrint_GXPG.html" /> |
| | | <Content Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_Kf_SellOutBillList.aspx" /> |
| | | <Content Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_Kf_SellOutBillList_BarCodeNote.aspx" /> |
| | | <Content Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_HPOInStockBackBill.aspx" /> |
| | | <Content Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_Sc_ICMOChangeBillList.aspx" /> |
| | | <Content Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_Sc_ProcessExchangeArrangement.aspx" /> |
| | | <Content Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_Kf_MateOutBillList.aspx" /> |
| | |
| | | <Content Include="views\grf\ä¸è¯ç±»å.grf" /> |
| | | <Content Include="views\grf\å¼å¸¸ç±»å.grf" /> |
| | | <Content Include="views\grf\ç产订åé¢æç¶ææ¥è¡¨.grf" /> |
| | | <Content Include="views\grf\éæéç¥å.grf" /> |
| | | <None Include="Web.Debug.config"> |
| | | <DependentUpon>Web.config</DependentUpon> |
| | | </None> |
| | |
| | | <Compile Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_Kf_SellOutBillList_BarCodeNote.aspx.designer.cs"> |
| | | <DependentUpon>xmlLBM_Kf_SellOutBillList_BarCodeNote.aspx</DependentUpon> |
| | | </Compile> |
| | | <Compile Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_HPOInStockBackBill.aspx.cs"> |
| | | <DependentUpon>xmlLBM_HPOInStockBackBill.aspx</DependentUpon> |
| | | <SubType>ASPXCodeBehind</SubType> |
| | | </Compile> |
| | | <Compile Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_HPOInStockBackBill.aspx.designer.cs"> |
| | | <DependentUpon>xmlLBM_HPOInStockBackBill.aspx</DependentUpon> |
| | | </Compile> |
| | | <Compile Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_Sc_ICMOChangeBillList.aspx.cs"> |
| | | <DependentUpon>xmlLBM_Sc_ICMOChangeBillList.aspx</DependentUpon> |
| | | <SubType>ASPXCodeBehind</SubType> |
| | |
| | | <?xml version="1.0" encoding="utf-8"?> |
| | | <Project ToolsVersion="12.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> |
| | | <PropertyGroup> |
| | | <NameOfLastUsedPublishProfile>D:\ç½ç«åå¸\å端代ç \MES-WEB-TM\MESWMS-LayUI\WebTM\Properties\PublishProfiles\JFTM.pubxml</NameOfLastUsedPublishProfile> |
| | | <NameOfLastUsedPublishProfile>D:\ä¹ä¸è®¡éåä½å表\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\JFTM.pubxml</NameOfLastUsedPublishProfile> |
| | | <ProjectView>ProjectFiles</ProjectView> |
| | | <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig> |
| | | <UseIISExpress>true</UseIISExpress> |
| | |
| | | //var WEBURL = "http://61.164.86.218:8099/ABAPI/"; |
| | | //var WEBURL = "http://localhost/API/"; //颿忬å°é
ç½® |
| | | //var WEBURL = "http://localhost:8082/LuBaoAPI/"; //æ¨ä¹æ¬å°é
ç½® |
| | | var WEBURL = "http://localhost:8082/API/"; //æè´ºæ¬å°é
ç½® |
| | | //var WEBURL = "http://localhost:8082/API/"; //æè´ºæ¬å°é
ç½® |
| | | //var WEBURL = "http://localhost:8082/API/"; //å¼ ç广æ¬å°é
ç½® |
| | | //var WEBURL = "http://localhost:81/API/"; //éé¯éæ¬å°é
ç½® |
| | | var WEBURL = "http://localhost:81/API/"; //éé¯éæ¬å°é
ç½® |
| | | //var WEBURL = "http://localhost:8082/LuBaoAPI/"; //ä½ææ°æ¬å°é
ç½® |
| | | //var WEBURL = "http://localhost:8088/ARAPI/"; //ä½ææ°æ¬å°é
ç½®(å®ç) |
| | | //var WEBURL = "http://10.1.4.155/API/"; //æ±ä¸°å®¢æ·NEW |
| New file |
| | |
| | | { |
| | | "Version":"6.8.2.2", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Size":105000, |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "Printer":{ |
| | | "Oriention":"Landscape", |
| | | "LeftMargin":1.5, |
| | | "TopMargin":0.5, |
| | | "RightMargin":1.5, |
| | | "BottomMargin":0.5 |
| | | }, |
| | | "DetailGrid":{ |
| | | "Recordset":{ |
| | | "Field":[ |
| | | { |
| | | "Name":"æ¥æ", |
| | | "Type":"DateTime", |
| | | "Format":"yyyy//MM//dd" |
| | | }, |
| | | { |
| | | "Name":"ä¾åºå" |
| | | }, |
| | | { |
| | | "Name":"ç©æä»£ç " |
| | | }, |
| | | { |
| | | "Name":"ç©æåç§°" |
| | | }, |
| | | { |
| | | "Name":"è§æ ¼åå·" |
| | | }, |
| | | { |
| | | "Name":"计éåä½" |
| | | }, |
| | | { |
| | | "Name":"åä»·", |
| | | "Type":"Currency" |
| | | }, |
| | | { |
| | | "Name":"éé¢", |
| | | "Type":"Currency" |
| | | }, |
| | | { |
| | | "Name":"å«ç¨åä»·", |
| | | "Type":"Currency" |
| | | }, |
| | | { |
| | | "Name":"ä¸å¡å" |
| | | }, |
| | | { |
| | | "Name":"è®¢åæ°é", |
| | | "Type":"Integer", |
| | | "Format":"0.####" |
| | | }, |
| | | { |
| | | "Name":"æ°é" |
| | | }, |
| | | { |
| | | "Name":"åæ®å·" |
| | | }, |
| | | { |
| | | "Name":"æºååå·" |
| | | }, |
| | | { |
| | | "Name":"äº¤è´§æ¥æ", |
| | | "Type":"DateTime" |
| | | }, |
| | | { |
| | | "Name":"é¨é¨" |
| | | } |
| | | ] |
| | | }, |
| | | "Column":[ |
| | | { |
| | | "Name":"åºå·", |
| | | "Width":0.7673 |
| | | }, |
| | | { |
| | | "Name":"计åè·è¸ªå·", |
| | | "Width":2.8046 |
| | | }, |
| | | { |
| | | "Name":"ç©æ", |
| | | "Width":3.4131 |
| | | }, |
| | | { |
| | | "Name":"è§æ ¼åå·", |
| | | "Width":3.4131 |
| | | }, |
| | | { |
| | | "Name":"Column2", |
| | | "Width":2.1696 |
| | | }, |
| | | { |
| | | "Name":"Column3", |
| | | "Width":2.5665 |
| | | }, |
| | | { |
| | | "Name":"Column4", |
| | | "Width":2.43417 |
| | | }, |
| | | { |
| | | "Name":"Column5", |
| | | "Width":3.81 |
| | | }, |
| | | { |
| | | "Name":"Column6", |
| | | "Width":2.80458 |
| | | }, |
| | | { |
| | | "Name":"Column7", |
| | | "Width":2.6458 |
| | | } |
| | | ], |
| | | "ColumnContent":{ |
| | | "Height":1.00542, |
| | | "ColumnContentCell":[ |
| | | { |
| | | "Column":"åºå·", |
| | | "FreeCell":true, |
| | | "Control":[ |
| | | { |
| | | "Type":"SystemVarBox", |
| | | "Name":"SystemVarBox1", |
| | | "Dock":"Fill", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "SystemVar":"RowNo" |
| | | } |
| | | ] |
| | | }, |
| | | { |
| | | "Column":"计åè·è¸ªå·", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "DataField":"åæ®å·" |
| | | }, |
| | | { |
| | | "Column":"ç©æ", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "DataField":"ç©æä»£ç " |
| | | }, |
| | | { |
| | | "Column":"è§æ ¼åå·", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "DataField":"ç©æåç§°" |
| | | }, |
| | | { |
| | | "Column":"Column2", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "DataField":"æ°é" |
| | | }, |
| | | { |
| | | "Column":"Column3", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "DataField":"计éåä½" |
| | | }, |
| | | { |
| | | "Column":"Column4", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "DataField":"é¨é¨" |
| | | }, |
| | | { |
| | | "Column":"Column5", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "DataField":"æ¥æ" |
| | | }, |
| | | { |
| | | "Column":"Column6", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "DataField":"ä¾åºå" |
| | | }, |
| | | { |
| | | "Column":"Column7", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "DataField":"æºååå·" |
| | | } |
| | | ] |
| | | }, |
| | | "ColumnTitle":{ |
| | | "Height":0.79375, |
| | | "RepeatStyle":"OnPage", |
| | | "ColumnTitleCell":[ |
| | | { |
| | | "GroupTitle":false, |
| | | "Column":"åºå·", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "Text":"åºå·" |
| | | }, |
| | | { |
| | | "GroupTitle":false, |
| | | "Column":"计åè·è¸ªå·", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "Text":"éæéç¥åå·" |
| | | }, |
| | | { |
| | | "GroupTitle":false, |
| | | "Column":"ç©æ", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "Text":"ç©æä»£ç " |
| | | }, |
| | | { |
| | | "GroupTitle":false, |
| | | "Column":"è§æ ¼åå·", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "Text":"ç©æåç§°" |
| | | }, |
| | | { |
| | | "GroupTitle":false, |
| | | "Column":"Column2", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "Text":"æ°é" |
| | | }, |
| | | { |
| | | "GroupTitle":false, |
| | | "Column":"Column3", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "Text":"åä½" |
| | | }, |
| | | { |
| | | "GroupTitle":false, |
| | | "Column":"Column4", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "Text":"é¨é¨" |
| | | }, |
| | | { |
| | | "GroupTitle":false, |
| | | "Column":"Column5", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "Text":"æ¥æ" |
| | | }, |
| | | { |
| | | "GroupTitle":false, |
| | | "Column":"Column6", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "Text":"ä¾åºå" |
| | | }, |
| | | { |
| | | "GroupTitle":false, |
| | | "Column":"Column7", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Weight":400, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"MiddleCenter", |
| | | "Text":"éè´è®¢åå·" |
| | | } |
| | | ] |
| | | }, |
| | | "Group":[ |
| | | { |
| | | "Name":"Group1", |
| | | "GroupHeader":{ |
| | | "Height":0 |
| | | }, |
| | | "GroupFooter":{ |
| | | "Height":0 |
| | | } |
| | | } |
| | | ] |
| | | }, |
| | | "ReportHeader":[ |
| | | { |
| | | "Name":"ReportHeader1", |
| | | "Height":3.81, |
| | | "Control":[ |
| | | { |
| | | "Type":"MemoBox", |
| | | "Name":"MemoBox1", |
| | | "Left":7.59, |
| | | "Top":1.59, |
| | | "Width":11.62, |
| | | "Height":0.87, |
| | | "Border":{ |
| | | "Styles":"[DrawBottom]" |
| | | }, |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Size":180000, |
| | | "Bold":true, |
| | | "Charset":134 |
| | | }, |
| | | "TextAlign":"TopCenter", |
| | | "Text":"é æ é ç¥ å\r\n" |
| | | }, |
| | | { |
| | | "Type":"Barcode", |
| | | "Name":"Barcode2", |
| | | "Left":21.59, |
| | | "Top":0.79, |
| | | "Width":3.59833, |
| | | "Height":2.80458, |
| | | "BarcodeType":"QRCode", |
| | | "CaptionPosition":"None", |
| | | "Text":"[#åæ®å·#]", |
| | | "Font":{ |
| | | "Name":"å®ä½", |
| | | "Size":82500, |
| | | "Weight":400, |
| | | "Charset":134 |
| | | } |
| | | } |
| | | ], |
| | | "RepeatOnPage":true |
| | | } |
| | | ], |
| | | "ReportFooter":[ |
| | | { |
| | | "Name":"ReportFooter1", |
| | | "Height":4.78896, |
| | | "RepeatOnPage":true |
| | | } |
| | | ] |
| | | } |
| | |
| | | case "Sc_ICMOChangeBillList": //ç产订ååæ´å |
| | | CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_Sc_ICMOChangeBillList.aspx?linterid=" + value, true, ""); |
| | | break; |
| | | case "HPOInStockBackBill": //éæéç¥å |
| | | CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_HPOInStockBackBill.aspx?linterid=" + value, true, ""); |
| | | break; |
| | | } |
| | | </script> |
| | | </body> |
| New file |
| | |
| | | <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="xmlLBM_HPOInStockBackBill.aspx.cs" Inherits="WebTM.views.åºç¡èµæ.å
¬ç¨åºç¡èµæ.xmlLBM_MouldRepairOutStockBill" %> |
| | | |
| | | <!DOCTYPE html> |
| | | |
| | | <html xmlns="http://www.w3.org/1999/xhtml"> |
| | | <head runat="server"> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> |
| | | <title></title> |
| | | <script runat="server"> |
| | | protected void Page_Load(object sender, EventArgs e) |
| | | { |
| | | //â
ç¹å«æç¤ºâ
ï¼ |
| | | //ä¸åçæ°æ®åºåºè¯¥éç¨ä¸åçæ¥è¡¨XMLæ°æ®çæç±»ï¼SQL Serveræ°æ®åºç¨SqlXMLReportDataï¼Oracleæ°æ®åºç¨OracleXMLReportData |
| | | //OledbXMLReportDataéåäºAccessçæ¬å°æ°æ®åºï¼ä¸ºäºæ¼ç¤ºæ¹ä¾¿ï¼è¿éä»Grid++ReportçAccessä¾åæ°æ®åºä¸è·åæ¥è¡¨æ°æ® |
| | | |
| | | //OledbXMLReportData.GenOneRecordset(this, "select * from Customers order by CustomerID"); |
| | | //SqlXMLReportData.GenOneRecordset(this, "select * from h_v_Kf_POStockInBillList_K3 where hmainid=1781"); |
| | | SqlXMLReportData.GenOneRecordset(this, "select max(åæ®å·)åæ®å·,max(é¨é¨)é¨é¨,max(æ¥æ)æ¥æ,ç©æä»£ç ,max(ç©æåç§°)ç©æåç§°,è§æ ¼åå·,sum(æ°é)æ°é,max(计éåä½)计éåä½,max(ä¾åºå)ä¾åºå from h_v_IF_POInStockBackBillList where hmainid=" + Request.Params["linterid"]+ " group by ç©æä»£ç ,è§æ ¼åå· order by åæ®å·"); |
| | | } |
| | | </script> |
| | | </head> |
| | | <body> |
| | | <form id="form1" runat="server"> |
| | | <div> |
| | | </div> |
| | | </form> |
| | | </body> |
| | | </html> |
| New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using System.Web; |
| | | using System.Web.UI; |
| | | using System.Web.UI.WebControls; |
| | | |
| | | namespace WebTM.views.åºç¡èµæ.å
¬ç¨åºç¡èµæ |
| | | { |
| | | public partial class xmlLBM_HPOInStockBackBill : System.Web.UI.Page |
| | | { |
| | | protected void Page_Load(object sender, EventArgs e) |
| | | { |
| | | |
| | | } |
| | | } |
| | | } |
| New file |
| | |
| | | //------------------------------------------------------------------------------ |
| | | // <èªå¨çæ> |
| | | // æ¤ä»£ç ç±å·¥å
·çæã |
| | | // |
| | | // å¯¹æ¤æä»¶çæ´æ¹å¯è½å¯¼è´ä¸æ£ç¡®çè¡ä¸ºï¼å¦æ |
| | | // éæ°çæä»£ç ï¼åæåæ´æ¹å°ä¸¢å¤±ã |
| | | // </èªå¨çæ> |
| | | //------------------------------------------------------------------------------ |
| | | |
| | | namespace WebTM.views.åºç¡èµæ.å
¬ç¨åºç¡èµæ |
| | | { |
| | | |
| | | |
| | | public partial class xmlLBM_HPOInStockBackBill |
| | | { |
| | | |
| | | /// <summary> |
| | | /// form1 æ§ä»¶ã |
| | | /// </summary> |
| | | /// <remarks> |
| | | /// èªå¨çæçåæ®µã |
| | | /// è¥è¦è¿è¡ä¿®æ¹ï¼è¯·å°å段声æä»è®¾è®¡å¨æä»¶ç§»å°ä»£ç éèæä»¶ã |
| | | /// </remarks> |
| | | protected global::System.Web.UI.HtmlControls.HtmlForm form1; |
| | | } |
| | | } |
| | |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-DeClose" id="DeClose"><i class="layui-icon layui-icon-radio"></i>åå
³é</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Drop" id="Drop"><i class="layui-icon layui-icon-radio"></i>ä½åº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-DeDrop" id="DeDrop"><i class="layui-icon layui-icon-radio"></i>åä½åº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print" id="print"><i class="layui-icon layui-icon-print"></i>æå°</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>æé®è®¾ç½®</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button> |
| | |
| | | //éåºæé® |
| | | case 'get_Exit': Pub_Close(2); |
| | | break; |
| | | //æå° |
| | | case 'btn-print': |
| | | get_PrintReport(); |
| | | break; |
| | | //å设置 |
| | | case 'set_HideColumn': get_HideColumn(); |
| | | break; |
| | |
| | | } |
| | | //#endregion |
| | | |
| | | //#region æå° |
| | | function get_PrintReport() { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | | |
| | | if (checkStatus.data.length === 0) { |
| | | return layer.msg('è¯·éæ©æ°æ®æå°ï¼'); |
| | | } |
| | | else { |
| | | var hmainid = []; |
| | | |
| | | for (var i = 0; i < checkStatus.data.length; i++) { |
| | | hmainid.push((data[i].hmainid * (10 ** 8)) + data[i].hsubid) |
| | | } |
| | | |
| | | layer.open({ |
| | | type: 2 |
| | | , area: ['50%', '50%'] |
| | | , title: 'æå°æ¨¡çéæ©' |
| | | , shade: 0.6 //é®ç½©éæåº¦ |
| | | , maxmin: false //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + data[0].hmainid.toString() + '&MyMsg=' + data[0].hmainid.toString() + '&Type=HPOInStockBackBill', 'yes'] |
| | | , resize: false |
| | | }) |
| | | } |
| | | } |
| | | //#endregion |
| | | |
| | | //#region å·æ° |
| | | function get_Refresh() { |