实例介绍
【实例简介】c/s程序，附加数据库即可使用
1、首先保证计算机上已经成功安装SQL Server 2005。
2、将数据库文件附加到数据库中。
3、如果当前计算机装有多个SQL Server 2005实例,请在BookManageSystem目录下打开app.config程序文件，将程序数据库连接字符串localhost改为localhost\你的数据库实例名。如果仅有一个实例，就不用修改了。
4、编译运行即可。
【实例截图】
【核心代码】
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Windows.Forms;
namespace Jackone
{
public partial class FrmMain : Form
{
public FrmMain(string loginname)
{
InitializeComponent();
dgv_bookinfo.AutoGenerateColumns = false;
dgv_bookinfo.RowsDefaultCellStyle.BackColor = Color.Bisque;
dgv_bookinfo.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
this.lbladmin.Text = loginname;
lbltime.Text = "时间：" System.DateTime.Now.ToString();
}
private void timer1_Tick(object sender, EventArgs e)
{
lbltime.Text = "时间：" System.DateTime.Now.ToString();
}
private void FrmMain_Load(object sender, EventArgs e)
{
LoadLeftView();
}
private void LoadLeftView()
{
tv_BookType.Nodes.Clear();
List<BookTypeInfo> list = new List<BookTypeInfo>();
try
{
list = BookTypeService.SelectBookTypeInfo();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
//创建根节点
TreeNode root = new TreeNode("所有分类");
//绑定到父容器
tv_BookType.Nodes.Add(root);
foreach (BookTypeInfo b in list)
{
TreeNode node = new TreeNode(b.BookTypeName);
node.Tag = b;
root.Nodes.Add(node);
}
if (tv_BookType.SelectedNode == null)
tv_BookType.SelectedNode = root;
tv_BookType.ImageList = imageListLeft;
tv_BookType.ExpandAll();
}
private void FrmMain_FormClosing(object sender, FormClosingEventArgs e)
{
DialogResult dr = MessageBox.Show("是否退出", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (dr == DialogResult.OK)
{
Environment.Exit(0);
}
else
{
e.Cancel = true;
}
}
#region TreeView
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tv_BookType_AfterSelect(object sender, TreeViewEventArgs e)
{
tv_BookType.SelectedImageIndex = 1;
LoadBoolByType(tv_BookType.SelectedNode);
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tv_BookType_AfterCollapse(object sender, TreeViewEventArgs e)
{
e.Node.SelectedImageIndex = 0;
e.Node.ImageIndex = 0;
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tv_BookType_AfterExpand(object sender, TreeViewEventArgs e)
{
e.Node.SelectedImageIndex = 1;
e.Node.ImageIndex = 1;
}
#endregion
/// <summary>
///
/// </summary>
/// <param name="_node"></param>
private void LoadBoolByType(TreeNode _node)
{
DataTable list = null;
try
{
if (_node.Tag is BookTypeInfo)
{
list = BookInfoService.LoadBookByType((_node.Tag as BookTypeInfo).BookTypeID);
}
else
{
list = BookInfoService.LoadBookByType(-1);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
List<BookTypeInfo> typelist = BookTypeService.SelectBookTypeInfo();
comType.DataSource = typelist;
comType.DisplayMember = "BookTypeName";
comType.ValueMember = "BookTypeID";
dgv_bookinfo.DataSource = list;
if (list.Rows.Count > 0)
{
Loadimg(dgv_bookinfo.Rows[0]);
}
else
{
this.picimg.Image = null;
this.txt_remark.Text = "";
}
}
private void ts_AddBook_Click(object sender, EventArgs e)
{
Frm_Book _Addui = new Frm_Book(-1);
if (_Addui.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
LoadBoolByType(tv_BookType.SelectedNode);
}
}
private void tsm_AddUser_Click(object sender, EventArgs e)
{
FrmAddUser _FrmAddUser = new FrmAddUser();
_FrmAddUser.ShowDialog();
}
private void tsm_ModifyPwd_Click(object sender, EventArgs e)
{
FrmUpdPwd _FrmUpdPwd = new FrmUpdPwd(this.lbladmin.Text);
_FrmUpdPwd.ShowDialog();
}
private void tsm_DelUser_Click(object sender, EventArgs e)
{
FrmDelUser _FrmDelUser = new FrmDelUser();
_FrmDelUser.ShowDialog();
}
private void tsm_AddBookType_Click(object sender, EventArgs e)
{
FrmBookType _FrmBookType = new FrmBookType(-1);
_FrmBookType.ShowDialog();
}
private void tsm_UpdateBookType_Click(object sender, EventArgs e)
{
FrmBookType _FrmBookType = new FrmBookType(1);
_FrmBookType.ShowDialog();
}
private void tsm_DelBookType_Click(object sender, EventArgs e)
{
if (tv_BookType.SelectedNode.Tag is BookTypeInfo)
{
DialogResult result = MessageBox.Show("是否删除", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (result == DialogResult.Yes)
{
try
{
BookTypeInfo bi = tv_BookType.SelectedNode.Tag as BookTypeInfo;
BookTypeService.DeleteBookTypeInfo(bi.BookTypeID);
MessageBox.Show("删除成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadLeftView();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
else
{
MessageBox.Show("请选择要删除的图书类型", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void tsm_Detail_Click(object sender, EventArgs e)
{
FrmBookType _FrmBookType = new FrmBookType(0);
_FrmBookType.ShowDialog();
}
private void tsm_Exit_Click(object sender, EventArgs e)
{
this.Close();
}
private void left_refresh_Click(object sender, EventArgs e)
{
LoadLeftView();
}
private void LinkAuthor_Click(object sender, EventArgs e)
{
Author _Author = new Author();
_Author.ShowDialog();
}
private void dgv_bookinfo_RowEnter(object sender, DataGridViewCellEventArgs e)
{
if (dgv_bookinfo.CurrentRow == null) return;
int rowIndex = e.RowIndex;//获取当前行
Loadimg(dgv_bookinfo.Rows[rowIndex]);
}
private void Loadimg(DataGridViewRow _Var)
{
try
{
byte[] imgPho = _Var.Cells["ConverImage"].Value as byte[];
using (System.IO.MemoryStream ms = new System.IO.MemoryStream(imgPho))
{
this.picimg.Image = System.Drawing.Image.FromStream(ms);
}
}
catch
{
this.picimg.Image = null;
}
this.txt_remark.Text = _Var.Cells["Summary"].Value as string;
}
private void tsm_updatebook_Click(object sender, EventArgs e)
{
if (dgv_bookinfo.CurrentRow != null)
{
Frm_Book _FrmBook=new Frm_Book((int)dgv_bookinfo.CurrentRow.Cells["BookID"].Value);
_FrmBook.ShowDialog();
LoadBoolByType(tv_BookType.SelectedNode);
}
}
private void tsm_delBook_Click(object sender, EventArgs e)
{
if (dgv_bookinfo.CurrentRow != null)
{
BookInfoService.DeleteBookInfo((int)dgv_bookinfo.CurrentRow.Cells["BookID"].Value);
LoadBoolByType(tv_BookType.SelectedNode);
}
}
private void groupBox_Paint(object sender, PaintEventArgs e)
{
GroupBox _curBox = (GroupBox)sender;
Function.DrawGroupBox(e, _curBox);
}
}
}
好例子网口号：伸出你的我的手 — 分享！
相关软件
网友评论
小贴士
感谢您为本站写下的评论，您的评论对其它用户来说具有重要的参考价值，所以请认真填写。
- 类似“顶”、“沙发”之类没有营养的文字，对勤劳贡献的楼主来说是令人沮丧的反馈信息。
- 相信您也不想看到一排文字/表情墙，所以请不要反馈意义不大的重复字符，也请尽量不要纯表情的回复。
- 提问之前请再仔细看一遍楼主的说明，或许是您遗漏了。
- 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦，又没人会搭理，于人于己都无利。
关于好例子网
本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享，对搜索内容的合法性不具有预见性、识别性、控制性，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论平台是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定，若资源存在侵权或相关问题请联系本站客服人员，点此联系我们。关于更多版权及免责申明参见 版权及免责申明
支持(0) 盖楼(回复)
支持(0) 盖楼(回复)