/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ProvinceInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dt_Province set ");
strSql.Append("ID=@ID,");
strSql.Append("ProvinceName=@ProvinceName");
strSql.Append(" where ID=@ID and ProvinceName=@ProvinceName ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.BigInt, 8),
new SqlParameter("@ProvinceName", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.ProvinceName;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public SelectionProvince(ProvinceInfo info, bool isSelected)
{
Id = info.Id;
Name = info.Name;
Slug = info.Slug;
IsSelected = isSelected;
}
protected virtual StarMapProvince CreateProvince(
GameObjectSet gos,
ProvinceInfo oi,
StarMapBase.SyncContext context)
{
return((StarMapProvince)null);
}
public void GiveInformation(Province province)
{
if (province == currentProvince)
{
return;
}
ProvinceInfo pop = province.ProvinceInfo;
float[] temp = { pop.ruralPopulation, pop.urbanPopulation, pop.aristocraticPopulation };
currentProvince = province;
//populationPieGraph.GiveValues( temp);
populationText.text = "Population Stats: " + "\n" + pop.totalPopulation + " Total\n";
provinceName.text = currentProvince.GetName();
//culturePieGraph.MakeCultureGraph(province.ProvinceInfo);
religionText.text += "\n" + pop.GetMajorityReligion().religionName;
Debug.Log("total pop" + pop.totalPopulation);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ProvinceInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dt_Province(");
strSql.Append("ID,ProvinceName)");
strSql.Append(" values (");
strSql.Append("@ID,@ProvinceName)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.BigInt, 8),
new SqlParameter("@ProvinceName", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.ProvinceName;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ProvinceInfo GetModel(long ID, string ProvinceName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,ProvinceName from dt_Province ");
strSql.Append(" where ID=@ID and ProvinceName=@ProvinceName ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.BigInt, 8),
new SqlParameter("@ProvinceName", SqlDbType.NVarChar, 50)
};
parameters[0].Value = ID;
parameters[1].Value = ProvinceName;
ProvinceInfo model = new ProvinceInfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
private void menuCity_AddNew_Click(object sender, EventArgs e)
{
if (!HasFunction("Dictionary/CityDistrict/CityAdd"))
{
MessageDxUtil.ShowError(Const.NoAuthMsg);
return;
}
if (SelectedProvinceId == 0)
{
MessageDxUtil.ShowTips("请先选择省份");
return;
}
ProvinceInfo info = BLLFactory <Province> .Instance.FindById(SelectedProvinceId);
if (info != null)
{
FrmEditCity dlg = new FrmEditCity();
dlg.txtProvince.Text = info.ProvinceName;
dlg.txtProvince.Tag = info.Id;
dlg.OnDataSaved += new EventHandler(dlgCity_OnDataSaved);
dlg.ShowDialog();
}
}
private void Province()
{
var items = GetTemplate <List <ProvinceTemplate> >(@"Template\provinces.json");
foreach (var item in items)
{
try
{
var info = new ProvinceInfo();
info.Code = item.PROVINCE_CODE;
info.GeographyId = item.GEO_ID;
info.Id = item.PROVINCE_ID;
info.Name = item.PROVINCE_NAME;
using (var context = new ThailandAddressMsSqlEntities())
{
context.ProvinceInfoes.Add(info);
context.SaveChanges();
}
}
catch (Exception ex)
{
_logger.Error($"Province || {ex}");
}
}
}
private void menuCity_Edit_Click(object sender, EventArgs e)
{
if (!HasFunction("Dictionary/CityDistrict/CityEdit"))
{
MessageDxUtil.ShowError(Const.NoAuthMsg);
return;
}
TreeNode selectedNode = this.treeCity.SelectedNode;
if (selectedNode != null && selectedNode.Tag != null)
{
ProvinceInfo info = BLLFactory <Province> .Instance.FindById(SelectedProvinceId);
if (info != null)
{
FrmEditCity dlg = new FrmEditCity();
dlg.txtProvince.Text = info.ProvinceName;
dlg.txtProvince.Tag = info.Id;
dlg.Id = Convert.ToInt32(selectedNode.Tag);
dlg.OnDataSaved += new EventHandler(dlgCity_OnDataSaved);
dlg.ShowDialog();
}
}
}
public ProvinceInfo[] getInfo()
{
ProvinceInfo[] info = new ProvinceInfo[provinces.Count];
for (int i = 0; i < provinces.Count; i++)
{
info[i] = provinces[i].ProvinceInfo;
}
return(info);
}
protected override StarMapProvince CreateProvince(
GameObjectSet gos,
ProvinceInfo oi,
StarMapBase.SyncContext context)
{
StarMapProvince starMapProvince = new StarMapProvince(this.App);
starMapProvince.SetLabel(oi.Name);
gos.Add((IGameObject)starMapProvince);
return(starMapProvince);
}
private void FrmEditProvince_Load(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(ID))
{
ProvinceInfo info = BLLFactory <Province> .Instance.FindByID(ID);
if (info != null)
{
tempInfo = info;
this.txtProvince.Text = info.ProvinceName;
}
}
}
private ProvinceInfo ReadProvinceInfo(SqlDataReader dr)
{
ProvinceInfo pri = new ProvinceInfo()
{
Id = DatabaseHelper.GetInt32("Id", dr),
ProvinceName = DatabaseHelper.GetString("ProvinceName", dr),
ProvinceCode = DatabaseHelper.GetString("ProvinceCode", dr),
ProvinceShortNAme = DatabaseHelper.GetString("ProvinceShortName", dr),
MapId = DatabaseHelper.GetString("ProvinceMapId", dr)
};
return(pri);
}
//定义私有方法获取信息
private static List <ProvinceInfo> GetInfoBySql(string strsql)
{
List <ProvinceInfo> list = new List <ProvinceInfo>();
DataTable dt = DBHelper.GetTable(strsql);
foreach (DataRow row in dt.Rows)
{
ProvinceInfo provinceInfo = new ProvinceInfo();
provinceInfo.ProviceId = Convert.ToInt32(row["ProviceId"]);
provinceInfo.ProviceName = row["ProviceName"].ToString();
list.Add(provinceInfo);
}
return(list);
}
private void listView1_MouseDoubleClick(object sender, MouseEventArgs e)
{
//双击选择
if (this.listView1.SelectedItems.Count < 1)
{
return;
}
var selectedItem = this.listView1.SelectedItems[0];
var info = selectedItem.Tag as ProvinceInfo;
this.ProvinceInfo = info;
this.DialogResult = DialogResult.OK;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ProvinceInfo DataRowToModel(DataRow row)
{
ProvinceInfo model = new ProvinceInfo();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = Convert.ToInt16(row["ID"].ToString());
}
if (row["ProvinceName"] != null)
{
model.ProvinceName = row["ProvinceName"].ToString();
}
}
return(model);
}
protected override void UpdateProvince(
StarMapProvince o,
ProvinceInfo oi,
StarMapBase.SyncContext context)
{
ProvinceInfo provinceInfo = this._db.GetProvinceInfo(oi.ID);
oi.Name = provinceInfo.Name;
oi.PlayerID = provinceInfo.PlayerID;
oi.CapitalSystemID = provinceInfo.CapitalSystemID;
o.SetPosition(this._db.GetStarSystemOrigin(oi.CapitalSystemID));
if (this._db.IsStarSystemVisibleToPlayer(this._sim.LocalPlayer.ID, oi.CapitalSystemID))
{
o.SetCapital(this.Systems.Reverse[oi.CapitalSystemID]);
}
o.SetPlayer(this._sim.GetPlayerObject(oi.PlayerID));
}
private void menuCity_AddNew_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(SelectedProvinceId))
{
MessageDxUtil.ShowTips("请先选择省份");
return;
}
ProvinceInfo info = BLLFactory <Province> .Instance.FindByID(SelectedProvinceId);
if (info != null)
{
FrmEditCity dlg = new FrmEditCity();
dlg.txtProvince.Text = info.ProvinceName;
dlg.txtProvince.Tag = info.ID;
dlg.OnDataSaved += new EventHandler(dlgCity_OnDataSaved);
dlg.ShowDialog();
}
}
private void menuCity_Edit_Click(object sender, EventArgs e)
{
TreeNode selectedNode = this.treeCity.SelectedNode;
if (selectedNode != null && selectedNode.Tag != null)
{
ProvinceInfo info = BLLFactory <Province> .Instance.FindByID(SelectedProvinceId);
if (info != null)
{
FrmEditCity dlg = new FrmEditCity();
dlg.txtProvince.Text = info.ProvinceName;
dlg.txtProvince.Tag = info.ID;
dlg.ID = selectedNode.Tag.ToString();
dlg.OnDataSaved += new EventHandler(dlgCity_OnDataSaved);
dlg.ShowDialog();
}
}
}
public List <ProvinceInfo> GetAllProvinceInfo()
{
List <ProvinceInfo> list = new List <ProvinceInfo>();
string sqlcmd = "Select * From ProvinceInfo Order by pinyin";
SqlDataReader reader = SqlHelper.ExecuteReader(
SqlHelper.ConnectionString,
CommandType.Text,
sqlcmd);
ProvinceInfo province;
while (reader.Read())
{
province = new ProvinceInfo();
province.Name = reader["Name"].ToString();
province.Simple = reader["Simple"].ToString();
list.Add(province);
}
return(list);
}
public void BuildBasicInfo()
{
string[] data = File.ReadAllLines("Assets/ProvinceMap/Resources/provBasic.txt");
foreach (string entry in data)
{
//Basic info
ProvinceInfo prov = new ProvinceInfo();
string[] elements = entry.Split('#');
prov.provinceID = int.Parse(elements[0]);
prov.provinceColour = new Color32((byte)int.Parse(elements[1]), (byte)int.Parse(elements[2]), (byte)int.Parse(elements[3]), 255);
//GameObject Creation
GameObject go = new GameObject();
go.name = "provinceID: " + prov.provinceID;
//Province province = go.AddComponent<Province>();
//province.ProvinceInfo = prov;
//BuildBorders(province);
//go.transform.SetParent(this.transform);
//ProvinceController.instance.AddProvince(province);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ProvinceInfo model)
{
return(dal.Update(model));
}
protected virtual void UpdateProvince(
StarMapProvince o,
ProvinceInfo oi,
StarMapBase.SyncContext context)
{
}
public SelectionProvince(ProvinceInfo info)
{
Id = info.Id;
Name = info.Name;
Slug = info.Slug;
}
public void Sync(GameObjectSet gos)
{
StarMapBase.SyncContext context = new StarMapBase.SyncContext(this._db);
List <StarSystemInfo> list1 = this._db.GetStarSystemInfos().ToList <StarSystemInfo>();
foreach (StarSystemInfo starSystemInfo in list1.Where <StarSystemInfo>((Func <StarSystemInfo, bool>)(x => !x.IsVisible)).ToList <StarSystemInfo>())
{
if (!StarMap.IsInRange(this._db, this._sim.LocalPlayer.ID, starSystemInfo.ID))
{
list1.Remove(starSystemInfo);
}
else
{
starSystemInfo.IsVisible = true;
this._db.UpdateStarSystemVisible(starSystemInfo.ID, true);
}
}
IEnumerable <StarMapTerrain> source1 = this.Terrain.Sync(gos, this._db.GetTerrainInfos(), context, false);
IEnumerable <StarMapProvince> source2 = this.Provinces.Sync(gos, this._db.GetProvinceInfos(), context, false);
IEnumerable <StarMapSystem> source3 = this.Systems.Sync(gos, (IEnumerable <StarSystemInfo>)list1, context, false);
List <FleetInfo> list2 = this._db.GetFleetInfos(FleetType.FL_NORMAL | FleetType.FL_CARAVAN | FleetType.FL_ACCELERATOR).Where <FleetInfo>((Func <FleetInfo, bool>)(x =>
{
if (!x.IsReserveFleet)
{
return(this._sim.GetPlayerObject(x.PlayerID) != null);
}
return(false);
})).ToList <FleetInfo>();
int swarmerPlayer = this._sim.ScriptModules == null || this._sim.ScriptModules.Swarmers == null ? 0 : this._sim.ScriptModules.Swarmers.PlayerID;
if (swarmerPlayer != 0)
{
foreach (FleetInfo fleetInfo in list2.Where <FleetInfo>((Func <FleetInfo, bool>)(x =>
{
if (x.PlayerID == swarmerPlayer)
{
return(x.Name.Contains("Swarm"));
}
return(false);
})).ToList <FleetInfo>())
{
list2.Remove(fleetInfo);
}
}
foreach (FleetInfo fleetInfo in list2.Where <FleetInfo>((Func <FleetInfo, bool>)(x =>
{
if (this._db.GetMissionByFleetID(x.ID) != null)
{
return(this._db.GetMissionByFleetID(x.ID).Type == MissionType.PIRACY);
}
return(false);
})).ToList <FleetInfo>())
{
if (!this._db.PirateFleetVisibleToPlayer(fleetInfo.ID, this._sim.LocalPlayer.ID))
{
list2.Remove(fleetInfo);
}
}
IEnumerable <StarMapFleet> source4 = this.Fleets.Sync(gos, (IEnumerable <FleetInfo>)list2, context, true);
this.PostObjectAddObjects((IGameObject[])source2.ToArray <StarMapProvince>());
this.PostObjectAddObjects((IGameObject[])source3.ToArray <StarMapSystem>());
this.PostObjectAddObjects((IGameObject[])source4.ToArray <StarMapFleet>());
if (this._sim.LocalPlayer.Faction.Name == "human")
{
this.PostObjectAddObjects((IGameObject[])this.NodeLines.Sync(gos, (IEnumerable <NodeLineInfo>) this._db.GetExploredNodeLines(this._sim.LocalPlayer.ID).Where <NodeLineInfo>((Func <NodeLineInfo, bool>)(x => x.IsPermenant)).ToList <NodeLineInfo>(), context, false).ToArray <StarMapNodeLine>());
}
this.PostObjectAddObjects((IGameObject[])source1.ToArray <StarMapTerrain>());
Dictionary <int, int> dictionary1 = new Dictionary <int, int>();
List <StarMap.PlayerSystemPair> playerSystemPairList = new List <StarMap.PlayerSystemPair>();
foreach (StarMapFleet key in this.Fleets.Forward.Keys)
{
this._sim.GameDatabase.IsStealthFleet(key.FleetID);
if (key.InTransit)
{
key.SetVisible(StarMap.IsInRange(this.App.Game.GameDatabase, this._sim.LocalPlayer.ID, key.Position, 1f, (Dictionary <int, List <ShipInfo> >)null));
}
else
{
dictionary1[key.SystemID] = 0;
bool flag = false;
foreach (StarMap.PlayerSystemPair playerSystemPair in playerSystemPairList)
{
if (playerSystemPair.PlayerID == key.PlayerID && playerSystemPair.SystemID == key.SystemID)
{
flag = true;
break;
}
}
if (flag)
{
key.SetVisible(false);
}
else
{
key.SetVisible(StarMap.IsInRange(this.App.Game.GameDatabase, this._sim.LocalPlayer.ID, key.Position, 1f, (Dictionary <int, List <ShipInfo> >)null));
playerSystemPairList.Add(new StarMap.PlayerSystemPair()
{
PlayerID = key.PlayerID,
SystemID = key.SystemID
});
}
}
}
foreach (StarMapFleet key in this.Fleets.Forward.Keys)
{
if (!key.InTransit && key.IsVisible)
{
key.SetSystemFleetIndex(dictionary1[key.SystemID]);
Dictionary <int, int> dictionary2;
int systemId;
(dictionary2 = dictionary1)[systemId = key.SystemID] = dictionary2[systemId] + 1;
}
}
foreach (StarMapFleet key in this.Fleets.Forward.Keys)
{
if (!key.InTransit && key.IsVisible)
{
key.SetSystemFleetCount(dictionary1[key.SystemID]);
}
}
foreach (HomeworldInfo homeworld in this._db.GetHomeworlds())
{
HomeworldInfo hw = homeworld;
ColonyInfo hwci = this._db.GetColonyInfo(hw.ColonyID);
if (hwci != null && list1.Any <StarSystemInfo>((Func <StarSystemInfo, bool>)(x =>
{
if (x.ID == hw.SystemID)
{
return(hw.PlayerID == hwci.PlayerID);
}
return(false);
})))
{
this.PostSetProp("Homeworld", (object)this._sim.GetPlayerObject(hw.PlayerID).ObjectID, (object)this.Systems.Reverse[hw.SystemID].ObjectID);
}
}
foreach (StarSystemInfo starSystemInfo in list1)
{
this.PostSetProp("ProvinceCapitalEffect", (object)false, (object)this.Systems.Reverse[starSystemInfo.ID].ObjectID);
}
foreach (ProvinceInfo provinceInfo in this._db.GetProvinceInfos().ToList <ProvinceInfo>())
{
ProvinceInfo p = provinceInfo;
if (list1.Any <StarSystemInfo>((Func <StarSystemInfo, bool>)(x => x.ID == p.CapitalSystemID)))
{
this.PostSetProp("ProvinceCapitalEffect", (object)true, (object)this.Systems.Reverse[p.CapitalSystemID].ObjectID);
}
}
this.PostSetProp("RegenerateTerrain");
this.PostSetProp("RegenerateBorders");
this.PostSetProp("RegenerateFilters");
}
public Province(ProvinceInfo info)
{
this.ProvinceInfo = info;
name = ProvinceInfo.provinceName;
}
