public void GetFileInfo() { string idsString = Request.QueryString["ids"].ToString(); string fileName = Request.QueryString["filename"].ToString(); string SessionID = Request.QueryString["SessionID"].ToString(); CMMLog.Debug(string.Format("ZIP打包下载入口GetFileInfo,接收参数。idsString:{0},fileName:{1},SessionID:{2}", idsString, fileName, SessionID)); Sys_ModelFileBLL bllFiles = new Sys_ModelFileBLL(); List <Sys_ModelFile> newsfiles = bllFiles.GetList(p => idsString.Contains(p.FileID)).ToList(); CMMLog.Debug(string.Format("ZIP打包下载入口GetFileInfo,检索文件数。count:{0}", newsfiles.Count)); if (!string.IsNullOrEmpty(SessionID)) { List <Sys_ModelFile> list = null; if (HttpContext.Current.Session[SessionID] != null) { list = HttpContext.Current.Session[SessionID] as List <Sys_ModelFile>; for (int i = 0; i < list.Count; i++) { newsfiles.Add(list[i]); } } } string path = Server.MapPath("/"); if (newsfiles.Count > 0) { string curName = path + "Files/ZipTemp/" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".zip"; ZipHelper.CreateZipFiles(newsfiles, path, curName, 5, 50); LoadFile(curName, fileName); } }
public void Show() { string id = Request.QueryString["id"]; Sys_Notice model = bllNotice.Get(p => p.NoticeID == id); if (model != null) { Notice_Title.Text = model.Notice_Title; Notice_Context.Text = model.Notice_Content; string hid_id = Request.QueryString["id"].ToString(); List <Sys_ModelFile> newsfiles = bllFiles.GetList(p => p.File_OperationID == hid_id).ToList(); if (newsfiles.Count > 0) { foreach (Sys_ModelFile file in newsfiles) { this.lblFj.Text += "<a href=\"/Files/Download.aspx?path=" + file.File_Path + "&filename=" + file.File_Name + "\" style=\"cursor:pointer\">" + (new ListItem(file.File_Name, file.FileID).Text) + "</br>"; } } } else { MessageBox.ShowAndRedirect(this, "该数据不存在!", "NoticeList.aspx"); } }
public void GuiLeiFilseList(HttpContext context) { string re = "1"; string id = context.Request.QueryString["id"]; string SessionID = context.Request.QueryString["SessionID"]; string FileType = context.Request.QueryString["FileType"]; if (!string.IsNullOrEmpty(FileType)) { FileType = HttpUtility.UrlDecode(FileType); } List <Sys_ModelFile> list = null; if (HttpContext.Current.Session[SessionID] != null) { list = HttpContext.Current.Session[SessionID] as List <Sys_ModelFile>; //List<Sys_ModelFile> list2 = list.FindAll(p => id.Contains(p.FileID)); for (int i = 0; i < list.Count; i++) { //for (int j = 0; j < list.Count;j++ ) //{ // if(list2[i].FileID){} //} string fileid = list[i].FileID; if (id.Contains(fileid)) { list[i].File_Type = FileType; } } HttpContext.Current.Session[SessionID] = list; List <Sys_ModelFile> lisst = HttpContext.Current.Session[SessionID] as List <Sys_ModelFile>; } Sys_ModelFileBLL bllfile = new Sys_ModelFileBLL(); //string picid = "'" + id.Replace(",", "','") + "'"; //List<Sys_ModelFile> fileList = bllfile.FindWhere(" FileID in (" + picid + ")"); string[] picid = id.Split(','); List <Sys_ModelFile> fileList = bllfile.GetList(p => picid.Contains(p.FileID)).ToList(); for (int i = 0; i < fileList.Count; i++) { fileList[i].File_Type = FileType; } string b = ""; bool bl = bllfile.Update(fileList); if (!bl) { re = "2"; } context.Response.Write(re); }
/// <summary> /// 附件查询 /// </summary> /// <param name="context"></param> public void FilseSelect(HttpContext context) { string OperationID = context.Request.QueryString["OperationID"]; //业务ID string FileType = context.Request.QueryString["FileType"]; //附件的类型 string str = ""; if (!string.IsNullOrEmpty(OperationID)) { List <Sys_ModelFile> filelist = null; Sys_ModelFileBLL modelfile = new Sys_ModelFileBLL(); if (string.IsNullOrEmpty(FileType)) { filelist = modelfile.GetList(p => p.File_OperationID == OperationID).OrderBy(a => a.File_AddTime).ToList(); } else { filelist = modelfile.GetList(p => p.File_OperationID == OperationID && p.File_Type == FileType).OrderBy(a => a.File_AddTime).ToList(); } str += "["; foreach (Sys_ModelFile file in filelist) { string fileContentLength = fileSizs(Convert.ToInt32(file.File_Size)); string filename2 = file.File_Name; if (filename2.Length > 10) { filename2 = filename2.Substring(0, filename2.Length - 1) + ".."; } //string fileUrl = "/Files/Download.aspx?path=" + file.File_Path + "&filename=" + file.File_Name; str += "{\"id\":\"" + file.FileID + "\",\"filename\":\"" + file.File_Name + "\",\"filesize\":\"" + fileContentLength + "\",\"uploaddate\":\"" + Convert.ToDateTime(file.File_AddTime).ToString("yyyy年MM月dd日") + "\",\"fileUrl\":\"" + file.File_Path + "\",\"filetitle\":\"" + filename2 + "\"},"; } str = str.Substring(0, str.Length - 1); str += "]"; context.Response.Write(str); } }
/// <summary> /// 背景图片添加 /// </summary> /// <param name="context"></param> public string Logo(HttpContext context) { string url = ""; Sys_ModelFileBLL bllModelFile = new Sys_ModelFileBLL(); List <Sys_ModelFile> fileList = bllModelFile.GetList(p => p.File_Type == "主框架LOGO背景图片" && p.File_OperationID == "zhukuangjiatupian").OrderByDescending(p => p.File_AddTime).ToList();; if (fileList.Count > 0) { url = fileList[0].File_Path; //int changdu = url.Length - 1; //url = url.Substring(1, changdu); } else { url = "/Images/main/logo.png"; } return(url); }
/// <summary> /// 背景图片添加 /// </summary> /// <param name="context"></param> public string Showbeijing(HttpContext context) { string url = ""; Sys_ModelFileBLL bllModelFile = new Sys_ModelFileBLL(); List <Sys_ModelFile> fileList = bllModelFile.GetList(p => p.File_Type == "登陆背景图片" && p.File_OperationID == "denglubeijing").OrderByDescending(p => p.File_AddTime).ToList();; if (fileList.Count > 0) { url = fileList[0].File_Path; int changdu = url.Length - 1; url = url.Substring(1, changdu); } else { url = "Styles/login/img/examples/01.jpg"; } return(url); }
public void DelFilseList(HttpContext context) { string re = "1"; string id = context.Request.QueryString["id"]; string SessionID = context.Request.QueryString["SessionID"]; string FileType = context.Request.QueryString["FileType"]; if (FileType == Constant.fileType1) //如果是第一部 真删除 { List <Sys_ModelFile> list = null; if (HttpContext.Current.Session[SessionID] != null) { list = HttpContext.Current.Session[SessionID] as List <Sys_ModelFile>; List <Sys_ModelFile> modelList = list.FindAll(p => id.Contains(p.FileID)); if (modelList.Count > 0) { for (int i = 0; i < modelList.Count; i++) { File.Delete(HttpContext.Current.Server.MapPath(modelList[i].File_Path)); if (modelList[i] != null) { list.Remove(modelList[i]); } } HttpContext.Current.Session[SessionID] = list; } } Sys_ModelFileBLL bllfile = new Sys_ModelFileBLL(); string[] picid = id.Split(','); //string picid = "'" + id.Replace(",", "','") + "'"; //List<Sys_ModelFile> fileList = bllfile.FindWhere(" FileID in (" + picid + ")"); //bool b = bllfile.DeleteWhere(" FileID in (" + picid + ")"); List <Sys_ModelFile> fileList = bllfile.GetList(p => picid.Contains(p.FileID)).ToList(); bool b = bllfile.Delete((p => picid.Contains(p.FileID))); if (b) { for (int i = 0; i < fileList.Count; i++) { try { File.Delete(HttpContext.Current.Server.MapPath(fileList[i].File_Path)); } catch { } re = "1"; } } } else { List <Sys_ModelFile> list = null; if (HttpContext.Current.Session[SessionID] != null) { list = HttpContext.Current.Session[SessionID] as List <Sys_ModelFile>; for (int i = 0; i < list.Count; i++) { string fileid = list[i].FileID; if (id.Contains(fileid)) { list[i].File_Type = Constant.fileType7; } } HttpContext.Current.Session[SessionID] = list; } Sys_ModelFileBLL bllfile = new Sys_ModelFileBLL(); string[] picid = id.Split(','); List <Sys_ModelFile> fileList = bllfile.GetList(p => picid.Contains(p.FileID)).ToList(); //string picid = "'" + id.Replace(",", "','") + "'"; //List<Sys_ModelFile> fileList = bllfile.FindWhere(" FileID in (" + picid + ")"); for (int i = 0; i < fileList.Count; i++) { fileList[i].File_Type = Constant.fileType7; } bool bl = bllfile.Update(fileList); if (!bl) { re = "2"; } } context.Response.Write(re); }
/// <summary> /// 查询数据库中和Session中的附件 /// </summary> /// <param name="context"></param> public void DataFilseSelect(HttpContext context) { Regex r = new Regex(@"[\u4e00-\u9fa5]+"); string OperationID = context.Request.QueryString["OperationID"]; //业务ID string FileType = context.Request.QueryString["FileType"]; //附件的类型 string SessionID = context.Request.QueryString["SessionID"]; //SessionID string type = context.Request.QueryString["type"]; //类型1:未归类 string productType = context.Request.QueryString["ProductType"]; //业务类别(个人、企业) string str = ""; if (!string.IsNullOrEmpty(FileType)) { FileType = HttpUtility.UrlDecode(FileType); } if (!string.IsNullOrEmpty(OperationID) || SessionID != "") { List <Sys_ModelFile> ModelFilelist = null; if (context.Session[SessionID] == null) { ModelFilelist = new List <Sys_ModelFile>(); } else { ModelFilelist = context.Session[SessionID] as List <Sys_ModelFile>; } str += "["; List <Sys_ModelFile> filelist = null; Sys_ModelFileBLL modelfile = new Sys_ModelFileBLL(); if (string.IsNullOrEmpty(FileType)) { filelist = modelfile.GetList(p => p.File_OperationID == OperationID).OrderBy(a => a.File_AddTime).ToList(); } else { string filetypes = ""; Sys_UploadDataTypeBLL upBll = new Sys_UploadDataTypeBLL(); List <Sys_UploadDataType> chlist = upBll.GetList(p => p.UploadDataType_TypeCode == FileType || p.UploadDataType_ProcessStage == FileType).ToList(); if (chlist.Count > 0) { for (int i = 0; i < chlist.Count; i++) { filetypes += chlist[i].UploadDataType_TypeCode; } } if (FileType == Constant.fileType7) { filetypes = FileType; } else if (FileType == Constant.Classification) { filetypes = FileType; } if (FileType == "0") { ModelFilelist = ModelFilelist.FindAll(p => !filetypes.Contains(p.File_Type)); } else { if (FileType == Constant.Classification) { string lb = ""; Common_BLL ComBLL = new Common_BLL(); List <ParameterModel> ParameterModel = null; List <ParameterModel> ParameterList = new List <ParameterModel>(); ParameterList.Add(new ParameterModel { ParamName = "ProductType", ParamValue = productType, ParamMode = ParamEnumMode.InMode, ParamType = DbType.String }); DataSet ds = ComBLL.ExecStoredProcedures(new StoredProcModel { ProcName = "P_GetUploadDataType", ParameterList = ParameterList }, out ParameterModel); int cout = ds.Tables[0].Rows.Count; for (int j = 0; j < cout; j++) { lb += ds.Tables[0].Rows[j][0].ToString(); } ModelFilelist = ModelFilelist.FindAll(p => filetypes.Contains(p.File_Type) || lb.Contains(p.File_Type)).OrderBy(a => a.File_AddTime).ToList(); } else { ModelFilelist = ModelFilelist.FindAll(p => filetypes.Contains(p.File_Type) || p.File_Type == FileType).OrderBy(a => a.File_AddTime).ToList(); } } if (FileType == Constant.Classification) { string lb = ""; Common_BLL ComBLL = new Common_BLL(); List <ParameterModel> ParameterModel = null; List <ParameterModel> ParameterList = new List <ParameterModel>(); ParameterList.Add(new ParameterModel { ParamName = "ProductType", ParamValue = productType, ParamMode = ParamEnumMode.InMode, ParamType = DbType.String }); DataSet ds = ComBLL.ExecStoredProcedures(new StoredProcModel { ProcName = "P_GetUploadDataType", ParameterList = ParameterList }, out ParameterModel); int cout = ds.Tables[0].Rows.Count; for (int j = 0; j < cout; j++) { lb += ds.Tables[0].Rows[j][0].ToString(); } filelist = modelfile.GetList(p => p.File_OperationID == OperationID && p.File_Type == FileType).OrderBy(a => a.File_AddTime).ToList(); } else { filelist = modelfile.GetList(p => p.File_OperationID == OperationID && (filetypes.Contains(p.File_Type) || p.File_Type == FileType)).OrderBy(a => a.File_AddTime).ToList();// || p.File_Type == FileType } } foreach (Sys_ModelFile file in ModelFilelist) { string filename2 = file.File_Name; if (filename2.Length > 9) { Match mc = r.Match(filename2); Match mt = r.Match(file.File_Type); if (mc.Length != 0) // { if (mt.Length != 0 && file.File_Type != Constant.fileType7) { filename2 = filename2.Substring(0, 7) + "..(未归类)"; } else { filename2 = filename2.Substring(0, 9) + ".."; } } else { if (mt.Length != 0 && file.File_Type != Constant.fileType7) { filename2 = filename2.Substring(0, 9) + "..(未归类)"; } else { filename2 = filename2.Substring(0, 9) + ".."; } } } else { Match mt = r.Match(file.File_Type); if (mt.Length != 0 && file.File_Type != Constant.fileType7) { filename2 = filename2 + "(未归类)"; } } str += "{\"id\":\"" + file.FileID + "\",\"filename\":\"" + file.File_Name + "\",\"filesize\":\"\",\"uploaddate\":\"" + Convert.ToDateTime(file.File_AddTime).ToString("yyyy年MM月dd日") + "\",\"fileUrl\":\"" + file.File_Path + "\",\"filetitle\":\"" + filename2 + "\"},"; } foreach (Sys_ModelFile file in filelist) { string fileContentLength = fileSizs(Convert.ToInt32(file.File_Size)); string filename2 = file.File_Name; if (filename2.Length > 9) { Match mc = r.Match(file.File_Type); if (mc.Length != 0 && file.File_Type != Constant.fileType7) //类别中含有汉字 { filename2 = filename2.Substring(0, 7) + "(未归类)"; } else { filename2 = filename2.Substring(0, 9) + ".."; } } else { Match mc = r.Match(file.File_Type); if (mc.Length != 0 && file.File_Type != Constant.fileType7) //类别中含有汉字 { filename2 = filename2 + "(未归类)"; } } str += "{\"id\":\"" + file.FileID + "\",\"filename\":\"" + file.File_Name + "\",\"filesize\":\"" + fileContentLength + "\",\"uploaddate\":\"" + Convert.ToDateTime(file.File_AddTime).ToString("yyyy年MM月dd日") + "\",\"fileUrl\":\"" + file.File_Path + "\",\"filetitle\":\"" + filename2 + "\"},"; } if (str.Length > 1) { str = str.Substring(0, str.Length - 1); } str += "]"; context.Response.Write(str); } }