private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_tticol080 parametros, bool blnUsarPRetorno = false) { string param = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ORNO", DbType.String, parametros.orno); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PONO", DbType.String, parametros.pono); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ITEM", DbType.String, " " + parametros.item.Trim().ToUpperInvariant()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWAR", DbType.String, parametros.cwar); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QUNE", DbType.Decimal, Convert.ToDecimal(parametros.qune).ToString("#.##0,0000")); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.logn); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PROC", DbType.String, parametros.proc); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.String, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.String, parametros.refcntu); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CLOT", DbType.String, parametros.clot); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PICK", DbType.String, parametros.pick); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$OORG", DbType.String, parametros.oorg); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { throw (ex); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_ttccol300 parametros, bool blnUsarPRetorno = false) { method = MethodBase.GetCurrentMethod(); string strError = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$USER", DbType.String, parametros.user); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$NAMA", DbType.String, parametros.nama); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PASS", DbType.String, parametros.pass); //Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$UFIN", DbType.String, parametros.ufin); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ROLE", DbType.Int32, parametros.refcntu); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$SHIF", DbType.Int32, parametros.refcntu); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { strError = "Error when creating parameters [301]. Try again or contact your administrator \n"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_ttwhcol016 parametros, bool blnUsarPRetorno = false) { string strError = string.Empty; string param = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ZONE", DbType.String, parametros.zone); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LABL", DbType.String, parametros.labl); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ITEM", DbType.String, parametros.item); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWAR", DbType.String, parametros.cwar); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CLOT", DbType.String, parametros.clot); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTYR", DbType.Decimal, Convert.ToDecimal(parametros.qtyr).ToString("#.##0,0000")); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.logn); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { log.escribirError(strError + Console.Out.NewLine + ex.Message, method.Module.Name, method.Name, method.ReflectedType.Name); throw (ex); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_tticol132 parametros, bool blnUsarPRetorno = false) { method = MethodBase.GetCurrentMethod(); string strError = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$BCDE", DbType.String, parametros.barcode); //Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$DATE", DbType.DateTime, parametros.date.ToString("dd/MM/yyyy HH:mm:ss")); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$TYPE", DbType.Int64, parametros.type); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$ITEM", DbType.String, parametros.item); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$USER", DbType.String, parametros.user); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$STAT", DbType.Int64, parametros.status); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$MCNO", DbType.String, parametros.machine); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$REFCNTD", DbType.Int64, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$REFCNTU", DbType.Int64, parametros.refcntu); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { strError = "Error when creating parameters [135]. Try again or contact your administrator \n"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunesUpdate(Ent_tticol127 parametros, bool blnUsarPRetorno = false) { string param = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$USER", DbType.String, parametros.user); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWAR", DbType.String, parametros.cwar); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { log.escribirError(ex.Message, stackTrace.GetFrame(2).GetMethod().Name, metodo, method.ReflectedType.Name); // throw (ex); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_tticol030 parametros, bool blnUsarPRetorno = false) { string param = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PDNO", DbType.String, parametros.pdno); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$SQNB", DbType.String, parametros.sqnb); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MITM", DbType.String, parametros.mitm); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DSCA", DbType.String, parametros.dsca); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWAR", DbType.String, parametros.cwar); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOCA", DbType.String, parametros.loca); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTDL", DbType.Decimal, Convert.ToDecimal(parametros.qtdl).ToString("#.##0,0000")); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CUNI", DbType.String, parametros.cuni); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MESS", DbType.String, parametros.mess); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$USER", DbType.String, parametros.user); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.String, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.String, parametros.refcntu); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { throw (ex); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_twhcol018 parametros, bool blnUsarPRetorno = false) { method = MethodBase.GetCurrentMethod(); string strError = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$TGID", DbType.String, parametros.tgid); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$ITEM", DbType.String, parametros.item); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CLOT", DbType.String, parametros.clot); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$QTDL", DbType.Decimal, Convert.ToDecimal(System.Math.Abs(parametros.qtdl)).ToString("#.##0,0000")); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CUNI", DbType.String, parametros.cuni); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { strError = "Error when creating parameters [twhcol018]. Try again or contact your administrator \n"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_ttdcol137 parametros, bool blnUsarPRetorno = false) { method = MethodBase.GetCurrentMethod(); string strError = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PAID", DbType.String, parametros.Paid); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ORNO", DbType.String, parametros.Orno); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CLOT", DbType.String, parametros.Clot); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWAR", DbType.String, parametros.Cwar); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOCA", DbType.String, parametros.Loca); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTYA", DbType.String, parametros.Qtya); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$USER", DbType.String, parametros.User); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int64, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int64, parametros.refcntu); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { strError = "Error when creating parameters [137]. Try again or contact your administrator \n"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_tticol025 parametros, bool blnUsarPRetorno = false) { method = MethodBase.GetCurrentMethod(); string strError = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PDNO", DbType.String, parametros.pdno); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$SQNB", DbType.Int32, parametros.sqnb); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MITM", DbType.String, parametros.mitm); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DSCA", DbType.String, parametros.dsca); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTDL", DbType.Decimal, Convert.ToDecimal(parametros.qtdl)); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CUNI", DbType.String, parametros.cuni); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MESS", DbType.String, parametros.mess); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$USER", DbType.String, parametros.user); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { strError = "Error when creating parameters [301]. Try again or contact your administrator \n"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_tticol022 parametros, bool blnUsarPRetorno = false) { method = MethodBase.GetCurrentMethod(); string strError = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PDNO", DbType.String, parametros.pdno); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$SQNB", DbType.String, parametros.sqnb); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PROC", DbType.Int32, parametros.proc); //if (!string.IsNullOrEmpty(parametros.logn.Trim())) Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.logn); //Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DATE", DbType.String, parametros.date); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MITM", DbType.String, " " + parametros.mitm); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTDL", DbType.Decimal, Convert.ToDecimal(parametros.qtdl).ToString("#.##0,0000")); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CUNI", DbType.String, parametros.cuni); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOG1", DbType.String, parametros.log1); //Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DATC", DbType.String, parametros.datc); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTD1", DbType.Int32, parametros.qtd1); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PRO1", DbType.Int32, parametros.pro1); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOG2", DbType.String, parametros.log2); //Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DATU", DbType.String, parametros.datu); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTD2", DbType.Int32, parametros.qtd2); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PRO2", DbType.Int32, parametros.pro2); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOCA", DbType.String, parametros.loca); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$NORP", DbType.Int32, parametros.norp); //Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DLRP", DbType.String, parametros.dlrp); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DELE", DbType.Int32, parametros.dele); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGD", DbType.String, parametros.logd); //Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DATD", DbType.String, parametros.datd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu); //Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$URPT", DbType.String, parametros.refcntu); //Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ACQT", DbType.Double, parametros.refcntu); //Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWAF", DbType.String, parametros.refcntu); //Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWAT", DbType.String, parametros.refcntu); //Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ACLO", DbType.String, parametros.refcntu); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { strError = "Error when creating parameters [022]. Try again or contact your administrator \n"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_twhcol025 parametros, bool blnUsarPRetorno = false) { method = MethodBase.GetCurrentMethod(); string strError = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { //T$PAID, T$ITEM, T$LOCA, T$CLOT, T$QTYA, T$UNIT, T$DATE, T$LOGN, T$EMNO, T$PROC, T$REFCNTD,T$REFCNTU ////obj.PAID = txtPalletId.Text.ToUpperInvariant(); ////obj.ITEM = lblItemValue.Text.Trim().ToUpper(); ////obj.LOCA = lblLocationValue.Text.Trim().ToUpper(); ////obj.CLOT = lblLot.Text.Trim().ToUpper(); ////obj.QTYA = Convert.ToInt32(txtAdjustmentQuantity.Text.Trim()); ////obj.UNIT = lblUnitValue.Text.Trim().ToUpper(); ////obj.DATE = lblUnitValue.Text.Trim().ToUpper(); ////obj.CDIS = dropDownCostCenters.SelectedItem.Value; ////obj.EMNO = dropDownReasonCodes.SelectedItem.Value; ////obj.PROC = 0; ////obj.REFCNTD = 0; ////obj.REFCNTU = 0; ////T$PAID, T$ITEM, T$LOCA, T$CLOT, T$QTYA, T$UNIT, T$DATE, T$LOGN,T$CDIS, T$EMNO, T$PROC, T$REFCNTD,T$REFCNTU Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PAID", DbType.String, parametros.PAID); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ITEM", DbType.String, parametros.ITEM.Trim()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOCA", DbType.String, parametros.LOCA); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CLOT", DbType.String, parametros.CLOT); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTYA", DbType.Double, parametros.QTYA); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$UNIT", DbType.String, parametros.UNIT); //Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DATE", DbType.String, parametros.DATE); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DATE", DbType.String, parametros.DATE); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.LOGN); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CDIS", DbType.String, parametros.CDIS); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$EMNO", DbType.String, parametros.EMNO); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PROC", DbType.Int32, parametros.PROC); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWAR", DbType.String, parametros.CWAR); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ORNO", DbType.String, parametros.ORNO); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PONO", DbType.Int32, parametros.PONO); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MESS", DbType.String, parametros.MESS); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.REFCNTD); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.REFCNTU); } catch (Exception ex) { strError = "Error when creating parameters [125]. Try again or contact your administrator \n"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_ttscol101 parametros, bool blnUsarPRetorno = false) { method = MethodBase.GetCurrentMethod(); string strError = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ORNO", DbType.String, parametros.orno.ToUpperInvariant()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ITEM", DbType.String, parametros.item.Trim().ToUpperInvariant()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOCA", DbType.String, parametros.loca); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWAR", DbType.String, parametros.cwar.ToUpperInvariant()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QDEL", DbType.Decimal, Convert.ToDecimal(parametros.qdel).ToString("#.##0,0000")); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CDAT", DbType.String, parametros.cdat); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MESS", DbType.String, parametros.mess); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu); if (!string.IsNullOrEmpty(parametros.logn)) { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.logn); } if (!string.IsNullOrEmpty(parametros.cusr)) { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CUSR", DbType.String, parametros.cusr); } if (parametros.conf > 0) { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CONF", DbType.Int32, parametros.conf); } if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { strError = "Error when creating parameters [scol101]. Try again or contact your administrator \n"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_tticol125 parametros, bool blnUsarPRetorno = false) { method = MethodBase.GetCurrentMethod(); string strError = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PDNO", DbType.String, parametros.pdno); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PONO", DbType.Int32, parametros.pono); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ITEM", DbType.String, " " + parametros.item.Trim()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWAR", DbType.String, parametros.cwar); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CLOT", DbType.String, parametros.clot); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REQT", DbType.Decimal, Convert.ToDecimal(parametros.reqt).ToString("#.##0,0000")); //DbType.Int32, parametros.reqt); if (!string.IsNullOrEmpty(parametros.user)) { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$USER", DbType.String, parametros.user); } if (parametros.prin > 0) { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PRIN", DbType.Int32, parametros.prin); } Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CONF", DbType.Int32, parametros.conf); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.String, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.String, parametros.refcntu); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MESS", DbType.String, parametros.mess); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PAID", DbType.String, parametros.paid); //if (!string.IsNullOrEmpty(parametros.idrecord)) // Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":ROWID", DbType.String, parametros.idrecord); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { strError = "Error when creating parameters [125]. Try again or contact your administrator \n"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_twhcol080 parametros, bool blnUsarPRetorno = false) { method = MethodBase.GetCurrentMethod(); string strError = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$SOUR", DbType.Int32, parametros.sour); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ORNO", DbType.String, parametros.orno); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CONJ", DbType.Int32, parametros.conj); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PONO", DbType.Int32, parametros.pono); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$SQNB", DbType.Int32, parametros.sqnb); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$SERN", DbType.Int32, parametros.sern); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$RCNO", DbType.String, parametros.rcno); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWAR", DbType.String, parametros.cwar); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOCA", DbType.String, parametros.loca); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ITEM", DbType.String, parametros.item); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QANA", DbType.Double, parametros.qana); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CUNI", DbType.String, parametros.cuni); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CLOT", DbType.String, parametros.clot == null ? " " : parametros.clot.Trim().ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.logn); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$HABL", DbType.Double, parametros.habl); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ESTI", DbType.Int32, parametros.esti); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DIFE", DbType.Int32, parametros.dife); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PROC", DbType.Int32, parametros.proc); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CONF", DbType.Int32, parametros.conf); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ORIG", DbType.Int32, parametros.orig); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { strError = "Error when creating parameters [301]. Try again or contact your administrator \n"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_tticol100 parametros, bool blnUsarPRetorno = false) { method = MethodBase.GetCurrentMethod(); string strError = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PDNO", DbType.String, parametros.pdno.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PONO", DbType.Int32, parametros.pono); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$SEQN", DbType.Int32, parametros.seqn); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MCNO", DbType.String, parametros.mcno.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$SHIF", DbType.String, parametros.shif.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ITEM", DbType.String, parametros.item.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTYR", DbType.Double, parametros.qtyr); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CDIS", DbType.String, parametros.cdis.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REJT", DbType.Int32, parametros.rejt); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CLOT", DbType.String, parametros.clot.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$OBSE", DbType.String, parametros.obse.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGR", DbType.String, parametros.logr.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DISP", DbType.Int32, parametros.disp); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.logn.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PROC", DbType.Int32, parametros.proc); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MESS", DbType.String, parametros.mess.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PAID", DbType.String, parametros.paid.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWAR", DbType.String, parametros.cwar.ToUpper()); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { strError = "Error when creating parameters [301]. Try again or contact your administrator \n"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_tticol118 parametros, bool blnUsarPRetorno = false) { string param = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ITEM", DbType.String, parametros.item); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWAR", DbType.String, parametros.cwar); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CLOT", DbType.String, parametros.clot); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTYR", DbType.Double, parametros.qtyr); //Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DQTYR", DbType.Decimal, parametros.dqtyr); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CDIS", DbType.String, parametros.cdis); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$OBSE", DbType.String, parametros.obse); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGR", DbType.String, parametros.logr); //Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DATR", DbType.String, parametros.datr); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DISP", DbType.Int32, parametros.disp); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$STOC", DbType.String, parametros.stoc); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$RITM", DbType.String, parametros.ritm); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PROC", DbType.Int32, parametros.proc); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MESS", DbType.String, parametros.mess); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$SUNO", DbType.String, parametros.suno); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PAID", DbType.String, parametros.paid); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PLLD", DbType.String, parametros.plld); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { log.escribirError(ex.Message, stackTrace.GetFrame(2).GetMethod().Name, metodo, method.ReflectedType.Name); throw (ex); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_twhcol072 parametros, bool blnUsarPRetorno = false) { string param = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$SOUR", DbType.String, parametros.sour); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ORNO", DbType.String, parametros.orno); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PONO", DbType.String, parametros.pono); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DWMS", DbType.String, parametros.dwms); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PWMS", DbType.String, parametros.pwms); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWAR", DbType.String, parametros.cwar); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ITEM", DbType.String, parametros.item); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QANA", DbType.Decimal, Convert.ToDecimal(parametros.qana).ToString("#.##0,0000")); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CUNI", DbType.String, parametros.cuni); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CLOT", DbType.String, parametros.clot); //Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$INDT", DbType.String, parametros.indt); //Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PRDT", DbType.String, parametros.prdt); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PROC", DbType.String, parametros.proc); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$RCNO", DbType.String, parametros.rcno); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$RWMS", DbType.String, parametros.rwms); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.logn); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ERRO", DbType.String, parametros.erro); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$SEQN", DbType.String, parametros.seqn); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.String, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.String, parametros.refcntu); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { throw (ex); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_tticol042 parametros, bool blnUsarPRetorno = false) { string param = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PDNO", DbType.String, parametros.pdno); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$SQNB", DbType.String, parametros.sqnb); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PROC", DbType.String, parametros.proc); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.logn); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MITM", DbType.String, parametros.mitm); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PONO", DbType.String, parametros.pono); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTDL", DbType.Decimal, Convert.ToDecimal(parametros.qtdl).ToString("#.##0,0000")); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CUNI", DbType.String, parametros.cuni); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOG1", DbType.String, parametros.log1); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTD1", DbType.Decimal, Convert.ToDecimal(parametros.qtd1).ToString("#.##0,0000")); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PRO1", DbType.String, parametros.pro1); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOG2", DbType.String, parametros.log2); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTD2", DbType.Decimal, Convert.ToDecimal(parametros.qtd2).ToString("#.##0,0000")); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PRO2", DbType.String, parametros.pro2); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOCA", DbType.String, parametros.loca); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$NORP", DbType.String, parametros.norp); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DELE", DbType.String, parametros.dele); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGD", DbType.String, parametros.logd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.String, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.String, parametros.refcntu); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { throw (ex); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_twhcol120 parametros, bool blnUsarPRetorno = false) { method = MethodBase.GetCurrentMethod(); string strError = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$UNID", DbType.String, parametros.unid.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.logn.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$IDTR", DbType.String, parametros.idtr.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$WHSO", DbType.String, parametros.whso.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$WHTA", DbType.String, parametros.whta.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$SHPO", DbType.String, parametros.shpo.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ENPI", DbType.Int32, parametros.enpi); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ENRE", DbType.Int32, parametros.enre); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$RCNO", DbType.String, parametros.rcno.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PRNT", DbType.Int32, parametros.prnt); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PROO", DbType.Int32, parametros.proo); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PROR", DbType.Int32, parametros.pror); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MES1", DbType.String, parametros.mes1); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MES2", DbType.String, parametros.mes2); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { strError = "Error when creating parameters [301]. Try again or contact your administrator \n"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_ttdcol524 parametros, bool blnUsarPRetorno = false) { method = MethodBase.GetCurrentMethod(); string strError = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$ORNO$EAM", DbType.String, parametros.orderNumber); //Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$DATE", DbType.DateTime, parametros.date.ToString("dd/MM/yyyy HH:mm:ss")); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$EMNO", DbType.String, parametros.employee); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$CWAR", DbType.String, parametros.warehouse); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$ITEM", DbType.String, parametros.item); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$VSTK", DbType.Int64, parametros.adjustmentQuantity); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$STUN", DbType.String, parametros.unit); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$RECD", DbType.String, parametros.adjustmentReason); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$ESTA", DbType.Int16, parametros.status); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$ORNO", DbType.String, parametros.adjustmentBaanOrder); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$PONO", DbType.String, parametros.adjustmentBaanOrderLine); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$REFCNTD", DbType.Int64, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$REFCNTU", DbType.Int64, parametros.refcntu); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { strError = "Error when creating parameters [524]. Try again or contact your administrator \n"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_tticol090 parametros, bool blnUsarPRetorno = false) { string param = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$FPDN", DbType.String, parametros.fpdn); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$TPDN", DbType.String, parametros.tpdn); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ITEM", DbType.String, parametros.item); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CLOT", DbType.String, parametros.clot); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$SRNO", DbType.Int32, parametros.srno); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QANA", DbType.Decimal, Convert.ToDecimal(parametros.qana).ToString("#.##0,0000")); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PROC", DbType.Int32, parametros.proc); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu); if (!string.IsNullOrEmpty(parametros.logn)) { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.logn); } if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { log.escribirError(ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); throw (ex); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_twhcol124 parametros, bool blnUsarPRetorno = false) { method = MethodBase.GetCurrentMethod(); string strError = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$UNID", DbType.String, parametros.unid.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.logn.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PAID", DbType.String, parametros.paid.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ITEM", DbType.String, parametros.item.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CLOT", DbType.String, parametros.clot.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTDT", DbType.Double, parametros.qtdt); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PROC", DbType.Int32, parametros.proc); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MES1", DbType.String, parametros.mes1); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOCA", DbType.String, parametros.loca.ToUpper()); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOCS", DbType.Int32, parametros.locs); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { strError = "Error when creating parameters [301]. Try again or contact your administrator \n"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_tticol074 parametros, bool blnUsarPRetorno = false) { method = MethodBase.GetCurrentMethod(); string strError = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CHEC", DbType.Int32, parametros.chequeado); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$COMM", DbType.String, parametros.comentario); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWTT", DbType.String, parametros.tarifaHoraria); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DATE", DbType.String, parametros.fecha.ToString("dd/MM/yyyy HH:mm:ss")); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$HREA", DbType.Decimal, parametros.horas); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.usuario); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MESS", DbType.String, parametros.mensaje); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$OPNO", DbType.Int32, parametros.numOperacion); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PDNO", DbType.String, parametros.orden); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PROC", DbType.Int32, parametros.procesado); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { strError = "Error when creating parameters [074]. Try again or contact your administrator \n"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_tticol085 parametros, bool blnUsarPRetorno = false) { method = MethodBase.GetCurrentMethod(); string strError = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MCNO", DbType.String, parametros.mcno); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$TYPE", DbType.Int32, parametros.type); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$TANO", DbType.Int32, parametros.tano); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWTT", DbType.String, parametros.cwtt); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$HREA", DbType.Double, parametros.hrea); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$COMM", DbType.String, parametros.comm); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.logn); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PROC", DbType.Int32, parametros.proc); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CHEC", DbType.Int32, parametros.chec); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MESS", DbType.String, parametros.mess); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { strError = "Error when creating parameters [301]. Try again or contact your administrator \n"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(parameterCollection); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_ttwhcol017 parametros, bool blnUsarPRetorno = false) { string param = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$LABL", DbType.String, parametros.labl); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$SQNB", DbType.Int32, parametros.sqnb); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$CWAR", DbType.String, parametros.cwar); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$ITEM", DbType.String, parametros.item); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$CLOT", DbType.String, parametros.clot); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$QTDL", DbType.Decimal, Convert.ToDecimal(parametros.qtdl).ToString("#.##0,0000")); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$CUNI", DbType.String, parametros.cuni); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$LOGN", DbType.String, parametros.logn); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$COUN", DbType.Int32, parametros.coun); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$PROC", DbType.Int32, parametros.proc); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$REFCNTD", DbType.Int32, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$REFCNTU", DbType.Int32, parametros.refcntu); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$ZONE", DbType.String, parametros.zone); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { throw (ex); } return(parameterCollection); }