public string GetConn(int kindID)
{
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
GameGameItem dBAddString = this.GetDBAddString(kindID);
string result;
if (dBAddString == null)
{
result = "";
}
else
{
DataBaseInfo databaseInfo = this.GetDatabaseInfo(dBAddString.DataBaseAddr);
if (databaseInfo == null)
{
result = "";
}
else
{
string text = CWHEncryptNet.XorCrevasse(databaseInfo.DBUser);
string text2 = CWHEncryptNet.XorCrevasse(databaseInfo.DBPassword);
stringBuilder.AppendFormat("Data Source={0}; Initial Catalog={1}; User ID={2}; Password={3}; Pooling=true", new object[]
{
dBAddString.DataBaseAddr + (string.IsNullOrEmpty(databaseInfo.DBPort.ToString()) ? "" : ("," + databaseInfo.DBPort.ToString())),
dBAddString.DataBaseName,
text,
text2
});
result = stringBuilder.ToString();
}
}
return(result);
}
/// <summary>
/// 获取验证码数值
/// </summary>
/// <returns></returns>
public static string GetVerifyCode()
{
string vcode = "";
if (HttpContext.Current != null && HttpContext.Current.Session != null)
{
vcode = SessionState.Get(Fetch.UC_VERIFY_CODE_KEY) as string;
//Session 保存，无需解密
if (!string.IsNullOrEmpty(vcode))
{
return(vcode);
}
}
else
{
vcode = Utility.GetCookie(Fetch.UC_VERIFY_CODE_KEY);
}
if (!String.IsNullOrEmpty(vcode))
{
vcode = CWHEncryptNet.XorCrevasse(vcode);
}
return(vcode);
}
/// <summary>
/// 保存数据
/// </summary>
protected void btnSave_Click(object sender, EventArgs e)
{
if (!Utils.Validate.IsPositiveInt(txtDBPort.Text))
{
ShowError("端口不规范，端口只能为正整数");
return;
}
string address = CtrlHelper.GetText(txtDBAddr);
DataBaseInfo dataBaseInfo = new DataBaseInfo();
if (IntParam > 0)
{
if (!AuthUserOperationPermission(Permission.Edit))
{
return;
}
dataBaseInfo = FacadeManage.aidePlatformFacade.GetDataBaseInfo(IntParam);
}
else
{
if (!AuthUserOperationPermission(Permission.Add))
{
return;
}
DataBaseInfo info = FacadeManage.aidePlatformFacade.GetDataBaseInfo(address);
if (info != null)
{
ShowError("地址已经存在");
return;
}
}
dataBaseInfo.DBAddr = address;
dataBaseInfo.DBPort = CtrlHelper.GetInt(txtDBPort, 0);
dataBaseInfo.DBUser = CWHEncryptNet.XorEncrypt(CtrlHelper.GetText(txtDBUser));
if (CtrlHelper.GetText(hdfDBPassword) == "********")
{
dataBaseInfo.DBPassword = CWHEncryptNet.XorEncrypt(CtrlHelper.GetText(txtDBPassword));
}
else
{
dataBaseInfo.DBPassword = CtrlHelper.GetText(hdfDBPassword);
}
dataBaseInfo.MachineID = CtrlHelper.GetText(txtMachineID);
dataBaseInfo.Information = CtrlHelper.GetText(txtInformation);
int result = IntParam > 0 ? FacadeManage.aidePlatformFacade.UpdateDataBase(dataBaseInfo) : FacadeManage.aidePlatformFacade.InsertDataBase(dataBaseInfo);
if (result > 0)
{
ShowInfo("机器信息操作成功", "DataBaseInfoList.aspx", 1200);
}
else
{
ShowError("机器信息失败成功");
}
}
/// <summary>
/// 页面加载
/// </summary>
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (IntParam > 0)
{
DataBaseInfo dataBaseInfo = FacadeManage.aidePlatformFacade.GetDataBaseInfo(IntParam);
if (dataBaseInfo != null)
{
CtrlHelper.SetText(txtInformation, dataBaseInfo.Information.Trim());
CtrlHelper.SetText(txtDBAddr, dataBaseInfo.DBAddr.Trim());
CtrlHelper.SetText(txtDBPort, dataBaseInfo.DBPort.ToString().Trim());
CtrlHelper.SetText(txtDBUser, CWHEncryptNet.XorCrevasse(dataBaseInfo.DBUser.Trim()));
if (dataBaseInfo.DBPassword != "")
{
txtDBPassword.Attributes.Add("value", "********");
CtrlHelper.SetText(hdfDBPassword, dataBaseInfo.DBPassword.Trim());
}
CtrlHelper.SetText(txtMachineID, dataBaseInfo.MachineID.Trim());
}
}
}
}
private void DataBaseDataBind()
{
if (StrCmd == "add")
{
litInfo.Text = "新增";
}
else
{
litInfo.Text = "更新";
}
if (IntParam <= 0)
{
return;
}
//获取站点信息
DataBaseInfo dataBaseInfo = FacadeManage.aidePlatformFacade.GetDataBaseInfo(IntParam);
if (dataBaseInfo == null)
{
ShowError("机器信息不存在");
Redirect("DataBaseInfoList.aspx");
return;
}
CtrlHelper.SetText(txtInformation, dataBaseInfo.Information.Trim());
CtrlHelper.SetText(txtDBAddr, dataBaseInfo.DBAddr.Trim());
CtrlHelper.SetText(txtDBPort, dataBaseInfo.DBPort.ToString().Trim());
CtrlHelper.SetText(txtDBUser, CWHEncryptNet.XorCrevasse(dataBaseInfo.DBUser.Trim()));
if (dataBaseInfo.DBPassword != "")
{
txtDBPassword.Attributes.Add("value", "********");
CtrlHelper.SetText(hdfDBPassword, dataBaseInfo.DBPassword.Trim());
}
CtrlHelper.SetText(txtMachineID, dataBaseInfo.MachineID.Trim());
}
/// <summary>
/// 指定用户是否申请了保护
/// </summary>
/// <param name="strUserID"></param>
/// <returns></returns>
protected virtual bool IsApplyProtection(string strUserID, out AccountsProtect protectInfo)
{
int dwUserID = TypeParse.StrToInt(CWHEncryptNet.XorCrevasse(strUserID), 0);
return(IsApplyProtection(dwUserID, out protectInfo));
}
/// <summary>
/// 获取加密后的用户标识
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public static string GetStrUserID(int userID)
{
return(CWHEncryptNet.XorEncrypt(userID.ToString()));
}
/// <summary>
/// 获取用户标识
/// </summary>
/// <param name="strUserID"></param>
/// <returns></returns>
public static int GetUserID(string strUserID)
{
int dwUserID = TypeParse.StrToInt(CWHEncryptNet.XorCrevasse(strUserID), 0);
return(dwUserID);
}
private void ProcessData()
{
if (!Utils.Validate.IsPositiveInt(txtDBPort.Text))
{
ShowError("端口不规范，端口只能为正整数");
return;
}
DataBaseInfo dataBaseInfo = new DataBaseInfo();
dataBaseInfo.DBAddr = CtrlHelper.GetText(txtDBAddr);
dataBaseInfo.DBPort = CtrlHelper.GetInt(txtDBPort, 0);
dataBaseInfo.DBUser = CWHEncryptNet.XorEncrypt(CtrlHelper.GetText(txtDBUser));
if (CtrlHelper.GetText(hdfDBPassword) == "********")
{
dataBaseInfo.DBPassword = CWHEncryptNet.XorEncrypt(CtrlHelper.GetText(txtDBPassword));
}
else
{
dataBaseInfo.DBPassword = CtrlHelper.GetText(hdfDBPassword);
}
dataBaseInfo.MachineID = CtrlHelper.GetText(txtMachineID);
dataBaseInfo.Information = CtrlHelper.GetText(txtInformation);
Message msg = new Message();
if (StrCmd == "add")
{
//判断权限
AuthUserOperationPermission(Permission.Add);
if (FacadeManage.aidePlatformFacade.IsExistsDBAddr(dataBaseInfo.DBAddr))
{
ShowError("地址已经存在");
return;
}
msg = FacadeManage.aidePlatformFacade.InsertDataBase(dataBaseInfo);
}
else
{
//判断权限
AuthUserOperationPermission(Permission.Edit);
dataBaseInfo.DBInfoID = IntParam;
msg = FacadeManage.aidePlatformFacade.UpdateDataBase(dataBaseInfo);
}
if (msg.Success)
{
if (StrCmd == "add")
{
ShowInfo("机器信息增加成功", "DataBaseInfoList.aspx", 1200);
}
else
{
ShowInfo("机器信息修改成功", "DataBaseInfoList.aspx", 1200);
}
}
else
{
ShowError(msg.Content);
}
}
