private void IniData()
{
tvMain.Nodes.Clear();
TreeNode trNo = new TreeNode("内部文件");
trNo.ImageUrl = "~/Image/Folder.ico";
trNo.Target = "0";
tb_FolderService folderSer = new tb_FolderService();
List <tb_Folder> allFolder = folderSer.GetListArray("");
tb_AttachmentService ATTSer = new tb_AttachmentService();
List <tb_Attachment> atts = ATTSer.GetListArray_TV("");
for (int i = 0; i < atts.Count; i++)
{
tb_Folder fole = new tb_Folder();
fole.Type = "file";
fole.ParentId = Convert.ToInt32(atts[i].Folder_Id);
fole.Folder_NAME = atts[i].MainName + "(" + atts[i].createTime + ")";
fole.AttId1 = atts[i].id.ToString();
fole.Folder_ID = -1;
allFolder.Add(fole);
}
showFolder(allFolder, trNo);
tvMain.Nodes.Add(trNo);
tvMain.CollapseAll();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
IniData();
lblParent.Text = "";
lblFolderId.Visible = false;
tb_AttachmentService attSer = new tb_AttachmentService();
if (base.Request["Id"] != null)
{
this.btnAdd.Visible = false;
tb_Attachment attachment = attSer.GetListArrayByParentId(Convert.ToInt32(base.Request["Id"]));
txtAttName.Text = attachment.MainName;
txtRemark.Text = attachment.Remark;
txtVersion.Text = attachment.version;
lblFolderId.Text = attachment.Folder_Id.ToString();
lblParent.Text = attachment.FolderName;
lblAttName.Text = attachment.fileName;
}
else
{
this.btnUpdate.Visible = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
tb_AttachmentService attSer = new tb_AttachmentService();
List <tb_Attachment> atts = attSer.GetListArray("");
gvList.DataSource = atts;
gvList.DataBind();
tb_FolderService folderSer = new tb_FolderService();
List <tb_Folder> allFolder = folderSer.GetListArray("");
allFolder.Insert(0, new tb_Folder());
ddlFolders.DataSource = allFolder;
ddlFolders.DataBind();
ddlFolders.DataTextField = "Folder_NAME";
ddlFolders.DataValueField = "Folder_ID";
#region 是否有删除功能
if (Session["currentUserId"] != null)
{
VAN_OA.Dal.TB_AdminDeleteService deleteSer = new VAN_OA.Dal.TB_AdminDeleteService();
if (deleteSer.CheckIsExistByUserId(Convert.ToInt32(Session["currentUserId"])) == false)
{
gvList.Columns[6].Visible = false;
}
}
#endregion
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// string url="<script>window.open('55.htm', '','fullscreen=yes')</script>";
// Response.Write(url);
//if (1 == 1)
//{
// return;
//}
if (Request["id"] != null)
{
tb_AttachmentService attSer = new tb_AttachmentService();
tb_Attachment atts = attSer.GetListArrayByParentId_Pre(Request["id"]);
if (atts != null)
{
string qizhui = System.Web.HttpContext.Current.Request.MapPath("Attachment/") + Request["id"];
string fileExtension = atts.fileName.Substring(atts.fileName.LastIndexOf(".") + 1).ToLower();
if (fileExtension == "doc" || fileExtension == "docx")
{
if (File.Exists(qizhui + "." + "htm") == false)
{
WordToHtml(qizhui + "." + fileExtension, qizhui + ".htm");
}
// url = "/Attachment/" + Request["id"] + ".htm";
Response.Redirect("~/Attachment/" + Request["id"] + ".htm");
}
else if (fileExtension == "xlsx" || fileExtension == "xls")
{
if (File.Exists(qizhui + "." + "htm") == false)
{
ExcelConvertToHtml(qizhui + "." + fileExtension, qizhui + ".htm");
}
// url = "/Attachment/" + Request["id"] + ".htm";
Response.Redirect("~/Attachment/" + Request["id"] + ".htm");
}
else
{
Response.Redirect("~/Attachment/" + Request["id"] + "." + fileExtension);
//Response.ContentType = atts.FileType;
//Response.BinaryWrite((byte[])atts.fileNo);
//Response.Write(atts.fileName.ToString());
}
}
// Response.Write("<script>window.close();window.opener=null;</script>");
}
}
}
protected void gvList_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string id = this.gvList.DataKeys[e.RowIndex].Value.ToString();
tb_AttachmentService attSer = new tb_AttachmentService();
attSer.Delete(id.ToString());
show();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request["id"]!=null)
{
tb_AttachmentService attSer = new tb_AttachmentService();
tb_Attachment atts = attSer.GetListArrayByParentId_Down( Request["id"]);
if (atts != null )
{
string qizhui = System.Web.HttpContext.Current.Request.MapPath("Attachment/") + Request["id"];
string fileExtension = atts.fileName.Substring(atts.fileName.LastIndexOf(".") + 1).ToLower();
string url = qizhui + "." + fileExtension;
down1(Request["id"]+"." + fileExtension, url);
//Response.Buffer = true;
//Page.Response.Clear();//清除缓冲区所有内容
//Page.Response.ContentType = "application/octet-stream";
//Page.Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(atts.fileName));
//byte[] file;
//if (atts.fileNo == null)
//{
// file = new byte[0];
//}
//else
//{
// file = (Byte[])atts.fileNo;//读出数据
//}
//int a = file.Length;
//if (atts.fileNo != null)
//{
// Response.BinaryWrite(file);
//}
//Response.Flush();
//Response.End();
}
// Response.Write("<script>window.close();window.opener=null;</script>");
}
}
}
private void show()
{
try
{
string sql = " ";
if (txtMainName.Text.Trim() != "")
{
sql += string.Format(" and mainName like '%{0}%'", txtMainName.Text);
}
if (txtFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtFrom.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('创建时间 格式错误！');</script>");
return;
}
sql += string.Format(" and createTime>='{0} 00:00:00'", txtFrom.Text);
}
if (txtTo.Text != "")
{
if (CommHelp.VerifesToDateTime(txtTo.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('创建时间 格式错误！');</script>");
return;
}
sql += string.Format(" and createTime<='{0} 23:59:59'", txtTo.Text);
}
if (ddlFolders.Text != "0")
{
sql += string.Format(" and tb_Attachment.folder_Id={0}", ddlFolders.Text);
}
tb_AttachmentService attSer = new tb_AttachmentService();
List <tb_Attachment> atts = attSer.GetListArray(sql);
gvList.DataSource = atts;
gvList.DataBind();
}
catch (Exception)
{
}
}
