Merge branch 'master' of http://101.37.171.70:10101/r/MESWMS-LayUI
7个文件已删除
2 文件已重命名
11个文件已修改
1个文件已添加
| | |
| | | <Content Include="views\grf\å¢åæ¡ç .grf" /> |
| | | <Content Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\grf\ç产å.grf" /> |
| | | <Content Include="views\grf\ç产å.grf" /> |
| | | <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> |
| | |
| | | <Content Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_MouldProdMoveStockBill.aspx" /> |
| | | <Content Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_MouldProdOutStockBill.aspx" /> |
| | | <Content Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_MouldTypeBill.aspx" /> |
| | | <Content Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_QK_BZPackingBillList.aspx" /> |
| | | <Content Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_QK_HXPackingBillList.aspx" /> |
| | | <Content Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_QK_PackingBillList.aspx" /> |
| | | <Content Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_QK_WLPackingBillList.aspx" /> |
| | | <Content Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_QK_SPackingBillList.aspx" /> |
| | | <Content Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_Sc_ICMOBillList.aspx" /> |
| | | <Content Include="views\åºç¡èµæ\åºç¡èµæ\Gy_ConkReasonEdit.html" /> |
| | | <Content Include="views\åºç¡èµæ\åºç¡èµæ\Gy_ConkReasonList.html" /> |
| | |
| | | <Compile Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_MouldTypeBill.aspx.designer.cs"> |
| | | <DependentUpon>xmlLBM_MouldTypeBill.aspx</DependentUpon> |
| | | </Compile> |
| | | <Compile Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_QK_BZPackingBillList.aspx.cs"> |
| | | <DependentUpon>xmlLBM_QK_BZPackingBillList.aspx</DependentUpon> |
| | | <SubType>ASPXCodeBehind</SubType> |
| | | </Compile> |
| | | <Compile Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_QK_BZPackingBillList.aspx.designer.cs"> |
| | | <DependentUpon>xmlLBM_QK_BZPackingBillList.aspx</DependentUpon> |
| | | </Compile> |
| | | <Compile Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_QK_HXPackingBillList.aspx.cs"> |
| | | <DependentUpon>xmlLBM_QK_HXPackingBillList.aspx</DependentUpon> |
| | | <SubType>ASPXCodeBehind</SubType> |
| | | </Compile> |
| | | <Compile Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_QK_HXPackingBillList.aspx.designer.cs"> |
| | | <DependentUpon>xmlLBM_QK_HXPackingBillList.aspx</DependentUpon> |
| | | </Compile> |
| | | <Compile Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_QK_PackingBillList.aspx.cs"> |
| | | <DependentUpon>xmlLBM_QK_PackingBillList.aspx</DependentUpon> |
| | | <SubType>ASPXCodeBehind</SubType> |
| | |
| | | <Compile Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_QK_PackingBillList.aspx.designer.cs"> |
| | | <DependentUpon>xmlLBM_QK_PackingBillList.aspx</DependentUpon> |
| | | </Compile> |
| | | <Compile Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_QK_WLPackingBillList.aspx.cs"> |
| | | <DependentUpon>xmlLBM_QK_WLPackingBillList.aspx</DependentUpon> |
| | | <Compile Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_QK_SPackingBillList.aspx.cs"> |
| | | <DependentUpon>xmlLBM_QK_SPackingBillList.aspx</DependentUpon> |
| | | <SubType>ASPXCodeBehind</SubType> |
| | | </Compile> |
| | | <Compile Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_QK_WLPackingBillList.aspx.designer.cs"> |
| | | <DependentUpon>xmlLBM_QK_WLPackingBillList.aspx</DependentUpon> |
| | | <Compile Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_QK_SPackingBillList.aspx.designer.cs"> |
| | | <DependentUpon>xmlLBM_QK_SPackingBillList.aspx</DependentUpon> |
| | | </Compile> |
| | | <Compile Include="views\åºç¡èµæ\å
¬ç¨åºç¡èµæ\xmlLBM_Sc_ICMOBillList.aspx.cs"> |
| | | <DependentUpon>xmlLBM_Sc_ICMOBillList.aspx</DependentUpon> |
| | |
| | | Object Report |
| | | Version='6.0.0.6' |
| | | Version='6.8.2.5' |
| | | Title='ç产任å¡å' |
| | | PrintAsDesignPaper=F |
| | | Object Font |
| | |
| | | Name='å
è£
æ¹å¼' |
| | | End |
| | | Item |
| | | Name='å¢åç¼' |
| | | Name='å¢åA/Uç¼' |
| | | End |
| | | Item |
| | | Name='æ°é' |
| | |
| | | Item |
| | | Name='æ¶è´§æ¹å°å' |
| | | End |
| | | End |
| | | End |
| | | Items Column |
| | | Item |
| | | Name='Column3' |
| | | Width=9.49854 |
| | | End |
| | | End |
| | | Object ColumnContent |
| | | Height=10.0013 |
| | | RowsPerPage=1 |
| | | Items ColumnContentCell |
| | | Item |
| | | Column='Column3' |
| | | FreeCell=T |
| | | CanGrow=T |
| | | Items Control |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox1' |
| | | Left=3 |
| | | Top=2.5 |
| | | Width=2.40771 |
| | | Height=0.582083 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='è系人' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox2' |
| | | Left=3 |
| | | Top=3.5 |
| | | Width=6.00604 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='å
è£
æ¹å¼' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox3' |
| | | Left=3 |
| | | Top=4.5 |
| | | Width=3.20146 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='å¢åç¼' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox4' |
| | | Left=3 |
| | | Top=5.5 |
| | | Width=2.61938 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='æ°é' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox5' |
| | | Left=3 |
| | | Top=6.5 |
| | | Width=3.01625 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='ç®±å·' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox6' |
| | | Left=3 |
| | | Top=7.5 |
| | | Width=6.00604 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='å¤å
夿³¨' |
| | | End |
| | | Item |
| | | Type=Barcode |
| | | Name='Barcode1' |
| | | Left=6.19125 |
| | | Top=5.00063 |
| | | Width=2.25 |
| | | Height=1.79917 |
| | | BarcodeType=QRCode |
| | | CaptionPosition=None |
| | | Text='[#订åå·#]' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox7' |
| | | Left=5.4 |
| | | Top=2.5 |
| | | Width=3.59833 |
| | | Height=0.608542 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='æ¶è´§æ¹å°å' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox8' |
| | | Left=3.01625 |
| | | Top=8.14917 |
| | | Width=6.00604 |
| | | Height=1.03188 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=105000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | WordWrap=T |
| | | TextAlign=TopLeft |
| | | DataField='æ¶è´§æ¹å°å' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox9' |
| | | Left=3 |
| | | Top=1.5 |
| | | Width=6.00604 |
| | | Height=0.608542 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='éå®è®¢åå·' |
| | | End |
| | | Item |
| | | Type=MemoBox |
| | | Name='MemoBox1' |
| | | Left=0.79375 |
| | | Top=1.5 |
| | | Width=2.19604 |
| | | Height=0.582083 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | Text='åæ®ç¼å·ï¼' |
| | | End |
| | | Item |
| | | Type=MemoBox |
| | | Name='MemoBox2' |
| | | Left=0.926042 |
| | | Top=8.06979 |
| | | Width=2.19604 |
| | | Height=0.582083 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=105000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | Text='æ¶è´§å°åï¼' |
| | | End |
| | | End |
| | | End |
| | | End |
| | | End |
| | | Items Column |
| | | Item |
| | | Name='Column3' |
| | | Width=9.49854 |
| | | End |
| | | Object ColumnTitle |
| | | Height=0 |
| | | Items ColumnTitleCell |
| | | End |
| | | Object ColumnContent |
| | | Height=10.0013 |
| | | RowsPerPage=1 |
| | | Items ColumnContentCell |
| | | Item |
| | | Column='Column3' |
| | | FreeCell=T |
| | | CanGrow=T |
| | | Items Control |
| | | Item |
| | | GroupTitle=F |
| | | Column='Column3' |
| | | Text='Column1' |
| | | Type=FieldBox |
| | | Name='FieldBox1' |
| | | Left=3 |
| | | Top=2.5 |
| | | Width=2.40771 |
| | | Height=0.582083 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='è系人' |
| | | End |
| | | End |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox2' |
| | | Left=3 |
| | | Top=3.5 |
| | | Width=6.00604 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='å
è£
æ¹å¼' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox3' |
| | | Left=3 |
| | | Top=4.5 |
| | | Width=3.20146 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='å¢åA/Uç¼' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox4' |
| | | Left=3 |
| | | Top=5.5 |
| | | Width=2.61938 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='æ°é' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox5' |
| | | Left=3 |
| | | Top=6.5 |
| | | Width=3.01625 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='ç®±å·' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox6' |
| | | Left=3 |
| | | Top=7.5 |
| | | Width=6.00604 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='å¤å
夿³¨' |
| | | End |
| | | Item |
| | | Type=Barcode |
| | | Name='Barcode1' |
| | | Left=6.19125 |
| | | Top=5.00063 |
| | | Width=2.25 |
| | | Height=1.79917 |
| | | BarcodeType=QRCode |
| | | CaptionPosition=None |
| | | Text='[#订åå·#]' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox7' |
| | | Left=5.4 |
| | | Top=2.5 |
| | | Width=3.59833 |
| | | Height=0.608542 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='æ¶è´§æ¹å°å' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox8' |
| | | Left=3.01625 |
| | | Top=8.14917 |
| | | Width=6.00604 |
| | | Height=1.03188 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=105000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | WordWrap=T |
| | | TextAlign=TopLeft |
| | | DataField='æ¶è´§æ¹å°å' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox9' |
| | | Left=3 |
| | | Top=1.5 |
| | | Width=6.00604 |
| | | Height=0.608542 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='éå®è®¢åå·' |
| | | End |
| | | Item |
| | | Type=MemoBox |
| | | Name='MemoBox1' |
| | | Left=0.79375 |
| | | Top=1.5 |
| | | Width=2.19604 |
| | | Height=0.582083 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | Text='åæ®ç¼å·ï¼' |
| | | End |
| | | Item |
| | | Type=MemoBox |
| | | Name='MemoBox2' |
| | | Left=0.926042 |
| | | Top=8.06979 |
| | | Width=2.19604 |
| | | Height=0.582083 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=105000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | Text='æ¶è´§å°åï¼' |
| | | End |
| | | End |
| | | End |
| | | Items ReportHeader |
| | | End |
| | | End |
| | | Object ColumnTitle |
| | | Height=0 |
| | | Items ColumnTitleCell |
| | | Item |
| | | Name='ReportHeader1' |
| | | Height=0 |
| | | RepeatOnPage=T |
| | | GroupTitle=F |
| | | Column='Column3' |
| | | Text='Column1' |
| | | End |
| | | End |
| | | Items ReportFooter |
| | | Item |
| | | Name='ReportFooter1' |
| | | Height=0 |
| | | End |
| | | End |
| | | End |
| | | Items ReportHeader |
| | | Item |
| | | Name='ReportHeader1' |
| | | Height=0 |
| | | RepeatOnPage=T |
| | | End |
| | | End |
| | | Items ReportFooter |
| | | Item |
| | | Name='ReportFooter1' |
| | | Height=0 |
| | | End |
| | | End |
| | | End |
| | |
| | | Oriention=Landscape |
| | | LeftMargin=1.5 |
| | | TopMargin=0.5 |
| | | RightMargin=1.5 |
| | | RightMargin=1.03188 |
| | | BottomMargin=0.5 |
| | | End |
| | | Object DetailGrid |
| | | Object Recordset |
| | | Items Field |
| | | Item |
| | | Name='æ¥æ' |
| | | Name='éå®è®¢åæ¥æ' |
| | | End |
| | | Item |
| | | Name='åæ®ç¼å·' |
| | |
| | | End |
| | | Item |
| | | Name='é宿°é' |
| | | Type=Float |
| | | Format='0.#####' |
| | | End |
| | | Item |
| | | Name='è´è´§åä½' |
| | | End |
| | | Item |
| | | Name='æ¶è´§æ¹è系人' |
| | | Name='éå®è®¢åè系人' |
| | | End |
| | | Item |
| | | Name='éå®è®¢åç¼å·' |
| | | End |
| | | End |
| | | End |
| | |
| | | End |
| | | Item |
| | | Name='ç©æä»£ç ' |
| | | Width=3.99521 |
| | | Width=3.59833 |
| | | End |
| | | Item |
| | | Name='ç©æ' |
| | | Width=3.41313 |
| | | Width=3.01625 |
| | | End |
| | | Item |
| | | Name='è§æ ¼åå·' |
| | | Width=3.41313 |
| | | Width=3.175 |
| | | End |
| | | Item |
| | | Name='Column2' |
| | | Width=2.61938 |
| | | Width=2.40771 |
| | | End |
| | | Item |
| | | Name='Column6' |
| | | Width=2.93688 |
| | | Width=1.61396 |
| | | End |
| | | Item |
| | | Name='Column7' |
| | | Width=2.59292 |
| | | Width=2.01083 |
| | | End |
| | | Item |
| | | Name='Column8' |
| | | Width=2.19604 |
| | | Width=2.38125 |
| | | End |
| | | Item |
| | | Name='Column9' |
| | | Width=2.77813 |
| | | Width=2.40771 |
| | | End |
| | | Item |
| | | Name='Column10' |
| | | Width=2.59292 |
| | | End |
| | | End |
| | | Object ColumnContent |
| | | Height=2.59292 |
| | | Height=2.19604 |
| | | Items ColumnContentCell |
| | | Item |
| | | Column='åºå·' |
| | |
| | | End |
| | | WordWrap=T |
| | | ShrinkFontToFit=T |
| | | DataField='æ¥æ' |
| | | DataField='éå®è®¢åæ¥æ' |
| | | End |
| | | Item |
| | | Column='ç©æä»£ç ' |
| | |
| | | End |
| | | WordWrap=T |
| | | ShrinkFontToFit=T |
| | | DataField='éå®ç©æåç§°' |
| | | DataField='éå®è®¢åç¼å·' |
| | | End |
| | | Item |
| | | Column='è§æ ¼åå·' |
| | |
| | | End |
| | | WordWrap=T |
| | | ShrinkFontToFit=T |
| | | DataField='å
è£
æ¹å¼' |
| | | DataField='éå®ç©æåç§°' |
| | | End |
| | | Item |
| | | Column='Column2' |
| | |
| | | Items Control |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox1' |
| | | Name='FieldBox3' |
| | | Dock=Fill |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | TextAlign=MiddleCenter |
| | | DataField='é宿°é' |
| | | WordWrap=T |
| | | DataField='å
è£
æ¹å¼' |
| | | End |
| | | End |
| | | End |
| | |
| | | Items Control |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox2' |
| | | Name='FieldBox1' |
| | | Dock=Fill |
| | | DataField='æ¶è´§æ¹è系人' |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | DataField='é宿°é' |
| | | End |
| | | End |
| | | End |
| | |
| | | Text='[#åæ®ç¼å·#]' |
| | | End |
| | | Item |
| | | Type=Barcode |
| | | Name='Barcode4' |
| | | Left=0.185208 |
| | | Top=0.343958 |
| | | Width=2.19604 |
| | | Height=1.98438 |
| | | BarcodeType=QRCode |
| | | CaptionPosition=None |
| | | Text='[#åæ®ç¼å·#]' |
| | | Type=FieldBox |
| | | Name='FieldBox2' |
| | | Dock=Fill |
| | | WordWrap=T |
| | | DataField='éå®è®¢åè系人' |
| | | End |
| | | End |
| | | End |
| | |
| | | Charset=134 |
| | | End |
| | | FreeCell=T |
| | | Items Control |
| | | Item |
| | | Type=Barcode |
| | | Name='Barcode5' |
| | | Left=0.185208 |
| | | Top=0.238125 |
| | | Width=1.95792 |
| | | Height=1.77271 |
| | | BarcodeType=QRCode |
| | | CaptionPosition=None |
| | | Text='[#åæ®ç¼å·#]' |
| | | End |
| | | End |
| | | End |
| | | Item |
| | | Column='Column9' |
| | | TextAlign=MiddleCenter |
| | | End |
| | | Item |
| | | Column='Column10' |
| | | TextAlign=MiddleCenter |
| | | End |
| | | End |
| | |
| | | Charset=134 |
| | | End |
| | | TextAlign=MiddleCenter |
| | | Text='æ¥æ' |
| | | Text='éå®è®¢åæ¥æ' |
| | | End |
| | | Item |
| | | GroupTitle=F |
| | |
| | | End |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | Text='éå®ç©æåç§°' |
| | | Text='éå®è®¢åç¼å·' |
| | | End |
| | | Item |
| | | GroupTitle=F |
| | |
| | | End |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | Text='å
è£
æ¹å¼' |
| | | Text='éå®ç©æåç§°' |
| | | End |
| | | Item |
| | | GroupTitle=F |
| | |
| | | End |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | Text='é宿°é' |
| | | Text='å
è£
æ¹å¼' |
| | | End |
| | | Item |
| | | GroupTitle=F |
| | |
| | | End |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | Text='æ¶è´§æ¹è系人' |
| | | Text='é宿°é' |
| | | End |
| | | Item |
| | | GroupTitle=F |
| | |
| | | End |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | Text='ï¼äºç»´ç ï¼' |
| | | Text='è系人' |
| | | End |
| | | Item |
| | | GroupTitle=F |
| | |
| | | End |
| | | WordWrap=T |
| | | TextAlign=MiddleCenter |
| | | Text='å·²ç产' |
| | | Text='ï¼äºç»´ç ï¼' |
| | | End |
| | | Item |
| | | GroupTitle=F |
| | |
| | | Charset=134 |
| | | End |
| | | TextAlign=MiddleCenter |
| | | Text='å·²ç产' |
| | | End |
| | | Item |
| | | GroupTitle=F |
| | | Column='Column10' |
| | | Object Font |
| | | Name='å®ä½' |
| | | Weight=400 |
| | | Charset=134 |
| | | End |
| | | TextAlign=MiddleCenter |
| | | Text='夿³¨' |
| | | End |
| | | End |
| | |
| | | Object Report |
| | | Version='6.0.0.6' |
| | | Version='6.8.2.5' |
| | | Title='ç产任å¡å' |
| | | PrintAsDesignPaper=F |
| | | Object Font |
| | |
| | | Name='è±å' |
| | | End |
| | | Item |
| | | Name='å¢åç¼' |
| | | Name='å¢åA/Uç¼' |
| | | End |
| | | Item |
| | | Name='æ°é' |
| | |
| | | Item |
| | | Name='æ¶è´§æ¹å°å' |
| | | End |
| | | End |
| | | End |
| | | Items Column |
| | | Item |
| | | Name='Column3' |
| | | Width=9.49854 |
| | | End |
| | | End |
| | | Object ColumnContent |
| | | Height=10.0013 |
| | | RowsPerPage=1 |
| | | Items ColumnContentCell |
| | | Item |
| | | Column='Column3' |
| | | FreeCell=T |
| | | CanGrow=T |
| | | Items Control |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox1' |
| | | Left=3 |
| | | Top=2.5 |
| | | Width=2.40771 |
| | | Height=0.582083 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='è系人' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox2' |
| | | Left=3 |
| | | Top=3.5 |
| | | Width=5.82083 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='è±å' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox3' |
| | | Left=3 |
| | | Top=4.5 |
| | | Width=3.20146 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='å¢åç¼' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox4' |
| | | Left=3 |
| | | Top=5.5 |
| | | Width=2.40771 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='æ°é' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox5' |
| | | Left=3 |
| | | Top=6.5 |
| | | Width=3.01625 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='ç®±å·' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox6' |
| | | Left=3 |
| | | Top=7.5 |
| | | Width=6.00604 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='å¤å
夿³¨' |
| | | End |
| | | Item |
| | | Type=Barcode |
| | | Name='Barcode1' |
| | | Left=6.19125 |
| | | Top=5.00063 |
| | | Width=2.25 |
| | | Height=1.79917 |
| | | BarcodeType=QRCode |
| | | CaptionPosition=None |
| | | Text='[#订åå·#]' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox7' |
| | | Left=5.4 |
| | | Top=2.5 |
| | | Width=3.59833 |
| | | Height=0.608542 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='æ¶è´§æ¹å°å' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox8' |
| | | Left=3.01625 |
| | | Top=8.12271 |
| | | Width=6.00604 |
| | | Height=1.03188 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=105000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | WordWrap=T |
| | | TextAlign=TopLeft |
| | | DataField='æ¶è´§æ¹å°å' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox9' |
| | | Left=3 |
| | | Top=1.5 |
| | | Width=5.82083 |
| | | Height=0.608542 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='éå®è®¢åå·' |
| | | End |
| | | Item |
| | | Type=MemoBox |
| | | Name='MemoBox1' |
| | | Left=0.79375 |
| | | Top=1.5 |
| | | Width=2.19604 |
| | | Height=0.582083 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | Text='åæ®ç¼å·ï¼' |
| | | End |
| | | Item |
| | | Type=MemoBox |
| | | Name='MemoBox2' |
| | | Left=0.9525 |
| | | Top=8.04333 |
| | | Width=2.19604 |
| | | Height=0.582083 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=105000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | Text='æ¶è´§å°åï¼' |
| | | End |
| | | Name='éå®ç©æåç§°' |
| | | End |
| | | End |
| | | End |
| | | End |
| | | End |
| | | Items Column |
| | | Item |
| | | Name='Column3' |
| | | Width=9.39271 |
| | | End |
| | | Object ColumnTitle |
| | | Height=0 |
| | | Items ColumnTitleCell |
| | | End |
| | | Object ColumnContent |
| | | Height=10.0013 |
| | | RowsPerPage=1 |
| | | Items ColumnContentCell |
| | | Item |
| | | Column='Column3' |
| | | FreeCell=T |
| | | CanGrow=T |
| | | Items Control |
| | | Item |
| | | GroupTitle=F |
| | | Column='Column3' |
| | | Text='Column1' |
| | | Type=FieldBox |
| | | Name='FieldBox1' |
| | | Left=3 |
| | | Top=2.5 |
| | | Width=2.40771 |
| | | Height=0.582083 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='è系人' |
| | | End |
| | | End |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox2' |
| | | Left=3 |
| | | Top=4 |
| | | Width=5.82083 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='è±å' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox3' |
| | | Left=3 |
| | | Top=4.5 |
| | | Width=3.20146 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='å¢åA/Uç¼' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox4' |
| | | Left=3 |
| | | Top=5.5 |
| | | Width=2.40771 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='æ°é' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox5' |
| | | Left=3 |
| | | Top=6.5 |
| | | Width=3.01625 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='ç®±å·' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox6' |
| | | Left=3 |
| | | Top=7.5 |
| | | Width=6.00604 |
| | | Height=0.502708 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='å¤å
夿³¨' |
| | | End |
| | | Item |
| | | Type=Barcode |
| | | Name='Barcode1' |
| | | Left=6.19125 |
| | | Top=5.00063 |
| | | Width=2.25 |
| | | Height=1.79917 |
| | | BarcodeType=QRCode |
| | | CaptionPosition=None |
| | | Text='[#订åå·#]' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox7' |
| | | Left=5.4 |
| | | Top=2.5 |
| | | Width=3.59833 |
| | | Height=0.608542 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='æ¶è´§æ¹å°å' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox8' |
| | | Left=3.01625 |
| | | Top=8.12271 |
| | | Width=6.00604 |
| | | Height=1.03188 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=105000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | WordWrap=T |
| | | TextAlign=TopLeft |
| | | DataField='æ¶è´§æ¹å°å' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox9' |
| | | Left=3 |
| | | Top=1.5 |
| | | Width=5.82083 |
| | | Height=0.608542 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='éå®è®¢åå·' |
| | | End |
| | | Item |
| | | Type=MemoBox |
| | | Name='MemoBox1' |
| | | Left=0.79375 |
| | | Top=1.5 |
| | | Width=2.19604 |
| | | Height=0.582083 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | Text='åæ®ç¼å·ï¼' |
| | | End |
| | | Item |
| | | Type=MemoBox |
| | | Name='MemoBox2' |
| | | Left=0.9525 |
| | | Top=8.04333 |
| | | Width=2.19604 |
| | | Height=0.582083 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=105000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | Text='æ¶è´§å°åï¼' |
| | | End |
| | | Item |
| | | Type=FieldBox |
| | | Name='FieldBox10' |
| | | Left=3 |
| | | Top=3.41 |
| | | Width=5.60917 |
| | | Height=0.582083 |
| | | Object Font |
| | | Name='å®ä½' |
| | | Size=120000,0 |
| | | Bold=T |
| | | Charset=134 |
| | | End |
| | | DataField='éå®ç©æåç§°' |
| | | End |
| | | End |
| | | End |
| | | Items ReportHeader |
| | | End |
| | | End |
| | | Object ColumnTitle |
| | | Height=0 |
| | | Items ColumnTitleCell |
| | | Item |
| | | Name='ReportHeader1' |
| | | Height=0 |
| | | RepeatOnPage=T |
| | | GroupTitle=F |
| | | Column='Column3' |
| | | Text='Column1' |
| | | End |
| | | End |
| | | Items ReportFooter |
| | | Item |
| | | Name='ReportFooter1' |
| | | Height=0 |
| | | End |
| | | End |
| | | End |
| | | Items ReportHeader |
| | | Item |
| | | Name='ReportHeader1' |
| | | Height=0 |
| | | RepeatOnPage=T |
| | | End |
| | | End |
| | | Items ReportFooter |
| | | Item |
| | | Name='ReportFooter1' |
| | | Height=0 |
| | | End |
| | | End |
| | | End |
| | |
| | | var Type = params[params[1]]; |
| | | var OpenTmp = params[params[2]]; |
| | | |
| | | if (OpenTmp =="å¢åæ¡ç ") { |
| | | Type += "1"; |
| | | } |
| | | |
| | | switch (Type) { |
| | | |
| | | //case "HBarCodePrint"://ç©ææ¡ç æå° |
| | |
| | | CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_HSeOrderBillList.aspx?linterid=" + value, true, ""); |
| | | break; |
| | | case "HQKPackBill"://å¢åè£
ç®±æå° |
| | | if (OpenTmp =="å¢åæ¡ç ") { |
| | | CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_QK_PackingBillList.aspx?linterid=" + value, true, ""); |
| | | break; |
| | | } |
| | | if (OpenTmp == "è±åæ¡ç ") { |
| | | CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_QK_HXPackingBillList.aspx?linterid=" + value, true, ""); |
| | | break; |
| | | } |
| | | if (OpenTmp == "å
è£
æ¹å¼æ¡ç ") { |
| | | CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_QK_BZPackingBillList.aspx?linterid=" + value, true, ""); |
| | | break; |
| | | } |
| | | if (OpenTmp == "ç©æåç§°æ¡ç ") { |
| | | CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_QK_WLPackingBillList.aspx?linterid=" + value, true, ""); |
| | | break; |
| | | } |
| | | |
| | | CreateDisplayViewerEx("100%", "100%", "../../grf/" + OpenTmp + ".grf", "xmlLBM_QK_PackingBillList.aspx?typename='" + OpenTmp + "'&linterid=" + value, true, ""); |
| | | break; |
| | | } |
| | | </script> |
| | | </body> |
| | |
| | | |
| | | <html xmlns="http://www.w3.org/1999/xhtml"> |
| | | <head runat="server"> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> |
| | | <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ä¾åæ°æ®åºä¸è·åæ¥è¡¨æ°æ® |
| | | <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"); |
| | | var ids = Request.Params["linterid"]; |
| | | //OledbXMLReportData.GenOneRecordset(this, "select * from Customers order by CustomerID"); |
| | | //SqlXMLReportData.GenOneRecordset(this, "select * from h_v_Kf_POStockInBillList_K3 where hmainid=1781"); |
| | | var ids = Request.Params["linterid"]; |
| | | var type=Request.Params["typename"].ToString(); |
| | | var idsArray = ids.Split(','); |
| | | var PrintIds = ""; |
| | | for (int i = 0; i < idsArray.Length; i++) |
| | |
| | | PrintIds += "'" + idsArray[i] + "',"; |
| | | } |
| | | PrintIds = PrintIds.Substring(0, PrintIds.Length - 1); |
| | | SqlXMLReportData.GenOneRecordset(this, "select HSourceBillNo 订åå·,a.HMaterID,m.HName ç©æ,m.HModel åå·,a.HQty æ°é,a.HBatchNo æ¹å·,a.HBarCode ç®±å·,a.HRemark åºæ¯å· from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID in ("+ PrintIds+")"); |
| | | } |
| | | </script> |
| | | |
| | | if (type.Trim()=="å¢åæ¡ç ") |
| | | { |
| | | SqlXMLReportData.GenOneRecordset(this, "select HSourceBillNo 订åå·,a.HMaterID,m.HName ç©æ,m.HModel åå·,a.HQty æ°é,a.HBatchNo æ¹å·,a.HBarCode ç®±å·,a.HRemark åºæ¯å· from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID in (" + PrintIds + ")"); |
| | | } |
| | | else |
| | | { |
| | | SqlXMLReportData.GenOneRecordset(this, "select fo.FBILLNO éå®è®¢åå·,fo.F_ZZZZ_TEXT7 è系人,fo.FRECEIVEADDRESS æ¶è´§æ¹å°å," + |
| | | "fm1.FOLDNUMBER éå®ç©æåç§°,fo.F_ZZZZ_TEXT å
è£
æ¹å¼,fu.FDATAVALUE è±å,fu1.FDATAVALUE å¢åç¼,a.HQty æ°é,a.HBarCode ç®±å·,fo.F_ZZZZ_WBBZ å¤å
夿³¨ " + |
| | | "from Gy_BarCodeBill a " + |
| | | "left join Sc_ICMOBillSub b on a.HSourceInterID=b.HInterID " + |
| | | "left join AIS20200908101915zs..T_PRD_MOENTRY f1 on b.HERPEntryID=f1.FENTRYID " + |
| | | "left join AIS20200908101915zs..T_SAL_ORDER fo on f1.FSaleOrderId =fo.FID " + |
| | | "left join AIS20200908101915zs..T_SAL_ORDERENTRY fo1 on fo.FID=fo1.FID " + |
| | | "left join AIS20200908101915zs..T_BD_MATERIAL fm1 on fo1.FSUBMATERIALNUMBER=fm1.FMATERIALID " + |
| | | "LEFT JOIN AIS20200908101915zs..T_BAS_ASSISTANTDATAENTRY_L fu1 on fo1.F_ZZZZ_ASSISTANT1=fu1.FENTRYID " + |
| | | "LEFT JOIN AIS20200908101915zs..T_BAS_ASSISTANTDATAENTRY_L fu on fo1.F_ZZZZ_ASSISTANT2=fu.FENTRYID "+ |
| | | "where a.HItemID in (" + PrintIds + ")"); |
| | | } |
| | | } |
| | | </script> |
| | | </head> |
| | | <body> |
| | | <form id="form1" runat="server"> |
| New file |
| | |
| | | <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="xmlLBM_QK_SPackingBillList.aspx.cs" Inherits="WebTM.views.åºç¡èµæ.å
¬ç¨åºç¡èµæ.xmlLBM_QK_SPackingBillList" %> |
| | | |
| | | <!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"); |
| | | var ids = Request.Params["linterid"]; |
| | | var idsArray = ids.Split(','); |
| | | var PrintIds = ""; |
| | | for (int i = 0; i < idsArray.Length; i++) |
| | | { |
| | | PrintIds += "'" + idsArray[i] + "',"; |
| | | } |
| | | PrintIds = PrintIds.Substring(0, PrintIds.Length - 1); |
| | | SqlXMLReportData.GenOneRecordset(this, "select fo.FBILLNO éå®è®¢åå·,fo.F_ZZZZ_TEXT7 è系人,fo.FRECEIVEADDRESS æ¶è´§æ¹å°å," + |
| | | "fm1.FOLDNUMBER éå®ç©æåç§°,fo.F_ZZZZ_TEXT å
è£
æ¹å¼,fu.FDATAVALUE è±å,fu1.FDATAVALUE å¢åç¼,a.HQty æ°é,a.HBarCode ç®±å·,fo.F_ZZZZ_WBBZ å¤å
夿³¨ " + |
| | | "from Gy_BarCodeBill a " + |
| | | "left join Sc_ICMOBillSub b on a.HSourceInterID=b.HInterID " + |
| | | "left join AIS20200908101915zs..T_PRD_MOENTRY f1 on b.HERPEntryID=f1.FENTRYID " + |
| | | "left join AIS20200908101915zs..T_SAL_ORDER fo on f1.FSaleOrderId =fo.FID " + |
| | | "left join AIS20200908101915zs..T_SAL_ORDERENTRY fo1 on fo.FID=fo1.FID " + |
| | | "left join AIS20200908101915zs..T_BD_MATERIAL fm1 on fo1.FSUBMATERIALNUMBER=fm1.FMATERIALID " + |
| | | "LEFT JOIN AIS20200908101915zs..T_BAS_ASSISTANTDATAENTRY_L fu1 on fo1.F_ZZZZ_ASSISTANT1=fu1.FENTRYID " + |
| | | "LEFT JOIN AIS20200908101915zs..T_BAS_ASSISTANTDATAENTRY_L fu on fo1.F_ZZZZ_ASSISTANT2=fu.FENTRYID "+ |
| | | "where a.HItemID in (" + PrintIds + ")"); |
| | | } |
| | | </script> |
| | | </head> |
| | | <body> |
| | | <form id="form1" runat="server"> |
| | | <div> |
| | | </div> |
| | | </form> |
| | | </body> |
| | | </html> |
| File was renamed from WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/xmlLBM_QK_HXPackingBillList.aspx.cs |
| | |
| | | |
| | | namespace WebTM.views.åºç¡èµæ.å
¬ç¨åºç¡èµæ |
| | | { |
| | | public partial class xmlLBM_QK_HXPackingBillList : System.Web.UI.Page |
| | | public partial class xmlLBM_QK_SPackingBillList : System.Web.UI.Page |
| | | { |
| | | protected void Page_Load(object sender, EventArgs e) |
| | | { |
| File was renamed from WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/xmlLBM_QK_WLPackingBillList.aspx.designer.cs |
| | |
| | | { |
| | | |
| | | |
| | | public partial class xmlLBM_QK_WLPackingBillList |
| | | public partial class xmlLBM_QK_SPackingBillList |
| | | { |
| | | |
| | | /// <summary> |
| | |
| | | PrintIds += "'" + idsArray[i] + "',"; |
| | | } |
| | | PrintIds = PrintIds.Substring(0, PrintIds.Length - 1); |
| | | |
| | | string sql = string.Format(@"select convert(varchar,f.FSalOrderDate ,23) éå®è®¢åæ¥æ,a.HBillNo åæ®ç¼å·,f.F_YQN_XSDD éå®è®¢åç¼å·, f.F_zzzz_Text4 éå®ç©æåç§°,f.F_zzzz_Text1 éå®è®¢åè系人, |
| | | f.F_BZFS å
è£
æ¹å¼,b.HQty é宿°é,convert(varchar(50),a.HInterID)+'-'+convert(varchar(50),b.HEntryID) 主ååå· |
| | | LogService.Write(PrintIds); |
| | | string sql = string.Format(@"select convert(varchar,f1.FSalOrderDate ,23) éå®è®¢åæ¥æ,a.HBillNo åæ®ç¼å·,f1.F_YQN_XSDD éå®è®¢åç¼å·, f1.F_zzzz_Text4 éå®ç©æåç§°,f1.F_ZZZZ_XSDDLXR éå®è®¢åè系人,f1.F_BZFS å
è£
æ¹å¼,b.HQty é宿°é,convert(varchar(50),a.HInterID)+'-'+convert(varchar(50),b.HEntryID) 主ååå· |
| | | from Sc_ICMOBillMain a |
| | | left join Sc_ICMOBillSub b on a.HInterID=b.HInterID |
| | | left join AIS20200908101915zs..T_PRD_MOENTRY f on b.HERPInterID=f.FID |
| | | left join AIS20200908101915zs..T_PRD_MOENTRY f1 on b.HERPEntryID=f1.FENTRYID |
| | | left join AIS20200908101915zs..T_PRD_MO f on f1.FID=f.FID |
| | | left join Xs_SeOrderBillMain x on a.HSeOrderInterID=x.HInterID |
| | | where convert(varchar(50),a.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ("+ PrintIds+") order by a.HInterID desc"); |
| | | |
| | | where convert(varchar(50),a.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ("+ PrintIds+") order by b.HEntryID"); |
| | | LogService.Write(sql); |
| | | SqlXMLReportData.GenOneRecordset(this, sql); |
| | | } |
| | | </script> |
| | |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç产车é´</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HDeptName" id="HDeptName"> |
| | | <select name="HDeptName" id="HDeptName" lay-verify="required" lay-search class="layui-input"> |
| | | |
| | | <!--å¨ææ¸²æè½¦é´--> |
| | | </select> |
| | | |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ä¸å¡ç¶æ</label> |
| | | <div class="layui-input-block"> |
| | | <select name="HStatus" id="HStatus" lay-verify="required" lay-search class="layui-input"> |
| | | <option value="0" selected>å
¨é¨</option> |
| | | <option value="计å">计å</option> |
| | | <option value="计å确认">计å确认</option> |
| | | <option value="ä¸è¾¾">ä¸è¾¾</option> |
| | | <option value="å¼å·¥">å¼å·¥</option> |
| | | <option value="å®å·¥">å®å·¥</option> |
| | | <option value="ç»æ¡">ç»æ¡</option> |
| | | </select> |
| | | |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">åæ®ç±»å</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HBillType" id="HBillType"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | |
| | | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | //è·å车é´å |
| | | var HDeptName = '<option value="0" style="color:red;">å
¨é¨è½¦é´</option>'; |
| | | $.ajax({ |
| | | type: "get", |
| | | url: GetWEBURL() + "/Sc_ICMOBill/GetHDeptList", |
| | | success: function (result) { |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | if (i == 0) |
| | | HDeptName += '<option style="color:blue;" value="' + data[i].HItemID + '" selected>' + data[i].HName + '</option>'; |
| | | else |
| | | HDeptName += '<option style="color:blue;" value="' + data[i].HItemID + '">' + data[i].HName + '</option>'; |
| | | |
| | | } |
| | | $("#HDeptName").append(HDeptName); |
| | | form.render('select'); |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | //#endregion |
| | | |
| | | |
| | |
| | | , { field: 'éå®è®¢åæ¥æ', title: 'éå®è®¢åæ¥æ', sort: true, width: 120, hide: true } |
| | | , { field: 'åæ®å·', title: 'åæ®å·', sort: true, width: 170, hide: true } |
| | | |
| | | , { field: 'éå®è®¢åæ¥æ', title: 'éå®è®¢åæ¥æ', sort: true, width: 120 } |
| | | , { field: 'éå®è®¢åç¼å·', title: 'éå®è®¢åç¼å·', sort: true, width: 120 } |
| | | , { field: 'éå®ç©æåç§°', title: 'éå®ç©æåç§°', sort: true, width: 120 } |
| | | , { field: 'å
è£
æ¹å¼', title: 'å
è£
æ¹å¼', sort: true, width: 120 } |
| | | , { field: 'é宿°é', title: 'é宿°é', sort: true, width: 120 } |
| | | , { field: 'éå®è®¢åè系人', title: 'éå®è®¢åè系人', sort: true, width: 120 } |
| | | , { field: 'ä¸å¡ç¶æ', title: 'ä¸å¡ç¶æ', sort: true, width: 120 } |
| | | , { field: 'éå®è®¢åæ¥æ', title: 'éå®è®¢åæ¥æ', sort: true, width: 200 } |
| | | , { field: 'éå®è®¢åç¼å·', title: 'éå®è®¢åç¼å·', sort: true, width: 200 } |
| | | , { field: 'éå®ç©æåç§°', title: 'éå®ç©æåç§°', sort: true, width: 200 } |
| | | , { field: 'å
è£
æ¹å¼', title: 'å
è£
æ¹å¼', sort: true, width: 150 } |
| | | , { field: 'é宿°é', title: 'é宿°é', sort: true, width: 150 } |
| | | , { field: 'éå®è®¢åè系人', title: 'éå®è®¢åè系人', sort: true, width: 150 } |
| | | , { field: 'ä¸å¡ç¶æ', title: 'ä¸å¡ç¶æ', sort: true, width: 150 } |
| | | |
| | | , { field: '订åè·è¸ªå·', title: '订åè·è¸ªå·', sort: true, width: 120, hide: true } |
| | | , { field: 'HDeptID', title: 'HDeptID', hide: true} |
| | |
| | | var HDate1 = $("#HDate1").val();//ç»ææ¥æ |
| | | var HOrderProcNO = $("#HOrderProcNO").val();//订åè·è¸ªå· |
| | | var WorkCenter = $("#WorkCenter").val();//åæ®å· |
| | | var HDeptName = $("#HDeptName").val();//åæ®å· |
| | | var HMaterName = $("#HMaterName").val();//åæ®å· |
| | | var HDeptName = $("#HDeptName").val();//åæ®å· |
| | | var HStatus = $("#HStatus").val();//åæ®å· |
| | | var HBillType = $("#HBillType").val();//åæ®ç±»å |
| | | if (HDate) { |
| | | sWhere += " and æ¥æ >= '" + HDate + "'"; |
| | | } |
| | |
| | | if (WorkCenter) { |
| | | sWhere += " and åæ®å· like '%" + WorkCenter + "%'"; |
| | | } |
| | | if (HDeptName) { |
| | | sWhere += " and çäº§è½¦é´ like '%" + HDeptName + "%'"; |
| | | } |
| | | if (HMaterName) { |
| | | sWhere += " and 产å代ç like '%" + HMaterName + "%'"; |
| | | } |
| | | if (HDeptName && HDeptName!=0) { |
| | | sWhere += " and HDeptID = " + HDeptName ; |
| | | } |
| | | if (HStatus && HStatus != 0) { |
| | | sWhere += " and ä¸å¡ç¶æ like '%" + HStatus + "%'"; |
| | | } |
| | | if (HBillType) { |
| | | sWhere += " and åæ®ç±»å like '%" + HBillType + "%'"; |
| | | } |
| | | get_Display(sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | |
| | | $("#WorkCenter").val("");//åæ®å· |
| | | $("#HDeptName").val("");//åæ®å· |
| | | $("#HMaterName").val("");//åæ®å· |
| | | $("#HDeptName").val("");//åæ®å· |
| | | $("#HStatus").val("");//åæ®å· |
| | | $("#btnSearch").click(); |
| | | sWhere = ""; |
| | | } |
| | |
| | | form.on('submit(btnPack)', function (data) { |
| | | var flag = "ZZ"; |
| | | var sSubStr = table.checkStatus('mainTable'); |
| | | if (sSubStr.data.length > 0) { |
| | | SavePack(flag, sSubStr); |
| | | } |
| | | else { |
| | | layer.msg('请æå°éæ©1è¡æ°æ®ï¼'); |
| | | return; |
| | | } |
| | | SavePack(flag, sSubStr); |
| | | }); |
| | | //æ¼ç®±çæ |
| | |
| | | { type: 'checkbox', fixed: 'left' } |
| | | , { field: 'HSeOrderBillNo', title: 'éå®è®¢åå·', edit: 'text', width: 100, hide: true } |
| | | , { field: 'HInterID', title: 'HInterID', edit: 'text', width: 100, hide: true } |
| | | , { field: 'HEntryID', title: 'HEntryID', edit: 'text', width: 100, hide: true } |
| | | , { field: 'HBillNo', title: 'HBillNo', edit: 'text', width: 100, hide: true } |
| | | , { field: 'HMaterID', title: 'HMaterID', edit: 'text', width: 100, hide: true } |
| | | , { field: 'HMaterNumber', title: 'HMaterNumber', edit: 'text', width: 100, hide: true } |
| | |
| | | if (data.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var PrintIds = data.code; |
| | | PrintIds = PrintIds.substring(0, PrintIds.length - 1); |
| | | layer.open({ |
| | | type: 2 |
| | | , area: ['50%', '50%'] |
| | | , title: 'æå°æ¨¡çéæ©' |
| | | , shade: 0.6 //é®ç½©éæåº¦ |
| | | , maxmin: false //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + PrintIds + '&MyMsg=' + PrintIds + '&Type=HQKPackBill', 'yes'] |
| | | , resize: false |
| | | }) |
| | | var Type = "HQKPackBill"; |
| | | var OpenTmp = ""; |
| | | if (sSubStr.data[0].FBZFS == "" && (sSubStr.data[0].FHX != "" || sSubStr.data[0].FMaterName != "")) { |
| | | OpenTmp = "è±åæ¡ç "; |
| | | } |
| | | else { |
| | | OpenTmp = "å
è£
æ¹å¼æ¡ç "; |
| | | } |
| | | window.open("../åºç¡èµæ/å
¬ç¨åºç¡èµæ/HBarPlanPrint.html?linterid=" + PrintIds.toString() + "&Type=" + Type.toString() + "&OpenTmp=" + OpenTmp.toString()); |
| | | |
| | | } |
| | | else { |
| | | f_alert(data.Message); |
| | |
| | | <label class="layui-form-label">å®æç¶æ</label> |
| | | <div class="layui-input-block" style="width:190px;"> |
| | | <select name="HFinishStatus" lay-filter="HFinishStatus"> |
| | | <option value="" selected>å
¨é¨</option> |
| | | <option value="æªå®æ" selected>æªå®æ</option> |
| | | <option value="已宿">已宿</option> |
| | | </select> |
| | |
| | | <label class="layui-form-label">å®æç¶æ</label> |
| | | <div class="layui-input-block" style="width:190px;"> |
| | | <select name="HFinishStatus" lay-filter="HFinishStatus"> |
| | | <option value="" selected>å
¨é¨</option> |
| | | <option value="æªå®æ" selected>æªå®æ</option> |
| | | <option value="已宿">已宿</option> |
| | | </select> |