C#图书管理系统 附源码下载

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Reflection;
using System.Drawing;

namespace Common
{
 public class Com
 {
 public void thread() {
 
 }
 /// <summary>
 /// DataGridView的样式
 /// </summary>
 /// <param name="GridView"></param>
 public void ExitGridView(DataGridView GridView)
 {
  GridView.AllowDrop = false;
  GridView.AllowUserToAddRows = false;
  GridView.AllowUserToDeleteRows = false;
  GridView.AllowUserToOrderColumns = false;
  GridView.AllowUserToResizeColumns = false;
 }
 /// <summary>
 /// 生成一列有功能的按钮
 /// </summary>
 /// <param name="name"></param>
 /// <param name="GridView"></param>
 public void AddColumn(string name,DataGridView GridView)
 {
  //添加修改按钮
  DataGridViewButtonColumn c = new DataGridViewButtonColumn();
  //设置列标题单元格的名称
  c.Text = name;
  //单元格的背景色
  c.DefaultCellStyle.BackColor = Color.LightGray;
  //单元格选定时的背景色
  c.DefaultCellStyle.SelectionBackColor = Color.DarkGray;

  //单元格的默认文本
  c.UseColumnTextForButtonValue = true;
  //单元格宽
  c.Width = 60;
  //添加新的一列对象
  //选中时背景色为灰色
  c.DefaultCellStyle.SelectionBackColor = Color.LightGray;
  c.DefaultCellStyle.SelectionForeColor = Color.Black;
  c.FillWeight = 50;
  GridView.Columns.Add(c);
 }
 /// <summary>
 /// 自动生成columns 没有修改和删除
 /// </summary>
 /// <param name="HeaderText"></param>
 /// <param name="DataPropertyNames"></param>
 /// <param name="GrdiView"></param>
 public void AutoColumn(string HeaderText,string DataPropertyNames,DataGridView GrdiView)
 {
  //去掉自动生成的列
  GrdiView.AutoGenerateColumns = false;
  GrdiView.RowHeadersDefaultCellStyle.SelectionBackColor = Color.DarkGray;
  //生成行标题标号的方法
  GrdiView.DataSource = System.Drawing.Imaging.ImageCodecInfo.GetImageDecoders();
  // 禁止用户改变DataGridView1的所有列的列宽
  GrdiView.AllowUserToResizeColumns = false;
  //禁止用户改变DataGridView1の所有行的行高 
  GrdiView.AllowUserToResizeRows = false;
  //选择整行
  GrdiView.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
  GrdiView.AllowDrop = false;
  //不可以添加行
  GrdiView.AllowUserToAddRows = false;
  //不可以删除行
  GrdiView.AllowUserToDeleteRows = false;
  //不可以手动对列重新定位
  GrdiView.AllowUserToOrderColumns = false;
  //不可以调整列的大小
  GrdiView.AllowUserToResizeColumns = false;
  //不可以调整行的大小
  GrdiView.AllowUserToResizeRows = false;
  //行标题行的宽度
  GrdiView.RowHeadersWidth = 32;
  //不能多选
  GrdiView.MultiSelect = false;
  //获取标题样式
  GrdiView.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
  string[] arrayHeaderText = HeaderText.Split(',');
  string[] arrayDataPropertyNames = DataPropertyNames.Split(',');
  for (int i = 0; i < arrayHeaderText.Length; i++)
  {
  DataGridViewTextBoxColumn d = new DataGridViewTextBoxColumn();
  //绑定数据库列名称
  d.DataPropertyName = arrayDataPropertyNames[i];
  //设置列标题的名称
  d.HeaderText = arrayHeaderText[i];
  //单元格选定时的背景色
  d.DefaultCellStyle.SelectionBackColor = Color.Gainsboro;
  d.DefaultCellStyle.SelectionForeColor = Color.Black;
  //单元格的内容居中
  d.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
  GrdiView.Columns.Add(d);
  }
  GrdiView.DataSource = null;
 }
 /// <summary>
 /// 找到刚刚添加成功的数据行s
 /// </summary>
 /// <param name="A"></param>
 /// <param name="GridView"></param>
 public void AutoFindRow(string A,DataGridView GridView) 
 {
  //获取DataGridView中的总行数
  int rows = GridView.RowCount;

  //找到刚刚添加成功的数据行
  for (int i = 0; i < rows; i++)
  {
  string a = GridView.Rows[i].Cells[0].Value.ToString();
  if (a == A)
  {
   //选中整行
   GridView.Rows[i].Selected = true;
   //垂直滚动条，滚动到当前行索引位置
   GridView.FirstDisplayedScrollingRowIndex = i;
  }
  else
  {
   //清楚整行选中
   GridView.Rows[i].Selected = false;
  }
  }
 }

 /// <summary>
 /// 找到刚刚添加成功的数据行
 /// </summary>
 /// <param name="A"></param>
 /// <param name="GridView"></param>
 public void AutoFindRow(int A,DataGridView GridView)
 {
  //获取DataGridView中的总行数
  int rows = GridView.RowCount;

  //找到刚刚添加成功的数据行
  for (int i = 0; i < rows; i++)
  {
  int a = (int)GridView.Rows[i].Cells[0].Value;
  if (a == A)
  {
   //选中整行
   GridView.Rows[i].Selected = true;
   //垂直滚动条，滚动到当前行索引位置
   GridView.FirstDisplayedScrollingRowIndex = i;
  }
  else
  {
   //清楚整行选中
   GridView.Rows[i].Selected = false;
  }
  }
 }
 }
} 

private void BookInfoManager_UI_Load(object sender,EventArgs e)
 {
  #region DataGridView1绑定
  //需要添加列的列标题字符串
  string arraysHeaderText = @"图书编号,图书名称,登记时间,图书类型,作者,拼音码,翻译,语言,页数,价格,印刷版面,存放位置,ISBS码,版本,描述";
  //需要绑定数据库列名称的字符串
  string arraysName = @"BookId,BookName,TimeIn,BookTypeName,Author,PinYinCode,Translator,Language,BookNumber,Price,Layout,Address,ISBS,Versions,BookRemark";


  //自动生成columns
  autocoumns.AutoColumn(arraysHeaderText,arraysName,dataGridView1);
  dataGridView1.DataSource = bookInfo_bll.selectBookInfo1().Tables[0];
  autocoumns.AddColumn("修改",dataGridView1);
  autocoumns.AddColumn("删除",dataGridView1);

  //DataGridView1数据集绑定
  this.dataGridView1.DataSource = bookInfo_bll.selectBookInfo1().Tables[0];
  //窗体加载时默认隐藏的列
  this.dataGridView1.Columns[14].Visible = false;
  this.dataGridView1.Columns[13].Visible = false;
  this.dataGridView1.Columns[12].Visible = false;
  this.dataGridView1.Columns[11].Visible = false;
  this.dataGridView1.Columns[10].Visible = false;
  #endregion

  #region 下拉框绑定

  DataGridViewColumnCollection columns = dataGridView1.Columns;

  for (int i = 0; i < columns.Count - 2; i++)
  {
  comboBox1.Items.Add(columns[i].HeaderText);
  }
  comboBox1.Items.Insert(0,"全部");
  comboBox1.SelectedIndex = 0;

  #endregion

  #region 树状图的绑定

  TreeViewBand();

  #endregion

  #region DgvHostory绑定

  string Header1 = @"图书编号,读者编号,读者名称,借出时间,书应归还时间,实际归还时间,应付罚金,续借次数,借还描述";
  string PropertyNames1 = @"BookId,ReaderId,ReaderName,BorrowTime,ReturnTime,FactReturnTime,Fine,RenewCount,BorrowRemark";
  //自动生成columns
  autocoumns.AutoColumn(Header1,PropertyNames1,dgvHostory);

  #endregion
 }