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", "未设置");
}
}