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);
}
public DataGridViewMaskedTextBoxColumn GetMaskedColumn(
string PropertyName, string HeaderText, string ColumnName, string MaskValue)
{
DataGridViewMaskedTextBoxColumn maskedColumn = new DataGridViewMaskedTextBoxColumn();
maskedColumn.DataPropertyName = PropertyName;
maskedColumn.HeaderText = HeaderText;
maskedColumn.Name = ColumnName;
maskedColumn.Mask = MaskValue;
return(maskedColumn);
}
//绑定下拉列表列
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
}
private void setDatagridview()
{
#region datagridview 设置
dgvDetails.Columns["ID"].Visible = false;
dgvDetails.Columns["项目ID"].Visible = false;
dgvDetails.Columns["开工时间"].Visible = false;
dgvDetails.Columns["竣工时间"].Visible = false;
//绑定开工时间列
DataGridViewMaskedTextBoxColumn kgsjcolumn = new DataGridViewMaskedTextBoxColumn();
kgsjcolumn.DataPropertyName = "开工时间";
kgsjcolumn.HeaderText = "开工时间";
kgsjcolumn.Name = "开工时间";
kgsjcolumn.Width = 80;
kgsjcolumn.Mask = "0000-00-00";
dgvDetails.Columns.Add(kgsjcolumn);
//绑定竣工时间列
DataGridViewMaskedTextBoxColumn jgsjcolumn = new DataGridViewMaskedTextBoxColumn();
jgsjcolumn.DataPropertyName = "竣工时间";
jgsjcolumn.HeaderText = "竣工时间";
jgsjcolumn.Name = "竣工时间";
jgsjcolumn.Width = 80;
jgsjcolumn.Mask = "0000-00-00";
dgvDetails.Columns.Add(jgsjcolumn);
dgvDetails.Columns["建筑面积"].HeaderText = "建筑面积(㎡)";
dgvDetails.Columns["高度"].HeaderText = "高度(m)";
dgvDetails.Columns["单项工程名称"].Width = 105;
dgvDetails.Columns["施工单位"].Width = 100;
dgvDetails.Columns["建筑面积"].Width = 85;
dgvDetails.Columns["高度"].Width = 60;
dgvDetails.Columns["地下层数"].Width = 60;
dgvDetails.Columns["地上层数"].Width = 60;
dgvDetails.Columns["结构类型"].Width = 60;
#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
}
