protected void searchResault(object sender, EventArgs e) { string query = ""; lblsearch.Text = "搜索内容<"; lblsearch.Text += " 发送给:" + ddlobjtype.SelectedItem.Text; query += " and a.objtype=" + ddlobjtype.Text; if (txtobjname.Text.Trim() != "") { lblsearch.Text += " 用户名:" + txtobjname.Text; int uid = -1; if (ddlobjtype.Text.Trim() == "0") { List<wgiAdUnionSystem.Model.wgi_sitehost> o = new wgiAdUnionSystem.BLL.wgi_sitehost().GetModelList(" username='******' "); if (o.Count() > 0) { uid = o.SingleOrDefault().userid; } } else if (ddlobjtype.Text.Trim() == "1") { List<wgiAdUnionSystem.Model.wgi_adhost> o = new wgiAdUnionSystem.BLL.wgi_adhost().GetModelList(" username='******' "); if (o.Count() > 0) { uid = o.SingleOrDefault().companyid; } } query += " and a.objid=" + uid + " "; } if (txttitle.Text.Trim() != "") { lblsearch.Text += "标题:" + txttitle.Text + " "; query = " and a.title like '%" + txttitle.Text + "%' "; } if (txtstart.Text.Trim() != "" || txtend.Text.Trim() != "") { lblsearch.Text += "发布时间:"; if (txtstart.Text.Trim() == "") { lblsearch.Text += txtend.Text + "之前"; query += " and a.pubdate<'" + txtend.Text + "' "; } else if (txtend.Text.Trim() == "") { lblsearch.Text += txtstart.Text + "之后"; query += " and a.pubdate>'" + txtstart.Text + "' "; } else { lblsearch.Text += Convert.ToDateTime(txtstart.Text).ToString("yyyy-MM-dd") + "-" + Convert.ToDateTime(txtend.Text).ToString("yyyy-MM-dd") + "之间"; query += " and a.pubdate > '" + txtstart.Text + "' and a.pubdate < '" + txtend.Text + "' "; } } if (lblsearch.Text == "搜索内容<") { lblsearch.Text = ""; lbtnclear.Visible = false; } else { lblsearch.Text += ">"; lbtnclear.Visible = true; } hidquery.Value = query; initData(); }