c#实现文件上传下载

最新推荐文章于 2024-07-31 17:22:00 发布
最新推荐文章于 2024-07-31 17:22:00 发布
阅读量1.8k 收藏 1
点赞数
分类专栏： .net 开发 文章标签： c# string border table exception null
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/liupeng826/article/details/1518114
版权
页面部分代码
<%@ Page language="c#" Codebehind="CVW_Attaced_File.aspx.cs" AutoEventWireup="false" Inherits="CVPro1.CVW_Attaced_File" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
  <HEAD>
  <TITLE>CVPro 対話管理</TITLE>
  <META http-equiv="Content-Type" content="text/html; charset=x-sjis">
  <META http-equiv="Content-Style-Type" content="text/css">
  <STYLE type="text/css">BODY { SCROLLBAR-FACE-COLOR: #aaaaee; SCROLLBAR-HIGHLIGHT-COLOR: #eeeeff; SCROLLBAR-SHADOW-COLOR: #7777cc; SCROLLBAR-3DLIGHT-COLOR: #ccccff; SCROLLBAR-TRACK-COLOR: #eeeeff; SCROLLBAR-DARKSHADOW-COLOR: #333399 }
 </STYLE>
   <LINK href="./img/css/file.css" type="text/css" rel="stylesheet">
    <script language="javascript" type="text/javascript">
  <!--
   function fncClick(keyCVNO,keyBUNSHONO,keySTEPCD,keyFILENO,flg) {
    var theform = document.CVW_Attaced_File;
    theform.FileCvno.value = keyCVNO;
    theform.FileKobunshono.value = keyBUNSHONO;
    theform.FileStepcd.value = keySTEPCD;
    theform.FileNo.value = keyFILENO;
    theform.submitFlg.value = flg;
    
    theform.submit();
    theform.FileCvno.value = "";
    theform.FileKobunshono.value = "";
    theform.FileStepcd.value = "";
    theform.FileNo.value = "";
    theform.submitFlg.value = "";
      }
     // -->
    </script>
</HEAD>
 <BODY text="#000000" vLink="#000000" aLink="#000000" link="#000000" bgColor="#aaaaee"
  leftMargin="0" topMargin="0">
  <!-- ##FROM## -->
  <form id="CVW_Attaced_File" method="post" runat="server">
   <FONT face="MS UI Gothic"></FONT>
   <BR>
   <TABLE style="BORDER-BOTTOM: 1px solid" borderColor="#7777cc" cellSpacing="0" cellPadding="0"
    width="100%" border="0">
    <TR>
     <TD></TD>
     <TD width="100%"><STRONG>&nbsp;&nbsp; 添付ファイル管理<br></STRONG><font color="#990000"><b>
        <asp:label id="lblErrorMessager" style="Z-INDEX: 101; LEFT: 400px; POSITION: absolute; TOP: 30px"
         ReadOnly="True" Runat="server" ></asp:label></b></font><BR>
     </TD>
    </TR>
   </TABLE>
   <IMG height="8" alt="" src="./img/clear.gif" width="8"><BR>
   <TABLE cellSpacing="0" cellPadding="0" border="0">
    <TR vAlign="top">
     <TD width="6"><IMG height="8" alt="" src="./img/clear.gif" width="6"></TD>
     <TD>
      <TABLE cellSpacing="0" cellPadding="0" width="100%" border="0">
       <TR vAlign="top" bgColor="#7777cc">
        <TD>
         <TABLE cellSpacing="0" cellPadding="0" width="100%" border="0">
          <TR bgColor="#ffffff">
           <TD></TD>
          </TR>
          <TR bgColor="#dddddd">
           <TD noWrap height="21"><b><span style="FONT-SIZE: 14px">　添付ファイル一覧</span></b><BR>
           </TD>
          </TR>
          <TR bgColor="#999999">
           <TD></TD>
          </TR>
          <TR bgColor="#ddddff">
           <TD></TD>
          </TR>
          <TR bgColor="#ffffff" border="0">
           <TD>
           <div style="DISPLAY: inline; OVERFLOW: auto; width: 910px; height: 300px;  background-color: #AAAAEE" id="layer1">
           
            <TABLE cellSpacing="0" cellPadding="0" border="0" >
             <TR bgColor="#bbbbff">
              <TD>
               <TABLE>
                <TR>
                 <TD><FONT face="MS UI Gothic"></FONT></TD>
                 <TD width="250"><B>&nbsp;タイトル</B></TD>
                 <TD width="3"><IMG height="25" src="img/lene_gw_hh.gif" width="2" border="0"></TD>
                 <TD width="150"><B>登録ステップ</B></TD>
                 <TD width="3"><FONT face="MS UI Gothic"><IMG height="25" src="img/lene_gw_hh.gif" width="2" border="0"></FONT></TD>
                 <TD width="75"><B>登録者</B></TD>
                 <TD width="3"><FONT face="MS UI Gothic"><IMG height="25" src="img/lene_gw_hh.gif" width="2" border="0"></FONT></TD>
                 <TD width="115"><B>登録日時</B></TD>
                 <TD width="3"><FONT face="MS UI Gothic"><IMG height="25" src="img/lene_gw_hh.gif" width="2" border="0"></FONT></TD>
                 <TD width="90"><B>操作</B></TD>
                 <TD width="3"><FONT face="MS UI Gothic"><IMG height="25" src="img/lene_gw_hh.gif" width="2" border="0"></FONT></TD>
                 <TD width="1200"><B>コメント</B></TD>
                                
                </TR>
               </TABLE>
             <tr bgColor="#ffffff">
              <td colSpan="2"><asp:datalist id="DataListFile" ItemStyle-Wrap=True AlternatingItemStyle-Wrap=True SelectedItemStyle-Wrap=True runat="server" width="1800px">
                <AlternatingItemStyle CssClass="dataGridAlternatingItemStyle"></AlternatingItemStyle>
                <ItemTemplate>                
                 <TABLE style="TABLE-LAYOUT: fixed">
                  <TR>
                   <TD></TD>
                   <TD width="250" style="LEFT: 0px; WORD-WRAP: break-word"><%# DataBinder.Eval(Container.DataItem, "TITLE") %>&nbsp;(&nbsp;<%# DataBinder.Eval(Container.DataItem, "FILEKIND") %>&nbsp;)</TD>
                   <TD width="5"></TD>
                   <TD width="150"><%# DataBinder.Eval(Container.DataItem, "STEPCD") %>&nbsp;<%# DataBinder.Eval(Container.DataItem, "KOBUNSHONO") %></TD>
                   <TD width="5"></TD>
                   <TD width="75"><%# DataBinder.Eval(Container.DataItem, "TOROKUSHACD") %></TD>
                   <TD width="5"></TD>
                   <TD width="115"><%# DataBinder.Eval(Container.DataItem, "TOROKUBI") %></TD>
                   <TD width="5"></TD>
                   <TD width="90"><%# DataBinder.Eval(Container.DataItem, "BOTTON") %></TD>
                   <TD width="5"></TD>
                   <TD width="1200" style="LEFT: 0px; WORD-WRAP: break-word"><%# DataBinder.Eval(Container.DataItem, "COMMENTS") %></TD>
                  </TR>                  
                 </TABLE>
                </ItemTemplate>
               </asp:datalist>
              </td>
             </tr>
            </TABLE> 
            </DIV>           
           </TD>
          </TR>
          
          <!-- BLOCK:WHITE -->
          <!-- /BLOCK:WHITE -->
          <!-- BLOCK:GREEN --></TABLE>
        </TD>
       </TR>
      </TABLE>
      
     </TD>
    </TR>
   </TABLE></TD></TR></TABLE></TD><TD width="1" bgColor="#ccccff"><IMG height="1" alt="" src="./img/clear.gif" width="1"></TD>
   <BR>
   <TABLE cellSpacing="0" cellPadding="0" border="0">
    <TR>
     <TD><IMG height="1" alt="" src="./img/clear.gif" width="6"></TD>
     <TD>
      <TABLE cellSpacing="0" cellPadding="0" width="910" border="0">
       <TR>
        <TD>
         <TABLE cellSpacing="0" cellPadding="0" width="910" border="0">
          <TR>
           <TD bgColor="#7777cc">
            <TABLE cellSpacing="0" cellPadding="0" width="910" border="0">
             <TR>
              <TD bgColor="#aaaaee">
               <TABLE cellSpacing="0" cellPadding="5" width="908" border="0">
                <TR>
                 <TD>
                  <TABLE id="table13" cellSpacing="0" cellPadding="0" width="906" border="0">
                   <TR>
                    <TD>
                     <hr>
                     <table id="table34" borderColor="#dddddd" height="31" width="910" border="0" borderbgColor="#dddddd">
                      <tr>
                       <td borderColor="#dddddd" bgColor="#dddddd"><b>お客様情報入力</b></td>
                      </tr>
                     </table>
                    </TD>
                   </TR>
                  </TABLE>                  
                  <TABLE id="table24" borderColor="#a2cef2" cellSpacing="0" width="908" bgColor="#ffffff"
                   border="1">
                   <TR>
                    <TD width="117" bgColor="#deeffe" height="24">&nbsp;ファイル名</TD>
                    <TD width="806" colSpan="3" height="24"><INPUT id="fileUpload" type="file" size="130" name="fileUpload" UNSELECTABLE="on" runat="server"></TD>
                   </TR>
                   <TR>
                    <TD width="117" bgColor="#deeffe">&nbsp;タイトル</TD>
                    <TD width="632" style="border-right-style: none; border-right-width: medium">
                    <asp:textbox id="titleBox" οnblur="this.style.backgroundColor='#FFFFFF'" style="TEXT-ALIGN: left"
                     οnfοcus="this.style.backgroundColor='#FFFFCC'" runat="server" Width="640px"></asp:textbox></FONT>
                    <TD width="81" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium">ファイルの種類</TD>
                    <TD width="62"  style="border-left-style: none; border-left-width: medium">
                     <!-- ファイル種類キー --><asp:dropdownlist id="filekindchange" tabIndex="10" runat="server" Width="70px"></asp:dropdownlist></TD>
                   </TR>
                   <TR>
                    <TD bgColor="#deeffe">&nbsp;コメント</TD>
                    <TD colSpan="3"><asp:textbox id="comments" οnblur="this.style.backgroundColor='#FFFFFF'" style="TEXT-ALIGN: left"
                      οnfοcus="this.style.backgroundColor='#FFFFCC'" runat="server" Width="800px"></asp:textbox></TD>
                   </TR>
                  </TABLE>
                  <p align="right"><INPUT class="submit_hj" id="clear" type="button" value="クリア" runat="server">
                   <INPUT class="submit_hj" id="execute" type="button" value="登録" name="execute" runat="server">
                   <INPUT class="submit_hj" id="close" οnclick="window.close();" type="button" value="閉じる">&nbsp;&nbsp;
                  </p>
                 </TD>
                 <TD align="right"></TD>
                </TR>
               </TABLE>
              </TD>
             </TR>
            </TABLE>
           </TD>
          </TR>
         </TABLE>
        </TD>
       </TR>
      </TABLE>
      <INPUT id="FileCvno" type="hidden" size="10" name="FileCvno" runat="server"> <INPUT id="FileNo" type="hidden" size="10" name="FileNo" runat="server">
      <INPUT id="FileStepcd" type="hidden" size="10" name="FileStepcd" runat="server">
      <INPUT id="FileKobunshono" type="hidden" size="10" name="FileKobunshono" runat="server">
      <INPUT id="submitFlg" type="hidden" size="10" name="submitFlg" runat="server">
     </TD>
    </TR>
   </TABLE>
  </form></FONT>
 </BODY>
</HTML>

表的的定义代码
CREATE TABLE CVPRODEMO.CV_ATTACHEDFILE
(
    CVNO                           NUMBER(11,0) NOT NULL,
    BUNSHONO                       NUMBER(2,0) NOT NULL,
    STEPCD                         CHAR(1) DEFAULT '0' NOT NULL,
    FILENO                         NUMBER(15,0) NOT NULL,
    FILENAME                       VARCHAR2(255) NOT NULL,
    FILEKIND                       CHAR(3) NOT NULL,
    FILECONTENTS                   BLOB NOT NULL,
    TOROKUSHACD                    NUMBER(3,0) NOT NULL,
    TOROKUBI                       DATE DEFAULT SYSDATE NOT NULL,
    DELFLG                         CHAR(1),
    TITLE                          VARCHAR2(255) NOT NULL,
    COMMENTS                       VARCHAR2(512),
    LSTUPDATETIME                  DATE DEFAULT SYSDATE NOT NULL,
    CONSTRAINT "pk_CV_ATTACHEDFILE" PRIMARY KEY (CVNO, BUNSHONO, STEPCD, FILENO) USING INDEX
        PCTFREE 10
        INITRANS 2
        MAXTRANS 255
        TABLESPACE CVPRODEMO
        STORAGE(INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
        LOGGING
)
PCTFREE 10
MAXTRANS 255
TABLESPACE CVPRODEMO
STORAGE(INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
NOCACHE
LOGGING
/
后台代码
using System;
using System.Data;
using System.Data.OracleClient;
using System.IO;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using CVPro1.Common;
using CVProCom.Common;
using CVW.DBWrapper;
namespace CVPro1
{
 /// <summary>
 /// CVW_Attaced_File の概要の説明です。
 /// </summary>
 public class CVW_Attaced_File : Page
 {
  private DataSet DataSetFile;
  private ConnectionManager connectionManager = new ConnectionManager();
  protected System.Web.UI.WebControls.DataList DataListFile;
  protected System.Web.UI.HtmlControls.HtmlInputFile fileUpload;
  protected System.Web.UI.HtmlControls.HtmlInputHidden submitFlg;
  protected System.Web.UI.HtmlControls.HtmlInputHidden FILENO;
  
  protected System.Web.UI.WebControls.TextBox titleBox;
  protected System.Web.UI.WebControls.TextBox comments;
  protected System.Web.UI.WebControls.DropDownList filekindchange;
  protected System.Web.UI.HtmlControls.HtmlInputHidden FileKobunshono;
  protected System.Web.UI.HtmlControls.HtmlInputHidden FileStepcd;
  protected System.Web.UI.HtmlControls.HtmlInputHidden FileNo;
  protected System.Web.UI.HtmlControls.HtmlInputButton clear;
  protected System.Web.UI.HtmlControls.HtmlInputButton execute;
  protected System.Web.UI.HtmlControls.HtmlInputHidden FileCvno;
  protected System.Web.UI.WebControls.Label lblErrorMessager; 
  private string pstrCVNO = "";           //CV番号
  private string pstrBUNSHONO = "";       //子文書番号
  private string pstrSTEPCD= "";   //処理ｽﾃｯﾌﾟ
  private string pstrTOROKUSHACD= "";  //担当者ＣＤ
  private double strMAXSIZE= 0;   //MAXSIZE
  string keySTEPCD = "";
  string keyCVNO= "";
  string keyBUNSHONO= "";
  string keyFILENO = "";
  string documentURL="";
  
  private void Page_Load(object sender, EventArgs e)
  {
   
   // ページを初期化するユーザー コードをここに挿入します。
   //タイムアウト
   try
   {
    pstrCVNO = this.Request.QueryString["cvno"].ToString();
   }
   catch
   {
    pstrCVNO = "";
   }
   try
   {
    pstrBUNSHONO = this.Request.QueryString["bunshono"].ToString();
   }
   catch
   {
    pstrBUNSHONO = "";
   }
   try
   {
    pstrTOROKUSHACD = this.Request.QueryString["tantoshacd"].ToString();
   }
   catch
   {
    pstrTOROKUSHACD = "";
   }
   try
   {
    pstrSTEPCD = this.Request.QueryString["stepcd"].ToString();
   }
   catch
   {
    pstrSTEPCD = "";
   }
   try
   {
    strMAXSIZE = double.Parse(this.Request.QueryString["maxsize"]);
   }
   catch
   {
    strMAXSIZE = 3;
   }
 
   
   if ("sakuzyo".Equals(submitFlg.Value))
   {
    _doSakuzyo();
   }
   else if ("download".Equals(submitFlg.Value))
   {
    _doDownload();
   }
   //ファイル名 初期状態はNULL、直接入力不可
   //this.fileUpload.Disabled = true;
   
   _fillBody();
   if (!IsPostBack) {
   //ファイル種類
    CVWCommon.setCboDefault(filekindchange, "700", null);
   
    }
   }
  #region Web フォーム デザイナで生成されたコード
  protected override void OnInit(EventArgs e)
  {
   //
   // CODEGEN: この呼び出しは、ASP.NET Web フォーム デザイナで必要です。
   //
   InitializeComponent();
   base.OnInit(e);
  }
  /// <summary>
  /// デザイナ サポートに必要なメソッドです。このメソッドの内容を
  /// コード エディタで変更しないでください。
  /// </summary>
  private void InitializeComponent()
  {
   this.clear.ServerClick += new System.EventHandler(this.clear_ServerClick);
   this.execute.ServerClick += new System.EventHandler(this.Execute_ServerClick);
   this.Load += new System.EventHandler(this.Page_Load);
  }
  #endregion
  /// <summary>
  ///　画面入力のチェック
  /// </summary>
  /// <returns></returns>
  private bool fncCheck()
  {
   if (this.fileUpload.Value == "")
   {
    this.lblErrorMessager.Text = "ファイル名が取得できません。";
    return false;
   }
   if (this.titleBox.Text == "")
   {  
    this.lblErrorMessager.Text = "タイトルが取得できません。";
    return false;
   }
   return true;
  }
  
  private void _fillBody()
  {
   try
   {
    connectionManager.Open();
    OleDBOperation oleDbOperation = new OleDBOperation(connectionManager.Connection, connectionManager.Transaction);
    string strSql = " SELECT A.TITLE, B2.CODEMEISHO,  B1.CODEMEISHO , C.SEIK||' '||C.MEIK ,TO_CHAR(A.TOROKUBI, 'YY/MM/DD HH24:MI') , A.COMMENTS , A.FILENO , '('||'子文書'||A.BUNSHONO||')' ,A.STEPCD,trim(to_char(A.CVNO,'00000000000')),trim(to_char(A.BUNSHONO,'00'))" +
                                " FROM CV_ATTACHEDFILE A , CVC_CODE B1,CVC_CODE B2 ,CVM_TANTOSHA C WHERE  ((B2.CODEKEY = '700') AND (A.FILEKIND = B2.CODE)) AND ((B1.CODEKEY = '961') AND (A.STEPCD = B1.CODE)) AND (A.TOROKUSHACD = C.TANTOSHACD) AND ( A.DELFLG = '0' ) AND" +
                    " A.CVNO = " + this.pstrCVNO +
                    " ORDER BY A.CVNO ASC,A.STEPCD ASC ,A.BUNSHONO ASC ,A.FILENO ASC";
    DataSetFile = oleDbOperation.SelectToDataSet(strSql);
    _DataListsyutoku();
   }
   catch (Exception ex)
   {
    throw ex;
   }
   finally
   {
    connectionManager.Close();
   }
  }
  private void _DataListsyutoku()
  {
   DataTable dt = new DataTable();
   dt.Columns.Add(new DataColumn("TITLE", typeof (string)));
   dt.Columns.Add(new DataColumn("STEPCD", typeof (string)));
   dt.Columns.Add(new DataColumn("FILENO", typeof (string)));
   dt.Columns.Add(new DataColumn("TOROKUSHACD", typeof (string)));
   dt.Columns.Add(new DataColumn("TOROKUBI", typeof (string)));
   dt.Columns.Add(new DataColumn("BOTTON", typeof (string)));
   dt.Columns.Add(new DataColumn("COMMENTS", typeof (string)));
   dt.Columns.Add(new DataColumn("FILEKIND", typeof (string)));
   dt.Columns.Add(new DataColumn("KOBUNSHONO", typeof (string)));
   
   DataRow row = null;
   if (DataSetFile != null)
   {
    for (int intRow = 0; intRow < DataSetFile.Tables[0].Rows.Count; intRow++)
    {
     row = dt.NewRow();
     row["TITLE"] = DataSetFile.Tables[0].Rows[intRow][0].ToString().Trim();
     row["FILEKIND"] = DataSetFile.Tables[0].Rows[intRow][1].ToString().Trim();
     row["STEPCD"] = DataSetFile.Tables[0].Rows[intRow][2].ToString().Trim();
     row["TOROKUSHACD"] = DataSetFile.Tables[0].Rows[intRow][3].ToString().Trim();
     row["TOROKUBI"] = DataSetFile.Tables[0].Rows[intRow][4].ToString().Trim();
     keySTEPCD = DataSetFile.Tables[0].Rows[intRow][8].ToString().Trim();
     
     if((keySTEPCD=="3") || (keySTEPCD=="4" ))
     {
      row["KOBUNSHONO"] = DataSetFile.Tables[0].Rows[intRow][7].ToString().Trim();
     }
     
     keyCVNO= DataSetFile.Tables[0].Rows[intRow][9].ToString().Trim();
     keyBUNSHONO= DataSetFile.Tables[0].Rows[intRow][10].ToString().Trim();
     keyFILENO = DataSetFile.Tables[0].Rows[intRow][6].ToString().Trim();
     string button =
       "<input id='download" + intRow + "' type='button' class='submit_hj2' value='取出' οnclick=fncClick('" + keyCVNO +
      "','" + keyBUNSHONO + "','" + keySTEPCD + "','" + keyFILENO + "','download')>&nbsp;&nbsp;"
      + "<input id='sakuzyo" + intRow + "'  type='button' class='submit_hj2' value='削除'  οnclick=fncClick('" + keyCVNO +
      "','" + keyBUNSHONO + "','" + keySTEPCD + "','" + keyFILENO + "','sakuzyo')>";
     row["BOTTON"] = button;
     row["COMMENTS"] = DataSetFile.Tables[0].Rows[intRow][5].ToString().Trim();
     dt.Rows.Add(row);
    }
   }
   DataListFile.DataSource = new DataView(dt);
   DataListFile.DataBind();
  }
  private void Execute_ServerClick(object sender, EventArgs e)
  {
   Response.Clear();
   try
   {
    // Get a reference to PostedFile object
    HttpPostedFile myFile = fileUpload.PostedFile;
    // Get size of uploaded file
    int nFileLen = myFile.ContentLength;
    double nFileMB = nFileLen/(1024*1024.0);
    string filepath = this.fileUpload.Value;
   
    if (nFileMB > strMAXSIZE)
    {
     this.lblErrorMessager.Text = "ファイル最大サイズは"+strMAXSIZE+"MB。";
     return ;
    }
    //デーだのチェック
    if(fncCheck()==false) return;
   }
   catch (Exception ex)
   {
    throw   ex;
   }
   
   string connstr = "User Id=cvprodemo;Password=cvpro;Data Source=orcl;";
   OracleConnection conn = new OracleConnection(connstr);
   conn.Open();
   if (fileUpload.PostedFile != null)
   {
    string selSql = "SELECT * FROM CV_ATTACHEDFILE WHERE FILENO IS NULL ";
    _saveDB(conn, selSql);
   }
   _fillBody();
   clear_ServerClick(sender, e);
  }
  private void _saveDB(OracleConnection conn, string selSql)
  {
   // Get a reference to PostedFile object
   HttpPostedFile myFile = fileUpload.PostedFile;
   // Get size of uploaded file
   int nFileLen = myFile.ContentLength;
   double nFileMB = nFileLen/(1024*1024.0);
   if ((nFileLen > 0) && (nFileMB < strMAXSIZE))
   {
    // Allocate a buffer for reading of the file
    byte[] myData = new byte[nFileLen];
    // Read uploaded file from the Stream
    myFile.InputStream.Read(myData, 0, nFileLen);
    try
    {
     OracleDataAdapter da = new OracleDataAdapter(selSql, conn);
     DataTable dt = new DataTable();
     da.FillSchema(dt, SchemaType.Source);
     OracleCommandBuilder cb = new OracleCommandBuilder(da);
     string filename = Path.GetFileName(fileUpload.Value);
     string filekind = this.filekindchange.SelectedValue;
     string systime = DateTime.Now.ToString("yyyy/MM/dd hh:mm");
     DataRow row = dt.NewRow();
     row["CVNO"] = pstrCVNO;
     row["BUNSHONO"] = pstrBUNSHONO;
     row["STEPCD"] = pstrSTEPCD;
     row["FILENO"] = _getFileNO();
     row["FILENAME"] = filename;
     row["TOROKUBI"] = systime;
     row["FILEKIND"] = filekind;
     row["FILECONTENTS"] = myData;
     row["TOROKUSHACD"] = pstrTOROKUSHACD;
     row["TITLE"] = titleBox.Text;
     row["DELFLG"] = '0';
     row["LSTUPDATETIME"] = systime;
     if ( this.comments.Text != "")
     {
      row["COMMENTS"] = this.comments.Text;
     }
     dt.Rows.Add(row);
     da.Update(dt);
    }
    catch (Exception ex)
    {
     throw   ex;
    }
   }
    
  }
  private void _doSakuzyo()
  {
   try
   {
    connectionManager.Open();
    connectionManager.BeginTransaction();
    OleDBOperation oleDbOperation = new OleDBOperation(connectionManager.Connection, connectionManager.Transaction);
    string sql = " UPDATE CV_ATTACHEDFILE  SET DELFLG ='1' WHERE " +
     " CVNO = " + this.FileCvno.Value + " AND" +
     " BUNSHONO = " + FileKobunshono.Value + " AND" +
     " STEPCD = '" + FileStepcd.Value + "'" + " AND" +
     " FILENO = " + FileNo.Value ;
    oleDbOperation.InsertAction(sql);
    connectionManager.CommitTransaction();
   }
   catch (Exception ex )
   {
    connectionManager.RollbackTransaction();
   }
   finally
   {
    connectionManager.Close();
   }
  }
  private void _doDownload()
  {
   string connstr = "User Id=cvprodemo;Password=cvpro;Data Source=orcl;";
   OracleConnection conn = new OracleConnection(connstr);
   conn.Open();
   string sql = " SELECT  FILECONTENTS , FILENAME , CVNO, BUNSHONO , STEPCD, FILENO ,FILEKIND  ,TOROKUSHACD ,TOROKUBI ,DELFLG , TITLE, COMMENTS , LSTUPDATETIME" +
    " FROM CV_ATTACHEDFILE  WHERE " +
    " CVNO = " + this.FileCvno.Value + " AND" +
    " BUNSHONO = " + FileKobunshono.Value + " AND" +
    " STEPCD = '" + FileStepcd.Value + "'" + " AND" +
    " FILENO = " + FileNo.Value ;
   _DL(conn, sql);
  }
  private void _DL(OracleConnection conn, string sql)
  {
   try
   {
    OracleDataAdapter dbAdapt = new OracleDataAdapter();
    dbAdapt.SelectCommand = new OracleCommand(sql, conn);
    DataSet dset = new DataSet("dset");
    dbAdapt.Fill(dset);
    DataTable dataTable = dset.Tables[0];
    if (dataTable != null)
    {
     string destFileName = (string) dataTable.Rows[0][1];
     string newFileName = destFileName;
     byte[] blob = (byte[]) dataTable.Rows[0][0];
     
     destFileName = Server.MapPath("AttachedFiles") + "//" + FileCvno.Value + FileKobunshono.Value + FileStepcd.Value  + "//" + destFileName;
     
     destFileName = Server.UrlDecode(destFileName);
     
     //CreateDirectory
     if (!Directory.Exists(Server.MapPath("AttachedFiles")))
     {
      Directory.CreateDirectory(Server.MapPath("AttachedFiles"));
     }
     
     Directory.CreateDirectory(Server.MapPath("AttachedFiles") + "//" + FileCvno.Value + FileKobunshono.Value + FileStepcd.Value);
     
     FileStream FS = new FileStream(destFileName, FileMode.Create);
     FS.Write(blob, 0, blob.Length);
     FS.Close();
     FS = null;
     
     documentURL = HttpContext.Current.Request.ApplicationPath + "/AttachedFiles/"
      + FileCvno.Value + FileKobunshono.Value + FileStepcd.Value + "/" + newFileName;
     
     string script = "<SCRIPT LANGUAGE='javascript'>";
     script += "window.open('" + documentURL + "');";
     script += "</SCRIPT>";
     Response.Write(script);
     
//     Response.Clear();
//     Response.ClearHeaders();
//     Response.Buffer = false;
//     Response.AppendHeader("Content-Disposition",
//      "attachment;filename=" + HttpUtility.UrlEncode(Path.GetFileName(destFileName), Encoding.UTF8));
//     Response.AppendHeader("Content-Length", blob.Length.ToString());
//     Response.ContentType = "application/octet-stream";
//     Response.OutputStream.Write(blob, 0, blob.Length);
//     Response.Flush();
//     Response.End();
    }
   }
   catch (Exception ex)
   {
    throw ex;
   }
  }
  private string _getFileNO()
  {
   string tmpID = "";
   try
   {
    connectionManager.Open();
    OleDBOperation oleDbOperation = new OleDBOperation(connectionManager.Connection, connectionManager.Transaction);
    string selSql = "SELECT ATTACHEDFILENO.NEXTVAL FROM DUAL";
    DataSetFile = oleDbOperation.SelectToDataSet(selSql);
    tmpID = DataSetFile.Tables[0].Rows[0][0].ToString().Trim();
   }
   catch (Exception ex)
   {
    throw ex;
   }
   finally
   {
    connectionManager.Close();
   }
   return tmpID;
  }
  private void clear_ServerClick(object sender, System.EventArgs e)
  {
   Response.Clear();
   this.titleBox.Text = "";
   this.comments.Text = "";
   this.filekindchange.SelectedIndex = 0;
   this.lblErrorMessager.Text = "";
  }
 }
}
 
liupeng826
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
C#文件上传与下载
XieYi_____的博客
05-19 342
///文件上传 bool fileOK = true; //文件的上传路径 string path = Server.MapPath("~/ExperimentTen/res/Import/"); //判断上传文件夹是否存在，若不存在，则创建 if (!Directory.Exists(path)) { //创建文件夹 ...
C#实现文件上传下载
对信仰的忠诚丶
10-12 1467
文件下载  //指定文件MIME类型             Response.ContentType = "application/msword";             //下载头指令             Response.AddHeader("Content-Disposition", "attchment;filename=c#基础概念.doc");        
C#文件上传下载
03-09
对于初学TCP方面的新手比较有帮助的，此程序使用socket套接字进行通信，对文件进行接收和上传
C# 文件上传下载
weixin_45525177的博客
12-08 184
大家都知道，在我们平时使用计算机时要找到需要的文件就必须知道文件的位置，而表示文件的位置的方式就是路径，例如只要看到这个路径：c:/website/img/photo.jpg我们就知道photo.jpg文件是在c盘的website目录下的img子目录中。这样完整的描述文件位置的路径就是绝对路径。参考文章：http://blog.ncmem.com/wordpress/2023/12/08/c-%e6%96%87%e4%bb%b6%e4%b8%8a%e4%bc%a0%e4%b8%8b%e8%bd%bd/
C#.NET大文件上传解决方案
最新发布
weixin_52041354的博客
07-31 368
C#.NET支持超大文件HTTP切割上传，C#.NET支持超大文件HTTP切片上传，C#.NET支持超大文件HTTP分割上传，C#.NET支持超大文件HTTP分段上传，C#.NET支持超大文件HTTP分块上传，C#.NET支持超大文件HTTP分片上传，.NET mvc支持超大文件HTTP断点续传，.NET core支持超大文件HTTP断点续传，要求支持断点续传，支持进度信息离线存储，用户可能传一半没有传完，下班了，明天上班后继续上传，电脑晚上到点需要关机，支持加密传输，支持国密加密算法SM4，
文件上传(C#代码)
山里娃的专栏
08-21 1030
string filename = file.PostedFile.FileName;    string shortname = System.IO.Path.GetFileName(filename); //短文件名    if (filename != "")    {     string path = ConfigurationSettings.AppSettings["Path
WebAPI的文件上传与下载
weixin_30244681的博客
12-28 157
上传： <input type="file" id="file" /> <input type="button" id="upload" value="上传文件" /> <script> //上传 $("#upload").click(function () { var formData = new F...
c# 文件上传下载
Empty_Android的博客
12-03 1209
1. 介绍  C#文件上传下载用WebClient类实现 微软官方使用Demo https://docs.microsoft.com/en-us/dotnet/api/system.net.webclient.downloadfile?view=netframework-4.7.2 架构为B/S   模板 服务器: WebForm 客户端:ConsoleApplication  ...
C#实现文件上传下载Excel文档示例代码
08-29
C#实现文件上传下载Excel文档示例代码 本文主要介绍了C#实现文件上传下载Excel文档示例代码的相关知识点，主要包括文件上传、文件下载、Excel文档处理等方面。 一、文件上传 文件上传是指将文件从客户端上传到...
C#实现文件上传及文件下载功能实例代码
08-29
"C#实现文件上传及文件下载功能实例代码" 在项目开发中，文件上传和下载是非常常见的需求。今天，我们将分享C#实现文件上传及文件下载功能实例代码，帮助开发者更好地解决文件上传和下载的问题。 文件上传 文件...
c# 实现文件上传下载功能的实例代码
08-18
"c# 实现文件上传下载功能的实例代码" 本文主要介绍了如何使用 C# 实现文件上传下载功能，通过详细的示例代码，帮助大家更好地理解和学习 C# 文件上传下载功能的实现。 知识点 1：DbContext 类的实现 在 C# 中，...
C# 多文件上传下载
09-27
C# 多文件上传下载C# 多文件上传下载C# 多文件上传下载C# 多文件上传下载C# 多文件上传下载C# 多文件上传下载C# 多文件上传下载C# 多文件上传下载C# 多文件上传下载
C# 文件上传
weixin_33727510的博客
01-10 114
 一、分析       本次博客，主要解决文件上传等一系列问题，将从两方面来论述，即1G以内文件和1G以上文件。       对于上传1G以内的文件，可以采用基本的三种上传方法：用Web控件FileUpload、html控件HtmlInputFile和用Html元素&lt;input type="file" id="file"/&gt;，通过Request.Files上传。       对于...
C# 文件上传
weixin_30561425的博客
09-15 116
将文件以二进制数据上传： 前台： 给提交表单设置提交方式： enctype="multipart/form-data" 使用一个上传文件的input框 给它一个name 后台： 　if (file==null) { re...
C# 文件上传
不学习何以强国的博客
01-22 2773
【代码】C# 文件上传
C#文件上传
清雨小竹
04-11 387
【代码】C#文件上传。
C# WinForm文件上传与下载实现
在C#中，实现文件上传与下载功能是常见的需求，特别是在开发基于WinForm的应用程序时。以下是一些关于如何在C#中实现这些功能的关键知识点： 1. **文件上传**： 文件上传通常涉及用户通过Web表单选择本地文件，...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值