bool ITypeDao.updateType(Entity.Type type)
{
string sql = "update type set employeeid = :id , name = :name where typeid =" + type.TypeID;
OracleCommand cmd = new OracleCommand(sql, con);
cmd.Parameters.Add(":id", OracleDbType.Int32);
cmd.Parameters.Add(":name", OracleDbType.Varchar2);
cmd.Parameters[0].Value = type.Employee.EmployeeID;
cmd.Parameters[1].Value = type.Name;
int result = -1;
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
result = cmd.ExecuteNonQuery();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
finally
{
con.Close();
}
if (result != -1)
{
return(true);
}
return(false);
}
public void AddUnit(Entity.Type type)
{
GameObject unit = Instantiate(unitPrefab) as GameObject;
unit.transform.parent = transform;
unit.transform.localPosition = m_offset;
switch (type)
{
case Entity.Type.bomber:
unit.GetComponent <tk2dSprite>().SetSprite("SmallFighter");
break;
case Entity.Type.fighter:
unit.GetComponent <tk2dSprite>().SetSprite("SmallBomber");
break;
//case Entity.Type.icbm:
// sprite.GetComponent<tk2dSprite>().SetSprite("SmallFighter");
// break;
default:
break;
}
m_offset.x += unit.GetComponent <tk2dSprite>().GetBounds().size.x + 3;
unit.SetActive(false);
m_spawnList.Add(unit);
}
public static string GetCityTypesFullName(int id)
{
try
{
Entity.Type type = GetTypeByID(id);
if (type != null)
{
if (type.PID == TypeConfigs.GetCityRoot)
{
return(type.Name);
}
else
{
Entity.Type type1 = GetTypeByID(type.PID);
if (type1 != null)
{
return(string.Format("{0},{1}", type1.Name, type.Name));
}
else
{
return(type.Name);
}
}
}
else
{
throw new Exception("不存在类别");
}
}
catch (Exception ex)
{
Logs.WriteErrorLog(ex);
return("其他");
}
}
private GameObject CreateButton(string name, string img, Entity.Type type, Vector2 offset)
{
GameObject ret = new GameObject();
ret.name = name;
ret.transform.parent = this.transform;
ret.transform.localPosition = offset;
ret.SetActive(false);
tk2dSprite sprite = ret.AddComponent <tk2dSprite>();
sprite.SetSprite(GetComponent <tk2dSprite>().Collection, m_theme + img);
BoxCollider2D box = ret.AddComponent <BoxCollider2D>();
box.size = sprite.GetBounds().size;
box.isTrigger = true;
UIUnit unit = ret.AddComponent <UIUnit>();
unit.m_buySound = m_buySound;
unit.type = type;
unit.fab = this;
return(ret);
}
public void AddToSpawnList(Entity.Type type)
{
if (IsOpen())
{
m_spawnList.Add(type);
m_unitQueueUI.AddUnit(type);
}
}
public void AddEntity(string name, int age, float weight, float height, Entity.Type type)
{
Entity newEntity = new Entity();
newEntity.SetEntity(name, age, weight, height, type);
entities.Add(newEntity);
}
public GameObject SpawnUnit(Entity.Type type)
{
GameObject prefab = null;
switch (type)
{
case Entity.Type.fighter:
if (m_fighterLevel < 1)
{
prefab = fighterSmall;
}
else if (m_fighterLevel < 2)
{
prefab = fighterMedium;
}
else
{
prefab = fighterBig;
}
break;
case Entity.Type.bomber:
if (m_bomberLevel < 1)
{
prefab = bomberSmall;
}
else if (m_bomberLevel < 2)
{
prefab = bomberMedium;
}
else
{
prefab = bomberBig;
}
break;
case Entity.Type.icbm:
if (m_icbmLevel < 1)
{
prefab = icbmSmall;
}
else if (m_icbmLevel < 2)
{
prefab = icbmMedium;
}
else
{
prefab = icbmBig;
}
break;
}
prefab.GetComponent <Entity>().m_owner = owner;
return(Instantiate(prefab) as GameObject);
}
public void CheckAltUse()
{
Collider selected;
Entity.Type entType = LookingAt(out selected);
if (playerMain.input.act_altUse)
{
switch (entType)
{
case Entity.Type.TPEye:
if (playerMain.prog.abilityEye)
{
selected.GetComponent <EntityHeader>().TPPlayerToSelf();
}
break;
}
}
}
public static int GetCostOf(Entity.Type type)
{
switch (type)
{
case Entity.Type.fighter:
return(COST_FIGHTER);
case Entity.Type.bomber:
return(COST_BOMBER);
case Entity.Type.icbm:
return(COST_ICBM);
default:
Debug.LogError("Entity type " + type + " does not have a cost.");
return(0);
}
}
Entity.Type ITypeDao.getSingleType(int typeid)
{
Entity.Type type = null;
string sql = "select * from type where typeid = :id";
OracleCommand cmd = new OracleCommand(sql, con);
cmd.Parameters.Add("id", OracleDbType.Int32);
cmd.Parameters[0].Value = typeid;
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
OracleDataReader DataReader = cmd.ExecuteReader();
if (DataReader.Read())
{
type = new Entity.Type();
int id = int.Parse(DataReader["typeid"].ToString());
string name = DataReader["name"].ToString();
int employeeid = int.Parse(DataReader["employeeid"].ToString());
// Employee employee = new Employee();
// employee.EmployeeID = employeeid;
IEmployeeDao dao = new EmployeeDao();
type.Employee = dao.getSingleEmployee(employeeid);
type.TypeID = id;
type.Name = name;
// type.Employee = employee;
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(type);
}
private static Bitmap getTypeIcon(Entity.Type type)
{
switch (type)
{
case Entity.Type.GET:
return(Properties.Resources.get);
case Entity.Type.POST:
return(Properties.Resources.post);
case Entity.Type.PUT:
return(Properties.Resources.put);
case Entity.Type.DELETE:
return(Properties.Resources.delete);
default:
return(Properties.Resources.get);
}
}
public static IService GetService(Entity.Type serviceType)
{
switch (serviceType)
{
case Entity.Type.GET:
return(new GetService());
case Entity.Type.POST:
return(new PostOrPutService());
case Entity.Type.PUT:
return(new PostOrPutService());
case Entity.Type.DELETE:
return(new DeleteService());
default:
return(null);
}
}
List <Entity.Type> ITypeDao.getTypeList()
{
List <Entity.Type> TypeList = new List <Entity.Type>();
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sql = "select * from type";
OracleCommand cmd = new OracleCommand(sql, con);
OracleDataReader DataReader = cmd.ExecuteReader();
while (DataReader.Read())
{
Entity.Type type = new Entity.Type();
int id = int.Parse(DataReader["typeid"].ToString());
string name = DataReader["name"].ToString();
int employeeid = int.Parse(DataReader["employeeid"].ToString());
Employee employee = new Employee();
employee.EmployeeID = employeeid;
type.TypeID = id;
type.Name = name;
type.Employee = employee;
TypeList.Add(type);
}
}
catch (Exception ex)
{
Console.Out.WriteLine(ex.ToString());
}
finally
{
con.Close();
}
return(TypeList);
}
bool ITypeDao.addType(Entity.Type type)
{
string sql = "insert into type values(null,:name,:employeeid)";
OracleCommand cmd = new OracleCommand(sql, con);
cmd.Parameters.Add(":name", OracleDbType.Varchar2);
cmd.Parameters.Add(":employeeid", OracleDbType.Int32);
cmd.Parameters[0].Value = type.Name;
cmd.Parameters[1].Value = type.Employee.EmployeeID;
int result = -1;
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
result = cmd.ExecuteNonQuery();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
if (result != -1)
{
return(true);
}
return(false);
}
public void EntityEnter(uint id, Entity.Type type, uint subType, Vector3 position, float direction)
{
Entity entity = null;
switch (type)
{
case Entity.Type.Player:
case Entity.Type.NPC:
{
RoleInfo info = Core.Database.GetRoleInfo(subType);
GameObject go = Core.Database.LoadResource("Roles/" + info.res);
go.transform.localScale = Vector3.one * info.scale;
Role role = go.AddComponent <Role>();
go.AddComponent <RoleAnimator>();
RoleAgent agent = go.AddComponent <RoleAgent>();
agent.RoleId = id;
CapsuleCollider collider = go.AddComponent <CapsuleCollider>();
collider.radius = 0.5f;
collider.height = 2;
collider.center = new Vector3(0, 1.1f, 0);
if (Core.Account.role == null)
{
Core.Account.role = role;
m_camera.GetComponent <CameraController>().target = go.transform;
go.AddComponent <RoleController>();
Rigidbody rigidbody = go.AddComponent <Rigidbody>();
rigidbody.freezeRotation = true;
rigidbody.useGravity = false;
}
entity = role;
}
break;
case Entity.Type.Teleporter:
{
GameObject go = Core.Database.LoadResource("Entities/Teleporter");
entity = go.AddComponent <Teleporter>();
}
break;
case Entity.Type.Item:
{
GameObject go = Core.Database.LoadResource("Entities/Bottle");
entity = go.AddComponent <DropItem>();
}
break;
default:
break;
}
if (entity != null)
{
entity.SetInfo(id, type, subType);
entity.SetPosition(position);
entity.SetDirection(direction);
AddEntity(entity);
}
}
public List <Pet> GetPetByType(Entity.Type type)
{
return(_petRepo.ReadPetByType(type));
}
bool ITypeDao.deleteType(Entity.Type type)
{
List <int> GoodList = new List <int>();
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sql = "select goodid from good where typeid=" + type.TypeID;
OracleCommand cmd = new OracleCommand(sql, con);
OracleDataReader DataReader = cmd.ExecuteReader();
while (DataReader.Read())
{
GoodList.Add(int.Parse(DataReader["goodid"].ToString()));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
if (GoodList.Count > 0)
{
return(false);
}
else
{
string sql = "delete from type where typeid=:id";
OracleCommand cmd = new OracleCommand(sql, con);
cmd.Parameters.Add(":id", OracleDbType.Int32);
cmd.Parameters[0].Value = type.TypeID;
int result = -1;
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
result = cmd.ExecuteNonQuery();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
if (result != -1)
{
return(true);
}
return(false);
}
}
private void Spawn(Entity.Type type)
{
State.EnemyMoney -= State.GetCostOf(type);
SendUnit(m_unitFactory.SpawnUnit(type));
}
