New file |
| | |
| | | using System; |
| | | using System.Collections; |
| | | using System.Data; |
| | | using System.Data.SqlClient; |
| | | using System.Configuration; |
| | | using System.IO; |
| | | using System.IO.Compression; |
| | | |
| | | ///////////////////////////////////////////////////////////////////////////////////////////////////////// |
| | | //class SqlReportData 产çæä¾ç»æ¥è¡¨çæéè¦ç æ JSON æ°æ® |
| | | public class SqlReportData |
| | | { |
| | | //â
ç¹å«æç¤ºâ
ï¼ |
| | | //è¿æ¥SQL Serveræ°æ®åºçè¿æ¥ä¸²ï¼åºè¯¥ä¿®æ¹ä¸ºä¸å®é
ä¸è´ã妿æ¯è¿è¡Grid++Reportæ¬èº«çä¾åï¼åºè¯¥é¦å
éå ä¾åæ°æ®åºå° |
| | | //SQL Server2000/2005æ°æ®åºä¸ã |
| | | //public const string SqlConnStr = "Data Source=(local);Initial Catalog=gridreport;Persist Security Info=True;User ID=sa;Password=;"; |
| | | |
| | | //public const string SqlConnStr = "Data Source=10.0.2.9;Initial Catalog=HX_LimsSys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;"; |
| | | public const string SqlConnStr = "Data Source=.;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;"; |
| | | |
| | | //public string sServer; |
| | | //public string sDataBase; |
| | | //public string sUser; |
| | | //public string sPassword; |
| | | //public const string SqlConnStr=""; |
| | | //protected void Page_Load(object sender, EventArgs e) |
| | | //{ |
| | | // sServer = Pub_Class.ClsIni.ReadIni("Erp", "Server", Pub_Class.ClsPub.AppPath + @"\" + "HXErp.ini"); |
| | | // sDataBase = Pub_Class.ClsIni.ReadIni("Erp", "DataBase", Pub_Class.ClsPub.AppPath + @"\" + "HXErp.ini"); |
| | | // sUser = Pub_Class.ClsIni.ReadIni("Erp", "UserName", Pub_Class.ClsPub.AppPath + @"\" + "HXErp.ini"); |
| | | // sPassword = Pub_Class.ClsIni.ReadIni("Erp", "PassWord", Pub_Class.ClsPub.AppPath + @"\" + "HXErp.ini"); |
| | | // SqlConnStr = "Data Source=" + sServer + |
| | | // ";Initial Catalog=" + sDataBase + |
| | | // ";Persist Security Info=True;"+ |
| | | // "User ID=" + sUser + |
| | | // ";Password=" + sPassword + ";"; |
| | | //} |
| | | |
| | | //å®ä¹å¨SQLä¸è¡¨ç¤ºæ¥æå¼çå
å´ç¬¦å·ï¼Accessç¨â#â, èMS SQl Serverç¨â'âï¼ä¸ºäºçæä¸¤è
é½å¯ç¨çæ¥è¯¢SQLè¯å¥ï¼å°å
¶åæ°åå®ä¹åºæ¥ãè¿æ ·å¤çåªæ¯ä¸ºäºæ¼ç¤ºä¾åæ¹ä¾¿ |
| | | public const char DateSqlBracketChar = '\''; |
| | | |
| | | //æ ¹æ®æ¥è¯¢SQL,产çæä¾ç»æ¥è¡¨çæéè¦ç XML æ°æ®ï¼å段å¼ä¸ºç©ºä¹äº§çæ°æ® |
| | | public static void FullGenNodeXmlData(System.Web.UI.Page DataPage, string QuerySQL, bool ToCompress) |
| | | { |
| | | SqlConnection ReportConn = new SqlConnection(SqlConnStr); |
| | | SqlCommand ReportDataCommand = new SqlCommand(QuerySQL, ReportConn); |
| | | ReportConn.Open(); |
| | | SqlDataReader ReportDataReader = ReportDataCommand.ExecuteReader(); |
| | | XMLReportData.GenNodeXmlDataFromReader(DataPage, ReportDataReader, ToCompress ? ResponseDataType.ZipBinary : ResponseDataType.PlainText); |
| | | ReportDataReader.Close(); |
| | | ReportConn.Close(); |
| | | } |
| | | |
| | | //è·å Count(*) SQL æ¥è¯¢å°çæ°æ®è¡æ°ãåæ° QuerySQL æå®è·åæ¥è¡¨æ°æ®çæ¥è¯¢SQL |
| | | public static int BatchGetDataCount(string QuerySQL) |
| | | { |
| | | int Total = 0; |
| | | |
| | | SqlConnection ReportConn = new SqlConnection(SqlConnStr); |
| | | SqlCommand ReportDataCommand = new SqlCommand(QuerySQL, ReportConn); |
| | | ReportConn.Open(); |
| | | SqlDataReader ReportDataReader = ReportDataCommand.ExecuteReader(); |
| | | if (ReportDataReader.Read()) |
| | | Total = ReportDataReader.GetInt32(0); |
| | | ReportDataReader.Close(); |
| | | ReportConn.Close(); |
| | | |
| | | return Total; |
| | | } |
| | | |
| | | //<<protected function |
| | | //æ ¹æ®æ¥è¯¢SQL,产çæä¾ç»æ¥è¡¨çæéè¦ç XML æ JSON æ°æ® |
| | | protected static void DoGenDetailData(System.Web.UI.Page DataPage, string QuerySQL, ResponseDataType DataType, bool IsJSON) |
| | | { |
| | | SqlConnection ReportConn = new SqlConnection(SqlConnStr); |
| | | SqlDataAdapter ReportDataAdapter = new SqlDataAdapter(QuerySQL, ReportConn); |
| | | DataSet ReportDataSet = new DataSet(); |
| | | ReportConn.Open(); |
| | | ReportDataAdapter.Fill(ReportDataSet); |
| | | ReportConn.Close(); |
| | | |
| | | if (IsJSON) |
| | | JSONReportData.GenDataSet(DataPage, ReportDataSet, DataType); |
| | | else |
| | | XMLReportData.GenDataSet(DataPage, ReportDataSet, DataType); |
| | | } |
| | | //>>protected function |
| | | |
| | | //ç¹å«æç¤ºï¼ä»¥ä¸å½æ°ä¸ºå
¼å®¹ä»¥åçæ¬èä¿çï¼è¯·å¿åç¨ä¹ï¼æ é¡»å
¼å®¹èèå¯å é¤ä¹ |
| | | //<<ä¿çåé¢çæ¬ç彿°ï¼å
¼å®¹ä»¥åçæ¬æåç¨åº |
| | | //æ ¹æ®æ¥è¯¢SQL,产çæä¾ç»æ¥è¡¨çæéè¦ç XML æ°æ®ï¼éç¨ Sql æ°æ®å¼æ |
| | | public static void GenNodeXmlData(System.Web.UI.Page DataPage, string QuerySQL, bool ToCompress) |
| | | { |
| | | DoGenDetailData(DataPage, QuerySQL, ToCompress ? ResponseDataType.ZipBinary : ResponseDataType.PlainText, false); |
| | | } |
| | | |
| | | //æ ¹æ®æ¥è¯¢SQL,产çæä¾ç»æ¥è¡¨çæéè¦ç XML æ°æ®ï¼éç¨ Sql æ°æ®å¼æ, è¿éåªäº§çæ¥è¡¨åæ°æ°æ® |
| | | //彿¥è¡¨æ²¡ææç»æ¶ï¼è°ç¨æ¬æ¹æ³çææ°æ®ï¼æ¥è¯¢SQLåºè¯¥åªè½æ¥è¯¢åºä¸æ¡è®°å½ |
| | | public static void GenParameterReportData(System.Web.UI.Page DataPage, string ParameterQuerySQL) |
| | | { |
| | | DoGenDetailData(DataPage, ParameterQuerySQL, ResponseDataType.PlainText, false); |
| | | } |
| | | |
| | | //æ ¹æ®æ¥è¯¢SQL,产çæä¾ç»æ¥è¡¨çæéè¦ç XML æ°æ®ï¼éç¨ Sql æ°æ®å¼æ, æ ¹æ®RecordsetQuerySQLè·åæ¥è¡¨æç»æ°æ®ï¼æ ¹æ®ParameterQuerySQLè·åæ¥è¡¨åæ°æ°æ® |
| | | public static void GenEntireReportData(System.Web.UI.Page DataPage, string RecordsetQuerySQL, string ParameterQuerySQL, bool ToCompress) |
| | | { |
| | | SqlConnection ReportConn = new SqlConnection(SqlConnStr); |
| | | DataSet ReportDataSet = new DataSet(); |
| | | ReportConn.Open(); |
| | | SqlDataAdapter DataAdapter1 = new SqlDataAdapter(RecordsetQuerySQL, ReportConn); |
| | | DataAdapter1.Fill(ReportDataSet, "Detail"); |
| | | SqlDataAdapter DataAdapter2 = new SqlDataAdapter(ParameterQuerySQL, ReportConn); |
| | | DataAdapter2.Fill(ReportDataSet, "Master"); |
| | | ReportConn.Close(); |
| | | XMLReportData.GenDataSet(DataPage, ReportDataSet, ReportDataBase.DefaultDataType); |
| | | } |
| | | //>>ä¿çåé¢çæ¬ç彿°ï¼å
¼å®¹ä»¥åçæ¬æåç¨åº |
| | | } |
| | | |
| | | ///////////////////////////////////////////////////////////////////////////////////////////////////////// |
| | | //class SqlXMLReportData æ ¹æ®SQLäº§çæ¥è¡¨éè¦ç XML æ°æ®ï¼éç¨ Sql æ°æ®å¼æ |
| | | public class SqlXMLReportData : SqlReportData |
| | | { |
| | | public static void GenOneRecordset(System.Web.UI.Page DataPage, string QuerySQL) |
| | | { |
| | | SqlReportData.DoGenDetailData(DataPage, QuerySQL, ReportDataBase.DefaultDataType, false); |
| | | } |
| | | |
| | | public static void GenMultiRecordset(System.Web.UI.Page DataPage, ArrayList QueryList) |
| | | { |
| | | SqlConnection ReportConn = new SqlConnection(SqlConnStr); |
| | | DataSet ReportDataSet = new DataSet(); |
| | | |
| | | ReportConn.Open(); |
| | | |
| | | foreach (ReportQueryItem item in QueryList) |
| | | { |
| | | SqlDataAdapter DataAdapter = new SqlDataAdapter(item.QuerySQL, ReportConn); |
| | | DataAdapter.Fill(ReportDataSet, item.RecordsetName); |
| | | } |
| | | |
| | | ReportConn.Close(); |
| | | |
| | | XMLReportData.GenDataSet(DataPage, ReportDataSet, ReportDataBase.DefaultDataType); |
| | | } |
| | | |
| | | //ç¹å«æç¤ºï¼ä»¥ä¸å½æ°ä¸ºå
¼å®¹ä»¥åçæ¬èä¿çï¼è¯·å¿åç¨ä¹ï¼æ é¡»å
¼å®¹èèå¯å é¤ä¹ |
| | | //<<ä¿çåé¢çæ¬ç彿°ï¼å
¼å®¹ä»¥åçæ¬æåç¨åº |
| | | //äº§çæ¥è¡¨æç»è®°å½æ°æ®ï¼æ°æ®å°è¢«å è½½å°æç»ç½æ ¼çè®°å½éä¸ |
| | | public static void GenDetailData(System.Web.UI.Page DataPage, string QuerySQL) |
| | | { |
| | | GenOneRecordset(DataPage, QuerySQL); |
| | | } |
| | | |
| | | //è¿éåªäº§çæ¥è¡¨åæ°æ°æ®ï¼æ°æ®å è½½å°æ¥è¡¨åæ°ãéæç»ç½æ ¼ä¸çé¨ä»¶æ¡ä¸ |
| | | //彿¥è¡¨æ²¡ææç»æ¶ï¼è°ç¨æ¬æ¹æ³çææ°æ®ï¼æ¥è¯¢SQLåºè¯¥åªè½æ¥è¯¢åºä¸æ¡è®°å½ |
| | | public static void GenParameterData(System.Web.UI.Page DataPage, string ParameterQuerySQL) |
| | | { |
| | | GenOneRecordset(DataPage, ParameterQuerySQL); |
| | | } |
| | | |
| | | //æ ¹æ®RecordsetQuerySQLè·åæ¥è¡¨æç»æ°æ®ï¼å¯¹åºæ°æ®å è½½å°æ¥è¡¨çæç»ç½æ ¼çè®°å½éä¸ |
| | | //æ ¹æ®ParameterQuerySQLè·åæ¥è¡¨åæ°æ°æ®ï¼å¯¹åºæ°æ®å è½½å°æ¥è¡¨åæ°ãéæç»ç½æ ¼ä¸çé¨ä»¶æ¡ä¸ |
| | | public static void GenEntireData(System.Web.UI.Page DataPage, string RecordsetQuerySQL, string ParameterQuerySQL, ResponseDataType DataType) |
| | | { |
| | | ArrayList QueryList = new ArrayList(); |
| | | QueryList.Add(new ReportQueryItem(RecordsetQuerySQL, "Detail")); |
| | | QueryList.Add(new ReportQueryItem(ParameterQuerySQL, "Master")); |
| | | GenMultiRecordset(DataPage, QueryList); |
| | | } |
| | | public static void GenEntireData(System.Web.UI.Page DataPage, string RecordsetQuerySQL, string ParameterQuerySQL) |
| | | { |
| | | GenEntireData(DataPage, RecordsetQuerySQL, ParameterQuerySQL, ReportDataBase.DefaultDataType); |
| | | } |
| | | //>>ä¿çåé¢çæ¬ç彿°ï¼å
¼å®¹ä»¥åçæ¬æåç¨åº |
| | | } |
| | | |
| | | ///////////////////////////////////////////////////////////////////////////////////////////////////////// |
| | | //class SqlJsonReportData æ ¹æ®SQLäº§çæ¥è¡¨éè¦ç JSON æ°æ®ï¼éç¨ Sql æ°æ®å¼æ |
| | | public class SqlJsonReportData : SqlReportData |
| | | { |
| | | public static void GenOneRecordset(System.Web.UI.Page DataPage, string QuerySQL) |
| | | { |
| | | SqlReportData.DoGenDetailData(DataPage, QuerySQL, ReportDataBase.DefaultDataType, true); |
| | | } |
| | | |
| | | public static void GenMultiRecordset(System.Web.UI.Page DataPage, ArrayList QueryList) |
| | | { |
| | | SqlConnection ReportConn = new SqlConnection(SqlConnStr); |
| | | DataSet ReportDataSet = new DataSet(); |
| | | |
| | | ReportConn.Open(); |
| | | |
| | | foreach (ReportQueryItem item in QueryList) |
| | | { |
| | | SqlDataAdapter DataAdapter = new SqlDataAdapter(item.QuerySQL, ReportConn); |
| | | DataAdapter.Fill(ReportDataSet, item.RecordsetName); |
| | | } |
| | | |
| | | ReportConn.Close(); |
| | | |
| | | JSONReportData.GenDataSet(DataPage, ReportDataSet, ReportDataBase.DefaultDataType); |
| | | } |
| | | |
| | | |
| | | //ç¹å«æç¤ºï¼ä»¥ä¸å½æ°ä¸ºå
¼å®¹ä»¥åçæ¬èä¿çï¼è¯·å¿åç¨ä¹ï¼æ é¡»å
¼å®¹èèå¯å é¤ä¹ |
| | | //<<ä¿çåé¢çæ¬ç彿°ï¼å
¼å®¹ä»¥åçæ¬æåç¨åº |
| | | //äº§çæ¥è¡¨æç»è®°å½æ°æ®ï¼æ°æ®å°è¢«å è½½å°æç»ç½æ ¼çè®°å½éä¸ |
| | | public static void GenDetailData(System.Web.UI.Page DataPage, string QuerySQL) |
| | | { |
| | | GenOneRecordset(DataPage, QuerySQL); |
| | | } |
| | | |
| | | //è¿éåªäº§çæ¥è¡¨åæ°æ°æ®ï¼æ°æ®å°å è½½å°æ¥è¡¨åæ°ãéæç»ç½æ ¼ä¸çé¨ä»¶æ¡ä¸ |
| | | //彿¥è¡¨æ²¡ææç»æ¶ï¼è°ç¨æ¬æ¹æ³çææ°æ®ï¼æ¥è¯¢SQLåºè¯¥åªè½æ¥è¯¢åºä¸æ¡è®°å½ |
| | | public static void GenParameterData(System.Web.UI.Page DataPage, string ParameterQuerySQL) |
| | | { |
| | | GenOneRecordset(DataPage, ParameterQuerySQL); |
| | | } |
| | | |
| | | //æ ¹æ®RecordsetQuerySQLè·åæ¥è¡¨æç»æ°æ®ï¼å¯¹åºæ°æ®å è½½å°æ¥è¡¨çæç»ç½æ ¼çè®°å½éä¸ |
| | | //æ ¹æ®ParameterQuerySQLè·åæ¥è¡¨åæ°æ°æ®ï¼å¯¹åºæ°æ®å è½½å°æ¥è¡¨åæ°ãéæç»ç½æ ¼ä¸çé¨ä»¶æ¡ä¸ |
| | | public static void GenEntireData(System.Web.UI.Page DataPage, string RecordsetQuerySQL, string ParameterQuerySQL, ResponseDataType DataType) |
| | | { |
| | | ArrayList QueryList = new ArrayList(); |
| | | QueryList.Add(new ReportQueryItem(RecordsetQuerySQL, "Detail")); |
| | | QueryList.Add(new ReportQueryItem(ParameterQuerySQL, "Master")); |
| | | GenMultiRecordset(DataPage, QueryList); |
| | | } |
| | | public static void GenEntireData(System.Web.UI.Page DataPage, string RecordsetQuerySQL, string ParameterQuerySQL) |
| | | { |
| | | GenEntireData(DataPage, RecordsetQuerySQL, ParameterQuerySQL, ReportDataBase.DefaultDataType); |
| | | } |
| | | //>>ä¿çåé¢çæ¬ç彿°ï¼å
¼å®¹ä»¥åçæ¬æåç¨åº |
| | | } |
New file |
| | |
| | | using System; |
| | | //using System.Collections; |
| | | using System.Text; |
| | | using System.Data; |
| | | using System.Configuration; |
| | | using System.IO; |
| | | using System.IO.Compression; |
| | | using System.Web; |
| | | using System.Web.Security; |
| | | using System.Web.UI; |
| | | using System.Web.UI.WebControls; |
| | | using System.Web.UI.WebControls.WebParts; |
| | | using System.Web.UI.HtmlControls; |
| | | |
| | | ///////////////////////////////////////////////////////////////////////////////////////////////////////// |
| | | //以䏿䏾æå®æ¥è¡¨æ°æ®çæ ¼å¼ç±»å |
| | | public enum ResponseDataType |
| | | { |
| | | PlainText, //æ¥è¡¨æ°æ®ä¸ºXMLæJSONææ¬ï¼å¨è°è¯æ¶å¯ä»¥æ¥çæ¥è¡¨æ°æ®ãæ°æ®æªç»å缩ï¼å¤§æ°æ®éæ¥è¡¨éç¨æ¤ç§æ¹å¼ä¸åé |
| | | ZipBinary, //æ¥è¡¨æ°æ®ä¸ºXMLæJSONææ¬ç»è¿å缩å¾å°çäºè¿å¶æ°æ®ãæ¤ç§æ¹å¼æ°æ®éæå°(约为åå§æ°æ®ç1/10)ï¼ä½ç¨Ajaxæ¹å¼å è½½æ¥è¡¨æ°æ®æ¶ä¸è½ä¸ºæ¤ç§æ¹å¼ |
| | | ZipBase64, //æ¥è¡¨æ°æ®ä¸ºå° ZipBinary æ¹å¼å¾å°çæ°æ®åè¿è¡ BASE64 ç¼ç çæ°æ®ãæ¤ç§æ¹å¼éåç¨Ajaxæ¹å¼å è½½æ¥è¡¨æ°æ® |
| | | }; |
| | | |
| | | ///////////////////////////////////////////////////////////////////////////////////////////////////////// |
| | | // ReportQueryItem |
| | | public class ReportQueryItem |
| | | { |
| | | public string QuerySQL; |
| | | public string RecordsetName; |
| | | |
| | | public ReportQueryItem(string AQuerySQL, string ARecordsetName) |
| | | { |
| | | QuerySQL = AQuerySQL; |
| | | RecordsetName = ARecordsetName; |
| | | } |
| | | }; |
| | | |
| | | ///////////////////////////////////////////////////////////////////////////////////////////////////////// |
| | | // ReportDataBase |
| | | public class ReportDataBase |
| | | { |
| | | //æå®æ¥è¡¨çé»è®¤æ°æ®ç±»åï¼ä¾¿äºç»ä¸å®ä¹æ´ä¸ªæ¥è¡¨ç³»ç»çæ°æ®ç±»å |
| | | //卿¥è¡¨å¼åè°è¯é¶æ®µï¼é常æå®ä¸º ResponseDataType.PlainText, ä»¥ä¾¿å¨æµè§å¨ä¸æ¥çååºçæºæä»¶æ¶è½çå°å¯è¯»çææ¬æ°æ® |
| | | //å¨é¡¹ç®é¨ç½²æ¶ï¼é常æå®ä¸º ResponseDataType.ZipBinary æ ResponseDataType.ZipBase64ï¼è¿æ ·å¯ä»¥æå¤§åå°æ°æ®éï¼æä¾æ¥è¡¨ååºé度 |
| | | public const ResponseDataType DefaultDataType = ResponseDataType.PlainText; //PlainText ZipBinary ZipBase64 |
| | | |
| | | //å°æ¥è¡¨XMLæ°æ®ææ¬è¾åºå°HTTPè¯·æ± |
| | | public static void ResponseData(System.Web.UI.Page DataPage, ref string DataText, ResponseDataType DataType) |
| | | { |
| | | //æ¥è¡¨XMLæ°æ®çååä¸è½éå ä»»ä½å
¶å®æ°æ®ï¼å¦åXMLæ°æ®å°ä¸è½æåè§£æï¼æä»¥è°ç¨ClearContentæ¹æ³æ¸
çç½é¡µä¸åé¢å¤ä½çæ°æ® |
| | | DataPage.Response.ClearContent(); |
| | | |
| | | if (ResponseDataType.PlainText == DataType) |
| | | { |
| | | // æxml对象åéç»å®¢æ·ç«¯ |
| | | //DataPage.Response.ContentType = "text/xml"; |
| | | DataPage.Response.Write(DataText); |
| | | } |
| | | else |
| | | { |
| | | //å°stringæ°æ®è½¬æ¢ä¸ºbyte[]ï¼ä»¥ä¾¿è¿è¡å缩 |
| | | System.Text.UTF8Encoding converter = new System.Text.UTF8Encoding(); |
| | | byte[] XmlBytes = converter.GetBytes(DataText); |
| | | |
| | | //å¨ HTTP 头信æ¯ä¸åå
¥æ¥è¡¨æ°æ®åç¼©ä¿¡æ¯ |
| | | DataPage.Response.AppendHeader("gr_zip_type", "deflate"); //æå®åç¼©æ¹æ³ |
| | | DataPage.Response.AppendHeader("gr_zip_size", XmlBytes.Length.ToString()); //æå®æ°æ®çåå§é¿åº¦ |
| | | DataPage.Response.AppendHeader("gr_zip_encode", converter.HeaderName); //æå®æ°æ®çç¼ç æ¹å¼ utf-8 utf-16 ... |
| | | |
| | | // æå缩åçxmlæ°æ®åéç»å®¢æ·ç«¯ |
| | | if (ResponseDataType.ZipBinary == DataType) |
| | | { |
| | | DeflateStream compressedzipStream = new DeflateStream(DataPage.Response.OutputStream, CompressionMode.Compress, true); |
| | | compressedzipStream.Write(XmlBytes, 0, XmlBytes.Length); |
| | | compressedzipStream.Close(); |
| | | } |
| | | else //ResponseDataType.ZipBase64 |
| | | { |
| | | MemoryStream memStream = new MemoryStream(); |
| | | DeflateStream compressedzipStream = new DeflateStream(memStream, CompressionMode.Compress, true); |
| | | compressedzipStream.Write(XmlBytes, 0, XmlBytes.Length); |
| | | compressedzipStream.Close(); //è¿å¥å¾éè¦ï¼è¿æ ·æ°æ®æè½å
¨é¨åå
¥ MemoryStream |
| | | |
| | | // Read bytes from the stream. |
| | | memStream.Seek(0, SeekOrigin.Begin); // Set the position to the beginning of the stream. |
| | | int count = (int)memStream.Length; |
| | | byte[] byteArray = new byte[count]; |
| | | count = memStream.Read(byteArray, 0, count); |
| | | |
| | | string Base64Text = Convert.ToBase64String(byteArray); |
| | | DataPage.Response.Write(Base64Text); |
| | | } |
| | | } |
| | | |
| | | //æ¥è¡¨XMLæ°æ®çååä¸è½éå ä»»ä½å
¶å®æ°æ®ï¼å¦åXMLæ°æ®å°ä¸è½æåè§£æï¼æä»¥è°ç¨Endæ¹æ³æ¾å¼ç½é¡µä¸åé¢ä¸å¿
è¦çæ°æ® |
| | | DataPage.Response.End(); |
| | | } |
| | | } |
| | | |
| | | ///////////////////////////////////////////////////////////////////////////////////////////////////////// |
| | | //class XMLReportData äº§çæ¥è¡¨éè¦çxmlæ°æ® |
| | | public class XMLReportData |
| | | { |
| | | //æ ¹æ® DataSet 产çæä¾ç»æ¥è¡¨éè¦çXMLæ°æ®ï¼åæ°DataTypeæå®å缩ç¼ç æ°æ®çå½¢å¼ |
| | | public static void GenDataSet(System.Web.UI.Page DataPage, DataSet ReportDataSet, ResponseDataType DataType) |
| | | { |
| | | string XMLText = ReportDataSet.GetXml(); |
| | | ReportDataBase.ResponseData(DataPage, ref XMLText, DataType); |
| | | } |
| | | |
| | | //æ ¹æ® DataTable 产çæä¾ç»æ¥è¡¨éè¦çXMLæ°æ®ï¼åæ°DataTypeæå®å缩ç¼ç æ°æ®çå½¢å¼ |
| | | public static void GenDataTable(System.Web.UI.Page DataPage, DataTable mydt, ResponseDataType DataType) |
| | | { |
| | | DataSet ds = new DataSet(); |
| | | ds.Tables.Add(mydt); |
| | | GenDataSet(DataPage, ds, DataType); |
| | | } |
| | | |
| | | //æ ¹æ®IDataReader, 产çæä¾ç»æ¥è¡¨éè¦çXMLæ°æ®ï¼å
¶ä¸ç空å¼å段ä¹ä¼äº§çXMLèç¹ï¼åæ°DataTypeæå®å缩ç¼ç æ°æ®çå½¢å¼ |
| | | public static void GenNodeXmlDataFromReader(System.Web.UI.Page DataPage, IDataReader dr, ResponseDataType DataType) |
| | | { |
| | | string XMLText = "<xml>\n"; |
| | | while (dr.Read()) |
| | | { |
| | | XMLText += "<row>"; |
| | | for (int i = 0; i < dr.FieldCount; ++i) |
| | | { |
| | | string FldName = dr.GetName(i); |
| | | if (FldName == "") |
| | | FldName = "Fld" + i; |
| | | XMLText += String.Format("<{0}>{1}</{0}>", FldName, HttpUtility.HtmlEncode(dr.GetValue(i).ToString())); |
| | | } |
| | | XMLText += "</row>\n"; |
| | | } |
| | | XMLText += "</xml>\n"; |
| | | |
| | | ReportDataBase.ResponseData(DataPage, ref XMLText, DataType); |
| | | } |
| | | } |
| | | |
| | | ///////////////////////////////////////////////////////////////////////////////////////////////////////// |
| | | //class JSONReportData äº§çæ¥è¡¨éè¦ç JSON æ ¼å¼æ°æ® |
| | | public class JSONReportData |
| | | { |
| | | //æ ¹æ® DataSet 产çæä¾ç»æ¥è¡¨éè¦çJSONæ°æ®ï¼åæ°DataTypeæå®å缩ç¼ç æ°æ®çå½¢å¼ |
| | | public static void GenDataSet(System.Web.UI.Page DataPage, DataSet ReportDataSet, ResponseDataType DataType) |
| | | { |
| | | string Out = GenDetailText(ReportDataSet); |
| | | ReportDataBase.ResponseData(DataPage, ref Out, DataType); |
| | | } |
| | | |
| | | //æ ¹æ® DataTable 产çæä¾ç»æ¥è¡¨éè¦çJSONæ°æ®ï¼åæ°DataTypeæå®å缩ç¼ç æ°æ®çå½¢å¼ |
| | | public static void GenDataTable(System.Web.UI.Page DataPage, DataTable dt, ResponseDataType DataType) |
| | | { |
| | | DataSet ds = new DataSet(); |
| | | ds.Tables.Add(dt); |
| | | GenDataSet(DataPage, ds, DataType); |
| | | } |
| | | |
| | | //æ ¹æ® DataSet 产çæä¾ç»æ¥è¡¨éè¦çJSONææ¬æ°æ® |
| | | public static string GenDetailText(DataSet ds) |
| | | { |
| | | StringBuilder sbJSONText = new StringBuilder("{\n"); |
| | | foreach (DataTable dt in ds.Tables) |
| | | { |
| | | //"recordset":[ |
| | | sbJSONText.Append('"'); |
| | | sbJSONText.Append(dt.TableName); |
| | | sbJSONText.Append("\":[\n"); |
| | | foreach (DataRow dr in dt.Rows) |
| | | { |
| | | sbJSONText.Append('{'); |
| | | for (int i = 0; i < dt.Columns.Count; ++i) |
| | | { |
| | | if (!dr.IsNull(i)) |
| | | { |
| | | string Value; |
| | | if (dt.Columns[i].DataType.IsArray) |
| | | { |
| | | Value = Convert.ToBase64String((byte[])dr[i]); |
| | | } |
| | | else |
| | | { |
| | | Value = dr[i].ToString(); |
| | | PrepareValueText(ref Value); |
| | | } |
| | | sbJSONText.AppendFormat("\"{0}\":\"{1}\",", dt.Columns[i].ColumnName, Value); |
| | | } |
| | | } |
| | | sbJSONText.Remove(sbJSONText.Length - 1, 1); //廿æ¯ç¬è®°å½æåä¸ä¸ªå段åé¢ç"," |
| | | sbJSONText.Append("},\n"); |
| | | } |
| | | sbJSONText.Remove(sbJSONText.Length - 2, 1); //廿æå䏿¡è®°å½åé¢ç"," |
| | | sbJSONText.Append("],\n"); |
| | | } |
| | | sbJSONText.Remove(sbJSONText.Length - 2, 1); //廿æåä¸è®°å½éåé¢ç"," |
| | | sbJSONText.Append("}"); |
| | | |
| | | return sbJSONText.ToString(); |
| | | } |
| | | |
| | | //å¦ææ°æ®ä¸å
嫿JSONè§èä¸çç¹æ®å符(" \ \r \n \t)ï¼å¤ç¹æ®å符å \ ç¼ç |
| | | public static void PrepareValueText(ref string ValueText) |
| | | { |
| | | bool HasSpecialChar = false; |
| | | foreach(char ch in ValueText) |
| | | { |
| | | if (ch == '"' || ch == '\\' || ch == '\r' || ch == '\n' || ch == '\t') |
| | | { |
| | | HasSpecialChar = true; |
| | | break; |
| | | } |
| | | } |
| | | if (HasSpecialChar) |
| | | { |
| | | StringBuilder NewValueText = new StringBuilder(); |
| | | foreach (char ch in ValueText) |
| | | { |
| | | if (ch == '"' || ch == '\\' || ch == '\r' || ch == '\n' || ch == '\t') |
| | | { |
| | | NewValueText.Append( '\\'); |
| | | if (ch == '"' || ch == '\\') |
| | | NewValueText.Append( ch ); |
| | | else if (ch == '\r') |
| | | NewValueText.Append( 'r' ); |
| | | else if (ch == '\n') |
| | | NewValueText.Append( 'n' ); |
| | | else if (ch == '\t') |
| | | NewValueText.Append( 't' ); |
| | | } |
| | | else |
| | | { |
| | | NewValueText.Append( ch ); |
| | | } |
| | | } |
| | | ValueText = NewValueText.ToString(); |
| | | } |
| | | } |
| | | } |
| | |
| | | <publishTime>03/23/2021 16:57:43</publishTime> |
| | | </File> |
| | | <File Include="bin/WebTM.dll"> |
| | | <publishTime>04/22/2021 18:32:43</publishTime> |
| | | <publishTime>04/23/2021 17:24:02</publishTime> |
| | | </File> |
| | | <File Include="bin/WebTM.pdb"> |
| | | <publishTime>04/22/2021 18:32:43</publishTime> |
| | | <publishTime>04/23/2021 17:24:02</publishTime> |
| | | </File> |
| | | <File Include="layuiadmin/config.js"> |
| | | <publishTime>03/23/2021 16:57:43</publishTime> |
| | |
| | | <File Include="views/component/说æ.txt"> |
| | | <publishTime>03/23/2021 16:57:43</publishTime> |
| | | </File> |
| | | <File Include="views/CreateControl.js"> |
| | | <publishTime>04/23/2021 17:23:49</publishTime> |
| | | </File> |
| | | <File Include="views/grf/æ±æ¥å.grf"> |
| | | <publishTime>04/23/2021 17:05:55</publishTime> |
| | | </File> |
| | | <File Include="views/GRInstall.js"> |
| | | <publishTime>04/23/2021 17:23:49</publishTime> |
| | | </File> |
| | | <File Include="views/GRUtility.js"> |
| | | <publishTime>04/23/2021 17:23:49</publishTime> |
| | | </File> |
| | | <File Include="views/home/console.html"> |
| | | <publishTime>04/09/2021 09:06:20</publishTime> |
| | | </File> |
| | |
| | | <publishTime>03/23/2021 16:57:43</publishTime> |
| | | </File> |
| | | <File Include="views/index.html"> |
| | | <publishTime>04/21/2021 09:39:21</publishTime> |
| | | <publishTime>04/22/2021 20:02:50</publishTime> |
| | | </File> |
| | | <File Include="views/senior/echarts/bar.html"> |
| | | <publishTime>03/23/2021 16:57:43</publishTime> |
| | |
| | | <File Include="views/ç产工åºç®¡ç/å§å¤å·¥åºæ±æ¥å/Sc_StationOutBillMainList.html"> |
| | | <publishTime>03/29/2021 19:54:57</publishTime> |
| | | </File> |
| | | <File Include="views/ç产工åºç®¡ç/å·¥åºæ±æ¥å/HBarPlanPrint.html"> |
| | | <publishTime>04/23/2021 16:56:48</publishTime> |
| | | </File> |
| | | <File Include="views/ç产工åºç®¡ç/å·¥åºæ±æ¥å/Sc_Add_ProcessReportList.html"> |
| | | <publishTime>04/22/2021 19:52:57</publishTime> |
| | | <publishTime>04/23/2021 16:59:42</publishTime> |
| | | </File> |
| | | <File Include="views/ç产工åºç®¡ç/å·¥åºæ±æ¥å/Sc_ProcessReport_PDA.html"> |
| | | <publishTime>04/09/2021 17:56:11</publishTime> |
| | | </File> |
| | | <File Include="views/ç产工åºç®¡ç/å·¥åºæ±æ¥å/xmlLBM_ProcessReport.aspx"> |
| | | <publishTime>04/23/2021 16:41:10</publishTime> |
| | | </File> |
| | | <File Include="views/ç产工åºç®¡ç/å·¥åºæ´¾å·¥å/Sc_Add_ProcessSendWork.html"> |
| | | <publishTime>04/21/2021 16:40:38</publishTime> |
| | |
| | | <publishTime>04/09/2021 09:06:20</publishTime> |
| | | </File> |
| | | <File Include="views/车é´ç®¡ç/å§å¤å·¥åºæ¥æ¶å/Cj_StationEntrustOutBill.html"> |
| | | <publishTime>04/21/2021 09:39:21</publishTime> |
| | | <publishTime>04/22/2021 20:02:50</publishTime> |
| | | </File> |
| | | <File Include="views/车é´ç®¡ç/å§å¤å·¥åºæ¥æ¶å/Cj_StationEntrustOutBillList.html"> |
| | | <publishTime>04/08/2021 10:57:44</publishTime> |
| | |
| | | <publishTime>04/08/2021 10:57:44</publishTime> |
| | | </File> |
| | | <File Include="views/车é´ç®¡ç/å·¥åºåºç«ååºå/Cj_StationOutBill.html"> |
| | | <publishTime>04/22/2021 17:01:48</publishTime> |
| | | <publishTime>04/22/2021 20:02:50</publishTime> |
| | | </File> |
| | | <File Include="views/车é´ç®¡ç/å·¥åºåºç«ååºå/Cj_StationOutBillList.html"> |
| | | <publishTime>04/22/2021 17:08:14</publishTime> |
| | | <publishTime>04/22/2021 20:02:50</publishTime> |
| | | </File> |
| | | <File Include="views/车é´ç®¡ç/å·¥åºæµè½¬/MES_StationInBill.html"> |
| | | <publishTime>03/29/2021 20:16:17</publishTime> |
| | |
| | | <publishTime>03/23/2021 16:57:43</publishTime> |
| | | </File> |
| | | <File Include="views/车é´ç®¡ç/å·¥åºè¿ç«æ¥æ¶å/Cj_StationInBill.html"> |
| | | <publishTime>04/21/2021 09:39:21</publishTime> |
| | | <publishTime>04/22/2021 20:02:50</publishTime> |
| | | </File> |
| | | <File Include="views/车é´ç®¡ç/å·¥åºè¿ç«æ¥æ¶å/Cj_StationInBillList.html"> |
| | | <publishTime>04/21/2021 09:39:21</publishTime> |
| | | <publishTime>04/22/2021 20:02:51</publishTime> |
| | | </File> |
| | | <File Include="views/车é´ç®¡ç/æ¥è¡¨åæ/Qk_OutProcessList.html"> |
| | | <publishTime>03/23/2021 16:57:43</publishTime> |
| | |
| | | <Content Include="layuiadmin\layui\font\iconfont.ttf" /> |
| | | <Content Include="layuiadmin\layui\font\iconfont.woff" /> |
| | | <None Include="Properties\PublishProfiles\JFTM.pubxml" /> |
| | | <Content Include="views\CreateControl.js" /> |
| | | <Content Include="views\grf\æ±æ¥å.grf" /> |
| | | <None Include="Web.Debug.config"> |
| | | <DependentUpon>Web.config</DependentUpon> |
| | | </None> |
| | |
| | | <Content Include="views\component\upload\index.html" /> |
| | | <Content Include="views\component\util\index.html" /> |
| | | <Content Include="views\component\说æ.txt" /> |
| | | <Content Include="views\GRInstall.js" /> |
| | | <Content Include="views\GRUtility.js" /> |
| | | <Content Include="views\home\console.html" /> |
| | | <Content Include="views\home\homepage1.html" /> |
| | | <Content Include="views\home\homepage2.html" /> |
| | |
| | | <Content Include="views\åºç¡èµæ\éè´åºç¡èµæ\Gy_Supplier.html" /> |
| | | <Content Include="views\模治å
·ç®¡ç\模治å
·ç®¡ç\Gy_CheckToolsFileMainList.html" /> |
| | | <Content Include="views\模治å
·ç®¡ç\模治å
·ç®¡ç\Gy_Mould.html" /> |
| | | <Content Include="views\ç产工åºç®¡ç\å·¥åºæ±æ¥å\HBarPlanPrint.html" /> |
| | | <Content Include="views\ç产工åºç®¡ç\å·¥åºæ±æ¥å\xmlLBM_ProcessReport.aspx" /> |
| | | <Content Include="views\车é´ç®¡ç\å·¥åºåºç«ååºå\Cj_StationOutBill.html" /> |
| | | <Content Include="views\车é´ç®¡ç\å·¥åºåºç«ååºå\Cj_StationOutBillList.html" /> |
| | | <Content Include="views\车é´ç®¡ç\å·¥åºè¿ç«æ¥æ¶å\Cj_StationInBill.html" /> |
| | |
| | | <None Include="Properties\PublishProfiles\Web.pubxml" /> |
| | | </ItemGroup> |
| | | <ItemGroup> |
| | | <Compile Include="App_Data\MssqlReportData.cs" /> |
| | | <Compile Include="App_Data\ReportData.cs" /> |
| | | <Compile Include="Properties\AssemblyInfo.cs" /> |
| | | <Compile Include="views\ç产工åºç®¡ç\å·¥åºæ±æ¥å\xmlLBM_ProcessReport.aspx.cs"> |
| | | <DependentUpon>xmlLBM_ProcessReport.aspx</DependentUpon> |
| | | <SubType>ASPXCodeBehind</SubType> |
| | | </Compile> |
| | | <Compile Include="views\ç产工åºç®¡ç\å·¥åºæ±æ¥å\xmlLBM_ProcessReport.aspx.designer.cs"> |
| | | <DependentUpon>xmlLBM_ProcessReport.aspx</DependentUpon> |
| | | </Compile> |
| | | </ItemGroup> |
| | | <ItemGroup> |
| | | <Folder Include="views\ä»å管ç\è°æ¨åæ ¸å¯¹\" /> |
New file |
| | |
| | | //1ãåé gr_InstallPath çå·åé¢çåæ°æ¯æä»¶å®è£
æä»¶çæå¨çç½ç«ç®å½ï¼ä¸è¬ä»ç½ç«çæ ¹ç® |
| | | // å½å¼å§å¯»åï¼æä»¶å®è£
æä»¶ä¸å®è¦åå¨äºæå®ç®å½ä¸ã |
| | | //2ãgr_Version çå·åé¢çåæ°æ¯æä»¶å®è£
å
ççæ¬å·ï¼å¦æææ°çæ¬æä»¶å®è£
å
ï¼åºä¸ä¼ æ°ç |
| | | // æ¬æä»¶å®è£
æä»¶å°ç½ç«å¯¹åºç®å½ï¼å¹¶æ´æ°è¿éççæ¬å·ã |
| | | //3ãæ´å¤è¯¦ç»ä¿¡æ¯è¯·åè帮å©ä¸âæ¥è¡¨æä»¶(WEBæ¥è¡¨)->卿å¡å¨é¨ç½²æä»¶å®è£
å
âé¨å |
| | | var gr_InstallPath = "grinstall"; //å®é
项ç®ä¸åºè¯¥å仿 ¹ç®å½å¯»åçç®å½ï¼å¦gr_InstallPath="/myapp/report/grinstall"; |
| | | var gr_Version = "6,0,15,0819"; |
| | | |
| | | //以䏿³¨åå·ä¸ºæ¬æºå¼åæµè¯æ³¨åå·ï¼æ¥è¡¨è®¿é®å°å为localhostæ¶å¯ä»¥å»æè¯ç¨æ å¿ |
| | | //è´ä¹°æ³¨ååï¼è¯·ç¨æ¨ç注åç¨æ·å䏿³¨åå·æ¿æ¢ä¸é¢åéä¸å¼ |
| | | var gr_UserName = 'éæµªæ¥è¡¨æä»¶æ¬æºå¼åæµè¯æ³¨å'; |
| | | var gr_SerialNo = '8PJH495VA61FLI5TG0L4KB2337F1G7AKLD6LNNA9F9T28IKRU6N33P8Z6XX4BUYB5E9NZ6INMD5T8EN47IX63VV7F9BJHB5ZJQQ6MX3J3V12C4XDHU97SXX6X3VA57KCB6'; |
| | | |
| | | //æ¥è¡¨æä»¶ç®ååªè½å¨32使µè§å¨ä¸ä½¿ç¨ |
| | | var _gr_platform = window.navigator.platform; |
| | | if (_gr_platform.indexOf("64") > 0) |
| | | alert("éæµªGrid++Reportæ¥è¡¨æä»¶ä¸è½è¿è¡å¨64使µè§å¨ä¸ï¼ç¸å
³æ¥è¡¨ä¸æå°åè½å°æ æ³æ£å¸¸è¿æ°ï¼è¯·æ¹ç¨32使µè§å¨ï¼"); |
| | | |
| | | //åºåæµè§å¨(IE or not) |
| | | var _gr_agent = navigator.userAgent.toLowerCase(); |
| | | var _gr_isIE = (_gr_agent.indexOf("msie")>0)? true : false; |
| | | |
| | | var gr_CodeBase; |
| | | if( _gr_isIE ) |
| | | gr_CodeBase = 'codebase="' + gr_InstallPath + '/grbsctl6.cab#Version=' + gr_Version + '"'; |
| | | else |
| | | gr_CodeBase = ''; |
| | | |
| | | //å建æ¥è¡¨å¯¹è±¡ï¼æ¥è¡¨å¯¹è±¡æ¯ä¸å¯è§ç对象ï¼è¯¦ç»è¯·æ¥ç帮å©ä¸ç IGridppReport |
| | | //Name - æå®æä»¶å¯¹è±¡çIDï¼å¯ä»¥ç¨js代ç document.getElementById("%Name%") è·åæ¥è¡¨å¯¹è±¡ |
| | | //EventParams - æå®æ¥è¡¨å¯¹è±¡çéè¦ååºçäºä»¶ï¼å¦ï¼"<param name='OnInitialize' value=OnInitialize> <param name='OnProcessBegin' value=OnProcessBegin>"å½¢å¼ï¼å¯ä»¥æå®å¤ä¸ªäºä»¶ |
| | | function CreateReport(PluginID, EventParams) |
| | | { |
| | | var typeid; |
| | | if( _gr_isIE ) |
| | | typeid = 'classid="clsid:396841CC-FC0F-4989-8182-EBA06AA8CA2F" '; |
| | | else |
| | | typeid = 'type="application/x-grplugin6-report" '; |
| | | typeid += gr_CodeBase; |
| | | document.write('<object id="' + PluginID + '" ' + typeid); |
| | | document.write(' width="0" height="0" VIEWASTEXT>'); |
| | | if (EventParams != undefined) |
| | | document.write(EventParams); |
| | | document.write('</object>'); |
| | | |
| | | document.write('<script type="text/javascript">'); |
| | | document.write(PluginID + '.Register("' + gr_UserName + '", "' + gr_SerialNo + '");'); |
| | | document.write('</script>'); |
| | | } |
| | | |
| | | //ç¨æ´å¤çåæ°å建æ¥è¡¨æå°æ¾ç¤ºæä»¶ï¼è¯¦ç»è¯·æ¥ç帮å©ä¸ç IGRPrintViewer |
| | | //PluginID - æä»¶çIDï¼å¯ä»¥éè¿ var ReportViewer = document.getElementById("%PluginID%"); è¿æ ·çæ¹å¼è·åæä»¶å¼ç¨åé |
| | | //Width - æä»¶çæ¾ç¤ºå®½åº¦ï¼"100%"为æ´ä¸ªæ¾ç¤ºåºå宽度ï¼"500"表示500个å±å¹åç´ ç¹ |
| | | //Height - æä»¶çæ¾ç¤ºé«åº¦ï¼"100%"为æ´ä¸ªæ¾ç¤ºåºåé«åº¦ï¼"500"表示500个å±å¹åç´ ç¹ |
| | | //ReportURL - è·åæ¥è¡¨æ¨¡æ¿çURL |
| | | //DataURL - è·åæ¥è¡¨æ°æ®çURL |
| | | //AutoRun - æå®æä»¶å¨å建ä¹åæ¯å¦èªå¨çæå¹¶å±ç°æ¥è¡¨,å¼ä¸ºfalseætrue |
| | | //ExParams - æå®æ´å¤çæä»¶å±æ§éè¿°,å½¢å¦: "<param name="%ParamName%" value="%Value%">"è¿æ ·ç忰䏲 |
| | | function CreatePrintViewerEx2(PluginID, Width, Height, ReportURL, DataURL, AutoRun, ExParams) |
| | | { |
| | | var typeid; |
| | | if( _gr_isIE ) |
| | | typeid = 'classid="clsid:ABB64AAC-D7E8-4733-B052-1B141C92F3CE" ' + gr_CodeBase; |
| | | else |
| | | typeid = 'type="application/x-grplugin6-printviewer"'; |
| | | document.write('<object id="' + PluginID + '" ' + typeid); |
| | | document.write(' width="' + Width + '" height="' + Height + '">'); |
| | | document.write('<param name="ReportURL" value="' + ReportURL + '">'); |
| | | document.write('<param name="DataURL" value="' + DataURL + '">'); |
| | | document.write('<param name="AutoRun" value=' + AutoRun + '>'); |
| | | document.write('<param name="SerialNo" value="' + gr_SerialNo + '">'); |
| | | document.write('<param name="UserName" value="' + gr_UserName + '">'); |
| | | document.write(ExParams); |
| | | document.write('</object>'); |
| | | } |
| | | |
| | | //ç¨æ´å¤çåæ°å建æ¥è¡¨æå°æ¾ç¤ºæä»¶ï¼è¯¦ç»è¯·æ¥ç帮å©ä¸ç IGRDisplayViewer |
| | | //PluginID - æä»¶çIDï¼å¯ä»¥éè¿ var ReportViewer = document.getElementById("%PluginID%"); è¿æ ·çæ¹å¼è·åæä»¶å¼ç¨åé |
| | | //Width - æä»¶çæ¾ç¤ºå®½åº¦ï¼"100%"为æ´ä¸ªæ¾ç¤ºåºå宽度ï¼"500"表示500个å±å¹åç´ ç¹ |
| | | //Height - æä»¶çæ¾ç¤ºé«åº¦ï¼"100%"为æ´ä¸ªæ¾ç¤ºåºåé«åº¦ï¼"500"表示500个å±å¹åç´ ç¹ |
| | | //ReportURL - è·åæ¥è¡¨æ¨¡æ¿çURL |
| | | //DataURL - è·åæ¥è¡¨æ°æ®çURL |
| | | //AutoRun - æå®æä»¶å¨å建ä¹åæ¯å¦èªå¨çæå¹¶å±ç°æ¥è¡¨,å¼ä¸ºfalseætrue |
| | | //ExParams - æå®æ´å¤çæä»¶å±æ§éè¿°,å½¢å¦: "<param name="%ParamName%" value="%Value%">"è¿æ ·ç忰䏲 |
| | | function CreateDisplayViewerEx2(PluginID, Width, Height, ReportURL, DataURL, AutoRun, ExParams) |
| | | { |
| | | var typeid; |
| | | if( _gr_isIE ) |
| | | typeid = 'classid="clsid:600CD6D9-EBE1-42cb-B8DF-DFB81977122E" ' + gr_CodeBase; |
| | | else |
| | | typeid = 'type="application/x-grplugin6-displayviewer"'; |
| | | document.write('<object id="' + PluginID + '" ' + typeid); |
| | | document.write(' width="' + Width + '" height="' + Height + '">'); |
| | | document.write('<param name="ReportURL" value="' + ReportURL + '">'); |
| | | document.write('<param name="DataURL" value="' + DataURL + '">'); |
| | | document.write('<param name="AutoRun" value=' + AutoRun + '>'); |
| | | document.write('<param name="SerialNo" value="' + gr_SerialNo + '">'); |
| | | document.write('<param name="UserName" value="' + gr_UserName + '">'); |
| | | document.write(ExParams); |
| | | document.write('</object>'); |
| | | } |
| | | |
| | | //以 ReportDesigner 为 ID å建æ¥è¡¨è®¾è®¡å¨æä»¶(Designer)ï¼è¯¦ç»è¯·æ¥ç帮å©ä¸ç IGRDesigner |
| | | //Width - æä»¶çæ¾ç¤ºå®½åº¦ï¼"100%"为æ´ä¸ªæ¾ç¤ºåºå宽度ï¼"500"表示500个å±å¹åç´ ç¹ |
| | | //Height - æä»¶çæ¾ç¤ºé«åº¦ï¼"100%"为æ´ä¸ªæ¾ç¤ºåºåé«åº¦ï¼"500"表示500个å±å¹åç´ ç¹ |
| | | //LoadReportURL - è¯»åæ¥è¡¨æ¨¡æ¿çURLï¼è¿è¡æ¶ä»æ¤URL读å
¥æ¥è¡¨æ¨¡æ¿æ°æ®å¹¶å è½½å°è®¾è®¡å¨æä»¶ |
| | | //SaveReportURL - ä¿åæ¥è¡¨æ¨¡æ¿çURLï¼ä¿å设计åçç»ææ°æ®ï¼ç±æ¤URLçæå¡å¨WEBæå¡ç«¯å°æ¥è¡¨æ¨¡æ¿æä¹
ä¿å |
| | | //DataURL - è·åæ¥è¡¨è¿è¡æ¶æ°æ®çURLï¼å¨è®¾è®¡å¨ä¸è¿å
¥æå°è§å¾ä¸æ¥è¯¢è§å¾æ¶ä»æ¤URLè·åæ¥è¡¨æ°æ® |
| | | //ExParams - æå®æ´å¤çæä»¶å±æ§éè¿°,å½¢å¦: "<param name="%ParamName%" value="%Value%">"è¿æ ·ç忰䏲 |
| | | function CreateDesignerEx(Width, Height, LoadReportURL, SaveReportURL, DataURL, ExParams) |
| | | { |
| | | var typeid; |
| | | if( _gr_isIE ) |
| | | typeid = 'classid="clsid:CE666189-5D7C-42ee-AAA4-E5CB375ED3C7" ' + gr_CodeBase; |
| | | else |
| | | typeid = 'type="application/x-grplugin6-designer"'; |
| | | |
| | | |
| | | document.write('<object id="ReportDesigner" ' + typeid); |
| | | document.write(' width="' + Width + '" height="' + Height + '">'); |
| | | document.write('<param name="LoadReportURL" value="' + LoadReportURL + '">'); |
| | | document.write('<param name="SaveReportURL" value="' + SaveReportURL + '">'); |
| | | document.write('<param name="DataURL" value="' + DataURL + '">'); |
| | | document.write('<param name="SerialNo" value="' + gr_SerialNo + '">'); |
| | | document.write('<param name="UserName" value="' + gr_UserName + '">'); |
| | | document.write(ExParams); |
| | | document.write('</object>'); |
| | | } |
| | | |
| | | //以 ReportViewer 为 ID å建æ¥è¡¨æå°æ¾ç¤ºå¨æä»¶(PrintViewer)ï¼åæ°è¯´æåè CreatePrintViewerEx2 |
| | | function CreatePrintViewerEx(Width, Height, ReportURL, DataURL, AutoRun, ExParams) |
| | | { |
| | | CreatePrintViewerEx2("ReportViewer", Width, Height, ReportURL, DataURL, AutoRun, ExParams) |
| | | } |
| | | |
| | | //以 ReportViewer 为 ID å建æ¥è¡¨æ¥è¯¢æ¾ç¤ºå¨æä»¶(DisplayViewer)ï¼åæ°è¯´æåè CreateDisplayViewerEx2 |
| | | function CreateDisplayViewerEx(Width, Height, ReportURL, DataURL, AutoRun, ExParams) |
| | | { |
| | | CreateDisplayViewerEx2("ReportViewer", Width, Height, ReportURL, DataURL, AutoRun, ExParams) |
| | | } |
| | | |
| | | //以 ReportViewer 为 ID å建æ¥è¡¨æå°æ¾ç¤ºå¨æä»¶(PrintViewer)ï¼æä»¶å¤§å°ä¸º100%å
满ä½ç½®åºåï¼æä»¶å建åä¼èªå¨è¿è¡ï¼åæ°è¯´æåè CreatePrintViewerEx2 |
| | | function CreatePrintViewer(ReportURL, DataURL) |
| | | { |
| | | CreatePrintViewerEx("100%", "100%", ReportURL, DataURL, true, ""); |
| | | } |
| | | |
| | | //以 ReportViewer 为 ID å建æ¥è¡¨æ¥è¯¢æ¾ç¤ºå¨æä»¶(DisplayViewer)ï¼æä»¶å¤§å°ä¸º100%å
满ä½ç½®åºåï¼æä»¶å建åä¼èªå¨è¿è¡ï¼åæ°è¯´æåè CreateDisplayViewerEx2 |
| | | function CreateDisplayViewer(ReportURL, DataURL) |
| | | { |
| | | CreateDisplayViewerEx("100%", "100%", ReportURL, DataURL, true, ""); |
| | | } |
| | | |
| | | //以 ReportDesigner 为 ID å建æ¥è¡¨è®¾è®¡å¨æä»¶(Designer)ï¼æä»¶å¤§å°ä¸º100%å
满ä½ç½®åºåï¼åæ°è¯´æåè CreateDesignerEx |
| | | function CreateDesigner(LoadReportURL, SaveReportURL, DataURL) |
| | | { |
| | | CreateDesignerEx("100%", "100%", LoadReportURL, SaveReportURL, DataURL, ""); |
| | | } |
New file |
| | |
| | | //å¨ç½é¡µä¸å¼ç¨æ¤æä»¶ä¹åï¼åºè¯¥å
å¼ç¨CreateControl.js |
| | | //document.write("<script type='text/javascript' src='CreateControl.js'></script>"); |
| | | |
| | | //æå
¥ä¸ä¸ªæ¥è¡¨å¯¹è±¡ï¼ç¨æ¥å¤ææä»¶æ¯å¦å·²ç»å®è£
ï¼ææ¯å¦éè¦å®è£
æ´æ°çæ¬ |
| | | //æ¤å½æ°åºè¯¥å¨ç½é¡µç<head>ä¸è°ç¨ï¼å
·ä½è¯·çä¾å ReportHome.htm ä¸çç¨æ³ |
| | | function Install_InsertReport() |
| | | { |
| | | var typeid; |
| | | if( _gr_isIE ) |
| | | typeid = 'classid="clsid:396841CC-FC0F-4989-8182-EBA06AA8CA2F" '; |
| | | else |
| | | typeid = 'type="application/x-grplugin6-report" '; |
| | | typeid += gr_CodeBase; |
| | | document.write('<object id="_ReportOK" ' + typeid); |
| | | document.write(' width="0" height="0" VIEWASTEXT>'); |
| | | document.write('</object>'); |
| | | } |
| | | |
| | | //ç¨æ¥å¤ææä»¶æ¯å¦å·²ç»å®è£
ï¼ææ¯å¦éè¦å®è£
æ´æ°çæ¬ã妿éè¦å®è£
ï¼åå¨ç½é¡µä¸æå
¥å®è£
ç¸å
³çæåå
容 |
| | | //妿æä»¶å·²ç»å®è£
ä¸ä¹ä¸è¦æ´æ°ï¼åè¿å trueï¼åä¹ä¸º falseã |
| | | //æ¤å½æ°åºè¯¥å¨ç½é¡µç<body>å¼å§ä½ç½®å¤è°ç¨ï¼å
·ä½è¯·çä¾å ReportHome.htm ä¸çç¨æ³ |
| | | function Install_Detect() |
| | | { |
| | | var _ReportOK = document.getElementById("_ReportOK"); |
| | | if (_ReportOK.Register == undefined) //if ((_ReportOK == null) || (_ReportOK.Register == undefined)) |
| | | { |
| | | document.write('<div style="width: 100%; background-color: #fff8dc; text-align: center; vertical-align: middle; line-height: 20pt; padding-bottom: 12px; padding-top: 12px;">'); |
| | | document.write('<strong> æ¤ç½ç«éè¦å®è£
éæµªæ¥è¡¨æä»¶ æè½ä¿è¯å
¶æ£å¸¸è¿è¡<br /></strong>'); |
| | | |
| | | if( _gr_isIE ) |
| | | document.write('<strong><span style="color: #ff0000"> 妿µè§å¨ç顶鍿åºé¨åºç°æç¤ºæ¡ï¼å·¦é®ç¹å»æç¤ºæ¡å¹¶è¿è¡å è½½é¡¹ï¼ææ¤æ¹å¼å®è£
æç®ä¾¿</span><br /></strong>'); |
| | | |
| | | document.write('<a href="' + gr_InstallPath + '/grbsctl6.exe"><span style="color: #ff0000"><strong>ç¹å»æ¤å¤ä¸è½½é浪æ¥è¡¨æä»¶å®è£
å
<br /></strong></span></a>'); |
| | | document.write('éæµªæ¥è¡¨æä»¶å®è£
åï¼<a href="#" onclick="javascript:document.location.reload();">ç¹å»æ¤å¤</a> éæ°å è½½æ¤ç½ç«'); |
| | | document.write('</div>'); |
| | | return false; |
| | | } |
| | | else if ((_ReportOK.Utility.ShouldUpdatePlugin == undefined) || _ReportOK.Utility.ShouldUpdatePlugin(gr_Version) == true) //æ£æ¥æ¯å¦åºè¯¥ä¸è½½æ°çæ¬ç¨åº |
| | | { |
| | | document.write('<div style="width: 100%; background-color: #fff8dc; text-align: center; vertical-align: middle; line-height: 20pt; padding-bottom: 12px; padding-top: 12px;">'); |
| | | document.write('<strong> æ¤ç½ç«éè¦å级å®è£
éæµªæ¥è¡¨æä»¶ æè½ä¿è¯å
¶æ£å¸¸è¿è¡<br /></strong>'); |
| | | document.write('<a href="' + gr_InstallPath + '/grbsctl6.exe"><span style="color: #ff0000"><strong>ç¹å»æ¤å¤ä¸è½½é浪æ¥è¡¨æä»¶å®è£
å
<br /></strong></span></a>'); |
| | | document.write('æä»¶å®è£
æ¶å¿
é¡»å
³éç½é¡µçªå£ï¼ç¹å»æ¬ç½é¡µçªå£çå
³éæé®è¿è¡å
³éï¼å®è£
宿ååéæ°æå¼æ¬ç½é¡µ<br />'); |
| | | document.write('å¦å®è£
ä¸åºç°âä¸è½æå¼è¦åå
¥çæä»¶...âçæç¤ºæ¶ï¼è¯·å°ç½é¡µçªå£å
³éï¼ç¶åç¹å»âéè¯âæé®ç»§ç»å®è£
'); |
| | | document.write('</div>'); |
| | | return false; |
| | | } |
| | | |
| | | return true; |
| | | } |
New file |
| | |
| | | //ç±ä¸åè²å¼åæé¢è²æ´æ°å¼ |
| | | function ColorFromRGB(red, green, blue) |
| | | { |
| | | return red + green*256 + blue*256*256; |
| | | } |
| | | |
| | | //è·åé¢è²ä¸ç红è²å¼ï¼ä¼ å
¥åæ°ä¸ºæ´æ°è¡¨ç¤ºçRGBå¼ |
| | | function ColorGetR(intColor) |
| | | { |
| | | return intColor & 255; |
| | | } |
| | | |
| | | //è·åé¢è²ä¸ç绿è²å¼ï¼ä¼ å
¥åæ°ä¸ºæ´æ°è¡¨ç¤ºçRGBå¼ |
| | | function ColorGetG(intColor) |
| | | { |
| | | return (intColor>>8) & 255; |
| | | } |
| | | |
| | | //è·åé¢è²ä¸çèè²å¼ï¼ä¼ å
¥åæ°ä¸ºæ´æ°è¡¨ç¤ºçRGBå¼ |
| | | function ColorGetB(intColor) |
| | | { |
| | | return (intColor>>16) & 255; |
| | | } |
| | | |
| | | //å建 XMLHttpRequest 对象 |
| | | function CreateXMLHttpRequest() |
| | | { |
| | | var xmlhttp; |
| | | if (window.XMLHttpRequest) |
| | | xmlhttp = new XMLHttpRequest(); // code for IE7+, Firefox, Chrome, Opera, Safari |
| | | else |
| | | xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); // code for IE6, IE5 |
| | | return xmlhttp; |
| | | } |
| | | |
| | | //æå¼æ¥æ¹å¼è¯·æ±æ¥è¡¨æ°æ®ï¼å¨ååºäºä»¶ä¸å°æ°æ®å è½½è¿æ¥è¡¨ï¼ç¶åæ§è¡åç»ä»»å¡å½æ° |
| | | function AjaxReportRun(Report, DataUrl, RunFun) |
| | | { |
| | | var xmlhttp = CreateXMLHttpRequest(); |
| | | xmlhttp.onreadystatechange = function() |
| | | { |
| | | if (xmlhttp.readyState==4 && xmlhttp.status==200) |
| | | { |
| | | Report.LoadDataFromAjaxRequest(xmlhttp.responseText, xmlhttp.getAllResponseHeaders()); //å è½½æ¥è¡¨æ°æ® |
| | | RunFun(); //æ°æ®å è½½åéè¦æ§è¡çä»»å¡ |
| | | } |
| | | } |
| | | xmlhttp.open("POST", encodeURI(DataUrl), true); |
| | | xmlhttp.send(); |
| | | } |
| | | |
| | | //æå¼æ¥æ¹å¼è¯·æ±æ¥è¡¨æ°æ®ï¼å¨ååºäºä»¶ä¸å°æ°æ®å è½½è¿æ¥è¡¨ï¼å¹¶å¯å¨æ¥è¡¨æ¥çå¨çè¿è¡ |
| | | function AjaxReportViewerStart(ReportViewer, DataUrl) |
| | | { |
| | | ReportViewer.Stop(); //é¦å
忢æ¥è¡¨çè¿è¡ |
| | | |
| | | var xmlhttp = CreateXMLHttpRequest(); |
| | | xmlhttp.onreadystatechange = function() |
| | | { |
| | | if (xmlhttp.readyState==4 && xmlhttp.status==200) |
| | | { |
| | | ReportViewer.Report.LoadDataFromAjaxRequest(xmlhttp.responseText, xmlhttp.getAllResponseHeaders()); //å è½½æ¥è¡¨æ°æ® |
| | | ReportViewer.Start(); //å¯å¨æ¥è¡¨è¿è¡ |
| | | } |
| | | } |
| | | xmlhttp.open("POST", encodeURI(DataUrl), true); |
| | | xmlhttp.send(); |
| | | } |
| | | |
| | | //æå¼æ¥æ¹å¼è¯·æ±æ¥è¡¨æ¨¡æ¿ä¸æ¥è¡¨æ°æ®ï¼å¨ååºäºä»¶ä¸å°æ¨¡æ¿ä¸æ°æ®å è½½è¿æ¥è¡¨ï¼å¹¶å¯å¨æ¥è¡¨æ¥çå¨çè¿è¡ |
| | | function AjaxReportViewerStart2(ReportViewer, ReportUrl, DataUrl, ReportUrlMethod) |
| | | { |
| | | var xmlhttp = CreateXMLHttpRequest(); |
| | | xmlhttp.onreadystatechange = function() |
| | | { |
| | | if (xmlhttp.readyState==4 && xmlhttp.status==200) |
| | | { |
| | | ReportViewer.Report.LoadFromStr(xmlhttp.responseText); |
| | | |
| | | AjaxReportViewerStart(ReportViewer, DataUrl); |
| | | } |
| | | } |
| | | xmlhttp.open(ReportUrlMethod, encodeURI(ReportUrl), true); |
| | | xmlhttp.send(); |
| | | } |
| | | |
| | | //æå¼æ¥æ¹å¼è¯·æ±æ¥è¡¨æ¨¡æ¿ï¼å¨ååºäºä»¶ä¸å°æ¨¡æ¿å è½½ |
| | | function AjaxReportLoad(Report, ReportUrl, ReportUrlMethod) |
| | | { |
| | | var xmlhttp = CreateXMLHttpRequest(); |
| | | xmlhttp.onreadystatechange = function() |
| | | { |
| | | if (xmlhttp.readyState==4 && xmlhttp.status==200) |
| | | Report.LoadFromStr(xmlhttp.responseText); |
| | | } |
| | | xmlhttp.open(ReportUrlMethod, encodeURI(ReportUrl), true); |
| | | xmlhttp.send(); |
| | | } |
| | | |
| | | |
| | | //æåæ¥æ¹å¼è¯·æ±æ¥è¡¨æ°æ®ï¼æ°æ®è¯·æ±æ¹æ³è°ç¨åç´§æ¥çè°ç¨æ¥è¡¨è½½å
¥æ°æ®çæ¹æ³ |
| | | //ç¨ Ajax è½½å
¥åæ¥è¡¨æ°æ®å¿
é¡»ç¨ HTTP åæ¥æ°æ®è¯·æ±ï¼å³éç¨æ¬å½æ° |
| | | function AjaxSyncLoadReportData(Report, DataUrl) |
| | | { |
| | | var xmlhttp = CreateXMLHttpRequest(); |
| | | xmlhttp.open("POST", encodeURI(DataUrl), false); |
| | | xmlhttp.send(); |
| | | Report.LoadDataFromAjaxRequest(xmlhttp.responseText, xmlhttp.getAllResponseHeaders()); //å è½½æ¥è¡¨æ°æ® |
| | | } |
New file |
| | |
| | | Object Report |
| | | Version='6.0.0.6' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=105000,0 |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | Object Printer |
| | | Height=29.7 |
| | | Oriention=Landscape |
| | | LeftMargin=1.5 |
| | | TopMargin=0.5 |
| | | RightMargin=1.5 |
| | | BottomMargin=0.5 |
| | | End |
| | | Object DetailGrid |
| | | Object Recordset |
| | | Items Field |
| | | Item |
| | | Name='åæ®å·' |
| | | End |
| | | Item |
| | | Name='æ¥æ' |
| | | Type=DateTime |
| | | Format='yyyy//MM//dd' |
| | | End |
| | | Item |
| | | Name='ä¾åºå' |
| | | End |
| | | Item |
| | | Name='ç©æä»£ç ' |
| | | End |
| | | Item |
| | | Name='ç©æåç§°' |
| | | End |
| | | Item |
| | | Name='è§æ ¼åå·' |
| | | End |
| | | Item |
| | | Name='计éåä½' |
| | | End |
| | | Item |
| | | Name='æ°é' |
| | | Type=Integer |
| | | End |
| | | Item |
| | | Name='åä»·' |
| | | Type=Currency |
| | | End |
| | | Item |
| | | Name='éé¢' |
| | | Type=Currency |
| | | End |
| | | Item |
| | | Name='å«ç¨åä»·' |
| | | Type=Currency |
| | | End |
| | | Item |
| | | Name='äº¤è´§æ¥æ' |
| | | Type=DateTime |
| | | Format='yyyy//MM//dd' |
| | | End |
| | | Item |
| | | Name='ä¸å¡å' |
| | | End |
| | | Item |
| | | Name='è¡å·' |
| | | End |
| | | Item |
| | | Name='æ¹æ¬¡' |
| | | End |
| | | Item |
| | | Name='è®©æ¥æ¥æ¶' |
| | | End |
| | | Item |
| | | Name='çäº§æ¥æ' |
| | | End |
| | | Item |
| | | Name='åæ ¼æ°é' |
| | | End |
| | | Item |
| | | Name='计åè·è¸ªåå·' |
| | | End |
| | | Item |
| | | Name='éè´§åå·' |
| | | End |
| | | Item |
| | | Name='éè´è®¢åå·' |
| | | End |
| | | Item |
| | | Name='æºååå·' |
| | | End |
| | | Item |
| | | Name='è¡¨å¤´å¤æ³¨' |
| | | End |
| | | Item |
| | | Name='é¢è®¡å°è´§æ¥æ' |
| | | End |
| | | Item |
| | | Name='ä¾åºå代ç ' |
| | | End |
| | | Item |
| | | Name='Field3' |
| | | End |
| | | Item |
| | | Name='表ä½å¤æ³¨' |
| | | End |
| | | End |
| | | End |
| | | Items Column |
| | | Item |
| | | Name='åºå·' |
| | | Width=0.767292 |
| | | End |
| | | Item |
| | | Name='计åè·è¸ªåå·' |
| | | Width=2.80458 |
| | | End |
| | | Item |
| | | Name='ç©æä»£ç ' |
| | | Width=3.20146 |
| | | End |
| | | Item |
| | | Name='ç©æ' |
| | | Width=2.98979 |
| | | End |
| | | Item |
| | | Name='è§æ ¼åå·' |
| | | Width=3.01625 |
| | | End |
| | | Item |
| | | Name='计éåä½' |
| | | Width=1.79917 |
| | | End |
| | | Item |
| | | Name='æ°é' |
| | | Width=1.98438 |
| | | End |
| | | Item |
| | | Name='Column2' |
| | | Width=0.899583 |
| | | End |
| | | Item |
| | | Name='Column3' |
| | | Width=1.905 |
| | | End |
| | | Item |
| | | Name='Column4' |
| | | Width=2.01083 |
| | | End |
| | | Item |
| | | Name='Column5' |
| | | Width=1.98438 |
| | | End |
| | | Item |
| | | Name='Column6' |
| | | Width=3.20146 |
| | | End |
| | | End |
| | | Object ColumnContent |
| | | Height=1.00542 |
| | | Items ColumnContentCell |
| | | Item |
| | | Column='åºå·' |
| | | FreeCell=T |
| | | Items Control |
| | | Item |
| | | Type=SystemVarBox |
| | | Name='SystemVarBox1' |
| | | Dock=Fill |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | SystemVar=RowNo |
| | | End |
| | | End |
| | | End |
| | | Item |
| | | Column='计åè·è¸ªåå·' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | ShrinkFontToFit=T |
| | | DataField='æºååå·' |
| | | End |
| | | Item |
| | | Column='ç©æä»£ç ' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | ShrinkFontToFit=T |
| | | DataField='ç©æä»£ç ' |
| | | End |
| | | Item |
| | | Column='ç©æ' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | ShrinkFontToFit=T |
| | | DataField='ç©æåç§°' |
| | | End |
| | | Item |
| | | Column='è§æ ¼åå·' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | ShrinkFontToFit=T |
| | | DataField='è§æ ¼åå·' |
| | | End |
| | | Item |
| | | Column='计éåä½' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | ShrinkFontToFit=T |
| | | DataField='æ¹æ¬¡' |
| | | End |
| | | Item |
| | | Column='æ°é' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | ShrinkFontToFit=T |
| | | DataField='çäº§æ¥æ' |
| | | End |
| | | Item |
| | | Column='Column2' |
| | | FreeCell=T |
| | | Items Control |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox1' |
| | | Dock=Fill |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | TextAlign=MiddleCenter |
| | | DataField='计éåä½' |
| | | End |
| | | End |
| | | End |
| | | Item |
| | | Column='Column3' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | TextAlign=MiddleCenter |
| | | DataField='æ°é' |
| | | End |
| | | Item |
| | | Column='Column4' |
| | | TextAlign=MiddleCenter |
| | | End |
| | | Item |
| | | Column='Column5' |
| | | End |
| | | Item |
| | | Column='Column6' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | FreeCell=T |
| | | Items Control |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox2' |
| | | Dock=Fill |
| | | DataField='表ä½å¤æ³¨' |
| | | End |
| | | End |
| | | End |
| | | End |
| | | End |
| | | Object ColumnTitle |
| | | Height=1.00542 |
| | | RepeatStyle=OnPage |
| | | Items ColumnTitleCell |
| | | Item |
| | | GroupTitle=F |
| | | Column='åºå·' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | TextAlign=MiddleCenter |
| | | Text='åºå·' |
| | | End |
| | | Item |
| | | GroupTitle=F |
| | | Column='计åè·è¸ªåå·' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | TextAlign=MiddleCenter |
| | | Text='订åå·' |
| | | End |
| | | Item |
| | | GroupTitle=F |
| | | Column='ç©æä»£ç ' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | Text='ç©æä»£ç ' |
| | | End |
| | | Item |
| | | GroupTitle=F |
| | | Column='ç©æ' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | Text='ç©æåç§°' |
| | | End |
| | | Item |
| | | GroupTitle=F |
| | | Column='è§æ ¼åå·' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | Text='è§æ ¼åå·' |
| | | End |
| | | Item |
| | | GroupTitle=F |
| | | Column='计éåä½' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | Text='æ¹æ¬¡å·' |
| | | End |
| | | Item |
| | | GroupTitle=F |
| | | Column='æ°é' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | Text='çäº§æ¥æ' |
| | | End |
| | | Item |
| | | GroupTitle=F |
| | | Column='Column2' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=82500,0 |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | Text='计éåä½' |
| | | End |
| | | Item |
| | | GroupTitle=F |
| | | Column='Column3' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | TextAlign=MiddleCenter |
| | | Text='éè´§æ°é' |
| | | End |
| | | Item |
| | | GroupTitle=F |
| | | Column='Column4' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | TextAlign=MiddleCenter |
| | | Text='å
è£
æ°*å®é' |
| | | End |
| | | Item |
| | | GroupTitle=F |
| | | Column='Column5' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | TextAlign=MiddleCenter |
| | | Text='ç¾æ¶æ°é' |
| | | End |
| | | Item |
| | | GroupTitle=F |
| | | Column='Column6' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | Text='夿³¨' |
| | | End |
| | | End |
| | | End |
| | | End |
| | | Items ReportHeader |
| | | Item |
| | | Name='ReportHeader1' |
| | | Height=5.60917 |
| | | Items Control |
| | | Item |
| | | Type=MemoBox |
| | | Name='MemoBox3' |
| | | Left=7.59354 |
| | | Top=1.5875 |
| | | Width=11.6152 |
| | | Height=0.873125 |
| | | Object Border |
| | | Styles=[DrawBottom] |
| | | End |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=180000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | TextAlign=TopCenter |
| | | Text='é è´§ æ¸
å\r\n' |
| | | End |
| | | Item |
| | | Type=Barcode |
| | | Name='Barcode1' |
| | | Left=21.0079 |
| | | Top=0.608542 |
| | | Width=3.59833 |
| | | Height=2.80458 |
| | | BarcodeType=QRCode |
| | | Text='[#åæ®å·#]' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=82500,0 |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | End |
| | | Item |
| | | Type=MemoBox |
| | | Name='MemoBox4' |
| | | Left=0.396875 |
| | | Top=0.740833 |
| | | Width=15.0019 |
| | | Height=0.79375 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | Text='ä¾åºå:[#ä¾åºå#]' |
| | | End |
| | | Item |
| | | Type=MemoBox |
| | | Name='MemoBox6' |
| | | Left=0.396875 |
| | | Top=2.51354 |
| | | Width=14.605 |
| | | Height=0.6 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | TextAlign=TopLeft |
| | | Text='åéè´§åå·:[#éè´§åå·#]' |
| | | End |
| | | Item |
| | | Type=MemoBox |
| | | Name='MemoBox7' |
| | | Left=0.396875 |
| | | Top=3.09563 |
| | | Width=8.20208 |
| | | Height=0.6 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | TextAlign=TopLeft |
| | | Text='åæ®å·:[#åæ®å·#]' |
| | | End |
| | | Item |
| | | Type=MemoBox |
| | | Name='MemoBox10' |
| | | Left=0.396875 |
| | | Top=3.70417 |
| | | Width=14.605 |
| | | Height=0.6 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | TextAlign=TopLeft |
| | | Text='æ¶è´§å°åï¼æµæ±çå°å·å¸æ¤æ±åºå¼å大é䏿®µ818å·\r' |
| | | End |
| | | Item |
| | | Type=MemoBox |
| | | Name='MemoBox11' |
| | | Left=12.7 |
| | | Top=3.09563 |
| | | Width=6.40292 |
| | | Height=0.6 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | Text='ä¾åºåç¼ç ï¼[#ä¾åºå代ç #]' |
| | | End |
| | | Item |
| | | Type=MemoBox |
| | | Name='MemoBox12' |
| | | Left=0.396875 |
| | | Top=4.31271 |
| | | Width=8.20208 |
| | | Height=0.6 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | TextAlign=TopLeft |
| | | Text='éè´§æ¥æï¼[#æ¥æ#]' |
| | | End |
| | | Item |
| | | Type=MemoBox |
| | | Name='MemoBox13' |
| | | Left=0.396875 |
| | | Top=4.92125 |
| | | Width=8.20208 |
| | | Height=0.6 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | TextAlign=TopLeft |
| | | Text='æ¶è´§è系人ï¼é»å»º' |
| | | End |
| | | Item |
| | | Type=MemoBox |
| | | Name='MemoBox14' |
| | | Left=12.7 |
| | | Top=4.92125 |
| | | Width=8.20208 |
| | | Height=0.6 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | TextAlign=TopLeft |
| | | Text='çµè¯ï¼13185687491' |
| | | End |
| | | Item |
| | | Type=PictureBox |
| | | Name='PictureBox1' |
| | | Left=0.396875 |
| | | Top=0.211667 |
| | | Width=2.80458 |
| | | Height=0.582083 |
| | | Picture=-2055 |
| | | iVBORw0KGgoAAAANSUhEUgAAAEwAAAAbCAYAAADWHGlkAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAecSURBVGhD7Vlr |
| | | bFRFFJ5uCxgkgcTE3/pDfxjjD02MGAx9v0tEEjX6S4yAUUGiiRA0RhRE+tjubktLy0MNAgqFBugD2/IKpQ+00G5LKWxpaUsLbdFS+6KPPZ4zc27v3b23tDUgkPAlX27v |
| | | uefMnfl27syZU1Hd5QFPRw/0DNwCDbXtLVDXot8PDXfDpRt/Q3Pvdbbo6B/thbOtHVB77Rq4Day96obW7r/YS8dQXx+cbz8Gde3FJha3V8Ch1mr08ipnAyraPOBuu34H |
| | | drCnQlPbTWjq7uS7O8PrHQVPYx1c6qjHN5vfbYQQ89NARCVCjruNTWiMcIF47Xu+AzjdPIg2ByzfkcMWHU8t2wMiLBlEqN2XYekwb/EO9tJRPzqGz7OR2yyYCbbwDAhL |
| | | L2VvHSKSntN7iElmhiSxp4IITUSm8N3kEBGZIIKz+G5iCBGSDAGxLiiob2cTQECcEwIMHai42g8iLhW+zCpmi8K1zk4ciANscQ6McfnQhhQxDrDnn2ZvhSvDo2CLN/vr |
| | | dIIITzX90gEx2+Rzatccg8QxGCEiU0HEOvhucohQ7G/U5P6PBGNMXTCcutTJPINgslPh+nSuaO7HDjlg9a5ytig8s/RHGWuLTYMAEsFAEtFGz+Kz2Vvheu+Aaj8+Vfcn |
| | | wWUM/lDy3gWO8gqOUAiK5ndpPvF0NRDbMEJE4bIQ6+S7ySFCUeDIyT9hFCxJdsRXMPyVI/wFc8Kne8rYAjDqpbXILjsqIvBl4+uLRvzF6Fm0HS40XeQogK4ebAsHKKKt |
| | | YnAtwraoP08kbOEIhVnRO6V93M+fIYnsqTB9wVJQMDvfTYz/LJinpRMHjoLEuGDlznxYe6gaeR7WHkbidVNBCXZ4C7btgo+SjnCUEiwQhXx+5c/K38B1edUQnHoc28TB |
| | | hvh2XgqGIq/LP8f+dGXmKhoxfcFQ9HspWFbORTlTYtebd04NB6pKpWBPv/8bW5Rg1P4nGSfZ4ovRsVGMycABp8LAyBBblWAiIpnvJscDJ9jqnQW4djmhqqWRLWZ4vV4p |
| | | 6uxFGWzRBVvhOsYWM15Yk4OzzAmdV1rYwoJFPsyCZW5HPxd0D1GcVbKnbDTDRPg2+TdhXLC0iQVbmoyC4SbT1a5vMlIwzPf64TbgRgu3LWjEA7eGPRJsmoIty96Dfg48 |
| | | /uhHKCuQYDbMxzRMRbB3NxRKwS6160exWXGYh2E7r3y9FxauOQyvrTniwwVf6BsLYfqCUVpxDwVbzoI1dQ6yxRokWGCsvvZMRbC3NxyVgtW19LAFYCYJRv3CXEkyCtML |
| | | IyP9jkbTFgz9/w/Bmrv62WINJZje1nQEu9CqH95lWoFxcsbGU8avkthx+okzfcFI9LskWHnzwH0RrLZN/9w1wUgEEUvHHj9i7mbE9AW7i7tkFX4aSjB9EV6WvXvqgsXp |
| | | HZmKYG99U4SDdcDlJr1kowRzwdxFKTAvgWj34dw4vb+E+ypYQ3cNCpYGn/9SxBaAVRm7ceY4obvTtw7lDxpk0GL9PDklwTYXyMH2lJ9li1r0KXFtHByB2mEz3UgjHgn2 |
| | | 8AjmhYMNx3FRdcFn+/RPcsVPp+RC6+64c1WT2p7zRhrf6YJ9eAfBXvyuWJaGOj16pj8zPhsH9ABl+sWeG2xiwQzlnZe+Ooo+aXDYXcMWgPW5NSASXPDOtjNsMaOsxS1n |
| | | 2JPv7WWLLtiq7eaqqoY5r6M40Q4YGBxgC86wmAflLBmShANwwLKsEsitbIQjf1yRAtLh13H4LPxw9Dg2lCYH3tHXxWEAZ1qapS0A/Tbuq4XkA5WQcqBinN8WnoLZCRTn |
| | | hMWbfuUoXbD56/ZDSk65T0zK78WwOvecnF0iLBXPohyEkJk+vst+phLsOYYYA43QBEvZX2rpm3jwT/ZUIMEowT5SVgWZqENWpceHGeUe5acJRp8g1ZSIgSiETdas8KWh |
| | | VOyjop5THqY1DI8N4KBUsU9WN2OIVO5Rf9tQZIGfMe12ha0NHKULJn3xmeZP9wEUE041NicELdnKEQpyl6T8C4VUaYSKGY+PTmVPBRKM2lHv0PwM/lF+uyp9adi+zPhZ |
| | | Bx++ulH50RkqIF6rmOoVTEoO6Uq1Kymo4RPV8NjiTLm2kbjGWBWvEkoR6oQx7xhHANzoxZxOJp7mqqmqxOLf+CzlYC5HKMyUFVeKwf74xakY389PE8wWl272RYo43wIl |
| | | Ja6B6G9ZzSX/CPW5ChGGs4jEkc4GB75KsaKd8OwHvqVm2gyKMBOnX9B68HhFfrz9BPsrNI5QTV9v30SasdjmyIBvfjcjCo9G/NwUQ8QYI6Rg8tkEAkSls6eCCLX206ht |
| | | go8EY0xdsJc3gwjGc1QwrmFWDLHD40vS4Z8R3zxHK9/MoMZoXQnG9ScYB0uken0Ufq549Ro+R0L9bS8+x3bJx4ox6fDcm+b/DwaFZlj7a0SBjBAh3I+JuNDvfwALaGJY |
| | | +GkM3qz89p2vgRK3B4rdly1Zgs9vDtH2bq550b/CWvv7oKisFvbXnYaculLJzLwLcKiwEMqu6qmKhlu4WWwtqLNkVr4bcopPQdewuWSUdaLBMmaceXXsqbDvZJG1H3NL |
| | | /kXDiLywq+SEpZ/GjIJ69AP4F1sn4ukxmV+HAAAAAElFTkSuQmCC |
| | | End |
| | | Item |
| | | Type=MemoBox |
| | | Name='MemoBox15' |
| | | Left=12.7 |
| | | Top=4.33917 |
| | | Width=8.20208 |
| | | Height=0.6 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | TextAlign=TopLeft |
| | | Text='é¢è®¡å°è´§æ¥æï¼[#é¢è®¡å°è´§æ¥æ#]' |
| | | End |
| | | End |
| | | RepeatOnPage=T |
| | | End |
| | | End |
| | | Items ReportFooter |
| | | Item |
| | | Name='ReportFooter1' |
| | | Height=3.41313 |
| | | Items Control |
| | | Item |
| | | Type=ShapeBox |
| | | Name='ShapeBox1' |
| | | Left=0.132292 |
| | | Top=0.396875 |
| | | Width=26.4054 |
| | | Height=1.19063 |
| | | End |
| | | Item |
| | | Type=StaticBox |
| | | Name='StaticBox3' |
| | | Left=0.211667 |
| | | Top=2.40771 |
| | | Width=3.38667 |
| | | Height=0.582083 |
| | | Text='é货人ï¼' |
| | | End |
| | | Item |
| | | Type=StaticBox |
| | | Name='StaticBox4' |
| | | Left=16.4042 |
| | | Top=2.40771 |
| | | Width=3.20146 |
| | | Height=0.582083 |
| | | Text='æ¶è´§äººï¼' |
| | | End |
| | | Item |
| | | Type=MemoBox |
| | | Name='MemoBox16' |
| | | Left=0.211667 |
| | | Top=0.502708 |
| | | Width=26.1938 |
| | | Height=0.978958 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | Text='夿³¨ï¼[#è¡¨å¤´å¤æ³¨#]' |
| | | End |
| | | End |
| | | RepeatOnPage=T |
| | | End |
| | | End |
| | | End |
New file |
| | |
| | | <!DOCTYPE html> |
| | | <html xmlns="http://www.w3.org/1999/xhtml"> |
| | | <head> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> |
| | | <title>æå°</title> |
| | | <script src="../CreateControl.js"></script> |
| | | <script src="../GRInstall.js"></script> |
| | | <script src="../GRUtility.js"></script> |
| | | <style type="text/css"> |
| | | html, body { |
| | | margin: 0; |
| | | height: 100%; |
| | | } |
| | | </style> |
| | | <script type="text/javascript"> |
| | | |
| | | function getUrlVars() { |
| | | var vars = [], hash; |
| | | var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&'); |
| | | for (var i = 0; i < hashes.length; i++) { |
| | | hash = hashes[i].split('='); |
| | | vars.push(hash[0]); |
| | | vars[hash[0]] = hash[1]; |
| | | } |
| | | return vars; |
| | | } |
| | | //å¨ç½é¡µåå§å è½½æ¶åæ¥è¡¨æä¾æ°æ® |
| | | function window_onload() { |
| | | var ReportViewer = document.getElementById("ReportViewer"); |
| | | // ReportViewer.Stop(); |
| | | var Report = ReportViewer.Report; |
| | | //å¼å¯æ¥è¡¨çæè¿åº¦æ¡æ¾ç¤º |
| | | //ReportViewer.Report.ShowProgressUI = true; |
| | | Report.OnPrintBegin = OnPrintBegin; |
| | | Report.OnPrintEnd = OnPrintEnd; |
| | | |
| | | ReportViewer.Start(); |
| | | } |
| | | //function OnPrintEnd() { |
| | | // if (PrintCount == 0) { |
| | | // var LCStatus = sessionStorage.getItem("LCStatus"); |
| | | // if (LCStatus == "Print")//æå°ç¶æ |
| | | // { |
| | | // SaveLabelPrint(sessionStorage.getItem("LabelJson")); |
| | | // PrintCount = 1; |
| | | // } |
| | | // } |
| | | |
| | | //} |
| | | //function OnPrintBegin() { |
| | | |
| | | //} |
| | | </script> |
| | | </head> |
| | | <body> |
| | | <script type="text/javascript"> |
| | | var PrintCount = 0; |
| | | var params = getUrlVars(); |
| | | var value = params[params[0]]; |
| | | var Type = params[params[1]]; |
| | | var OpenTmp = params[params[2]]; |
| | | switch (Type) { |
| | | //case "HBarCodePrint"://ç©ææ¡ç æå° |
| | | // //CreateDisplayViewerEx("100%", "100%", "../../views/grf/" + OpenTmp + ".grf", "../../views/SRM/xmlSRM_Web_BarCodeBillList.aspx?linterid=" + value, true, ""); |
| | | // CreateDisplayViewerEx("100%", "100%", "../../views/grf/" + OpenTmp + ".grf", "xmlSRM_Web_BarCodeBillList.aspx?linterid=" + value, true, ""); |
| | | // break; |
| | | case "HProcessReport"://å·¥åºæ±æ¥åæå° |
| | | CreateDisplayViewerEx("100%", "100%", "../../views/grf/" + OpenTmp + ".grf", "xmlLBM_ProcessReport.aspx?linterid=" + value, true, ""); |
| | | break; |
| | | //case "HPOOrderBill"://éè´è®¢ååæå° |
| | | // CreateDisplayViewerEx("100%", "100%", "../../views/grf/" + OpenTmp + ".grf", "xmlSRM_POInStockBill.aspx?linterid=" + value, true, ""); |
| | | // break; |
| | | } |
| | | </script> |
| | | </body> |
| | | </html> |
| | |
| | | |
| | | <button type="button" id="add-btn" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Saver">ä¿å</button> |
| | | <button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Exit">éåº</button> |
| | | <button type="button" id="Closeing" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Closeing">å
³é</button> |
| | | <button type="button" id="BackClose" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="BackClose">åå
³é</button> |
| | | <button type="button" id="Auditing" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Auditing">å®¡æ ¸</button> |
| | | <button type="button" id="BackAudit" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="BackAudit">åå®¡æ ¸</button> |
| | | <button type="button" id="Closeing" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Closeing">å
³é</button> |
| | | <button type="button" id="BackClose" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="BackClose">åå
³é</button> |
| | | <button type="button" id="Auditing" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Auditing">å®¡æ ¸</button> |
| | | <button type="button" id="BackAudit" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="BackAudit">åå®¡æ ¸</button> |
| | | <button type="button" id="Printing" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Printing">æå°</button> |
| | | |
| | | </div> |
| | | |
| | | </div> |
| | |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label">ä»»å¡åå·ï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HICMOBillNo" id="HICMOBillNo" autocomplete="off" disabled> |
| | | <input class="layui-input" name="HICMOBillNo" id="HICMOBillNo" autocomplete="off" disabled> |
| | | <!--<input id="HICMOInterID" name="HICMOInterID" type="hidden" />--> |
| | | </div> |
| | | </div> |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label">车é´ä»£ç ï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input type="text" name="HDeptNumber" id="HDeptNumber" lay-verify="HDeptID" readonly="readonly" autocomplete="off" class="layui-input"> |
| | | <input type="text" name="HDeptNumber" id="HDeptNumber" lay-verify="HDeptID" readonly="readonly" autocomplete="off" class="layui-input"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | |
| | | <label class="layui-form-label">车é´ï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input type="text" name="HDeptName" id="HDeptName" lay-verify="HDeptName" autocomplete="off" class="layui-input"> |
| | | |
| | | <button type="button" id="HDeptID-BT" lay-submit="" class="layui-btn" lay-filter="HDeptID-BT"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | | </button> |
| | | <input id="HDeptID" name="HDeptID" type="hidden" /> |
| | | |
| | | |
| | | <button type="button" id="HDeptID-BT" lay-submit="" class="layui-btn" lay-filter="HDeptID-BT"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | | </button> |
| | | <input id="HDeptID" name="HDeptID" type="hidden" /> |
| | | |
| | | </div> |
| | | </div> |
| | | |
| | | <!--<div class="layui-col-xs3"> |
| | | <label class="layui-form-label"> è§æ ¼åå·ï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HDHDate" lay-verify="HDHDate" id="HDHDate"> |
| | | </div> |
| | | </div>--> |
| | | <div class="layui-col-xs3"> |
| | | <!--<div class="layui-col-xs3"> |
| | | <label class="layui-form-label"> è§æ ¼åå·ï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HDHDate" lay-verify="HDHDate" id="HDHDate"> |
| | | </div> |
| | | </div>--> |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label"> 计åå¼å·¥æ¥æï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HPlanBeginDate" lay-verify="HPlanBeginDate" id="HPlanBeginDate" autocomplete="off"> |
| | | |
| | | <input class="layui-input" name="HPlanBeginDate" lay-verify="HPlanBeginDate" id="HPlanBeginDate" autocomplete="off"> |
| | | |
| | | </div> |
| | | </div> |
| | | |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label"> 计åå®å·¥æ¥æï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HPlanEndDate" lay-verify="HPlanEndDate" id="HPlanEndDate" autocomplete="off"> |
| | | |
| | | <input class="layui-input" name="HPlanEndDate" lay-verify="HPlanEndDate" id="HPlanEndDate" autocomplete="off"> |
| | | |
| | | </div> |
| | | </div> |
| | | |
| | | <div class="layui-col-xs3"> |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label"> æ±æ¥æ°éï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HPlanQty" lay-verify="HPlanQty" id="HPlanQty" autocomplete="off"> |
| | | <input class="layui-input" name="HPlanQty" lay-verify="HPlanQty" id="HPlanQty" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | |
| | |
| | | |
| | | <div class="layui-form-item"> |
| | | <div class="layui-row"> |
| | | |
| | | |
| | | <div class="layui-col-xs8"> |
| | | <label class="layui-form-label"> å¤ æ³¨ï¼</label> |
| | | <div class="layui-input-block"> |
| | |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="layui-tab-item"> |
| | | <div class="layui-form-item"> |
| | | <div class="layui-row"> |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label">å¶ å 人ï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HMaker" id="HMaker" readonly="readonly" autocomplete="off"> |
| | | <input type="hidden" name="HEmpID" id="HEmpID" autocomplete="off" class="layui-input"> |
| | | <div class="layui-tab-item"> |
| | | <div class="layui-form-item"> |
| | | <div class="layui-row"> |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label">å¶ å 人ï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HMaker" id="HMaker" readonly="readonly" autocomplete="off"> |
| | | <input type="hidden" name="HEmpID" id="HEmpID" autocomplete="off" class="layui-input"> |
| | | |
| | | </div> |
| | | </div> |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label">审 æ ¸ 人ï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HChecker" id="HChecker" readonly="readonly" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label">ä¿®æ¹äººï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HUpDater" id="HUpDater" readonly="readonly" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label">å
³é人ï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HCloseMan" id="HCloseMan" readonly="readonly" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="layui-form-item"> |
| | | <div class="layui-row"> |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label">å¶åæ¥æï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HMakeDate" id="HMakeDate" readonly="readonly" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label">å®¡æ ¸æ¥æï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HCheckDate" id="HCheckDate" readonly="readonly" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label">ä¿®æ¹æ¥æï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HUpDateDate" id="HUpDateDate" readonly="readonly" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label">å
³éæ¥æï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HCloseDate" id="HCloseDate" readonly="readonly" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label">审 æ ¸ 人ï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HChecker" id="HChecker" readonly="readonly" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label">ä¿®æ¹äººï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HUpDater" id="HUpDater" readonly="readonly" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label">å
³é人ï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HCloseMan" id="HCloseMan" readonly="readonly" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | |
| | | </div> |
| | | <div class="layui-form-item"> |
| | | <div class="layui-row"> |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label">å¶åæ¥æï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HMakeDate" id="HMakeDate" readonly="readonly" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label">å®¡æ ¸æ¥æï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HCheckDate" id="HCheckDate" readonly="readonly" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label">ä¿®æ¹æ¥æï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HUpDateDate" id="HUpDateDate" readonly="readonly" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-col-xs3"> |
| | | <label class="layui-form-label">å
³éæ¥æï¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" name="HCloseDate" id="HCloseDate" readonly="readonly" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <blockquote class="layui-elem-quote">å·¥åºæ´¾å·¥å</blockquote> |
| | | <table class="layui-hide" id="mainTable" lay-filter="mainTable"></table> |
| | | <script type="text/html" id="toolbarDemo"> |
| | | <div class="layui-btn-container"> |
| | | <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-add"><i class="layui-icon layui-icon-addition"></i>æå</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-del"><i class="layui-icon layui-icon-subtraction"></i>å è¡</button>--> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-del"><i class="layui-icon layui-icon-subtraction"></i>å è¡</button>--> |
| | | </div> |
| | | </script> |
| | | |
| | | |
| | | |
| | | </form> |
| | | </div> |
| | | </div> |
| | |
| | | <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/webConfig.js"></script> |
| | | <script> |
| | | |
| | | function getUrlVars() { |
| | | var vars = [], hash; |
| | | var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&'); |
| | |
| | | |
| | | }); |
| | | |
| | | //æå°Printing |
| | | form.on("submit(Printing)", function (data) { layer.alert("ææ¯æå°æé®ï¼");}); |
| | | //æå°Printing |
| | | form.on("submit(Printing)", function (data) { |
| | | layer.alert("ææ¯æå°æé®ï¼åæ®ä¸»IDæ¯ï¼" + HInterID); |
| | | window.open("../../views/ç产工åºç®¡ç/å·¥åºæ±æ¥å/HBarPlanPrint.html?linterid=" + HInterID + "&Type=HProcessReport"+"&OpenTmp=æ±æ¥å"); |
| | | |
| | | }); |
| | | |
| | | function f_alert(sMsg) { |
| | | layer.alert(sMsg, { icon: 5 }); |
New file |
| | |
| | | <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="xmlLBM_ProcessReport.aspx.cs" Inherits="WebTM.views.ç产工åºç®¡ç.å·¥åºæ±æ¥å.xmlLBM_ProcessReport" %> |
| | | |
| | | <!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 * from h_v_Sc_ProcessReportList where hmainid=" + Request.Params["linterid"]+ " 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_ProcessReport : System.Web.UI.Page |
| | | { |
| | | protected void Page_Load(object sender, EventArgs e) |
| | | { |
| | | |
| | | } |
| | | } |
| | | } |
New file |
| | |
| | | //------------------------------------------------------------------------------ |
| | | // <auto-generated> |
| | | // æ¤ä»£ç ç±å·¥å
·çæã |
| | | // |
| | | // å¯¹æ¤æä»¶çæ´æ¹å¯è½ä¼å¯¼è´ä¸æ£ç¡®çè¡ä¸ºï¼å¹¶ä¸å¦æ |
| | | // éæ°çæä»£ç ï¼è¿äºæ´æ¹å°ä¼ä¸¢å¤±ã |
| | | // </auto-generated> |
| | | //------------------------------------------------------------------------------ |
| | | |
| | | |
| | | namespace WebTM.views.ç产工åºç®¡ç.å·¥åºæ±æ¥å |
| | | { |
| | | public partial class xmlLBM_ProcessReport |
| | | { |
| | | |
| | | /// <summary> |
| | | /// form1 æ§ä»¶ã |
| | | /// </summary> |
| | | /// <remarks> |
| | | /// èªå¨çæçåæ®µã |
| | | /// è¥è¦è¿è¡ä¿®æ¹ï¼è¯·å°å段声æä»è®¾è®¡å¨æä»¶ç§»å°ä»£ç éèæä»¶ã |
| | | /// </remarks> |
| | | protected global::System.Web.UI.HtmlControls.HtmlForm form1; |
| | | } |
| | | } |