/// <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);
}
