//// 2007.02.11 Added
////
//static public void ResolveGprsStation()
//{
// string s = string.Format(@"select gprs_station_id, name, commport,
// gr_address, xg_address, grstation_id, xgstation_id from v_gprs_gr_xg where client = {0}", XGConfig.Default.ClientAorB );
// DataSet ds = DbClient.Execute( s );
// DataTable dt = ds.Tables[0];
// foreach ( DataRow r in dt.Rows )
// {
// string name = r[1].ToString();
// int commport = int.Parse( r[2].ToString() );
// CommPortProxy cpp = new CommPortProxy((short) commport, XGConfig.Default.CommPortSettings );
// // add try
// //
// try
// {
// cpp.Open();
// }
// catch
// {
// // Open commport fail.
// //
// Debug.Fail( "Open commport " + commport + " fail." );
// }
//
// cpp.IsEnableAutoReport = true;
// cpp.RThreshold = 1;
// //cpp.ReceiveAutoReport += new EventHandler( ARDProcessor.Default.Process );
//
// CFW.TaskScheduler commTaskSch = new CFW.TaskScheduler( cpp, XGConfig.Default.TaskSchedulerInterval );
// //commTaskSch.Executed +=new EventHandler( CommTaskResultProcessor.Default.Process );
// commTaskSch.Enabled = true;
//
// // Add the commTask scheduler to taskSchedulerCollection
// //
// TaskSchedulersCollection tss = Singles.S.TaskSchCollection;
// tss.Add( commTaskSch );
//
// }
//
//}
static public ObjectIdAssociateCollection ResolveCard()
{
ObjectIdAssociateCollection cardIdAssoc = new ObjectIdAssociateCollection("tbl_card");
string s = "select card_id, sn, person from tbl_card";
DataSet ds = DbClient.Execute(s);
DataTable tbl = ds.Tables[0];
foreach (DataRow r in tbl.Rows)
{
int id = int.Parse(r[0].ToString());
string sn = r[1].ToString();
string person = r[2].ToString();
Card card = new Card(sn, person);
cardIdAssoc.Add(card, id);
}
return(cardIdAssoc);
}
/// <summary>
/// 解析巡更控制器站点
/// </summary>
/// <returns></returns>
static public ObjectIdAssociateCollection ResolveXGStation()
{
ObjectIdAssociateCollection stationIdAssoc = new ObjectIdAssociateCollection("tbl_xgstation");
// string s = "select xgstation_id, name, address from tbl_xgstation";
string s = "select xgstation_id, name, xg_address, ip from v_gprs_gr_xg";
DataSet ds = DbClient.Execute(s);
DataTable tbl = ds.Tables[0];
foreach (DataRow r in tbl.Rows)
{
int id = int.Parse(r[0].ToString());
string name = r[1].ToString();
int address = int.Parse(r[2].ToString());
string ipAddr = r[3].ToString().Trim();
XGStation st = new XGStation(name, ipAddr, address);
stationIdAssoc.Add(st, id);
}
return(stationIdAssoc);
}