public List <BELinea> fnListaLineaDA(BELinea objELLinea)
{
List <BELinea> objListaAct = new List <BELinea>();
try
{
cmdSQL.Connection = NewConnection(ConfigurationManager.AppSettings[objELLinea.DBConexion]);
cmdSQL.Connection = NewConnection(strCon);
cmdSQL.CommandType = CommandType.StoredProcedure;
cmdSQL.Parameters.Clear();
cmdSQL.CommandText = "USP_SAR_SEL_ListaLinea_Filter";
pAddParameter(cmdSQL, "@nLinId", objELLinea.pnLinId == 0 ? 0 : objELLinea.pnLinId, DbType.Int32);
pAddParameter(cmdSQL, "@nMatId", objELLinea.pnMatId == 0 ? 0 : objELLinea.pnMatId, DbType.Int32);
pAddParameter(cmdSQL, "@nLinActivo", objELLinea.pnLinActivo == 0 ? 0 : objELLinea.pnLinActivo, DbType.Int32);
pAddParameter(cmdSQL, "@cOpcion", objELLinea.pcOpcion == "" ? "00" : objELLinea.pcOpcion, DbType.String);
pAddParameter(cmdSQL, "@nPageNumber", objELLinea.PageNumber == 0 ? 0 : objELLinea.PageNumber, DbType.Int32);
pAddParameter(cmdSQL, "@nPageZize", objELLinea.PageSize == 0 ? 0 : objELLinea.PageSize, DbType.Int32);
SqlDataReader drSQL = fLeer(cmdSQL);
objListaAct = (List <BELinea>)ConvertirDataReaderALista <BELinea>(drSQL);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
if (cmdSQL.Connection.State == ConnectionState.Open)
{
cmdSQL.Connection.Close();
}
}
return(objListaAct);
}
public string fnMantenimientoLineaDA(BELinea objELLinea)
{
String sRes = "";
try
{
cmdSQL.Connection = NewConnection(ConfigurationManager.AppSettings[objELLinea.DBConexion]);
//cmdSQL.Connection = NewConnection(strCon);
cmdSQL.CommandText = "USP_SAR_MNT_Linea";
cmdSQL.CommandType = CommandType.StoredProcedure;
cmdSQL.Parameters.Clear();
pAddParameter(cmdSQL, "@nLinId", objELLinea.pnLinId == 0 ? 0 : objELLinea.pnLinId, DbType.Int32);
pAddParameter(cmdSQL, "@nMatId", objELLinea.pnMatId == 0 ? 0 : objELLinea.pnMatId, DbType.Int32);
pAddParameter(cmdSQL, "@cLinFecVigIni", objELLinea.pcLinFecVigIni == "" ? "" : objELLinea.pcLinFecVigIni, DbType.String);
pAddParameter(cmdSQL, "@cLinFecVigFin", objELLinea.pcLinFecVigFin == "" ? "" : objELLinea.pcLinFecVigFin, DbType.String);
pAddParameter(cmdSQL, "@nLinActivo", objELLinea.pnLinActivo == 0 ? 0 : objELLinea.pnLinActivo, DbType.Int32);
pAddParameter(cmdSQL, "@cOpcion", objELLinea.pcOpcion == "" ? "00" : objELLinea.pcOpcion, DbType.String);
sRes = fEjecutar(cmdSQL);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
if (cmdSQL.Connection.State == ConnectionState.Open)
{
cmdSQL.Connection.Close();
}
}
return(sRes);
}
public string fn_INS_Linea(BELinea Request)
{
string Respuesta = "";
try
{
Respuesta = LineaBL.fnINSMantenimientoLineaBL(Request);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
return(Respuesta);
}
public string fn_UPD_MatrizEsfuerzo(BEMatrizEsfuerzo objMat)
{
string rpta = "";
string Respuesta = "";
try
{
BEMatrizEsfuerzo objEsf = new BEMatrizEsfuerzo();
objEsf.pnMatId = objMat.pnMatId;
objEsf.pnLenId = objMat.pnLenId;
objEsf.pnWorId = objMat.pnWorId;
objEsf.pcMatNombre = objMat.pcMatNombre;
objEsf.pcMatEliminado = objMat.pcMatEliminado;
objEsf.pcOpcion = "02";
objEsf.pnSisId = 3;
objEsf.DBConexion = objMat.DBConexion;
objEsf.pnLinCantidad = objMat.pnLinCantidad;
rpta = new BLMatrizEsfuerzo().fnUPDMatrizEsfuerzoBL(objEsf);
if (rpta.Length > 0)
{
BELinea objLin = new BELinea();
objLin.pnLinId = objMat.pnLinCantidad;
objLin.pnMatId = objMat.pnMatId;
objLin.pcLinFecVigIni = objMat.pcLinFecVigIni;
objLin.pcLinFecVigFin = objMat.pcLinFecVigFin;
objLin.pnLinActivo = 0;
objLin.pcOpcion = objMat.pcOpcion;
objLin.DBConexion = objMat.DBConexion;
Respuesta = new BLLinea().fnINSMantenimientoLineaBL(objLin);
}
}
catch (Exception ex)
{
var st = new StackTrace(ex, true);
var frame = st.GetFrame(0);
var line = frame.GetFileLineNumber();
throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex.Message + "; line:" + frame.ToString()));
}
return(Respuesta);
}
public List <BELinea> LIST_Linea(int pnMatId, int pnLinId, int pnLinActivo, string pcOpcion, string DBConexion)
{
BELinea objBELin = new BELinea();
List <BELinea> lstLin = new List <BELinea>();
try
{
objBELin.pnMatId = pnMatId;
objBELin.pnLinId = pnLinId;
objBELin.pnLinActivo = pnLinActivo;
objBELin.pcOpcion = pcOpcion;
objBELin.DBConexion = DBConexion;
lstLin = LineaBL.fnListaLineaBL(objBELin);
}
catch (Exception ex)
{
var st = new StackTrace(ex, true);
var frame = st.GetFrame(0);
var line = frame.GetFileLineNumber();
throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex.Message + "; line:" + frame.ToString()));
}
return(lstLin);
}
public string fnINSMantenimientoLineaBL(BELinea Request)
{
return(objDA.fnMantenimientoLineaDA(Request));
}
public List <BELinea> fnListaLineaBL(BELinea Request)
{
return(objDA.fnListaLineaDA(Request));
}
