/// <summary>
/// 保存文件信息到数据库
/// </summary>
/// <param name="parentId">父文件ID(如果保存缩略图的话，此id就是主图的id)</param>
/// <param name="settingModel">设置信息</param>
/// <param name="relativePath">相对路径</param>
/// <returns>记录主键ID</returns>
private long SaveFileInfoToDB(long parentId, XCLCMS.FileManager.Models.Uploader.FileSetting settingModel, string relativePath, int width, int height)
{
System.IO.FileInfo info = new System.IO.FileInfo(Server.MapPath(relativePath));
DateTime dtNow = DateTime.Now;
XCLCMS.Data.BLL.Attachment bll = new Data.BLL.Attachment();
XCLCMS.Data.Model.Attachment model = new Data.Model.Attachment();
model.AttachmentID = XCLCMS.Data.BLL.Common.Common.GenerateID(Data.CommonHelper.EnumType.IDTypeEnum.ATT);
model.FileName = info.Name;
model.CreaterID = base.UserID;
model.CreaterName = base.CurrentUserModel.UserName;
model.CreateTime = dtNow;
model.Description = settingModel.Description;
model.DownLoadCount = settingModel.DownloadCount;
model.Ext = (info.Extension ?? "").Trim('.');
model.FileSize = (decimal)(info.Length / 1024);
model.FormatType = "";
model.ImgHeight = height;
model.ImgWidth = width;
model.ParentID = parentId;
model.RecordState = XCLCMS.Data.CommonHelper.EnumType.RecordStateEnum.N.ToString();
model.Title = settingModel.Title;
model.OriginFileName = settingModel.Name;
model.UpdaterID = base.UserID;
model.UpdaterName = base.CurrentUserModel.UserName;
model.UpdateTime = dtNow;
model.URL = relativePath;
model.ViewCount = settingModel.ViewCount;
model.ViewType = settingModel.ViewType;
model.FK_MerchantID = base.CurrentUserModel.FK_MerchantID;
return(bll.Add(model) ? model.AttachmentID : 0);
}
public ActionResult List()
{
XCLCMS.FileManager.Models.LogicFile.ListVM viewModel = new Models.LogicFile.ListVM();
viewModel.IsSelectFile = XCLNetTools.StringHander.FormHelper.GetInt("IsSelectFile") == 1;
viewModel.SelectFileCallBack = XCLNetTools.StringHander.FormHelper.GetString("selectFileCallback");
#region 初始化查询条件
viewModel.Search = new XCLNetSearch.Search();
viewModel.Search.TypeList = new List <XCLNetSearch.SearchFieldInfo>()
{
new XCLNetSearch.SearchFieldInfo("文件ID", "AttachmentID|number|text", ""),
new XCLNetSearch.SearchFieldInfo("主文件ID", "ParentID|number|text", ""),
new XCLNetSearch.SearchFieldInfo("标题", "Title|string|text", ""),
new XCLNetSearch.SearchFieldInfo("文件名", "OriginFileName|string|text", ""),
new XCLNetSearch.SearchFieldInfo("查看类型", "ViewType|string|text", ""),
new XCLNetSearch.SearchFieldInfo("格式类型", "FormatType|string|text", ""),
new XCLNetSearch.SearchFieldInfo("扩展名", "Ext|string|text", ""),
new XCLNetSearch.SearchFieldInfo("相对路径", "URL|string|text", ""),
new XCLNetSearch.SearchFieldInfo("描述信息", "Description|string|text", ""),
new XCLNetSearch.SearchFieldInfo("下载数", "DownLoadCount|number|text", ""),
new XCLNetSearch.SearchFieldInfo("查看数", "ViewCount|number|text", ""),
new XCLNetSearch.SearchFieldInfo("大小（kb）", "FileSize|number|text", ""),
new XCLNetSearch.SearchFieldInfo("图片宽度（如果是图片）", "ImgWidth|number|text", ""),
new XCLNetSearch.SearchFieldInfo("图片高度（如果是图片）", "ImgHeight|number|text", ""),
new XCLNetSearch.SearchFieldInfo("创建时间", "CreateTime|dateTime|text", ""),
new XCLNetSearch.SearchFieldInfo("创建者名", "CreaterName|string|text", ""),
new XCLNetSearch.SearchFieldInfo("更新时间", "UpdateTime|dateTime|text", ""),
new XCLNetSearch.SearchFieldInfo("更新人名", "UpdaterName|string|text", "")
};
string strWhere = string.Format("RecordState='{0}'", XCLCMS.Data.CommonHelper.EnumType.RecordStateEnum.N.ToString());
string strSearch = viewModel.Search.StrSQL;
if (!string.IsNullOrEmpty(strSearch))
{
strWhere = string.Format("{0} and ({1})", strWhere, strSearch);
}
#endregion 初始化查询条件
XCLCMS.Data.BLL.Attachment bll = new Data.BLL.Attachment();
base.PageParamsInfo.PageSize = 15;
viewModel.AttachmentList = bll.GetPageList(base.PageParamsInfo, strWhere, "", "[AttachmentID]", "[AttachmentID] desc");
viewModel.PagerModel = base.PageParamsInfo;
return(View(viewModel));
}
