📄 officeserver.aspx.cs
字号:
else
{
mFilePath=mFilePath + "\\HTML\\" + mDirectory;
}
MsgObj.MakeDirectory(mFilePath);
if (MsgObj.MsgFileSave(mFilePath+"\\"+mHtmlName))
{
MsgObj.MsgError(""); //清除错误信息
MsgObj.SetMsgByName("STATUS","保存成功"); //设置状态信息
}
else
{
MsgObj.MsgError("保存失败"); //设置错误信息
}
MsgObj.MsgFileClear();
}
else if(mOption.Equals("INSERTFILE")) //请求调用正文文档
{
mRecordID=MsgObj.GetMsgByName("RECORDID"); //取得文档编号
//mFileName=MsgObj.GetMsgByName("FILENAME"); //取得文档名称
//mFileType=MsgObj.GetMsgByName("FILETYPE"); //取得文档类型
MsgObj.MsgTextClear();
if (LoadFile()) //调入文档
{
MsgObj.MsgFileBody(mFileBody); //将文件信息打包
MsgObj.SetMsgByName("POSITION","Content"); //设置插入的位置[书签对象名]
MsgObj.SetMsgByName("STATUS","插入文件成功!."); //设置状态信息
MsgObj.MsgError(""); //清除错误信息
}
else
{
MsgObj.MsgError("插入文件失败!"); //设置错误信息
}
}
else if(mOption.Equals("UPDATEFILE")) //请求保存文档
{
mRecordID=MsgObj.GetMsgByName("RECORDID"); //取得文档编号
mFileName=MsgObj.GetMsgByName("FILENAME"); //取得文档名称
mFileType=MsgObj.GetMsgByName("FILETYPE"); //取得文档类型
mFileSize=MsgObj.MsgFileSize(); //取得文档大小
mFileDate=DBAobj.GetDateTime(); //取得文档时间
mFileBody=MsgObj.MsgFileBody(); //取得文档内容
mFilePath=""; //如果保存为文件，则填写文件路径
mUserName=MsgObj.GetMsgByName("USERNAME"); //取得保存用户名称
mDescript="定稿版本"; //定稿版本说明
MsgObj.MsgTextClear();
if (SaveFile()) //保存文档内容
{
MsgObj.SetMsgByName("STATUS", "定稿保存成功!"); //设置状态信息
MsgObj.MsgError(""); //清除错误信息
}
else
{
MsgObj.MsgError("定稿保存失败!"); //设置错误信息
}
MsgObj.MsgFileClear();
}
else if(mOption.Equals("SENDMESSAGE")) //Web页面请求信息
{
mRecordID=MsgObj.GetMsgByName("RECORDID"); //取得文档编号
mFileName=MsgObj.GetMsgByName("FILENAME"); //取得文档名称
mFileType=MsgObj.GetMsgByName("FILETYPE"); //取得文档类型
mCommand=MsgObj.GetMsgByName("COMMAND"); //取得操作类型 InportText or ExportText
mContent=MsgObj.GetMsgByName("CONTENT"); //取得文本信息 Content
MsgObj.MsgTextClear();
MsgObj.MsgFileClear();
if (mCommand.Equals("INPORTTEXT"))
{
if (LoadContent())
{
MsgObj.SetMsgByName("CONTENT",mContent);
MsgObj.SetMsgByName("STATUS", "导入成功!"); //设置状态信息
MsgObj.MsgError(""); //清除错误信息
}
else
{
MsgObj.MsgError("导入失败!"); //设置错误信息
}
}
else if (mCommand.Equals("EXPORTTEXT"))
{
if (SaveContent())
{
MsgObj.SetMsgByName("STATUS", "导出成功!"); //设置状态信息
MsgObj.MsgError(""); //清除错误信息
}
else
{
MsgObj.MsgError("导出失败!"); //设置错误信息
}
}
else
{
MsgObj.MsgError("客户端Web发送数据包命令没有合适的处理函数!["+mCommand+"]");
MsgObj.MsgTextClear();
MsgObj.MsgFileClear();
}
}
else
{
MsgObj.MsgError("Error:packet message");
MsgObj.MsgTextClear();
MsgObj.MsgFileClear();
}
}
else
{
MsgObj.MsgError("Error:packet message");
MsgObj.MsgTextClear();
MsgObj.MsgFileClear();
}
Response.BinaryWrite(MsgObj.MsgVariant());
}
private bool LoadTemplate()
{
bool mResult=false;
string strSelectCmd="SELECT FileBody FROM Template WHERE RecordID='" + mTemplate + "'";
SqlCommand mCommand = new SqlCommand(strSelectCmd,DBAobj.GetConn());//更改
SqlDataReader mReader = null;
mReader=mCommand.ExecuteReader(CommandBehavior.CloseConnection);
if (mReader.Read())
{
mFileBody=mReader.GetSqlBinary(0).Value;
mReader.Close();
mCommand.Dispose();
mResult=true;
}
else
{
mReader.Close();
mCommand.Dispose();
mResult=false;
}
return (mResult);
}
private bool SaveTemplate()
{
bool mResult=false;
SqlCommand nCommand=null;
string strUpdateCmd;
string strInsertCmd;
string strSelectCmd= "SELECT * FROM Template WHERE RecordID='" + mTemplate + "'";
SqlCommand mCommand = new SqlCommand(strSelectCmd,DBAobj.GetConn());//更改
SqlDataReader mReader ;
mReader=mCommand.ExecuteReader(CommandBehavior.CloseConnection);
if (mReader.Read())
{
mReader.Close();
strUpdateCmd="update Template set RecordID=@RecordID,FileName=@FileName,FileType=@FileType,FileSize=@FileSize,FileDate=@FileDate,FileBody=@FileBody,FilePath=@FilePath,UserName=@UserName,Descript=@Descript WHERE RecordID='" + mTemplate + "'";
nCommand = new SqlCommand(strUpdateCmd, DBAobj.GetConn());//更改
}
else
{
mReader.Close();
strInsertCmd="insert into Template (RecordID,FileName,FileType,FileSize,FileDate,FileBody,FilePath,UserName,Descript) values (@RecordID,@FileName,@FileType,@FileSize,@FileDate,@FileBody,@FilePath,@UserName,@Descript)";
nCommand = new SqlCommand(strInsertCmd, DBAobj.GetConn());//更改
}
nCommand.Parameters.Add(new SqlParameter("@RecordID", SqlDbType.VarChar,16));
nCommand.Parameters["@RecordID"].Value = mTemplate;
nCommand.Parameters.Add(new SqlParameter("@FileName",SqlDbType.VarChar,64));
nCommand.Parameters["@FileName"].Value = mFileName;
nCommand.Parameters.Add(new SqlParameter("@FileType",SqlDbType.VarChar,4));
nCommand.Parameters["@FileType"].Value = mFileType;
nCommand.Parameters.Add(new SqlParameter("@FileSize",SqlDbType.Int));
nCommand.Parameters["@FileSize"].Value = mFileSize;
nCommand.Parameters.Add(new SqlParameter("@FileDate",SqlDbType.DateTime));
nCommand.Parameters["@FileDate"].Value = mFileDate;
nCommand.Parameters.Add(new SqlParameter("@FileBody",SqlDbType.Image));
nCommand.Parameters["@FileBody"].Value = mFileBody;
nCommand.Parameters.Add(new SqlParameter("@FilePath",SqlDbType.VarChar,64));
nCommand.Parameters["@FilePath"].Value = mFilePath;
nCommand.Parameters.Add(new SqlParameter("@UserName",SqlDbType.VarChar,32));
nCommand.Parameters["@UserName"].Value = mUserName;
nCommand.Parameters.Add(new SqlParameter("@Descript",SqlDbType.VarChar,64));
nCommand.Parameters["@Descript"].Value = mDescript;
if( nCommand.ExecuteNonQuery()==1)
{
mResult=true;
}
// mError=e.ToString();
else
{
mResult=false;
}
DBAobj.DataBaseClose();
return (mResult);
}
//调出文档，将文档内容保存在mFileBody里，以便进行打包
private bool LoadFile()
{
bool mResult=false;
string strSelectCmd="SELECT FileBody FROM Document_File WHERE RecordID='" + mRecordID + "'";
SqlCommand mCommand = new SqlCommand(strSelectCmd,DBAobj.GetConn());//更改
SqlDataReader mReader;
mReader=mCommand.ExecuteReader( CommandBehavior.CloseConnection);
if (mReader.Read())
{
mFileBody=mReader.GetSqlBinary(0).Value;
mResult=true;
mReader.Close();
mCommand.Dispose();
}
else
{
mResult=false;
mReader.Close();
mCommand.Dispose();
}
return (mResult);
}
//保存文档，如果文档存在，则覆盖，不存在，则添加
private bool SaveFile()
{
bool mResult=false;
SqlCommand nCommand=null;
string strUpdateCmd;
string strInsertCmd;
string strSelectCmd= "SELECT * FROM Document_File WHERE RecordID='" + mRecordID + "'";
SqlCommand mCommand = new SqlCommand(strSelectCmd,DBAobj.GetConn());//更改
SqlDataReader mReader ;
mReader=mCommand.ExecuteReader(CommandBehavior.CloseConnection);
if (mReader.Read())
{
mReader.Close();
strUpdateCmd="update Document_File set RecordID=@RecordID,FileName=@FileName,FileType=@FileType,FileSize=@FileSize,FileDate=@FileDate,FileBody=@FileBody,FilePath=@FilePath,UserName=@UserName,Descript=@Descript WHERE RecordID='" + mRecordID + "'";
nCommand = new SqlCommand(strUpdateCmd, DBAobj.GetConn());//更改
}
else
{
mReader.Close();
strInsertCmd="insert into Document_File (RecordID,FileName,FileType,FileSize,FileDate,FileBody,FilePath,UserName,Descript) values (@RecordID,@FileName,@FileType,@FileSize,@FileDate,@FileBody,@FilePath,@UserName,@Descript)";
nCommand = new SqlCommand(strInsertCmd, DBAobj.GetConn());//更改
}
nCommand.Parameters.Add(new SqlParameter("@RecordID", SqlDbType.VarChar,16));
nCommand.Parameters["@RecordID"].Value = mRecordID;
nCommand.Parameters.Add(new SqlParameter("@FileName",SqlDbType.VarChar,64));
nCommand.Parameters["@FileName"].Value = mFileName;
nCommand.Parameters.Add(new SqlParameter("@FileType",SqlDbType.VarChar,4));
nCommand.Parameters["@FileType"].Value = mFileType;
nCommand.Parameters.Add(new SqlParameter("@FileSize",SqlDbType.Int));
nCommand.Parameters["@FileSize"].Value = mFileSize;
nCommand.Parameters.Add(new SqlParameter("@FileDate",SqlDbType.DateTime));
nCommand.Parameters["@FileDate"].Value = mFileDate;
nCommand.Parameters.Add(new SqlParameter("@FileBody",SqlDbType.Image));
nCommand.Parameters["@FileBody"].Value = mFileBody;
nCommand.Parameters.Add(new SqlParameter("@FilePath",SqlDbType.VarChar,64));
nCommand.Parameters["@FilePath"].Value = mFilePath;
nCommand.Parameters.Add(new SqlParameter("@UserName",SqlDbType.VarChar,32));
nCommand.Parameters["@UserName"].Value = mUserName;
nCommand.Parameters.Add(new SqlParameter("@Descript",SqlDbType.VarChar,64));
nCommand.Parameters["@Descript"].Value = mDescript;
if(nCommand.ExecuteNonQuery()==1)
{
mResult=true;
}
else
{
mResult=false;
}
DBAobj.DataBaseClose();
return (mResult);
}
//列出所有版本信息
private bool ListVersion()
{
bool mResult=false;
mFileID="\r\n";
mDateTime="保存时间\r\n";
mUserName="用户名\r\n";
mDescript="版本说明\r\n";
SqlDataReader mReader=null;
string strSelectCmd= "SELECT FileID,FileDate,UserName,Descript FROM Document_File WHERE RecordID='" + mRecordID + "'";
SqlCommand mCommand = new SqlCommand(strSelectCmd,DBAobj.GetConn());//更改
mReader= mCommand.ExecuteReader(CommandBehavior.CloseConnection);
if (mReader.FieldCount>0)
{
while(mReader.Read())
{
mFileID+=mReader["FileID"].ToString() +"\r\n"; //文件号列表
mDateTime+=mReader["FileDate"].ToString() +"\r\n"; //日期列表
mUserName+=mReader["UserName"].ToString() +"\r\n"; //用户名列表
mDescript+=mReader["Descript"].ToString() +"\r\n"; //如果说明信息里有回车，则将回车变成>符号
}
mResult=true;
mReader.Close();
}
else
{
mResult=false;
mReader.Close();
}
return (mResult);
}
//调入选中版本，通过文件号调用mFileID,并把文件放入mFileBody里，以便进行打包
private bool LoadVersion(string mFileID)
{
bool mResult=false;
string strSelectCmd="SELECT FileBody FROM Document_File WHERE RecordID='" + mRecordID + "' and FileID=" + mFileID;
SqlCommand mCommand = new SqlCommand(strSelectCmd,DBAobj.GetConn());//更改
SqlDataReader mReader;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -