Flexigrid系列使用教程（三）增加外部查询

来源：互联网发布：网络语小饼干什么意思编辑：程序博客网时间：2024/05/22 02:04

Flexigrid有内置的内部查询功能，但是很多时候需要将查询条件放到flexigrid控件的外面使用，本文实现的效果如下所示：

问题所在：本人在调试时使用flexigrid的flexReload方法，但是在提交时不知道为啥flexigrid自动刷新了两次，第一次刷新按自己设置的条件查询成功，但是紧接着就是第二次刷新使flexigrid又重新加载了一次，导致没有得到想要的查询结果，最后使用session暂时解决了这个问题，使用session记录了第一次刷新的查询条件，第二次刷新时自动加载session里面保存的条件。（有知道如何解决这个问题的朋友告诉一下 QQ：346933996）

废话不多说具体代码如下：

一、前台页面代码

<%@ Page Title="" Language="C#" MasterPageFile="~/Views/Shared/QyKwstu.Master" Inherits="System.Web.Mvc.ViewPage<IEnumerable<Kwstu.Model.TALENT_BASEINFO>>" %>

<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">

$(document).ready(function () {

//按回车键实现按tab键的效果，方便录入查询条件

$('#PONAME').focus();

var $inp = $('input:text');

$inp.bind('keydown', function (e) {

var key = e.which;

if (key == 13) {

$('#requery').click();

e.preventDefault();

var nxtIdx = $inp.index(this) + 1;

$(":input:text:eq(" + nxtIdx + ")").focus();

}

});

//全屏浏览查询结果

function toolbarItem_onclick(cmd, pid) {

var Height = document.documentElement.clientHeight - 60;

var Width = document.documentElement.clientWidth - 40;

if (cmd == "FullScreen") {

JqueryDialog.Open('简历查询结果浏览', '../FindTalent/FullScreen', Width, Height);

}

else if (cmd == "Delete") {

alert("cmd Delete is excuted");

}

//重新定义表格大小

$(window).resize(function () {

var w = $("#content_right").width() - 5;

var gh = $("#content_right").height() - 86;

$("#grdProList").flexResize(w, gh);

});

//时间关系查询暂时用这个（主要方法）

$("#requery").click(function () { doquery() });

function doquery() {

var PONAME = $("#PONAME").val();

var JOBTYPE1 = $("#JOBTYPE1X").val();

params = { 'PONAME': PONAME, 'JOBTYPE1X': JOBTYPE1 };

$.post(

"/FindTalent/GetByPositionFindFlex",

params,

function () { $('#grdProList').flexReload(); }

);

}

var maiheight = document.documentElement.clientHeight;

var w = $("#content_right").width() - 20;

var gh = $("#content_right").height() - 86;

$("#grdProList").flexigrid

({

url: '/FindTalent/GetByPositionFindFlex',

dataType: 'json',

colModel: [

{ display: '序号', name: '', sortable: true, width: 20, align: 'center' },

{ display: '用户姓名', name: 'REALNAME', sortable: true, width: 60, align: 'center' },

{ display: '性', name: 'SEX', sortable: true, width: 25, align: 'center' },

{ display: '年龄', name: 'AGE', sortable: true, width: 25, align: 'center' },

{ display: '最高学历', name: 'TOPESTEDU', sortable: true, width: 43, align: 'center' },

{ display: '最后访问时间', name: 'LASTVT', sortable: true, width: 110, align: 'center' }

buttons: [

{ name: 'FullScreen', displayname: "<span style=color:red;font-weight:bold>点Ì?击¡Â全屏查看搜索结果</span>", bclass: 'Add', onpress: toolbarItem_onclick }

ShowToggleCol: true,

singleSelect: true,

sortname: 'LASTVT',

sortorder: 'DESC',

usepager: true,

striped: true,

resizable: true,

title: '人才简历列表',

useRp: true,

rp: 20,

rpOptions: [10, 20, 40, 100],

usepager: true,

showTableToggleBtn: true,

showcheckbox: false,

width: w,

height: gh,

pagestat: '显示 {from} 到 {to}，共2 {total} 条',

procmsg: '请等待数据正在加载中…',

nomsg: '没有数据',

onError: '查询出错，请刷新'

});

</script>

请输入查询条件</div>

应聘岗位</div>

<%=Html.TextBox("PONAME")%></div>

</div>

职位类别1：</div>

<%=Html.TextBox("JOBTYPE1X")%></div>

</div>

</table>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="title" runat="server">

</asp:Content>

<asp:Content ID="Content3" ContentPlaceHolderID="ContentLeft" runat="server">

</asp:Content>

<asp:Content ID="Content4" ContentPlaceHolderID="topmenu" runat="server">

</asp:Content>

<asp:Content ID="Content5" ContentPlaceHolderID="bottemmenu" runat="server">

</asp:Content>

二、后台处理代码

public ActionResult ByPositionFindTalent()

{

Session["QUERRY"] = " and CVVISIBLE ='是º?' and 1=1 and LASTVT is not null ";

return View();

}

public String GetByPositionFindFlex()

{

int page = 1;

if (HttpContext.Request.Form["page"] != null)

{

page = int.Parse(HttpContext.Request.Form["page"].ToString());

}

int rp = 1;

if (HttpContext.Request.Form["rp"] != null)

{

rp = int.Parse(HttpContext.Request.Form["rp"].ToString());

}

string sortname = "";

if (HttpContext.Request.Form["sortname"] != null)

{

sortname = HttpContext.Request.Form["sortname"].ToString();

}

//自定义搜索条件（关键实现部分）

string define = "";

string logic = "and";

string tmp1 = HttpContext.Request.Form["PONAME"] == null ? "" : HttpContext.Request.Form["PONAME"];

string tmp2 = HttpContext.Request.Form["JOBTYPE1X"] == null ? "" : HttpContext.Request.Form["JOBTYPE1X"];

define = (define == "" ? (tmp1 == "" ? "" : (" PONAME like '%" + tmp1 + "%' or JOBTYPE1 like '%" + tmp1 + "%'")) : (tmp1 == "" ? define : (define + " " + logic + " PONAME like '%" + tmp1 + "%' or JOBTYPE1 like '%"+tmp1+"%'")));

define = (define == "" ? (tmp2 == "" ? "" : (" JOBTYPE1 like '%" + tmp2 + "%' or PONAME like '%" + tmp2 + "%'")) : (tmp2 == "" ? define : (define + " " + logic + " JOBTYPE1 like '%" + tmp2 + "%' or PONAME like '%" + tmp2 + "%'")));

if (define != "")

Session["define"] = " and (" + define + ")";

string whereCondition = " and CVVISIBLE ='是' and 1=1 and LASTVT is not null ";

if (Session["define"] != null)

{

whereCondition += (Session["define"] == null ? "" : Session["define"].ToString());

}

string sortorder = "";

if (HttpContext.Request.Form["sortorder"] != null)

{

sortorder = HttpContext.Request.Form["sortorder"].ToString();

}

string tablename = "TALENT_BASEINFO";

if (HttpContext.Request.Form["tablename"] != null)

{

tablename = HttpContext.Request.Form["tablename"].ToString();

}

string sortExp = sortname + " " + sortorder;

int start = ((page - 1) * rp) + 1;

DataSet ds = new DataSet(); int total = 0;

TALENT_BASEINFODAL _dal = new TALENT_BASEINFODAL();

string fields = "ID,REALNAME,SEX,AGE,TOPESTEDU,FIRSTREAL,SECONDREAL,WORKAGE,PONAME,JOBTYPE1,LASTVT";

Session["QUERRY"] = whereCondition;

ds = _dal.GetListByPage(tablename, whereCondition, fields, sortname, sortorder, page, rp, out total);

return GetJsonForByPositionFind(ds.Tables[0], page, total);

}

//生成json数据

public string GetJsonForByPositionFind(DataTable dt, int page, int total)

{

StringBuilder jsonBuilder = new StringBuilder();

jsonBuilder.Append("{");

jsonBuilder.Append("\"page\":" + page.ToString() + ",\"total\":" + total.ToString() + ",\"rows\":[");

for (int i = 0; i < dt.Rows.Count; i++)

{

jsonBuilder.Append("{");

for (int j = 0; j < dt.Columns.Count; j++)

{

if (j == 0)

{

jsonBuilder.Append("\"id\":\"");

jsonBuilder.Append(tools.JsonStringFormat(dt.Rows[i][j].ToString()));

jsonBuilder.Append("\",\"cell\":[");

jsonBuilder.Append("\"");

jsonBuilder.Append(i + 1);

jsonBuilder.Append("\",");

}

else

{

if (j == 1)

{

jsonBuilder.Append("\"");

jsonBuilder.Append("<a onclick=\\\"JqueryDialog.Open('浏¡¥览¤¨¤简¨°历¤¨²', '../CommonInfo/TalentInfo?talentid=" + tools.JsonStringFormat(dt.Rows[i]["ID"].ToString()) + "', 1100, 580)\\\" target='_blank'><font color=blue>" + tools.JsonStringFormat(dt.Rows[i][j].ToString()) + "</font></a>");

jsonBuilder.Append("\",");

}

else

{

jsonBuilder.Append("\"");

jsonBuilder.Append(tools.JsonStringFormat(dt.Rows[i][j].ToString()));

jsonBuilder.Append("\",");

}

jsonBuilder.Remove(jsonBuilder.Length - 1, 1);

jsonBuilder.Append("],");

jsonBuilder.Remove(jsonBuilder.Length - 1, 1);

jsonBuilder.Append("},");

}

if (total > 0)

{

jsonBuilder.Remove(jsonBuilder.Length - 1, 1);

}

jsonBuilder.Append("]");

jsonBuilder.Append("}");

return jsonBuilder.ToString();

}

出处：http://www.kwstu.com/ArticleView/lydia_20121031201137406