public void BindData(string user)
{
if (!string.IsNullOrEmpty(user))
{
user = user.ToLower().Replace("founder\\", "");
DataTable dt = GetDataInfos(user);
DataView dv = dt.DefaultView;
string proName = tbxTitle.Text.ToString().Trim();
string startTime = tbxBeginTime.Value.ToString().Trim();
string endTime = tbxEndTime.Value.ToString().Trim();
StringBuilder searchSql = new StringBuilder();
if (!string.IsNullOrEmpty(proName))
{
if (!Workflow_Common.ValidateQuery(proName))
{
DisplayMessage.ExecuteJs("alert('查询字符无效');");
return;
}
searchSql.AppendFormat("FormTitle like '%{0}%'", proName);
}
if (!string.IsNullOrEmpty(startTime))
{
if (!string.IsNullOrEmpty(searchSql.ToString()))
{
searchSql.Append(" and ");
}
searchSql.AppendFormat("ApproveAtTime>'{0}'", startTime);
}
if (!string.IsNullOrEmpty(endTime))
{
if (!string.IsNullOrEmpty(searchSql.ToString()))
{
searchSql.Append(" and ");
}
searchSql.AppendFormat("ApproveAtTime<'{0}'", endTime);
}
dv.RowFilter = searchSql.ToString();
gvDataList.DataSource = dv.ToTable();
gvDataList.DataBind();
}
}
