| | |
| | | } else if (ListTrue[1] == 1) { |
| | | //æå°å·¥åºæµè½¬å¡å°æ ç¾ |
| | | CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_Sc_ProcessExchangeBillList_Small.aspx?linterid=" + ListTrue[0], true, ""); |
| | | } else { |
| | | } |
| | | else if (ListTrue[1] == 2) { |
| | | //æå°å·¥åºæµè½¬å¡å°æ ç¾ |
| | | CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_Sc_ProcessExchangeBillList_stock.aspx?linterid=" + ListTrue[0], true, ""); |
| | | } |
| | | else { |
| | | CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + "_Sub.grf", "xmlLBM_Sc_ProcessExchangeBillList_SubList.aspx?linterid=" + ListTrue[0], true, ""); |
| | | } |
| | | break; |
| New file |
| | |
| | | <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="xmlLBM_Sc_ProcessExchangeBillList_stock.aspx.cs" Inherits="WebTM.views.åºç¡èµæ.å
¬ç¨åºç¡èµæ.xmlLBM_Sc_ProcessExchangeBillList" %> |
| | | |
| | | <!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"); |
| | | |
| | | //20250731è°æ´ï¼æ¥è¯¢æå°æ°æ®æ¶ï¼æ´æ°æå°æ¥æå°æµè½¬å¡ä¸»è¡¨ |
| | | SqlXMLReportData.GenEntireData(this, "select cast((cast( b.æµæ°´å· as float)/10) as decimal(6,1)) æµæ°´å·,ç产订åå·,a.ç产æ°é,a.éå®è®¢åå·,a.æåå·,a.æµè½¬å¡æ°é,a.äº¤è´§æ¥æ,a.产å代ç ,a.åæ®å·,case when ISNULL(a.çäº§è§æ ¼,'')='' then a.产åè§æ ¼ else a.çäº§è§æ ¼ end 产åè§æ ¼,a.产ååç§°,a.æ¥æ,a.计åå®å·¥æ¥æ,a.åæ®å·,b.å·¥åºåç§°,b.模å
·ç¼å·,b.å·¥èºåæ°,b.å 工说æ,case when ISNULL(a.ç产å¹
宽,0)=0 then a.å¹
宽 else a.ç产å¹
宽 end å¹
宽,case when ISNULL(a.ç产å
é,0) = 0 then a.å
é else a.ç产å
é end å
é,a.ç½å¯è¦æ±,a.åºé¨å¤æ³¨,a.客æ·,a.ä¸å¡å,a.æ¯é«,a.寸æ°ç»ç»,a.å
¨æ¯é¿,a.å¯å¸å¯åº¦,a.æ¯çº±åç§°åè§æ ¼,a.åºä¸,a.è¾
æ°é,a.è¾
å©åä½,a.å®åæµæ,a.äº¤è´§æ¥æ,a.æè²è¦æ±,a.è¾
æ°é2,a.HAuxUnit2,a.è¾
å©åä½2,b.åºç«å
³èæ°é from h_v_Sc_ProcessExchangeBillQuery a left join h_v_Sc_ProcessExchangeBillQuerySub b on a.hmainid=b.hmainid where b.hmainid in("+Request.Params["linterid"] +") order by cast(b.æµæ°´å· as int)","update Sc_ProcessExchangeBillMain set HPrintQty1 = HPrintQty1+1 where HInterID in ("+Request.Params["linterid"] + ") and HPrintDate is null"); |
| | | |
| | | |
| | | } |
| | | </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_Sc_ProcessExchangeBillList_stock : System.Web.UI.Page |
| | | { |
| | | protected void Page_Load(object sender, EventArgs e) |
| | | { |
| | | |
| | | } |
| | | } |
| | | } |