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 tbSpecies).species_id;
CTDBEntities ct = new CTDBEntities();
var q = from c in ct.tbSpecies
where c.species_id == id
select c;
List <tbSpecies> sl = q.ToList <tbSpecies>();
tbSpecies s = sl[0];
{
cspeciesID.Text = s.species_id.ToString();
cspeciesNote.Text = s.species_note;
cspeciesLatin.Text = s.species_latin;
cspeciesCHN.Text = s.species_CHN;
cspeciesOrder.Text = s.species_Order;
cspeciesFamily.Text = s.species_Family;
cspeciesGenus.Text = s.species_Genus;
cspeciesSpecies.Text = s.species_Species;
}
string str = "";
//str += ct.tbSpecimen.Where(c => c.species_id == s.species_id).Count<tbSpecimen>() ;
lbSPcount.Text = ct.tbSpecimen.Where(c => c.species_id == s.species_id).Count <tbSpecimen>().ToString();
}
}
private void csmSpecies_SelectedIndexChanged(object sender, EventArgs e)
{
tbSpecies ts = (csmSpecies.SelectedItem as tbSpecies);
lbSpeciesCHN.Text = ts.species_CHN;
lbSpeciesLatin.Text = ts.species_latin;
csmNote.Text = csmSpecies.Text.Trim();
}
//operations
/// <summary> set values </summary>
/// <param name="s"></param>
void setDBValue(tbSpecies s)
{
s.species_note = cspeciesNote.Text.Trim();
s.species_CHN = cspeciesCHN.Text.Trim();
s.species_latin = cspeciesLatin.Text.Trim();
s.species_Order = cspeciesOrder.Text.Trim();
s.species_Family = cspeciesFamily.Text.Trim();
s.species_Genus = cspeciesGenus.Text.Trim();
s.species_Species = cspeciesSpecies.Text.Trim();
s.species_LSID = "-";
s.date_in = DateTime.Now;
s.UserId = Guid.Parse(CTHelper.GetConfig("userid"));
}
private void bSpeciesAdd_Click(object sender, EventArgs e)
{
tbSpecies s = new tbSpecies();
setDBValue(s);
CTDBEntities ct = new CTDBEntities();
ct.tbSpecies.Add(s);
ct.SaveChanges(); //将修改保存到数据库中
if ((dataGridView1.DataSource as List <tbSpecies>) != null)
{
refreshdata(null, null, (dataGridView1.DataSource as List <tbSpecies>).Count);
}
else
{
refreshdata(null, null);
}
}
static public string ExportPIDXML(int id)
{
string r = "";
try
{
//https://blog.csdn.net/xjj51296646/article/details/4241548
XmlDocument xmldoc = new XmlDocument();
//加入XML的声明段落,<?xml version="1.0" encoding="gb2312"?>
XmlDeclaration xmldecl = xmldoc.CreateXmlDeclaration("1.0", "UTF-8", null);
xmldoc.AppendChild(xmldecl);
//加入一个根元素
XmlElement xmlroot = xmldoc.CreateElement("", "pid", "");
xmlroot.SetAttribute("type", "DATASET");
xmldoc.AppendChild(xmlroot);
XmlElement xmlroot2 = xmldoc.CreateElement("", "metadatas", "");
xmlroot.AppendChild(xmlroot2);
XmlElement xmlmeta = xmldoc.CreateElement("", "metadata", "");
xmlmeta.SetAttribute("type", "Metadata");
xmlroot2.AppendChild(xmlmeta);
List <Tuple <string, string> > ht = new List <Tuple <string, string> >();
CTDBEntities ct = new CTDBEntities();
tbSlice slice = ct.tbSlice.FirstOrDefault(s => s.slice_id == id);
tbScan scan = ct.tbScan.FirstOrDefault(s => s.scan_id == slice.scan_id);
string part = scan.scan_specimen_Body;
tbSpecimen sp = ct.tbSpecimen.FirstOrDefault(s => s.sp_id == slice.sp_id);
tbSpecies species = ct.tbSpecies.FirstOrDefault(s => s.species_id == sp.species_id);
string spname = species.species_latin;
string pid = "21.86116.3/CT.slice." + slice.slice_id.ToString();
xmlmeta.AppendChild(addnode(xmldoc, "pid", pid));
string url = "http://ct.especies.cn/slice/info/" + slice.slice_id.ToString();
xmlmeta.AppendChild(addnode(xmldoc, "url", url));
string funding = "the Strategic Priority Research Program of the Chinese Academy of Sciences(Grant No. XDA19050203)";
xmlmeta.AppendChild(addnode(xmldoc, "funding", funding));
xmlmeta.AppendChild(addnode(xmldoc, "copyright", "CC BY 4.0"));
string title_zh = spname + " " + part + " 显微CT扫描和标注数据";
xmlmeta.AppendChild(addnode(xmldoc, "title_zh", title_zh));
string title_en = "Micro-CT Slice and Label Data of " + spname + " " + part;
xmlmeta.AppendChild(addnode(xmldoc, "title_en", title_en));
string description_zh = title_zh;
xmlmeta.AppendChild(addnode(xmldoc, "description_zh", description_zh));
string description_en = title_en;
xmlmeta.AppendChild(addnode(xmldoc, "description_en", description_en));
string keyword_zh = spname + ";显微CT;结构标注";
xmlmeta.AppendChild(addnode(xmldoc, "keyword_zh", keyword_zh));
string keyword_en = spname + ";Micro CT;structural label";
xmlmeta.AppendChild(addnode(xmldoc, "keyword_en", keyword_en));
xmlmeta.AppendChild(addnode(xmldoc, "resource_type", "采集数据"));
xmlmeta.AppendChild(addnode(xmldoc, "publisher_zh", "动物科学数据中心"));
xmlmeta.AppendChild(addnode(xmldoc, "publisher_en", "Scientific Data Center of Zoology"));
string f = Application.StartupPath + "\\meta.xml";
if (File.Exists(f))
{
File.Delete(f);
}
xmldoc.Save(f);
System.Diagnostics.Process.Start(f);
}
catch (Exception ee)
{
MessageBox.Show("记录有问题，导出失败\r\n" + ee.ToString());
}
return(r);
}
/// <summary>导出元数据方法</summary>
/// <param name="id">slice表的 slice_id </param>
static public void ExportMeta(int id)
{
try
{
List <Tuple <string, string> > ht = new List <Tuple <string, string> >();
CTDBEntities ct = new CTDBEntities();
tbSlice slice = ct.tbSlice.FirstOrDefault(s => s.slice_id == id);
ht.Add(new Tuple <string, string>("URL", "http://ct.especies.cn/slice/info/" + slice.slice_id.ToString()));
ht.Add(new Tuple <string, string>("Slice ID", slice.slice_id.ToString()));
ht.Add(new Tuple <string, string>("Slice Number", slice.slice_para_SliceNumber.ToString()));
ht.Add(new Tuple <string, string>("Slice File Type", slice.slice_para_ResultFileType.ToString()));
ht.Add(new Tuple <string, string>("Slice Resolution", slice.slice_para_PixelSize.ToString()));
tbScan scan = ct.tbScan.FirstOrDefault(s => s.scan_id == slice.scan_id);
//ht.Add(new Tuple<string, string>("Scan ID", scan.scan_id.ToString()));
ht.Add(new Tuple <string, string>("Scan Voltage", scan.scan_para_SourceVoltage.ToString()));
ht.Add(new Tuple <string, string>("Scan Power", scan.scan_para_SourcePower.ToString()));
ht.Add(new Tuple <string, string>("Scan Binning", scan.scan_para_CameraBinning.ToString()));
ht.Add(new Tuple <string, string>("Scan Lens", scan.scan_para_LensMultiple.ToString()));
ht.Add(new Tuple <string, string>("Scan Exposure", scan.scan_para_Exposure.ToString()));
ht.Add(new Tuple <string, string>("Scan Time", scan.scan_date));
ht.Add(new Tuple <string, string>("Scan Operator", scan.scan_operator));
ht.Add(new Tuple <string, string>("Scan Part", scan.scan_specimen_Body));
//tbTag ttag = ct.tbTag.FirstOrDefault(s => s.tag_id == scan.scan_tag_SpecimenAlive);
//ht.Add(new Tuple<string, string>("Specimen Status", ttag.tag_tag));
ht.Add(new Tuple <string, string>("Specimen Status", FormTag.GetTagTag(scan.scan_tag_SpecimenAlive)));
tbEquipment equip = ct.tbEquipment.FirstOrDefault(s => s.e_id == scan.e_id);
ht.Add(new Tuple <string, string>("Equipment", equip.e_name));
tbSpecimen sp = ct.tbSpecimen.FirstOrDefault(s => s.sp_id == slice.sp_id);
ht.Add(new Tuple <string, string>("Specimen ID", sp.sp_spid));
ht.Add(new Tuple <string, string>("Specimen Collector", sp.sp_collector));
ht.Add(new Tuple <string, string>("Specimen Time", sp.sp_collect_time));
ht.Add(new Tuple <string, string>("Specimen Place", sp.sp_collect_place));
ht.Add(new Tuple <string, string>("Specimen Identifier", sp.sp_identifier));
ht.Add(new Tuple <string, string>("Preprocess", sp.sp_dehydrant));
tbSpecies species = ct.tbSpecies.FirstOrDefault(s => s.species_id == sp.species_id);
ht.Add(new Tuple <string, string>("Specie Name", species.species_latin));
ht.Add(new Tuple <string, string>("Specie Genus", species.species_Genus));
ht.Add(new Tuple <string, string>("Specie Family", species.species_Family));
string f = Application.StartupPath + "\\meta.txt";
if (File.Exists(f))
{
File.Delete(f);
}
//foreach (System.Collections.DictionaryEntry item in ht)
foreach (Tuple <string, string> item in ht)
{
string s = item.Item1 + "\t:\t" + item.Item2;
CTHelper.AddLog(s, f);
}
System.Diagnostics.Process.Start(f);
}
catch (Exception ee)
{
MessageBox.Show("记录有问题，导出失败\r\n" + ee.ToString());
}
}
//add
private void btnAdd_Click(object sender, EventArgs e)
{
CTDBEntities ct = new CTDBEntities();
//create species
var s1 = new tbSpecies();
s1.species_note = cspeciesNote.Text;
s1.species_Order = cspeciesOrder.Text;
s1.date_in = DateTime.Now;
s1.UserId = Guid.Parse(CTHelper.GetConfig("userid"));
ct.tbSpecies.Add(s1);
ct.SaveChanges(); //将修改保存到数据库中
//create specimen
var s2 = new tbSpecimen();
s2.species_id = s1.species_id;
s2.sp_spid = csmSPID.Text; //实际标本号-不是必须字段
s2.specimen_sex = (csmSex.SelectedItem as tbTag).tag_id;
s2.specimen_age = csmAge.Text;
s2.sp_note = csmNote.Text;
s2.specimen_dry_save_path = csmSavePosition.Text;
s2.sp_collector = csmCollector.Text;
s2.sp_collect_place = csmCollectPlace.Text;
s2.sp_collect_time = csmCollectTime.Text;
s2.sp_dehydrant = csmDehydrant.Text;
s2.sp_drycirletime = int.Parse(GetStringNumber(csmDryCycleTime.Text));
//s2.sp_dryinstrument = "-";
s2.Abstract = s1.species_note + "-" + s2.sp_id;
s2.date_in = DateTime.Now;
s2.UserId = Guid.Parse(CTHelper.GetConfig("userid"));
s2.sp_preserve_status = "-";
ct.tbSpecimen.Add(s2);
ct.SaveChanges(); //将修改保存到数据库中
//create scan record
var s3 = new tbScan();
s3.sp_id = s2.sp_id;
s3.e_id = (int)cscanEquipment.SelectedValue;
s3.scan_specimen_Body = cscanTagSpecimenParty.Text;
s3.scan_source_save_path = cscanPath.Text;
//s3.scan_timebegin = DateTime.Parse(cscanTimeBegin.Text);
s3.scan_date = cscanTimeBegin.Text;
s3.scan_para_CameraBinning = cscanCameraBinning.Text;
s3.scan_para_SourceVoltage = double.Parse(GetStringNumber(cscanSourceVoltage.Text));
s3.scan_para_SourceCurrent = double.Parse(GetStringNumber(cscanSourceCurrent.Text));
s3.scan_para_Exposure = double.Parse(GetStringNumber(cscanExposure.Text));
s3.Abstract = s2.Abstract + "-" + s3.scan_specimen_Body;
s3.date_in = DateTime.Now;
s3.UserId = Guid.Parse(CTHelper.GetConfig("userid"));
ct.tbScan.Add(s3);
ct.SaveChanges(); //将修改保存到数据库中
//create slice record
var s4 = new tbSlice();
s4.scan_id = s3.scan_id;
s4.slice_save_path = csliceSavePath.Text;
s4.date_in = DateTime.Now;
s4.UserId = Guid.Parse(CTHelper.GetConfig("userid"));
s4.Abstract = s3.Abstract;
ct.tbSlice.Add(s4);
ct.SaveChanges(); //将修改保存到数据库中
refreshdata(null, null);
}