/// <summary> /// 初始化数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void InitDataGridView(object sender, EventArgs_WelderFilter e) { Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.Welder.ToString(), false); SqlCommand myCmd_Temp = new SqlCommand("Person_Welder_Query", Class_zwjPublic.myClass_SqlConnection.mySqlConn); myCmd_Temp.CommandType = CommandType.StoredProcedure; myCmd_Temp.Parameters.Add("@IdentificationCard", SqlDbType.NChar, 18).Value = ZCCL.Tools.Class_DataValidateTool.CovertIdentificationCard(e.str_IdentificationCard); myCmd_Temp.Parameters.Add("@WelderName", SqlDbType.NVarChar, 10).Value = e.str_WelderName; myCmd_Temp.Parameters.Add("@WelderWorkerID", SqlDbType.NVarChar, 10).Value = e.str_WelderWorkerID; myCmd_Temp.Parameters.Add("@RegistrationNo", SqlDbType.NVarChar, 20).Value = e.str_RegistrationNo; myCmd_Temp.Parameters.Add("@ExaminingNo", SqlDbType.NVarChar, 20).Value = e.str_ExaminingNo; myCmd_Temp.Parameters.Add("@CertificateNo", SqlDbType.NVarChar, 20).Value = e.str_CertificateNo; myCmd_Temp.Parameters.Add("@IssueNo", SqlDbType.NVarChar, 20).Value = e.str_IssueNo; if (!string.IsNullOrEmpty(e.str_Filter)) { myCmd_Temp.Parameters.Add("@Filter", SqlDbType.NVarChar).Value = e.str_Filter; } SqlDataAdapter myAdapter = new SqlDataAdapter(myCmd_Temp); DataTable myDataTable = new DataTable(); myAdapter.Fill(myDataTable); this.dataGridView_Data.DataSource = new DataView(myDataTable); this.label_Data.Text = string.Format("焊工,({0}):", this.dataGridView_Data.RowCount); if (this.dataGridView_Data.RowCount == 0) { EventArgs_Welder my_e = new EventArgs_Welder(null); Publisher_Welder.OnEventName(my_e); MessageBox.Show("没有找到符合条件的焊工!"); } }
/// <summary> /// 刷新数据 /// </summary> /// <param name="bool_JustFill">true-只添加和修改数据,false-刷新全部数据</param> private void RefreshData(bool bool_JustFill) { if (this.myEventArgs_Welder != null) { Publisher_Welder.OnEventName(this.myEventArgs_Welder); } }
private void toolStripMenuItem_RowSetQCValid_Click(object sender, EventArgs e) { Class_QC myClass_QC = new Class_QC(this.dataGridView_Data.CurrentRow.Cells["ExaminingNo"].Value.ToString()); Form_QC_Update myForm = new Form_QC_Update(); myForm.myClass_QC = myClass_QC; if (myForm.ShowDialog() == DialogResult.OK) { Publisher_Welder.OnEventName(this.myEventArgs_Welder); } }
private void dataGridView_Data_RowEnter(object sender, DataGridViewCellEventArgs e) { EventArgs_Welder my_e = new EventArgs_Welder(this.dataGridView_Data.Rows[e.RowIndex].Cells["IdentificationCard"].Value.ToString()); Publisher_Welder.OnEventName(my_e); }