//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 = "";
}
}
