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]); } }