/// <summary> ///根据文件名和文件md5判断是否已经上传 /// </summary> /// <param name="fileName"></param> /// <param name="fileMd5"></param> /// <returns></returns> public int GetFileID(System.Data.SqlClient.SqlConnection connection, int forderID, string fileName, string fileMd5) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID from " + databaseprefix + "File"); strSql.Append(" where File_DirId=@forderID and File_Name=@fileName and isDeleted =0"); SqlParameter[] parameters = { new SqlParameter("@forderID", SqlDbType.Int), new SqlParameter("@fileName", SqlDbType.VarChar), new SqlParameter("@fileMd5", SqlDbType.VarChar), }; parameters[0].Value = forderID; parameters[1].Value = fileName; parameters[2].Value = fileMd5; return(Convert.ToInt32(DbHelperSQLEx.GetSingle(connection, strSql.ToString(), parameters))); }
/// <summary> /// 是否存在该记录 /// </summary> public int GetForderId(System.Data.SqlClient.SqlConnection connection, int parentId, string forderName, string userName, int projectId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id from " + databaseprefix + "Forder"); strSql.Append(" where Parent_Id=@Parent_Id and Title=@Title and Project_Id=@Project_Id and isdeleted = 0"); SqlParameter[] parameters = { new SqlParameter("@Parent_Id", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.VarChar, 200), new SqlParameter("@Project_Id", SqlDbType.Int, 4), }; parameters[0].Value = parentId; parameters[1].Value = forderName; parameters[2].Value = projectId; return(Convert.ToInt32(DbHelperSQLEx.GetSingle(connection, strSql.ToString(), parameters))); }
/// <summary> /// 获取文件最新版本 /// </summary> /// <param name="fileId"></param> /// <returns></returns> public Model.FileVersion GetFileLastVer(System.Data.SqlClient.SqlConnection connection, int fileId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 V.ID from " + databaseprefix + "File F left join " + databaseprefix + "FileVersion V on F.id = V.File_Id"); if (fileId > 0) { strSql.Append(" where F.id = @fileId "); } strSql.Append(" order by v.ver desc"); SqlParameter[] parameters = { new SqlParameter("@fileId", SqlDbType.Int, 4), }; parameters[0].Value = fileId; int verID = Convert.ToInt32(DbHelperSQLEx.GetSingle(connection, strSql.ToString(), parameters)); return(new FileVersionDalEx(databaseprefix).GetModel(connection, verID)); }