📄 officeserver.aspx.cs
字号:
{
MsgObj.MsgError("打开全文批注失败!"); //设置状态信息
}
}
else
{
MsgObj.MsgError("Error:packet message");
MsgObj.MsgTextClear();
MsgObj.MsgFileClear();
}
}
else
{
MsgObj.MsgError("Error:packet message");
MsgObj.MsgTextClear();
MsgObj.MsgFileClear();
}
Response.BinaryWrite(MsgObj.MsgVariant());
}
//
// 文档、模板管理代码 开始 *******************************
//
//调出模板文档，将模板文档内容保存在mFileBody里，以便进行打包
private bool LoadTemplate()
{
bool mResult=false;
string strSelectCmd="SELECT FileBody FROM Template_File WHERE RecordID='" + mTemplate + "'";
SqlCommand mCommand = new SqlCommand(strSelectCmd,DBAobj.Connection);
SqlDataReader mReader = mCommand.ExecuteReader();
if (mReader.Read())
{
mFileBody=mReader.GetSqlBinary(0).Value;
mResult=true;
}
else
{
mResult=false;
}
mReader.Close();
return (mResult);
}
//保存模板文档，如果模板文档存在，则覆盖，不存在，则添加
private bool SaveTemplate()
{
bool mResult=false;
SqlCommand nCommand;
string strUpdateCmd;
string strInsertCmd;
string strSelectCmd= "SELECT * FROM Template_File WHERE RecordID='" + mTemplate + "'";
SqlCommand mCommand = new SqlCommand(strSelectCmd,DBAobj.Connection);
SqlDataReader mReader = mCommand.ExecuteReader();
if (mReader.Read())
{
strUpdateCmd="update Template_File 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.Connection);
}
else
{
strInsertCmd="insert into Template_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.Connection);
}
mReader.Close();
try
{
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;
nCommand.ExecuteNonQuery();
mResult=true;
}
catch(SqlException e)
{
mError=e.ToString();
mResult=false;
}
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.Connection);
SqlDataReader mReader = mCommand.ExecuteReader();
if (mReader.Read())
{
mFileBody=mReader.GetSqlBinary(0).Value;
mResult=true;
}
else
{
mResult=false;
}
mReader.Close();
return (mResult);
}
//保存文档，如果文档存在，则覆盖，不存在，则添加
private bool SaveFile()
{
bool mResult=false;
SqlCommand nCommand;
string strUpdateCmd;
string strInsertCmd;
string strSelectCmd= "SELECT * FROM Document_File WHERE RecordID='" + mRecordID + "'";
SqlCommand mCommand = new SqlCommand(strSelectCmd,DBAobj.Connection);
SqlDataReader mReader = mCommand.ExecuteReader();
if (mReader.Read())
{
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.Connection);
}
else
{
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.Connection);
}
mReader.Close();
try
{
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;
nCommand.ExecuteNonQuery();
mResult=true;
}
catch(SqlException e)
{
mError=e.ToString();
mResult=false;
}
return (mResult);
}
//
// 文档、模板管理代码 结束 *******************************
//
//
// 版本管理代码 开始 *******************************
//
//列出所有版本信息
private bool ListVersion()
{
bool mResult=false;
mFileID="\r\n";
mDateTime="保存时间\r\n";
mUserName="用户名\r\n";
mDescript="版本说明\r\n";
try
{
string strSelectCmd= "SELECT FileID,FileDate,UserName,Descript FROM Version_File WHERE RecordID='" + mRecordID + "'";
SqlCommand mCommand = new SqlCommand(strSelectCmd,DBAobj.Connection);
SqlDataReader mReader = mCommand.ExecuteReader();
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"; //如果说明信息里有回车，则将回车变成>符号
}
mReader.Close();
mResult=true;
}
catch(SqlException e)
{
mError=e.ToString();
mResult=false;
}
return (mResult);
}
//调入选中版本，通过文件号调用mFileID,并把文件放入mFileBody里，以便进行打包
private bool LoadVersion(string mFileID)
{
bool mResult=false;
try
{
string strSelectCmd="SELECT FileBody FROM Version_File WHERE RecordID='" + mRecordID + "' and FileID=" + mFileID;
SqlCommand mCommand = new SqlCommand(strSelectCmd,DBAobj.Connection);
SqlDataReader mReader = mCommand.ExecuteReader();
if (mReader.Read())
{
mFileBody=mReader.GetSqlBinary(0).Value;
mResult=true;
}
else
{
mResult=false;
}
mReader.Close();
}
catch(SqlException e)
{
mError=e.ToString();
mResult=false;
}
return (mResult);
}
//保存版本，将该版本文件存盘，并将说明信息也保存起来
private bool SaveVersion()
{
bool mResult=false;
SqlCommand nCommand;
string strInsertCmd;
strInsertCmd="insert into Version_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.Connection);
try
{
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;
nCommand.ExecuteNonQuery();
mResult=true;
}
catch(SqlException e)
{
mError=e.ToString();
mResult=false;
}
return (mResult);
}
//
// 版本管理代码 结束 *******************************
//
//
// 标签管理代码 开始 *******************************
//
//创建标签列表
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -