/// <summary>
/// 获取删除时插入日志表sql
/// </summary>
/// <param name="modelInfo"></param>
/// <param name="userId"></param>
/// <returns></returns>
protected override string GetInsertDeleteHistory(XModelBase modelInfo, string userId)
{
XFileAttachmentInfo info = modelInfo as XFileAttachmentInfo;
string sql = "Insert Into " + this.HistoryTableName + "(RID,FileId,AtchName,AtchDesc,AtchType,AtchSize,AtchPath,AtchShotGifPath,AtchImag,InputUserId,InputTime,OperateUserId,Operate,OperateTime,NewID) SELECT RID,FileId,AtchName,AtchDesc,AtchType,AtchSize,AtchPath,AtchShotGifPath,AtchImag,InputUserId,InputTime,'" + userId + "','删除',getdate(),newid() FROM " + this.TableName + " WHERE " + this.PrimaryKey + "='" + info.RID + "'";
return(sql);
}
/// <summary>
/// 获取插入sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetInsertSql(XModelBase modelInfo)
{
XFileAttachmentInfo info = modelInfo as XFileAttachmentInfo;
string sql = "Insert Into " + this.TableName + "(RID,FileId,AtchName,AtchDesc,AtchType,AtchSize,AtchPath,AtchShotGifPath,AtchImag,InputUserId,InputTime)Values('{0}','{1}','{2}','{3}','{4}',{5},'{6}','{7}','{8}','{9}',{10})";
sql = String.Format(sql, info.RID, info.FileId, info.AtchName, info.AtchDesc, info.AtchType, info.AtchSize, info.AtchPath, info.AtchShotGifPath, info.AtchImag, info.InputUserId, this.GetServerTimeFuncion());
return(sql);
}
public static bool Preview(string fileId)
{
string where = " and FileId='" + fileId + "'";
IList <XModelBase> fileAttachInfos = m_FileAttachBusiness.QueryByWhere(where);
if (fileAttachInfos.Count == 0)
{
XMessageBox.ShowError("未找到附件，无法预览！");
return(false);
}
XFileAttachmentInfo fileInfo = fileAttachInfos[0] as XFileAttachmentInfo;
string[] imageTypes = new string[] { ".png", ".jpg", ".jpeg" };
string[] officeTypes = new string[] { ".doc", ".docx", ".xls", ".xlsx" };
if (!imageTypes.Contains(fileInfo.AtchType) &&
!officeTypes.Contains(fileInfo.AtchType))
{
XMessageBox.ShowError("不支持预览格式为[" + fileInfo.AtchType + "]的文件！");
return(false);
}
string path = XCommon.TempPath;
string fileName = Guid.NewGuid().ToString();
fileName = m_FileAttachBusiness.DownLoadFile(fileId, path, fileName);
if (imageTypes.Contains(fileInfo.AtchType))
{
//如果是图片
frmImagePreview frm = new frmImagePreview(fileName);
frm.ShowDialog();
}
else
{
frmOfficeFilePreview frm = new frmOfficeFilePreview(fileName);
frm.ShowDialog();
}
if (File.Exists(fileName))
{
try
{
File.Delete(fileName);
}
catch (Exception ex)
{
XErrorLogTool.WriteLog(ex.ToString());
}
}
return(true);
}
/// <summary>
/// 获取更新Sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetUpdateSql(XModelBase modelInfo)
{
string sql = String.Empty;
XFileAttachmentInfo info = modelInfo as XFileAttachmentInfo;
sql = "Update " + this.TableName + " Set FileId='{0}',AtchName='{1}',AtchDesc='{2}',AtchType='{3}',AtchSize={4},AtchPath='{5}',AtchShotGifPath='{6}',AtchImag='{7}', Where RID='{8}'";
sql = string.Format(sql, info.FileId, info.AtchName, info.AtchDesc, info.AtchType, info.AtchSize, info.AtchPath, info.AtchShotGifPath, info.AtchImag, info.RID);
return(sql);
}
/// <summary>
/// 自定义修改校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateUpdateCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XFileAttachmentInfo fileattachment = modelInfo as XFileAttachmentInfo;
if (fileattachment == null)
{
return(this.GetNotRightType());
}
return(string.Empty);
}
/// <summary>
/// 将数据行转换为实体
/// </summary>
/// <param name="modelRow">数据行记录</param>
/// <returns>实体信息</returns>
protected override void DataRow2ModelBase(XModelBase modelInfo, DataRow modelRow)
{
XFileAttachmentInfo info = modelInfo as XFileAttachmentInfo;
info.ID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.RID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.FileId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "FileId")); //文档主键
info.AtchName = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "AtchName")); //附件名称
info.AtchDesc = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "AtchDesc")); //附件描述
info.AtchType = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "AtchType")); //附件类型
info.AtchSize = XHelper.GetDouble(XDataRowHelper.GetFieldValue(modelRow, "AtchSize")); //附件大小
info.AtchPath = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "AtchPath")); //附件路径
info.AtchShotGifPath = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "AtchShotGifPath")); //缩略图路径
info.AtchImag = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "AtchImag")); //流文件
info.InputUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "InputUserId")); //录入人
info.InputTime = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "InputTime")); //录入时间
}
