YES-Win Winform开发框架 自定义查询方法并在表格中展示

public class bllLog : bllBaseUserCommon
{
    public bllLog()
        : base(typeof(sys_DataLog))
    {

    }
    /// <summary>
    /// 查询
    /// </summary>
    /// <param name="UserID"></param>
    /// <param name="UserName"></param>
    /// <param name="DataType"></param>
    /// <param name="TableName"></param>
    /// <param name="timeBegin"></param>
    /// <param name="timeEnd"></param>
    /// <returns></returns>
    public DataTable Search(string UserID, string UserName, string DataType, string TableName, DateTime? timeBegin, DateTime? timeEnd)
    {
        // 查询sql语句
        StringBuilder sqlBuilder = new StringBuilder();
        // 查询参数
        var cmds = new GZDBHelper.SqlParameterProvider();

        sqlBuilder.AppendFormat("SELECT * FROM {0} WHERE 1=1", sys_DataLog._TableName);
        if (!String.IsNullOrEmpty(UserID))
        {
            sqlBuilder.AppendFormat(" AND UserID = @UserID");
            cmds.AddParameter("@UserID", SqlDbType.VarChar, UserID);
        }
        if (!String.IsNullOrEmpty(UserName))
        {
            sqlBuilder.AppendFormat(" AND UserName = @UserName");
            cmds.AddParameter("@UserName", SqlDbType.VarChar, UserName);
        }
        if (!String.IsNullOrEmpty(DataType))
        {
            sqlBuilder.AppendFormat(" AND DataType = @DataType");
            cmds.AddParameter("@DataType", SqlDbType.VarChar, DataType);
        }
        if (!String.IsNullOrEmpty(TableName))
        {
            sqlBuilder.AppendFormat(" AND DataType = @TableName");
            cmds.AddParameter("@TableName", SqlDbType.VarChar, TableName);
        }
        if (timeBegin != null)
        {
            sqlBuilder.AppendFormat(" AND LogTime>=@LogTime1");
            cmds.AddParameter("@LogTime1", SqlDbType.Date, timeBegin.Value.Date);
        }
        if (timeEnd != null)
        {
            sqlBuilder.AppendFormat(" AND LogTime<@LogTime2");
            // 结束时间，存在 23:59秒
            cmds.AddParameter("@LogTime2", SqlDbType.Date, timeEnd.Value.Date.AddDays(1));
        }

        sqlBuilder.AppendLine(" ORDER BY LogTime DESC");

        DataTable data = dal.DBHelper.GetTable(sqlBuilder.ToString(), sys_DataLog._TableName, cmds);
        return data;
    }

}

private void btn_Refresh_Click(object sender, EventArgs e)
{

    DataTable dt1 = bll.Search(txtUserID.Text, txt_UserName.Text, txtDataType.Text, txtTableName.Text, txtTime1.DateTime, txtTime2.DateTime);
    gc_Business.DataSource = dt1;
}