/// <summary> /// ������Ϣ��ID ��ѯ������Ϣ /// </summary> /// <param name="itemID"></param> /// <returns></returns> public List<BuilderObject> GetBuilderInfo(string ObjectID) { SqlHelper sh = new SqlHelper(); ds = new DataSet(); ds = sh.selectAll("builderObject", "buildObjectID='" + ObjectID + "'"); list = new List<BuilderObject>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { BuilderObject boTemp = new BuilderObject(); boTemp.BuilId = int.Parse(ds.Tables[0].Rows[i][0].ToString()); boTemp.BuilName = ds.Tables[0].Rows[i][1].ToString(); //������ǵ�i�еĵ�1�е����� // boTemp.BuilItemID = ds.Tables[0].Rows[i][2].ToString(); boTemp.BuilHeight = ds.Tables[0].Rows[i][2].ToString(); boTemp.BuilArea = ds.Tables[0].Rows[i][3].ToString(); boTemp.BuilInfo = ds.Tables[0].Rows[i][4].ToString(); boTemp.BuilLongitude = ds.Tables[0].Rows[i][5].ToString(); boTemp.BuilLatitude = ds.Tables[0].Rows[i][6].ToString(); boTemp.BuidObjectID = ds.Tables[0].Rows[i][7].ToString(); //Tables��Rows���Ǽ��ϣ��������ǿ���ͨ���������������еij�Ա list.Add(boTemp); } return list; }
/// <summary> /// 根据条件查询建筑列表 /// </summary> /// <param name="where"></param> /// <returns></returns> public List <BuilderObject> GetBuilderByName(string where) { SqlHelper sh = new SqlHelper(); ds = new DataSet(); ds = sh.selectAll("builderObject", "buildName like '%" + where + "%'"); list = new List <BuilderObject>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { BuilderObject boTemp = new BuilderObject(); boTemp.BuilId = int.Parse(ds.Tables[0].Rows[i][0].ToString()); boTemp.BuilName = ds.Tables[0].Rows[i][1].ToString(); // boTemp.BuilItemID = ds.Tables[0].Rows[i][2].ToString(); boTemp.BuilHeight = ds.Tables[0].Rows[i][2].ToString(); boTemp.BuilArea = ds.Tables[0].Rows[i][3].ToString(); boTemp.BuilInfo = ds.Tables[0].Rows[i][4].ToString(); boTemp.BuilLongitude = ds.Tables[0].Rows[i][5].ToString(); boTemp.BuilLatitude = ds.Tables[0].Rows[i][6].ToString(); boTemp.BuidObjectID = ds.Tables[0].Rows[i][7].ToString(); list.Add(boTemp); } return(list); }
/// <summary> /// ����������ѯ�����б� /// </summary> /// <param name="where"></param> /// <returns></returns> public List<BuilderObject> GetBuilderByName(string where) { SqlHelper sh = new SqlHelper(); ds = new DataSet(); ds = sh.selectAll("builderObject", "buildName like '%" + where + "%'"); list = new List<BuilderObject>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { BuilderObject boTemp = new BuilderObject(); boTemp.BuilId = int.Parse(ds.Tables[0].Rows[i][0].ToString()); boTemp.BuilName = ds.Tables[0].Rows[i][1].ToString(); // boTemp.BuilItemID = ds.Tables[0].Rows[i][2].ToString(); boTemp.BuilHeight = ds.Tables[0].Rows[i][2].ToString(); boTemp.BuilArea = ds.Tables[0].Rows[i][3].ToString(); boTemp.BuilInfo = ds.Tables[0].Rows[i][4].ToString(); boTemp.BuilLongitude = ds.Tables[0].Rows[i][5].ToString(); boTemp.BuilLatitude = ds.Tables[0].Rows[i][6].ToString(); boTemp.BuidObjectID = ds.Tables[0].Rows[i][7].ToString(); list.Add(boTemp); } return list; }
/// <summary> /// 根据信息树ID 查询物体信息 /// </summary> /// <param name="itemID"></param> /// <returns></returns> public List <BuilderObject> GetBuilderInfo(string ObjectID) { SqlHelper sh = new SqlHelper(); ds = new DataSet(); ds = sh.selectAll("builderObject", "buildObjectID='" + ObjectID + "'"); list = new List <BuilderObject>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { BuilderObject boTemp = new BuilderObject(); boTemp.BuilId = int.Parse(ds.Tables[0].Rows[i][0].ToString()); boTemp.BuilName = ds.Tables[0].Rows[i][1].ToString(); //输出的是第i行的第1列的数据 // boTemp.BuilItemID = ds.Tables[0].Rows[i][2].ToString(); boTemp.BuilHeight = ds.Tables[0].Rows[i][2].ToString(); boTemp.BuilArea = ds.Tables[0].Rows[i][3].ToString(); boTemp.BuilInfo = ds.Tables[0].Rows[i][4].ToString(); boTemp.BuilLongitude = ds.Tables[0].Rows[i][5].ToString(); boTemp.BuilLatitude = ds.Tables[0].Rows[i][6].ToString(); boTemp.BuidObjectID = ds.Tables[0].Rows[i][7].ToString(); //Tables、Rows都是集合,所以它们可以通过索引来访问其中的成员 list.Add(boTemp); } return(list); }