/// <summary> /// 根据ParentGuid得到第一个附件的文件名 /// </summary> /// <param name="ParentGuid"></param> /// <returns></returns> public static String GetFirstFileName(String ParentGuid) { String result = String.Empty; if (String.IsNullOrEmpty(ParentGuid) == false) { List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("parentGuid", ParentGuid)); JAttachmentDA da1 = new JAttachmentDA(); DataRow dr1 = da1.GetFirstDataRow(condition, "EncryptFileName"); if (dr1 != null) { result = dr1[0].ToString(); } } return(result); }
/// <summary> /// 得到相关的附件数量 /// </summary> /// <param name="ParentGuid"></param> /// <returns></returns> public static int GetFileCount(String ParentGuid) { int result = 0; if (String.IsNullOrEmpty(ParentGuid) == false) { List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("ParentGuid", ParentGuid)); JAttachmentDA da1 = new JAttachmentDA(); DataRow dr1 = da1.GetFirstDataRow(condition, "count(*) as count0"); if (dr1 != null) { result = int.Parse(dr1[0].ToString()); } } return(result); }
/// <summary> /// 删除附件中的数据 /// </summary> /// <param name="guidID"></param> /// <returns></returns> public bool DeleteData(String guidID) { bool succ = false; try { if (String.IsNullOrEmpty(guidID) == false) { List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("guidID", guidID)); JAttachmentDA da1 = new JAttachmentDA(); DataRow dr1 = da1.GetFirstDataRow(condition, "*"); if (dr1 != null) { String file1 = dr1["FileDir"].ToString() + dr1["EncryptFileName"].ToString(); //删除数据库 da1.DeleteData(condition); //删除文件 file1 = HttpContext.Current.Server.MapPath(file1); if (File.Exists(file1)) { File.Delete(file1); } //删除文件2 file1 = dr1["EncryptFileName"].ToString(); file1 = HttpContext.Current.Server.MapPath(file1); if (File.Exists(file1)) { File.Delete(file1); } } } succ = true; } catch (Exception err) { throw err; } return(succ); }