private void GetData(string selectCommand)
{
try
{
DataTable table = new DataTable();
table.Locale = System.Globalization.CultureInfo.InvariantCulture;
if (UIPublicClass.PublicClass.IsSingleClent)
{
oledbconn.Open();
oledbdataAdapter = new OleDbDataAdapter(selectCommand, oledbconn);
OleDbCommandBuilder commandBuilder = new OleDbCommandBuilder(oledbdataAdapter);
oledbdataAdapter.Fill(table);
oledbconn.Close();
}
else
{
sqlconn.Open();
sqldataAdapter = new SqlDataAdapter(selectCommand, sqlconn);
SqlCommandBuilder commandBuilder = new SqlCommandBuilder(sqldataAdapter);
sqldataAdapter.Fill(table);
sqlconn.Close();
}
bindingSource1.DataSource = table;
dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
setColumns(dataGridView1, TabelName);
lbldgvRowCount.Text = table.Rows.Count.ToString();
}
catch (SqlException)
{
MessageBox.Show("error");
}
}
//绑定datagridview中的数据
private void GetData(string selectCommand)
{
try
{
dataAdapter = new SqlDataAdapter(selectCommand, conn);
SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);
DataTable table = new DataTable();
table.Locale = System.Globalization.CultureInfo.InvariantCulture;
dataAdapter.Fill(table);
bindingSource1.DataSource = table;
dgvDetails.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
}
private void wsYjLoad()
{
#region dgv初始化
ds = bz_yj.getData(DocID);
dgvRows = ds.Tables[0].Rows.Count + 1;
dgvYj.DataSource = ds.Tables[0];
table = ds.Tables[0];
lbldgvNum.Text = Convert.ToString(dgvYj.Rows.Count - 1);
//设置 DataGridView
dgvYj.AllowUserToDeleteRows = false;
dgvYj.RowHeadersWidth = 25;
dgvYj.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.DisplayedCells);
dgvYj.Columns["原件ID"].Visible = false;
dgvYj.Columns["文件ID"].Visible = false;
dgvYj.Columns["Ftp目录"].Visible = false;
dgvYj.Columns["Ftp保存名称"].Visible = false;
DataGridViewLinkColumn linkcol = dgvCommon.GetLinkColumn("", "载入", "载入");
dgvYj.Columns.Insert(5, linkcol);
linkcol = dgvCommon.GetLinkColumn("", "查看", "查看");
dgvYj.Columns.Insert(6, linkcol);
linkcol = dgvCommon.GetLinkColumn("", "下载", "下载");
dgvYj.Columns.Insert(7, linkcol);
linkcol = dgvCommon.GetLinkColumn("", "删除", "删除");
dgvYj.Columns.Insert(8, linkcol);
dgvYj.Columns["序号"].Width = 50;
dgvYj.Columns["描述"].Width = 400;
dgvYj.Columns["扩展名"].Width = 80;
DataGridViewTextBoxColumn DgvColumn;
DgvColumn = (DataGridViewTextBoxColumn)dgvYj.Columns["序号"];
DgvColumn.MaxInputLength = 6;
dgvYj.Columns["序号"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
#endregion
}
//初始化方法
private void wsYjLoad()
{
ds = gd_yj.getData(DocID);
dgvRows = ds.Tables[0].Rows.Count + 1;
dgvYj.DataSource = ds.Tables[0];
table = ds.Tables[0];
lblCount.Text = Convert.ToString(dgvYj.Rows.Count - 1);
//设置 DataGridView
dgvYj.AllowUserToDeleteRows = false;
dgvYj.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.DisplayedCells);
dgvYj.Columns["原件ID"].Visible = false;
dgvYj.Columns["文件ID"].Visible = false;
dgvYj.Columns["Ftp目录"].Visible = false;
dgvYj.Columns["Ftp保存名称"].Visible = false;
DataGridViewLinkColumn linkcol = dgvCommon.GetLinkColumn("", "载入", "载入");
dgvYj.Columns.Insert(5, linkcol);
linkcol = dgvCommon.GetLinkColumn("", "查看", "查看");
dgvYj.Columns.Insert(6, linkcol);
linkcol = dgvCommon.GetLinkColumn("", "下载", "下载");
dgvYj.Columns.Insert(7, linkcol);
linkcol = dgvCommon.GetLinkColumn("", "删除", "删除");
dgvYj.Columns.Insert(8, linkcol);
dgvYj.Columns["序号"].Width = 50;
dgvYj.Columns["描述"].Width = 400;
dgvYj.Columns["扩展名"].Width = 100;
DataGridViewTextBoxColumn DgvColumn;
DgvColumn = (DataGridViewTextBoxColumn)dgvYj.Columns["序号"];
DgvColumn.MaxInputLength = 6;
}
private void cjYjLoad()
{
ds = OldCJ_yj.getData(DocID);
dgvRows = ds.Tables[0].Rows.Count + 1;
dgvYj.DataSource = ds.Tables[0];
table = ds.Tables[0];
lbldgvNum.Text = Convert.ToString(dgvYj.Rows.Count - 1);
//设置 DataGridView
dgvYj.AllowUserToDeleteRows = false;
dgvYj.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.DisplayedCells);
dgvYj.Columns["原件ID"].Visible = false;
dgvYj.Columns["城建旧大纲文件ID"].Visible = false;
dgvYj.Columns["路径"].Visible = false;
dgvYj.Columns["保存名称"].Visible = false;
#region 绑定列
DataGridViewLinkColumn addcol = new DataGridViewLinkColumn();
addcol.HeaderText = "载入";
addcol.Name = "载入";
addcol.LinkColor = Color.SteelBlue;
addcol.ActiveLinkColor = Color.SteelBlue;
addcol.VisitedLinkColor = Color.SteelBlue;
addcol.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
addcol.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
addcol.ReadOnly = true;
addcol.Width = 60;
//dgvProject.Columns.Insert(29, linkcol);
dgvYj.Columns.Insert(5, addcol);
DataGridViewLinkColumn linkcol = new DataGridViewLinkColumn();
linkcol.HeaderText = "查看";
linkcol.Name = "查看";
linkcol.LinkColor = Color.SteelBlue;
linkcol.ActiveLinkColor = Color.SteelBlue;
linkcol.VisitedLinkColor = Color.SteelBlue;
linkcol.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
linkcol.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
linkcol.ReadOnly = true;
linkcol.Width = 60;
//dgvProject.Columns.Insert(29, linkcol);
dgvYj.Columns.Insert(6, linkcol);
linkcol = new DataGridViewLinkColumn();
linkcol.HeaderText = "下载";
linkcol.Name = "下载";
linkcol.LinkColor = Color.SteelBlue;
linkcol.ActiveLinkColor = Color.SteelBlue;
linkcol.VisitedLinkColor = Color.SteelBlue;
linkcol.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
linkcol.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
linkcol.ReadOnly = true;
linkcol.Width = 60;
//dgvProject.Columns.Insert(29, linkcol);
dgvYj.Columns.Insert(7, linkcol);
linkcol = new DataGridViewLinkColumn();
linkcol.HeaderText = "删除";
linkcol.Name = "删除";
linkcol.LinkColor = Color.SteelBlue;
linkcol.ActiveLinkColor = Color.SteelBlue;
linkcol.VisitedLinkColor = Color.SteelBlue;
linkcol.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
linkcol.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
linkcol.ReadOnly = true;
linkcol.Width = 60;
//dgvProject.Columns.Insert(29, linkcol);
dgvYj.Columns.Insert(8, linkcol);
#endregion
dgvYj.Columns["序号"].Width = 50;
dgvYj.Columns["描述"].Width = 400;
dgvYj.Columns["扩展名"].Width = 80;
DataGridViewTextBoxColumn DgvColumn;
DgvColumn = (DataGridViewTextBoxColumn)dgvYj.Columns["序号"];
DgvColumn.MaxInputLength = 6;
}
//页面初始化方法
private void contentLoad()
{
#region DataGridView导航...
dgvCommon.getNavigationYesNewRows(dgvClass, btn首记录dgv, btn上一记录dgv, btn下一记录dgv, btn尾记录dgv, btn新纪录dgv,
UI.Input.GD_Input.tsmi首记录, UI.Input.GD_Input.tsmi上一记录, UI.Input.GD_Input.tsmi下一记录, UI.Input.GD_Input.tsmi尾记录, UI.Input.GD_Input.tsmi新纪录, txt行号dgv);
#endregion
dgvClass.ScrollBars = ScrollBars.Vertical;
dgvClass.HScrollBarEx = this.hScrollBar1;
dgvClass.Dock = DockStyle.Fill;
pnlDGV.Controls.Add(dgvClass);
Padding padding = new Padding();
padding.Bottom = 39;
this.pnlDGV.Padding = padding;
#region DataGridView 事件
this.dgvClass.CellBeginEdit += new System.Windows.Forms.DataGridViewCellCancelEventHandler(this.dgvClass_CellBeginEdit);
this.dgvClass.RowValidating += new System.Windows.Forms.DataGridViewCellCancelEventHandler(this.dgvClass_RowValidating);
this.dgvClass.CellEndEdit += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvClass_CellEndEdit);
this.dgvClass.DefaultValuesNeeded += new System.Windows.Forms.DataGridViewRowEventHandler(this.dgvClass_DefaultValuesNeeded);
this.dgvClass.CurrentCellChanged += new System.EventHandler(this.dgvClass_CurrentCellChanged);
this.dgvClass.CellFormatting += new DataGridViewCellFormattingEventHandler(dgvClass_CellFormatting);
this.dgvClass.SelectionChanged += new EventHandler(dgvClass_SelectionChanged);
#endregion
//绑定数据
string limit = yNode.Parent.Text;
string year = yNode.Text;
ds = Gd_class.getClassList(TopClassID, limit, year);
dgvRows = ds.Tables[0].Rows.Count + 1;
dgvClass.DataSource = ds.Tables[0];
table = ds.Tables[0];
//初始化设置记录数和导航按钮
RowCount = dgvClass.Rows.Count - 1;
lbldgvRowCount.Text = Convert.ToString(RowCount);
//设置不能删除行
dgvClass.AllowUserToDeleteRows = false;
dgvClass.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.DisplayedCells);
//设置 DataGridView 样式
dgvClass.Columns["类目ID"].Visible = false;
dgvClass.Columns["一级类目ID"].Visible = false;
dgvClass.Columns["类目"].Visible = false;
dgvClass.Columns["整理人"].Visible = false;
dgvClass.Columns["检查人"].Visible = false;
dgvClass.Columns["归档时间"].Visible = false;
dgvClass.Columns["科室代号"].Visible = false;
//绑定 DataGridVeiw 下拉列表
BoundCmbLimit();
//设置列宽
dgvClass.Columns["类目"].Width = 120;
dgvClass.Columns["整理人"].Width = 100;
dgvClass.Columns["检查人"].Width = 100;
dgvClass.Columns["归档时间"].Width = 80;
dgvClass.Columns["科室代号"].Width = 100;
dgvClass.Columns["类目"].HeaderText = "类目﹡";
}
