frmonlyfile.cs

个人信息的源代码

		}
		/// <summary>
		/// 将文件存入表中
		/// </summary>
		private void SaveFile()
		{
			string fileName = this.txtFile.Text.Trim();
			//必须写有文件名
			if(fileName == string.Empty)
			{
				MessageBox.Show("请选择一个文件！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
				return;
			}
			//创建文件对象
			this.FileObj = new Attachment();
			this.FileObj.FileID = this.FileSaver.GetNextID();
			this.FileObj.FileName = fileName;
			try
			{
				FileInfo file = new FileInfo(fileName);
				this.FileObj.FileSize = file.Length;
			}
			catch
			{
				MessageBox.Show("非法的文件名：" + fileName, "出错信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
				return;
			}
			
			this._OnlyFile.AttachFile = this.FileObj;
			this._OnlyFile.Text = this.txtFileDetail.Text;

			try
			{
				this.Cursor = Cursors.WaitCursor;
				//保存对象到数据库中
				this.FileSaver.SaveObjAndFileToDB(this.FileObj);
				this.OnlyFileSaver.UpdateDBRow(this._OnlyFile);
			}
			catch(Exception ex)
			{
				MessageBox.Show(ex.Message, "出错信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
			}
			finally
			{
				this.Cursor = Cursors.Default;
			}

			//不允许再次保存
			this.btnSaveFile.Enabled = false;
			//不允许再选文件
			this.btnOpen.Enabled = false;

			//可以删除
			this.btnDeleteFile.Enabled = true;
			this.btnExportFile.Enabled = true;
		}
		/// <summary>
		/// 删除文件
		/// </summary>
		private void DeleteFile()
		{
			if(this._OnlyFile == null || this._OnlyFile.AttachFile == null)
				return;

			try
			{
				this.FileSaver.DeleteObj(this._OnlyFile.AttachFile);
			}
			catch(Exception ex)
			{
				MessageBox.Show(ex.Message, "出错信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
			}

			this._OnlyFile.AttachFile = null;
			this.FileObj = null;
			//更新数据库信息
			this.OnlyFileSaver.UpdateDBRow(this._OnlyFile);

			this.txtFile.Text = "";
			this.btnSaveFile.Enabled = false;
			this.btnOpen.Enabled = true;
			this.btnDeleteFile.Enabled = false;
			this.btnExportFile.Enabled = false;
		}
		/// <summary>
		/// 导出文件
		/// </summary>
		private void ExportFile()
		{
			if(this._OnlyFile.AttachFile == null)
				return;

			string saveFileName = "";
			int fileID = 0;
			this.saveFileDialog1.FileName = Path.GetFileName(this._OnlyFile.AttachFile.FileName);
			if(this.saveFileDialog1.ShowDialog() == DialogResult.OK)
			{
				saveFileName = this.saveFileDialog1.FileName;
				fileID = this._OnlyFile.AttachFile.FileID;
				if(fileID == 0)
					return;
				try
				{
					this.Cursor = Cursors.WaitCursor;

					this.OnlyFileSaver.SaveAttachFileToDB(this._OnlyFile.AttachFile, saveFileName);
					MessageBox.Show("文件已经成功导出到：" + saveFileName, "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
				}
				catch(Exception ex)
				{
					MessageBox.Show(ex.Message, "出错信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
				}
				finally
				{
					this.Cursor = Cursors.Default;
				}
			}
		}

		#endregion 

		/// <summary>
		/// 设置粗体
		/// </summary>
		private void SetBold()
		{
			Font _font = this.txtFileDetail.SelectionFont;

			if(_font == null)
				return;

			if(_font.Bold == false)
			{
				_font = new Font(_font, _font.Style | FontStyle.Bold);
			}
			else
			{//除去粗体选项
				_font = new Font(_font, _font.Style - 1);
			}
			this.txtFileDetail.SelectionFont = _font;
		}
		/// <summary>
		/// 设置斜体
		/// </summary>
		private void SetItalic()
		{
			Font _font = this.txtFileDetail.SelectionFont;

			if(_font == null)
				return;

			if(_font.Italic == false)
			{
				_font = new Font(_font, _font.Style | FontStyle.Italic);
			}
			else
			{//除去粗体选项
				_font = new Font(_font, _font.Style - 2);
			}
			this.txtFileDetail.SelectionFont = _font;
		}
		/// <summary>
		/// 设置字体尺寸
		/// </summary>
		/// <param name="IsUp"></param>
		private void SetFontSize(bool IsUp)
		{
			if(this.txtFileDetail.SelectionFont == null)
				return;

			float size = this.txtFileDetail.SelectionFont.Size;

			if(IsUp)
			{
				size ++;
			}
			else if(size > 1)
			{
				size --;
			}
			Font _font = new Font(this.txtFileDetail.SelectionFont.Name, size, this.txtFileDetail.SelectionFont.Style, GraphicsUnit.Point);
			this.txtFileDetail.SelectionFont = _font;
		}

		private void btnOpen_Click(object sender, System.EventArgs e)
		{
			this.OpenFileName();
		}

		private void btnSaveFile_Click(object sender, System.EventArgs e)
		{
			this.SaveFile();
		}

		private void btnDeleteFile_Click(object sender, System.EventArgs e)
		{
			this.DeleteFile();
		}

		private void btnExportFile_Click(object sender, System.EventArgs e)
		{
			this.ExportFile();
		}

		private void txtFileDetail_Leave(object sender, System.EventArgs e)
		{
			this.UpdateDB();
		}

		private void txtFileDetail_TextChanged(object sender, System.EventArgs e)
		{
			this.UpdateObj();
		}

		private void lnkSetBold_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
		{
			this.SetBold();
			this.UpdateObj();
		}

		private void lnkItalic_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
		{
			this.SetItalic();
			this.UpdateObj();
		}

		private void lnkFontSizeUp_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
		{
			this.SetFontSize(true);
			this.UpdateObj();
		}

		private void lnkFontSizeDown_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
		{
			this.SetFontSize(false);
			this.UpdateObj();
		}

		private void lnkSelectFont_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
		{
			this.txtFileDetail.SetSelectionFontFromFontDialog();
			this.UpdateObj();
		}

		private void lnkCut_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
		{
			this.txtFileDetail.Cut();
			this.txtFileDetail.Focus();
		}

		private void lnkCopy_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
		{
			this.txtFileDetail.Copy();
			this.txtFileDetail.Focus();
		}

		private void lnkPaste_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
		{
			this.txtFileDetail.Paste();
			this.txtFileDetail.Focus();
		}

		private void lnkSelectAll_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
		{
			this.txtFileDetail.SelectAll();
		}

		private void lnkFind_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
		{
			this.txtFileDetail.FindAndReplace();
		}

		private void lnkClearFormat_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
		{
			this.txtFileDetail.ClearFormat();
		}

		private void lnkMoveToBegin_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
		{
			this.txtFileDetail.MoveToBegin();
			this.txtFileDetail.Focus();
		}

		private void lnkMoveToEnd_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
		{
			this.txtFileDetail.MoveToEnd();
			this.txtFileDetail.Focus();
		}

		private void lnkZoomIn_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
		{
			this.txtFileDetail.ZoomIn();
		}

		private void lnkPrint_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
		{
			this.txtFileDetail.Print();
		}

		private void lnkSave_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
		{
			this.UpdateDB();
			MessageBox.Show("数据已经被保存！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
			this.txtFileDetail.Focus();
		}
	}
}