161 lines
8.1 KiB
Plaintext
161 lines
8.1 KiB
Plaintext
|
<?xml version="1.0" encoding="utf-8"?>
|
||
|
|
<root>
|
||
|
|
<!--
|
||
|
|
Microsoft ResX Schema
|
||
|
|
|
||
|
|
Version 2.0
|
||
|
|
|
||
|
|
The primary goals of this format is to allow a simple XML format
|
||
|
|
that is mostly human readable. The generation and parsing of the
|
||
|
|
various data types are done through the TypeConverter classes
|
||
|
|
associated with the data types.
|
||
|
|
|
||
|
|
Example:
|
||
|
|
|
||
|
|
... ado.net/XML headers & schema ...
|
||
|
|
<resheader name="resmimetype">text/microsoft-resx</resheader>
|
||
|
|
<resheader name="version">2.0</resheader>
|
||
|
|
<resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>
|
||
|
|
<resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>
|
||
|
|
<data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>
|
||
|
|
<data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>
|
||
|
|
<data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">
|
||
|
|
<value>[base64 mime encoded serialized .NET Framework object]</value>
|
||
|
|
</data>
|
||
|
|
<data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
|
||
|
|
<value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>
|
||
|
|
<comment>This is a comment</comment>
|
||
|
|
</data>
|
||
|
|
|
||
|
|
There are any number of "resheader" rows that contain simple
|
||
|
|
name/value pairs.
|
||
|
|
|
||
|
|
Each data row contains a name, and value. The row also contains a
|
||
|
|
type or mimetype. Type corresponds to a .NET class that support
|
||
|
|
text/value conversion through the TypeConverter architecture.
|
||
|
|
Classes that don't support this are serialized and stored with the
|
||
|
|
mimetype set.
|
||
|
|
|
||
|
|
The mimetype is used for serialized objects, and tells the
|
||
|
|
ResXResourceReader how to depersist the object. This is currently not
|
||
|
|
extensible. For a given mimetype the value must be set accordingly:
|
||
|
|
|
||
|
|
Note - application/x-microsoft.net.object.binary.base64 is the format
|
||
|
|
that the ResXResourceWriter will generate, however the reader can
|
||
|
|
read any of the formats listed below.
|
||
|
|
|
||
|
|
mimetype: application/x-microsoft.net.object.binary.base64
|
||
|
|
value : The object must be serialized with
|
||
|
|
: System.Runtime.Serialization.Formatters.Binary.BinaryFormatter
|
||
|
|
: and then encoded with base64 encoding.
|
||
|
|
|
||
|
|
mimetype: application/x-microsoft.net.object.soap.base64
|
||
|
|
value : The object must be serialized with
|
||
|
|
: System.Runtime.Serialization.Formatters.Soap.SoapFormatter
|
||
|
|
: and then encoded with base64 encoding.
|
||
|
|
|
||
|
|
mimetype: application/x-microsoft.net.object.bytearray.base64
|
||
|
|
value : The object must be serialized into a byte array
|
||
|
|
: using a System.ComponentModel.TypeConverter
|
||
|
|
: and then encoded with base64 encoding.
|
||
|
|
-->
|
||
|
|
<xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
|
||
|
|
<xsd:import namespace="http://www.w3.org/XML/1998/namespace" />
|
||
|
|
<xsd:element name="root" msdata:IsDataSet="true">
|
||
|
|
<xsd:complexType>
|
||
|
|
<xsd:choice maxOccurs="unbounded">
|
||
|
|
<xsd:element name="metadata">
|
||
|
|
<xsd:complexType>
|
||
|
|
<xsd:sequence>
|
||
|
|
<xsd:element name="value" type="xsd:string" minOccurs="0" />
|
||
|
|
</xsd:sequence>
|
||
|
|
<xsd:attribute name="name" use="required" type="xsd:string" />
|
||
|
|
<xsd:attribute name="type" type="xsd:string" />
|
||
|
|
<xsd:attribute name="mimetype" type="xsd:string" />
|
||
|
|
<xsd:attribute ref="xml:space" />
|
||
|
|
</xsd:complexType>
|
||
|
|
</xsd:element>
|
||
|
|
<xsd:element name="assembly">
|
||
|
|
<xsd:complexType>
|
||
|
|
<xsd:attribute name="alias" type="xsd:string" />
|
||
|
|
<xsd:attribute name="name" type="xsd:string" />
|
||
|
|
</xsd:complexType>
|
||
|
|
</xsd:element>
|
||
|
|
<xsd:element name="data">
|
||
|
|
<xsd:complexType>
|
||
|
|
<xsd:sequence>
|
||
|
|
<xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
|
||
|
|
<xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />
|
||
|
|
</xsd:sequence>
|
||
|
|
<xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" />
|
||
|
|
<xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />
|
||
|
|
<xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />
|
||
|
|
<xsd:attribute ref="xml:space" />
|
||
|
|
</xsd:complexType>
|
||
|
|
</xsd:element>
|
||
|
|
<xsd:element name="resheader">
|
||
|
|
<xsd:complexType>
|
||
|
|
<xsd:sequence>
|
||
|
|
<xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
|
||
|
|
</xsd:sequence>
|
||
|
|
<xsd:attribute name="name" type="xsd:string" use="required" />
|
||
|
|
</xsd:complexType>
|
||
|
|
</xsd:element>
|
||
|
|
</xsd:choice>
|
||
|
|
</xsd:complexType>
|
||
|
|
</xsd:element>
|
||
|
|
</xsd:schema>
|
||
|
|
<resheader name="resmimetype">
|
||
|
|
<value>text/microsoft-resx</value>
|
||
|
|
</resheader>
|
||
|
|
<resheader name="version">
|
||
|
|
<value>2.0</value>
|
||
|
|
</resheader>
|
||
|
|
<resheader name="reader">
|
||
|
|
<value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
|
||
|
|
</resheader>
|
||
|
|
<resheader name="writer">
|
||
|
|
<value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
|
||
|
|
</resheader>
|
||
|
|
<metadata name="sqlDataSource1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
|
||
|
|
<value>17, 93</value>
|
||
|
|
</metadata>
|
||
|
|
<data name="customSqlQuery1.Sql" xml:space="preserve">
|
||
|
|
<value>select
|
||
|
|
|
||
|
|
b.GOODS_ID as 物料编号,
|
||
|
|
b.goods_name as 物料名称 ,
|
||
|
|
--商品分类
|
||
|
|
--商品分类
|
||
|
|
|
||
|
|
a.PRODUCTION_DATE as 生产日期 , --生产日期
|
||
|
|
--入库仓库编号
|
||
|
|
c.storage_name as 仓库名称 ,
|
||
|
|
|
||
|
|
x.VC_DICTIONARY_NAME as 单位名称,
|
||
|
|
b.PERIOD as 保质期,
|
||
|
|
|
||
|
|
g.provider_name as 供应商名称 , --供应商名称
|
||
|
|
ISNULL(a.GVOLUME,0) GVOLUME ,a.GOODSVOLUME as 装箱数 ,
|
||
|
|
f.GOODS_MEASURE_NAME as 箱型 ,'' as 箱码 ,'' as 二维码
|
||
|
|
FROM T_RK_WARE_NOTICE_TAB a left join t_base_goods b
|
||
|
|
|
||
|
|
on a.goods_id = b.goods_id
|
||
|
|
left join t_base_storageinfo c
|
||
|
|
on a.storage_id = c.storage_id
|
||
|
|
|
||
|
|
|
||
|
|
left join T_BASE_GOODS_MEASURE f
|
||
|
|
on a.GOODS_MEASURE_ID = f.GOODS_MEASURE_ID
|
||
|
|
left join t_base_provider_dictionary g
|
||
|
|
on a.provider_id = g.provider_id
|
||
|
|
left join T_SYS_DICTIONARY_TAB x
|
||
|
|
on x.VC_CHAR_VALUE=a.UNIT
|
||
|
|
and x.VC_DICTIONARY_TYPE='vc_uom' and 1!=1
|
||
|
|
|
||
|
|
</value>
|
||
|
|
</data>
|
||
|
|
<data name="sqlDataSource1.ResultSchemaSerializable" xml:space="preserve">
|
||
|
|
<value>PERhdGFTZXQgTmFtZT0ic3FsRGF0YVNvdXJjZTEiPjxWaWV3IE5hbWU9IueuseeggeaJk+WNsCI+PEZpZWxkIE5hbWU9IueJqeaWmee8luWPtyIgVHlwZT0iU3RyaW5nIiAvPjxGaWVsZCBOYW1lPSLnianmlpnlkI3np7AiIFR5cGU9IlN0cmluZyIgLz48RmllbGQgTmFtZT0i55Sf5Lqn5pel5pyfIiBUeXBlPSJEYXRlVGltZSIgLz48RmllbGQgTmFtZT0i5LuT5bqT5ZCN56ewIiBUeXBlPSJTdHJpbmciIC8+PEZpZWxkIE5hbWU9IuWNleS9jeWQjeensCIgVHlwZT0iU3RyaW5nIiAvPjxGaWVsZCBOYW1lPSLkv53otKjmnJ8iIFR5cGU9IkRlY2ltYWwiIC8+PEZpZWxkIE5hbWU9IuS+m+W6lOWVhuWQjeensCIgVHlwZT0iU3RyaW5nIiAvPjxGaWVsZCBOYW1lPSJHVk9MVU1FIiBUeXBlPSJEZWNpbWFsIiAvPjxGaWVsZCBOYW1lPSLoo4XnrrHmlbAiIFR5cGU9IkRlY2ltYWwiIC8+PEZpZWxkIE5hbWU9IueuseWeiyIgVHlwZT0iU3RyaW5nIiAvPjxGaWVsZCBOYW1lPSLnrrHnoIEiIFR5cGU9IlN0cmluZyIgLz48RmllbGQgTmFtZT0i5LqM57u056CBIiBUeXBlPSJTdHJpbmciIC8+PC9WaWV3PjwvRGF0YVNldD4=</value>
|
||
|
|
</data>
|
||
|
|
</root>
|