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