private void dataGridView1_SelectionChanged(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 1) { //int id = (int)dataGridView1.SelectedRows[0].Cells[0].Value; int rid = dataGridView1.SelectedRows[0].Index; int id = ((dataGridView1.DataSource as ArrayList)[rid] as tbSlice).slice_id; using (CTDBEntities ct = new CTDBEntities()) { tbSlice s = ct.tbSlice.Where <tbSlice>(c => c.slice_id == id).Single(); clID.Text = s.slice_id.ToString(); CTHelper.setControl(clScan, s.scan_id); clReconstructionProgram.Text = s.slice_para_ReconstructionProgram; clFileType.Text = s.slice_para_ResultFileType; // clNumberSlice.Text = s.slice_para_SliceNumber.ToString(); clPixelSize.Text = s.slice_para_PixelSize.ToString(); CTHelper.setControl(clOpenStatus, s.open_status); ucFileInfo1.ParaDatasetID = s.slice_id; clLabelNo.Text = ct.tbLabel.Count <tbLabel>(c => c.slice_id == id).ToString(); CTHelper.setControl(cscRef, s.ref_id); mitDelete.Enabled = dataGridView1.Rows.Count > 0; } } }
private void dataGridView1_SelectionChanged(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 1) { // int id = (int)dataGridView1.SelectedRows[0].Cells[0].Value; int rid = dataGridView1.SelectedRows[0].Index; int id = ((dataGridView1.DataSource as ArrayList)[rid] as tbLabel).label_id; using (CTDBEntities ct = new CTDBEntities()) { tbLabel s = ct.tbLabel.Where <tbLabel>(c => c.label_id == id).Single(); clbID.Text = s.label_id.ToString(); // CTHelper.setControl(clbSlice, s.slice_id); clbAuthor.Text = s.label_author; //clbFileType.Text = s.label_file_type; //clbNumberSlice.Text = s.label_file_number.ToString(); clbStructure.Text = s.label_structure; clbMethod.Text = s.label_method; clbTitle.Text = s.label_title; clbSrcFolder.Text = s.label_srcfolder; CTHelper.setControl(clbOpenStatus, s.open_status); ucFileInfo1.ParaDatasetID = s.label_id; clbNote.Text = s.label_note; mitDelete.Enabled = dataGridView1.Rows.Count > 0; } } }
private void dataGridView1_SelectionChanged(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 1) { //int id = (int)dataGridView1.SelectedRows[0].Cells[0].Value; //lbNote.Text = id.ToString(); int rid = dataGridView1.SelectedRows[0].Index; int id = ((dataGridView1.DataSource as ArrayList)[rid] as tbScan).scan_id; CTDBEntities ct = new CTDBEntities(); var q = from c in ct.tbScan where c.scan_id == id select c; tbScan s = q.ToList <tbScan>()[0]; cscID.Text = s.scan_id.ToString(); cscOperator.Text = s.scan_operator; //cscTimeBegin.Text = s.scan_timebegin.ToShortDateString(); cscTimeBegin.Text = s.scan_timebegin.ToString(); cscTimeEnd.Text = s.scan_timeend.ToString(); cscScanDate.Text = s.scan_date; CTHelper.setControl(cscSpecimen, s.sp_id); CTHelper.setControl(cscTagSpecimenAlive, s.scan_tag_SpecimenAlive); cscTagSpecimenParty.Text = s.scan_specimen_Body; s.scan_specimen_Body = cscTagSpecimenParty.Text; //cscNumberFile.Text = s.scan_para_FilesNumber.ToString(); cscFileType.Text = s.scan_para_ImageFomat; //cscLensMultiple.Text = s.scan_para_ImagePixelSize.ToString(); cscLensMultiple.Text = s.scan_para_LensMultiple.ToString(); cscCameraBinning.Text = s.scan_para_CameraBinning; CTHelper.setControl(cscEquipment, s.e_id); cscSourceType.Text = s.scan_para_SourceType; cscCamera.Text = s.scan_para_Camera; cscSourceVoltage.Text = s.scan_para_SourceVoltage.ToString(); cscSourceCurrent.Text = s.scan_para_SourceCurrent.ToString(); cscSourcePower.Text = s.scan_para_SourcePower.ToString(); cscCamera2Source.Text = s.scan_para_Camera2Source.ToString(); cscObejct2Souce.Text = s.scan_para_Object2Source.ToString(); cscVerticalObjectPosition.Text = s.scan_para_VerticalObjectPosition.ToString(); cscPixelSize.Text = s.scan_para_ImagePixelSize.ToString(); cscRotationStep.Text = s.scan_para_RotationStep.ToString(); cscExposure.Text = s.scan_para_Exposure.ToString(); //cscScanSourceSavePath.Text = s.scan_source_save_path; cscSliceNo.Text = ct.tbSlice.Count <tbSlice>(c => c.scan_id == id).ToString(); CTHelper.setControl(cscOpenStatus, s.open_status); ucFileInfo1.ParaDatasetID = s.scan_id; CTHelper.setControl(cscRef, s.ref_id); mitDelete.Enabled = dataGridView1.Rows.Count > 0; } }
private void lboxDB_SelectedIndexChanged(object sender, EventArgs e) { if (lboxDB.SelectedIndex > 0) { tbFile f = lboxDB.SelectedItem as tbFile; lbDBFile.Text = f.f_id + ":" + f.f_md5 + ":"; CTHelper.setControl(cdFileType, (int)f.f_filetype); CTHelper.setControl(cdFileOpenStatus, (int)f.open_status); CTHelper.setControl(cdFileRef, (int)f.ref_id); cdFileAuthor.Text = f.f_author; } }
/// <summary>set value for combox with Tag </summary> /// <param name="cb">combox name</param> /// <param name="rootid">parent tag's id </param> /// <param name="sid">selected tag's id, -1 means not select</param> static public void setControlTag(ComboBox cb, int rootid, int sid = -1) { using (CTDBEntities ct = new CTDBEntities()) { var q = from c in ct.tbTag where c.tag_pid == rootid select c; cb.DataSource = q.ToList <tbTag>(); cb.ValueMember = "tag_id"; cb.DisplayMember = "tag_tag"; if (sid != -1) { CTHelper.setControl(cb, sid); } } }
//load selected information private void dataGridView1_SelectionChanged(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 1) { int rid = dataGridView1.SelectedRows[0].Index; int id = ((dataGridView1.DataSource as ArrayList)[rid] as tbSpecimen).sp_id; // (int)(dataGridView1.SelectedRows[0].Cells[0].Value as tbSpecimen); //tbSpecimen ss = dataGridView1.SelectedRows[0].Cells[0].Value as tbSpecimen; //Console.WriteLine(ss.sp_spid.ToString()); CTDBEntities ct = new CTDBEntities(); var q = from c in ct.tbSpecimen where c.sp_id == id select c; tbSpecimen s = q.ToList <tbSpecimen>()[0]; csmID.Text = s.sp_id.ToString(); csmSPID.Text = s.sp_spid; csmCollector.Text = s.sp_collector; csmCollectPlace.Text = s.sp_collect_place; csmCollectTime.Text = s.sp_collect_time; csmIdentifier.Text = s.sp_identifier; csmDehydrant.Text = s.sp_dehydrant; csmDryInstrument.Text = s.sp_dryinstrument; csmDryCycleTime.Text = s.sp_drycirletime.ToString(); CTHelper.setControl(csmSpecies, (int)s.species_id); CTHelper.setControl(csmSex, (int)s.specimen_sex); csmAge.Text = s.specimen_age; csmDriedSpecimenSavePosition.Text = s.specimen_dry_save_path; csmPS.Text = s.sp_preserve_status; csmNote.Text = s.sp_note; //lbFilecount.Text = ct.tbFile.Where<tbFile>(c => c.f_pid == s.sp_id && c.f_table == "ctdb-specimen").Count<tbFile>().ToString(); ucFileInfo1.ParaDatasetID = s.sp_id; mitDelete.Enabled = dataGridView1.Rows.Count > 0; lbSPcount.Text = ct.tbScan.Where(c => c.sp_id == id).Count <tbScan>().ToString(); } }
//parse the parameter private void tbParas_TextChanged(object sender, EventArgs e) { if (tbParas.Text.Trim() == "") { return; } string[] sl = tbParas.Text.Split('\t'); if (sl.Length < 24) { return; } //MessageBox.Show(sl.Length.ToString()); //初始化一些字段 cscanCameraBinning.Text = ""; cscanSourceVoltage.Text = "0"; cscanSourceCurrent.Text = "0"; cscanExposure.Text = "0"; csmDryCycleTime.Text = "25"; //字段对应 //0-扫描时间 //1-扫描地点 //2-样本编号(年[4位]月[2位]标本号[3位]) //3-目 //4,5,6 - 种名(俗名,中文) 拉丁名 名称备注 //7-性别(♀♂A P L)功能型等 //8-虫龄 //12-采集备注 //9,10,11 - 采集时间 采集地点 采集人 //16-脱水参数 //17-临界点干燥 //18-扫描部位 //19-扫描参数 //21-ct -slice数据保存位置 //22-ct原始数据保存位置 //23-干样本保存位置 如样本编号为201903001的样本,保存在1号箱的1号抽屉里,则命名为1 - 2019 - 1 - 3 - 01 //24-对应数据库编号 //================================ cscanTimeBegin.Text = sl[0]; try { if (sl[1].Contains("上海光源")) { CTHelper.setControl(cscanEquipment, 2); } else if (sl[1].Contains("动物所")) { CTHelper.setControl(cscanEquipment, 1); } } catch { } csmSPID.Text = sl[2]; cspeciesOrder.Text = sl[3]; cspeciesNote.Text = sl[4] + " " + sl[5]; //cspeciesOrder.Text = sl[3]; //7-性别(♀♂A P L)功能型等 //8-虫龄 //12-采集备注 //9,10,11 - 采集时间 采集地点 采集人 try { if (sl[7].Contains("♀")) { CTHelper.setControl(csmSex, 44); } else if (sl[7].Contains("♂")) { CTHelper.setControl(csmSex, 41); } } catch { } csmAge.Text = (sl[8].Trim() == "") ? "-" : sl[7]; csmNote.Text = (sl[12].Trim() == "") ? "-" : sl[8]; //9,10,11-采集地点 采集时间 采集人 csmCollectTime.Text = (sl[9].Trim() == "") ? "-" : sl[10]; csmCollectPlace.Text = (sl[10].Trim() == "") ? "-" : sl[11]; csmCollector.Text = (sl[11].Trim() == "") ? "-" : sl[9]; //16-脱水参数 //17-临界点干燥 //18-扫描部位 //19-扫描参数 try { if (sl[16].Contains("75%-100%")) { CTHelper.setControl(csmDehydrant, 0); } else if (sl[16].Contains("75-100")) { CTHelper.setControl(csmDehydrant, 0); } else if (sl[16].Contains("75%-丙酮")) { CTHelper.setControl(csmDehydrant, 3); } else if (sl[16].Contains("100")) { CTHelper.setControl(csmDehydrant, 1); } } catch { } csmDryCycleTime.Text = (sl[17].Trim() == "") ? "0" : sl[13]; //cscanTagSpecimenParty try { if (sl[19].Trim() != "") { string[] sp = sl[19].Split(new char[] { ':', '-' }); cscanCameraBinning.Text = sp[1].Trim(); cscanSourceVoltage.Text = sp[2].Trim().ToLower().Replace("kv", ""); cscanSourceCurrent.Text = sp[3].Trim().ToLower().Replace("w", ""); cscanExposure.Text = sp[4].Trim().ToLower().Replace("s", ""); } } catch { } //21-ct -slice数据保存位置 //22-ct原始数据保存位置 //23-干样本保存位置 如样本编号为201903001的样本,保存在1号箱的1号抽屉里,则命名为1 - 2019 - 1 - 3 - 01 //24-对应数据库编号 cscanPath.Text = sl[21].Trim(); csmSavePosition.Text = sl[22].Trim(); }