public static void Update(XDSW_T_FILE entity)
{
using (var db = Pub.DB)
{
db.Update <XDSW_T_FILE>(entity);
}
}
public static void Insert(XDSW_T_FILE entity)
{
using (var db = Pub.DB)
{
db.Insert <XDSW_T_FILE>(entity);
}
}
public void ProcessRequest(HttpContext context)
{
int maxSize = 1024 * 1024 * 1024;
if (context.Request.Files.Count == 0)
{
showError(context, "请选择文件".GetRes());
return;
}
HttpPostedFile imgFile = context.Request.Files[0];
if (imgFile.InputStream == null || imgFile.InputStream.Length > maxSize)
{
showError(context, "上传文件大小超过限制".GetRes());
return;
}
try
{
var user = Util.GetCurrentUser();
// 将文件插入到数据库中
var entity = new XDSW_T_FILE();
using (var db = Pub.DB)
{
//var sql = "select top 1 FileId from XDSW_T_FILE where FileName=@FileName";
//var dbFileId = db.Query<string>(sql, new { FileName = Path.GetFileName(imgFile.FileName) }).FirstOrDefault();
//if (!string.IsNullOrWhiteSpace(dbFileId))
//{
// showError(context, "文件名已经存在".GetRes());
// return;
//}
entity.FileId = Guid.NewGuid().ToString();
entity.FileName = Path.GetFileName(imgFile.FileName);
entity.FileData = StreamHelper.ToBytes(imgFile.InputStream);
entity.LastModifyTime = DateTime.Now;
entity.LastModifyUser = user.UserName;
entity.CreateTime = DateTime.Now;
entity.CreateUser = user.UserName;
entity.Extend01 = "TempFile";
db.Insert(entity);
}
Hashtable hash = new Hashtable();
hash["error"] = 0;
hash["fileName"] = entity.FileName;
hash["fileId"] = entity.FileId;
hash["message"] = "上传成功";
context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8");
context.Response.Write(JsonSerializeHelper.SerializeObject(hash));
}
catch (Exception ex)
{
showError(context, ex.Message);
return;
}
}
private DataGridVM UploadFile(HttpContext context, DFDictionary dict)
{
var vm = new DataGridVM();
try
{
int maxSize = 1024 * 1024 * 10;
if (context.Request.Files.Count == 0)
{
throw new WFException("请上传文件");
}
for (int i = 0; i < context.Request.Files.Count; i++)
{
var item = context.Request.Files[i];
if (item.InputStream == null || item.InputStream.Length > maxSize)
{
throw new WFException(string.Format("第 {0} 个上传文件大小超过限制", i + 1));
}
}
var user = Util.GetCurrentUser();
var list = new List <XDSW_T_FILE>();
for (int i = 0; i < context.Request.Files.Count; i++)
{
var item = context.Request.Files[i];
// 将文件插入到数据库中
var entity = new XDSW_T_FILE();
using (var db = Pub.DB)
{
entity.FileId = Guid.NewGuid().ToString();
entity.FileName = Path.GetFileName(item.FileName);
entity.FileData = StreamHelper.ToBytes(item.InputStream);
entity.LastModifyTime = DateTime.Now;
entity.LastModifyUser = user.UserName;
entity.CreateTime = DateTime.Now;
entity.CreateUser = user.UserName;
list.Add(entity);
db.Insert(entity);
}
}
vm.rows = list.Select(a => new { FileId = a.FileId, FileName = a.FileName }).ToList();
}
catch (Exception ex)
{
vm.hasError = true;
vm.error = ex.Message;
}
return(vm);
}