From 5256514b68b10ddea93055f737c1ec80420a6b1f Mon Sep 17 00:00:00 2001 From: yxj <yxj@hz-kingdee.com> Date: 星期四, 07 八月 2025 16:55:40 +0800 Subject: [PATCH] 新增海诚物料打印模版 --- WebTM/App_Data/MssqlReportData.cs | 1 WebTM/views/grf/物料条码_海诚.grf | 585 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 586 insertions(+), 0 deletions(-) diff --git a/WebTM/App_Data/MssqlReportData.cs b/WebTM/App_Data/MssqlReportData.cs index f6b2020..d0a4dec 100644 --- a/WebTM/App_Data/MssqlReportData.cs +++ b/WebTM/App_Data/MssqlReportData.cs @@ -34,6 +34,7 @@ //public const string SqlConnStr = "Data Source=192.168.1.8;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//娣诲悍绉戞妧 //public const string SqlConnStr = "Data Source=192.168.6.5;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//鑸滄垚 //public const string SqlConnStr = "Data Source=172.16.1.89;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//杩﹀崡 + //public const string SqlConnStr = "Data Source=172.16.1.30;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";//娴疯瘹 //public string sServer; //public string sDataBase; diff --git "a/WebTM/views/grf/\347\211\251\346\226\231\346\235\241\347\240\201_\346\265\267\350\257\232.grf" "b/WebTM/views/grf/\347\211\251\346\226\231\346\235\241\347\240\201_\346\265\267\350\257\232.grf" new file mode 100644 index 0000000..b75ebd3 --- /dev/null +++ "b/WebTM/views/grf/\347\211\251\346\226\231\346\235\241\347\240\201_\346\265\267\350\257\232.grf" @@ -0,0 +1,585 @@ +锘縊bject Report + Version='6.0.0.6' + Title='鐢熶骇浠诲姟鍗�' + PrintAsDesignPaper=F + Object Font + Name='瀹嬩綋' + Size=135000,0 + Weight=400 + Charset=134 + End + Object Printer + Size=256 + Width=8 + Height=5 + LeftMargin=0 + TopMargin=0 + RightMargin=0 + BottomMargin=0 + End + Object DetailGrid + CenterView=T + ShowColLine=F + ShowRowLine=F + Object Border + Styles=[] + End + Object Recordset + Items Field + Item + Name='鏉$爜缂栧彿' + End + Item + Name='渚涘簲鍟�' + End + Item + Name='鐗╂枡浠g爜' + End + Item + Name='鐗╂枡鍚嶇О' + End + Item + Name='瑙勬牸鍨嬪彿' + End + Item + Name='鏁伴噺' + Type=Float + Format='0' + End + Item + Name='鏃ユ湡' + Type=DateTime + Format='yyyy/MM/dd' + End + Item + Name='瀹㈡埛缂栧彿' + End + Item + Name='娆惧彿' + End + Item + Name='鍒嗙粍' + End + Item + Name='閲囪喘鍗曞彿' + End + End + End + Items Column + Item + Name='Column3' + Width=7.99042 + End + End + Object ColumnContent + Height=4.9 + RowsPerPage=1 + Items ColumnContentCell + Item + Column='Column3' + FreeCell=T + CanGrow=T + Items Control + Item + Type=FreeGrid + Name='FreeGrid1' + Left=0.264583 + Top=0.15875 + Locked=T + ColumnCount=2 + RowCount=16 + ShowColLine=F + ShowRowLine=F + Items FreeGridColumn + Item[1] + Width=3.7 + End + Item[2] + Width=3.7 + End + End + Items FreeGridRow + Item[1] + Height=0.38 + End + Item[2] + Height=0.2 + End + Item[3] + Height=0.38 + End + Item[4] + Height=0.2 + End + Item[5] + Height=0.38 + End + Item[6] + Height=0.2 + End + Item[7] + Height=0.38 + End + Item[8] + Height=0.2 + End + Item[9] + Height=0.38 + End + Item[10] + Height=0.2 + End + Item[11] + Height=0.38 + End + Item[12] + Height=0.2 + End + Item[13] + Height=0.38 + End + Item[14] + Height=0.2 + End + Item[15] + Height=0.38 + End + Item[16] + Height=0.2 + End + End + Items FreeGridCell + Item[1,1] + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + Text='渚涘簲鍟�:' + End + Item[2,1] + Object Font + Name='Arial' + Size=52500,0 + Weight=400 + End + Text='(Supplier)' + End + Item[3,1] + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + Text='渚涘簲鍟嗘枡鍙�:' + End + Item[4,1] + Object Font + Name='Arial' + Size=52500,0 + Weight=400 + End + Text='(Supplier Sku No.)' + End + Item[5,1] + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + Text='鐗╂枡鍚嶇О:' + End + Item[6,1] + Object Font + Name='Arial' + Size=52500,0 + Weight=400 + End + Text='(Material Code)' + End + Item[7,1] + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + Text='娆惧彿:' + End + Item[7,2] + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + Text='瀹㈡埛缂栧彿:' + End + Item[8,1] + Object Font + Name='Arial' + Size=52500,0 + Weight=400 + End + Text='(Style No.)' + End + Item[8,2] + Object Font + Name='Arial' + Size=52500,0 + Weight=400 + End + Text='(Consumer No.)' + End + Item[9,1] + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + Text='鍒嗙粍:' + End + Item[9,2] + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + Text='瑙勬牸:' + End + Item[10,1] + Object Font + Name='Arial' + Size=52500,0 + Weight=400 + End + Text='(Group)' + End + Item[10,2] + Object Font + Name='Arial' + Size=52500,0 + Weight=400 + End + Text='(SKU NO.)' + End + Item[11,1] + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + Text='鏁伴噺:' + End + Item[11,2] + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + Text='鏃ユ湡:' + End + Item[12,1] + Object Font + Name='Arial' + Size=52500,0 + Weight=400 + End + Text='(Quantity)' + End + Item[12,2] + Object Font + Name='Arial' + Size=52500,0 + Weight=400 + End + Text='(Date)' + End + Item[13,1] + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + Text='妫�楠屽憳:' + End + Item[13,2] + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + Text='閲囪喘鍗曞彿:' + End + Item[14,1] + Object Font + Name='Arial' + Size=52500,0 + Weight=400 + End + Text='(QC)' + End + Item[14,2] + Object Font + Name='Arial' + Size=52500,0 + Weight=400 + End + Text='(Purchase Order No.)' + End + Item[15,1] + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + Text='妫�楠岀粨鏋�:' + End + Item[16,1] + Object Font + Name='Arial' + Size=52500,0 + Weight=400 + End + Text='(Inspection status)' + End + End + End + Item + Type=Barcode + Name='Barcode1' + Left=6.00604 + Top=0.211667 + Width=1.5875 + Height=1.5 + BarcodeType=QRCode + CaptionPosition=None + Text='[#璁㈠崟鍙�#]' + End + Item + Type=FieldBox + Name='FieldBox9' + Left=1.5875 + Top=0.15875 + Width=4.20688 + Height=0.38 + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + ShrinkFontToFit=T + DataField='渚涘簲鍟�' + End + Item + Type=StaticBox + Name='StaticBox5' + Left=3.20146 + Top=4.20688 + Width=3.99521 + Height=0.396875 + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + Text='鈻″悎鏍� 鈻′笉鍚堟牸 鈻$壒閲�' + End + Item + Type=StaticBox + Name='StaticBox6' + Left=3.41313 + Top=4.60375 + Width=3.99521 + Height=0.211667 + Object Font + Name='Arial' + Size=52500,0 + Weight=400 + End + Text='(Pass) (Fail) (Spec.accepted)' + End + Item + Type=FieldBox + Name='FieldBox10' + Left=2.19604 + Top=0.714375 + Width=3.59833 + Height=0.38 + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + ShrinkFontToFit=T + DataField='鐗╂枡浠g爜' + End + Item + Type=FieldBox + Name='FieldBox11' + Left=1.79917 + Top=1.29646 + Width=3.99521 + Height=0.38 + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + ShrinkFontToFit=T + DataField='鐗╂枡鍚嶇О' + End + Item + Type=FieldBox + Name='FieldBox12' + Left=1.19063 + Top=1.905 + Width=2.61938 + Height=0.38 + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + ShrinkFontToFit=T + DataField='娆惧彿' + End + Item + Type=FieldBox + Name='FieldBox13' + Left=1.19063 + Top=2.48708 + Width=2.61938 + Height=0.38 + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + ShrinkFontToFit=T + DataField='鍒嗙粍' + End + Item + Type=FieldBox + Name='FieldBox14' + Left=5.60917 + Top=1.87854 + Width=1.98438 + Height=0.396875 + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + ShrinkFontToFit=T + DataField='瀹㈡埛缂栧彿' + End + Item + Type=FieldBox + Name='FieldBox15' + Left=5.00063 + Top=2.46063 + Width=2.59292 + Height=0.396875 + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + ShrinkFontToFit=T + DataField='瑙勬牸鍨嬪彿' + End + Item + Type=FieldBox + Name='FieldBox16' + Left=5.00063 + Top=3.04271 + Width=2.59292 + Height=0.423333 + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + ShrinkFontToFit=T + DataField='鏃ユ湡' + End + Item + Type=FieldBox + Name='FieldBox17' + Left=5.60917 + Top=3.62479 + Width=1.98438 + Height=0.396875 + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + ShrinkFontToFit=T + DataField='閲囪喘鍗曞彿' + End + Item + Type=MemoBox + Name='MemoBox1' + Left=1.19063 + Top=3.06917 + Width=2.61938 + Height=0.38 + Object Font + Name='瀹嬩綋' + Size=90000,0 + Weight=400 + Charset=134 + End + Text='[#鏁伴噺#] (瀵�/浠�)' + End + End + End + End + End + Object ColumnTitle + Height=0 + Items ColumnTitleCell + Item + GroupTitle=F + Column='Column3' + Text='Column1' + End + End + End + End + Items ReportHeader + Item + Name='ReportHeader1' + Height=0 + RepeatOnPage=T + End + End + Items ReportFooter + Item + Name='ReportFooter1' + Height=0 + End + End +End -- Gitblit v1.9.1