private void myDataGrid_OnCellMouseUp(object sender, DataGridViewCellMouseEventArgs e) { // End of edition on each click on column of checkbox if (e.ColumnIndex == myCheckBoxColumn.Index && e.RowIndex != -1) { GR_LIST.EndEdit(); } }
//Search function public void Search() { var aaa = E_UNCHIN2.Checked; GR_LIST.DataSource = null; object Area = CB_AREA.SelectedValue; bool MNR = CH_MNR.Checked; bool SNK = CH_SNK.Checked; bool TYU = CH_TYU.Checked; bool CYU = CH_CYU.Checked; bool APU = CH_APU.Checked; bool Status1 = radioButton1.Checked; bool Status2 = radioButton3.Checked; bool Status3 = radioButton2.Checked; bool Status4 = radioButton4.Checked; bool Status5 = radioButton5.Checked; bool Status6 = radioButton6.Checked; bool Status7 = radioButton7.Checked; string SyukaBi1 = E_SYUKABI1.Value.ToString(); string SyukaBi2 = E_SYUKABI2.Value.ToString(); string Exlsrd1 = E_EXLSRD1.Value.ToString(); string Exlsrd2 = E_EXLSRD2.Value.ToString(); string Unchin1 = E_UNCHIN1.Value.ToString(); string Unchin2 = E_UNCHIN2.Value.ToString(); string OrderNO = E_ORDERNO.Text; string HaisoBnNO = E_HAISOBNNO.Text; bool ZanKa = CH_ZANKA.Checked; if (OrderNO.Length >= 0 || SyukaBi1.Length >= 0) { Search search = new Search(); DataTable ds = new DataTable(); ds = search.SearchByParameter(MNR, SNK, TYU, CYU, APU, Status1, Status2, Status3, Status4, Status5, Status6, Status7, SyukaBi1, SyukaBi2, Exlsrd1, Exlsrd2, Unchin1, Unchin2, OrderNO, HaisoBnNO, ZanKa, Area, !E_SYUKABI1.Checked, !E_SYUKABI2.Checked, !E_EXLSRD1.Checked, !E_EXLSRD2.Checked, !E_UNCHIN1.Checked, !E_UNCHIN2.Checked); if (ds.Rows.Count <= 0) { MessageBox.Show("対象データがありません。", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); label6.Text = label7.Text = "0"; } else if (ds.Rows.Count > int.Parse(Tools.GetKenSu())) { string mess = "最大件数" + Tools.GetKenSu() + "を越えています。検索条件を変更してください。"; MessageBox.Show(mess, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); label6.Text = label7.Text = "0"; } else { GR_LIST.DataSource = ds; GR_LIST.Sort(ZNKFLG, 0); int totalCount = 0; double totalWeight = 0; for (int i = 0; i < GR_LIST.RowCount; i++) { var nmsl = GR_LIST.Rows[i].Cells["ZNKFLG"].Value; if (nmsl is DBNull) { totalCount += Convert.ToInt32(GR_LIST.Rows[i].Cells["KOSU"].Value); var bb = GR_LIST.Rows[i].Cells["WT"].Value; totalWeight += Convert.ToDouble(bb); } } label6.Text = totalCount.ToString(); label7.Text = totalWeight.ToString(); } } else { MessageBox.Show("Error"); } }