/// <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);
}