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();
 //設(shè)置列標(biāo)題單元格的名稱
 c.Text = name;
 //單元格的背景色
 c.DefaultCellStyle.BackColor = Color.LightGray;
 //單元格選定時(shí)的背景色
 c.DefaultCellStyle.SelectionBackColor = Color.DarkGray;

 //單元格的默認(rèn)文本
 c.UseColumnTextForButtonValue = true;
 //單元格寬
 c.Width = 60;
 //添加新的一列對(duì)象
 //選中時(shí)背景色為灰色
 c.DefaultCellStyle.SelectionBackColor = Color.LightGray;
 c.DefaultCellStyle.SelectionForeColor = Color.Black;
 c.FillWeight = 50;
 GridView.Columns.Add(c);
 }
 /// <summary>
 /// 自動(dòng)生成columns 沒有修改和刪除
 /// </summary>
 /// <param name="HeaderText"></param>
 /// <param name="DataPropertyNames"></param>
 /// <param name="GrdiView"></param>
 public void AutoColumn(string HeaderText, string DataPropertyNames, DataGridView GrdiView)
 {
 //去掉自動(dòng)生成的列
 GrdiView.AutoGenerateColumns = false;
 GrdiView.RowHeadersDefaultCellStyle.SelectionBackColor = Color.DarkGray;
 //生成行標(biāo)題標(biāo)號(hào)的方法
 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;
 //不可以手動(dòng)對(duì)列重新定位
 GrdiView.AllowUserToOrderColumns = false;
 //不可以調(diào)整列的大小
 GrdiView.AllowUserToResizeColumns = false;
 //不可以調(diào)整行的大小
 GrdiView.AllowUserToResizeRows = false;
 //行標(biāo)題行的寬度
 GrdiView.RowHeadersWidth = 32;
 //不能多選
 GrdiView.MultiSelect = false;
 //獲取標(biāo)題樣式
 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();
 //綁定數(shù)據(jù)庫列名稱
 d.DataPropertyName = arrayDataPropertyNames[i];
 //設(shè)置列標(biāo)題的名稱
 d.HeaderText = arrayHeaderText[i];
 //單元格選定時(shí)的背景色
 d.DefaultCellStyle.SelectionBackColor = Color.Gainsboro;
 d.DefaultCellStyle.SelectionForeColor = Color.Black;
 //單元格的內(nèi)容居中
 d.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
 GrdiView.Columns.Add(d);
 }
 GrdiView.DataSource = null;
 }
 /// <summary>
 /// 找到剛剛添加成功的數(shù)據(jù)行s
 /// </summary>
 /// <param name="A"></param>
 /// <param name="GridView"></param>
 public void AutoFindRow(string A, DataGridView GridView) 
 {
 //獲取DataGridView中的總行數(shù)
 int rows = GridView.RowCount;

 //找到剛剛添加成功的數(shù)據(jù)行
 for (int i = 0; i < rows; i++)
 {
 string a = GridView.Rows[i].Cells[0].Value.ToString();
 if (a == A)
 {
 //選中整行
 GridView.Rows[i].Selected = true;
 //垂直滾動(dòng)條，滾動(dòng)到當(dāng)前行索引位置
 GridView.FirstDisplayedScrollingRowIndex = i;
 }
 else
 {
 //清楚整行選中
 GridView.Rows[i].Selected = false;
 }
 }
 }

 /// <summary>
 /// 找到剛剛添加成功的數(shù)據(jù)行
 /// </summary>
 /// <param name="A"></param>
 /// <param name="GridView"></param>
 public void AutoFindRow(int A, DataGridView GridView)
 {
 //獲取DataGridView中的總行數(shù)
 int rows = GridView.RowCount;

 //找到剛剛添加成功的數(shù)據(jù)行
 for (int i = 0; i < rows; i++)
 {
 int a = (int)GridView.Rows[i].Cells[0].Value;
 if (a == A)
 {
 //選中整行
 GridView.Rows[i].Selected = true;
 //垂直滾動(dòng)條，滾動(dòng)到當(dāng)前行索引位置
 GridView.FirstDisplayedScrollingRowIndex = i;
 }
 else
 {
 //清楚整行選中
 GridView.Rows[i].Selected = false;
 }
 }
 }
 }
} 

private void BookInfoManager_UI_Load(object sender, EventArgs e)
 {
 #region DataGridView1綁定
 //需要添加列的列標(biāo)題字符串
 string arraysHeaderText = @"圖書編號(hào),圖書名稱,登記時(shí)間,圖書類型,作者,拼音碼,翻譯,語言,頁數(shù),價(jià)格,印刷版面,存放位置,ISBS碼,版本,描述";
 //需要綁定數(shù)據(jù)庫列名稱的字符串
 string arraysName = @"BookId,BookName,TimeIn,BookTypeName,Author,PinYinCode,Translator,Language,BookNumber,Price,Layout,Address,ISBS,Versions,BookRemark";


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

 //DataGridView1數(shù)據(jù)集綁定
 this.dataGridView1.DataSource = bookInfo_bll.selectBookInfo1().Tables[0];
 //窗體加載時(shí)默認(rèn)隱藏的列
 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 = @"圖書編號(hào),圖書名稱,讀者編號(hào),讀者名稱,借出時(shí)間,書應(yīng)歸還時(shí)間,實(shí)際歸還時(shí)間,應(yīng)付罰金,續(xù)借次數(shù),借還描述";
 string PropertyNames1 = @"BookId,BookName,ReaderId,ReaderName,BorrowTime,ReturnTime,FactReturnTime,Fine,RenewCount,BorrowRemark";
 //自動(dòng)生成columns
 autocoumns.AutoColumn(Header1, PropertyNames1, dgvHostory);

 #endregion
 }