protected override bool InitCache()
{
try
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string sGetSql = "select [userid],[username],[userpassword],[useremail],[userinfo],[usergroupid],[userCName] from GameOa.dbo.oa_user ";
using (SqlDataReader aReader = SqlHelper.ExecuteReader(con, CommandType.Text, sGetSql))
{
if (aReader == null)
{
throw new Exception();
}
List <BaseEmployee> listBaseEmp = new List <BaseEmployee>();
if (aReader.HasRows)
{
while (aReader.Read())
{
BaseEmployee oTmpEmployee = new BaseEmployee(Convert.ToInt32(aReader["userid"]));
oTmpEmployee.InitData(aReader);
listBaseEmp.Add(oTmpEmployee);
}
}
this.addCache(listBaseEmp);
return(true);
}
}
catch (Exception ex)
{
this.SaveLog(ex);
return(false);
}
}
protected override bool InitCache()
{
try
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string sGetSql = "select * from GameOA.dbo.oa_PermitIp where PermitStat=1";
using (SqlDataReader aReader = SqlHelper.ExecuteReader(con, CommandType.Text, sGetSql))
{
if (aReader == null)
{
throw new Exception();
}
List <string> permitIps = new List <string>();
if (aReader.HasRows)
{
while (aReader.Read())
{
permitIps.Add(aReader["PermitIp"].ToString());
}
}
this.addCache(permitIps);
return(true);
}
}
catch (Exception ex)
{
this.SaveLog(ex);
return(false);
}
}
protected override bool InitCache()
{
try
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string sGetSql = "select * from GameOA.dbo.oa_usergroup";
using (SqlDataReader rReader = SqlHelper.ExecuteReader(con, CommandType.Text, sGetSql))
{
if (rReader == null)
{
throw new Exception();
}
List <BaseEmployeeGroup> tmpList = new List <BaseEmployeeGroup>();
if (rReader.HasRows)
{
while (rReader.Read())
{
BaseEmployeeGroup oTmp = new BaseEmployeeGroup();
oTmp.InitData(rReader);
tmpList.Add(oTmp);
}
}
this.addCache(tmpList);
return(true);
}
}
catch (Exception ex)
{
this.SaveLog(ex);
return(false);
}
}
public void InitData(SqlDataReader aReader)
{
_GroupId = Convert.ToInt32(aReader["groupid"]);
_GroupLv = Convert.ToInt32(aReader["grouplv"]);
_GroupName = Convert.ToString(aReader["groupname"]);
_IsSuperMaster = Convert.ToBoolean(aReader["IsSuperMaster"]);
_GroupStat = Convert.ToBoolean(aReader["GroupStat"]);
_GameList = Convert.ToString(aReader["GameList"]);
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string sGetSql = "select * from GameOA.dbo.oa_GroupPurview where GroupId=@aGetGroupid";
SqlParameter[] paramsGet = new SqlParameter[1];
paramsGet[0] = SqlParamHelper.MakeInParam("@aGetGroupId", SqlDbType.Int, 0, _GroupId);
using (SqlDataReader oReader = SqlHelper.ExecuteReader(con, CommandType.Text, sGetSql, paramsGet))
{
if (oReader == null)
{
throw new Exception();
}
if (oReader.HasRows)
{
while (oReader.Read())
{
_ListPageId.Add(Convert.ToInt32(oReader["pageid"]));
}
}
}
}
public void RunError()
{
MessageConfig config = ConfigContext.GetInstance().SysMessageConfig;
string pcName = Dns.GetHostName();
HashSet <string> queuqHash = new HashSet <string>();
new Thread(() =>
{
while (true)
{
var messageList = MessageQueue.GetPrivateQueuesByMachine(pcName);
foreach (var messageQueue in messageList)
{
if (messageQueue.QueueName.ToLower().IndexOf("errorlogcmdsql") != -1)
{
if (!queuqHash.Contains(messageQueue.QueueName))
{
queuqHash.Add(messageQueue.QueueName);
MessageConfig tempConfig = new MessageConfig();
tempConfig.IsErrorQueue = true;
tempConfig.ManagerName = config.ManagerName;
tempConfig.ManagerThreadNumber = config.ManagerThreadNumber;
tempConfig.ManagerThreadTimeOut = config.ManagerThreadTimeOut;
tempConfig.ManagerMessagePath = messageQueue.Path;
tempConfig.ManagerErrorPath = config.ManagerErrorPath;
new Thread(new MSMQDistribution().Receive).Start(tempConfig);
}
}
}
Thread.Sleep(60000);
}
}).Start();
}
protected override bool InitCache()
{
try
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string sSql = "select * from GameOA.dbo.OA_Config order by Id";
using (SqlDataReader reader = SqlHelper.ExecuteReader(con, CommandType.Text, sSql))
{
if (reader == null)
{
throw new Exception();
}
if (reader.HasRows)
{
Dictionary <string, string> dict = new Dictionary <string, string>();
while (reader.Read())
{
dict.Add(reader["Name"].ToString(), reader["Value"].ToString());
}
this.addCache(dict);
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
this.SaveLog(ex);
return(false);
}
}
/// <summary>
/// 添加新的关键字
/// </summary>
/// <param name="aKeyWord"></param>
/// <param name="aStat"></param>
/// <returns></returns>
public bool AddNewKeyWord(string aKeyWord, int aStat)
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string sGetSql = "select * from SnsCenter.dbo.ForbidWordKey where keyword=@aKeyWord";
SqlParameter[] paramsGet = new SqlParameter[2];
paramsGet[0] = SqlParamHelper.MakeInParam("@aKeyWord", SqlDbType.VarChar, 0, aKeyWord);
using (SqlDataReader aReader = SqlHelper.ExecuteReader(con, CommandType.Text, sGetSql, paramsGet))
{
if (aReader == null)
{
return(false);
}
if (aReader.HasRows)
{
return(false);
}
}
string sInsertSql = "insert into SnsCenter.dbo.forbidWordKey(keyWord, Stat)values(@aKeyWord, @aStat)";
paramsGet[1] = SqlParamHelper.MakeInParam("@aStat", SqlDbType.Int, 0, aStat);
if (SqlHelper.ExecuteNonQuery(con, CommandType.Text, sInsertSql, paramsGet) == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool GetFormula()
{
bool bHasFormula = false;
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string sGetSql = "select * from ConfigFormula where formulaid=@aformulaid";
SqlParameter[] paramsGet = new SqlParameter[1];
paramsGet[0] = SqlParamHelper.MakeInParam("@aformulaid", SqlDbType.Int, 0, _formulaId);
using (SqlDataReader aReader = SqlHelper.ExecuteReader(con, CommandType.Text, sGetSql, paramsGet))
{
if (aReader == null)
{
throw new Exception();
}
if (aReader.HasRows)
{
bHasFormula = true;
aReader.Read();
this.InitData(aReader);
}
}
if (bHasFormula)
{
}
return(bHasFormula);
}
/// <summary>
/// 监控系统整体性能
/// </summary>
public void MonitorAll()
{
PC.CategoryName = "Processor"; //指定获取计算机进程信息 如果传Processor参数代表查询计算机CPU
PC.CounterName = "% Processor Time"; //占有率
PC.InstanceName = "_Total";
float cpuValue = PC.NextValue();
Thread.Sleep(TimeSpan.FromSeconds(1));
cpuValue = PC.NextValue();
PostDataToServer(Math.Round(cpuValue, 2).ToString(), saveDir, "");
if (ConfigContext.GetInstance().MaxCPU < cpuValue)
{
if (ContinuousManage.GetInstance().GetIsWaring(CpuMonitorKey + _serverIP + PC.CounterName))
{
string title = _serverIP + "机器CPU过高";
string content = string.Format("IP：{2} CPU：{0}，高于警戒值：{1}", cpuValue.ToString(), ConfigContext.GetInstance().MaxCPU.ToString(), _serverIP);
//Modify post trace
string planName = string.Format("{0}，CPU高于警戒值", _serverIP);
string planValue = string.Format("{0}/{1}", Math.Round(cpuValue, 2), ConfigContext.GetInstance().MaxCPU);
OaSimplePlanHelper.PostDataToServer(planName, planValue);
LogHelper.WriteException("CPU监视[" + _serverIP + "]>>", new Exception(content));
Mail139Helper.SendMail(title, content, ConfigContext.GetInstance().SendTo139Mail, true);
}
}
else
{
ContinuousManage.GetInstance().Reset(CpuMonitorKey + _serverIP + PC.CounterName);
}
}
private static void SendToMail(string content)
{
if (errorTimes > ContinuousTimes)
{
try
{
lock (thisLock)
{
errorTimes = 0;
}
Mail139Helper.SendMail("游戏登录监视", content, ConfigContext.GetInstance().SendTo139Mail, true);
}
catch (Exception ex)
{
Logger.SaveLog("Log in to check mail error", ex);
}
}
else
{
lock (thisLock)
{
errorTimes++;
}
}
}
/// <summary>
/// 导入数据到数据库
/// </summary>
/// <param name="table">导入的数据表</param>
/// <param name="tableName">数据库表名</param>
public ImportState ImportSql(DataTable table, string tableName)
{
if (!TableExist(tableName)) //表名是否存在
{
return(ImportState.TableNameError);
}
if (table == null)
{
return(ImportState.ExcelFormatError);
}
ArrayList tableField = GetTableField(tableName); //表格的列名称
StringBuilder columnName = new StringBuilder();
for (int i = 0; i < table.Columns.Count; i++)
{
columnName.Append(table.Columns[i].ColumnName + ",");
string currentColumn = table.Columns[i].ToString().ToUpper(); //当前列名
for (int j = 0; j < tableField.Count; j++)
{
if (tableField[j].ToString().ToUpper() == table.Columns[i].ToString().ToUpper())
{
break; //跳出本层和上一层循环，continue是跳出本层循环，如果用continue，会继续执行j++ Excel里的字段必须在Sql中都有
}
if ((tableField[j].ToString().ToUpper() != table.Columns[i].ToString().ToUpper()) && j == tableField.Count - 1)
{
return(ImportState.FieldMatchError);
}
}
}
columnName.Remove(columnName.Length - 1, 1); //移除最后一个逗号
StringBuilder value = null;
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
try
{
string strSql = string.Empty;
for (int h = 0; h < table.Rows.Count; h++)
{
value = new StringBuilder();
for (int k = 0; k < table.Columns.Count; k++) //根据列名得到值
{
value.Append("'" + table.Rows[h][k].ToString() + "',");
}
value.Remove(value.Length - 1, 1); //移除最后一个逗号
strSql = "insert into " + tableName + "(" + columnName.ToString() + ") values(" + value + ")";
SqlHelper.ExecuteNonQuery(con, CommandType.Text, strSql);
}
//sqlTran.Commit();
return(ImportState.Success);
}
catch (Exception ex)
{
ErrorInfo = ex.Message;
//sqlTran.Rollback();
return(ImportState.DataTypeError);
}
}
protected override bool InitCache()
{
try
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string sGetSql = "select [PageID],[PageTitle],[PageUrl],[DisplayLeft],[PageDesc],[FatherPid],[LastModifyTime],[menuID] from GameOA.dbo.oa_purviewpage";
using (SqlDataReader oReader = SqlHelper.ExecuteReader(con, CommandType.Text, sGetSql))
{
if (oReader == null)
{
throw new Exception();
}
List<BasePurviewPage> tmpList = new List<BasePurviewPage>();
if (oReader.HasRows)
{
while (oReader.Read())
{
BasePurviewPage oTmp = new BasePurviewPage();
oTmp.InitData(oReader);
tmpList.Add(oTmp);
}
}
this.addCache(tmpList);
return true;
}
}
catch (Exception ex)
{
this.SaveLog(ex);
return false;
}
}
/// <summary>
/// 获取最大Id
/// </summary>
/// <returns></returns>
public int GetMaxId()
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string sGetSql = "select max(groupid) from GameOA.dbo.oa_UserGroup ";
object tobj = SqlHelper.ExecuteScalar(con, CommandType.Text, sGetSql);
return(Convert.ToInt32(tobj) + 1);
}
/// <summary>
/// 获取最大栏目序号
/// </summary>
/// <returns></returns>
public int GetMaxDisplayIndex()
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string sGetSql = "Select max(DisplayIndex) from GameOA.dbo.oa_leftmenu ";
object tobj = SqlHelper.ExecuteScalar(con, CommandType.Text, sGetSql);
return(Convert.ToInt32(tobj) + 1);
}
/// <summary>
/// 检测用户输入的登录用户名与密码是否一直
/// </summary>
/// <param name="aUserName"></param>
/// <param name="aPwd"></param>
/// <param name="isExpire">过期</param>
/// <returns></returns>
protected bool CheckUserLogin(string aUserName, string aPwd, out bool isExpire)
{
isExpire = false;
string aTmpPwdMd5 = this.DoMd5(aPwd);
try
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string sSqlExist = "select * from GameOA.dbo.OA_User where UserName=@aUserName";
SqlParameter[] paramsLogin = new SqlParameter[1];
paramsLogin[0] = SqlParamHelper.MakeInParam("@aUserName", SqlDbType.VarChar, 0, aUserName);
using (SqlDataReader loginReader = SqlHelper.ExecuteReader(con, CommandType.Text, sSqlExist, paramsLogin))
{
if (loginReader == null)
{
return(false);
}
else
{
if (loginReader.HasRows && loginReader.Read())
{
DateTime expireDate = ConvertHelper.ToDateTime(loginReader["pwdmodifydate"]);
if (expireDate.AddDays(oa_changepwd_day) < DateTime.Now)//30天过期
{
isExpire = true;
}
if (Convert.ToString(loginReader["UserPassword"]) == aTmpPwdMd5)
{
BaseCookie oBaseSession = new BaseCookie();
oBaseSession.SaveCookie(loginReader, 4 * 60);
string sql = @"INSERT INTO [GameOA].[dbo].[LoginLog]([LoginIP],[LoginID],[LoginTime])VALUES(@LoginIP,@LoginID,getdate())";
string LoginIP = HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];
SqlParameter[] paramsList = new SqlParameter[] {
SqlParamHelper.MakeInParam("@LoginIP", SqlDbType.VarChar, 0, LoginIP),
SqlParamHelper.MakeInParam("@LoginID", SqlDbType.VarChar, 20, aUserName)
};
SqlHelper.ExecuteNonQuery(con, CommandType.Text, sql, paramsList);
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
}
}
catch
{
return(false);
}
}
public static string AddLogToDB(HttpRequest aRequest, int aUserId, string aUserIp)
{
try
{
string sLogValue = "\r\n";
sLogValue += "userid=" + aUserId.ToString() + "\r\n";
//-------------------------------------------
string aRequestType = aRequest.RequestType.ToLower();
sLogValue += aRequestType + "\r\n";
//----------------------------------------
string sHostUrl = aRequest.Url.Host;
sLogValue += sHostUrl + "\r\n";
//-----------------------------------
string aRawUrl = aRequest.Path;
sLogValue += aRawUrl + "\r\n";
//-----------------------------------
string aReqValue = "";
if (aRequestType == "get")
{
aReqValue = aRequest.QueryString.ToString();
}
else
{
string[] aFormKeys = aRequest.Form.AllKeys;
for (int i = 0; i < aFormKeys.Length; i++)
{
aReqValue += aFormKeys[i].ToString() + "=" + aRequest.Form[i].ToString();
if (i < aFormKeys.Length - 1)
{
aReqValue += "&";
}
}
}
sLogValue += aReqValue + "\r\n";
//-------------------
string sInsertSql = "insert into GameOA.dbo.OA_VisitPageLog(userid, LogUrlHost, LogPath, LogRequestType, LogClientRequest, LogUserIp, LogTime)";
sInsertSql += "values(@aUserId, @aLogUrlHost, @aLogPath, @aLogRequestType, @aLogClientRequest, @aLogUserId, getdate())";
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
SqlParameter[] paramsInsert = new SqlParameter[6];
paramsInsert[0] = SqlParamHelper.MakeInParam("@aUserId", SqlDbType.Int, 0, aUserId);
paramsInsert[1] = SqlParamHelper.MakeInParam("@aLogUrlHost", SqlDbType.VarChar, 0, sHostUrl);
paramsInsert[2] = SqlParamHelper.MakeInParam("@aLogPath", SqlDbType.VarChar, 0, aRawUrl);
paramsInsert[3] = SqlParamHelper.MakeInParam("@aLogRequestType", SqlDbType.VarChar, 0, aRequestType);
paramsInsert[4] = SqlParamHelper.MakeInParam("@aLogClientRequest", SqlDbType.VarChar, 0, aReqValue);
paramsInsert[5] = SqlParamHelper.MakeInParam("@aLogUserId", SqlDbType.VarChar, 0, aUserIp);
SqlHelper.ExecuteNonQuery(con, CommandType.Text, sInsertSql, paramsInsert);
// paramsInsert[6] = conndb.MakeInParam("@aLogUrlHost", SqlDbType.VarChar, 0, sHostUrl);
return(sLogValue);
}
catch (Exception ex)
{
return(ex.Message + ex.StackTrace);
}
//------------------
}
protected override bool InitCache()
{
try
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string sGetSql = "select [menuid],[menuname],[menuDesc],[fatherid],[DisplayIndex] from GameOA.dbo.oa_leftmenu where fatherid = -1 order by DisplayIndex";
using (SqlDataReader oReader = SqlHelper.ExecuteReader(con, CommandType.Text, sGetSql))
{
if (oReader == null)
{
throw new Exception();
}
List <BaseLeftMenu> tmpList = new List <BaseLeftMenu>();
if (oReader.HasRows)
{
while (oReader.Read())
{
BaseLeftMenu oTmp = new BaseLeftMenu();
oTmp.InitData(oReader);
oTmp.GetPurviewPages();
sGetSql = "select [menuid],[menuname],[menuDesc],[fatherid],[DisplayIndex] from GameOA.dbo.oa_leftmenu where fatherid =" + oTmp.MenuId;
using (SqlDataReader childReader = SqlHelper.ExecuteReader(con, CommandType.Text, sGetSql))
{
if (childReader == null)
{
throw new Exception();
}
if (childReader.HasRows)
{
while (childReader.Read())
{
BaseLeftMenu childMenu = new BaseLeftMenu();
childMenu.InitData(childReader);
childMenu.GetPurviewPages();
tmpList.Add(childMenu);
oTmp.ChildPages.Add(childMenu);
}
}
}
tmpList.Add(oTmp);
}
}
this.addCache(tmpList);
return(true);
}
}
catch (Exception ex)
{
this.SaveLog(ex);
return(false);
}
}
public void SearchSimplePlanInfo()
{
try
{
string pcName = Dns.GetHostName();
var messageList = MessageQueue.GetPrivateQueuesByMachine(pcName);
foreach (var queue in messageList)
{
int queueCount = -1;
try
{
queueCount = queue.GetAllMessages().Length;
}
catch (Exception ex)
{
}
OaSimplePlanHelper.PostDataToServer(PlanType.msmq, queue.QueueName, queueCount);
if ((queueCount > MaxErrorQueue && queue.QueueName.ToLower().IndexOf("errorlogcmdsql") != -1) ||
(queueCount > ConfigContext.GetInstance().CitQueueMaxCount))
{
if (ContinuousManage.GetInstance().GetIsWaring(SimplePlanInfoKey + _serverIP + queue.QueueName))
{
string title = _serverIP + "服务器消息队列异常";
string content = string.Format("队列服务器：{0}<br />队列名称：{1}<br />队列总数：{2}<br />",
_serverIP,
queue.QueueName,
queueCount
);
int maxQueueCount = ConfigContext.GetInstance().CitQueueMaxCount;
if (queue.QueueName.ToLower().IndexOf("errorlogcmdsql") != -1)
{
maxQueueCount = MaxErrorQueue;
}
//Modify post trace
string planName = string.Format("{0}，消息队列{1}高于警戒值", _serverIP, queue.QueueName);
string planValue = string.Format("{0}/{1}", queueCount, maxQueueCount);
OaSimplePlanHelper.PostDataToServer(planName, planValue);
LogHelper.WriteException("服务器消息队列监视[" + _serverIP + "]>>", new Exception(content));
Mail139Helper.SendMail(title, content, ConfigContext.GetInstance().SendTo139Mail, true);
}
}
else
{
ContinuousManage.GetInstance().Reset(SimplePlanInfoKey + _serverIP + queue.QueueName);
}
}
}
catch (Exception ex)
{
LogHelper.WriteException("MSMQ information error", ex);
}
}
protected DataSet GetLevelDS()
{
try
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string strSql = "SELECT LevelRangeID,LevelName FROM SnsCenter.dbo.ConfigLevelRange";
return(SqlHelper.ExecuteDataset(con, CommandType.Text, strSql));
}
catch
{
return(null);
}
}
public void DoDelete(string aNewPhoneNum)
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string sUpdateSql = "update mobilegame.dbo.userbasicinfo set mobilephone=@aNewPhone where mobilephone=@amobilephone";
SqlParameter[] paramsupdate = new SqlParameter[2];
paramsupdate[0] = SqlParamHelper.MakeInParam("@aNewPhone", SqlDbType.VarChar, 0, aNewPhoneNum);
paramsupdate[1] = SqlParamHelper.MakeInParam("@amobilephone", SqlDbType.VarChar, 0, this._deleteMobilePhone);
if (SqlHelper.ExecuteNonQuery(con, CommandType.Text, sUpdateSql, paramsupdate) == 1)
{
this._sErrorMsg = "帐号删除成功";
}
else
{
this._sErrorMsg = "帐号删除失败";
}
}
private bool CheckPhone(string aCheckPhone, bool isNew)
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string sGetSql = "select * from mobilegame.dbo.userbasicinfo where mobilephone=@amobilephone";
SqlParameter[] paramsGet = new SqlParameter[1];
paramsGet[0] = SqlParamHelper.MakeInParam("@amobilephone", SqlDbType.VarChar, 0, aCheckPhone);
using (SqlDataReader aReader = SqlHelper.ExecuteReader(con, CommandType.Text, sGetSql, paramsGet))
{
if (aReader == null)
{
this._sErrorMsg = "查询号码" + aCheckPhone + "是否已注册出现异常";
return(false);
}
else
{
if (isNew)
{
if (aReader.HasRows)
{
this._sErrorMsg = "号码：" + aCheckPhone + "已注册";
return(false);
}
else
{
return(true);
}
}
else
{
if (aReader.HasRows)
{
//aReader.Read();
//_UserId = Convert.ToInt32(aReader["userid"]);
return(true);
}
else
{
this._sErrorMsg = "所要删除手机号码" + aCheckPhone + "未注册";
return(false);
}
}
}
}
}
/// <summary>
/// 执行消息队列SQL语句
/// </summary>
/// <param name="messageQueue">消息队列对象</param>
public bool DoSqlExecute(SqlMessageQueue messageQueue, int reDoingCount)
{
if (messageQueue == null || messageQueue.paramters == null)
{
return(false);
}
try
{
SqlParameter[] paramsAction = new SqlParameter[messageQueue.paramters.Length];
for (int i = 0; i < messageQueue.paramters.Length; i++)
{
if (messageQueue.paramters[i] == null)
{
continue;
}
SqlDbType dbtype = (SqlDbType)Enum.Parse(typeof(SqlDbType), messageQueue.paramters[i].iDBTypeValue.ToString(), true);
paramsAction[i] = SqlParamHelper.MakeInParam(messageQueue.paramters[i].paramName, dbtype, messageQueue.paramters[i].isize, messageQueue.paramters[i].ivalue);
}
int result = 0;
if (string.IsNullOrEmpty(messageQueue.ConnectionString))
{
result = SqlHelper.ExecuteNonQuery(ConfigContext.GetInstance().ConnctionString, messageQueue.commandType, messageQueue.commandText, paramsAction);
}
else
{
result = SqlHelper.ExecuteNonQuery(messageQueue.ConnectionString, messageQueue.commandType, messageQueue.commandText, paramsAction);
}
if (result > 1)
{
LogHelper.WriteDebug(string.Format("Message queue [{0} times] perform impact {1} line Sql：{2}", reDoingCount, result, messageQueue.commandText + "：parameter：" + messageQueue.commandType + GetMessagQueueParamterString(messageQueue)));
}
return(true);
}
catch (SqlException sqlex)
{
LogHelper.WriteException(string.Format("Message queue [{0} times] to execute SQL statements SQLEX：{1};{2}", reDoingCount, sqlex.Message, messageQueue.commandText + "：parameter：" + messageQueue.commandType + GetMessagQueueParamterString(messageQueue)), sqlex);
}
catch (Exception ex)
{
LogHelper.WriteException(string.Format("Message queue [{0} times] SQL statement error：{1};{2}", reDoingCount, ex.Message, messageQueue.commandText + "：parameter：" + messageQueue.commandType + GetMessagQueueParamterString(messageQueue)), ex);
}
return(false);
}
protected DataSet GetDetailDS(int gameId, bool activeLoss, string levelRangeID, string beginTime, string endTime)
{
try
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
SqlParameter[] param = new SqlParameter[5];
param[0] = SqlParamHelper.MakeInParam("@GameId", SqlDbType.Int, 4, gameId);
param[1] = SqlParamHelper.MakeInParam("@ActiveLoss", SqlDbType.Bit, 1, activeLoss);
param[2] = SqlParamHelper.MakeInParam("@LevelRangeID", SqlDbType.VarChar, 5, levelRangeID);
param[3] = SqlParamHelper.MakeInParam("@BeginTime", SqlDbType.VarChar, 50, beginTime);
param[4] = SqlParamHelper.MakeInParam("@EndTime", SqlDbType.VarChar, 50, endTime);
return(SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, StoredProcedure, param));
}
catch
{
return(null);
}
}
private void ReDoSqlExecute(MSMQContext context, SqlMessageQueue messageQueue, int runTimes)
{
try
{
for (int i = 0; i < ConfigContext.GetInstance().ReDoExecuteCount; i++)
{
runTimes++;
if (DoSqlExecute(messageQueue, runTimes))
{
LogHelper.WriteDebug(string.Format("Message queue [{0} times] re-execute Sql: {1} successfully!", runTimes, messageQueue.commandText));
return;
}
}
WriteErrorMSMQ(context.MsgConfig, messageQueue);
}
catch (Exception ex)
{
LogHelper.WriteException(string.Format("Queue reexecute {0} error:", context.MsgConfig.ManagerMessagePath), ex);
}
}
public ArrayList GetTableField(string tableName) //得到数据库某一个表中的所有字段
{
ArrayList al = new ArrayList();
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string table = tableName.Substring(0, tableName.LastIndexOf('.') + 1);
tableName = tableName.Substring(tableName.LastIndexOf('.') + 1);
string sql = "SELECT b.name FROM " + table + "sysobjects a INNER JOIN " + table + "syscolumns b ON a.id = b.id WHERE (a.name = '" + tableName + "')";
using (SqlDataReader reader = SqlHelper.ExecuteReader(con, CommandType.Text, sql))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
al.Add(reader.GetString(0));
}
}
}
return(al); //返回的是表中的字段
}
/// <summary>
/// 查看数据库里是否有此表名
/// </summary>
/// <param name="tableName"></param>
public bool TableExist(string tableName)
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string table = tableName.Substring(0, tableName.LastIndexOf('.') + 1);
tableName = tableName.Substring(tableName.LastIndexOf('.') + 1).ToUpper();
string sql = "select name from " + table + "sysobjects where type='u'";
using (SqlDataReader reader = SqlHelper.ExecuteReader(con, CommandType.Text, sql))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
if (reader.GetString(0).ToUpper() == tableName)
{
return(true);
}
}
}
}
return(false);
}
protected override bool InitCache()
{
try
{
string con = ConfigContext.GetInstance().DataBaseSettingProvider.SimpleManagerConnstring;
string sSql = "select * from SnsCenter.dbo.ConfigGameProject order by gameid";
using (SqlDataReader reader = SqlHelper.ExecuteReader(con, CommandType.Text, sSql))
{
if (reader == null)
{
throw new Exception();
}
if (reader.HasRows)
{
List <BaseGameProject> tmplist = new List <BaseGameProject>();
while (reader.Read())
{
BaseGameProject oTmpBaseAsp = new BaseGameProject();
oTmpBaseAsp.InitData(reader);
tmplist.Add(oTmpBaseAsp);
}
this.addCache(tmplist);
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
this.SaveLog(ex);
return(false);
}
}
/// <summary>
/// 检查服务器磁盘空间容量
/// </summary>
public void CheckDriveInfo()
{
try
{
DriveInfo[] alldrive = DriveInfo.GetDrives();
List <string> listWaring = new List <string>();
foreach (DriveInfo d in alldrive)
{
if (d.DriveType == DriveType.Fixed)
{
DriveWaring checkItem = null;
foreach (DriveWaring driveItem in ConfigContext.GetInstance().DriveWaringSet)
{
if (d.Name.IndexOf(driveItem.DriveName) != -1)
{
checkItem = driveItem;
break;
}
}
int curFreeSpace = Convert.ToInt32(d.TotalFreeSpace / 1048576); //计算剩余多少M
int waringSize = 10000;
if (checkItem != null)
{
waringSize = checkItem.WaringSize;
}
PostDataToServer(_serverIP, d.Name, curFreeSpace);
string waringKey = DriveInfoKey + _serverIP + d.Name;
if (curFreeSpace < waringSize)
{
if (ContinuousManage.GetInstance().GetIsWaring(waringKey))
{
string content = string.Format("磁盘：{0}，剩余空间：{1}MB，低于警戒值：{2}MB<br />", d.Name,
curFreeSpace, waringSize);
listWaring.Add(content);
//Modify post trace
string planName = string.Format("{0},磁盘：{1}低于警戒值", _serverIP, d.Name);
string planValue = string.Format("{0}/{1}MB", curFreeSpace, waringSize);
OaSimplePlanHelper.PostDataToServer(planName, planValue);
}
}
else
{
ContinuousManage.GetInstance().Reset(waringKey);
}
}
}
if (listWaring.Count > 0)
{
if (ContinuousManage.GetInstance().GetIsWaring(DriveInfoKey + _serverIP))
{
string title = _serverIP + "磁盘空间不足";
string content = string.Format("共{0}个磁盘空间不足<br />", listWaring.Count);
foreach (string item in listWaring)
{
content += item;
}
LogHelper.WriteException("Disk monitoring [" + _serverIP + "]>>", new Exception(content));
Mail139Helper.SendMail(title, content, ConfigContext.GetInstance().SendTo139Mail, true);
}
}
else
{
ContinuousManage.GetInstance().Reset(DriveInfoKey + _serverIP);
}
}
catch (Exception ex)
{
LogHelper.WriteException("Check server disk space remaining capacity error", ex);
}
}
