/// <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));
}
