public List <WallFile> GetWallFileByCategory(int categoryId) { List <WallFile> wallFileList = new List <WallFile>(); string sql = string.Format("select wf.* from WallFile wf " + "inner join FileCategoryMapping fcm ON fcm.Fid=wf.Id inner JOIN WallCategory wc ON wc.Id = fcm.Cid where wc.Id = " + categoryId + " order by wf.id desc"); using (SqlDataReader dr = SQLHelper.ExecuteReader(sql)) { while (dr.Read()) { WallFile wallFile = new WallFile(); wallFile.Id = int.Parse(dr["Id"].ToString()); wallFile.Name = dr["Name"].ToString(); wallFile.FileName = dr["FileName"].ToString(); wallFile.FileSize = double.Parse(dr["FileSize"].ToString()); wallFile.Type = dr["Type"].ToString(); wallFile.UpdateDate = DateTime.Parse(dr["UpdateDate"].ToString()); wallFile.Owner = dr["Owner"].ToString(); wallFileList.Add(wallFile); } dr.Close(); } return(wallFileList); }
//删除 WallFile List public bool DeleteWallFileList(List <int> removeIdList, string filePath) { try { if (!string.IsNullOrEmpty(filePath)) { foreach (int fid in removeIdList) { WallFile wallFile = GetWallFileById(fid); if (wallFile != null) { if (wallFile.Type.Equals("File")) { AOnlineWall.Business.Common com = new AOnlineWall.Business.Common(); com.DeleteFile(filePath, wallFile.FileName); } DeleteWallFile(wallFile.Id); } } } } catch (Exception) { return(false); } return(true); }
/// <summary> /// 更新 /// </summary> /// <param name="wf"></param> /// <returns></returns> public int Update(WallFile wf) { string sql = string.Format("UPDATE WallFile set Name=@Name,UpdateDate=getDate(),Owner=@Owner where Id=@Id"); SqlParameter[] cmdParams = new SqlParameter[3]; cmdParams[0] = new SqlParameter("@Name", wf.Name); cmdParams[1] = new SqlParameter("@Owner", wf.Owner); cmdParams[2] = new SqlParameter("@Id", wf.Id); return(SQLHelper.ExecuteNonQuery(sql, cmdParams)); }
public int Save(WallFile wf) { string sql = string.Format("DECLARE @fid int;INSERT WallFile(Name,Filename,FileSize,Type,UpdateDate,Owner)" + "VALUES (@Name,@FileName,@FileSize,@Type,getdate(),@Owner);select @fid = SCOPE_IDENTITY();INSERT FileCategoryMapping VALUES(@fid,@Category)"); SqlParameter[] cmdParams = new SqlParameter[6]; cmdParams[0] = new SqlParameter("@Name", wf.Name); cmdParams[1] = new SqlParameter("@FileName", wf.FileName); cmdParams[2] = new SqlParameter("@FileSize", wf.FileSize); cmdParams[3] = new SqlParameter("@Type", wf.Type); cmdParams[4] = new SqlParameter("@Owner", wf.Owner); cmdParams[5] = new SqlParameter("@Category", wf.CategoryId); return(SQLHelper.ExecuteNonQuery(sql, cmdParams)); }
/// <summary> /// 获取 Wall File /// </summary> /// <param name="fid"></param> /// <returns></returns> public WallFile GetWallFileById(int fid) { string sql = string.Format("select * from WallFile where Id = {0}", fid); WallFile wallFile = null; using (SqlDataReader dr = SQLHelper.ExecuteReader(sql)) { if (dr.Read()) { wallFile = new WallFile(); wallFile.Id = int.Parse(dr["Id"].ToString()); wallFile.Name = dr["Name"].ToString(); wallFile.FileName = dr["FileName"].ToString(); wallFile.FileSize = double.Parse(dr["FileSize"].ToString()); wallFile.Type = dr["Type"].ToString(); wallFile.UpdateDate = DateTime.Parse(dr["UpdateDate"].ToString()); wallFile.Owner = dr["Owner"].ToString(); } dr.Close(); } return(wallFile); }
public static WallFile ToEntityModel(this WallFileViewModel wallFileViewModel, WallFile wallFile) { return(Mapper.Map(wallFileViewModel, wallFile)); }