/// <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));
}
