/// <summary>
/// 文件删除校验
/// </summary>
/// <returns></returns>
bool CheckCorrectDelete()
{
bool tempDeleteNoLimite = SysConvert.ToBoolean(UCFileUPParamSet.GetIntValueByID(7203)); //文件管理的文件删除权限不做限制
int tempDeleteHours = UCFileUPParamSet.GetIntValueByID(7204); //文件管理的文件删除限制在多少小时内，除非是管理员
if (tempDeleteHours == 0)
{
tempDeleteHours = 24;//默认24小时
}
if (!tempDeleteNoLimite) //限制本人或管理员
{
if (!UCMangerFlag) //如果不是管理员
{
if (SysConvert.ToString(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "UploadOPID")) != UCUploadOPID)
{
this.ShowMessage("上传人不是本人，不允许删除");
return(false);
}
}
}
if (tempDeleteHours > 0)//校验删除时效性
{
DateTime uploadTime = SysConvert.ToDateTime(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "UploadTime"));
TimeSpan ts = UCFileUPParamSet.ServerTime - uploadTime;
if (ts.TotalHours > tempDeleteHours)
{
this.ShowMessage("超过时效性(" + tempDeleteHours + "小时)，不允许删除");
return(false);
}
}
return(true);
}
/// <summary>
/// 换行改变事件
/// </summary>
/// <param name="sender"></param>
private void gridViewRowChanged3(object sender)
{
try
{
ColumnView view = sender as ColumnView;
saveFileID = SysConvert.ToInt32(view.GetRowCellValue(view.FocusedRowHandle, "ID"));
saveFileName = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "FileName"));
saveFileExe = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "FileExe"));
string tempExe = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "FileExe")).ToLower();
if (tempExe == ".jpg" || tempExe == ".gif" || tempExe == ".bmp")//如果是图片
{
bool autoshowPic = SysConvert.ToBoolean(UCFileUPParamSet.GetIntValueByID(7206));
if (autoshowPic)//自动显示图片
{
groupControlBRight.Visible = true;
PictureSet(saveFileID);
}
else
{
groupControlBRight.Visible = false;
}
}
else
{
groupControlBRight.Visible = false;
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 新增(传入事务处理)
/// </summary>
/// <param name="sqlTrans">事务类</param>
public int RAdd(byte[] p_File, int winListID, int headtype, int subtype, int dataid, int dataSeq, string fileName, string filetitle, string fileExec, string p_Remark, string p_FileProt1, string p_FileProt2, decimal fileSize, string LoginID, string LoginName, int loginLogID, IDBTransAccess sqlTrans)
{
try
{
int sysEntityID = UCFileUPParamSet.GetIntValueByID(7201);//获得文件管理实体ID
if (sysEntityID == 0)
{
sysEntityID = 45;//默认是45
}
int maxID = (int)EntityIDTable.GetID(sysEntityID, (int)DBSort.Default, sqlTrans);
string sql = string.Empty;
//sql = "SELECT ISNULL(MAX(Seq),0)+1 MSeq FROM Pro_TecFile WHERE TecID=" + SysString.ToDBString(tecID);
//int maxSeq = 0;// SysConvert.ToInt32(sqlTrans.Fill(sql).Rows[0][0]);
sql = "INSERT INTO Data_WinListAttachFile(ID,WinListID,HeadType,SubType,HTDataID,HTDataSeq,FileName,FileContext,FileSize";
sql += ",UploadTime,UploadOPID,UploadOPName,UploadLoginLogID,FileExe,Remark,FileProt1,FileProt2)";
sql += "VALUES(" + maxID + "," + winListID + "," + headtype + "," + subtype + "," + dataid + "," + dataSeq + "," + SysString.ToDBString(fileName) + ",@Context," + SysString.ToDBString(fileSize);
sql += ",GetDate()," + SysString.ToDBString(LoginID) + "," + SysString.ToDBString(LoginName) + "," + SysString.ToDBString(loginLogID);
sql += "," + SysString.ToDBString(fileExec) + "," + SysString.ToDBString(p_Remark) + "," + SysString.ToDBString(p_FileProt1) + "," + SysString.ToDBString(p_FileProt2);
sql += ")";
object[,] obja = new object[2, 1];
obja[0, 0] = "@Context";
obja[1, 0] = p_File;
sqlTrans.ExecuteNonQuery(sql, obja);
return(maxID);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}