/// <summary>参数加载</summary>
/// <param name="file">加密参数文件</param>
/// <param name="appkey">加密参数</param>
/// <returns></returns>
static public string LoadPara(string file, string appkey)
{
string connectionString = CTHelper.LoadTxt(file);
connectionString = CTHelper.Decrypt(connectionString, CTHelper.GetConfig(appkey));
return(connectionString);
}
void setDBValue(tbSlice s)
{
s.scan_id = (clScan.SelectedValue as tbScan).scan_id;
s.sp_id = (clScan.SelectedValue as tbScan).sp_id; //specimen_id
s.slice_para_ReconstructionProgram = clReconstructionProgram.Text;
s.slice_para_ResultFileType = clResultFileType.Text.Trim();
s.slice_para_SliceNumber = ucFileInfo1.ValueFileCount;// int.Parse(clNumberSlice.Text);
double psize = -1.0;
double.TryParse(clPixelSize.Text, out psize);
s.slice_para_PixelSize = psize;
if (clPixelSize.Text != "")
{
s.slice_para_PixelSize = float.Parse(clPixelSize.Text);
}
s.open_status = int.Parse(clOpenStatus.SelectedValue.ToString());
s.slice_para_CutMethod = clCutMethod.Text;
s.slice_save_path = "-";// clSavePath.Text;
if (s.tbScan != null)
{
s.Abstract = s.tbScan.Abstract;
}
s.UserId = Guid.Parse(CTHelper.GetConfig("userid"));
s.date_in = DateTime.Now;
s.ref_id = (cscRef.SelectedItem as tbRef).ref_id;
}
//scan
private void btnAdd_Click(object sender, EventArgs e)
{
var s = new tbScan();
setDBValue(s);
using (CTDBEntities ct = new CTDBEntities())
{
ct.tbScan.Add(s);
ct.SaveChanges(); //将修改保存到数据库中
}
//refreshDatagridview(dataGridView1.Rows.Count.ToString());
int rowid = dataGridView1.Rows.Count;
refreshdata(null, null);
dataGridView1.Rows[rowid].Selected = true;
//return;
//级联添加一个slice
using (CTDBEntities ct = new CTDBEntities())
{
tbSlice sl = new tbSlice();
sl.scan_id = int.Parse(cscID.Text);
sl.slice_para_ReconstructionProgram = "NRecon";
sl.slice_para_ResultFileType = "BMP";
sl.slice_para_SliceNumber = 0;
sl.slice_para_PixelSize = s.scan_para_ImagePixelSize;
sl.open_status = 30;
sl.UserId = Guid.Parse(CTHelper.GetConfig("userid"));
sl.Abstract = FormSpecimen.CutString(cscSpecimen.Text, 40) + "-" + FormSpecimen.CutString(cscTagSpecimenParty.Text, 7);
ct.tbSlice.Add(sl);
ct.SaveChanges(); //将修改保存到数据库中
}
}
//tbSpecimen operations
/// <summary> set values </summary>
/// <param name="s"></param>
void setDBValue(tbSpecimen s)
{
s.species_id = (csmSpecies.SelectedItem as tbSpecies).species_id;
s.sp_note = CutString(csmNote.Text, 50);
s.sp_spid = csmSPID.Text;//实际标本号-不是必须字段
s.specimen_age = csmAge.Text;
s.specimen_sex = (csmSex.SelectedItem as tbTag).tag_id;
s.specimen_dry_save_path = csmDriedSpecimenSavePosition.Text;
//s.sp_description = csmDescrip.Text;
s.sp_collector = csmCollector.Text;
s.sp_collect_place = csmCollectPlace.Text;
s.sp_collect_time = csmCollectTime.Text;
s.sp_identifier = csmIdentifier.Text;
s.sp_dehydrant = csmDehydrant.Text;
s.sp_drycirletime = int.Parse(csmDryCycleTime.Text);
s.sp_dryinstrument = csmDryInstrument.Text;
s.sp_preserve_status = csmPS.Text;
//s.Abstract = csmSpecies.Text.Trim() + "-" + csmSPID.Text;
s.Abstract = CutString(lbSpeciesLatin.Text, 28) + " : " + CutString(csmSPID.Text, 18);
s.UserId = Guid.Parse(CTHelper.GetConfig("userid"));
s.date_in = DateTime.Now;
}
//operations
/// <summary> set values </summary>
/// <param name="s"></param>
void setDBValue(tbRef s)
{
s.UserId = Guid.Parse(CTHelper.GetConfig("userid"));
s.title = refTitle.Text;
s.url = refURL.Text;
s.cite = refCite.Text;
s.author = refAuthor.Text;
s.year = int.Parse(refYear.Text);
s.doc = refDoc.Text;
if (File.Exists(s.doc))
{
string md5 = CTHelper.GetMD5Hash(s.doc);
string f = CTHelper.CommonPath("app") + "\\" + md5 + ".pdf";
File.Copy(s.doc, f);
string r = CTHelper.UploadAPI(f, s.ref_id.ToString(), "upload", "ctdb-ref", "iozct", s.UserId.ToString());
Console.Write(r);
if (File.Exists(f))
{
File.Delete(f);
}
if (r == "")
{
s.doc = md5;
}
}
}
//从数据库里检测相关数据，看网页是否可以访问
private void btnCheckDB_Click(object sender, EventArgs e)
{
CTDBEntities ct = new CTDBEntities();
var q = from c in ct.tbFile
where c.f_pid == ParaDatasetID && c.f_table == ParaTable
orderby c.f_path
select c;
List <tbFile> l = q.ToList <tbFile>();
string flog = CTHelper.CommonPath("app") + "\\UrlTestlog.txt";
if (File.Exists(flog))
{
File.Delete(flog);
}
note(l.Count);
this.Enabled = false;
foreach (tbFile f in l)
{
string url = CTHelper.GetConfig("downloadurl") + f.f_table + "/" + f.f_pid.ToString() + "/" + f.f_md5 + ".jpg";
if (CTHelper.IsUrlExist(url))
{
CTHelper.AddLog("1\t" + url, flog);
}
else
{
CTHelper.AddLog("0\t" + url, flog);
}
notep();
}
refreshdb();
this.Enabled = true;
}
private void lbUpdate_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
string fupdate = Application.StartupPath + "\\Updater.exe";
if (File.Exists(fupdate))
{
File.Delete(fupdate);
}
//update updater.exe
if (!File.Exists(fupdate))
{
CTHelper.DownloadFile(CTHelper.GetConfig("updateUrl") + "/Updater.exe", fupdate);
}
if (!File.Exists(fupdate))
{
CTHelper.DownloadFile(CTHelper.GetConfig("downloadurl") + "/Updater.exe", fupdate);
}
if (!File.Exists(fupdate))
{
MessageBox.Show("Fail!");
return;
}
//begin to update
ProcessStartInfo startInfo = new ProcessStartInfo();
startInfo.FileName = fupdate;
startInfo.Arguments = CTHelper.GetConfig("updateUrl") + " " + Application.ExecutablePath;
System.Diagnostics.Process.Start(startInfo);
Application.Exit();
}
/// <summary>获得加权数据</summary>
/// <param name="table">table name</param>
/// <returns></returns>
static public ArrayList LoadDataA(string table)
{
ArrayList l = new ArrayList();
Guid uid = Guid.Parse(CTHelper.GetConfig("userid"));
if (uid.ToString() == "e28e0fe9-f0cd-4572-9d95-ec8b1e32bc07")
{
return(LoadDataF(table));
}
CTDBEntities ct = new CTDBEntities();
switch (table)
{
case "tbSpecies": foreach (tbSpecies t in ct.tbSpecies.Where <tbSpecies>(c => ((Guid)c.UserId) == uid))
{
l.Add(t);
}
break;
case "tbSpecimen": foreach (tbSpecimen t in ct.tbSpecimen.Where <tbSpecimen>(c => ((Guid)c.UserId) == uid))
{
l.Add(t);
}
break;
case "tbScan": foreach (tbScan t in ct.tbScan.Where <tbScan>(c => ((Guid)c.UserId) == uid))
{
l.Add(t);
}
break;
case "tbSlice": foreach (tbSlice t in ct.tbSlice.Where <tbSlice>(c => ((Guid)c.UserId) == uid))
{
l.Add(t);
}
break;
case "tbLabel": foreach (tbLabel t in ct.tbLabel.Where <tbLabel>(c => ((Guid)c.UserId) == uid))
{
l.Add(t);
}
break;
case "tbFile": foreach (tbFile t in ct.tbFile.Where <tbFile>(c => ((Guid)c.UserId) == uid))
{
l.Add(t);
}
break;
case "tbRef": foreach (tbRef t in ct.tbRef.Where <tbRef>(c => ((Guid)c.UserId) == uid))
{
l.Add(t);
}
break;
}
return(l);
}
private void FormLogin_Load(object sender, EventArgs e)
{
if (CTHelper.GetConfig("username") != "")
{
tbUser.Text = CTHelper.GetConfig("username");
}
if (CTHelper.GetConfig("userkey") != "")
{
tbPassword.Text = CTHelper.Decrypt(CTHelper.GetConfig("userkey"), "WXDX");
}
}
/// <summary>upload specimen file / example /demo </summary>
/// <param name="specimenid"></param>
/// <param name="lll"></param>
/// <param name="filetablep"></param>
/// <param name="choose_number"></param>
void uploadSpecimenFile(int specimenid, List <tbFile> lll, string filetablep, int choose_number)
{
//从slice表中随机找出10张图
List <string> fl = new List <string>();
int[] fr = CTHelper.RandomIntArray(choose_number, 0, lll.Count - 1);
for (int i = 0; i < fr.Length; i++)
{
string url = CTHelper.GetConfig("downloadurl") + "ct/" + filetablep + "/" + lll[fr[i]].f_pid + "/";
string fn = Path.GetFileName(lll[fr[i]].f_path.Trim());
fl.Add(url + fn);
}
Application.DoEvents();
string ftmpd = CTHelper.CommonPath("app") + "\\" + "d.jpg";
string ftmp = "";
//对每张图进行上传操作 同 Add功能
note(fl.Count);
for (int i = 0; i < fr.Length; i++)
{
notep();
if (File.Exists(ftmpd))
{
File.Delete(ftmpd);
}
CTHelper.DownloadFile(fl[i], ftmpd); //download source image
string fn = CTHelper.GetMD5Hash(ftmpd) + ".jpg";
if (File.Exists(ftmpd))
{
Bitmap b = CTHelper.CreateDemoImage(ftmpd, 150, 150);
ftmp = CTHelper.CommonPath("app") + "\\" + fn;
b.Save(ftmp, System.Drawing.Imaging.ImageFormat.Jpeg);
if (File.Exists(ftmp))
{
cdFileAuthor.Text = "selected from " + filetablep;
string r = addFile(ftmp, ftmp, "ctdb-specimen", specimenid);
if (r != "")
{
MessageBox.Show(r);
}
}
}
if (File.Exists(ftmpd))
{
File.Delete(ftmpd);
}
if (File.Exists(ftmp))
{
File.Delete(ftmp);
}
}
}
private void FormLabel_Load(object sender, EventArgs e)
{
ucFileInfo1.ParaTable = "ctdb-label";
ucFileInfo1.ParaFileType = 93;
clbAuthor.Text = CTHelper.GetConfig("username");
CTHelper.setControlTag(clbOpenStatus, 31, 30);
CTHelper.setControlTag(clbMethod, 58, 59);
CTHelper.setControlTag(clbStructure, 18, 23);
refreshdata(sender, e);
}
private void CTDBForm1_Load(object sender, EventArgs e)
{
connectionString = CTHelper.LoadTxt("efp.txt");
connectionString = CTHelper.Decrypt(connectionString, CTHelper.GetConfig("appkey2"));
CTHelper.UpdateConnectionString(Application.ProductName, conName, connectionString, providerName);
lbHelpSpecimen.Text = Properties.Resources.help_ct_Specimen;
lbHelpScan.Text = Properties.Resources.help_ct_Scan;
lbHelpTag.Text = Properties.Resources.help_ct_Tag;
lbHelp.Text = Properties.Resources.help_ct;
lbHelp2.Text = Properties.Resources.help_ct;
tabControl2.SelectedIndex = 3;//help
updateUserInfo();
}
//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"));
}
/// <summary>获得权限状态</summary>
/// <param name="table">parameter of</param>
/// <returns></returns>
static public bool HasAuthorty(string para)
{
ArrayList l = new ArrayList();
Guid uid = Guid.Parse(CTHelper.GetConfig("userid"));
try
{
if (uid.ToString() == CTHelper.LoadPara("admin.txt", "appkey3"))
{
return(true); //管理员权限
}
}
catch { }
return(false);
}
/// <summary>set values </summary>
/// <param name="s"></param>
void setDBValue(tbScan s)
{
DateTime dt = DateTime.Now;
s.scan_operator = cscOperator.Text;
DateTime.TryParse(cscTimeBegin.Text, out dt);
s.scan_timebegin = dt;
DateTime.TryParse(cscTimeEnd.Text, out dt);
s.scan_timeend = dt;
s.scan_date = cscScanDate.Text.Trim();
s.sp_id = (cscSpecimen.SelectedItem as tbSpecimen).sp_id;
s.scan_tag_SpecimenAlive = int.Parse(cscTagSpecimenAlive.SelectedValue.ToString());
s.scan_specimen_Body = cscTagSpecimenParty.Text;
s.scan_para_FilesNumber = ucFileInfo1.ValueFileCount;// int.Parse(cscNumberFile.Text);
s.scan_para_ImageFomat = cscFileType.Text;
s.scan_para_ImagePixelSize = 0.0;
s.scan_para_LensMultiple = getValueDouble(cscLensMultiple.Text);
s.scan_para_CameraBinning = cscCameraBinning.Text;
s.e_id = (cscEquipment.SelectedItem as tbEquipment).e_id;
s.scan_para_SourceType = cscSourceType.Text;
s.scan_para_Camera = cscCamera.Text;
s.scan_para_SourceVoltage = getValueDouble(cscSourceVoltage.Text);
s.scan_para_SourceCurrent = getValueDouble(cscSourceCurrent.Text);
s.scan_para_SourcePower = getValueDouble(cscSourcePower.Text);
s.scan_para_Camera2Source = getValueDouble(cscCamera2Source.Text);
s.scan_para_Object2Source = getValueDouble(cscObejct2Souce.Text);
s.scan_para_VerticalObjectPosition = getValueDouble(cscVerticalObjectPosition.Text);
s.scan_para_ImagePixelSize = getValueDouble(cscPixelSize.Text);
s.scan_para_RotationStep = getValueDouble(cscRotationStep.Text);
s.scan_para_Exposure = getValueDouble(cscExposure.Text);
s.Abstract = cscSpecimen.Text + "-" + cscTagSpecimenParty.Text;
s.scan_source_save_path = "-";
s.open_status = (cscOpenStatus.SelectedItem as tbTag).tag_id;
s.date_in = DateTime.Now;
s.ref_id = (cscRef.SelectedItem as tbRef).ref_id;
s.UserId = Guid.Parse(CTHelper.GetConfig("userid"));
}
private void beUpdate_Click(object sender, EventArgs e)
{
int id = int.Parse(ceID.Text);
CTDBEntities db = new CTDBEntities();
var s = db.tbEquipment.FirstOrDefault(st => st.e_id == id);
s.e_nameA = ceNameA.Text;
s.e_name = ceName.Text;
s.e_note = ceNote.Text;
s.e_location = ceLocation.Text;
s.e_type = ceType.Text;
s.e_description = ceDescription.Text;
s.e_contact = ceContact.Text;
s.UserId = Guid.Parse(CTHelper.GetConfig("userid"));
db.SaveChanges();
refrashDataGridview(null, null);
}
void setDBValue(tbLabel s)
{
s.slice_id = sliceID;
s.scan_id = (clbSilceID.Tag as tbSlice).scan_id;
s.sp_id = (clbSilceID.Tag as tbSlice).sp_id;
s.label_author = clbAuthor.Text;
s.label_file_type = "-";
s.label_file_number = ucFileInfo1.ValueFileCount;
s.label_structure = clbStructure.Text;
s.label_method = clbMethod.Text;
s.label_title = clbTitle.Text;
s.label_srcfolder = clbSrcFolder.Text;
s.label_note = clbNote.Text;
s.open_status = int.Parse(clbOpenStatus.SelectedValue.ToString());
s.date_in = DateTime.Now;
s.UserId = Guid.Parse(CTHelper.GetConfig("userid"));
}
//equipment
private void beAdd_Click(object sender, EventArgs e)
{
var s = new tbEquipment();
s.e_nameA = ceNameA.Text;
s.e_name = ceName.Text;
s.e_note = ceNote.Text;
s.e_location = ceLocation.Text;
s.e_type = ceType.Text;
s.e_description = ceDescription.Text;
s.date_in = DateTime.Now;
s.e_contact = ceContact.Text;
s.UserId = Guid.Parse(CTHelper.GetConfig("userid"));
CTDBEntities ct = new CTDBEntities();
ct.tbEquipment.Add(s);
ct.SaveChanges(); //将修改保存到数据库中
refrashDataGridview(null, null);
}
void autoMatch(string s)
{
List <FormItemModel> formDatas = new List <FormItemModel>();
formDatas.Add(new FormItemModel()
{
Key = "sstring", Value = s
});
formDatas.Add(new FormItemModel()
{
Key = "para", Value = "ct"
});
formDatas.Add(new FormItemModel()
{
Key = "vcode", Value = "cts"
});
string r = CTHelper.PostForm(CTHelper.GetConfig("namesearchurl"), formDatas);
Console.Write(r);
//MessageBox.Show(r);
//cspeciesLatin.Text = cspeciesGenus.Text.Trim() + " " + cspeciesSpecies.Text.Trim();
//解析
JObject jo = JObject.Parse(r);
if (jo.GetValue("error_code").ToString() == "0")
{
if (jo.GetValue("data_count").ToString() != "0")
{
string datastr = jo.GetValue("data").ToString();
DataTable dt = Newtonsoft.Json.JsonConvert.DeserializeObject <DataTable>(datastr);
//MessageBox.Show(dt.Rows[0][0].ToString());
cspeciesCHN.Text = dt.Rows[0]["tag_tag"].ToString();
cspeciesLatin.Text = dt.Rows[0]["tag_En"].ToString();
}
}
}
void autoParse(string s)
{
List <FormItemModel> formDatas = new List <FormItemModel>();
formDatas.Add(new FormItemModel()
{
Key = "src", Value = s
});
formDatas.Add(new FormItemModel()
{
Key = "para", Value = "trans"
});
formDatas.Add(new FormItemModel()
{
Key = "vcode", Value = "iozName"
});
string r = CTHelper.PostForm(CTHelper.GetConfig("nameParseUrl"), formDatas);
Console.Write(r);
//MessageBox.Show(r);
//cspeciesLatin.Text = cspeciesGenus.Text.Trim() + " " + cspeciesSpecies.Text.Trim();
//解析
JObject jo = JObject.Parse(r);
if (jo.GetValue("la") != null)
{
string[] sl = jo.GetValue("la").ToString().Split(' ');
cspeciesGenus.Text = sl[0];
if (sl.Length > 1)
{
cspeciesSpecies.Text = sl[1];
}
}
}
//gridview=====load when select Table
private void tabControl2_SelectedIndexChanged(object sender, EventArgs e)
{
Guid uid = Guid.Parse(CTHelper.GetConfig("userid"));
dataGridView1.DataSource = null;
CTDBEntities ct = new CTDBEntities();
if (tabControl2.SelectedIndex == 0) //specimen
{
dataGridView1.DataSource = ct.tbSpecimen.Where <tbSpecimen>(c => c.UserId == uid).ToList <tbSpecimen>();
}
else if (tabControl2.SelectedIndex == 1) //scan
{
dataGridView1.DataSource = ct.tbScan.Where <tbScan>(c => c.UserId == uid).ToList <tbScan>();
}
else if (tabControl2.SelectedIndex == 2) //tag
{
dataGridView1.DataSource = ct.tbTag.ToList <tbTag>();
}
else if (tabControl2.SelectedIndex == 3) //help
{
DataTable dt = new DataTable();
dt.Columns.Add("Table Name");
dt.Columns.Add("Records");
dt.Rows.Add(new object[] { "Equipment", ct.tbEquipment.Count <tbEquipment>(c => c.UserId == uid).ToString() });
dt.Rows.Add(new object[] { "Tag", ct.tbTag.Count <tbTag>().ToString() });
dt.Rows.Add(new object[] { "Species", ct.tbSpecies.Count <tbSpecies>(c => c.UserId == uid).ToString() });
dt.Rows.Add(new object[] { "Specimen", ct.tbSpecimen.Count <tbSpecimen>(c => c.UserId == uid).ToString() });
dt.Rows.Add(new object[] { "Scan", ct.tbScan.Count <tbScan>(c => c.UserId == uid).ToString() });
dt.Rows.Add(new object[] { "Slice", ct.tbSlice.Count <tbSlice>(c => c.UserId == uid).ToString() });
dt.Rows.Add(new object[] { "Label", ct.tbLabel.Count <tbLabel>(c => c.UserId == uid).ToString() });
dt.Rows.Add(new object[] { "Files", ct.tbFile.Count <tbFile>(c => c.UserId == uid).ToString() });
dataGridView1.DataSource = dt;
}
}
/// <summary>record user information if the user first login, else update </summary>
void updateUserInfo()
{
Guid uid = Guid.Parse(CTHelper.GetConfig("userid"));
string username = CTHelper.GetConfig("username");
string mail = CTHelper.GetConfig("mail");
CTDBEntities ct = new CTDBEntities();
tbUser tu = null;
try { tu = ct.tbUser.Where(c => c.UserId == uid).Single(); }
catch (Exception ex) { Console.Write(ex.ToString()); }
if (tu == null)
{
tu = ct.tbUser.Create();
tu.UserId = uid;
tu.date_in = DateTime.Now;
ct.tbUser.Add(tu);
}
tu.UserName = username;
tu.mail = mail;
tu.date_up = DateTime.Now;
ct.SaveChanges();
this.Text = "Insect 3D Database Clicent -- " + username;
btnMDTag.Enabled = FormLogin.HasAuthorty("");
}
private void FormUpload_Load(object sender, EventArgs e)
{
lbDataset.Text = ParaDatasetID.ToString();
UserID = CTHelper.GetConfig("userid");
CTDBEntities ct = new CTDBEntities();
if (ParaTable == "ctdb-slice")
{
this.Text = "CTDB - Slice File";
lbTableName.Text = "SliceID";
tbSlice s = ct.tbSlice.Where(c => c.slice_id == ParaDatasetID).Single();
lbDSName.Text = s.Abstract;
lbSpecimenID.Text = s.tbScan.tbSpecimen.sp_id.ToString();
mitCreatedFromSlice.Visible = true;
cdFileRef.Visible = false;
}
else if (ParaTable == "ctdb-scan")
{
this.Text = "CTDB - Scan Source File";
lbTableName.Text = "ScanID";
tbScan s = ct.tbScan.Where(c => c.scan_id == ParaDatasetID).Single();
lbDSName.Text = s.Abstract;
lbSpecimenID.Text = s.tbSpecimen.sp_id.ToString();
cdFileRef.Visible = false;
}
else if (ParaTable == "ctdb-label")
{
this.Text = "CTDB - Tissue Label File";
lbTableName.Text = "LabelID";
tbLabel s = ct.tbLabel.Where(c => c.label_id == ParaDatasetID).Single();
lbDSName.Text = s.label_id.ToString();
lbSpecimenID.Text = s.tbSlice.tbScan.tbSpecimen.sp_id.ToString();
mitCreatedFromLabel.Visible = true;
cdFileRef.Visible = false;
}
else if (ParaTable == "ctdb-specimen")
{
this.Text = "CTDB - Specimen's Demo File";
lbTableName.Text = "SpecimenID";
tbSpecimen s = ct.tbSpecimen.Where(c => c.sp_id == ParaDatasetID).Single();
lbSpecimenID.Text = s.sp_id.ToString();
lbDSName.Text = s.Abstract;
// cdFileRef.Enabled = true;
}
else if (ParaTable == "ctdb-scanpara")
{
this.Text = "CTDB - scan parameter's picture file";
lbTableName.Text = "";
tbScan s = ct.tbScan.Where(c => c.scan_id == ParaDatasetID).Single();
lbDSName.Text = s.Abstract;
lbSpecimenID.Text = s.tbSpecimen.sp_id.ToString();
cdFileRef.Visible = false;
}
else
{
this.Close();
}
CTHelper.setControlTag(cdFileType, 14, ParaFileType); // 14 filetype, 指定的Image
CTHelper.setControlTag(cdFileOpenStatus, 31, 30); //31 share method, 30 share in group
CTHelper.LoadControl(cdFileRef, "tbRef", 4); // 14 filetype, 11 image
cdFileAuthor.Text = CTHelper.GetConfig("username");
refreshdb();
}
private void btnOCR_Click(object sender, EventArgs e)
{
return;
if (!int.TryParse(cscID.Text, out int id))
{
return;
}
OpenFileDialog d = new OpenFileDialog();
d.Title = "挑选参数图";
d.Filter = "Photos (*.jpg;*.png;*.bmp)|*.jpg;*.png;*.bmp";
if (d.ShowDialog() == DialogResult.OK)
{
string md5 = CTHelper.GetMD5Hash(d.FileName);
string f = CTHelper.CommonPath("app") + "\\" + md5 + ".pdf";
File.Copy(d.FileName, f);
string r = CTHelper.UploadAPI(f, id.ToString(), "upload", "ctdb-scanpara", "iozct", CTHelper.GetConfig("userid"));
Console.Write(r);
if (File.Exists(f))
{
File.Delete(f);
}
if (r == "")
{
//update tFile 表
}
}
}
//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);
}
