//-----------------------
//fecha servidor (global)
//-----------------------
public string Get_FechaServidor(BE_ReqFechaServidor Request)
{
string Item = "";
try
{
clsConection Obj = new clsConection();
string Cadena = Obj.GetConexionString("Naylamp");
using (SqlConnection cn = new SqlConnection(Cadena))
{
cn.Open();
using (SqlCommand cm = new SqlCommand())
{
cm.CommandText = "SET LANGUAGE 'Español' SELECT CONVERT(CHAR(10),GETDATE(),103) FechaServerSQL ";
cm.CommandType = CommandType.Text;
//cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerCodigo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
{
while (dr.Read())
{
Item = dr.GetString(dr.GetOrdinal("FechaServerSQL")).Trim();
}
}
}
}
}
catch (Exception)
{
throw;
}
return Item;
}
//-----------------------
// Obtener Fecha Servidor
//-----------------------
public string Get_FechaServidor(BE_ReqFechaServidor Request)
{
string Item = "";
DA_Sistema Obj = new DA_Sistema();
Item = Obj.Get_FechaServidor(Request);
return Item;
//return Obj.Get_FechaServidor
}
//------------------------------
// Obtener Empresas del Sistema
//------------------------------
public DataTable Get_SysEmpresa(BE_ReqFechaServidor Request)
{
//Recuperando registros
DataTable dt = new DataTable();
DA_Sistema Obj = new DA_Sistema();
return Obj.Get_SysEmpresa(Request);
}
//---------------------------------------------------------
//Obtengo List Empresa del Sistema (90000) -Peridentifica-
//---------------------------------------------------------
public DataTable Get_SysEmpresa(BE_ReqFechaServidor Request)
{
DataTable dt = new DataTable();
try
{
clsConection Obj = new clsConection();
string Cadena = Obj.GetConexionString("Naylamp");
using (SqlConnection cn = new SqlConnection(Cadena))
{
cn.Open();
using (SqlCommand cm = new SqlCommand())
{
cm.CommandText = "[usp_Get_PerSysJuridica]";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cPerCodigo", Request.dFechaServer);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
dt.Load(dr);
}
}
}
catch (Exception)
{
throw;
}
return dt;
}
