private static void MapPoint(DataRow row, RobotParam param)
{
param.Rx = decimal.Parse(row["RX"].ToString());
param.Ry = decimal.Parse(row["RY"].ToString());
param.Rz = decimal.Parse(row["RZ"].ToString());
param.Base = decimal.Parse(row["Base"].ToString());
param.BaseIndex = int.Parse(row["BaseIndex"].ToString());
}
public static RobotParam GetOrigin(int panelPoint)
{
const string SQL_1 = "select * from RobotParam where PanelIndexNo=@PanelIndexNo and Remark='Base'";
var dtOrigin = new DataAccess().Query(SQL_1,
new System.Data.SqlClient.SqlParameter("@PanelIndexNo", panelPoint));
if (dtOrigin != null && dtOrigin.Rows.Count > 0)
{
var foo = new RobotParam();
var row = dtOrigin.Rows[0];
MapPoint(row, foo);
return(foo);
}
else
{
return(null);
}
}
public static RobotParam GetPoint(int panelPoint, int baseIndex)
{
const string SQL_2 = "select * from RobotParam where PanelIndexNo=@PanelIndexNo and BaseIndex=@BaseIndex";
var dtPoint = DataAccess.CreateDataAccess.sa.Query(SQL_2,
new System.Data.SqlClient.SqlParameter("@PanelIndexNo", panelPoint),
new System.Data.SqlClient.SqlParameter("@BaseIndex", baseIndex));
if (dtPoint != null && dtPoint.Rows.Count > 0)
{
var row = dtPoint.Rows[0];
var foo = new RobotParam();
MapPoint(row, foo);
return(foo);
}
else
{
return(null);
}
}
