public List <DDLOptionsText> Lista_Entregable()
{
var lstParametro = new List <DDLOptionsText>();
var oDatabase = DatabaseFactory.CreateDatabase();
var oDbCommand = oDatabase.GetStoredProcCommand("up_Base_Sellst_Entregable");
using (var oReader = oDatabase.ExecuteReader(oDbCommand))
{
while (oReader.Read())
{
var oParametro = new DDLOptionsText
{
S_ID = DataConvert.ToString(oReader["S_ID"]),
S_Descripcion = DataConvert.ToString(oReader["S_Descripcion"])
};
lstParametro.Add(oParametro);
}
oReader.Close();
}
return(lstParametro);
}
public List <DDLOptionsText> ListarCargo(int N_IDUnidad)
{
var lstParametro = new List <DDLOptionsText>();
var oDatabase = DatabaseFactory.CreateDatabase();
var oDbCommand = oDatabase.GetStoredProcCommand("up_Usuario_Sellst_Cargo");
oDatabase.AddInParameter(oDbCommand, "@N_IDUnidad", DbType.Int32, N_IDUnidad);
using (var oReader = oDatabase.ExecuteReader(oDbCommand))
{
while (oReader.Read())
{
var oParametro = new DDLOptionsText
{
S_ID = DataConvert.ToString(oReader["N_IDParametro"]),
S_Descripcion = DataConvert.ToString(oReader["S_Descripcion"])
};
lstParametro.Add(oParametro);
}
oReader.Close();
}
return(lstParametro);
}
public List <DDLOptionsText> Lista_ParametroCombo(string sTabla, int IDUserUnidad)
{
var lstParametro = new List <DDLOptionsText>();
var oDatabase = DatabaseFactory.CreateDatabase();
var oDbCommand = oDatabase.GetStoredProcCommand("up_ParametroGeneral_Sellst_Parametro");
oDatabase.AddInParameter(oDbCommand, "@S_Tabla", DbType.String, sTabla);
oDatabase.AddInParameter(oDbCommand, "@IDUserUnidad", DbType.String, IDUserUnidad);
using (var oReader = oDatabase.ExecuteReader(oDbCommand))
{
while (oReader.Read())
{
var oParametro = new DDLOptionsText
{
S_ID = DataConvert.ToString(oReader["S_ID"]),
S_Descripcion = DataConvert.ToString(oReader["S_Descripcion"])
};
lstParametro.Add(oParametro);
}
oReader.Close();
}
return(lstParametro);
}
