/// <summary> /// 根据主键值更新记录的全部字段(注意:该方法不会对自增字段、timestamp类型字段以及主键字段更新!如果要更新主键字段,请使用Update方法)。 /// 如果数据库有数据被更新了则返回True,否则返回False /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="weChatResult">待更新的实体对象</param> public int UpdateWeChatResult(WeChatResultEntity entity) { string sql = @" UPDATE dbo.[WeChatResult] SET [appid]=@Appid,[bank_type]=@BankType,[cash_fee]=@CashFee,[fee_type]=@FeeType,[is_subscribe]=@IsSubscribe,[mch_id]=@MchId,[nonce_str]=@NonceStr,[openid]=@Openid,[out_trade_no]=@OutTradeNo,[result_code]=@ResultCode,[return_code]=@ReturnCode,[sign]=@Sign,[time_end]=@TimeEnd,[total_fee]=@TotalFee,[trade_type]=@TradeType,[transaction_id]=@TransactionId,[CreateTime]=@CreateTime WHERE [Id]=@id"; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@Id", DbType.Int32, entity.Id); db.AddInParameter(cmd, "@Appid", DbType.String, entity.Appid); db.AddInParameter(cmd, "@BankType", DbType.String, entity.Bank_type); db.AddInParameter(cmd, "@CashFee", DbType.String, entity.Cash_fee); db.AddInParameter(cmd, "@FeeType", DbType.String, entity.Fee_type); db.AddInParameter(cmd, "@IsSubscribe", DbType.String, entity.Is_subscribe); db.AddInParameter(cmd, "@MchId", DbType.String, entity.Mch_id); db.AddInParameter(cmd, "@NonceStr", DbType.String, entity.Nonce_str); db.AddInParameter(cmd, "@Openid", DbType.String, entity.Openid); db.AddInParameter(cmd, "@OutTradeNo", DbType.String, entity.Out_trade_no); db.AddInParameter(cmd, "@ResultCode", DbType.String, entity.Result_code); db.AddInParameter(cmd, "@ReturnCode", DbType.String, entity.Return_code); db.AddInParameter(cmd, "@Sign", DbType.String, entity.Sign); db.AddInParameter(cmd, "@TimeEnd", DbType.String, entity.Time_end); db.AddInParameter(cmd, "@TotalFee", DbType.String, entity.Total_fee); db.AddInParameter(cmd, "@TradeType", DbType.String, entity.Trade_type); db.AddInParameter(cmd, "@TransactionId", DbType.String, entity.Transaction_id); db.AddInParameter(cmd, "@CreateTime", DbType.DateTime, entity.CreateTime); return(db.ExecuteNonQuery(cmd)); }
/// <summary> /// 插入一条记录到表WeChatResult,如果表中存在自增字段,则返回值为新记录的自增字段值,否则返回0 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="weChatResult">待插入的实体对象</param> public int AddWeChatResult(WeChatResultEntity entity) { string sql = @"insert into WeChatResult( [appid],[bank_type],[cash_fee],[fee_type],[is_subscribe],[mch_id],[nonce_str],[openid],[out_trade_no],[result_code],[return_code],[sign],[time_end],[total_fee],[trade_type],[transaction_id],[CreateTime])VALUES ( @Appid,@BankType,@CashFee,@FeeType,@IsSubscribe,@MchId,@NonceStr,@Openid,@OutTradeNo,@ResultCode,@ReturnCode,@Sign,@TimeEnd,@TotalFee,@TradeType,@TransactionId,@CreateTime); SELECT SCOPE_IDENTITY();" ; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@Appid", DbType.String, entity.Appid); db.AddInParameter(cmd, "@BankType", DbType.String, entity.Bank_type); db.AddInParameter(cmd, "@CashFee", DbType.String, entity.Cash_fee); db.AddInParameter(cmd, "@FeeType", DbType.String, entity.Fee_type); db.AddInParameter(cmd, "@IsSubscribe", DbType.String, entity.Is_subscribe); db.AddInParameter(cmd, "@MchId", DbType.String, entity.Mch_id); db.AddInParameter(cmd, "@NonceStr", DbType.String, entity.Nonce_str); db.AddInParameter(cmd, "@Openid", DbType.String, entity.Openid); db.AddInParameter(cmd, "@OutTradeNo", DbType.String, entity.Out_trade_no); db.AddInParameter(cmd, "@ResultCode", DbType.String, entity.Result_code); db.AddInParameter(cmd, "@ReturnCode", DbType.String, entity.Return_code); db.AddInParameter(cmd, "@Sign", DbType.String, entity.Sign); db.AddInParameter(cmd, "@TimeEnd", DbType.String, entity.Time_end); db.AddInParameter(cmd, "@TotalFee", DbType.String, entity.Total_fee); db.AddInParameter(cmd, "@TradeType", DbType.String, entity.Trade_type); db.AddInParameter(cmd, "@TransactionId", DbType.String, entity.Transaction_id); db.AddInParameter(cmd, "@CreateTime", DbType.DateTime, entity.CreateTime); object identity = db.ExecuteScalar(cmd); if (identity == null || identity == DBNull.Value) { return(0); } return(Convert.ToInt32(identity)); }
/// <summary> /// 判断当前节点是否已存在相同的 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int ExistNum(WeChatResultEntity entity) { ///id=0,判断总数,ID>0判断除自己之外的总数 string sql = @"Select count(1) from dbo.[WeChatResult] WITH(NOLOCK) "; string where = "where "; if (entity.Id == 0) { } else { } sql = sql + where; DbCommand cmd = db.GetSqlStringCommand(sql); if (entity.Id > 0) { db.AddInParameter(cmd, "@Id", DbType.Int32, entity.Id); } object identity = db.ExecuteScalar(cmd); if (identity == null || identity == DBNull.Value) { return(0); } return(Convert.ToInt32(identity)); }
/// <summary> /// 读取记录列表。 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="columns">需要返回的列,不提供任何列名时默认将返回所有列</param> public IList <WeChatResultEntity> GetWeChatResultAll() { string sql = @"SELECT [Id],[appid],[bank_type],[cash_fee],[fee_type],[is_subscribe],[mch_id],[nonce_str],[openid],[out_trade_no],[result_code],[return_code],[sign],[time_end],[total_fee],[trade_type],[transaction_id],[CreateTime] from dbo.[WeChatResult] WITH(NOLOCK) "; IList <WeChatResultEntity> entityList = new List <WeChatResultEntity>(); DbCommand cmd = db.GetSqlStringCommand(sql); using (IDataReader reader = db.ExecuteReader(cmd)) { while (reader.Read()) { WeChatResultEntity entity = new WeChatResultEntity(); entity.Id = StringUtils.GetDbInt(reader["Id"]);; entity.Appid = StringUtils.GetDbString(reader["Appid"]);; entity.Bank_type = StringUtils.GetDbString(reader["Bank_type"]);; entity.Cash_fee = StringUtils.GetDbString(reader["Cash_fee"]);; entity.Fee_type = StringUtils.GetDbString(reader["Fee_type"]);; entity.Is_subscribe = StringUtils.GetDbString(reader["Is_subscribe"]);; entity.Mch_id = StringUtils.GetDbString(reader["Mch_id"]);; entity.Nonce_str = StringUtils.GetDbString(reader["Nonce_str"]);; entity.Openid = StringUtils.GetDbString(reader["Openid"]);; entity.Out_trade_no = StringUtils.GetDbString(reader["Out_trade_no"]);; entity.Result_code = StringUtils.GetDbString(reader["Result_code"]);; entity.Return_code = StringUtils.GetDbString(reader["Return_code"]);; entity.Sign = StringUtils.GetDbString(reader["Sign"]);; entity.Time_end = StringUtils.GetDbString(reader["Time_end"]);; entity.Total_fee = StringUtils.GetDbString(reader["Total_fee"]);; entity.Trade_type = StringUtils.GetDbString(reader["Trade_type"]);; entity.Transaction_id = StringUtils.GetDbString(reader["Transaction_id"]);; entity.CreateTime = StringUtils.GetDbDateTime(reader["CreateTime"]);; entityList.Add(entity); } } return(entityList); }
/// <summary> /// 读取记录列表。 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="columns">需要返回的列,不提供任何列名时默认将返回所有列</param> public IList <WeChatResultEntity> GetWeChatResultList(int pagesize, int pageindex, ref int recordCount) { string sql = @"SELECT [Id],[appid],[bank_type],[cash_fee],[fee_type],[is_subscribe],[mch_id],[nonce_str],[openid],[out_trade_no],[result_code],[return_code],[sign],[time_end],[total_fee],[trade_type],[transaction_id],[CreateTime] FROM (SELECT ROW_NUMBER() OVER (ORDER BY Id desc) AS ROWNUMBER, [Id],[appid],[bank_type],[cash_fee],[fee_type],[is_subscribe],[mch_id],[nonce_str],[openid],[out_trade_no],[result_code],[return_code],[sign],[time_end],[total_fee],[trade_type],[transaction_id],[CreateTime] from dbo.[WeChatResult] WITH(NOLOCK) WHERE 1=1 ) as temp where rownumber BETWEEN ((@PageIndex - 1) * @PageSize + 1) AND @PageIndex * @PageSize" ; string sql2 = @"Select count(1) from dbo.[WeChatResult] with (nolock) "; IList <WeChatResultEntity> entityList = new List <WeChatResultEntity>(); DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@PageIndex", DbType.Int32, pageindex); db.AddInParameter(cmd, "@PageSize", DbType.Int32, pagesize); using (IDataReader reader = db.ExecuteReader(cmd)) { while (reader.Read()) { WeChatResultEntity entity = new WeChatResultEntity(); entity.Id = StringUtils.GetDbInt(reader["Id"]);; entity.Appid = StringUtils.GetDbString(reader["Appid"]);; entity.Bank_type = StringUtils.GetDbString(reader["Bank_type"]);; entity.Cash_fee = StringUtils.GetDbString(reader["Cash_fee"]);; entity.Fee_type = StringUtils.GetDbString(reader["Fee_type"]);; entity.Is_subscribe = StringUtils.GetDbString(reader["Is_subscribe"]);; entity.Mch_id = StringUtils.GetDbString(reader["Mch_id"]);; entity.Nonce_str = StringUtils.GetDbString(reader["Nonce_str"]);; entity.Openid = StringUtils.GetDbString(reader["Openid"]);; entity.Out_trade_no = StringUtils.GetDbString(reader["Out_trade_no"]);; entity.Result_code = StringUtils.GetDbString(reader["Result_code"]);; entity.Return_code = StringUtils.GetDbString(reader["Return_code"]);; entity.Sign = StringUtils.GetDbString(reader["Sign"]);; entity.Time_end = StringUtils.GetDbString(reader["Time_end"]);; entity.Total_fee = StringUtils.GetDbString(reader["Total_fee"]);; entity.Trade_type = StringUtils.GetDbString(reader["Trade_type"]);; entity.Transaction_id = StringUtils.GetDbString(reader["Transaction_id"]);; entity.CreateTime = StringUtils.GetDbDateTime(reader["CreateTime"]);; entityList.Add(entity); } } cmd = db.GetSqlStringCommand(sql2); using (IDataReader reader = db.ExecuteReader(cmd)) { if (reader.Read()) { recordCount = StringUtils.GetDbInt(reader[0]); } else { recordCount = 0; } } return(entityList); }
/// <summary> /// 根据主键值读取记录。如果数据库不存在这条数据将返回null /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="columns">需要返回的列,不提供任何列名时默认将返回所有列</param> public WeChatResultEntity GetWeChatResult(int id) { string sql = @"SELECT [Id],[appid],[bank_type],[cash_fee],[fee_type],[is_subscribe],[mch_id],[nonce_str],[openid],[out_trade_no],[result_code],[return_code],[sign],[time_end],[total_fee],[trade_type],[transaction_id],[CreateTime] FROM dbo.[WeChatResult] WITH(NOLOCK) WHERE [Id]=@id" ; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@Id", DbType.Int32, id); WeChatResultEntity entity = new WeChatResultEntity(); using (IDataReader reader = db.ExecuteReader(cmd)) { if (reader.Read()) { entity.Id = StringUtils.GetDbInt(reader["Id"]);; entity.Appid = StringUtils.GetDbString(reader["Appid"]);; entity.Bank_type = StringUtils.GetDbString(reader["Bank_type"]);; entity.Cash_fee = StringUtils.GetDbString(reader["Cash_fee"]);; entity.Fee_type = StringUtils.GetDbString(reader["Fee_type"]);; entity.Is_subscribe = StringUtils.GetDbString(reader["Is_subscribe"]);; entity.Mch_id = StringUtils.GetDbString(reader["Mch_id"]);; entity.Nonce_str = StringUtils.GetDbString(reader["Nonce_str"]);; entity.Openid = StringUtils.GetDbString(reader["Openid"]);; entity.Out_trade_no = StringUtils.GetDbString(reader["Out_trade_no"]);; entity.Result_code = StringUtils.GetDbString(reader["Result_code"]);; entity.Return_code = StringUtils.GetDbString(reader["Return_code"]);; entity.Sign = StringUtils.GetDbString(reader["Sign"]);; entity.Time_end = StringUtils.GetDbString(reader["Time_end"]);; entity.Total_fee = StringUtils.GetDbString(reader["Total_fee"]);; entity.Trade_type = StringUtils.GetDbString(reader["Trade_type"]);; entity.Transaction_id = StringUtils.GetDbString(reader["Transaction_id"]);; entity.CreateTime = StringUtils.GetDbDateTime(reader["CreateTime"]);; } } return(entity); }
/// <summary> /// 更新一条WeChatResult记录。 /// 该方法提供给界面等UI层调用 /// </summary> /// <param name="weChatResult">待更新的实体对象</param> /// <param name="columns">要更新的列名,不提供任何列名时默认将更新主键之外的所有列</param> public int UpdateWeChatResult(WeChatResultEntity weChatResult) { return(WeChatResultDA.Instance.UpdateWeChatResult(weChatResult)); }
/// <summary> /// 插入一条记录到表WeChatResult,如果表中存在自增字段,则返回值为新记录的自增字段值,否则返回0。 /// 该方法提供给界面等UI层调用 /// </summary> /// <param name="weChatResult">要添加的WeChatResult数据实体对象</param> public int AddWeChatResult(WeChatResultEntity weChatResult) { return(WeChatResultDA.Instance.AddWeChatResult(weChatResult)); }
/// <summary> /// 判断对象是否存在 /// </summary> /// <param name="dicEnum"></param> /// <returns></returns> public bool IsExist(WeChatResultEntity weChatResult) { return(WeChatResultDA.Instance.ExistNum(weChatResult) > 0); }