<?xml version="1.0" encoding="utf-8"?>
|
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
|
<!-- EF Runtime content -->
|
<edmx:Runtime>
|
<!-- SSDL content -->
|
<edmx:StorageModels>
|
<Schema Namespace="developModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
|
<!--Errors Found During Generation:
|
warning 6002: The table/view 'develop.dbo.ADDTIONAL_TERM_EXISTENCE' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
|
<EntityType Name="AttachInfo">
|
<Key>
|
<PropertyRef Name="AttachID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="AttachID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="AttachName" Type="nvarchar" MaxLength="100" />
|
<Property Name="Source" Type="int" />
|
<Property Name="FilePath" Type="nvarchar" MaxLength="255" />
|
<Property Name="CreatedUser" Type="varchar" MaxLength="20" />
|
<Property Name="FileViewName" Type="nvarchar" MaxLength="100" />
|
</EntityType>
|
<EntityType Name="Calendar">
|
<Key>
|
<PropertyRef Name="CalDate" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="CalDate" Type="varchar" MaxLength="10" Nullable="false" />
|
<Property Name="Caltype" Type="int" />
|
<Property Name="Description" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="DocumentNo">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="ClientID" Type="varchar" MaxLength="10" />
|
<Property Name="Catalog" Type="varchar" MaxLength="15" Nullable="false" />
|
<Property Name="TypeCode" Type="char" MaxLength="5" />
|
<Property Name="UDKey1" Type="varchar" MaxLength="16" />
|
<Property Name="UDKey2" Type="varchar" MaxLength="16" />
|
<Property Name="UDKey3" Type="varchar" MaxLength="16" />
|
<Property Name="UDKey4" Type="varchar" MaxLength="16" />
|
<Property Name="UDKey5" Type="varchar" MaxLength="16" />
|
<Property Name="UDKey6" Type="varchar" MaxLength="16" />
|
<Property Name="UDKey7" Type="varchar" MaxLength="16" />
|
<Property Name="UDKey8" Type="varchar" MaxLength="16" />
|
<Property Name="UDKey9" Type="varchar" MaxLength="16" />
|
<Property Name="UDKey10" Type="varchar" MaxLength="16" />
|
<Property Name="NextNumber" Type="varchar" MaxLength="16" Nullable="false" />
|
<Property Name="LockInfo" Type="char" MaxLength="22" />
|
<Property Name="IsDeleted" Type="int" />
|
<Property Name="CreateDate" Type="datetime" />
|
<Property Name="CreateUser" Type="varchar" MaxLength="16" />
|
<Property Name="ModifiedDate" Type="datetime" />
|
<Property Name="ModifiedUser" Type="varchar" MaxLength="16" />
|
</EntityType>
|
<EntityType Name="DocumentNoTemplate">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="ClientID" Type="varchar" MaxLength="10" />
|
<Property Name="TypeCode" Type="char" MaxLength="5" />
|
<Property Name="Catalog" Type="varchar" MaxLength="50" Nullable="false" />
|
<Property Name="Model" Type="varchar" MaxLength="512" />
|
<Property Name="LockInfo" Type="char" MaxLength="22" />
|
<Property Name="IsDeleted" Type="char" MaxLength="1" />
|
<Property Name="CreateUser" Type="varchar" MaxLength="16" />
|
<Property Name="CreateDate" Type="datetime" />
|
<Property Name="LastMaintUser" Type="varchar" MaxLength="16" />
|
<Property Name="LastMaintDate" Type="datetime" />
|
</EntityType>
|
<EntityType Name="dtproperties">
|
<Key>
|
<PropertyRef Name="id" />
|
<PropertyRef Name="property" />
|
</Key>
|
<Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="objectid" Type="int" />
|
<Property Name="property" Type="varchar" MaxLength="64" Nullable="false" />
|
<Property Name="value" Type="varchar" MaxLength="255" />
|
<Property Name="uvalue" Type="nvarchar" MaxLength="255" />
|
<Property Name="lvalue" Type="image" />
|
<Property Name="version" Type="int" Nullable="false" />
|
</EntityType>
|
<EntityType Name="FAQ">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="Kind" Type="int" Nullable="false" />
|
<Property Name="UnitName" Type="varchar" MaxLength="128" />
|
<Property Name="Question" Type="text" />
|
<Property Name="Response" Type="text" />
|
<Property Name="FileName" Type="varchar" MaxLength="128" />
|
<Property Name="LastMaintUser" Type="varchar" MaxLength="8" />
|
<Property Name="LastMaintDate" Type="datetime" />
|
</EntityType>
|
<EntityType Name="Holiday">
|
<Key>
|
<PropertyRef Name="Holiday" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="Holiday" Type="varchar" MaxLength="5" Nullable="false" />
|
<Property Name="Description" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="LogDBMonitor">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="MsgNo" Type="varchar" MaxLength="15" />
|
<Property Name="currentProsID" Type="varchar" MaxLength="20" />
|
<Property Name="ModifyDetail" Type="text" />
|
<Property Name="CreatedDate" Type="datetime" />
|
<Property Name="CreatedUser" Type="varchar" MaxLength="20" />
|
</EntityType>
|
<EntityType Name="LogMailAssign">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="MsgID" Type="varchar" MaxLength="15" Nullable="false" />
|
<Property Name="MsgNo" Type="varchar" MaxLength="15" />
|
<Property Name="currentProsID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="parentProsID" Type="varchar" MaxLength="20" />
|
<Property Name="FromUnit" Type="varchar" MaxLength="20" />
|
<Property Name="ToUnit" Type="varchar" MaxLength="20" />
|
<Property Name="ToUser" Type="varchar" MaxLength="20" />
|
<Property Name="DispatchedNum" Type="int" />
|
<Property Name="FinishedNum" Type="int" />
|
<Property Name="Note" Type="text" />
|
<Property Name="Response" Type="text" />
|
<Property Name="AttachID" Type="varchar" MaxLength="255" />
|
<Property Name="Version" Type="int" />
|
<Property Name="MsgState" Type="int" />
|
<Property Name="PressCount" Type="int" />
|
<Property Name="UpperRcvDate" Type="datetime" />
|
<Property Name="UpperDspDate" Type="datetime" />
|
<Property Name="SelfReceivedDate" Type="datetime" />
|
<Property Name="SelfExpiredDate" Type="datetime" />
|
<Property Name="ExpiredDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="SelfDonedDate" Type="datetime" />
|
<Property Name="ClosedDate" Type="datetime" />
|
<Property Name="WorkDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="RootWorkDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="SelfOverdueDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="IsMaster" Type="int" />
|
<Property Name="IsAssembled" Type="int" />
|
<Property Name="IsApproved" Type="int" />
|
<Property Name="IsRejected" Type="int" />
|
<Property Name="IsExpired" Type="int" />
|
<Property Name="IsDeleted" Type="int" />
|
<Property Name="LogReason" Type="varchar" MaxLength="20" />
|
</EntityType>
|
<EntityType Name="LogTransMail">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="TransferDate" Type="varchar" MaxLength="10" Nullable="false" />
|
<Property Name="ToUnit" Type="varchar" MaxLength="20" />
|
<Property Name="CreatedDate" Type="datetime" />
|
</EntityType>
|
<EntityType Name="MailAssign">
|
<Key>
|
<PropertyRef Name="currentProsID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="MsgID" Type="varchar" MaxLength="15" Nullable="false" />
|
<Property Name="MsgNo" Type="varchar" MaxLength="15" />
|
<Property Name="currentProsID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="parentProsID" Type="varchar" MaxLength="20" />
|
<Property Name="FromUnit" Type="varchar" MaxLength="20" />
|
<Property Name="ToUnit" Type="varchar" MaxLength="20" />
|
<Property Name="ToUser" Type="varchar" MaxLength="20" />
|
<Property Name="DispatchedNum" Type="int" />
|
<Property Name="FinishedNum" Type="int" />
|
<Property Name="Note" Type="text" />
|
<Property Name="Response" Type="text" />
|
<Property Name="ReAssign" Type="text" />
|
<Property Name="AttachID" Type="varchar" MaxLength="255" />
|
<Property Name="Version" Type="int" />
|
<Property Name="MsgState" Type="int" />
|
<Property Name="PressCount" Type="int" />
|
<Property Name="UpperRcvDate" Type="datetime" />
|
<Property Name="UpperDspDate" Type="datetime" />
|
<Property Name="SelfReceivedDate" Type="datetime" />
|
<Property Name="SelfExpiredDate" Type="datetime" />
|
<Property Name="ExpiredDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="SelfDonedDate" Type="datetime" />
|
<Property Name="WorkDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="ClosedDate" Type="datetime" />
|
<Property Name="RootWorkDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="SelfOverdueDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="IsMaster" Type="int" />
|
<Property Name="IsAssembled" Type="int" />
|
<Property Name="IsApproved" Type="int" />
|
<Property Name="IsChecked" Type="int" />
|
<Property Name="IsRejected" Type="int" />
|
<Property Name="IsExpired" Type="int" />
|
<Property Name="IsDeleted" Type="int" />
|
<Property Name="IsQueued" Type="int" />
|
<Property Name="IsSnReply" Type="int" />
|
<Property Name="SnToUnit" Type="varchar" MaxLength="20" />
|
<Property Name="ReserveField01" Type="varchar" MaxLength="100" />
|
<Property Name="ReserveField02" Type="varchar" MaxLength="100" />
|
<Property Name="NoReq" Type="varchar" MaxLength="1" Nullable="false" />
|
<Property Name="FileReceivedDate" Type="datetime" />
|
<Property Name="FileCheckDate" Type="datetime" />
|
<Property Name="FileCheckUnit" Type="varchar" MaxLength="20" />
|
<Property Name="FileNo" Type="varchar" MaxLength="20" />
|
<Property Name="FileMajorUnit" Type="varchar" MaxLength="20" />
|
<Property Name="FileMajorID" Type="varchar" MaxLength="20" />
|
<Property Name="FileMajorUser" Type="varchar" MaxLength="20" />
|
<Property Name="FilePros" Type="varchar" MaxLength="20" />
|
<Property Name="IsCancel" Type="int" />
|
<Property Name="IsCombin" Type="int" />
|
<Property Name="FileCancelReason" Type="varchar" MaxLength="500" />
|
<Property Name="FileCombinNo" Type="varchar" MaxLength="20" />
|
</EntityType>
|
<EntityType Name="MailCatelog">
|
<Key>
|
<PropertyRef Name="CateID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="CID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="CateID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="CateName" Type="varchar" MaxLength="50" />
|
<Property Name="parentID" Type="varchar" MaxLength="20" />
|
<Property Name="SeqNo" Type="int" />
|
<Property Name="IsActived" Type="int" />
|
<Property Name="IsDeleted" Type="int" />
|
<Property Name="CreatedDate" Type="datetime" />
|
<Property Name="CreatedUser" Type="varchar" MaxLength="20" />
|
<Property Name="ExpiredDays" Type="int" />
|
<Property Name="ReportNeed" Type="int" />
|
<Property Name="OverDate" Type="int" />
|
</EntityType>
|
<EntityType Name="Mailor">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="MailorID" Type="varchar" MaxLength="10" />
|
<Property Name="MailorName" Type="nvarchar" MaxLength="100" />
|
<Property Name="Password" Type="nvarchar" MaxLength="100" />
|
<Property Name="IDNum" Type="varchar" MaxLength="10" />
|
<Property Name="Email" Type="varchar" MaxLength="100" Nullable="false" />
|
<Property Name="AliasEmail" Type="varchar" MaxLength="100" />
|
<Property Name="MailorTel" Type="varchar" MaxLength="40" />
|
<Property Name="MailorAddr" Type="nvarchar" MaxLength="100" />
|
<Property Name="Mailcount" Type="int" />
|
<Property Name="Sex" Type="int" />
|
<Property Name="City" Type="varchar" MaxLength="20" />
|
<Property Name="PostCode" Type="varchar" MaxLength="3" />
|
<Property Name="edubackground" Type="int" />
|
<Property Name="Mailorfex" Type="varchar" MaxLength="15" />
|
<Property Name="Age" Type="int" />
|
<Property Name="IsDemos" Type="varchar" MaxLength="1" />
|
<Property Name="Career" Type="int" />
|
<Property Name="Occupation" Type="varchar" MaxLength="20" />
|
<Property Name="IsActived" Type="tinyint" />
|
<Property Name="PowerNo" Type="nvarchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="NewMail">
|
<Key>
|
<PropertyRef Name="MsgID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="MsgID" Type="varchar" MaxLength="15" Nullable="false" />
|
<Property Name="MsgNo" Type="varchar" MaxLength="15" Nullable="false" />
|
<Property Name="MID" Type="int" />
|
<Property Name="MailorAcct" Type="varchar" MaxLength="50" />
|
<Property Name="MailorDomain" Type="varchar" MaxLength="50" />
|
<Property Name="MsgSubject" Type="varchar" MaxLength="512" />
|
<Property Name="MsgContent" Type="text" />
|
<Property Name="AttachID" Type="varchar" MaxLength="255" />
|
<Property Name="MsgAttr1" Type="varchar" MaxLength="10" />
|
<Property Name="MsgAttr2" Type="varchar" MaxLength="10" />
|
<Property Name="MsgAttr3" Type="varchar" MaxLength="10" />
|
<Property Name="MsgAttr4" Type="varchar" MaxLength="10" />
|
<Property Name="MsgAttr5" Type="varchar" MaxLength="20" />
|
<Property Name="IsDeleted" Type="int" />
|
<Property Name="IsSatSvy" Type="int" />
|
<Property Name="IsHaveRefMail" Type="int" />
|
<Property Name="AllowedDate" Type="datetime" />
|
<Property Name="UniReply" Type="int" />
|
<Property Name="CreatedUser" Type="varchar" MaxLength="20" />
|
<Property Name="CreatedDate" Type="datetime" />
|
<Property Name="LastMaintUser" Type="datetime" />
|
<Property Name="LastMaintDate" Type="varchar" MaxLength="20" />
|
<Property Name="IdentityCatalog" Type="varchar" MaxLength="40" />
|
<Property Name="SatSvyKey" Type="varchar" MaxLength="36" />
|
<Property Name="IsStatement" Type="int" />
|
<Property Name="IsReAssign" Type="int" />
|
<Property Name="StateCatalog" Type="varchar" MaxLength="20" />
|
<Property Name="MajorDesc" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="RefMail">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="PreMsgNo" Type="varchar" MaxLength="15" />
|
<Property Name="MsgNo" Type="varchar" MaxLength="15" />
|
<Property Name="SeqNo" Type="int" />
|
</EntityType>
|
<EntityType Name="REP_01_M">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="Unit" Type="varchar" MaxLength="20" />
|
<Property Name="CreatedDate" Type="datetime" />
|
<Property Name="CountDate" Type="datetime" />
|
<Property Name="Column01" Type="int" />
|
<Property Name="Column02" Type="int" />
|
<Property Name="Column03" Type="int" />
|
<Property Name="Column04" Type="int" />
|
<Property Name="Column05" Type="int" />
|
<Property Name="Column0504" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column06" Type="int" />
|
<Property Name="Column0604" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column07" Type="int" />
|
<Property Name="Column0704" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column08" Type="int" />
|
<Property Name="Column0804" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column09" Type="int" />
|
<Property Name="Column0904" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column10" Type="int" />
|
<Property Name="Column1004" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column11" Type="int" />
|
<Property Name="Column1104" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column12" Type="int" />
|
<Property Name="Column1204" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="IsStatement" Type="int" />
|
</EntityType>
|
<EntityType Name="REP_02_M">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="Unit" Type="varchar" MaxLength="20" />
|
<Property Name="CreatedDate" Type="datetime" />
|
<Property Name="CountDate" Type="datetime" />
|
<Property Name="Column01" Type="int" />
|
<Property Name="Column02" Type="int" />
|
<Property Name="IsStatement" Type="int" />
|
</EntityType>
|
<EntityType Name="REP_03_M">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="Unit" Type="varchar" MaxLength="20" />
|
<Property Name="CreatedDate" Type="datetime" />
|
<Property Name="CountDate" Type="datetime" />
|
<Property Name="Column01" Type="int" />
|
<Property Name="Column02" Type="int" />
|
<Property Name="Column03" Type="int" />
|
<Property Name="Column04" Type="int" />
|
<Property Name="Column0409" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column05" Type="int" />
|
<Property Name="Column0504" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column06" Type="int" />
|
<Property Name="Column0604" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column07" Type="int" />
|
<Property Name="Column0704" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column08" Type="int" />
|
<Property Name="Column0809" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column09" Type="int" />
|
<Property Name="Column0903" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column10" Type="int" />
|
<Property Name="Column1003" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column11" Type="int" />
|
<Property Name="Column12" Type="int" />
|
<Property Name="Column13" Type="decimal" Precision="5" Scale="1" />
|
<Property Name="IsStatement" Type="int" />
|
</EntityType>
|
<EntityType Name="REP_04_M">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="Catalog" Type="varchar" MaxLength="20" />
|
<Property Name="CreatedDate" Type="datetime" />
|
<Property Name="CountDate" Type="datetime" />
|
<Property Name="Column01" Type="int" />
|
<Property Name="Column02" Type="int" />
|
<Property Name="Column03" Type="int" />
|
<Property Name="Column04" Type="int" />
|
<Property Name="Column0409" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column05" Type="int" />
|
<Property Name="Column0504" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column06" Type="int" />
|
<Property Name="Column0604" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column07" Type="int" />
|
<Property Name="Column0704" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column08" Type="int" />
|
<Property Name="Column0809" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column09" Type="int" />
|
<Property Name="Column0903" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column10" Type="int" />
|
<Property Name="Column1003" Type="decimal" Precision="5" Scale="2" />
|
<Property Name="Column11" Type="int" />
|
<Property Name="Column12" Type="int" />
|
<Property Name="Column13" Type="decimal" Precision="5" Scale="1" />
|
<Property Name="IsStatement" Type="int" />
|
</EntityType>
|
<EntityType Name="SatSvy">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="MsgNo" Type="varchar" MaxLength="15" Nullable="false" />
|
<Property Name="LastMaintDate" Type="datetime" />
|
<Property Name="Version" Type="varchar" MaxLength="10" />
|
<Property Name="maqa0" Type="varchar" MaxLength="100" />
|
<Property Name="maqa1" Type="varchar" MaxLength="555" />
|
<Property Name="maqa2" Type="varchar" MaxLength="255" />
|
<Property Name="maqa3" Type="varchar" MaxLength="255" />
|
</EntityType>
|
<EntityType Name="SendQueue">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="QueueID" Type="varchar" MaxLength="20" />
|
<Property Name="Priority" Type="varchar" MaxLength="1" />
|
<Property Name="TmptXML" Type="text" />
|
<Property Name="AttachID" Type="varchar" MaxLength="255" />
|
<Property Name="QueueType" Type="varchar" MaxLength="20" />
|
<Property Name="DeliveryDate" Type="datetime" />
|
<Property Name="CreatedDate" Type="datetime" />
|
<Property Name="FinishedDate" Type="datetime" />
|
</EntityType>
|
<!--Errors Found During Generation:
|
warning 6002: The table/view 'develop.dbo.SendQueue_Temp' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
|
<EntityType Name="SendQueue_Temp">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="QueueID" Type="varchar" MaxLength="20" />
|
<Property Name="Priority" Type="varchar" MaxLength="1" />
|
<Property Name="TmptXML" Type="text" />
|
<Property Name="AttachID" Type="varchar" MaxLength="255" />
|
<Property Name="QueueType" Type="varchar" MaxLength="20" />
|
<Property Name="DeliveryDate" Type="datetime" />
|
<Property Name="CreatedDate" Type="datetime" />
|
<Property Name="FinishedDate" Type="datetime" />
|
</EntityType>
|
<EntityType Name="SYS_AREA_M">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="AreaID" Type="varchar" MaxLength="11" />
|
<Property Name="AreaClass" Type="int" />
|
<Property Name="AreaName" Type="varchar" MaxLength="50" />
|
<Property Name="ToUnit" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="SYS_FUN_LIST_L">
|
<Key>
|
<PropertyRef Name="FID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="FID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="FunID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="FunName" Type="varchar" MaxLength="20" />
|
<Property Name="PFunID" Type="varchar" MaxLength="20" />
|
<Property Name="FunPath" Type="varchar" MaxLength="50" />
|
<Property Name="SortNum" Type="int" />
|
<Property Name="IsVisible" Type="int" />
|
</EntityType>
|
<EntityType Name="SYS_LOG_L">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="CreatedDate" Type="datetime" />
|
<Property Name="RemoteAddr" Type="varchar" MaxLength="15" />
|
<Property Name="GroupType" Type="int" />
|
<Property Name="UserID" Type="varchar" MaxLength="20" />
|
<Property Name="UsePage" Type="varchar" MaxLength="20" />
|
<Property Name="UserBrowser" Type="varchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="int" />
|
</EntityType>
|
<EntityType Name="SYS_RIGHTS_X">
|
<Key>
|
<PropertyRef Name="RoleID" />
|
<PropertyRef Name="FunID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="RoleID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="FunID" Type="varchar" MaxLength="20" Nullable="false" />
|
</EntityType>
|
<EntityType Name="SYS_ROLE_M">
|
<Key>
|
<PropertyRef Name="RoleID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="RoleID" Type="varchar" MaxLength="10" Nullable="false" />
|
<Property Name="RoleName" Type="varchar" MaxLength="20" />
|
<Property Name="IsActived" Type="int" />
|
<Property Name="IsDeleted" Type="int" />
|
<Property Name="RoleGroup" Type="int" />
|
</EntityType>
|
<EntityType Name="SYS_UNIT_M">
|
<Key>
|
<PropertyRef Name="UnitID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="UID" Type="varchar" MaxLength="20" />
|
<Property Name="UnitID" Type="varchar" MaxLength="50" Nullable="false" />
|
<Property Name="OUnitID" Type="varchar" MaxLength="20" />
|
<Property Name="UnitName" Type="varchar" MaxLength="50" />
|
<Property Name="Email" Type="varchar" MaxLength="60" />
|
<Property Name="ParentID" Type="varchar" MaxLength="20" />
|
<Property Name="SeqNo" Type="int" />
|
<Property Name="UAgent" Type="varchar" MaxLength="20" />
|
<Property Name="UAssembler" Type="varchar" MaxLength="20" />
|
<Property Name="IsActived" Type="int" />
|
<Property Name="IsDeleted" Type="int" />
|
<Property Name="GroupId" Type="int" />
|
<Property Name="MasterUnit" Type="varchar" MaxLength="255" />
|
</EntityType>
|
<EntityType Name="SYS_UNIT_O_M">
|
<Key>
|
<PropertyRef Name="UnitID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="UID" Type="varchar" MaxLength="20" />
|
<Property Name="UnitID" Type="varchar" MaxLength="50" Nullable="false" />
|
<Property Name="OUnitID" Type="varchar" MaxLength="20" />
|
<Property Name="UnitName" Type="varchar" MaxLength="50" />
|
<Property Name="Email" Type="varchar" MaxLength="60" />
|
<Property Name="ParentID" Type="varchar" MaxLength="20" />
|
<Property Name="SeqNo" Type="int" />
|
<Property Name="UAgent" Type="varchar" MaxLength="20" />
|
<Property Name="UAssembler" Type="varchar" MaxLength="20" />
|
<Property Name="IsActived" Type="int" />
|
<Property Name="IsDeleted" Type="int" />
|
<Property Name="GroupId" Type="int" />
|
<Property Name="MasterUnit" Type="varchar" MaxLength="255" />
|
</EntityType>
|
<EntityType Name="SYS_USER_M">
|
<Key>
|
<PropertyRef Name="UserID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="EmployeeID" Type="varchar" MaxLength="20" />
|
<Property Name="UserID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="UserName" Type="varchar" MaxLength="20" />
|
<Property Name="Password" Type="varchar" MaxLength="20" />
|
<Property Name="Email" Type="varchar" MaxLength="60" />
|
<Property Name="TitleName" Type="varchar" MaxLength="30" />
|
<Property Name="RoleID" Type="varchar" MaxLength="20" />
|
<Property Name="UnitID" Type="varchar" MaxLength="20" />
|
<Property Name="IsRest" Type="int" />
|
<Property Name="IsLogin" Type="int" />
|
<Property Name="IsDeleted" Type="int" />
|
<Property Name="IsActived" Type="int" />
|
<Property Name="LastLoginDate" Type="datetime" />
|
<Property Name="OffTel" Type="varchar" MaxLength="20" />
|
<Property Name="HomeTel" Type="varchar" MaxLength="20" />
|
</EntityType>
|
<EntityType Name="SysCodeTable">
|
<Key>
|
<PropertyRef Name="CodeID" />
|
<PropertyRef Name="SeqNo" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="CodeID" Type="int" Nullable="false" />
|
<Property Name="CodeName" Type="varchar" MaxLength="100" />
|
<Property Name="SeqNo" Type="int" Nullable="false" />
|
<Property Name="CodeValue" Type="varchar" MaxLength="50" Nullable="false" />
|
<Property Name="CodeDesc" Type="varchar" MaxLength="50" />
|
<Property Name="ReserveField01" Type="varchar" MaxLength="10" />
|
<Property Name="ReserveField02" Type="varchar" MaxLength="10" />
|
<Property Name="IsActived" Type="int" />
|
</EntityType>
|
<EntityType Name="SysEnvVar">
|
<Key>
|
<PropertyRef Name="CodeID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="CodeID" Type="int" Nullable="false" />
|
<Property Name="CodeName" Type="varchar" MaxLength="50" />
|
<Property Name="CodeValue" Type="varchar" MaxLength="100" />
|
<Property Name="CodeDesc" Type="varchar" MaxLength="100" />
|
<Property Name="IsActived" Type="int" />
|
<Property Name="IsVisible" Type="int" />
|
</EntityType>
|
<EntityType Name="SysFunLists">
|
<Key>
|
<PropertyRef Name="FID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="FID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="FunID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="FunName" Type="varchar" MaxLength="20" />
|
<Property Name="PFunID" Type="varchar" MaxLength="20" />
|
<Property Name="FunPath" Type="varchar" MaxLength="50" />
|
<Property Name="SortNum" Type="int" />
|
<Property Name="IsVisible" Type="int" />
|
</EntityType>
|
<EntityType Name="SysGlobalVar">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="GVID" Type="varchar" MaxLength="30" />
|
<Property Name="GVName" Type="varchar" MaxLength="50" />
|
<Property Name="GVValue" Type="varchar" MaxLength="100" />
|
<Property Name="GVDesc" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="SysRights">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="RoleID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="FunID" Type="varchar" MaxLength="20" Nullable="false" />
|
</EntityType>
|
<EntityType Name="SysRole">
|
<Key>
|
<PropertyRef Name="RoleID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="RoleID" Type="varchar" MaxLength="10" Nullable="false" />
|
<Property Name="RoleName" Type="varchar" MaxLength="20" />
|
<Property Name="IsActived" Type="int" />
|
<Property Name="IsDeleted" Type="int" />
|
<Property Name="RoleGroup" Type="int" />
|
</EntityType>
|
<EntityType Name="SysTitle">
|
<Key>
|
<PropertyRef Name="TitleID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="TitleID" Type="varchar" MaxLength="10" Nullable="false" />
|
<Property Name="TitleName" Type="varchar" MaxLength="20" />
|
<Property Name="IsActived" Type="int" />
|
<Property Name="IsDeleted" Type="int" />
|
</EntityType>
|
<EntityType Name="SysTmpt">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="TmptID" Type="varchar" MaxLength="50" Nullable="false" />
|
<Property Name="TmptName" Type="varchar" MaxLength="50" />
|
<Property Name="TmptType" Type="int" />
|
<Property Name="TmptContent" Type="text" />
|
<Property Name="LayoutType" Type="int" />
|
<Property Name="IsActived" Type="int" />
|
<Property Name="CreatedUnit" Type="varchar" MaxLength="20" />
|
<Property Name="CreatedUser" Type="varchar" MaxLength="20" />
|
</EntityType>
|
<EntityType Name="SysUnit">
|
<Key>
|
<PropertyRef Name="UnitID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="UID" Type="varchar" MaxLength="20" />
|
<Property Name="UnitID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="OUnitID" Type="varchar" MaxLength="20" />
|
<Property Name="UnitName" Type="varchar" MaxLength="30" />
|
<Property Name="Email" Type="varchar" MaxLength="60" />
|
<Property Name="ParentID" Type="varchar" MaxLength="20" />
|
<Property Name="SeqNo" Type="int" />
|
<Property Name="UAgent" Type="varchar" MaxLength="20" />
|
<Property Name="UAssembler" Type="varchar" MaxLength="20" />
|
<Property Name="IsActived" Type="int" />
|
<Property Name="IsDeleted" Type="int" />
|
<Property Name="GroupId" Type="int" />
|
<Property Name="MasterUnit" Type="varchar" MaxLength="20" />
|
</EntityType>
|
<EntityType Name="SysUser">
|
<Key>
|
<PropertyRef Name="UserID" />
|
</Key>
|
<Property Name="OID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="EmployeeID" Type="varchar" MaxLength="20" />
|
<Property Name="UserID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="UserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="Password" Type="varchar" MaxLength="20" />
|
<Property Name="Email" Type="varchar" MaxLength="60" />
|
<Property Name="TitleName" Type="varchar" MaxLength="30" />
|
<Property Name="RoleID" Type="varchar" MaxLength="20" />
|
<Property Name="UnitID" Type="varchar" MaxLength="20" />
|
<Property Name="IsRest" Type="int" />
|
<Property Name="IsLogin" Type="int" />
|
<Property Name="IsDeleted" Type="int" />
|
<Property Name="IsActived" Type="int" />
|
<Property Name="LastLoginDate" Type="datetime" />
|
<Property Name="OffTel" Type="varchar" MaxLength="20" />
|
<Property Name="HomeTel" Type="varchar" MaxLength="20" />
|
</EntityType>
|
<!--Errors Found During Generation:
|
warning 6002: The table/view 'develop.dbo.Worklist' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
|
<EntityType Name="Worklist">
|
<Key>
|
<PropertyRef Name="OID" />
|
<PropertyRef Name="currentProsID" />
|
</Key>
|
<Property Name="OID" Type="int" Nullable="false" />
|
<Property Name="currentProsID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="MsgID" Type="varchar" MaxLength="15" />
|
<Property Name="UserID" Type="varchar" MaxLength="20" />
|
<Property Name="WorkType" Type="int" />
|
<Property Name="IsTerminate" Type="int" />
|
<Property Name="CreatedDate" Type="datetime" />
|
<Property Name="CreatedUser" Type="varchar" MaxLength="20" />
|
</EntityType>
|
<!--Errors Found During Generation:
|
warning 6002: The table/view 'develop.dbo.AssignToMail' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
|
<EntityType Name="AssignToMail">
|
<Key>
|
<PropertyRef Name="OID" />
|
<PropertyRef Name="MsgID" />
|
<PropertyRef Name="currentProsID" />
|
<PropertyRef Name="NoReq" />
|
<PropertyRef Name="Expr1" />
|
<PropertyRef Name="Expr2" />
|
<PropertyRef Name="Expr3" />
|
<PropertyRef Name="Email" />
|
<PropertyRef Name="CodeID" />
|
</Key>
|
<Property Name="OID" Type="int" Nullable="false" />
|
<Property Name="MsgID" Type="varchar" MaxLength="15" Nullable="false" />
|
<Property Name="MsgNo" Type="varchar" MaxLength="15" />
|
<Property Name="currentProsID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="parentProsID" Type="varchar" MaxLength="20" />
|
<Property Name="FromUnit" Type="varchar" MaxLength="20" />
|
<Property Name="ToUnit" Type="varchar" MaxLength="20" />
|
<Property Name="ToUser" Type="varchar" MaxLength="20" />
|
<Property Name="DispatchedNum" Type="int" />
|
<Property Name="FinishedNum" Type="int" />
|
<Property Name="Note" Type="text" />
|
<Property Name="Response" Type="text" />
|
<Property Name="AttachID" Type="varchar" MaxLength="255" />
|
<Property Name="Version" Type="int" />
|
<Property Name="MsgState" Type="int" />
|
<Property Name="PressCount" Type="int" />
|
<Property Name="UpperRcvDate" Type="datetime" />
|
<Property Name="UpperDspDate" Type="datetime" />
|
<Property Name="SelfReceivedDate" Type="datetime" />
|
<Property Name="SelfExpiredDate" Type="datetime" />
|
<Property Name="ExpiredDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="SelfDonedDate" Type="datetime" />
|
<Property Name="WorkDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="ClosedDate" Type="datetime" />
|
<Property Name="RootWorkDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="SelfOverdueDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="IsMaster" Type="int" />
|
<Property Name="IsAssembled" Type="int" />
|
<Property Name="IsApproved" Type="int" />
|
<Property Name="IsRejected" Type="int" />
|
<Property Name="IsExpired" Type="int" />
|
<Property Name="IsDeleted" Type="int" />
|
<Property Name="IsQueued" Type="int" />
|
<Property Name="ReserveField01" Type="varchar" MaxLength="100" />
|
<Property Name="ReserveField02" Type="varchar" MaxLength="100" />
|
<Property Name="NoReq" Type="varchar" MaxLength="1" Nullable="false" />
|
<Property Name="Expr1" Type="int" Nullable="false" />
|
<Property Name="Expr2" Type="varchar" MaxLength="15" Nullable="false" />
|
<Property Name="Expr3" Type="varchar" MaxLength="15" Nullable="false" />
|
<Property Name="MID" Type="int" />
|
<Property Name="MailorAcct" Type="varchar" MaxLength="50" />
|
<Property Name="MailorDomain" Type="varchar" MaxLength="50" />
|
<Property Name="MsgSubject" Type="varchar" MaxLength="512" />
|
<Property Name="MsgContent" Type="text" />
|
<Property Name="Expr4" Type="varchar" MaxLength="255" />
|
<Property Name="MsgAttr1" Type="varchar" MaxLength="10" />
|
<Property Name="MsgAttr2" Type="varchar" MaxLength="10" />
|
<Property Name="MsgAttr3" Type="varchar" MaxLength="10" />
|
<Property Name="MsgAttr4" Type="varchar" MaxLength="10" />
|
<Property Name="MsgAttr5" Type="varchar" MaxLength="20" />
|
<Property Name="Expr5" Type="int" />
|
<Property Name="IsSatSvy" Type="int" />
|
<Property Name="IsHaveRefMail" Type="int" />
|
<Property Name="AllowedDate" Type="datetime" />
|
<Property Name="UniReply" Type="int" />
|
<Property Name="CreatedUser" Type="varchar" MaxLength="20" />
|
<Property Name="CreatedDate" Type="datetime" />
|
<Property Name="LastMaintUser" Type="datetime" />
|
<Property Name="LastMaintDate" Type="varchar" MaxLength="20" />
|
<Property Name="IdentityCatalog" Type="varchar" MaxLength="40" />
|
<Property Name="SatSvyKey" Type="varchar" MaxLength="36" />
|
<Property Name="MailorID" Type="varchar" MaxLength="10" />
|
<Property Name="MailorName" Type="varchar" MaxLength="100" />
|
<Property Name="IDNum" Type="varchar" MaxLength="10" />
|
<Property Name="Email" Type="varchar" MaxLength="100" Nullable="false" />
|
<Property Name="AliasEmail" Type="varchar" MaxLength="100" />
|
<Property Name="MailorTel" Type="varchar" MaxLength="40" />
|
<Property Name="MailorAddr" Type="nvarchar" MaxLength="100" />
|
<Property Name="Mailcount" Type="int" />
|
<Property Name="Sex" Type="int" />
|
<Property Name="PostCode" Type="varchar" MaxLength="3" />
|
<Property Name="City" Type="varchar" MaxLength="20" />
|
<Property Name="edubackground" Type="int" />
|
<Property Name="Mailorfex" Type="varchar" MaxLength="15" />
|
<Property Name="Age" Type="int" />
|
<Property Name="Career" Type="int" />
|
<Property Name="Occupation" Type="varchar" MaxLength="20" />
|
<Property Name="IsActived" Type="tinyint" />
|
<Property Name="PowerNo" Type="varchar" MaxLength="20" />
|
<Property Name="FileCombinNo" Type="varchar" MaxLength="20" />
|
<Property Name="FileNo" Type="varchar" MaxLength="20" />
|
<Property Name="FileCancelReason" Type="varchar" MaxLength="100" />
|
<Property Name="FileCheckUnit" Type="varchar" MaxLength="20" />
|
<Property Name="FileCheckDate" Type="datetime" />
|
<Property Name="FileReceivedDate" Type="datetime" />
|
<Property Name="FileMajorUnit" Type="varchar" MaxLength="20" />
|
<Property Name="FileMajorID" Type="varchar" MaxLength="20" />
|
<Property Name="FileMajorUser" Type="varchar" MaxLength="20" />
|
<Property Name="FilePros" Type="varchar" MaxLength="20" />
|
<Property Name="StateCatalog" Type="varchar" MaxLength="20" />
|
<Property Name="UnitName" Type="varchar" MaxLength="50" />
|
<Property Name="CodeDesc" Type="varchar" MaxLength="50" />
|
<Property Name="CodeID" Type="int" Nullable="false" />
|
<Property Name="IsStatement" Type="int" />
|
<Property Name="IsReAssign" Type="int" />
|
<Property Name="IsCancel" Type="int" />
|
<Property Name="IsCombin" Type="int" />
|
<Property Name="CateName" Type="varchar" MaxLength="50" />
|
<Property Name="MailClass" Type="varchar" MaxLength="50" />
|
<Property Name="IsSnReply" Type="int" />
|
<Property Name="SnToUnit" Type="varchar" MaxLength="20" />
|
<Property Name="MailState" Type="varchar" MaxLength="50" />
|
<Property Name="ReAssign" Type="text" />
|
</EntityType>
|
<!--Errors Found During Generation:
|
warning 6002: The table/view 'develop.dbo.FeaturesResult' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
|
<EntityType Name="FeaturesResult">
|
<Key>
|
<PropertyRef Name="currentProsID" />
|
</Key>
|
<Property Name="MsgNo" Type="varchar" MaxLength="15" />
|
<Property Name="MID" Type="int" />
|
<Property Name="MailorName" Type="nvarchar" MaxLength="100" />
|
<Property Name="Password" Type="nvarchar" MaxLength="100" />
|
<Property Name="Email" Type="varchar" MaxLength="100" />
|
<Property Name="CreatedDate" Type="datetime" />
|
<Property Name="AllowedDate" Type="datetime" />
|
<Property Name="UniReply" Type="int" />
|
<Property Name="MsgSubject" Type="varchar" MaxLength="512" />
|
<Property Name="MsgContent" Type="text" />
|
<Property Name="AttachID" Type="varchar" MaxLength="255" />
|
<Property Name="FromUnit" Type="varchar" MaxLength="20" />
|
<Property Name="ToUnit" Type="varchar" MaxLength="20" />
|
<Property Name="currentProsID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="MsgID" Type="varchar" MaxLength="15" />
|
<Property Name="parentProsID" Type="varchar" MaxLength="20" />
|
<Property Name="Response" Type="text" />
|
<Property Name="MsgState" Type="int" />
|
<Property Name="CodeDesc" Type="varchar" MaxLength="50" />
|
<Property Name="CateName" Type="varchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="int" />
|
<Property Name="IsExpired" Type="int" />
|
<Property Name="SatSvyKey" Type="varchar" MaxLength="36" />
|
<Property Name="IsSatSvy" Type="int" />
|
<Property Name="UnitName" Type="varchar" MaxLength="50" />
|
<Property Name="IsApproved" Type="int" />
|
<Property Name="IsMaster" Type="int" />
|
<Property Name="IsAssembled" Type="int" />
|
<Property Name="IsRejected" Type="int" />
|
<Property Name="IsQueued" Type="int" />
|
<Property Name="IsReAssign" Type="int" />
|
<Property Name="FileNo" Type="varchar" MaxLength="20" />
|
<Property Name="MailFrom" Type="varchar" MaxLength="50" />
|
<Property Name="MailClass" Type="varchar" MaxLength="50" />
|
<Property Name="SelfReceivedDate" Type="datetime" />
|
<Property Name="ClosedDate" Type="datetime" />
|
<Property Name="SelfDonedDate" Type="datetime" />
|
<Property Name="UpperDspDate" Type="datetime" />
|
<Property Name="SelfOverdueDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="RootWorkDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="WorkDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="ExpiredDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="SelfExpiredDate" Type="datetime" />
|
<Property Name="UpperRcvDate" Type="datetime" />
|
<Property Name="Expr1" Type="varchar" MaxLength="255" />
|
<Property Name="Note" Type="text" />
|
<Property Name="FileCombinNo" Type="varchar" MaxLength="20" />
|
<Property Name="FileCancelReason" Type="varchar" MaxLength="100" />
|
<Property Name="IsCombin" Type="int" />
|
<Property Name="IsCancel" Type="int" />
|
<Property Name="IsStatement" Type="int" />
|
<Property Name="StateCatalog" Type="varchar" MaxLength="20" />
|
<Property Name="IsChecked" Type="int" />
|
<Property Name="MailorTel" Type="varchar" MaxLength="40" />
|
<Property Name="MailorAddr" Type="nvarchar" MaxLength="100" />
|
<Property Name="PowerNo" Type="nvarchar" MaxLength="50" />
|
<Property Name="FileMajorUnit" Type="varchar" MaxLength="20" />
|
<Property Name="FileMajorUser" Type="varchar" MaxLength="20" />
|
<Property Name="FileMajorID" Type="varchar" MaxLength="20" />
|
<Property Name="FileCheckUnit" Type="varchar" MaxLength="20" />
|
<Property Name="FileCheckDate" Type="datetime" />
|
<Property Name="FileReceivedDate" Type="datetime" />
|
<Property Name="FilePros" Type="varchar" MaxLength="20" />
|
</EntityType>
|
<!--Errors Found During Generation:
|
warning 6002: The table/view 'develop.dbo.MailProcess' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
|
<EntityType Name="MailProcess">
|
<Key>
|
<PropertyRef Name="MsgID" />
|
<PropertyRef Name="MsgNo" />
|
<PropertyRef Name="currentProsID" />
|
<PropertyRef Name="Email" />
|
</Key>
|
<Property Name="ToUnit" Type="varchar" MaxLength="20" />
|
<Property Name="MsgID" Type="varchar" MaxLength="15" Nullable="false" />
|
<Property Name="MsgNo" Type="varchar" MaxLength="15" Nullable="false" />
|
<Property Name="MID" Type="int" />
|
<Property Name="MailorAcct" Type="varchar" MaxLength="50" />
|
<Property Name="MailorDomain" Type="varchar" MaxLength="50" />
|
<Property Name="MsgSubject" Type="varchar" MaxLength="512" />
|
<Property Name="MsgContent" Type="text" />
|
<Property Name="AttachID" Type="varchar" MaxLength="255" />
|
<Property Name="AllowedDate" Type="datetime" />
|
<Property Name="CreatedDate" Type="datetime" />
|
<Property Name="currentProsID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="parentProsID" Type="varchar" MaxLength="20" />
|
<Property Name="Note" Type="text" />
|
<Property Name="Response" Type="text" />
|
<Property Name="MsgState" Type="int" />
|
<Property Name="UpperRcvDate" Type="datetime" />
|
<Property Name="UpperDspDate" Type="datetime" />
|
<Property Name="SelfReceivedDate" Type="datetime" />
|
<Property Name="SelfExpiredDate" Type="datetime" />
|
<Property Name="ExpiredDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="SelfDonedDate" Type="datetime" />
|
<Property Name="WorkDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="ClosedDate" Type="datetime" />
|
<Property Name="RootWorkDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="SelfOverdueDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="ReserveField01" Type="varchar" MaxLength="100" />
|
<Property Name="ReserveField02" Type="varchar" MaxLength="100" />
|
<Property Name="MsgAttr4" Type="varchar" MaxLength="10" />
|
<Property Name="UnitName" Type="varchar" MaxLength="50" />
|
<Property Name="MailorName" Type="varchar" MaxLength="100" />
|
<Property Name="Email" Type="varchar" MaxLength="100" Nullable="false" />
|
<Property Name="MsgAttr1" Type="varchar" MaxLength="10" />
|
<Property Name="MailorTel" Type="varchar" MaxLength="30" />
|
<Property Name="MailorAddr" Type="varchar" MaxLength="100" />
|
<Property Name="Mailcount" Type="int" />
|
<Property Name="Sex" Type="int" />
|
<Property Name="City" Type="varchar" MaxLength="20" />
|
<Property Name="PostCode" Type="varchar" MaxLength="3" />
|
<Property Name="edubackground" Type="int" />
|
<Property Name="Mailorfex" Type="varchar" MaxLength="15" />
|
<Property Name="Age" Type="int" />
|
<Property Name="Career" Type="int" />
|
<Property Name="Occupation" Type="varchar" MaxLength="20" />
|
<Property Name="PowerNo" Type="varchar" MaxLength="20" />
|
<Property Name="IDNum" Type="varchar" MaxLength="10" />
|
<Property Name="LastMaintUser" Type="datetime" />
|
<Property Name="LastMaintDate" Type="varchar" MaxLength="20" />
|
<Property Name="CreatedUser" Type="varchar" MaxLength="20" />
|
<Property Name="IsReAssign" Type="int" />
|
<Property Name="StateCatalog" Type="varchar" MaxLength="20" />
|
<Property Name="SatSvyKey" Type="varchar" MaxLength="36" />
|
<Property Name="IsMaster" Type="int" />
|
<Property Name="IsAssembled" Type="int" />
|
<Property Name="IsApproved" Type="int" />
|
<Property Name="IsRejected" Type="int" />
|
<Property Name="IsExpired" Type="int" />
|
<Property Name="IsDeleted" Type="int" />
|
<Property Name="IsQueued" Type="int" />
|
</EntityType>
|
<!--Errors Found During Generation:
|
warning 6002: The table/view 'develop.dbo.PieChart1' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
|
<!--Errors Found During Generation:
|
warning 6002: The table/view 'develop.dbo.PieChart2' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
|
<EntityType Name="PieChart2">
|
<Key>
|
<PropertyRef Name="MsgID" />
|
<PropertyRef Name="MsgNo" />
|
<PropertyRef Name="CateID" />
|
<PropertyRef Name="UnitID" />
|
<PropertyRef Name="currentProsID" />
|
</Key>
|
<Property Name="MsgID" Type="varchar" MaxLength="15" Nullable="false" />
|
<Property Name="MsgNo" Type="varchar" MaxLength="15" Nullable="false" />
|
<Property Name="MID" Type="int" />
|
<Property Name="UnitName" Type="varchar" MaxLength="30" />
|
<Property Name="CateName" Type="varchar" MaxLength="50" />
|
<Property Name="CateID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="IsActived" Type="int" />
|
<Property Name="CreatedDate" Type="datetime" />
|
<Property Name="AllowedDate" Type="datetime" />
|
<Property Name="UnitID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="currentProsID" Type="varchar" MaxLength="20" Nullable="false" />
|
<Property Name="parentProsID" Type="varchar" MaxLength="20" />
|
<Property Name="FromUnit" Type="varchar" MaxLength="20" />
|
<Property Name="ToUser" Type="varchar" MaxLength="20" />
|
<Property Name="DispatchedNum" Type="int" />
|
<Property Name="FinishedNum" Type="int" />
|
<Property Name="MsgState" Type="int" />
|
<Property Name="SelfReceivedDate" Type="datetime" />
|
<Property Name="SelfExpiredDate" Type="datetime" />
|
<Property Name="ExpiredDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="SelfDonedDate" Type="datetime" />
|
<Property Name="WorkDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="ClosedDate" Type="datetime" />
|
<Property Name="RootWorkDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="SelfOverdueDays" Type="numeric" Precision="18" Scale="1" />
|
<Property Name="ReserveField01" Type="varchar" MaxLength="100" />
|
<Property Name="IsMaster" Type="int" />
|
<Property Name="IsAssembled" Type="int" />
|
<Property Name="ToUnit" Type="varchar" MaxLength="20" />
|
<Property Name="maqa0" Type="varchar" MaxLength="100" />
|
<Property Name="maqa1" Type="varchar" MaxLength="255" />
|
<Property Name="LastMaintDate" Type="datetime" />
|
<Property Name="maqa2" Type="varchar" MaxLength="255" />
|
<Property Name="maqa3" Type="varchar" MaxLength="255" />
|
</EntityType>
|
<EntityContainer Name="developModelStoreContainer">
|
<EntitySet Name="AttachInfo" EntityType="Self.AttachInfo" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="Calendar" EntityType="Self.Calendar" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="DocumentNo" EntityType="Self.DocumentNo" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="DocumentNoTemplate" EntityType="Self.DocumentNoTemplate" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="dtproperties" EntityType="Self.dtproperties" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="FAQ" EntityType="Self.FAQ" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="Holiday" EntityType="Self.Holiday" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="LogDBMonitor" EntityType="Self.LogDBMonitor" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="LogMailAssign" EntityType="Self.LogMailAssign" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="LogTransMail" EntityType="Self.LogTransMail" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="MailAssign" EntityType="Self.MailAssign" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="MailCatelog" EntityType="Self.MailCatelog" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="Mailor" EntityType="Self.Mailor" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="NewMail" EntityType="Self.NewMail" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="RefMail" EntityType="Self.RefMail" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="REP_01_M" EntityType="Self.REP_01_M" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="REP_02_M" EntityType="Self.REP_02_M" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="REP_03_M" EntityType="Self.REP_03_M" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="REP_04_M" EntityType="Self.REP_04_M" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SatSvy" EntityType="Self.SatSvy" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SendQueue" EntityType="Self.SendQueue" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SYS_AREA_M" EntityType="Self.SYS_AREA_M" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SYS_FUN_LIST_L" EntityType="Self.SYS_FUN_LIST_L" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SYS_LOG_L" EntityType="Self.SYS_LOG_L" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SYS_RIGHTS_X" EntityType="Self.SYS_RIGHTS_X" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SYS_ROLE_M" EntityType="Self.SYS_ROLE_M" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SYS_UNIT_M" EntityType="Self.SYS_UNIT_M" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SYS_UNIT_O_M" EntityType="Self.SYS_UNIT_O_M" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SYS_USER_M" EntityType="Self.SYS_USER_M" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SysCodeTable" EntityType="Self.SysCodeTable" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SysEnvVar" EntityType="Self.SysEnvVar" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SysFunLists" EntityType="Self.SysFunLists" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SysGlobalVar" EntityType="Self.SysGlobalVar" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SysRights" EntityType="Self.SysRights" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SysRole" EntityType="Self.SysRole" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SysTitle" EntityType="Self.SysTitle" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SysTmpt" EntityType="Self.SysTmpt" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SysUnit" EntityType="Self.SysUnit" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SysUser" EntityType="Self.SysUser" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="SendQueue_Temp" EntityType="Self.SendQueue_Temp" store:Type="Tables" store:Schema="dbo">
|
<DefiningQuery>SELECT
|
[SendQueue_Temp].[OID] AS [OID],
|
[SendQueue_Temp].[QueueID] AS [QueueID],
|
[SendQueue_Temp].[Priority] AS [Priority],
|
[SendQueue_Temp].[TmptXML] AS [TmptXML],
|
[SendQueue_Temp].[AttachID] AS [AttachID],
|
[SendQueue_Temp].[QueueType] AS [QueueType],
|
[SendQueue_Temp].[DeliveryDate] AS [DeliveryDate],
|
[SendQueue_Temp].[CreatedDate] AS [CreatedDate],
|
[SendQueue_Temp].[FinishedDate] AS [FinishedDate]
|
FROM [dbo].[SendQueue_Temp] AS [SendQueue_Temp]</DefiningQuery>
|
</EntitySet>
|
<EntitySet Name="Worklist" EntityType="Self.Worklist" store:Type="Tables" store:Schema="dbo">
|
<DefiningQuery>SELECT
|
[Worklist].[OID] AS [OID],
|
[Worklist].[currentProsID] AS [currentProsID],
|
[Worklist].[MsgID] AS [MsgID],
|
[Worklist].[UserID] AS [UserID],
|
[Worklist].[WorkType] AS [WorkType],
|
[Worklist].[IsTerminate] AS [IsTerminate],
|
[Worklist].[CreatedDate] AS [CreatedDate],
|
[Worklist].[CreatedUser] AS [CreatedUser]
|
FROM [dbo].[Worklist] AS [Worklist]</DefiningQuery>
|
</EntitySet>
|
<EntitySet Name="AssignToMail" EntityType="Self.AssignToMail" store:Type="Views" store:Schema="dbo">
|
<DefiningQuery>SELECT
|
[AssignToMail].[OID] AS [OID],
|
[AssignToMail].[MsgID] AS [MsgID],
|
[AssignToMail].[MsgNo] AS [MsgNo],
|
[AssignToMail].[currentProsID] AS [currentProsID],
|
[AssignToMail].[parentProsID] AS [parentProsID],
|
[AssignToMail].[FromUnit] AS [FromUnit],
|
[AssignToMail].[ToUnit] AS [ToUnit],
|
[AssignToMail].[ToUser] AS [ToUser],
|
[AssignToMail].[DispatchedNum] AS [DispatchedNum],
|
[AssignToMail].[FinishedNum] AS [FinishedNum],
|
[AssignToMail].[Note] AS [Note],
|
[AssignToMail].[Response] AS [Response],
|
[AssignToMail].[AttachID] AS [AttachID],
|
[AssignToMail].[Version] AS [Version],
|
[AssignToMail].[MsgState] AS [MsgState],
|
[AssignToMail].[PressCount] AS [PressCount],
|
[AssignToMail].[UpperRcvDate] AS [UpperRcvDate],
|
[AssignToMail].[UpperDspDate] AS [UpperDspDate],
|
[AssignToMail].[SelfReceivedDate] AS [SelfReceivedDate],
|
[AssignToMail].[SelfExpiredDate] AS [SelfExpiredDate],
|
[AssignToMail].[ExpiredDays] AS [ExpiredDays],
|
[AssignToMail].[SelfDonedDate] AS [SelfDonedDate],
|
[AssignToMail].[WorkDays] AS [WorkDays],
|
[AssignToMail].[ClosedDate] AS [ClosedDate],
|
[AssignToMail].[RootWorkDays] AS [RootWorkDays],
|
[AssignToMail].[SelfOverdueDays] AS [SelfOverdueDays],
|
[AssignToMail].[IsMaster] AS [IsMaster],
|
[AssignToMail].[IsAssembled] AS [IsAssembled],
|
[AssignToMail].[IsApproved] AS [IsApproved],
|
[AssignToMail].[IsRejected] AS [IsRejected],
|
[AssignToMail].[IsExpired] AS [IsExpired],
|
[AssignToMail].[IsDeleted] AS [IsDeleted],
|
[AssignToMail].[IsQueued] AS [IsQueued],
|
[AssignToMail].[ReserveField01] AS [ReserveField01],
|
[AssignToMail].[ReserveField02] AS [ReserveField02],
|
[AssignToMail].[NoReq] AS [NoReq],
|
[AssignToMail].[Expr1] AS [Expr1],
|
[AssignToMail].[Expr2] AS [Expr2],
|
[AssignToMail].[Expr3] AS [Expr3],
|
[AssignToMail].[MID] AS [MID],
|
[AssignToMail].[MailorAcct] AS [MailorAcct],
|
[AssignToMail].[MailorDomain] AS [MailorDomain],
|
[AssignToMail].[MsgSubject] AS [MsgSubject],
|
[AssignToMail].[MsgContent] AS [MsgContent],
|
[AssignToMail].[Expr4] AS [Expr4],
|
[AssignToMail].[MsgAttr1] AS [MsgAttr1],
|
[AssignToMail].[MsgAttr2] AS [MsgAttr2],
|
[AssignToMail].[MsgAttr3] AS [MsgAttr3],
|
[AssignToMail].[MsgAttr4] AS [MsgAttr4],
|
[AssignToMail].[MsgAttr5] AS [MsgAttr5],
|
[AssignToMail].[Expr5] AS [Expr5],
|
[AssignToMail].[IsSatSvy] AS [IsSatSvy],
|
[AssignToMail].[IsHaveRefMail] AS [IsHaveRefMail],
|
[AssignToMail].[AllowedDate] AS [AllowedDate],
|
[AssignToMail].[UniReply] AS [UniReply],
|
[AssignToMail].[CreatedUser] AS [CreatedUser],
|
[AssignToMail].[CreatedDate] AS [CreatedDate],
|
[AssignToMail].[LastMaintUser] AS [LastMaintUser],
|
[AssignToMail].[LastMaintDate] AS [LastMaintDate],
|
[AssignToMail].[IdentityCatalog] AS [IdentityCatalog],
|
[AssignToMail].[SatSvyKey] AS [SatSvyKey],
|
[AssignToMail].[MailorID] AS [MailorID],
|
[AssignToMail].[MailorName] AS [MailorName],
|
[AssignToMail].[IDNum] AS [IDNum],
|
[AssignToMail].[Email] AS [Email],
|
[AssignToMail].[AliasEmail] AS [AliasEmail],
|
[AssignToMail].[MailorTel] AS [MailorTel],
|
[AssignToMail].[MailorAddr] AS [MailorAddr],
|
[AssignToMail].[Mailcount] AS [Mailcount],
|
[AssignToMail].[Sex] AS [Sex],
|
[AssignToMail].[PostCode] AS [PostCode],
|
[AssignToMail].[City] AS [City],
|
[AssignToMail].[edubackground] AS [edubackground],
|
[AssignToMail].[Mailorfex] AS [Mailorfex],
|
[AssignToMail].[Age] AS [Age],
|
[AssignToMail].[Career] AS [Career],
|
[AssignToMail].[Occupation] AS [Occupation],
|
[AssignToMail].[IsActived] AS [IsActived],
|
[AssignToMail].[PowerNo] AS [PowerNo],
|
[AssignToMail].[FileCombinNo] AS [FileCombinNo],
|
[AssignToMail].[FileNo] AS [FileNo],
|
[AssignToMail].[FileCancelReason] AS [FileCancelReason],
|
[AssignToMail].[FileCheckUnit] AS [FileCheckUnit],
|
[AssignToMail].[FileCheckDate] AS [FileCheckDate],
|
[AssignToMail].[FileReceivedDate] AS [FileReceivedDate],
|
[AssignToMail].[FileMajorUnit] AS [FileMajorUnit],
|
[AssignToMail].[FileMajorID] AS [FileMajorID],
|
[AssignToMail].[FileMajorUser] AS [FileMajorUser],
|
[AssignToMail].[FilePros] AS [FilePros],
|
[AssignToMail].[StateCatalog] AS [StateCatalog],
|
[AssignToMail].[UnitName] AS [UnitName],
|
[AssignToMail].[CodeDesc] AS [CodeDesc],
|
[AssignToMail].[CodeID] AS [CodeID],
|
[AssignToMail].[IsStatement] AS [IsStatement],
|
[AssignToMail].[IsReAssign] AS [IsReAssign],
|
[AssignToMail].[IsCancel] AS [IsCancel],
|
[AssignToMail].[IsCombin] AS [IsCombin],
|
[AssignToMail].[CateName] AS [CateName],
|
[AssignToMail].[MailClass] AS [MailClass],
|
[AssignToMail].[IsSnReply] AS [IsSnReply],
|
[AssignToMail].[SnToUnit] AS [SnToUnit],
|
[AssignToMail].[MailState] AS [MailState],
|
[AssignToMail].[ReAssign] AS [ReAssign]
|
FROM [dbo].[AssignToMail] AS [AssignToMail]</DefiningQuery>
|
</EntitySet>
|
<EntitySet Name="FeaturesResult" EntityType="Self.FeaturesResult" store:Type="Views" store:Schema="dbo">
|
<DefiningQuery>SELECT
|
[FeaturesResult].[MsgNo] AS [MsgNo],
|
[FeaturesResult].[MID] AS [MID],
|
[FeaturesResult].[MailorName] AS [MailorName],
|
[FeaturesResult].[Password] AS [Password],
|
[FeaturesResult].[Email] AS [Email],
|
[FeaturesResult].[CreatedDate] AS [CreatedDate],
|
[FeaturesResult].[AllowedDate] AS [AllowedDate],
|
[FeaturesResult].[UniReply] AS [UniReply],
|
[FeaturesResult].[MsgSubject] AS [MsgSubject],
|
[FeaturesResult].[MsgContent] AS [MsgContent],
|
[FeaturesResult].[AttachID] AS [AttachID],
|
[FeaturesResult].[FromUnit] AS [FromUnit],
|
[FeaturesResult].[ToUnit] AS [ToUnit],
|
[FeaturesResult].[currentProsID] AS [currentProsID],
|
[FeaturesResult].[MsgID] AS [MsgID],
|
[FeaturesResult].[parentProsID] AS [parentProsID],
|
[FeaturesResult].[Response] AS [Response],
|
[FeaturesResult].[MsgState] AS [MsgState],
|
[FeaturesResult].[CodeDesc] AS [CodeDesc],
|
[FeaturesResult].[CateName] AS [CateName],
|
[FeaturesResult].[IsDeleted] AS [IsDeleted],
|
[FeaturesResult].[IsExpired] AS [IsExpired],
|
[FeaturesResult].[SatSvyKey] AS [SatSvyKey],
|
[FeaturesResult].[IsSatSvy] AS [IsSatSvy],
|
[FeaturesResult].[UnitName] AS [UnitName],
|
[FeaturesResult].[IsApproved] AS [IsApproved],
|
[FeaturesResult].[IsMaster] AS [IsMaster],
|
[FeaturesResult].[IsAssembled] AS [IsAssembled],
|
[FeaturesResult].[IsRejected] AS [IsRejected],
|
[FeaturesResult].[IsQueued] AS [IsQueued],
|
[FeaturesResult].[IsReAssign] AS [IsReAssign],
|
[FeaturesResult].[FileNo] AS [FileNo],
|
[FeaturesResult].[MailFrom] AS [MailFrom],
|
[FeaturesResult].[MailClass] AS [MailClass],
|
[FeaturesResult].[SelfReceivedDate] AS [SelfReceivedDate],
|
[FeaturesResult].[ClosedDate] AS [ClosedDate],
|
[FeaturesResult].[SelfDonedDate] AS [SelfDonedDate],
|
[FeaturesResult].[UpperDspDate] AS [UpperDspDate],
|
[FeaturesResult].[SelfOverdueDays] AS [SelfOverdueDays],
|
[FeaturesResult].[RootWorkDays] AS [RootWorkDays],
|
[FeaturesResult].[WorkDays] AS [WorkDays],
|
[FeaturesResult].[ExpiredDays] AS [ExpiredDays],
|
[FeaturesResult].[SelfExpiredDate] AS [SelfExpiredDate],
|
[FeaturesResult].[UpperRcvDate] AS [UpperRcvDate],
|
[FeaturesResult].[Expr1] AS [Expr1],
|
[FeaturesResult].[Note] AS [Note],
|
[FeaturesResult].[FileCombinNo] AS [FileCombinNo],
|
[FeaturesResult].[FileCancelReason] AS [FileCancelReason],
|
[FeaturesResult].[IsCombin] AS [IsCombin],
|
[FeaturesResult].[IsCancel] AS [IsCancel],
|
[FeaturesResult].[IsStatement] AS [IsStatement],
|
[FeaturesResult].[StateCatalog] AS [StateCatalog],
|
[FeaturesResult].[IsChecked] AS [IsChecked],
|
[FeaturesResult].[MailorTel] AS [MailorTel],
|
[FeaturesResult].[MailorAddr] AS [MailorAddr],
|
[FeaturesResult].[PowerNo] AS [PowerNo],
|
[FeaturesResult].[FileMajorUnit] AS [FileMajorUnit],
|
[FeaturesResult].[FileMajorUser] AS [FileMajorUser],
|
[FeaturesResult].[FileMajorID] AS [FileMajorID],
|
[FeaturesResult].[FileCheckUnit] AS [FileCheckUnit],
|
[FeaturesResult].[FileCheckDate] AS [FileCheckDate],
|
[FeaturesResult].[FileReceivedDate] AS [FileReceivedDate],
|
[FeaturesResult].[FilePros] AS [FilePros]
|
FROM [dbo].[FeaturesResult] AS [FeaturesResult]</DefiningQuery>
|
</EntitySet>
|
<EntitySet Name="MailProcess" EntityType="Self.MailProcess" store:Type="Views" store:Schema="dbo">
|
<DefiningQuery>SELECT
|
[MailProcess].[ToUnit] AS [ToUnit],
|
[MailProcess].[MsgID] AS [MsgID],
|
[MailProcess].[MsgNo] AS [MsgNo],
|
[MailProcess].[MID] AS [MID],
|
[MailProcess].[MailorAcct] AS [MailorAcct],
|
[MailProcess].[MailorDomain] AS [MailorDomain],
|
[MailProcess].[MsgSubject] AS [MsgSubject],
|
[MailProcess].[MsgContent] AS [MsgContent],
|
[MailProcess].[AttachID] AS [AttachID],
|
[MailProcess].[AllowedDate] AS [AllowedDate],
|
[MailProcess].[CreatedDate] AS [CreatedDate],
|
[MailProcess].[currentProsID] AS [currentProsID],
|
[MailProcess].[parentProsID] AS [parentProsID],
|
[MailProcess].[Note] AS [Note],
|
[MailProcess].[Response] AS [Response],
|
[MailProcess].[MsgState] AS [MsgState],
|
[MailProcess].[UpperRcvDate] AS [UpperRcvDate],
|
[MailProcess].[UpperDspDate] AS [UpperDspDate],
|
[MailProcess].[SelfReceivedDate] AS [SelfReceivedDate],
|
[MailProcess].[SelfExpiredDate] AS [SelfExpiredDate],
|
[MailProcess].[ExpiredDays] AS [ExpiredDays],
|
[MailProcess].[SelfDonedDate] AS [SelfDonedDate],
|
[MailProcess].[WorkDays] AS [WorkDays],
|
[MailProcess].[ClosedDate] AS [ClosedDate],
|
[MailProcess].[RootWorkDays] AS [RootWorkDays],
|
[MailProcess].[SelfOverdueDays] AS [SelfOverdueDays],
|
[MailProcess].[ReserveField01] AS [ReserveField01],
|
[MailProcess].[ReserveField02] AS [ReserveField02],
|
[MailProcess].[MsgAttr4] AS [MsgAttr4],
|
[MailProcess].[UnitName] AS [UnitName],
|
[MailProcess].[MailorName] AS [MailorName],
|
[MailProcess].[Email] AS [Email],
|
[MailProcess].[MsgAttr1] AS [MsgAttr1],
|
[MailProcess].[MailorTel] AS [MailorTel],
|
[MailProcess].[MailorAddr] AS [MailorAddr],
|
[MailProcess].[Mailcount] AS [Mailcount],
|
[MailProcess].[Sex] AS [Sex],
|
[MailProcess].[City] AS [City],
|
[MailProcess].[PostCode] AS [PostCode],
|
[MailProcess].[edubackground] AS [edubackground],
|
[MailProcess].[Mailorfex] AS [Mailorfex],
|
[MailProcess].[Age] AS [Age],
|
[MailProcess].[Career] AS [Career],
|
[MailProcess].[Occupation] AS [Occupation],
|
[MailProcess].[PowerNo] AS [PowerNo],
|
[MailProcess].[IDNum] AS [IDNum],
|
[MailProcess].[LastMaintUser] AS [LastMaintUser],
|
[MailProcess].[LastMaintDate] AS [LastMaintDate],
|
[MailProcess].[CreatedUser] AS [CreatedUser],
|
[MailProcess].[IsReAssign] AS [IsReAssign],
|
[MailProcess].[StateCatalog] AS [StateCatalog],
|
[MailProcess].[SatSvyKey] AS [SatSvyKey],
|
[MailProcess].[IsMaster] AS [IsMaster],
|
[MailProcess].[IsAssembled] AS [IsAssembled],
|
[MailProcess].[IsApproved] AS [IsApproved],
|
[MailProcess].[IsRejected] AS [IsRejected],
|
[MailProcess].[IsExpired] AS [IsExpired],
|
[MailProcess].[IsDeleted] AS [IsDeleted],
|
[MailProcess].[IsQueued] AS [IsQueued]
|
FROM [dbo].[MailProcess] AS [MailProcess]</DefiningQuery>
|
</EntitySet>
|
<EntitySet Name="PieChart2" EntityType="Self.PieChart2" store:Type="Views" store:Schema="dbo">
|
<DefiningQuery>SELECT
|
[PieChart2].[MsgID] AS [MsgID],
|
[PieChart2].[MsgNo] AS [MsgNo],
|
[PieChart2].[MID] AS [MID],
|
[PieChart2].[UnitName] AS [UnitName],
|
[PieChart2].[CateName] AS [CateName],
|
[PieChart2].[CateID] AS [CateID],
|
[PieChart2].[IsActived] AS [IsActived],
|
[PieChart2].[CreatedDate] AS [CreatedDate],
|
[PieChart2].[AllowedDate] AS [AllowedDate],
|
[PieChart2].[UnitID] AS [UnitID],
|
[PieChart2].[currentProsID] AS [currentProsID],
|
[PieChart2].[parentProsID] AS [parentProsID],
|
[PieChart2].[FromUnit] AS [FromUnit],
|
[PieChart2].[ToUser] AS [ToUser],
|
[PieChart2].[DispatchedNum] AS [DispatchedNum],
|
[PieChart2].[FinishedNum] AS [FinishedNum],
|
[PieChart2].[MsgState] AS [MsgState],
|
[PieChart2].[SelfReceivedDate] AS [SelfReceivedDate],
|
[PieChart2].[SelfExpiredDate] AS [SelfExpiredDate],
|
[PieChart2].[ExpiredDays] AS [ExpiredDays],
|
[PieChart2].[SelfDonedDate] AS [SelfDonedDate],
|
[PieChart2].[WorkDays] AS [WorkDays],
|
[PieChart2].[ClosedDate] AS [ClosedDate],
|
[PieChart2].[RootWorkDays] AS [RootWorkDays],
|
[PieChart2].[SelfOverdueDays] AS [SelfOverdueDays],
|
[PieChart2].[ReserveField01] AS [ReserveField01],
|
[PieChart2].[IsMaster] AS [IsMaster],
|
[PieChart2].[IsAssembled] AS [IsAssembled],
|
[PieChart2].[ToUnit] AS [ToUnit],
|
[PieChart2].[maqa0] AS [maqa0],
|
[PieChart2].[maqa1] AS [maqa1],
|
[PieChart2].[LastMaintDate] AS [LastMaintDate],
|
[PieChart2].[maqa2] AS [maqa2],
|
[PieChart2].[maqa3] AS [maqa3]
|
FROM [dbo].[PieChart2] AS [PieChart2]</DefiningQuery>
|
</EntitySet>
|
</EntityContainer>
|
</Schema></edmx:StorageModels>
|
<!-- CSDL content -->
|
<edmx:ConceptualModels>
|
<Schema Namespace="developModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
|
<EntityType Name="AttachInfo">
|
<Key>
|
<PropertyRef Name="AttachID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="AttachID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="AttachName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Source" Type="Int32" />
|
<Property Name="FilePath" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="CreatedUser" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FileViewName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
</EntityType>
|
<EntityType Name="Calendar">
|
<Key>
|
<PropertyRef Name="CalDate" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="CalDate" Type="String" MaxLength="10" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="Caltype" Type="Int32" />
|
<Property Name="Description" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="DocumentNo">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="ClientID" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="Catalog" Type="String" MaxLength="15" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="TypeCode" Type="String" MaxLength="5" FixedLength="true" Unicode="false" />
|
<Property Name="UDKey1" Type="String" MaxLength="16" FixedLength="false" Unicode="false" />
|
<Property Name="UDKey2" Type="String" MaxLength="16" FixedLength="false" Unicode="false" />
|
<Property Name="UDKey3" Type="String" MaxLength="16" FixedLength="false" Unicode="false" />
|
<Property Name="UDKey4" Type="String" MaxLength="16" FixedLength="false" Unicode="false" />
|
<Property Name="UDKey5" Type="String" MaxLength="16" FixedLength="false" Unicode="false" />
|
<Property Name="UDKey6" Type="String" MaxLength="16" FixedLength="false" Unicode="false" />
|
<Property Name="UDKey7" Type="String" MaxLength="16" FixedLength="false" Unicode="false" />
|
<Property Name="UDKey8" Type="String" MaxLength="16" FixedLength="false" Unicode="false" />
|
<Property Name="UDKey9" Type="String" MaxLength="16" FixedLength="false" Unicode="false" />
|
<Property Name="UDKey10" Type="String" MaxLength="16" FixedLength="false" Unicode="false" />
|
<Property Name="NextNumber" Type="String" MaxLength="16" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="LockInfo" Type="String" MaxLength="22" FixedLength="true" Unicode="false" />
|
<Property Name="IsDeleted" Type="Int32" />
|
<Property Name="CreateDate" Type="DateTime" Precision="3" />
|
<Property Name="CreateUser" Type="String" MaxLength="16" FixedLength="false" Unicode="false" />
|
<Property Name="ModifiedDate" Type="DateTime" Precision="3" />
|
<Property Name="ModifiedUser" Type="String" MaxLength="16" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="DocumentNoTemplate">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="ClientID" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="TypeCode" Type="String" MaxLength="5" FixedLength="true" Unicode="false" />
|
<Property Name="Catalog" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="Model" Type="String" MaxLength="512" FixedLength="false" Unicode="false" />
|
<Property Name="LockInfo" Type="String" MaxLength="22" FixedLength="true" Unicode="false" />
|
<Property Name="IsDeleted" Type="String" MaxLength="1" FixedLength="true" Unicode="false" />
|
<Property Name="CreateUser" Type="String" MaxLength="16" FixedLength="false" Unicode="false" />
|
<Property Name="CreateDate" Type="DateTime" Precision="3" />
|
<Property Name="LastMaintUser" Type="String" MaxLength="16" FixedLength="false" Unicode="false" />
|
<Property Name="LastMaintDate" Type="DateTime" Precision="3" />
|
</EntityType>
|
<EntityType Name="dtproperties">
|
<Key>
|
<PropertyRef Name="id" />
|
<PropertyRef Name="property" />
|
</Key>
|
<Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="objectid" Type="Int32" />
|
<Property Name="property" Type="String" MaxLength="64" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="value" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
<Property Name="uvalue" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="lvalue" Type="Binary" MaxLength="Max" FixedLength="false" />
|
<Property Name="version" Type="Int32" Nullable="false" />
|
</EntityType>
|
<EntityType Name="FAQ">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="Kind" Type="Int32" Nullable="false" />
|
<Property Name="UnitName" Type="String" MaxLength="128" FixedLength="false" Unicode="false" />
|
<Property Name="Question" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="Response" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="FileName" Type="String" MaxLength="128" FixedLength="false" Unicode="false" />
|
<Property Name="LastMaintUser" Type="String" MaxLength="8" FixedLength="false" Unicode="false" />
|
<Property Name="LastMaintDate" Type="DateTime" Precision="3" />
|
</EntityType>
|
<EntityType Name="Holiday">
|
<Key>
|
<PropertyRef Name="Holiday1" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="Holiday1" Type="String" MaxLength="5" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="Description" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="LogDBMonitor">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="MsgNo" Type="String" MaxLength="15" FixedLength="false" Unicode="false" />
|
<Property Name="currentProsID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="ModifyDetail" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="CreatedDate" Type="DateTime" Precision="3" />
|
<Property Name="CreatedUser" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="LogMailAssign">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="MsgID" Type="String" MaxLength="15" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="MsgNo" Type="String" MaxLength="15" FixedLength="false" Unicode="false" />
|
<Property Name="currentProsID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="parentProsID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FromUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="ToUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="ToUser" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="DispatchedNum" Type="Int32" />
|
<Property Name="FinishedNum" Type="Int32" />
|
<Property Name="Note" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="Response" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="AttachID" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
<Property Name="Version" Type="Int32" />
|
<Property Name="MsgState" Type="Int32" />
|
<Property Name="PressCount" Type="Int32" />
|
<Property Name="UpperRcvDate" Type="DateTime" Precision="3" />
|
<Property Name="UpperDspDate" Type="DateTime" Precision="3" />
|
<Property Name="SelfReceivedDate" Type="DateTime" Precision="3" />
|
<Property Name="SelfExpiredDate" Type="DateTime" Precision="3" />
|
<Property Name="ExpiredDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="SelfDonedDate" Type="DateTime" Precision="3" />
|
<Property Name="ClosedDate" Type="DateTime" Precision="3" />
|
<Property Name="WorkDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="RootWorkDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="SelfOverdueDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="IsMaster" Type="Int32" />
|
<Property Name="IsAssembled" Type="Int32" />
|
<Property Name="IsApproved" Type="Int32" />
|
<Property Name="IsRejected" Type="Int32" />
|
<Property Name="IsExpired" Type="Int32" />
|
<Property Name="IsDeleted" Type="Int32" />
|
<Property Name="LogReason" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="LogTransMail">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="TransferDate" Type="String" MaxLength="10" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="ToUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="CreatedDate" Type="DateTime" Precision="3" />
|
</EntityType>
|
<EntityType Name="MailAssign">
|
<Key>
|
<PropertyRef Name="currentProsID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="MsgID" Type="String" MaxLength="15" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="MsgNo" Type="String" MaxLength="15" FixedLength="false" Unicode="false" />
|
<Property Name="currentProsID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="parentProsID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FromUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="ToUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="ToUser" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="DispatchedNum" Type="Int32" />
|
<Property Name="FinishedNum" Type="Int32" />
|
<Property Name="Note" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="Response" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="ReAssign" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="AttachID" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
<Property Name="Version" Type="Int32" />
|
<Property Name="MsgState" Type="Int32" />
|
<Property Name="PressCount" Type="Int32" />
|
<Property Name="UpperRcvDate" Type="DateTime" Precision="3" />
|
<Property Name="UpperDspDate" Type="DateTime" Precision="3" />
|
<Property Name="SelfReceivedDate" Type="DateTime" Precision="3" />
|
<Property Name="SelfExpiredDate" Type="DateTime" Precision="3" />
|
<Property Name="ExpiredDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="SelfDonedDate" Type="DateTime" Precision="3" />
|
<Property Name="WorkDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="ClosedDate" Type="DateTime" Precision="3" />
|
<Property Name="RootWorkDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="SelfOverdueDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="IsMaster" Type="Int32" />
|
<Property Name="IsAssembled" Type="Int32" />
|
<Property Name="IsApproved" Type="Int32" />
|
<Property Name="IsChecked" Type="Int32" />
|
<Property Name="IsRejected" Type="Int32" />
|
<Property Name="IsExpired" Type="Int32" />
|
<Property Name="IsDeleted" Type="Int32" />
|
<Property Name="IsQueued" Type="Int32" />
|
<Property Name="IsSnReply" Type="Int32" />
|
<Property Name="SnToUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="ReserveField01" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="ReserveField02" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="NoReq" Type="String" MaxLength="1" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="FileReceivedDate" Type="DateTime" Precision="3" />
|
<Property Name="FileCheckDate" Type="DateTime" Precision="3" />
|
<Property Name="FileCheckUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FileNo" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FileMajorUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FileMajorID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FileMajorUser" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FilePros" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="IsCancel" Type="Int32" />
|
<Property Name="IsCombin" Type="Int32" />
|
<Property Name="FileCancelReason" Type="String" MaxLength="500" FixedLength="false" Unicode="false" />
|
<Property Name="FileCombinNo" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="MailCatelog">
|
<Key>
|
<PropertyRef Name="CateID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="CID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="CateID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="CateName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="parentID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="SeqNo" Type="Int32" />
|
<Property Name="IsActived" Type="Int32" />
|
<Property Name="IsDeleted" Type="Int32" />
|
<Property Name="CreatedDate" Type="DateTime" Precision="3" />
|
<Property Name="CreatedUser" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="ExpiredDays" Type="Int32" />
|
<Property Name="ReportNeed" Type="Int32" />
|
<Property Name="OverDate" Type="Int32" />
|
</EntityType>
|
<EntityType Name="Mailor">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="MailorID" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="MailorName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Password" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="IDNum" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="Email" Type="String" MaxLength="100" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="AliasEmail" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="MailorTel" Type="String" MaxLength="40" FixedLength="false" Unicode="false" />
|
<Property Name="MailorAddr" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Mailcount" Type="Int32" />
|
<Property Name="Sex" Type="Int32" />
|
<Property Name="City" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="PostCode" Type="String" MaxLength="3" FixedLength="false" Unicode="false" />
|
<Property Name="edubackground" Type="Int32" />
|
<Property Name="Mailorfex" Type="String" MaxLength="15" FixedLength="false" Unicode="false" />
|
<Property Name="Age" Type="Int32" />
|
<Property Name="IsDemos" Type="String" MaxLength="1" FixedLength="false" Unicode="false" />
|
<Property Name="Career" Type="Int32" />
|
<Property Name="Occupation" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="IsActived" Type="Byte" />
|
<Property Name="PowerNo" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
</EntityType>
|
<EntityType Name="NewMail">
|
<Key>
|
<PropertyRef Name="MsgID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="MsgID" Type="String" MaxLength="15" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="MsgNo" Type="String" MaxLength="15" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="MID" Type="Int32" />
|
<Property Name="MailorAcct" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="MailorDomain" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="MsgSubject" Type="String" MaxLength="512" FixedLength="false" Unicode="false" />
|
<Property Name="MsgContent" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="AttachID" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
<Property Name="MsgAttr1" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="MsgAttr2" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="MsgAttr3" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="MsgAttr4" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="MsgAttr5" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="IsDeleted" Type="Int32" />
|
<Property Name="IsSatSvy" Type="Int32" />
|
<Property Name="IsHaveRefMail" Type="Int32" />
|
<Property Name="AllowedDate" Type="DateTime" Precision="3" />
|
<Property Name="UniReply" Type="Int32" />
|
<Property Name="CreatedUser" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="CreatedDate" Type="DateTime" Precision="3" />
|
<Property Name="LastMaintUser" Type="DateTime" Precision="3" />
|
<Property Name="LastMaintDate" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="IdentityCatalog" Type="String" MaxLength="40" FixedLength="false" Unicode="false" />
|
<Property Name="SatSvyKey" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
|
<Property Name="IsStatement" Type="Int32" />
|
<Property Name="IsReAssign" Type="Int32" />
|
<Property Name="StateCatalog" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="MajorDesc" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="RefMail">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="PreMsgNo" Type="String" MaxLength="15" FixedLength="false" Unicode="false" />
|
<Property Name="MsgNo" Type="String" MaxLength="15" FixedLength="false" Unicode="false" />
|
<Property Name="SeqNo" Type="Int32" />
|
</EntityType>
|
<EntityType Name="REP_01_M">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="Unit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="CreatedDate" Type="DateTime" Precision="3" />
|
<Property Name="CountDate" Type="DateTime" Precision="3" />
|
<Property Name="Column01" Type="Int32" />
|
<Property Name="Column02" Type="Int32" />
|
<Property Name="Column03" Type="Int32" />
|
<Property Name="Column04" Type="Int32" />
|
<Property Name="Column05" Type="Int32" />
|
<Property Name="Column0504" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column06" Type="Int32" />
|
<Property Name="Column0604" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column07" Type="Int32" />
|
<Property Name="Column0704" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column08" Type="Int32" />
|
<Property Name="Column0804" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column09" Type="Int32" />
|
<Property Name="Column0904" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column10" Type="Int32" />
|
<Property Name="Column1004" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column11" Type="Int32" />
|
<Property Name="Column1104" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column12" Type="Int32" />
|
<Property Name="Column1204" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="IsStatement" Type="Int32" />
|
</EntityType>
|
<EntityType Name="REP_02_M">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="Unit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="CreatedDate" Type="DateTime" Precision="3" />
|
<Property Name="CountDate" Type="DateTime" Precision="3" />
|
<Property Name="Column01" Type="Int32" />
|
<Property Name="Column02" Type="Int32" />
|
<Property Name="IsStatement" Type="Int32" />
|
</EntityType>
|
<EntityType Name="REP_03_M">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="Unit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="CreatedDate" Type="DateTime" Precision="3" />
|
<Property Name="CountDate" Type="DateTime" Precision="3" />
|
<Property Name="Column01" Type="Int32" />
|
<Property Name="Column02" Type="Int32" />
|
<Property Name="Column03" Type="Int32" />
|
<Property Name="Column04" Type="Int32" />
|
<Property Name="Column0409" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column05" Type="Int32" />
|
<Property Name="Column0504" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column06" Type="Int32" />
|
<Property Name="Column0604" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column07" Type="Int32" />
|
<Property Name="Column0704" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column08" Type="Int32" />
|
<Property Name="Column0809" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column09" Type="Int32" />
|
<Property Name="Column0903" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column10" Type="Int32" />
|
<Property Name="Column1003" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column11" Type="Int32" />
|
<Property Name="Column12" Type="Int32" />
|
<Property Name="Column13" Type="Decimal" Precision="5" Scale="1" />
|
<Property Name="IsStatement" Type="Int32" />
|
</EntityType>
|
<EntityType Name="REP_04_M">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="Catalog" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="CreatedDate" Type="DateTime" Precision="3" />
|
<Property Name="CountDate" Type="DateTime" Precision="3" />
|
<Property Name="Column01" Type="Int32" />
|
<Property Name="Column02" Type="Int32" />
|
<Property Name="Column03" Type="Int32" />
|
<Property Name="Column04" Type="Int32" />
|
<Property Name="Column0409" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column05" Type="Int32" />
|
<Property Name="Column0504" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column06" Type="Int32" />
|
<Property Name="Column0604" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column07" Type="Int32" />
|
<Property Name="Column0704" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column08" Type="Int32" />
|
<Property Name="Column0809" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column09" Type="Int32" />
|
<Property Name="Column0903" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column10" Type="Int32" />
|
<Property Name="Column1003" Type="Decimal" Precision="5" Scale="2" />
|
<Property Name="Column11" Type="Int32" />
|
<Property Name="Column12" Type="Int32" />
|
<Property Name="Column13" Type="Decimal" Precision="5" Scale="1" />
|
<Property Name="IsStatement" Type="Int32" />
|
</EntityType>
|
<EntityType Name="SatSvy">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="MsgNo" Type="String" MaxLength="15" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="LastMaintDate" Type="DateTime" Precision="3" />
|
<Property Name="Version" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="maqa0" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="maqa1" Type="String" MaxLength="555" FixedLength="false" Unicode="false" />
|
<Property Name="maqa2" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
<Property Name="maqa3" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="SendQueue">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="QueueID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="Priority" Type="String" MaxLength="1" FixedLength="false" Unicode="false" />
|
<Property Name="TmptXML" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="AttachID" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
<Property Name="QueueType" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="DeliveryDate" Type="DateTime" Precision="3" />
|
<Property Name="CreatedDate" Type="DateTime" Precision="3" />
|
<Property Name="FinishedDate" Type="DateTime" Precision="3" />
|
</EntityType>
|
<EntityType Name="SYS_AREA_M">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="AreaID" Type="String" MaxLength="11" FixedLength="false" Unicode="false" />
|
<Property Name="AreaClass" Type="Int32" />
|
<Property Name="AreaName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="ToUnit" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="SYS_FUN_LIST_L">
|
<Key>
|
<PropertyRef Name="FID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="FID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="FunID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="FunName" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="PFunID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FunPath" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="SortNum" Type="Int32" />
|
<Property Name="IsVisible" Type="Int32" />
|
</EntityType>
|
<EntityType Name="SYS_LOG_L">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="CreatedDate" Type="DateTime" Precision="3" />
|
<Property Name="RemoteAddr" Type="String" MaxLength="15" FixedLength="false" Unicode="false" />
|
<Property Name="GroupType" Type="Int32" />
|
<Property Name="UserID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="UsePage" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="UserBrowser" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="IsDeleted" Type="Int32" />
|
</EntityType>
|
<EntityType Name="SYS_RIGHTS_X">
|
<Key>
|
<PropertyRef Name="RoleID" />
|
<PropertyRef Name="FunID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="RoleID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="FunID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
</EntityType>
|
<EntityType Name="SYS_ROLE_M">
|
<Key>
|
<PropertyRef Name="RoleID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="RoleID" Type="String" MaxLength="10" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="RoleName" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="IsActived" Type="Int32" />
|
<Property Name="IsDeleted" Type="Int32" />
|
<Property Name="RoleGroup" Type="Int32" />
|
</EntityType>
|
<EntityType Name="SYS_UNIT_M">
|
<Key>
|
<PropertyRef Name="UnitID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="UID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="UnitID" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="OUnitID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="UnitName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Email" Type="String" MaxLength="60" FixedLength="false" Unicode="false" />
|
<Property Name="ParentID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="SeqNo" Type="Int32" />
|
<Property Name="UAgent" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="UAssembler" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="IsActived" Type="Int32" />
|
<Property Name="IsDeleted" Type="Int32" />
|
<Property Name="GroupId" Type="Int32" />
|
<Property Name="MasterUnit" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="SYS_UNIT_O_M">
|
<Key>
|
<PropertyRef Name="UnitID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="UID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="UnitID" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="OUnitID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="UnitName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Email" Type="String" MaxLength="60" FixedLength="false" Unicode="false" />
|
<Property Name="ParentID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="SeqNo" Type="Int32" />
|
<Property Name="UAgent" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="UAssembler" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="IsActived" Type="Int32" />
|
<Property Name="IsDeleted" Type="Int32" />
|
<Property Name="GroupId" Type="Int32" />
|
<Property Name="MasterUnit" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="SYS_USER_M">
|
<Key>
|
<PropertyRef Name="UserID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="EmployeeID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="UserID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="UserName" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="Password" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="Email" Type="String" MaxLength="60" FixedLength="false" Unicode="false" />
|
<Property Name="TitleName" Type="String" MaxLength="30" FixedLength="false" Unicode="false" />
|
<Property Name="RoleID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="UnitID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="IsRest" Type="Int32" />
|
<Property Name="IsLogin" Type="Int32" />
|
<Property Name="IsDeleted" Type="Int32" />
|
<Property Name="IsActived" Type="Int32" />
|
<Property Name="LastLoginDate" Type="DateTime" Precision="3" />
|
<Property Name="OffTel" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="HomeTel" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="SysCodeTable">
|
<Key>
|
<PropertyRef Name="CodeID" />
|
<PropertyRef Name="SeqNo" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="CodeID" Type="Int32" Nullable="false" />
|
<Property Name="CodeName" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="SeqNo" Type="Int32" Nullable="false" />
|
<Property Name="CodeValue" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="CodeDesc" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="ReserveField01" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="ReserveField02" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="IsActived" Type="Int32" />
|
</EntityType>
|
<EntityType Name="SysEnvVar">
|
<Key>
|
<PropertyRef Name="CodeID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="CodeID" Type="Int32" Nullable="false" />
|
<Property Name="CodeName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="CodeValue" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="CodeDesc" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="IsActived" Type="Int32" />
|
<Property Name="IsVisible" Type="Int32" />
|
</EntityType>
|
<EntityType Name="SysFunLists">
|
<Key>
|
<PropertyRef Name="FID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="FID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="FunID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="FunName" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="PFunID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FunPath" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="SortNum" Type="Int32" />
|
<Property Name="IsVisible" Type="Int32" />
|
</EntityType>
|
<EntityType Name="SysGlobalVar">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="GVID" Type="String" MaxLength="30" FixedLength="false" Unicode="false" />
|
<Property Name="GVName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="GVValue" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="GVDesc" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="SysRights">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="RoleID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="FunID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
</EntityType>
|
<EntityType Name="SysRole">
|
<Key>
|
<PropertyRef Name="RoleID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="RoleID" Type="String" MaxLength="10" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="RoleName" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="IsActived" Type="Int32" />
|
<Property Name="IsDeleted" Type="Int32" />
|
<Property Name="RoleGroup" Type="Int32" />
|
</EntityType>
|
<EntityType Name="SysTitle">
|
<Key>
|
<PropertyRef Name="TitleID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="TitleID" Type="String" MaxLength="10" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="TitleName" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="IsActived" Type="Int32" />
|
<Property Name="IsDeleted" Type="Int32" />
|
</EntityType>
|
<EntityType Name="SysTmpt">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="TmptID" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="TmptName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="TmptType" Type="Int32" />
|
<Property Name="TmptContent" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="LayoutType" Type="Int32" />
|
<Property Name="IsActived" Type="Int32" />
|
<Property Name="CreatedUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="CreatedUser" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="SysUnit">
|
<Key>
|
<PropertyRef Name="UnitID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="UID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="UnitID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="OUnitID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="UnitName" Type="String" MaxLength="30" FixedLength="false" Unicode="false" />
|
<Property Name="Email" Type="String" MaxLength="60" FixedLength="false" Unicode="false" />
|
<Property Name="ParentID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="SeqNo" Type="Int32" />
|
<Property Name="UAgent" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="UAssembler" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="IsActived" Type="Int32" />
|
<Property Name="IsDeleted" Type="Int32" />
|
<Property Name="GroupId" Type="Int32" />
|
<Property Name="MasterUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="SysUser">
|
<Key>
|
<PropertyRef Name="UserID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="EmployeeID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="UserID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="UserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="Password" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="Email" Type="String" MaxLength="60" FixedLength="false" Unicode="false" />
|
<Property Name="TitleName" Type="String" MaxLength="30" FixedLength="false" Unicode="false" />
|
<Property Name="RoleID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="UnitID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="IsRest" Type="Int32" />
|
<Property Name="IsLogin" Type="Int32" />
|
<Property Name="IsDeleted" Type="Int32" />
|
<Property Name="IsActived" Type="Int32" />
|
<Property Name="LastLoginDate" Type="DateTime" Precision="3" />
|
<Property Name="OffTel" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="HomeTel" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="SendQueue_Temp">
|
<Key>
|
<PropertyRef Name="OID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="QueueID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="Priority" Type="String" MaxLength="1" FixedLength="false" Unicode="false" />
|
<Property Name="TmptXML" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="AttachID" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
<Property Name="QueueType" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="DeliveryDate" Type="DateTime" Precision="3" />
|
<Property Name="CreatedDate" Type="DateTime" Precision="3" />
|
<Property Name="FinishedDate" Type="DateTime" Precision="3" />
|
</EntityType>
|
<EntityType Name="Worklist">
|
<Key>
|
<PropertyRef Name="OID" />
|
<PropertyRef Name="currentProsID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" />
|
<Property Name="currentProsID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="MsgID" Type="String" MaxLength="15" FixedLength="false" Unicode="false" />
|
<Property Name="UserID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="WorkType" Type="Int32" />
|
<Property Name="IsTerminate" Type="Int32" />
|
<Property Name="CreatedDate" Type="DateTime" Precision="3" />
|
<Property Name="CreatedUser" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="AssignToMail">
|
<Key>
|
<PropertyRef Name="OID" />
|
<PropertyRef Name="MsgID" />
|
<PropertyRef Name="currentProsID" />
|
<PropertyRef Name="NoReq" />
|
<PropertyRef Name="Expr1" />
|
<PropertyRef Name="Expr2" />
|
<PropertyRef Name="Expr3" />
|
<PropertyRef Name="Email" />
|
<PropertyRef Name="CodeID" />
|
</Key>
|
<Property Name="OID" Type="Int32" Nullable="false" />
|
<Property Name="MsgID" Type="String" MaxLength="15" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="MsgNo" Type="String" MaxLength="15" FixedLength="false" Unicode="false" />
|
<Property Name="currentProsID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="parentProsID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FromUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="ToUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="ToUser" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="DispatchedNum" Type="Int32" />
|
<Property Name="FinishedNum" Type="Int32" />
|
<Property Name="Note" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="Response" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="AttachID" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
<Property Name="Version" Type="Int32" />
|
<Property Name="MsgState" Type="Int32" />
|
<Property Name="PressCount" Type="Int32" />
|
<Property Name="UpperRcvDate" Type="DateTime" Precision="3" />
|
<Property Name="UpperDspDate" Type="DateTime" Precision="3" />
|
<Property Name="SelfReceivedDate" Type="DateTime" Precision="3" />
|
<Property Name="SelfExpiredDate" Type="DateTime" Precision="3" />
|
<Property Name="ExpiredDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="SelfDonedDate" Type="DateTime" Precision="3" />
|
<Property Name="WorkDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="ClosedDate" Type="DateTime" Precision="3" />
|
<Property Name="RootWorkDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="SelfOverdueDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="IsMaster" Type="Int32" />
|
<Property Name="IsAssembled" Type="Int32" />
|
<Property Name="IsApproved" Type="Int32" />
|
<Property Name="IsRejected" Type="Int32" />
|
<Property Name="IsExpired" Type="Int32" />
|
<Property Name="IsDeleted" Type="Int32" />
|
<Property Name="IsQueued" Type="Int32" />
|
<Property Name="ReserveField01" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="ReserveField02" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="NoReq" Type="String" MaxLength="1" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="Expr1" Type="Int32" Nullable="false" />
|
<Property Name="Expr2" Type="String" MaxLength="15" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="Expr3" Type="String" MaxLength="15" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="MID" Type="Int32" />
|
<Property Name="MailorAcct" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="MailorDomain" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="MsgSubject" Type="String" MaxLength="512" FixedLength="false" Unicode="false" />
|
<Property Name="MsgContent" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="Expr4" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
<Property Name="MsgAttr1" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="MsgAttr2" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="MsgAttr3" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="MsgAttr4" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="MsgAttr5" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="Expr5" Type="Int32" />
|
<Property Name="IsSatSvy" Type="Int32" />
|
<Property Name="IsHaveRefMail" Type="Int32" />
|
<Property Name="AllowedDate" Type="DateTime" Precision="3" />
|
<Property Name="UniReply" Type="Int32" />
|
<Property Name="CreatedUser" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="CreatedDate" Type="DateTime" Precision="3" />
|
<Property Name="LastMaintUser" Type="DateTime" Precision="3" />
|
<Property Name="LastMaintDate" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="IdentityCatalog" Type="String" MaxLength="40" FixedLength="false" Unicode="false" />
|
<Property Name="SatSvyKey" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
|
<Property Name="MailorID" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="MailorName" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="IDNum" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="Email" Type="String" MaxLength="100" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="AliasEmail" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="MailorTel" Type="String" MaxLength="40" FixedLength="false" Unicode="false" />
|
<Property Name="MailorAddr" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Mailcount" Type="Int32" />
|
<Property Name="Sex" Type="Int32" />
|
<Property Name="PostCode" Type="String" MaxLength="3" FixedLength="false" Unicode="false" />
|
<Property Name="City" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="edubackground" Type="Int32" />
|
<Property Name="Mailorfex" Type="String" MaxLength="15" FixedLength="false" Unicode="false" />
|
<Property Name="Age" Type="Int32" />
|
<Property Name="Career" Type="Int32" />
|
<Property Name="Occupation" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="IsActived" Type="Byte" />
|
<Property Name="PowerNo" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FileCombinNo" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FileNo" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FileCancelReason" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="FileCheckUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FileCheckDate" Type="DateTime" Precision="3" />
|
<Property Name="FileReceivedDate" Type="DateTime" Precision="3" />
|
<Property Name="FileMajorUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FileMajorID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FileMajorUser" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FilePros" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="StateCatalog" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="UnitName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="CodeDesc" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="CodeID" Type="Int32" Nullable="false" />
|
<Property Name="IsStatement" Type="Int32" />
|
<Property Name="IsReAssign" Type="Int32" />
|
<Property Name="IsCancel" Type="Int32" />
|
<Property Name="IsCombin" Type="Int32" />
|
<Property Name="CateName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="MailClass" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="IsSnReply" Type="Int32" />
|
<Property Name="SnToUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="MailState" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="ReAssign" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="MailProcess">
|
<Key>
|
<PropertyRef Name="MsgID" />
|
<PropertyRef Name="MsgNo" />
|
<PropertyRef Name="currentProsID" />
|
<PropertyRef Name="Email" />
|
</Key>
|
<Property Name="ToUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="MsgID" Type="String" MaxLength="15" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="MsgNo" Type="String" MaxLength="15" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="MID" Type="Int32" />
|
<Property Name="MailorAcct" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="MailorDomain" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="MsgSubject" Type="String" MaxLength="512" FixedLength="false" Unicode="false" />
|
<Property Name="MsgContent" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="AttachID" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
<Property Name="AllowedDate" Type="DateTime" Precision="3" />
|
<Property Name="CreatedDate" Type="DateTime" Precision="3" />
|
<Property Name="currentProsID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="parentProsID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="Note" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="Response" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="MsgState" Type="Int32" />
|
<Property Name="UpperRcvDate" Type="DateTime" Precision="3" />
|
<Property Name="UpperDspDate" Type="DateTime" Precision="3" />
|
<Property Name="SelfReceivedDate" Type="DateTime" Precision="3" />
|
<Property Name="SelfExpiredDate" Type="DateTime" Precision="3" />
|
<Property Name="ExpiredDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="SelfDonedDate" Type="DateTime" Precision="3" />
|
<Property Name="WorkDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="ClosedDate" Type="DateTime" Precision="3" />
|
<Property Name="RootWorkDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="SelfOverdueDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="ReserveField01" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="ReserveField02" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="MsgAttr4" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="UnitName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="MailorName" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="Email" Type="String" MaxLength="100" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="MsgAttr1" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="MailorTel" Type="String" MaxLength="30" FixedLength="false" Unicode="false" />
|
<Property Name="MailorAddr" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="Mailcount" Type="Int32" />
|
<Property Name="Sex" Type="Int32" />
|
<Property Name="City" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="PostCode" Type="String" MaxLength="3" FixedLength="false" Unicode="false" />
|
<Property Name="edubackground" Type="Int32" />
|
<Property Name="Mailorfex" Type="String" MaxLength="15" FixedLength="false" Unicode="false" />
|
<Property Name="Age" Type="Int32" />
|
<Property Name="Career" Type="Int32" />
|
<Property Name="Occupation" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="PowerNo" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="IDNum" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="LastMaintUser" Type="DateTime" Precision="3" />
|
<Property Name="LastMaintDate" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="CreatedUser" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="IsReAssign" Type="Int32" />
|
<Property Name="StateCatalog" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="SatSvyKey" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
|
<Property Name="IsMaster" Type="Int32" />
|
<Property Name="IsAssembled" Type="Int32" />
|
<Property Name="IsApproved" Type="Int32" />
|
<Property Name="IsRejected" Type="Int32" />
|
<Property Name="IsExpired" Type="Int32" />
|
<Property Name="IsDeleted" Type="Int32" />
|
<Property Name="IsQueued" Type="Int32" />
|
</EntityType>
|
<EntityType Name="PieChart2">
|
<Key>
|
<PropertyRef Name="MsgID" />
|
<PropertyRef Name="MsgNo" />
|
<PropertyRef Name="CateID" />
|
<PropertyRef Name="UnitID" />
|
<PropertyRef Name="currentProsID" />
|
</Key>
|
<Property Name="MsgID" Type="String" MaxLength="15" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="MsgNo" Type="String" MaxLength="15" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="MID" Type="Int32" />
|
<Property Name="UnitName" Type="String" MaxLength="30" FixedLength="false" Unicode="false" />
|
<Property Name="CateName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="CateID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="IsActived" Type="Int32" />
|
<Property Name="CreatedDate" Type="DateTime" Precision="3" />
|
<Property Name="AllowedDate" Type="DateTime" Precision="3" />
|
<Property Name="UnitID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="currentProsID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="parentProsID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FromUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="ToUser" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="DispatchedNum" Type="Int32" />
|
<Property Name="FinishedNum" Type="Int32" />
|
<Property Name="MsgState" Type="Int32" />
|
<Property Name="SelfReceivedDate" Type="DateTime" Precision="3" />
|
<Property Name="SelfExpiredDate" Type="DateTime" Precision="3" />
|
<Property Name="ExpiredDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="SelfDonedDate" Type="DateTime" Precision="3" />
|
<Property Name="WorkDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="ClosedDate" Type="DateTime" Precision="3" />
|
<Property Name="RootWorkDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="SelfOverdueDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="ReserveField01" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="IsMaster" Type="Int32" />
|
<Property Name="IsAssembled" Type="Int32" />
|
<Property Name="ToUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="maqa0" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="maqa1" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
<Property Name="LastMaintDate" Type="DateTime" Precision="3" />
|
<Property Name="maqa2" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
<Property Name="maqa3" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityContainer Name="developEntities" annotation:LazyLoadingEnabled="true">
|
<EntitySet Name="AttachInfo" EntityType="Self.AttachInfo" />
|
<EntitySet Name="Calendar" EntityType="Self.Calendar" />
|
<EntitySet Name="DocumentNo" EntityType="Self.DocumentNo" />
|
<EntitySet Name="DocumentNoTemplate" EntityType="Self.DocumentNoTemplate" />
|
<EntitySet Name="dtproperties" EntityType="Self.dtproperties" />
|
<EntitySet Name="FAQ" EntityType="Self.FAQ" />
|
<EntitySet Name="Holiday" EntityType="Self.Holiday" />
|
<EntitySet Name="LogDBMonitor" EntityType="Self.LogDBMonitor" />
|
<EntitySet Name="LogMailAssign" EntityType="Self.LogMailAssign" />
|
<EntitySet Name="LogTransMail" EntityType="Self.LogTransMail" />
|
<EntitySet Name="MailAssign" EntityType="Self.MailAssign" />
|
<EntitySet Name="MailCatelog" EntityType="Self.MailCatelog" />
|
<EntitySet Name="Mailor" EntityType="Self.Mailor" />
|
<EntitySet Name="NewMail" EntityType="Self.NewMail" />
|
<EntitySet Name="RefMail" EntityType="Self.RefMail" />
|
<EntitySet Name="REP_01_M" EntityType="Self.REP_01_M" />
|
<EntitySet Name="REP_02_M" EntityType="Self.REP_02_M" />
|
<EntitySet Name="REP_03_M" EntityType="Self.REP_03_M" />
|
<EntitySet Name="REP_04_M" EntityType="Self.REP_04_M" />
|
<EntitySet Name="SatSvy" EntityType="Self.SatSvy" />
|
<EntitySet Name="SendQueue" EntityType="Self.SendQueue" />
|
<EntitySet Name="SYS_AREA_M" EntityType="Self.SYS_AREA_M" />
|
<EntitySet Name="SYS_FUN_LIST_L" EntityType="Self.SYS_FUN_LIST_L" />
|
<EntitySet Name="SYS_LOG_L" EntityType="Self.SYS_LOG_L" />
|
<EntitySet Name="SYS_RIGHTS_X" EntityType="Self.SYS_RIGHTS_X" />
|
<EntitySet Name="SYS_ROLE_M" EntityType="Self.SYS_ROLE_M" />
|
<EntitySet Name="SYS_UNIT_M" EntityType="Self.SYS_UNIT_M" />
|
<EntitySet Name="SYS_UNIT_O_M" EntityType="Self.SYS_UNIT_O_M" />
|
<EntitySet Name="SYS_USER_M" EntityType="Self.SYS_USER_M" />
|
<EntitySet Name="SysCodeTable" EntityType="Self.SysCodeTable" />
|
<EntitySet Name="SysEnvVar" EntityType="Self.SysEnvVar" />
|
<EntitySet Name="SysFunLists" EntityType="Self.SysFunLists" />
|
<EntitySet Name="SysGlobalVar" EntityType="Self.SysGlobalVar" />
|
<EntitySet Name="SysRights" EntityType="Self.SysRights" />
|
<EntitySet Name="SysRole" EntityType="Self.SysRole" />
|
<EntitySet Name="SysTitle" EntityType="Self.SysTitle" />
|
<EntitySet Name="SysTmpt" EntityType="Self.SysTmpt" />
|
<EntitySet Name="SysUnit" EntityType="Self.SysUnit" />
|
<EntitySet Name="SysUser" EntityType="Self.SysUser" />
|
<EntitySet Name="SendQueue_Temp" EntityType="Self.SendQueue_Temp" />
|
<EntitySet Name="Worklist" EntityType="Self.Worklist" />
|
<EntitySet Name="AssignToMail" EntityType="Self.AssignToMail" />
|
<EntitySet Name="MailProcess" EntityType="Self.MailProcess" />
|
<EntitySet Name="PieChart2" EntityType="Self.PieChart2" />
|
<EntitySet Name="FeaturesResult" EntityType="developModel.FeaturesResult" />
|
</EntityContainer>
|
<EntityType Name="FeaturesResult">
|
<Key>
|
<PropertyRef Name="currentProsID" />
|
</Key>
|
<Property Name="MsgNo" Type="String" MaxLength="15" FixedLength="false" Unicode="false" />
|
<Property Name="MailorName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Email" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="CreatedDate" Type="DateTime" Precision="3" />
|
<Property Name="AllowedDate" Type="DateTime" Precision="3" />
|
<Property Name="UniReply" Type="Int32" />
|
<Property Name="MsgSubject" Type="String" MaxLength="512" FixedLength="false" Unicode="false" />
|
<Property Name="MsgContent" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="AttachID" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
<Property Name="FromUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="ToUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="currentProsID" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="MsgID" Type="String" MaxLength="15" FixedLength="false" Unicode="false" />
|
<Property Name="parentProsID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="Response" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="MsgState" Type="Int32" />
|
<Property Name="CodeDesc" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="CateName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="IsDeleted" Type="Int32" />
|
<Property Name="IsExpired" Type="Int32" />
|
<Property Name="SatSvyKey" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
|
<Property Name="IsSatSvy" Type="Int32" />
|
<Property Name="UnitName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="IsApproved" Type="Int32" />
|
<Property Name="IsMaster" Type="Int32" />
|
<Property Name="IsAssembled" Type="Int32" />
|
<Property Name="IsRejected" Type="Int32" />
|
<Property Name="IsQueued" Type="Int32" />
|
<Property Name="IsReAssign" Type="Int32" />
|
<Property Name="FileNo" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="MailFrom" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="MailClass" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="SelfReceivedDate" Type="DateTime" Precision="3" />
|
<Property Name="ClosedDate" Type="DateTime" Precision="3" />
|
<Property Name="SelfDonedDate" Type="DateTime" Precision="3" />
|
<Property Name="UpperDspDate" Type="DateTime" Precision="3" />
|
<Property Name="SelfOverdueDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="RootWorkDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="WorkDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="ExpiredDays" Type="Decimal" Precision="18" Scale="1" />
|
<Property Name="SelfExpiredDate" Type="DateTime" Precision="3" />
|
<Property Name="UpperRcvDate" Type="DateTime" Precision="3" />
|
<Property Name="Expr1" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
|
<Property Name="Note" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="FileCombinNo" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FileCancelReason" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
<Property Name="IsCombin" Type="Int32" />
|
<Property Name="IsCancel" Type="Int32" />
|
<Property Name="IsStatement" Type="Int32" />
|
<Property Name="StateCatalog" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="IsChecked" Type="Int32" />
|
<Property Name="MailorTel" Type="String" MaxLength="40" FixedLength="false" Unicode="false" />
|
<Property Name="MailorAddr" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="PowerNo" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="FileMajorUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FileMajorUser" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FileMajorID" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FileCheckUnit" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="FileCheckDate" Type="DateTime" Precision="3" />
|
<Property Name="FileReceivedDate" Type="DateTime" Precision="3" />
|
<Property Name="FilePros" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
</EntityType>
|
</Schema>
|
</edmx:ConceptualModels>
|
<!-- C-S mapping content -->
|
<edmx:Mappings>
|
<Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
|
<EntityContainerMapping StorageEntityContainer="developModelStoreContainer" CdmEntityContainer="developEntities">
|
<EntitySetMapping Name="AttachInfo">
|
<EntityTypeMapping TypeName="developModel.AttachInfo">
|
<MappingFragment StoreEntitySet="AttachInfo">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="AttachID" ColumnName="AttachID" />
|
<ScalarProperty Name="AttachName" ColumnName="AttachName" />
|
<ScalarProperty Name="Source" ColumnName="Source" />
|
<ScalarProperty Name="FilePath" ColumnName="FilePath" />
|
<ScalarProperty Name="CreatedUser" ColumnName="CreatedUser" />
|
<ScalarProperty Name="FileViewName" ColumnName="FileViewName" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="Calendar">
|
<EntityTypeMapping TypeName="developModel.Calendar">
|
<MappingFragment StoreEntitySet="Calendar">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="CalDate" ColumnName="CalDate" />
|
<ScalarProperty Name="Caltype" ColumnName="Caltype" />
|
<ScalarProperty Name="Description" ColumnName="Description" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="DocumentNo">
|
<EntityTypeMapping TypeName="developModel.DocumentNo">
|
<MappingFragment StoreEntitySet="DocumentNo">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="ClientID" ColumnName="ClientID" />
|
<ScalarProperty Name="Catalog" ColumnName="Catalog" />
|
<ScalarProperty Name="TypeCode" ColumnName="TypeCode" />
|
<ScalarProperty Name="UDKey1" ColumnName="UDKey1" />
|
<ScalarProperty Name="UDKey2" ColumnName="UDKey2" />
|
<ScalarProperty Name="UDKey3" ColumnName="UDKey3" />
|
<ScalarProperty Name="UDKey4" ColumnName="UDKey4" />
|
<ScalarProperty Name="UDKey5" ColumnName="UDKey5" />
|
<ScalarProperty Name="UDKey6" ColumnName="UDKey6" />
|
<ScalarProperty Name="UDKey7" ColumnName="UDKey7" />
|
<ScalarProperty Name="UDKey8" ColumnName="UDKey8" />
|
<ScalarProperty Name="UDKey9" ColumnName="UDKey9" />
|
<ScalarProperty Name="UDKey10" ColumnName="UDKey10" />
|
<ScalarProperty Name="NextNumber" ColumnName="NextNumber" />
|
<ScalarProperty Name="LockInfo" ColumnName="LockInfo" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="CreateDate" ColumnName="CreateDate" />
|
<ScalarProperty Name="CreateUser" ColumnName="CreateUser" />
|
<ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
|
<ScalarProperty Name="ModifiedUser" ColumnName="ModifiedUser" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="DocumentNoTemplate">
|
<EntityTypeMapping TypeName="developModel.DocumentNoTemplate">
|
<MappingFragment StoreEntitySet="DocumentNoTemplate">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="ClientID" ColumnName="ClientID" />
|
<ScalarProperty Name="TypeCode" ColumnName="TypeCode" />
|
<ScalarProperty Name="Catalog" ColumnName="Catalog" />
|
<ScalarProperty Name="Model" ColumnName="Model" />
|
<ScalarProperty Name="LockInfo" ColumnName="LockInfo" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="CreateUser" ColumnName="CreateUser" />
|
<ScalarProperty Name="CreateDate" ColumnName="CreateDate" />
|
<ScalarProperty Name="LastMaintUser" ColumnName="LastMaintUser" />
|
<ScalarProperty Name="LastMaintDate" ColumnName="LastMaintDate" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="dtproperties">
|
<EntityTypeMapping TypeName="developModel.dtproperties">
|
<MappingFragment StoreEntitySet="dtproperties">
|
<ScalarProperty Name="id" ColumnName="id" />
|
<ScalarProperty Name="objectid" ColumnName="objectid" />
|
<ScalarProperty Name="property" ColumnName="property" />
|
<ScalarProperty Name="value" ColumnName="value" />
|
<ScalarProperty Name="uvalue" ColumnName="uvalue" />
|
<ScalarProperty Name="lvalue" ColumnName="lvalue" />
|
<ScalarProperty Name="version" ColumnName="version" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="FAQ">
|
<EntityTypeMapping TypeName="developModel.FAQ">
|
<MappingFragment StoreEntitySet="FAQ">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="Kind" ColumnName="Kind" />
|
<ScalarProperty Name="UnitName" ColumnName="UnitName" />
|
<ScalarProperty Name="Question" ColumnName="Question" />
|
<ScalarProperty Name="Response" ColumnName="Response" />
|
<ScalarProperty Name="FileName" ColumnName="FileName" />
|
<ScalarProperty Name="LastMaintUser" ColumnName="LastMaintUser" />
|
<ScalarProperty Name="LastMaintDate" ColumnName="LastMaintDate" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="Holiday">
|
<EntityTypeMapping TypeName="developModel.Holiday">
|
<MappingFragment StoreEntitySet="Holiday">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="Holiday1" ColumnName="Holiday" />
|
<ScalarProperty Name="Description" ColumnName="Description" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="LogDBMonitor">
|
<EntityTypeMapping TypeName="developModel.LogDBMonitor">
|
<MappingFragment StoreEntitySet="LogDBMonitor">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="MsgNo" ColumnName="MsgNo" />
|
<ScalarProperty Name="currentProsID" ColumnName="currentProsID" />
|
<ScalarProperty Name="ModifyDetail" ColumnName="ModifyDetail" />
|
<ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
|
<ScalarProperty Name="CreatedUser" ColumnName="CreatedUser" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="LogMailAssign">
|
<EntityTypeMapping TypeName="developModel.LogMailAssign">
|
<MappingFragment StoreEntitySet="LogMailAssign">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="MsgID" ColumnName="MsgID" />
|
<ScalarProperty Name="MsgNo" ColumnName="MsgNo" />
|
<ScalarProperty Name="currentProsID" ColumnName="currentProsID" />
|
<ScalarProperty Name="parentProsID" ColumnName="parentProsID" />
|
<ScalarProperty Name="FromUnit" ColumnName="FromUnit" />
|
<ScalarProperty Name="ToUnit" ColumnName="ToUnit" />
|
<ScalarProperty Name="ToUser" ColumnName="ToUser" />
|
<ScalarProperty Name="DispatchedNum" ColumnName="DispatchedNum" />
|
<ScalarProperty Name="FinishedNum" ColumnName="FinishedNum" />
|
<ScalarProperty Name="Note" ColumnName="Note" />
|
<ScalarProperty Name="Response" ColumnName="Response" />
|
<ScalarProperty Name="AttachID" ColumnName="AttachID" />
|
<ScalarProperty Name="Version" ColumnName="Version" />
|
<ScalarProperty Name="MsgState" ColumnName="MsgState" />
|
<ScalarProperty Name="PressCount" ColumnName="PressCount" />
|
<ScalarProperty Name="UpperRcvDate" ColumnName="UpperRcvDate" />
|
<ScalarProperty Name="UpperDspDate" ColumnName="UpperDspDate" />
|
<ScalarProperty Name="SelfReceivedDate" ColumnName="SelfReceivedDate" />
|
<ScalarProperty Name="SelfExpiredDate" ColumnName="SelfExpiredDate" />
|
<ScalarProperty Name="ExpiredDays" ColumnName="ExpiredDays" />
|
<ScalarProperty Name="SelfDonedDate" ColumnName="SelfDonedDate" />
|
<ScalarProperty Name="ClosedDate" ColumnName="ClosedDate" />
|
<ScalarProperty Name="WorkDays" ColumnName="WorkDays" />
|
<ScalarProperty Name="RootWorkDays" ColumnName="RootWorkDays" />
|
<ScalarProperty Name="SelfOverdueDays" ColumnName="SelfOverdueDays" />
|
<ScalarProperty Name="IsMaster" ColumnName="IsMaster" />
|
<ScalarProperty Name="IsAssembled" ColumnName="IsAssembled" />
|
<ScalarProperty Name="IsApproved" ColumnName="IsApproved" />
|
<ScalarProperty Name="IsRejected" ColumnName="IsRejected" />
|
<ScalarProperty Name="IsExpired" ColumnName="IsExpired" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="LogReason" ColumnName="LogReason" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="LogTransMail">
|
<EntityTypeMapping TypeName="developModel.LogTransMail">
|
<MappingFragment StoreEntitySet="LogTransMail">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="TransferDate" ColumnName="TransferDate" />
|
<ScalarProperty Name="ToUnit" ColumnName="ToUnit" />
|
<ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="MailAssign">
|
<EntityTypeMapping TypeName="developModel.MailAssign">
|
<MappingFragment StoreEntitySet="MailAssign">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="MsgID" ColumnName="MsgID" />
|
<ScalarProperty Name="MsgNo" ColumnName="MsgNo" />
|
<ScalarProperty Name="currentProsID" ColumnName="currentProsID" />
|
<ScalarProperty Name="parentProsID" ColumnName="parentProsID" />
|
<ScalarProperty Name="FromUnit" ColumnName="FromUnit" />
|
<ScalarProperty Name="ToUnit" ColumnName="ToUnit" />
|
<ScalarProperty Name="ToUser" ColumnName="ToUser" />
|
<ScalarProperty Name="DispatchedNum" ColumnName="DispatchedNum" />
|
<ScalarProperty Name="FinishedNum" ColumnName="FinishedNum" />
|
<ScalarProperty Name="Note" ColumnName="Note" />
|
<ScalarProperty Name="Response" ColumnName="Response" />
|
<ScalarProperty Name="ReAssign" ColumnName="ReAssign" />
|
<ScalarProperty Name="AttachID" ColumnName="AttachID" />
|
<ScalarProperty Name="Version" ColumnName="Version" />
|
<ScalarProperty Name="MsgState" ColumnName="MsgState" />
|
<ScalarProperty Name="PressCount" ColumnName="PressCount" />
|
<ScalarProperty Name="UpperRcvDate" ColumnName="UpperRcvDate" />
|
<ScalarProperty Name="UpperDspDate" ColumnName="UpperDspDate" />
|
<ScalarProperty Name="SelfReceivedDate" ColumnName="SelfReceivedDate" />
|
<ScalarProperty Name="SelfExpiredDate" ColumnName="SelfExpiredDate" />
|
<ScalarProperty Name="ExpiredDays" ColumnName="ExpiredDays" />
|
<ScalarProperty Name="SelfDonedDate" ColumnName="SelfDonedDate" />
|
<ScalarProperty Name="WorkDays" ColumnName="WorkDays" />
|
<ScalarProperty Name="ClosedDate" ColumnName="ClosedDate" />
|
<ScalarProperty Name="RootWorkDays" ColumnName="RootWorkDays" />
|
<ScalarProperty Name="SelfOverdueDays" ColumnName="SelfOverdueDays" />
|
<ScalarProperty Name="IsMaster" ColumnName="IsMaster" />
|
<ScalarProperty Name="IsAssembled" ColumnName="IsAssembled" />
|
<ScalarProperty Name="IsApproved" ColumnName="IsApproved" />
|
<ScalarProperty Name="IsChecked" ColumnName="IsChecked" />
|
<ScalarProperty Name="IsRejected" ColumnName="IsRejected" />
|
<ScalarProperty Name="IsExpired" ColumnName="IsExpired" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="IsQueued" ColumnName="IsQueued" />
|
<ScalarProperty Name="IsSnReply" ColumnName="IsSnReply" />
|
<ScalarProperty Name="SnToUnit" ColumnName="SnToUnit" />
|
<ScalarProperty Name="ReserveField01" ColumnName="ReserveField01" />
|
<ScalarProperty Name="ReserveField02" ColumnName="ReserveField02" />
|
<ScalarProperty Name="NoReq" ColumnName="NoReq" />
|
<ScalarProperty Name="FileReceivedDate" ColumnName="FileReceivedDate" />
|
<ScalarProperty Name="FileCheckDate" ColumnName="FileCheckDate" />
|
<ScalarProperty Name="FileCheckUnit" ColumnName="FileCheckUnit" />
|
<ScalarProperty Name="FileNo" ColumnName="FileNo" />
|
<ScalarProperty Name="FileMajorUnit" ColumnName="FileMajorUnit" />
|
<ScalarProperty Name="FileMajorID" ColumnName="FileMajorID" />
|
<ScalarProperty Name="FileMajorUser" ColumnName="FileMajorUser" />
|
<ScalarProperty Name="FilePros" ColumnName="FilePros" />
|
<ScalarProperty Name="IsCancel" ColumnName="IsCancel" />
|
<ScalarProperty Name="IsCombin" ColumnName="IsCombin" />
|
<ScalarProperty Name="FileCancelReason" ColumnName="FileCancelReason" />
|
<ScalarProperty Name="FileCombinNo" ColumnName="FileCombinNo" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="MailCatelog">
|
<EntityTypeMapping TypeName="developModel.MailCatelog">
|
<MappingFragment StoreEntitySet="MailCatelog">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="CID" ColumnName="CID" />
|
<ScalarProperty Name="CateID" ColumnName="CateID" />
|
<ScalarProperty Name="CateName" ColumnName="CateName" />
|
<ScalarProperty Name="parentID" ColumnName="parentID" />
|
<ScalarProperty Name="SeqNo" ColumnName="SeqNo" />
|
<ScalarProperty Name="IsActived" ColumnName="IsActived" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
|
<ScalarProperty Name="CreatedUser" ColumnName="CreatedUser" />
|
<ScalarProperty Name="ExpiredDays" ColumnName="ExpiredDays" />
|
<ScalarProperty Name="ReportNeed" ColumnName="ReportNeed" />
|
<ScalarProperty Name="OverDate" ColumnName="OverDate" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="Mailor">
|
<EntityTypeMapping TypeName="developModel.Mailor">
|
<MappingFragment StoreEntitySet="Mailor">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="MailorID" ColumnName="MailorID" />
|
<ScalarProperty Name="MailorName" ColumnName="MailorName" />
|
<ScalarProperty Name="Password" ColumnName="Password" />
|
<ScalarProperty Name="IDNum" ColumnName="IDNum" />
|
<ScalarProperty Name="Email" ColumnName="Email" />
|
<ScalarProperty Name="AliasEmail" ColumnName="AliasEmail" />
|
<ScalarProperty Name="MailorTel" ColumnName="MailorTel" />
|
<ScalarProperty Name="MailorAddr" ColumnName="MailorAddr" />
|
<ScalarProperty Name="Mailcount" ColumnName="Mailcount" />
|
<ScalarProperty Name="Sex" ColumnName="Sex" />
|
<ScalarProperty Name="City" ColumnName="City" />
|
<ScalarProperty Name="PostCode" ColumnName="PostCode" />
|
<ScalarProperty Name="edubackground" ColumnName="edubackground" />
|
<ScalarProperty Name="Mailorfex" ColumnName="Mailorfex" />
|
<ScalarProperty Name="Age" ColumnName="Age" />
|
<ScalarProperty Name="IsDemos" ColumnName="IsDemos" />
|
<ScalarProperty Name="Career" ColumnName="Career" />
|
<ScalarProperty Name="Occupation" ColumnName="Occupation" />
|
<ScalarProperty Name="IsActived" ColumnName="IsActived" />
|
<ScalarProperty Name="PowerNo" ColumnName="PowerNo" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="NewMail">
|
<EntityTypeMapping TypeName="developModel.NewMail">
|
<MappingFragment StoreEntitySet="NewMail">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="MsgID" ColumnName="MsgID" />
|
<ScalarProperty Name="MsgNo" ColumnName="MsgNo" />
|
<ScalarProperty Name="MID" ColumnName="MID" />
|
<ScalarProperty Name="MailorAcct" ColumnName="MailorAcct" />
|
<ScalarProperty Name="MailorDomain" ColumnName="MailorDomain" />
|
<ScalarProperty Name="MsgSubject" ColumnName="MsgSubject" />
|
<ScalarProperty Name="MsgContent" ColumnName="MsgContent" />
|
<ScalarProperty Name="AttachID" ColumnName="AttachID" />
|
<ScalarProperty Name="MsgAttr1" ColumnName="MsgAttr1" />
|
<ScalarProperty Name="MsgAttr2" ColumnName="MsgAttr2" />
|
<ScalarProperty Name="MsgAttr3" ColumnName="MsgAttr3" />
|
<ScalarProperty Name="MsgAttr4" ColumnName="MsgAttr4" />
|
<ScalarProperty Name="MsgAttr5" ColumnName="MsgAttr5" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="IsSatSvy" ColumnName="IsSatSvy" />
|
<ScalarProperty Name="IsHaveRefMail" ColumnName="IsHaveRefMail" />
|
<ScalarProperty Name="AllowedDate" ColumnName="AllowedDate" />
|
<ScalarProperty Name="UniReply" ColumnName="UniReply" />
|
<ScalarProperty Name="CreatedUser" ColumnName="CreatedUser" />
|
<ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
|
<ScalarProperty Name="LastMaintUser" ColumnName="LastMaintUser" />
|
<ScalarProperty Name="LastMaintDate" ColumnName="LastMaintDate" />
|
<ScalarProperty Name="IdentityCatalog" ColumnName="IdentityCatalog" />
|
<ScalarProperty Name="SatSvyKey" ColumnName="SatSvyKey" />
|
<ScalarProperty Name="IsStatement" ColumnName="IsStatement" />
|
<ScalarProperty Name="IsReAssign" ColumnName="IsReAssign" />
|
<ScalarProperty Name="StateCatalog" ColumnName="StateCatalog" />
|
<ScalarProperty Name="MajorDesc" ColumnName="MajorDesc" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="RefMail">
|
<EntityTypeMapping TypeName="developModel.RefMail">
|
<MappingFragment StoreEntitySet="RefMail">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="PreMsgNo" ColumnName="PreMsgNo" />
|
<ScalarProperty Name="MsgNo" ColumnName="MsgNo" />
|
<ScalarProperty Name="SeqNo" ColumnName="SeqNo" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="REP_01_M">
|
<EntityTypeMapping TypeName="developModel.REP_01_M">
|
<MappingFragment StoreEntitySet="REP_01_M">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="Unit" ColumnName="Unit" />
|
<ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
|
<ScalarProperty Name="CountDate" ColumnName="CountDate" />
|
<ScalarProperty Name="Column01" ColumnName="Column01" />
|
<ScalarProperty Name="Column02" ColumnName="Column02" />
|
<ScalarProperty Name="Column03" ColumnName="Column03" />
|
<ScalarProperty Name="Column04" ColumnName="Column04" />
|
<ScalarProperty Name="Column05" ColumnName="Column05" />
|
<ScalarProperty Name="Column0504" ColumnName="Column0504" />
|
<ScalarProperty Name="Column06" ColumnName="Column06" />
|
<ScalarProperty Name="Column0604" ColumnName="Column0604" />
|
<ScalarProperty Name="Column07" ColumnName="Column07" />
|
<ScalarProperty Name="Column0704" ColumnName="Column0704" />
|
<ScalarProperty Name="Column08" ColumnName="Column08" />
|
<ScalarProperty Name="Column0804" ColumnName="Column0804" />
|
<ScalarProperty Name="Column09" ColumnName="Column09" />
|
<ScalarProperty Name="Column0904" ColumnName="Column0904" />
|
<ScalarProperty Name="Column10" ColumnName="Column10" />
|
<ScalarProperty Name="Column1004" ColumnName="Column1004" />
|
<ScalarProperty Name="Column11" ColumnName="Column11" />
|
<ScalarProperty Name="Column1104" ColumnName="Column1104" />
|
<ScalarProperty Name="Column12" ColumnName="Column12" />
|
<ScalarProperty Name="Column1204" ColumnName="Column1204" />
|
<ScalarProperty Name="IsStatement" ColumnName="IsStatement" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="REP_02_M">
|
<EntityTypeMapping TypeName="developModel.REP_02_M">
|
<MappingFragment StoreEntitySet="REP_02_M">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="Unit" ColumnName="Unit" />
|
<ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
|
<ScalarProperty Name="CountDate" ColumnName="CountDate" />
|
<ScalarProperty Name="Column01" ColumnName="Column01" />
|
<ScalarProperty Name="Column02" ColumnName="Column02" />
|
<ScalarProperty Name="IsStatement" ColumnName="IsStatement" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="REP_03_M">
|
<EntityTypeMapping TypeName="developModel.REP_03_M">
|
<MappingFragment StoreEntitySet="REP_03_M">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="Unit" ColumnName="Unit" />
|
<ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
|
<ScalarProperty Name="CountDate" ColumnName="CountDate" />
|
<ScalarProperty Name="Column01" ColumnName="Column01" />
|
<ScalarProperty Name="Column02" ColumnName="Column02" />
|
<ScalarProperty Name="Column03" ColumnName="Column03" />
|
<ScalarProperty Name="Column04" ColumnName="Column04" />
|
<ScalarProperty Name="Column0409" ColumnName="Column0409" />
|
<ScalarProperty Name="Column05" ColumnName="Column05" />
|
<ScalarProperty Name="Column0504" ColumnName="Column0504" />
|
<ScalarProperty Name="Column06" ColumnName="Column06" />
|
<ScalarProperty Name="Column0604" ColumnName="Column0604" />
|
<ScalarProperty Name="Column07" ColumnName="Column07" />
|
<ScalarProperty Name="Column0704" ColumnName="Column0704" />
|
<ScalarProperty Name="Column08" ColumnName="Column08" />
|
<ScalarProperty Name="Column0809" ColumnName="Column0809" />
|
<ScalarProperty Name="Column09" ColumnName="Column09" />
|
<ScalarProperty Name="Column0903" ColumnName="Column0903" />
|
<ScalarProperty Name="Column10" ColumnName="Column10" />
|
<ScalarProperty Name="Column1003" ColumnName="Column1003" />
|
<ScalarProperty Name="Column11" ColumnName="Column11" />
|
<ScalarProperty Name="Column12" ColumnName="Column12" />
|
<ScalarProperty Name="Column13" ColumnName="Column13" />
|
<ScalarProperty Name="IsStatement" ColumnName="IsStatement" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="REP_04_M">
|
<EntityTypeMapping TypeName="developModel.REP_04_M">
|
<MappingFragment StoreEntitySet="REP_04_M">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="Catalog" ColumnName="Catalog" />
|
<ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
|
<ScalarProperty Name="CountDate" ColumnName="CountDate" />
|
<ScalarProperty Name="Column01" ColumnName="Column01" />
|
<ScalarProperty Name="Column02" ColumnName="Column02" />
|
<ScalarProperty Name="Column03" ColumnName="Column03" />
|
<ScalarProperty Name="Column04" ColumnName="Column04" />
|
<ScalarProperty Name="Column0409" ColumnName="Column0409" />
|
<ScalarProperty Name="Column05" ColumnName="Column05" />
|
<ScalarProperty Name="Column0504" ColumnName="Column0504" />
|
<ScalarProperty Name="Column06" ColumnName="Column06" />
|
<ScalarProperty Name="Column0604" ColumnName="Column0604" />
|
<ScalarProperty Name="Column07" ColumnName="Column07" />
|
<ScalarProperty Name="Column0704" ColumnName="Column0704" />
|
<ScalarProperty Name="Column08" ColumnName="Column08" />
|
<ScalarProperty Name="Column0809" ColumnName="Column0809" />
|
<ScalarProperty Name="Column09" ColumnName="Column09" />
|
<ScalarProperty Name="Column0903" ColumnName="Column0903" />
|
<ScalarProperty Name="Column10" ColumnName="Column10" />
|
<ScalarProperty Name="Column1003" ColumnName="Column1003" />
|
<ScalarProperty Name="Column11" ColumnName="Column11" />
|
<ScalarProperty Name="Column12" ColumnName="Column12" />
|
<ScalarProperty Name="Column13" ColumnName="Column13" />
|
<ScalarProperty Name="IsStatement" ColumnName="IsStatement" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SatSvy">
|
<EntityTypeMapping TypeName="developModel.SatSvy">
|
<MappingFragment StoreEntitySet="SatSvy">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="MsgNo" ColumnName="MsgNo" />
|
<ScalarProperty Name="LastMaintDate" ColumnName="LastMaintDate" />
|
<ScalarProperty Name="Version" ColumnName="Version" />
|
<ScalarProperty Name="maqa0" ColumnName="maqa0" />
|
<ScalarProperty Name="maqa1" ColumnName="maqa1" />
|
<ScalarProperty Name="maqa2" ColumnName="maqa2" />
|
<ScalarProperty Name="maqa3" ColumnName="maqa3" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SendQueue">
|
<EntityTypeMapping TypeName="developModel.SendQueue">
|
<MappingFragment StoreEntitySet="SendQueue">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="QueueID" ColumnName="QueueID" />
|
<ScalarProperty Name="Priority" ColumnName="Priority" />
|
<ScalarProperty Name="TmptXML" ColumnName="TmptXML" />
|
<ScalarProperty Name="AttachID" ColumnName="AttachID" />
|
<ScalarProperty Name="QueueType" ColumnName="QueueType" />
|
<ScalarProperty Name="DeliveryDate" ColumnName="DeliveryDate" />
|
<ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
|
<ScalarProperty Name="FinishedDate" ColumnName="FinishedDate" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SYS_AREA_M">
|
<EntityTypeMapping TypeName="developModel.SYS_AREA_M">
|
<MappingFragment StoreEntitySet="SYS_AREA_M">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="AreaID" ColumnName="AreaID" />
|
<ScalarProperty Name="AreaClass" ColumnName="AreaClass" />
|
<ScalarProperty Name="AreaName" ColumnName="AreaName" />
|
<ScalarProperty Name="ToUnit" ColumnName="ToUnit" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SYS_FUN_LIST_L">
|
<EntityTypeMapping TypeName="developModel.SYS_FUN_LIST_L">
|
<MappingFragment StoreEntitySet="SYS_FUN_LIST_L">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="FID" ColumnName="FID" />
|
<ScalarProperty Name="FunID" ColumnName="FunID" />
|
<ScalarProperty Name="FunName" ColumnName="FunName" />
|
<ScalarProperty Name="PFunID" ColumnName="PFunID" />
|
<ScalarProperty Name="FunPath" ColumnName="FunPath" />
|
<ScalarProperty Name="SortNum" ColumnName="SortNum" />
|
<ScalarProperty Name="IsVisible" ColumnName="IsVisible" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SYS_LOG_L">
|
<EntityTypeMapping TypeName="developModel.SYS_LOG_L">
|
<MappingFragment StoreEntitySet="SYS_LOG_L">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
|
<ScalarProperty Name="RemoteAddr" ColumnName="RemoteAddr" />
|
<ScalarProperty Name="GroupType" ColumnName="GroupType" />
|
<ScalarProperty Name="UserID" ColumnName="UserID" />
|
<ScalarProperty Name="UsePage" ColumnName="UsePage" />
|
<ScalarProperty Name="UserBrowser" ColumnName="UserBrowser" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SYS_RIGHTS_X">
|
<EntityTypeMapping TypeName="developModel.SYS_RIGHTS_X">
|
<MappingFragment StoreEntitySet="SYS_RIGHTS_X">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="RoleID" ColumnName="RoleID" />
|
<ScalarProperty Name="FunID" ColumnName="FunID" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SYS_ROLE_M">
|
<EntityTypeMapping TypeName="developModel.SYS_ROLE_M">
|
<MappingFragment StoreEntitySet="SYS_ROLE_M">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="RoleID" ColumnName="RoleID" />
|
<ScalarProperty Name="RoleName" ColumnName="RoleName" />
|
<ScalarProperty Name="IsActived" ColumnName="IsActived" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="RoleGroup" ColumnName="RoleGroup" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SYS_UNIT_M">
|
<EntityTypeMapping TypeName="developModel.SYS_UNIT_M">
|
<MappingFragment StoreEntitySet="SYS_UNIT_M">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="UID" ColumnName="UID" />
|
<ScalarProperty Name="UnitID" ColumnName="UnitID" />
|
<ScalarProperty Name="OUnitID" ColumnName="OUnitID" />
|
<ScalarProperty Name="UnitName" ColumnName="UnitName" />
|
<ScalarProperty Name="Email" ColumnName="Email" />
|
<ScalarProperty Name="ParentID" ColumnName="ParentID" />
|
<ScalarProperty Name="SeqNo" ColumnName="SeqNo" />
|
<ScalarProperty Name="UAgent" ColumnName="UAgent" />
|
<ScalarProperty Name="UAssembler" ColumnName="UAssembler" />
|
<ScalarProperty Name="IsActived" ColumnName="IsActived" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="GroupId" ColumnName="GroupId" />
|
<ScalarProperty Name="MasterUnit" ColumnName="MasterUnit" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SYS_UNIT_O_M">
|
<EntityTypeMapping TypeName="developModel.SYS_UNIT_O_M">
|
<MappingFragment StoreEntitySet="SYS_UNIT_O_M">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="UID" ColumnName="UID" />
|
<ScalarProperty Name="UnitID" ColumnName="UnitID" />
|
<ScalarProperty Name="OUnitID" ColumnName="OUnitID" />
|
<ScalarProperty Name="UnitName" ColumnName="UnitName" />
|
<ScalarProperty Name="Email" ColumnName="Email" />
|
<ScalarProperty Name="ParentID" ColumnName="ParentID" />
|
<ScalarProperty Name="SeqNo" ColumnName="SeqNo" />
|
<ScalarProperty Name="UAgent" ColumnName="UAgent" />
|
<ScalarProperty Name="UAssembler" ColumnName="UAssembler" />
|
<ScalarProperty Name="IsActived" ColumnName="IsActived" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="GroupId" ColumnName="GroupId" />
|
<ScalarProperty Name="MasterUnit" ColumnName="MasterUnit" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SYS_USER_M">
|
<EntityTypeMapping TypeName="developModel.SYS_USER_M">
|
<MappingFragment StoreEntitySet="SYS_USER_M">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
|
<ScalarProperty Name="UserID" ColumnName="UserID" />
|
<ScalarProperty Name="UserName" ColumnName="UserName" />
|
<ScalarProperty Name="Password" ColumnName="Password" />
|
<ScalarProperty Name="Email" ColumnName="Email" />
|
<ScalarProperty Name="TitleName" ColumnName="TitleName" />
|
<ScalarProperty Name="RoleID" ColumnName="RoleID" />
|
<ScalarProperty Name="UnitID" ColumnName="UnitID" />
|
<ScalarProperty Name="IsRest" ColumnName="IsRest" />
|
<ScalarProperty Name="IsLogin" ColumnName="IsLogin" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="IsActived" ColumnName="IsActived" />
|
<ScalarProperty Name="LastLoginDate" ColumnName="LastLoginDate" />
|
<ScalarProperty Name="OffTel" ColumnName="OffTel" />
|
<ScalarProperty Name="HomeTel" ColumnName="HomeTel" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SysCodeTable">
|
<EntityTypeMapping TypeName="developModel.SysCodeTable">
|
<MappingFragment StoreEntitySet="SysCodeTable">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="CodeID" ColumnName="CodeID" />
|
<ScalarProperty Name="CodeName" ColumnName="CodeName" />
|
<ScalarProperty Name="SeqNo" ColumnName="SeqNo" />
|
<ScalarProperty Name="CodeValue" ColumnName="CodeValue" />
|
<ScalarProperty Name="CodeDesc" ColumnName="CodeDesc" />
|
<ScalarProperty Name="ReserveField01" ColumnName="ReserveField01" />
|
<ScalarProperty Name="ReserveField02" ColumnName="ReserveField02" />
|
<ScalarProperty Name="IsActived" ColumnName="IsActived" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SysEnvVar">
|
<EntityTypeMapping TypeName="developModel.SysEnvVar">
|
<MappingFragment StoreEntitySet="SysEnvVar">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="CodeID" ColumnName="CodeID" />
|
<ScalarProperty Name="CodeName" ColumnName="CodeName" />
|
<ScalarProperty Name="CodeValue" ColumnName="CodeValue" />
|
<ScalarProperty Name="CodeDesc" ColumnName="CodeDesc" />
|
<ScalarProperty Name="IsActived" ColumnName="IsActived" />
|
<ScalarProperty Name="IsVisible" ColumnName="IsVisible" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SysFunLists">
|
<EntityTypeMapping TypeName="developModel.SysFunLists">
|
<MappingFragment StoreEntitySet="SysFunLists">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="FID" ColumnName="FID" />
|
<ScalarProperty Name="FunID" ColumnName="FunID" />
|
<ScalarProperty Name="FunName" ColumnName="FunName" />
|
<ScalarProperty Name="PFunID" ColumnName="PFunID" />
|
<ScalarProperty Name="FunPath" ColumnName="FunPath" />
|
<ScalarProperty Name="SortNum" ColumnName="SortNum" />
|
<ScalarProperty Name="IsVisible" ColumnName="IsVisible" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SysGlobalVar">
|
<EntityTypeMapping TypeName="developModel.SysGlobalVar">
|
<MappingFragment StoreEntitySet="SysGlobalVar">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="GVID" ColumnName="GVID" />
|
<ScalarProperty Name="GVName" ColumnName="GVName" />
|
<ScalarProperty Name="GVValue" ColumnName="GVValue" />
|
<ScalarProperty Name="GVDesc" ColumnName="GVDesc" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SysRights">
|
<EntityTypeMapping TypeName="developModel.SysRights">
|
<MappingFragment StoreEntitySet="SysRights">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="RoleID" ColumnName="RoleID" />
|
<ScalarProperty Name="FunID" ColumnName="FunID" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SysRole">
|
<EntityTypeMapping TypeName="developModel.SysRole">
|
<MappingFragment StoreEntitySet="SysRole">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="RoleID" ColumnName="RoleID" />
|
<ScalarProperty Name="RoleName" ColumnName="RoleName" />
|
<ScalarProperty Name="IsActived" ColumnName="IsActived" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="RoleGroup" ColumnName="RoleGroup" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SysTitle">
|
<EntityTypeMapping TypeName="developModel.SysTitle">
|
<MappingFragment StoreEntitySet="SysTitle">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="TitleID" ColumnName="TitleID" />
|
<ScalarProperty Name="TitleName" ColumnName="TitleName" />
|
<ScalarProperty Name="IsActived" ColumnName="IsActived" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SysTmpt">
|
<EntityTypeMapping TypeName="developModel.SysTmpt">
|
<MappingFragment StoreEntitySet="SysTmpt">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="TmptID" ColumnName="TmptID" />
|
<ScalarProperty Name="TmptName" ColumnName="TmptName" />
|
<ScalarProperty Name="TmptType" ColumnName="TmptType" />
|
<ScalarProperty Name="TmptContent" ColumnName="TmptContent" />
|
<ScalarProperty Name="LayoutType" ColumnName="LayoutType" />
|
<ScalarProperty Name="IsActived" ColumnName="IsActived" />
|
<ScalarProperty Name="CreatedUnit" ColumnName="CreatedUnit" />
|
<ScalarProperty Name="CreatedUser" ColumnName="CreatedUser" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SysUnit">
|
<EntityTypeMapping TypeName="developModel.SysUnit">
|
<MappingFragment StoreEntitySet="SysUnit">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="UID" ColumnName="UID" />
|
<ScalarProperty Name="UnitID" ColumnName="UnitID" />
|
<ScalarProperty Name="OUnitID" ColumnName="OUnitID" />
|
<ScalarProperty Name="UnitName" ColumnName="UnitName" />
|
<ScalarProperty Name="Email" ColumnName="Email" />
|
<ScalarProperty Name="ParentID" ColumnName="ParentID" />
|
<ScalarProperty Name="SeqNo" ColumnName="SeqNo" />
|
<ScalarProperty Name="UAgent" ColumnName="UAgent" />
|
<ScalarProperty Name="UAssembler" ColumnName="UAssembler" />
|
<ScalarProperty Name="IsActived" ColumnName="IsActived" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="GroupId" ColumnName="GroupId" />
|
<ScalarProperty Name="MasterUnit" ColumnName="MasterUnit" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SysUser">
|
<EntityTypeMapping TypeName="developModel.SysUser">
|
<MappingFragment StoreEntitySet="SysUser">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
|
<ScalarProperty Name="UserID" ColumnName="UserID" />
|
<ScalarProperty Name="UserName" ColumnName="UserName" />
|
<ScalarProperty Name="Password" ColumnName="Password" />
|
<ScalarProperty Name="Email" ColumnName="Email" />
|
<ScalarProperty Name="TitleName" ColumnName="TitleName" />
|
<ScalarProperty Name="RoleID" ColumnName="RoleID" />
|
<ScalarProperty Name="UnitID" ColumnName="UnitID" />
|
<ScalarProperty Name="IsRest" ColumnName="IsRest" />
|
<ScalarProperty Name="IsLogin" ColumnName="IsLogin" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="IsActived" ColumnName="IsActived" />
|
<ScalarProperty Name="LastLoginDate" ColumnName="LastLoginDate" />
|
<ScalarProperty Name="OffTel" ColumnName="OffTel" />
|
<ScalarProperty Name="HomeTel" ColumnName="HomeTel" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="SendQueue_Temp">
|
<EntityTypeMapping TypeName="developModel.SendQueue_Temp">
|
<MappingFragment StoreEntitySet="SendQueue_Temp">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="QueueID" ColumnName="QueueID" />
|
<ScalarProperty Name="Priority" ColumnName="Priority" />
|
<ScalarProperty Name="TmptXML" ColumnName="TmptXML" />
|
<ScalarProperty Name="AttachID" ColumnName="AttachID" />
|
<ScalarProperty Name="QueueType" ColumnName="QueueType" />
|
<ScalarProperty Name="DeliveryDate" ColumnName="DeliveryDate" />
|
<ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
|
<ScalarProperty Name="FinishedDate" ColumnName="FinishedDate" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="Worklist">
|
<EntityTypeMapping TypeName="developModel.Worklist">
|
<MappingFragment StoreEntitySet="Worklist">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="currentProsID" ColumnName="currentProsID" />
|
<ScalarProperty Name="MsgID" ColumnName="MsgID" />
|
<ScalarProperty Name="UserID" ColumnName="UserID" />
|
<ScalarProperty Name="WorkType" ColumnName="WorkType" />
|
<ScalarProperty Name="IsTerminate" ColumnName="IsTerminate" />
|
<ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
|
<ScalarProperty Name="CreatedUser" ColumnName="CreatedUser" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="AssignToMail">
|
<EntityTypeMapping TypeName="developModel.AssignToMail">
|
<MappingFragment StoreEntitySet="AssignToMail">
|
<ScalarProperty Name="OID" ColumnName="OID" />
|
<ScalarProperty Name="MsgID" ColumnName="MsgID" />
|
<ScalarProperty Name="MsgNo" ColumnName="MsgNo" />
|
<ScalarProperty Name="currentProsID" ColumnName="currentProsID" />
|
<ScalarProperty Name="parentProsID" ColumnName="parentProsID" />
|
<ScalarProperty Name="FromUnit" ColumnName="FromUnit" />
|
<ScalarProperty Name="ToUnit" ColumnName="ToUnit" />
|
<ScalarProperty Name="ToUser" ColumnName="ToUser" />
|
<ScalarProperty Name="DispatchedNum" ColumnName="DispatchedNum" />
|
<ScalarProperty Name="FinishedNum" ColumnName="FinishedNum" />
|
<ScalarProperty Name="Note" ColumnName="Note" />
|
<ScalarProperty Name="Response" ColumnName="Response" />
|
<ScalarProperty Name="AttachID" ColumnName="AttachID" />
|
<ScalarProperty Name="Version" ColumnName="Version" />
|
<ScalarProperty Name="MsgState" ColumnName="MsgState" />
|
<ScalarProperty Name="PressCount" ColumnName="PressCount" />
|
<ScalarProperty Name="UpperRcvDate" ColumnName="UpperRcvDate" />
|
<ScalarProperty Name="UpperDspDate" ColumnName="UpperDspDate" />
|
<ScalarProperty Name="SelfReceivedDate" ColumnName="SelfReceivedDate" />
|
<ScalarProperty Name="SelfExpiredDate" ColumnName="SelfExpiredDate" />
|
<ScalarProperty Name="ExpiredDays" ColumnName="ExpiredDays" />
|
<ScalarProperty Name="SelfDonedDate" ColumnName="SelfDonedDate" />
|
<ScalarProperty Name="WorkDays" ColumnName="WorkDays" />
|
<ScalarProperty Name="ClosedDate" ColumnName="ClosedDate" />
|
<ScalarProperty Name="RootWorkDays" ColumnName="RootWorkDays" />
|
<ScalarProperty Name="SelfOverdueDays" ColumnName="SelfOverdueDays" />
|
<ScalarProperty Name="IsMaster" ColumnName="IsMaster" />
|
<ScalarProperty Name="IsAssembled" ColumnName="IsAssembled" />
|
<ScalarProperty Name="IsApproved" ColumnName="IsApproved" />
|
<ScalarProperty Name="IsRejected" ColumnName="IsRejected" />
|
<ScalarProperty Name="IsExpired" ColumnName="IsExpired" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="IsQueued" ColumnName="IsQueued" />
|
<ScalarProperty Name="ReserveField01" ColumnName="ReserveField01" />
|
<ScalarProperty Name="ReserveField02" ColumnName="ReserveField02" />
|
<ScalarProperty Name="NoReq" ColumnName="NoReq" />
|
<ScalarProperty Name="Expr1" ColumnName="Expr1" />
|
<ScalarProperty Name="Expr2" ColumnName="Expr2" />
|
<ScalarProperty Name="Expr3" ColumnName="Expr3" />
|
<ScalarProperty Name="MID" ColumnName="MID" />
|
<ScalarProperty Name="MailorAcct" ColumnName="MailorAcct" />
|
<ScalarProperty Name="MailorDomain" ColumnName="MailorDomain" />
|
<ScalarProperty Name="MsgSubject" ColumnName="MsgSubject" />
|
<ScalarProperty Name="MsgContent" ColumnName="MsgContent" />
|
<ScalarProperty Name="Expr4" ColumnName="Expr4" />
|
<ScalarProperty Name="MsgAttr1" ColumnName="MsgAttr1" />
|
<ScalarProperty Name="MsgAttr2" ColumnName="MsgAttr2" />
|
<ScalarProperty Name="MsgAttr3" ColumnName="MsgAttr3" />
|
<ScalarProperty Name="MsgAttr4" ColumnName="MsgAttr4" />
|
<ScalarProperty Name="MsgAttr5" ColumnName="MsgAttr5" />
|
<ScalarProperty Name="Expr5" ColumnName="Expr5" />
|
<ScalarProperty Name="IsSatSvy" ColumnName="IsSatSvy" />
|
<ScalarProperty Name="IsHaveRefMail" ColumnName="IsHaveRefMail" />
|
<ScalarProperty Name="AllowedDate" ColumnName="AllowedDate" />
|
<ScalarProperty Name="UniReply" ColumnName="UniReply" />
|
<ScalarProperty Name="CreatedUser" ColumnName="CreatedUser" />
|
<ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
|
<ScalarProperty Name="LastMaintUser" ColumnName="LastMaintUser" />
|
<ScalarProperty Name="LastMaintDate" ColumnName="LastMaintDate" />
|
<ScalarProperty Name="IdentityCatalog" ColumnName="IdentityCatalog" />
|
<ScalarProperty Name="SatSvyKey" ColumnName="SatSvyKey" />
|
<ScalarProperty Name="MailorID" ColumnName="MailorID" />
|
<ScalarProperty Name="MailorName" ColumnName="MailorName" />
|
<ScalarProperty Name="IDNum" ColumnName="IDNum" />
|
<ScalarProperty Name="Email" ColumnName="Email" />
|
<ScalarProperty Name="AliasEmail" ColumnName="AliasEmail" />
|
<ScalarProperty Name="MailorTel" ColumnName="MailorTel" />
|
<ScalarProperty Name="MailorAddr" ColumnName="MailorAddr" />
|
<ScalarProperty Name="Mailcount" ColumnName="Mailcount" />
|
<ScalarProperty Name="Sex" ColumnName="Sex" />
|
<ScalarProperty Name="PostCode" ColumnName="PostCode" />
|
<ScalarProperty Name="City" ColumnName="City" />
|
<ScalarProperty Name="edubackground" ColumnName="edubackground" />
|
<ScalarProperty Name="Mailorfex" ColumnName="Mailorfex" />
|
<ScalarProperty Name="Age" ColumnName="Age" />
|
<ScalarProperty Name="Career" ColumnName="Career" />
|
<ScalarProperty Name="Occupation" ColumnName="Occupation" />
|
<ScalarProperty Name="IsActived" ColumnName="IsActived" />
|
<ScalarProperty Name="PowerNo" ColumnName="PowerNo" />
|
<ScalarProperty Name="FileCombinNo" ColumnName="FileCombinNo" />
|
<ScalarProperty Name="FileNo" ColumnName="FileNo" />
|
<ScalarProperty Name="FileCancelReason" ColumnName="FileCancelReason" />
|
<ScalarProperty Name="FileCheckUnit" ColumnName="FileCheckUnit" />
|
<ScalarProperty Name="FileCheckDate" ColumnName="FileCheckDate" />
|
<ScalarProperty Name="FileReceivedDate" ColumnName="FileReceivedDate" />
|
<ScalarProperty Name="FileMajorUnit" ColumnName="FileMajorUnit" />
|
<ScalarProperty Name="FileMajorID" ColumnName="FileMajorID" />
|
<ScalarProperty Name="FileMajorUser" ColumnName="FileMajorUser" />
|
<ScalarProperty Name="FilePros" ColumnName="FilePros" />
|
<ScalarProperty Name="StateCatalog" ColumnName="StateCatalog" />
|
<ScalarProperty Name="UnitName" ColumnName="UnitName" />
|
<ScalarProperty Name="CodeDesc" ColumnName="CodeDesc" />
|
<ScalarProperty Name="CodeID" ColumnName="CodeID" />
|
<ScalarProperty Name="IsStatement" ColumnName="IsStatement" />
|
<ScalarProperty Name="IsReAssign" ColumnName="IsReAssign" />
|
<ScalarProperty Name="IsCancel" ColumnName="IsCancel" />
|
<ScalarProperty Name="IsCombin" ColumnName="IsCombin" />
|
<ScalarProperty Name="CateName" ColumnName="CateName" />
|
<ScalarProperty Name="MailClass" ColumnName="MailClass" />
|
<ScalarProperty Name="IsSnReply" ColumnName="IsSnReply" />
|
<ScalarProperty Name="SnToUnit" ColumnName="SnToUnit" />
|
<ScalarProperty Name="MailState" ColumnName="MailState" />
|
<ScalarProperty Name="ReAssign" ColumnName="ReAssign" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="MailProcess">
|
<EntityTypeMapping TypeName="developModel.MailProcess">
|
<MappingFragment StoreEntitySet="MailProcess">
|
<ScalarProperty Name="ToUnit" ColumnName="ToUnit" />
|
<ScalarProperty Name="MsgID" ColumnName="MsgID" />
|
<ScalarProperty Name="MsgNo" ColumnName="MsgNo" />
|
<ScalarProperty Name="MID" ColumnName="MID" />
|
<ScalarProperty Name="MailorAcct" ColumnName="MailorAcct" />
|
<ScalarProperty Name="MailorDomain" ColumnName="MailorDomain" />
|
<ScalarProperty Name="MsgSubject" ColumnName="MsgSubject" />
|
<ScalarProperty Name="MsgContent" ColumnName="MsgContent" />
|
<ScalarProperty Name="AttachID" ColumnName="AttachID" />
|
<ScalarProperty Name="AllowedDate" ColumnName="AllowedDate" />
|
<ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
|
<ScalarProperty Name="currentProsID" ColumnName="currentProsID" />
|
<ScalarProperty Name="parentProsID" ColumnName="parentProsID" />
|
<ScalarProperty Name="Note" ColumnName="Note" />
|
<ScalarProperty Name="Response" ColumnName="Response" />
|
<ScalarProperty Name="MsgState" ColumnName="MsgState" />
|
<ScalarProperty Name="UpperRcvDate" ColumnName="UpperRcvDate" />
|
<ScalarProperty Name="UpperDspDate" ColumnName="UpperDspDate" />
|
<ScalarProperty Name="SelfReceivedDate" ColumnName="SelfReceivedDate" />
|
<ScalarProperty Name="SelfExpiredDate" ColumnName="SelfExpiredDate" />
|
<ScalarProperty Name="ExpiredDays" ColumnName="ExpiredDays" />
|
<ScalarProperty Name="SelfDonedDate" ColumnName="SelfDonedDate" />
|
<ScalarProperty Name="WorkDays" ColumnName="WorkDays" />
|
<ScalarProperty Name="ClosedDate" ColumnName="ClosedDate" />
|
<ScalarProperty Name="RootWorkDays" ColumnName="RootWorkDays" />
|
<ScalarProperty Name="SelfOverdueDays" ColumnName="SelfOverdueDays" />
|
<ScalarProperty Name="ReserveField01" ColumnName="ReserveField01" />
|
<ScalarProperty Name="ReserveField02" ColumnName="ReserveField02" />
|
<ScalarProperty Name="MsgAttr4" ColumnName="MsgAttr4" />
|
<ScalarProperty Name="UnitName" ColumnName="UnitName" />
|
<ScalarProperty Name="MailorName" ColumnName="MailorName" />
|
<ScalarProperty Name="Email" ColumnName="Email" />
|
<ScalarProperty Name="MsgAttr1" ColumnName="MsgAttr1" />
|
<ScalarProperty Name="MailorTel" ColumnName="MailorTel" />
|
<ScalarProperty Name="MailorAddr" ColumnName="MailorAddr" />
|
<ScalarProperty Name="Mailcount" ColumnName="Mailcount" />
|
<ScalarProperty Name="Sex" ColumnName="Sex" />
|
<ScalarProperty Name="City" ColumnName="City" />
|
<ScalarProperty Name="PostCode" ColumnName="PostCode" />
|
<ScalarProperty Name="edubackground" ColumnName="edubackground" />
|
<ScalarProperty Name="Mailorfex" ColumnName="Mailorfex" />
|
<ScalarProperty Name="Age" ColumnName="Age" />
|
<ScalarProperty Name="Career" ColumnName="Career" />
|
<ScalarProperty Name="Occupation" ColumnName="Occupation" />
|
<ScalarProperty Name="PowerNo" ColumnName="PowerNo" />
|
<ScalarProperty Name="IDNum" ColumnName="IDNum" />
|
<ScalarProperty Name="LastMaintUser" ColumnName="LastMaintUser" />
|
<ScalarProperty Name="LastMaintDate" ColumnName="LastMaintDate" />
|
<ScalarProperty Name="CreatedUser" ColumnName="CreatedUser" />
|
<ScalarProperty Name="IsReAssign" ColumnName="IsReAssign" />
|
<ScalarProperty Name="StateCatalog" ColumnName="StateCatalog" />
|
<ScalarProperty Name="SatSvyKey" ColumnName="SatSvyKey" />
|
<ScalarProperty Name="IsMaster" ColumnName="IsMaster" />
|
<ScalarProperty Name="IsAssembled" ColumnName="IsAssembled" />
|
<ScalarProperty Name="IsApproved" ColumnName="IsApproved" />
|
<ScalarProperty Name="IsRejected" ColumnName="IsRejected" />
|
<ScalarProperty Name="IsExpired" ColumnName="IsExpired" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="IsQueued" ColumnName="IsQueued" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="PieChart2">
|
<EntityTypeMapping TypeName="developModel.PieChart2">
|
<MappingFragment StoreEntitySet="PieChart2">
|
<ScalarProperty Name="MsgID" ColumnName="MsgID" />
|
<ScalarProperty Name="MsgNo" ColumnName="MsgNo" />
|
<ScalarProperty Name="MID" ColumnName="MID" />
|
<ScalarProperty Name="UnitName" ColumnName="UnitName" />
|
<ScalarProperty Name="CateName" ColumnName="CateName" />
|
<ScalarProperty Name="CateID" ColumnName="CateID" />
|
<ScalarProperty Name="IsActived" ColumnName="IsActived" />
|
<ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
|
<ScalarProperty Name="AllowedDate" ColumnName="AllowedDate" />
|
<ScalarProperty Name="UnitID" ColumnName="UnitID" />
|
<ScalarProperty Name="currentProsID" ColumnName="currentProsID" />
|
<ScalarProperty Name="parentProsID" ColumnName="parentProsID" />
|
<ScalarProperty Name="FromUnit" ColumnName="FromUnit" />
|
<ScalarProperty Name="ToUser" ColumnName="ToUser" />
|
<ScalarProperty Name="DispatchedNum" ColumnName="DispatchedNum" />
|
<ScalarProperty Name="FinishedNum" ColumnName="FinishedNum" />
|
<ScalarProperty Name="MsgState" ColumnName="MsgState" />
|
<ScalarProperty Name="SelfReceivedDate" ColumnName="SelfReceivedDate" />
|
<ScalarProperty Name="SelfExpiredDate" ColumnName="SelfExpiredDate" />
|
<ScalarProperty Name="ExpiredDays" ColumnName="ExpiredDays" />
|
<ScalarProperty Name="SelfDonedDate" ColumnName="SelfDonedDate" />
|
<ScalarProperty Name="WorkDays" ColumnName="WorkDays" />
|
<ScalarProperty Name="ClosedDate" ColumnName="ClosedDate" />
|
<ScalarProperty Name="RootWorkDays" ColumnName="RootWorkDays" />
|
<ScalarProperty Name="SelfOverdueDays" ColumnName="SelfOverdueDays" />
|
<ScalarProperty Name="ReserveField01" ColumnName="ReserveField01" />
|
<ScalarProperty Name="IsMaster" ColumnName="IsMaster" />
|
<ScalarProperty Name="IsAssembled" ColumnName="IsAssembled" />
|
<ScalarProperty Name="ToUnit" ColumnName="ToUnit" />
|
<ScalarProperty Name="maqa0" ColumnName="maqa0" />
|
<ScalarProperty Name="maqa1" ColumnName="maqa1" />
|
<ScalarProperty Name="LastMaintDate" ColumnName="LastMaintDate" />
|
<ScalarProperty Name="maqa2" ColumnName="maqa2" />
|
<ScalarProperty Name="maqa3" ColumnName="maqa3" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="FeaturesResult">
|
<EntityTypeMapping TypeName="developModel.FeaturesResult">
|
<MappingFragment StoreEntitySet="FeaturesResult">
|
<ScalarProperty Name="FilePros" ColumnName="FilePros" />
|
<ScalarProperty Name="FileReceivedDate" ColumnName="FileReceivedDate" />
|
<ScalarProperty Name="FileCheckDate" ColumnName="FileCheckDate" />
|
<ScalarProperty Name="FileCheckUnit" ColumnName="FileCheckUnit" />
|
<ScalarProperty Name="FileMajorID" ColumnName="FileMajorID" />
|
<ScalarProperty Name="FileMajorUser" ColumnName="FileMajorUser" />
|
<ScalarProperty Name="FileMajorUnit" ColumnName="FileMajorUnit" />
|
<ScalarProperty Name="PowerNo" ColumnName="PowerNo" />
|
<ScalarProperty Name="MailorAddr" ColumnName="MailorAddr" />
|
<ScalarProperty Name="MailorTel" ColumnName="MailorTel" />
|
<ScalarProperty Name="IsChecked" ColumnName="IsChecked" />
|
<ScalarProperty Name="StateCatalog" ColumnName="StateCatalog" />
|
<ScalarProperty Name="IsStatement" ColumnName="IsStatement" />
|
<ScalarProperty Name="IsCancel" ColumnName="IsCancel" />
|
<ScalarProperty Name="IsCombin" ColumnName="IsCombin" />
|
<ScalarProperty Name="FileCancelReason" ColumnName="FileCancelReason" />
|
<ScalarProperty Name="FileCombinNo" ColumnName="FileCombinNo" />
|
<ScalarProperty Name="Note" ColumnName="Note" />
|
<ScalarProperty Name="Expr1" ColumnName="Expr1" />
|
<ScalarProperty Name="UpperRcvDate" ColumnName="UpperRcvDate" />
|
<ScalarProperty Name="SelfExpiredDate" ColumnName="SelfExpiredDate" />
|
<ScalarProperty Name="ExpiredDays" ColumnName="ExpiredDays" />
|
<ScalarProperty Name="WorkDays" ColumnName="WorkDays" />
|
<ScalarProperty Name="RootWorkDays" ColumnName="RootWorkDays" />
|
<ScalarProperty Name="SelfOverdueDays" ColumnName="SelfOverdueDays" />
|
<ScalarProperty Name="UpperDspDate" ColumnName="UpperDspDate" />
|
<ScalarProperty Name="SelfDonedDate" ColumnName="SelfDonedDate" />
|
<ScalarProperty Name="ClosedDate" ColumnName="ClosedDate" />
|
<ScalarProperty Name="SelfReceivedDate" ColumnName="SelfReceivedDate" />
|
<ScalarProperty Name="MailClass" ColumnName="MailClass" />
|
<ScalarProperty Name="MailFrom" ColumnName="MailFrom" />
|
<ScalarProperty Name="FileNo" ColumnName="FileNo" />
|
<ScalarProperty Name="IsReAssign" ColumnName="IsReAssign" />
|
<ScalarProperty Name="IsQueued" ColumnName="IsQueued" />
|
<ScalarProperty Name="IsRejected" ColumnName="IsRejected" />
|
<ScalarProperty Name="IsAssembled" ColumnName="IsAssembled" />
|
<ScalarProperty Name="IsMaster" ColumnName="IsMaster" />
|
<ScalarProperty Name="IsApproved" ColumnName="IsApproved" />
|
<ScalarProperty Name="UnitName" ColumnName="UnitName" />
|
<ScalarProperty Name="IsSatSvy" ColumnName="IsSatSvy" />
|
<ScalarProperty Name="SatSvyKey" ColumnName="SatSvyKey" />
|
<ScalarProperty Name="IsExpired" ColumnName="IsExpired" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="CateName" ColumnName="CateName" />
|
<ScalarProperty Name="CodeDesc" ColumnName="CodeDesc" />
|
<ScalarProperty Name="MsgState" ColumnName="MsgState" />
|
<ScalarProperty Name="Response" ColumnName="Response" />
|
<ScalarProperty Name="parentProsID" ColumnName="parentProsID" />
|
<ScalarProperty Name="MsgID" ColumnName="MsgID" />
|
<ScalarProperty Name="currentProsID" ColumnName="currentProsID" />
|
<ScalarProperty Name="ToUnit" ColumnName="ToUnit" />
|
<ScalarProperty Name="FromUnit" ColumnName="FromUnit" />
|
<ScalarProperty Name="AttachID" ColumnName="AttachID" />
|
<ScalarProperty Name="MsgContent" ColumnName="MsgContent" />
|
<ScalarProperty Name="MsgSubject" ColumnName="MsgSubject" />
|
<ScalarProperty Name="UniReply" ColumnName="UniReply" />
|
<ScalarProperty Name="AllowedDate" ColumnName="AllowedDate" />
|
<ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
|
<ScalarProperty Name="Email" ColumnName="Email" />
|
<ScalarProperty Name="MailorName" ColumnName="MailorName" />
|
<ScalarProperty Name="MsgNo" ColumnName="MsgNo" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
</EntityContainerMapping>
|
</Mapping>
|
</edmx:Mappings>
|
</edmx:Runtime>
|
<!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
|
<Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
|
<Connection>
|
<DesignerInfoPropertySet>
|
<DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
|
</DesignerInfoPropertySet>
|
</Connection>
|
<Options>
|
<DesignerInfoPropertySet>
|
<DesignerProperty Name="ValidateOnBuild" Value="true" />
|
<DesignerProperty Name="EnablePluralization" Value="false" />
|
<DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
|
<DesignerProperty Name="UseLegacyProvider" Value="false" />
|
<DesignerProperty Name="CodeGenerationStrategy" Value="None" />
|
</DesignerInfoPropertySet>
|
</Options>
|
<!-- Diagram content (shape and connector positions) -->
|
<Diagrams></Diagrams>
|
</Designer>
|
</edmx:Edmx>
|
