Web程序中将Cell华表的修改 保存到数据库或服务器端文件夹内

1.JS端 调用UploadFile方法
2.处理页面的相关编码

=========================
1.
----------------
//JS端 调用UploadFile方法
//该方法可能部分低版本不支持
var flag1 = cellShow.UploadFile("ReportUpload.aspx?
     ReportType=1&CellType=1&CellTitle="+escape(FiledTitle)+
     "&CellModule="+escape(cellModule)+"");

2.
----------------
//ReportUpload.aspx页面的相关代码
//该页面为空页面
//只需要Page_Load内如下相关操作就可
using ...
using System.IO;
protected void Page_Load(object sender, System.EventArgs e)
{
 // 接收客户发来的文件流
 int nBytes = Request.TotalBytes;
 byte[] UpFile = new byte[nBytes];
 UpFile = Request.BinaryRead(nBytes);
 
 // 保存到CellReport数据库中
 string myConnString = "Provider=Microsoft.Jet.OLEDB.4.0;data source =";
 OleDbConnection myConn =
                new OleDbConnection( myConnString + Server.MapPath("CellReport.mdb"));
 myConn.Open();
 string sql = "SELECT * FROM CellReportUpload";
 OleDbDataAdapter myAdapter = new OleDbDataAdapter(sql, myConn);
 OleDbCommandBuilder oleDbCommandBuilder = new OleDbCommandBuilder(myAdapter);
 
 DataSet ds = new DataSet();
 myAdapter.Fill(ds, "CellReportUpload");
 DataRow dr = ds.Tables["CellReportUpload"].NewRow();
 dr[1] = UpFile;
 ds.Tables["CellReportUpload"].Rows.Add(dr);
 myAdapter.Update(ds, "CellReportUpload");
 ds.Tables["CellReportUpload"].AcceptChanges();
 myConn.Close();
 
 // 保存到磁盘文件,通过流将数据保存成文件
        string strCellTitle = Request.QueryString["CellTitle"];
        string strCellModule = Request.QueryString["CellModule"];
        string strCellPath = "rpt" + strCellModule + "/where_" + strCellTitle + ".cll";
 if (File.Exists(Server.MapPath(strCellPath)))
                File.Delete(Server.MapPath(strCellPath));

 Stream fStream = new FileStream(Server.MapPath(strCellPath), FileMode.Create);
        fStream.Write(UpFile, 0, nBytes);
        fStream.Close();
}

posted on 2007-09-11 10:53  freeliver54  阅读(1647)  评论(1编辑  收藏  举报

导航