/// <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";
}
}
