public void LoadImageToSphere(string ImageId)
{
Debug.Log("ImageID" + ImageId);
List <string[]> result = new List <string[]>();
result = DataDBContorller.Select("select HouseShowType FROM biulding WHERE id in(SELECT biulding_Id from image WHERE id=" + ImageId + ");");
int HouseShowType = int.Parse(result[0][0]); //获取到展示类型 1为全景 2为平面
switch (HouseShowType)
{
case 1:
LoadSphere.Instance.LoadSphereTextureById(ImageId);
Debug.Log("当前全景看房模式");
break;
case 2:
LoadPlaneImage.Instance.LoadPlaneImageById(ImageId);
ObjectManager.Instance.PlaneImageCanvas.SetActive(true);
Debug.Log("当前平面看房模式");
break;
case 3:
LoadPlaneImage.Instance.LoadPlaneImageById(ImageId);
ObjectManager.Instance.PlaneImageCanvas.SetActive(true);
Debug.Log("当前平面看房模式");
break;
case 4:
Debug.Log("当前模型看房模式");
Load3DModel.Instance.LoadModelByImageID(ImageId);
break;
}
}
IEnumerator LoadHouseMessageToUI(string House_Id)
{
yield return(null);
string sql = "SELECT biuldingName,region.regionName,TrafficRegion,HouseType,biuldingAddres,HousePosition,SellTell,MoneyTell,HouseSize FROM biulding,region,image WHERE region.id=biulding.region_Id and biulding.id =" + House_Id + ";";
result = DataDBContorller.Select(sql);
Transform HouseMessage = ObjectManager.Instance.RoomCanvas_HouseMessage.transform;
foreach (var item in result)
{
HouseMessage.GetChild(1).GetComponent <Text>().text = item[0];
HouseMessage.GetChild(2).GetComponent <Text>().text = "房源行政区: " + item[1];
HouseMessage.GetChild(3).GetComponent <Text>().text = "交通区位: " + item[2];
HouseMessage.GetChild(4).GetComponent <Text>().text = "地址: " + item[4];
HouseMessage.GetChild(5).GetComponent <Text>().text = "经纬度: " + item[5];
if (item[3].Equals("集中式租赁项目"))
{
HouseMessage.GetChild(6).GetComponent <Text>().text = "客服热线: " + item[6];
HouseMessage.GetChild(7).GetComponent <Text>().text = "";
}
else
{
HouseMessage.GetChild(6).GetComponent <Text>().text = "售楼热线: " + item[6];
HouseMessage.GetChild(7).GetComponent <Text>().text = "建行贷款咨询热线: " + item[7];
}
HouseMessage.GetChild(8).GetComponent <Text>().text = "户型: " + item[8];
}
}
public void DisposeSecondaryInterfaceInfo(int id)
{
string sql = "SELECT * FROM `test` WHERE ID = " + id + ";";
result = DataDBContorller.Select(sql);
DisposeDataSecondary();
StartCoroutine(DisposeIMGInSecondary());
}
void LoadAreaButtonMethod()
{
string sql = "SELECT *FROM Region WHERE State = 1;";
result = DataDBContorller.Select(sql);
for (int i = 0; i < result.Count; i++)
{
GameObject go = GameObject.Instantiate(areaBtn.gameObject, GameManager.Instance.MainCanvasContentInAreaList.transform) as GameObject;
go.transform.localPosition = new Vector3(i * width + width / 2.0f + gaps, -(height + gaps) / 2.0f);
go.transform.GetChild(0).GetComponent <Text>().text = result[i][1].ToString();
}
}
// Use this for initialization
void Start()
{
string sql = "SELECT * FROM `test` where state = 1";
result = DataDBContorller.Select(sql);
List <string[]> listData = new List <string[]>();
for (int i = 0; i < result.Count - 50; i++)
{
listData.Add(result[i]);
}
MainCanvasContentInHousingResource.Data(listData);
}
IEnumerator LoadTexture()
{
string sql = "SELECT * FROM `biulding` WHERE id = " + id + ";";
List <string[]> result = new List <string[]>();
result = DataDBContorller.Select(sql);
texName = result[0][2];
string TempURL = "file://" + Application.streamingAssetsPath + @result[0][4];
WWW www = new WWW(TempURL);
yield return(www);
texInPanel = www.texture;
Resources.UnloadUnusedAssets();
}
public void Select()
{
RecStr = DataDBContorller.Select("SELECT * FROM `test`;")[0] as string[];
//for (int i = 0; i < RecStr.Length; i++)
//{
// RecStr[i].Trim();
//}
textStr.text = RecStr[0] + "\n" + RecStr[1].Trim() + "\n" + RecStr[2]
+ "\n" + RecStr[3] + "\n" + RecStr[4] + "\n" + RecStr[5] + "\n" + RecStr[6]
+ "\n" + RecStr[7] + "\n" + RecStr[8] + "\n" + RecStr[9] + "\n" + RecStr[10]
+ "\n" + RecStr[11] + "\n" + RecStr[12] + "\n" + RecStr[13] + "\n" + RecStr[14]
+ "\n" + RecStr[15]
;
Debug.Log("房源信息 ： " + textStr.text);
// StartCoroutine(LoadTextureToMainTexture());
}
IEnumerator LoadPlaneImageToCanvas(string ImageId)
{
yield return(null);
//读取图片并显示
ObjectManager.Instance.SphereLoding.SetActive(true); //显示加载面板
string sql = "select ImageAddres from Image WHERE id=" + ImageId + ";";
List <string[]> result = new List <string[]>();
result = DataDBContorller.Select(sql);
Debug.Log("resultCount:" + result.Count + "----" + sql);
string TempURL = "file://" + Application.streamingAssetsPath + @result[0][0];
Debug.Log("加载平面图片ID:" + ImageId + " URl:" + TempURL);
WWW www = new WWW(TempURL);
yield return(www);
NowSphereTexture = www.texture;
ObjectManager.Instance.PlaneImageBody.GetComponent <RawImage>().texture = NowSphereTexture;
ObjectManager.Instance.SphereLoding.SetActive(false); //隐藏加载面板
ObjectManager.Instance.MainCanvas.SetActive(false); //隐藏主页UI界面
Resources.UnloadUnusedAssets();
}
IEnumerator LoadSphereTextureToSphere(string ImageId)
{
yield return(null);
CueContorller.Instance.ResetCuePool(); //重置对象池
//读取图片并显示
ObjectManager.Instance.SphereLoding.SetActive(true);
string sql = "select ImageAddres,r_x,r_y,r_z from Image WHERE id=" + ImageId + ";";
List <string[]> result = new List <string[]>();
result = DataDBContorller.Select(sql);
Debug.Log("resultCount:" + result.Count + "----" + sql);
string TempURL = "file://" + Application.streamingAssetsPath + @result[0][0];
Debug.Log("加载全景图片ID:" + ImageId + " URl:" + TempURL);
WWW www = new WWW(TempURL);
yield return(www);
NowSphereTexture = www.texture;
ObjectManager.Instance.RoomSphere.GetComponent <Renderer>().materials[0].mainTexture = NowSphereTexture;
ObjectManager.Instance.RoomSphere.transform.GetChild(1).name = ImageId; //将ID存在物体名字上
//读取标识
List <string[]> Cueresult = new List <string[]>();
sql = "select * from roomcue where image_Id =" + ImageId + ";";
Cueresult = DataDBContorller.Select(sql);
Debug.Log("resultCount:" + result.Count + "----" + sql);
foreach (var item in Cueresult)
{
//根据数据库中存储的CueType从对象池获取一个对应的标识对象
Debug.Log(item[2]);
GameObject TempCue = CueContorller.Instance.GetGameObj((RoomEnum.UIType) int.Parse(item[2]));
//设置父对象
TempCue.transform.SetParent(ObjectManager.Instance.SphereCanvas.transform);
//设置提示文字
TempCue.transform.GetChild(1).GetComponent <Text>().text = item[6];
//设置指向ID
TempCue.transform.GetChild(2).name = item[10];
//设置位置
TempCue.transform.localPosition = new Vector3(float.Parse(item[3]), float.Parse(item[4]), float.Parse(item[5]));
Debug.Log(TempCue.transform.position);
//设置旋转
TempCue.transform.localEulerAngles = new Vector3(float.Parse(item[7]), float.Parse(item[8]), float.Parse(item[9]));
//显示提示
TempCue.SetActive(true);
}
ObjectManager.Instance.SphereLoding.SetActive(false); //显示加载面板
ObjectManager.Instance.MainCanvas.SetActive(false); //隐藏主页UI界面
Resources.UnloadUnusedAssets();
if (!IsAtHouse)
{
for (int i = 0; i < 51; i++)
{
ObjectManager.Instance.RoomSphere.transform.position = new Vector3(0, 0, -0.02f * i); //拉近房间的动画
ObjectManager.Instance.RoomSphere.transform.Rotate(1.8f, 0, 0); //调整房间的方向
yield return(new WaitForSeconds(0.01f));
}
}
//设置全景球的旋转为数据库中读取到的数据
if (result[0][1] != "")
{
Vector3 temp = new Vector3(float.Parse(result[0][1]), float.Parse(result[0][2]), float.Parse(result[0][3]));
ObjectManager.Instance.RoomSphere.transform.eulerAngles = temp;
}
else
{ //没有旋转数据就把球还原
Vector3 temp = new Vector3(0, 0, 0);
ObjectManager.Instance.RoomSphere.transform.eulerAngles = temp;
}
IsAtHouse = true; //将当前状态设置为在房内
}
public void CloseSql()
{
DataDBContorller.CloseConnection();
}
public void TestSql()
{
DataDBContorller.OpenSqlConnection(DataDBContorller.connectionString);
}
public void Select()
{
Debug.Log((DataDBContorller.Select("select * FROM region;")[0] as string[]));
}
IEnumerator LoadModelToScene(string ImageId)
{
yield return(null);
CueContorller.Instance.ResetCuePool(); //重置对象池
//读取图片并显示
ObjectManager.Instance.SphereLoding.SetActive(true);
string sql = "SELECT biuldingName FROM biulding WHERE region_Id = " + ImageId + ";";
List <string[]> result = new List <string[]>();
result = DataDBContorller.Select(sql);
string name = result[0][0];
GameObject g = Instantiate(Resources.Load(name) as GameObject, Vector3.zero, Quaternion.identity);
g.transform.localScale = Vector3.one * 0.8f;
loadedModels.Add(g);
yield return(new WaitForSeconds(0.5f));
#region 加载图片
// string TempURL="file://" + Application.streamingAssetsPath +@result[0][0];
//Debug.Log("加载全景图片ID:"+ImageId+" URl:"+TempURL);
//WWW www =new WWW(TempURL);
//yield return www;
//NowSphereTexture =www.texture;
//ObjectManager.Instance.RoomSphere.GetComponent<Renderer>().materials[0].mainTexture = NowSphereTexture;
//ObjectManager.Instance.RoomSphere.transform.GetChild(1).name=ImageId;//将ID存在物体名字上
////读取标识
//List<string[]> Cueresult =new List<string[]>();
//if(IsReadCue)
//{
// sql="select * from roomcue where image_Id ="+ImageId+";";
// Cueresult=DataDBContorller.Select(sql);
// Debug.Log("resultCount:"+Cueresult.Count+"----"+sql);
// foreach (var item in Cueresult)
// {
// //根据数据库中存储的CueType从对象池获取一个对应的标识对象
// GameObject TempCue=CueContorller.Instance.GetGameObj((RoomEnum.UIType)int.Parse(item[2]));
// //设置父对象
// TempCue.transform.SetParent(ObjectManager.Instance.SphereCanvas.transform);
// //设置提示文字
// TempCue.transform.GetChild(1).GetComponent<Text>().text=item[6];
// //设置指向ID
// TempCue.transform.GetChild(2).name=item[10];
// //设置位置
// TempCue.transform.localPosition=new Vector3(float.Parse(item[3]),float.Parse(item[4]),float.Parse(item[5]));
// //设置旋转
// TempCue.transform.localEulerAngles=new Vector3(float.Parse(item[7]),float.Parse(item[8]),float.Parse(item[9]));
// //显示提示
// TempCue.SetActive(true);
// }
//}
//ObjectManager.Instance.SphereLoding.SetActive(false);//显示加载面板
//ObjectManager.Instance.MainCanvas.SetActive(false);//隐藏主页UI界面
//Resources.UnloadUnusedAssets();
//if(!IsAtHouse)
//{
// for (int i = 0; i < 51; i++)
// {
// ObjectManager.Instance.RoomSphere.transform.position = new Vector3(0, 0, -0.02f * i); //拉近房间的动画
// ObjectManager.Instance.RoomSphere.transform.Rotate(1.8f, 0, 0); //调整房间的方向
// yield return new WaitForSeconds(0.01f);
// }
//}
////设置全景球的旋转为数据库中读取到的数据
//if(result[0][1] !="")
//{
// Vector3 temp=new Vector3(float.Parse(result[0][1]),float.Parse(result[0][2]),float.Parse(result[0][3]));
// ObjectManager.Instance.RoomSphere.transform.eulerAngles=temp;
//}
//else
//{//没有旋转数据就把球还原
// Vector3 temp=new Vector3(0,0,0);
// ObjectManager.Instance.RoomSphere.transform.eulerAngles=temp;
//}
#endregion
//显示房间内UI
ObjectManager.Instance.SphereLoding.SetActive(false);
ObjectManager.Instance.RoomSphere.SetActive(false);
ObjectManager.Instance.MainCanvas.SetActive(false);
//ObjectManager.Instance.outputCanvas.SetActive(true);
//ObjectManager.Instance.outputCanvas.transform.GetChild(0).DOLocalJump(Vector3.zero, 5.0f, 10, 1.0f).OnComplete(delegate () { ObjectManager.Instance.MainCanvas.SetActive(false); });
//IsAtHouse =true;//将当前状态设置为在房内
}
