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) 编辑 收藏 举报