void CreateNewDayKe(Transform keDau)
{
Debug.Log(NextID(CreateObjOnMap.listDayKe[CreateObjOnMap.listDayKe.Count - 1].Id, "DK"));
DayKe dayKeTemp = new DayKe();
dayKeTemp.Id = NextID(CreateObjOnMap.listDayKe[CreateObjOnMap.listDayKe.Count - 1].Id, "DK");
dayKeTemp.X = keDau.position.x;
dayKeTemp.Z = keDau.position.z;
dayKeTemp.RotY = (int)keDau.eulerAngles.y;
dayKeTemp.Name = dayKeTemp.Id;
GameObject objDK = Instantiate(CreateObjOnMap.dayKePrefabSta, new Vector3(keDau.position.x, 0, keDau.position.z), keDau.rotation);
objDK.name = NextID(CreateObjOnMap.listDayKe[CreateObjOnMap.listDayKe.Count - 1].Id, "DK");
dayKeTemp.Obj = objDK;
objDK.GetComponent <DragDayKe>().dayKe = dayKeTemp;
CreateObjOnMap.listDayKe.Add(dayKeTemp);
keDau.SetParent(objDK.transform);
parent = objDK.transform;
objDK.transform.GetChild(0).GetChild(0).GetComponent <Text>().text = dayKeTemp.Name;
}
void Start()
{
dayKePrefabSta = dayKePrefab;
kePrefabSta = kePrefab;
item1xSta = item1x;
item2xSta = item2x;
listDayKe = new List <DayKe>();
listKe = new List <Ke>();
listItemAll = new List <SanPham>();
listItem = new List <SanPham>();
listItemWareHouse = new List <SanPham>();
listType = new List <LoaiSanPham>();
listNameType = new List <string>();
conn = "URI=file:" + Application.dataPath + "/dbSM.s3db";
try
{
dbconn = new SqliteConnection(conn);
dbconn.Open();
dbcmd = dbconn.CreateCommand();
string sqlQuery = "SELECT * FROM DayKe";
dbcmd.CommandText = sqlQuery;
reader = dbcmd.ExecuteReader();
while (reader.Read())
{
string keID = reader.GetString(0);
string name = reader.GetString(1);
float X = reader.GetFloat(2);
float Z = reader.GetFloat(3);
int rotY = reader.GetInt32(4);
DayKe dayKe = new DayKe();
dayKe.Id = keID;
dayKe.X = X;
dayKe.Z = Z;
dayKe.RotY = rotY;
dayKe.Name = name;
GameObject objDK = Instantiate(dayKePrefab, new Vector3(dayKe.X, 0, dayKe.Z), new Quaternion(0, 0, 0, 0));
objDK.transform.eulerAngles = new Vector3(0, dayKe.RotY, 0);
objDK.name = dayKe.Id;
dayKe.Obj = objDK;
objDK.GetComponent <DragDayKe>().dayKe = dayKe;
objDK.transform.GetChild(0).GetChild(0).GetComponent <Text>().text = dayKe.Name;
listDayKe.Add(dayKe);
}
sqlQuery = "SELECT * FROM Ke";
dbcmd = dbconn.CreateCommand();
dbcmd.CommandText = sqlQuery;
reader = dbcmd.ExecuteReader();
while (reader.Read())
{
string keID = reader.GetString(0);
string daykeID = reader.GetString(1);
float X = reader.GetFloat(2);
Ke ke = new Ke();
ke.Id = keID;
ke.X = X;
ke.DayKeID = daykeID;
GameObject objKe = Instantiate(kePrefab, new Vector3(0, 0, 0), new Quaternion(0, 0, 0, 0));
objKe.name = ke.Id;
objKe.transform.SetParent(FindParent(ke.DayKeID).transform);
objKe.transform.localPosition = new Vector3(ke.X, 0, 0);
objKe.transform.localEulerAngles = new Vector3(0, 0, 0);
ke.Obj = objKe;
objKe.GetComponent <Drag>().ke = ke;
listKe.Add(ke);
}
sqlQuery = "SELECT * FROM SanPham";
dbcmd = dbconn.CreateCommand();
dbcmd.CommandText = sqlQuery;
reader = dbcmd.ExecuteReader();
while (reader.Read())
{
if (reader.GetString(9) == "N")
{
GameObject ke1Found = FindKe(reader.GetString(3));
if (ke1Found != null)
{
GameObject ke2Found = FindKe(reader.GetString(4));
if ((int)reader.GetFloat(5) == 1 || ((int)reader.GetFloat(5) == 2 && ke2Found != null && ((ke1Found = ke2Found) || (ke1Found.transform.parent == ke2Found.transform.parent && ke1Found.transform.GetSiblingIndex() == ke2Found.transform.GetSiblingIndex() - 1))))
{
SanPham sanPham = new SanPham();
sanPham.Id = reader.GetString(0);
sanPham.Name = reader.GetString(1);
sanPham.Type = reader.GetString(2);
sanPham.KeID1 = reader.GetString(3);
sanPham.KeID2 = reader.GetString(4);
sanPham.Size = (int)reader.GetFloat(5);
sanPham.Price = reader.GetInt32(6);
sanPham.Pos1 = reader.GetInt32(7);
sanPham.Pos2 = reader.GetInt32(8);
sanPham.Status = false;
sanPham.Description = reader.GetString(10);
//sanPham.Description = "Đang đợi nhập liệu...";
sanPham.Exp = reader.GetString(11);
sanPham.Weight = reader.GetInt32(12);
sanPham.Quantity = reader.GetInt32(13);
sanPham.Image = reader.GetString(14);
GameObject item;
if (sanPham.Size == 1)
{
item = Instantiate(item1x, FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position, FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).rotation);
}
else
{
int y = (int)FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).eulerAngles.y;
switch (y)
{
case 0:
item = Instantiate(item2x, new Vector3(FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.x + 0.5f, FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.y, FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.z), FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).rotation);
break;
case 180:
item = Instantiate(item2x, new Vector3(FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.x - 0.5f, FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.y, FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.z), FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).rotation);
break;
case 90:
item = Instantiate(item2x, new Vector3(FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.x, FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.y, FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.z - 0.5f), FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).rotation);
break;
case 270:
item = Instantiate(item2x, new Vector3(FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.x, FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.y, FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.z + 0.5f), FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).rotation);
break;
case 44:
item = Instantiate(item2x, new Vector3(FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.x + 0.3535f, FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.y, FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.z - 0.3535f), FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).rotation);
break;
case 224:
item = Instantiate(item2x, new Vector3(FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.x - 0.3535f, FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.y, FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.z + 0.3535f), FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).rotation);
break;
default:
item = Instantiate(item2x, new Vector3(FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.x + 0.5f, FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.y, FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).position.z), FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).rotation);
break;
}
}
item.transform.eulerAngles = new Vector3(item.transform.eulerAngles.x, item.transform.eulerAngles.y, 180f);
FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1).GetComponent <BoxCollider>().enabled = false;
item.GetComponent <DragItem>().posObj = FindKe(sanPham.KeID1).transform.Search("Position " + sanPham.Pos1);
item.GetComponent <DragItem>().posObj.GetComponent <DropItem>().allowDrop = false;
FindKe(sanPham.KeID2).transform.Search("Position " + sanPham.Pos2).GetComponent <BoxCollider>().enabled = false;
item.GetComponent <DragItem>().posObj2 = FindKe(sanPham.KeID2).transform.Search("Position " + sanPham.Pos2);
item.GetComponent <DragItem>().posObj2.GetComponent <DropItem>().allowDrop = false;
sanPham.Obj = item;
item.GetComponent <DragItem>().sanPham = sanPham;
item.GetComponent <MeshRenderer>().material.mainTexture = LoadTexture(Application.dataPath + "/Images/Products/" + sanPham.Image);
listItem.Add(sanPham);
listItemAll.Add(sanPham);
}
else
{
SanPham sanPham = new SanPham();
sanPham.Id = reader.GetString(0);
sanPham.Name = reader.GetString(1);
sanPham.Type = reader.GetString(2);
sanPham.KeID1 = "";
sanPham.KeID2 = "";
sanPham.Size = (int)reader.GetFloat(5);
sanPham.Price = reader.GetInt32(6);
sanPham.Pos1 = 0;
sanPham.Pos2 = 0;
sanPham.Status = true;
sanPham.Description = reader.GetString(10);
//sanPham.Description = "Đang đợi nhập liệu...";
sanPham.Exp = reader.GetString(11);
sanPham.Weight = reader.GetInt32(12);
sanPham.Quantity = reader.GetInt32(13);
sanPham.Image = reader.GetString(14);
sanPham.Obj = null;
listItemWareHouse.Add(sanPham);
listItemAll.Add(sanPham);
Warehouse.AddWarehouse(sanPham);
}
}
else
{
SanPham sanPham = new SanPham();
sanPham.Id = reader.GetString(0);
sanPham.Name = reader.GetString(1);
sanPham.Type = reader.GetString(2);
sanPham.KeID1 = "";
sanPham.KeID2 = "";
sanPham.Size = (int)reader.GetFloat(5);
sanPham.Price = reader.GetInt32(6);
sanPham.Pos1 = 0;
sanPham.Pos2 = 0;
sanPham.Status = true;
sanPham.Description = reader.GetString(10);
//sanPham.Description = "Đang đợi nhập liệu...";
sanPham.Exp = reader.GetString(11);
sanPham.Weight = reader.GetInt32(12);
sanPham.Quantity = reader.GetInt32(13);
sanPham.Image = reader.GetString(14);
sanPham.Obj = null;
listItemWareHouse.Add(sanPham);
listItemAll.Add(sanPham);
Warehouse.AddWarehouse(sanPham);
}
}
else
{
SanPham sanPham = new SanPham();
sanPham.Id = reader.GetString(0);
sanPham.Name = reader.GetString(1);
sanPham.Type = reader.GetString(2);
sanPham.KeID1 = "";
sanPham.KeID2 = "";
sanPham.Size = (int)reader.GetFloat(5);
sanPham.Price = reader.GetInt32(6);
sanPham.Pos1 = 0;
sanPham.Pos2 = 0;
sanPham.Status = true;
sanPham.Description = reader.GetString(10);
//sanPham.Description = "Đang đợi nhập liệu...";
sanPham.Exp = reader.GetString(11);
sanPham.Weight = reader.GetInt32(12);
sanPham.Quantity = reader.GetInt32(13);
sanPham.Image = reader.GetString(14);
sanPham.Obj = null;
listItemWareHouse.Add(sanPham);
listItemAll.Add(sanPham);
Warehouse.AddWarehouse(sanPham);
}
}
reader.Close();
reader = null;
dbcmd.Dispose();
dbcmd = null;
dbconn.Close();
dbconn = null;
}
catch (Exception ex)
{
Debug.Log(ex);
}
}
