/// <summary>
/// 查询
/// </summary>
/// <param name="code"></param>
/// <returns></returns>
public ActionResult Search(string code)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("CODE", code);
var list = new Dal.Search.s_searchDal(dic, "CODE").ToList();
return(View(list));
}
public object BindModel(ControllerContext context, ModelBindingContext bindingContext)
{
HttpRequestBase request = context.RequestContext.HttpContext.Request;
int page, rows, beg = 0, end = 2000;
string sort = " list_id ", order = " desc ";
if (request["page"] != null)
{
page = Convert.ToInt32(request["page"]);
rows = Convert.ToInt32(request["rows"]);
beg = (page - 1) * rows;
end = beg + rows;
}
if (request["sort"] != null)
{
sort = " " + request["sort"].ToString() + " ";
}
if (request["order"] != null)
{
order = " " + request["order"].ToString() + " ";
}
string sqls = "";
List <SqlParameter> paramter = new List <SqlParameter>();
if (request["SubmitSearch"] != null)
{
JObject obj = JsonConvert.DeserializeObject <dynamic>(request["SubmitSearch"].ToString());
string code = obj["searchModelCode"].ToString();
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("code", code);
var list = new Dal.Search.s_searchDal(dic, "code").ToList();
foreach (var i in list)
{
if (obj["listid" + i.list_id].ToString() != "")
{
string value = obj["listid" + i.list_id].ToString();
if (value == "未审核")
{
value = "";
}
sqls += " " + i.sqltext + " " + i.tablename;
if (i.sqltext.IndexOf("like") > 0)
{
value = "%" + value + "%";
}
if (i.cdef1 == "Y" && value.IndexOf("]") > 0)
{
value = value.Substring(1, value.IndexOf("]") - 1);
}
paramter.Add(new SqlParameter(i.tablename, value));
}
}
}
var columnsList = new List <PageColumn>();
if (request["clist"] != null)
{
JArray clist = JsonConvert.DeserializeObject <dynamic>(Convert.ToString(request["clist"].ToString()));
foreach (var k in clist)
{
columnsList.Add(new PageColumn()
{
field = k["field"].ToString(), title = k["title"].ToString(), hidden = k["hidden"].ToString()
});
}
}
return(new ListData()
{
beg = beg,
end = end,
sqls = sqls,
paramter = paramter,
columns = columnsList,
sort = sort,
order = order
});
}
