private void BoundCmbLimit() { //分类号 object[] fields = bz_file.getFLH(); cmb_Temp = dgvCommon.GetComboBoxColumn("分类号", "分类号", "分类号", fields); dgvFile.Columns.Insert(4, cmb_Temp); //绑定 页面的分类号下拉类表 cmbTypeNum.Items.Clear(); cmbTypeNum.Items.AddRange(fields); //类目名称 fields = bz_file.getLMMC(); cmb_Temp = dgvCommon.GetComboBoxColumn("类目名称", "类目名称", "类目名称", fields); dgvFile.Columns.Insert(5, cmb_Temp); //绑定 页面的类目名称下拉列表 cmbTypeName.Items.Clear(); cmbTypeName.Items.AddRange(fields); //归档时间 maskedColumn = dgvCommon.GetMaskedColumn("归档时间", "归档时间", "归档时间", "0000-00-00"); dgvFile.Columns.Insert(6, maskedColumn); //年度 maskedColumn = dgvCommon.GetMaskedColumn("年度", "年度", "年度", "0000"); dgvFile.Columns.Insert(7, maskedColumn); //密级 fields = bz_file.getMJ(); cmb_Temp = dgvCommon.GetComboBoxColumn("密级", "密级", "密级", fields); dgvFile.Columns.Insert(9, cmb_Temp); //绑定 页面的密级下拉列表 cmbDept.Items.Clear(); cmbDept.Items.AddRange(fields); //立卷人 fields = bz_file.getZLR(); cmb_Temp = dgvCommon.GetComboBoxColumn("立卷人", "立卷人", "立卷人", fields); dgvFile.Columns.Insert(10, cmb_Temp); //绑定 页面的立卷人下拉列表 cmbAuthor.Items.Clear(); cmbAuthor.Items.AddRange(fields); //检查人 fields = bz_file.getJCR(); cmb_Temp = dgvCommon.GetComboBoxColumn("检查人", "检查人", "检查人", fields); dgvFile.Columns.Insert(11, cmb_Temp); //绑定 页面的检查人下拉列表 cmbChecker.Items.Clear(); cmbChecker.Items.AddRange(fields); //柜架号 maskedColumn = dgvCommon.GetMaskedColumn("柜架号", "柜架号", "柜架号", UIPublicClass.PublicClass.AddressMask); dgvFile.Columns.Insert(12, maskedColumn); }
//绑定下拉列表,DataGridView 和 cmbLimite 的 private void BoundCmbLimit() { cmb_Temp = new DataGridViewEditComboBoxColumn(); cmb_Temp.DataPropertyName = "保管期限"; cmb_Temp.HeaderText = "保管期限"; cmb_Temp.Name = "保管期限"; ds = ws_content.getLimit(deptID); string[] strField = new string[ds.Tables[0].Rows.Count]; if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { strField[i] = ds.Tables[0].Rows[i]["保管期限"].ToString(); } cmb_Temp.Items = strField; } dgvContent.Columns.Insert(3, cmb_Temp); //绑定 页面的 下拉列表 cmbLimit.Items.Clear(); cmbLimit.Items.AddRange(strField); cmb_Temp = new DataGridViewEditComboBoxColumn(); cmb_Temp.DataPropertyName = "科室代号"; cmb_Temp.HeaderText = "科室代号"; cmb_Temp.Name = "科室代号"; ds = ws_content.getTypeNum(deptID, UI.Input.BZ_Input.UserID); strField = new string[ds.Tables[0].Rows.Count]; if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { strField[i] = ds.Tables[0].Rows[i]["科室代号"].ToString(); } cmb_Temp.Items = strField; } dgvContent.Columns.Insert(4, cmb_Temp); if (!BZ_Input.CheckContentPermission) { cmb_Temp.Visible = false; } //绑定 页面的 下拉列表 cmbTypeNum.Items.Clear(); cmbTypeNum.Items.AddRange(strField); }
//绑定下拉列表列 private void BoundCmbLimit() { DataGridViewTextBoxColumn ColTopClassID = new DataGridViewTextBoxColumn(); ColTopClassID.HeaderText = "一级类目ID"; ColTopClassID.Name = "一级类目ID"; ColTopClassID.DataPropertyName = "一级类目ID"; dgvLimit.Columns.Add(ColTopClassID); object[] fields = Gd_limit.getBGQX(); cmb_Temp = dgvCommon.GetComboBoxColumn("保管期限", "保管期限", "保管期限", fields); dgvLimit.Columns.Insert(1, cmb_Temp); }
public DataGridViewEditComboBoxColumn GetComboBoxColumn( string PropertyName, string HeaderText, string ColumnName, object[] Items) { DataGridViewEditComboBoxColumn cmb_Temp = new DataGridViewEditComboBoxColumn(); cmb_Temp.DataPropertyName = PropertyName; cmb_Temp.HeaderText = HeaderText; cmb_Temp.Name = ColumnName; cmb_Temp.Items = Items; return(cmb_Temp); }
//绑定下拉列表列 private void BoundCmbLimit() { #region 绑定列 //绑定类目列 object[] fields = Gd_class.getLMMC(); cmb_Temp = dgvCommon.GetComboBoxColumn("类目", "类目", "类目", fields); dgvClass.Columns.Insert(1, cmb_Temp); //绑定界面中 类目下拉列表 cmbClass.Items.Clear(); cmbClass.Items.AddRange(fields); //绑定整理人列 fields = Gd_class.getZLR(); cmb_Temp = dgvCommon.GetComboBoxColumn("整理人", "整理人", "整理人", fields); dgvClass.Columns.Insert(3, cmb_Temp); //绑定界面中 整理人下拉列表 cmbZLR.Items.Clear(); cmbZLR.Items.AddRange(fields); //绑定检查人列 fields = Gd_class.getJCR(); cmb_Temp = dgvCommon.GetComboBoxColumn("检查人", "检查人", "检查人", fields); dgvClass.Columns.Insert(5, cmb_Temp); //绑定界面中 检查人下拉列表 cmbJCR.Items.Clear(); cmbJCR.Items.AddRange(fields); //归档时间 maskedColumn = dgvCommon.GetMaskedColumn("归档时间", "归档时间", "归档时间", "0000-00-00"); dgvClass.Columns.Insert(5, maskedColumn); //绑定分类号列 fields = Gd_class.getKSDH(); cmb_Temp = dgvCommon.GetComboBoxColumn("科室代号", "科室代号", "科室代号", fields); dgvClass.Columns.Insert(6, cmb_Temp); if (!PublicClass.CheckContentPermission) { cmb_Temp.Visible = false; } //绑定界面中 检查人下拉列表 cmbTypeNum.Items.Clear(); cmbTypeNum.Items.AddRange(fields); #endregion }
//绑定下拉列表,DataGridView 和 cmbLimite 的 private void BoundCmbLimit() { object[] fields = bz_content.getBGQX(); cmb_Temp = dgvCommon.GetComboBoxColumn("保管期限", "保管期限", "保管期限", fields); dgvContent.Columns.Insert(3, cmb_Temp); //绑定 页面的 下拉列表 cmbLimit.Items.Clear(); cmbLimit.Items.AddRange(fields); fields = bz_content.getKSDH(); cmb_Temp = dgvCommon.GetComboBoxColumn("科室代号", "科室代号", "科室代号", fields); dgvContent.Columns.Insert(4, cmb_Temp); if (!PublicClass.CheckContentPermission) { cmb_Temp.Visible = false; } //绑定 页面的 下拉列表 cmbTypeNum.Items.Clear(); cmbTypeNum.Items.AddRange(fields); }
//手动绑定 DataGridView 列 private void setColumns() { #region 绑定列 dgvTypeNum.AutoGenerateColumns = false; dgvTypeNum.Columns.Clear(); DataGridViewTextBoxColumn ColID = new DataGridViewTextBoxColumn(); ColID.HeaderText = "ID"; ColID.Name = "ID"; ColID.DataPropertyName = "ID"; dgvTypeNum.Columns.Add(ColID); DataGridViewTextBoxColumn ColDeptID = new DataGridViewTextBoxColumn(); ColDeptID.HeaderText = "全宗ID"; ColDeptID.Name = "全宗ID"; ColDeptID.DataPropertyName = "全宗ID"; dgvTypeNum.Columns.Add(ColDeptID); DataGridViewTextBoxColumn ColTypeNumLevel = new DataGridViewTextBoxColumn(); ColTypeNumLevel.HeaderText = "类目级别"; ColTypeNumLevel.Name = "类目级别"; ColTypeNumLevel.DataPropertyName = "类目级别"; dgvTypeNum.Columns.Add(ColTypeNumLevel); DataGridViewTextBoxColumn ColDGLX = new DataGridViewTextBoxColumn(); ColDGLX.HeaderText = "大纲类型"; ColDGLX.Name = "大纲类型"; ColDGLX.DataPropertyName = "大纲类型"; dgvTypeNum.Columns.Add(ColDGLX); DataGridViewTextBoxColumn ColTypeNum = new DataGridViewTextBoxColumn(); ColTypeNum.HeaderText = "分类号"; ColTypeNum.Name = "分类号"; ColTypeNum.DataPropertyName = "分类号"; dgvTypeNum.Columns.Add(ColTypeNum); DataGridViewTextBoxColumn ColTypeNumName = new DataGridViewTextBoxColumn(); ColTypeNumName.HeaderText = "类目名称"; ColTypeNumName.Name = "类目名称"; ColTypeNumName.DataPropertyName = "类目名称"; dgvTypeNum.Columns.Add(ColTypeNumName); DataGridViewTextBoxColumn ColProjectTypeID = new DataGridViewTextBoxColumn(); ColProjectTypeID.HeaderText = "项目类型"; ColProjectTypeID.Name = "项目类型"; ColProjectTypeID.DataPropertyName = "项目类型"; dgvTypeNum.Columns.Add(ColProjectTypeID); //绑定编制单位列 DataGridViewEditComboBoxColumn projectType = new DataGridViewEditComboBoxColumn(); projectType.HeaderText = "项目类型"; projectType.Name = "项目分类名称"; //EditComboBox的Items项设定 DataSet dsProjectType = typeNum.getProjectType(); int rowscount = dsProjectType.Tables[0].Rows.Count; object[] itemsBZDW = new object[rowscount]; if (rowscount > 0) { for (int i = 0; i < rowscount; i++) { itemsBZDW[i] = dsProjectType.Tables[0].Rows[i][0].ToString(); } projectType.Items = itemsBZDW; } dgvTypeNum.Columns.Add(projectType); #endregion }
//手动绑定列 private void BoundCmbLimit() { #region 手工绑定列 //责任者 cmb_Temp = new DataGridViewEditComboBoxColumn(); cmb_Temp.DataPropertyName = "责任者"; cmb_Temp.HeaderText = "责任者"; cmb_Temp.Name = "责任者"; DataSet ds = OldCJ_doc.getZRZ(deptID); string[] strField = new string[ds.Tables[0].Rows.Count]; if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string typeNum = ds.Tables[0].Rows[i]["责任者"].ToString(); strField[i] = typeNum; } cmb_Temp.Items = strField; } dgvDoc.Columns.Insert(6, cmb_Temp); //绑定 页面的责任者下拉类表 cmbZRZ.Items.Clear(); cmbZRZ.Items.AddRange(strField); //时间 maskedColumn = new DataGridViewMaskedTextBoxColumn(); maskedColumn.DataPropertyName = "时间"; maskedColumn.HeaderText = "时间"; maskedColumn.Name = "时间"; maskedColumn.Mask = "0000-00-00"; dgvDoc.Columns.Insert(7, maskedColumn); //文本 cmb_Temp = new DataGridViewEditComboBoxColumn(); cmb_Temp.DataPropertyName = "文本"; cmb_Temp.HeaderText = "文本"; cmb_Temp.Name = "文本"; ds = OldCJ_doc.getWB(deptID); strField = new string[ds.Tables[0].Rows.Count]; if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string typeNum = ds.Tables[0].Rows[i]["文本"].ToString(); strField[i] = typeNum; } cmb_Temp.Items = strField; } dgvDoc.Columns.Insert(8, cmb_Temp); //绑定 页面的文本下拉类表 cmbWB.Items.Clear(); cmbWB.Items.AddRange(strField); #endregion }
//手动绑定列 private void BoundCmbLimit() { #region 手工绑定列 //绑定责任者列 DataGridViewEditComboBoxColumn zrzcolumn = new DataGridViewEditComboBoxColumn(); zrzcolumn.DataPropertyName = "责任者"; zrzcolumn.HeaderText = "责任者"; zrzcolumn.Name = "责任者"; //EditComboBox的Items项设定 DataSet dszrz = CJ_doc.getZRZ(deptID); int rowscount = dszrz.Tables[0].Rows.Count; object[] itemsZRZ = new object[rowscount]; if (rowscount > 0) { for (int i = 0; i < rowscount; i++) { itemsZRZ[i] = dszrz.Tables[0].Rows[i][0].ToString(); } zrzcolumn.Items = itemsZRZ; } dgvDoc.Columns.Insert(4, zrzcolumn); //绑定 页面的责任者下拉类表 cmbZRZ.Items.Clear(); cmbZRZ.Items.AddRange(itemsZRZ); //绑定文本列 DataGridViewEditComboBoxColumn wbcolumn = new DataGridViewEditComboBoxColumn(); wbcolumn.DataPropertyName = "文本"; wbcolumn.HeaderText = "文本"; wbcolumn.Name = "文本"; //EditComboBox的Items项设定 DataSet dswb = CJ_doc.getWB(deptID); rowscount = dswb.Tables[0].Rows.Count; object[] itemsWB = new object[rowscount]; if (rowscount > 0) { for (int i = 0; i < rowscount; i++) { itemsWB[i] = dswb.Tables[0].Rows[i][0].ToString(); } wbcolumn.Items = itemsWB; } dgvDoc.Columns.Insert(6, wbcolumn); //绑定 页面的文本下拉类表 cmbWB.Items.Clear(); cmbWB.Items.AddRange(itemsWB); //绑定形成时间列 DataGridViewMaskedTextBoxColumn datecolumn = new DataGridViewMaskedTextBoxColumn(); datecolumn.DataPropertyName = "形成时间"; datecolumn.HeaderText = "形成时间"; datecolumn.Name = "形成时间"; datecolumn.Mask = "0000-00-00"; dgvDoc.Columns.Insert(8, datecolumn); #endregion }