/// <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("没有找到符合条件的焊工！");
}
}
private void InitstatusStrip(object sender, EventArgs_WelderFilter e)
{
if (string.IsNullOrEmpty(e.str_Filter))
{
this.toolStripStatusLabel_Filter.Text = string.Format("¼ìË÷Ìõ¼þ£ºÖ±½Ó¼ìË÷");
}
else
{
this.toolStripStatusLabel_Filter.Text = string.Format("¼ìË÷Ìõ¼þ£º{0}", e.str_Filter);
}
}
private void button_QueryAdvance_Click(object sender, EventArgs e)
{
Form_QueryFilter myForm = new Form_QueryFilter();
myForm.InitControl(Enum_DataTable.Welder.ToString());
if (myForm.ShowDialog() == DialogResult.OK)
{
EventArgs_WelderFilter g = new EventArgs_WelderFilter(myForm.str_Filter);
Publisher_WelderFilter.OnEventName(g);
}
}
/// <summary>
/// 添加数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void toolStripMenuItem_DataGridViewRowAdd_Click(object sender, EventArgs e)
{
Form_Welder_Update myForm = new Form_Welder_Update();
myForm.myClass_Welder = new Class_Welder();
myForm.bool_Add = true;
if (myForm.ShowDialog() == DialogResult.OK)
{
EventArgs_WelderFilter my_e = new EventArgs_WelderFilter(null);
my_e.str_IdentificationCard = myForm.myClass_Welder.IdentificationCard;
Publisher_WelderFilter.OnEventName(my_e);
}
}
private void button_OnOK_Click(object sender, EventArgs e)
{
EventArgs_WelderFilter my_e = new EventArgs_WelderFilter(null);
my_e.str_IdentificationCard = Class_DataValidateTool.CovertIdentificationCard(this.TextBox_IdentificationCardQuery.Text);
my_e.str_WelderName = this.TextBox_WelderNameQuery.Text;
my_e.str_RegistrationNo = this.TextBox_RegistrationNoQuery.Text;
my_e.str_WelderWorkerID = this.TextBox_WorkerIDQuery.Text;
my_e.str_ExaminingNo = this.TextBox_ExaminingNoQuery.Text;
my_e.str_CertificateNo = this.TextBox_CertificateNoQuery.Text;
my_e.str_IssueNo = this.textBox_IssueNoQuery.Text;
Publisher_WelderFilter.OnEventName(my_e);
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void toolStripMenuItem_DataGridViewRowDelete_Click(object sender, EventArgs e)
{
if (Class_Welder.ExistAndCanDeleteAndDelete(this.dataGridView_Data.CurrentRow.Cells["IdentificationCard"].Value.ToString(), Enum_zwjKindofUpdate.CanDelete))
{
if (MessageBox.Show("确认删除吗？", "确认窗口", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
Class_Welder.ExistAndCanDeleteAndDelete(this.dataGridView_Data.CurrentRow.Cells["IdentificationCard"].Value.ToString(), Enum_zwjKindofUpdate.Delete);
EventArgs_WelderFilter my_e = new EventArgs_WelderFilter(null);
my_e.str_IdentificationCard = this.dataGridView_Data.CurrentRow.Cells["IdentificationCard"].Value.ToString();
Publisher_WelderFilter.OnEventName(my_e);
}
}
else
{
MessageBox.Show("不能删除！");
}
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void toolStripMenuItem_DataGridViewRowModify_Click(object sender, EventArgs e)
{
Form_Welder_Update myForm = new Form_Welder_Update();
myForm.myClass_Welder = new Class_Welder();
myForm.myClass_Welder.IdentificationCard = this.dataGridView_Data.CurrentRow.Cells["IdentificationCard"].Value.ToString();
if (myForm.myClass_Welder.FillData())
{
myForm.bool_Add = false;
if (myForm.ShowDialog() == DialogResult.OK)
{
EventArgs_WelderFilter my_e = new EventArgs_WelderFilter(null);
my_e.str_IdentificationCard = myForm.myClass_Welder.IdentificationCard;
Publisher_WelderFilter.OnEventName(my_e);
}
}
else
{
MessageBox.Show("该行数据已被删除！");
}
}
private void toolStripMenuItem_RowAddByExcel_Click(object sender, EventArgs e)
{
DataTable myDataTable = Class_DataControlBind.ImportExcelToDataTable();
if (myDataTable != null)
{
if (!myDataTable.Columns.Contains("IdentificationCard"))
{
MessageBox.Show("数据表中不存在 'IdentificationCard' 列！");
return;
}
DataRow[] myDataRow_Range;
myDataRow_Range = myDataTable.Select("len(IdentificationCard)>0");
StringBuilder myStringBuilder = new StringBuilder();
myStringBuilder.Append("1=0");
foreach (DataRow myDataRow in myDataRow_Range)
{
myStringBuilder.Append(string.Format(" Or IdentificationCard='{0}'", Class_DataValidateTool.CovertIdentificationCard(myDataRow["IdentificationCard"].ToString())));
}
EventArgs_WelderFilter g = new EventArgs_WelderFilter(myStringBuilder.ToString());
Publisher_WelderFilter.OnEventName(g);
}
}
