public void GetExistFileNotFinishCategory()
{
string returnMsg = string.Empty;
int errorCode = 0;
string[] parametersRequired = { "projectId" };
if (!CheckParamsRequired(parametersRequired, out errorCode, out returnMsg))
{
JsonResult <string> resultPar = new JsonResult <string> {
Code = errorCode, Message = returnMsg, Rows = 0, Result = null, Req_Date = DateTime.Now
};
GenerateJson(resultPar);
return;
}
FileCategoryBLL fcBll = new FileCategoryBLL();
string notFinished = fcBll.GetExistFileNotFinishCategory(context, out errorCode);
string message = ErrorCode.GetCodeMessage(errorCode);
List <string> lstNotFinished = new List <string>();
lstNotFinished.Add(notFinished);
JsonResult <string> result = new JsonResult <string> {
Code = errorCode, Message = message, Rows = 0, Result = lstNotFinished, Req_Date = DateTime.Now
};
GenerateJson(result);
return;
}
/// <summary>
/// 发送提醒
/// </summary>
public void SendDingtalkMessage()
{
string returnMsg = string.Empty;
int errorCode = 0;
// 校验参数
string[] parametersRequired = { "categoryId", "taskRemindId" };
if (!CheckParamsRequired(parametersRequired, out errorCode, out returnMsg))
{
JsonResult <string> result = new JsonResult <string> {
Code = errorCode, Message = returnMsg, Rows = 0, Result = null
};
GenerateJson(result);
return;
}
string taskRemindId = context.Request["taskRemindId"];
FileCategoryBLL fcBll = new FileCategoryBLL();
bool isSuccess = new TaskRemindingBLL().SetRemind(taskRemindId);
errorCode = isSuccess ? 0 : 1;
string message = ErrorCode.GetCodeMessage(errorCode);
JsonResult <string> result2 = new JsonResult <string> {
Code = errorCode, Message = message, Rows = 0, Result = null
};
GenerateJson(result2);
return;
}
public void AddFileCategory()
{
string returnMsg = string.Empty;
int errorCode = 0;
string[] parametersRequired = { "projectId", "categoryId", "description", "expiredate" };
if (!CheckParamsRequired(parametersRequired, out errorCode, out returnMsg))
{
JsonResult <string> result = new JsonResult <string> {
Code = errorCode, Message = returnMsg, Rows = 0, Result = null, Req_Date = DateTime.Now
};
GenerateJson(result);
return;
}
FileCategoryBLL fcBll = new FileCategoryBLL();
if (fcBll.AddFileCategory(context, out errorCode))
{
string message = ErrorCode.GetCodeMessage(errorCode);
JsonResult <string> result = new JsonResult <string> {
Code = errorCode, Message = message, Rows = 0, Result = null, Req_Date = DateTime.Now
};
GenerateJson(result);
return;
}
else
{
string message = ErrorCode.GetCodeMessage(errorCode);
JsonResult <string> result = new JsonResult <string> {
Code = errorCode, Message = message, Rows = 0, Result = null, Req_Date = DateTime.Now
};
GenerateJson(result);
return;
}
}
/// <summary>
/// 获取指定 project 下的文件列表
/// </summary>
public void GetFilesByProject()
{
string returnMsg = string.Empty;
int errorCode = 0;
// 校验参数
string[] parametersRequired = { "projectId" };
if (!CheckParamsRequired(parametersRequired, out errorCode, out returnMsg))
{
JsonResult <string> result = new JsonResult <string> {
Code = errorCode, Message = returnMsg, Rows = 0, Result = null
};
GenerateJson(result);
return;
}
string fileIconPath = Convert.ToString(ConfigurationManager.AppSettings["fileIconPath"]) ?? string.Empty;
FileHistoryBLL fileHistoryBLL = new FileHistoryBLL();
List <FileHistory> fileHistories = fileHistoryBLL.GetFileHistories(context, out errorCode);
// 如果有结果
if (fileHistories != null && fileHistories.Count() > 0)
{
List <FilesForTab> filesForTabs = new List <FilesForTab>();
foreach (var item in fileHistories)
{
FilesForTab file = new FilesForTab();
file.categoryId = item.PARENTID;
file.fileHistoryId = item.ID;
file.fileName = item.FILENAME;
file.fileExt = item.FILEEXTENSION;
file.fileIconPath = string.Format("{0}{1}", fileIconPath, FileIconHelper.GetFileIcon(item.FILEEXTENSION));
file.description = item.DESCRIPTION;
filesForTabs.Add(file);
}
string message = ErrorCode.GetCodeMessage(errorCode);
JsonResult <FilesForTab> result = new JsonResult <FilesForTab> {
Code = errorCode, Message = message, Rows = filesForTabs.Count, Result = filesForTabs
};
GenerateJson(result);
return;
}
// 结果集为空
else
{
string message = ErrorCode.GetCodeMessage(errorCode);
JsonResult <string> result = new JsonResult <string> {
Code = errorCode, Message = message, Rows = 0, Result = null
};
GenerateJson(result);
return;
}
}
public void GetProjectOperationLogs()
{
string returnMsg = string.Empty;
int errorCode = 0;
// 校验参数
string[] parametersRequired = { "projectId" };
if (!CheckParamsRequired(parametersRequired, out errorCode, out returnMsg))
{
JsonResult <string> result = new JsonResult <string> {
Code = errorCode, Message = returnMsg, Rows = 0, Result = null
};
GenerateJson(result);
return;
}
FileOperationLogBLL foBll = new FileOperationLogBLL();
DataSet dsFileOperationLogs = foBll.GetFileOperateLogs(context, out errorCode);
// 获取到结果
if (dsFileOperationLogs != null && dsFileOperationLogs.Tables.Count > 0 && dsFileOperationLogs.Tables[0].Rows.Count > 0)
{
List <SubFileOperateLog> fileOperateLogs = new List <SubFileOperateLog>();
DataTable dt = dsFileOperationLogs.Tables[0];
int rowsCount = dt.Rows.Count;
for (int i = 0; i < rowsCount; i++)
{
SubFileOperateLog file = new SubFileOperateLog();
file.operateDate = DateTimeHelper.ConvertDateTimeInt(Convert.ToDateTime(dt.Rows[i]["operateDate"]));
file.operateUser = Convert.ToString(dt.Rows[i]["operateUser"]);
file.operateContent = Convert.ToString(dt.Rows[i]["operateContent"]);
fileOperateLogs.Add(file);
}
string message = ErrorCode.GetCodeMessage(errorCode);
JsonResult <SubFileOperateLog> result = new JsonResult <SubFileOperateLog> {
Code = errorCode, Message = message, Rows = fileOperateLogs.Count, Result = fileOperateLogs
};
GenerateJson(result);
return;
}
// 结果集为空
else
{
string message = ErrorCode.GetCodeMessage(errorCode);
JsonResult <string> result = new JsonResult <string> {
Code = errorCode, Message = message, Rows = 0, Result = null
};
GenerateJson(result);
return;
}
}
/// <summary>
/// 获取 fileCategory 列表
/// </summary>
public void GetCategories()
{
string returnMsg = string.Empty;
int errorCode = 0;
// 校验参数
string[] parametersRequired = { "projectId" };
if (!CheckParamsRequired(parametersRequired, out errorCode, out returnMsg))
{
JsonResult <string> result = new JsonResult <string> {
Code = errorCode, Message = returnMsg, Rows = 0, Result = null
};
GenerateJson(result);
return;
}
FileCategoryBLL fcBll = new FileCategoryBLL();
List <FileCategory> categories = fcBll.GetCategories(context, out errorCode);
// 获取到结果
if (categories != null && categories.Count() > 0)
{
List <CategoryTabs> categoryTabs = new List <CategoryTabs>();
foreach (var item in categories)
{
CategoryTabs tab = new CategoryTabs();
tab.Id = item.ID;
tab.title = item.TITLE;
tab.description = item.DESCRIPTION;
tab.expiredate = DateTimeHelper.ConvertDateTimeInt(item.EXPIREDATE ?? DateTime.MinValue);
categoryTabs.Add(tab);
}
string message = ErrorCode.GetCodeMessage(errorCode);
JsonResult <CategoryTabs> result = new JsonResult <CategoryTabs> {
Code = errorCode, Message = message, Rows = categoryTabs.Count, Result = categoryTabs
};
GenerateJson(result);
return;
}
// 结果为空
else
{
string message = ErrorCode.GetCodeMessage(errorCode);
JsonResult <string> result = new JsonResult <string> {
Code = errorCode, Message = message, Rows = 0, Result = null
};
GenerateJson(result);
return;
}
}
/// <summary>
/// 校验必输参数
/// </summary>
/// <param name="paramsRequired">必输参数数组</param>
/// <param name="returnMsg">返回消息</param>
/// <returns>是否通过校验</returns>
public bool CheckParamsRequired(string[] paramsRequired, out int errorCode, out string errorMsg)
{
errorCode = 0;
errorMsg = string.Empty;
string[] parametersGet = context.Request.Params.AllKeys;
string param = paramsRequired.Except(parametersGet).FirstOrDefault();
if (!string.IsNullOrEmpty(param))
{
errorCode = 2004;
errorMsg = string.Format("{0}:{1}", ErrorCode.GetCodeMessage(errorCode), param);
return(false);
}
return(true);
}
/// <summary>
/// 根据选择的tal获取回复tab列表
/// </summary>
public void GetReplyToTab()
{
string returnMsg = string.Empty;
int errorCode = 0;
// 校验参数
string[] parametersRequired = { "projectId", "categoryId" };
if (!CheckParamsRequired(parametersRequired, out errorCode, out returnMsg))
{
JsonResult <string> result = new JsonResult <string> {
Code = errorCode, Message = returnMsg, Rows = 0, Result = null
};
GenerateJson(result);
return;
}
// 获取列表
FileCategoryBLL fcBll = new FileCategoryBLL();
DataTable fileCategories = fcBll.GetReplyToTab(context, out errorCode).Tables[0];
if (fileCategories != null && fileCategories.Rows.Count > 0)
{
List <SubTabs> subTabs = new List <SubTabs>();
for (int i = 0; i < fileCategories.Rows.Count; i++)
{
SubTabs sub = new SubTabs();
sub.Id = fileCategories.Rows[i]["ID"].ToString();
//sub.hasParent = fileCategories.Rows[i]["hasParent"].ToString() == "1";
sub.categoryId = fileCategories.Rows[i]["categoryId"].ToString();
sub.Title = fileCategories.Rows[i]["title"].ToString();
subTabs.Add(sub);
}
string message = ErrorCode.GetCodeMessage(errorCode);
JsonResult <SubTabs> result = new JsonResult <SubTabs> {
Code = errorCode, Message = message, Rows = subTabs.Count(), Result = subTabs
};
GenerateJson(result);
return;
}
else
{
string message = ErrorCode.GetCodeMessage(errorCode);
JsonResult <string> result = new JsonResult <string> {
Code = errorCode, Message = message, Rows = 0, Result = null
};
GenerateJson(result);
return;
}
}
/// <summary>
/// 判断是否提醒过
/// </summary>
public void GetIsRemind()
{
string returnMsg = string.Empty;
int errorCode = 0;
// 校验参数
string[] parametersRequired = { "categoryId" };
if (!CheckParamsRequired(parametersRequired, out errorCode, out returnMsg))
{
JsonResult <string> result = new JsonResult <string> {
Code = errorCode, Message = returnMsg, Rows = 0, Result = null
};
GenerateJson(result);
return;
}
string taskRemindId = string.Empty;
bool isReminded = false;
FileCategoryBLL fcBll = new FileCategoryBLL();
DataSet dsIsRemind = fcBll.GetIsRemindCategoriesId(context, out errorCode);
if (dsIsRemind != null && dsIsRemind.Tables.Count > 0 && dsIsRemind.Tables[0].Rows.Count > 0)
{
if ((string)dsIsRemind.Tables[0].Rows[0]["ISREMINDED"] == "1")
{
isReminded = true;
errorCode = 7001;
}
}
string message = ErrorCode.GetCodeMessage(errorCode);
TaskRemindEntity taskRemindEntity = new TaskRemindEntity {
Id = taskRemindId, IsRemind = isReminded
};
List <TaskRemindEntity> taskRemindEntities = new List <TaskRemindEntity>();
taskRemindEntities.Add(taskRemindEntity);
JsonResult <TaskRemindEntity> result2 = new JsonResult <TaskRemindEntity> {
Code = errorCode, Message = message, Rows = 0, Result = taskRemindEntities
};
GenerateJson(result2);
return;
}
public void PreviewFile()
{
string returnMsg = string.Empty;
int errorCode = 0;
// 校验参数
string[] parametersRequired = { "fileHistoryId" };
if (!CheckParamsRequired(parametersRequired, out errorCode, out returnMsg))
{
JsonResult <string> resultPra = new JsonResult <string> {
Code = errorCode, Message = returnMsg, Rows = 0, Result = null
};
GenerateJson(resultPra);
return;
}
string actPath = string.Empty;
string taskRootFolder = string.Empty;
string taskFolderWithoutEmpNo = string.Empty;
try
{
string fileHistoryId = context.Request["fileHistoryId"];
string previewFolder = ConfigurationManager.AppSettings["filePreviewFolder"].ToString();
// 根据 ID 获取到 fileHistory 对象
FileHistory fileHistory = new FileHistoryBLL().GetModel(fileHistoryId);
DataTable dtPrjIdAndCategory = new FileCategoryBLL().GetProjectIdByFileHistoryId(fileHistoryId).Tables[0];
string projectId = Convert.ToString(dtPrjIdAndCategory.Rows[0]["PROJECTID"]);
string category = Convert.ToString(dtPrjIdAndCategory.Rows[0]["category"]);
string folderName = Convert.ToString(dtPrjIdAndCategory.Rows[0]["folderName"]);
bool flag = new FileCategoryBLL().GetFilePathByProjectId(projectId, category, folderName, false, out actPath, out taskRootFolder, out taskFolderWithoutEmpNo, out errorCode);
string physicalFileName = Path.Combine(actPath, fileHistory.FILENAME);
if (File.Exists(physicalFileName))
{
System.Web.HttpServerUtility server = System.Web.HttpContext.Current.Server;
string previewHtmlFile = Path.Combine(previewFolder, fileHistory.ID + ".html");
LogHelper.WriteLine("previewHtmlFile Path: " + previewHtmlFile);
if (!File.Exists(previewHtmlFile))
{
string extName = Path.GetExtension(physicalFileName);
switch (extName)
{
case ".doc":
case ".docx":
//case ".rtf":
Office2HtmlHelper.Word2Html(physicalFileName, previewFolder, fileHistory.ID);
break;
case ".xls":
case ".xlsx":
Office2HtmlHelper.Excel2Html(physicalFileName, previewFolder, fileHistory.ID);
break;
default:
return;
}
}
List <PreviewResult> lstPre = new List <PreviewResult>();
if (File.Exists(previewHtmlFile))
{
string htmlFile = string.Format("/FilePreview/{0}.html", fileHistory.ID);
PreviewResult pre = new PreviewResult();
pre.previewUrl = htmlFile;
lstPre.Add(pre);
}
else
{
errorCode = 1;
returnMsg = "文件未能成功生成！";
}
JsonResult <PreviewResult> resultPre = new JsonResult <PreviewResult> {
Code = errorCode, Message = returnMsg, Rows = 0, Result = lstPre
};
GenerateJson(resultPre);
return;
}
errorCode = 6001;
returnMsg = ErrorCode.GetCodeMessage(errorCode);
JsonResult <string> result = new JsonResult <string> {
Code = errorCode, Message = returnMsg, Rows = 0, Result = null
};
GenerateJson(result);
return;
}
catch (Exception ex)
{
errorCode = 1;
LogHelper.WriteLine("预览生成出错：" + ex.Message + ex.StackTrace);
}
}
public void DownloadFile()
{
string returnMsg = string.Empty;
int errorCode = 0;
// 校验参数
string[] parametersRequired = { "fileHistoryId" };
if (!CheckParamsRequired(parametersRequired, out errorCode, out returnMsg))
{
JsonResult <string> resultPra = new JsonResult <string> {
Code = errorCode, Message = returnMsg, Rows = 0, Result = null
};
GenerateJson(resultPra);
return;
}
string actPath = string.Empty;
string taskRootFolder = string.Empty;
string taskFolderWithoutEmpNo = string.Empty;
string fileHistoryId = context.Request["fileHistoryId"];
// 根据 ID 获取到 fileHistory 对象
FileHistory fileHistory = new FileHistoryBLL().GetModel(fileHistoryId);
DataTable dtPrjIdAndCategory = new FileCategoryBLL().GetProjectIdByFileHistoryId(fileHistoryId).Tables[0];
string projectId = Convert.ToString(dtPrjIdAndCategory.Rows[0]["PROJECTID"]);
string category = Convert.ToString(dtPrjIdAndCategory.Rows[0]["category"]);
string folderName = Convert.ToString(dtPrjIdAndCategory.Rows[0]["folderName"]);
bool flag = new FileCategoryBLL().GetFilePathByProjectId(projectId, category, folderName, false, out actPath, out taskRootFolder, out taskFolderWithoutEmpNo, out errorCode);
string physicalFileName = Path.Combine(actPath, fileHistory.FILENAME);
if (File.Exists(physicalFileName))
{
string userId = UserProfile.GetInstance()?.ID;
string operateTypeName = "下载";
int operateTypeKey = new ConfigureBLL().GetConfig(ConfigTypeName.文件操作类型.ToString()).AsEnumerable().Where(item => item["configValue"].ToString() == operateTypeName).Select(item => Convert.ToInt32(item["configKey"])).FirstOrDefault();
FileOperationLog fileOperationLog = new FileOperationLog();
fileOperationLog.ID = Guid.NewGuid().ToString();
fileOperationLog.PROJECTID = projectId;
fileOperationLog.EMPLOYEEID = userId;
fileOperationLog.FILENAME = fileHistory.FILENAME;
fileOperationLog.OPERATETYPE = operateTypeKey;
fileOperationLog.OPERATEDATE = DateTime.Now;
fileOperationLog.OPERATECONTENT = operateTypeName + fileHistory.FILENAME;
fileOperationLog.OPERATEUSER = userId;
new FileOperationLogBLL().Add(fileOperationLog);
System.IO.Stream iStream = null;
// Buffer to read 10K bytes in chunk:
byte[] buffer = new Byte[10000];
// Length of the file:
int length;
// Total bytes to read.
long dataToRead;
// Identify the file to download including its path.
string filepath = physicalFileName;
// Identify the file name.
string filename = System.IO.Path.GetFileName(filepath);
try
{
// Open the file.
iStream = new System.IO.FileStream(filepath, System.IO.FileMode.Open,
System.IO.FileAccess.Read, System.IO.FileShare.Read);
// Total bytes to read.
dataToRead = iStream.Length;
context.Response.Clear();
context.Response.ClearHeaders();
context.Response.ClearContent();
context.Response.ContentType = "text/plain"; // Set the file type
context.Response.AddHeader("Content-Length", dataToRead.ToString());
context.Response.AddHeader("Content-Disposition", "attachment; filename=" + filename + "");
// Read the bytes.
while (dataToRead > 0)
{
// Verify that the client is connected.
if (context.Response.IsClientConnected)
{
// Read the data in buffer.
length = iStream.Read(buffer, 0, 10000);
// Write the data to the current output stream.
context.Response.OutputStream.Write(buffer, 0, length);
// Flush the data to the HTML output.
context.Response.Flush();
buffer = new Byte[10000];
dataToRead = dataToRead - length;
}
else
{
// Prevent infinite loop if user disconnects
dataToRead = -1;
}
}
}
catch (Exception ex)
{
// Trap the error, if any.
context.Response.Write("Error : " + ex.Message);
}
finally
{
if (iStream != null)
{
//Close the file.
iStream.Close();
}
context.Response.End();
}
}
errorCode = 6001;
returnMsg = ErrorCode.GetCodeMessage(errorCode);
JsonResult <string> result = new JsonResult <string> {
Code = errorCode, Message = returnMsg, Rows = 0, Result = null
};
GenerateJson(result);
return;
}
public void UploadSuccess()
{
string returnMsg = string.Empty;
int errorCode = 0;
string projectId = string.Empty;
string category = string.Empty;
string folder = string.Empty;
string userId = string.Empty;
string physicalFileName = string.Empty;
// 校验参数
string[] parametersRequired = { "parentId", "description", "taskid", "filename" };
if (!CheckParamsRequired(parametersRequired, out errorCode, out returnMsg))
{
JsonResult <string> resultChkPar = new JsonResult <string> {
Code = errorCode, Message = returnMsg, Rows = 0, Result = null
};
GenerateJson(resultChkPar);
return;
}
string taskid = context.Request["taskid"].ToString();
string filename = context.Request["filename"].ToString();
string parentId = Convert.ToString(context.Request["parentId"]);
string description = Convert.ToString(context.Request["description"]);
FileCategory fileCategory = new FileCategoryBLL().GetModel(parentId);
if (fileCategory != null)
{
projectId = fileCategory.PROJECTID;
folder = fileCategory.FOLDERNAME;
category = fileCategory.CATEGORY;
bool flag = MergeSplitFile(taskid, projectId, category, folder, filename, out physicalFileName, out errorCode);
if (flag)
{
userId = UserProfile.GetInstance()?.ID;
string fileNameRelativeToTaskFolder = Path.Combine(folder, filename);
bool addFileHisFlag = new FileHistoryBLL().AddFileHistory(parentId, filename, fileNameRelativeToTaskFolder, description, userId);
if (addFileHisFlag)
{
string operateTypeName = "上传";
int operateTypeKey = new ConfigureBLL().GetConfig(ConfigTypeName.文件操作类型.ToString()).AsEnumerable().Where(item => item["configValue"].ToString() == operateTypeName).Select(item => Convert.ToInt32(item["configKey"])).FirstOrDefault();
FileOperationLog fileOperationLog = new FileOperationLog();
fileOperationLog.ID = Guid.NewGuid().ToString();
fileOperationLog.PROJECTID = projectId;
fileOperationLog.EMPLOYEEID = userId;
fileOperationLog.FILENAME = filename;
fileOperationLog.OPERATETYPE = operateTypeKey;
fileOperationLog.OPERATEDATE = DateTime.Now;
fileOperationLog.OPERATECONTENT = operateTypeName + filename;
fileOperationLog.OPERATEUSER = userId;
new FileOperationLogBLL().Add(fileOperationLog);
JsonResult <string> resultOprLog = new JsonResult <string> {
Code = errorCode, Message = returnMsg, Rows = 0, Result = null
};
GenerateJson(resultOprLog);
return;
}
// 添加失败时，需删除已上传的文件
else
{
if (File.Exists(physicalFileName))
{
File.Delete(physicalFileName);
}
JsonResult <string> resultAddDb2 = new JsonResult <string> {
Code = errorCode, Message = "数据库记录添加失败", Rows = 0, Result = null
};
GenerateJson(resultAddDb2);
return;
}
}
returnMsg = ErrorCode.GetCodeMessage(errorCode);
JsonResult <string> resultAddDb = new JsonResult <string> {
Code = errorCode, Message = returnMsg, Rows = 0, Result = null
};
GenerateJson(resultAddDb);
return;
}
JsonResult <string> result = new JsonResult <string> {
Code = errorCode, Message = "未找到 projectId 对应的记录", Rows = 0, Result = null
};
GenerateJson(result);
return;
}