/// <summary> /// 更新一条数据 /// </summary> public bool Update(WxTokensModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update HQ_WxTokens set "); strSql.Append("Token=@Token,"); strSql.Append("BuildTime=@BuildTime,"); strSql.Append("TypeKey=@TypeKey"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Token", SqlDbType.VarChar, 250), new SqlParameter("@BuildTime", SqlDbType.DateTime), new SqlParameter("@TypeKey", SqlDbType.SmallInt), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.Token; parameters[1].Value = model.BuildTime; parameters[2].Value = model.TypeKey; parameters[3].Value = model.Id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(WxTokensModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into HQ_WxTokens("); strSql.Append("Token,BuildTime,TypeKey)"); strSql.Append(" values ("); strSql.Append("@Token,@BuildTime,@TypeKey)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Token", SqlDbType.VarChar, 250), new SqlParameter("@BuildTime", SqlDbType.DateTime), new SqlParameter("@TypeKey", SqlDbType.SmallInt) }; parameters[0].Value = model.Token; parameters[1].Value = model.BuildTime; parameters[2].Value = model.TypeKey; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WxTokensModel DataRowToModel(DataRow row) { WxTokensModel model = new WxTokensModel(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["Token"] != null) { model.Token = row["Token"].ToString(); } if (row["BuildTime"] != null && row["BuildTime"].ToString() != "") { model.BuildTime = DateTime.Parse(row["BuildTime"].ToString()); } if (row["TypeKey"].ToString() != "") { model.TypeKey = Convert.ToInt16(row["TypeKey"]); } } return(model); }
/// <summary> /// 刷新jsapi_ticket,数据库更新 /// </summary> /// <param name="accessToken"></param> /// <param name="mpInfo"></param> /// <param name="errMsg">错误信息</param> /// <returns></returns> private string RefreshJsApiTicket(string accessToken, WeixinMPInfo mpInfo, out string errMsg) { string ticket = WeixinTokenBuildHelper.BuildJsApiTickets(accessToken, out errMsg); if (ticket == "") { return(""); } //尝试更新,没有就新增 WxTokensModel model = WxTokensBLL.Instance.GetModel((int)HQEnums.WxTokenTypeOptions.Jsticket); if (model == null) { WxTokensBLL.Instance.Add(new WxTokensModel() { BuildTime = DateTime.Now, Token = ticket, TypeKey = (int)HQEnums.WxTokenTypeOptions.Jsticket }); } else { model.Token = ticket; model.BuildTime = DateTime.Now; WxTokensBLL.Instance.Update(model); } return(ticket); }
/// <summary> /// 刷新accessToken,数据库更新 /// </summary> /// <param name="mpInfo">公众账号APPID等信息</param> /// <param name="errMsg">错误信息</param> /// <returns></returns> private string RefreshAccessToken(WeixinMPInfo mpInfo, out string errMsg) { string accessToken = WeixinTokenBuildHelper.BuildAccessToken(mpInfo.AppId, mpInfo.AppSecret, out errMsg); if (accessToken == "") { return(""); } //尝试更新,没有就新增 WxTokensModel model = WxTokensBLL.Instance.GetModel((int)HQEnums.WxTokenTypeOptions.Accesstoken); if (model == null) { WxTokensBLL.Instance.Add(new WxTokensModel() { BuildTime = DateTime.Now, Token = accessToken, TypeKey = (int)HQEnums.WxTokenTypeOptions.Accesstoken }); } else { model.Token = accessToken; model.BuildTime = DateTime.Now; WxTokensBLL.Instance.Update(model); } return(accessToken); }
/// <summary> /// 得到一个对象实体 /// </summary> public WxTokensModel GetModel(int TypeKey) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from HQ_WxTokens "); strSql.Append(" where TypeKey=@TypeKey "); SqlParameter[] parameters = { new SqlParameter("@TypeKey", SqlDbType.Int, 4) }; parameters[0].Value = TypeKey; WxTokensModel model = new WxTokensModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WxTokensModel model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(WxTokensModel model) { return(dal.Add(model)); }