internal int CountByUsuario(Int32 t314_idusuario)
{
try
{
SqlParameter[] dbparams = new SqlParameter[1] {
Param(enumDBFields.t314_idusuario, t314_idusuario)
};
return((int)cDblib.Execute("SUP_USUARIOAVISOS_CountByT314_idusuario", dbparams));
}
catch (Exception ex)
{
throw ex;
}
}
public static void graba(string app, string proxy, string hostName, List <logrow> lst)
{
//abrir conexion
IB.sqldblib.SqlServerSP cDblib = null;
try
{
cDblib = new IB.sqldblib.SqlServerSP(GetConStr());
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("netTime", typeof(int)));
dt.Columns.Add(new DataColumn("openConnection", typeof(int)));
dt.Columns.Add(new DataColumn("executeSP", typeof(int)));
dt.Columns.Add(new DataColumn("totalTime", typeof(int)));
dt.Columns.Add(new DataColumn("errorText", typeof(string)));
foreach (logrow o in lst)
{
DataRow row = dt.NewRow();
row["netTime"] = o.netTime;
row["openConnection"] = o.openConnection;
row["executeSP"] = o.executeSP;
row["totalTime"] = o.totalTime;
row["errorText"] = o.errorText;
dt.Rows.Add(row);
}
//ejecutar sp
SqlParameter[] dbparams = new SqlParameter[4] {
Param(cDblib, enumDBFields.app, app),
Param(cDblib, enumDBFields.proxy, proxy),
Param(cDblib, enumDBFields.hostName, hostName),
Param(cDblib, enumDBFields.tabRows, dt)
};
cDblib.Execute("ZZJAVIPROC_GRABALOG_APP", dbparams);
//cerrar conexion
cDblib.Dispose();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (cDblib != null)
{
cDblib.Dispose();
}
}
}