private void DefaultBind() { string key = new BLL.QuickPay.SecretSecurity().EpayKey; string ExSql = "select configValue from sys_config where configName='TenpayMer_code'"; string AccountID = string.Empty; object objAccid = DAL.DBHelper.ExecuteScalar(ExSql); if (objAccid != DBNull.Value && objAccid != null) { AccountID = objAccid.ToString(); //AccountID = BLL.QuickPay.SecretSecurity.Decrypt3Des24Bit(AccountID, key); } ExSql = "select configValue from sys_config where configName='TenpayMer_key'"; string AccountKey = string.Empty; object objAccKey = DAL.DBHelper.ExecuteScalar(ExSql); if (objAccKey != DBNull.Value && objAccKey != null) { AccountKey = objAccKey.ToString(); //AccountKey = BLL.QuickPay.SecretSecurity.Decrypt3Des24Bit(AccountKey, key); } if (AccountID != "") { lblIDFlag.Text = GetTran("006943", "己设置"); txtAcctId.Text = BLL.QuickPay.SecretSecurity.Decrypt3Des24Bit(AccountID, key); } else { lblIDFlag.Text = GetTran("006944", "未设置"); } if (AccountKey != "") { this.lblKeyFlag.Text = GetTran("006943", "己设置"); txtKey.Text = BLL.QuickPay.SecretSecurity.Decrypt3Des24Bit(AccountKey, key); } else { this.lblKeyFlag.Text = GetTran("006944", "未设置"); } }
protected void btnSubmit_Click(object sender, EventArgs e) { int var = 0; SqlTransaction tran = null; SqlConnection con = DAL.DBHelper.SqlCon(); try { string AccID = this.txtAcctId.Text.Trim(); string Acc = this.txtaccount.Text.Trim(); string accKey = this.txtKey.Text.Trim(); string bgUrl = this.txtBgUrl.Text.Trim(); AccID = BLL.CommonClass.ValidData.InputText(AccID); accKey = BLL.CommonClass.ValidData.InputText(accKey); string key = new BLL.QuickPay.SecretSecurity().EpayKey; if (Acc == "" || AccID == "" || accKey == "") { BLL.CommonClass.Transforms.JSAlert(GetTran("007055", "各项内容均不可为空!")); } if (Acc == "") { BLL.CommonClass.Transforms.JSAlert(GetTran("007933", "请输入盛大通行证帐号")); return; } else { Acc = BLL.QuickPay.SecretSecurity.Encrypt3Des24Bit(Acc, key); } if (AccID == "") { BLL.CommonClass.Transforms.JSAlert(GetTran("007934", "请输入网关商户号")); return; } else { AccID = BLL.QuickPay.SecretSecurity.Encrypt3Des24Bit(AccID, key); } if (accKey == "") { BLL.CommonClass.Transforms.JSAlert(GetTran("007935", "请输入网关证书号")); return; } else { accKey = BLL.QuickPay.SecretSecurity.Encrypt3Des24Bit(accKey, key); } if (bgUrl == "") { BLL.CommonClass.Transforms.JSAlert(GetTran("006682", "请输入服务器通知地址!")); return; } else { bgUrl = BLL.QuickPay.SecretSecurity.Encrypt3Des24Bit(bgUrl, key); } string ExSql = ""; string accountc = "sheng_Account"; string accountColumn = "sheng_AccountID"; string accountKey = "sheng_Key"; string accountBgUrl = "sheng_PageUrl"; string AccDesc = GetTran("007929", "盛大通行证帐号"); string AccIDDesc = GetTran("007936", "盛付通商户号"); string accKeyDesc = GetTran("007937", "盛付通证书号"); string bgUrlDesc = GetTran("007054", "服务器通知地址"); string newCodeStr = string.Empty; string newCode = string.Empty; int inewCode = 0; con.Open(); tran = con.BeginTransaction(); SqlParameter[] spa = null; if (bgUrl != "") { ExSql = "select isnull(count(*),0) as icount from sys_config where configName='" + accountBgUrl + "'"; int exist = int.Parse(DAL.DBHelper.ExecuteScalar(tran, ExSql, CommandType.Text).ToString()); if (exist > 0) { spa = new SqlParameter[] { new SqlParameter("@configValue", SqlDbType.VarChar, 100), new SqlParameter("@configName", SqlDbType.VarChar, 50) }; spa[0].Value = bgUrl; spa[1].Value = accountBgUrl; ExSql = "update sys_config set configValue=@configValue where configName=@configName"; } else { ExSql = "select isnull(max(configCode),0) as configCode from sys_config"; newCodeStr = DAL.DBHelper.ExecuteScalar(tran, ExSql, CommandType.Text).ToString(); inewCode = int.Parse(newCodeStr) + 1; newCode = inewCode.ToString().PadLeft(5, '0'); spa = new SqlParameter[] { new SqlParameter("@configValue", SqlDbType.NVarChar, 100), new SqlParameter("@configName", SqlDbType.NVarChar, 50), new SqlParameter("@configCode", SqlDbType.NVarChar, 5), new SqlParameter("@configDesc", SqlDbType.NVarChar, 200) }; spa[0].Value = bgUrl; spa[1].Value = accountBgUrl; spa[2].Value = newCode; spa[3].Value = bgUrlDesc; ExSql = "insert sys_config(configCode,configName,configValue,configDesc) values(@configCode,@configName,@configValue,@configDesc)"; } var = DAL.DBHelper.ExecuteNonQuery(tran, ExSql, spa, CommandType.Text); } if (Acc != "") { ExSql = "select isnull(count(*),0) as icount from sys_config where configName='" + accountc + "'"; int exist = int.Parse(DAL.DBHelper.ExecuteScalar(tran, ExSql, CommandType.Text).ToString()); if (exist > 0) { spa = new SqlParameter[] { new SqlParameter("@configValue", SqlDbType.VarChar, 100), new SqlParameter("@configName", SqlDbType.VarChar, 50) }; spa[0].Value = Acc; spa[1].Value = accountc; ExSql = "update sys_config set configValue=@configValue where configName=@configName"; } else { ExSql = "select isnull(max(configCode),0) as configCode from sys_config"; newCodeStr = DAL.DBHelper.ExecuteScalar(tran, ExSql, CommandType.Text).ToString(); inewCode = int.Parse(newCodeStr) + 1; newCode = inewCode.ToString().PadLeft(5, '0'); spa = new SqlParameter[] { new SqlParameter("@configValue", SqlDbType.NVarChar, 100), new SqlParameter("@configName", SqlDbType.NVarChar, 50), new SqlParameter("@configCode", SqlDbType.NVarChar, 5), new SqlParameter("@configDesc", SqlDbType.NVarChar, 200) }; spa[0].Value = Acc; spa[1].Value = accountc; spa[2].Value = newCode; spa[3].Value = AccDesc; ExSql = "insert sys_config(configCode,configName,configValue,configDesc) values(@configCode,@configName,@configValue,@configDesc)"; } var = DAL.DBHelper.ExecuteNonQuery(tran, ExSql, spa, CommandType.Text); } if (AccID != "") { ExSql = "select isnull(count(*),0) as icount from sys_config where configName='" + accountColumn + "'"; int exist = int.Parse(DAL.DBHelper.ExecuteScalar(tran, ExSql, CommandType.Text).ToString()); if (exist > 0) { spa = new SqlParameter[] { new SqlParameter("@configValue", SqlDbType.VarChar, 100), new SqlParameter("@configName", SqlDbType.VarChar, 50) }; spa[0].Value = AccID; spa[1].Value = accountColumn; ExSql = "update sys_config set configValue=@configValue where configName=@configName"; } else { ExSql = "select isnull(max(configCode),0) as configCode from sys_config"; newCodeStr = DAL.DBHelper.ExecuteScalar(tran, ExSql, CommandType.Text).ToString(); inewCode = int.Parse(newCodeStr) + 1; newCode = inewCode.ToString().PadLeft(5, '0'); spa = new SqlParameter[] { new SqlParameter("@configValue", SqlDbType.NVarChar, 100), new SqlParameter("@configName", SqlDbType.NVarChar, 50), new SqlParameter("@configCode", SqlDbType.NVarChar, 5), new SqlParameter("@configDesc", SqlDbType.NVarChar, 200) }; spa[0].Value = AccID; spa[1].Value = accountColumn; spa[2].Value = newCode; spa[3].Value = AccIDDesc; ExSql = "insert sys_config(configCode,configName,configValue,configDesc) values(@configCode,@configName,@configValue,@configDesc)"; } var = DAL.DBHelper.ExecuteNonQuery(tran, ExSql, spa, CommandType.Text); } if (accKey != "" && var > 0) { ExSql = "select isnull(count(*),0) as icount from sys_config where configName='" + accountKey + "'"; int exist = int.Parse(DAL.DBHelper.ExecuteScalar(tran, ExSql, CommandType.Text).ToString()); if (exist > 0) { spa = new SqlParameter[] { new SqlParameter("@configValue", SqlDbType.VarChar, 100), new SqlParameter("@configName", SqlDbType.VarChar, 50) }; spa[0].Value = accKey; spa[1].Value = accountKey; ExSql = "update sys_config set configValue=@configValue where configName=@configName"; } else { ExSql = "select isnull(max(configCode),0) as configCode from sys_config"; newCodeStr = DAL.DBHelper.ExecuteScalar(tran, ExSql, CommandType.Text).ToString(); inewCode = int.Parse(newCodeStr) + 1; newCode = inewCode.ToString().PadLeft(5, '0'); spa = new SqlParameter[] { new SqlParameter("@configValue", SqlDbType.NVarChar, 100), new SqlParameter("@configName", SqlDbType.NVarChar, 50), new SqlParameter("@configCode", SqlDbType.NVarChar, 5), new SqlParameter("@configDesc", SqlDbType.NVarChar, 200) }; spa[0].Value = accKey; spa[1].Value = accountKey; spa[2].Value = newCode; spa[3].Value = accKeyDesc; ExSql = "insert sys_config(configCode,configName,configValue,configDesc) values(@configCode,@configName,@configValue,@configDesc)"; } var = DAL.DBHelper.ExecuteNonQuery(tran, ExSql, spa, CommandType.Text); } if (var > 0) { BLL.CommonClass.Transforms.JSAlert(GetTran("005820", "设置成功!")); tran.Commit(); } else { tran.Rollback(); } } catch (Exception ex) { BLL.CommonClass.Transforms.JSAlert(GetTran("005821", "设置失败") + ":" + ex.Message.ToString()); tran.Rollback(); } if (var > 0) { DefaultBind(); } }
protected void btn_submit_Click(object sender, EventArgs e) { try { string cipherPwd = ""; string ExSql = ""; string key = new BLL.QuickPay.SecretSecurity().EpayKey; string pwdColumn = ddlPwdType.SelectedItem.Value.Trim(); string CertificatePwd = this.txtCertificatePwd.Text.Trim(); string PwdConfirm = this.txtPwdConfirm.Text.Trim(); CertificatePwd = BLL.CommonClass.ValidData.InputText(CertificatePwd); PwdConfirm = BLL.CommonClass.ValidData.InputText(PwdConfirm); if (CertificatePwd == "" || PwdConfirm == "") { BLL.CommonClass.Transforms.JSAlert(GetTran("006686", "请输入证书密码!")); return; } if (CertificatePwd.Length > 32) { BLL.CommonClass.Transforms.JSAlert(GetTran("006934", "注:密码为4~32位字符。")); return; } if (CertificatePwd != PwdConfirm) { BLL.CommonClass.Transforms.JSAlert(GetTran("001365", "两次密码不一样")); return; } cipherPwd = BLL.QuickPay.SecretSecurity.Encrypt3Des24Bit(CertificatePwd, key); string configDesc = this.ddlPwdType.SelectedItem.Text.Trim(); int var = 0; SqlParameter[] spa = null; if (cipherPwd != "") { int exist = int.Parse(DAL.DBHelper.ExecuteScalar("select isnull(count(*),0) as icount from sys_config where configName='" + pwdColumn + "'").ToString()); if (exist > 0) { spa = new SqlParameter[] { new SqlParameter("@configValue", SqlDbType.VarChar, 100), new SqlParameter("@configName", SqlDbType.VarChar, 50) }; spa[0].Value = cipherPwd; spa[1].Value = pwdColumn; ExSql = "update sys_config set configValue=@configValue where configName=@configName"; } else { string newCodeStr = DAL.DBHelper.ExecuteScalar("select isnull(max(configCode),0) as configCode from sys_config").ToString(); int inewCode = int.Parse(newCodeStr) + 1; string newCode = inewCode.ToString().PadLeft(5, '0'); spa = new SqlParameter[] { new SqlParameter("@configValue", SqlDbType.VarChar, 100), new SqlParameter("@configName", SqlDbType.VarChar, 50), new SqlParameter("@configCode", SqlDbType.VarChar, 5), new SqlParameter("@configDesc", SqlDbType.VarChar, 200) }; spa[0].Value = cipherPwd; spa[1].Value = pwdColumn; spa[2].Value = newCode; spa[3].Value = configDesc; ExSql = "insert sys_config(configCode,configName,configValue,configDesc) values(@configCode,@configName,@configValue,@configDesc)"; } var = DAL.DBHelper.ExecuteNonQuery(ExSql, spa, CommandType.Text); } if (var > 0) { BLL.CommonClass.Transforms.JSAlert(GetTran("005820", "设置成功!")); } } catch (Exception ex) { BLL.CommonClass.Transforms.JSAlert(GetTran("005821", "设置失败") + ":" + ex.Message.ToString()); } }
private void DefaultBind() { string key = new BLL.QuickPay.SecretSecurity().EpayKey; string ExSql = "select configValue from sys_config where configName='quickPay_AccountID'"; string AccountID = string.Empty; object objAccid = DAL.DBHelper.ExecuteScalar(ExSql); if (objAccid != DBNull.Value && objAccid != null) { AccountID = objAccid.ToString(); //if (AccountID != "") //AccountID = BLL.QuickPay.SecretSecurity.Decrypt3Des24Bit(AccountID, key); } ExSql = "select configValue from sys_config where configName='quickPay_Key'"; string AccountKey = string.Empty; object objAccKey = DAL.DBHelper.ExecuteScalar(ExSql); if (objAccKey != DBNull.Value && objAccKey != null) { AccountKey = objAccKey.ToString(); //if (AccountKey != "") //AccountKey = BLL.QuickPay.SecretSecurity.Decrypt3Des24Bit(AccountKey, key); } ExSql = "select configValue from sys_config where configName='quickPay_PageUrl'"; string PageUrl = string.Empty; object objPageUrl = DAL.DBHelper.ExecuteScalar(ExSql); if (objPageUrl != DBNull.Value && objPageUrl != null) { PageUrl = objPageUrl.ToString(); //if (PageUrl!="") // PageUrl = BLL.QuickPay.SecretSecurity.Decrypt3Des24Bit(PageUrl, key); } ExSql = "select configValue from sys_config where configName='quickPay_BgUrl'"; string BgUrl = string.Empty; object objBgUrl = DAL.DBHelper.ExecuteScalar(ExSql); if (objBgUrl != DBNull.Value && objBgUrl != null) { BgUrl = objBgUrl.ToString(); //if(BgUrl!="") // BgUrl = BLL.QuickPay.SecretSecurity.Decrypt3Des24Bit(BgUrl, key); } if (AccountID != "") { lblIDFlag.Text = GetTran("006943", "己设置"); txtAcctId.Text = BLL.QuickPay.SecretSecurity.Decrypt3Des24Bit(AccountID, key); } else { lblIDFlag.Text = GetTran("006944", "未设置"); } if (AccountKey != "") { this.lblKeyFlag.Text = GetTran("006943", "己设置"); txtKey.Text = BLL.QuickPay.SecretSecurity.Decrypt3Des24Bit(AccountKey, key); } else { this.lblKeyFlag.Text = GetTran("006944", "未设置"); } if (PageUrl != "") { lblPageUrl.Text = GetTran("006943", "己设置"); txtPageUrl.Text = BLL.QuickPay.SecretSecurity.Decrypt3Des24Bit(PageUrl, key).ToLower(); } else { lblPageUrl.Text = GetTran("006944", "未设置"); } if (BgUrl != "") { this.lblBgUrl.Text = GetTran("006943", "己设置"); txtBgUrl.Text = BLL.QuickPay.SecretSecurity.Decrypt3Des24Bit(BgUrl, key).ToLower(); } else { this.lblBgUrl.Text = GetTran("006944", "未设置"); } }