/// <summary> /// 得到一个对象实体 /// </summary> public WxPtInfoModel GetModel(decimal WxPtId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select WxPtId, MerId, WxPtTypeId, YuanShiId, ArticleUrl, ProUrl, TieZiUrl, Invalid, WxPtCode, AccessToken, AccessTokenCreateTime, WxPtName, ReUrl, ReToken, AppId, AppSecret "); strSql.Append(" from CORE.dbo.WxPtInfo "); strSql.Append(" where WxPtId=@WxPtId"); SqlParameter[] parameters = { new SqlParameter("@WxPtId", SqlDbType.Decimal) }; parameters[0].Value = WxPtId; WxPtInfoModel model = new WxPtInfoModel(); DataSet ds = helper.ExecSqlReDs(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["WxPtId"].ToString() != "") { model.WxPtId = decimal.Parse(ds.Tables[0].Rows[0]["WxPtId"].ToString()); } if (ds.Tables[0].Rows[0]["MerId"].ToString() != "") { model.MerId = decimal.Parse(ds.Tables[0].Rows[0]["MerId"].ToString()); } if (ds.Tables[0].Rows[0]["WxPtTypeId"].ToString() != "") { model.WxPtTypeId = int.Parse(ds.Tables[0].Rows[0]["WxPtTypeId"].ToString()); } model.YuanShiId = ds.Tables[0].Rows[0]["YuanShiId"].ToString(); model.ArticleUrl = ds.Tables[0].Rows[0]["ArticleUrl"].ToString(); model.ProUrl = ds.Tables[0].Rows[0]["ProUrl"].ToString(); model.TieZiUrl = ds.Tables[0].Rows[0]["TieZiUrl"].ToString(); if (ds.Tables[0].Rows[0]["Invalid"].ToString() != "") { if ((ds.Tables[0].Rows[0]["Invalid"].ToString() == "1") || (ds.Tables[0].Rows[0]["Invalid"].ToString().ToLower() == "true")) { model.Invalid = true; } else { model.Invalid = false; } } model.WxPtCode = ds.Tables[0].Rows[0]["WxPtCode"].ToString(); model.AccessToken = ds.Tables[0].Rows[0]["AccessToken"].ToString(); if (ds.Tables[0].Rows[0]["AccessTokenCreateTime"].ToString() != "") { model.AccessTokenCreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["AccessTokenCreateTime"].ToString()); } model.WxPtName = ds.Tables[0].Rows[0]["WxPtName"].ToString(); model.ReUrl = ds.Tables[0].Rows[0]["ReUrl"].ToString(); model.ReToken = ds.Tables[0].Rows[0]["ReToken"].ToString(); model.AppId = ds.Tables[0].Rows[0]["AppId"].ToString(); model.AppSecret = ds.Tables[0].Rows[0]["AppSecret"].ToString(); return(model); } else { return(model); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(WxPtInfoModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CORE.dbo.WxPtInfo ("); strSql.Append("MerId,WxPtTypeId,YuanShiId,ArticleUrl,ProUrl,TieZiUrl,Invalid,WxPtCode,AccessToken,AccessTokenCreateTime,WxPtName,ReUrl,ReToken,AppId,AppSecret"); strSql.Append(") values ("); strSql.Append("@MerId,@WxPtTypeId,@YuanShiId,@ArticleUrl,@ProUrl,@TieZiUrl,@Invalid,@WxPtCode,@AccessToken,@AccessTokenCreateTime,@WxPtName,@ReUrl,@ReToken,@AppId,@AppSecret"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MerId", SqlDbType.Decimal, 9), new SqlParameter("@WxPtTypeId", SqlDbType.Int, 4), new SqlParameter("@YuanShiId", SqlDbType.VarChar, 50), new SqlParameter("@ArticleUrl", SqlDbType.VarChar, 250), new SqlParameter("@ProUrl", SqlDbType.VarChar, 250), new SqlParameter("@TieZiUrl", SqlDbType.VarChar, 250), new SqlParameter("@Invalid", SqlDbType.Bit, 1), new SqlParameter("@WxPtCode", SqlDbType.VarChar, 50), new SqlParameter("@AccessToken", SqlDbType.VarChar, 200), new SqlParameter("@AccessTokenCreateTime", SqlDbType.DateTime), new SqlParameter("@WxPtName", SqlDbType.NChar, 10), new SqlParameter("@ReUrl", SqlDbType.VarChar, 500), new SqlParameter("@ReToken", SqlDbType.VarChar, 50), new SqlParameter("@AppId", SqlDbType.VarChar, 100), new SqlParameter("@AppSecret", SqlDbType.VarChar, 100) }; parameters[0].Value = model.MerId; parameters[1].Value = model.WxPtTypeId; parameters[2].Value = model.YuanShiId; parameters[3].Value = model.ArticleUrl; parameters[4].Value = model.ProUrl; parameters[5].Value = model.TieZiUrl; parameters[6].Value = model.Invalid; parameters[7].Value = model.WxPtCode; parameters[8].Value = model.AccessToken; parameters[9].Value = model.AccessTokenCreateTime; parameters[10].Value = model.WxPtName; parameters[11].Value = model.ReUrl; parameters[12].Value = model.ReToken; parameters[13].Value = model.AppId; parameters[14].Value = model.AppSecret; bool result = false; try { helper.ExecSqlReInt(strSql.ToString(), parameters); result = true; } catch (Exception ex) { this.helper.Close(); throw ex; } finally { } return(result); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WxPtInfoModel model) { bool reValue = true; int reCount = 0; StringBuilder strSql = new StringBuilder(); strSql.Append("update CORE.dbo.WxPtInfo set "); strSql.Append(" MerId = @MerId , "); strSql.Append(" WxPtTypeId = @WxPtTypeId , "); strSql.Append(" YuanShiId = @YuanShiId , "); strSql.Append(" ArticleUrl = @ArticleUrl , "); strSql.Append(" ProUrl = @ProUrl , "); strSql.Append(" TieZiUrl = @TieZiUrl , "); strSql.Append(" Invalid = @Invalid , "); strSql.Append(" WxPtCode = @WxPtCode , "); strSql.Append(" AccessToken = @AccessToken , "); strSql.Append(" AccessTokenCreateTime = @AccessTokenCreateTime , "); strSql.Append(" WxPtName = @WxPtName , "); strSql.Append(" ReUrl = @ReUrl , "); strSql.Append(" ReToken = @ReToken , "); strSql.Append(" AppId = @AppId , "); strSql.Append(" AppSecret = @AppSecret "); strSql.Append(" where WxPtId=@WxPtId "); SqlParameter[] parameters = { new SqlParameter("@WxPtId", SqlDbType.Decimal, 9), new SqlParameter("@MerId", SqlDbType.Decimal, 9), new SqlParameter("@WxPtTypeId", SqlDbType.Int, 4), new SqlParameter("@YuanShiId", SqlDbType.VarChar, 50), new SqlParameter("@ArticleUrl", SqlDbType.VarChar, 250), new SqlParameter("@ProUrl", SqlDbType.VarChar, 250), new SqlParameter("@TieZiUrl", SqlDbType.VarChar, 250), new SqlParameter("@Invalid", SqlDbType.Bit, 1), new SqlParameter("@WxPtCode", SqlDbType.VarChar, 50), new SqlParameter("@AccessToken", SqlDbType.VarChar, 200), new SqlParameter("@AccessTokenCreateTime", SqlDbType.DateTime), new SqlParameter("@WxPtName", SqlDbType.NChar, 10), new SqlParameter("@ReUrl", SqlDbType.VarChar, 500), new SqlParameter("@ReToken", SqlDbType.VarChar, 50), new SqlParameter("@AppId", SqlDbType.VarChar, 100), new SqlParameter("@AppSecret", SqlDbType.VarChar, 100) }; parameters[0].Value = model.WxPtId; parameters[1].Value = model.MerId; parameters[2].Value = model.WxPtTypeId; parameters[3].Value = model.YuanShiId; parameters[4].Value = model.ArticleUrl; parameters[5].Value = model.ProUrl; parameters[6].Value = model.TieZiUrl; parameters[7].Value = model.Invalid; parameters[8].Value = model.WxPtCode; parameters[9].Value = model.AccessToken; parameters[10].Value = model.AccessTokenCreateTime; parameters[11].Value = model.WxPtName; parameters[12].Value = model.ReUrl; parameters[13].Value = model.ReToken; parameters[14].Value = model.AppId; parameters[15].Value = model.AppSecret; try {//异常处理 reCount = this.helper.ExecSqlReInt(strSql.ToString(), parameters); } catch (Exception ex) { this.helper.Close(); throw ex; } if (reCount <= 0) { reValue = false; } return(reValue); }