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();
}