///// <summary>
///// 获取文件最新的版本
///// </summary>
///// <param name="fileName"></param>
///// <param name="forderId"></param>
///// <returns></returns>
//public int GetFileLastVer(string fileName, int forderId)
//{
// return dal.GetFileLastVer(fileName, forderId);
//}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.FileVersion model)
{
return(dal.Add(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.FileVersion model)
{
string contentId = Guid.NewGuid().ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [" + databaseprefix + "FileVersion](");
strSql.Append("Ver,UserID,UserName,File_Id,File_Type,File_Size,File_Md5,File_Ext,File_SmallImage,File_LargeImage,Content,File_Modify_Time,IsDeleted,ActionNum,ComputerName,Ip,ClientPath,Remark,Add_Time,FileContentId)");
strSql.Append(" values (");
strSql.Append("@Ver,@UserID,@UserName,@File_Id,@File_Type,@File_Size,@File_Md5,@File_Ext,@File_SmallImage,@File_LargeImage,@Content,@File_Modify_Time,@IsDeleted,@ActionNum,@ComputerName,@Ip,@ClientPath,@Remark,@Add_Time,@FileContentId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Ver", SqlDbType.Int, 4),
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@UserName", SqlDbType.NVarChar, 100),
new SqlParameter("@File_Id", SqlDbType.Int),
new SqlParameter("@File_Type", SqlDbType.NVarChar, 100),
new SqlParameter("@File_Size", SqlDbType.Int),
new SqlParameter("@File_Md5", SqlDbType.NVarChar, 100),
new SqlParameter("@File_Ext", SqlDbType.NVarChar, 200),
new SqlParameter("@File_SmallImage", SqlDbType.VarBinary),
new SqlParameter("@File_LargeImage", SqlDbType.VarBinary),
new SqlParameter("@Content", SqlDbType.VarBinary),
new SqlParameter("@File_Modify_Time", SqlDbType.BigInt),
new SqlParameter("@IsDeleted", SqlDbType.TinyInt),
new SqlParameter("@ActionNum", SqlDbType.TinyInt),
new SqlParameter("@ComputerName", SqlDbType.NVarChar, 200),
new SqlParameter("@Ip", SqlDbType.NVarChar, 200),
new SqlParameter("@ClientPath", SqlDbType.NVarChar, 2000),
new SqlParameter("@Remark", SqlDbType.NVarChar, 2000),
new SqlParameter("@Add_Time", SqlDbType.DateTime),
new SqlParameter("@FileContentId", SqlDbType.NVarChar),
};
parameters[0].Value = model.Ver;
parameters[1].Value = model.UserID;
parameters[2].Value = model.UserName;
parameters[3].Value = model.File_Id;
parameters[4].Value = model.File_Type;
parameters[5].Value = model.File_Size;
parameters[6].Value = model.File_Md5;
parameters[7].Value = model.File_Ext;
parameters[8].Value = model.File_SmallImage;
parameters[9].Value = model.File_LargeImage;
parameters[10].Value = new byte[1];
parameters[11].Value = model.File_Modify_Time;
parameters[12].Value = model.IsDeleted;
parameters[13].Value = model.ActionNum;
parameters[14].Value = model.ComputerName;
parameters[15].Value = model.Ip;
parameters[16].Value = model.ClientPath;
parameters[17].Value = model.Remark;
parameters[18].Value = model.Add_Time;
parameters[19].Value = contentId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
int retId = Convert.ToInt32(obj);
//文件内容的上传
Model.FileContentModel contentModel = new FileContentModel()
{
ID = contentId,
Add_Time = DateTime.Now,
File_Content = model.Content,
File_ID = model.File_Id,
File_Ver = model.Ver.ToString(),
File_VerID = retId
};
string fileContentId = new DAL.FileContentDal(databaseprefix).Add(contentModel);
if (obj == null || string.IsNullOrEmpty(fileContentId))
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
