//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); }