DAL/MyChatPayOnLineService.cs

（开头部分） 18KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;

namespace DAL
{
	/// <summary>
	/// 数据访问类:MyChatPayOnLineService
	/// </summary>
	public partial class MyChatPayOnLineService
	{
		public MyChatPayOnLineService()
		{}
		#region  BasicMethod
		/// <summary>
		/// 是否存在该记录
		/// </summary>
        public static bool Exists(Model.MyChatPayOnLine model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select count(1) from MyChatPayOnLine");
            strSql.Append(" where out_trade_no=@out_trade_no");
			SqlParameter[] parameters = {
					new SqlParameter("@out_trade_no", SqlDbType.VarChar,154)
			};
            parameters[0].Value = model.out_trade_no;

			return DBHelperSQL.Exists(strSql.ToString(),parameters);
		}


		/// <summary>
		/// 增加一条数据
		/// </summary>
        public static int Add(Model.MyChatPayOnLine model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("insert into MyChatPayOnLine(");
			strSql.Append("typeId,typeName,appid,mch_id,device_info,nonce_str,sign,result_code,err_code,err_code_des,openid,is_subscribe,trade_type,bank_type,total_fee,settlement_total_fee,fee_type,cash_fee,cash_fee_type,coupon_fee,coupon_count,transaction_id,out_trade_no,attach,time_end,status,remark,addTime,addUser,infoType)");
			strSql.Append(" values (");
			strSql.Append("@typeId,@typeName,@appid,@mch_id,@device_info,@nonce_str,@sign,@result_code,@err_code,@err_code_des,@openid,@is_subscribe,@trade_type,@bank_type,@total_fee,@settlement_total_fee,@fee_type,@cash_fee,@cash_fee_type,@coupon_fee,@coupon_count,@transaction_id,@out_trade_no,@attach,@time_end,@status,@remark,@addTime,@addUser,@infoType)");
			strSql.Append(";select @@IDENTITY");
			SqlParameter[] parameters = {
					new SqlParameter("@typeId", SqlDbType.Int,4),
					new SqlParameter("@typeName", SqlDbType.VarChar,150),
					new SqlParameter("@appid", SqlDbType.VarChar,150),
					new SqlParameter("@mch_id", SqlDbType.VarChar,150),
					new SqlParameter("@device_info", SqlDbType.VarChar,150),
					new SqlParameter("@nonce_str", SqlDbType.VarChar,150),
					new SqlParameter("@sign", SqlDbType.VarChar,150),
					new SqlParameter("@result_code", SqlDbType.VarChar,150),
					new SqlParameter("@err_code", SqlDbType.VarChar,150),
					new SqlParameter("@err_code_des", SqlDbType.VarChar,150),
					new SqlParameter("@openid", SqlDbType.VarChar,150),
					new SqlParameter("@is_subscribe", SqlDbType.VarChar,150),
					new SqlParameter("@trade_type", SqlDbType.VarChar,150),
					new SqlParameter("@bank_type", SqlDbType.VarChar,150),
					new SqlParameter("@total_fee", SqlDbType.VarChar,150),
					new SqlParameter("@settlement_total_fee", SqlDbType.VarChar,150),
后面还有 490 行代码，解锁后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。