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 表
}
}
}
//从数据库里检测相关数据，看网页是否可以访问
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;
}
//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;
}
}
}
/// <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 mitExportZipFileForServerToolStripMenuItem_Click(object sender, EventArgs e)
{
ArrayList sl = dataGridView1.DataSource as ArrayList;
if (sl.Count > 0)
{
if (MessageBox.Show("确认打包" + sl.Count + " records?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
string fd = CTHelper.CommonPath() + "\\ctdbr";
if (!Directory.Exists(fd))
{
Directory.CreateDirectory(fd);
}
progressBar1.Visible = true;
progressBar1.Maximum = sl.Count;
progressBar1.Value = 0;
using (var db = new CTDBEntities())
foreach (tbLabel ts in sl)
{
progressBar1.Value++;
try
{
//MessageBox.Show(ts.label_id.ToString());
tbLabel lb = db.tbLabel.FirstOrDefault(s => s.label_id == ts.label_id);
string src = lb.label_srcfolder;
string des = fd + "\\" + lb.label_id + ".zip";
if (File.Exists(des))
{
continue;
}
CTHelper.ZipDirectory(src, des);
System.Threading.Thread.Sleep(500);
}
catch { }
}
progressBar1.Visible = false;
System.Diagnostics.Process.Start(fd);
}
}
}
private void miUpload_Click(object sender, EventArgs e)
{
//阻止休眠
CTHelper.PreventSleep();
//upload files
pbar1.Maximum = lboxFile.Items.Count;
pbar1.Value = 0;
lbNote.Text = "开始上传文件";
string logl = CTHelper.CommonPath("app") + "\\upload.log";
int countOK = 0, countError = 0;
foreach (string fileSrc in lboxFile.Items)
{
pbar1.Value++;
lbNote.Text = pbar1.Value + "/" + lboxFile.Items.Count + ", " + countOK + " OK," + countError + " Fail";
if (checkSkipSameFile.Checked) //重复检查
{
string checkfilename = Path.GetFileName(fileSrc);
using (CTDBEntities ct = new CTDBEntities())
{
var q = from c in ct.tbFile
where c.f_pid == ParaDatasetID && c.f_table == ParaTable && c.f_path.Contains(checkfilename)
select c;
if (q.ToList <tbFile>().Count > 0)
{
continue;
}
}
}
//check names before upload上传前检测，名称检测
string fileDes = CTHelper.CommonPath("app") + "\\" + Path.GetFileName(fileSrc).Replace(" ", "");
if (File.Exists(fileDes))
{
File.Delete(fileDes);
}
File.Copy(fileSrc, fileDes, true);
string md5 = CTHelper.GetMD5Hash(fileDes);
string fn = md5 + System.IO.Path.GetExtension(fileDes);
/////////begin to upload开始上传
if (File.Exists(fileDes))
{
addFile(fileDes, fileSrc, ParaTable, ParaDatasetID); /////核心上传函数
}
///////////////////
File.Delete(fileDes);
this.Enabled = true;
Application.DoEvents();
}
this.Enabled = true;
//finished
refreshdb();
MessageBox.Show("Finishe upload. Error number:" + countError.ToString());
lbNote.Text = "Finish Upload.";
//恢复休眠
CTHelper.RestoreSleep();
}
