/// <summary> /// 由一行数据得到一个实体 /// </summary> private Hi.Model.Pay_PayWxandAli GetModel(DataRow r) { Hi.Model.Pay_PayWxandAli model = new Hi.Model.Pay_PayWxandAli(); model.ID = SqlHelper.GetInt(r["ID"]); model.CompID = SqlHelper.GetInt(r["CompID"]); model.wx_appid = SqlHelper.GetString(r["wx_appid"]); model.wx_mchid = SqlHelper.GetString(r["wx_mchid"]); model.wx_key = SqlHelper.GetString(r["wx_key"]); model.wx_appsechet = SqlHelper.GetString(r["wx_appsechet"]); model.wx_Isno = SqlHelper.GetString(r["wx_Isno"]); model.wx_vdef2 = SqlHelper.GetString(r["wx_vdef2"]); model.wx_vdef3 = SqlHelper.GetString(r["wx_vdef3"]); model.ali_partner = SqlHelper.GetString(r["ali_partner"]); model.ali_key = SqlHelper.GetString(r["ali_key"]); model.ali_seller_email = SqlHelper.GetString(r["ali_seller_email"]); model.ali_isno = SqlHelper.GetString(r["ali_isno"]); model.ali_vdef2 = SqlHelper.GetString(r["ali_vdef2"]); model.ali_vdef3 = SqlHelper.GetString(r["ali_vdef3"]); model.ali_RSAkey = SqlHelper.GetString(r["ali_RSAkey"]); return(model); }
static Config() { //↓↓↓↓↓↓↓↓↓↓请在这里配置您的基本信息↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓ //合作身份者ID,以2088开头由16位纯数字组成的字符串 //partner = "2088811467352658"; Hi.Model.Pay_PayWxandAli model = Common.GetPayWxandAli(0); partner = model.ali_partner; // ConfigurationManager.AppSettings["partner"] == null ? "2088811467352658" : ConfigurationManager.AppSettings["partner"].ToString().Trim(); //交易安全检验码,由数字和字母组成的32位字符串 key = model.ali_key;// ConfigurationManager.AppSettings["PayKey"] == null ? "g3sxskbx8udfcwnjl9rzmonny6bsas9r" : ConfigurationManager.AppSettings["PayKey"].ToString().Trim(); //↑↑↑↑↑↑↑↑↑↑请在这里配置您的基本信息↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑ //字符编码格式 目前支持 gbk 或 utf-8 input_charset = "utf-8"; //签名方式,选择项:RSA、DSA、MD5 sign_type = "MD5"; }
static Config() { //↓↓↓↓↓↓↓↓↓↓请在这里配置您的基本信息↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓ //合作身份者ID,以2088开头由16位纯数字组成的字符串 //partner = "2088811467352658"; Hi.Model.Pay_PayWxandAli model = Common.GetPayWxandAli(1046); partner = model.ali_partner; // ConfigurationManager.AppSettings["partner"] == null ? "2088811467352658" : ConfigurationManager.AppSettings["partner"].ToString().Trim(); //交易安全检验码,由数字和字母组成的32位字符串 //key = model.ali_key;// ConfigurationManager.AppSettings["PayKey"] == null ? "g3sxskbx8udfcwnjl9rzmonny6bsas9r" : ConfigurationManager.AppSettings["PayKey"].ToString().Trim(); //key = "MIICdwIBADANBgkqhkiG9w0BAQEFAASCAmEwggJdAgEAAoGBANDptrV3pWWdbnr6wT8lPkZ6kbRgsjf8CfXpQNrJyOsmktOaX8DQRh5nd0lSFTtbfeGV4oWXi26bv+1Vt+CfAsYssf+futRj0l6Cxx0psJapK7QEXq3HqjB0tM11M9ym75WFFvTSZs1DysUkRV35g5rXuRtBOWR2sqm9JRAen+29AgMBAAECgYEAzZ+L1xb5c4e960uOE1Hb9tDDQs/9+j6XqzQ3QmFj4Zeo4p9KaeRVb62U6lThUvgdcYDuYWEkuuyPvtEk1/CKb61AvEW69ehwLeDXOy9AzEgQpGFPb1bgJ+kU8YCpgcOGR9G55iVc0ZW7B2iyx111Wvij8pc+A2ZeuByAG1f8PoECQQD7wvCyBJRNb7Gv7iHF+zx2lDxG6LTX2rCAZdr8FyWVjZEBfL6uPI+/2J2AqtFPaLa25+jQc3b74r4wuGKsvxBhAkEA1G4aDQovfB9RO/c4I+NX4mmitpNt66IuqKp0a9pOL/YfpNtr5GBgmK4LMVASqIG74bw5wAV7zJkunlGGPusK3QJBALLiUm/KvS1AXbqpsymfV9jRfvrLQiPVaW/x72ULdVMMIaoy3rGiqmkgGtlfhhWsS5cutMfYIwTamVS4zrP7lkECQFTvDJVoHCI5d0ZNivG2ZR4OdFMhURKkTpl7RX8V0qsUcgR9An9WFWkWNT1rMXqUHGWd100yJBRirqP4Hn+rhDUCQBPVgm4jNd5WjKD0Oj39FmF5D89OviTgQK4xYxYUIfqLBhuGZ3kWDvAmeE6uRgVXjQncv/c68W8pS2huT0syom4="; key = "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCnxj/9qwVfgoUh/y2W89L6BkRAFljhNhgPdyPuBV64bfQNN1PjbCzkIM6qRdKBoLPXmKKMiFYnkd6rAoprih3/PrQEB/VsW8OoM8fxn67UDYuyBTqA23MML9q1+ilIZwBC2AQ2UBVOrFXfFl75p6/B5KsiNG9zpgmLCUYuLkxpLQIDAQAB"; //↑↑↑↑↑↑↑↑↑↑请在这里配置您的基本信息↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑ //字符编码格式 目前支持 gbk 或 utf-8 input_charset = "utf-8"; //签名方式,选择项:RSA、DSA、MD5 sign_type = "RSA"; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hi.Model.Pay_PayWxandAli model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [Pay_PayWxandAli]("); strSql.Append("[CompID],[wx_appid],[wx_mchid],[wx_key],[wx_appsechet],[wx_Isno],[wx_vdef2],[wx_vdef3],[ali_partner],[ali_key],[ali_seller_email],[ali_isno],[ali_vdef2],[ali_vdef3],[ali_RSAkey])"); strSql.Append(" values ("); strSql.Append("@CompID,@wx_appid,@wx_mchid,@wx_key,@wx_appsechet,@wx_Isno,@wx_vdef2,@wx_vdef3,@ali_partner,@ali_key,@ali_seller_email,@ali_isno,@ali_vdef2,@ali_vdef3,@ali_RSAkey)"); strSql.Append(";select @@Identity"); SqlParameter[] parameters = { new SqlParameter("@CompID", SqlDbType.BigInt), new SqlParameter("@wx_appid", SqlDbType.NVarChar, 50), new SqlParameter("@wx_mchid", SqlDbType.NVarChar, 50), new SqlParameter("@wx_key", SqlDbType.NVarChar, 50), new SqlParameter("@wx_appsechet", SqlDbType.NVarChar, 50), new SqlParameter("@wx_Isno", SqlDbType.NVarChar, 50), new SqlParameter("@wx_vdef2", SqlDbType.NVarChar, 50), new SqlParameter("@wx_vdef3", SqlDbType.NVarChar, 50), new SqlParameter("@ali_partner", SqlDbType.NVarChar, 50), new SqlParameter("@ali_key", SqlDbType.NVarChar, 50), new SqlParameter("@ali_seller_email", SqlDbType.NVarChar, 50), new SqlParameter("@ali_isno", SqlDbType.NVarChar, 50), new SqlParameter("@ali_vdef2", SqlDbType.NVarChar, 50), new SqlParameter("@ali_vdef3", SqlDbType.NVarChar, 50), new SqlParameter("@ali_RSAkey", SqlDbType.NVarChar, 300) }; parameters[0].Value = model.CompID; if (model.wx_appid != null) { parameters[1].Value = model.wx_appid; } else { parameters[1].Value = DBNull.Value; } if (model.wx_mchid != null) { parameters[2].Value = model.wx_mchid; } else { parameters[2].Value = DBNull.Value; } if (model.wx_key != null) { parameters[3].Value = model.wx_key; } else { parameters[3].Value = DBNull.Value; } if (model.wx_appsechet != null) { parameters[4].Value = model.wx_appsechet; } else { parameters[4].Value = DBNull.Value; } if (model.wx_Isno != null) { parameters[5].Value = model.wx_Isno; } else { parameters[5].Value = DBNull.Value; } if (model.wx_vdef2 != null) { parameters[6].Value = model.wx_vdef2; } else { parameters[6].Value = DBNull.Value; } if (model.wx_vdef3 != null) { parameters[7].Value = model.wx_vdef3; } else { parameters[7].Value = DBNull.Value; } if (model.ali_partner != null) { parameters[8].Value = model.ali_partner; } else { parameters[8].Value = DBNull.Value; } if (model.ali_key != null) { parameters[9].Value = model.ali_key; } else { parameters[9].Value = DBNull.Value; } if (model.ali_seller_email != null) { parameters[10].Value = model.ali_seller_email; } else { parameters[10].Value = DBNull.Value; } if (model.ali_isno != null) { parameters[11].Value = model.ali_isno; } else { parameters[11].Value = DBNull.Value; } if (model.ali_vdef2 != null) { parameters[12].Value = model.ali_vdef2; } else { parameters[12].Value = DBNull.Value; } if (model.ali_vdef3 != null) { parameters[13].Value = model.ali_vdef3; } else { parameters[13].Value = DBNull.Value; } if (model.ali_RSAkey != null) { parameters[14].Value = model.ali_RSAkey; } else { parameters[14].Value = DBNull.Value; } return(SqlHelper.GetInt(SqlHelper.GetSingle(SqlHelper.LocalSqlServer, strSql.ToString(), parameters))); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hi.Model.Pay_PayWxandAli model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [Pay_PayWxandAli] set "); strSql.Append("[CompID]=@CompID,"); strSql.Append("[wx_appid]=@wx_appid,"); strSql.Append("[wx_mchid]=@wx_mchid,"); strSql.Append("[wx_key]=@wx_key,"); strSql.Append("[wx_appsechet]=@wx_appsechet,"); strSql.Append("[wx_Isno]=@wx_Isno,"); strSql.Append("[wx_vdef2]=@wx_vdef2,"); strSql.Append("[wx_vdef3]=@wx_vdef3,"); strSql.Append("[ali_partner]=@ali_partner,"); strSql.Append("[ali_key]=@ali_key,"); strSql.Append("[ali_seller_email]=@ali_seller_email,"); strSql.Append("[ali_isno]=@ali_isno,"); strSql.Append("[ali_vdef2]=@ali_vdef2,"); strSql.Append("[ali_vdef3]=@ali_vdef3,"); strSql.Append("[ali_RSAkey]=@ali_RSAkey"); strSql.Append(" where [ID]=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.BigInt), new SqlParameter("@CompID", SqlDbType.BigInt), new SqlParameter("@wx_appid", SqlDbType.NVarChar, 50), new SqlParameter("@wx_mchid", SqlDbType.NVarChar, 50), new SqlParameter("@wx_key", SqlDbType.NVarChar, 50), new SqlParameter("@wx_appsechet", SqlDbType.NVarChar, 50), new SqlParameter("@wx_Isno", SqlDbType.NVarChar, 50), new SqlParameter("@wx_vdef2", SqlDbType.NVarChar, 50), new SqlParameter("@wx_vdef3", SqlDbType.NVarChar, 50), new SqlParameter("@ali_partner", SqlDbType.NVarChar, 50), new SqlParameter("@ali_key", SqlDbType.NVarChar, 50), new SqlParameter("@ali_seller_email", SqlDbType.NVarChar, 50), new SqlParameter("@ali_isno", SqlDbType.NVarChar, 50), new SqlParameter("@ali_vdef2", SqlDbType.NVarChar, 50), new SqlParameter("@ali_vdef3", SqlDbType.NVarChar, 50), new SqlParameter("@ali_RSAkey", SqlDbType.NVarChar, 300) }; parameters[0].Value = model.ID; parameters[1].Value = model.CompID; if (model.wx_appid != null) { parameters[2].Value = model.wx_appid; } else { parameters[2].Value = DBNull.Value; } if (model.wx_mchid != null) { parameters[3].Value = model.wx_mchid; } else { parameters[3].Value = DBNull.Value; } if (model.wx_key != null) { parameters[4].Value = model.wx_key; } else { parameters[4].Value = DBNull.Value; } if (model.wx_appsechet != null) { parameters[5].Value = model.wx_appsechet; } else { parameters[5].Value = DBNull.Value; } if (model.wx_Isno != null) { parameters[6].Value = model.wx_Isno; } else { parameters[6].Value = DBNull.Value; } if (model.wx_vdef2 != null) { parameters[7].Value = model.wx_vdef2; } else { parameters[7].Value = DBNull.Value; } if (model.wx_vdef3 != null) { parameters[8].Value = model.wx_vdef3; } else { parameters[8].Value = DBNull.Value; } if (model.ali_partner != null) { parameters[9].Value = model.ali_partner; } else { parameters[9].Value = DBNull.Value; } if (model.ali_key != null) { parameters[10].Value = model.ali_key; } else { parameters[10].Value = DBNull.Value; } if (model.ali_seller_email != null) { parameters[11].Value = model.ali_seller_email; } else { parameters[11].Value = DBNull.Value; } if (model.ali_isno != null) { parameters[12].Value = model.ali_isno; } else { parameters[12].Value = DBNull.Value; } if (model.ali_vdef2 != null) { parameters[13].Value = model.ali_vdef2; } else { parameters[13].Value = DBNull.Value; } if (model.ali_vdef3 != null) { parameters[14].Value = model.ali_vdef3; } else { parameters[14].Value = DBNull.Value; } if (model.ali_RSAkey != null) { parameters[15].Value = model.ali_RSAkey; } else { parameters[15].Value = DBNull.Value; } return(SqlHelper.ExecuteSql(SqlHelper.LocalSqlServer, strSql.ToString(), parameters) > 0); }