/// <summary> /// 得到一个对象实体 /// </summary> public static EtNet_Models.AnnouncementFiles GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" from AnnouncementFiles "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; EtNet_Models.AnnouncementFiles model = new EtNet_Models.AnnouncementFiles(); DataTable tbl = EtNet_DAL.DBHelper.GetDataSet(strSql.ToString(), parameters); if (tbl.Rows.Count > 0) { model.id = int.Parse(tbl.Rows[0]["id"].ToString()); model.announcementid = int.Parse(tbl.Rows[0]["announcementid"].ToString()); model.cname = tbl.Rows[0]["cname"].ToString(); model.path = tbl.Rows[0]["path"].ToString(); model.uptime = DateTime.Parse(tbl.Rows[0]["uptime"].ToString()); model.founderid = int.Parse(tbl.Rows[0]["founderid"].ToString()); model.remark = tbl.Rows[0]["remark"].ToString(); return(model); } else { return(null); } }
/// 删除附件 /// </summary> private void DelFile(HttpContext context) { int id = int.Parse(context.Request.Params["fileid"]); EtNet_Models.AnnouncementFiles model = EtNet_BLL.AnnouncementFilesManager.GetModel(id); if (model != null) { //删除服务器上的相应的文件 File.Delete(context.Server.MapPath(model.path)); EtNet_BLL.AnnouncementFilesManager.Delete(model.id); context.Response.Write("删除成功_1"); } else { context.Response.Write("删除失败_0"); } }
/// <summary> /// 保存附件的路径 /// </summary> /// <param name="filelist">附件的路径的列表</param> /// <param name="id">公告的id值</param> private void CreateFile(string[] filelist, int id) { EtNet_Models.AnnouncementFiles model = null; EtNet_Models.LoginInfo login = (EtNet_Models.LoginInfo)Session["login"]; for (int i = 1; i < 6; i++) { if (filelist[i] != "") { model = new EtNet_Models.AnnouncementFiles(); model.path = filelist[i].Substring(0, filelist[i].IndexOf("|")); model.uptime = DateTime.Now; model.cname = filelist[i].Substring(filelist[i].LastIndexOf('|') + 1); model.announcementid = id; model.founderid = login.Id; model.remark = ""; EtNet_BLL.AnnouncementFilesManager.Add(model); } } }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(EtNet_Models.AnnouncementFiles model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AnnouncementFiles set "); strSql.Append(" announcementid = @announcementid , "); strSql.Append(" cname = @cname , "); strSql.Append(" path = @path , "); strSql.Append(" uptime = @uptime , "); strSql.Append(" founderid = @founderid , "); strSql.Append(" remark = @remark "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@announcementid", SqlDbType.Int, 4), new SqlParameter("@cname", SqlDbType.VarChar, 100), new SqlParameter("@path", SqlDbType.VarChar, 200), new SqlParameter("@uptime", SqlDbType.DateTime), new SqlParameter("@founderid", SqlDbType.Int, 4), new SqlParameter("@remark", SqlDbType.VarChar, 200) }; parameters[0].Value = model.id; parameters[1].Value = model.announcementid; parameters[2].Value = model.cname; parameters[3].Value = model.path; parameters[4].Value = model.uptime; parameters[5].Value = model.founderid; parameters[6].Value = model.remark; int result = EtNet_DAL.DBHelper.ExecuteCommand(strSql.ToString(), parameters); if (result >= 1) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public static bool Add(EtNet_Models.AnnouncementFiles model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AnnouncementFiles("); strSql.Append("announcementid,cname,path,uptime,founderid,remark"); strSql.Append(") values ("); strSql.Append("@announcementid,@cname,@path,@uptime,@founderid,@remark"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@announcementid", SqlDbType.Int, 4), new SqlParameter("@cname", SqlDbType.VarChar, 100), new SqlParameter("@path", SqlDbType.VarChar, 200), new SqlParameter("@uptime", SqlDbType.DateTime), new SqlParameter("@founderid", SqlDbType.Int, 4), new SqlParameter("@remark", SqlDbType.VarChar, 200) }; parameters[0].Value = model.announcementid; parameters[1].Value = model.cname; parameters[2].Value = model.path; parameters[3].Value = model.uptime; parameters[4].Value = model.founderid; parameters[5].Value = model.remark; int result = EtNet_DAL.DBHelper.ExecuteCommand(strSql.ToString(), parameters); if (result >= 1) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(EtNet_Models.AnnouncementFiles model) { return(EtNet_DAL.AnnouncementFilesService.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public static bool Add(EtNet_Models.AnnouncementFiles model) { return(EtNet_DAL.AnnouncementFilesService.Add(model)); }