private void SetPanel(Transform panel, PartyPosition position)
{
ClearPanel(panel);
Unit unit = _AssignedParty.GetAssignedUnit(position);
if (unit != null)
{
GameObject unitPanel = Instantiate(UnitPanelPrefab);
unitPanel.transform.SetParent(panel, false);
UnitPanel panelControl = unitPanel.GetComponent <UnitPanel>();
if (panelControl != null)
{
panelControl.DisplayedUnit = unit;
panelControl.UnitPosition = position;
}
}
}
public IHttpActionResult PartyPositionEdit([FromBody] PartyPosition item)
{
List <PartyPosition> result = new List <PartyPosition>();
DBConnector.DBConnector conn = new DBConnector.DBConnector();
string SQLString;
if (conn.OpenConnection())
{
try
{
SQLString = @"update partyposition set PositionRunno = @PositionRunno, PositionNo = @PositionNo,
PositionName = @PositionName where PositionRunno = @PositionRunno";
MySqlCommand qExe = new MySqlCommand
{
Connection = conn.connection,
CommandText = SQLString
};
qExe.Parameters.AddWithValue("@PositionRunno", item.PositionRunno);
qExe.Parameters.AddWithValue("@PositionNo", item.PositionNo);
qExe.Parameters.AddWithValue("@PositionName", item.PositionName);
qExe.ExecuteNonQuery();
conn.CloseConnection();
return(Json(new ResultDataModel {
success = true, errorMessage = "", returnRunno = ""
}));
}
catch (Exception e)
{
return(Json(new ResultDataModel {
success = false, errorMessage = e.Message, returnRunno = ""
}));
}
}
else
{
return(Json(new ResultDataModel {
success = false, errorMessage = "Database connect fail!", returnRunno = ""
}));
}
}
public IHttpActionResult PartyPositionAdd([FromBody] PartyPosition item)
{
DBConnector.DBConnector conn = new DBConnector.DBConnector();
string SQLString;
if (conn.OpenConnection())
{
try
{
SQLString = @"insert into partyposition (PositionNo, PositionName) values (@PositionNo, @PositionName) ";
MySqlCommand qExe = new MySqlCommand
{
Connection = conn.connection,
CommandText = SQLString
};
qExe.Parameters.AddWithValue("@PositionNo", item.PositionNo);
qExe.Parameters.AddWithValue("@PositionName", item.PositionName);
qExe.ExecuteNonQuery();
long returnid = qExe.LastInsertedId;
conn.CloseConnection();
return(Json(new ResultDataModel {
success = true, errorMessage = "", returnRunno = returnid.ToString()
}));
}
catch (Exception e)
{
return(Json(new ResultDataModel {
success = false, errorMessage = e.Message, returnRunno = ""
}));
}
}
else
{
return(Json(new ResultDataModel {
success = false, errorMessage = "Database connect fail!", returnRunno = ""
}));
}
}
