1623 lines
198 KiB
XML
1623 lines
198 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DSMail" targetNamespace="http://tempuri.org/DSMail.xsd" xmlns:mstns="http://tempuri.org/DSMail.xsd" xmlns="http://tempuri.org/DSMail.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
|
|
<xs:annotation>
|
|
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<Connections>
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="gwcs" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="gwcs (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Project.Properties.Settings.GlobalReference.Default.gwcs" Provider="System.Data.SqlClient" />
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CS" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CS (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Project.Properties.Settings.GlobalReference.Default.gwcs" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MailFormTableAdapter" GeneratorDataComponentClassName="MailFormTableAdapter" Name="MailForm" UserDataComponentName="MailFormTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="gwcs (Settings)" DbObjectName="EE.dbo.MailForm" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM EETGW_MailForm
|
|
WHERE (idx = @Original_idx) AND (gcode = @Original_gcode) AND (@IsNull_cate = 1 AND cate IS NULL OR
|
|
cate = @Original_cate) AND (@IsNull_title = 1 AND title IS NULL OR
|
|
title = @Original_title) AND (@IsNull_selfTo = 1 AND selfTo IS NULL OR
|
|
selfTo = @Original_selfTo) AND (@IsNull_selfCC = 1 AND selfCC IS NULL OR
|
|
selfCC = @Original_selfCC) AND (@IsNull_selfBCC = 1 AND selfBCC IS NULL OR
|
|
selfBCC = @Original_selfBCC) AND (wuid = @Original_wuid) AND (wdate = @Original_wdate)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_idx" ColumnName="idx" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idx" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idx" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_gcode" ColumnName="gcode" DataSourceName="" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@Original_gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_cate" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_cate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_cate" ColumnName="cate" DataSourceName="" DataTypeServer="varchar(2)" DbType="AnsiString" Direction="Input" ParameterName="@Original_cate" Precision="0" ProviderType="VarChar" Scale="0" Size="2" SourceColumn="cate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_title" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_title" ColumnName="title" DataSourceName="" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_selfTo" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_selfTo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="selfTo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_selfTo" ColumnName="selfTo" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Original_selfTo" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="selfTo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_selfCC" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_selfCC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="selfCC" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_selfCC" ColumnName="selfCC" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Original_selfCC" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="selfCC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_selfBCC" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_selfBCC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="selfBCC" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_selfBCC" ColumnName="selfBCC" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Original_selfBCC" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="selfBCC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_wuid" ColumnName="wuid" DataSourceName="" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Original_wuid" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="wuid" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_wdate" ColumnName="wdate" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@Original_wdate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="wdate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO EETGW_MailForm
|
|
(gcode, cate, title, tolist, bcc, cc, subject, tail, body, selfTo, selfCC, selfBCC, wuid, wdate, exceptmail, exceptmailcc)
|
|
VALUES (@gcode,@cate,@title,@tolist,@bcc,@cc,@subject,@tail,@body,@selfTo,@selfCC,@selfBCC,@wuid,@wdate,@exceptmail,@exceptmailcc);
|
|
SELECT idx, gcode, cate, title, tolist, bcc, cc, subject, tail, body, selfTo, selfCC, selfBCC, wuid, wdate, exceptmail, exceptmailcc FROM MailForm WHERE (idx = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="gcode" ColumnName="gcode" DataSourceName="" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="cate" ColumnName="cate" DataSourceName="" DataTypeServer="varchar(2)" DbType="AnsiString" Direction="Input" ParameterName="@cate" Precision="0" ProviderType="VarChar" Scale="0" Size="2" SourceColumn="cate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="title" ColumnName="title" DataSourceName="" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="tolist" ColumnName="tolist" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@tolist" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="tolist" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="bcc" ColumnName="bcc" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@bcc" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="bcc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="cc" ColumnName="cc" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@cc" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="cc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="subject" ColumnName="subject" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@subject" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="subject" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="tail" ColumnName="tail" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@tail" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="tail" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="body" ColumnName="body" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@body" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="body" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="selfTo" ColumnName="selfTo" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@selfTo" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="selfTo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="selfCC" ColumnName="selfCC" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@selfCC" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="selfCC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="selfBCC" ColumnName="selfBCC" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@selfBCC" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="selfBCC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="wuid" ColumnName="wuid" DataSourceName="" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@wuid" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="wuid" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="wdate" ColumnName="wdate" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@wdate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="wdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="exceptmail" ColumnName="exceptmail" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@exceptmail" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="exceptmail" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="exceptmailcc" ColumnName="exceptmailcc" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@exceptmailcc" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="exceptmailcc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT idx, gcode, cate, title, tolist, bcc, cc, subject, tail, body, selfTo, selfCC, selfBCC, wuid, wdate, exceptmail, exceptmailcc
|
|
FROM MailForm WITH (nolock)
|
|
WHERE (gcode = @gcode) AND (cate = @cate)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="gcode" ColumnName="gcode" DataSourceName="EE.dbo.MailForm" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="cate" ColumnName="cate" DataSourceName="EE.dbo.MailForm" DataTypeServer="varchar(2)" DbType="AnsiString" Direction="Input" ParameterName="@cate" Precision="0" ProviderType="VarChar" Scale="0" Size="2" SourceColumn="cate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [MailForm] SET [gcode] = @gcode, [cate] = @cate, [title] = @title, [tolist] = @tolist, [bcc] = @bcc, [cc] = @cc, [subject] = @subject, [tail] = @tail, [body] = @body, [selfTo] = @selfTo, [selfCC] = @selfCC, [selfBCC] = @selfBCC, [wuid] = @wuid, [wdate] = @wdate, [exceptmail] = @exceptmail, [exceptmailcc] = @exceptmailcc WHERE (([idx] = @Original_idx) AND ([gcode] = @Original_gcode) AND ((@IsNull_cate = 1 AND [cate] IS NULL) OR ([cate] = @Original_cate)) AND ((@IsNull_title = 1 AND [title] IS NULL) OR ([title] = @Original_title)) AND ((@IsNull_selfTo = 1 AND [selfTo] IS NULL) OR ([selfTo] = @Original_selfTo)) AND ((@IsNull_selfCC = 1 AND [selfCC] IS NULL) OR ([selfCC] = @Original_selfCC)) AND ((@IsNull_selfBCC = 1 AND [selfBCC] IS NULL) OR ([selfBCC] = @Original_selfBCC)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate));
|
|
SELECT idx, gcode, cate, title, tolist, bcc, cc, subject, tail, body, selfTo, selfCC, selfBCC, wuid, wdate, exceptmail, exceptmailcc FROM MailForm WHERE (idx = @idx)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="gcode" ColumnName="gcode" DataSourceName="" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="cate" ColumnName="cate" DataSourceName="" DataTypeServer="varchar(2)" DbType="AnsiString" Direction="Input" ParameterName="@cate" Precision="0" ProviderType="VarChar" Scale="0" Size="2" SourceColumn="cate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="title" ColumnName="title" DataSourceName="" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="tolist" ColumnName="tolist" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@tolist" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="tolist" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="bcc" ColumnName="bcc" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@bcc" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="bcc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="cc" ColumnName="cc" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@cc" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="cc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="subject" ColumnName="subject" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@subject" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="subject" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="tail" ColumnName="tail" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@tail" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="tail" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="body" ColumnName="body" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@body" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="body" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="selfTo" ColumnName="selfTo" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@selfTo" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="selfTo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="selfCC" ColumnName="selfCC" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@selfCC" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="selfCC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="selfBCC" ColumnName="selfBCC" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@selfBCC" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="selfBCC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="wuid" ColumnName="wuid" DataSourceName="" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@wuid" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="wuid" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="wdate" ColumnName="wdate" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@wdate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="wdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="exceptmail" ColumnName="exceptmail" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@exceptmail" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="exceptmail" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="exceptmailcc" ColumnName="exceptmailcc" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@exceptmailcc" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="exceptmailcc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_idx" ColumnName="idx" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idx" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idx" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_gcode" ColumnName="gcode" DataSourceName="" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@Original_gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_cate" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_cate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_cate" ColumnName="cate" DataSourceName="" DataTypeServer="varchar(2)" DbType="AnsiString" Direction="Input" ParameterName="@Original_cate" Precision="0" ProviderType="VarChar" Scale="0" Size="2" SourceColumn="cate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_title" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_title" ColumnName="title" DataSourceName="" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_selfTo" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_selfTo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="selfTo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_selfTo" ColumnName="selfTo" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Original_selfTo" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="selfTo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_selfCC" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_selfCC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="selfCC" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_selfCC" ColumnName="selfCC" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Original_selfCC" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="selfCC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_selfBCC" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_selfBCC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="selfBCC" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_selfBCC" ColumnName="selfBCC" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Original_selfBCC" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="selfBCC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_wuid" ColumnName="wuid" DataSourceName="" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Original_wuid" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="wuid" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_wdate" ColumnName="wdate" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@Original_wdate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="wdate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="idx" ColumnName="idx" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@idx" Precision="0" Scale="0" Size="1024" SourceColumn="idx" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idx" DataSetColumn="idx" />
|
|
<Mapping SourceColumn="gcode" DataSetColumn="gcode" />
|
|
<Mapping SourceColumn="cate" DataSetColumn="cate" />
|
|
<Mapping SourceColumn="title" DataSetColumn="title" />
|
|
<Mapping SourceColumn="tolist" DataSetColumn="tolist" />
|
|
<Mapping SourceColumn="bcc" DataSetColumn="bcc" />
|
|
<Mapping SourceColumn="cc" DataSetColumn="cc" />
|
|
<Mapping SourceColumn="subject" DataSetColumn="subject" />
|
|
<Mapping SourceColumn="tail" DataSetColumn="tail" />
|
|
<Mapping SourceColumn="body" DataSetColumn="body" />
|
|
<Mapping SourceColumn="selfTo" DataSetColumn="selfTo" />
|
|
<Mapping SourceColumn="selfCC" DataSetColumn="selfCC" />
|
|
<Mapping SourceColumn="selfBCC" DataSetColumn="selfBCC" />
|
|
<Mapping SourceColumn="wuid" DataSetColumn="wuid" />
|
|
<Mapping SourceColumn="wdate" DataSetColumn="wdate" />
|
|
<Mapping SourceColumn="exceptmail" DataSetColumn="exceptmail" />
|
|
<Mapping SourceColumn="exceptmailcc" DataSetColumn="exceptmailcc" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MailDataTableAdapter" GeneratorDataComponentClassName="MailDataTableAdapter" Name="MailData" UserDataComponentName="MailDataTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="gwcs (Settings)" DbObjectName="EE.dbo.MailData" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [MailData] WHERE (([idx] = @Original_idx) AND ((@IsNull_project = 1 AND [project] IS NULL) OR ([project] = @Original_project)) AND ([gcode] = @Original_gcode) AND ((@IsNull_cate = 1 AND [cate] IS NULL) OR ([cate] = @Original_cate)) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_SendOK = 1 AND [SendOK] IS NULL) OR ([SendOK] = @Original_SendOK)) AND ((@IsNull_SendMsg = 1 AND [SendMsg] IS NULL) OR ([SendMsg] = @Original_SendMsg)) AND ((@IsNull_aidx = 1 AND [aidx] IS NULL) OR ([aidx] = @Original_aidx)) AND ((@IsNull_atime = 1 AND [atime] IS NULL) OR ([atime] = @Original_atime)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idx" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_project" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="project" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_project" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="project" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cate" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pdate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pdate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_pdate" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pdate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SendOK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SendOK" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_SendOK" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SendOK" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SendMsg" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SendMsg" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SendMsg" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SendMsg" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_aidx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="aidx" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_aidx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="aidx" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_atime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="atime" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_atime" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="atime" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_wuid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="wuid" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_wdate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="wdate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [MailData] ([project], [gcode], [cate], [pdate], [subject], [fromlist], [tolist], [bcc], [cc], [body], [SendOK], [SendMsg], [aidx], [atime], [wuid], [wdate]) VALUES (@project, @gcode, @cate, @pdate, @subject, @fromlist, @tolist, @bcc, @cc, @body, @SendOK, @SendMsg, @aidx, @atime, @wuid, @wdate);
|
|
SELECT idx, project, gcode, cate, pdate, subject, fromlist, tolist, bcc, cc, body, SendOK, SendMsg, aidx, atime, wuid, wdate FROM MailData WHERE (idx = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@project" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="project" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cate" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@pdate" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@subject" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="subject" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fromlist" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fromlist" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@tolist" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="tolist" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@bcc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="bcc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@body" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="body" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SendOK" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SendOK" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SendMsg" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SendMsg" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@aidx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="aidx" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@atime" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="atime" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@wuid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="wuid" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@wdate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="wdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT idx, project, gcode, cate, pdate, subject, fromlist, tolist, bcc, cc, body, SendOK, SendMsg, aidx, atime, wuid, wdate, suid, sdate, SendOK2, SendMsg2, suid2, sdate2
|
|
FROM MailData WITH (nolock)
|
|
WHERE (gcode = @gcode) AND (pdate = @pdate) AND (cate = @cate)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="gcode" ColumnName="gcode" DataSourceName="EE.dbo.MailData" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="pdate" ColumnName="pdate" DataSourceName="EE.dbo.MailData" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@pdate" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="pdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="cate" ColumnName="cate" DataSourceName="EE.dbo.MailData" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@cate" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="cate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [MailData] SET [project] = @project, [gcode] = @gcode, [cate] = @cate, [pdate] = @pdate, [subject] = @subject, [fromlist] = @fromlist, [tolist] = @tolist, [bcc] = @bcc, [cc] = @cc, [body] = @body, [SendOK] = @SendOK, [SendMsg] = @SendMsg, [aidx] = @aidx, [atime] = @atime, [wuid] = @wuid, [wdate] = @wdate WHERE (([idx] = @Original_idx) AND ((@IsNull_project = 1 AND [project] IS NULL) OR ([project] = @Original_project)) AND ([gcode] = @Original_gcode) AND ((@IsNull_cate = 1 AND [cate] IS NULL) OR ([cate] = @Original_cate)) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_SendOK = 1 AND [SendOK] IS NULL) OR ([SendOK] = @Original_SendOK)) AND ((@IsNull_SendMsg = 1 AND [SendMsg] IS NULL) OR ([SendMsg] = @Original_SendMsg)) AND ((@IsNull_aidx = 1 AND [aidx] IS NULL) OR ([aidx] = @Original_aidx)) AND ((@IsNull_atime = 1 AND [atime] IS NULL) OR ([atime] = @Original_atime)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate));
|
|
SELECT idx, project, gcode, cate, pdate, subject, fromlist, tolist, bcc, cc, body, SendOK, SendMsg, aidx, atime, wuid, wdate FROM MailData WHERE (idx = @idx)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="project" ColumnName="project" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@project" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="project" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="gcode" ColumnName="gcode" DataSourceName="" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="cate" ColumnName="cate" DataSourceName="" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@cate" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="cate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="pdate" ColumnName="pdate" DataSourceName="" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@pdate" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="pdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="subject" ColumnName="subject" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@subject" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="subject" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="fromlist" ColumnName="fromlist" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@fromlist" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="fromlist" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="tolist" ColumnName="tolist" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@tolist" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="tolist" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="bcc" ColumnName="bcc" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@bcc" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="bcc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="cc" ColumnName="cc" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@cc" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="cc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="body" ColumnName="body" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@body" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="body" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="SendOK" ColumnName="SendOK" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@SendOK" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="SendOK" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="SendMsg" ColumnName="SendMsg" DataSourceName="" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@SendMsg" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="SendMsg" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="aidx" ColumnName="aidx" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@aidx" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="aidx" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="atime" ColumnName="atime" DataSourceName="" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@atime" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="atime" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="wuid" ColumnName="wuid" DataSourceName="" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@wuid" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="wuid" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="wdate" ColumnName="wdate" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@wdate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="wdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_idx" ColumnName="idx" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idx" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idx" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_project" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_project" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="project" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_project" ColumnName="project" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_project" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="project" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_gcode" ColumnName="gcode" DataSourceName="" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@Original_gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_cate" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_cate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_cate" ColumnName="cate" DataSourceName="" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Original_cate" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="cate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_pdate" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_pdate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pdate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_pdate" ColumnName="pdate" DataSourceName="" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@Original_pdate" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="pdate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_SendOK" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_SendOK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SendOK" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_SendOK" ColumnName="SendOK" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Original_SendOK" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="SendOK" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_SendMsg" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_SendMsg" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SendMsg" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_SendMsg" ColumnName="SendMsg" DataSourceName="" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@Original_SendMsg" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="SendMsg" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_aidx" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_aidx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="aidx" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_aidx" ColumnName="aidx" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_aidx" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="aidx" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_atime" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_atime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="atime" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_atime" ColumnName="atime" DataSourceName="" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Original_atime" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="atime" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_wuid" ColumnName="wuid" DataSourceName="" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Original_wuid" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="wuid" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_wdate" ColumnName="wdate" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@Original_wdate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="wdate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="idx" ColumnName="idx" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@idx" Precision="0" Scale="0" Size="1024" SourceColumn="idx" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idx" DataSetColumn="idx" />
|
|
<Mapping SourceColumn="project" DataSetColumn="project" />
|
|
<Mapping SourceColumn="gcode" DataSetColumn="gcode" />
|
|
<Mapping SourceColumn="cate" DataSetColumn="cate" />
|
|
<Mapping SourceColumn="pdate" DataSetColumn="pdate" />
|
|
<Mapping SourceColumn="subject" DataSetColumn="subject" />
|
|
<Mapping SourceColumn="fromlist" DataSetColumn="fromlist" />
|
|
<Mapping SourceColumn="tolist" DataSetColumn="tolist" />
|
|
<Mapping SourceColumn="bcc" DataSetColumn="bcc" />
|
|
<Mapping SourceColumn="cc" DataSetColumn="cc" />
|
|
<Mapping SourceColumn="body" DataSetColumn="body" />
|
|
<Mapping SourceColumn="SendOK" DataSetColumn="SendOK" />
|
|
<Mapping SourceColumn="SendMsg" DataSetColumn="SendMsg" />
|
|
<Mapping SourceColumn="aidx" DataSetColumn="aidx" />
|
|
<Mapping SourceColumn="atime" DataSetColumn="atime" />
|
|
<Mapping SourceColumn="wuid" DataSetColumn="wuid" />
|
|
<Mapping SourceColumn="wdate" DataSetColumn="wdate" />
|
|
<Mapping SourceColumn="suid" DataSetColumn="suid" />
|
|
<Mapping SourceColumn="sdate" DataSetColumn="sdate" />
|
|
<Mapping SourceColumn="SendOK2" DataSetColumn="SendOK2" />
|
|
<Mapping SourceColumn="SendMsg2" DataSetColumn="SendMsg2" />
|
|
<Mapping SourceColumn="suid2" DataSetColumn="suid2" />
|
|
<Mapping SourceColumn="sdate2" DataSetColumn="sdate2" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MailAutoTableAdapter" GeneratorDataComponentClassName="MailAutoTableAdapter" Name="MailAuto" UserDataComponentName="MailAutoTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="gwcs (Settings)" DbObjectName="EE.dbo.MailAuto" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [MailAuto] WHERE (([idx] = @Original_idx) AND ((@IsNull_enable = 1 AND [enable] IS NULL) OR ([enable] = @Original_enable)) AND ([fidx] = @Original_fidx) AND ([gcode] = @Original_gcode) AND ((@IsNull_sdate = 1 AND [sdate] IS NULL) OR ([sdate] = @Original_sdate)) AND ((@IsNull_edate = 1 AND [edate] IS NULL) OR ([edate] = @Original_edate)) AND ((@IsNull_stime = 1 AND [stime] IS NULL) OR ([stime] = @Original_stime)) AND ((@IsNull_sday = 1 AND [sday] IS NULL) OR ([sday] = @Original_sday)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idx" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_enable" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="enable" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_enable" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="enable" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_fidx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fidx" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sdate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sdate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_sdate" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sdate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_edate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="edate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_edate" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="edate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_stime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="stime" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_stime" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="stime" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sday" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_sday" Precision="0" ProviderType="Binary" Scale="0" Size="0" SourceColumn="sday" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_wuid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="wuid" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_wdate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="wdate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [MailAuto] ([enable], [fidx], [gcode], [fromlist], [tolist], [subject], [body], [bcc], [cc], [sdate], [edate], [stime], [sday], [wuid], [wdate]) VALUES (@enable, @fidx, @gcode, @fromlist, @tolist, @subject, @body, @bcc, @cc, @sdate, @edate, @stime, @sday, @wuid, @wdate);
|
|
SELECT idx, enable, fidx, gcode, fromlist, tolist, subject, body, bcc, cc, sdate, edate, stime, sday, wuid, wdate FROM MailAuto WHERE (idx = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@enable" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="enable" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@fidx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fidx" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@fromlist" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="fromlist" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@tolist" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="tolist" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@subject" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="subject" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@body" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="body" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@bcc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="bcc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@sdate" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@edate" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="edate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@stime" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="stime" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@sday" Precision="0" ProviderType="Binary" Scale="0" Size="0" SourceColumn="sday" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@wuid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="wuid" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@wdate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="wdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT idx, enable, fidx, gcode, fromlist, tolist, subject, body, bcc, cc, sdate, edate, stime, sday, wuid, wdate
|
|
FROM MailAuto WITH (nolock)</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [MailAuto] SET [enable] = @enable, [fidx] = @fidx, [gcode] = @gcode, [fromlist] = @fromlist, [tolist] = @tolist, [subject] = @subject, [body] = @body, [bcc] = @bcc, [cc] = @cc, [sdate] = @sdate, [edate] = @edate, [stime] = @stime, [sday] = @sday, [wuid] = @wuid, [wdate] = @wdate WHERE (([idx] = @Original_idx) AND ((@IsNull_enable = 1 AND [enable] IS NULL) OR ([enable] = @Original_enable)) AND ([fidx] = @Original_fidx) AND ([gcode] = @Original_gcode) AND ((@IsNull_sdate = 1 AND [sdate] IS NULL) OR ([sdate] = @Original_sdate)) AND ((@IsNull_edate = 1 AND [edate] IS NULL) OR ([edate] = @Original_edate)) AND ((@IsNull_stime = 1 AND [stime] IS NULL) OR ([stime] = @Original_stime)) AND ((@IsNull_sday = 1 AND [sday] IS NULL) OR ([sday] = @Original_sday)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate));
|
|
SELECT idx, enable, fidx, gcode, fromlist, tolist, subject, body, bcc, cc, sdate, edate, stime, sday, wuid, wdate FROM MailAuto WHERE (idx = @idx)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="enable" ColumnName="enable" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@enable" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="enable" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="fidx" ColumnName="fidx" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@fidx" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="fidx" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="gcode" ColumnName="gcode" DataSourceName="" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="fromlist" ColumnName="fromlist" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@fromlist" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="fromlist" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="tolist" ColumnName="tolist" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@tolist" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="tolist" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="subject" ColumnName="subject" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@subject" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="subject" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="body" ColumnName="body" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@body" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="body" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="bcc" ColumnName="bcc" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@bcc" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="bcc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="cc" ColumnName="cc" DataSourceName="" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@cc" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="cc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="sdate" ColumnName="sdate" DataSourceName="" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@sdate" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="sdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="edate" ColumnName="edate" DataSourceName="" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@edate" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="edate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="stime" ColumnName="stime" DataSourceName="" DataTypeServer="varchar(8)" DbType="AnsiString" Direction="Input" ParameterName="@stime" Precision="0" ProviderType="VarChar" Scale="0" Size="8" SourceColumn="stime" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="sday" ColumnName="sday" DataSourceName="" DataTypeServer="binary(2)" DbType="Binary" Direction="Input" ParameterName="@sday" Precision="0" ProviderType="Binary" Scale="0" Size="2" SourceColumn="sday" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="wuid" ColumnName="wuid" DataSourceName="" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@wuid" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="wuid" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="wdate" ColumnName="wdate" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@wdate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="wdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_idx" ColumnName="idx" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_idx" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idx" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_enable" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_enable" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="enable" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_enable" ColumnName="enable" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Original_enable" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="enable" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_fidx" ColumnName="fidx" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_fidx" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="fidx" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_gcode" ColumnName="gcode" DataSourceName="" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@Original_gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_sdate" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_sdate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sdate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_sdate" ColumnName="sdate" DataSourceName="" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@Original_sdate" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="sdate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_edate" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_edate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="edate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_edate" ColumnName="edate" DataSourceName="" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@Original_edate" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="edate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_stime" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_stime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="stime" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_stime" ColumnName="stime" DataSourceName="" DataTypeServer="varchar(8)" DbType="AnsiString" Direction="Input" ParameterName="@Original_stime" Precision="0" ProviderType="VarChar" Scale="0" Size="8" SourceColumn="stime" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="IsNull_sday" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_sday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sday" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Original_sday" ColumnName="sday" DataSourceName="" DataTypeServer="binary(2)" DbType="Binary" Direction="Input" ParameterName="@Original_sday" Precision="0" ProviderType="Binary" Scale="0" Size="2" SourceColumn="sday" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_wuid" ColumnName="wuid" DataSourceName="" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Original_wuid" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="wuid" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_wdate" ColumnName="wdate" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@Original_wdate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="wdate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="idx" ColumnName="idx" DataSourceName="" DataTypeServer="unknown" DbType="Object" Direction="Input" ParameterName="@idx" Precision="0" Scale="0" Size="1024" SourceColumn="idx" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idx" DataSetColumn="idx" />
|
|
<Mapping SourceColumn="enable" DataSetColumn="enable" />
|
|
<Mapping SourceColumn="fidx" DataSetColumn="fidx" />
|
|
<Mapping SourceColumn="gcode" DataSetColumn="gcode" />
|
|
<Mapping SourceColumn="fromlist" DataSetColumn="fromlist" />
|
|
<Mapping SourceColumn="tolist" DataSetColumn="tolist" />
|
|
<Mapping SourceColumn="subject" DataSetColumn="subject" />
|
|
<Mapping SourceColumn="body" DataSetColumn="body" />
|
|
<Mapping SourceColumn="bcc" DataSetColumn="bcc" />
|
|
<Mapping SourceColumn="cc" DataSetColumn="cc" />
|
|
<Mapping SourceColumn="sdate" DataSetColumn="sdate" />
|
|
<Mapping SourceColumn="edate" DataSetColumn="edate" />
|
|
<Mapping SourceColumn="stime" DataSetColumn="stime" />
|
|
<Mapping SourceColumn="sday" DataSetColumn="sday" />
|
|
<Mapping SourceColumn="wuid" DataSetColumn="wuid" />
|
|
<Mapping SourceColumn="wdate" DataSetColumn="wdate" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="vMailingProjectScheduleTableAdapter" GeneratorDataComponentClassName="vMailingProjectScheduleTableAdapter" Name="vMailingProjectSchedule" UserDataComponentName="vMailingProjectScheduleTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="gwcs (Settings)" DbObjectName="EE.dbo.vMailingProjectSchedule" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT *
|
|
FROM vMailingProjectSchedule
|
|
WHERE (gcode = @gcode)
|
|
ORDER BY pdate, idx, seq</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="gcode" ColumnName="gcode" DataSourceName="EE.dbo.vMailingProjectSchedule" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="gcode" DataSetColumn="gcode" />
|
|
<Mapping SourceColumn="status" DataSetColumn="status" />
|
|
<Mapping SourceColumn="idx" DataSetColumn="idx" />
|
|
<Mapping SourceColumn="pdate" DataSetColumn="pdate" />
|
|
<Mapping SourceColumn="name" DataSetColumn="name" />
|
|
<Mapping SourceColumn="userManager" DataSetColumn="userManager" />
|
|
<Mapping SourceColumn="seq" DataSetColumn="seq" />
|
|
<Mapping SourceColumn="title" DataSetColumn="title" />
|
|
<Mapping SourceColumn="sw" DataSetColumn="sw" />
|
|
<Mapping SourceColumn="ew" DataSetColumn="ew" />
|
|
<Mapping SourceColumn="swa" DataSetColumn="swa" />
|
|
<Mapping SourceColumn="progress" DataSetColumn="progress" />
|
|
<Mapping SourceColumn="ewa" DataSetColumn="ewa" />
|
|
<Mapping SourceColumn="ww" DataSetColumn="ww" />
|
|
<Mapping SourceColumn="memo" DataSetColumn="memo" />
|
|
<Mapping SourceColumn="sidx" DataSetColumn="sidx" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProjectsIngListTableAdapter" GeneratorDataComponentClassName="ProjectsIngListTableAdapter" Name="ProjectsIngList" UserDataComponentName="ProjectsIngListTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="gwcs (Settings)" DbObjectName="EE.dbo.Projects" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [Projects] DEFAULT VALUES</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT idx, status, sdate, name, reqstaff, userManager, usermain, usersub, cnt, edate, costo, costn, orderno, userhw2
|
|
FROM Projects WITH (nolock)
|
|
WHERE (gcode = @gcode) AND (status = '진행') AND (ISNULL(isdel, 0) = 0)
|
|
ORDER BY sdate</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="gcode" ColumnName="gcode" DataSourceName="EE.dbo.Projects" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idx" DataSetColumn="idx" />
|
|
<Mapping SourceColumn="status" DataSetColumn="status" />
|
|
<Mapping SourceColumn="sdate" DataSetColumn="sdate" />
|
|
<Mapping SourceColumn="name" DataSetColumn="name" />
|
|
<Mapping SourceColumn="reqstaff" DataSetColumn="reqstaff" />
|
|
<Mapping SourceColumn="userManager" DataSetColumn="userManager" />
|
|
<Mapping SourceColumn="usermain" DataSetColumn="usermain" />
|
|
<Mapping SourceColumn="usersub" DataSetColumn="usersub" />
|
|
<Mapping SourceColumn="cnt" DataSetColumn="cnt" />
|
|
<Mapping SourceColumn="edate" DataSetColumn="edate" />
|
|
<Mapping SourceColumn="costo" DataSetColumn="costo" />
|
|
<Mapping SourceColumn="costn" DataSetColumn="costn" />
|
|
<Mapping SourceColumn="orderno" DataSetColumn="orderno" />
|
|
<Mapping SourceColumn="userhw2" DataSetColumn="userhw2" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EETGW_ProjectsScheduleTableAdapter" GeneratorDataComponentClassName="EETGW_ProjectsScheduleTableAdapter" Name="EETGW_ProjectsSchedule" UserDataComponentName="EETGW_ProjectsScheduleTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="gwcs (Settings)" DbObjectName="EE.dbo.EETGW_ProjectsSchedule" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [EETGW_ProjectsSchedule] WHERE (([idx] = @Original_idx))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idx" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT idx
|
|
FROM EETGW_ProjectsSchedule WITH (nolock)
|
|
WHERE (gcode = @gcode) AND (project = @project)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="gcode" ColumnName="gcode" DataSourceName="EE.dbo.EETGW_ProjectsSchedule" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="project" ColumnName="project" DataSourceName="EE.dbo.EETGW_ProjectsSchedule" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@project" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="project" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idx" DataSetColumn="idx" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="vJobReportForUserTableAdapter" GeneratorDataComponentClassName="vJobReportForUserTableAdapter" Name="vJobReportForUser" UserDataComponentName="vJobReportForUserTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="CS (Settings)" DbObjectName="EE.dbo.vJobReportForUser" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT id, MAX(name) AS name
|
|
FROM vJobReportForUser
|
|
WHERE (gcode = @gcode)
|
|
GROUP BY id
|
|
ORDER BY name</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="gcode" ColumnName="gcode" DataSourceName="EE.dbo.vJobReportForUser" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="id" DataSetColumn="id" />
|
|
<Mapping SourceColumn="name" DataSetColumn="name" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="JobReportTableAdapter" GeneratorDataComponentClassName="JobReportTableAdapter" Name="JobReport" UserDataComponentName="JobReportTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="gwcs (Settings)" DbObjectName="EE.dbo.JobReport" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [JobReport] ([gcode], [pdate], [pidx], [projectName], [uid], [requestpart], [package], [status], [type], [process], [hrs], [ot], [otStart], [otEnd], [import], [wuid], [wdate], [tag], [autoinput], [kisullv], [kisuldiv], [kisulamt], [ot2], [otReason], [otwuid], [ottime]) VALUES (@gcode, @pdate, @pidx, @projectName, @uid, @requestpart, @package, @status, @type, @process, @hrs, @ot, @otStart, @otEnd, @import, @wuid, @wdate, @tag, @autoinput, @kisullv, @kisuldiv, @kisulamt, @ot2, @otReason, @otwuid, @ottime)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@pdate" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@pidx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pidx" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@projectName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="projectName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@uid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@requestpart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="requestpart" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@package" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="package" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@process" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="process" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@hrs" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="hrs" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ot" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ot" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@otStart" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="otStart" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@otEnd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="otEnd" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@import" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="import" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@wuid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="wuid" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@wdate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="wdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@tag" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="tag" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@autoinput" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="autoinput" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@kisullv" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="kisullv" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@kisuldiv" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="kisuldiv" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@kisulamt" Precision="18" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="kisulamt" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ot2" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ot2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@otReason" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="otReason" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@otwuid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="otwuid" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ottime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ottime" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT idx, gcode, pdate, pidx, projectName, uid, requestpart, package, status, type, process, hrs, ot, otStart, otEnd, import, wuid, wdate, tag, autoinput, kisullv, kisuldiv, kisulamt, ot2, otReason,
|
|
otwuid, ottime
|
|
FROM JobReport WITH (nolock)
|
|
WHERE (gcode = @gcode) AND (uid = @uid) AND (pdate BETWEEN @sd AND @ed)
|
|
ORDER BY pdate</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="gcode" ColumnName="gcode" DataSourceName="EE.dbo.JobReport" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="uid" ColumnName="uid" DataSourceName="EE.dbo.JobReport" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@uid" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="sd" ColumnName="pdate" DataSourceName="EE.dbo.JobReport" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@sd" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="pdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="ed" ColumnName="pdate" DataSourceName="EE.dbo.JobReport" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@ed" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="pdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idx" DataSetColumn="idx" />
|
|
<Mapping SourceColumn="gcode" DataSetColumn="gcode" />
|
|
<Mapping SourceColumn="pdate" DataSetColumn="pdate" />
|
|
<Mapping SourceColumn="pidx" DataSetColumn="pidx" />
|
|
<Mapping SourceColumn="projectName" DataSetColumn="projectName" />
|
|
<Mapping SourceColumn="uid" DataSetColumn="uid" />
|
|
<Mapping SourceColumn="requestpart" DataSetColumn="requestpart" />
|
|
<Mapping SourceColumn="package" DataSetColumn="package" />
|
|
<Mapping SourceColumn="status" DataSetColumn="status" />
|
|
<Mapping SourceColumn="type" DataSetColumn="type" />
|
|
<Mapping SourceColumn="process" DataSetColumn="process" />
|
|
<Mapping SourceColumn="hrs" DataSetColumn="hrs" />
|
|
<Mapping SourceColumn="ot" DataSetColumn="ot" />
|
|
<Mapping SourceColumn="otStart" DataSetColumn="otStart" />
|
|
<Mapping SourceColumn="otEnd" DataSetColumn="otEnd" />
|
|
<Mapping SourceColumn="import" DataSetColumn="import" />
|
|
<Mapping SourceColumn="wuid" DataSetColumn="wuid" />
|
|
<Mapping SourceColumn="wdate" DataSetColumn="wdate" />
|
|
<Mapping SourceColumn="tag" DataSetColumn="tag" />
|
|
<Mapping SourceColumn="autoinput" DataSetColumn="autoinput" />
|
|
<Mapping SourceColumn="kisullv" DataSetColumn="kisullv" />
|
|
<Mapping SourceColumn="kisuldiv" DataSetColumn="kisuldiv" />
|
|
<Mapping SourceColumn="kisulamt" DataSetColumn="kisulamt" />
|
|
<Mapping SourceColumn="ot2" DataSetColumn="ot2" />
|
|
<Mapping SourceColumn="otReason" DataSetColumn="otReason" />
|
|
<Mapping SourceColumn="otwuid" DataSetColumn="otwuid" />
|
|
<Mapping SourceColumn="ottime" DataSetColumn="ottime" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="HolidayLIstTableAdapter" GeneratorDataComponentClassName="HolidayLIstTableAdapter" Name="HolidayLIst" UserDataComponentName="HolidayLIstTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="gwcs (Settings)" DbObjectName="EE.dbo.HolidayLIst" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [HolidayLIst] WHERE (([idx] = @Original_idx) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_free = 1 AND [free] IS NULL) OR ([free] = @Original_free)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idx" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pdate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pdate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_pdate" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pdate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_free" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="free" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_free" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="free" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_memo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="memo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_memo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="memo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_wuid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="wuid" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_wdate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="wdate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [HolidayLIst] ([pdate], [free], [memo], [wuid], [wdate]) VALUES (@pdate, @free, @memo, @wuid, @wdate);
|
|
SELECT idx, pdate, free, memo, wuid, wdate FROM HolidayLIst WHERE (idx = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@pdate" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@free" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="free" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@memo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="memo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@wuid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="wuid" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@wdate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="wdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT idx, pdate, free, memo, wuid, wdate
|
|
FROM HolidayLIst WITH (nolock)
|
|
WHERE (pdate = @pdate)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="pdate" ColumnName="pdate" DataSourceName="EE.dbo.HolidayLIst" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@pdate" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="pdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [HolidayLIst] SET [pdate] = @pdate, [free] = @free, [memo] = @memo, [wuid] = @wuid, [wdate] = @wdate WHERE (([idx] = @Original_idx) AND ((@IsNull_pdate = 1 AND [pdate] IS NULL) OR ([pdate] = @Original_pdate)) AND ((@IsNull_free = 1 AND [free] IS NULL) OR ([free] = @Original_free)) AND ((@IsNull_memo = 1 AND [memo] IS NULL) OR ([memo] = @Original_memo)) AND ([wuid] = @Original_wuid) AND ([wdate] = @Original_wdate));
|
|
SELECT idx, pdate, free, memo, wuid, wdate FROM HolidayLIst WHERE (idx = @idx)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@pdate" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@free" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="free" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@memo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="memo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@wuid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="wuid" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@wdate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="wdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idx" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pdate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pdate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_pdate" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pdate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_free" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="free" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_free" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="free" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_memo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="memo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_memo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="memo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_wuid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="wuid" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_wdate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="wdate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="idx" ColumnName="idx" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idx" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idx" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="idx" DataSetColumn="idx" />
|
|
<Mapping SourceColumn="pdate" DataSetColumn="pdate" />
|
|
<Mapping SourceColumn="free" DataSetColumn="free" />
|
|
<Mapping SourceColumn="memo" DataSetColumn="memo" />
|
|
<Mapping SourceColumn="wuid" DataSetColumn="wuid" />
|
|
<Mapping SourceColumn="wdate" DataSetColumn="wdate" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="vGroupUserTableAdapter" GeneratorDataComponentClassName="vGroupUserTableAdapter" Name="vGroupUser" UserDataComponentName="vGroupUserTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="CS (Settings)" DbObjectName="EE.dbo.vGroupUser" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT gcode, dept, level, name, nameE, grade, email, tel, indate, outdate, hp, place, ads_employNo, ads_title, ads_created, memo, processs, id, state, useJobReport, useUserState, password
|
|
FROM vGroupUser
|
|
WHERE (gcode = @gcode)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="gcode" ColumnName="gcode" DataSourceName="EE.dbo.vGroupUser" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="gcode" DataSetColumn="gcode" />
|
|
<Mapping SourceColumn="dept" DataSetColumn="dept" />
|
|
<Mapping SourceColumn="level" DataSetColumn="level" />
|
|
<Mapping SourceColumn="name" DataSetColumn="name" />
|
|
<Mapping SourceColumn="nameE" DataSetColumn="nameE" />
|
|
<Mapping SourceColumn="grade" DataSetColumn="grade" />
|
|
<Mapping SourceColumn="email" DataSetColumn="email" />
|
|
<Mapping SourceColumn="tel" DataSetColumn="tel" />
|
|
<Mapping SourceColumn="indate" DataSetColumn="indate" />
|
|
<Mapping SourceColumn="outdate" DataSetColumn="outdate" />
|
|
<Mapping SourceColumn="hp" DataSetColumn="hp" />
|
|
<Mapping SourceColumn="place" DataSetColumn="place" />
|
|
<Mapping SourceColumn="ads_employNo" DataSetColumn="ads_employNo" />
|
|
<Mapping SourceColumn="ads_title" DataSetColumn="ads_title" />
|
|
<Mapping SourceColumn="ads_created" DataSetColumn="ads_created" />
|
|
<Mapping SourceColumn="memo" DataSetColumn="memo" />
|
|
<Mapping SourceColumn="processs" DataSetColumn="processs" />
|
|
<Mapping SourceColumn="id" DataSetColumn="id" />
|
|
<Mapping SourceColumn="state" DataSetColumn="state" />
|
|
<Mapping SourceColumn="useJobReport" DataSetColumn="useJobReport" />
|
|
<Mapping SourceColumn="useUserState" DataSetColumn="useUserState" />
|
|
<Mapping SourceColumn="password" DataSetColumn="password" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="CS (Settings)" DbObjectName="EE.dbo.vGroupUser" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetyByID" GeneratorSourceName="FillByID" GetMethodModifier="Public" GetMethodName="GetyByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetyByID" UserSourceName="FillByID">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT gcode, dept, level, name, nameE, grade, email, tel, indate, outdate, hp, place, ads_employNo, ads_title, ads_created, memo, processs, id, state, useJobReport, useUserState, password
|
|
FROM vGroupUser
|
|
WHERE (gcode = @gcode) AND (id = @uid)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="gcode" ColumnName="gcode" DataSourceName="EE.dbo.vGroupUser" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="uid" ColumnName="id" DataSourceName="EE.dbo.vGroupUser" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@uid" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="JobReportDateListTableAdapter" GeneratorDataComponentClassName="JobReportDateListTableAdapter" Name="JobReportDateList" UserDataComponentName="JobReportDateListTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="gwcs (Settings)" DbObjectName="EE.dbo.JobReport" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT pdate
|
|
FROM JobReport WITH (nolock)
|
|
WHERE (gcode = @gcode) AND (pdate BETWEEN @sd AND @ed)
|
|
GROUP BY pdate
|
|
ORDER BY pdate</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="gcode" ColumnName="gcode" DataSourceName="EE.dbo.JobReport" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@gcode" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="gcode" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="sd" ColumnName="pdate" DataSourceName="EE.dbo.JobReport" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@sd" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="pdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="ed" ColumnName="pdate" DataSourceName="EE.dbo.JobReport" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@ed" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="pdate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="pdate" DataSetColumn="pdate" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="DSMail" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DSMail" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DSMail">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="MailForm" msprop:Generator_RowEvHandlerName="MailFormRowChangeEventHandler" msprop:Generator_RowDeletedName="MailFormRowDeleted" msprop:Generator_RowDeletingName="MailFormRowDeleting" msprop:Generator_RowEvArgName="MailFormRowChangeEvent" msprop:Generator_TablePropName="MailForm" msprop:Generator_RowChangedName="MailFormRowChanged" msprop:Generator_UserTableName="MailForm" msprop:Generator_RowChangingName="MailFormRowChanging" msprop:Generator_RowClassName="MailFormRow" msprop:Generator_TableClassName="MailFormDataTable" msprop:Generator_TableVarName="tableMailForm">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idx" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="idxColumn" msprop:Generator_ColumnPropNameInRow="idx" msprop:Generator_UserColumnName="idx" msprop:Generator_ColumnVarNameInTable="columnidx" type="xs:int" />
|
|
<xs:element name="gcode" msprop:Generator_ColumnPropNameInTable="gcodeColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="gcode" msprop:Generator_UserColumnName="gcode" msprop:Generator_ColumnVarNameInTable="columngcode">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cate" msprop:Generator_ColumnPropNameInTable="cateColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="cate" msprop:Generator_UserColumnName="cate" msprop:Generator_ColumnVarNameInTable="columncate" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_UserColumnName="title" msprop:Generator_ColumnVarNameInTable="columntitle" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="tolist" msprop:Generator_ColumnPropNameInTable="tolistColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="tolist" msprop:Generator_UserColumnName="tolist" msprop:Generator_ColumnVarNameInTable="columntolist" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="bcc" msprop:Generator_ColumnPropNameInTable="bccColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="bcc" msprop:Generator_UserColumnName="bcc" msprop:Generator_ColumnVarNameInTable="columnbcc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cc" msprop:Generator_ColumnPropNameInTable="ccColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="cc" msprop:Generator_UserColumnName="cc" msprop:Generator_ColumnVarNameInTable="columncc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="subject" msprop:Generator_ColumnPropNameInTable="subjectColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="subject" msprop:Generator_UserColumnName="subject" msprop:Generator_ColumnVarNameInTable="columnsubject" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="tail" msprop:Generator_ColumnPropNameInTable="tailColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="tail" msprop:Generator_UserColumnName="tail" msprop:Generator_ColumnVarNameInTable="columntail" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="body" msprop:Generator_ColumnPropNameInTable="bodyColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="body" msprop:Generator_UserColumnName="body" msprop:Generator_ColumnVarNameInTable="columnbody" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="selfTo" msprop:Generator_ColumnPropNameInTable="selfToColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="selfTo" msprop:Generator_UserColumnName="selfTo" msprop:Generator_ColumnVarNameInTable="columnselfTo" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="selfCC" msprop:Generator_ColumnPropNameInTable="selfCCColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="selfCC" msprop:Generator_UserColumnName="selfCC" msprop:Generator_ColumnVarNameInTable="columnselfCC" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="selfBCC" msprop:Generator_ColumnPropNameInTable="selfBCCColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="selfBCC" msprop:Generator_UserColumnName="selfBCC" msprop:Generator_ColumnVarNameInTable="columnselfBCC" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="wuid" msprop:Generator_ColumnPropNameInTable="wuidColumn" msprop:Generator_ColumnPropNameInRow="wuid" msprop:Generator_UserColumnName="wuid" msprop:Generator_ColumnVarNameInTable="columnwuid">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="wdate" msprop:Generator_ColumnPropNameInTable="wdateColumn" msprop:Generator_ColumnPropNameInRow="wdate" msprop:Generator_UserColumnName="wdate" msprop:Generator_ColumnVarNameInTable="columnwdate" type="xs:dateTime" />
|
|
<xs:element name="exceptmail" msprop:Generator_ColumnPropNameInTable="exceptmailColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="exceptmail" msprop:Generator_UserColumnName="exceptmail" msprop:Generator_ColumnVarNameInTable="columnexceptmail" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="exceptmailcc" msprop:Generator_ColumnPropNameInTable="exceptmailccColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="exceptmailcc" msprop:Generator_UserColumnName="exceptmailcc" msprop:Generator_ColumnVarNameInTable="columnexceptmailcc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="MailData" msprop:Generator_RowEvHandlerName="MailDataRowChangeEventHandler" msprop:Generator_RowDeletedName="MailDataRowDeleted" msprop:Generator_RowDeletingName="MailDataRowDeleting" msprop:Generator_RowEvArgName="MailDataRowChangeEvent" msprop:Generator_TablePropName="MailData" msprop:Generator_RowChangedName="MailDataRowChanged" msprop:Generator_UserTableName="MailData" msprop:Generator_RowChangingName="MailDataRowChanging" msprop:Generator_RowClassName="MailDataRow" msprop:Generator_TableClassName="MailDataDataTable" msprop:Generator_TableVarName="tableMailData">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idx" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="idxColumn" msprop:Generator_ColumnPropNameInRow="idx" msprop:Generator_UserColumnName="idx" msprop:Generator_ColumnVarNameInTable="columnidx" type="xs:int" />
|
|
<xs:element name="project" msprop:Generator_ColumnPropNameInTable="projectColumn" msprop:Generator_ColumnPropNameInRow="project" msprop:Generator_UserColumnName="project" msprop:Generator_ColumnVarNameInTable="columnproject" type="xs:int" minOccurs="0" />
|
|
<xs:element name="gcode" msprop:Generator_ColumnPropNameInTable="gcodeColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="gcode" msprop:Generator_UserColumnName="gcode" msprop:Generator_ColumnVarNameInTable="columngcode">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cate" msprop:Generator_ColumnPropNameInTable="cateColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="cate" msprop:Generator_UserColumnName="cate" msprop:Generator_ColumnVarNameInTable="columncate" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="pdate" msprop:Generator_ColumnPropNameInTable="pdateColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="pdate" msprop:Generator_UserColumnName="pdate" msprop:Generator_ColumnVarNameInTable="columnpdate" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="subject" msprop:Generator_ColumnPropNameInTable="subjectColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="subject" msprop:Generator_UserColumnName="subject" msprop:Generator_ColumnVarNameInTable="columnsubject" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="fromlist" msprop:Generator_ColumnPropNameInTable="fromlistColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="fromlist" msprop:Generator_UserColumnName="fromlist" msprop:Generator_ColumnVarNameInTable="columnfromlist" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="tolist" msprop:Generator_ColumnPropNameInTable="tolistColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="tolist" msprop:Generator_UserColumnName="tolist" msprop:Generator_ColumnVarNameInTable="columntolist" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="bcc" msprop:Generator_ColumnPropNameInTable="bccColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="bcc" msprop:Generator_UserColumnName="bcc" msprop:Generator_ColumnVarNameInTable="columnbcc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cc" msprop:Generator_ColumnPropNameInTable="ccColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="cc" msprop:Generator_UserColumnName="cc" msprop:Generator_ColumnVarNameInTable="columncc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="body" msprop:Generator_ColumnPropNameInTable="bodyColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="body" msprop:Generator_UserColumnName="body" msprop:Generator_ColumnVarNameInTable="columnbody" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="SendOK" msprop:Generator_ColumnPropNameInTable="SendOKColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="SendOK" msprop:Generator_UserColumnName="SendOK" msprop:Generator_ColumnVarNameInTable="columnSendOK" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="SendMsg" msprop:Generator_ColumnPropNameInTable="SendMsgColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="SendMsg" msprop:Generator_UserColumnName="SendMsg" msprop:Generator_ColumnVarNameInTable="columnSendMsg" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="aidx" msprop:Generator_ColumnPropNameInTable="aidxColumn" msprop:Generator_ColumnPropNameInRow="aidx" msprop:Generator_UserColumnName="aidx" msprop:Generator_ColumnVarNameInTable="columnaidx" type="xs:int" minOccurs="0" />
|
|
<xs:element name="atime" msprop:Generator_ColumnPropNameInTable="atimeColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="atime" msprop:Generator_UserColumnName="atime" msprop:Generator_ColumnVarNameInTable="columnatime" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="wuid" msprop:Generator_ColumnPropNameInTable="wuidColumn" msprop:Generator_ColumnPropNameInRow="wuid" msprop:Generator_UserColumnName="wuid" msprop:Generator_ColumnVarNameInTable="columnwuid">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="wdate" msprop:Generator_ColumnPropNameInTable="wdateColumn" msprop:Generator_ColumnPropNameInRow="wdate" msprop:Generator_UserColumnName="wdate" msprop:Generator_ColumnVarNameInTable="columnwdate" type="xs:dateTime" />
|
|
<xs:element name="suid" msprop:Generator_ColumnPropNameInRow="suid" msprop:Generator_ColumnPropNameInTable="suidColumn" msprop:Generator_ColumnVarNameInTable="columnsuid" msprop:Generator_UserColumnName="suid" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="sdate" msprop:Generator_ColumnPropNameInRow="sdate" msprop:Generator_ColumnPropNameInTable="sdateColumn" msprop:Generator_ColumnVarNameInTable="columnsdate" msprop:Generator_UserColumnName="sdate" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="SendOK2" msprop:Generator_ColumnPropNameInRow="SendOK2" msprop:Generator_ColumnPropNameInTable="SendOK2Column" msprop:Generator_ColumnVarNameInTable="columnSendOK2" msprop:Generator_UserColumnName="SendOK2" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="SendMsg2" msprop:Generator_ColumnPropNameInRow="SendMsg2" msprop:Generator_ColumnPropNameInTable="SendMsg2Column" msprop:Generator_ColumnVarNameInTable="columnSendMsg2" msprop:Generator_UserColumnName="SendMsg2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="suid2" msprop:Generator_ColumnPropNameInRow="suid2" msprop:Generator_ColumnPropNameInTable="suid2Column" msprop:Generator_ColumnVarNameInTable="columnsuid2" msprop:Generator_UserColumnName="suid2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="sdate2" msprop:Generator_ColumnPropNameInRow="sdate2" msprop:Generator_ColumnPropNameInTable="sdate2Column" msprop:Generator_ColumnVarNameInTable="columnsdate2" msprop:Generator_UserColumnName="sdate2" type="xs:dateTime" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="MailAuto" msprop:Generator_RowEvHandlerName="MailAutoRowChangeEventHandler" msprop:Generator_RowDeletedName="MailAutoRowDeleted" msprop:Generator_RowDeletingName="MailAutoRowDeleting" msprop:Generator_RowEvArgName="MailAutoRowChangeEvent" msprop:Generator_TablePropName="MailAuto" msprop:Generator_RowChangedName="MailAutoRowChanged" msprop:Generator_UserTableName="MailAuto" msprop:Generator_RowChangingName="MailAutoRowChanging" msprop:Generator_RowClassName="MailAutoRow" msprop:Generator_TableClassName="MailAutoDataTable" msprop:Generator_TableVarName="tableMailAuto">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idx" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="idxColumn" msprop:Generator_ColumnPropNameInRow="idx" msprop:Generator_UserColumnName="idx" msprop:Generator_ColumnVarNameInTable="columnidx" type="xs:int" />
|
|
<xs:element name="enable" msprop:Generator_ColumnPropNameInTable="enableColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="enable" msprop:Generator_UserColumnName="enable" msprop:Generator_ColumnVarNameInTable="columnenable" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="fidx" msprop:Generator_ColumnPropNameInTable="fidxColumn" msprop:Generator_ColumnPropNameInRow="fidx" msprop:Generator_UserColumnName="fidx" msprop:Generator_ColumnVarNameInTable="columnfidx" type="xs:int" />
|
|
<xs:element name="gcode" msprop:Generator_ColumnPropNameInTable="gcodeColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="gcode" msprop:Generator_UserColumnName="gcode" msprop:Generator_ColumnVarNameInTable="columngcode">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="fromlist" msprop:Generator_ColumnPropNameInTable="fromlistColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="fromlist" msprop:Generator_UserColumnName="fromlist" msprop:Generator_ColumnVarNameInTable="columnfromlist" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="tolist" msprop:Generator_ColumnPropNameInTable="tolistColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="tolist" msprop:Generator_UserColumnName="tolist" msprop:Generator_ColumnVarNameInTable="columntolist" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="subject" msprop:Generator_ColumnPropNameInTable="subjectColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="subject" msprop:Generator_UserColumnName="subject" msprop:Generator_ColumnVarNameInTable="columnsubject" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="body" msprop:Generator_ColumnPropNameInTable="bodyColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="body" msprop:Generator_UserColumnName="body" msprop:Generator_ColumnVarNameInTable="columnbody" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="bcc" msprop:Generator_ColumnPropNameInTable="bccColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="bcc" msprop:Generator_UserColumnName="bcc" msprop:Generator_ColumnVarNameInTable="columnbcc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cc" msprop:Generator_ColumnPropNameInTable="ccColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="cc" msprop:Generator_UserColumnName="cc" msprop:Generator_ColumnVarNameInTable="columncc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="sdate" msprop:Generator_ColumnPropNameInTable="sdateColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="sdate" msprop:Generator_UserColumnName="sdate" msprop:Generator_ColumnVarNameInTable="columnsdate" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="edate" msprop:Generator_ColumnPropNameInTable="edateColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="edate" msprop:Generator_UserColumnName="edate" msprop:Generator_ColumnVarNameInTable="columnedate" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="stime" msprop:Generator_ColumnPropNameInTable="stimeColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="stime" msprop:Generator_UserColumnName="stime" msprop:Generator_ColumnVarNameInTable="columnstime" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="sday" msprop:Generator_ColumnPropNameInTable="sdayColumn" msprop:Generator_ColumnPropNameInRow="sday" msprop:Generator_UserColumnName="sday" msprop:Generator_ColumnVarNameInTable="columnsday" type="xs:base64Binary" minOccurs="0" />
|
|
<xs:element name="wuid" msprop:Generator_ColumnPropNameInTable="wuidColumn" msprop:Generator_ColumnPropNameInRow="wuid" msprop:Generator_UserColumnName="wuid" msprop:Generator_ColumnVarNameInTable="columnwuid">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="wdate" msprop:Generator_ColumnPropNameInTable="wdateColumn" msprop:Generator_ColumnPropNameInRow="wdate" msprop:Generator_UserColumnName="wdate" msprop:Generator_ColumnVarNameInTable="columnwdate" type="xs:dateTime" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="vMailingProjectSchedule" msprop:Generator_RowEvHandlerName="vMailingProjectScheduleRowChangeEventHandler" msprop:Generator_RowDeletedName="vMailingProjectScheduleRowDeleted" msprop:Generator_RowDeletingName="vMailingProjectScheduleRowDeleting" msprop:Generator_RowEvArgName="vMailingProjectScheduleRowChangeEvent" msprop:Generator_TablePropName="vMailingProjectSchedule" msprop:Generator_RowChangedName="vMailingProjectScheduleRowChanged" msprop:Generator_UserTableName="vMailingProjectSchedule" msprop:Generator_RowChangingName="vMailingProjectScheduleRowChanging" msprop:Generator_RowClassName="vMailingProjectScheduleRow" msprop:Generator_TableClassName="vMailingProjectScheduleDataTable" msprop:Generator_TableVarName="tablevMailingProjectSchedule">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="gcode" msprop:Generator_ColumnPropNameInTable="gcodeColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="gcode" msprop:Generator_UserColumnName="gcode" msprop:Generator_ColumnVarNameInTable="columngcode">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_UserColumnName="status" msprop:Generator_ColumnVarNameInTable="columnstatus" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="idx" msprop:Generator_ColumnPropNameInTable="idxColumn" msprop:Generator_ColumnPropNameInRow="idx" msprop:Generator_UserColumnName="idx" msprop:Generator_ColumnVarNameInTable="columnidx" type="xs:int" />
|
|
<xs:element name="pdate" msprop:Generator_ColumnPropNameInTable="pdateColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="pdate" msprop:Generator_UserColumnName="pdate" msprop:Generator_ColumnVarNameInTable="columnpdate" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="userManager" msprop:Generator_ColumnPropNameInTable="userManagerColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="userManager" msprop:Generator_UserColumnName="userManager" msprop:Generator_ColumnVarNameInTable="columnuserManager" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="seq" msprop:Generator_ColumnPropNameInTable="seqColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="seq" msprop:Generator_UserColumnName="seq" msprop:Generator_ColumnVarNameInTable="columnseq" type="xs:int" minOccurs="0" />
|
|
<xs:element name="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_UserColumnName="title" msprop:Generator_ColumnVarNameInTable="columntitle" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="sw" msprop:Generator_ColumnPropNameInTable="swColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="sw" msprop:Generator_UserColumnName="sw" msprop:Generator_ColumnVarNameInTable="columnsw" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ew" msprop:Generator_ColumnPropNameInTable="ewColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="ew" msprop:Generator_UserColumnName="ew" msprop:Generator_ColumnVarNameInTable="columnew" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="swa" msprop:Generator_ColumnPropNameInTable="swaColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="swa" msprop:Generator_UserColumnName="swa" msprop:Generator_ColumnVarNameInTable="columnswa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="progress" msprop:Generator_ColumnPropNameInTable="progressColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="progress" msprop:Generator_UserColumnName="progress" msprop:Generator_ColumnVarNameInTable="columnprogress" type="xs:int" minOccurs="0" />
|
|
<xs:element name="ewa" msprop:Generator_ColumnPropNameInTable="ewaColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="ewa" msprop:Generator_UserColumnName="ewa" msprop:Generator_ColumnVarNameInTable="columnewa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ww" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="wwColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="ww" msprop:Generator_UserColumnName="ww" msprop:Generator_ColumnVarNameInTable="columnww" type="xs:int" minOccurs="0" />
|
|
<xs:element name="memo" msprop:Generator_ColumnPropNameInTable="memoColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="memo" msprop:Generator_UserColumnName="memo" msprop:Generator_ColumnVarNameInTable="columnmemo" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="sidx" msprop:Generator_ColumnPropNameInTable="sidxColumn" msprop:Generator_ColumnPropNameInRow="sidx" msprop:Generator_UserColumnName="sidx" msprop:Generator_ColumnVarNameInTable="columnsidx" type="xs:int" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="ProjectsIngList" msprop:Generator_RowEvHandlerName="ProjectsIngListRowChangeEventHandler" msprop:Generator_RowDeletedName="ProjectsIngListRowDeleted" msprop:Generator_RowDeletingName="ProjectsIngListRowDeleting" msprop:Generator_RowEvArgName="ProjectsIngListRowChangeEvent" msprop:Generator_TablePropName="ProjectsIngList" msprop:Generator_RowChangedName="ProjectsIngListRowChanged" msprop:Generator_UserTableName="ProjectsIngList" msprop:Generator_RowChangingName="ProjectsIngListRowChanging" msprop:Generator_RowClassName="ProjectsIngListRow" msprop:Generator_TableClassName="ProjectsIngListDataTable" msprop:Generator_TableVarName="tableProjectsIngList">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idx" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="idxColumn" msprop:Generator_ColumnPropNameInRow="idx" msprop:Generator_UserColumnName="idx" msprop:Generator_ColumnVarNameInTable="columnidx" type="xs:int" />
|
|
<xs:element name="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_UserColumnName="status" msprop:Generator_ColumnVarNameInTable="columnstatus" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="sdate" msprop:Generator_ColumnPropNameInTable="sdateColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="sdate" msprop:Generator_UserColumnName="sdate" msprop:Generator_ColumnVarNameInTable="columnsdate" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="reqstaff" msprop:Generator_ColumnPropNameInTable="reqstaffColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="reqstaff" msprop:Generator_UserColumnName="reqstaff" msprop:Generator_ColumnVarNameInTable="columnreqstaff" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="userManager" msprop:Generator_ColumnPropNameInTable="userManagerColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="userManager" msprop:Generator_UserColumnName="userManager" msprop:Generator_ColumnVarNameInTable="columnuserManager" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="usermain" msprop:Generator_ColumnPropNameInTable="usermainColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="usermain" msprop:Generator_UserColumnName="usermain" msprop:Generator_ColumnVarNameInTable="columnusermain" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="usersub" msprop:Generator_ColumnPropNameInTable="usersubColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="usersub" msprop:Generator_UserColumnName="usersub" msprop:Generator_ColumnVarNameInTable="columnusersub" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cnt" msprop:Generator_ColumnPropNameInTable="cntColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="cnt" msprop:Generator_UserColumnName="cnt" msprop:Generator_ColumnVarNameInTable="columncnt" type="xs:int" minOccurs="0" />
|
|
<xs:element name="edate" msprop:Generator_ColumnPropNameInTable="edateColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="edate" msprop:Generator_UserColumnName="edate" msprop:Generator_ColumnVarNameInTable="columnedate" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="costo" msprop:Generator_ColumnPropNameInTable="costoColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="costo" msprop:Generator_UserColumnName="costo" msprop:Generator_ColumnVarNameInTable="columncosto" type="xs:double" minOccurs="0" />
|
|
<xs:element name="costn" msprop:Generator_ColumnPropNameInTable="costnColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="costn" msprop:Generator_UserColumnName="costn" msprop:Generator_ColumnVarNameInTable="columncostn" type="xs:double" minOccurs="0" />
|
|
<xs:element name="orderno" msprop:Generator_ColumnPropNameInTable="ordernoColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="orderno" msprop:Generator_UserColumnName="orderno" msprop:Generator_ColumnVarNameInTable="columnorderno" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="userhw2" msprop:Generator_ColumnPropNameInTable="userhw2Column" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="userhw2" msprop:Generator_UserColumnName="userhw2" msprop:Generator_ColumnVarNameInTable="columnuserhw2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="EETGW_ProjectsSchedule" msprop:Generator_RowEvHandlerName="EETGW_ProjectsScheduleRowChangeEventHandler" msprop:Generator_RowDeletedName="EETGW_ProjectsScheduleRowDeleted" msprop:Generator_RowDeletingName="EETGW_ProjectsScheduleRowDeleting" msprop:Generator_RowEvArgName="EETGW_ProjectsScheduleRowChangeEvent" msprop:Generator_TablePropName="EETGW_ProjectsSchedule" msprop:Generator_RowChangedName="EETGW_ProjectsScheduleRowChanged" msprop:Generator_UserTableName="EETGW_ProjectsSchedule" msprop:Generator_RowChangingName="EETGW_ProjectsScheduleRowChanging" msprop:Generator_RowClassName="EETGW_ProjectsScheduleRow" msprop:Generator_TableClassName="EETGW_ProjectsScheduleDataTable" msprop:Generator_TableVarName="tableEETGW_ProjectsSchedule">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idx" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="idxColumn" msprop:Generator_ColumnPropNameInRow="idx" msprop:Generator_UserColumnName="idx" msprop:Generator_ColumnVarNameInTable="columnidx" type="xs:int" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="vJobReportForUser" msprop:Generator_RowEvHandlerName="vJobReportForUserRowChangeEventHandler" msprop:Generator_RowDeletedName="vJobReportForUserRowDeleted" msprop:Generator_RowDeletingName="vJobReportForUserRowDeleting" msprop:Generator_RowEvArgName="vJobReportForUserRowChangeEvent" msprop:Generator_TablePropName="vJobReportForUser" msprop:Generator_RowChangedName="vJobReportForUserRowChanged" msprop:Generator_UserTableName="vJobReportForUser" msprop:Generator_RowChangingName="vJobReportForUserRowChanging" msprop:Generator_RowClassName="vJobReportForUserRow" msprop:Generator_TableClassName="vJobReportForUserDataTable" msprop:Generator_TableVarName="tablevJobReportForUser">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="name" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="JobReport" msprop:Generator_RowEvHandlerName="JobReportRowChangeEventHandler" msprop:Generator_RowDeletedName="JobReportRowDeleted" msprop:Generator_RowDeletingName="JobReportRowDeleting" msprop:Generator_RowEvArgName="JobReportRowChangeEvent" msprop:Generator_TablePropName="JobReport" msprop:Generator_RowChangedName="JobReportRowChanged" msprop:Generator_UserTableName="JobReport" msprop:Generator_RowChangingName="JobReportRowChanging" msprop:Generator_RowClassName="JobReportRow" msprop:Generator_TableClassName="JobReportDataTable" msprop:Generator_TableVarName="tableJobReport">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idx" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="idxColumn" msprop:Generator_ColumnPropNameInRow="idx" msprop:Generator_UserColumnName="idx" msprop:Generator_ColumnVarNameInTable="columnidx" type="xs:int" />
|
|
<xs:element name="gcode" msprop:Generator_ColumnPropNameInTable="gcodeColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="gcode" msprop:Generator_UserColumnName="gcode" msprop:Generator_ColumnVarNameInTable="columngcode">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="pdate" msprop:Generator_ColumnPropNameInTable="pdateColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="pdate" msprop:Generator_UserColumnName="pdate" msprop:Generator_ColumnVarNameInTable="columnpdate" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="pidx" msprop:Generator_ColumnPropNameInTable="pidxColumn" msprop:Generator_ColumnPropNameInRow="pidx" msprop:Generator_UserColumnName="pidx" msprop:Generator_ColumnVarNameInTable="columnpidx" type="xs:int" minOccurs="0" />
|
|
<xs:element name="projectName" msprop:Generator_ColumnPropNameInTable="projectNameColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="projectName" msprop:Generator_UserColumnName="projectName" msprop:Generator_ColumnVarNameInTable="columnprojectName" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="uid" msprop:Generator_ColumnPropNameInTable="uidColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="uid" msprop:Generator_UserColumnName="uid" msprop:Generator_ColumnVarNameInTable="columnuid" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="requestpart" msprop:Generator_ColumnPropNameInTable="requestpartColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="requestpart" msprop:Generator_UserColumnName="requestpart" msprop:Generator_ColumnVarNameInTable="columnrequestpart" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="package" msprop:Generator_ColumnPropNameInTable="packageColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="package" msprop:Generator_UserColumnName="package" msprop:Generator_ColumnVarNameInTable="columnpackage" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_UserColumnName="status" msprop:Generator_ColumnVarNameInTable="columnstatus" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="type" msprop:Generator_ColumnPropNameInTable="typeColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="type" msprop:Generator_UserColumnName="type" msprop:Generator_ColumnVarNameInTable="columntype" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="process" msprop:Generator_ColumnPropNameInTable="processColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="process" msprop:Generator_UserColumnName="process" msprop:Generator_ColumnVarNameInTable="columnprocess" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="hrs" msprop:Generator_ColumnPropNameInTable="hrsColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="hrs" msprop:Generator_UserColumnName="hrs" msprop:Generator_ColumnVarNameInTable="columnhrs" type="xs:double" minOccurs="0" />
|
|
<xs:element name="ot" msprop:Generator_ColumnPropNameInTable="otColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="ot" msprop:Generator_UserColumnName="ot" msprop:Generator_ColumnVarNameInTable="columnot" type="xs:double" minOccurs="0" />
|
|
<xs:element name="otStart" msprop:Generator_ColumnPropNameInTable="otStartColumn" msprop:Generator_ColumnPropNameInRow="otStart" msprop:Generator_UserColumnName="otStart" msprop:Generator_ColumnVarNameInTable="columnotStart" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="otEnd" msprop:Generator_ColumnPropNameInTable="otEndColumn" msprop:Generator_ColumnPropNameInRow="otEnd" msprop:Generator_UserColumnName="otEnd" msprop:Generator_ColumnVarNameInTable="columnotEnd" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="import" msprop:Generator_ColumnPropNameInTable="importColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="import" msprop:Generator_UserColumnName="import" msprop:Generator_ColumnVarNameInTable="columnimport" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="wuid" msprop:Generator_ColumnPropNameInTable="wuidColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="wuid" msprop:Generator_UserColumnName="wuid" msprop:Generator_ColumnVarNameInTable="columnwuid">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="wdate" msprop:Generator_ColumnPropNameInTable="wdateColumn" msprop:Generator_ColumnPropNameInRow="wdate" msprop:Generator_UserColumnName="wdate" msprop:Generator_ColumnVarNameInTable="columnwdate" type="xs:dateTime" />
|
|
<xs:element name="tag" msprop:Generator_ColumnPropNameInTable="tagColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="tag" msprop:Generator_UserColumnName="tag" msprop:Generator_ColumnVarNameInTable="columntag" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="autoinput" msprop:Generator_ColumnPropNameInTable="autoinputColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="autoinput" msprop:Generator_UserColumnName="autoinput" msprop:Generator_ColumnVarNameInTable="columnautoinput" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="kisullv" msprop:Generator_ColumnPropNameInTable="kisullvColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="kisullv" msprop:Generator_UserColumnName="kisullv" msprop:Generator_ColumnVarNameInTable="columnkisullv" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="kisuldiv" msprop:Generator_ColumnPropNameInTable="kisuldivColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="kisuldiv" msprop:Generator_UserColumnName="kisuldiv" msprop:Generator_ColumnVarNameInTable="columnkisuldiv" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="kisulamt" msprop:Generator_ColumnPropNameInTable="kisulamtColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="kisulamt" msprop:Generator_UserColumnName="kisulamt" msprop:Generator_ColumnVarNameInTable="columnkisulamt" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="ot2" msprop:Generator_ColumnPropNameInTable="ot2Column" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="ot2" msprop:Generator_UserColumnName="ot2" msprop:Generator_ColumnVarNameInTable="columnot2" type="xs:double" minOccurs="0" />
|
|
<xs:element name="otReason" msprop:Generator_ColumnPropNameInTable="otReasonColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="otReason" msprop:Generator_UserColumnName="otReason" msprop:Generator_ColumnVarNameInTable="columnotReason" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="otwuid" msprop:Generator_ColumnPropNameInTable="otwuidColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="otwuid" msprop:Generator_UserColumnName="otwuid" msprop:Generator_ColumnVarNameInTable="columnotwuid" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ottime" msprop:Generator_ColumnPropNameInTable="ottimeColumn" msprop:Generator_ColumnPropNameInRow="ottime" msprop:Generator_UserColumnName="ottime" msprop:Generator_ColumnVarNameInTable="columnottime" type="xs:dateTime" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="HolidayLIst" msprop:Generator_RowEvHandlerName="HolidayLIstRowChangeEventHandler" msprop:Generator_RowDeletedName="HolidayLIstRowDeleted" msprop:Generator_RowDeletingName="HolidayLIstRowDeleting" msprop:Generator_RowEvArgName="HolidayLIstRowChangeEvent" msprop:Generator_TablePropName="HolidayLIst" msprop:Generator_RowChangedName="HolidayLIstRowChanged" msprop:Generator_UserTableName="HolidayLIst" msprop:Generator_RowChangingName="HolidayLIstRowChanging" msprop:Generator_RowClassName="HolidayLIstRow" msprop:Generator_TableClassName="HolidayLIstDataTable" msprop:Generator_TableVarName="tableHolidayLIst">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="idx" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="idxColumn" msprop:Generator_ColumnPropNameInRow="idx" msprop:Generator_UserColumnName="idx" msprop:Generator_ColumnVarNameInTable="columnidx" type="xs:int" />
|
|
<xs:element name="pdate" msprop:Generator_ColumnPropNameInTable="pdateColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="pdate" msprop:Generator_UserColumnName="pdate" msprop:Generator_ColumnVarNameInTable="columnpdate" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="free" msprop:Generator_ColumnPropNameInTable="freeColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="free" msprop:Generator_UserColumnName="free" msprop:Generator_ColumnVarNameInTable="columnfree" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="memo" msprop:Generator_ColumnPropNameInTable="memoColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="memo" msprop:Generator_UserColumnName="memo" msprop:Generator_ColumnVarNameInTable="columnmemo" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="wuid" msprop:Generator_ColumnPropNameInTable="wuidColumn" msprop:Generator_ColumnPropNameInRow="wuid" msprop:Generator_UserColumnName="wuid" msprop:Generator_ColumnVarNameInTable="columnwuid">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="wdate" msprop:Generator_ColumnPropNameInTable="wdateColumn" msprop:Generator_ColumnPropNameInRow="wdate" msprop:Generator_UserColumnName="wdate" msprop:Generator_ColumnVarNameInTable="columnwdate" type="xs:dateTime" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="vGroupUser" msprop:Generator_RowEvHandlerName="vGroupUserRowChangeEventHandler" msprop:Generator_RowDeletedName="vGroupUserRowDeleted" msprop:Generator_RowDeletingName="vGroupUserRowDeleting" msprop:Generator_RowEvArgName="vGroupUserRowChangeEvent" msprop:Generator_TablePropName="vGroupUser" msprop:Generator_RowChangedName="vGroupUserRowChanged" msprop:Generator_UserTableName="vGroupUser" msprop:Generator_RowChangingName="vGroupUserRowChanging" msprop:Generator_RowClassName="vGroupUserRow" msprop:Generator_TableClassName="vGroupUserDataTable" msprop:Generator_TableVarName="tablevGroupUser">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="gcode" msprop:Generator_ColumnPropNameInTable="gcodeColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="gcode" msprop:Generator_UserColumnName="gcode" msprop:Generator_ColumnVarNameInTable="columngcode">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="dept" msprop:Generator_ColumnPropNameInTable="deptColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="dept" msprop:Generator_UserColumnName="dept" msprop:Generator_ColumnVarNameInTable="columndept" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="level" msprop:Generator_ColumnPropNameInTable="levelColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="level" msprop:Generator_UserColumnName="level" msprop:Generator_ColumnVarNameInTable="columnlevel" type="xs:short" minOccurs="0" />
|
|
<xs:element name="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="nameE" msprop:Generator_ColumnPropNameInTable="nameEColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="nameE" msprop:Generator_UserColumnName="nameE" msprop:Generator_ColumnVarNameInTable="columnnameE" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="grade" msprop:Generator_ColumnPropNameInTable="gradeColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="grade" msprop:Generator_UserColumnName="grade" msprop:Generator_ColumnVarNameInTable="columngrade" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_UserColumnName="email" msprop:Generator_ColumnVarNameInTable="columnemail" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="tel" msprop:Generator_ColumnPropNameInTable="telColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="tel" msprop:Generator_UserColumnName="tel" msprop:Generator_ColumnVarNameInTable="columntel" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="indate" msprop:Generator_ColumnPropNameInTable="indateColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="indate" msprop:Generator_UserColumnName="indate" msprop:Generator_ColumnVarNameInTable="columnindate" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="outdate" msprop:Generator_ColumnPropNameInTable="outdateColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="outdate" msprop:Generator_UserColumnName="outdate" msprop:Generator_ColumnVarNameInTable="columnoutdate" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="hp" msprop:Generator_ColumnPropNameInTable="hpColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="hp" msprop:Generator_UserColumnName="hp" msprop:Generator_ColumnVarNameInTable="columnhp" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="place" msprop:Generator_ColumnPropNameInTable="placeColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="place" msprop:Generator_UserColumnName="place" msprop:Generator_ColumnVarNameInTable="columnplace" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ads_employNo" msprop:Generator_ColumnPropNameInTable="ads_employNoColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="ads_employNo" msprop:Generator_UserColumnName="ads_employNo" msprop:Generator_ColumnVarNameInTable="columnads_employNo" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ads_title" msprop:Generator_ColumnPropNameInTable="ads_titleColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="ads_title" msprop:Generator_UserColumnName="ads_title" msprop:Generator_ColumnVarNameInTable="columnads_title" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ads_created" msprop:Generator_ColumnPropNameInTable="ads_createdColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="ads_created" msprop:Generator_UserColumnName="ads_created" msprop:Generator_ColumnVarNameInTable="columnads_created" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="memo" msprop:Generator_ColumnPropNameInTable="memoColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="memo" msprop:Generator_UserColumnName="memo" msprop:Generator_ColumnVarNameInTable="columnmemo" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="processs" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInTable="processsColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="processs" msprop:Generator_UserColumnName="processs" msprop:Generator_ColumnVarNameInTable="columnprocesss" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="state" msprop:Generator_ColumnPropNameInTable="stateColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="state" msprop:Generator_UserColumnName="state" msprop:Generator_ColumnVarNameInTable="columnstate" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="useJobReport" msprop:Generator_ColumnPropNameInTable="useJobReportColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="useJobReport" msprop:Generator_UserColumnName="useJobReport" msprop:Generator_ColumnVarNameInTable="columnuseJobReport" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="useUserState" msprop:Generator_ColumnPropNameInTable="useUserStateColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="useUserState" msprop:Generator_UserColumnName="useUserState" msprop:Generator_ColumnVarNameInTable="columnuseUserState" type="xs:boolean" minOccurs="0" />
|
|
<xs:element name="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_UserColumnName="password" msprop:Generator_ColumnVarNameInTable="columnpassword" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="JobReportDateList" msprop:Generator_RowEvHandlerName="JobReportDateListRowChangeEventHandler" msprop:Generator_RowDeletedName="JobReportDateListRowDeleted" msprop:Generator_RowDeletingName="JobReportDateListRowDeleting" msprop:Generator_RowEvArgName="JobReportDateListRowChangeEvent" msprop:Generator_TablePropName="JobReportDateList" msprop:Generator_RowChangedName="JobReportDateListRowChanged" msprop:Generator_UserTableName="JobReportDateList" msprop:Generator_RowChangingName="JobReportDateListRowChanging" msprop:Generator_RowClassName="JobReportDateListRow" msprop:Generator_TableClassName="JobReportDateListDataTable" msprop:Generator_TableVarName="tableJobReportDateList">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="pdate" msprop:Generator_ColumnPropNameInTable="pdateColumn" msprop:Generator_ColumnPropNameInRow="pdate" msprop:Generator_UserColumnName="pdate" msprop:Generator_ColumnVarNameInTable="columnpdate">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:MailForm" />
|
|
<xs:field xpath="mstns:idx" />
|
|
</xs:unique>
|
|
<xs:unique name="MailData_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:MailData" />
|
|
<xs:field xpath="mstns:idx" />
|
|
</xs:unique>
|
|
<xs:unique name="MailAuto_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:MailAuto" />
|
|
<xs:field xpath="mstns:idx" />
|
|
</xs:unique>
|
|
<xs:unique name="vMailingProjectSchedule_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:vMailingProjectSchedule" />
|
|
<xs:field xpath="mstns:gcode" />
|
|
<xs:field xpath="mstns:idx" />
|
|
<xs:field xpath="mstns:sidx" />
|
|
</xs:unique>
|
|
<xs:unique name="ProjectsIngList_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:ProjectsIngList" />
|
|
<xs:field xpath="mstns:idx" />
|
|
</xs:unique>
|
|
<xs:unique name="EETGW_ProjectsSchedule_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:EETGW_ProjectsSchedule" />
|
|
<xs:field xpath="mstns:idx" />
|
|
</xs:unique>
|
|
<xs:unique name="vJobReportForUser_Constraint1" msdata:ConstraintName="Constraint1">
|
|
<xs:selector xpath=".//mstns:vJobReportForUser" />
|
|
<xs:field xpath="mstns:id" />
|
|
</xs:unique>
|
|
<xs:unique name="JobReport_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:JobReport" />
|
|
<xs:field xpath="mstns:idx" />
|
|
</xs:unique>
|
|
<xs:unique name="HolidayLIst_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:HolidayLIst" />
|
|
<xs:field xpath="mstns:idx" />
|
|
</xs:unique>
|
|
<xs:unique name="vGroupUser_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:vGroupUser" />
|
|
<xs:field xpath="mstns:gcode" />
|
|
<xs:field xpath="mstns:id" />
|
|
</xs:unique>
|
|
<xs:unique name="JobReportDateList_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:JobReportDateList" />
|
|
<xs:field xpath="mstns:pdate" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
</xs:schema> |