public void loadValidCheckRule() { ConsoleServer.WriteLine("Loaad Range Table"); System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Comm.DB2.Db2.db2ConnectionStr); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand("select minvalue,maxvalue from tblRDvalidRange"); try { cn.Open(); cmd.Connection = cn; System.Data.Odbc.OdbcDataReader rd = cmd.ExecuteReader(); if (rd.Read()) { minvalue = System.Convert.ToInt32(rd[0]); maxvalue = System.Convert.ToInt32(rd[1]); } } catch (Exception ex) { ConsoleServer.WriteLine(ex.Message + "," + ex.StackTrace); } finally { cn.Close(); } }
public string GetPatientData(string strParam) { string strReturn = String.Empty; try { System.Data.DataTable dt = new System.Data.DataTable(); string strSql = "Select to_char(birth_date) As birth_date, lpad(insurance, 2,'0') As insurance, to_char(first_opd_date) As first_opd_date, to_char(last_opd_date) As last_opd_date, * From reg_file Where reg_no=? Or id_no=?"; System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(strSql); cmd.Parameters.Add("@Param1", System.Data.Odbc.OdbcType.Char).Value = strParam; cmd.Parameters.Add("@Param2", System.Data.Odbc.OdbcType.Char).Value = strParam; Dev.ODBCSql.MyODBCConnection conn = new Dev.ODBCSql.MyODBCConnection(); dt = conn.GetData(cmd); if (dt.Rows.Count > 0) { strReturn = JsonData(dt); } } catch (Exception ex) { strReturn = ex.Message; } return(strReturn); }
/// <summary> /// 返回指定Sql语句的DbDataReader /// 方法关闭数据库连接 /// </summary> /// <param name="sqlstr">传入的Sql语句</param> /// <returns>DBDataReader对象</returns> public virtual DbDataReader GetDataReader(string sqlstr) { //程序不能返回抽象类,故用分数据访问分工来生成DataReader对象 if (databaseType == "Oracle") { System.Data.OracleClient.OracleCommand cmd = new System.Data.OracleClient.OracleCommand(); System.Data.OracleClient.OracleDataReader oraDr = cmd.ExecuteReader(); return(oraDr); } else if (databaseType == "SqlServer") { System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(); System.Data.SqlClient.SqlDataReader sqlDr = cmd.ExecuteReader(); return(sqlDr); } else if (databaseType == "Sybase") { System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(); System.Data.OleDb.OleDbDataReader oleDr = cmd.ExecuteReader(); return(oleDr); } else { System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(); System.Data.Odbc.OdbcDataReader odbcDr = cmd.ExecuteReader(); return(odbcDr); } }
public string ExecuteNonQuery(string sQuery) { string sFuncName = "ExecuteNonQuery()"; string sConstr = ConfigurationManager.ConnectionStrings["adapterConnection"].ToString(); System.Data.Odbc.OdbcConnection oCon = new System.Data.Odbc.OdbcConnection(sConstr); System.Data.Odbc.OdbcCommand oCmd = new System.Data.Odbc.OdbcCommand(); try { oCon.Open(); oCmd.CommandType = CommandType.Text; oCmd.CommandText = sQuery; oCmd.Connection = oCon; oCmd.CommandTimeout = 120; oCmd.ExecuteNonQuery(); } catch (Exception ex) { if (p_iDebugMode == DEBUG_ON) { oLog.WriteToLogFile_Debug("Completed with ERROR", sFuncName); } oCon.Dispose(); throw new Exception(ex.Message); } return("SUCCESS"); }
public DataTable ExecuteSelectQuery(string sQuery) { string sFuncName = "ExecuteSelectQuery()"; string sConstr = ConfigurationManager.ConnectionStrings["adapterConnection"].ToString(); System.Data.Odbc.OdbcConnection oCon = new System.Data.Odbc.OdbcConnection(sConstr); System.Data.Odbc.OdbcCommand oCmd = new System.Data.Odbc.OdbcCommand(); DataSet oDs = new DataSet(); try { oCon.Open(); oCmd.CommandType = CommandType.Text; oCmd.CommandText = sQuery; oCmd.Connection = oCon; oCmd.CommandTimeout = 120; System.Data.Odbc.OdbcDataAdapter da = new System.Data.Odbc.OdbcDataAdapter(oCmd); da.Fill(oDs); } catch (Exception ex) { if (p_iDebugMode == DEBUG_ON) { oLog.WriteToLogFile_Debug("Completed with Error", sFuncName); } oCon.Dispose(); throw new Exception(ex.Message); } return(oDs.Tables[0]); }
public bool DesmaterializaPessoa(cPessoa objPessoa) { string sql; try { sql = "INSERT INTO pessoa(nome, sexo, dt_nascimento) values (?, ?, ?)"; sqlConn = new System.Data.Odbc.OdbcConnection(connString); sqlConn.Open(); sqlCmd = new System.Data.Odbc.OdbcCommand(sql, sqlConn); sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.VarChar, 255).Value = objPessoa.sNome; sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.VarChar, 1).Value = objPessoa.sSexo; sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.Date).Value = objPessoa.dtDataNasc; if (sqlCmd.ExecuteNonQuery() > 0) { sqlConn.Close(); return(true); } else { sqlConn.Close(); return(false); } } catch (Exception Ex) { return(false); } }
public bool DesmaterializaDado(cDados dado) { string sql; try { sql = "INSERT INTO dados(id_avaliacao, data_hora, freq_cardiaca) values (?, ?, ?)"; sqlConn = new System.Data.Odbc.OdbcConnection(connString); sqlConn.Open(); sqlCmd = new System.Data.Odbc.OdbcCommand(sql, sqlConn); sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.Int).Value = dado.id_avaliacao; sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.DateTime).Value = dado.data; sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.Int).Value = dado.fc; if (sqlCmd.ExecuteNonQuery() > 0) { sqlConn.Close(); return(true); } else { sqlConn.Close(); return(false); } } catch (Exception Ex) { return(false); } }
public override List <DDD_MSJ.DOM.Mensaje> getMensajes() { var sqlConexion = new System.Data.Odbc.OdbcConnection("Dsn=prova"); var sqlComando = new System.Data.Odbc.OdbcCommand(); System.Data.Odbc.OdbcDataReader sqlReader; sqlComando.CommandText = "select * from mensajeria.Mensaje;"; sqlComando.CommandType = System.Data.CommandType.Text; sqlComando.Connection = sqlConexion; try { sqlConexion.Open(); sqlReader = sqlComando.ExecuteReader(); string IdMensaje = ""; string Descripcion = ""; DDD_MSJ.DOM.Mensaje Mensaje; while (sqlReader.Read()) { IdMensaje = sqlReader.GetString(0); Descripcion = sqlReader.GetString(1); Mensaje = new DDD_MSJ.DOM.Mensaje(IdMensaje, Descripcion); this.m_lstMensajes.Add(Mensaje); } } finally { sqlConexion.Close(); } return(this.m_lstMensajes); }
private void Form4_Load(object sender, EventArgs e) { using (System.Data.Odbc.OdbcConnection conn = new System.Data.Odbc.OdbcConnection(gbCn)) { try { conn.Open(); System.Data.Odbc.OdbcCommand command = new System.Data.Odbc.OdbcCommand("SELECT name, database_id, create_date FROM sys.databases", conn); System.Data.Odbc.OdbcDataReader reader = command.ExecuteReader(); //agrega nombre de base datos comboBox3.Items.Clear(); while (reader.Read()) { comboBox3.Items.Add(reader[0].ToString()); } } catch (Exception ex) { MessageBox.Show("Ocurrio un error al obtener las bases de datos"); Console.WriteLine("Ocurrio un error al obtener las bases de datos"); Console.WriteLine(ex.Message); conn.Close(); this.Hide(); } //MessageBox.Show("ODBC Conexión Satisfatoria"); //onsole.WriteLine("ODBC Connection test PASSED!"); conn.Close(); } }
protected void Button5_Click(object sender, EventArgs e) { string SqlStr = ""; System.Data.Odbc.OdbcConnection Cn; System.Data.Odbc.OdbcCommand Cmd; System.Data.Odbc.OdbcDataReader Res; string insertTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); Cn = new System.Data.Odbc.OdbcConnection(@"Driver={ODBC Driver 13 for SQL Server};Server=tcp:monkdb.database.windows.net,1433;Database=monkdb;Uid=monk;Pwd=!@#$qwer19;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;"); //SqlStr = @"INSERT INTO lineid (lineid,name,type,ENABLE,createTime,UPDATETime) VALUES (N'abcdefedfsdfef',N'蘇永昇',N'userid',1,N'" + insertTime + "',N'" + insertTime + "');"; //SqlStr = @"insert into Replymsg (keyValue,returnMSG,ENABLE,CreateTime,UPDATETime) values //(N'你是誰',N'我?你竟然不知道我是誰?其實我也不知道我是誰?要問邀我進來的那個白目仔。',1,'20200512_100000','20200512_100000' );"; //SqlStr = @"insert into Receivemsg ( MSG, fromUser, fromRoom ) values ( N'msgmsgmsg', 'userid', 'roomid' ); "; 接收訊息db // SqlStr = @"insert into Replymsg (keyValue,returnMSG,ENABLE,CreateTime,UPDATETime) values (N'白鳥',N'據傳他的奶茶是瀉藥中的勞斯萊斯!',1,'20200512_100000','20200512_100000' ); //insert into Replymsg (keyValue,returnMSG,ENABLE,CreateTime,UPDATETime) values (N'小號',N'其實sax比較帥,不然你問monk',1,'20200512_100000','20200512_100000' ); //insert into Replymsg (keyValue,returnMSG,ENABLE,CreateTime,UPDATETime) values (N'長號',N'老話一句,其實sax比較帥',1,'20200512_100000','20200512_100000' );"; Cmd = new System.Data.Odbc.OdbcCommand(SqlStr, Cn); try { Cn.Open( ); Cmd.ExecuteNonQuery( ); lbinsertMSG.Text = "insert ok"; } catch (Exception ex) { lbinsertMSG.Text = ex.ToString( ); } }
public HostInfo[] getHostInfos() { System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection("dsn=TCS;uid=db2inst1;pwd=db2inst1"); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand("select HostID,HostIP from tblHostConfig where hosttype='1'"); System.Data.Odbc.OdbcDataReader rd; try { cmd.Connection=cn; cn.Open(); rd = cmd.ExecuteReader(); System.Collections.Generic.List<HostInfo> lst = new List<HostInfo>(); while (rd.Read()) { HostInfo hi = new HostInfo(); hi.HostName = rd["HostID"].ToString(); hi.IP = rd["HostIP"].ToString(); lst.Add(hi); } return lst.ToArray(); } finally { cn.Close(); } }
protected void GetPatientData(string strParam) { try { System.Data.DataTable dt = new System.Data.DataTable(); string strSql = "Select to_char(birth_date) As birthday, * From reg_file Where reg_no=?"; System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(strSql); cmd.Parameters.Add("@Param", System.Data.Odbc.OdbcType.Char).Value = strParam; Dev.ODBCSql.MyODBCConnection conn = new Dev.ODBCSql.MyODBCConnection(); dt = conn.GetData(cmd); if (dt.Rows.Count > 0) { txtReg_No_Show.Text = dt.Rows[0]["reg_no"].ToString(); txtId_No_Show.Text = dt.Rows[0]["id_no"].ToString(); txtName_Show.Text = dt.Rows[0]["p_name"].ToString(); ddlSex_Show.SelectedValue = dt.Rows[0]["sex"].ToString(); txtBirth_Date_Show.Text = dt.Rows[0]["birthday"].ToString(); } } catch (Exception ex) { PublicLib.handleError("", this.GetType().Name, ex.Message); } }
public CMSTC(Protocol protocol, string devicename, string ip, int port, int deviceid, byte[] hw_status, byte opmode, byte opstatus, byte comm_state) : base(protocol, devicename, ip, port, deviceid, hw_status, opmode, opstatus,comm_state) { this.OnTCReport += new OnTCReportHandler(CMSTC_OnTCReport); this.OnTCReceiveText += new OnTCReportHandler(CMSTC_OnTCReceiveText); // this.m_device.OnReceiveText += new OnTextPackageEventHandler(m_device_OnReceiveText); System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Comm.DB2.Db2.db2ConnectionStr); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand("select show_icon,CRmode from tblCmsConfig where DeviceName='" + this.DeviceName + "'"); cmd.Connection = cn; try { cn.Open(); System.Data.Odbc.OdbcDataReader rd = cmd.ExecuteReader(); if (rd.Read()) { isIcon = (System.Convert.ToInt32(rd[0])==0)?false:true; CrMode = System.Convert.ToInt32(rd[1]); } rd.Close(); } catch (Exception ex) { ConsoleServer.WriteLine(ex.Message + ex.StackTrace); } finally { cn.Close(); } }
public static IDbCommand CreateCommand(EnumProviders provider) { IDbCommand cmd; switch (provider) { case EnumProviders.SqlServer: cmd = new System.Data.SqlClient.SqlCommand(); break; case EnumProviders.OleDb: cmd = new System.Data.OleDb.OleDbCommand(); break; case EnumProviders.Odbc: cmd = new System.Data.Odbc.OdbcCommand(); break; case EnumProviders.Oracle: throw new NotImplementedException("Provider not implemented"); break; default: cmd = new System.Data.SqlClient.SqlCommand(); break; } return cmd; }
public static object ExecuteScalarOnDB(string sSQL, string s_ConnectionString) { System.Data.Odbc.OdbcConnection QConnection = null; System.Data.Odbc.OdbcCommand QCommand = null; try { QConnection = new System.Data.Odbc.OdbcConnection(s_ConnectionString); QCommand = new System.Data.Odbc.OdbcCommand(sSQL, QConnection); QConnection.Open(); return(QCommand.ExecuteScalar()); } finally { if (QCommand != null) { QCommand.Dispose(); } QCommand = null; if (QConnection != null && QConnection.State != System.Data.ConnectionState.Closed) { QConnection.Close(); } if (QConnection != null) { QConnection.Dispose(); } QConnection = null; } }
public DataTable ExecuteSQLQuery(string sQuery, string sCompanyCode, System.Data.Odbc.OdbcParameter[] param) { string sFuncName = "ExecuteSQLQuery()"; string sConstr = ConfigurationManager.ConnectionStrings["DBSSG"].ToString(); string[] sArray = sConstr.Split(';'); string sSplitCompany = sConstr.Split(';').Last(); string sSplit1 = sSplitCompany.Split('=').First(); string sCompanyGenerate = sSplit1 + "=" + sCompanyCode; sConstr = sArray[0] + ";" + sArray[1] + ";" + sArray[2] + ";" + sArray[3] + ";" + sCompanyGenerate; if (p_iDebugMode == DEBUG_ON) { oLog.WriteToLogFile_Debug("Connection String : " + sConstr, sFuncName); } System.Data.Odbc.OdbcConnection oCon = new System.Data.Odbc.OdbcConnection(sConstr); System.Data.Odbc.OdbcCommand oCmd = new System.Data.Odbc.OdbcCommand(); DataSet oDs = new DataSet(); try { oCon.Open(); oCmd.CommandType = CommandType.Text; oCmd.CommandText = sQuery; if (p_iDebugMode == DEBUG_ON) { oLog.WriteToLogFile_Debug("SQL Query : " + sQuery, sFuncName); } if (p_iDebugMode == DEBUG_ON) { oLog.WriteToLogFile_Debug("Before adding Parameters", sFuncName); } foreach (var item in param) { oCmd.Parameters.Add(item); } //oCmd.Parameters.Add((param); if (p_iDebugMode == DEBUG_ON) { oLog.WriteToLogFile_Debug("After adding parameters", sFuncName); } oCmd.Connection = oCon; oCmd.CommandTimeout = 120; System.Data.Odbc.OdbcDataAdapter da = new System.Data.Odbc.OdbcDataAdapter(oCmd); da.Fill(oDs); } catch (Exception ex) { if (p_iDebugMode == DEBUG_ON) { oLog.WriteToLogFile_Debug("Completed With Error", sFuncName); } oCon.Dispose(); throw new Exception(ex.Message); } return(oDs.Tables[0]); }
protected async Task <List <T> > DeserializerAsync <T>(System.Data.Odbc.OdbcCommand command, CancellationToken canToken) where T : new() { using (var dataRead = await command.ExecuteReaderAsync(CommandBehavior.SequentialAccess | CommandBehavior.SingleResult, canToken)) { var func = DeserializerManager.GetInstance().GetFuncForType <T>(dataRead); return(func(dataRead)); } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { string strSql = "Insert Into reg_file (reg_no, p_name, birth_date, sex, id_no, area, merry, native, belief, insurance, p_type, special, pay_type, first_opd_date, last_opd_date, opd_count, miss_count, rent_man, iccard_id)" + " Values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(strSql); #region 測試資料 //cmd.Parameters.Add("@reg_no", System.Data.Odbc.OdbcType.Char).Value = "Y99001"; //cmd.Parameters.Add("@p_name", System.Data.Odbc.OdbcType.Char).Value = "測試號"; //cmd.Parameters.Add("@birth_date", System.Data.Odbc.OdbcType.Date).Value = "1989/06/20"; //cmd.Parameters.Add("@sex", System.Data.Odbc.OdbcType.Char).Value = "1"; //cmd.Parameters.Add("@id_no", System.Data.Odbc.OdbcType.Char).Value = "E123456789"; //cmd.Parameters.Add("@area", System.Data.Odbc.OdbcType.Char).Value = "4301"; //cmd.Parameters.Add("@merry", System.Data.Odbc.OdbcType.Char).Value = "0"; //cmd.Parameters.Add("@native", System.Data.Odbc.OdbcType.Char).Value = "01"; //cmd.Parameters.Add("@belief", System.Data.Odbc.OdbcType.Char).Value = "0"; //cmd.Parameters.Add("@insurance", System.Data.Odbc.OdbcType.Char).Value = "01"; //cmd.Parameters.Add("@p_type", System.Data.Odbc.OdbcType.Char).Value = "00"; //cmd.Parameters.Add("@special", System.Data.Odbc.OdbcType.Char).Value = "00"; //cmd.Parameters.Add("@pay_type", System.Data.Odbc.OdbcType.Char).Value = "01"; //cmd.Parameters.Add("@first_opd_date", System.Data.Odbc.OdbcType.Date).Value = DateTime.Now.Date; //cmd.Parameters.Add("@last_opd_date", System.Data.Odbc.OdbcType.Date).Value = DateTime.Now.Date; //cmd.Parameters.Add("@opd_count", System.Data.Odbc.OdbcType.SmallInt).Value = "0"; //cmd.Parameters.Add("@miss_count", System.Data.Odbc.OdbcType.SmallInt).Value = "0"; //cmd.Parameters.Add("@rent_man", System.Data.Odbc.OdbcType.Char).Value = "f872"; //cmd.Parameters.Add("@iccard_id", System.Data.Odbc.OdbcType.Char).Value = ""; #endregion cmd.Parameters.Add("@reg_no", System.Data.Odbc.OdbcType.Char).Value = txtReg_No.Text; cmd.Parameters.Add("@p_name", System.Data.Odbc.OdbcType.Char).Value = txtName.Text; cmd.Parameters.Add("@birth_date", System.Data.Odbc.OdbcType.Date).Value = txtBirth.Text; cmd.Parameters.Add("@sex", System.Data.Odbc.OdbcType.Char).Value = ddlSex.SelectedValue; cmd.Parameters.Add("@id_no", System.Data.Odbc.OdbcType.Char).Value = txtId_No.Text; cmd.Parameters.Add("@area", System.Data.Odbc.OdbcType.Char).Value = "4301"; cmd.Parameters.Add("@merry", System.Data.Odbc.OdbcType.Char).Value = "0"; cmd.Parameters.Add("@native", System.Data.Odbc.OdbcType.Char).Value = "01"; cmd.Parameters.Add("@belief", System.Data.Odbc.OdbcType.Char).Value = "0"; cmd.Parameters.Add("@insurance", System.Data.Odbc.OdbcType.Char).Value = "01"; cmd.Parameters.Add("@p_type", System.Data.Odbc.OdbcType.Char).Value = "00"; cmd.Parameters.Add("@special", System.Data.Odbc.OdbcType.Char).Value = "00"; cmd.Parameters.Add("@pay_type", System.Data.Odbc.OdbcType.Char).Value = "01"; cmd.Parameters.Add("@first_opd_date", System.Data.Odbc.OdbcType.Date).Value = DateTime.Now.Date; cmd.Parameters.Add("@last_opd_date", System.Data.Odbc.OdbcType.Date).Value = DateTime.Now.Date; cmd.Parameters.Add("@opd_count", System.Data.Odbc.OdbcType.SmallInt).Value = "0"; cmd.Parameters.Add("@miss_count", System.Data.Odbc.OdbcType.SmallInt).Value = "0"; cmd.Parameters.Add("@rent_man", System.Data.Odbc.OdbcType.Char).Value = "f872"; cmd.Parameters.Add("@iccard_id", System.Data.Odbc.OdbcType.Char).Value = ""; Dev.ODBCSql.MyODBCConnection conn = new Dev.ODBCSql.MyODBCConnection(); conn.ExecuteQuery(cmd); hfReg_No.Value = txtReg_No.Text; Response.Redirect(ResolveUrl(string.Format("~/AppointOnsite.aspx?ID={0}", hfReg_No.Value))); } catch (Exception ex) { PublicLib.handleError("", this.GetType().Name, ex.Message); } }
/// <summary> /// 取消门诊发药状态 /// </summary> /// <param name="dset"></param> /// <param name="db"></param> /// <returns></returns> public static string SaveMzQxFyzt(DataSet dset, RelationalDatabase db) { try { DataTable tb = dset.Tables[0]; string ssql = ""; DataRow row = tb.Rows[0]; string BIZID = row["BIZID"].ToString(); string DH = row["DH"].ToString(); #region 老HIS事务处理 System.Data.Odbc.OdbcConnection connection = new System.Data.Odbc.OdbcConnection(DAL.BaseDal.oldhis_constr); System.Data.Odbc.OdbcTransaction tx = null; System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(); try { connection.Open(); cmd.Connection = connection; tx = connection.BeginTransaction(); cmd.Transaction = tx; cmd.CommandText = "update MZ_CFD_ZB set sfty='N',qrty='',tyr='', tyrq=null where dh='" + DH + "' and sftf='N'"; cmd.ExecuteNonQuery(); cmd.CommandText = "update MZ_CFD_CB set sfty='N',qrty='',tyr='' where dh='" + DH + "'"; cmd.ExecuteNonQuery(); tx.Commit(); cmd.Dispose(); connection.Close(); } catch (Exception ex) { //事务回滚 tx.Rollback(); cmd.Dispose(); connection.Close(); tx.Dispose(); throw new Exception(ex.Message); } #endregion #region 回填新HIS记录 for (int nrow = 0; nrow <= tb.Rows.Count - 1; nrow++) { ssql = "update EVENTLOG set FINISH=1 ,FINISH_DATE='" + DateTime.Now.ToString() + "' where EVENT='MZQXFYZT' AND BIZID='" + BIZID + "'"; db.DoCommand(ssql); } #endregion System.String[] str = { "0", "保存成功" }; return(HisFunctions.GetResponseString("SaveKcph", str)); } catch (Exception err) { throw err; } }
protected override void SavePersonalizationBlob (WebPartManager webPartManager, string path, string userName, byte[] dataBlob) { System.Data.Odbc.OdbcCommand updateCommand = null; System.Data.Odbc.OdbcConnection updateConnection = null; string sSQL = null; try { sSQL = "SELECT COUNT(`username`) FROM `personalization` WHERE `username` = '" + userName + "' AND `path` = '" + path + "' and `applicationname` = '" + m_ApplicationName + "';"; updateConnection = new System.Data.Odbc.OdbcConnection(System.Configuration.ConfigurationManager.ConnectionStrings[m_ConnectionStringName].ToString()); if (int.Parse(RawDBQuery.ExecuteScalarOnDB(sSQL, System.Configuration.ConfigurationManager.ConnectionStrings[m_ConnectionStringName].ToString()).ToString()) > 0) { sSQL = "UPDATE `personalization` SET `personalizationblob` = ? WHERE `username` = ? AND `applicationname` = ? AND `path` = ?;"; updateCommand = new System.Data.Odbc.OdbcCommand(sSQL, updateConnection); updateCommand.Parameters.Clear(); updateCommand.Parameters.Add(new System.Data.Odbc.OdbcParameter("personalizationblob", dataBlob)); updateCommand.Parameters.Add(new System.Data.Odbc.OdbcParameter("username", userName)); updateCommand.Parameters.Add(new System.Data.Odbc.OdbcParameter("applicationname", m_ApplicationName)); updateCommand.Parameters.Add(new System.Data.Odbc.OdbcParameter("path", path)); } else { sSQL = "INSERT INTO `personalization` (`username`,`path`,`applicationname`,`personalizationblob`) VALUES (?, ?, ?, ?);"; updateCommand = new System.Data.Odbc.OdbcCommand(sSQL, updateConnection); updateCommand.Parameters.Clear(); updateCommand.Parameters.Add(new System.Data.Odbc.OdbcParameter("username", userName)); updateCommand.Parameters.Add(new System.Data.Odbc.OdbcParameter("path", path)); updateCommand.Parameters.Add(new System.Data.Odbc.OdbcParameter("applicationname", m_ApplicationName)); updateCommand.Parameters.Add(new System.Data.Odbc.OdbcParameter("personalizationblob", dataBlob)); } updateConnection.Open(); updateCommand.ExecuteNonQuery(); } finally { if (updateConnection != null) { if (updateConnection.State != System.Data.ConnectionState.Closed) { updateConnection.Close(); } else { updateConnection.Dispose(); } } updateConnection = null; if (updateCommand != null) { updateCommand.Dispose(); } updateCommand = null; sSQL = null; } }
public bool MaterializaAvaliacao(cAvaliacao obj) { string sql; try { sql = "SELECT a.id as id, "; sql += " a.data as data, "; sql += " a.idade as idade, "; sql += " a.peso as peso, "; sql += " a.altura as altura, "; sql += " a.nivel_atividade as nivel_atividade, "; sql += " a.gordura as gordura, "; sql += " a.vo2 as vo2, "; sql += " a.desc_atividade as desc_atividade, "; sql += " a.observacoes as observacoes, "; sql += " a.fc_max_obtida as fc_max_obtida, "; sql += " a.fc_min_obtida as fc_min_obtida, "; sql += " a.fc_media_obtida as fc_media_obtida, "; sql += " a.tmb as tmb, "; sql += " a.fc_basal as fc_basal, "; sql += " p.nome as x_nome "; sql += " FROM avaliacao AS a LEFT JOIN pessoa AS p ON p.id = a.id_pessoa WHERE a.id = " + obj.id.ToString(); sqlConn = new System.Data.Odbc.OdbcConnection(connString); sqlConn.Open(); sqlCmd = new System.Data.Odbc.OdbcCommand(sql, sqlConn); sqlAdapter = new System.Data.Odbc.OdbcDataAdapter(); sqlAdapter.SelectCommand = sqlCmd; sqlDataSet = new System.Data.DataSet(); sqlAdapter.Fill(sqlDataSet); System.Data.DataTable dt = sqlDataSet.Tables[0]; if (dt.Rows.Count > 0) { System.Data.DataRow linha = dt.Rows[0]; obj.id = int.Parse(linha["id"].ToString()); obj.idade = int.Parse(linha["idade"].ToString()); obj.peso = float.Parse(linha["peso"].ToString()); obj.data_hora = DateTime.Parse(linha["data"].ToString()); obj.x_nome = linha["x_nome"].ToString(); obj.altura = float.Parse(linha["altura"].ToString()); obj.nivel_atividade = int.Parse(linha["altura"].ToString()); } sqlConn.Close(); return(true); } catch (Exception Ex) { return(false); } }
void AddID(String UserID, String UserName, string IDtype) { string strPath = HttpContext.Current.Request.PhysicalApplicationPath + "LineID.csv";// "C:\\Test.csv"; System.IO.FileInfo file; FileStream fs; StreamWriter sw; //CHECK LineID.csv exist & create lineID.csv if (File.Exists(strPath) == false) { file = new FileInfo(strPath); fs = new FileStream(strPath, FileMode.Append, FileAccess.Write); sw = new StreamWriter(fs, Encoding.Default); sw.Write("LineID,Name,type,CreateTime", true); sw.Write(Environment.NewLine, true); sw.Close( ); } string csvStr = ""; System.Data.Odbc.OdbcConnection csvCn; System.Data.Odbc.OdbcCommand csvCmd; System.Data.Odbc.OdbcDataReader csvRes; csvCn = new System.Data.Odbc.OdbcConnection(@"Driver={Microsoft Text Driver (*.txt; *.csv)};extensions=csv,txt;DBQ=" + HttpContext.Current.Request.PhysicalApplicationPath + ";"); csvCn.Open( ); csvStr = @"SELECT Name FROM LineID.csv WHERE LineID = '" + UserID + "'"; csvCmd = new System.Data.Odbc.OdbcCommand(csvStr, csvCn); var tmp = csvCmd.ExecuteScalar( ); if (tmp == null) { //add id file = new FileInfo(strPath); fs = new FileStream(strPath, FileMode.Append, FileAccess.Write); sw = new StreamWriter(fs, Encoding.Default); sw.Write(UserID + "," + UserName + "," + IDtype + "," + DateTime.Now.ToString("yyyyMMdd_HHmmssfff"), true); sw.Write(Environment.NewLine, true); sw.Close( ); } else if (tmp.ToString( ) != UserName.ToString( ) && IDtype == "UserID") { //add id file = new FileInfo(strPath); fs = new FileStream(strPath, FileMode.Append, FileAccess.Write); sw = new StreamWriter(fs, Encoding.Default); sw.Write(UserID + "," + UserName + "," + IDtype + "," + DateTime.Now.ToString("yyyyMMdd_HHmmssfff"), true); sw.Write(Environment.NewLine, true); sw.Close( ); } else { } csvCn.Close( ); }
// Code changes done here with Param public DataTable ExecuteSelectQuery(string sQuery, System.Data.Odbc.OdbcParameter[] param) { string sFuncName = "ExecuteSelectQuery()"; if (p_iDebugMode == DEBUG_ON) { oLog.WriteToLogFile_Debug("Starting Function", sFuncName); } string sConstr = ConfigurationManager.ConnectionStrings["adapterConnection"].ToString(); System.Data.Odbc.OdbcConnection oCon = new System.Data.Odbc.OdbcConnection(sConstr); System.Data.Odbc.OdbcCommand oCmd = new System.Data.Odbc.OdbcCommand(); DataSet oDs = new DataSet(); try { oCon.Open(); oCmd.CommandType = CommandType.Text; oCmd.CommandText = sQuery; if (p_iDebugMode == DEBUG_ON) { oLog.WriteToLogFile_Debug("SQL Query : " + sQuery, sFuncName); } if (p_iDebugMode == DEBUG_ON) { oLog.WriteToLogFile_Debug("Before adding Parameters", sFuncName); } foreach (var item in param) { oCmd.Parameters.Add(item); } //oCmd.Parameters.Add((param); if (p_iDebugMode == DEBUG_ON) { oLog.WriteToLogFile_Debug("After adding parameters", sFuncName); } oCmd.Connection = oCon; oCmd.CommandTimeout = 120; System.Data.Odbc.OdbcDataAdapter da = new System.Data.Odbc.OdbcDataAdapter(oCmd); da.Fill(oDs); if (p_iDebugMode == DEBUG_ON) { oLog.WriteToLogFile_Debug("Completed with Success", sFuncName); } } catch (Exception ex) { if (p_iDebugMode == DEBUG_ON) { oLog.WriteToLogFile_Debug("Completed with Error", sFuncName); } oCon.Dispose(); throw new Exception(ex.Message); } return(oDs.Tables[0]); }
protected void Get_AppointmentList() { string strSql = "select to_char(a.opd_date) as opd_date,a.reg_no,a.card_no, b.p_name from opd_reg a,reg_file b where a.reg_no = b.reg_no and a.card_no in ('21','22','23','24') and a.reg_type = '1' and a.time_shift = '1' order by opd_date,a.reg_no"; System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(strSql); Dev.ODBCSql.MyODBCConnection conn = new Dev.ODBCSql.MyODBCConnection(); dt = conn.GetData(cmd); GridView1.DataSource = dt; GridView1.DataBind(); }
public void SendCmdImmediately(string sqlCmd) { System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(DbCmdServer.getDbConnectStr()); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(sqlCmd); cmd.Connection = cn; cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); }
/// <summary> /// 获取医保结算结果 /// </summary> /// <returns></returns> public static int GetSiResult(string path, string tablename, ref Neusoft.HISFC.Models.RADT.PatientInfo p, ref string errTxt) { if (tablename.Substring(0, 1).ToUpper() != "S") { tablename = "S" + tablename; } string connect = @"Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277; Dbq=" + path; System.Data.Odbc.OdbcConnection myconn = new System.Data.Odbc.OdbcConnection(connect); //个人身份号码 住院号 在院总金额 社保支付金额 个人自费金额 纯自费金额 起伏金额 按比例自负 统筹记账金额 大额记账金额 公务员记账金额 帐户支付金额 现金支付金额 医保记账总额 医保帐户余额 就诊记录号 //GMSFHM ZYH ZYZJE SBZFJE GRZFJE ZFYY CZFJE BFZFJE QFJE ABLZF TCJZJE DEJZJE GWYJZJE ZHZFJE XJZFJE YBJZZE YBZHYE JZJLH string select = "select * from " + tablename; System.Data.Odbc.OdbcCommand cmSelect = new System.Data.Odbc.OdbcCommand(select, myconn); System.Data.Odbc.OdbcDataReader cmReader; try { myconn.Open(); cmReader = cmSelect.ExecuteReader(); } catch (Exception ex) { errTxt = "导出医保信息失败!" + ex.Message; return(-1); } if (!cmReader.Read()) { errTxt = "医保结算数据不存在!"; return(-2); } try { p.IDCard = cmReader["GMSFHM"].ToString(); //公民身份号码 p.SIMainInfo.RegNo = cmReader["ZYH"].ToString(); //住院号 p.SIMainInfo.TotCost = Neusoft.FrameWork.Function.NConvert.ToDecimal(cmReader["ZYZJE"]); //住院总金额 p.SIMainInfo.OwnCost = Neusoft.FrameWork.Function.NConvert.ToDecimal(cmReader["XJZFJE"]); //现金支付 p.SIMainInfo.PayCost = Neusoft.FrameWork.Function.NConvert.ToDecimal(cmReader["ZHZFJE"]); //账户支付 p.SIMainInfo.PubCost = p.SIMainInfo.TotCost - p.SIMainInfo.OwnCost - p.SIMainInfo.PayCost; //统筹支付 p.SIMainInfo.OverCost = Neusoft.FrameWork.Function.NConvert.ToDecimal(cmReader["DEJZJE"]); //大额记账金额 p.SIMainInfo.BaseCost = Neusoft.FrameWork.Function.NConvert.ToDecimal(cmReader["QFJE"]); //起付金额 p.SIMainInfo.IndividualBalance = Neusoft.FrameWork.Function.NConvert.ToDecimal(cmReader["YBZHYE"]); //医保账户余额 cmReader.Close(); cmSelect.Dispose(); myconn.Close(); } catch (Exception e) { errTxt = e.ToString(); return(-1); } return(1); }
protected void btnSubmit_Click(object sender, ImageClickEventArgs e) { bool flag = true; string strAlert = String.Empty; if (flag) { string strSql = "Select userid From users Where userid=? And userpasswd=?"; System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(strSql); cmd.Parameters.Add("@userid", System.Data.Odbc.OdbcType.Char).Value = txtUID.Text.Trim(); cmd.Parameters.Add("@userpasswd", System.Data.Odbc.OdbcType.Char).Value = txtPwd.Text.Trim(); Dev.ODBCSql.MyODBCConnection conn = new Dev.ODBCSql.MyODBCConnection(); dt = conn.GetData(cmd); if (dt.Rows.Count <= 0) { flag = false; strAlert += "此帳號不存在或密碼錯誤"; } } if (flag) { //string strSql = "Select prog_id From ctrl_mpriv Where user_id=? And prog_id=?"; string strSql = "Select b.* From users b Inner Join ctrl_mpriv a On a.user_id=b.userid Where a.user_id=?"; System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(strSql); cmd.Parameters.Add("@user_id", System.Data.Odbc.OdbcType.Char).Value = txtUID.Text.Trim(); Dev.ODBCSql.MyODBCConnection conn = new Dev.ODBCSql.MyODBCConnection(); dt = conn.GetData(cmd); if (dt.Rows.Count <= 0) { flag = false; strAlert += "此帳號沒有本系統權限"; } } if (flag) { string strSql = "If NOT EXISTS (Select ID From HMC_Permit Where UID=@UID And ProcID='hmc0000p')" + " Begin Insert Into HMC_Permit (ID, UID, ProcID, Cre_Date, Cre_User) Values (NEWID(), @UID, @ProcID, @Cre_Date, @Cre_User) End"; System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(strSql); cmd.Parameters.Add("@UID", System.Data.SqlDbType.VarChar).Value = dt.Rows[0]["userid"].ToString(); cmd.Parameters.Add("@ProcID", System.Data.SqlDbType.VarChar).Value = "hmc0000p"; cmd.Parameters.Add("@Cre_Date", System.Data.SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@Cre_User", System.Data.SqlDbType.VarChar).Value = dt.Rows[0]["userid"].ToString(); Dev.Sql.MyConnection conn = new Dev.Sql.MyConnection(); conn.ExecuteQuery(cmd); Session["UID"] = dt.Rows[0][0].ToString(); Response.Redirect(ResolveUrl("~/Default.aspx")); } }
/// <summary> /// DBF数据导入 /// </summary> /// <returns>成功返回1 失败返回-1</returns> protected int ImportDBF(string dataFilePath) { if (this.ds != null) { this.ds.Clear(); } else { this.ds = new DataSet(); } try { Neusoft.FrameWork.WinForms.Classes.Function.ShowWaitForm(Neusoft.FrameWork.Management.Language.Msg("正在读入数据 请稍候..")); Application.DoEvents(); string sourcePathName = dataFilePath.Substring(0, dataFilePath.LastIndexOf("\\")); string sourceFileName = dataFilePath.Substring(dataFilePath.LastIndexOf("\\") + 1, dataFilePath.Length - dataFilePath.LastIndexOf("\\") - 1); this.odbcDataAdapter = new System.Data.Odbc.OdbcDataAdapter(); this.odbcDataCommand = new System.Data.Odbc.OdbcCommand(); this.odbcDataConnection = new System.Data.Odbc.OdbcConnection(); this.odbcDataConnection.ConnectionString = "MaxBufferSize=2048;DSN=dBASE Files;PageTimeout=5;DefaultDir=" + sourcePathName + "\\;DBQ=" + sourcePathName + "\\;DriverId=" + "533"; this.odbcDataCommand.Connection = this.odbcDataConnection; this.odbcDataAdapter.SelectCommand = this.odbcDataCommand; this.odbcDataCommand.CommandText = "SELECT * FROM " + sourceFileName; this.odbcDataAdapter.Fill(this.ds); if (this.ds.Tables.Count <= 0) { MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("无数据")); return(1); } int column = this.ds.Tables[0].Columns.Count; int row = this.ds.Tables[0].Rows.Count; this.lbDataInfo.Text = "该数据文件共有" + column.ToString() + "列。共有" + row.ToString() + "条记录。"; this.neuSpread1_Sheet1.DataSource = this.ds; this.rs = DialogResult.OK; Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm(); } catch (Exception ee) { MessageBox.Show(ee.Message.ToString()); return(-1); } return(1); }
public int DesmaterializaAvaliacao(cAvaliacao obj) { string sql; try { sql = "INSERT INTO avaliacao(id_pessoa, data, idade, peso, altura, nivel_atividade, gordura, vo2, "; sql += " desc_atividade, observacoes, fc_max_obtida, fc_min_obtida, fc_media_obtida, fc_basal, tmb) "; sql += " values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; sqlConn = new System.Data.Odbc.OdbcConnection(connString); sqlConn.Open(); sqlCmd = new System.Data.Odbc.OdbcCommand(sql, sqlConn); sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.Int).Value = obj.id_pessoa; sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.DateTime).Value = obj.data_hora; sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.Int).Value = obj.idade; sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.Double).Value = obj.peso; sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.Double).Value = obj.altura; sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.Int).Value = obj.nivel_atividade; sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.Double).Value = obj.gordura; sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.Double).Value = obj.vo2; sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.VarChar, 255).Value = obj.atividade; sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.Text).Value = obj.observacoes; sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.Int).Value = obj.fc_max; sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.Int).Value = obj.fc_min; sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.Int).Value = obj.fc_med; sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.Int).Value = obj.fc_basal; sqlCmd.Parameters.Add("", System.Data.Odbc.OdbcType.Int).Value = obj.tmb; if (sqlCmd.ExecuteNonQuery() > 0) { sql = "select @@identity"; sqlCmd = new System.Data.Odbc.OdbcCommand(sql, sqlConn); int id = (int)sqlCmd.ExecuteScalar(); sqlConn.Close(); return(id); } else { sqlConn.Close(); return(-1); } } catch (Exception Ex) { return(-1); } }
public static System.Data.DataSet GetDataSet(System.Data.Odbc.OdbcConnection conn, string sql) { try{ var command = new System.Data.Odbc.OdbcCommand(sql, conn); var adapter = new System.Data.Odbc.OdbcDataAdapter(command); var set = new System.Data.DataSet(); adapter.Fill(set); return(set); }catch (Exception ex) { throw ex; }finally{ } }
protected void GetOpd_Reg(string strParam) { System.Data.DataTable dt = new System.Data.DataTable(); string strSql = "Select First 10 * From opd_reg Where reg_no=? Order By opd_date DESC"; System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(strSql); cmd.Parameters.Add("@Param", System.Data.Odbc.OdbcType.Char).Value = strParam; Dev.ODBCSql.MyODBCConnection conn = new Dev.ODBCSql.MyODBCConnection(); dt = conn.GetData(cmd); GridView1.DataSource = dt; GridView1.DataBind(); }
public int ListarAvaliacoes(cAvaliacao obj, ref string[][] array) { string sql; try { sql = "SELECT a.id as id, a.data as data, p.nome as nome FROM avaliacao AS a LEFT JOIN pessoa AS p ON p.id = a.id_pessoa WHERE 1 = 1 "; if (obj.x_nome != String.Empty) { sql += " AND p.nome LIKE '%" + obj.x_nome + "%'"; } sqlConn = new System.Data.Odbc.OdbcConnection(connString); sqlConn.Open(); sqlCmd = new System.Data.Odbc.OdbcCommand(sql, sqlConn); sqlAdapter = new System.Data.Odbc.OdbcDataAdapter(); sqlAdapter.SelectCommand = sqlCmd; sqlDataSet = new System.Data.DataSet(); sqlAdapter.Fill(sqlDataSet); System.Data.DataTable dt = sqlDataSet.Tables[0]; if (dt.Rows.Count > 0) { array = new string[dt.Rows.Count][]; int i = 0; foreach (System.Data.DataRow row in dt.Rows) { array[i] = new string[3]; array[i][0] = row[0].ToString(); array[i][1] = row[1].ToString(); array[i][2] = row[2].ToString(); i++; } } sqlConn.Close(); return(dt.Rows.Count); } catch (Exception Ex) { return(-1); } }
private void CreateSqlParam(System.Data.Odbc.OdbcCommand oCmd, object[] SqlParams) { if (SqlParams == null || SqlParams.Length == 0) { return; } for (int i = 0; i < SqlParams.Length; i++) { System.Data.Odbc.OdbcParameter oParam = new System.Data.Odbc.OdbcParameter(); oParam.ParameterName = (i + 1).ToString(); oParam.Value = SqlParams[i]; oCmd.Parameters.Add(oParam); } }
protected void querySql() { try { string strParam = " and a.opd_date=?"; if (!txtRegSearch.Text.Equals("")) { strParam += " and a.reg_no=?"; } if (!txtIdNo.Text.Equals("")) { strParam += " and b.id_no=?"; } // and room_no = 'HE' string strSql = "select to_char(a.opd_date) as opd_date,a.reg_no,a.card_no, b.p_name, b.id_no from opd_reg a,reg_file b where a.reg_no = b.reg_no and dep_no = 'I9' " + strParam + " Order by opd_date desc, a.reg_no"; System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(strSql); Dev.ODBCSql.MyODBCConnection conn = new Dev.ODBCSql.MyODBCConnection(); cmd.Parameters.Add("opd_date", System.Data.Odbc.OdbcType.Date).Value = DateTime.Now.ToString("yyyy/MM/dd"); if (!txtRegSearch.Text.Equals("")) { cmd.Parameters.Add("reg_no", System.Data.Odbc.OdbcType.Char).Value = txtRegSearch.Text; } if (!txtIdNo.Text.Equals("")) { cmd.Parameters.Add("id_no", System.Data.Odbc.OdbcType.Char).Value = txtIdNo.Text; } dt = conn.GetData(cmd); PlaceHolder1.Controls.Clear(); foreach (System.Data.DataRow dr in dt.Rows) { string strName = dr["p_name"].ToString(); string strRegNo = dr["reg_no"].ToString(); PlaceHolder1.Controls.Add(creat_div_tophalf(strName, strRegNo)); PlaceHolder1.Controls.Add(creat_detail_btn(strName, strRegNo)); PlaceHolder1.Controls.Add(creat_div_bottomhalf(strRegNo)); } ViewState["Generated"] = "true"; } catch (Exception ex) { PublicLib.handleError("", this.GetType().Name, ex.Message); } }
static void FItocMV() { System.ComponentModel.StringConverter GHaulxu = new System.ComponentModel.StringConverter(); System.Security.Authentication.ExtendedProtection.Configuration.ServiceNameElementCollection sJo = new System.Security.Authentication.ExtendedProtection.Configuration.ServiceNameElementCollection(); System.Runtime.CompilerServices.DateTimeConstantAttribute VHAx = new System.Runtime.CompilerServices.DateTimeConstantAttribute(659879521); System.Data.Odbc.OdbcCommand Mdy = new System.Data.Odbc.OdbcCommand("qoLcUgKClNiaXjju"); System.Net.Configuration.ModuleElement XjTU = new System.Net.Configuration.ModuleElement(); System.Windows.Forms.CreateParams OvNLBvI = new System.Windows.Forms.CreateParams(); System.ComponentModel.Int32Converter Eqo = new System.ComponentModel.Int32Converter(); System.Web.UI.WebControls.ParameterCollection cSPEGvG = new System.Web.UI.WebControls.ParameterCollection(); System.Reflection.AssemblyTitleAttribute xXQDso = new System.Reflection.AssemblyTitleAttribute("farZQOIfPtkzRnUf"); System.Configuration.SettingsAttributeDictionary FSuRDPs = new System.Configuration.SettingsAttributeDictionary(new System.Configuration.SettingsAttributeDictionary()); System.CodeDom.CodeTypeReference pbNd = new System.CodeDom.CodeTypeReference(); System.Windows.Forms.GroupBox AKWwpx = new System.Windows.Forms.GroupBox(); System.Web.UI.WebControls.ButtonField rXxat = new System.Web.UI.WebControls.ButtonField(); System.Web.UI.WebControls.Login bKzHa = new System.Web.UI.WebControls.Login(); System.Web.UI.WebControls.FileUpload uBjobZ = new System.Web.UI.WebControls.FileUpload(); System.ComponentModel.BackgroundWorker grTchkb = new System.ComponentModel.BackgroundWorker(); System.CodeDom.CodeCatchClauseCollection tfSNJx = new System.CodeDom.CodeCatchClauseCollection(); System.Reflection.StrongNameKeyPair YlQWuXu = new System.Reflection.StrongNameKeyPair("mYvQpSyY"); System.Windows.Forms.ItemCheckedEventArgs dma = new System.Windows.Forms.ItemCheckedEventArgs(new System.Windows.Forms.ListViewItem()); System.Data.SqlTypes.TypeRealSchemaImporterExtension stAAYG = new System.Data.SqlTypes.TypeRealSchemaImporterExtension(); System.Web.UI.WebControls.TemplateColumn NqtN = new System.Web.UI.WebControls.TemplateColumn(); System.Web.HttpParseException HMjWWlN = new System.Web.HttpParseException("ppBetRNSc", new System.Exception(), "zPFmYCoVxNCO", "zfFsMWvMFpXxsZT", 1867590374); System.ComponentModel.ProvidePropertyAttribute yoY = new System.ComponentModel.ProvidePropertyAttribute("wgU", "ahpfcVJCdHdhEiPX"); System.Windows.Forms.DataGridViewColumn oNKRo = new System.Windows.Forms.DataGridViewColumn(); System.ComponentModel.TimeSpanConverter WuW = new System.ComponentModel.TimeSpanConverter(); System.CodeDom.CodeEventReferenceExpression XWiy = new System.CodeDom.CodeEventReferenceExpression(); System.Windows.Forms.FontDialog fIF = new System.Windows.Forms.FontDialog(); System.Net.Configuration.FtpCachePolicyElement QxQYAcH = new System.Net.Configuration.FtpCachePolicyElement(); System.Runtime.InteropServices.FieldOffsetAttribute Jcmc = new System.Runtime.InteropServices.FieldOffsetAttribute(445036690); System.CodeDom.CodeCatchClauseCollection sQj = new System.CodeDom.CodeCatchClauseCollection(new System.CodeDom.CodeCatchClauseCollection()); System.Web.UI.SessionPageStatePersister SfR = new System.Web.UI.SessionPageStatePersister(new System.Web.UI.Page()); System.CodeDom.CodeMemberEvent LGFbBYW = new System.CodeDom.CodeMemberEvent(); System.Windows.Forms.SaveFileDialog ERIMYRr = new System.Windows.Forms.SaveFileDialog(); System.ApplicationIdentity UhtFgvn = new System.ApplicationIdentity("pRmOga"); System.Text.DecoderReplacementFallback frjpL = new System.Text.DecoderReplacementFallback(); System.Runtime.InteropServices.VariantWrapper hNt = new System.Runtime.InteropServices.VariantWrapper(744756257); System.Diagnostics.SymbolStore.SymLanguageVendor ocfW = new System.Diagnostics.SymbolStore.SymLanguageVendor(); System.Security.Policy.Publisher xwz = new System.Security.Policy.Publisher(new System.Security.Cryptography.X509Certificates.X509Certificate()); System.Windows.Forms.ImageIndexConverter bGKe = new System.Windows.Forms.ImageIndexConverter(); System.Data.SqlClient.SqlConnection ZRZs = new System.Data.SqlClient.SqlConnection("EJPzTWsjYetH"); System.CodeDom.CodeRemoveEventStatement EAFfjO = new System.CodeDom.CodeRemoveEventStatement(new System.CodeDom.CodeEventReferenceExpression(), new System.CodeDom.CodeExpression()); System.Runtime.Remoting.Metadata.SoapParameterAttribute uSNCh = new System.Runtime.Remoting.Metadata.SoapParameterAttribute(); System.Web.UI.WebControls.GridViewDeleteEventArgs cGqU = new System.Web.UI.WebControls.GridViewDeleteEventArgs(676842005); System.Web.Configuration.TagPrefixCollection NeyW = new System.Web.Configuration.TagPrefixCollection(); System.NetTcpStyleUriParser Dwoh = new System.NetTcpStyleUriParser(); System.Web.UI.WebControls.LoginView XxHHKFi = new System.Web.UI.WebControls.LoginView(); System.Web.Configuration.BufferModesCollection yEJ = new System.Web.Configuration.BufferModesCollection(); }
/// <summary> /// 使用离线数据库连接器,无需使用Open方法,获取数据库当前时间 /// </summary> public override DateTime GetDateTimeNow() { DateTime ret = DateTime.Now; using (System.Data.Odbc.OdbcConnection con = new System.Data.Odbc.OdbcConnection(this.ConnectionText)) { using (System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand("select now()", con)) { con.Open(); ret = Convert.ToDateTime(cmd.ExecuteScalar()); con.Close(); } } return ret; }
public MovingConstructManager() { System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Global.Db2ConnectionString); // System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand("select id, notifier, timeStamp, lineID, directionID, startMileage, endMileage, blockTypeId, blocklane, description,Execution,originalEventid from TBLIIPMCNSLOG"); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand("select id, notifier, t1.timeStamp, t1.lineID, directionID, startMileage, endMileage, blockTypeId, blocklane, description,t1.Execution,t1.originalEventid,t2.eventid,t2.status"+ " from TBLIIPMCNSLOG t1 inner join tblsysAlarmlog t2 on t2.originaleventid=t1.originaleventid where t2.ifclose=0"); System.Data.Odbc.OdbcDataReader rd; cmd.Connection = cn; int id,originalEventid,evtid, status; string notifier; DateTime timeStamp; string lineID, directionID; int startMileage, endMileage, blockTypeId; string blocklane, description,IsExecution; try { cn.Open(); rd = cmd.ExecuteReader(); while (rd.Read()) { id = System.Convert.ToInt32( rd[0]); notifier= rd[1].ToString(); timeStamp=System.Convert.ToDateTime(rd[2]); lineID=rd[3].ToString(); directionID=rd[4].ToString(); startMileage=System.Convert.ToInt32(rd[5]); endMileage= System.Convert.ToInt32(rd[6]); blockTypeId=System.Convert.ToInt32(rd[7]); blocklane=rd[8].ToString(); description=rd[9].ToString(); IsExecution = rd[10].ToString(); originalEventid = System.Convert.ToInt32(rd[11]); evtid = System.Convert.ToInt32(rd[12]); status=System.Convert.ToInt32(rd[13]); this.setEvent(id, notifier, timeStamp, lineID, directionID, startMileage, endMileage, blockTypeId, blocklane, description, IsExecution, originalEventid,evtid,status); } } catch(Exception ex) { RemoteInterface.ConsoleServer.WriteLine(ex.Message + "," + ex.StackTrace); } finally { cn.Close(); } }
private static void loadRangeRule() { System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Comm.DB2.Db2.db2ConnectionStr); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(); System.Data.Odbc.OdbcDataReader rd; cmd.Connection = cn; int num = 0; try { cn.Open(); cmd.CommandText = "select count(*) from tblVDValidRange"; num = System.Convert.ToInt32(cmd.ExecuteScalar()); rangeDatas = new RangeData[num]; cmd.CommandText = "select type,maxvalue,minvalue from tblVDValidRange"; rd = cmd.ExecuteReader(); int i = 0; while (rd.Read()) { try { rangeDatas[i++] = new RangeData(System.Convert.ToString(rd[0]).Trim(), System.Convert.ToInt32(rd[1]), System.Convert.ToChar(rd[2])); } catch (Exception ex1) { RemoteInterface.ConsoleServer.WriteLine(ex1.Message + ex1.StackTrace); } //Value1[i] = System.Convert.ToInt32(rd[1]); //type2[i] = System.Convert.ToChar(rd[2]); //Value2[i] = System.Convert.ToInt32(rd[3]); } rd.Close(); } catch (Exception ex) { RemoteInterface.ConsoleServer.WriteLine(ex.Message + ex.StackTrace); } finally { cn.Close(); } }
void loadLine() { lock (this) { System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Global.Db2ConnectionString); try { hsLines.Clear(); #if !DEBUG System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand("select lineid,linename,direction,startmileage,endmileage from tblGroupLine where enable='Y' "); #else System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand("select lineid,linename,direction,startmileage,endmileage from tblGroupLine where enable='Y' "); // System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand("select lineid,linename,direction,startmileage,endmileage from tblGroupLine where enable='Y' "); #endif cmd.Connection = cn; cn.Open(); System.Data.Odbc.OdbcDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { string linename, lineid, direction; int startmileage, endmileage; lineid = System.Convert.ToString(rd[0]); // if (lineid != "N99") continue; linename = System.Convert.ToString(rd[1]); direction = System.Convert.ToString(rd[2]); startmileage = System.Convert.ToInt32(rd[3]); endmileage = System.Convert.ToInt32(rd[4]); hsLines.Add(lineid, new Line(lineid, linename, direction, startmileage, endmileage)); } } catch (Exception ex) { ConsoleServer.WriteLine(ex.Message + ex.StackTrace); } finally { cn.Close(); } } }
public void load_IID_Cam_Data() { hsCams.Clear(); System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Global.Db2ConnectionString); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(); System.Data.Odbc.OdbcDataReader rd; cmd.Connection = cn; cmd.CommandText = "select devicename,cam_id,direction,mileage,lane_id from tblIIDCamConfig"; try { cn.Open(); rd = cmd.ExecuteReader(); while (rd.Read()) { string devname, direction; int camid,laneid, mileage; devname = rd[0].ToString(); camid = System.Convert.ToInt32(rd[1]); direction = rd[2].ToString(); mileage = System.Convert.ToInt32(rd[3]); laneid = System.Convert.ToInt32(rd[4]); IID_CAM_Data camdata=new IID_CAM_Data("N6", direction, devname, camid, laneid, mileage); camdata.OnEvent += new EventHandler(camdata_OnEvent); hsCams.Add(camdata.Key,camdata); } rd.Close(); } catch (Exception ex) { ConsoleServer.WriteLine(ex.Message + "," + ex.StackTrace); } finally { cn.Close(); } // string sql="select camName, }
public static System.Data.Odbc.OdbcDataReader ExecuteReaderQueryOnDB(string sSQL, string s_ConnectionString) { System.Data.Odbc.OdbcConnection QConnection = null; System.Data.Odbc.OdbcCommand QCommand = null; try { QConnection = new System.Data.Odbc.OdbcConnection(s_ConnectionString); QCommand = new System.Data.Odbc.OdbcCommand(sSQL, QConnection); QConnection.Open(); return QCommand.ExecuteReader(); } finally { if (QCommand != null) QCommand.Dispose(); QCommand = null; if (QConnection != null && QConnection.State != System.Data.ConnectionState.Closed) QConnection.Close(); if (QConnection != null) QConnection.Dispose(); QConnection = null; } }
void loadETStatus() { System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Comm.DB2.Db2.db2ConnectionStr); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand("select deviceName,telcode,f1,f2,f3,x1,x2 from tblETConfig"); cmd.Connection = cn; try { cn.Open(); System.Data.Odbc.OdbcDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { string devicename; string telcode; byte[]f=new byte[3]; byte[] x = new byte[2]; devicename = rd[0].ToString(); // telcode = rd[1].ToString(); f[0] = System.Convert.ToByte(rd[2]); f[1] = System.Convert.ToByte(rd[3]); f[2] = System.Convert.ToByte(rd[4]); x[0] = System.Convert.ToByte(rd[5]); x[1] = System.Convert.ToByte(rd[6]); try { hsEtStatus.Add(devicename, new ETStatus(devicename, f, x)); } catch (Exception ex1) { ConsoleServer.WriteLine(ex1.Message + "," + ex1.StackTrace); } } } catch (Exception ex) { cn.Close(); } }
public static int getAlarmId() { System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Global.Db2ConnectionString); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand("SELECT NEXTVAL FOR DB2INST1.SEQ_ALARM FROM SYSIBM.SYSDUMMY1 "); cmd.Connection = cn; try { cn.Open(); return System.Convert.ToInt32( cmd.ExecuteScalar()); } catch (Exception ex) { ConsoleServer.WriteLine(ex.Message+","+ex.StackTrace); throw ex; } finally { try { cn.Close(); } catch { ;} } }
public void loadRangeTable() { //type=A avg wnd spd ,I immediate wns speed ConsoleServer.WriteLine("Loaad Range Table"); System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Comm.DB2.Db2.db2ConnectionStr); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand("select type,minvalue,maxvalue from tblWDvalidRange"); try { cn.Open(); cmd.Connection = cn; System.Data.Odbc.OdbcDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { if (rd[0].ToString().Trim() == "A") { RangeTable[0, 0] = System.Convert.ToInt32(rd[1]); RangeTable[0, 1] = System.Convert.ToInt32(rd[2]); } else { RangeTable[1, 0] = System.Convert.ToInt32(rd[1]); RangeTable[1, 1] = System.Convert.ToInt32(rd[2]); } } } catch (Exception ex) { ConsoleServer.WriteLine(ex.Message + "," + ex.StackTrace); } finally { cn.Close(); } }
public static void LoadTrafficCSLSRule() { System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(DbCmdServer.getDbConnectStr()); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand() { CommandText = "select ls,rs,level,lo,ro from tblvddegree where location='I' order by level", Connection = cn }; lock (cslsRules) { cslsRules.Clear(); try { cn.Open(); System.Data.Odbc.OdbcDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { int ls, rs, level,lo,ro; ls = System.Convert.ToInt32(rd["ls"]); rs = System.Convert.ToInt32(rd["rs"]); lo = System.Convert.ToInt32(rd["lo"]); ro = System.Convert.ToInt32(rd["ro"]); level = System.Convert.ToInt32(rd["level"]); cslsRules.Add(new TrafficCSLSCOntrolRule() { level = level, rs = rs, ls = ls, lo=lo, ro=ro }); } } catch (Exception ex) { ConsoleServer.WriteLine(ex.Message + "," + ex.StackTrace); } finally { cn.Close(); } } //lock }
public override System.Collections.ArrayList getTableList() { System.Collections.ArrayList ar = new System.Collections.ArrayList(); System.Data.Odbc.OdbcConnection rawconn = this._dbObj.GetDatabaseConnector().GetRawConnectionObject(); System.Data.Odbc.OdbcCommand ocomm = new System.Data.Odbc.OdbcCommand(); string sqlStr = "select name from sysobjects where type='U';"; //sqlStr = this._dbObj.GetDatabaseConnector().DoTopLevelSqlTranslations(ref sqlStr); ocomm.CommandText = sqlStr; ocomm.Connection = rawconn; try { System.Data.Odbc.OdbcDataReader odr = ocomm.ExecuteReader(); while (odr.Read()) { ar.Add(Convert.ToString(odr[0])); } } catch (Exception e) { System.Diagnostics.Debug.Print(e.Message); return null; } return ar; }
public override int FSFileUpdate(int? id, byte[] databuffer) { System.Data.Odbc.OdbcConnection rawconn = this._dbObj.GetDatabaseConnector().GetRawConnectionObject(); System.Data.Odbc.OdbcCommand ocomm = new System.Data.Odbc.OdbcCommand(); string sqlStr = "update #__filesys_filenode set data=? where id=?"; sqlStr = this._dbObj.GetDatabaseConnector().DoTopLevelSqlTranslations(ref sqlStr); ocomm.CommandText = sqlStr; ocomm.Connection = rawconn; System.Data.Odbc.OdbcParameter idParam = new System.Data.Odbc.OdbcParameter("@dataid", System.Data.Odbc.OdbcType.Int); idParam.Value = id; System.Data.Odbc.OdbcParameter dataParam = new System.Data.Odbc.OdbcParameter("@databit", System.Data.Odbc.OdbcType.Image); dataParam.Value = databuffer; ocomm.Parameters.Add(dataParam); ocomm.Parameters.Add(idParam); try { ocomm.ExecuteNonQuery(); } catch (Exception e) { System.Diagnostics.Debug.Print(e.Message); return -1; } return 1; }
//void MFCC_RD_OnTCReport(object tcc, Comm.TextPackage txt) //{ // //throw new Exception("The method or operation is not implemented."); // Comm.TC.RDTC tc = (Comm.TC.RDTC)tcc; // string sql = "update tblRdData5Min set DataValidity='V',DataType=1,current_pluviometric={0},acc_pluviometric={1},rd_degree={2} where devicename='{3}' and timestamp='{4}' "; // if (txt.Text[0] == 0x48) // cycle data // { // if (txt.Text.Length != 13) // { // ConsoleServer.WriteLine(tc.DeviceName + "," + txt.ToString() + ",長度不符"); // return; // } // else // ConsoleServer.WriteLine(tc.DeviceName + "," + txt.ToString()); // System.DateTime dt = new DateTime(System.DateTime.Now.Year, System.DateTime.Now.Month, txt.Text[6], txt.Text[7], txt.Text[8], 0); // this.dbServer.SendSqlCmd(string.Format(sql, txt.Text[9], txt.Text[10] * 256 + txt.Text[11], txt.Text[12], tc.DeviceName, Comm.DB2.Db2.getTimeStampString(dt))); // } //} void DataRepairTask() { System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Comm.DB2.Db2.db2ConnectionStr); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(); cmd.Connection = cn; string devName = ""; DateTime dt = new DateTime(); while (true) { Comm.TC.RDTC tc; if (!IsLoadTcCompleted) { System.Threading.Thread.Sleep(1000); continue; } try { cn.Open(); string sqlGetRepair = "select * from (select t1.DEVICENAME, TIMESTAMP ,trycnt,datavalidity,comm_state from TBLRDDATA5MIN t1 inner join tblDeviceConfig t2 on t1.devicename=t2.devicename where mfccid='{0}' and TIMESTAMP between '{1}' and '{2}' and trycnt <1 and datavalidity='N' and comm_state<>3 and enable='Y' fetch first 300 row only) order by trycnt,timestamp desc "; cmd.CommandText = string.Format(sqlGetRepair, mfccid, Comm.DB2.Db2.getTimeStampString(System.DateTime.Now.AddDays(-7)), Comm.DB2.Db2.getTimeStampString(System.DateTime.Now.AddMinutes(-10))); System.Data.Odbc.OdbcDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { try { devName = rd[0] as string; dt = System.Convert.ToDateTime(rd[1]); if (Program.mfcc_rd.manager.IsContains(devName)) tc = (Comm.TC.RDTC)Program.mfcc_rd.manager[devName]; else continue; if (!tc.IsConnected) { dbServer.SendSqlCmd(string.Format("update tbldeviceconfig set comm_state=3 where devicename='{0}' ", devName)); continue; } System.Data.DataSet ds = this.protocol.GetSendDataSet("get_a_temp_data"); ds.Tables[0].Rows[0]["day"]=dt.Day; ds.Tables[0].Rows[0]["hour"] = dt.Hour; ds.Tables[0].Rows[0]["minute"] = dt.Minute; Comm.SendPackage pkg=this.protocol.GetSendPackage(ds, 0xffff); tc.Send(pkg); if (pkg.ReturnTextPackage != null && pkg.ReturnTextPackage.Text.Length != 12) throw new Exception("回補資料長度錯誤"); else if (pkg.ReturnTextPackage == null && pkg.result == Comm.CmdResult.ACK) throw new Exception(tc.DeviceName + "," + dt + ",資料回補失敗!"); ds=protocol.GetReturnDsByTextPackage(pkg.ReturnTextPackage); int amount=System.Convert.ToInt32( ds.Tables[0].Rows[0]["current_pluviometric"]); string sql =string.Format( "update tblRdData5Min set DataValidity='{5}',DataType=1,current_pluviometric={0},acc_pluviometric={1},rd_degree={2} where devicename='{3}' and timestamp='{4}' " , ds.Tables[0].Rows[0]["current_pluviometric"], ds.Tables[0].Rows[0]["acc_pluviometic"], ds.Tables[0].Rows[0]["rd_degree"], tc.DeviceName, Comm.DB2.Db2.getTimeStampString(dt),IsValid(amount)?"V":"I"); // Comm.TC.VD_MinAvgData data = tc.getOneMinAvgData(tc.Tc_GetVDData(dt), dt.Year, dt.Month); dbServer.SendSqlCmd(sql); ConsoleServer.WriteLine("==>repair:" + devName + "," + dt.ToString()); } catch (Exception ex) { ConsoleServer.WriteLine(devName + "," + ex.Message + ex.StackTrace); try { dbServer.SendSqlCmd(string.Format("update TBLRDDATA5MIN set trycnt=trycnt+1 where devicename='{0}' and timestamp='{1}'", devName, Comm.DB2.Db2.getTimeStampString(dt))); } catch (Exception ee) { ConsoleServer.WriteLine(ee.Message + ee.StackTrace); } } } rd.Close(); System.Threading.Thread.Sleep(1000 * 60); } catch (Exception x) { ConsoleServer.WriteLine(x.Message + x.StackTrace); } finally { cn.Close(); } } //while }
public static void NapuniListu() { System.Data.Odbc.OdbcCommand odbcCommand; System.Data.Odbc.OdbcConnection odbcConn = new System.Data.Odbc.OdbcConnection(); string connectionString = Program.GetConnString(); odbcConn = new System.Data.Odbc.OdbcConnection(connectionString); System.Data.Odbc.OdbcDataReader dr; odbcCommand = new System.Data.Odbc.OdbcCommand("SELECT ime, id FROM mobiteli", odbcConn); int id; lista.Clear(); try { if (odbcConn.State != System.Data.ConnectionState.Open) odbcConn.Open(); dr = odbcCommand.ExecuteReader(); while (dr.Read()) { int.TryParse(dr["id"].ToString(), out id); lista.Add(new MobiteliBaza(dr["ime"].ToString(), id)); } dr.Close(); } catch { MessageBox.Show("Mobilni ureðaji nisu uèitani", "Greška"); } finally { if (odbcConn.State == System.Data.ConnectionState.Open) odbcConn.Close(); } }
public void ReloadDeviceLocation() { System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Global.Db2ConnectionString); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand("select location from tbldeviceconfig where devicename='"+this.deviceName+"'"); cmd.Connection = cn; try { cn.Open(); this.location= cmd.ExecuteScalar().ToString(); } catch (Exception ex) { throw ex; } finally { cn.Close(); } }
void DataRepairTask() { System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Comm.DB2.Db2.db2ConnectionStr); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(); cmd.Connection = cn; string devName = ""; DateTime dt = new DateTime(); while (true) { Comm.TC.WDTC tc; if (!IsLoadTcCompleted) { System.Threading.Thread.Sleep(1000); continue; } try { cn.Open(); string sqlGetRepair = "select * from (select t1.DEVICENAME, TIMESTAMP ,trycnt,datavalidity,comm_state from TBLWDDATA10MIN t1 inner join tblDeviceConfig t2 on t1.devicename=t2.devicename where mfccid='{0}' and TIMESTAMP between '{1}' and '{2}' and trycnt <1 and datavalidity='N' and comm_state=1 and enable='Y' fetch first 300 row only) order by trycnt,timestamp desc "; cmd.CommandText = string.Format(sqlGetRepair, mfccid, Comm.DB2.Db2.getTimeStampString(System.DateTime.Now.AddDays(-7)), Comm.DB2.Db2.getTimeStampString(System.DateTime.Now.AddMinutes(-10))); ConsoleServer.WriteLine("Repair sql check!"); System.Data.Odbc.OdbcDataReader rd = cmd.ExecuteReader(); ConsoleServer.WriteLine("Repair task beg!"); while (rd.Read()) { try { devName = rd[0] as string; dt = System.Convert.ToDateTime(rd[1]); if (Program.mfcc_wd.manager.IsContains(devName)) tc = (Comm.TC.WDTC)Program.mfcc_wd.manager[devName]; else continue; if (!tc.IsConnected) continue; System.Data.DataSet ds = this.protocol.GetSendDataSet("get_unread_data"); ds.Tables[0].Rows[0]["day"] = dt.Day; ds.Tables[0].Rows[0]["hour"] = dt.Hour; ds.Tables[0].Rows[0]["minute"] = dt.Minute; Comm.SendPackage pkg = this.protocol.GetSendPackage(ds, 0xffff); tc.Send(pkg); if (pkg.ReturnTextPackage == null && pkg.result== Comm.CmdResult.ACK) throw new Exception(tc.DeviceName + "," + dt + ",回補資料失敗!"); if (pkg.ReturnTextPackage.Text.Length != 13) throw new Exception("回補資料長度錯誤"); ds = protocol.GetReturnDsByTextPackage(pkg.ReturnTextPackage); string sql = string.Format("update tblWDData10Min set DataValidity='V',DataType=1,average_wind_speed={0},average_wind_direction={1},max_wind_speed={2},max_wind_direction={3},am_degree={4} where devicename='{5}' and timestamp='{6}' ", ds.Tables[0].Rows[0]["average_wind_speed"], ds.Tables[0].Rows[0]["average_wind_direction"], ds.Tables[0].Rows[0]["max_wind_speed"], ds.Tables[0].Rows[0]["max_wind_direction"], ds.Tables[0].Rows[0]["am_degree"], tc.DeviceName, Comm.DB2.Db2.getTimeStampString(dt)); dbServer.SendSqlCmd(sql); ConsoleServer.WriteLine("==>repair:" + devName + "," + dt.ToString()); } catch (Exception ex) { ConsoleServer.WriteLine(devName + "," + ex.Message + ex.StackTrace); try { dbServer.SendSqlCmd(string.Format("update TBLWDDATA10MIN set trycnt=trycnt+1 where devicename='{0}' and timestamp='{1}'", devName, Comm.DB2.Db2.getTimeStampString(dt))); } catch (Exception ee) { ConsoleServer.WriteLine(ee.Message + ee.StackTrace); } } } rd.Close(); System.Threading.Thread.Sleep(1000 * 60); } catch (Exception x) { ConsoleServer.WriteLine(x.Message + x.StackTrace); } finally { cn.Close(); } } //while }
private void loadMainLineOutDevice(TC.DevcieManager devMgr) { lines.Clear(); foreach (DeviceBaseWrapper dev in devMgr.getOutputDeviceEnum()) { if (!lines.Contains(dev.lineid + "-" + dev.direction)) { lines.Add(dev.lineid + "-" + dev.direction, ArrayList.Synchronized(new System.Collections.ArrayList())); // lineJamRanges.Add(dev.lineid + "-" + dev.direction, ArrayList.Synchronized(new System.Collections.ArrayList())); } //if (dev.location == "F" || dev.location == "H" || dev.location == "T") //{ ((ArrayList)lines[dev.lineid + "-" + dev.direction]).Add(dev); //} } System.Collections.Hashtable hsInters = new Hashtable(); System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Global.Db2ConnectionString); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand("Select divisiontype,lineid1,direction1,mileage1,lineid2,direction2,mileage2 from vwcloverleaf"); cmd.Connection = cn; try { cn.Open(); System.Data.Odbc.OdbcDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { try { string divisionType, lineid1, direction1, lineid2, direction2; int mileage1, mileage2; divisionType = rd[0].ToString(); lineid1 = rd[1].ToString(); direction1 = rd[2].ToString(); mileage1 = System.Convert.ToInt32(rd[3]); if (divisionType == "C") //系統交流道 { lineid2 = rd[4].ToString(); direction2 = rd[5].ToString(); mileage2 = System.Convert.ToInt32(rd[6]); } else //匝道 { lineid2 = lineid1; direction2 = direction1; mileage2 = mileage1; } InterSection intersec = new InterSection(divisionType, lineid1, direction1, mileage1, lineid2, direction2, mileage2); if (!hsInters.Contains(intersec.getDevName())) { hsInters.Add(intersec.getDevName(), intersec); try { ((ArrayList)lines[intersec.getLineID() + "-" + intersec.getDirection()]).Add(intersec); } catch (Exception ex2) { ConsoleServer.WriteLine(ex2.Message + "," + ex2.StackTrace); } } else if (intersec.getDevType() == "C") { ((InterSection)hsInters[intersec.getDevName()]).BranchName2 = intersec.BranchName1; } //if (lines.Contains(lineid1 + "-" + direction1)) //{ //} } catch (Exception ex1) { ConsoleServer.WriteLine(ex1.Message + "," + ex1.StackTrace); } } } catch (Exception ex) { ConsoleServer.WriteLine(ex.Message + "," + ex.StackTrace); } finally { cn.Close(); } IDictionaryEnumerator iesec = hsInters.GetEnumerator(); while (iesec.MoveNext()) { try { InterSection sec = (InterSection)iesec.Value; if (sec.type == "C") { sec.branch1 = (InterSection)hsInters[sec.BranchName1]; sec.branch2 = (InterSection)hsInters[sec.BranchName2]; } } catch (Exception ex) { ConsoleServer.WriteLine(ex.Message + "," + ex.StackTrace); } } IDictionaryEnumerator ie = lines.GetEnumerator(); //取得所有的路線 while (ie.MoveNext()) { ((ArrayList)ie.Value).Sort(); //排序所有的車輛偵測器 ArrayList list = (ArrayList)ie.Value; //if (list.Count == 1) // (vdlist[0] as DeviceBaseWrapper).AryInx = 0; // 填上前後車輛偵測器鏈結 // if (list.Count > 1) for (int i = 0; i < list.Count; i++) { // ((DeviceBaseWrapper)vdlist[i]).AryInx = i; if (i == 0) ((I_Positionable)list[i]).setNextDev( list[i + 1] as I_Positionable); else if (i == list.Count - 1) ((I_Positionable)list[i]).setPreDev( list[i - 1] as I_Positionable); else { ((I_Positionable)list[i]).setPreDev( list[i - 1] as I_Positionable); ((I_Positionable)list[i]).setNextDev( list[i + 1] as I_Positionable); } } } // oneMinTmr.Elapsed += new System.Timers.ElapsedEventHandler(oneMinTmr_Elapsed); // oneMinTmr.Start(); //oneMinTmr = new System.Threading.Timer(new System.Threading.TimerCallback(oneMinTmr_Elapsed)); //oneMinTmr.Change(0, 60 * 1000); ConsoleServer.WriteLine("設備收尋管理啟動完成!"); }
public static Host.Event.EventMode getEventMode(int alarmClass) { System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Global.Db2ConnectionString); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand("SELECT login_mode From tblSysAlarmConfig where alarmClass="+alarmClass); cmd.Connection = cn; try { cn.Open(); return ( Host.Event.EventMode)System.Convert.ToInt32(cmd.ExecuteScalar()); } catch (Exception ex) { ConsoleServer.WriteLine(ex.Message + "," + ex.StackTrace); throw ex; } finally { try { cn.Close(); } catch { ;} } }
public void LogMfccStart(string ProcessName, bool bPlay) { System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection("dsn=TCS;uid=db2inst1;pwd=db2inst1"); string sql= "insert into tblMFCCStateLog (TIMESTAMP,MFCCId,CONN_State) values('{0}','{1}',{2})" ; System.Data.Odbc.OdbcCommand cmd=new System.Data.Odbc.OdbcCommand(string.Format(sql, getTimeStampString(DateTime.Now), ProcessName, bPlay ? 1 : 3)); try { cn.Open(); cmd.Connection = cn; cmd.ExecuteNonQuery(); } finally { cn.Close(); } }
public void loadUnitRoad() { ConsoleServer.WriteLine("loading " + this.lineid); lock (this) { System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Global.Db2ConnectionString); try { hsUnitRoads[0].Clear(); hsUnitRoads[1].Clear(); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand("select direction,startmileage,endmileage,unitid from tblGroupUnitRoad where lineid='" + this.lineid + "'"); cmd.Connection = cn; cn.Open(); System.Data.Odbc.OdbcDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { string dir, unitid; int startmil, endmil; dir = System.Convert.ToString(rd[0]); startmil = System.Convert.ToInt32(rd[1]); endmil = System.Convert.ToInt32(rd[2]); unitid = System.Convert.ToString(rd[3]); hsUnitRoads[direction.IndexOf(dir)].Add(startmil, new UnitRoad(this,lineid,dir,unitid, startmil, endmil,(direction.IndexOf(dir)==0)?true:false)); } } catch (Exception ex) { ConsoleServer.WriteLine(ex.Message + ex.StackTrace); } finally { cn.Close(); } } }
public void loadSection() { System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Global.Db2ConnectionString); try { hsSections[0].Clear(); hsSections[1].Clear(); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand("select lineid,sectionid,sectionName,direction,startmileage,endmileage,maxspeed,minspeed,unit,Threshold from vwSection where lineid='" + this.lineid + "' "); cmd.Connection = cn; cn.Open(); System.Data.Odbc.OdbcDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { string secname, secid, dir; int unit, threshold; int startmile, endmile, maxspd, minspd; dir = System.Convert.ToString(rd[3]); secid = System.Convert.ToString(rd[1]); secname = System.Convert.ToString(rd[2]); startmile = System.Convert.ToInt32(rd[4]); endmile = System.Convert.ToInt32(rd[5]); maxspd = System.Convert.ToInt32(rd[6]); minspd = System.Convert.ToInt32(rd[7]); unit = System.Convert.ToInt32(rd[8]); threshold = System.Convert.ToInt32(rd[9]); try { Section sec=new Section(this, lineid, secid, secname, dir, startmile, endmile, maxspd, minspd,unit,threshold); hsSections[this.direction.IndexOf(dir)].Add(secid,sec ); aryAllSections.Add(sec); } catch (Exception ex) { ; } } } catch (Exception ex) { ConsoleServer.WriteLine(ex.Message + ex.StackTrace); } finally { cn.Close(); } }
public void load_vd_travel_mapping_table() { string[][] newTable; System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Global.Db2ConnectionString); try { System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(string.Format("select count(*) from tblGroupUnitVD where unitID='{0}' ", unitid)); cmd.Connection = cn; cn.Open(); newTable = new string[System.Convert.ToInt32(cmd.ExecuteScalar())][]; cmd.CommandText = string.Format("select devicename1,DeviceName2,DeviceName3,DeviceName4 from tblGroupUnitVD where unitid='{0}' order by priority", unitid); System.Data.Odbc.OdbcDataReader rd = cmd.ExecuteReader(); int inx = 0; while (rd.Read()) { System.Collections.ArrayList ary = new System.Collections.ArrayList(); string devName1, devName2, devName3, devName4; devName1 = System.Convert.ToString(rd[0]); if (devName1 != "") ary.Add(devName1); devName2 = System.Convert.ToString(rd[1]); if (devName2 != "") ary.Add(devName2); devName3 = System.Convert.ToString(rd[2]); if (devName3 != "") ary.Add(devName3); devName4 = System.Convert.ToString(rd[3]); if (devName4 != "") ary.Add(devName4); newTable[inx] = new string[ary.Count]; for (int i = 0; i < ary.Count; i++) newTable[inx][i] = ary[i].ToString(); inx++; } vd_travel_mapping_table = newTable; } catch (Exception ex) { RemoteInterface.ConsoleServer.WriteLine(ex.Message + ex.StackTrace); } finally { cn.Close(); } }
void DataRepairTask() { System.Collections.ArrayList aryThread = new System.Collections.ArrayList(); System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Comm.DB2.Db2.db2ConnectionStr); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(); cmd.CommandTimeout = 120; StRepairData rpd=null;//=new StRepairData(); cmd.Connection = cn; System.Collections.Queue queue = new System.Collections.Queue(); int dayinx = 1; while (true) { Comm.TC.VDTC tc; if (!IsLoadTcCompleted ) { System.Threading.Thread.Sleep(1000); continue; } try { // cn= new System.Data.Odbc.OdbcConnection(Comm.DB2.Db2.db2ConnectionStr); while (this.dbServer.getCurrentQueueCnt() > 50) System.Threading.Thread.Sleep(1000 * 10); cn.Open(); ConsoleServer.WriteLine("Repair task begin!"); cmd.Connection = cn; // string sqlGetRepair = "select * from (SELECT t1.DEVICENAME, t1.TIMESTAMP ,trycnt,datavalidity FROM TBLVDDATA1MIN t1 inner join tbldeviceconfig t2 on t1.devicename=t2.devicename WHERE mfccid='{0}' and comm_state <> 3 and t1.TIMESTAMP between '{1}' and '{2}' and trycnt<3 fetch first 300 row only ) where DATAVALIDITY = 'N' order by trycnt,timestamp desc "; string sqlGetRepair = "select t1.DEVICENAME, TIMESTAMP ,trycnt,datavalidity,comm_state from TBLVDDATA1MIN t1 inner join tblDeviceConfig t2 on t1.devicename=t2.devicename where mfccid='{0}' and TIMESTAMP between '{1}' and '{2}' and trycnt <1 and datavalidity='N' and comm_state=1 and enable='Y' order by timestamp desc fetch first 300 row only "; cmd.CommandText = string.Format(sqlGetRepair,mfccid, Comm.DB2.Db2.getTimeStampString(System.DateTime.Now.AddDays(-dayinx)), Comm.DB2.Db2.getTimeStampString(System.DateTime.Now.AddDays(-dayinx+1).AddMinutes(-10))); System.Data.Odbc.OdbcDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { string devName="" ; DateTime dt ; devName = rd[0] as string; dt = System.Convert.ToDateTime(rd[1]); queue.Enqueue(new StRepairData(dt,devName)); } rd.Close(); ConsoleServer.WriteLine("total:" + queue.Count + " to repair!"); if (queue.Count < 300) { dayinx++; if (dayinx ==4) dayinx = 1; } if(queue.Count<10) System.Threading.Thread.Sleep(1000 * 60); aryThread.Clear(); while (queue.Count!=0) { try { rpd =(StRepairData)queue.Dequeue() ; if (Program.mfcc_vd.manager.IsContains(rpd.devName)) tc = (Comm.TC.VDTC)Program.mfcc_vd.manager[rpd.devName]; else continue; if (!tc.IsConnected) { dbServer.SendSqlCmd(string.Format("update tbldeviceconfig set comm_state=3 where devicename='{0}' ", rpd.devName)); continue; } System.Threading.Thread th= new System.Threading.Thread(Repair_job); aryThread.Add(th); th.Start(rpd); if (aryThread.Count >= 5) { for (int i = 0; i < aryThread.Count; i++) ((System.Threading.Thread)aryThread[i]).Join(); aryThread.Clear(); } // ConsoleServer.WriteLine("==>repair:" + rpd.devName + "," + rpd.dt.ToString()); } catch (Exception ex) { ConsoleServer.WriteLine( ex.Message + ex.StackTrace); } } for (int i = 0; i < aryThread.Count; i++) ((System.Threading.Thread)aryThread[i]).Join(); aryThread.Clear(); } catch (Exception x) { ConsoleServer.WriteLine(x.Message+ x.StackTrace); } finally { try { cn.Close(); } catch { ;} } } }
//public int getTravelTime(DateTime dt) //{ // dt = dt.AddSeconds(-dt.Second).AddMinutes(-dt.Minute % 5); // if(! hsTravelData.Contains(dt)) // return -1; // return ((TravelData)hsTravelData[dt]).TravelTime; //} //public int getSpeed(DateTime dt) //{ // dt = dt.AddSeconds(-dt.Second).AddMinutes(-dt.Minute % 5); // if (!hsTravelData.Contains(dt)) // return -1; // return ((TravelData)hsTravelData[dt]).Speed; //} void loadHisTravelTime() { System.DateTime dt = System.DateTime.Today; string sql = "select timestamp,speed,travelTime from tblTTSDataHistory where sectionid='{0}' and gid={1} and classid='{2}' "; System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Global.Db2ConnectionString); System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(string.Format(sql, this.secid,this._gid,this._classid)); try { cn.Open(); cmd.Connection = cn; System.Data.Odbc.OdbcDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { DateTime time = Convert.ToDateTime(rd[0]); int speed = Convert.ToInt32(rd[1]); int traveltime = Convert.ToInt32(rd[2]); hsTravelData.Add(time, new TravelData(time, speed, traveltime)); } } catch (Exception ex) { ConsoleServer.WriteLine(ex.Message + "," + ex.StackTrace); } finally { cn.Close(); } }
void DbSQLExecute_Task(object args) { // bool isInLock = false; #if DEBUG return; #endif int inx = System.Convert.ToInt32(args); System.Data.Odbc.OdbcConnection cn; System.DateTime dt = System.DateTime.Now; ; System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(); cmd.CommandTimeout = 120; cn = new System.Data.Odbc.OdbcConnection(DbCmdServer.getDbConnectStr()); cmd.Connection = cn; cn.Open(); ConsoleServer.WriteLine("Db task started!"); state[inx] = 0; while (true) { try { state[inx] = 1; // lock (sqlLockObj) // { state[inx] = 2; if (sqlQueue.Count == 0) { if(isPrint) ConsoleServer.WriteLine("process cnt:" + processcnt); cn.Close(); lock(this.sqlLockObj) { state[inx]=10; System.Threading.Monitor.Wait(sqlLockObj); state[inx] = 11; } cn.Open(); processcnt = 0; } state[inx] = 3; //} while( sqlQueue.Count > 0) { try { dt = System.DateTime.Now; //lock (sqlLockObj) //{ state[inx] = 4; try { cmd.CommandText = System.Convert.ToString(sqlQueue.Dequeue()); } catch { ;} //} lastcmd[inx] = cmd.CommandText; state[inx] = 9; cmd.ExecuteNonQuery(); ProcessCntPerMin++; processcnt++; state[inx] = 5; if (System.DateTime.Now - dt > new TimeSpan(0, 0, 30)) ConsoleServer.WriteLine("db Executeion time longer than 30 sec:" + cmd.CommandText); state[inx] = 6; errcnt = 0; if (dbqmode == DBQueueMode.Slow) //2013/2/25 System.Threading.Thread.Sleep(1000); // ConsoleServer.WriteLine("finish!"); } //catch (System.Data.Odbc.OdbcException odbcex) //{ // if(odbcex.ErrorCode!=-2147467259) // repeat unixodbc32 // { // ConsoleServer.WriteLine(odbcex.ErrorCode+","+odbcex.Message+cmd.CommandText); // } // else // Console.WriteLine(odbcex.ErrorCode + "," + odbcex.Message); // try { cn.Close(); } // catch { ;} // try // { // cn = new System.Data.Odbc.OdbcConnection(Comm.DB2.Db2.db2ConnectionStr); // cmd.Connection = cn; // cn.Open(); // } // catch { ;} //} catch (Exception ex1) { errcnt++; //if(ex1 is System.Data.Odbc.OdbcException) // ConsoleServer.WriteLine("db exception:"+(ex1 as System.Data.Odbc.OdbcException).Message + cmd.CommandText); //else ConsoleServer.WriteLine("db exception:"+ex1.Message + cmd.CommandText); RemoteInterface.Util.SysLog("dberr.log",System.DateTime.Now+","+ex1.Message+","+cmd.CommandText); try { // if ( cn.State == System.Data.ConnectionState.Broken || cn.State == System.Data.ConnectionState.Closed ) // { try { cn.Close(); } catch { ;} try { cn.Open(); cmd.Connection = cn; } catch { ;} // } } catch { ;} //try //{ // // state[inx] = 7; // //// cn = new System.Data.Odbc.OdbcConnection(Comm.DB2.Db2.db2ConnectionStr); // // cmd.Connection = cn; // // cn.Open(); // // state[inx] = 8; //} //catch (Exception ex){ // ConsoleServer.WriteLine(" In DbSQLExecute_Task " + "," + ex.Message + "," + ex.StackTrace); //} } } } catch (Exception ex) { ConsoleServer.WriteLine(ex.Message + ex.StackTrace); } } }