static public void LoadMailDbCfg() { XmlDocument xml = new XmlDocument(); string appPath = AppDomain.CurrentDomain.BaseDirectory; //xml.Load(appPath + "\\ServerConfig.xml"); //XML地址 xml.Load("cfg/DbConfig.xml"); XmlNodeList serverNodeList = xml.SelectNodes("/DbCfg/mail"); if (null != serverNodeList) { foreach (XmlNode serverNode in serverNodeList) { //string csip = serverNode.SelectSingleNode("csname").InnerText; string ip = serverNode.SelectSingleNode("csdb").InnerText; string user = serverNode.SelectSingleNode("user").InnerText; string pwd = serverNode.SelectSingleNode("pwd").InnerText; string db = serverNode.SelectSingleNode("dbname").InnerText; MailInfoCfg dbcfg = new MailInfoCfg(); dbcfg.InitDbCfg(ip, user, pwd, db); dbSfgList.Add(dbcfg); } } LoadChannelCfg(); }
//获取当前选择的cs-->db static public MailInfoCfg GetCurtCSDBInfo(String choseCS) { MailInfoCfg tcfg = new MailInfoCfg(); foreach (MailInfoCfg cfg in Program.dbSfgList) { tcfg = cfg; break; } return(tcfg); }
static public bool GetUseridAndQuery(int type, String str, MailInfoCfg cfg) { ReleaseList(); bool bFlag = DbFunc.IfConnDb(cfg); if (bFlag) { SplitUserStr(type, str); CheckUserSql(cfg); } return(bFlag); }
static public void CheckUserSql(MailInfoCfg cfg) { foreach (UserInfo user in userList) { String strSql = "select id from account_user where "; try { switch (user.eType) { case EUserType.eUser_Id: { strSql += "id=" + Convert.ToInt64(user.obj) + ";"; } break; case EUserType.eUser_Name: { strSql += "user_name='" + Convert.ToString(user.obj) + "';";; } break; case EUserType.eUser_Account: { strSql += "cdkey='" + Convert.ToString(user.obj) + "';"; } break; default: break; } } catch (System.Exception ex) { errorStr.Add(user.obj.ToString()); continue; } UInt64 objIdx = DbFunc.CheckAndGetUserIdx(strSql); if (objIdx > 0) { if (!userIdList.Contains(objIdx)) { userIdList.Add(objIdx); existUserList.Add(user); } } else { errorStr.Add(user.obj.ToString()); } } }
static public bool IfConnDb(MailInfoCfg cfg) { if (conn != null) { return(true); } try { String mysqlStr = "Database=" + cfg.mDbname + ";Data Source=" + cfg.mIpAddr + ";User Id=" + cfg.mUser + ";Password="******";pooling=false;CharSet=utf8;port=3306"; conn = new MySqlConnection(mysqlStr); if (conn != null) { return(true); } return(false); } catch (System.Exception ex) { err = ex.Message; return(false); } return(false); }
public bool ifConnectDb(MailInfoCfg cfg) { return(true); }