Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-LayUI
| 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> |
| 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; |
| | | } |
| | | } |
| | |
| | | <div class="layui-col-xs4 layui-inline"> |
| | | <label class="layui-form-label">éåå·</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="Box2" id="Box2" autocomplete="off"> |
| | | <input type="text" name="" id="" class="layui-input" value="" style="float:left;width:150px;"> |
| | | |
| | | <button type="button" lay-submit="" class="layui-btn" lay-filter="XDHList" id="XDHList" style="width:40px;"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i> |
| | | </button> |
| | | </div> |
| | | <!--<label class="layui-form-label">éåå·</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="Box2" id="Box2" autocomplete="off"> |
| | | </div>--> |
| | | </div> |
| | | |
| | | </div> |
| | |
| | | var rowdata = [{ |
| | | "HMaterID": 0, "ç©æä»£ç ": "", "ç©æåç§°": "", "è§æ ¼åå·": "", "HUnitID": 0, "计éåä½": "", "HWHID": 0, "æ¶æä»åº": "", |
| | | "HSPID": 0, "æ¶æä»ä½": "", "HSecUnitID": 0, "è¾
å©åä½": "", "HQty": "0", "HRemark": "" |
| | | , "HPrice": "0", "HTaxPrice": "0", "HMoney": "0", "HDiscountRate": "0", "HTaxRate": "0", "HTaxMoney": "0" |
| | | , "HPrice": "0", "HTaxPrice": "0", "HMoney": "0", "HDiscountRate": "0", "HTaxRate": "0", "HTaxMoney": "0", |
| | | "HSourceBillNo": 0, "HSourceBillType": 0, "HSourceInterID": 0, "HSourceEntryID": 0 |
| | | }]; |
| | | |
| | | // åå§åç |
| | |
| | | //æ°å¢è¡è¡¨æ ¼æ°æ® |
| | | var NewRow = { |
| | | "HMaterID": 0, "ç©æä»£ç ": "", "ç©æåç§°": "", "è§æ ¼åå·": "", "HUnitID": 0, "计éåä½": "", "HWHID": 0, "æ¶æä»åº": "", |
| | | "HSPID": 0, "æ¶æä»ä½": "", "HSecUnitID": data.HSecUnitID, "è¾
å©åä½":data.è¾
å©åä½, "HQty": "0", "HRemark": "" |
| | | , "HPrice": "0", "HTaxPrice": "0", "HMoney": "0", "HDiscountRate": "0", "HTaxRate": "0", "HTaxMoney": "0" |
| | | "HSPID": 0, "æ¶æä»ä½": "", "HSecUnitID": data.HSecUnitID, "è¾
å©åä½": data.è¾
å©åä½, "HQty": "0", "HRemark": "" |
| | | , "HPrice": "0", "HTaxPrice": "0", "HMoney": "0", "HDiscountRate": "0", "HTaxRate": "0", "HTaxMoney": "0", |
| | | "HSourceBillNo": 0, "HSourceBillType": 0, "HSourceInterID": 0, "HSourceEntryID": 0, |
| | | }; |
| | | switch (obj.event) { |
| | | case 'btn-AddLine': |
| | |
| | | , HPrice: HPrice |
| | | , HMoney: HMoney |
| | | }); |
| | | /* table.render(option);*/ |
| | | /* table.render(option);*/ |
| | | break; |
| | | case "HPrice": //åä»· |
| | | //æ°æ®æ ¼å¼æ ¡éª |
| | |
| | | obj.update({ |
| | | HPrice: oldText |
| | | }); |
| | | /* table.render(option);*/ |
| | | /* table.render(option);*/ |
| | | |
| | | layer.msg("å价请è¾å
¥å¤§äº0çæ°å!"); |
| | | return; |
| | |
| | | |
| | | //æ°æ®æ ¡éªåæ ¼ï¼éç®è®°å½ |
| | | var HQty = obj.data.HQty * 1; //æ°é |
| | | var HPrice = value * 1; |
| | | var HPrice = value * 1; |
| | | var HMoney = HQty * HPrice; //éé¢=æ°é*åä»· |
| | | |
| | | |
| | |
| | | , cols: [[ //å表 |
| | | { type: 'checkbox', totalRowText: 'å计è¡' } |
| | | , { type: 'numbers', title: 'åºå·', width: 100, totalRow: true } |
| | | , { type: 'HSourceBillNo', title: 'æºåå·', width: 100, hide: true }//æºåå· |
| | | , { field: 'HSourceBillType', title: 'æºåç±»å', width: 100, hide: true }//æºåç±»å |
| | | , { type: 'HSourceInterID', title: 'æºå主å
ç ', width: 100, hide: true }//æºå主å
ç |
| | | , { field: 'HSourceEntryID', title: 'æºååå
ç ', width: 100, hide: true }//æºååå
ç |
| | | , { field: 'HMaterID', title: 'HMaterID', width: 100, hide: true } |
| | | , { field: 'ç©æä»£ç ', title: 'ç©æä»£ç ', width: 150, edit: 'text', event: "HMaterID" }//f7 |
| | | , { field: 'ç©æåç§°', title: 'ç©æåç§°', width: 150, } |
| | |
| | | ]] |
| | | } |
| | | |
| | | option.data = rowdata; |
| | | option.data = []; |
| | | table.render(option); |
| | | } |
| | | |
| | |
| | | { |
| | | "HMaterID": data.HMaterID, "ç©æä»£ç ": data.ç©æä»£ç , "ç©æåç§°": data.ç©æåç§°, "è§æ ¼åå·": data.è§æ ¼åå·, "HUnitID": data.HUnitID, "计éåä½": data.计éåä½, "HWHID": data.HWHID, "æ¶æä»åº": data.æ¶æä»åº, |
| | | "HSPID": data.HSPID, "æ¶æä»ä½": data.ä»ä½åç§°, "HSecUnitID": data.HSecUnitID, "è¾
å©åä½": data.è¾
å©åä½, "HQty": data.æ°é, "HRemark": data.表ä½å¤æ³¨ |
| | | , "HPrice": data.åä»·, "HTaxPrice": data.å«ç¨åä»·, "HMoney": data.éé¢, "HDiscountRate": data.ææ£ç, "HTaxRate": data.ç¨ç, "HTaxMoney": data.ç¨é¢ |
| | | , "HPrice": data.åä»·, "HTaxPrice": data.å«ç¨åä»·, "HMoney": data.éé¢, "HDiscountRate": data.ææ£ç, "HTaxRate": data.ç¨ç, "HTaxMoney": data.ç¨é¢, |
| | | "HSourceBillNo": data.æºååå·, //æºåå· |
| | | "HSourceBillType": data.æºåç±»å, //æºåç±»å |
| | | "HSourceInterID": data.æºå主å
ç , //æºå主å
ç |
| | | "HSourceEntryID": data.æºååå
ç //æºååå
ç |
| | | } |
| | | ) |
| | | } |
| | |
| | | table.cache["mainTable"][i].LAY_TABLE_INDEX = i; |
| | | num.push(table.cache["mainTable"][i]) |
| | | } |
| | | } |
| | | |
| | | checkDuplicateData(num); |
| | | const duplicateRows = checkDuplicateData(num); |
| | | if (duplicateRows.length > 0) { |
| | | let message = 'è¡¨æ ¼ä¸åå¨é夿°æ®ï¼éå¤è¡æ°ä¸ºï¼'; |
| | | |
| | | for (let i = 0; i < duplicateRows.length; i++) { |
| | | const { row1, row2 } = duplicateRows[i]; |
| | | message += `第${row1}è¡ä¸ç¬¬${row2}è¡ç¸å`; |
| | | |
| | | if (i !== duplicateRows.length - 1) { |
| | | message += 'ï¼'; |
| | | } |
| | | } |
| | | |
| | | message += 'ï¼è¯·å é¤å
¶ä¸ä¸è¡'; |
| | | layer.alert(message); |
| | | } |
| | | |
| | | var sMainStr = JSON.stringify(data.field); |
| | |
| | | }) |
| | | } |
| | | |
| | | //表头信æ¯éæ©åæ®å¼¹çª |
| | | form.on('submit(XDHList)', function () { |
| | | |
| | | //页é¢å±-èªå®ä¹ |
| | | layer.open({ |
| | | type: 2 |
| | | , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ |
| | | , title: "éè´å
¥åºåå表" //æ é¢ |
| | | , closeBtn: 1 //çªä½å³ä¸è§å
³é ç æ ·å¼ |
| | | , shift: 2 //å¼¹åºå¨ç» |
| | | , area: ["90%", "90%"] //çªä½å¤§å° |
| | | , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º |
| | | , content: ["../../éè´ç®¡ç/éè´è®¢å/Cg_POOrderBillList.html", "yes"] |
| | | , btn: ["ç¡®å®", "åæ¶"] |
| | | , btn1: function (index, laero) { |
| | | //æé®ä¸ çåè° |
| | | var iframeWindow = window["layui-layer-iframe" + index];//è·åå¼¹æ¡é¡µé¢ |
| | | var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//è·åéä¸çæ°æ® |
| | | |
| | | if (checkStatus.data.length == 0) { |
| | | return layer.msg("请è³å°éæ©ä¸æ¡æ°æ®!"); |
| | | } |
| | | layer.alert("ä½ å·²éæ©" + checkStatus.data.length + "æ¡æ°æ®"); |
| | | //è·åæ¶æéç¥å代ç |
| | | var ProcessNumber = []; |
| | | for (var i = 0; i < checkStatus.data.length; i++) { |
| | | ProcessNumber.push(checkStatus.data[i]); |
| | | } |
| | | |
| | | //è·åå½åä½ç½®æå¨è¡æ° |
| | | var NowNum = 0; |
| | | NowNum = option.data.length; |
| | | |
| | | var j = 0; |
| | | for (var i = 0; i < ProcessNumber.length; i++) { |
| | | option.data.push({ |
| | | "HMaterID": checkStatus.data[j].HMaterID, "ç©æä»£ç ": checkStatus.data[j].ç©æä»£ç , "ç©æåç§°": checkStatus.data[j].ç©æåç§°, "è§æ ¼åå·": checkStatus.data[j].è§æ ¼åå·, |
| | | "HUnitID": checkStatus.data[j].HUnitID, "计éåä½": checkStatus.data[j].计éåä½, |
| | | "HQty": checkStatus.data[j].æ°é, "HPrice": checkStatus.data[j].åä»·, |
| | | "HMoney": checkStatus.data[j].éé¢, "HTaxPrice": checkStatus.data[j].å«ç¨åä»·, "HTaxRate": checkStatus.data[j].ç¨ç, "HTaxMoney": checkStatus.data[j].ç¨é¢, |
| | | "HSourceBillNo": checkStatus.data[j].åæ®å·, "HSourceBillType": checkStatus.data[j].HBillType, "HSourceInterID": checkStatus.data[j].hmainid, "HSourceEntryID": checkStatus.data[j].hsubid, |
| | | }) |
| | | j++; |
| | | } |
| | | table.render(option); |
| | | layer.close(index);//å
³éå¼¹çª |
| | | } |
| | | |
| | | }); |
| | | }); |
| | | |
| | | //夿æéçä¸è¡¨æ ¼æ¯å¦æé夿°æ® |
| | | function checkDuplicateData(data) { |
| | | const duplicates = []; |
| | | |
| | | for (let i = 0; i < data.length; i++) { |
| | | const currentItem = data[i]; |
| | | let isDuplicate = false; |
| | | |
| | | for (let j = i + 1; j < data.length; j++) { |
| | | const compareItem = data[j]; |
| | | //主åid |
| | | if (currentItem.HSourceInterID === compareItem.HSourceInterID && currentItem.HSourceEntryID === compareItem.HSourceEntryID) { |
| | | isDuplicate = true; |
| | | duplicates.push({ row1: i + 1, row2: j + 1 }); // è®°å½é夿°æ®æå¨è¡æ° |
| | | } |
| | | } |
| | | if (isDuplicate && !duplicates.some(item => item.row1 === i + 1)) { |
| | | duplicates.push({ row1: i + 1, row2: -1 }); // è®°å½é夿°æ®æå¨è¡æ°ï¼-1 è¡¨ç¤ºæªæ¾å°ä¸å½åè¡éå¤çè¡ |
| | | } |
| | | } |
| | | return duplicates; |
| | | } |
| | | |
| | | |
| | | //#region æ ¹æ®ç©æIDè·åç©æè¯¦ç»ä¿¡æ¯ |
| | | function getMaterialByMaterID(HMaterID) { |
| | |
| | | //ç´æ¥æ§è¡å表çé å è½½æ°æ®å°ç½æ ¼ |
| | | get_FastQuery(1) |
| | | //æ¥è¯¢ |
| | | get_Display(sWhere); |
| | | //get_Display(sWhere); |
| | | //éèå¾éåæ®µ |
| | | DisPlay_HideColumn(); |
| | | |
| | |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | | if (checkStatus.data.length === 1) { |
| | | var InterID = data[0].hmainid.toString(); |
| | | var HInterID = data[0].hmainid.toString(); |
| | | var HsupId = data[0].hsubid; |
| | | var HQty = data[0].æ°é; |
| | | var HSourceInterID = data[0].æºå主å
ç ; |
| | | var HSourceEntryID = data[0].æºååå
ç ; |
| | | //é»è¾å 餿¹æ³ |
| | | layer.confirm("确认è¦å é¤åï¼å é¤åä¸è½æ¢å¤", { title: "å é¤ç¡®è®¤" }, function (index) { |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "Cg_POInStockBill/DeltetPOInStockBill", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | data: { "HInterID": InterID, "user": sessionStorage["HUserName"] }, |
| | | data: { "HInterID": HInterID, "HsupId": HsupId, "HQty": HQty, "HSourceInterID": HSourceInterID, "HSourceEntryID": HSourceEntryID, "user": sessionStorage["HUserName"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { |
| | | layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () { |
| | |
| | | if (HMangerID) { |
| | | sWhere += " and 主管 like '%" + HMangerID + "%'"; |
| | | } |
| | | sWhere += " and å
³é人 =''"; |
| | | get_Display(sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | |
| | | <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() { |
| | |
| | | <div class="layui-col-xs4 layui-inline"> |
| | | <label class="layui-form-label">éåå·</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="Box2" id="Box2" autocomplete="off"> |
| | | <input type="text" name="" id="" class="layui-input" value="" style="float:left;width:150px;"> |
| | | |
| | | <button type="button" lay-submit="" class="layui-btn" lay-filter="XDHList" id="XDHList" style="width:40px;"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i> |
| | | </button> |
| | | </div> |
| | | <!--<label class="layui-form-label">éåå·</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="Box2" id="Box2" autocomplete="off"> |
| | | </div>--> |
| | | </div> |
| | | <div class="layui-col-xs4 layui-inline"> |
| | | <label class="layui-form-label">è´è´£äºº</label> |
| | |
| | | <input type="text" class="layui-input" name="HCheckDate" id="HCheckDate" style="background-color:#efefef4d;" readonly> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <div class="layui-inline" > |
| | | <label class="layui-form-label" style="width: 85px;">å
³éæ¥æ</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HCloseDate" id="HCloseDate" style="background-color:#efefef4d;" readonly> |
| | |
| | | "HMaterID": 0, "ç©æä»£ç ": "", "ç©æåç§°": "", "è§æ ¼åå·": "", "HAuxPropID": 0, "ç©æè¾
å©å±æ§": "", "HUnitID": 0, "计éåä½": "", "HQtyMust": "", "HQty": "", "HRemark": "", |
| | | "HPrice": "0", "HMoney": "0", "HOrderPrice": "0", "HWHID": 0, "æ¶æä»åº": "", |
| | | "HSPID": 0, "ä»ä½åç§°": "", "HBatchNo": "", "HPOOrderInterID": 0, "HPOOrderEntryID": 0, |
| | | "HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": "" |
| | | "HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": "", |
| | | "HSourceBillNo": 0, "HSourceBillType": 0, "HSourceInterID": 0, "HSourceEntryID": 0, |
| | | }]; |
| | | // åå§åç |
| | | set_InitGrid(); |
| | |
| | | "HMaterID": 0, "ç©æä»£ç ": "", "ç©æåç§°": "", "è§æ ¼åå·": "", "HAuxPropID": 0, "ç©æè¾
å©å±æ§": "", "HUnitID": 0, "计éåä½": "", "HQtyMust": "", "HQty": "", "HRemark": "", |
| | | "HPrice": "0", "HMoney": "0", "HOrderPrice": "0", "HWHID": 0, "æ¶æä»åº": "", |
| | | "HSPID": 0, "ä»ä½åç§°": "", "HBatchNo": "", "HPOOrderInterID": 0, "HPOOrderEntryID": 0, |
| | | "HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": "" |
| | | "HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": "", |
| | | "HSourceBillNo": 0, "HSourceBillType": 0, "HSourceInterID": 0, "HSourceEntryID": 0, |
| | | }; |
| | | switch (obj.event) { |
| | | case 'btn-AddLine': |
| | |
| | | } |
| | | |
| | | |
| | | |
| | | //å表 |
| | | |
| | | function set_InitGrid() { |
| | | option = { |
| | |
| | | , cols: [[ //å表 |
| | | { type: 'checkbox', totalRowText: 'å计è¡' } |
| | | , { type: 'numbers', title: 'åºå·', width: 100, totalRow: true } |
| | | , { type: 'HSourceBillNo', title: 'æºåå·', width: 100, hide: true }//æºåå· |
| | | , { field: 'HSourceBillType', title: 'æºåç±»å', width: 100, hide: true }//æºåç±»å |
| | | , { type: 'HSourceInterID', title: 'æºå主å
ç ', width: 100, hide: true }//æºå主å
ç |
| | | , { field: 'HSourceEntryID', title: 'æºååå
ç ', width: 100, hide: true }//æºååå
ç |
| | | , { field: 'HMaterID', title: 'HMaterID', width: 100, hide: true } |
| | | , { field: 'ç©æä»£ç ', title: 'ç©æä»£ç ', width: 150, edit: 'text', event: "HMaterID" }//f7 |
| | | , { field: 'ç©æåç§°', title: 'ç©æåç§°', width: 150, } |
| | |
| | | ]] |
| | | } |
| | | |
| | | option.data = rowdata; |
| | | option.data = []; |
| | | table.render(option); |
| | | } |
| | | |
| | |
| | | , "HManagerID": data.HManagerID |
| | | , "HManagerName": data.è´è´£äºº |
| | | , "HExRate": data.æ±ç |
| | | , "Box2": "" |
| | | //, "Box2": "" |
| | | , "HRemark": data.è¡¨å¤´å¤æ³¨ |
| | | , "HMaker": data.å¶å人 |
| | | , "HChecker": data.å®¡æ ¸äºº |
| | |
| | | { |
| | | "HMaterID": subdata[i].HMaterID, "ç©æä»£ç ": subdata[i].ç©æä»£ç , "ç©æåç§°": subdata[i].ç©æåç§°, "è§æ ¼åå·": subdata[i].è§æ ¼åå·, "HAuxPropID": subdata[i].HAuxPropID, "ç©æè¾
å©å±æ§": subdata[i].ç©æè¾
å©å±æ§, "HUnitID": subdata[i].HUnitID, "计éåä½": subdata[i].计éåä½, |
| | | "HQtyMust": subdata[i].åºæ¶æ°é, "HQty": subdata[i].宿¶æ°é, "HRemark": subdata[i].表ä½å¤æ³¨, "HPrice": subdata[i].åä»·, "HMoney": subdata[i].éé¢, "HOrderPrice": subdata[i].éè´éé¢, "HWHID": subdata[i].HWHID, "æ¶æä»åº": subdata[i].æ¶æä»åº, "HSPID": subdata[i].HSPID, "ä»ä½åç§°": subdata[i].ä»ä½åç§°, |
| | | "HBatchNo": subdata[i].æ¹æ¬¡ |
| | | "HBatchNo": subdata[i].æ¹æ¬¡, |
| | | "HSourceBillNo": subdata[i].æºååå·, //æºåå· |
| | | "HSourceBillType": subdata[i].æºåç±»å, //æºåç±»å |
| | | "HSourceInterID": subdata[i].æºå主å
ç , //æºå主å
ç |
| | | "HSourceEntryID": subdata[i].æºååå
ç //æºååå
ç |
| | | } |
| | | ) |
| | | } |
| | |
| | | return; |
| | | } |
| | | |
| | | |
| | | var num = []; |
| | | for (var i = 0; i < table.cache["mainTable"].length; i++) { |
| | | if (table.cache["mainTable"][i] != "") { |
| | |
| | | num.push(table.cache["mainTable"][i]) |
| | | } |
| | | } |
| | | |
| | | checkDuplicateData(num); |
| | | const duplicateRows = checkDuplicateData(num); |
| | | if (duplicateRows.length > 0) { |
| | | let message = 'è¡¨æ ¼ä¸åå¨é夿°æ®ï¼éå¤è¡æ°ä¸ºï¼'; |
| | | |
| | | for (let i = 0; i < duplicateRows.length; i++) { |
| | | const { row1, row2 } = duplicateRows[i]; |
| | | message += `第${row1}è¡ä¸ç¬¬${row2}è¡ç¸å`; |
| | | |
| | | if (i !== duplicateRows.length - 1) { |
| | | message += 'ï¼'; |
| | | } |
| | | } |
| | | |
| | | message += 'ï¼è¯·å é¤å
¶ä¸ä¸è¡'; |
| | | layer.alert(message); |
| | | } |
| | | |
| | | |
| | | var sMainStr = JSON.stringify(data.field); |
| | | var sSubStr = JSON.stringify(num); |
| | |
| | | "HMaterID": 0, "ç©æä»£ç ": "", "ç©æåç§°": "", "è§æ ¼åå·": "", "HAuxPropID": 0, "ç©æè¾
å©å±æ§": "", "HUnitID": 0, "计éåä½": "", "HQtyMust": "", "HQty": "", "HRemark": "", |
| | | "HPrice": "0", "HMoney": "0", "HOrderPrice": "0", "HWHID": 0, "æ¶æä»åº": "", |
| | | "HSPID": 0, "ä»ä½åç§°": "", "HBatchNo": "", "HPOOrderInterID": 0, "HPOOrderEntryID": 0, |
| | | "HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": "" |
| | | "HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": "", |
| | | "HSourceBillNo": 0, "HSourceBillType": 0, "HSourceInterID": 0, "HSourceEntryID": 0, |
| | | }; |
| | | |
| | | table.cache["mainTable"].push(NewRow); |
| | |
| | | } |
| | | }) |
| | | } |
| | | |
| | | |
| | | //è¡å
äºä»¶ |
| | | table.on('tool(mainTable)', function (obj) { |
| | | set_GridDelete(obj); //è¡å
å é¤ |
| | | set_GridCellCheck(obj); //è¡å
å¿«æ·é®çé |
| | | |
| | | }); |
| | | //表头信æ¯éæ©åæ®å¼¹çª |
| | | form.on('submit(XDHList)', function () { |
| | | |
| | | //页é¢å±-èªå®ä¹ |
| | | layer.open({ |
| | | type: 2 |
| | | , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ |
| | | , title: "æ¶æéç¥åå表" //æ é¢ |
| | | , closeBtn: 1 //çªä½å³ä¸è§å
³é ç æ ·å¼ |
| | | , shift: 2 //å¼¹åºå¨ç» |
| | | , area: ["90%", "90%"] //çªä½å¤§å° |
| | | , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º |
| | | , content: ["../../éè´ç®¡ç/æ¶æéç¥å/Cg_POInStockBillList.html", "yes"] |
| | | , btn: ["ç¡®å®", "åæ¶"] |
| | | , btn1: function (index, laero) { |
| | | //æé®ä¸ çåè° |
| | | var iframeWindow = window["layui-layer-iframe" + index];//è·åå¼¹æ¡é¡µé¢ |
| | | var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//è·åéä¸çæ°æ® |
| | | |
| | | if (checkStatus.data.length == 0) { |
| | | return layer.msg("请è³å°éæ©ä¸æ¡æ°æ®!"); |
| | | } |
| | | layer.alert("ä½ å·²éæ©" + checkStatus.data.length + "æ¡æ°æ®"); |
| | | //è·åæ¶æéç¥å代ç |
| | | var ProcessNumber = []; |
| | | for (var i = 0; i < checkStatus.data.length; i++) { |
| | | ProcessNumber.push(checkStatus.data[i]); |
| | | } |
| | | |
| | | //è·åå½åä½ç½®æå¨è¡æ° |
| | | var NowNum = 0; |
| | | NowNum = option.data.length; |
| | | |
| | | |
| | | var j = 0; |
| | | for (var i = 0; i < ProcessNumber.length; i++) { |
| | | option.data.push({ |
| | | "HMaterID": checkStatus.data[j].HMaterID, "ç©æä»£ç ": checkStatus.data[j].ç©æä»£ç , "ç©æåç§°": checkStatus.data[j].ç©æåç§°, "è§æ ¼åå·": checkStatus.data[j].è§æ ¼åå·, |
| | | "HAuxPropID": 0, "ç©æè¾
å©å±æ§": "", "HUnitID": checkStatus.data[j].HUnitID, "计éåä½": checkStatus.data[j].计éåä½, "HQtyMust": "", "HQty": checkStatus.data[j].æ°é, "HRemark": "", |
| | | "HPrice": checkStatus.data[j].åä»·, "HMoney": checkStatus.data[j].éé¢, "HOrderPrice": "0", "HWHID": checkStatus.data[j].HWHID, "æ¶æä»åº": checkStatus.data[j].æ¶æä»åº, |
| | | "HSPID": checkStatus.data[j].HSPID, "ä»ä½åç§°": checkStatus.data[j].ä»ä½åç§°, "HBatchNo": "", "HPOOrderInterID": 0, "HPOOrderEntryID": 0, |
| | | "HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": "", |
| | | "HSourceBillNo": checkStatus.data[j].åæ®å·, "HSourceBillType": checkStatus.data[j].HBillType, "HSourceInterID": checkStatus.data[j].hmainid, "HSourceEntryID": checkStatus.data[j].hsubid, |
| | | }) |
| | | j++; |
| | | } |
| | | table.render(option); |
| | | layer.close(index);//å
³éå¼¹çª |
| | | } |
| | | |
| | | }); |
| | | }); |
| | | //夿æéçä¸è¡¨æ ¼æ¯å¦æé夿°æ® |
| | | function checkDuplicateData(data) { |
| | | const duplicates = []; |
| | | |
| | | for (let i = 0; i < data.length; i++) { |
| | | const currentItem = data[i]; |
| | | let isDuplicate = false; |
| | | |
| | | for (let j = i + 1; j < data.length; j++) { |
| | | const compareItem = data[j]; |
| | | |
| | | if (currentItem.HSourceInterID === compareItem.HSourceInterID && currentItem.HSourceEntryID === compareItem.HSourceEntryID) { |
| | | isDuplicate = true; |
| | | duplicates.push({ row1: i + 1, row2: j + 1 }); // è®°å½é夿°æ®æå¨è¡æ° |
| | | } |
| | | } |
| | | if (isDuplicate && !duplicates.some(item => item.row1 === i + 1)) { |
| | | duplicates.push({ row1: i + 1, row2: -1 }); // è®°å½é夿°æ®æå¨è¡æ°ï¼-1 è¡¨ç¤ºæªæ¾å°ä¸å½åè¡éå¤çè¡ |
| | | } |
| | | } |
| | | return duplicates; |
| | | } |
| | | //è¡å
å é¤ |
| | | function set_GridDelete(obj) { |
| | | var data = obj.data; |
| | |
| | | layer.msg('è¯·éæ©ä¸è¡æ°æ®å®¡æ ¸ï¼'); |
| | | } |
| | | } |
| | | //#endregion |
| | | //#endregionz |
| | | |
| | | //#region æ¡ç æç» |
| | | function get_BarCodeDetail() { |
| | |
| | | //if (HOrgID) { |
| | | // sWhere += " and HUSEORGID = '" + HOrgID + "'"; |
| | | //} |
| | | sWhere += " and å
³é人 =''"; |
| | | get_Display(sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | |
| | | get_Display(sWhere); |
| | | } |
| | | //#endregion |
| | | |
| | | //å é¤ |
| | | function set_DeleteBill() { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | | if (checkStatus.data.length === 1) { |
| | | var InterID = data[0].hmainid.toString(); |
| | | var Hmainid = data[0].hmainid.toString(); |
| | | var HsupId = data[0].hsubid; |
| | | var HQty = data[0].宿¶æ°é; |
| | | var HSourceInterID = data[0].æºå主å
ç ; |
| | | var HSourceEntryID = data[0].æºååå
ç ; |
| | | //é»è¾å 餿¹æ³ |
| | | layer.confirm("确认è¦å é¤åï¼å é¤åä¸è½æ¢å¤", { title: "å é¤ç¡®è®¤" }, function (index) { |
| | | var wait = layer.load(); |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "/Kf_POStockInBill/DeltetKf_POStockInBill", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | data: { "HInterID": InterID }, |
| | | data: { "Hmainid": Hmainid, "HsupId": HsupId, "HQty": HQty, "HSourceInterID": HSourceInterID, "HSourceEntryID": HSourceEntryID, "user": sessionStorage["HUserName"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { |
| | | layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () { |