public void Modificar(CatalogoServBE pCatSrvBE)
{
string wsql = string.Empty;
decimal codRegistroN = ObtenerCodRegistro(pCatSrvBE.CodServicioN);
wsql = "update GE_AMBCATALOGO SET " + Environment.NewLine +
"COD_TIPRETORNO_N = " + Convert.ToString(pCatSrvBE.CodTipretornoN) + "," + Environment.NewLine +
"COD_OBJPROP_N = " + Convert.ToString(pCatSrvBE.CodObjpropN) + "," + Environment.NewLine +
"COD_TIPSERVICIO_N = " + Convert.ToString(pCatSrvBE.CodTipservicioN) + "," + Environment.NewLine +
"COD_ACCSERV_N = " + Convert.ToString(pCatSrvBE.CodAccservN) + "," + Environment.NewLine +
"NOM_SERVICIO = " + MyStringUtils.entreComas(pCatSrvBE.NomServicio) + "," + Environment.NewLine +
"IND_ATOMSERV_V = " + MyStringUtils.entreComas(pCatSrvBE.IndAtomservV) + "," + Environment.NewLine +
"COD_MODULO_N = " + Convert.ToString(pCatSrvBE.CodModuloN) + "," + Environment.NewLine +
"DES_SERVICIO = " + MyStringUtils.entreComas(pCatSrvBE.DesServicio) + "," + Environment.NewLine +
"NUM_CACHE = " + Convert.ToString(pCatSrvBE.NumCache) + "," + Environment.NewLine +
"DES_INVOCADOR = " + MyStringUtils.entreComas(pCatSrvBE.DesInvocador) + "," + Environment.NewLine +
"COD_REGISTRO_N = " + Convert.ToString(pCatSrvBE.CodRegistroN) + "," + Environment.NewLine +
"COD_ESTADO_N = " + Convert.ToString(pCatSrvBE.CodEstadoN) + "," + Environment.NewLine +
"IND_LOGUEO = " + Convert.ToString(pCatSrvBE.IndLogueo) + "," + Environment.NewLine +
"IND_PUBLICO = " + Convert.ToString(pCatSrvBE.IndPublico) + "," + Environment.NewLine +
"DES_ESQUEMA = " + MyStringUtils.entreComas(pCatSrvBE.DesEsquema) + Environment.NewLine +
"WHERE COD_SERVICIO_N = " + Convert.ToString(pCatSrvBE.CodServicioN);
using (DbConnection connection = database.CreateOpenConnection())
{
using (DbCommand command = database.CreateCommand(wsql, connection))
{
int numRows = command.ExecuteNonQuery();
}
}
string usuario = Environment.UserName;
bitObjDL.Registrar(3, "GE_AMBCATALOGO", codRegistroN, usuario);
}
private void InitMyComponents()
{
this.catSrvBE = new CatalogoServBE();
this.catSrvBL = new CatalogoServBL();
FillCombos();
txtInd_AtmServV.Text = "E";
txtNumCache.Text = "60";
}
public void GetServiceDataByPk(decimal p, CatalogoServBE catalogoServBE)
{
try
{
this.catServDL.GetServiceDataByPk(p, catalogoServBE);
}
catch (Exception)
{
throw;
}
}
protected override void FrmManteBase_Load(object sender, EventArgs e)
{
base.FrmManteBase_Load(sender, e);
if (this.EstadoForm == FormEstados.ModModif ||
this.EstadoForm == FormEstados.ModBorrar)
{
this.catSrvBL.GetServiceDataByPk(this.catSrvBE.CodServicioN, this.catSrvBE);
BEtoUI();
}
else
{
this.catSrvBE = new CatalogoServBE();
}
}
public void GetServiceDataByPk(decimal p, CatalogoServBE catalogoServBE)
{
string sql = "select a.* " + Environment.NewLine +
"from ge_ambcatalogo a " + Environment.NewLine +
" where a.cod_servicio_n = " + Convert.ToString(p);
try
{
using (DbConnection connection = database.CreateOpenConnection())
{
using (DbCommand command = database.CreateCommand(sql, connection))
{
using (IDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
catalogoServBE.CodServicioN = Convert.ToInt32(reader["COD_SERVICIO_N"]);
catalogoServBE.CodTipretornoN = Convert.ToInt32(reader["COD_TIPRETORNO_N"]);
catalogoServBE.CodObjpropN = Convert.ToInt32(reader["COD_OBJPROP_N"]);
catalogoServBE.CodTipservicioN = Convert.ToInt32(reader["COD_TIPSERVICIO_N"]);
catalogoServBE.CodAccservN = Convert.ToInt32(reader["COD_ACCSERV_N"]);
catalogoServBE.NomServicio = Convert.ToString(reader["NOM_SERVICIO"]);
catalogoServBE.IndAtomservV = Convert.ToString(reader["IND_ATOMSERV_V"]);
catalogoServBE.CodModuloN = Convert.ToInt32(reader["COD_MODULO_N"]);
catalogoServBE.DesServicio = Convert.ToString(reader["DES_SERVICIO"]);
catalogoServBE.NumCache = Convert.ToInt32(reader["NUM_CACHE"]);
catalogoServBE.DesInvocador = Convert.ToString(reader["DES_INVOCADOR"]);
catalogoServBE.CodRegistroN = Convert.ToDecimal(reader["COD_REGISTRO_N"]);
catalogoServBE.CodEstadoN = Convert.ToInt32(reader["COD_ESTADO_N"]);
catalogoServBE.IndLogueo = Convert.ToInt32(reader["IND_LOGUEO"]);
catalogoServBE.IndPublico = Convert.ToInt32(reader["IND_PUBLICO"]);
catalogoServBE.DesEsquema = Convert.ToString(reader["DES_ESQUEMA"]);
}
}
}
}
}
catch (Exception)
{
throw;
}
}
public void Insertar(CatalogoServBE pCatSrvBE)
{
pCatSrvBE.CodRegistroN = bitObjDL.ObtenerCodRegistro();
string wsql = "Insert into GE_AMBCATALOGO (" + Environment.NewLine +
"COD_SERVICIO_N, COD_TIPRETORNO_N,COD_OBJPROP_N,COD_TIPSERVICIO_N, " + Environment.NewLine +
"COD_ACCSERV_N,NOM_SERVICIO,IND_ATOMSERV_V,COD_MODULO_N, " + Environment.NewLine +
"DES_SERVICIO, NUM_CACHE,DES_INVOCADOR,COD_REGISTRO_N, " + Environment.NewLine +
"COD_ESTADO_N,IND_LOGUEO,IND_PUBLICO,DES_ESQUEMA) " + Environment.NewLine +
"values (" + Environment.NewLine +
pCatSrvBE.CodServicioN.ToString() + ", " + pCatSrvBE.CodTipretornoN.ToString() + ", " +
pCatSrvBE.CodObjpropN.ToString() + ", " + pCatSrvBE.CodTipservicioN.ToString() + ", " +
pCatSrvBE.CodAccservN.ToString() + ", " + MyStringUtils.entreComas(pCatSrvBE.NomServicio) + ", " +
MyStringUtils.entreComas(pCatSrvBE.IndAtomservV) + ", " + pCatSrvBE.CodModuloN.ToString() + ", " +
MyStringUtils.entreComas(pCatSrvBE.DesServicio) + ", " + pCatSrvBE.NumCache.ToString() + ", " +
MyStringUtils.entreComas(pCatSrvBE.DesInvocador) + ", " + pCatSrvBE.CodRegistroN.ToString() +
", " + pCatSrvBE.CodEstadoN.ToString() + ", " + pCatSrvBE.IndLogueo.ToString() + ", " +
pCatSrvBE.IndPublico.ToString() + ", " + "'" + pCatSrvBE.DesEsquema + "')";
using (DbConnection connection = database.CreateOpenConnection())
{
using (DbCommand command = database.CreateCommand(wsql, connection))
{
int numRows = command.ExecuteNonQuery();
}
}
/*
* GE_PAMBBITOBJETO.registrar(pcod_accionreg_n => 1,
* pdes_tabla => 'GE_AMBDOCUMENTO',
* pcod_registro_n => wcod_registro,
* pcod_usuario_v => pCOD_USUARIOREG_V);
* */
string usuario = Environment.UserName;
bitObjDL.Registrar(1, "GE_AMBCATALOGO", pCatSrvBE.CodRegistroN, usuario);
}
public List <CatalogoServBE> GetList()
{
string sql = "Select a.* " + Environment.NewLine +
"from Ge_ambcatalogo a " + Environment.NewLine +
"Order by a.cod_servicio_n desc";
List <CatalogoServBE> res = new List <CatalogoServBE>();
using (DbConnection connection = database.CreateOpenConnection())
{
using (DbCommand command = database.CreateCommand(sql, connection))
{
using (IDataReader dr = command.ExecuteReader())
{
while (dr.Read())
{
CatalogoServBE catSrvBe = new CatalogoServBE();
catSrvBe.CodServicioN = Convert.ToInt32(dr["COD_SERVICIO_N"]);
catSrvBe.CodTipretornoN = Convert.ToInt32(dr["COD_TIPRETORNO_N"]);
catSrvBe.CodObjpropN = Convert.ToInt32(dr["COD_OBJPROP_N"]);
catSrvBe.CodTipservicioN = Convert.ToInt32(dr["COD_TIPSERVICIO_N"]);
catSrvBe.CodAccservN = Convert.ToInt32(dr["COD_ACCSERV_N"]);
catSrvBe.NomServicio = Convert.ToString(dr["NOM_SERVICIO"]);
catSrvBe.IndAtomservV = Convert.ToString(dr["IND_ATOMSERV_V"]);
catSrvBe.CodModuloN = Convert.ToInt32(dr["COD_MODULO_N"]);
catSrvBe.DesServicio = Convert.ToString(dr["DES_SERVICIO"]);
catSrvBe.NumCache = Convert.ToInt32(dr["NUM_CACHE"]);
catSrvBe.DesInvocador = null;
catSrvBe.CodRegistroN = Convert.ToDecimal(dr["COD_REGISTRO_N"]);
catSrvBe.CodEstadoN = Convert.ToInt32(dr["COD_ESTADO_N"]);
catSrvBe.IndLogueo = Convert.ToInt32(dr["IND_LOGUEO"]);
catSrvBe.IndPublico = Convert.ToInt32(dr["IND_PUBLICO"]);
catSrvBe.DesEsquema = null;
res.Add(catSrvBe);
}
}
}
}
return(res);
}
public void Modificar(CatalogoServBE pCatSrvBE)
{
this.catServDL.Modificar(pCatSrvBE);
}
public void Insertar(CatalogoServBE pCatSrvBE)
{
this.catServDL.Insertar(pCatSrvBE);
}
