public PantallaGerencial() { InitializeComponent(); cta = new CADINDataSetTableAdapters.CasoTableAdapter(); ata3 = new CADINDataSetTableAdapters.Actividades3TableAdapter(); s1 = new BindingSource(); s2 = new BindingSource(); cdt = cta.GetData(); s1.DataSource = cdt; s2.DataSource = adt3; llenarActividades(); String q = "SELECT COUNT(*) FROM Caso"; SqlCommand comand; comand = new SqlCommand(q, cta.Connection); comand.Connection.Open(); comand.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(q, cta.Connection); SqlCommandBuilder builder = new SqlCommandBuilder(da); DataTable table = new DataTable(); da.Fill(table); System.Data.DataRow row = table.Rows[0]; txtotal.Text = row.ItemArray.GetValue(0).ToString(); comand.Connection.Close(); }
public Casos_View(int codigo) { InitializeComponent(); this.codigo = codigo; tableAdapterCaso = new CADINDataSetTableAdapters.CasoTableAdapter(); dataTableCaso = new CADINDataSet.CasoDataTable(); dataTableCaso=tableAdapterCaso.GetDataByEmpresa(codigo); this.dataGridViewX1.DataSource = dataTableCaso; this.dataGridViewX1.Columns[1].Visible = false; }
public Caso(Usuario u) { InitializeComponent(); this.u = u; cta = new CADINDataSetTableAdapters.CasoTableAdapter(); ata = new CADINDataSetTableAdapters.ActividadesTableAdapter(); ata2 = new CADINDataSetTableAdapters.Actividades2TableAdapter(); eta = new CADINDataSetTableAdapters.EmpresaTableAdapter(); s1 = new BindingSource(); s2 = new BindingSource(); cdt = cta.GetData(); adt = ata.GetData(); s1.DataSource = cdt; s2.DataSource = adt; if (s1.Position != -1) { txcod_Caso.DataBindings.Add("Text", s1, "cod_caso"); txCod_empr.DataBindings.Add("Text", s1, "cod_empr"); txNomb_solic.DataBindings.Add("Text", s1, "pers_solic"); txCargo.DataBindings.Add("Text", s1, "carg_pers_solic"); ipFech_soli.DataBindings.Add("Text", s1, "fech_solic"); txDesc_prob.DataBindings.Add("Text", s1, "desc_soli"); txDesc_solu.DataBindings.Add("Text", s1, "desc_solu"); if (s1.Position != -1) sliderNiv_solu.DataBindings.Add("Value", s1, "nive_solu"); if (s1.Position != -1) ckbCaso_cerr.DataBindings.Add("Checked", s1, "caso_cerrado"); txObservaciones.DataBindings.Add("Text", s1, "observaciones"); txCod_resp.DataBindings.Add("Text", s1, "cod_func_asig"); txResp_Caso.DataBindings.Add("Text", s1, "nomb_func_asig"); ipFech_solu.DataBindings.Add("Text", s1, "fech_solf"); dataGridViewX1.DataSource = s2; if (u.Admin) { chkbAdm.Visible = true; if (s1.Position != -1) chkbAdm.DataBindings.Add("Checked", s1, "caso_cerrado"); } s1.MoveFirst(); cargarNE1(); llenarActividades(); Cancelar(); } else { MessageBox.Show("No hay registros guardados"); Nuevo(); } }
public Actividades(bool modo2, System.Data.DataRow s, int cod_Usuario, int cod_caso) { InitializeComponent(); cta = new CADINDataSetTableAdapters.CasoTableAdapter(); ata = new CADINDataSetTableAdapters.ActividadesTableAdapter(); sata = new CADINDataSetTableAdapters.Solicitud_ApoyoTableAdapter(); tata = new CADINDataSetTableAdapters.Tipo_ActividadTableAdapter(); s2 = new BindingSource(); s3 = new BindingSource(); s4 = new BindingSource(); adt = ata.GetData(); sadt = sata.GetData(); tadt = tata.GetData(); s2.DataSource = adt; //s2.DataSource = s; s3.DataSource = sadt; s4.DataSource = tadt; cbTipSolic.DataSource = s3; cbTipSolic.DisplayMember = "nombre"; cbTipSolic.ValueMember = "cod_soli"; cbTipoAct.DataSource = s4; cbTipoAct.DisplayMember = "nombre"; cbTipoAct.ValueMember = "cod_tact"; cfa = cod_Usuario; c_caso = cod_caso; if ((modo2 == false) && (Convert.ToInt32(s["cod_actv"].ToString()) == -1)) modo2 = true; else { if (modo2 == true) { limpiarControles(); } else { btnAgregarAct.Visible = false; btnCambiosAct.Visible = true; ca = Convert.ToInt32(s["cod_actv"].ToString()); cc = Convert.ToInt32(s["cod_caso"].ToString()); ipFechProg.Value = Convert.ToDateTime(s["fech_prog"].ToString()); //ipFechProg.DataBindings.Add("Value", s2, "fech_prog"); chkbRealizado.Checked = Convert.ToBoolean(s["realizado"].ToString()); //chkbRealizado.DataBinding.Add("Checked", s2, "realizado"); chkbActCerrada.Checked = Convert.ToBoolean(s["acti_cerrada"].ToString()); //chkbActCerrada.DataBindings.Add("Checked", s2, "acti_cerrada"); string fecha = s["fech_cierre"].ToString(); if (fecha == "") { ipFechCierre.IsEmpty = true; } else { ipFechCierre.Value = Convert.ToDateTime(fecha); } //ipFechCierre.DataBindings.Add("Value", s2, "fech_cierre"); txRef.Text = s["referencia"].ToString(); //txRef.DataBindings.Add("Text", s2, "referencia"); txObservacionesA.Text = s["observaciones"].ToString(); //txObservacionesA.DataBindings.Add("Text", s2, "observaciones"); cbTipoAct.SelectedValue = Convert.ToInt32(s["cod_tact"].ToString()); //cbTipoAct.DataBindings.Add("SelectedValue", s2, "cod_tact"); cbTipSolic.SelectedValue = Convert.ToInt32(s["cod_soli"].ToString()); //cbTipSolic.DataBindings.Add("SelectedValue", s2, "cod_soli"); } } }