/// <summary> /// 按页取数据 /// </summary> /// <returns>json</returns> private string doSelect() { StringBuilder sb = new StringBuilder(); //取Grid提交来的数据开始 int uploadId = IRequest.GetQueryInt("id", 0); int rp = IRequest.GetFormInt("rp", 10); int page = IRequest.GetFormInt("page", 1); string keyword = IRequest.GetFormString("query"); string qtype = IRequest.GetFormString("qtype"); string path = getUploadPathByUploadId(uploadId).Replace("\\", "/"); //取Grid提交来的数据结束 using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_File file = new SqlDb.Dcms_File(); //创建查询 IQuery query = session.GetQuery(file); if (keyword.Length > 0) { query.Where(SqlDb.Dcms_File._FILE_OLDERFILENAME_.Like('%', keyword, '%')).OrderBy(SqlDb.Dcms_File._FILE_ID_, Direction.DESC); } else { query.Where(SqlDb.Dcms_File._FILE_UPLOADID_.EqulesExp(uploadId)).OrderBy(SqlDb.Dcms_File._FILE_ID_, Direction.DESC); } //取总记录 int totalCount = query.Count(); List <SqlDb.Dcms_File> fileList = query.GetList <SqlDb.Dcms_File>(page, rp); //Json格式 sb.Append("{\n"); sb.Append("\"page\":" + page.ToString() + ",\n"); sb.Append("\"total\":" + totalCount.ToString() + ",\n"); sb.Append("\"rows\": [\n"); for (int i = 0; i < fileList.Count; i++) { sb.Append("{"); sb.Append(string.Format("\"id\":\"{0}\",\"cell\":[\"{1}\",\"{2}\",\"{3}\",\"{4}\"]", fileList[i].File_Id.ToString(), fileList[i].File_Id.ToString(), "<a onclick='javascript:void()' target='_blank' href='" + "../../UploadFile" + path + "/" + fileList[i].File_NewFileName.ToString() + "'>" + fileList[i].File_OlderFileName.ToString() + "</a>", fileList[i].File_FileSize.ToString(), fileList[i].File_AddDateTime.ToString("yyyy/MM/dd"))); if ((i + 1) == fileList.Count) { sb.Append("}\n"); } else { sb.Append("},\n"); } } sb.Append("]\n"); sb.Append("}"); } return(sb.ToString()); }
/// <summary> /// 批量删除操作 /// </summary> /// <returns></returns> private string doDelete() { try { string id = IRequest.GetQueryString("id").TrimStart(new char[] { ',' }); string path = HttpContext.Current.Server.MapPath(@"~/UploadFile"); //string[] files = Directory.GetFiles(path); //string delfiles = ""; //string delfile = "reflector.zip"; using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_File file = new SqlDb.Dcms_File(); string[] ids = id.Split(new char[] { ',' }); foreach (string fileid in ids) { IQuery query = session.GetQuery(file).Where(SqlDb.Dcms_File._FILE_ID_.EqulesExp(fileid)); List <SqlDb.Dcms_File> fileList = query.GetList <SqlDb.Dcms_File>(); //if (uploadList[0].Upload_PathName != null) //{ // continue; //} // foreach (string delfile in files) // { // System.IO.File.Delete(delfile); // delfiles += delfile; //if (delfile == path + @"\"+uploadList[0].Upload_OlderFileName) //{ // System.IO.File.Delete(delfile); // //Response.Write(delfile); //} //Response.Write(delfiles); // } string Sql = "DELETE FROM [Dcms_File] WHERE [File_Id] ='" + fileid + "'"; session.simple(Sql); System.IO.File.Delete(path + @getUploadPathByUploadId(fileList[0].File_UploadId) + @"/" + fileList[0].File_NewFileName); } // string Sql = "DELETE FROM [Dcms_Upload] WHERE [Upload_Id] IN(" + id + ")"; // session.simple(Sql); } return("true"); } catch { return("false"); } }
/// <summary> /// 重命名文件操作 /// </summary> /// <returns></returns> private string doRenew() { try { int fileId = IRequest.GetFormInt("fileId", 0); string newFileName = IRequest.GetFormString("newFileName"); string path = HttpContext.Current.Server.MapPath(@"~/UploadFile"); //string[] files = Directory.GetFiles(path); //string delfiles = ""; //string delfile = "reflector.zip"; using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_File file = new SqlDb.Dcms_File(); IQuery query = session.GetQuery(file).Where(SqlDb.Dcms_File._FILE_ID_.EqulesExp(fileId)); List <SqlDb.Dcms_File> fileList = query.GetList <SqlDb.Dcms_File>(); if (fileList.Count > 0) { string olderFileName = fileList[0].File_OlderFileName; string olderNewFileName = fileList[0].File_NewFileName; path = path + @getUploadPathByUploadId(fileList[0].File_UploadId); file = fileList[0]; file.File_AddDateTime = DateTime.Now; file.File_OlderFileName = newFileName; file.File_NewFileName = System.DateTime.Now.ToString().Replace("-", "").Replace(":", "").Replace(" ", "") + "-" + newFileName; if (File.Exists(path + @"/" + olderNewFileName)) { File.Copy(path + @"/" + olderNewFileName, path + @"/" + file.File_NewFileName, false); File.Delete(path + @"/" + olderNewFileName); session.Update(file); } } // System.IO.File.Delete(path + @getUploadPathByUploadId(fileList[0].File_UploadId) + @"/" + fileList[0].File_OlderFileName); // string Sql = "DELETE FROM [Dcms_Upload] WHERE [Upload_Id] IN(" + id + ")"; // session.simple(Sql); } return("true"); } catch { return("false"); } }
/// <summary> /// 批量删除操作 /// </summary> /// <returns></returns> private string doDelete() { try { string id = IRequest.GetQueryString("id").TrimStart(new char[] { ',' }); string path = HttpContext.Current.Server.MapPath(@"~/UploadFile"); //string[] files = Directory.GetFiles(path); //string delfiles = ""; //string delfile = "reflector.zip"; using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_File file = new SqlDb.Dcms_File(); string[] ids = id.Split(new char[] { ',' }); foreach (string fileid in ids) { IQuery query = session.GetQuery(file).Where(SqlDb.Dcms_File._FILE_ID_.EqulesExp(fileid)); List<SqlDb.Dcms_File> fileList = query.GetList<SqlDb.Dcms_File>(); //if (uploadList[0].Upload_PathName != null) //{ // continue; //} // foreach (string delfile in files) // { // System.IO.File.Delete(delfile); // delfiles += delfile; //if (delfile == path + @"\"+uploadList[0].Upload_OlderFileName) //{ // System.IO.File.Delete(delfile); // //Response.Write(delfile); //} //Response.Write(delfiles); // } string Sql = "DELETE FROM [Dcms_File] WHERE [File_Id] ='" + fileid + "'"; session.simple(Sql); System.IO.File.Delete(path + @getUploadPathByUploadId(fileList[0].File_UploadId) + @"/" + fileList[0].File_NewFileName); } // string Sql = "DELETE FROM [Dcms_Upload] WHERE [Upload_Id] IN(" + id + ")"; // session.simple(Sql); } return "true"; } catch { return "false"; } }
/// <summary> /// 按页取数据 /// </summary> /// <returns>json</returns> private string doSelect() { StringBuilder sb = new StringBuilder(); //取Grid提交来的数据开始 int uploadId = IRequest.GetQueryInt("id", 0); int rp = IRequest.GetFormInt("rp", 10); int page = IRequest.GetFormInt("page", 1); string keyword = IRequest.GetFormString("query"); string qtype = IRequest.GetFormString("qtype"); string path = getUploadPathByUploadId(uploadId).Replace("\\", "/"); //取Grid提交来的数据结束 using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_File file = new SqlDb.Dcms_File(); //创建查询 IQuery query = session.GetQuery(file); if (keyword.Length > 0) { query.Where(SqlDb.Dcms_File._FILE_OLDERFILENAME_.Like('%', keyword, '%')).OrderBy(SqlDb.Dcms_File._FILE_ID_, Direction.DESC); } else { query.Where(SqlDb.Dcms_File._FILE_UPLOADID_.EqulesExp(uploadId)).OrderBy(SqlDb.Dcms_File._FILE_ID_, Direction.DESC); } //取总记录 int totalCount = query.Count(); List<SqlDb.Dcms_File> fileList = query.GetList<SqlDb.Dcms_File>(page, rp); //Json格式 sb.Append("{\n"); sb.Append("\"page\":" + page.ToString() + ",\n"); sb.Append("\"total\":" + totalCount.ToString() + ",\n"); sb.Append("\"rows\": [\n"); for (int i = 0; i < fileList.Count; i++) { sb.Append("{"); sb.Append(string.Format("\"id\":\"{0}\",\"cell\":[\"{1}\",\"{2}\",\"{3}\",\"{4}\"]", fileList[i].File_Id.ToString(), fileList[i].File_Id.ToString(), "<a onclick='javascript:void()' target='_blank' href='" + "../../UploadFile" + path + "/" + fileList[i].File_NewFileName.ToString() + "'>" + fileList[i].File_OlderFileName.ToString() + "</a>", fileList[i].File_FileSize.ToString(), fileList[i].File_AddDateTime.ToString("yyyy/MM/dd"))); if ((i + 1) == fileList.Count) { sb.Append("}\n"); } else { sb.Append("},\n"); } } sb.Append("]\n"); sb.Append("}"); } return sb.ToString(); }
/// <summary> /// 重命名文件操作 /// </summary> /// <returns></returns> private string doRenew() { try { int fileId = IRequest.GetFormInt("fileId", 0); string newFileName = IRequest.GetFormString("newFileName"); string path = HttpContext.Current.Server.MapPath(@"~/UploadFile"); //string[] files = Directory.GetFiles(path); //string delfiles = ""; //string delfile = "reflector.zip"; using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { SqlDb.Dcms_File file = new SqlDb.Dcms_File(); IQuery query = session.GetQuery(file).Where(SqlDb.Dcms_File._FILE_ID_.EqulesExp(fileId)); List<SqlDb.Dcms_File> fileList = query.GetList<SqlDb.Dcms_File>(); if (fileList.Count > 0) { string olderFileName = fileList[0].File_OlderFileName; string olderNewFileName = fileList[0].File_NewFileName; path = path + @getUploadPathByUploadId(fileList[0].File_UploadId); file = fileList[0]; file.File_AddDateTime = DateTime.Now; file.File_OlderFileName = newFileName; file.File_NewFileName = System.DateTime.Now.ToString().Replace("-", "").Replace(":", "").Replace(" ", "") + "-" + newFileName; if (File.Exists(path + @"/" + olderNewFileName)) { File.Copy(path + @"/" + olderNewFileName, path + @"/" + file.File_NewFileName, false); File.Delete(path + @"/" + olderNewFileName); session.Update(file); } } // System.IO.File.Delete(path + @getUploadPathByUploadId(fileList[0].File_UploadId) + @"/" + fileList[0].File_OlderFileName); // string Sql = "DELETE FROM [Dcms_Upload] WHERE [Upload_Id] IN(" + id + ")"; // session.simple(Sql); } return "true"; } catch { return "false"; } }