public BE_Aux GetSystemDate()
{
BE_Aux _aux = new BE_Aux();
_aux.date = DateTime.Now.ToShortDateString();
return(_aux);
}
public BE_Aux GetSystemDate()
{
BE_Aux _aux = new BE_Aux();
_aux.date = DateTime.Now.ToString(BE.n.util.CustomeDateFormat());
return(_aux);
}
public List <BE_Aux> listar(string codEmp)
{
List <BE_Aux> vResultado = new List <BE_Aux>();
BE_Aux oEntidad = null;
SqlDataReader oSqlDataReader = null;
SqlConnection pSql_Connection = new DA_Connection().connection_Sysmacon();
using (SqlCommand oSqlCommand = new SqlCommand("SP_TGAUX_LISTAR", pSql_Connection))
{
try
{
oSqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
oSqlCommand.Parameters.Clear();
oSqlCommand.Parameters.Add(new SqlParameter("@PI_COD_EMP", (codEmp == string.Empty ? (object)DBNull.Value : codEmp)));
pSql_Connection.Open();
oSqlDataReader = oSqlCommand.ExecuteReader();
while (oSqlDataReader.Read())
{
oEntidad = new BE_Aux();
oEntidad.codemp = Convert.ToString(oSqlDataReader["codemp"]);
oEntidad.codaux = Convert.ToString(oSqlDataReader["codaux"]);
oEntidad.razaux = Convert.ToString(oSqlDataReader["razaux"]);
oEntidad.rucaux = Convert.ToString(oSqlDataReader["rucaux"]);
vResultado.Add(oEntidad);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (pSql_Connection != null)
{
pSql_Connection.Close();
}
if (oSqlCommand != null)
{
oSqlCommand.Dispose();
}
}
}
return(vResultado);
}
