protected void cbbUsuario_Callback(object sender, CallbackEventArgsBase e) { var obec = ((BEParameters)Session["InitPar"]); if (e.Parameter.Contains("GET")) { var obj = new BEParameters() { Socied = obec.Socied, Project = obec.Project, U_DXP_SEDE = obec.U_DXP_SEDE, }; var obrd = new BRDocument(); var olst = obrd.USUARIOS(obj); if (olst.Count != 0) { cbbUsuario.Items.Add("", 0); olst.ForEach(ite => { cbbUsuario.Items.Add(ite.UserName, ite.UserName); }); } else { cbbUsuario.Items.Add("", 0); cbbUsuario.SelectedIndex = 0; } } }
protected void gvcontacto_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 = splv[1], accion = 2, }; var obrd = new BRDocument(); var olst = obrd.GET_CLIENTES_CONTACTOS(obj); Session["crd1"] = olst; gvcontacto.DataSource = olst; gvcontacto.DataBind(); } else if (e.Parameters.Contains("CLR")) { ((List <BEContactLines>)Session["crd1"]).Clear(); gvcontacto.DataSource = Session["crd1"]; gvcontacto.DataBind(); } }
protected void gdvQutSearch_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); var obj = new BEParameters(); obj.Socied = obec.Socied; if (chkqDocEntry.Checked) { obj.Internal = txtqDocEntry.Text.Trim(); } if (chkqCreateDate.Checked) { obj.DateIn = dteqCreateDate.Date; } if (chkqCardCode.Checked) { obj.CardCode = txtqCardCode.Text.Trim(); } if (chkqCardName.Checked) { obj.CardName = txtqCardName.Text.Trim(); } if (chkqActives.Checked) { obj.Actives = txtqActives.Text.Trim(); } var obrd = new BRDocument(); Session["qut"] = obrd.Get_OSCSP_SRCH_QUTT(obj); gdvQutSearch.DataSource = Session["qut"]; gdvQutSearch.DataBind(); }
private string SaveTarjeta() { var obec = ((BEParameters)Session["InitPar"]); var obj = new BETarjetaEquipo(); obj.CardCode = bteCustomer.Text; obj.CardName = txtcustmrName.Text; obj.Status = cbbstatus.Value.ToString(); obj.ItemCode = bteitemCode.Text; obj.ItemName = txtitemName.Text; obj.manufSN = txtmanufSN.Text; obj.internalSN = txtinternalSN.Text; obj.instLction = cbbAddress.Text; obj.street = txtStreets1.Text; obj.county = txtDistrito1.Text; obj.state = txtDepartamento1.Text; obj.U_GOS_MARCA = txtMarca.Text; obj.U_GOS_MODELO = txtModelo.Text; //obj.ContactPerson = Convert.ToString(txtcontctCode1.Value); using (var obrd = new BRDocument()) { obrd.SaveTarjeta(obj, ((BEParameters)Session["InitPar"]).objSapSbo); } var _err = !string.IsNullOrWhiteSpace(obj.Msg) ? obj.Msg : string.Format("OKBP#{0}", obj.insID); //Init_VarSessions(); return(_err); }
protected void grdvLlamada_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); if (e.Parameters.Contains("GET")) { var spl = e.Parameters.Split(':'); var obj = new BEParameters() { Socied = obec.Socied, ItemCode = spl[2], CardCode = spl[1], SerieMaqr = spl[3] }; var obrd = new BRDocument(); var olst = obrd.DXP_GET_SERVICIO_TJ(obj); Session["oscl"] = olst; grdvLlamada.DataSource = olst; grdvLlamada.DataBind(); } else if (e.Parameters.Contains("CLR")) { ((List <BELlamadaServicio>)Session["oscl"]).Clear(); grdvLlamada.DataSource = Session["oscl"]; grdvLlamada.DataBind(); } }
protected void gdvdln1_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); var obep = new BEParameters(); if (e.Parameters.Contains("GET")) { var spl = e.Parameters.Split(':'); if (spl[1] != "" && spl[1] != null) { obep.Socied = obec.Socied; obep.DocNum = Convert.ToInt32(spl[1]); var olst = new List <BEDocumentLine>(); var obrd = new BRDocument(); olst = obrd.DXP_GET_GUIA_LLAMADA(obep); Session["dln1"] = olst; gdvdln1.DataSource = ((List <BEDocumentLine>)Session["dln1"]); gdvdln1.DataBind(); } } else if (e.Parameters.Contains("CLR")) { ((List <BEDocumentLine>)Session["dln1"]).Clear(); gdvdln1.DataSource = Session["dln1"]; gdvdln1.DataBind(); } }
protected void gdvGrupoArt_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); var obj = new BEParameters() { Socied = obec.Socied, Descripcion = txtnombregrupo.Text, }; if (e.Parameters.Contains("SRCH")) { var obrd = new BRDocument(); var olst = obrd.DXP_GET_GRUPO_ART(obj); Session["grupo"] = olst; gdvGrupoArt.DataSource = olst; gdvGrupoArt.DataBind(); } else if (e.Parameters.Contains("CLR")) { ((List <BEGrupoArt>)Session["grupo"]).Clear(); gdvGrupoArt.DataSource = Session["grupo"]; gdvGrupoArt.DataBind(); } }
protected void gdvTipoCambio_RowUpdating(object sender, ASPxDataUpdatingEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); var index = gdvTipoCambio.EditingRowVisibleIndex; //if(((List<BEAlmacen>)Session["oitw"])[index].Tiempo == "Existente") ((List <BETipoCambio>)Session["ortt"])[index].RateUSD = Convert.ToDecimal(e.NewValues["RateUSD"]); ((List <BETipoCambio>)Session["ortt"])[index].RateEUR = Convert.ToDecimal(e.NewValues["RateEUR"]); BETipoCambio tp = new BETipoCambio(); tp.RateDate = Convert.ToDateTime(e.NewValues["RateDate"]); tp.RateUSD = Convert.ToDecimal(e.NewValues["RateUSD"]); tp.RateEUR = Convert.ToDecimal(e.NewValues["RateEUR"]); gdvTipoCambio.CancelEdit(); e.Cancel = true; gdvTipoCambio.DataSource = ((List <BETipoCambio>)Session["ortt"]); gdvTipoCambio.DataBind(); using (var obrd = new BRDocument()) { obrd.SaveCurrencyDates(tp, ((BEParameters)Session["InitPar"]).objSapSbo); ((BEParameters)Session["InitPar"]).Rate = tp.RateUSD; ((BEParameters)Session["InitPar"]).RateEur = tp.RateEUR; //Rate1 = tp.RateUSD; } }
/// <summary> /// LISTA LOS CLIENTES /// </summary> /// <returns></returns> protected void gdvClientSearch_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); if (e.Parameters.Contains("SRCH")) { var obj = new BEParameters() { Socied = obec.Socied, ParValue = txtParClient.Text.Trim(), CardName = txtRazonS.Text, ColumnIndex = ((GridViewDataColumn)gdvClientSearch.GetSortedColumns().ElementAt(0)).VisibleIndex }; var obrd = new BRDocument(); var olst = obrd.Get_OSCSP_OCRD(obj); Session["ocrd"] = olst; gdvClientSearch.DataSource = olst; gdvClientSearch.DataBind(); } else if (e.Parameters.Contains("CLR")) { ((List <BEClient>)Session["ocrd"]).Clear(); gdvClientSearch.DataSource = Session["ocrd"]; gdvClientSearch.DataBind(); } }
private string Modify() { var obec = ((BEParameters)Session["InitPar"]); var obj = new BEBusinessPartner(); obj.Socied = obec.Socied; obj.CardCode = txtCrCardCode.Text; obj.CardName = txtCrCardName.Text; //cbbCrDocumentType obj.LicTradNum = txtCrLicTradNum.Text; //obj.GroupCode = obj.Phone1 = txtCrPhone1.Text; obj.Cellular = txtCrCellular.Text; obj.E_Mail = txtCrE_Mail.Text; obj.U_PN_FecNac = dteCrU_PN_FecNac.Text; obj.U_BPP_BPTP = Convert.ToString(cbbCrPersonType.Value); obj.U_BPP_BPTD = Convert.ToString(cbbCrDocumentType.Value); obj.GroupNum = Convert.ToString(GroupNum.Value); obj.Currency = Convert.ToString(cbbCurrency.Value); obj.ListNum = Convert.ToString(ListNum.Value); obj.Active = Convert.ToString(rbtnestado.SelectedItem.Value); obj.Lines = ((List <BEContactLines>)Session["crd1"]); obj.Lines2 = ((List <BEClientAddress>)Session["dire"]); using (var obrd = new BRDocument()) { obrd.UpdateBusinessPartner(obj, ((BEParameters)Session["InitPar"]).objSapSbo); } var _err = !string.IsNullOrWhiteSpace(obj.Msg) ? obj.Msg : "OKUPDBP"; //Init_VarSessions(); return(_err); }
/// <summary> /// LISTA LOS PRODUCTOS /// </summary> /// <returns></returns> protected void gdvProductSearch_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); if (e.Parameters.Contains("BUSCAR")) { var obep = new BEParameters() { Socied = obec.Socied, Project = obec.Project, CardCode = txtCardCode.Text, PriceList = Convert.ToInt16(cbbListNum.Value), WhsCode = "", ParValue = txtParProduct.Text.Trim(), ColumnIndex = ((GridViewDataColumn)gdvProductSearch.GetSortedColumns().ElementAt(0)).VisibleIndex, Sw = 2, Kit = false, Moneda = cbbDocCur.Value.ToString(), DateIn = Convert.ToDateTime(dteDocDate.Text), Descripcion = txtDescription.Text, SerieMaqr = txtMarca.Text }; var obrd = new BRDocument(); var olst = obrd.Get_OSCSP_OITM_P(obep); Session["oitm"] = olst; gdvProductSearch.DataSource = olst; gdvProductSearch.DataBind(); } else if (e.Parameters.Contains("CLEAR")) { ((List <BEProduct>)Session["oitm"]).Clear(); gdvProductSearch.DataSource = Session["oitm"]; gdvProductSearch.DataBind(); } }
protected void cbbAddress_Callback(object sender, CallbackEventArgsBase e) { var obec = ((BEParameters)Session["InitPar"]); if (e.Parameter.Contains("GET")) { var splv = e.Parameter.Split(':'); var obj = new BEParameters() { Socied = obec.Socied, CardCode = splv[1], accion = 3, }; var obrd = new BRDocument(); var olst = obrd.GET_CLIENTES_DIRECCIONES(obj); if (olst.Count != 0) { cbbAddress.Items.Add("", 0); olst.Where(i => i.AdresType != "B").ToList().ForEach(ite => { cbbAddress.Items.Add(ite.Address, ite.Street + "$" + ite.StateName + "$" + ite.U_DXP_BIZ_PROV + "$" + ite.U_DXP_BIZ_DIST + "$" + ite.AdresType); }); //cbbAddress.SelectedIndex = 0; } else { cbbAddress.Items.Add("", 0); cbbAddress.SelectedIndex = 0; } } }
private string SaveItem() { var obec = ((BEParameters)Session["InitPar"]); var obj = new BETipoCambio(); //obj.RateDate = Convert.ToDateTime(dteFecha.Text); //obj.UserSing = obec.CardName; //if(txtDolar.Text != "0.00") //{ // obj.CurrencyUSD = "USD"; // obj.RateUSD = Convert.ToDecimal(txtDolar.Text); //} //if (txtEuro.Text != "0.00") //{ // obj.CurrencyEUR = "EUR"; // obj.RateEUR = Convert.ToDecimal(txtDolar.Text); //} using (var obrd = new BRDocument()) { obrd.SaveCurrencyDates(obj, ((BEParameters)Session["InitPar"]).objSapSbo); } var _err = !string.IsNullOrWhiteSpace(obj.Msg) ? obj.Msg : "OKBP"; //Init_VarSessions(); return(_err); }
protected void gvDirecciones_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 = splv[1], accion = 3, }; var obrd = new BRDocument(); var olst = obrd.GET_CLIENTES_DIRECCIONES(obj); Session["dire"] = olst; gvDirecciones.DataSource = olst; gvDirecciones.DataBind(); } else if (e.Parameters.Contains("CLR")) { ((List <BEClientAddress>)Session["dire"]).Clear(); gvDirecciones.DataSource = Session["dire"]; gvDirecciones.DataBind(); } }
private void Init_VarSessions() { var obec = ((BEParameters)Session["InitPar"]); var obj = new BEParameters() { Socied = obec.Socied, Project = obec.Project, U_DXP_SEDE = obec.U_DXP_SEDE, }; var obrd = new BRDocument(); var olst = obrd.USUARIOS(obj); if (olst.Count != 0) { cbbUsuario.Items.Add("", 0); olst.ForEach(ite => { cbbUsuario.Items.Add(ite.UserName, ite.UserName); }); } else { cbbUsuario.Items.Add("", 0); cbbUsuario.SelectedIndex = 0; } }
protected void txtcontctCode1_Callback(object sender, CallbackEventArgsBase e) { var obec = ((BEParameters)Session["InitPar"]); if (e.Parameter.Contains("INICIAR")) { var x = e.Parameter.Split(':'); var olst = new List <BEContactLines>(); var obj = new BEParameters() { Socied = obec.Socied, CardCode = x[1], }; var obrd = new BRDocument(); olst = obrd.Get_Contact_Person(obj); if (olst.Count != 0) { olst.ForEach(ite => { txtcontctCode1.Items.Add(ite.Name, ite.CntctCode); }); txtcontctCode1.SelectedIndex = 0; } else { txtcontctCode1.Items.Add("", 0); txtcontctCode1.SelectedIndex = 0; } } }
protected void gdvdln1_RowInserting(object sender, ASPxDataInsertingEventArgs e) { var beNe = new BRDocument(); gdvdln1.DoRowValidation(); var obec = ((BEParameters)Session["InitPar"]); string almacen = ""; /*if (obec.Socied == "BM") * { * if (beNe.getStockAlmacen(Convert.ToString(e.NewValues["ItemCode"])) <= 0) * almacen = "BL010"; * else * almacen = obec.WhsCode; * } * if (obec.Socied == "BT") * {*/ almacen = obec.WhsCode; //} var line = new BEDocumentLine() { ItemCode = Convert.ToString(e.NewValues["ItemCode"]), ItemName = Convert.ToString(e.NewValues["ItemName"]), Quantity = Convert.ToInt32(e.NewValues["Quantity"]), PriceBefDi = Convert.ToDecimal(e.NewValues["PriceBefDi"]), DiscPrcnt = Convert.ToDecimal(e.NewValues["DiscPrcnt"]), Price = Convert.ToDecimal(e.NewValues["Price"]), LineTotal = Convert.ToDecimal(e.NewValues["LineTotal"]), GTotal = Convert.ToDecimal(e.NewValues["GTotal"]), IssueMthd = Convert.ToString(e.NewValues["IssueMthd"]), WhsCode = almacen, U_StoDiBE = Convert.ToDecimal(e.NewValues["U_StoDiBE"]), U_BF_StoDiYo = Convert.ToDecimal(e.NewValues["U_BF_StoDiYo"]), //BL050 = Convert.ToDecimal(e.NewValues["BL050"]), //BL010 = Convert.ToDecimal(e.NewValues["BL010"]), //U_U_BF_CompTot = Convert.ToDecimal(e.NewValues["U_U_BF_CompTot"]), //U_BIZ_DREC = Convert.ToString(e.NewValues["U_BIZ_DREC"]), //U_BIZ_FFAR = Convert.ToString(e.NewValues["U_BIZ_FFAR"]), //U_BIZ_CANT = Convert.ToDecimal(e.NewValues["U_BIZ_CANT"]), //U_BF_FECH_EXPE = DateTime.Today.ToShortDateString(), //U_BF_FECH_VENC = DateTime.Today.AddDays(90).ToShortDateString(), //U_BF_CodKit = string.Empty, OItemCode = Convert.ToString(e.NewValues["OItemCode"]), OnDscOrg = Convert.ToDecimal(e.NewValues["OnDscOrg"]), Serie = Convert.ToString(e.NewValues["Serie"]) //PASAR EL SERIALNUMBER PARA LUEGO HACER EL DATASOURCE AL DETALLE }; line.InDscOrg = (line.OnDscOrg == 0) ? 1 : 0; ((List <BEDocumentLine>)Session["dln1"]).Add(line); //Set_Promotion(); Set_LineNum(); gdvdln1.JSProperties["cpSubTotal"] = ((List <BEDocumentLine>)Session["dln1"]).Sum(item => Math.Round(item.LineTotal, 2)); gdvdln1.CancelEdit(); e.Cancel = true; gdvdln1.DataSource = ((List <BEDocumentLine>)Session["dln1"]); gdvdln1.DataBind(); }
protected void clbSession_Callback(object source, DevExpress.Web.ASPxCallback.CallbackEventArgs e) { try { e.Result = string.Empty; var obrd = new BRLogin(); var brdoc = new BRDocument(); var obec = ((BEParameters)Session["InitPar"]); var obep = new BEParameters(); obep.UserName = UserName.Text; obep.Password = Password.Text; obep.SAPPASSWORD = tbPasswordConfirm.Text; List <BEParameters> lval = obrd.Get_val_usu(obep.UserName.Trim(), obec.Socied, obec.U_DXP_SEDE); if (obep.Password != obep.SAPPASSWORD) { throw new KeyNotFoundException(); } else if (lval.Count == 0) { throw new KeyNotFoundException(); } else { brdoc.Recoverer(obep); e.Result = "PERM#" + "Cambio Exitoso"; } } catch (KeyNotFoundException ex) { e.Result = ex.Message; } }
protected void gdvProductSearch3_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); if (e.Parameters.Contains("GENERAL")) { var obep = new BEParameters() { Socied = obec.Socied, ItemCode = txtParProduct3.Text.Trim(), WhsCode = obec.WhsCode, VALOR = txtmarc3.Text, Descripcion = txtdescrip3.Text }; var obrd = new BRDocument(); var olst = obrd.DXP_GET_ITEM_SEGUN_ALMACEN(obep); Session["oitt"] = olst; gdvProductSearch3.DataSource = olst; gdvProductSearch3.DataBind(); } else if (e.Parameters.Contains("CLR")) { ((List <BEProduct>)Session["oitt"]).Clear(); gdvProductSearch3.DataSource = Session["oitt"]; gdvProductSearch3.DataBind(); } }
public static List <BEAdministrator> getdatos() { var obrd = new BRDocument(); var list = obrd.Get_list_user_admin(); return(list); }
protected void gdvTipoPlan_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, Code = spl[1], U_DXP_SEDE = cbbssede.Text }; var obrd = new BRDocument(); if (obj.U_DXP_SEDE == "CE JULIACA") { obj.U_DXP_SEDE = "02"; } else if (obj.U_DXP_SEDE == "CE PUNO") { obj.U_DXP_SEDE = "01"; } var olst = obrd.GET_TIPOPLAN(obj); Session["DXP_IP_POOL"] = olst; gdvTipoPlan.DataSource = olst; gdvTipoPlan.DataBind(); } }
protected void gdvAsiento_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); var obep = new BEParameters(); if (e.Parameters.Contains("SRCH")) { obep.Socied = obec.Socied; obep.TransId = Convert.ToInt32(txtTransId.Text); var olst = new List <BEDocumentLine>(); var obrd = new BRDocument(); olst = obrd.Get_OSCSP_SRCH_JDT1(obep); Session["asientoPrinc"] = olst; gdvAsiento.DataSource = ((List <BEDocumentLine>)Session["asientoPrinc"]); gdvAsiento.DataBind(); } else if (e.Parameters.Contains("CLR")) { ((List <BEDocumentLine>)Session["asientoPrinc"]).Clear(); gdvAsiento.DataSource = Session["asientoPrinc"]; gdvAsiento.DataBind(); } }
private string UpdtAsiento() { var obec = ((BEParameters)Session["InitPar"]); var obj = new BEAsiento(); obj.Series = cbbnumero.Text; obj.TransId = Convert.ToInt32(txtTransId.Text); obj.DueDate = Convert.ToDateTime(txtDueDate.Value); obj.Memo = txtmemo.Text; obj.Indicator = Convert.ToString(cbbIndicator.Value); obj.Project = bteProject.Text; obj.TransCode = Convert.ToString(cbbTransCode.Value); obj.Ref1 = txtRef1.Text; obj.Ref2 = txtRef2.Text; obj.Ref3 = txtRef3.Text; obj.TipoC = Convert.ToString(chktipocamb.Value); obj.AutoStorno = Convert.ToString(chkanular.Value); obj.StornoDate = Convert.ToDateTime(txtanular.Value); obj.AdjTran = Convert.ToString(chkajuste.Value); obj.U_GOS_ESTDOC_LE = Convert.ToString(cbbestadodoc.Value); obj.U_GOS_FECHA_LE = txtlibroelec.Text; obj.U_MSS_TransIdAD = Convert.ToInt32(txtdocdes.Text); obj.Lines = ((List <BEDocumentLine>)Session["asientoPrinc"]); using (var obrd = new BRDocument()) { obrd.UpdtAsiento(obj, ((BEParameters)Session["InitPar"]).objSapSbo); } var _err = !string.IsNullOrWhiteSpace(obj.Msg) ? obj.Msg : "IKCC"; //Init_VarSessions(); return(_err); }
protected void grdvRecurso_CustomButtonCallback(object sender, ASPxGridViewCustomButtonCallbackEventArgs e) { var obrd = new BRDocument(); var obec = ((BEParameters)Session["InitPar"]); if (e.ButtonID != "Enviar") { return; } Hashtable copiedValues = null; string[] copiedFields = new string[] { "PrjName", "DIRECCIONIP", "USUARIOMKT", "PASSWORDMKT" }; copiedValues = new Hashtable(); foreach (string fieldName in copiedFields) { copiedValues[fieldName] = grdvRecurso.GetRowValues(e.VisibleIndex, fieldName); } var obj = new BEParameters() { U_DXP_SEDE = Convert.ToString(copiedValues["PrjName"]), //PrjName = Convert.ToString(copiedValues["PrjName"]), DIRECCIONIP = Convert.ToString(copiedValues["DIRECCIONIP"]), USUARIOMKT = Convert.ToString(copiedValues["USUARIOMKT"]), PASSWORDMKT = Convert.ToString(copiedValues["PASSWORDMKT"]), Socied = obec.Socied, }; obrd.Leer_Mikrotik_Abonados(obj, obec.objSapSbo); }
protected void gdvProductSearch_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); if (e.Parameters.Contains("GENERAL")) { var obep = new BEParameters() { Socied = obec.Socied, accion = 1, ItemCode = txtParProduct.Text.Trim(), VALOR = txtmarc.Text, Descripcion = txtdescrip.Text }; var obrd = new BRDocument(); var olst = obrd.GET_ARTICULOS_GENERAL(obep); Session["oitm"] = olst; gdvProductSearch.DataSource = olst; gdvProductSearch.DataBind(); } else if (e.Parameters.Contains("CLR")) { ((List <BEProduct>)Session["oitm"]).Clear(); gdvProductSearch.DataSource = Session["oitm"]; gdvProductSearch.DataBind(); } }
protected void grdvContratos_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); var Detalle = ""; if (e.Parameters.Contains("INIT")) { //var spl = e.Parameters.Split(':'); var obep1 = new BEParameters(); obep1.Socied = obec.Socied; obep1.CardCode = txtCliente.Text; obep1.Id_Dire = txtIdDirec.Text; obep1.Code = txtCode.Text; obep1.LOCAL = txtcalle.Text; obep1.distrito = txtdistr.Text; obep1.provincia = txtprovinc.Text; obep1.Descripcion = txturba.Text; obep1.Project = obec.Project; if (string.IsNullOrEmpty(cbbVendedor.Text)) { obep1.CompanyDB = ""; } else { obep1.CompanyDB = cbbVendedor.Value.ToString(); } obep1.DateIn = (DateTime?)dtebusqueda.Value; obep1.DateFi = (DateTime?)dtebusqueda2.Value; var obrd = new BRDocument(); var olst1 = obrd.DXP_GET_CONTRATOS(obep1); olst1.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["orcp"] = olst1; grdvContratos.DataSource = Session["orcp"]; grdvContratos.DataBind(); } }
protected void grdvContratos_RowUpdating(object sender, ASPxDataUpdatingEventArgs e) { var obec = ((BEParameters)Session["InitPar"]); var index = grdvContratos.EditingRowVisibleIndex; string[] x = new string[15]; DateTime?fch = new DateTime(); //if(((List<BEAlmacen>)Session["oitw"])[index].Tiempo == "Existente") ((List <BEContratos>)Session["orcp"])[index].Code = Convert.ToString(e.NewValues["Code"]); ((List <BEContratos>)Session["orcp"])[index].Dscription = Convert.ToString(e.NewValues["Dscription"]); ((List <BEContratos>)Session["orcp"])[index].Frequency = Convert.ToString(e.NewValues["Frequency"]); ((List <BEContratos>)Session["orcp"])[index].Remind = Convert.ToInt32(e.NewValues["Remind"]); ((List <BEContratos>)Session["orcp"])[index].DocNum = Convert.ToString(e.NewValues["DocNum"]); ((List <BEContratos>)Session["orcp"])[index].StartDate = Convert.ToDateTime(e.NewValues["StartDate"]); ((List <BEContratos>)Session["orcp"])[index].EndDate = Convert.ToDateTime(e.NewValues["EndDate"]); ((List <BEContratos>)Session["orcp"])[index].EndDate2 = Convert.ToString(e.NewValues["EndDate2"]); var absentry = 0; if (((List <BEContratos>)Session["orcp"])[index].EndDate2 == "") { fch = null; } else { x = ((List <BEContratos>)Session["orcp"])[index].EndDate2.Substring(0, 10).Split('/'); fch = Convert.ToDateTime(x[1] + "/" + x[0] + "/" + x[2]); } ((List <BEContratos>)Session["orcp"]).Where(i => i.Code == Convert.ToString(e.NewValues["Code"]) && i.DocNum == Convert.ToString(e.NewValues["DocNum"]) && i.CardCode == Convert.ToString(e.NewValues["CardCode"])).ToList().ForEach(item => { absentry = item.AbsEntry; }); var obep = new BEParameters(); obep.Socied = obec.Socied; obep.accion = 2; obep.AbsEntryUpdt = absentry; obep.FechaUpdt = fch; obep.Descripcion = ((List <BEContratos>)Session["orcp"])[index].Dscription; obep.DraftEntry = 0; var obrd = new BRDocument(); obrd.CRUD_CONTRATO(obep); var olst = obrd.DXP_GET_CONTRATOS(obep); grdvContratos.CancelEdit(); e.Cancel = true; grdvContratos.DataSource = olst; grdvContratos.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["print"] != null) { ocno = (BEDocument)Session["print"]; var obec = ((BEParameters)Session["InitPar"]); var obrd = new BRDocument(); ReportDocument cryRpt = new ReportDocument(); var list = obrd.DXP_GET_URL_FORMATOIMPRESION(new BEParameters() { Socied = obec.Socied }); // list.Where(item => item.U_DXP_NOMBRE_PARAMET == ocno.formatoImpresion).ToList().ForEach(i => { cryRpt.Load(i.U_DXP_VALOR_PARAMETR); }); string var1 = ocno.DocEntry.ToString();//Request.QueryString["docEnry"]; String strServer = "SRV-SQL01"; String strDatabase = obec.CompanyDB; String strUserID = "sa"; String strPwd = "MPP@SW0RD"; CrystalReportViewer1.Width = new Unit("2000px"); CrystalReportViewer1.Height = new Unit("2000px"); cryRpt.DataSourceConnections[0].SetConnection(strServer, strDatabase, strUserID, strPwd); cryRpt.SetParameterValue(0, var1); CrystalReportViewer1.ReportSource = cryRpt; cryRpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, "Crystal"); Response.End(); } /////////////////////////////////////////////////////////////////////// //ReportDocument cryRpt = new ReportDocument(); ////string rpt = Request.QueryString["rpt"]; //cryRpt.Load(Server.MapPath("FacturaOdex.rpt")); //string var1 = "18";//Request.QueryString["docEnry"]; //String strServer = "SRV-SQL01"; //String strDatabase = "SBO_DEXO"; //String strUserID = "sa"; //String strPwd = "MPP@SW0RD"; //CrystalReportViewer1.Width = new Unit("2000px"); //CrystalReportViewer1.Height = new Unit("2000px"); //cryRpt.DataSourceConnections[0].SetConnection(strServer, strDatabase, strUserID, strPwd); //cryRpt.SetParameterValue(0, var1); //CrystalReportViewer1.ReportSource = cryRpt; //cryRpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, "Crystal"); //Response.End(); }
protected void btnAddVistas_Click(object sender, EventArgs e) { var obec = ((BEParameters)Session["InitPar"]); var obrd = new BRDocument(); var olst = obrd.VISTAS(); var cant = ((List <BEParameters>)Session["perm"]).Count; var usuario = cbbUsuario.Text; var listavistas = new List <BEParameters>(); if (cant == 0) { listavistas.Clear(); olst.ForEach(item => { var linea = new BEParameters(); linea.UserName = usuario; linea.PERMISO = 1; linea.Socied = obec.Socied; linea.Project = obec.Project; linea.GRUPO_MENU = item.GRUPO_MENU; linea.PARTICULAR_MENU = item.PARTICULAR_MENU; linea.NOMBRE_OFICIAL = item.NOMBRE_OFICIAL; listavistas.Add(linea); }); } else { listavistas.Clear(); olst.ForEach(item => { ((List <BEParameters>)Session["perm"]).ForEach(it => { if (item.NOMBRE_OFICIAL == it.NOMBRE_OFICIAL) { item.Band = true; } }); }); olst.Where(i => i.Band != true).ToList().ForEach(x => { var linea = new BEParameters(); linea.UserName = usuario; linea.PERMISO = 1; linea.Socied = obec.Socied; linea.Project = obec.Project; linea.GRUPO_MENU = x.GRUPO_MENU; linea.PARTICULAR_MENU = x.PARTICULAR_MENU; linea.NOMBRE_OFICIAL = x.NOMBRE_OFICIAL; listavistas.Add(linea); }); } if (listavistas.Count != 0) { listavistas.ForEach(add => { obrd.DXP_INSERT_VISTA_POR_USUARIO(add); }); } }
public static List<BEInitialData> Get_InitialTipClie(string socied) { var obep = new BEParameters() { Socied = socied, }; var obrd = new BRDocument(); var olst = obrd.GET_SP_TIP_CLIE(obep); return (olst); }