//Ya no se utiliza este método
public errorCompositeType UpdatePartListExchangeCost(PartListExchangeCompositeType plect)
{
var lstError = new errorCompositeType();
try
{
param = new SqlParameter[4];
param[0] = new SqlParameter("@fiid_part_list", SqlDbType.Int)
{
Value = plect.iIdPartList
};
param[1] = new SqlParameter("@fiid_affectation_type", SqlDbType.Int)
{
Value = plect.iIdAffectation
};
param[2] = new SqlParameter("@fiid_Exchange", SqlDbType.Int)
{
Value = plect.iIdExchange
};
objDB.ExecStore("sp_updatePartListExchangeCost", param);
lstError.bError = true;
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public int getSUMPartListExchangeComponents(PartListExchangeCompositeType plect)
{
param = new SqlParameter[2];
param[0] = new SqlParameter("@fiid_part_list", SqlDbType.Int)
{
Value = plect.iIdPartList
};
param[1] = new SqlParameter("@fiid_Exchange", SqlDbType.Int)
{
Value = plect.iIdExchange
};
return((int)objDB.ExecStore("sp_SelectSumPartListExchangeCost", param).Rows[0].ItemArray[0]);
}
public int getIdExchangePartListByAll(PartListExchangeCompositeType plect)
{
param = new SqlParameter[4];
param[0] = new SqlParameter("@fiid_part_list", SqlDbType.Int)
{
Value = plect.iIdPartList
};
param[1] = new SqlParameter("@fiid_affectation_type", SqlDbType.Int)
{
Value = plect.iIdAffectation
};
param[2] = new SqlParameter("@fiid_exchange", SqlDbType.Int)
{
Value = plect.iIdExchange
};
return((int)objDB.ExecStore("sp_getIdExchangePartListByAll", param).Rows[0].ItemArray[0]);
}
public PartListExchangeCompositeType getPartListExchange(int iIdListPartExchange)
{
param = new SqlParameter[1];
param[0] = new SqlParameter("@fiid_Exchange_part_list", SqlDbType.Int)
{
Value = iIdListPartExchange
};
DataTable dt = objDB.ExecStore("sp_SelectPartListExchangeByIdExPl", param);
var et = new PartListExchangeCompositeType
{
iIdPartListExchange = (int)dt.Rows[0].ItemArray[0],
iIdPartList = (int)dt.Rows[0].ItemArray[1],
iIdAffectation = (int)dt.Rows[0].ItemArray[2],
iIdExchange = (int)dt.Rows[0].ItemArray[3],
sPartListDS = dt.Rows[0].ItemArray[4].ToString(),
sPartListDescription = dt.Rows[0].ItemArray[5].ToString(),
sPartListClient = dt.Rows[0].ItemArray[6].ToString(),
sAffectationDescription = dt.Rows[0].ItemArray[7].ToString(),
sFolio = dt.Rows[0].ItemArray[8].ToString(),
sPreFolio = dt.Rows[0].ItemArray[9].ToString()
};
return(et);
}
