public void ModificarPronosticoCierre(PronCierre pronCierre, Sesion sesion, ref int validador) { try { CD_CierreMes cd_cierremes = new CD_CierreMes(); cd_cierremes.ModificarPronosticoCierre(pronCierre, sesion, ref validador); } catch (Exception ex) { throw ex; } }
public void CierreGrid(Sesion sesion, ref List <PronCierre> listProCierre) { try { SqlDataReader dr = null; CapaDatos.CD_Datos CapaDatos = new CapaDatos.CD_Datos(sesion.Emp_Cnx); string[] Parametros = { "@Id_Emp", "@Id_Cd", "@Id_Rik" }; object[] Valores = { sesion.Id_Emp, sesion.Id_Cd, sesion.Id_Rik }; SqlCommand sqlcmd = CapaDatos.GenerarSqlCommand("spPronosticoCierre_Consulta", ref dr, Parametros, Valores); PronCierre proCierre; while (dr.Read()) { proCierre = new PronCierre(); proCierre.Id_ProCierre = (int)dr.GetValue(dr.GetOrdinal("Id_ProCierre")); proCierre.Id_Cte = (int)dr.GetValue(dr.GetOrdinal("Id_Cte")); proCierre.Cte_NomComercial = (string)dr.GetValue(dr.GetOrdinal("Cte_NomComercial")); proCierre.Id_Ter = (int)dr.GetValue(dr.GetOrdinal("Id_Ter")); proCierre.Ter_Nombre = (string)dr.GetValue(dr.GetOrdinal("Ter_Nombre")); proCierre.Id_Rik = (int)dr.GetValue(dr.GetOrdinal("Id_Rik")); proCierre.Autorizado = dr.GetValue(dr.GetOrdinal("Estatus")).ToString().ToUpper() == "A" ? true : false; proCierre.Pron_Actual = !string.IsNullOrEmpty(dr.GetValue(dr.GetOrdinal("Pron_Actual")).ToString()) ? (double)dr.GetValue(dr.GetOrdinal("Pron_Actual")) : 0.00; proCierre.Pron_Anterior = (double)dr.GetValue(dr.GetOrdinal("Pron_Anterior")); listProCierre.Add(proCierre); } CapaDatos.LimpiarSqlcommand(ref sqlcmd); } catch (Exception ex) { throw ex; } }
private void soloLectura() { try { for (int i = 0; i < this.RadGrid1.Items.Count; i++) { PronCierre pronCierre = new PronCierre(); RadNumericTextBox RadNumericTextBox1 = new RadNumericTextBox(); RadNumericTextBox1 = (RadNumericTextBox)this.RadGrid1.Items[i].Cells[6].FindControl("RadNumericTextBox1"); pronCierre.Id_ProCierre = Convert.ToInt32(RadGrid1.Items[i]["Id_ProCierre"].Text); pronCierre.Pron_Actual = RadNumericTextBox1.Value.HasValue ? Convert.ToDouble(RadNumericTextBox1.Value.Value) : 0; if (pronCierre.Pron_Actual != 0) { RadNumericTextBox1.Enabled = false; } } } catch (Exception ex) { throw ex; } }
public void ModificarPronosticoCierre(PronCierre pronCierre, Sesion sesion, ref int validador) { try { CapaDatos.CD_Datos CapaDatos = new CapaDatos.CD_Datos(sesion.Emp_Cnx); string[] Parametros = { "@Id_Emp", "@Id_Cd", "@Id_Rik", "@Id_ProCierre", "@Id_Ter", "@Id_Cte", "@Pron_Anterior", "@Pron_Actual" }; object[] Valores = { pronCierre.Id_Emp, pronCierre.Id_Cd, pronCierre.Id_Rik, pronCierre.Id_ProCierre, pronCierre.Id_Ter, pronCierre.Id_Cte, pronCierre.Pron_Anterior, pronCierre.Pron_Actual }; SqlCommand sqlcmd = CapaDatos.GenerarSqlCommand("spRepPronosticoCierre_Modificar", ref validador, Parametros, Valores); CapaDatos.LimpiarSqlcommand(ref sqlcmd); } catch (Exception ex) { throw ex; } }
private void GuardarCampos(ref int validador) { try { Sesion Sesion = new Sesion(); Sesion = (Sesion)Session["Sesion" + Session.SessionID]; if (Sesion != null) { if (RadGrid1.Items.Count > 0) { int revision = 0; for (int i = 0; i < this.RadGrid1.Items.Count; i++) { revision = 0; PronCierre pronCierre = new PronCierre(); RadNumericTextBox txtPron_Actual = new RadNumericTextBox(); txtPron_Actual = (RadNumericTextBox)this.RadGrid1.Items[i].Cells[6].FindControl("RadNumericTextBox1"); pronCierre.Pron_Actual = txtPron_Actual.Value.HasValue ? Convert.ToDouble(txtPron_Actual.Value.Value) : 0; if (pronCierre.Pron_Actual == 0) { Alerta("Existen clientes sin pronóstico de cierre"); revision = 1; return; } else { if (pronCierre.Pron_Actual < 0) { Alerta("Los pronóstico no deben ser negativos"); revision = 1; return; } } } if (revision == 0) { for (int i = 0; i < this.RadGrid1.Items.Count; i++) { validador = 0; PronCierre pronCierre = new PronCierre(); RadNumericTextBox txtPron_Actual = new RadNumericTextBox(); txtPron_Actual = (RadNumericTextBox)this.RadGrid1.Items[i].Cells[6].FindControl("RadNumericTextBox1"); pronCierre.Id_Emp = Sesion.Id_Emp; pronCierre.Id_Cd = Sesion.Id_Cd_Ver; pronCierre.Id_Rik = Sesion.Id_Rik; pronCierre.Id_ProCierre = Convert.ToInt32(RadGrid1.Items[i]["Id_ProCierre"].Text); pronCierre.Id_Cte = Convert.ToInt32(RadGrid1.Items[i]["Id_Cte"].Text); pronCierre.Id_Ter = Convert.ToInt32(RadGrid1.Items[i]["Id_Ter"].Text); pronCierre.Pron_Anterior = Convert.ToDouble(RadGrid1.Items[i]["Pron_Anterior"].Text); pronCierre.Pron_Actual = txtPron_Actual.Value.HasValue ? Convert.ToDouble(txtPron_Actual.Value.Value) : 0; CN_ProCierreMes proCierre = new CN_ProCierreMes(); proCierre.ModificarPronosticoCierre(pronCierre, Sesion, ref validador); } } else { validador = 0; } } else { validador = 1; } } } catch (Exception ex) { throw ex; } }