private void dmbImp_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtdocfile.Text.Trim()))
{
return;
}
string treetype = manForm.treetype;
int parentid = Convert.ToInt32(manForm.parentid);
string doc_path = txtdocfile.Text.Trim();
string doc_type = doc_path.Substring(doc_path.LastIndexOf(".") + 1); //文件类型
string dco_name = doc_path.Substring(doc_path.LastIndexOf("\\") + 1); //文件名
if (!Directory.Exists(ConfigHelper.documentClass_FILE))
{
Directory.CreateDirectory(ConfigHelper.documentClass_FILE);
}
string savename = DateTime.Now.ToString("yyyyMMdd") + Guid.NewGuid() + dco_name;
File.Copy(doc_path, ConfigHelper.documentClass_FILE + savename);
Sys_DocumentClass sdc = new Sys_DocumentClass();
sdc.del_status = 0;
sdc.doc_Fsid = parentid;
sdc.doc_Name = dco_name;
sdc.doc_Path = ConfigHelper.documentClass_FILE;
sdc.doc_savename = savename;
sdc.doc_Type = doc_type;
bfo.Insert(sdc);
MetroMessageBox.Show(this, "导入成功！");
this.Close();
}
public void Insert(Sys_DocumentClass sdc)
{
string sql = string.Format(@"INSERT INTO Sys_DocumentClass (doc_Name,doc_savename,doc_Path,doc_Type,del_status,doc_Fsid) values
('{0}','{1}','{2}','{3}',{4},{5})", sdc.doc_Name, sdc.doc_savename, sdc.doc_Path, sdc.doc_Type, sdc.del_status, sdc.doc_Fsid);
DbHelperSQLite.ExecuteSql(sql);
}
public void Insert(Sys_DocumentClass sdc)
{
dao.Insert(sdc);
}
