/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DTUEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update DTU set ");
strSql.Append("DTU_tp_ID=@DTU_tp_ID,");
strSql.Append("Vi_ID=@Vi_ID,");
strSql.Append("DTU_name=@DTU_name,");
strSql.Append("DTU_longitude=@DTU_longitude,");
strSql.Append("DTU_dimensionality=@DTU_dimensionality,");
strSql.Append("DTU_sim=@DTU_sim,");
strSql.Append("Mo_ID=@Mo_ID,");
strSql.Append("polling-delay-time=@polling-delay-time,");
strSql.Append("polling-time=@polling-time,");
strSql.Append("GP_ID=@GP_ID");
strSql.Append(" where DTU_ID=@DTU_ID ");
SqlParameter[] parameters =
{
new SqlParameter("@DTU_tp_ID", SqlDbType.Int, 4),
new SqlParameter("@Vi_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@DTU_name", SqlDbType.NVarChar, 50),
new SqlParameter("@DTU_longitude", SqlDbType.Float, 8),
new SqlParameter("@DTU_dimensionality", SqlDbType.Float, 8),
new SqlParameter("@DTU_sim", SqlDbType.NVarChar, 50),
new SqlParameter("@Mo_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@polling-delay-time", SqlDbType.Int, 4),
new SqlParameter("@polling-time", SqlDbType.Int, 4),
new SqlParameter("@GP_ID", SqlDbType.Int, 4),
new SqlParameter("@DTU_ID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.DTU_tp_ID;
parameters[1].Value = model.Vi_ID;
parameters[2].Value = model.DTU_name;
parameters[3].Value = model.DTU_longitude;
parameters[4].Value = model.DTU_dimensionality;
parameters[5].Value = model.DTU_sim;
parameters[6].Value = model.Mo_ID;
parameters[7].Value = model.polling_delay_time;
parameters[8].Value = model.polling_time;
parameters[9].Value = model.GP_ID;
parameters[10].Value = model.DTU_ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DTUEntity DataRowToModel(DataRow row)
{
DTUEntity model = new DTUEntity();
if (row != null)
{
if (row["DTU_ID"] != null)
{
model.DTU_ID = row["DTU_ID"].ToString();
}
if (row["DTU_tp_ID"] != null && row["DTU_tp_ID"].ToString() != "")
{
model.DTU_tp_ID = int.Parse(row["DTU_tp_ID"].ToString());
}
if (row["Vi_ID"] != null)
{
model.Vi_ID = row["Vi_ID"].ToString();
}
if (row["DTU_name"] != null)
{
model.DTU_name = row["DTU_name"].ToString();
}
if (row["DTU_longitude"] != null && row["DTU_longitude"].ToString() != "")
{
model.DTU_longitude = decimal.Parse(row["DTU_longitude"].ToString());
}
if (row["DTU_dimensionality"] != null && row["DTU_dimensionality"].ToString() != "")
{
model.DTU_dimensionality = decimal.Parse(row["DTU_dimensionality"].ToString());
}
if (row["DTU_sim"] != null)
{
model.DTU_sim = row["DTU_sim"].ToString();
}
if (row["Mo_ID"] != null)
{
model.Mo_ID = row["Mo_ID"].ToString();
}
if (row["polling-delay-time"] != null && row["polling-delay-time"].ToString() != "")
{
model.polling_delay_time = int.Parse(row["polling-delay-time"].ToString());
}
if (row["polling-time"] != null && row["polling-time"].ToString() != "")
{
model.polling_time = int.Parse(row["polling-time"].ToString());
}
if (row["GP_ID"] != null && row["GP_ID"].ToString() != "")
{
model.GP_ID = int.Parse(row["GP_ID"].ToString());
}
}
return(model);
}
public BaseDTU(DTUEntity dtu, Dictionary <string, BaseStation> baseStationDic)
: this(dtu, IntPtr.Zero, null)
{
this.baseStationDic = baseStationDic;
/// this.trList = trList;
StationEntity se = new StationEntity();
se.DTU_ID = dtu.DTU_ID;
se.Address = dtu.Address;
selfStation = new BaseStation(se);
InitTimedRule();
InitBaseStationDic();
InitSendCmd();
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(DTUEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into DTU(");
strSql.Append("DTU_ID,DTU_tp_ID,Vi_ID,DTU_name,DTU_longitude,DTU_dimensionality,DTU_sim,Mo_ID,polling-delay-time,polling-time,GP_ID)");
strSql.Append(" values (");
strSql.Append("@DTU_ID,@DTU_tp_ID,@Vi_ID,@DTU_name,@DTU_longitude,@DTU_dimensionality,@DTU_sim,@Mo_ID,@polling-delay-time,@polling-time,@GP_ID)");
SqlParameter[] parameters =
{
new SqlParameter("@DTU_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@DTU_tp_ID", SqlDbType.Int, 4),
new SqlParameter("@Vi_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@DTU_name", SqlDbType.NVarChar, 50),
new SqlParameter("@DTU_longitude", SqlDbType.Float, 8),
new SqlParameter("@DTU_dimensionality", SqlDbType.Float, 8),
new SqlParameter("@DTU_sim", SqlDbType.NVarChar, 50),
new SqlParameter("@Mo_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@polling-delay-time", SqlDbType.Int, 4),
new SqlParameter("@polling-time", SqlDbType.Int, 4),
new SqlParameter("@GP_ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.DTU_ID;
parameters[1].Value = model.DTU_tp_ID;
parameters[2].Value = model.Vi_ID;
parameters[3].Value = model.DTU_name;
parameters[4].Value = model.DTU_longitude;
parameters[5].Value = model.DTU_dimensionality;
parameters[6].Value = model.DTU_sim;
parameters[7].Value = model.Mo_ID;
parameters[8].Value = model.polling_delay_time;
parameters[9].Value = model.polling_time;
parameters[10].Value = model.GP_ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public Dictionary <String, BaseDTU> getDTUDic()
{
if (dtuDic.Count <= 0)
{
//读数据库 初始化dtudic
for (int i = 0; i < dicNumber; i++)
{
DTUEntity dtuEntity = new DTUEntity();
dtuEntity.Address = i + "";
dtuEntity.polling_delay_time = polling_delay_time;
dtuEntity.polling_time = polling_time;
Dictionary <string, BaseStation> stationDic = new Dictionary <string, BaseStation>();
////////////模块1、////////
StationEntity se1 = new StationEntity();
se1.Address = "1";
se1.Md_ID = i + "md1";
StationEDA9017 s1 = new StationEDA9017(se1);
s1.initCmd();
stationDic.Add(se1.Address, s1);
////////////模块1完成////////
////////////模块2、////////
StationEntity se2 = new StationEntity();
se2.Address = "2";
se2.Md_ID = i + "md2";
StationEDA9017 s2 = new StationEDA9017(se2);
s2.initCmd();
stationDic.Add(se2.Address, s2);
//////////////模块2完成、////////
BaseDTU basedtu = new BaseDTU(dtuEntity, stationDic);
dtuDic.Add((100000 + i) + "", basedtu);
}
return(dtuDic);
}
else
{
return(dtuDic);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DTUEntity GetModel(string DTU_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 DTU_ID,DTU_tp_ID,Vi_ID,DTU_name,DTU_longitude,DTU_dimensionality,DTU_sim,Mo_ID,polling-delay-time,polling-time,GP_ID from DTU ");
strSql.Append(" where DTU_ID=@DTU_ID ");
SqlParameter[] parameters =
{
new SqlParameter("@DTU_ID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = DTU_ID;
DTUEntity model = new DTUEntity();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public DTULQ8110E(DTUEntity dtu, IntPtr connId, TcpServer server)
: base(dtu, connId, server)
{
}
public BaseDTU(DTUEntity dtu, IntPtr connId, TcpServer server)
{
this.dtu = dtu;
this.connId = connId;
this.server = server;
}
public DTUJTT10(DTUEntity dtu, IntPtr connId, TcpServer server)
: base(dtu, connId, server)
{
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DTUEntity model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(DTUEntity model)
{
return(dal.Add(model));
}
