/// <summary> /// Handles invocation of RowClick events /// </summary> internal bool DoRowClickEvent(GridRow row, RowArea rowArea, MouseEventArgs e) { if (RowClick != null) { GridRowClickEventArgs ev = new GridRowClickEventArgs(row.GridPanel, row, rowArea, e); RowClick(this, ev); return (ev.Cancel); } return (false); }
private void sgc_receta_RowClick(object sender, GridRowClickEventArgs e) { sgc_receta.PrimaryGrid.GridPanel.GetSelectedRows().GetCells(); }
private void sgc_prod_RowClick(object sender, GridRowClickEventArgs e) { List<GridCell> row = sgc_prod.PrimaryGrid.GridPanel.GetSelectedRows().GetCells(); if (row.Count != 0) { id_prod = row[0].Value.ToString(); cb_cat.SelectedIndex = obtenerIndice(row[1].Value,cb_cat); tb_nombre.Text = row[2].Value.ToString(); tb_desc.Text = row[3].Value.ToString(); tb_precio.Text = row[4].Value.ToString(); tb_sact.Text = row[5].Value.ToString(); tb_smin.Text = row[6].Value.ToString(); tb_smax.Text = row[7].Value.ToString(); cb_unidad.SelectedIndex = obtenerIndice(row[9].Value, cb_unidad); ruta_imagen = row[10].Value.ToString().Replace("|", "\\"); pb_carga.ImageLocation = Path.Combine(Application.StartupPath, ruta_imagen); } }
private void sgc_mp_RowClick(object sender, DevComponents.DotNetBar.SuperGrid.GridRowClickEventArgs e) { List <GridCell> row = sgc_mp.PrimaryGrid.GridPanel.GetSelectedRows().GetCells(); if (row.Count != 0) { tb_id.Text = row[0].Value.ToString(); tb_id_prov.Text = row[1].Value.ToString(); tb_rz.Text = row[2].Value.ToString(); tb_nombre.Text = row[3].Value.ToString(); tb_desc.Text = row[4].Value.ToString(); tb_precio.Text = row[5].Value.ToString(); tb_sact.Text = row[6].Value.ToString(); tb_smin.Text = row[7].Value.ToString(); tb_smax.Text = row[8].Value.ToString(); if (row[9].Value.ToString().CompareTo("Litros") == 0) { cb_unidad.SelectedIndex = 0; } else { cb_unidad.SelectedIndex = 1; } } }
private void sgc_cli_RowClick(object sender, DevComponents.DotNetBar.SuperGrid.GridRowClickEventArgs e) { List <GridCell> row = sgc_cli.PrimaryGrid.GridPanel.GetSelectedRows().GetCells(); if (row.Count != 0) { tb_id.Text = row[0].Value.ToString(); tb_rs.Text = row[1].Value.ToString(); tb_rfc.Text = row[2].Value.ToString(); tb_ciudad.Text = row[3].Value.ToString(); tb_cp.Text = row[4].Value.ToString(); tb_direccion.Text = row[5].Value.ToString(); tb_tel.Text = row[6].Value.ToString(); tb_email.Text = row[7].Value.ToString(); } }
/// <summary> /// 收款-列表行单击触发事件 /// Created:20170330(ChengMengjia) /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void gridSK_RowClick(object sender, DevComponents.DotNetBar.SuperGrid.GridRowClickEventArgs e) { DevComponents.DotNetBar.SuperGrid.GridElement list = gridSK.GetSelectedRows()[0]; string s = list.ToString(); s = s.Replace("{", ","); s = s.Replace("}", ","); string[] listS = s.Split(','); txtSBatchNo.Tag = listS[1].Trim(); txtSBatchNo.Text = listS[3].Trim(); txtExplanation.Text = listS[4] == "<null>" ? "" : listS[4].Trim(); intSRatio.Value = listS[5] == "<null>" ? 0 : int.Parse(listS[5].Trim()); txtAmount.Text = listS[6] == "<null>" ? "0" : listS[6].Trim(); txtSCondition.Text = listS[7] == "<null>" ? "" : listS[7].Trim(); dtSInDate.Value = listS[9] == "<null>" ? DateTime.Now : DateTime.Parse(listS[9].Trim()); DataHelper.SetComboBoxSelectItemByText(cbSFinishStatus, listS[8] == "<null>" ? "-1" : listS[8].Trim()); txtSRemark.Text = listS[10] == "<null>" ? "" : listS[10].Trim(); }
/// <summary> /// 时间变更列表行点击事件 /// 2017/04/18(zhuguanjun) /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void superDate_RowClick(object sender, DevComponents.DotNetBar.SuperGrid.GridRowClickEventArgs e) { var rows = superDate.PrimaryGrid.GetSelectedRows(); if (rows.Count != 1) { MessageBox.Show("请选择一行"); superDate.PrimaryGrid.ClearSelectedColumns(); return; } btnClearFile_Click(null, null); GridRow row = (GridRow)rows[0]; DomainDLL.Change change = new DomainDLL.Change(); DataTable files = new DataTable(); bll.GetChangeInfo(row.Cells["ID"].Value.ToString(), out change, out files); CHANGEDATEID = row.Cells["ID"].Value.ToString(); if (change != null) { txtCost.Text = change.Cost; txtName.Text = change.Name; txtPayment.Text = change.Payment; txtReason.Text = change.Reason; string[] temp = change.AfterInfo.Split('-'); if (temp != null && temp.Count() == 2) { dtiAfter1.Value = Convert.ToDateTime(temp[0]); dtiAfter2.Value = Convert.ToDateTime(temp[1]); } string[] tempb = change.BeforeInfo.Split('-'); if (tempb != null && tempb.Count() == 2) { dtiBefore1.Value = Convert.ToDateTime(tempb[0]); dtiBefore2.Value = Convert.ToDateTime(tempb[1]); } _changedateid = change.ID;//实际id } superGridControl1.PrimaryGrid.DataSource = files; }
/// <summary> /// Grid点击事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void superGridControl1_RowClick(object sender, DevComponents.DotNetBar.SuperGrid.GridRowClickEventArgs e) { var rows = superGridControl1.PrimaryGrid.GetSelectedRows(); if (rows.Count != 1) { MessageBox.Show("请选择一行"); superGridControl1.PrimaryGrid.ClearSelectedColumns(); return; } GridRow row = (GridRow)rows[0]; txtAddr.Text = row.Cells["Addr"].Value.ToString(); txtLegalMan.Text = row.Cells["LegalMan"].Value.ToString(); txtManager.Text = row.Cells["Manager"].Value.ToString(); txtName.Text = row.Cells["Name"].Value.ToString(); txtTel.Text = row.Cells["Tel"].Value.ToString(); ZGZ = row.Cells["PathZGZ"].Value.ToString(); YYZZ = row.Cells["PathYYZZ"].Value.ToString(); DMZ = row.Cells["PathDMZ"].Value.ToString(); ID = row.Cells["ID"].Value.ToString(); dtiCREATED.Value = Convert.ToDateTime(row.Cells["CREATED"].Value.ToString()); LoadFile(); }
private void sgrid_tratamientos_RowClick(object sender, GridRowClickEventArgs e) { GridRow tupla = (GridRow)sgrid_tratamientos.ActiveRow; if (tupla != null) { desc_esp_t.Text = tupla.Cells[2].Value.ToString(); SC.llena_detalle("MXTC", tupla[0].Value.ToString(), sgrid_det_med); } }
private void sgrid_sus_RowClick(object sender, GridRowClickEventArgs e) { GridRow tupla = (GridRow)sgrid_sus.ActiveRow; if (tupla != null) { indicaciones_hist.Text = tupla.Cells[6].Value.ToString(); SC.llena_detalle("MXRF", tupla[0].Value.ToString(), sgrid_det_medrec); } }
private void sgrid_pr_RowClick(object sender, GridRowClickEventArgs e) { GridRow tupla = (GridRow)e.GridRow; if (tupla != null) { GridCellCollection celdas = tupla.Cells; String codigo = celdas[2].Value.ToString(); String consultorio = celdas[1].Value.ToString(); //sgrid_pr.PrimaryGrid.Rows.Clear(); if (codigo != "") SC.llena_detalle_tratamiento(codigo, consultorio, sgrid_mr, sgrid_rmtos); else mensaje_error("Antes de editar una receta debe\nasignar un tratamiento al paciente."); } }
//Interfaz citas private void sgrid_pc_RowClick(object sender, GridRowClickEventArgs e) { boton_si.Enabled = boton_no.Enabled = false; }
private void gCompanies_RowClick(object sender, GridRowClickEventArgs e) { if (e.MouseEventArgs.Button == MouseButtons.Right) { Point pos = gCompanies.PointToClient(Cursor.Position); mCompanies.Show(gCompanies, pos); } else if (e.MouseEventArgs.Button == MouseButtons.Left) { if (e.GridRow.RowIndex > -1 && e.MouseEventArgs.Button == MouseButtons.Left) { GridElement row = gCompanies.PrimaryGrid.Rows[e.GridRow.RowIndex]; Program.DB.AddParameter("ID", row.Tag); DataSet c = Program.DB.SelectAll("SELECT * FROM Companies WHERE ID=@ID;"); if (c.Tables.Count > 0 && c.Tables[0].Rows.Count > 0) { SharedData.iCompanyID = Convert.ToInt32(c.Tables[0].Rows[0]["ID"]); txtCompanyName.Text = c.Tables[0].Rows[0]["Name"].ToString(); txtCompanyTrading.Text = c.Tables[0].Rows[0]["TradingAs"].ToString(); txtCompanyReg.Text = c.Tables[0].Rows[0]["RegNumber"].ToString(); txtCompanyRegVat.Text = c.Tables[0].Rows[0]["RegNumberVat"].ToString(); txtCompanyPhone.Text = c.Tables[0].Rows[0]["Phones"].ToString(); txtCompanyEmail.Text = c.Tables[0].Rows[0]["Emails"].ToString(); txtCompanyAddress.Text = c.Tables[0].Rows[0]["Addresses"].ToString(); txtCompanyNotes.Text = c.Tables[0].Rows[0]["Notes"].ToString(); if (c.Tables[0].Rows[0]["Contacts"].ToString().Trim().Length > 0) { AutoCompleteStringCollection asContacts = new AutoCompleteStringCollection(); DataSet t = Program.DB.SelectAll("SELECT NameFirst,NameLast FROM Contacts WHERE ID IN (" + c.Tables[0].Rows[0]["Contacts"].ToString() + ");"); if (t.Tables.Count > 0 && t.Tables[0].Rows.Count > 0) { foreach (DataRow r in t.Tables[0].Rows) { asContacts.Add(r["NameFirst"].ToString() + " " + r["NameLast"].ToString()); } } txtCompanyContact.AutoCompleteCustomSource = asContacts; } } } } }
private void gComments_RowClick(object sender, GridRowClickEventArgs e) { if (e.MouseEventArgs.Button == MouseButtons.Right) { Point pos = gComments.PointToClient(Cursor.Position); mComments.Show(gComments, pos); } else if (e.MouseEventArgs.Button == MouseButtons.Left) { if (rComment != null && e.MouseEventArgs.Button == MouseButtons.Left) { txtComment.Text = rComment.Cells[2].Value.ToString(); } } }
private void g_RowClick(object sender, GridRowClickEventArgs e) { if (e.MouseEventArgs.Button == MouseButtons.Right) { Point pos = g.PointToClient(Cursor.Position); m.Show(g, pos); } else if (e.MouseEventArgs.Button == MouseButtons.Left) { if (e.GridRow.RowIndex > -1 && e.MouseEventArgs.Button == MouseButtons.Left) { iID = Convert.ToInt32(g.PrimaryGrid.Rows[e.GridRow.RowIndex].Tag); Program.DB.AddParameter("ID", iID); DataSet d = Program.DB.SelectAll("SELECT * FROM WorkSheets WHERE ID=@ID;"); if (d.Tables.Count > 0 && d.Tables[0].Rows.Count > 0) { DataRow r = d.Tables[0].Rows[0]; txtName.Text = r["Name"].ToString(); dtFrom.Text = Convert.ToDateTime(r["Start"].ToString()).ToShortDateString(); dtTo.Text = Convert.ToDateTime(r["Finish"].ToString()).ToShortDateString(); string[] sRooms = r["Rooms"].ToString().Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); foreach (TreeNode n in tv.Nodes) { n.Checked = false; if (sRooms.Contains(n.Tag.ToString())) { n.Checked = true; if (n.Nodes.Count > 0) { foreach (TreeNode nc in n.Nodes) { nc.Checked = false; if (sRooms.Contains(nc.Tag.ToString())) { nc.Checked = true; } } } } } } } } }
/// <summary> /// 选中一行 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void superGridControl1_RowClick(object sender, DevComponents.DotNetBar.SuperGrid.GridRowClickEventArgs e) { txtDependency.Clear(); foreach (var node in advTree1.CheckedNodes) { node.Checked = false; } var rows = superGridControl1.PrimaryGrid.GetSelectedRows(); if (rows.Count != 1) { MessageBox.Show("请选择一行"); superGridControl1.PrimaryGrid.ClearSelectedColumns(); return; } GridRow row = (GridRow)rows[0]; cmbtSource.SelectedIndex = -1; cmbtDepenency.SelectedIndex = -1; //识别风险 //来源 if (!string.IsNullOrEmpty(row.Cells["Source"].Value.ToString())) { DataHelper.SetTreeSelectByValue(cmbtSource.AdvTree, row.Cells["Source"].Value.ToString()); } txtName.Text = row.Cells["Name"].Value.ToString(); txtDesc.Text = row.Cells["Desc"].Value.ToString(); if (!string.IsNullOrEmpty(row.Cells["FindDate"].Value.ToString())) { dtiFindDate.Value = Convert.ToDateTime(row.Cells["FindDate"].Value.ToString()); } //评估风险 txtCostTime.Text = row.Cells["CostTime"].Value.ToString(); string select = string.IsNullOrEmpty(row.Cells["Probability2"].Value.ToString()) ? "0" : row.Cells["Probability2"].Value.ToString(); DataHelper.SetComboBoxSelectItemByValue(cmbProbability, select); string select1 = string.IsNullOrEmpty(row.Cells["Level2"].Value.ToString()) ? "0" : row.Cells["Level2"].Value.ToString(); DataHelper.SetComboBoxSelectItemByValue(cmbLevel, select1); //依赖关系 if (!string.IsNullOrEmpty(row.Cells["Dependency"].Value.ToString())) { string[] str = row.Cells["Dependency"].Value.ToString().Split(','); DataHelper.SetAdvTreeData(this.advTree1, ProjectId, 0, str); string text = ""; //显示值 string vall = ""; //实际值 txtDependency.Clear(); foreach (dynamic node in advTree1.Nodes) { if (node.Checked) { text += node.Text + ","; vall += node.Name + ","; } nodetext(node, text, vall); } this.txtDependency.Text = text; this.txtDependency.Tag = vall; } //DataHelper.SetTreeSelectByValue(cmbtDepenency.AdvTree, row.Cells["Dependency"].Value.ToString()); txtAcessDesc.Text = row.Cells["AssessDesc"].Value.ToString(); if (!string.IsNullOrEmpty(row.Cells["AssessDate"].Value.ToString())) { dtiAccessDesc.Value = Convert.ToDateTime(row.Cells["AssessDate"].Value.ToString()); } //应对风险 string select2 = string.IsNullOrEmpty(row.Cells["HandleType2"].Value.ToString()) ? "0" : row.Cells["HandleType2"].Value.ToString(); DataHelper.SetComboBoxSelectItemByValue(cmbHandleType, select2); txtHandleDesc.Text = row.Cells["HandleDesc"].Value.ToString(); if (!string.IsNullOrEmpty(row.Cells["HandleDate"].Value.ToString())) { dtiHandleDate.Value = Convert.ToDateTime(row.Cells["HandleDate"].Value.ToString()); } ID = row.Cells["ID"].Value.ToString(); if (!string.IsNullOrEmpty(row.Cells["CREATED"].Value.ToString())) { CREATED = Convert.ToDateTime(row.Cells["CREATED"].Value.ToString()); } }
/// <summary> /// 行点击 /// 2017/05/08(zhuguanjun) /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void superGridControl1_RowClick(object sender, DevComponents.DotNetBar.SuperGrid.GridRowClickEventArgs e) { }
private void gItems_RowClick(object sender, GridRowClickEventArgs e) { if (e.MouseEventArgs.Button == MouseButtons.Right) { Point pos = gItems.PointToClient(Cursor.Position); cmItems.Show(gItems, pos); } else if (e.MouseEventArgs.Button == MouseButtons.Left) { if (e.GridRow.RowIndex > -1 && e.MouseEventArgs.Button == MouseButtons.Left) { iItem = Convert.ToInt32(e.GridRow.Tag); GridElement row = gItems.PrimaryGrid.Rows[e.GridRow.RowIndex]; Program.SQL.AddParameter("@id", row.Tag.ToString()); DataSet d = Program.SQL.SelectAll("SELECT * FROM items WHERE id=@id;"); if (d.Tables.Count > 0 && d.Tables[0].Rows.Count > 0) { DataRow r = d.Tables[0].Rows[0]; txtItemACat.Text = r["atex_category"].ToString(); txtItemAccess.Text = r["access_req"].ToString(); txtItemAGroup.Text = r["area_group"].ToString(); txtItemATRating.Text = r["area_trating"].ToString(); txtItemAZone.Text = r["area_zone"].ToString(); txtItemBarcode.Text = r["barcode"].ToString(); txtItemCableID.Text = r["cableid"].ToString(); txtItemCE.Text = r["ce_number"].ToString(); txtItemDescription.Text = r["description"].ToString(); txtItemDLDrawing.Text = r["drawing_device_loop"].ToString(); txtItemDType.Text = r["type_device"].ToString(); txtItemECert.Text = r["cert_equipment"].ToString(); txtItemIP.Text = r["ip_rating"].ToString(); txtItemMType.Text = r["type_model"].ToString(); txtItemPType.Text = r["type_protection"].ToString(); txtItemSerial.Text = r["serial"].ToString(); txtItemTag.Text = r["tag"].ToString(); txtItemTemp.Text = r["temp_range"].ToString(); txtItemTRating.Text = r["trating"].ToString(); txtItemCPRef.Text = r["cpref"].ToString(); cbxItemAGroup.SelectedIndex = -1; foreach (DevComponents.Editors.ComboItem i in cbxItemAGroup.Items) { if (i.Text == r["atex_group"].ToString()) { cbxItemAGroup.SelectedItem = i; break; } } cbxItemAProt.SelectedIndex = -1; foreach (DevComponents.Editors.ComboItem i in cbxItemAProt.Items) { if (i.Text == r["atex_protection"].ToString()) { cbxItemAProt.SelectedItem = i; break; } } cbxItemBarrier.SelectedIndex = -1; foreach (DevComponents.Editors.ComboItem i in cbxItemBarrier.Items) { if (i.Text == r["barrier"].ToString()) { cbxItemBarrier.SelectedItem = i; break; } } cbxItemDrawing.SelectedIndex = -1; foreach (DevComponents.Editors.ComboItem i in cbxItemDrawing.Items) { if (i.Value.ToString().Equals(r["drawing"].ToString())) { cbxItemDrawing.SelectedItem = i; break; } } cbxItemEGroup.SelectedIndex = -1; foreach (DevComponents.Editors.ComboItem i in cbxItemEGroup.Items) { if (i.Text == r["group_equipment"].ToString()) { cbxItemEGroup.SelectedItem = i; break; } } cbxItemEPL.SelectedIndex = -1; foreach (DevComponents.Editors.ComboItem i in cbxItemEPL.Items) { if (i.Text == r["epl"].ToString()) { cbxItemEPL.SelectedItem = i; break; } } cbxItemEType.SelectedIndex = -1; foreach (DevComponents.Editors.ComboItem i in cbxItemEType.Items) { if (i.Text == r["type_equipment"].ToString()) { cbxItemEType.SelectedItem = i; break; } } cbxItemDrawingHac.SelectedIndex = -1; foreach (DevComponents.Editors.ComboItem i in cbxItemDrawingHac.Items) { if (i.Value.ToString().Equals(r["drawing_hac"].ToString())) { cbxItemDrawingHac.SelectedItem = i; break; } } cbxItemManufacturer.SelectedIndex = -1; foreach (DevComponents.Editors.ComboItem i in cbxItemManufacturer.Items) { if (i.Value.ToString().Equals(r["manufacturer"].ToString())) { cbxItemManufacturer.SelectedItem = i; break; } } cbxItemSuitable.SelectedIndex = -1; foreach (DevComponents.Editors.ComboItem i in cbxItemSuitable.Items) { if (i.Text == r["suitable"].ToString()) { cbxItemSuitable.SelectedItem = i; break; } } cbxItemTraceHC.SelectedIndex = -1; foreach (DevComponents.Editors.ComboItem i in cbxItemTraceHC.Items) { if (i.Value.ToString().Equals(r["tracehc"].ToString())) { cbxItemTraceHC.SelectedItem = i; break; } } } } } }
private void gBookings_RowClick(object sender, GridRowClickEventArgs e) { if (e.MouseEventArgs.Button == MouseButtons.Right) { Point pos = gBookings.PointToClient(Cursor.Position); mBookingsList.Show(gBookings, pos); } else if (e.MouseEventArgs.Button == MouseButtons.Left) { if (e.GridRow.RowIndex > -1 && e.MouseEventArgs.Button == MouseButtons.Left) { SharedData.iBookingID = Convert.ToInt32(gBookings.PrimaryGrid.Rows[e.GridRow.RowIndex].Tag); } } }
private void gEnquiries_RowClick(object sender, GridRowClickEventArgs e) { if (e.MouseEventArgs.Button == MouseButtons.Right) { Point pos = gEnquiries.PointToClient(Cursor.Position); mEnquiries.Show(gEnquiries, pos); } else if (e.MouseEventArgs.Button == MouseButtons.Left) { if (e.GridRow.RowIndex > -1 && e.MouseEventArgs.Button == MouseButtons.Left) { GridElement row = gEnquiries.PrimaryGrid.Rows[e.GridRow.RowIndex]; Program.DB.AddParameter("ID", row.Tag); DataSet c = Program.DB.SelectAll("SELECT * FROM Jobs WHERE ID=@ID;"); if (c.Tables.Count > 0 && c.Tables[0].Rows.Count > 0) { SharedData.iEnquiryID = Convert.ToInt32(c.Tables[0].Rows[0]["ID"]); lblEnquiryNumberVal.Text = SharedData.iEnquiryID.ToString("D6"); txtEnquiryName.Text = c.Tables[0].Rows[0]["EName"].ToString(); txtEnquiryCompany.Text = c.Tables[0].Rows[0]["ECompany"].ToString(); txtEnquiryPhone.Text = c.Tables[0].Rows[0]["EPhone"].ToString(); txtEnquiryEmail.Text = c.Tables[0].Rows[0]["EEmail"].ToString(); txtEnquiryInfo.Text = c.Tables[0].Rows[0]["EInfo"].ToString(); txtEnquiryReferrer.Text = c.Tables[0].Rows[0]["EReferer"].ToString(); txtEnquiryInfoWanted.Text = c.Tables[0].Rows[0]["EInfoWanted"].ToString(); foreach (ComboItem ci in cbxEnquiryType.Items) { if (ci.Text.Equals(c.Tables[0].Rows[0]["EType"])) { cbxEnquiryType.SelectedItem = ci; } } foreach (ListViewItem i in lvEnquiryCourses.Items) { i.Checked = false; } if (lvEnquiryDocs.Items.Count > 0) { lvEnquiryDocs.Clear(); } string sPath = Properties.Settings.Default.PathToData + @"\" + SharedData.iEnquiryID.ToString("D6") + @"\Enquiry"; if (System.IO.Directory.Exists(sPath)) { string[] sFiles = System.IO.Directory.GetFiles(sPath); foreach (string sFile in sFiles) { lvEnquiryDocs.Items.Add(System.IO.Path.GetFileNameWithoutExtension(sFile)); } } } } } }
private void gContacts_RowClick(object sender, GridRowClickEventArgs e) { if (e.MouseEventArgs.Button == MouseButtons.Right) { Point pos = gContacts.PointToClient(Cursor.Position); mContacts.Show(gContacts, pos); } else if (e.MouseEventArgs.Button == MouseButtons.Left) { if (e.GridRow.RowIndex > -1 && e.MouseEventArgs.Button == MouseButtons.Left) { GridElement row = gContacts.PrimaryGrid.Rows[e.GridRow.RowIndex]; Program.DB.AddParameter("ID", row.Tag); DataSet c = Program.DB.SelectAll("SELECT * FROM Contacts WHERE ID=@ID;"); if (c.Tables.Count > 0 && c.Tables[0].Rows.Count > 0) { SharedData.iContactID = Convert.ToInt32(c.Tables[0].Rows[0]["ID"]); txtContactNameTitle.Text = c.Tables[0].Rows[0]["NameTitle"].ToString(); txtContactNameFirst.Text = c.Tables[0].Rows[0]["NameFirst"].ToString(); txtContactNameLast.Text = c.Tables[0].Rows[0]["NameLast"].ToString(); txtContactPhone.Text = c.Tables[0].Rows[0]["Phones"].ToString(); txtContactEmail.Text = c.Tables[0].Rows[0]["Emails"].ToString(); txtContactAddress.Text = c.Tables[0].Rows[0]["Addresses"].ToString(); txtContactNotes.Text = c.Tables[0].Rows[0]["Notes"].ToString(); } } } }
private void gInspections_RowClick(object sender, GridRowClickEventArgs e) { if (e.MouseEventArgs.Button == MouseButtons.Right) { Point pos = gInspections.PointToClient(Cursor.Position); cmInspections.Show(gInspections, pos); } else if (e.MouseEventArgs.Button == MouseButtons.Left) { if (e.GridRow.RowIndex > -1 && e.MouseEventArgs.Button == MouseButtons.Left) { iInspection = Convert.ToInt32(e.GridRow.Tag); GridElement row = gInspections.PrimaryGrid.Rows[e.GridRow.RowIndex]; Program.SQL.AddParameter("@id", row.Tag.ToString()); DataSet d = Program.SQL.SelectAll("SELECT * FROM inspections WHERE id=@id;"); if (d.Tables.Count > 0 && d.Tables[0].Rows.Count > 0) { if (gInspectionAnswers.PrimaryGrid.Rows.Count > 0) { gInspectionAnswers.PrimaryGrid.Rows.Clear(); } DataRow r = d.Tables[0].Rows[0]; txtInspectionWorkOrder.Text = r["workorder"].ToString(); txtInspectionElectrical.Text = r["electrical"].ToString(); txtInspectionMechanical.Text = r["mechanical"].ToString(); txtInspectionComments.Text = r["comments"].ToString(); foreach (DataRow dr in dsItems.Tables[0].Rows) { if (dr["id"].ToString().Equals(r["item"].ToString())) { txtInspectionTag.Text = dr["tag"].ToString().Length > 0 ? dr["tag"].ToString() : (dr["barcode"].ToString().Length > 0 ? dr["barcode"].ToString() : dr["id"].ToString()); break; } } foreach (DevComponents.Editors.ComboItem i in cbxInspectionInspector.Items) { if (i.Value.ToString().Equals(r["inspector"].ToString())) { cbxInspectionInspector.SelectedItem = i; break; } } foreach (DevComponents.Editors.ComboItem i in cbxInspectionSchedule.Items) { if (i.Value.ToString().Equals(r["schedule"].ToString())) { cbxInspectionSchedule.SelectedItem = i; break; } } foreach (DevComponents.Editors.ComboItem i in cbxInspectionPriority.Items) { if (i.Value.ToString().Equals(r["priority"].ToString())) { cbxInspectionPriority.SelectedItem = i; break; } } DataSet st = Program.SQL.SelectAll("SELECT questions FROM schedules WHERE id=" + r["schedule"].ToString() + ";"); if (st.Tables.Count == 1 && st.Tables[0].Rows.Count > 0 && st.Tables[0].Rows[0]["questions"].ToString() != "") { List<string> lQuestions = new List<string>(); string[] sQIDs = st.Tables[0].Rows[0]["questions"].ToString().Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); foreach (string sQ in sQIDs) { string sQuestion = sQ.IndexOf(':') > 0 ? sQ.Substring(0, sQ.IndexOf(':')) : sQ; if (!lQuestions.Contains(sQuestion)) { lQuestions.Add(sQuestion); } } DataSet at = Program.SQL.SelectAll("SELECT id,question,part,answer FROM inspections_answers WHERE inspection=" + iInspection + ";"); DataSet ft = Program.SQL.SelectAll("SELECT id,question,part,fault FROM inspections_faults WHERE inspection=" + iInspection + ";"); DataSet qt = Program.SQL.SelectAll("SELECT id,section,letter,number,question,parts FROM schedules_questions WHERE id IN (" + string.Join(",", lQuestions) + ");"); if (qt.Tables.Count == 1 && qt.Tables[0].Rows.Count > 0) { foreach (DataRow qr in qt.Tables[0].Rows) { bool bHasFault = false; if (ft.Tables.Count == 1 && ft.Tables[0].Rows.Count > 0) { foreach (DataRow fr in ft.Tables[0].Rows) { if (fr["question"].ToString().Equals(qr["id"].ToString())) { bHasFault = true; break; } } } string sQuestion = qr["question"].ToString(), sAnswer = ""; string sQSec = qr["letter"].ToString(), sQNum = Convert.ToInt32(qr["number"]).ToString("D2"); string[] sParts = qr["parts"] != DBNull.Value ? qr["parts"].ToString().TrimStart('{').TrimEnd('}').Split(new char[] { '}', '{' }, StringSplitOptions.RemoveEmptyEntries) : new string[] { }; foreach (DataRow ar in at.Tables[0].Rows) { if (ar["question"].ToString() == qr["id"].ToString()) { sAnswer = ar["answer"].ToString(); if (sParts.Length > 0) { for (int i = 0; i < sParts.Length; i++) { if (ar["part"].ToString() != (i + 1).ToString()) { continue; } sQuestion = qr["question"].ToString() + " [" + sParts[i] + "]"; GridRow ir = new GridRow(new object[] { qr["id"].ToString(), sQSec, sQNum, (i + 1), sQuestion, sAnswer }); ir.Tag = ar["id"].ToString(); if (bHasFault) { ir.CellStyles.Default.Background.Color1 = Color.Red; ir.CellStyles.Default.Background.Color2 = Color.Red; ir.CellStyles.Default.TextColor = Color.White; } gInspectionAnswers.PrimaryGrid.Rows.Add(ir); } } else { GridRow ir = new GridRow(new object[] { qr["id"].ToString(), sQSec, sQNum, "", sQuestion, sAnswer }); ir.Tag = ar["id"].ToString(); if (bHasFault) { ir.CellStyles.Default.Background.Color1 = Color.Red; ir.CellStyles.Default.Background.Color2 = Color.Red; ir.CellStyles.Default.TextColor = Color.White; } gInspectionAnswers.PrimaryGrid.Rows.Add(ir); } } } } } } } } } }
//Interfaz medicos private void sgrid_medicos_RowClick(object sender, GridRowClickEventArgs e) { GridRow tupla = (GridRow)e.GridRow; GridCellCollection celdas = tupla.Cells; this.nombre_m.Text = celdas[2].Value.ToString(); this.app_m.Text = celdas[3].Value.ToString(); this.apm_m.Text = celdas[4].Value.ToString(); this.consultorio_m.Text = celdas[1].Value.ToString(); this.especialidad_m.Text = celdas[6].Value.ToString(); if (celdas[5].Value.ToString() == "Matutino") this.turnom_m.Checked = true; else this.turnov_m.Checked = true; }
private void nodelist_RowClick(object sender, GridRowClickEventArgs e) { string nodename = (string)e.GridPanel.GetCell(e.GridRow.RowIndex, 0).Value; updateDrop(nodename,checkBox1.Checked); }
//Interfaz medicamentos private void sgrid_mt_RowClick(object sender, GridRowClickEventArgs e) { GridRow tupla = (GridRow)e.GridRow; GridCellCollection celdas = tupla.Cells; this.compuesto_mt.Text = celdas[2].Value.ToString(); this.tipo_mt.Text = celdas[1].Value.ToString(); this.presentacion_mt.Text = celdas[3].Value.ToString(); this.contenido_mt.Text = celdas[4].Value.ToString(); this.via_admon_mt.Text = celdas[5].Value.ToString(); this.cbp_mt.Text = celdas[6].Value.ToString(); this.existencias_mt.Value = Convert.ToInt32(celdas[7].Value.ToString()); }
/// <summary> /// 选中 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void superGridControl1_RowClick(object sender, DevComponents.DotNetBar.SuperGrid.GridRowClickEventArgs e) { var rows = superGridControl1.PrimaryGrid.GetSelectedRows(); if (rows.Count != 1) { MessageBox.Show("请选择一行"); superGridControl1.PrimaryGrid.ClearSelectedColumns(); return; } //清空 ClearAll(); GridRow row = (GridRow)rows[0]; Stakeholders stakeholders = new Stakeholders(); List <CommunicationFXFA> list = new List <CommunicationFXFA>(); bll.GetCommunicationMatix(ProjectId, row.Cells["ID"].Value.ToString(), out stakeholders, out list); if (stakeholders != null) { txtCompanyName.Text = stakeholders.CompanyName; txtDuty.Text = stakeholders.Duty; txtEmail.Text = stakeholders.Email; txtName.Text = stakeholders.Name; txtPosition.Text = stakeholders.Position; txtQQ.Text = stakeholders.QQ; txtTel.Text = stakeholders.Tel; txtWechat.Text = stakeholders.Wechat; cbIspublic.CheckValue = stakeholders.IsPublic; dtiCREATED.Value = stakeholders.CREATED; type = stakeholders.Type; sendtype = stakeholders.SendType; ID = stakeholders.ID; CREATED = stakeholders.CREATED; } if (list != null && list.Count > 0) { txtAddress1.Text = list[0].Addr; txtContent1.Text = list[0].Content; txtCommunicateDate1.Text = list[0].CommunicateDate; txtFrenquence1.Text = list[0].Frequency; DataHelper.SetComboBoxSelectItemByValue(cmbCommunication1, list[0].CID); FXFAID1 = list[0].ID; if (list.Count > 1) { txtAddress2.Text = list[1].Addr; txtContent2.Text = list[1].Content; txtConmunicateDate2.Text = list[0].CommunicateDate; txtFrenquence2.Text = list[0].Frequency; DataHelper.SetComboBoxSelectItemByValue(cmbCommunication2, list[1].CID); FXFAID2 = list[1].ID; } if (list.Count > 2) { txtAddress3.Text = list[2].Addr; txtContent3.Text = list[2].Content; txtConmunicateDate3.Text = list[0].CommunicateDate; txtFrenquence3.Text = list[0].Frequency; DataHelper.SetComboBoxSelectItemByValue(cmbCommunication3, list[2].CID); FXFAID3 = list[2].ID; } } }
//Interfaz pacientes private void sgrid_pacientes_RowClick(object sender, GridRowClickEventArgs e) { GridRow tupla = (GridRow)e.GridRow; GridCellCollection celdas = tupla.Cells; this.consultorio_p.Text = celdas[2].Value.ToString(); this.nombre_p.Text = celdas[3].Value.ToString(); this.app_p.Text = celdas[4].Value.ToString(); this.apm_p.Text = celdas[5].Value.ToString(); this.fn_p.Text = celdas[6].Value.ToString(); this.edad_p.Text = celdas[7].Value.ToString(); this.sexo_p.Text = celdas[8].Value.ToString(); }
/// <summary> /// Handles invocation of RowInfoClick events /// </summary> internal void DoRowInfoClickEvent(GridRow gridRow, MouseEventArgs e) { if (RowInfoClick != null) { GridRowClickEventArgs ev = new GridRowClickEventArgs(gridRow.GridPanel, gridRow, RowArea.InRowInfo, e); RowInfoClick(this, ev); } }
private void gCourses_RowClick(object sender, GridRowClickEventArgs e) { if (e.MouseEventArgs.Button == MouseButtons.Right) { Point pos = gCourses.PointToClient(Cursor.Position); mCourses.Show(gCourses, pos); } else if (e.MouseEventArgs.Button == MouseButtons.Left) { if (e.GridRow.RowIndex > -1 && e.MouseEventArgs.Button == MouseButtons.Left) { GridElement row = gCourses.PrimaryGrid.Rows[e.GridRow.RowIndex]; Program.DB.AddParameter("ID", row.Tag); DataSet c = Program.DB.SelectAll("SELECT * FROM Courses WHERE ID=@ID;"); if (c.Tables.Count > 0 && c.Tables[0].Rows.Count > 0) { SharedData.iCourseID = Convert.ToInt32(c.Tables[0].Rows[0]["ID"]); txtCourseName.Text = c.Tables[0].Rows[0]["Name"].ToString(); txtCourseCert.Text = c.Tables[0].Rows[0]["Certification"].ToString(); txtCourseDuration.Text = c.Tables[0].Rows[0]["Duration"].ToString(); txtCoursePricing.Text = c.Tables[0].Rows[0]["Pricing"].ToString(); txtCourseDetails.Text = c.Tables[0].Rows[0]["Details"].ToString(); } } } }
private void sgrid_citas_RowClick(object sender, GridRowClickEventArgs e) { boton_si.Enabled = boton_no.Enabled = true; }
private void sgc_mp_RowClick(object sender, DevComponents.DotNetBar.SuperGrid.GridRowClickEventArgs e) { mp_select = sgc_mp.PrimaryGrid.GridPanel.GetSelectedRows().GetCells(); }