/// <summary> /// 获得分页集合 /// </summary> /// <param name="pb">页类</param> /// <param name="count">总数</param> /// <returns>集合</returns> public List <Tunnel.Model.Tunnel_FilesManage> GetList(PageBase pb, ref int count) { DataTable dt = m_FilesManageDAL.GetList(pb, ref count).Tables[0]; List <Tunnel.Model.Tunnel_FilesManage> modelList = new List <Tunnel.Model.Tunnel_FilesManage>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0 && pb.DoCount == 0) { Tunnel.Model.Tunnel_FilesManage model; for (int n = 0; n < rowsCount; n++) { model = new Tunnel.Model.Tunnel_FilesManage(); model.F_ID = Convert.ToInt32(dt.Rows[n]["F_ID"].ToString()); model.F_Type = dt.Rows[n]["F_Type"].ToString().Trim(); model.F_Title = dt.Rows[n]["F_Title"].ToString().Trim(); model.F_Content = dt.Rows[n]["F_Content"].ToString().Trim(); model.F_Name = dt.Rows[n]["F_Name"].ToString().Trim(); model.F_URL = dt.Rows[n]["F_URL"].ToString().Trim(); model.F_CreateUser = Convert.ToInt32(dt.Rows[n]["F_CreateUser"].ToString().Trim()); model.F_CreateDate = Convert.ToDateTime(dt.Rows[n]["F_CreateDate"]); modelList.Add(model); } } return(modelList); }
protected void Button1_Click(object sender, EventArgs e) { if (ViewState["STATE"].ToString().Trim() == "N") { HttpPostedFile hpf = file1.PostedFile; if (hpf.FileName.Trim() == "") { Tunnel.Common.Message.back("请选择附件"); return; } m_FilesManageModel.F_Type = strType; m_FilesManageModel.F_Title = tb_Title.Text.Trim(); m_FilesManageModel.F_Content = FCKeditor.Value.Trim(); m_FilesManageModel.F_URL = string.Format("upload\\FilesManage\\{0}\\", strType); m_FilesManageModel.F_CreateUser = m_UserLogin.LoginID; m_FilesManageModel.F_CreateDate = DateTime.Now; m_FilesManageModel.F_Name = hpf.FileName; hpf.SaveAs(string.Format("{0}{1}{2}", Request.PhysicalApplicationPath, m_FilesManageModel.F_URL, m_FilesManageModel.F_Name)); if (m_FilesManageBLL.Add(m_FilesManageModel) > 0) { Tunnel.Common.Message.Show("新增成功", "N_FilesManageManage.aspx?type=" + strType + "&name=" + Request.QueryString["name"].ToString()); } else { Tunnel.Common.Message.back("新增失败"); return; } } else { m_FilesManageModel = m_FilesManageBLL.GetFilesManageModel(int.Parse(strFID)); m_FilesManageModel.F_Title = tb_Title.Text.Trim(); m_FilesManageModel.F_Content = FCKeditor.Value.Trim(); HttpPostedFile hpf = file1.PostedFile; if (hpf.FileName.Trim() != "") { m_FilesManageModel.F_Name = hpf.FileName; } else { m_FilesManageModel.F_Name = lblFiles.Text.Trim(); } m_FilesManageModel.F_URL = string.Format("upload\\FilesManage\\{0}\\", strType); m_FilesManageModel.F_ModiUser = m_UserLogin.LoginID; m_FilesManageModel.F_ModiDate = DateTime.Now; File.Delete(Request.PhysicalApplicationPath + lblUrl.Text.Trim()); hpf.SaveAs(string.Format("{0}{1}{2}", Request.PhysicalApplicationPath, m_FilesManageModel.F_URL, m_FilesManageModel.F_Name)); if (m_FilesManageBLL.Update(m_FilesManageModel) > 0) { Tunnel.Common.Message.Show("修改成功", "N_FilesManageManage.aspx?type=" + strType + "&name=" + Request.QueryString["name"].ToString()); } else { Tunnel.Common.Message.back("修改失败"); return; } } }
private void LoadSource() { if (strFID != "") { m_FilesManageModel = m_FilesManageBLL.GetFilesManageModel(int.Parse(strFID)); tb_Title.Text = m_FilesManageModel.F_Title; FCKeditor.Value = m_FilesManageModel.F_Content; if (m_FilesManageModel.F_Name.Trim() != "") { lblUrl.Text = m_FilesManageModel.F_URL + m_FilesManageModel.F_Name; lblFiles.Text = "附件:" + m_FilesManageModel.F_Name; lblMes.Visible = true; } } }
/// <summary> /// 更新数据 /// </summary> /// <param name="files">实体集</param> /// <returns>更新结果</returns> public int Update(Tunnel.Model.Tunnel_FilesManage files) { string strSQL = string.Format("UPDATE Tunnel_FilesManage SET F_Title='{1}',F_Content='{2}',F_Name='{3}',F_ModiUser={4},F_ModiDate='{5}' WHERE F_ID={0}", files.F_ID, files.F_Title, files.F_Content, files.F_Name, files.F_ModiUser, files.F_ModiDate); object obj = DbHelperSQL.ExecuteSql(strSQL); if (null != obj) { return(Convert.ToInt32(obj)); } else { return(0); } }
/// <summary> /// 新增一条数据 /// </summary> /// <param name="files">实体集</param> /// <returns>新增结果</returns> public int Add(Tunnel.Model.Tunnel_FilesManage files) { string strSQL = string.Format("INSERT INTO Tunnel_FilesManage (F_Type,F_Title,F_Content,F_Name,F_URL,F_CreateUser,F_CreateDate,F_ModiUser,F_ModiDate,F_DelUser,F_DelDate) " + "VALUES ('{0}','{1}','{2}','{3}','{4}',{5},'{6}',{7},'{8}',{9},'{10}')", files.F_Type, files.F_Title, files.F_Content, files.F_Name, files.F_URL, files.F_CreateUser, files.F_CreateDate, files.F_ModiUser, files.F_ModiDate, files.F_DelUser, files.F_DelDate); object obj = DbHelperSQL.ExecuteSql(strSQL); if (null != obj) { return(Convert.ToInt32(obj)); } else { return(0); } }
/// <summary> /// 获得档案Model /// </summary> /// <param name="fid">档案编号</param> /// <returns>档案Model</returns> public Tunnel.Model.Tunnel_FilesManage GetFilesManageModel(int fid) { Tunnel.Model.Tunnel_FilesManage filesManage = new Tunnel.Model.Tunnel_FilesManage(); string strSQL = string.Format("SELECT F_ID,F_Type,F_Title,F_Content,F_Name,F_URL,F_CreateUser,F_CreateDate FROM Tunnel_FilesManage WHERE F_ID={0}", fid); using (SqlDataReader reader = DbHelperSQL.ExecuteReader(strSQL)) { if (reader.Read()) { filesManage.F_ID = Convert.ToInt32(reader["F_ID"]); filesManage.F_Type = reader["F_Type"].ToString().Trim(); filesManage.F_Title = reader["F_Title"].ToString().Trim(); filesManage.F_Content = reader["F_Content"].ToString().Trim(); filesManage.F_Name = reader["F_Name"].ToString().Trim(); filesManage.F_URL = reader["F_URL"].ToString().Trim(); filesManage.F_CreateUser = Convert.ToInt32(reader["F_CreateUser"]); filesManage.F_CreateDate = Convert.ToDateTime(reader["F_CreateDate"]); } } return(filesManage); }
/// <summary> /// 修改 /// </summary> /// <param name="files">档案实体集</param> /// <returns>修改结果</returns> public int Update(Tunnel.Model.Tunnel_FilesManage files) { return(m_FilesManageDAL.Update(files)); }
/// <summary> /// 添加 /// </summary> /// <param name="files">档案实体集</param> /// <returns>添加结果</returns> public int Add(Tunnel.Model.Tunnel_FilesManage files) { return(m_FilesManageDAL.Add(files)); }