//通过POST只能获取1个对象，因此POST多个数据需要使用类
public HttpResponseMessage Lang([FromBody] LangAjax langajax)
{
Db db = new Db();
string sql = "SELECT XU_HAO, WEN_ZI FROM GDMS_LANG WHERE YE_MIAN_MING = '" + langajax.pageName + "' AND YU_ZHONG = '" + langajax.lang + "' order by XU_HAO";
var ds = db.QueryT(sql);
Response res = new Response();
Dictionary <string, string> data = new Dictionary <string, string>();
foreach (DataRow col in ds.Rows)
{
data.Add(col["XU_HAO"].ToString(), col["WEN_ZI"].ToString());
}
res.code = 0;
res.msg = "";
res.data = data;
var resJsonStr = JsonConvert.SerializeObject(res);
HttpResponseMessage resJson = new HttpResponseMessage
{
Content = new StringContent(resJsonStr, Encoding.GetEncoding("UTF-8"), "application/json")
};
return(resJson);
}
public HttpResponseMessage Lang([FromBody] LangAjax langajax)
{
Db db = new Db();
string where = "";
if (langajax.keyword != null && langajax.keyword.Length != 0)
{
where = where + "AND ( XU_HAO LIKE '" + langajax.keyword + "' or WEN_ZI LIKE '" + langajax.keyword + "')";
}
if (langajax.pageId != null)
{
where = where + "AND YE_MIAN_MING = '" + langajax.pageId + "'";
}
string sqlnp = "select * from GDMS_LANG where 1=1 " + where + " order by YE_MIAN_MING,XU_HAO,YU_ZHONG ";
int limit1 = (langajax.page - 1) * langajax.limit + 1;
int limit2 = langajax.page * langajax.limit;
string sql = "SELECT * FROM(SELECT p1.*,ROWNUM rn FROM(" + sqlnp + ")p1)WHERE rn BETWEEN " + limit1 + " AND " + limit2;
var ds = db.QueryT(sql);
Response res = new Response();
ArrayList data = new ArrayList();
foreach (DataRow col in ds.Rows)
{
Dictionary <string, string> dict = new Dictionary <string, string>
{
{ "YE_MIAN_MING", col["YE_MIAN_MING"].ToString() },
{ "XU_HAO", col["XU_HAO"].ToString() },
{ "YU_ZHONG", col["YU_ZHONG"].ToString() },
{ "WEN_ZI", col["WEN_ZI"].ToString() }
};
data.Add(dict);
}
string sql2 = "select count(*) as count from GDMS_LANG where 1=1 " + where;
var ds2 = db.QueryT(sql2);
foreach (DataRow col in ds2.Rows)
{
res.count = col["count"].ToString();
}
res.code = 0;
res.msg = "";
res.data = data;
var resJsonStr = JsonConvert.SerializeObject(res);
HttpResponseMessage resJson = new HttpResponseMessage
{
Content = new StringContent(resJsonStr, Encoding.GetEncoding("UTF-8"), "application/json")
};
return(resJson);
}
