using System; using System.CodeDom.Compiler; using System.Collections; using System.ComponentModel; using System.ComponentModel.Design; using System.Data; using System.Diagnostics; using System.IO; using System.Runtime.Serialization; using System.Xml; using System.Xml.Schema; using System.Xml.Serialization; namespace SunRoxm.BizPeri.ReportDataSet.ReportDataSet { [Serializable] [DesignerCategory("code")] [XmlRoot("dsFrmEmployee")] [HelpKeyword("vs.data.DataSet")] [XmlSchemaProvider("GetTypedDataSetSchema")] [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] [ToolboxItem(true)] public class dsFrmEmployee : DataSet { public delegate void EmployeeRowChangeEventHandler(object sender, EmployeeRowChangeEvent e); public delegate void AppendInfoRowChangeEventHandler(object sender, AppendInfoRowChangeEvent e); [Serializable] [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] [XmlSchemaProvider("GetTypedTableSchema")] public class EmployeeDataTable : DataTable, IEnumerable { private DataColumn columnNo_Employee; private DataColumn columnName_Employee; private DataColumn columnEmployeeNo_Employee; private DataColumn columnNameEng_Employee; private DataColumn columnGender_Employee; private DataColumn columnCountry_Employee; private DataColumn columnHomeplace_Employee; private DataColumn columnNation_Employee; private DataColumn columnIDNo_Employee; private DataColumn columnPassport_Employee; private DataColumn columnIsMarried_Employee; private DataColumn columnCreateDate_Employee; private DataColumn columnDuty_Employee; private DataColumn columnProbation_Employee; private DataColumn columnOnJobDate_Employee; private DataColumn columnOnDuty_Employee; private DataColumn columnObJobStatus_Employee; private DataColumn columnOffDuty_Employee; private DataColumn columnSuspendDate_Employee; private DataColumn columnTel_Employee; private DataColumn columnEMail_Employee; private DataColumn columnAddress_Employee; private DataColumn columnComment_Employee; private DataColumn columnLastModDate_Employee; private DataColumn columnMarried_Employee; private DataColumn columnObJobStatus; private DataColumn columnCreatorName_Employee; private DataColumn columnLastModUser_EmployeeName; private DataColumn columnName_Department; private DataColumn columnNo_Department; private DataColumn columnCountryName; [DebuggerNonUserCode] public DataColumn No_EmployeeColumn => columnNo_Employee; [DebuggerNonUserCode] public DataColumn Name_EmployeeColumn => columnName_Employee; [DebuggerNonUserCode] public DataColumn EmployeeNo_EmployeeColumn => columnEmployeeNo_Employee; [DebuggerNonUserCode] public DataColumn NameEng_EmployeeColumn => columnNameEng_Employee; [DebuggerNonUserCode] public DataColumn Gender_EmployeeColumn => columnGender_Employee; [DebuggerNonUserCode] public DataColumn Country_EmployeeColumn => columnCountry_Employee; [DebuggerNonUserCode] public DataColumn Homeplace_EmployeeColumn => columnHomeplace_Employee; [DebuggerNonUserCode] public DataColumn Nation_EmployeeColumn => columnNation_Employee; [DebuggerNonUserCode] public DataColumn IDNo_EmployeeColumn => columnIDNo_Employee; [DebuggerNonUserCode] public DataColumn Passport_EmployeeColumn => columnPassport_Employee; [DebuggerNonUserCode] public DataColumn IsMarried_EmployeeColumn => columnIsMarried_Employee; [DebuggerNonUserCode] public DataColumn CreateDate_EmployeeColumn => columnCreateDate_Employee; [DebuggerNonUserCode] public DataColumn Duty_EmployeeColumn => columnDuty_Employee; [DebuggerNonUserCode] public DataColumn Probation_EmployeeColumn => columnProbation_Employee; [DebuggerNonUserCode] public DataColumn OnJobDate_EmployeeColumn => columnOnJobDate_Employee; [DebuggerNonUserCode] public DataColumn OnDuty_EmployeeColumn => columnOnDuty_Employee; [DebuggerNonUserCode] public DataColumn ObJobStatus_EmployeeColumn => columnObJobStatus_Employee; [DebuggerNonUserCode] public DataColumn OffDuty_EmployeeColumn => columnOffDuty_Employee; [DebuggerNonUserCode] public DataColumn SuspendDate_EmployeeColumn => columnSuspendDate_Employee; [DebuggerNonUserCode] public DataColumn Tel_EmployeeColumn => columnTel_Employee; [DebuggerNonUserCode] public DataColumn EMail_EmployeeColumn => columnEMail_Employee; [DebuggerNonUserCode] public DataColumn Address_EmployeeColumn => columnAddress_Employee; [DebuggerNonUserCode] public DataColumn Comment_EmployeeColumn => columnComment_Employee; [DebuggerNonUserCode] public DataColumn LastModDate_EmployeeColumn => columnLastModDate_Employee; [DebuggerNonUserCode] public DataColumn Married_EmployeeColumn => columnMarried_Employee; [DebuggerNonUserCode] public DataColumn ObJobStatusColumn => columnObJobStatus; [DebuggerNonUserCode] public DataColumn CreatorName_EmployeeColumn => columnCreatorName_Employee; [DebuggerNonUserCode] public DataColumn LastModUser_EmployeeNameColumn => columnLastModUser_EmployeeName; [DebuggerNonUserCode] public DataColumn Name_DepartmentColumn => columnName_Department; [DebuggerNonUserCode] public DataColumn No_DepartmentColumn => columnNo_Department; [DebuggerNonUserCode] public DataColumn CountryNameColumn => columnCountryName; [DebuggerNonUserCode] [Browsable(false)] public int Count => base.Rows.Count; [DebuggerNonUserCode] public EmployeeRow this[int index] => (EmployeeRow)base.Rows[index]; public event EmployeeRowChangeEventHandler EmployeeRowChanging; public event EmployeeRowChangeEventHandler EmployeeRowChanged; public event EmployeeRowChangeEventHandler EmployeeRowDeleting; public event EmployeeRowChangeEventHandler EmployeeRowDeleted; [DebuggerNonUserCode] public EmployeeDataTable() { base.TableName = "Employee"; BeginInit(); InitClass(); EndInit(); } [DebuggerNonUserCode] internal EmployeeDataTable(DataTable table) { base.TableName = table.TableName; if (table.CaseSensitive != table.DataSet.CaseSensitive) { base.CaseSensitive = table.CaseSensitive; } if (table.Locale.ToString() != table.DataSet.Locale.ToString()) { base.Locale = table.Locale; } if (table.Namespace != table.DataSet.Namespace) { base.Namespace = table.Namespace; } base.Prefix = table.Prefix; base.MinimumCapacity = table.MinimumCapacity; } [DebuggerNonUserCode] protected EmployeeDataTable(SerializationInfo info, StreamingContext context) : base(info, context) { InitVars(); } [DebuggerNonUserCode] public void AddEmployeeRow(EmployeeRow row) { base.Rows.Add(row); } [DebuggerNonUserCode] public EmployeeRow AddEmployeeRow(string No_Employee, string Name_Employee, string EmployeeNo_Employee, string NameEng_Employee, bool Gender_Employee, int Country_Employee, string Homeplace_Employee, string Nation_Employee, string IDNo_Employee, string Passport_Employee, bool IsMarried_Employee, DateTime CreateDate_Employee, string Duty_Employee, decimal Probation_Employee, DateTime OnJobDate_Employee, DateTime OnDuty_Employee, int ObJobStatus_Employee, DateTime OffDuty_Employee, DateTime SuspendDate_Employee, string Tel_Employee, string EMail_Employee, string Address_Employee, string Comment_Employee, DateTime LastModDate_Employee, string Married_Employee, string ObJobStatus, string CreatorName_Employee, string LastModUser_EmployeeName, string Name_Department, string No_Department, string CountryName) { EmployeeRow employeeRow = (EmployeeRow)NewRow(); employeeRow.ItemArray = new object[31] { No_Employee, Name_Employee, EmployeeNo_Employee, NameEng_Employee, Gender_Employee, Country_Employee, Homeplace_Employee, Nation_Employee, IDNo_Employee, Passport_Employee, IsMarried_Employee, CreateDate_Employee, Duty_Employee, Probation_Employee, OnJobDate_Employee, OnDuty_Employee, ObJobStatus_Employee, OffDuty_Employee, SuspendDate_Employee, Tel_Employee, EMail_Employee, Address_Employee, Comment_Employee, LastModDate_Employee, Married_Employee, ObJobStatus, CreatorName_Employee, LastModUser_EmployeeName, Name_Department, No_Department, CountryName }; base.Rows.Add(employeeRow); return employeeRow; } [DebuggerNonUserCode] public virtual IEnumerator GetEnumerator() { return base.Rows.GetEnumerator(); } [DebuggerNonUserCode] public override DataTable Clone() { EmployeeDataTable employeeDataTable = (EmployeeDataTable)base.Clone(); employeeDataTable.InitVars(); return employeeDataTable; } [DebuggerNonUserCode] protected override DataTable CreateInstance() { return new EmployeeDataTable(); } [DebuggerNonUserCode] internal void InitVars() { columnNo_Employee = base.Columns["No_Employee"]; columnName_Employee = base.Columns["Name_Employee"]; columnEmployeeNo_Employee = base.Columns["EmployeeNo_Employee"]; columnNameEng_Employee = base.Columns["NameEng_Employee"]; columnGender_Employee = base.Columns["Gender_Employee"]; columnCountry_Employee = base.Columns["Country_Employee"]; columnHomeplace_Employee = base.Columns["Homeplace_Employee"]; columnNation_Employee = base.Columns["Nation_Employee"]; columnIDNo_Employee = base.Columns["IDNo_Employee"]; columnPassport_Employee = base.Columns["Passport_Employee"]; columnIsMarried_Employee = base.Columns["IsMarried_Employee"]; columnCreateDate_Employee = base.Columns["CreateDate_Employee"]; columnDuty_Employee = base.Columns["Duty_Employee"]; columnProbation_Employee = base.Columns["Probation_Employee"]; columnOnJobDate_Employee = base.Columns["OnJobDate_Employee"]; columnOnDuty_Employee = base.Columns["OnDuty_Employee"]; columnObJobStatus_Employee = base.Columns["ObJobStatus_Employee"]; columnOffDuty_Employee = base.Columns["OffDuty_Employee"]; columnSuspendDate_Employee = base.Columns["SuspendDate_Employee"]; columnTel_Employee = base.Columns["Tel_Employee"]; columnEMail_Employee = base.Columns["EMail_Employee"]; columnAddress_Employee = base.Columns["Address_Employee"]; columnComment_Employee = base.Columns["Comment_Employee"]; columnLastModDate_Employee = base.Columns["LastModDate_Employee"]; columnMarried_Employee = base.Columns["Married_Employee"]; columnObJobStatus = base.Columns["ObJobStatus"]; columnCreatorName_Employee = base.Columns["CreatorName_Employee"]; columnLastModUser_EmployeeName = base.Columns["LastModUser_EmployeeName"]; columnName_Department = base.Columns["Name_Department"]; columnNo_Department = base.Columns["No_Department"]; columnCountryName = base.Columns["CountryName"]; } [DebuggerNonUserCode] private void InitClass() { columnNo_Employee = new DataColumn("No_Employee", typeof(string), null, MappingType.Element); base.Columns.Add(columnNo_Employee); columnName_Employee = new DataColumn("Name_Employee", typeof(string), null, MappingType.Element); base.Columns.Add(columnName_Employee); columnEmployeeNo_Employee = new DataColumn("EmployeeNo_Employee", typeof(string), null, MappingType.Element); base.Columns.Add(columnEmployeeNo_Employee); columnNameEng_Employee = new DataColumn("NameEng_Employee", typeof(string), null, MappingType.Element); base.Columns.Add(columnNameEng_Employee); columnGender_Employee = new DataColumn("Gender_Employee", typeof(bool), null, MappingType.Element); base.Columns.Add(columnGender_Employee); columnCountry_Employee = new DataColumn("Country_Employee", typeof(int), null, MappingType.Element); base.Columns.Add(columnCountry_Employee); columnHomeplace_Employee = new DataColumn("Homeplace_Employee", typeof(string), null, MappingType.Element); base.Columns.Add(columnHomeplace_Employee); columnNation_Employee = new DataColumn("Nation_Employee", typeof(string), null, MappingType.Element); base.Columns.Add(columnNation_Employee); columnIDNo_Employee = new DataColumn("IDNo_Employee", typeof(string), null, MappingType.Element); base.Columns.Add(columnIDNo_Employee); columnPassport_Employee = new DataColumn("Passport_Employee", typeof(string), null, MappingType.Element); base.Columns.Add(columnPassport_Employee); columnIsMarried_Employee = new DataColumn("IsMarried_Employee", typeof(bool), null, MappingType.Element); base.Columns.Add(columnIsMarried_Employee); columnCreateDate_Employee = new DataColumn("CreateDate_Employee", typeof(DateTime), null, MappingType.Element); base.Columns.Add(columnCreateDate_Employee); columnDuty_Employee = new DataColumn("Duty_Employee", typeof(string), null, MappingType.Element); base.Columns.Add(columnDuty_Employee); columnProbation_Employee = new DataColumn("Probation_Employee", typeof(decimal), null, MappingType.Element); base.Columns.Add(columnProbation_Employee); columnOnJobDate_Employee = new DataColumn("OnJobDate_Employee", typeof(DateTime), null, MappingType.Element); base.Columns.Add(columnOnJobDate_Employee); columnOnDuty_Employee = new DataColumn("OnDuty_Employee", typeof(DateTime), null, MappingType.Element); base.Columns.Add(columnOnDuty_Employee); columnObJobStatus_Employee = new DataColumn("ObJobStatus_Employee", typeof(int), null, MappingType.Element); base.Columns.Add(columnObJobStatus_Employee); columnOffDuty_Employee = new DataColumn("OffDuty_Employee", typeof(DateTime), null, MappingType.Element); base.Columns.Add(columnOffDuty_Employee); columnSuspendDate_Employee = new DataColumn("SuspendDate_Employee", typeof(DateTime), null, MappingType.Element); base.Columns.Add(columnSuspendDate_Employee); columnTel_Employee = new DataColumn("Tel_Employee", typeof(string), null, MappingType.Element); base.Columns.Add(columnTel_Employee); columnEMail_Employee = new DataColumn("EMail_Employee", typeof(string), null, MappingType.Element); base.Columns.Add(columnEMail_Employee); columnAddress_Employee = new DataColumn("Address_Employee", typeof(string), null, MappingType.Element); base.Columns.Add(columnAddress_Employee); columnComment_Employee = new DataColumn("Comment_Employee", typeof(string), null, MappingType.Element); base.Columns.Add(columnComment_Employee); columnLastModDate_Employee = new DataColumn("LastModDate_Employee", typeof(DateTime), null, MappingType.Element); base.Columns.Add(columnLastModDate_Employee); columnMarried_Employee = new DataColumn("Married_Employee", typeof(string), null, MappingType.Element); base.Columns.Add(columnMarried_Employee); columnObJobStatus = new DataColumn("ObJobStatus", typeof(string), null, MappingType.Element); base.Columns.Add(columnObJobStatus); columnCreatorName_Employee = new DataColumn("CreatorName_Employee", typeof(string), null, MappingType.Element); base.Columns.Add(columnCreatorName_Employee); columnLastModUser_EmployeeName = new DataColumn("LastModUser_EmployeeName", typeof(string), null, MappingType.Element); base.Columns.Add(columnLastModUser_EmployeeName); columnName_Department = new DataColumn("Name_Department", typeof(string), null, MappingType.Element); base.Columns.Add(columnName_Department); columnNo_Department = new DataColumn("No_Department", typeof(string), null, MappingType.Element); base.Columns.Add(columnNo_Department); columnCountryName = new DataColumn("CountryName", typeof(string), null, MappingType.Element); base.Columns.Add(columnCountryName); } [DebuggerNonUserCode] public EmployeeRow NewEmployeeRow() { return (EmployeeRow)NewRow(); } [DebuggerNonUserCode] protected override DataRow NewRowFromBuilder(DataRowBuilder builder) { return new EmployeeRow(builder); } [DebuggerNonUserCode] protected override Type GetRowType() { return typeof(EmployeeRow); } [DebuggerNonUserCode] protected override void OnRowChanged(DataRowChangeEventArgs e) { base.OnRowChanged(e); if (this.EmployeeRowChanged != null) { this.EmployeeRowChanged(this, new EmployeeRowChangeEvent((EmployeeRow)e.Row, e.Action)); } } [DebuggerNonUserCode] protected override void OnRowChanging(DataRowChangeEventArgs e) { base.OnRowChanging(e); if (this.EmployeeRowChanging != null) { this.EmployeeRowChanging(this, new EmployeeRowChangeEvent((EmployeeRow)e.Row, e.Action)); } } [DebuggerNonUserCode] protected override void OnRowDeleted(DataRowChangeEventArgs e) { base.OnRowDeleted(e); if (this.EmployeeRowDeleted != null) { this.EmployeeRowDeleted(this, new EmployeeRowChangeEvent((EmployeeRow)e.Row, e.Action)); } } [DebuggerNonUserCode] protected override void OnRowDeleting(DataRowChangeEventArgs e) { base.OnRowDeleting(e); if (this.EmployeeRowDeleting != null) { this.EmployeeRowDeleting(this, new EmployeeRowChangeEvent((EmployeeRow)e.Row, e.Action)); } } [DebuggerNonUserCode] public void RemoveEmployeeRow(EmployeeRow row) { base.Rows.Remove(row); } [DebuggerNonUserCode] public static XmlSchemaComplexType GetTypedTableSchema(XmlSchemaSet xs) { XmlSchemaComplexType xmlSchemaComplexType = new XmlSchemaComplexType(); XmlSchemaSequence xmlSchemaSequence = new XmlSchemaSequence(); dsFrmEmployee dsFrmEmployee = new dsFrmEmployee(); xs.Add(dsFrmEmployee.GetSchemaSerializable()); XmlSchemaAny xmlSchemaAny = new XmlSchemaAny(); xmlSchemaAny.Namespace = "http://www.w3.org/2001/XMLSchema"; xmlSchemaAny.MinOccurs = 0m; xmlSchemaAny.MaxOccurs = decimal.MaxValue; xmlSchemaAny.ProcessContents = XmlSchemaContentProcessing.Lax; xmlSchemaSequence.Items.Add(xmlSchemaAny); XmlSchemaAny xmlSchemaAny2 = new XmlSchemaAny(); xmlSchemaAny2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"; xmlSchemaAny2.MinOccurs = 1m; xmlSchemaAny2.ProcessContents = XmlSchemaContentProcessing.Lax; xmlSchemaSequence.Items.Add(xmlSchemaAny2); XmlSchemaAttribute xmlSchemaAttribute = new XmlSchemaAttribute(); xmlSchemaAttribute.Name = "namespace"; xmlSchemaAttribute.FixedValue = dsFrmEmployee.Namespace; xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute); XmlSchemaAttribute xmlSchemaAttribute2 = new XmlSchemaAttribute(); xmlSchemaAttribute2.Name = "tableTypeName"; xmlSchemaAttribute2.FixedValue = "EmployeeDataTable"; xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute2); xmlSchemaComplexType.Particle = xmlSchemaSequence; return xmlSchemaComplexType; } } [Serializable] [XmlSchemaProvider("GetTypedTableSchema")] [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] public class AppendInfoDataTable : DataTable, IEnumerable { private DataColumn columnCurrentCompany; private DataColumn columnCurrentUser; [DebuggerNonUserCode] public DataColumn CurrentCompanyColumn => columnCurrentCompany; [DebuggerNonUserCode] public DataColumn CurrentUserColumn => columnCurrentUser; [DebuggerNonUserCode] [Browsable(false)] public int Count => base.Rows.Count; [DebuggerNonUserCode] public AppendInfoRow this[int index] => (AppendInfoRow)base.Rows[index]; public event AppendInfoRowChangeEventHandler AppendInfoRowChanging; public event AppendInfoRowChangeEventHandler AppendInfoRowChanged; public event AppendInfoRowChangeEventHandler AppendInfoRowDeleting; public event AppendInfoRowChangeEventHandler AppendInfoRowDeleted; [DebuggerNonUserCode] public AppendInfoDataTable() { base.TableName = "AppendInfo"; BeginInit(); InitClass(); EndInit(); } [DebuggerNonUserCode] internal AppendInfoDataTable(DataTable table) { base.TableName = table.TableName; if (table.CaseSensitive != table.DataSet.CaseSensitive) { base.CaseSensitive = table.CaseSensitive; } if (table.Locale.ToString() != table.DataSet.Locale.ToString()) { base.Locale = table.Locale; } if (table.Namespace != table.DataSet.Namespace) { base.Namespace = table.Namespace; } base.Prefix = table.Prefix; base.MinimumCapacity = table.MinimumCapacity; } [DebuggerNonUserCode] protected AppendInfoDataTable(SerializationInfo info, StreamingContext context) : base(info, context) { InitVars(); } [DebuggerNonUserCode] public void AddAppendInfoRow(AppendInfoRow row) { base.Rows.Add(row); } [DebuggerNonUserCode] public AppendInfoRow AddAppendInfoRow(string CurrentCompany, string CurrentUser) { AppendInfoRow appendInfoRow = (AppendInfoRow)NewRow(); appendInfoRow.ItemArray = new object[2] { CurrentCompany, CurrentUser }; base.Rows.Add(appendInfoRow); return appendInfoRow; } [DebuggerNonUserCode] public virtual IEnumerator GetEnumerator() { return base.Rows.GetEnumerator(); } [DebuggerNonUserCode] public override DataTable Clone() { AppendInfoDataTable appendInfoDataTable = (AppendInfoDataTable)base.Clone(); appendInfoDataTable.InitVars(); return appendInfoDataTable; } [DebuggerNonUserCode] protected override DataTable CreateInstance() { return new AppendInfoDataTable(); } [DebuggerNonUserCode] internal void InitVars() { columnCurrentCompany = base.Columns["CurrentCompany"]; columnCurrentUser = base.Columns["CurrentUser"]; } [DebuggerNonUserCode] private void InitClass() { columnCurrentCompany = new DataColumn("CurrentCompany", typeof(string), null, MappingType.Element); base.Columns.Add(columnCurrentCompany); columnCurrentUser = new DataColumn("CurrentUser", typeof(string), null, MappingType.Element); base.Columns.Add(columnCurrentUser); } [DebuggerNonUserCode] public AppendInfoRow NewAppendInfoRow() { return (AppendInfoRow)NewRow(); } [DebuggerNonUserCode] protected override DataRow NewRowFromBuilder(DataRowBuilder builder) { return new AppendInfoRow(builder); } [DebuggerNonUserCode] protected override Type GetRowType() { return typeof(AppendInfoRow); } [DebuggerNonUserCode] protected override void OnRowChanged(DataRowChangeEventArgs e) { base.OnRowChanged(e); if (this.AppendInfoRowChanged != null) { this.AppendInfoRowChanged(this, new AppendInfoRowChangeEvent((AppendInfoRow)e.Row, e.Action)); } } [DebuggerNonUserCode] protected override void OnRowChanging(DataRowChangeEventArgs e) { base.OnRowChanging(e); if (this.AppendInfoRowChanging != null) { this.AppendInfoRowChanging(this, new AppendInfoRowChangeEvent((AppendInfoRow)e.Row, e.Action)); } } [DebuggerNonUserCode] protected override void OnRowDeleted(DataRowChangeEventArgs e) { base.OnRowDeleted(e); if (this.AppendInfoRowDeleted != null) { this.AppendInfoRowDeleted(this, new AppendInfoRowChangeEvent((AppendInfoRow)e.Row, e.Action)); } } [DebuggerNonUserCode] protected override void OnRowDeleting(DataRowChangeEventArgs e) { base.OnRowDeleting(e); if (this.AppendInfoRowDeleting != null) { this.AppendInfoRowDeleting(this, new AppendInfoRowChangeEvent((AppendInfoRow)e.Row, e.Action)); } } [DebuggerNonUserCode] public void RemoveAppendInfoRow(AppendInfoRow row) { base.Rows.Remove(row); } [DebuggerNonUserCode] public static XmlSchemaComplexType GetTypedTableSchema(XmlSchemaSet xs) { XmlSchemaComplexType xmlSchemaComplexType = new XmlSchemaComplexType(); XmlSchemaSequence xmlSchemaSequence = new XmlSchemaSequence(); dsFrmEmployee dsFrmEmployee = new dsFrmEmployee(); xs.Add(dsFrmEmployee.GetSchemaSerializable()); XmlSchemaAny xmlSchemaAny = new XmlSchemaAny(); xmlSchemaAny.Namespace = "http://www.w3.org/2001/XMLSchema"; xmlSchemaAny.MinOccurs = 0m; xmlSchemaAny.MaxOccurs = decimal.MaxValue; xmlSchemaAny.ProcessContents = XmlSchemaContentProcessing.Lax; xmlSchemaSequence.Items.Add(xmlSchemaAny); XmlSchemaAny xmlSchemaAny2 = new XmlSchemaAny(); xmlSchemaAny2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"; xmlSchemaAny2.MinOccurs = 1m; xmlSchemaAny2.ProcessContents = XmlSchemaContentProcessing.Lax; xmlSchemaSequence.Items.Add(xmlSchemaAny2); XmlSchemaAttribute xmlSchemaAttribute = new XmlSchemaAttribute(); xmlSchemaAttribute.Name = "namespace"; xmlSchemaAttribute.FixedValue = dsFrmEmployee.Namespace; xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute); XmlSchemaAttribute xmlSchemaAttribute2 = new XmlSchemaAttribute(); xmlSchemaAttribute2.Name = "tableTypeName"; xmlSchemaAttribute2.FixedValue = "AppendInfoDataTable"; xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute2); xmlSchemaComplexType.Particle = xmlSchemaSequence; return xmlSchemaComplexType; } } [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] public class EmployeeRow : DataRow { private EmployeeDataTable tableEmployee; [DebuggerNonUserCode] public string No_Employee { get { try { return (string)base[tableEmployee.No_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'No_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.No_EmployeeColumn] = value; } } [DebuggerNonUserCode] public string Name_Employee { get { try { return (string)base[tableEmployee.Name_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'Name_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.Name_EmployeeColumn] = value; } } [DebuggerNonUserCode] public string EmployeeNo_Employee { get { try { return (string)base[tableEmployee.EmployeeNo_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'EmployeeNo_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.EmployeeNo_EmployeeColumn] = value; } } [DebuggerNonUserCode] public string NameEng_Employee { get { try { return (string)base[tableEmployee.NameEng_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'NameEng_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.NameEng_EmployeeColumn] = value; } } [DebuggerNonUserCode] public bool Gender_Employee { get { try { return (bool)base[tableEmployee.Gender_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'Gender_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.Gender_EmployeeColumn] = value; } } [DebuggerNonUserCode] public int Country_Employee { get { try { return (int)base[tableEmployee.Country_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'Country_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.Country_EmployeeColumn] = value; } } [DebuggerNonUserCode] public string Homeplace_Employee { get { try { return (string)base[tableEmployee.Homeplace_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'Homeplace_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.Homeplace_EmployeeColumn] = value; } } [DebuggerNonUserCode] public string Nation_Employee { get { try { return (string)base[tableEmployee.Nation_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'Nation_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.Nation_EmployeeColumn] = value; } } [DebuggerNonUserCode] public string IDNo_Employee { get { try { return (string)base[tableEmployee.IDNo_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'IDNo_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.IDNo_EmployeeColumn] = value; } } [DebuggerNonUserCode] public string Passport_Employee { get { try { return (string)base[tableEmployee.Passport_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'Passport_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.Passport_EmployeeColumn] = value; } } [DebuggerNonUserCode] public bool IsMarried_Employee { get { try { return (bool)base[tableEmployee.IsMarried_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'IsMarried_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.IsMarried_EmployeeColumn] = value; } } [DebuggerNonUserCode] public DateTime CreateDate_Employee { get { try { return (DateTime)base[tableEmployee.CreateDate_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'CreateDate_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.CreateDate_EmployeeColumn] = value; } } [DebuggerNonUserCode] public string Duty_Employee { get { try { return (string)base[tableEmployee.Duty_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'Duty_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.Duty_EmployeeColumn] = value; } } [DebuggerNonUserCode] public decimal Probation_Employee { get { try { return (decimal)base[tableEmployee.Probation_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'Probation_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.Probation_EmployeeColumn] = value; } } [DebuggerNonUserCode] public DateTime OnJobDate_Employee { get { try { return (DateTime)base[tableEmployee.OnJobDate_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'OnJobDate_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.OnJobDate_EmployeeColumn] = value; } } [DebuggerNonUserCode] public DateTime OnDuty_Employee { get { try { return (DateTime)base[tableEmployee.OnDuty_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'OnDuty_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.OnDuty_EmployeeColumn] = value; } } [DebuggerNonUserCode] public int ObJobStatus_Employee { get { try { return (int)base[tableEmployee.ObJobStatus_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'ObJobStatus_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.ObJobStatus_EmployeeColumn] = value; } } [DebuggerNonUserCode] public DateTime OffDuty_Employee { get { try { return (DateTime)base[tableEmployee.OffDuty_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'OffDuty_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.OffDuty_EmployeeColumn] = value; } } [DebuggerNonUserCode] public DateTime SuspendDate_Employee { get { try { return (DateTime)base[tableEmployee.SuspendDate_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'SuspendDate_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.SuspendDate_EmployeeColumn] = value; } } [DebuggerNonUserCode] public string Tel_Employee { get { try { return (string)base[tableEmployee.Tel_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'Tel_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.Tel_EmployeeColumn] = value; } } [DebuggerNonUserCode] public string EMail_Employee { get { try { return (string)base[tableEmployee.EMail_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'EMail_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.EMail_EmployeeColumn] = value; } } [DebuggerNonUserCode] public string Address_Employee { get { try { return (string)base[tableEmployee.Address_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'Address_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.Address_EmployeeColumn] = value; } } [DebuggerNonUserCode] public string Comment_Employee { get { try { return (string)base[tableEmployee.Comment_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'Comment_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.Comment_EmployeeColumn] = value; } } [DebuggerNonUserCode] public DateTime LastModDate_Employee { get { try { return (DateTime)base[tableEmployee.LastModDate_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'LastModDate_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.LastModDate_EmployeeColumn] = value; } } [DebuggerNonUserCode] public string Married_Employee { get { try { return (string)base[tableEmployee.Married_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'Married_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.Married_EmployeeColumn] = value; } } [DebuggerNonUserCode] public string ObJobStatus { get { try { return (string)base[tableEmployee.ObJobStatusColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'ObJobStatus' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.ObJobStatusColumn] = value; } } [DebuggerNonUserCode] public string CreatorName_Employee { get { try { return (string)base[tableEmployee.CreatorName_EmployeeColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'CreatorName_Employee' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.CreatorName_EmployeeColumn] = value; } } [DebuggerNonUserCode] public string LastModUser_EmployeeName { get { try { return (string)base[tableEmployee.LastModUser_EmployeeNameColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'LastModUser_EmployeeName' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.LastModUser_EmployeeNameColumn] = value; } } [DebuggerNonUserCode] public string Name_Department { get { try { return (string)base[tableEmployee.Name_DepartmentColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'Name_Department' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.Name_DepartmentColumn] = value; } } [DebuggerNonUserCode] public string No_Department { get { try { return (string)base[tableEmployee.No_DepartmentColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'No_Department' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.No_DepartmentColumn] = value; } } [DebuggerNonUserCode] public string CountryName { get { try { return (string)base[tableEmployee.CountryNameColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'CountryName' in table 'Employee' is DBNull.", innerException); } } set { base[tableEmployee.CountryNameColumn] = value; } } [DebuggerNonUserCode] internal EmployeeRow(DataRowBuilder rb) : base(rb) { tableEmployee = (EmployeeDataTable)base.Table; } [DebuggerNonUserCode] public bool IsNo_EmployeeNull() { return IsNull(tableEmployee.No_EmployeeColumn); } [DebuggerNonUserCode] public void SetNo_EmployeeNull() { base[tableEmployee.No_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsName_EmployeeNull() { return IsNull(tableEmployee.Name_EmployeeColumn); } [DebuggerNonUserCode] public void SetName_EmployeeNull() { base[tableEmployee.Name_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsEmployeeNo_EmployeeNull() { return IsNull(tableEmployee.EmployeeNo_EmployeeColumn); } [DebuggerNonUserCode] public void SetEmployeeNo_EmployeeNull() { base[tableEmployee.EmployeeNo_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsNameEng_EmployeeNull() { return IsNull(tableEmployee.NameEng_EmployeeColumn); } [DebuggerNonUserCode] public void SetNameEng_EmployeeNull() { base[tableEmployee.NameEng_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsGender_EmployeeNull() { return IsNull(tableEmployee.Gender_EmployeeColumn); } [DebuggerNonUserCode] public void SetGender_EmployeeNull() { base[tableEmployee.Gender_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsCountry_EmployeeNull() { return IsNull(tableEmployee.Country_EmployeeColumn); } [DebuggerNonUserCode] public void SetCountry_EmployeeNull() { base[tableEmployee.Country_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsHomeplace_EmployeeNull() { return IsNull(tableEmployee.Homeplace_EmployeeColumn); } [DebuggerNonUserCode] public void SetHomeplace_EmployeeNull() { base[tableEmployee.Homeplace_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsNation_EmployeeNull() { return IsNull(tableEmployee.Nation_EmployeeColumn); } [DebuggerNonUserCode] public void SetNation_EmployeeNull() { base[tableEmployee.Nation_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsIDNo_EmployeeNull() { return IsNull(tableEmployee.IDNo_EmployeeColumn); } [DebuggerNonUserCode] public void SetIDNo_EmployeeNull() { base[tableEmployee.IDNo_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsPassport_EmployeeNull() { return IsNull(tableEmployee.Passport_EmployeeColumn); } [DebuggerNonUserCode] public void SetPassport_EmployeeNull() { base[tableEmployee.Passport_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsIsMarried_EmployeeNull() { return IsNull(tableEmployee.IsMarried_EmployeeColumn); } [DebuggerNonUserCode] public void SetIsMarried_EmployeeNull() { base[tableEmployee.IsMarried_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsCreateDate_EmployeeNull() { return IsNull(tableEmployee.CreateDate_EmployeeColumn); } [DebuggerNonUserCode] public void SetCreateDate_EmployeeNull() { base[tableEmployee.CreateDate_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsDuty_EmployeeNull() { return IsNull(tableEmployee.Duty_EmployeeColumn); } [DebuggerNonUserCode] public void SetDuty_EmployeeNull() { base[tableEmployee.Duty_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsProbation_EmployeeNull() { return IsNull(tableEmployee.Probation_EmployeeColumn); } [DebuggerNonUserCode] public void SetProbation_EmployeeNull() { base[tableEmployee.Probation_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsOnJobDate_EmployeeNull() { return IsNull(tableEmployee.OnJobDate_EmployeeColumn); } [DebuggerNonUserCode] public void SetOnJobDate_EmployeeNull() { base[tableEmployee.OnJobDate_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsOnDuty_EmployeeNull() { return IsNull(tableEmployee.OnDuty_EmployeeColumn); } [DebuggerNonUserCode] public void SetOnDuty_EmployeeNull() { base[tableEmployee.OnDuty_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsObJobStatus_EmployeeNull() { return IsNull(tableEmployee.ObJobStatus_EmployeeColumn); } [DebuggerNonUserCode] public void SetObJobStatus_EmployeeNull() { base[tableEmployee.ObJobStatus_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsOffDuty_EmployeeNull() { return IsNull(tableEmployee.OffDuty_EmployeeColumn); } [DebuggerNonUserCode] public void SetOffDuty_EmployeeNull() { base[tableEmployee.OffDuty_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsSuspendDate_EmployeeNull() { return IsNull(tableEmployee.SuspendDate_EmployeeColumn); } [DebuggerNonUserCode] public void SetSuspendDate_EmployeeNull() { base[tableEmployee.SuspendDate_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsTel_EmployeeNull() { return IsNull(tableEmployee.Tel_EmployeeColumn); } [DebuggerNonUserCode] public void SetTel_EmployeeNull() { base[tableEmployee.Tel_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsEMail_EmployeeNull() { return IsNull(tableEmployee.EMail_EmployeeColumn); } [DebuggerNonUserCode] public void SetEMail_EmployeeNull() { base[tableEmployee.EMail_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsAddress_EmployeeNull() { return IsNull(tableEmployee.Address_EmployeeColumn); } [DebuggerNonUserCode] public void SetAddress_EmployeeNull() { base[tableEmployee.Address_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsComment_EmployeeNull() { return IsNull(tableEmployee.Comment_EmployeeColumn); } [DebuggerNonUserCode] public void SetComment_EmployeeNull() { base[tableEmployee.Comment_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsLastModDate_EmployeeNull() { return IsNull(tableEmployee.LastModDate_EmployeeColumn); } [DebuggerNonUserCode] public void SetLastModDate_EmployeeNull() { base[tableEmployee.LastModDate_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsMarried_EmployeeNull() { return IsNull(tableEmployee.Married_EmployeeColumn); } [DebuggerNonUserCode] public void SetMarried_EmployeeNull() { base[tableEmployee.Married_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsObJobStatusNull() { return IsNull(tableEmployee.ObJobStatusColumn); } [DebuggerNonUserCode] public void SetObJobStatusNull() { base[tableEmployee.ObJobStatusColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsCreatorName_EmployeeNull() { return IsNull(tableEmployee.CreatorName_EmployeeColumn); } [DebuggerNonUserCode] public void SetCreatorName_EmployeeNull() { base[tableEmployee.CreatorName_EmployeeColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsLastModUser_EmployeeNameNull() { return IsNull(tableEmployee.LastModUser_EmployeeNameColumn); } [DebuggerNonUserCode] public void SetLastModUser_EmployeeNameNull() { base[tableEmployee.LastModUser_EmployeeNameColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsName_DepartmentNull() { return IsNull(tableEmployee.Name_DepartmentColumn); } [DebuggerNonUserCode] public void SetName_DepartmentNull() { base[tableEmployee.Name_DepartmentColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsNo_DepartmentNull() { return IsNull(tableEmployee.No_DepartmentColumn); } [DebuggerNonUserCode] public void SetNo_DepartmentNull() { base[tableEmployee.No_DepartmentColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsCountryNameNull() { return IsNull(tableEmployee.CountryNameColumn); } [DebuggerNonUserCode] public void SetCountryNameNull() { base[tableEmployee.CountryNameColumn] = Convert.DBNull; } } [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] public class AppendInfoRow : DataRow { private AppendInfoDataTable tableAppendInfo; [DebuggerNonUserCode] public string CurrentCompany { get { try { return (string)base[tableAppendInfo.CurrentCompanyColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'CurrentCompany' in table 'AppendInfo' is DBNull.", innerException); } } set { base[tableAppendInfo.CurrentCompanyColumn] = value; } } [DebuggerNonUserCode] public string CurrentUser { get { try { return (string)base[tableAppendInfo.CurrentUserColumn]; } catch (InvalidCastException innerException) { throw new StrongTypingException("The value for column 'CurrentUser' in table 'AppendInfo' is DBNull.", innerException); } } set { base[tableAppendInfo.CurrentUserColumn] = value; } } [DebuggerNonUserCode] internal AppendInfoRow(DataRowBuilder rb) : base(rb) { tableAppendInfo = (AppendInfoDataTable)base.Table; } [DebuggerNonUserCode] public bool IsCurrentCompanyNull() { return IsNull(tableAppendInfo.CurrentCompanyColumn); } [DebuggerNonUserCode] public void SetCurrentCompanyNull() { base[tableAppendInfo.CurrentCompanyColumn] = Convert.DBNull; } [DebuggerNonUserCode] public bool IsCurrentUserNull() { return IsNull(tableAppendInfo.CurrentUserColumn); } [DebuggerNonUserCode] public void SetCurrentUserNull() { base[tableAppendInfo.CurrentUserColumn] = Convert.DBNull; } } [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] public class EmployeeRowChangeEvent : EventArgs { private EmployeeRow eventRow; private DataRowAction eventAction; [DebuggerNonUserCode] public EmployeeRow Row => eventRow; [DebuggerNonUserCode] public DataRowAction Action => eventAction; [DebuggerNonUserCode] public EmployeeRowChangeEvent(EmployeeRow row, DataRowAction action) { eventRow = row; eventAction = action; } } [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] public class AppendInfoRowChangeEvent : EventArgs { private AppendInfoRow eventRow; private DataRowAction eventAction; [DebuggerNonUserCode] public AppendInfoRow Row => eventRow; [DebuggerNonUserCode] public DataRowAction Action => eventAction; [DebuggerNonUserCode] public AppendInfoRowChangeEvent(AppendInfoRow row, DataRowAction action) { eventRow = row; eventAction = action; } } private EmployeeDataTable tableEmployee; private AppendInfoDataTable tableAppendInfo; private SchemaSerializationMode _schemaSerializationMode = SchemaSerializationMode.IncludeSchema; [DesignerSerializationVisibility(DesignerSerializationVisibility.Content)] [DebuggerNonUserCode] [Browsable(false)] public EmployeeDataTable Employee => tableEmployee; [Browsable(false)] [DebuggerNonUserCode] [DesignerSerializationVisibility(DesignerSerializationVisibility.Content)] public AppendInfoDataTable AppendInfo => tableAppendInfo; [DebuggerNonUserCode] [DesignerSerializationVisibility(DesignerSerializationVisibility.Visible)] [Browsable(true)] public override SchemaSerializationMode SchemaSerializationMode { get { return _schemaSerializationMode; } set { _schemaSerializationMode = value; } } [DebuggerNonUserCode] [DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)] public new DataTableCollection Tables => base.Tables; [DebuggerNonUserCode] [DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)] public new DataRelationCollection Relations => base.Relations; [DebuggerNonUserCode] public dsFrmEmployee() { BeginInit(); InitClass(); CollectionChangeEventHandler value = SchemaChanged; base.Tables.CollectionChanged += value; base.Relations.CollectionChanged += value; EndInit(); } [DebuggerNonUserCode] protected dsFrmEmployee(SerializationInfo info, StreamingContext context) : base(info, context, ConstructSchema: false) { if (IsBinarySerialized(info, context)) { InitVars(initTable: false); CollectionChangeEventHandler value = SchemaChanged; Tables.CollectionChanged += value; Relations.CollectionChanged += value; return; } string s = (string)info.GetValue("XmlSchema", typeof(string)); if (DetermineSchemaSerializationMode(info, context) == SchemaSerializationMode.IncludeSchema) { DataSet dataSet = new DataSet(); dataSet.ReadXmlSchema(new XmlTextReader(new StringReader(s))); if (dataSet.Tables["Employee"] != null) { base.Tables.Add(new EmployeeDataTable(dataSet.Tables["Employee"])); } if (dataSet.Tables["AppendInfo"] != null) { base.Tables.Add(new AppendInfoDataTable(dataSet.Tables["AppendInfo"])); } base.DataSetName = dataSet.DataSetName; base.Prefix = dataSet.Prefix; base.Namespace = dataSet.Namespace; base.Locale = dataSet.Locale; base.CaseSensitive = dataSet.CaseSensitive; base.EnforceConstraints = dataSet.EnforceConstraints; Merge(dataSet, preserveChanges: false, MissingSchemaAction.Add); InitVars(); } else { ReadXmlSchema(new XmlTextReader(new StringReader(s))); } GetSerializationData(info, context); CollectionChangeEventHandler value2 = SchemaChanged; base.Tables.CollectionChanged += value2; Relations.CollectionChanged += value2; } [DebuggerNonUserCode] protected override void InitializeDerivedDataSet() { BeginInit(); InitClass(); EndInit(); } [DebuggerNonUserCode] public override DataSet Clone() { dsFrmEmployee dsFrmEmployee = (dsFrmEmployee)base.Clone(); dsFrmEmployee.InitVars(); dsFrmEmployee.SchemaSerializationMode = SchemaSerializationMode; return dsFrmEmployee; } [DebuggerNonUserCode] protected override bool ShouldSerializeTables() { return false; } [DebuggerNonUserCode] protected override bool ShouldSerializeRelations() { return false; } [DebuggerNonUserCode] protected override void ReadXmlSerializable(XmlReader reader) { if (DetermineSchemaSerializationMode(reader) == SchemaSerializationMode.IncludeSchema) { Reset(); DataSet dataSet = new DataSet(); dataSet.ReadXml(reader); if (dataSet.Tables["Employee"] != null) { base.Tables.Add(new EmployeeDataTable(dataSet.Tables["Employee"])); } if (dataSet.Tables["AppendInfo"] != null) { base.Tables.Add(new AppendInfoDataTable(dataSet.Tables["AppendInfo"])); } base.DataSetName = dataSet.DataSetName; base.Prefix = dataSet.Prefix; base.Namespace = dataSet.Namespace; base.Locale = dataSet.Locale; base.CaseSensitive = dataSet.CaseSensitive; base.EnforceConstraints = dataSet.EnforceConstraints; Merge(dataSet, preserveChanges: false, MissingSchemaAction.Add); InitVars(); } else { ReadXml(reader); InitVars(); } } [DebuggerNonUserCode] protected override XmlSchema GetSchemaSerializable() { MemoryStream memoryStream = new MemoryStream(); WriteXmlSchema(new XmlTextWriter(memoryStream, null)); memoryStream.Position = 0L; return XmlSchema.Read(new XmlTextReader(memoryStream), null); } [DebuggerNonUserCode] internal void InitVars() { InitVars(initTable: true); } [DebuggerNonUserCode] internal void InitVars(bool initTable) { tableEmployee = (EmployeeDataTable)base.Tables["Employee"]; if (initTable && tableEmployee != null) { tableEmployee.InitVars(); } tableAppendInfo = (AppendInfoDataTable)base.Tables["AppendInfo"]; if (initTable && tableAppendInfo != null) { tableAppendInfo.InitVars(); } } [DebuggerNonUserCode] private void InitClass() { base.DataSetName = "dsFrmEmployee"; base.Prefix = ""; base.Namespace = "http://tempuri.org/dsFrmEmployee.xsd"; base.EnforceConstraints = true; SchemaSerializationMode = SchemaSerializationMode.IncludeSchema; tableEmployee = new EmployeeDataTable(); base.Tables.Add(tableEmployee); tableAppendInfo = new AppendInfoDataTable(); base.Tables.Add(tableAppendInfo); } [DebuggerNonUserCode] private bool ShouldSerializeEmployee() { return false; } [DebuggerNonUserCode] private bool ShouldSerializeAppendInfo() { return false; } [DebuggerNonUserCode] private void SchemaChanged(object sender, CollectionChangeEventArgs e) { if (e.Action == CollectionChangeAction.Remove) { InitVars(); } } [DebuggerNonUserCode] public static XmlSchemaComplexType GetTypedDataSetSchema(XmlSchemaSet xs) { dsFrmEmployee dsFrmEmployee = new dsFrmEmployee(); XmlSchemaComplexType xmlSchemaComplexType = new XmlSchemaComplexType(); XmlSchemaSequence xmlSchemaSequence = new XmlSchemaSequence(); xs.Add(dsFrmEmployee.GetSchemaSerializable()); XmlSchemaAny xmlSchemaAny = new XmlSchemaAny(); xmlSchemaAny.Namespace = dsFrmEmployee.Namespace; xmlSchemaSequence.Items.Add(xmlSchemaAny); xmlSchemaComplexType.Particle = xmlSchemaSequence; return xmlSchemaComplexType; } } }