public DevicesTypeDao(ApplicationClass application) { dbConnection = application.GetDbConnection(); }
public RecordDao(ApplicationClass application) { dbConnection = application.GetDbConnection(); }
public ExamItemDao(ApplicationClass application) { dbConnection = application.GetDbConnection(); }
public FactoryDao(ApplicationClass application) { dbConnection = application.GetDbConnection(); }
/// <summary> /// 账号验证,登录验证。 /// </summary> /// <param name="accountCode">账号名。</param> /// <param name="password">密码。</param> /// <returns>如果成功登录则返回账号对象,否则抛出异常。</returns> public IAccount AccountValidate(string accountCode, string password) { DbConnection dbConn = m_application.GetDbConnection(); if (dbConn != null) { Account account = new Account(); try { string strSql = string.Format("select * from AccountConfig where AccountCode = \"{0}\" and Password = \"{1}\"", accountCode, AC.Base.Function.md5(password)); System.Data.IDataReader dr = dbConn.ExecuteReader(strSql); if (dr.Read()) { //IPAddress myIPAddress = (IPAddress)Dns.GetHostAddresses(Dns.GetHostName()).GetValue(0); object objConfig = dr[Tables.AccountConfig.XMLConfig]; account.AccountCode = accountCode; account.Popedomlist = new List <Type>(); account.PopedomName = string.Empty; if (objConfig != null && !(objConfig is System.DBNull)) { System.Xml.XmlDocument xmlDoc = new System.Xml.XmlDocument(); try { xmlDoc.LoadXml(objConfig.ToString()); if (xmlDoc.ChildNodes.Count > 0) { foreach (System.Xml.XmlNode xnConfig in xmlDoc.ChildNodes) { if (xnConfig.Name.Equals("account")) { account.SetConfig(xnConfig); } } } } catch (Exception) { throw new Exception("没有找到用户正确配置"); } } } else { throw new Exception("没有查询到当前账号、或用户密码错误"); } account.PopedomName = "Administrator"; //strSql = string.Format("SELECT b.RoleName,b.Description,b.PermissionXML FROM AccountRoles a,Roles b where a.AccountCode = \"{0}\" and a.RID = b.RID", account.AccountCode); //System.Data.IDataReader dr1 = dbConn.ExecuteReader(strSql); //while (dr1.Read()) //{ // account.PopedomName = string.Format("{0} , {1}", account.PopedomName, dr1["RoleName"].ToString()); // System.Xml.XmlDocument xdc = new System.Xml.XmlDocument(); // xdc.LoadXml(dr1["PermissionXML"].ToString()); // System.Xml.XmlNode xn = xdc.SelectSingleNode("item"); // if (xn.ChildNodes != null && xn.ChildNodes.Count > 0) // { // foreach (System.Xml.XmlNode sxn in xn.ChildNodes) // { // Type p = Type.GetType(sxn.InnerText); // if (!account.Popedomlist.Contains(p)) // account.Popedomlist.Add(p); // } // } //} dr.Close(); //dr1.Close(); } catch (Exception ex) { throw ex; } finally { dbConn.Close(); } return(account); } else { throw new Exception("数据库连接失败,请检查当前网络环境或联系管理员"); } }