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,BookName,ReaderId,ReaderName,BorrowTime,ReturnTime,FactReturnTime,Fine,RenewCount,BorrowRemark";   //自动生成columns   autocoumns.AutoColumn(Header1, PropertyNames1, dgvHostory);   #endregion  }