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