﻿<?xml version="1.0" encoding="utf-8" ?>
<xml>
  <sql id="CtaNivel">
    <![CDATA[select sys_pk,icuenta from ccontable order by sys_pk desc]]>
  </sql>

  <sql id="Nivel">
    <![CDATA[select sys_pk,icuenta from ccontable where sys_pk=@cta]]>
  </sql>

  <sql id="SetNivel">
    <![CDATA[update ccontable set Sys_Info=@nivel where sys_pk=@cta]]>
  </sql>

  <sql id="CmdFree">
    <![CDATA[@sqlcmd]]>
  </sql>

  <sql id="BorrarBancosSat">
    <![CDATA[delete from ut_sat_banco;]]>
  </sql>

  <sql id="NuevoBanco">
    <![CDATA[
      insert into ut_sat_banco
      (Sys_TimeStamp, Sys_GUID, Sys_DTCreated, Sys_User, Sys_LastUser, Sys_Exported, Sys_DTExported, Sys_Info, uf_cve, uf_nombre, uf_descripcion)
      values
      (@ahora, @guid, @ahora, null, null, 0, @ahora, null, @cve, @nombre, @descripcion)
    ]]>
  </sql>

  <sql id="EditMoneda">
    <![CDATA[
      update divisa set Codigo=@cve,Descripcion=@descripcion where Codigo=@cve_old
    ]]>
  </sql>

  <sql id="NuevoMoneda" name="NuevoMoneda">
    <![CDATA[
      insert into divisa
      (Sys_TimeStamp, Sys_GUID, Sys_DTCreated, Sys_User, Sys_LastUser, Sys_Exported, Sys_DTExported, Sys_Info, Codigo, Descripcion, TCambio)
      values
      (@ahora, @guid, @ahora, null, null, 0, @ahora, null, @cve, @descripcion,1)
    ]]>
  </sql>

  <sql id="NuevoPago">
    <![CDATA[
      insert into ut_sat_metodo_pago
      (Sys_TimeStamp, Sys_GUID, Sys_DTCreated, Sys_User, Sys_LastUser, Sys_Exported, Sys_DTExported, Sys_Info, uf_Codigo, uf_Descripcion)
      values
      (@ahora, @guid, @ahora, null, null, 0, @ahora, null, @cve, @descripcion)
    ]]>
  </sql>

  <sql id="BorrarPagos">
    <![CDATA[delete from ut_sat_metodo_pago]]>
  </sql>

  <sql id="ClearCtaSat">
    <![CDATA[update ccontable set uf_sat_codigo=0]]>
  </sql>

  <sql id="BorrarCtaSat">
    <![CDATA[delete from ut_sat_cuenta]]>
  </sql>

  <sql id="NuevaCtaSat">
    <![CDATA[
      insert into ut_sat_cuenta
      (Sys_TimeStamp, Sys_GUID, Sys_DTCreated, Sys_User, Sys_LastUser, Sys_Exported, Sys_DTExported, Sys_Info, uf_CodAgrup, uf_NumCta, uf_Desc, uf_SubCuentaDe, uf_Nivel, uf_Naturaleza)
      values
      (@ahora, @guid, @ahora, null, null, 0, @ahora, null, @codagr, @numcta, @desc, @subde, @niv, @natu)
    ]]>
  </sql>

  <!--MYSQL-->
  <sql id="mysql_divisa">
    <![CDATA[ALTER TABLE divisa MODIFY COLUMN Descripcion VARCHAR(255);]]>
  </sql>

  <sql id="mysql_satcta">
    <![CDATA[ALTER TABLE ut_sat_cuenta MODIFY COLUMN uf_Desc VARCHAR(255);]]>
  </sql>

  <sql id="mysql_delpago">
    <![CDATA[DROP TABLE IF EXISTS ut_sat_metodo_pago;]]>
  </sql>

  <sql id="mysql_newtpago">
    <![CDATA[CREATE TABLE ut_sat_metodo_pago (Sys_PK int(11) NOT NULL auto_increment,Sys_TimeStamp datetime NOT NULL,Sys_GUID varchar(32) NOT NULL,Sys_DTCreated datetime default NULL,Sys_User varchar(5) default NULL,Sys_LastUser varchar(5) default NULL,Sys_Exported tinyint(1) default NULL,Sys_DTExported datetime default NULL,Sys_Info varchar(32) default NULL,uf_Codigo varchar(50) NOT NULL,uf_Descripcion varchar(255) default NULL,sys_recver int(11) default '0',sys_deleted bit(1) default NULL,sys_lock int(11) default NULL,PRIMARY KEY(Sys_PK),UNIQUE KEY Sys_GUID (Sys_GUID),UNIQUE KEY uf_Codigo (uf_Codigo));]]>
  </sql>
  
  <!--SQLSERVER-->
  <sql id="sqlsvr_divisa">
    <![CDATA[ALTER TABLE divisa ALTER COLUMN Descripcion VARCHAR(255);]]>
  </sql>

  <sql id="sqlsvr_satcta">
     <![CDATA[ALTER TABLE ut_sat_cuenta ALTER COLUMN uf_Desc VARCHAR(255);]]>
  </sql>

  <sql id="sqlsvr_delpago">
    <![CDATA[IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'ut_sat_metodo_pago') AND type in (N'U')) DROP TABLE ut_sat_metodo_pago;]]>
  </sql>

  <sql id="sqlsvr_newtpago">
    <![CDATA[CREATE TABLE ut_sat_metodo_pago (Sys_PK Int NOT NULL IDENTITY(1,1) CONSTRAINT IDX_ut_sat_metodo_pago_PK PRIMARY KEY , Sys_TimeStamp Datetime  NOT NULL , Sys_GUID VARCHAR(32) NOT NULL  UNIQUE , Sys_DTCreated Datetime , Sys_User VARCHAR(5), Sys_LastUser VARCHAR(5), Sys_Exported BIT , Sys_DTExported Datetime , Sys_Info VARCHAR(32),uf_Codigo VARCHAR(50), uf_Descripcion VARCHAR(255),sys_recver int default 0,sys_deleted bit default NULL,sys_lock int default NULL);]]>
  </sql>

  <!--Access-->
  <sql id="sqlacc_divisa">
    <![CDATA[ALTER TABLE divisa ALTER COLUMN Descripcion VARCHAR(255);]]>
  </sql>

  <sql id="sqlacc_satcta">
    <![CDATA[ALTER TABLE ut_sat_cuenta ALTER COLUMN uf_Desc VARCHAR(255);]]>
  </sql>

  <sql id="sqlacc_delpago">
    <![CDATA[DROP TABLE ut_sat_metodo_pago]]>
  </sql>

  <sql id="sqlacc_newtpago">
    <![CDATA[CREATE TABLE ut_sat_metodo_pago (sys_pk AUTOINCREMENT (1,1) NOT NULL CONSTRAINT idx_sys_ut_sat_metodo_pago_pk PRIMARY KEY,  Sys_TimeStamp Datetime  NOT NULL , Sys_GUID VARCHAR(32) NOT NULL  UNIQUE , Sys_DTCreated Datetime ,  Sys_User VARCHAR(5), Sys_LastUser VARCHAR(5),  Sys_Exported Bit ,  Sys_DTExported Datetime ,  Sys_Info VARCHAR(32), uf_Codigo VARCHAR(50), uf_Descripcion VARCHAR(255),sys_recver int,sys_deleted bit,sys_lock int);]]>
  </sql>
</xml>