<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="IRGodamDataSet" targetNamespace="http://tempuri.org/IRGodamDataSet.xsd" xmlns:mstns="http://tempuri.org/IRGodamDataSet.xsd" xmlns="http://tempuri.org/IRGodamDataSet.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="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="IRGodamConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="IRGodamConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.IRGodam.My.MySettings.GlobalReference.Default.IRGodamConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClientesTableAdapter" GeneratorDataComponentClassName="ClientesTableAdapter" Name="Clientes" UserDataComponentName="ClientesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IRGodamConnectionString (MySettings)" DbObjectName="IRGodam.dbo.Clientes" 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 [dbo].[Clientes] WHERE (([ID] = @Original_ID) AND ((@IsNull_Capturo = 1 AND [Capturo] IS NULL) OR ([Capturo] = @Original_Capturo)) AND ((@IsNull_Fecha = 1 AND [Fecha] IS NULL) OR ([Fecha] = @Original_Fecha)) AND ((@IsNull_Tipo = 1 AND [Tipo] IS NULL) OR ([Tipo] = @Original_Tipo)) AND ((@IsNull_RazonSoc = 1 AND [RazonSoc] IS NULL) OR ([RazonSoc] = @Original_RazonSoc)) AND ((@IsNull_NombreCom = 1 AND [NombreCom] IS NULL) OR ([NombreCom] = @Original_NombreCom)) AND ((@IsNull_Calle = 1 AND [Calle] IS NULL) OR ([Calle] = @Original_Calle)) AND ((@IsNull_Numero = 1 AND [Numero] IS NULL) OR ([Numero] = @Original_Numero)) AND ((@IsNull_Colonia = 1 AND [Colonia] IS NULL) OR ([Colonia] = @Original_Colonia)) AND ((@IsNull_CodPos = 1 AND [CodPos] IS NULL) OR ([CodPos] = @Original_CodPos)) AND ((@IsNull_Estado = 1 AND [Estado] IS NULL) OR ([Estado] = @Original_Estado)) AND ((@IsNull_Pais = 1 AND [Pais] IS NULL) OR ([Pais] = @Original_Pais)) AND ((@IsNull_Rfc = 1 AND [Rfc] IS NULL) OR ([Rfc] = @Original_Rfc)) AND ((@IsNull_TelUno = 1 AND [TelUno] IS NULL) OR ([TelUno] = @Original_TelUno)) AND ((@IsNull_TelDos = 1 AND [TelDos] IS NULL) OR ([TelDos] = @Original_TelDos)) AND ((@IsNull_Contacto1 = 1 AND [Contacto1] IS NULL) OR ([Contacto1] = @Original_Contacto1)) AND ((@IsNull_Email1 = 1 AND [Email1] IS NULL) OR ([Email1] = @Original_Email1)) AND ((@IsNull_Ext1 = 1 AND [Ext1] IS NULL) OR ([Ext1] = @Original_Ext1)) AND ((@IsNull_Contacto2 = 1 AND [Contacto2] IS NULL) OR ([Contacto2] = @Original_Contacto2)) AND ((@IsNull_Email2 = 1 AND [Email2] IS NULL) OR ([Email2] = @Original_Email2)) AND ((@IsNull_Ext2 = 1 AND [Ext2] IS NULL) OR ([Ext2] = @Original_Ext2)) AND ((@IsNull_Contacto3 = 1 AND [Contacto3] IS NULL) OR ([Contacto3] = @Original_Contacto3)) AND ((@IsNull_Email3 = 1 AND [Email3] IS NULL) OR ([Email3] = @Original_Email3)) AND ((@IsNull_Ext3 = 1 AND [Ext3] IS NULL) OR ([Ext3] = @Original_Ext3)) AND ((@IsNull_Notas = 1 AND [Notas] IS NULL) OR ([Notas] = @Original_Notas)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Capturo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Capturo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Capturo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Capturo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Fecha" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tipo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Tipo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RazonSoc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RazonSoc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RazonSoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RazonSoc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NombreCom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NombreCom" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NombreCom" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NombreCom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Calle" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Calle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Calle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Calle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Numero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Numero" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Colonia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Colonia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Colonia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Colonia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodPos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodPos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodPos" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodPos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Estado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Estado" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Pais" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pais" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Pais" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Pais" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rfc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rfc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Rfc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Rfc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TelUno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TelUno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TelUno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TelUno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TelDos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TelDos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TelDos" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TelDos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Contacto1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Contacto1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Contacto1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contacto1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ext1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ext1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ext1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ext1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Contacto2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Contacto2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Contacto2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contacto2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ext2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ext2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ext2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ext2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Contacto3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Contacto3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Contacto3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contacto3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ext3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ext3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ext3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ext3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Notas" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Notas" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Notas" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Notas" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Clientes] ([Capturo], [Fecha], [Tipo], [RazonSoc], [NombreCom], [Calle], [Numero], [Colonia], [CodPos], [Estado], [Pais], [Rfc], [TelUno], [TelDos], [Contacto1], [Email1], [Ext1], [Contacto2], [Email2], [Ext2], [Contacto3], [Email3], [Ext3], [Notas], [Foto]) VALUES (@Capturo, @Fecha, @Tipo, @RazonSoc, @NombreCom, @Calle, @Numero, @Colonia, @CodPos, @Estado, @Pais, @Rfc, @TelUno, @TelDos, @Contacto1, @Email1, @Ext1, @Contacto2, @Email2, @Ext2, @Contacto3, @Email3, @Ext3, @Notas, @Foto);
SELECT ID, Capturo, Fecha, Tipo, RazonSoc, NombreCom, Calle, Numero, Colonia, CodPos, Estado, Pais, Rfc, TelUno, TelDos, Contacto1, Email1, Ext1, Contacto2, Email2, Ext2, Contacto3, Email3, Ext3, Notas, Foto FROM Clientes WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Capturo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Capturo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Fecha" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Tipo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RazonSoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RazonSoc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NombreCom" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NombreCom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Calle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Calle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Numero" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Colonia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Colonia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodPos" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodPos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Pais" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Pais" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Rfc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Rfc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TelUno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TelUno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TelDos" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TelDos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Contacto1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contacto1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ext1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ext1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Contacto2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contacto2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ext2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ext2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Contacto3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contacto3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ext3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ext3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Notas" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Notas" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Foto" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Foto" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Capturo, Fecha, Tipo, RazonSoc, NombreCom, Calle, Numero, Colonia, CodPos, Estado, Pais, Rfc, TelUno, TelDos, Contacto1, Email1, Ext1, Contacto2, Email2, Ext2, Contacto3, Email3, Ext3, Notas, Foto FROM dbo.Clientes</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Clientes] SET [Capturo] = @Capturo, [Fecha] = @Fecha, [Tipo] = @Tipo, [RazonSoc] = @RazonSoc, [NombreCom] = @NombreCom, [Calle] = @Calle, [Numero] = @Numero, [Colonia] = @Colonia, [CodPos] = @CodPos, [Estado] = @Estado, [Pais] = @Pais, [Rfc] = @Rfc, [TelUno] = @TelUno, [TelDos] = @TelDos, [Contacto1] = @Contacto1, [Email1] = @Email1, [Ext1] = @Ext1, [Contacto2] = @Contacto2, [Email2] = @Email2, [Ext2] = @Ext2, [Contacto3] = @Contacto3, [Email3] = @Email3, [Ext3] = @Ext3, [Notas] = @Notas, [Foto] = @Foto WHERE (([ID] = @Original_ID) AND ((@IsNull_Capturo = 1 AND [Capturo] IS NULL) OR ([Capturo] = @Original_Capturo)) AND ((@IsNull_Fecha = 1 AND [Fecha] IS NULL) OR ([Fecha] = @Original_Fecha)) AND ((@IsNull_Tipo = 1 AND [Tipo] IS NULL) OR ([Tipo] = @Original_Tipo)) AND ((@IsNull_RazonSoc = 1 AND [RazonSoc] IS NULL) OR ([RazonSoc] = @Original_RazonSoc)) AND ((@IsNull_NombreCom = 1 AND [NombreCom] IS NULL) OR ([NombreCom] = @Original_NombreCom)) AND ((@IsNull_Calle = 1 AND [Calle] IS NULL) OR ([Calle] = @Original_Calle)) AND ((@IsNull_Numero = 1 AND [Numero] IS NULL) OR ([Numero] = @Original_Numero)) AND ((@IsNull_Colonia = 1 AND [Colonia] IS NULL) OR ([Colonia] = @Original_Colonia)) AND ((@IsNull_CodPos = 1 AND [CodPos] IS NULL) OR ([CodPos] = @Original_CodPos)) AND ((@IsNull_Estado = 1 AND [Estado] IS NULL) OR ([Estado] = @Original_Estado)) AND ((@IsNull_Pais = 1 AND [Pais] IS NULL) OR ([Pais] = @Original_Pais)) AND ((@IsNull_Rfc = 1 AND [Rfc] IS NULL) OR ([Rfc] = @Original_Rfc)) AND ((@IsNull_TelUno = 1 AND [TelUno] IS NULL) OR ([TelUno] = @Original_TelUno)) AND ((@IsNull_TelDos = 1 AND [TelDos] IS NULL) OR ([TelDos] = @Original_TelDos)) AND ((@IsNull_Contacto1 = 1 AND [Contacto1] IS NULL) OR ([Contacto1] = @Original_Contacto1)) AND ((@IsNull_Email1 = 1 AND [Email1] IS NULL) OR ([Email1] = @Original_Email1)) AND ((@IsNull_Ext1 = 1 AND [Ext1] IS NULL) OR ([Ext1] = @Original_Ext1)) AND ((@IsNull_Contacto2 = 1 AND [Contacto2] IS NULL) OR ([Contacto2] = @Original_Contacto2)) AND ((@IsNull_Email2 = 1 AND [Email2] IS NULL) OR ([Email2] = @Original_Email2)) AND ((@IsNull_Ext2 = 1 AND [Ext2] IS NULL) OR ([Ext2] = @Original_Ext2)) AND ((@IsNull_Contacto3 = 1 AND [Contacto3] IS NULL) OR ([Contacto3] = @Original_Contacto3)) AND ((@IsNull_Email3 = 1 AND [Email3] IS NULL) OR ([Email3] = @Original_Email3)) AND ((@IsNull_Ext3 = 1 AND [Ext3] IS NULL) OR ([Ext3] = @Original_Ext3)) AND ((@IsNull_Notas = 1 AND [Notas] IS NULL) OR ([Notas] = @Original_Notas)));
SELECT ID, Capturo, Fecha, Tipo, RazonSoc, NombreCom, Calle, Numero, Colonia, CodPos, Estado, Pais, Rfc, TelUno, TelDos, Contacto1, Email1, Ext1, Contacto2, Email2, Ext2, Contacto3, Email3, Ext3, Notas, Foto FROM Clientes WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Capturo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Capturo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Fecha" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Tipo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RazonSoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RazonSoc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NombreCom" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NombreCom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Calle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Calle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Numero" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Colonia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Colonia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodPos" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodPos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Pais" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Pais" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Rfc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Rfc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TelUno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TelUno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TelDos" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TelDos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Contacto1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contacto1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ext1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ext1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Contacto2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contacto2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ext2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ext2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Contacto3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contacto3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ext3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ext3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Notas" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Notas" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Foto" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Foto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Capturo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Capturo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Capturo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Capturo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Fecha" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tipo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Tipo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RazonSoc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RazonSoc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RazonSoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RazonSoc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NombreCom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NombreCom" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NombreCom" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NombreCom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Calle" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Calle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Calle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Calle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Numero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Numero" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Colonia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Colonia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Colonia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Colonia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodPos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodPos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodPos" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodPos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Estado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Estado" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Pais" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pais" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Pais" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Pais" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rfc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rfc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Rfc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Rfc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TelUno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TelUno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TelUno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TelUno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TelDos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TelDos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TelDos" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TelDos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Contacto1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Contacto1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Contacto1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contacto1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ext1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ext1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ext1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ext1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Contacto2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Contacto2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Contacto2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contacto2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ext2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ext2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ext2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ext2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Contacto3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Contacto3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Contacto3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contacto3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ext3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ext3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ext3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ext3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Notas" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Notas" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Notas" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Notas" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="IRGodam.dbo.Clientes" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Capturo" DataSetColumn="Capturo" />
              <Mapping SourceColumn="Fecha" DataSetColumn="Fecha" />
              <Mapping SourceColumn="Tipo" DataSetColumn="Tipo" />
              <Mapping SourceColumn="RazonSoc" DataSetColumn="RazonSoc" />
              <Mapping SourceColumn="NombreCom" DataSetColumn="NombreCom" />
              <Mapping SourceColumn="Calle" DataSetColumn="Calle" />
              <Mapping SourceColumn="Numero" DataSetColumn="Numero" />
              <Mapping SourceColumn="Colonia" DataSetColumn="Colonia" />
              <Mapping SourceColumn="CodPos" DataSetColumn="CodPos" />
              <Mapping SourceColumn="Estado" DataSetColumn="Estado" />
              <Mapping SourceColumn="Pais" DataSetColumn="Pais" />
              <Mapping SourceColumn="Rfc" DataSetColumn="Rfc" />
              <Mapping SourceColumn="TelUno" DataSetColumn="TelUno" />
              <Mapping SourceColumn="TelDos" DataSetColumn="TelDos" />
              <Mapping SourceColumn="Contacto1" DataSetColumn="Contacto1" />
              <Mapping SourceColumn="Email1" DataSetColumn="Email1" />
              <Mapping SourceColumn="Ext1" DataSetColumn="Ext1" />
              <Mapping SourceColumn="Contacto2" DataSetColumn="Contacto2" />
              <Mapping SourceColumn="Email2" DataSetColumn="Email2" />
              <Mapping SourceColumn="Ext2" DataSetColumn="Ext2" />
              <Mapping SourceColumn="Contacto3" DataSetColumn="Contacto3" />
              <Mapping SourceColumn="Email3" DataSetColumn="Email3" />
              <Mapping SourceColumn="Ext3" DataSetColumn="Ext3" />
              <Mapping SourceColumn="Notas" DataSetColumn="Notas" />
              <Mapping SourceColumn="Foto" DataSetColumn="Foto" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="InvoicesTableAdapter" GeneratorDataComponentClassName="InvoicesTableAdapter" Name="Invoices" UserDataComponentName="InvoicesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IRGodamConnectionString (MySettings)" DbObjectName="IRGodam.dbo.Invoices" 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 [Invoices] WHERE (([Id] = @Original_Id) AND ((@IsNull_Capturo = 1 AND [Capturo] IS NULL) OR ([Capturo] = @Original_Capturo)) AND ((@IsNull_Consecutivo = 1 AND [Consecutivo] IS NULL) OR ([Consecutivo] = @Original_Consecutivo)) AND ((@IsNull_Folio = 1 AND [Folio] IS NULL) OR ([Folio] = @Original_Folio)) AND ((@IsNull_TipoReg = 1 AND [TipoReg] IS NULL) OR ([TipoReg] = @Original_TipoReg)) AND ((@IsNull_Fecha = 1 AND [Fecha] IS NULL) OR ([Fecha] = @Original_Fecha)) AND ((@IsNull_Cliente = 1 AND [Cliente] IS NULL) OR ([Cliente] = @Original_Cliente)) AND ((@IsNull_Direccion = 1 AND [Direccion] IS NULL) OR ([Direccion] = @Original_Direccion)) AND ((@IsNull_Estatus = 1 AND [Estatus] IS NULL) OR ([Estatus] = @Original_Estatus)) AND ((@IsNull_Moneda = 1 AND [Moneda] IS NULL) OR ([Moneda] = @Original_Moneda)) AND ((@IsNull_Total = 1 AND [Total] IS NULL) OR ([Total] = @Original_Total)) AND ((@IsNull_Obs = 1 AND [Obs] IS NULL) OR ([Obs] = @Original_Obs)) AND ((@IsNull_Pagado = 1 AND [Pagado] IS NULL) OR ([Pagado] = @Original_Pagado)) AND ((@IsNull_FechaPag = 1 AND [FechaPag] IS NULL) OR ([FechaPag] = @Original_FechaPag)) AND ((@IsNull_RefPago = 1 AND [RefPago] IS NULL) OR ([RefPago] = @Original_RefPago)) AND ((@IsNull_TotalLetra = 1 AND [TotalLetra] IS NULL) OR ([TotalLetra] = @Original_TotalLetra)) AND ((@IsNull_Aplico = 1 AND [Aplico] IS NULL) OR ([Aplico] = @Original_Aplico)) AND ((@IsNull_FechaVenc = 1 AND [FechaVenc] IS NULL) OR ([FechaVenc] = @Original_FechaVenc)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Capturo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Capturo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Capturo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Capturo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Consecutivo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Consecutivo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Consecutivo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Consecutivo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Folio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Folio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Folio" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Folio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipoReg" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoReg" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TipoReg" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TipoReg" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Fecha" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cliente" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cliente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Direccion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Direccion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Direccion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Direccion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Estatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Estatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Estatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Estatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Moneda" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Moneda" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Moneda" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Moneda" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Total" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Total" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Total" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Total" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Obs" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Obs" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Obs" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Obs" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Pagado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pagado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Pagado" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Pagado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FechaPag" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FechaPag" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_FechaPag" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="FechaPag" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RefPago" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RefPago" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RefPago" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RefPago" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalLetra" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalLetra" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TotalLetra" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TotalLetra" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Aplico" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Aplico" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Aplico" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Aplico" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FechaVenc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FechaVenc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_FechaVenc" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="FechaVenc" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Invoices] ([Capturo], [Consecutivo], [Folio], [TipoReg], [Fecha], [Cliente], [Direccion], [Estatus], [Moneda], [Total], [Obs], [Pagado], [FechaPag], [RefPago], [TotalLetra], [Aplico], [FechaVenc]) VALUES (@Capturo, @Consecutivo, @Folio, @TipoReg, @Fecha, @Cliente, @Direccion, @Estatus, @Moneda, @Total, @Obs, @Pagado, @FechaPag, @RefPago, @TotalLetra, @Aplico, @FechaVenc);
SELECT Id, Capturo, Consecutivo, Folio, TipoReg, Fecha, Cliente, Direccion, Estatus, Moneda, Total, Obs, Pagado, FechaPag, RefPago, TotalLetra, Aplico, FechaVenc FROM Invoices WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Capturo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Capturo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Consecutivo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Consecutivo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Folio" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Folio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TipoReg" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TipoReg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Fecha" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Direccion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Direccion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Estatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Estatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Moneda" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Moneda" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Total" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Total" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Obs" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Obs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Pagado" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Pagado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@FechaPag" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="FechaPag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RefPago" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RefPago" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TotalLetra" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TotalLetra" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Aplico" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Aplico" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@FechaVenc" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="FechaVenc" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Capturo, Consecutivo, Folio, TipoReg, Fecha, Cliente, Direccion, Estatus, Moneda, Total, Obs, Pagado, FechaPag, RefPago, TotalLetra, Aplico, FechaVenc FROM Invoices</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Invoices] SET [Capturo] = @Capturo, [Consecutivo] = @Consecutivo, [Folio] = @Folio, [TipoReg] = @TipoReg, [Fecha] = @Fecha, [Cliente] = @Cliente, [Direccion] = @Direccion, [Estatus] = @Estatus, [Moneda] = @Moneda, [Total] = @Total, [Obs] = @Obs, [Pagado] = @Pagado, [FechaPag] = @FechaPag, [RefPago] = @RefPago, [TotalLetra] = @TotalLetra, [Aplico] = @Aplico, [FechaVenc] = @FechaVenc WHERE (([Id] = @Original_Id) AND ((@IsNull_Capturo = 1 AND [Capturo] IS NULL) OR ([Capturo] = @Original_Capturo)) AND ((@IsNull_Consecutivo = 1 AND [Consecutivo] IS NULL) OR ([Consecutivo] = @Original_Consecutivo)) AND ((@IsNull_Folio = 1 AND [Folio] IS NULL) OR ([Folio] = @Original_Folio)) AND ((@IsNull_TipoReg = 1 AND [TipoReg] IS NULL) OR ([TipoReg] = @Original_TipoReg)) AND ((@IsNull_Fecha = 1 AND [Fecha] IS NULL) OR ([Fecha] = @Original_Fecha)) AND ((@IsNull_Cliente = 1 AND [Cliente] IS NULL) OR ([Cliente] = @Original_Cliente)) AND ((@IsNull_Direccion = 1 AND [Direccion] IS NULL) OR ([Direccion] = @Original_Direccion)) AND ((@IsNull_Estatus = 1 AND [Estatus] IS NULL) OR ([Estatus] = @Original_Estatus)) AND ((@IsNull_Moneda = 1 AND [Moneda] IS NULL) OR ([Moneda] = @Original_Moneda)) AND ((@IsNull_Total = 1 AND [Total] IS NULL) OR ([Total] = @Original_Total)) AND ((@IsNull_Obs = 1 AND [Obs] IS NULL) OR ([Obs] = @Original_Obs)) AND ((@IsNull_Pagado = 1 AND [Pagado] IS NULL) OR ([Pagado] = @Original_Pagado)) AND ((@IsNull_FechaPag = 1 AND [FechaPag] IS NULL) OR ([FechaPag] = @Original_FechaPag)) AND ((@IsNull_RefPago = 1 AND [RefPago] IS NULL) OR ([RefPago] = @Original_RefPago)) AND ((@IsNull_TotalLetra = 1 AND [TotalLetra] IS NULL) OR ([TotalLetra] = @Original_TotalLetra)) AND ((@IsNull_Aplico = 1 AND [Aplico] IS NULL) OR ([Aplico] = @Original_Aplico)) AND ((@IsNull_FechaVenc = 1 AND [FechaVenc] IS NULL) OR ([FechaVenc] = @Original_FechaVenc)));
SELECT Id, Capturo, Consecutivo, Folio, TipoReg, Fecha, Cliente, Direccion, Estatus, Moneda, Total, Obs, Pagado, FechaPag, RefPago, TotalLetra, Aplico, FechaVenc FROM Invoices WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Capturo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Capturo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Consecutivo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Consecutivo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Folio" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Folio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TipoReg" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TipoReg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Fecha" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Direccion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Direccion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Estatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Estatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Moneda" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Moneda" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Total" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Total" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Obs" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Obs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Pagado" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Pagado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@FechaPag" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="FechaPag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RefPago" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RefPago" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TotalLetra" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TotalLetra" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Aplico" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Aplico" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@FechaVenc" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="FechaVenc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Capturo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Capturo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Capturo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Capturo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Consecutivo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Consecutivo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Consecutivo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Consecutivo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Folio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Folio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Folio" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Folio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipoReg" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoReg" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TipoReg" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TipoReg" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Fecha" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cliente" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cliente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Direccion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Direccion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Direccion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Direccion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Estatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Estatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Estatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Estatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Moneda" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Moneda" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Moneda" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Moneda" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Total" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Total" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Total" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Total" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Obs" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Obs" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Obs" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Obs" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Pagado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pagado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Pagado" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Pagado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FechaPag" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FechaPag" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_FechaPag" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="FechaPag" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RefPago" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RefPago" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RefPago" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RefPago" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalLetra" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalLetra" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TotalLetra" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TotalLetra" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Aplico" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Aplico" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Aplico" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Aplico" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FechaVenc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FechaVenc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_FechaVenc" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="FechaVenc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="IRGodam.dbo.Invoices" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Capturo" DataSetColumn="Capturo" />
              <Mapping SourceColumn="Consecutivo" DataSetColumn="Consecutivo" />
              <Mapping SourceColumn="Folio" DataSetColumn="Folio" />
              <Mapping SourceColumn="TipoReg" DataSetColumn="TipoReg" />
              <Mapping SourceColumn="Fecha" DataSetColumn="Fecha" />
              <Mapping SourceColumn="Cliente" DataSetColumn="Cliente" />
              <Mapping SourceColumn="Direccion" DataSetColumn="Direccion" />
              <Mapping SourceColumn="Estatus" DataSetColumn="Estatus" />
              <Mapping SourceColumn="Moneda" DataSetColumn="Moneda" />
              <Mapping SourceColumn="Total" DataSetColumn="Total" />
              <Mapping SourceColumn="Obs" DataSetColumn="Obs" />
              <Mapping SourceColumn="Pagado" DataSetColumn="Pagado" />
              <Mapping SourceColumn="FechaPag" DataSetColumn="FechaPag" />
              <Mapping SourceColumn="RefPago" DataSetColumn="RefPago" />
              <Mapping SourceColumn="TotalLetra" DataSetColumn="TotalLetra" />
              <Mapping SourceColumn="Aplico" DataSetColumn="Aplico" />
              <Mapping SourceColumn="FechaVenc" DataSetColumn="FechaVenc" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="InvoicesDetTableAdapter" GeneratorDataComponentClassName="InvoicesDetTableAdapter" Name="InvoicesDet" UserDataComponentName="InvoicesDetTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="IRGodamConnectionString (MySettings)" DbObjectName="IRGodam.dbo.InvoicesDet" 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 [dbo].[InvoicesDet] WHERE (([Id] = @Original_Id) AND ((@IsNull_IdReg = 1 AND [IdReg] IS NULL) OR ([IdReg] = @Original_IdReg)) AND ((@IsNull_Folio = 1 AND [Folio] IS NULL) OR ([Folio] = @Original_Folio)) AND ((@IsNull_Linea = 1 AND [Linea] IS NULL) OR ([Linea] = @Original_Linea)) AND ((@IsNull_Descripcion = 1 AND [Descripcion] IS NULL) OR ([Descripcion] = @Original_Descripcion)) AND ((@IsNull_Cantidad = 1 AND [Cantidad] IS NULL) OR ([Cantidad] = @Original_Cantidad)) AND ((@IsNull_Precio = 1 AND [Precio] IS NULL) OR ([Precio] = @Original_Precio)) AND ((@IsNull_Importe = 1 AND [Importe] IS NULL) OR ([Importe] = @Original_Importe)) AND ((@IsNull_Pedimento = 1 AND [Pedimento] IS NULL) OR ([Pedimento] = @Original_Pedimento)) AND ((@IsNull_Caja = 1 AND [Caja] IS NULL) OR ([Caja] = @Original_Caja)) AND ((@IsNull_Invo = 1 AND [Invo] IS NULL) OR ([Invo] = @Original_Invo)) AND ((@IsNull_FecInvo = 1 AND [FecInvo] IS NULL) OR ([FecInvo] = @Original_FecInvo)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdReg" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdReg" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdReg" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdReg" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Folio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Folio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Folio" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Folio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Linea" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Linea" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Linea" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Linea" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descripcion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Precio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Precio" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Importe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Importe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Importe" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Importe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Pedimento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pedimento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Pedimento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Pedimento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Caja" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Caja" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Caja" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Caja" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Invo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Invo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Invo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Invo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FecInvo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FecInvo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FecInvo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FecInvo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[InvoicesDet] ([IdReg], [Folio], [Linea], [Descripcion], [Cantidad], [Precio], [Importe], [Pedimento], [Caja], [Invo], [FecInvo]) VALUES (@IdReg, @Folio, @Linea, @Descripcion, @Cantidad, @Precio, @Importe, @Pedimento, @Caja, @Invo, @FecInvo);
SELECT Id, IdReg, Folio, Linea, Descripcion, Cantidad, Precio, Importe, Pedimento, Caja, Invo, FecInvo FROM InvoicesDet WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdReg" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdReg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Folio" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Folio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Linea" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Linea" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Precio" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Importe" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Importe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Pedimento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Pedimento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Caja" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Caja" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Invo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Invo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FecInvo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FecInvo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, IdReg, Folio, Linea, Descripcion, Cantidad, Precio, Importe, Pedimento, Caja, Invo, FecInvo FROM dbo.InvoicesDet</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[InvoicesDet] SET [IdReg] = @IdReg, [Folio] = @Folio, [Linea] = @Linea, [Descripcion] = @Descripcion, [Cantidad] = @Cantidad, [Precio] = @Precio, [Importe] = @Importe, [Pedimento] = @Pedimento, [Caja] = @Caja, [Invo] = @Invo, [FecInvo] = @FecInvo WHERE (([Id] = @Original_Id) AND ((@IsNull_IdReg = 1 AND [IdReg] IS NULL) OR ([IdReg] = @Original_IdReg)) AND ((@IsNull_Folio = 1 AND [Folio] IS NULL) OR ([Folio] = @Original_Folio)) AND ((@IsNull_Linea = 1 AND [Linea] IS NULL) OR ([Linea] = @Original_Linea)) AND ((@IsNull_Descripcion = 1 AND [Descripcion] IS NULL) OR ([Descripcion] = @Original_Descripcion)) AND ((@IsNull_Cantidad = 1 AND [Cantidad] IS NULL) OR ([Cantidad] = @Original_Cantidad)) AND ((@IsNull_Precio = 1 AND [Precio] IS NULL) OR ([Precio] = @Original_Precio)) AND ((@IsNull_Importe = 1 AND [Importe] IS NULL) OR ([Importe] = @Original_Importe)) AND ((@IsNull_Pedimento = 1 AND [Pedimento] IS NULL) OR ([Pedimento] = @Original_Pedimento)) AND ((@IsNull_Caja = 1 AND [Caja] IS NULL) OR ([Caja] = @Original_Caja)) AND ((@IsNull_Invo = 1 AND [Invo] IS NULL) OR ([Invo] = @Original_Invo)) AND ((@IsNull_FecInvo = 1 AND [FecInvo] IS NULL) OR ([FecInvo] = @Original_FecInvo)));
SELECT Id, IdReg, Folio, Linea, Descripcion, Cantidad, Precio, Importe, Pedimento, Caja, Invo, FecInvo FROM InvoicesDet WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdReg" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdReg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Folio" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Folio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Linea" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Linea" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Precio" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Importe" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Importe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Pedimento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Pedimento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Caja" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Caja" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Invo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Invo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FecInvo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FecInvo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdReg" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdReg" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdReg" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdReg" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Folio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Folio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Folio" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Folio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Linea" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Linea" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Linea" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Linea" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descripcion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Precio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Precio" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Importe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Importe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Importe" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Importe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Pedimento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pedimento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Pedimento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Pedimento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Caja" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Caja" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Caja" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Caja" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Invo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Invo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Invo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Invo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FecInvo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FecInvo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FecInvo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FecInvo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="IRGodam.dbo.InvoicesDet" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="IdReg" DataSetColumn="IdReg" />
              <Mapping SourceColumn="Folio" DataSetColumn="Folio" />
              <Mapping SourceColumn="Linea" DataSetColumn="Linea" />
              <Mapping SourceColumn="Descripcion" DataSetColumn="Descripcion" />
              <Mapping SourceColumn="Cantidad" DataSetColumn="Cantidad" />
              <Mapping SourceColumn="Precio" DataSetColumn="Precio" />
              <Mapping SourceColumn="Importe" DataSetColumn="Importe" />
              <Mapping SourceColumn="Pedimento" DataSetColumn="Pedimento" />
              <Mapping SourceColumn="Caja" DataSetColumn="Caja" />
              <Mapping SourceColumn="Invo" DataSetColumn="Invo" />
              <Mapping SourceColumn="FecInvo" DataSetColumn="FecInvo" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="IRGodamDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="IRGodamDataSet" msprop:Generator_UserDSName="IRGodamDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Clientes" msprop:Generator_TableClassName="ClientesDataTable" msprop:Generator_TableVarName="tableClientes" msprop:Generator_RowChangedName="ClientesRowChanged" msprop:Generator_TablePropName="Clientes" msprop:Generator_RowDeletingName="ClientesRowDeleting" msprop:Generator_RowChangingName="ClientesRowChanging" msprop:Generator_RowEvHandlerName="ClientesRowChangeEventHandler" msprop:Generator_RowDeletedName="ClientesRowDeleted" msprop:Generator_RowClassName="ClientesRow" msprop:Generator_UserTableName="Clientes" msprop:Generator_RowEvArgName="ClientesRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Capturo" msprop:Generator_ColumnVarNameInTable="columnCapturo" msprop:Generator_ColumnPropNameInRow="Capturo" msprop:Generator_ColumnPropNameInTable="CapturoColumn" msprop:Generator_UserColumnName="Capturo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fecha" msprop:Generator_ColumnVarNameInTable="columnFecha" msprop:Generator_ColumnPropNameInRow="Fecha" msprop:Generator_ColumnPropNameInTable="FechaColumn" msprop:Generator_UserColumnName="Fecha" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Tipo" msprop:Generator_ColumnVarNameInTable="columnTipo" msprop:Generator_ColumnPropNameInRow="Tipo" msprop:Generator_ColumnPropNameInTable="TipoColumn" msprop:Generator_UserColumnName="Tipo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RazonSoc" msprop:Generator_ColumnVarNameInTable="columnRazonSoc" msprop:Generator_ColumnPropNameInRow="RazonSoc" msprop:Generator_ColumnPropNameInTable="RazonSocColumn" msprop:Generator_UserColumnName="RazonSoc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NombreCom" msprop:Generator_ColumnVarNameInTable="columnNombreCom" msprop:Generator_ColumnPropNameInRow="NombreCom" msprop:Generator_ColumnPropNameInTable="NombreComColumn" msprop:Generator_UserColumnName="NombreCom" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Calle" msprop:Generator_ColumnVarNameInTable="columnCalle" msprop:Generator_ColumnPropNameInRow="Calle" msprop:Generator_ColumnPropNameInTable="CalleColumn" msprop:Generator_UserColumnName="Calle" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Numero" msprop:Generator_ColumnVarNameInTable="columnNumero" msprop:Generator_ColumnPropNameInRow="Numero" msprop:Generator_ColumnPropNameInTable="NumeroColumn" msprop:Generator_UserColumnName="Numero" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Colonia" msprop:Generator_ColumnVarNameInTable="columnColonia" msprop:Generator_ColumnPropNameInRow="Colonia" msprop:Generator_ColumnPropNameInTable="ColoniaColumn" msprop:Generator_UserColumnName="Colonia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodPos" msprop:Generator_ColumnVarNameInTable="columnCodPos" msprop:Generator_ColumnPropNameInRow="CodPos" msprop:Generator_ColumnPropNameInTable="CodPosColumn" msprop:Generator_UserColumnName="CodPos" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Estado" msprop:Generator_ColumnVarNameInTable="columnEstado" msprop:Generator_ColumnPropNameInRow="Estado" msprop:Generator_ColumnPropNameInTable="EstadoColumn" msprop:Generator_UserColumnName="Estado" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Pais" msprop:Generator_ColumnVarNameInTable="columnPais" msprop:Generator_ColumnPropNameInRow="Pais" msprop:Generator_ColumnPropNameInTable="PaisColumn" msprop:Generator_UserColumnName="Pais" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Rfc" msprop:Generator_ColumnVarNameInTable="columnRfc" msprop:Generator_ColumnPropNameInRow="Rfc" msprop:Generator_ColumnPropNameInTable="RfcColumn" msprop:Generator_UserColumnName="Rfc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TelUno" msprop:Generator_ColumnVarNameInTable="columnTelUno" msprop:Generator_ColumnPropNameInRow="TelUno" msprop:Generator_ColumnPropNameInTable="TelUnoColumn" msprop:Generator_UserColumnName="TelUno" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TelDos" msprop:Generator_ColumnVarNameInTable="columnTelDos" msprop:Generator_ColumnPropNameInRow="TelDos" msprop:Generator_ColumnPropNameInTable="TelDosColumn" msprop:Generator_UserColumnName="TelDos" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Contacto1" msprop:Generator_ColumnVarNameInTable="columnContacto1" msprop:Generator_ColumnPropNameInRow="Contacto1" msprop:Generator_ColumnPropNameInTable="Contacto1Column" msprop:Generator_UserColumnName="Contacto1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email1" msprop:Generator_ColumnVarNameInTable="columnEmail1" msprop:Generator_ColumnPropNameInRow="Email1" msprop:Generator_ColumnPropNameInTable="Email1Column" msprop:Generator_UserColumnName="Email1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ext1" msprop:Generator_ColumnVarNameInTable="columnExt1" msprop:Generator_ColumnPropNameInRow="Ext1" msprop:Generator_ColumnPropNameInTable="Ext1Column" msprop:Generator_UserColumnName="Ext1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Contacto2" msprop:Generator_ColumnVarNameInTable="columnContacto2" msprop:Generator_ColumnPropNameInRow="Contacto2" msprop:Generator_ColumnPropNameInTable="Contacto2Column" msprop:Generator_UserColumnName="Contacto2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email2" msprop:Generator_ColumnVarNameInTable="columnEmail2" msprop:Generator_ColumnPropNameInRow="Email2" msprop:Generator_ColumnPropNameInTable="Email2Column" msprop:Generator_UserColumnName="Email2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ext2" msprop:Generator_ColumnVarNameInTable="columnExt2" msprop:Generator_ColumnPropNameInRow="Ext2" msprop:Generator_ColumnPropNameInTable="Ext2Column" msprop:Generator_UserColumnName="Ext2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Contacto3" msprop:Generator_ColumnVarNameInTable="columnContacto3" msprop:Generator_ColumnPropNameInRow="Contacto3" msprop:Generator_ColumnPropNameInTable="Contacto3Column" msprop:Generator_UserColumnName="Contacto3" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email3" msprop:Generator_ColumnVarNameInTable="columnEmail3" msprop:Generator_ColumnPropNameInRow="Email3" msprop:Generator_ColumnPropNameInTable="Email3Column" msprop:Generator_UserColumnName="Email3" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ext3" msprop:Generator_ColumnVarNameInTable="columnExt3" msprop:Generator_ColumnPropNameInRow="Ext3" msprop:Generator_ColumnPropNameInTable="Ext3Column" msprop:Generator_UserColumnName="Ext3" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Notas" msprop:Generator_ColumnVarNameInTable="columnNotas" msprop:Generator_ColumnPropNameInRow="Notas" msprop:Generator_ColumnPropNameInTable="NotasColumn" msprop:Generator_UserColumnName="Notas" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Foto" msprop:Generator_ColumnVarNameInTable="columnFoto" msprop:Generator_ColumnPropNameInRow="Foto" msprop:Generator_ColumnPropNameInTable="FotoColumn" msprop:Generator_UserColumnName="Foto" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Invoices" msprop:Generator_TableClassName="InvoicesDataTable" msprop:Generator_TableVarName="tableInvoices" msprop:Generator_RowChangedName="InvoicesRowChanged" msprop:Generator_TablePropName="Invoices" msprop:Generator_RowDeletingName="InvoicesRowDeleting" msprop:Generator_RowChangingName="InvoicesRowChanging" msprop:Generator_RowEvHandlerName="InvoicesRowChangeEventHandler" msprop:Generator_RowDeletedName="InvoicesRowDeleted" msprop:Generator_RowClassName="InvoicesRow" msprop:Generator_UserTableName="Invoices" msprop:Generator_RowEvArgName="InvoicesRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Capturo" msprop:Generator_ColumnVarNameInTable="columnCapturo" msprop:Generator_ColumnPropNameInRow="Capturo" msprop:Generator_ColumnPropNameInTable="CapturoColumn" msprop:Generator_UserColumnName="Capturo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Consecutivo" msprop:Generator_ColumnVarNameInTable="columnConsecutivo" msprop:Generator_ColumnPropNameInRow="Consecutivo" msprop:Generator_ColumnPropNameInTable="ConsecutivoColumn" msprop:Generator_UserColumnName="Consecutivo" type="xs:int" minOccurs="0" />
              <xs:element name="Folio" msprop:Generator_ColumnVarNameInTable="columnFolio" msprop:Generator_ColumnPropNameInRow="Folio" msprop:Generator_ColumnPropNameInTable="FolioColumn" msprop:Generator_UserColumnName="Folio" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TipoReg" msprop:Generator_ColumnVarNameInTable="columnTipoReg" msprop:Generator_ColumnPropNameInRow="TipoReg" msprop:Generator_ColumnPropNameInTable="TipoRegColumn" msprop:Generator_UserColumnName="TipoReg" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fecha" msprop:Generator_ColumnVarNameInTable="columnFecha" msprop:Generator_ColumnPropNameInRow="Fecha" msprop:Generator_ColumnPropNameInTable="FechaColumn" msprop:Generator_UserColumnName="Fecha" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Cliente" msprop:Generator_ColumnVarNameInTable="columnCliente" msprop:Generator_ColumnPropNameInRow="Cliente" msprop:Generator_ColumnPropNameInTable="ClienteColumn" msprop:Generator_UserColumnName="Cliente" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Direccion" msprop:Generator_ColumnVarNameInTable="columnDireccion" msprop:Generator_ColumnPropNameInRow="Direccion" msprop:Generator_ColumnPropNameInTable="DireccionColumn" msprop:Generator_UserColumnName="Direccion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="350" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Estatus" msprop:Generator_ColumnVarNameInTable="columnEstatus" msprop:Generator_ColumnPropNameInRow="Estatus" msprop:Generator_ColumnPropNameInTable="EstatusColumn" msprop:Generator_UserColumnName="Estatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Moneda" msprop:Generator_ColumnVarNameInTable="columnMoneda" msprop:Generator_ColumnPropNameInRow="Moneda" msprop:Generator_ColumnPropNameInTable="MonedaColumn" msprop:Generator_UserColumnName="Moneda" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Total" msprop:Generator_ColumnVarNameInTable="columnTotal" msprop:Generator_ColumnPropNameInRow="Total" msprop:Generator_ColumnPropNameInTable="TotalColumn" msprop:Generator_UserColumnName="Total" type="xs:double" minOccurs="0" />
              <xs:element name="Obs" msprop:Generator_ColumnVarNameInTable="columnObs" msprop:Generator_ColumnPropNameInRow="Obs" msprop:Generator_ColumnPropNameInTable="ObsColumn" msprop:Generator_UserColumnName="Obs" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Pagado" msprop:Generator_ColumnVarNameInTable="columnPagado" msprop:Generator_ColumnPropNameInRow="Pagado" msprop:Generator_ColumnPropNameInTable="PagadoColumn" msprop:Generator_UserColumnName="Pagado" type="xs:boolean" minOccurs="0" />
              <xs:element name="FechaPag" msprop:Generator_ColumnVarNameInTable="columnFechaPag" msprop:Generator_ColumnPropNameInRow="FechaPag" msprop:Generator_ColumnPropNameInTable="FechaPagColumn" msprop:Generator_UserColumnName="FechaPag" type="xs:dateTime" minOccurs="0" />
              <xs:element name="RefPago" msprop:Generator_ColumnVarNameInTable="columnRefPago" msprop:Generator_ColumnPropNameInRow="RefPago" msprop:Generator_ColumnPropNameInTable="RefPagoColumn" msprop:Generator_UserColumnName="RefPago" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TotalLetra" msprop:Generator_ColumnVarNameInTable="columnTotalLetra" msprop:Generator_ColumnPropNameInRow="TotalLetra" msprop:Generator_ColumnPropNameInTable="TotalLetraColumn" msprop:Generator_UserColumnName="TotalLetra" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Aplico" msprop:Generator_ColumnVarNameInTable="columnAplico" msprop:Generator_ColumnPropNameInRow="Aplico" msprop:Generator_ColumnPropNameInTable="AplicoColumn" msprop:Generator_UserColumnName="Aplico" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FechaVenc" msprop:Generator_ColumnVarNameInTable="columnFechaVenc" msprop:Generator_ColumnPropNameInRow="FechaVenc" msprop:Generator_ColumnPropNameInTable="FechaVencColumn" msprop:Generator_UserColumnName="FechaVenc" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="InvoicesDet" msprop:Generator_TableClassName="InvoicesDetDataTable" msprop:Generator_TableVarName="tableInvoicesDet" msprop:Generator_RowChangedName="InvoicesDetRowChanged" msprop:Generator_TablePropName="InvoicesDet" msprop:Generator_RowDeletingName="InvoicesDetRowDeleting" msprop:Generator_RowChangingName="InvoicesDetRowChanging" msprop:Generator_RowEvHandlerName="InvoicesDetRowChangeEventHandler" msprop:Generator_RowDeletedName="InvoicesDetRowDeleted" msprop:Generator_RowClassName="InvoicesDetRow" msprop:Generator_UserTableName="InvoicesDet" msprop:Generator_RowEvArgName="InvoicesDetRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="IdReg" msprop:Generator_ColumnVarNameInTable="columnIdReg" msprop:Generator_ColumnPropNameInRow="IdReg" msprop:Generator_ColumnPropNameInTable="IdRegColumn" msprop:Generator_UserColumnName="IdReg" type="xs:int" minOccurs="0" />
              <xs:element name="Folio" msprop:Generator_ColumnVarNameInTable="columnFolio" msprop:Generator_ColumnPropNameInRow="Folio" msprop:Generator_ColumnPropNameInTable="FolioColumn" msprop:Generator_UserColumnName="Folio" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Linea" msprop:Generator_ColumnVarNameInTable="columnLinea" msprop:Generator_ColumnPropNameInRow="Linea" msprop:Generator_ColumnPropNameInTable="LineaColumn" msprop:Generator_UserColumnName="Linea" type="xs:int" minOccurs="0" />
              <xs:element name="Descripcion" msprop:Generator_ColumnVarNameInTable="columnDescripcion" msprop:Generator_ColumnPropNameInRow="Descripcion" msprop:Generator_ColumnPropNameInTable="DescripcionColumn" msprop:Generator_UserColumnName="Descripcion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cantidad" msprop:Generator_ColumnVarNameInTable="columnCantidad" msprop:Generator_ColumnPropNameInRow="Cantidad" msprop:Generator_ColumnPropNameInTable="CantidadColumn" msprop:Generator_UserColumnName="Cantidad" type="xs:int" minOccurs="0" />
              <xs:element name="Precio" msprop:Generator_ColumnVarNameInTable="columnPrecio" msprop:Generator_ColumnPropNameInRow="Precio" msprop:Generator_ColumnPropNameInTable="PrecioColumn" msprop:Generator_UserColumnName="Precio" type="xs:double" minOccurs="0" />
              <xs:element name="Importe" msprop:Generator_ColumnVarNameInTable="columnImporte" msprop:Generator_ColumnPropNameInRow="Importe" msprop:Generator_ColumnPropNameInTable="ImporteColumn" msprop:Generator_UserColumnName="Importe" type="xs:double" minOccurs="0" />
              <xs:element name="Pedimento" msprop:Generator_ColumnVarNameInTable="columnPedimento" msprop:Generator_ColumnPropNameInRow="Pedimento" msprop:Generator_ColumnPropNameInTable="PedimentoColumn" msprop:Generator_UserColumnName="Pedimento" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Caja" msprop:Generator_ColumnVarNameInTable="columnCaja" msprop:Generator_ColumnPropNameInRow="Caja" msprop:Generator_ColumnPropNameInTable="CajaColumn" msprop:Generator_UserColumnName="Caja" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Invo" msprop:Generator_ColumnVarNameInTable="columnInvo" msprop:Generator_ColumnPropNameInRow="Invo" msprop:Generator_ColumnPropNameInTable="InvoColumn" msprop:Generator_UserColumnName="Invo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FecInvo" msprop:Generator_ColumnVarNameInTable="columnFecInvo" msprop:Generator_ColumnPropNameInRow="FecInvo" msprop:Generator_ColumnPropNameInTable="FecInvoColumn" msprop:Generator_UserColumnName="FecInvo" 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:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Clientes" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Invoices_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Invoices" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="InvoicesDet_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:InvoicesDet" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
  </xs:element>
</xs:schema>