public static CadObjId[] GetViewportObjects(long vportnumber)
{
string sql = "SELECT * FROM pentity WHERE vportnumber =@vportnumber;";
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("vportnumber", vportnumber);
DataTable dt = ExecuteQuery(sql, parameters);
CadObjId cadobjid;
CadObjIdCollection cadobjidls;
long pobjid;
int i = 0;
string arraystring;
int pc = dt.Rows.Count;
string[] tokens;// = values.Split(',');
long[] myItems;
if (dt.Rows.Count > 0)
{
cadobjidls = new CadObjIdCollection();
arraystring = dt.Rows[0].Field <string>("mobjectid");
tokens = arraystring.Split(',');
myItems = Array.ConvertAll <string, long>(tokens, long.Parse);
foreach (long lid in myItems)
{
cadobjid = new CadObjId((IntPtr)lid);
cadobjidls.Add(cadobjid);
}
CadObjId[] cabids = new CadObjId[cadobjidls.Count];
cadobjidls.CopyTo(cabids, 0);
return(cabids);
}
else
{
return(null);
}
//string sql = "SELECT * FROM pentity WHERE vportnumber =@vportnumber;";
//Dictionary<string, object> parameters = new Dictionary<string, object>();
//parameters.Add("vportnumber", vportnumber);
//DataTable dt = ExecuteQuery(sql, parameters);
//CadObjId cadobjid;
//CadObjIdCollection cadobjidls;
//long pobjid,pid1;
//int i = 0;
//int pc = dt.Rows.Count;
//if (dt.Rows.Count > 0)
//{
// cadobjidls = new CadObjIdCollection();
// foreach (DataRow dr in dt.Rows)
// {
// pobjid = dr.Field<long>("mobjectid");
// cadobjid = new CadObjId((IntPtr)pobjid);
// cadobjidls.Add(cadobjid);
// }
// return cadobjidls;
// // pobjid= dt.Rows[0].Field<long>("mobjectid");
// ///pid1 = dt.Rows[1].Field<long>("mobjectid");
//}
//else
//return null;
}
