public string GetChannelList() { common.visitorRecord(); DataTable dt = new DataTable(); try { dt = new Bus.DAL.appkey().GetChannelList().Tables[0]; } catch (Exception ex) { dt.Columns.Add("ErrMessage", typeof(string)); dt.Rows.Add(ex.Message); } return dt.ToJson("Tracks"); }
//验证appkey值 private static bool verifyKey(string appkey) { try { DataTable dt = null; if (HttpRuntime.Cache["keymap"] == null) { dt = new Bus.DAL.appkey().GetList("app_status=1").Tables[0]; string dbpath = HttpContext.Current.Server.MapPath("~/app_data/bus_api.sqlite"); HttpRuntime.Cache.Insert("keymap", dt, new System.Web.Caching.CacheDependency(dbpath), System.Web.Caching.Cache.NoAbsoluteExpiration, System.Web.Caching.Cache.NoSlidingExpiration); } else { dt = HttpRuntime.Cache["keymap"] as DataTable; } if (dt.Rows.Count < 1) return false; DataRow[] drs = dt.Select("app_key='" + appkey + "'"); if (drs.Count() < 1) return false; else return true; } catch(Exception ex) { log.error("验证授权key失败", ex.Message, "appkey=" + appkey); return false; } }
public static int visitorRecord(string appkey) { HttpRequest request = HttpContext.Current.Request; Bus.Model.Vistor model = new Bus.Model.Vistor(); model.ip = request.UserHostAddress; model.ref_url = request.UrlReferrer == null ? "direct access" : request.UrlReferrer.ToString(); model.time = DateTime.Now; model.UA = request.UserAgent; model.url = request.Url.ToString(); model.appkey = appkey; int r = new Bus.DAL.appkey().record(model); return r; }
protected void channelid_Click(object sender, EventArgs e) { DataTable dt = new Bus.DAL.appkey().GetChannelList().Tables[0]; gv.DataSource = dt; gv.DataBind(); txtresult.Text = new musics().GetChannelList(); }
//appkey protected void Button11_Click(object sender, EventArgs e) { try { Bus.Model.AppKey m = new Bus.Model.AppKey(); m.app_key = Guid.NewGuid().ToString(); m.app_owner = "walker"; m.app_url = "bus.fm"; m.app_usage = "test"; int s = new Bus.DAL.appkey().Add(m); lblmsg.Text = s + "位用户被添加"+m.app_key; s += DBHelper.SQLiteHelper.ExecuteNonQuery("select count(*) from appkey where app_key=@appkey", m.app_key); lblmsg.Text = s + ""; s = new Bus.DAL.appkey().Delete(m.app_key); lblmsg.Text += "<br/>" + s + "位用户被删除"+m.app_key; } catch (Exception ex) { lblmsg.Text = ex.Message; } }
//guid protected void Button10_Click(object sender, EventArgs e) { try { DataTable dt = new Bus.DAL.appkey().GetList("app_status=3").Tables[0]; lblmsg.Text = "done"; } catch (Exception ex) { lblmsg.Text = ex.Message; } }