private void OnUpload(UploadResult r) { if (r) { var identity = User; var now = DateTime.Now; var ext = Path.GetExtension(r.FileName); var file = new WeedFile(); file.Id = r.Fid; file.Uid = r.Uid; file.Did = r.Did; file.Ext = ext; file.Url = r.FileUrl; file.Size = r.Size; file.Name = r.FileName; file.Badge = string.Empty; file.Extra = string.Empty; file.Status = true; file.CreatedBy = identity.Name; file.CreatedOn = now; file.ModifiedBy = identity.Name; file.ModifiedOn = now; var id = DefaultStorage.WeedFileCreate(file); if (id < 1) { Logger.LogError("保存到数据库失败:" + r.Error); } return; } Logger.LogError("上传失败:" + r.Error); }
///<summary> /// 文件 更新 ///</summary> ///<param name="o">WeedFile</param> ///<returns></returns> public bool WeedFileUpdate(WeedFile o) { return(Try(nameof(WeedFileUpdate), () => { var cmd = SqlBuilder.Update("WeedFile") .Column("Name", o.Name) .Column("Badge", o.Badge ?? string.Empty) .Column("Extra", o.Extra ?? string.Empty) //.Column("UserId", o.UserId) .Column("Status", o.Status) //.Column("CreatedBy", o.CreatedBy) //.Column("CreatedOn", o.CreatedOn) .Column("ModifiedBy", o.ModifiedBy) .Column("ModifiedOn", o.ModifiedOn) .Where("Id=@id", new { o.Id }) .ToCommand(); return WeedConn.Execute(cmd) > 0; })); }
///<summary> /// 文件 创建 ///</summary> ///<param name="o">WeedFile</param> ///<returns></returns> public int WeedFileCreate(WeedFile o) { return(Try(nameof(WeedFileCreate), () => { var cmd = SqlBuilder.Insert("WeedFile") .Column("Id", o.Id) .Column("Uid", o.Uid) .Column("Did", o.Did) .Column("Ext", o.Ext) .Column("Url", o.Url) .Column("Size", o.Size) .Column("Name", o.Name) .Column("Badge", o.Badge ?? string.Empty) .Column("Extra", o.Extra ?? string.Empty) .Column("Status", o.Status) .Column("CreatedBy", o.CreatedBy ?? string.Empty) .Column("CreatedOn", o.CreatedOn) .Column("ModifiedBy", o.ModifiedBy ?? string.Empty) .Column("ModifiedOn", o.ModifiedOn) .ToCommand(true); return WeedConn.ExecuteScalar <int>(cmd); })); }