public static string GetCriteria(QueryParameter queryPara)
{
StringBuilder criteria = new StringBuilder();
if (!queryPara.isToday)
{
criteria.Append(CC.CommbineLocationCriteria(queryPara.southLat.ToString(), queryPara.northLat.ToString(), queryPara.westLon.ToString(), queryPara.eastLon.ToString()));
}
criteria.Append(CC.CombineTimeCriteria(queryPara.photoTime, queryPara.createTime));
if (!queryPara.hasDelete)
{
criteria.Append(CC.CombineIsExistedCriteria(1));
}
return criteria.ToString();
}
/// <summary>
/// 初始化系统变量并验证其正确性
/// </summary>
/// <returns></returns>
QueryParameter VerifyVariable()
{
QueryParameter queryPara = new QueryParameter();
queryPara.eastLon = double.Parse(this.tbEast.Text);
queryPara.westLon = double.Parse(this.tbWest.Text);
queryPara.southLat = double.Parse(this.tbSouth.Text);
queryPara.northLat = double.Parse(this.tbNorth.Text);
if (this.dtPhotoTime.Checked)
{
DateTime dt = DateTime.Parse(this.dtPhotoTime.Text);
queryPara.photoTime = String.Format("{0:yyyyMMdd}", dt);
}
if (this.dtCreateTime.Checked)
{
queryPara.createTime = this.dtCreateTime.Text;
}
queryPara.hasDelete = cbDeleted.Checked;
return queryPara;
}
private void QueryAndBinding(QueryParameter queryPara)
{
criteria = DataHelper.GetCriteria(queryPara);
QueryAndBinding(criteria);
}
/// <summary>
/// 今天到达的数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void btnToday_Click(object sender, EventArgs e)
{
QueryParameter queryPara = new QueryParameter();
queryPara.isToday = true;
queryPara.createTime = DateTime.Now.ToString();
queryPara.hasDelete = cbDeleted.Checked;
QueryAndBinding(queryPara);
}