private List <Acys> GetList() { try { List <Acys> List = new List <Acys>(); CN_CapAcys clsCapAcys = new CN_CapAcys(); Sesion session2 = new Sesion(); session2 = (Sesion)Session["Sesion" + Session.SessionID]; Acys acys = new Acys(); acys.Id_Emp = session2.Id_Emp; acys.Id_Cd = session2.Id_Cd_Ver; acys.Filtro_FecIni = txtFecha1.SelectedDate; acys.Filtro_FecFin = txtFecha2.SelectedDate; acys.Filtro_Estatus = cmbEstatus.SelectedValue == "-1" ? "" : cmbEstatus.SelectedValue; acys.Filtro_FolIni = txtFolio1.Text; acys.Filtro_FolFin = txtFolio2.Text; acys.Filtro_usuario = session2.Propia ? session2.Id_U.ToString() : ""; acys.Id_Ter = cmbTerritorio.Text != "" && cmbTerritorio.SelectedValue != "-1" ? Convert.ToInt32(cmbTerritorio.SelectedValue) : -1; acys.Id_Cte = Convert.ToInt32(txtCliente.Value.HasValue ? txtCliente.Value.Value : -1); acys.Id_Rik = cmbRepresentante.Text != "" && cmbRepresentante.SelectedValue != "-1" ? Convert.ToInt32(cmbRepresentante.SelectedValue) : -1; acys.Acs_Vencido = cmbVencido.Text != "" && cmbVencido.SelectedValue != "-1" ? cmbVencido.SelectedValue: "-1"; clsCapAcys.ConsultarAcys_Lista(acys, session2.Emp_Cnx, ref List); return(List); } catch (Exception ex) { throw ex; } }
private void Captar(ref GridCommandEventArgs e, GridItem gi) { try { if (gi.Cells[2].Text.ToLower() != "false") { Alerta("El cliente tiene crédito suspendido, favor de hacer las gestiones correspondientes para poder captar"); e.Canceled = true; } else { CN_CapAcys cn_capacys = new CN_CapAcys(); Acys acys = new Acys(); acys.Id_Emp = session.Id_Emp; acys.Id_Cd = session.Id_Cd_Ver; acys.Id_Acs = Convert.ToInt32(gi.Cells[3].Text); cn_capacys.Consultar(ref acys, session.Emp_Cnx); if (acys.Acs_Estatus == "B") { Alerta("No se puede captar el pedido, el Acuerdo esta dado de baja"); rg1.Rebind(); return; } RAM1.ResponseScripts.Add("return AbrirVentana_ProPedidoVI('" + gi.Cells[3].Text + "', '" + _PermisoGuardar + "', '" + _PermisoModificar + "', '" + _PermisoEliminar + "', '" + _PermisoImprimir + "'," + gi.Cells[9].Text + ", '" + gi.Cells[8].Text + "')"); } } catch (Exception ex) { throw ex; } }
protected void Page_Load(object sender, EventArgs e) { try { Sesion Sesion = new Sesion(); Sesion = (Sesion)Session["Sesion" + Session.SessionID]; if (Sesion == null) { CerrarVentana(""); } else { if (!IsPostBack) { //if (list == null) //{ list = new DataTable(); list.Columns.Add("Id"); list.Columns.Add("Descripcion"); list.Columns.Add("Disponible"); list.Columns.Add("Cantidad"); list.Columns.Add("Precio"); CN_CapAcys acys = new CN_CapAcys(); Acys a = new Acys(); a.Id_Emp = Sesion.Id_Emp; a.Id_Cd = Sesion.Id_Cd_Ver; a.Id_Acs = Convert.ToInt32(Request.QueryString["Id_Acs"]); DataTable list2 = list; acys.ConsultarReemplazos(a, Convert.ToInt32(Request.QueryString["Id_Prd"]), ref list2, Sesion.Emp_Cnx); list = list2; //} RadGrid1.Rebind(); CN_CatProducto cn_catproducto = new CN_CatProducto(); Producto pr = new Producto(); int id_Prd; for (int x = 0; x < RadGrid1.Items.Count; x++) { id_Prd = Convert.ToInt32((RadGrid1.Items[x]["Id"].FindControl("lblId") as Label).Text); cn_catproducto.ConsultaProducto(ref pr, Sesion.Emp_Cnx, Sesion.Id_Emp, Sesion.Id_Cd_Ver, id_Prd); (RadGrid1.Items[x]["Precio"].FindControl("txtPrecio") as RadNumericTextBox).DbValue = pr.Prd_Precio; } } } } catch (Exception) { throw; } }
private void AcuerdoImpresion_NeedDataSource(object sender, EventArgs e) { this.sqlConnection2.ConnectionString = this.ReportParameters["Conexion"].Value.ToString(); //Transfer the ReportParameter value to the parameter of the select command this.sqlDataAdapter1.SelectCommand.Parameters["@Id_Emp"].Value = this.ReportParameters["Id_Emp"].Value; this.sqlDataAdapter1.SelectCommand.Parameters["@Id_Cd"].Value = this.ReportParameters["Id_Cd"].Value; this.sqlDataAdapter1.SelectCommand.Parameters["@Id_Acs"].Value = this.ReportParameters["Id_Acs"].Value; this.sqlDataAdapter2.SelectCommand.Parameters["@Id_Emp"].Value = this.ReportParameters["Id_Emp"].Value; this.sqlDataAdapter2.SelectCommand.Parameters["@Id_Cd"].Value = this.ReportParameters["Id_Cd"].Value; this.sqlDataAdapter2.SelectCommand.Parameters["@Id_Acs"].Value = this.ReportParameters["Id_Acs"].Value; this.sqlDataAdapter3.SelectCommand.Parameters["@Id_Emp"].Value = this.ReportParameters["Id_Emp"].Value; this.sqlDataAdapter3.SelectCommand.Parameters["@Id_Cd"].Value = this.ReportParameters["Id_Cd"].Value; this.sqlDataAdapter3.SelectCommand.Parameters["@Id_Acs"].Value = this.ReportParameters["Id_Acs"].Value; this.sqlDataAdapter4.SelectCommand.Parameters["@Id_Emp"].Value = this.ReportParameters["Id_Emp"].Value; this.sqlDataAdapter4.SelectCommand.Parameters["@Id_Cd"].Value = this.ReportParameters["Id_Cd"].Value; this.sqlDataAdapter4.SelectCommand.Parameters["@Id_Acs"].Value = this.ReportParameters["Id_Acs"].Value; this.sqlDataAdapter5.SelectCommand.Parameters["@Id_Emp"].Value = this.ReportParameters["Id_Emp"].Value; this.sqlDataAdapter5.SelectCommand.Parameters["@Id_Cd"].Value = this.ReportParameters["Id_Cd"].Value; this.sqlDataAdapter5.SelectCommand.Parameters["@Id_Acs"].Value = this.ReportParameters["Id_Acs"].Value; //Take the Telerik.Reporting.Processing.Report instance and set the adapter as it's DataSource Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender; report.DataSource = this.sqlDataAdapter1; // --------------------------------------------------------------------------------------------- // Si se asigno correctamente el origen de datos, se actualiza el estatus de la orden de compra // --------------------------------------------------------------------------------------------- //actualiza estatus de orden de compra a Impreso (I) CN_CapAcys cn_capacys = new CN_CapAcys(); Acys acys = new Acys(); acys.Id_Emp = (int)ReportParameters["Id_Emp"].Value; acys.Id_Cd = (int)ReportParameters["Id_Cd"].Value; acys.Id_Acs = (int)ReportParameters["Id_Acs"].Value; acys.Acs_Estatus = "I"; int verificador = 0; cn_capacys.Imprimir(acys, ReportParameters["Conexion"].Value.ToString(), ref verificador); }
private int CambiarEstatus(int Id_Acs, string estatus) { try { Sesion session = new Sesion(); session = (Sesion)Session["Sesion" + Session.SessionID]; CN_CapAcys cn_acys = new CN_CapAcys(); Acys acys = new Acys(); acys.Id_Emp = session.Id_Emp; acys.Id_Cd = session.Id_Cd_Ver; acys.Id_Acs = Id_Acs; acys.Acs_Estatus = estatus; int verificador = -1; cn_acys.actualizarEstatus(acys, session.Emp_Cnx, ref verificador); return(verificador); } catch (Exception ex) { throw ex; } }
protected void rtb1_ButtonClick(object sender, RadToolBarEventArgs e) { try { int Id_Prd_Original = Convert.ToInt32(Request.QueryString["Id_Prd"]); int Id_Prd = 0; int Cantidad = 0; double precio = 0; string Acs_Doc = ""; string Acs_Dia = ""; string Acs_DiaStr = ""; DateTime rdFechaF = default(DateTime); DataRow[] Ar_dr = dt.Select("Id_Prd='" + Id_Prd_Original + "'"); if (Ar_dr.Length > 0) { Acs_Doc = Ar_dr[0]["Acs_Doc"].ToString(); Acs_Dia = Ar_dr[0]["Acs_Dia"].ToString(); Acs_DiaStr = Ar_dr[0]["Acs_DiaStr"].ToString(); try { rdFechaF = Convert.ToDateTime(Ar_dr[0]["Acs_FechaF"]); } catch (Exception) { } //Ar_dr[0].Delete(); //dt.AcceptChanges(); } int contador = 0; string cantidad = ""; for (int x = 0; x < RadGrid1.Items.Count; x++) { cantidad = (RadGrid1.Items[x].FindControl("txtCantidad") as RadNumericTextBox).Text; if (cantidad != "0" && cantidad != "") { Cantidad = Convert.ToInt32((RadGrid1.Items[x].FindControl("txtCantidad") as RadNumericTextBox).Text); Id_Prd = Convert.ToInt32((RadGrid1.Items[x].FindControl("lblId") as Label).Text); precio = (RadGrid1.Items[x].FindControl("txtPrecio") as RadNumericTextBox).Text == "" ? 0 : Convert.ToDouble((RadGrid1.Items[x].FindControl("txtPrecio") as RadNumericTextBox).Text); Sesion sesion = (Sesion)Session["Sesion" + Session.SessionID]; CN_CatProducto cn_catproducto = new CN_CatProducto(); Producto pr = new Producto(); cn_catproducto.ConsultaProducto(ref pr, sesion.Emp_Cnx, sesion.Id_Emp, sesion.Id_Cd_Ver, Id_Prd); string Id_Cte = Request.QueryString["Id_Cte"].ToString(); cn_catproducto.ConsultarVentas(ref pr, Convert.ToInt32(Id_Cte), sesion.Emp_Cnx); dt.Rows.Add(new object[] { -1, Id_Prd, pr.Prd_Descripcion, pr.Prd_Presentacion, pr.Prd_UniNs, pr.ventaMes[0], pr.ventaMes[1], pr.ventaMes[2], Cantidad, precio, precio, Cantidad * precio, Acs_Doc, rdFechaF, 0, Acs_Dia, Acs_DiaStr, 0, 0, 0 }); CN_CapAcys cn_acys = new CN_CapAcys(); cn_acys.ModificarEquivalencia(Id_Prd, Id_Prd_Original, Request.QueryString["Id_Acs"].ToString(), sesion.Id_Emp, sesion.Id_Cd_Ver, sesion.Emp_Cnx); contador++; } if (Ar_dr.Length > 0 && contador > 0) { Ar_dr[0].Delete(); dt.AcceptChanges(); } } CerrarVentana(""); list = null; } catch (Exception) { throw; } }
protected void rg_ItemCommand(object source, GridCommandEventArgs e) { try { Sesion session2 = new Sesion(); session2 = (Sesion)Session["Sesion" + Session.SessionID]; DateTime fechaPeriodoInicio = session2.CalendarioIni; DateTime fechaPeriodoFinal = session2.CalendarioFin; GridItem gi = e.Item; List <string> statusPosibles; switch (e.CommandName) { case "Imprimir": statusPosibles = new List <string>() { "C", "I" }; if (!statusPosibles.Contains(gi.Cells[3].Text.ToUpper())) { Alerta("El acuerdo se encuentra en estatus no válido para realizar la impresión"); e.Canceled = true; return; } Imprimir(gi.Cells[2].Text.ToUpper()); break; case "Cancelar": if (gi.Cells[3].Text == "B") { Alerta("El acuerdo se encuentra en estatus no válido para realizar la cancelación"); e.Canceled = true; return; } int verificador = -1; CN_CapAcys cn_capacys = new CN_CapAcys(); Acys acys = new Acys(); acys.Id_Emp = sesion.Id_Emp; acys.Id_Cd = sesion.Id_Cd_Ver; acys.Id_Acs = Convert.ToInt32(gi.Cells[2].Text); cn_capacys.Cancelar(acys, sesion.Emp_Cnx, ref verificador); if (verificador == 1) { rgAcuerdo.Rebind(); } else { Alerta("Ocurrió un error al intentar cancelar el acuerdo"); } break; case "Editar": statusPosibles = new List <string>() { "C", "I" }; if (!statusPosibles.Contains(gi.Cells[3].Text.ToUpper())) { //Alerta("El acuerdo se encuentra en estatus no válido para realizar la modificación"); RAM1.ResponseScripts.Add("OpenAlert('El acuerdo se encuentra en estatus no válido para realizar la modificación','" + gi.Cells[2].Text + "','" + false + "','" + false + "','" + false + "','" + false + "')"); e.Canceled = true; return; } RAM1.ResponseScripts.Add("return AbrirVentana_Acys('" + gi.Cells[2].Text + "',0)"); break; case "Enviar": if (gi.Cells[3].Text.ToString().ToLower() == "i") { EnviaEmail(Convert.ToInt32(gi.Cells[2].Text)); } else { Alerta("La solicitud se encuentra en estatus no válido para su envio"); } break; case "Renovar": renovar(gi); break; case "Autorizar": autorizar(gi); break; } } catch (Exception ex) { ErrorManager(ex, new System.Diagnostics.StackTrace().GetFrame(0).GetMethod().Name); } }