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