/// <summary>
/// 向应急预案表中添加记录。
/// </summary>
/// <param name="EmergencyPlan">应急预案记录</param>
/// <returns>true：表示保存成功，false：表示保存失败</returns>
private bool AddEmergencyPlanInfo(t_PM_EmergencyPlan EmergencyPlan)
{
bool flag = false;
try
{
bll.t_PM_EmergencyPlan.AddObject(EmergencyPlan);
bll.SaveChanges();
flag = true;
}
catch (Exception ex)
{
flag = false;
}
return(flag);
}
/// <summary>
/// 删除信息
/// </summary>
/// <param name="epid"></param>
/// <returns></returns>
public ActionResult OnDelete(int epid)
{
string strJson = "success";
try
{
string fileSaveName = string.Empty;
//从t_cm_files表中获取文件名称，并删除表中记录
List <t_cm_files> Filelist = bll.t_cm_files.Where(d => (d.Fk_ID == epid && d.Modules == "EmergencyPlan")).ToList();
if (Filelist.Count > 0)
{
t_cm_files files_Temp = Filelist[0];
string filePath_Temp = files_Temp.FilePath;
string[] fileArry = filePath_Temp.Split('/');
if (fileArry.Length > 0)
{
fileSaveName = fileArry[fileArry.Length - 1];
}
else
{
}
//删除文件
string filePath = Server.MapPath("~/UploadFiles/EmergencyPlan/");
DirectoryUtil.DeleteFile(filePath + fileSaveName);
//删除记录
bll.t_cm_files.DeleteObject(files_Temp);
bll.SaveChanges();
Common.InsertLog("应急预案管理", CurrentUser.UserName, "删除应急预案[" + epid + "]");//log
}
//在t_PM_EmergencyPlan表中删除记录。
List <t_PM_EmergencyPlan> list = bll.t_PM_EmergencyPlan.Where(d => (d.EPID == epid)).ToList();
if (list.Count > 0)
{
t_PM_EmergencyPlan EmergencyPlan = list[0];
bll.t_PM_EmergencyPlan.DeleteObject(EmergencyPlan);
bll.SaveChanges();
}
}
catch (Exception ex)
{
strJson = "error";
}
return(Content(strJson));
}
/// <summary>
/// 获取预案编号
/// </summary>
/// <returns></returns>
private int GetCurEPID(string fileName)
{
int epid_temp = 0;
string strsql = string.Empty;
strsql = string.Format("select TOP 1 P.EPID, P.PID, P.Name, P.Remarks from t_PM_EmergencyPlan P where P.Name = '{0}' order by P.EPID desc ", fileName);
if (!string.IsNullOrEmpty(strsql))
{
List <t_PM_EmergencyPlan> list = bll.ExecuteStoreQuery <t_PM_EmergencyPlan>(strsql).ToList();
if (list.Count > 0)
{
t_PM_EmergencyPlan EmergencyPlan = list[0];
epid_temp = EmergencyPlan.EPID;
}
}
else
{
}
return(epid_temp);
}
/// <summary>
/// 删除已经上传的文件
/// </summary>
/// <param name="id"></param>
public ActionResult DeleteFile2(string filename, string ctype, int pid)
{
string strJson = "success";
try
{
int epid = 0;
//记录预案编号
string filePath = Server.MapPath("~/UploadFiles/EmergencyPlan/");
DirectoryUtil.DeleteFile(filePath + filename);
//删除文件到t_PM_EmergencyPlan表和t_cm_files表中。
List <t_cm_files> Filelist = bll.t_cm_files.Where(d => (d.FileName.Contains(filename) && d.FileType == ctype && d.Modules == "EmergencyPlan")).ToList();
if (Filelist.Count > 0)
{
t_cm_files files_Temp = Filelist[0];
epid = int.Parse(files_Temp.Fk_ID.ToString().Trim());
string mappth = System.AppDomain.CurrentDomain.BaseDirectory;
string fileName = "";
fileName = mappth + files_Temp.FilePath.Replace("~", "").Replace("/", "\\");//删除对应路径的文件
DirectoryUtil.DeleteFile(fileName);
bll.t_cm_files.DeleteObject(files_Temp);
bll.SaveChanges();
}
List <t_PM_EmergencyPlan> list = bll.t_PM_EmergencyPlan.Where(d => (d.EPID == epid && d.PID == pid)).ToList();
if (list.Count > 0)
{
t_PM_EmergencyPlan EmergencyPlan = list[0];
bll.t_PM_EmergencyPlan.DeleteObject(EmergencyPlan);
bll.SaveChanges();
}
}
catch (Exception ex)
{
strJson = "error";
}
return(Content(strJson));
}
/// <summary>
/// 信息查询
/// </summary>
/// <param name="epid">预案编号</param>
/// <param name="pid">配电室编号</param>
/// <returns></returns>
public ActionResult OnSearch(int epid, int pid)
{
try
{
string strJson = string.Empty;
StringBuilder sbSearchInfo = new StringBuilder();
sbSearchInfo.Append(" <ul> ");
if (epid == 0 && pid == 0)
{
//编号都为空
}
else if (epid == 0 && pid != 0)
{
//按照配电房编号进行查询
//t_PM_EmergencyPlan表
List <t_PM_EmergencyPlan> list = bll.t_PM_EmergencyPlan.Where(d => (d.PID == pid)).ToList();
if (list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
t_PM_EmergencyPlan EmergencyPlan = list[i];
//t_cm_files表中。
List <t_cm_files> Filelist = bll.t_cm_files.Where(d => (d.Fk_ID == EmergencyPlan.EPID && d.Modules == "EmergencyPlan")).ToList();
if (Filelist.Count > 0)
{
//获取当前预案上传文件的详细信息
t_cm_files files_Temp = Filelist[0];
sbSearchInfo.Append(" <li> ");
sbSearchInfo.Append(" <div> ");
sbSearchInfo.Append(" <img src=\"../content/images/wordicon.png\" /> ");
sbSearchInfo.Append(" <span>");
sbSearchInfo.Append(" <h3>");
string fileSaveName = string.Empty;
string[] fileNameArry_Temp = files_Temp.FileName.Split('.');
if (fileNameArry_Temp.Length > 0)
{
fileSaveName = fileNameArry_Temp[0];
}
else
{
}
sbSearchInfo.Append(fileSaveName);
sbSearchInfo.Append(" </h3>");
sbSearchInfo.Append(" <p>");
DateTime dateTime_Temp = new DateTime();
dateTime_Temp = DateTime.Parse(files_Temp.CommitTime.ToString().Trim());
sbSearchInfo.Append(" 上传：");
sbSearchInfo.Append(dateTime_Temp.ToString("yyyy-MM-dd HH:mm:ss"));
sbSearchInfo.Append(" </p>");
sbSearchInfo.Append(" <p>");
sbSearchInfo.Append(" 大小：");
sbSearchInfo.Append(files_Temp.FileSize);
sbSearchInfo.Append(" </p>");
sbSearchInfo.Append(" </span>");
sbSearchInfo.Append(" </div> ");
sbSearchInfo.Append(" <div class=\"standfile_btn\">");
sbSearchInfo.Append(" <button");
sbSearchInfo.Append(" title=\"下 载\" onclick=\"DoDownload('");
string[] fileDirArry_Temp = files_Temp.FilePath.Split('/');
string newFileDir = string.Empty;
if (fileDirArry_Temp.Length > 0)
{
for (int j = 1; j < fileDirArry_Temp.Length; j++)
{
newFileDir = newFileDir + "/" + fileDirArry_Temp[j].Trim();
}
}
else
{
}
sbSearchInfo.Append(newFileDir);
sbSearchInfo.Append("')\"");
sbSearchInfo.Append(" class=\"page_table_but3 radius5\"><img src=\"../content/images/download.png\" />下载</button>");
sbSearchInfo.Append(" <button");
sbSearchInfo.Append(" title=\"删 除\" onclick=\"DoDelete(");
sbSearchInfo.Append(files_Temp.Fk_ID.ToString());
sbSearchInfo.Append(")\"");
sbSearchInfo.Append(" class=\"page_table_but3 radius5\"><img src=\"../content/images/delete_new.png\" />删除</button>");
sbSearchInfo.Append(" </div>");
sbSearchInfo.Append(" </li> ");
}
}
}
}
else if (epid != 0)
{
//按照预案编号进行查询,直接进入t_cm_file表中查询
List <t_cm_files> Filelist = bll.t_cm_files.Where(d => (d.Fk_ID == epid && d.Modules == "EmergencyPlan")).ToList();
if (Filelist.Count > 0)
{
//获取当前预案上传文件的详细信息
t_cm_files files_Temp = Filelist[0];
sbSearchInfo.Append(" <li> ");
sbSearchInfo.Append(" <div> ");
sbSearchInfo.Append(" <img src=\"../content/images/wordicon.png\" /> ");
sbSearchInfo.Append(" <span>");
sbSearchInfo.Append(" <h3>");
string fileSaveName = string.Empty;
string[] fileNameArry_Temp = files_Temp.FileName.Split('.');
if (fileNameArry_Temp.Length > 0)
{
fileSaveName = fileNameArry_Temp[0];
}
else
{
}
sbSearchInfo.Append(fileSaveName);
sbSearchInfo.Append(" </h3>");
sbSearchInfo.Append(" <p>");
DateTime dateTime_Temp = new DateTime();
dateTime_Temp = DateTime.Parse(files_Temp.CommitTime.ToString().Trim());
sbSearchInfo.Append(" 上传：");
sbSearchInfo.Append(dateTime_Temp.ToString("yyyy-MM-dd HH:mm:ss"));
sbSearchInfo.Append(" </p>");
sbSearchInfo.Append(" <p>");
sbSearchInfo.Append(" 大小：");
sbSearchInfo.Append(files_Temp.FileSize);
sbSearchInfo.Append(" </p>");
sbSearchInfo.Append(" </span>");
sbSearchInfo.Append(" </div> ");
sbSearchInfo.Append(" <div class=\"standfile_btn\">");
sbSearchInfo.Append(" <button");
sbSearchInfo.Append(" title=\"下 载\" onclick=\"DoDownload('");
string[] fileDirArry_Temp = files_Temp.FilePath.Split('/');
string newFileDir = string.Empty;
if (fileDirArry_Temp.Length > 0)
{
for (int j = 1; j < fileDirArry_Temp.Length; j++)
{
newFileDir = newFileDir + "/" + fileDirArry_Temp[j].Trim();
}
}
else
{
}
sbSearchInfo.Append(newFileDir);
sbSearchInfo.Append("')\"");
sbSearchInfo.Append(" class=\"page_table_but3 radius5\"><img src=\"../content/images/download.png\" />下载</button>");
sbSearchInfo.Append(" <button");
sbSearchInfo.Append(" title=\"删 除\" onclick=\"DoDelete(");
sbSearchInfo.Append(files_Temp.Fk_ID.ToString());
sbSearchInfo.Append(")\"");
sbSearchInfo.Append(" class=\"page_table_but3 radius5\"><img src=\"../content/images/delete_new.png\" />删除</button>");
sbSearchInfo.Append(" </div>");
sbSearchInfo.Append(" </li> ");
}
}
else
{
//为空
}
sbSearchInfo.Append(" <ul> ");
strJson = sbSearchInfo.ToString();
return(Content(strJson));
}
catch (Exception ex)
{
string error = ex.ToString();
return(Content(""));
}
}
/// <summary>
/// 上传文件
/// </summary>
/// <param name="fileData"></param>
/// <param name="folder"></param>
/// <param name="pid">配电室编号</param>
/// <param name="ctype"></param>
/// <returns></returns>
public ActionResult Upload(HttpPostedFileBase fileData, string folder, int uid, string ctype = "file", int pid = 0)
{
if (fileData != null)
{
try
{
//所属编号
int fk_id = 0;
//备注
string Remark = string.Empty;
//上传用户
string CommitUser = string.Empty;
//资料类型（图片，视频,文档）
string FileType = string.Empty;
//来源(web,app)
string FSource = string.Empty;
//所属模块
string Modules = string.Empty;
ControllerContext.HttpContext.Request.ContentEncoding = Encoding.GetEncoding("UTF-8");
ControllerContext.HttpContext.Response.ContentEncoding = Encoding.GetEncoding("UTF-8");
ControllerContext.HttpContext.Response.Charset = "UTF-8";
// 文件上传后的保存路径
string url = "~/UploadFiles/EmergencyPlan/";
string filePath = Server.MapPath(url);
DirectoryUtil.CreateDirectory(filePath);
string fileName = Path.GetFileName(fileData.FileName); //原始文件名称
string fileExtension = Path.GetExtension(fileName); //文件扩展名
//string saveName = Guid.NewGuid().ToString() + fileExtension; //保存文件名称
string saveName = DateTime.Now.Ticks + fileExtension;
fileData.SaveAs(filePath + saveName);
byte[] FileData = ReadFileBytes(fileData);
double fileSize = FileData.Length;
double fileSizeKB = fileSize / 1024;
fileSizeKB = Math.Round(fileSizeKB, 2);
string fSize = fileSizeKB + "KB";
//上传文件到t_PM_EmergencyPlan表和t_cm_files表
//保存到t_PM_EmergencyPlan表
t_PM_EmergencyPlan obj_EmergencyPlan = new t_PM_EmergencyPlan();
obj_EmergencyPlan.Name = fileName;
obj_EmergencyPlan.PID = pid;
bll.t_PM_EmergencyPlan.AddObject(obj_EmergencyPlan);
bll.SaveChanges();
//获取pk_id
fk_id = GetCurEPID(fileName);
//获取上传人
CommitUser = GetUserByUid(uid);
//资料类型（图片，视频,文档）
FileType = ctype;
//来源(web,app)
FSource = "web";
//所属模块
Modules = "EmergencyPlan";
//保存到资料库t_cm_files表
t_cm_files obj = new t_cm_files();
obj.CommitTime = DateTime.Now;
obj.CommitUser = GetUserByUid(uid);
obj.FileName = fileName;
obj.FilePath = url + saveName;
obj.FileExtension = fileExtension;
obj.FileSize = fSize;
obj.FileType = FileType;
obj.Fk_ID = fk_id;
obj.FSource = FSource;
obj.MaxTemp = 0;
obj.MinTemp = 0;
obj.Remark = Remark;
obj.Modules = Modules;
bll.t_cm_files.AddObject(obj);
bll.SaveChanges();
return(Content(saveName));
}
catch (Exception ex)
{
return(Content(ex.ToString()));
}
}
else
{
return(Content("false"));
}
}
