void cargarDasboard(BEParameters obep) { var obrd = new BRDocument(); var oVentas = obrd.Get_DS_OSCSP_SRCH_OINV(obep); Session["Ventas"] = oVentas; var oProducto = obrd.Get_DS_OSCSP_SRCH_INV1(obep); Session["Producto"] = oProducto; var oOrden = obrd.Get_DS_OSCSP_SRCH_ORDR(obep); Session["Orden"] = oOrden; var oCotizacion = obrd.Get_DS_OSCSP_SRCH_OQUT(obep); Session["Cotizacion"] = oOrden; }
public static List <BEProduct> Get_OneProduct(string socied, string project, string whscode, string cardcode, string pricelist, string itemcode) { var obep = new BEParameters() { Socied = socied, Project = project, CardCode = cardcode, PriceList = Convert.ToInt16(pricelist), WhsCode = whscode, ParValue = itemcode, ColumnIndex = 0, Sw = 1, Kit = false }; var obrd = new BRDocument(); var olst = obrd.Get_OSCSP_OITM(obep); return(olst); }
protected void gdvDepartamento_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); var spl = e.Parameters.Split(':'); if (e.Parameters.Contains("SRCH")) { var obj = new BEParameters() { Socied = obec.Socied, departamento = spl[1], }; var obrd = new BRDocument(); var olst = obrd.GET_DEPARTAMENTOS(obj); Session["drcn"] = olst; gdvDepartamento.DataSource = olst; gdvDepartamento.DataBind(); } }
protected void gdvOinvSearch_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); var obj = new BEParameters() { Socied = obec.Socied, DateIn = (DateTime?)dteDateIn.Value, DateFi = (DateTime?)dteDateFi.Value, NumAtCard = txtNumAtCards.Text, Project = obec.Project, Reserve = "Y" }; var obrd = new BRDocument(); var olst = obrd.Get_OSCSP_SRCH_OINV(obj); Session["oinv"] = olst; gdvOinvSearch.DataSource = olst; gdvOinvSearch.DataBind(); }
protected void gdvClientSearch_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var Detalle = ""; var obec = ((BEParameters)Session["InitPar"]); var obj = new BEParameters(); obj.Socied = obec.Socied; obj.CardCode = txtcode.Text; obj.CardName = txtrason.Text; obj.Project = obec.Project; obj.Id_Dire = txtidir.Text; obj.Contrato = txtcontratobus.Text; var obrd = new BRDocument(); var olst = obrd.DXP_GET_CLIENTE_ESTADO_CUENTA(obj); olst.ForEach(item => { Detalle = ""; var obep2 = new BEParameters() { Socied = obec.Socied, DocNum = Convert.ToInt32(item.DocNum), CardCode = item.CardCode, ObjType = 17 }; var olst2 = obrd.DXP_GETDETALLE_BORRADOR_OV(obep2); olst2.Where(i => i.ActivoC == "Y").ToList().ForEach(item2 => { Detalle += item2.ItemName + ","; }); item.Detalle = Detalle.Substring(0, Detalle.Length - 1); }); Session["cliente"] = olst; gdvClientSearch.DataSource = olst; gdvClientSearch.DataBind(); }
protected void gdvLotes_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); if (e.Parameters.Contains("GETLOTE")) { var spl = e.Parameters.Split(':'); var obj = new BEParameters() { Socied = obec.Socied, ItemCode = spl[1], }; var obrd = new BRDocument(); Session["lote"] = obrd.Get_LotesNumber(obj); } //Session["lote"] = olst; gdvLotes.DataSource = Session["lote"]; gdvLotes.DataBind(); }
protected void gdvPermisos_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); if (e.Parameters.Contains("GET")) { var obj = new BEParameters() { Socied = obec.Socied, Project = obec.Project, UserName = cbbUsuario.Text }; var obrd = new BRDocument(); var olst = obrd.PERMISOS(obj); Session["perm"] = olst.Where(i => i.LOCAL == obec.Project).ToList(); gdvPermisos.DataSource = olst; gdvPermisos.DataBind(); } }
/// <summary> /// Insertar Local /// </summary> /// <param name="obep"></param> /// <param name="permi"></param> public void SET_SP_INSERTAR_LOCAL(BEParameters obep, bool permi) { try { odb = DatabaseFactory.CreateDatabase("ApplicationServices"); ocn = odb.CreateConnection(); if (ocn.State == ConnectionState.Closed) { ocn.Open(); } var ocmd = odb.GetStoredProcCommand("SP_INSERTAR_LOCAL", obep.UserName, obep.Socied, obep.Project, permi); ocmd.CommandTimeout = 2000; var ord = odb.ExecuteNonQuery(ocmd); Dispose(false); } finally { ocn.Close(); } }
protected void gdvTarjeta_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); if (e.Parameters.Contains("GET")) { var obj = new BEParameters() { Socied = obec.Socied, ItemCode = txtProducto.Text, CardCode = txtCliente.Text, SerieMaqr = txtSerie.Text }; var obrd = new BRDocument(); var olst = obrd.DXP_GET_TARJETAEQUIPO(obj); Session["oins"] = olst; gdvTarjeta.DataSource = olst; gdvTarjeta.DataBind(); } }
protected void gdvCards_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); if (e.Parameters.Contains("GET")) { var splv = e.Parameters.Split(':'); var obj = new BEParameters() { Socied = obec.Socied, CardCode = bteCustomer.Text, ItemCode = txtitemCode.Text, }; var obrd = new BRDocument(); var olst = obrd.DXP_GET_CARDS(obj); Session["oitm"] = olst; gdvCards.DataSource = olst; gdvCards.DataBind(); } }
public IDataReader GET_PERMISOS(BEParameters obep) { try { odb = DatabaseFactory.CreateDatabase("ApplicationServices"); ocn = odb.CreateConnection(); if (ocn.State == ConnectionState.Closed) { ocn.Open(); } var ocmd = odb.GetStoredProcCommand("DXP_GET_PERMISOS", obep.UserName, obep.Socied, obep.Project); ocmd.CommandTimeout = 2000; var ord = odb.ExecuteReader(ocmd); Dispose(false); return(ord); } finally { ocn.Close(); } }
protected void gdvCuentassrch_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); if (e.Parameters.Contains("GET")) { var splv = e.Parameters.Split(':'); var obj = new BEParameters() { Socied = obec.Socied, Code = txtCuenta.Text, Currency = cbbDocCur.Value.ToString(), //ItemCode = txtitemCode.Text, }; var obrd = new BRDocument(); var olst = obrd.DXP_GET_CUENTASGENERAL(obj); Session["oact"] = olst; gdvCuentassrch.DataSource = olst; gdvCuentassrch.DataBind(); } }
protected void gdvPR_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); if (e.Parameters.Contains("GET")) { var splv = e.Parameters.Split(':'); var obj = new BEParameters() { Socied = obec.Socied, CardCode = txtCliente.Text, Internal = txtnrodoc.Text, DateIn = Convert.ToDateTime(dteFecha.Text), }; var obrd = new BRDocument(); var olst = obrd.DXP_GET_PAGOR(obj); Session["oscl"] = olst; gdvPR.DataSource = olst; gdvPR.DataBind(); } }
protected void gdvServicio_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); if (e.Parameters.Contains("INIT")) { var spl = e.Parameters.Split(':'); var obep = new BEParameters() { Socied = obec.Socied, DocNum = Convert.ToInt32(spl[1]), CardCode = spl[2], ObjType = 17 }; var obrd = new BRDocument(); var olst = obrd.DXP_GETDETALLE_BORRADOR_OV(obep); Session["drf1"] = olst; gdvServicio.DataSource = Session["drf1"]; gdvServicio.DataBind(); } }
/// <summary> /// LISTA LOS LOCALES /// </summary> /// <param name="obep"></param> /// <returns></returns> public IDataReader Get_SCSP_LSPJ_OPRJ(BEParameters obep) { try { odb = DatabaseFactory.CreateDatabase(obep.Socied); ocn = odb.CreateConnection(); if (ocn.State == ConnectionState.Closed) { ocn.Open(); } var ocmd = odb.GetStoredProcCommand("SCSP_LSPJ_OPRJ", obep.RUC); ocmd.CommandTimeout = 2000; var ord = odb.ExecuteReader(ocmd); Dispose(false); return(ord); } finally { ocn.Close(); } }
/// <summary> /// RETORNA EL CODIGO DE EMPLEADO LOGUEADO /// </summary> /// <param name="obep"></param> /// <returns></returns> public string Get_OSCSP_IDOH(BEParameters obep) { try { odb = DatabaseFactory.CreateDatabase(obep.Socied); ocn = odb.CreateConnection(); if (ocn.State == ConnectionState.Closed) { ocn.Open(); } var ocmd = odb.GetStoredProcCommand("OSCSP_IDOH", obep.UserName); ocmd.CommandTimeout = 2000; var scl = (string)odb.ExecuteScalar(ocmd); Dispose(false); return(scl); } finally { ocn.Close(); } }
/// <summary> /// LISTA LOS LOCALES VALIDADOS POR USUARIO /// </summary> /// <param name="obep"></param> /// <returns></returns> public IDataReader Get_SP_LISTARLOCALVAL(BEParameters obep) { try { odb = DatabaseFactory.CreateDatabase("ApplicationServices"); ocn = odb.CreateConnection(); if (ocn.State == ConnectionState.Closed) { ocn.Open(); } var ocmd = odb.GetStoredProcCommand("SP_LISTVAL", obep.UserName); ocmd.CommandTimeout = 2000; var ord = odb.ExecuteReader(ocmd); Dispose(false); return(ord); } finally { ocn.Close(); } }
protected void gdvWhsCodeSearch1_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); if (e.Parameters.Contains("ALMCN")) { var splt = e.Parameters.Split(':'); var obj = new BEParameters() { Socied = obec.Socied, ParValue = txtParAlmacen.Text.Trim(), ColumnIndex = ((GridViewDataColumn)gdvWhsCodeSearch1.GetSortedColumns().ElementAt(0)).VisibleIndex, ItemCode = splt[1], }; var obrd = new BRDocument(); var olst = obrd.Get_OSCSP_OITW(obj); Session["owhs"] = olst; gdvWhsCodeSearch1.DataSource = olst; gdvWhsCodeSearch1.DataBind(); } }
protected void grdvInfiltrados_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); if (e.Parameters.Contains("INIT")) { //var spl = e.Parameters.Split(':'); var obep = new BEParameters() { Socied = obec.Socied, U_DXP_COD_ABONADO = txtCliente.Text, U_DXP_SEDE = obec.U_DXP_SEDE }; var obrd = new BRDocument(); var olst = obrd.DXP_GET_ISP_INFILTRADOS(obep); Session["DXP_ISP_INFILTRADOS"] = olst; grdvInfiltrados.DataSource = olst; grdvInfiltrados.DataBind(); } if (e.Parameters.Contains("CHANGE")) { var sede = cbbssede.Value.ToString().Split('$'); var obep = new BEParameters() { Socied = obec.Socied, U_DXP_COD_ABONADO = txtCliente.Text, DIRECCIONIP = sede[0], PASSWORDMKT = sede[1], USUARIOMKT = sede[2], U_DXP_SEDE = cbbssede.Text }; var obrd = new BRDocument(); var olst = obrd.DXP_GET_ISP_INFILTRADOS(obep); Session["DXP_ISP_INFILTRADOS"] = olst; grdvInfiltrados.DataSource = olst; grdvInfiltrados.DataBind(); } }
/// <summary> /// LISTA LOS PRODUCTOS /// </summary> /// <returns></returns> protected void gdvProductSearch_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); var obep = new BEParameters() { Socied = obec.Socied, Project = obec.Project, CardCode = txtCardCode.Text, PriceList = Convert.ToInt16(cbbListNum.Value), WhsCode = obec.WhsCode, ParValue = txtParProduct.Text.Trim(), ColumnIndex = ((GridViewDataColumn)gdvProductSearch.GetSortedColumns().ElementAt(0)).VisibleIndex, Sw = 2, Kit = chkKit.Checked }; var obrd = new BRDocument(); var olst = obrd.Get_OSCSP_OITM_P(obep); Session["oitm"] = olst; gdvProductSearch.DataSource = olst; gdvProductSearch.DataBind(); }
protected void gdvTipoCambio_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); ((List <BETipoCambio>)Session["ortt"]).Clear(); if (e.Parameters.Contains("INIT")) { var spl = e.Parameters.Split(':'); var listdias = GetDates(Convert.ToInt32(spl[1]), Convert.ToInt32(spl[2])); var obep = new BEParameters() { Socied = obec.Socied, mes = Convert.ToInt32(spl[1]), año = Convert.ToInt32(spl[2]), }; var obrd = new BRDocument(); var olst = obrd.DXP_GET_TIPOCAMBIO(obep); listdias.ForEach(i => { BETipoCambio tp = new BETipoCambio(); tp.RateDate = i; ((List <BETipoCambio>)Session["ortt"]).Add(tp); }); olst.ForEach(item => { ((List <BETipoCambio>)Session["ortt"]).Where(tp => tp.RateDate == item.RateDate).ToList().ForEach(x => { if (item.Currency == "USD") { x.RateUSD = item.Rate; } else if (item.Currency == "EUR") { x.RateEUR = item.Rate; } }); }); gdvTipoCambio.DataSource = Session["ortt"]; gdvTipoCambio.DataBind(); } }
protected void UpdateButton_Click(object sender, EventArgs e) { BEParameters obep = (BEParameters)Session["obep"]; if (navigateComboBox.Value.ToString() == "-") { obrl = new BRLogin(); List <BELogin> olst = obrl.Get_DS_SCSP_LSPJ_OPRJ(obep); var str = String.Join(",", olst.Select(p => p.PrjCode)); obep.Project = str; } else { obep.Project = navigateComboBox.Value.ToString(); } obep.DateIn = (DateTime)caleInicio.Value; obep.DateFi = (DateTime)caleFin.Value; hffechaInicio.Value = ((DateTime)caleInicio.Value).ToString("dd/MM/yyyy"); hffechaFin.Value = ((DateTime)caleFin.Value).ToString("dd/MM/yyyy"); cargarDasboard(obep); }
protected void gdvOrinSearch_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); var obj = new BEParameters() { Socied = obec.Socied, DateIn = (DateTime?)dteDateIn.Value, DateFi = (DateTime?)dteDateFi.Value, NumAtCard = txtNumAtCards.Text, CardCode = txtsCardCode.Text, CardName = txtsCardName.Text, Id_Dire = txtdirec.Text, Project = obec.Project, Code = txtCorrelativo.Text }; var obrd = new BRDocument(); var olst = obrd.Get_OSCSP_SRCH_ORPC(obj); Session["Orin"] = olst; gdvOrinSearch.DataSource = olst; gdvOrinSearch.DataBind(); }
private List <BEProduct> SerialNumber() { var obec = ((BEParameters)Session["InitPar"]); var olist = new List <BEProduct>(); var listaSN = new List <BEProduct>(); ((List <BEDocumentLine>)Session["dln1"]).ForEach(item => { var obj = new BEParameters() { Socied = obec.Socied, ItemCode = item.ItemCode }; using (var obrd = new BRDocument()) { olist = obrd.Get_SerialNumber(obj); } listaSN.AddRange(olist); }); return(listaSN); }
private void Init_VarSessions() { var obec = ((BEParameters)Session["InitPar"]); Session["orcp"] = new List <BEContratos>(); Session["DXP_ISP_REGISTRO"] = new List <BEAbonado>(); Session["odrf"] = new List <BEDocument>(); Session["orcl"] = new List <BEWhsCode>(); Session["DXP_IP_POOL"] = new List <BETipoPlan>(); hdfTemp.Add("IP", obec.DIRECCIONIP); hdfTemp.Add("Sociedad", obec.Socied); hdfTemp.Add("UNMK", obec.USUARIOMKT); hdfTemp.Add("PSWMK", obec.PASSWORDMKT); hdfTemp.Add("SEDE", obec.U_DXP_SEDE); if (obec.Band) { var obep = new BEParameters() { Socied = obec.Socied, //U_DXP_COD_ABONADO = txtCliente.Text, //U_DXP_DIREC_ABO = txtDireccion.Text, DIRECCIONIP = obec.DIRECCIONIP, PASSWORDMKT = obec.PASSWORDMKT, USUARIOMKT = obec.USUARIOMKT, }; var obrd = new BRDocument(); ((BEParameters)Session["InitPar"]).Band = false; // obrd.Leer_Mikrotik_Active(obep, obec.objSapSbo); } //hdfTemp.Add("_proj", obec.Project); //hdfTemp.Add("_whsc", obec.WhsCode); //hdfTemp.Add("_cpnadd", obec.CompanyAddress.ToUpper()); //hdfTemp.Add("_phone", obec.Phone); //hdfTemp.Add("_SerieM", obec.SerieMaqr); }
void cargarDasboard(BEParameters obep) { var obrd = new BRDocument(); var oVentas = obrd.Get_DS_OSCSP_SRCH_OPCH(obep); Session["Ventas"] = oVentas; var oProducto = obrd.Get_DS_OSCSP_SRCH_PCH1(obep); Session["Producto"] = oProducto; var oOrden = obrd.Get_DS_OSCSP_SRCH_OPOR(obep); Session["Orden"] = oOrden; var oOrden2 = obrd.Get_DS_OSCSP_SRCH_OPOR2(obep); Session["Orden2"] = oOrden2; var oGuia = obrd.Get_DS_OSCSP_SRCH_OPDN(obep); Session["Guia"] = oGuia; }
protected void gdvArticulos_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); if (e.Parameters.Contains("ADD")) { var spl = e.Parameters.Split(':'); var line = new BEDocumentLine(); line.ItemCode = spl[1]; line.ItemName = spl[2]; line.Quantity = 1; line.WhsCode = cbbalmacenorigen.Value.ToString(); line.WareHouse = cbbalmacendestino.Value.ToString(); line.IssueMthd = spl[3]; line.Serie = ""; ((List <BEDocumentLine>)Session["wtr1"]).Add(line); } else if (e.Parameters.Contains("GET")) { var _spl = e.Parameters.Split(':'); var obep = new BEParameters() { Socied = obec.Socied, DocEntry = Convert.ToInt32(_spl[1]), }; var obrd = new BRDocument(); var list = obrd.DXP_GET_TRANSTOCK_DETALLE(obep); Session["wtr1"] = list; } else if (e.Parameters.Contains("CLR")) { ((List <BEDocumentLine>)Session["wtr1"]).Clear(); } gdvArticulos.DataSource = ((List <BEDocumentLine>)Session["wtr1"]); gdvArticulos.DataBind(); Set_LineNum(); }
protected void grdvConsumos_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); if (e.Parameters.Contains("INIT")) { //var spl = e.Parameters.Split(':'); var obep = new BEParameters() { Socied = obec.Socied, U_DXP_COD_ABONADO = txtCliente.Text, DIRECCIONIP = obec.DIRECCIONIP, USUARIOMKT = obec.USUARIOMKT, PASSWORDMKT = obec.PASSWORDMKT, }; var obrd = new BRDocument(); var olst = obrd.Leer_Mikrotik_Consumos(obep); Session["DXP_ISP_REGISTRO"] = olst; grdvConsumos.DataSource = olst; grdvConsumos.DataBind(); } }
protected void cbbCuentaTrans_Callback(object sender, CallbackEventArgsBase e) { var obec = ((BEParameters)Session["InitPar"]); var obep = new BEParameters() { Socied = obec.Socied }; var obrd = new BRDocument(); var olst = obrd.GET_CUENTAS_PAGO(obep); if (olst.Count != 0) { olst.Where(i => i.Clave == "SC").ToList().ForEach(item => { cbbCuentaTrans.Items.Add(item.AcctName, item.AcctCode); }); cbbCuentaTrans.SelectedIndex = 0; } else { cbbCuentaTrans.Items.Add("", 0); cbbCuentaTrans.SelectedIndex = 0; } }
protected void btnEnviarTodo_Click(object sender, EventArgs e) { var obrd = new BRDocument(); var obec = ((BEParameters)Session["InitPar"]); var sede = cbbssede.Value.ToString().Split('$'); var ob = new BEParameters() { Socied = obec.Socied, DIRECCIONIP = sede[0], USUARIOMKT = sede[1], PASSWORDMKT = sede[2], U_DXP_COD_ABONADO = "", U_DXP_SEDE = cbbssede.Text, }; var mensaje = obrd.Enviar_pendientes(ob, obec.objSapSbo); //var mensaje = "hola mundo"; //hdfTemp.Set("Band", true); //hdfTemp.Set("Msg", mensaje); grdvPendientes.DataSource = ((List <BEAbonado>)Session["DXP_ISP_REGISTRO"]); grdvPendientes.DataBind(); }