/// <summary> /// createtime expiresetime不用传。 /// </summary> /// <param name="PubConn"></param> /// <param name="model"></param> /// <param name="tokentype"></param> /// <returns></returns> public virtual bool Add(DbConn PubConn, DbModels.tb_token model, Models.DbModels.TokenType tokentype) { DateTime nowtime = PubConn.GetServerDate(); model.createtime = nowtime; model.expires = nowtime.AddMinutes(GetExpiresminutes(tokentype)); List <ProcedureParameter> Par = new List <ProcedureParameter>() { // new ProcedureParameter("@token", model.token), // new ProcedureParameter("@userid", model.userid), new ProcedureParameter("@id", model.id), // new ProcedureParameter("@username", model.username), // new ProcedureParameter("@appid", model.appid), // new ProcedureParameter("@createtime", model.createtime), // new ProcedureParameter("@expires", model.expires) }; int rev = PubConn.ExecuteSql("insert into " + tokentype.ToString() + " (token,userid,id,username,appid,createtime,expires)" + " values(@token,@userid,@id,@username,@appid,@createtime,@expires)", Par); return(rev == 1); }
// // GET: /Toekn/ public ActionResult Index(int pno = 1, string keywords = "", Models.DbModels.TokenType tokentype = Models.DbModels.TokenType.usertoken) { using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn()) { PubConn.Open(); int pagesize = 10; int totalcount = 0; List <Models.DbModels.tb_token> listtoken = Models.TokenDal.Instance.GetByPage(PubConn, pno, pagesize, keywords, tokentype, out totalcount); Webdiyer.WebControls.Mvc.PagedList <Models.DbModels.tb_token> pager = new Webdiyer.WebControls.Mvc.PagedList <Models.DbModels.tb_token>(listtoken, pno, pagesize, totalcount); if (Request.IsAjaxRequest()) { return(PartialView("List", pager)); } return(View(pager)); } }
public JsonResult deletetoken(string id, Models.DbModels.TokenType tokentype) { using (XXF.Db.DbConn PubConn = XXF.Db.DbConfig.CreateConn()) { PubConn.Open(); bool r = Models.TokenDal.Instance.Delete(PubConn, id, tokentype); Models.DbModels.certcenterlog log = new Models.DbModels.certcenterlog(this); log.opecontent = "删除token。tokentype=" + tokentype.ToString() + " result=" + r; Models.CertCenterLogDal.Instance.Add(PubConn, log); if (r) { return(Json(new { code = 1 })); } else { return(Json(new { code = -905, msg = "删除失败,token不存在或存已被删除。" })); } } }
/// <summary> 得到过期时间 </summary> /// <param name="tokentype"></param> /// <returns></returns> public int GetExpiresminutes(Models.DbModels.TokenType tokentype) { int minute = 60; string stringminutes = ""; switch (tokentype) { case CertCenter.Models.DbModels.TokenType.usertoken: stringminutes = XXF.Db.DbConfig.GetConfig("UserTokenExpires"); if (string.IsNullOrEmpty(stringminutes)) { return(2000); } minute = Convert.ToInt32(stringminutes); break; case CertCenter.Models.DbModels.TokenType.shoptoken: stringminutes = XXF.Db.DbConfig.GetConfig("ShopTokenExpires"); if (string.IsNullOrEmpty(stringminutes)) { return(1000); } minute = Convert.ToInt32(stringminutes); break; case CertCenter.Models.DbModels.TokenType.managetoken: stringminutes = XXF.Db.DbConfig.GetConfig("ManageTokenExpires"); if (string.IsNullOrEmpty(stringminutes)) { return(60); } minute = Convert.ToInt32(stringminutes); break; default: break; } return(minute); }