/// <summary>
/// 查询启动地图
/// </summary>
/// <returns></returns>
public string SettingInfo()
{
List <string> setList = new List <string>();
string sql = string.Format("SELECT Map FROM agv.`setting`");
DataTable dt = MySqlHelper.ExecuteDataTable(sql);
return(dt.Rows.Count > 0 ? dt.Rows[0][0].ToString() : null);
}
public DataTable MapList(string MpName)
{
string Sql = "";
if (MpName != null)
{
Sql = "select * FROM map where Name LIKE '%" + MpName + "%'";
}
else
{
Sql = "select * from map";
}
DataTable data = MySqlHelper.ExecuteDataTable(Sql);
return(data.Rows.Count > 0 ? data : null);
}
public DataTable widgetArr(string Times)
{
return(MySqlHelper.ExecuteDataTable("select * from widget" + Times + ""));
}
public DataTable widgetArrlist(string Times)
{
return(MySqlHelper.ExecuteDataTable("select * from widget" + Times + " order by WidgetNo"));
}
/// <summary>
/// 查询所有线路
/// </summary>
/// <param name="Times"></param>
/// <returns></returns>
public DataTable LineData(string Times)
{
return(MySqlHelper.ExecuteDataTable("select * from line" + Times + ""));
}
/// <summary>
/// 判断线路号是否存在
/// </summary>
/// <param name="Program"></param>
/// <param name="MapTime"></param>
/// <returns></returns>
public bool ExistsProgram(string Program, long MapTime)
{
DataTable dt = MySqlHelper.ExecuteDataTable(string.Format("SELECT `CreateTime` FROM agv.`route{0}` WHERE `Program` = {1}", MapTime, Program));
return(dt.Rows.Count > 0 ? true : false);
}
public DataTable LoadDevice(long MapTime)
{
string sql = string.Format("SELECT `Com`, `Baud`, `Agv` FROM agv.`device{0}`", MapTime);
return(MySqlHelper.ExecuteDataTable(sql));
}
/// <summary>
/// 线路
/// </summary>
/// <returns></returns>
public DataTable MapRoute(string MapName)
{
DataTable dt = MySqlHelper.ExecuteDataTable(string.Format("select * FROM route{0}", MapName));
return(dt);
}
public DataTable MapSelect(string MpNAme)
{
return(MySqlHelper.ExecuteDataTable("select * FROM map where Name='" + MpNAme + "'"));
}
/// <summary>
/// 查询所有Tag
/// </summary>
/// <param name="exls"></param>
/// <returns></returns>
public DataTable GetMapTags(string exls)
{
return(MySqlHelper.ExecuteDataTable("select * from tag" + exls + " order by (TagName+0)"));
}