private void InsertDatosExportados(DcemVwContabilidad item, Int16 version)
{
string sql = "insert into DcemContabilidadExportados (fecha, year1, periodid, catalogo, tipodoc, version) values (@fecha, @year1, @periodid, @catalogo, @tipodoc, @version)";
using (SqlConnection conn = new SqlConnection(connectionString))
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
//cmd.CommandTimeout = Settings.Default.reportTimeout;
cmd.Parameters.Add("@fecha", SqlDbType.DateTime).Value = DateTime.Now;
cmd.Parameters.Add("@year1", SqlDbType.SmallInt).Value = item.year1;
cmd.Parameters.Add("@periodid", SqlDbType.SmallInt).Value = item.periodid;
cmd.Parameters.Add("@tipodoc", SqlDbType.VarChar, 20).Value = item.tipodoc;
cmd.Parameters.Add("@catalogo", SqlDbType.Xml).Value = item.catalogo;
cmd.Parameters.Add("@version", SqlDbType.SmallInt).Value = version;
cmd.CommandTimeout = 0;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
}
}
