string queryselect = "select * from jt where 1=1 ";
if (cb1.Checked)
{
queryselect += " and model = '" + cbbcategory.Text + " '";
}
if (cb2.Checked)
{
queryselect += " and modelnumber" + " like '%" + txtMN.Text + "%'";
}
if (cb3.Checked)
{
queryselect += " and problemdescribe" + " like '%" + cbbQC.Text + "%'";
}
if (cb4.Checked)
{
queryselect += " and author" + " like '%" + txtAuthor.Text + "%'";
}
//if (cb5.Checked)
//{
//queryselect += " and data" + " like '%" + txtTime.Text + "%'";
//}
if (cb5.Checked && cb6.Checked)
{
string ss = startTime.Value.ToString("yyyy-MM-dd 00:00:00");
string ee = endTime.Value.ToString("yyyy-MM-dd 00:00:00");
queryselect = "select * from jt where data >= '" + ss + "' and '" + ee + "'";
}
--------------------编程问答--------------------
if(cb5.Checked)
{
string ss = startTime.Value.ToString("yyyy-MM-dd 00:00:00");
queryselect+="data>="+ss;
}
if(cb6.Checked)
{
string ee = endTime.Value.ToString("yyyy-MM-dd 00:00:00");
queryselect+="data<="+ee;
}
--------------------编程问答--------------------
queryselect = "select * from jt where data between '" + ss + "' and '" + ee + "'";
if (cb5.Checked && cb6.Checked)
{
string ss = startTime.Value.ToString("yyyy-MM-dd 00:00:00");
string ee = endTime.Value.ToString("yyyy-MM-dd 00:00:00");
queryselect = "select * from jt where data >= '" + ss + "' and data<='" + ee + "'";
}