/// <summary> /// 得到某个Node /// </summary> /// <param name="fileName"></param> /// <param name="path"></param> /// <param name="name"></param> /// <returns></returns> public XmlNode ReadNodeFromNodeListByNodeAttr(XmlNodeList nodeList, string attrName, string attrValue) { try { foreach (XmlNode xn in nodeList) { if (attrName == "") { return(null); } string factAttr = NodeAtt(xn, attrName); if (factAttr != "") { if (factAttr.Equals(attrValue)) { return(xn); } } } return(null); } catch (Exception exception) { IAppLog log = (IAppLog)AppLogFactory.LogProduct(); log.writeLog(this.GetType().Name, "读取xml出错" + exception.ToString()); } return(null); }
/// <summary> /// 读取某个文件某个路径下的某个属性值 /// </summary> /// <param name="fileName"></param> /// <param name="path"></param> /// <param name="name"></param> /// <returns></returns> public string ReadAttrFromFile(string fileName, string path, string name) { string XMLFileName = System.AppDomain.CurrentDomain.BaseDirectory + @"config\" + fileName; try { XmlDocument xd = new System.Xml.XmlDocument(); xd.Load(XMLFileName); foreach (XmlNode xn in xd.SelectNodes(path)) { if (name == "") { return(""); } string attrName = NodeAtt(xn, name); if (attrName != "") { return(attrName); } } return(null); } catch (Exception exception) { IAppLog log = (IAppLog)AppLogFactory.LogProduct(); log.writeLog(this.GetType().Name, "读取!" + fileName + "出错" + exception.ToString()); } return(null); }
/// <summary> /// 得到某个Node /// </summary> /// <param name="fileName"></param> /// <param name="path"></param> /// <param name="name"></param> /// <returns></returns> public XmlNode ReadNodeFromNodeListByNodeName(XmlNodeList nodeList, string nodeName) { try { foreach (XmlNode xn in nodeList) { if (nodeName == "") { return(xn); } if (nodeName.Equals(xn.Name)) { return(xn); } } return(null); } catch (Exception exception) { IAppLog log = (IAppLog)AppLogFactory.LogProduct(); log.writeLog(this.GetType().Name, "读取xml出错" + exception.ToString()); } return(null); }
public void UpdateBySql(string sqlUpdate) { try { System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand(sqlUpdate, managerDB.OpenApp()); command.CommandType = System.Data.CommandType.Text; command.ExecuteNonQuery(); } catch (Exception exception) { IAppLog log = (IAppLog)AppLogFactory.LogProduct(); log.writeLog(this.GetType().Name, "更新数据出错!" + exception.ToString()); } }
public object ScalarBySql(string sql) { object dr = null; try { System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand(sql, managerDB.OpenApp()); dr = command.ExecuteScalar(); } catch (Exception exception) { IAppLog log = (IAppLog)AppLogFactory.LogProduct(); log.writeLog(this.GetType().Name, "查询数据出错!" + exception.ToString()); } return(dr); }
/// <summary> /// 查询数据返回一个loginPerson /// </summary> public DataSet SelectDataByCondition(string queryWhere) { DataSet ds = null; try { ManagerOperate managerDeal = ManagerOperate.getInstance(); LoginPerson loginPerson = new LoginPerson(); string queryStr = TableInfo.GetQueryFieldFile(loginPerson.Tables[0]); ds = managerDeal.SelectByCondition("manager_login_person", queryStr, queryWhere); } catch (Exception exception) { log.writeLog(this.GetType().Name, "查询数据出错!" + exception.ToString()); } return(ds); }
/// <summary> /// 根据条件(传入的DataSet)查询数据 /// </summary> /// <param name="ds"></param> /// <returns></returns> public DataSet SelectByCondition(String table, string where) { DataSet ds = new DataSet(); try { string querySql = table + where; System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter(querySql, managerDB.OpenApp()); adapter.Fill(ds, table); } catch (System.Exception exception) { IAppLog log = (IAppLog)AppLogFactory.LogProduct(); log.writeLog(this.GetType().Name, "查询数据表" + table + "出错!" + exception.ToString()); } return(ds); }
public void UpdateByProcedure(string procedureName, System.Data.OleDb.OleDbParameter[] sqlParameter) { try { System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand(procedureName, managerDB.OpenApp()); command.CommandType = System.Data.CommandType.StoredProcedure; for (int i = 0; i < sqlParameter.Length; i++) { command.Parameters.Add(sqlParameter[i]); } command.ExecuteNonQuery(); } catch (Exception exception) { IAppLog log = (IAppLog)AppLogFactory.LogProduct(); log.writeLog(this.GetType().Name, "执行存储过程出错!" + exception.ToString()); } }
/// <summary> /// 取得数据库连接 /// </summary> override public System.Data.OleDb.OleDbConnection OpenApp() { string connectStr = null; try { if (connect == null) { connectStr = "Provider=MSDAORA;User ID=" + this.ServerApplicationUserID + ";Data Source=" + this.ServerApplicationDB + ";Password="******"连接SqlServer数据库失败!连接字符串:" + connectStr + exception.ToString()); } return(connect); }
public string ValidPerson(string personID, string password) { try { string sqlWhere = " person_code='" + personID + "'"; PersonLoginBll loginPersonLogic = new PersonLoginBll(); DataSet loginPerson = loginPersonLogic.SelectDataByCondition(sqlWhere); if (loginPerson == null || loginPerson.Tables[0].Rows.Count <= 0) { return("-1"); } System.Data.DataRow loginPersonRow = loginPerson.Tables[0].Rows[0]; return((string)loginPersonRow["person_status"]); } catch (Exception exception) { log.writeLog(this.GetType().Name, "取登录人员信息出错!" + exception.ToString()); } return("-1"); }
/// <summary> /// 得到NodeList /// </summary> /// <param name="fileName"></param> /// <param name="path"></param> /// <param name="name"></param> /// <returns></returns> public XmlNodeList ReadNodeListFromFile(string fileName, string path) { string XMLFileName = System.AppDomain.CurrentDomain.BaseDirectory + @"config\" + fileName; try { XmlDocument xd = new System.Xml.XmlDocument(); xd.Load(XMLFileName); System.Xml.XmlNode nodeFirst = xd.SelectSingleNode(path); System.Xml.XmlNodeList nodeList = nodeFirst.ChildNodes; return(nodeList); } catch (Exception exception) { IAppLog log = (IAppLog)AppLogFactory.LogProduct(); log.writeLog(this.GetType().Name, "读取!" + fileName + "出错" + exception.ToString()); } return(null); }
/// <summary> /// 得到某个Node下所有的NodeList /// </summary> /// <param name="fileName"></param> /// <param name="path"></param> /// <param name="name"></param> /// <returns></returns> public XmlNodeList ReadNodeListFromNode(XmlNode node) { try { if (node.HasChildNodes == false) { return(null); } else { return(node.ChildNodes); } } catch (Exception exception) { IAppLog log = (IAppLog)AppLogFactory.LogProduct(); log.writeLog(this.GetType().Name, "根据Node得NodeList出错!" + exception.ToString()); } return(null); }
public System.Data.OleDb.OleDbDataReader SelectByProcedure(string procedureName, System.Data.SqlClient.SqlParameter[] sqlParameter) { System.Data.OleDb.OleDbDataReader dr = null; try { System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand(procedureName, managerDB.OpenApp()); command.CommandType = System.Data.CommandType.StoredProcedure; for (int i = 0; i < sqlParameter.Length; i++) { command.Parameters.Add(sqlParameter[i]); } dr = command.ExecuteReader(); } catch (Exception exception) { IAppLog log = (IAppLog)AppLogFactory.LogProduct(); log.writeLog(this.GetType().Name, "执行存储过程" + procedureName + "查询数据出错!" + exception.ToString()); } return(dr); }
/// <summary> /// 取得数据库连接 /// </summary> override public System.Data.OleDb.OleDbConnection OpenApp() { string connectStr = null; try { if (connect == null) { connectStr = "Provider=SQLOLEDB.1;Persist Security Info=True;"; connectStr += "Data Source=" + this.DbServer + "; Initial Catalog=" + this.ServerApplicationDB; connectStr += ";User ID=" + this.ServerApplicationUserID + "; Password="******"连接SqlServer数据库失败!连接字符串:" + connectStr + exception.ToString()); } return(connect); }
/// <summary> /// 读取某个节点下的某个属性值 /// </summary> /// <param name="node"></param> /// <param name="path"></param> /// <param name="name"></param> /// <returns></returns> public string ReadAttrFromPath(XmlNode node, string path, string name) { if (node.HasChildNodes == false) { string attrName = NodeAtt(node, name); if (attrName != "") { return(attrName); } else { return(""); } } try { foreach (XmlNode xn in node.SelectNodes(path)) { if (name == "") { return(""); } string attrName = NodeAtt(xn, name); if (attrName != "") { return(attrName); } } return(null); } catch (Exception exception) { IAppLog log = (IAppLog)AppLogFactory.LogProduct(); log.writeLog(this.GetType().Name, "读取!" + path + "出错" + exception.ToString()); } return(null); }
protected void OnStart(object sender) { try { ReadXml readXml = new ReadXml(); XmlNodeList xmlNodeList = readXml.ReadNodeListFromFile("interaction.xml", "interactions"); string tcpPort = readXml.ReadAttrFromFile("interaction.xml", "interactions", "tcpport"); string httpPort = readXml.ReadAttrFromFile("interaction.xml", "interactions", "httpport"); TcpServerChannel tcp = new TcpServerChannel(int.Parse(tcpPort)); ChannelServices.RegisterChannel(tcp, false); log.writeLog(this.GetType().Name, "Remoting服务正在用TCP方式监听端口(" + tcpPort + ")!"); HttpServerChannel http = new HttpServerChannel(int.Parse(httpPort)); ChannelServices.RegisterChannel(http, false); log.writeLog(this.GetType().Name, "Remoting服务正在用HTTP方式监听端口(" + httpPort + ")!"); foreach (XmlNode xn in xmlNodeList) { string interaction = xn.Attributes["impl"].Value; string implInterface = xn.Attributes["interface"].Value; Assembly remotingAssembly = Assembly.Load("RemoteObject"); if (remotingAssembly == null) { log.writeLog(this.GetType().Name, "注册服务" + interaction + "失败"); continue; } try { System.Type[] types = remotingAssembly.GetTypes(); if (types != null) { for (int loop = 0; loop < types.GetLength(0); loop++) { Type temp = types[loop]; Type[] tInterfaces = temp.GetInterfaces(); if (tInterfaces != null && tInterfaces.Length > 0) { for (int j = 0; j < tInterfaces.Length; j++) { string intfaceName = tInterfaces[j].Name; if (intfaceName.Equals(implInterface)) { RemotingConfiguration.RegisterWellKnownServiceType(temp, implInterface, WellKnownObjectMode.SingleCall); log.writeLog(this.GetType().Name, "注册服务" + temp.Name + "成功"); break; } } } } } } catch (Exception exception) { log.writeLog(this.GetType().Name, "注册服务" + interaction + "失败" + exception.ToString()); } } } catch (Exception exception) { log.writeLog(this.GetType().Name, "加载对象出错!" + exception.ToString()); } (sender as Control).Enabled = false; }