private void loadJewData() { dgv_searchRe.Rows.Clear(); jewDataList.Clear(); string sqlstr = "select * from JewDataTable order by ID asc "; var datalst = SqliteHelper.ExecDataTable(sqlstr); lbl_reCount.Text = "查找结果:" + datalst.Rows.Count + " 条。"; foreach (DataRow dr in datalst.Rows) { JewDataClass jewData = new Model.JewDataClass(); jewData.jewId = (int)dr["ID"]; jewData.jewName = (string)dr["Name"]; jewData.jewClass = (string)dr["JewClass"]; jewData.wavelength = ProcessArray.StringToDouble((string)dr["Wavelength"]); jewData.spectrum = ProcessArray.StringToDouble((string)dr["Spectrum"]); jewData.addTime = (string)dr["AddTime"]; jewData.creator = (string)dr["Creator"]; jewData.remark = (string)dr["Remark"]; jewDataList.Add(jewData); int index = dgv_searchRe.Rows.Add(); dgv_searchRe.Rows[index].Cells[0].Value = jewData.jewId; dgv_searchRe.Rows[index].Cells[1].Value = jewData.jewName; dgv_searchRe.Rows[index].Cells[2].Value = jewData.jewClass; dgv_searchRe.Rows[index].Cells[3].Value = jewData.addTime; dgv_searchRe.Rows[index].Cells[4].Value = jewData.creator; dgv_searchRe.Rows[index].Cells[5].Value = jewData.remark; } }
private void btn_search_Click(object sender, EventArgs e) { dgv_searchRe.Rows.Clear(); string key = txt_key.Text.Trim(); string className = cbx_class.SelectedItem.ToString(); string creatorName = cbx_creator.SelectedItem.ToString(); string sqlstr; jewDataList.Clear(); if (key == string.Empty) { // sqlstr = "select * from JewDataTable order by ID asc "; if (cbx_class.SelectedIndex == 0 && cbx_creator.SelectedIndex == 0) { sqlstr = "select * from JewDataTable order by ID asc "; } else if (cbx_class.SelectedIndex != 0 && cbx_creator.SelectedIndex != 0) { sqlstr = "select * from JewDataTable WHERE JewClass like '" + className + "' AND Creator like '" + creatorName + "' order by ID asc "; } else if (cbx_class.SelectedIndex != 0 && cbx_creator.SelectedIndex == 0) { sqlstr = "select * from JewDataTable WHERE JewClass like '" + className + "' order by ID asc "; } else { sqlstr = "select * from JewDataTable WHERE Creator like '" + creatorName + "' order by ID asc "; } } else { if (cbx_class.SelectedIndex == 0 && cbx_creator.SelectedIndex == 0) { sqlstr = "select * from JewDataTable WHERE Name like '%" + key + "%' order by ID asc "; } else if (cbx_class.SelectedIndex != 0 && cbx_creator.SelectedIndex != 0) { sqlstr = "select * from JewDataTable WHERE Name like '%" + key + "%' AND JewClass like '" + className + "' AND Creator like '" + creatorName + "' order by ID asc "; } else if (cbx_class.SelectedIndex != 0 && cbx_creator.SelectedIndex == 0) { sqlstr = "select * from JewDataTable WHERE Name like '%" + key + "%' AND JewClass like '" + className + "' order by ID asc "; } else { sqlstr = "select * from JewDataTable WHERE Name like '%" + key + "%' AND Creator like '" + creatorName + "' order by ID asc "; } } var datalst = SqliteHelper.ExecDataTable(sqlstr); lbl_reCount.Text = "查找结果:" + datalst.Rows.Count + " 条。"; foreach (DataRow dr in datalst.Rows) { JewDataClass jewData = new Model.JewDataClass(); jewData.jewId = (int)dr["ID"]; jewData.jewName = (string)dr["Name"]; jewData.jewClass = (string)dr["JewClass"]; jewData.wavelength = ProcessArray.StringToDoubleEncryption((string)dr["Wavelength"]); jewData.spectrum = ProcessArray.StringToDoubleEncryption((string)dr["Spectrum"]); jewData.addTime = (string)dr["AddTime"]; jewData.creator = (string)dr["Creator"]; jewData.remark = (string)dr["Remark"]; if (dr["RealSign"].ToString() != "") { jewData.realSign = ProcessArray.StringToDouble((string)dr["RealSign"]).ToList(); } if (dr["UnRealSign"].ToString() != "") { jewData.unRealSign = ProcessArray.StringToDouble((string)dr["UnRealSign"]).ToList(); } //jewData.factoryState = (string)dr["Factory"]; jewDataList.Add(jewData); int index = dgv_searchRe.Rows.Add(); dgv_searchRe.Rows[index].Cells[0].Value = jewData.jewId; dgv_searchRe.Rows[index].Cells[1].Value = jewData.jewName; dgv_searchRe.Rows[index].Cells[2].Value = jewData.jewClass; dgv_searchRe.Rows[index].Cells[3].Value = jewData.addTime; dgv_searchRe.Rows[index].Cells[4].Value = jewData.creator; dgv_searchRe.Rows[index].Cells[5].Value = jewData.remark; } }