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);
}
}
}
