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
}
