private TargetServerInfoViewModel AliveServer() { CALCULATION_SERVER_STATUS_Table_DAOManager daoM = new CALCULATION_SERVER_STATUS_Table_DAOManager(); daoM.SERVER_STATUS_ = "idle"; daoM.select(DataBaseConnectManager.ConnectionFactory(DataBaseConnectManager.ConnectionString_)); TargetServerInfoViewModel tsivm = new TargetServerInfoViewModel(); //tsivm.buildFromDAO(daoM.DAOList_[0]); return(tsivm); }
private InstrumentData getInstrumentData() { CALCULATION_QUEUE_INFO_Table_DAOManager daoM = new CALCULATION_QUEUE_INFO_Table_DAOManager(); daoM.select(DataBaseConnectManager.ConnectionFactory(DataBaseConnectManager.ConnectionString_)); InstrumentData instrumentData = new InstrumentData(); instrumentData.InstrumentCode_ = daoM.DAOList_[0].INST_CODE_; instrumentData.InstrumentType_ = daoM.DAOList_[0].INST_TYPE_; //instrumentData.InstrumentXml_= daoM.DAOList_[0].INST_MSGXML; return(instrumentData); }
public override void DoJob() { //this.buildInstrumentInfo(); // db queue insert CALCULATION_SERVER_STATUS_Table_DAO dao = new CALCULATION_SERVER_STATUS_Table_DAO(); dao.SERVER_NAME_ = this.MessageViewModel_.MessageHeaderViewModel_.Item_code_; dao.SERVER_IP_ = ""; dao.SERVER_PORT_ = "13212"; dao.SERVER_CORENUM_ = "2"; dao.SERVER_STATUS_ = "alive"; dao.SERVER_USE_ = "use"; dao.SERVER_DESCRIPTION_ = "haha test cal server"; dao.SERVER_ALIVETIME_ = DateTime.Now.ToString("yyyyMMddffffff"); string connectionStr = DataBaseConnectManager.ConnectionString_; if (dao.SERVER_STATUS_ == "regist") { dao.insert(DataBaseConnectManager.ConnectionFactory(connectionStr)); } else if (dao.SERVER_STATUS_ == "start") { dao.update(DataBaseConnectManager.ConnectionFactory(connectionStr)); } else if (dao.SERVER_STATUS_ == "stop") { dao.update(DataBaseConnectManager.ConnectionFactory(connectionStr)); } else if (dao.SERVER_STATUS_ == "deRegist") { dao.update(DataBaseConnectManager.ConnectionFactory(connectionStr)); } else { } //string fileName = this.InstrumentCode_; //File.WriteAllText(fileName, this.InstrumentXml_); //Console.WriteLine("File Saved. , name : {0} : ", fileName); //AsynchronousSocketListener.InstrumentQueue_.Enqueue(this); }
public void select(DbConnection conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } DataTable tb = new DataTable(); this.DAOList_ = new List <CALCULATION_SERVER_STATUS_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = CALCULATION_SERVER_STATUS_Table_DAOManager.SelectQuery_; //selectQuery = selectQuery.Replace("@KeyColumnValue@", this.KeyColumn_); dbCommand.CommandText = selectQuery; //DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn); DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn); dataAdapter.Fill(tb); DataRow[] dr = tb.Select(); int rowCount = dr.Length; foreach (DataRow item in dr) { CALCULATION_SERVER_STATUS_Table_DAO dao = new CALCULATION_SERVER_STATUS_Table_DAO(); dao.SERVER_NAME_ = item[0].ToString(); dao.SERVER_IP_ = item[1].ToString(); dao.SERVER_PORT_ = item[2].ToString(); dao.SERVER_STATUS_ = item[3].ToString(); dao.SERVER_CORENUM_ = item[4].ToString(); dao.SERVER_USE_ = item[5].ToString(); dao.SERVER_ALIVETIME_ = item[6].ToString(); dao.SERVER_DESCRIPTION_ = item[7].ToString(); this.DAOList_.Add(dao); } }
public void select(DbConnection conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } DataTable tb = new DataTable(); this.DAOList_ = new List <CALCULATION_QUEUE_INFO_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = CALCULATION_QUEUE_INFO_Table_DAOManager.SelectQuery_; //selectQuery = selectQuery.Replace("@KeyColumnValue@", this.KeyColumn_); dbCommand.CommandText = selectQuery; //DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn); DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn); dataAdapter.Fill(tb); DataRow[] dr = tb.Select(); int rowCount = dr.Length; foreach (DataRow item in dr) { CALCULATION_QUEUE_INFO_Table_DAO dao = new CALCULATION_QUEUE_INFO_Table_DAO(); dao.INST_CODE_ = item[0].ToString(); dao.INST_TYPE_ = item[1].ToString(); dao.INST_NAME_ = item[2].ToString(); dao.PARA_DATE_ = item[3].ToString(); dao.CALCULATION_STATE_ = item[4].ToString(); this.DAOList_.Add(dao); } }
//public void buildInstrumentInfo() //{ // //this.xmlDoc_.LoadXml(this.InstrumentXml_); // this.InstrumentType_ = "testType"; // this.InstrumentCode_ = "testCode"; // this.ReferenceDate_ = "testRefDate"; //} public override void DoJob() { //this.buildInstrumentInfo(); // db queue insert CALCULATION_QUEUE_INFO_Table_DAO dao = new CALCULATION_QUEUE_INFO_Table_DAO(); GridCalculationViewModel gcvm = this.MessageViewModel_.MessageBodyViewModel_ as GridCalculationViewModel; dao.INST_CODE_ = gcvm.Inst_code_; dao.INST_NAME_ = gcvm.Inst_name_; dao.INST_TYPE_ = gcvm.Inst_type_; dao.PARA_DATE_ = gcvm.Para_refDate_; dao.CALCULATION_STATE_ = "regist"; string connectionStr = DataBaseConnectManager.ConnectionString_; if (dao.CALCULATION_STATE_ == "regist") { dao.insert(DataBaseConnectManager.ConnectionFactory("sqlCe", connectionStr)); File.WriteAllText(gcvm.Inst_code_ + ".xml", gcvm.InnerXml_); } else if (dao.CALCULATION_STATE_ == "deRegist") { dao.delete(DataBaseConnectManager.ConnectionFactory("sqlCe", connectionStr)); } else { } //string fileName = this.InstrumentCode_; //File.WriteAllText(fileName, this.InstrumentXml_); //Console.WriteLine("File Saved. , name : {0} : ", fileName); //AsynchronousSocketListener.InstrumentQueue_.Enqueue(this); }