private void setDataGridViewControl(string[] myRows)
{
if (myRows != null)
{
foreach (string myRow in myRows)
{
DataRow row = myDTSelectProject.NewRow();
row[0] = myRow;
row[1] = myManageDB.getDataFromCell("proName", "ProjectManager", "proNO", myRow);
row[2] = myManageDB.getDataFromCell("proManager", "ProjectManager", "proNO", myRow);
row[3] = myManageDB.getDataFromCell("proDepartment", "ProjectManager", "proNO", myRow);
myDTSelectProject.Rows.Add(row);
}
//用户不能调整列标题高度
dgvSelectProject.ColumnHeadersHeightSizeMode =
DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
//设置行高
dgvSelectProject.RowTemplate.Height = ROW_HEIGHT;
//设置内边距大小
//Padding newPadding = new Padding(0, 1, 0, ROW_HEIGHT - 35);
//dgvSelectProject.RowTemplate.DefaultCellStyle.Padding = newPadding;
dgvSelectProject.AllowUserToAddRows = false;
dgvSelectProject.AllowUserToDeleteRows = false;
dgvSelectProject.AllowUserToResizeColumns = false;
//设置无单元格边框
dgvSelectProject.CellBorderStyle = DataGridViewCellBorderStyle.None;
//单元格选择模式为全选
dgvSelectProject.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dgvSelectProject.MultiSelect = false;
dgvSelectProject.AutoResizeRows(DataGridViewAutoSizeRowsMode.AllCellsExceptHeaders);
//设置字体样式
dgvSelectProject.DefaultCellStyle.SelectionForeColor = Color.Black;
dgvSelectProject.DefaultCellStyle.ForeColor = Color.Black;
//设置选中行背景色，需要绘制自定义背景应该在RowPrePaint处理，并设置该属性为Color.Transparent;
//dataGridView.RowTemplate.DefaultCellStyle.SelectionBackColor = Color.LightSkyBlue;
dgvSelectProject.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvSelectProject.DataSource = myDTSelectProject;
}
}
private void ToolCaseModify_Load(object sender, EventArgs e)
{
try
{
this.tb_Project.Text = myManageDB.getDataFromCell("ceProject", "CaseManager", "ceCaseNO", tcNO);
this.cb_Struct.Text = myManageDB.getDataFromCell("ceStruct", "CaseManager", "ceCaseNO", tcNO);
this.tb_SuiteNO.Text = myManageDB.getDataFromCell("ceSuiteNO", "CaseManager", "ceCaseNO", tcNO);
this.tb_SuiteName.Text = myManageDB.getDataFromCell("ceSuiteName", "CaseManager", "ceCaseNO", tcNO);
this.tb_CaseNO.Text = myManageDB.getDataFromCell("ceCaseNO", "CaseManager", "ceCaseNO", tcNO);
this.tb_CaseName.Text = myManageDB.getDataFromCell("ceCaseName", "CaseManager", "ceCaseNO", tcNO);
this.tb_ReqNO.Text = myManageDB.getDataFromCell("ceReqNO", "CaseManager", "ceCaseNO", tcNO);
this.cb_CaseLevel.Text = myManageDB.getDataFromCell("ceCaseLevel", "CaseManager", "ceCaseNO", tcNO);
this.tb_FatherModule.Text = myManageDB.getDataFromCell("ceFatherModule", "CaseManager", "ceCaseNO", tcNO);
this.tb_SubModule.Text = myManageDB.getDataFromCell("ceSubModule", "CaseManager", "ceCaseNO", tcNO);
this.tb_Author.Text = myManageDB.getDataFromCell("ceAuthor", "CaseManager", "ceCaseNO", tcNO);
this.tb_EditDate.Text = myManageDB.getDataFromCell("ceEditDate", "CaseManager", "ceCaseNO", tcNO).Split(' ')[0];
this.dtpModifyDate.Text = myManageDB.getDataFromCell("ceModifyDate", "CaseManager", "ceCaseNO", tcNO).Split(' ')[0];
this.cb_Tester.Text = myManageDB.getDataFromCell("ceTester", "CaseManager", "ceCaseNO", tcNO);
this.dtpTestDate.Text = myManageDB.getDataFromCell("ceTestDate", "CaseManager", "ceCaseNO", tcNO).Split(' ')[0];
this.rtb_Precondition.Text = myManageDB.getDataFromCell("cePrecondition", "CaseManager", "ceCaseNO", tcNO);
this.rtb_Steps.Text = myManageDB.getDataFromCell("ceSteps", "CaseManager", "ceCaseNO", tcNO);
this.rtb_Samples.Text = myManageDB.getDataFromCell("ceSamples", "CaseManager", "ceCaseNO", tcNO);
this.rtb_Except.Text = myManageDB.getDataFromCell("ceExcept", "CaseManager", "ceCaseNO", tcNO);
this.cb_Actually.Text = myManageDB.getDataFromCell("ceActually", "CaseManager", "ceCaseNO", tcNO);
this.cb_IfAuto.Text = myManageDB.getDataFromCell("ceIfAuto", "CaseManager", "ceCaseNO", tcNO);
this.dtpModifyDate.text = DateTime.Today.ToShortDateString();
this.tb_Modifier.Text = ManageDB.userFullName;
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, "异常消息提示：", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void ToolProjectModify_Load(object sender, EventArgs e)
{
try
{
this.tb_ProjectName.Text = myManageDB.getDataFromCell("proName", "ProjectManager", "proNO", proNO);
this.tb_ShortName.Text = myManageDB.getDataFromCell("proShortName", "ProjectManager", "proNO", proNO);
this.tb_ProjectNO.Text = myManageDB.getDataFromCell("proNO", "ProjectManager", "proNO", proNO);
this.cb_Type.Text = myManageDB.getDataFromCell("proType", "ProjectManager", "proNO", proNO);
this.cb_Priority.Text = myManageDB.getDataFromCell("proPriority", "ProjectManager", "proNO", proNO);
this.tb_Department.Text = myManageDB.getDataFromCell("proDepartment", "ProjectManager", "proNO", proNO);
this.tb_Manager.Text = myManageDB.getDataFromCell("proManager", "ProjectManager", "proNO", proNO);
this.tb_Assistant.Text = myManageDB.getDataFromCell("proAssistant", "ProjectManager", "proNO", proNO);
this.dtp_SetUpTime.Text = myManageDB.getDataFromCell("proSetUpTime", "ProjectManager", "proNO", proNO).Split(' ')[0];
this.dtp_ClosedTime.Text = myManageDB.getDataFromCell("proClosedTime", "ProjectManager", "proNO", proNO).Split(' ')[0];
this.tb_Customer.Text = myManageDB.getDataFromCell("proCustomer", "ProjectManager", "proNO", proNO);
this.tb_DevelopmentSite.Text = myManageDB.getDataFromCell("proDevelopmentSite", "ProjectManager", "proNO", proNO);
this.tb_Author.Text = myManageDB.getDataFromCell("proAuthor", "ProjectManager", "proNO", proNO);
this.dtp_BuildTime.Text = myManageDB.getDataFromCell("proBuildTime", "ProjectManager", "proNO", proNO).Split(' ')[0];
this.tb_Modifier.Text = myManageDB.getDataFromCell("proModifier", "ProjectManager", "proNO", proNO);
this.dtp_ModifyTime.Text = myManageDB.getDataFromCell("proModifyTime", "ProjectManager", "proNO", proNO).Split(' ')[0];
this.rtb_Describe.Text = myManageDB.getDataFromCell("proDescribe", "ProjectManager", "proNO", proNO);
this.dtp_ModifyTime.text = DateTime.Today.ToShortDateString();
this.tb_Modifier.Text = ManageDB.userFullName;
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, "异常消息提示：", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void setDataGridViewControl(string [] myRows)
{
if (myRows != null)
{
foreach (string myRow in myRows)
{
DataRow row = myDTCase.NewRow();
row[0] = myRow;
row[1] = myManageDB.getDataFromCell("ceAuthor", "CaseManager", "ceCaseNO", myRow);
row[2] = myManageDB.getDataFromCell("ceActually", "CaseManager", "ceCaseNO", myRow);
row[3] = myManageDB.getDataFromCell("ceEditDate", "CaseManager", "ceCaseNO", myRow).Split(' ')[0];
row[4] = myManageDB.getDataFromCell("ceModifyDate", "CaseManager", "ceCaseNO", myRow).Split(' ')[0];
row[5] = myManageDB.getDataFromCell("ceTestDate", "CaseManager", "ceCaseNO", myRow).Split(' ')[0];
row[6] = myManageDB.getDataFromCell("ceCaseName", "CaseManager", "ceCaseNO", myRow);
myDTCase.Rows.Add(row);
}
//用户不能调整列标题高度
dgvCaseManager.ColumnHeadersHeightSizeMode =
DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
//隐藏行标题
dgvCaseManager.RowHeadersVisible = false;
//设置行高
dgvCaseManager.RowTemplate.Height = ROW_HEIGHT;
//设置内边距大小
Padding newPadding = new Padding(0, 1, 0, ROW_HEIGHT - 35);
dgvCaseManager.RowTemplate.DefaultCellStyle.Padding = newPadding;
dgvCaseManager.AllowUserToAddRows = false;
dgvCaseManager.AllowUserToDeleteRows = false;
dgvCaseManager.AllowUserToResizeColumns = false;
//设置无单元格边框
dgvCaseManager.CellBorderStyle = DataGridViewCellBorderStyle.None;
//单元格选择模式为全选
dgvCaseManager.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dgvCaseManager.MultiSelect = false;
dgvCaseManager.AutoResizeRows(DataGridViewAutoSizeRowsMode.AllCellsExceptHeaders);
//设置字体样式
dgvCaseManager.DefaultCellStyle.SelectionForeColor = Color.Black;
dgvCaseManager.DefaultCellStyle.ForeColor = Color.Black;
//设置选中行背景色，需要绘制自定义背景应该在RowPrePaint处理，并设置该属性为Color.Transparent;
//dataGridView.RowTemplate.DefaultCellStyle.SelectionBackColor = Color.LightSkyBlue;
dgvCaseManager.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvCaseManager.DataSource = myDTCase;
//只需要把需要绘制的DataGridView传入DataGridViewRenderer即可，
//这里的隐藏列即为需要重新绘制的内容
DataGridViewRender render = new DataGridViewRender(dgvCaseManager,
dgvCaseManager.Columns[dgvCaseManager.ColumnCount - 1]);
}
}
