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