//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 bSpeciesAdd_Click(object sender, EventArgs e) { tbRef s = new tbRef(); setDBValue(s); CTDBEntities ct = new CTDBEntities(); ct.tbRef.Add(s); ct.SaveChanges(); //将修改保存到数据库中 refreshdata(null, null); }
private void dataGridView1_SelectionChanged(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 1) { int id = (int)dataGridView1.SelectedRows[0].Cells[0].Value; CTDBEntities ct = new CTDBEntities(); var q = from c in ct.tbRef where c.ref_id == id select c; List <tbRef> sl = q.ToList <tbRef>(); tbRef s = sl[0]; { refID.Text = s.ref_id.ToString(); refCite.Text = s.cite; refTitle.Text = s.title; refURL.Text = s.url; refAuthor.Text = s.author; refYear.Text = s.year.ToString(); refDoc.Text = s.doc; } string str = ""; } }