protected void Page_Load(object sender, EventArgs e)
{
//刚开始判断一下session，如果过期了就退出了，重新登录
if (Session["login"] == null)
{
MessageBox.Show("登录已过期");
Response.Redirect("Login.aspx");
}
CheckOtherLogin();
//如果没有过期就显示出来登录的用户名
if (!Page.IsPostBack)
{
//因为无法级联查询，所以只能这种方式
string roleid = (string)Session["roleid"];
string envid = ConfigurationManager.AppSettings["envid"];
string queryString = "{\"env\":\"" + envid + "\", \"query\": \"db.collection(\\\"role_func\\\").where({roleid:\\\"" + roleid + "\\\"}).limit(10).get()\"}";
string access_token = (string)Session["access_token"];
string url = "https://api.weixin.qq.com/tcb/databasequery?access_token=" + access_token; //POST到网站
string Message = OperateCloud.Query(queryString, url);
JObject jo = OperateCloud.GetJson(Message);
int length = int.Parse(jo["pager"]["Total"].ToString());
//MessageBox.Show(length+"");
//this.TreeView1.ShowLines = true;//在控件中显示网格线
for (int i = 0; i < length; i++)
{
string temp = jo["data"][i].ToString(); //data里面第一个列表里面的json数据
JObject jo1 = OperateCloud.GetJson(temp);
TreeNode rootNode = new TreeNode(); //定义根节点
//获得了funcid之后，从function数据库中取出功能名称
string funcid = jo1["funcid"].ToString();
queryString = "{\"env\":\"" + envid + "\", \"query\": \"db.collection(\\\"func\\\").where({id:\\\"" + funcid + "\\\"}).limit(10).get()\"}";
url = "https://api.weixin.qq.com/tcb/databasequery?access_token=" + access_token; //POST到网站
Message = OperateCloud.Query(queryString, url);
JObject jo2 = OperateCloud.GetJson(Message);
string function = jo2["data"][0].ToString();//data里面第一个列表里面的json数据
JObject jo22 = OperateCloud.GetJson(function);
rootNode.Text = jo22["func"].ToString();
//MessageBox.Show(jo22["func"].ToString());
//成功取出
rootNode.NavigateUrl = "~/" + jo22["func"].ToString() + ".aspx";
//rootNode.ChildNodes.Add(tr1);//把子节点添加到根节点
TreeView1.Nodes.Add(rootNode); //把根节点添加到TreeView控件中
}
TreeNode rootNode1 = new TreeNode(); //定义根节点
rootNode1.Text = "返回首页";
rootNode1.NavigateUrl = "~/Search.aspx";
TreeView1.Nodes.Add(rootNode1);//把根节点添加到TreeView控件中
showPersonInfo();
}
}
public void GetBook(string name)
{
string envid = ConfigurationManager.AppSettings["envid"];
int booknum = int.Parse(ConfigurationManager.AppSettings["booknum"]);
//string name = Request.QueryString["BookName"];
int skip = booknum * ((int)Session["CurrentPage"] - 1);
string queryString = "";
if (name == "")
{
queryString = "{\"env\":\"" + envid + "\", \"query\": \"db.collection(\\\"library\\\").where({}).limit(" + booknum + ").skip(" + skip + ").get()\"}";
}
else
{
queryString = "{\"env\":\"" + envid + "\", \"query\": \"db.collection(\\\"library\\\").where({name:db.RegExp({regexp:\\\"" + name + "\\\" ,option:\\\"i\\\"})}).limit(" + booknum + ").skip(" + skip + ").get()\"}";
}
//access_token
//MessageBox.Show(queryString);
string access_token = (string)Session["access_token"];
string url = "https://api.weixin.qq.com/tcb/databasequery?access_token=" + access_token; //POST到网站
string Message = OperateCloud.Query(queryString, url);
JObject jo = OperateCloud.GetJson(Message);
//MessageBox.Show("errcode:" + jo["errcode"].ToString());
int limit = int.Parse(jo["pager"]["Limit"].ToString());
int total = int.Parse(jo["pager"]["Total"].ToString());
//MessageBox.Show("total"+total+"limit"+limit);
if (total % booknum != 0)
{
Session["Count"] = total / booknum + 1;
count.Text = Session["Count"] + "";
}
else
{
Session["Count"] = total / booknum;
count.Text = Session["Count"] + "";
}
//MessageBox.Show("count:"+Session["Count"]);
//List<string> filelist = new List<string>();
int loop = 0;
if (limit < total - skip)
{
loop = limit;
}
else
{
loop = total - skip;
}
for (int i = 0; i < loop; i++)
{
string temp = jo["data"][i].ToString();
JObject jo1 = OperateCloud.GetJson(temp);
//MessageBox.Show(jo1["name"].ToString());
queryString = "{\"env\":\"" + envid + "\", \"file_list\": [{\"fileid\":\"" + jo1["fileIDs"][0].ToString() + "\",\"max_age\":7200}]}";
//access_token
url = "https://api.weixin.qq.com/tcb/batchdownloadfile?access_token=" + access_token; //POST到网站
Message = OperateCloud.Query(queryString, url);
JObject jo2 = OperateCloud.GetJson(Message);
int errorcode = int.Parse(jo2["errcode"].ToString());
if (errorcode == 0)
{
/*MessageBox.Show("获取图片成功");
* MessageBox.Show(jo2["file_list"][0]["download_url"].ToString());*/
TableRow row = new TableRow();
TableCell cell3 = new TableCell();
cell3.Text = "<p style='width:100px;padding-left:30px' class='overline'>" + jo1["remain"].ToString() + "</ p>";
row.Cells.Add(cell3);
TableCell cell1 = new TableCell();
cell1.Text = "<p style='width:100px;padding:10px' class='overline'>" + jo1["name"].ToString() + "</ p>";
row.Cells.Add(cell1);
TableCell cell0 = new TableCell();
cell0.Text = "<img style='width:120px;height:160px' src='" + jo2["file_list"][0]["download_url"].ToString() + "'/>";
row.Cells.Add(cell0);
TableCell cell6 = new TableCell();
cell6.Text = "<p style='width:500px;padding:40px' class='overline'>" + jo1["description"].ToString() + "</ p>";
row.Cells.Add(cell6);
TableCell cell2 = new TableCell();
cell2.Text = "<p style='width:200px;padding:10px' class='overline'>" + jo1["author"].ToString() + "</ p>";
row.Cells.Add(cell2);
TableCell cell4 = new TableCell();
cell4.Text = "<p style='width:100px;padding:10px' class='overline'>" + jo1["library"].ToString() + "</ p>";
row.Cells.Add(cell4);
TableCell cell5 = new TableCell();
cell5.Text = "<p style='width:100px;padding:10px' class='overline'>" + jo1["place"].ToString() + ":" + jo1["label"].ToString() + "</ p>";
row.Cells.Add(cell5);
MyTable.Rows.Add(row);
}
}
/*foreach(string i in filelist)
* {
* MessageBox.Show(i);
* }*/
}
