public ObservableCollection <Liquidation_Hdr> getViewGuiaforAdd(int idAgencia, String varFilterGuia, int varSECUENCIALTRANSPORTISTA) { try { /// DataSet dsLiqHdr = Liquidation_Hdr.getViewGuiaforAddDB(idAgencia, varFilterGuia, varSECUENCIALTRANSPORTISTA); /// if (dsLiqHdr != null) { foreach (DataRow dr in dsLiqHdr.Tables[0].Rows) { /// _LiquidationHdrOC.Add(new Liquidation_Hdr { _pdv_co = dr["IHV_CO"].ToString(), _IHV_INVOICE_NO = dr["IHV_INVOICE_NO"].ToString(), _PREFIJO = Convert.ToInt32(dr["PREFIJO"]), _RangoGuia = dr["rangoGuia"].ToString(), _SECUENCIALTRANSPORTISTA = Convert.ToInt32(dr["SECUENCIALTRANSPORTISTA"]), _nombre = dr["NOMBRE_TRANSPORTISTA"].ToString() }); } } /// return(_LiquidationHdrOC); } catch { return(_LiquidationHdrOC); } }
public ObservableCollection <Liquidation_Hdr> getViewGuiaEdit(int idAgencia, DateTime fecInvoice) { try { /// DataSet dsLiqHdr = Liquidation_Hdr.getViewGuiaEditDB(idAgencia, fecInvoice); /// if (dsLiqHdr != null) { foreach (DataRow dr in dsLiqHdr.Tables[0].Rows) { /// _LiquidationHdrOC.Add(new Liquidation_Hdr { _pdv_co = dr["LHV_CO"].ToString(), _Ag_transporte = dr["TRV_NAME"].ToString(), _SECUENCIALTRANSPORTISTA = Convert.ToInt32(dr["SECUENCIALTRANSPORTISTA"]), _nombre = dr["NOMBRE_TRANSPORTISTA"].ToString(), _cantidad = Convert.ToInt32(dr["CANT_GUIAS"]), _varCheck = 1 }); } } /// return(_LiquidationHdrOC); } catch { return(_LiquidationHdrOC); } }
public ObservableCollection <Liquidation_Hdr> getGuiaSecuencial(int idAgencia, DateTime fecInvoice) { try { /// DataSet dsLiqHdr = Liquidation_Hdr.getGuiaSecuencialDB(idAgencia, fecInvoice); /// if (dsLiqHdr != null) { foreach (DataRow dr in dsLiqHdr.Tables[0].Rows) { /// _LiquidationHdrOC.Add(new Liquidation_Hdr { _pdv_co = dr["IHV_CO"].ToString(), _BDN_ID = Convert.ToInt32(dr["BDN_ID"]), _nombre = dr["nombre"].ToString(), _IHV_INVOICE_NO = dr["IHV_INVOICE_NO"].ToString(), _PREFIJO = Convert.ToInt32(dr["PREFIJO"]), _cantidad = Convert.ToInt32(dr["cantidad"]), _RangoGuia = dr["rangoGuia"].ToString(), _varCheck = 1 }); } } /// return(_LiquidationHdrOC); } catch { return(_LiquidationHdrOC); } }
public ObservableCollection <Liquidation_Hdr> getTransportistaGuia(DateTime fechIni, DateTime fechFin) { try { /// DataSet dsLiqHdr = Liquidation_Hdr.getTransportistaGuiaDB(fechIni, fechFin); /// if (dsLiqHdr != null) { foreach (DataRow dr in dsLiqHdr.Tables[0].Rows) { /// _LiquidationHdrOC.Add(new Liquidation_Hdr { _idAgencia = Convert.ToInt32(dr["IDAGENCIA"]), _AGENCIA_TRANSP = dr["AGENCIA_TRANSP"].ToString(), _CANT_GUIAS = Convert.ToInt32(dr["CANT_GUIAS"]), _fecInvoice = Convert.ToDateTime(dr["fecInvoice"]) }); } } /// return(_LiquidationHdrOC); } catch { return(_LiquidationHdrOC); } }
public ObservableCollection <Liquidation_Hdr> getChooiseEditGuia(int varSECUENCIALTRANSPORTISTA) { try { /// DataSet dsLiqHdr = Liquidation_Hdr.getChooiseEditGuiaDB(varSECUENCIALTRANSPORTISTA); /// if (dsLiqHdr != null) { foreach (DataRow dr in dsLiqHdr.Tables[0].Rows) { /// _LiquidationHdrOC.Add(new Liquidation_Hdr { _pdv_co = dr["IHV_CO"].ToString(), _BDN_ID = Convert.ToInt32(dr["BDN_ID"]), _nombre = dr["nombre"].ToString(), // _LHV_LIQUIDATION_NO = dr["LHV_LIQUIDATION_NO"].ToString(), _IHV_INVOICE_NO = dr["IHV_INVOICE_NO"].ToString(), _PREFIJO = Convert.ToInt32(dr["PREFIJO"]), // _NUMGUIA = Convert.ToInt32(dr["NUMGUIA"]), _cantidad = Convert.ToInt32(dr["cantidad"]), // _NUMCOMPLETO = dr["NUMCOMPLETO"].ToString(), _RangoGuia = dr["rangoGuia"].ToString(), _varCheck = 1 }); } } /// return(_LiquidationHdrOC); } catch { return(_LiquidationHdrOC); } }
/// <summary> /// Actualizar el numero de guia de una liquidacion /// </summary> /// <param name="lhv_co"></param> /// <param name="lhv_liquidation_no"></param> /// <param name="tgn_guide_id"></param> /// <returns></returns> public String updateGuideLiquidation(String lhv_liquidation_no, String tgn_guide_id) { return(Liquidation_Hdr.updateGuideLiquidation(lhv_liquidation_no, tgn_guide_id)); }