/// <summary>
/// 로비에서 게임화면으로 전환
/// </summary>
/// <param name="eGameName">Name of the e game.</param>
public void LobbyToGame(eGameList eGameName)
{
SOUND.I.PlayStop(DEF.SND.lobby_bgm);
loadGame = eGameName;
Main.I.CurrentView = eView.Game;
string prefabGameName = DEF.GetGamePrefabName(loadGame);
GameObject obj = BUNDLE.I.LoadAsset <GameObject>(prefabGameName);
if (obj)
{
GameObject go = GameObject.Instantiate(obj);
go.name = prefabGameName;
go.transform.SetParent(this.gameObject.transform);
SOUND.I.LoadAssetBundleAudioClipsPackage(DEF.GetGameBundleName(loadGame));
GameMain = go.gameObject.GetComponent <InGame>();
GameMain.gameId = eGameName;
GameMain.Init();
Main.I.AppsFlyerEvent(AFInAppEvents.GAME, AFInAppEvents.GAME_SELECT, eGameName.ToString());
}
if (Lobby.I != null)
{
Lobby.I.LobbyToGame();
}
Coins.LobbyToGame();
Game.LobbyToGame();
BroadCast.LobbyToGame();
}
/// <summary>
/// 로그인후 로비씬 이전에 번틀 버젼채크를 하며, 완료후 로비씬 로딩이 이루어진다.
/// </summary>
private void AssetBundleVersionCheck()
{
_ProgressBar.gameObject.SetActive(true);
_ProgressLock = false;
_BeginTime = Time.time;
if ((SCENEIDs)m_args[0] == SCENEIDs.FBSignOut ||
(SCENEIDs)m_args[0] == SCENEIDs.ReConnectServer)
{
NET.I.AddMessage(PKID.LobbyDisconnect);
NET.I.AddMessage(PKID.LobbyConnect);
if (USER.I.IsGuestLogin)
{
NET.I.AddMessage(PKID.GuestUserJoin);
}
CommonLoginNeworkConnect();
}
else
{
_ProgressBar.SetFillAmount(0.03f);
_ProgressBar.AutoAddGague(60f, null);
StartCoroutine(BUNDLE.I.BeginVersionCheck(() => {
_BeginTime = Time.time;
_ProgressLock = false;
StartCoroutine(BUNDLE.I.DownloadUpdateFromServer(DEF.GetLobbyBundleName(), OnBundleUpdateProgress_Lobby, () => {
StartCoroutine(BUNDLE.I.DownloadUpdateFromServer(DEF.GetGameCommonBundleName(), OnBundleUpdateProgress_Game, () => {
string prefabGameName = DEF.GetGameBundleName(DEF.FIRST_INSTALL_GAME);
StartCoroutine(BUNDLE.I.DownloadUpdateFromServer(prefabGameName, OnBundleUpdateProgress_Game, FirstLoginNetworkConnect));
}, OnLoadError));
}, OnLoadError));
}, OnLoadError));
}
}
void OnEquipmentChanged(Equipment newItem, Equipment oldItem)
{
if (newItem != null)
{
HP.AddModifier(newItem.HP);
SP.AddModifier(newItem.SP);
MIN_ATT.AddModifier(newItem.MIN_ATT);
MAX_ATT.AddModifier(newItem.MAX_ATT);
CRI_RATE.AddModifier(newItem.CRI_RATE);
DEF.AddModifier(newItem.DEF);
ATT_SPD.AddModifier(newItem.ATT_SPD);
MOV_SPD.AddModifier(newItem.MOV_SPD);
STR.AddModifier(newItem.STR);
ACC.AddModifier(newItem.ACC);
SPR.AddModifier(newItem.SPR);
CON.AddModifier(newItem.CON);
AGI.AddModifier(newItem.CON);
CalculateMaxHP();
CalculateMaxSP();
CalculateCurrentDMG();
CalculateCurrentCRI_RATE();
CalculateCurrentDEF();
CalculateCurrentATT_SPD();
CalculateCurrentMOV_SPD();
}
if (oldItem != null)
{
HP.RemoveModifier(oldItem.HP);
SP.RemoveModifier(oldItem.SP);
MIN_ATT.RemoveModifier(oldItem.MIN_ATT);
MAX_ATT.RemoveModifier(oldItem.MAX_ATT);
CRI_RATE.RemoveModifier(oldItem.CRI_RATE);
DEF.RemoveModifier(oldItem.DEF);
ATT_SPD.RemoveModifier(oldItem.ATT_SPD);
MOV_SPD.RemoveModifier(oldItem.MOV_SPD);
STR.RemoveModifier(oldItem.STR);
ACC.RemoveModifier(oldItem.ACC);
SPR.RemoveModifier(oldItem.SPR);
CON.RemoveModifier(oldItem.CON);
AGI.RemoveModifier(oldItem.CON);
CalculateMaxHP();
CalculateMaxSP();
CalculateCurrentDMG();
CalculateCurrentCRI_RATE();
CalculateCurrentDEF();
CalculateCurrentATT_SPD();
CalculateCurrentMOV_SPD();
}
}
static void Main(string[] args)
{
int?seed = null;
Log.writeLine = write;
try
{
title();//タイトル表示
//オプションチェック
int fnIndex = AnalyzeOption(args, ref seed);
//ファイル名が指定されていない場合はusageを表示して終了
if (args.Length < fnIndex + 1)
{
DEF.PF("usage: m98.exe [-SEED=n] file1 [file2]");
throw new M98Exception();
}
string srcFile = args[fnIndex + 0]; //変換対象ファイル
string orgfile = Path.ChangeExtension(args[fnIndex + 0], "ORG"); //初版ファイル
string bupfile = Path.ChangeExtension(args[fnIndex + 0], "BUP"); //処理前のファイル
string saveFn = args[fnIndex + 0]; //処理後のファイル。(ソースと同名で上書き保存)
//引数で別名が指定されていたらそれを使用して保存
if (args.Length != fnIndex + 1)
{
saveFn = args[fnIndex + 1];
}
if (!File.Exists(orgfile))
{
DEF.PF("新規テキストなので、.orgファイルを作成します");
File.Copy(srcFile, orgfile);//.orgファイルの作成
}
File.Copy(srcFile, bupfile, true);//.bupファイルの作成
//M98で処理実施
M98 m98 = new M98(null);
m98.seed = seed;
using (FileStream sourceMML = new FileStream(srcFile, FileMode.Open, FileAccess.Read, FileShare.Read))
using (FileStream destMML = new FileStream(saveFn, FileMode.Create, FileAccess.Write))
{
m98.Preprocess(sourceMML, destMML, null);
}
}
catch (M98Exception)
{
Environment.Exit(-1);
}
DEF.PF("Complete.");
Environment.Exit(0);
}
public void LoadBundle()
{
#if UNITY_EDITOR
SOUND.I.LoadLocalDirectoryAudioClipsPackage("Lobby/", "Sounds", (x) => {
if (!SOUND.I.IsPlay(DEF.SND.lobby_bgm))
{
SOUND.I.Play(DEF.SND.lobby_bgm, true);
}
});
#else
SOUND.I.LoadAssetBundleAudioClipsPackage(DEF.GetLobbyBundleName());
if (!SOUND.I.IsPlay(DEF.SND.lobby_bgm))
{
SOUND.I.Play(DEF.SND.lobby_bgm, true);
}
#endif
// 고정적인 빌드에 포함되는 리소스
Popup = CreateUIPrefab <PopupUI>(thisTrans, "Popup_UI");
Popup.GetComponent <UnityEngine.UI.CanvasScaler>().matchWidthOrHeight = Main.I.GetMatchWidthOrHeight();
Popup.Initialize();
// 가변적으로 필요시 번들및 빌드에서 처리할 리소스들
UIGameLoadingPage = CreateUIPrefab <GameLoadingPage>(thisTrans, "GameLoadingPage");
UIGameLoadingPage.GetComponent <UnityEngine.UI.CanvasScaler>().matchWidthOrHeight = Main.I.GetMatchWidthOrHeight();
Gift = CreateUIPrefab <UIPopGift>(thisTrans, "Gift");
Gift.GetComponent <UnityEngine.UI.CanvasScaler>().matchWidthOrHeight = Main.I.GetMatchWidthOrHeight();
Gift.gameObject.SetActive(false);
Tournaments = CreateUIPrefab <TournamentsUI>(thisTrans, "Tournaments_UI");
Tournaments.GetComponent <UnityEngine.UI.CanvasScaler>().matchWidthOrHeight = Main.I.GetMatchWidthOrHeight();
Tournaments.gameObject.SetActive(false);
BroadCast = CreateUIPrefab <BroadCastUI>(thisTrans, "BroadCast_UI");
BroadCast.GetComponent <UnityEngine.UI.CanvasScaler>().matchWidthOrHeight = Main.I.GetMatchWidthOrHeight();
BroadCast.gameObject.SetActive(true);
Coins = CreateUIPrefab <CoinsUI>(thisTrans, "Coins_UI");
Coins.GetComponent <UnityEngine.UI.CanvasScaler>().matchWidthOrHeight = Main.I.GetMatchWidthOrHeight();
Coins.gameObject.SetActive(true);
Coins.Initialize();
Game = CreateUIPrefab <GameUI>(thisTrans, "Game_UI");
Game.GetComponent <UnityEngine.UI.CanvasScaler>().matchWidthOrHeight = Main.I.GetMatchWidthOrHeight();
GuestGuide = CreateUIPrefab <UIPopGuestGuide>(thisTrans, "GuestGuide");
GuestGuide.GetComponent <UnityEngine.UI.CanvasScaler>().matchWidthOrHeight = Main.I.GetMatchWidthOrHeight();
PayTable = CreateUIPrefab <PayTableUI>(thisTrans, "PayTable_UI");
PayTable.GetComponent <UnityEngine.UI.CanvasScaler>().matchWidthOrHeight = Main.I.GetMatchWidthOrHeight();
if (eTutorial.on == CONFIG.CurrentTutorial)
{
Tutorial = CreateUIPrefab <UITutorial>(thisTrans, "Tutorial_UI");
}
}
public void DEFConstructorTest()
{
string filePath = string.Empty; // TODO: Initialize to an appropriate value
DEF target = new DEF(@"C:\Work\rootR9\TCDEF\TCDEF_a.1_Main\2396\ffarazre - Copy (2).def");
SearchFieldCollection <SearchField> sf = new SearchFieldCollection <SearchField>(target.getOrigSearchFields());
sf.deleteField("City");
target.SaveDefChanges(sf.exportSearchFields(), sf.exportDelSearchFields());
//target.SaveDefFile();
}
void Start()
{
DEF.Init();
instance = this;
//NGUITools.SetActive(PanelOverGame,false);
ScoreControl.Score = 0;
DEF.ScaleAnchorGui();
restart();
setCountTextEffect();
SoundEngine.getInstance().PlayLoop(SoundEngine.getInstance()._soundBG2);
}
public void UpdateStats()
{
Vector2 ViewportPosition = Camera.main.WorldToViewportPoint(transform.position);
stats.transform.FindChild("HP").GetComponent <Text>().text = HP.ToString();
stats.transform.FindChild("ATT").GetComponent <Text>().text = ATT.ToString();
stats.transform.FindChild("DEF").GetComponent <Text>().text = DEF.ToString();
Vector2 WorldObject_ScreenPosition = new Vector2(
((ViewportPosition.x * canvasRect.sizeDelta.x) - (canvasRect.sizeDelta.x * 0.5f)),
((ViewportPosition.y * canvasRect.sizeDelta.y) - (canvasRect.sizeDelta.y * 0.5f)));
stats.anchoredPosition = WorldObject_ScreenPosition;
}
public void UpdateListItem()
{
ClearAllListItem();
// 게임 가능한 리스트 선별
for (int i = 0; i < USER.I._PKGamesInfo.data.Length; i++)
{
if (DEF.IsUseGameID((eGameList)USER.I._PKGamesInfo.data[i].game_id))
{
//Debug.Log("GameList Info = " + USER.I._PKGamesInfo.data[i].game_id.ToString() + " , status : " + USER.I._PKGamesInfo.data[i].status);
_GameList.Add(USER.I._PKGamesInfo.data[i]);
}
}
int count = _GameList.Count;
for (int i = 0; i < count; i += 3)
{
if (i < count)
{
STGameItem item = new STGameItem();
if (i < count)
{
item.list.Add(_GameList[i]);
}
if (i + 1 < count)
{
item.list.Add(_GameList[i + 1]);
}
if (i + 2 < count)
{
item.list.Add(_GameList[i + 2]);
}
m_ItemList.Add(item);
}
}
/*
#if UNITY_EDITOR
* for(int i=0; i<m_ItemList.Count; i++)
* for (int k = 0; k < m_ItemList[i].list.Count; k++)
* Debug.Log(i + " > m_ItemList Info = " + m_ItemList[i].list[k].game_id);
*
#endif
*/
CurrentItemMaxCount = m_ItemList.Count;
Reset();
_GamePage.Init(m_ItemList.Count);
}
private void LoadGameBundle()
{
SetState(eState.BeginDownloads);
imgLoadBar.fillAmount = 0;
_playTime = 30f;
_time = Time.time;
_tempfill = imgLoadBar.fillAmount;
StartCoroutine(coUpdateLoadBar());
string bundleName = DEF.GetGameBundleName((eGameList)_id);
StartCoroutine(xLIB.BUNDLE.I.DownloadUpdateFromServer(bundleName, null, OnLoadComplete, OnLoadError));
}
void Start()
{
DEF.Init();
DEF.ScaleAnchorGui();
ScoreControl.loadGame();
instance = this;
LabelCoin.text = ScoreControl.Coin.ToString();
LabelScore.text = ScoreControl.Score.ToString();
ShopManager.instance = GameShop.GetComponent <ShopManager>();
SoundEngine.getInstance().PlayLoop(SoundEngine.getInstance()._soundBG1);
//Application.targetFrameRate = 60;
// GamePlay.ShowADS();
// GamePlay.firstShowAds = false;
}
protected override void OnEnable()
{
base.OnEnable();
if (m_args == null)
{
return;
}
_imgFadeInOut.color = Color.black;
_imgFadeInOut.gameObject.SetActive(true);
_ProgressBar.gameObject.SetActive(true);
_ProgressBar.Reset();
if ((SCENEIDs)m_args[0] == SCENEIDs.LobbyToGame)
{
_ProgressBar.SetFillAmount(0.03f);
_ProgressBar.AutoAddGague(10f, null);
PK.GamesInfo.REData info = USER.I.GetGameListInfo((int)m_args[1]);
_GameKind = (eGameList)m_args[1];
_bundleName = DEF.GetGameBundleName(_GameKind);
// gamecommon 번들에 넣어둔 이미지 로딩
Sprite spr = DEF.GetGameLoadingImage(_GameKind);
if (spr != null)
{
_imgTitle.texture = spr.texture;
_imgFadeInOut.DOFade(0, 0.3f).OnComplete(OnFadeComplete);
}
else // 혹시나 로딩 실패하면 기존 웹다운방식
{
DB.I.WebDownloadImage(info.loading_image, (x) =>
{
_imgTitle.texture = x;
_imgFadeInOut.DOFade(0, 0.3f).OnComplete(OnFadeComplete);
});
}
}
else
{
Close("cancel");
}
}
void OnEnable()
{
if (_Info != null)
{
if (DEF.IsUseGameID((eGameList)_id))
{
if (_Info.status == "active")
{
// 게임 번들 존재 여부 확인
_bundleName = DEF.GetGameBundleName((eGameList)_id);
AssetBundle bundle = xLIB.BUNDLE.I.GetBundle(_bundleName);
if (bundle != null)
{
SetState(eState.Play);
}
else if (xLIB.BUNDLE.I.IsLocalFileCached(_bundleName))
{
SetState(eState.Play);
}
else
{
SetState(eState.Download);
}
// 잭팟 액션 시작
UpdateJackpotPool();
}
else if (_Info.status == "coming_soon")
{
SetState(eState.ComingSoon);
}
else if (_Info.status == "maintenance")
{
}
}
else
{
_url = "";
_bundleName = "";
InitState();
}
}
}
// View Diagnosis and treatment plans data
private void ViewDiagnosisAndTreatmentPlans()
{
DMF_Value.Text = DMF.ToString();
DMF_D.Text = D.ToString();
DMF_M.Text = M.ToString();
DMF_F.Text = F.ToString();
_dmf_value.Text = dmf.ToString();
_dmf_d.Text = d.ToString();
_dmf_m.Text = m.ToString();
_dmf_f.Text = f.ToString();
DEF_Value.Text = DEF.ToString();
DEF_D.Text = _D.ToString();
DEF_E.Text = E.ToString();
DEF_F.Text = _F.ToString();
foreach (List <String> row in DiagnosisAndTPs_table)
{
DATP_dataGridView.Rows.Add(row.ToArray());
}
}
void Start()
{
DEF.Init();
DEF.ScaleAnchorGui();
instance = this;
// currentpage = ScoreControl.mUnblockLevel / 20 + 1;
// if (currentpage > 34) currentpage = 34;
for (int i = 0; i < 24; i++)
{
GameObject g = Instantiate(button5) as GameObject;
g.SetActive(true);
g.transform.parent = scrollView.transform;
g.transform.localScale = Vector3.one;
g.transform.localPosition = new Vector3(0, y0 + i * dy, 0);
SelectLevels s = g.GetComponent <SelectLevels>();
s.Init(i * 5);
}
LabelCoin.text = ScoreControl.Coin.ToString();
LabelScore.text = ScoreControl.Score.ToString();
ShopManager.instance = GameShop.GetComponent <ShopManager>();
}
void Start()
{
DEF.Init();
PanelBoard = GameObject.Find("PanelBoard");
PanelInputName = GameObject.Find("PanelInputName");
if (ScoreControl.UserName.Length >= 5)
{
PostHightScore();
getHightScore();
loadRanking = true;
NGUITools.SetActive(PanelInputName, false);
}
else
{
loadRanking = false;
NGUITools.SetActive(PanelBoard, false);
}
DEF.ScaleAnchorGui();
instance = this;
}
//-------------------------------------------------
#region Virtual Methods Region
public virtual StrongString GetForServer()
{
StrongString myString =
CustomName + InCharSeparator + // index : 0
HeroID + InCharSeparator + // index : 1
Level.ToString() + InCharSeparator + // index : 2
Power.GetForServer() + InCharSeparator + // index : 3
SkillPoint.GetForServer() + InCharSeparator + // index : 4
Stars.ToString() + InCharSeparator + // index : 5
HeroSkill.GetForServer() + InCharSeparator + // index : 6
HP.GetForServer() + InCharSeparator + // index : 7
ATK.GetForServer() + InCharSeparator + // index : 8
INT.GetForServer() + InCharSeparator + // index : 9
DEF.GetForServer() + InCharSeparator + // index : 10
RES.GetForServer() + InCharSeparator + // index : 11
SPD.GetForServer() + InCharSeparator + // index : 12
PEN.GetForServer() + InCharSeparator + // index : 13
Block.GetForServer() + InCharSeparator + // index : 14
HeroCurrentExp.GetForServer() + InCharSeparator; // index : 15
return(myString);
}
/// <summary>
/// 게임화면에서 로비화면으로 전환
/// </summary>
public void GameToLobby()
{
if (!SOUND.I.IsPlay(DEF.SND.lobby_bgm))
{
SOUND.I.Play(DEF.SND.lobby_bgm, true);
}
Main.I.CurrentView = eView.Lobby;
if (GameMain != null)
{
SOUND.I.RemoveClipPackage(DEF.GetGameBundleName(loadGame));
BUNDLE.I.UnLoadBundle(DEF.GetGameBundleName(loadGame), true);
Destroy(GameMain.gameObject);
GameMain = null;
loadGame = eGameList.none;
}
if (Lobby.I != null)
{
Lobby.I.GameToLobby();
}
Coins.GameToLobby();
Game.GameToLobby();
Tournaments.GameToLobby();
BroadCast.GameToLobby();
Resources.UnloadUnusedAssets();
System.GC.Collect();
NET.I.SendReqLobbyUserInfo((id, msg) =>
{
USER.I.SetPKUserInfo(msg);
USER.I.UpdateAllUserInfo();
Main.I.AppsFlyerEvent(AFInAppEvents.GAME, AFInAppEvents.GAME_EXIT, "true");
}, null);
}
// 게임을 직접 실행한다.
public void RunNewsGame(eGameList gameId)
{
UI.SetWaitLoading(true);
if (DEF.IsUseGameID(gameId))
{
runGameId = (int)gameId;
string bundleName = DEF.GetGameBundleName(gameId);
AssetBundle bundle = xLIB.BUNDLE.I.GetBundle(bundleName);
if (bundle != null)
{
SCENE.I.AddMessage(SCENEIDs.LobbyToGame, "game", runGameId);
}
else if (xLIB.BUNDLE.I.IsLocalFileCached(bundleName))
{
SCENE.I.AddMessage(SCENEIDs.LobbyToGame, "game", runGameId);
}
else
{
StartCoroutine(xLIB.BUNDLE.I.DownloadUpdateFromServer(bundleName, null, () => {
SCENE.I.AddMessage(SCENEIDs.LobbyToGame, "game", runGameId);
}));
}
}
}
private static void title()
{
DEF.PF("M98 ver1.02");
DEF.PF("1993/11/13 Programed By Yuzo Koshiro");
}
public Container(String name, ABC abc, DEF def)
{
Name = name;
Abc = abc;
Def = def;
}
public string getInfo()
{
string stats;
stats = Name + "\nHealth: " + HLT.ToString() + "\nAttack: " + ATK.ToString() + "\nDefense: " + DEF.ToString()
+ "\nSpeed: " + SPD.ToString() + "\nEvasiveness: " + EVA.ToString() + "\nCurrent Item: " + CurrentlyHolding + "\n\n";
return(stats);
}
// Methods start here
public string getInfo()
{
string stats;
stats = Name + "\nHealth: " + HLT.ToString() + "\nAttack: " + ATK.ToString() + "\nDefense: " + DEF.ToString()
+ "\nSpeed: " + SPD.ToString() + "\nEvasiveness: " + EVA.ToString() + "\nFaction: " + Faction + "\n\n";
return(stats);
}
private void buttonParserPerson_Click(object sender, EventArgs e)
{
if (DateTime.Now > new DateTime(2017, 06, 01))
{
return;
}
try
{
if (this.folderBrowserDialog1.ShowDialog() != DialogResult.OK)
{
return;
}
string[] files = Directory.GetFiles(this.folderBrowserDialog1.SelectedPath);
Log("Начало обработки");
this.UseWaitCursor = true;
foreach (var file in files)
{
try
{
Log("Выбран файл: " + Path.GetFileName(file));
if (Path.GetExtension(file) != ".xlsx")
{
Log("Формат файла не поддерживается: " + Path.GetExtension(file));
continue;
}
Log("Начало обработки");
this.UseWaitCursor = true;
Log("Выбран файл: " + Path.GetFileName(file));
FileInfo newFile = new FileInfo(file);
ExcelPackage _pck = new ExcelPackage(newFile);
#region foreach
foreach (var worksheet in _pck.Workbook.Worksheets)
{
int ColumnName = -1;
int ColumnSex = -1;
int ColumnEmail = -1;
int ColumnTelephone = -1;
int ColumnBrithday = -1;
Log("Обрабатываем страницу: " + worksheet.Name);
if (worksheet.Dimension == null)
{
Log("Страница пуста - пропускаем");
continue;
}
#region for_rowCnt
var rowCnt = worksheet.Dimension.End.Row;
var colCnt = worksheet.Dimension.End.Column;
for (int i = 1; i <= colCnt; i++)
{
if (worksheet.Cells[1, i] == null)
{
continue;
}
if (worksheet.Cells[1, i].Value == null)
{
continue;
}
switch (worksheet.Cells[1, i].Value.ToString().Trim())
{
case "Имя":
ColumnName = i;
break;
case "Пол":
ColumnSex = i;
break;
case "Email":
ColumnEmail = i;
break;
case "Телефон":
ColumnTelephone = i;
break;
case "Дата рождения":
ColumnBrithday = i;
break;
}
}
#endregion
string Notify = "";
if (ColumnName < 0)
{
Notify += "\nИмя";
}
if (ColumnSex < 0)
{
Notify += "\nПол";
}
if (ColumnEmail < 0)
{
Notify += "\nEmail";
}
if (ColumnTelephone < 0)
{
Notify += "\nТелефон";
}
if (ColumnBrithday < 0)
{
Notify += "\nДата рождения";
}
if (Notify.Length > 0)
{
Notify = "Отсутствуют поля: " + Notify;
Log(Notify);
break;
}
string DirName = "ParserPerson";
if (!Directory.Exists(DirName))
{
Directory.CreateDirectory(DirName);
}
string FileName = DateTime.Now.ToString("yyyy-MM-dd-HH-mm");
FileName = Directory.GetCurrentDirectory() + @"\" + DirName + @"\" + FileName + ".xlsx";
var existingFile = new FileInfo(FileName);
#region using
using (var package = new ExcelPackage(existingFile))
{
var workbook = package.Workbook;
var worksheet1 = workbook.Worksheets.Add(worksheet.Name);
List <ParserPerson> theList = new List <ParserPerson>();
#region for
for (int i = 1; i <= rowCnt; i++)
{
ParserPerson data = new ParserPerson();
data.Telephone = GetValueFromCell(worksheet.Cells[i, ColumnTelephone]);
data.Name = GetValueFromCell(worksheet.Cells[i, ColumnName]);
data.Email = GetValueFromCell(worksheet.Cells[i, ColumnEmail]);
data.Sex = GetValueFromCell(worksheet.Cells[i, ColumnSex]);
data.Brithday = GetValueFromCell(worksheet.Cells[i, ColumnBrithday]);
data.Telephone = IndexMobileCore.Helper.Telephone.Normalize(data.Telephone);
if (data.Telephone.Length < 10)
{
continue;
}
string _Code = data.Telephone.Substring(0, 3);
string _Number = data.Telephone.Substring(3, 7);
Log("_Code - " + _Code);
Log("_Number - " + _Number);
int Code = 0;
int Number = 0;
try
{
Code = Convert.ToInt32(_Code);
Number = Convert.ToInt32(_Number);
}
catch
{
Log("Ошибка при определении Code и Number");
continue;
}
Log("Вызываем: IndexMobileCore.Helper.Telephone.Operator(" + Code.ToString() + ", " + Number.ToString() + ")");
var theDEF = DEF.GetOperator(Code, Number);
if (theDEF != null)
{
Log("Получено значение: tel_operator = " + theDEF.Operator + " - " + theDEF.Region);
data.Operator = theDEF.Operator;
data.Region = theDEF.Region;
}
else
{
Log("Значение отсутствует");
}
if (theList.Count(x => x.Email == data.Email) > 0)
{
continue;
}
theList.Add(data);
}
#endregion
for (int i = 1; i <= theList.Count; i++)
{
var data = theList[i - 1];
worksheet1.Cells[i, 1].Value = data.Telephone;
worksheet1.Cells[i, 2].Value = data.Operator;
worksheet1.Cells[i, 3].Value = data.Region;
worksheet1.Cells[i, 4].Value = data.Name;
worksheet1.Cells[i, 5].Value = data.Email;
worksheet1.Cells[i, 6].Value = data.Sex;
worksheet1.Cells[i, 7].Value = data.Brithday;
}
package.Save();
Log("Сохранено: " + FileName);
}
#endregion
break;
}
#endregion
}
catch (Exception ex)
{
Log("Ошибка при обработке файла: " + file + " " + ex.Message);
}
}
Log("Завершено!");
}
catch (Exception ex)
{
string err = ex.Message;
err += ex.StackTrace;
Log(err);
}
finally
{
this.UseWaitCursor = false;
}
}
private void ExecuteInForeground(Object obj)
{
FormMain theForm = (FormMain)obj;
try
{
List <Nameface> theListNameface = Nameface.GetAll();
foreach (var worksheet in theForm.pck.Workbook.Worksheets)
{
Log(theForm, "Обрабатываем страницу: " + worksheet.Name);
if (worksheet.Dimension == null)
{
Log(theForm, "Страница пуста - пропускаем");
continue;
}
worksheet.InsertColumn(2, 3);
var rowCnt = worksheet.Dimension.End.Row;
Log(theForm, "Кол-во строк в странице: " + rowCnt.ToString());
for (int i = 2; i <= rowCnt; i++)
{
Application.DoEvents();
if (theForm.isStop == true)
{
Log(theForm, "Принудительное завершение");
theForm.pck.Save();
return;
}
if (worksheet.Cells[i, 1].Value == null)
{
Log(theForm, "Значение в " + i.ToString() + " строке - отсутствует - пропускаем ");
continue;
}
string NameInCell = "";
if (worksheet.Cells[i, 5].Value != null)
{
NameInCell = worksheet.Cells[i, 5].Value.ToString();
}
string tel = IndexMobileCore.Helper.Telephone.Normalize(worksheet.Cells[i, 1].Value.ToString());
if (tel.Length < 10)
{
Log(theForm, "Значение в " + i.ToString() + " строке - меньше 10 по длине - пропускаем ");
continue;
}
string _Code = tel.Substring(0, 3);
string _Number = tel.Substring(3, 7);
Log(theForm, "_Code - " + _Code);
Log(theForm, "_Number - " + _Number);
int Code = 0; Convert.ToInt32(_Code);
int Number = 0; Convert.ToInt32(_Number);
try
{
Code = Convert.ToInt32(_Code);
Number = Convert.ToInt32(_Number);
}
catch
{
Log(theForm, "Ошибка при определении Code и Number");
}
Log(theForm, "Вызываем: IndexMobileCore.Helper.Telephone.Operator(" + Code.ToString() + ", " + Number.ToString() + ")");
//string tel_operator = IndexMobileCore.Helper.Telephone.Operator(Code, Number);
var theDEF = DEF.GetOperator(Code, Number);
if (theDEF != null)
{
Log(theForm, "Получено значение: tel_operator = " + theDEF.Operator + " - " + theDEF.Region);
worksheet.Cells[i, 2].Value = theDEF.Operator;
worksheet.Cells[i, 3].Value = theDEF.Region;
}
else
{
Log(theForm, "Значение отсутствует");
}
string theName = "";
foreach (var item in NameInCell.Split(new char[] { ' ', '(' }, StringSplitOptions.RemoveEmptyEntries))
{
if (item.Length == 1)
{
continue;
}
var list = theListNameface.Where(x => x.NameOff.ToLower() == item.ToLower());
if (list.Count() > 0)
{
theName = list.ToList <Nameface>()[0].NameOn;
break;
}
else
{
var check = theListNameface.Where(x => x.NameOn.ToLower() == item.ToLower());
if (check.Count() > 0)
{
theName = check.ToList <Nameface>()[0].NameOn;
break;
}
}
}
worksheet.Cells[i, 4].Value = theName;
Log(theForm, "Завершено!");
}
}
}
catch (Exception ex)
{
string err = ex.Message;
err += ex.StackTrace;
Log(theForm, err);
}
finally
{
Log(theForm, "Выход");
theForm.pck.Save();
th.Abort();
th = null;
theForm.button1.Enabled = true;
theForm.button3.Enabled = false;
theForm.button3_Click(null, null);
theForm.Update();
this.button1.Enabled = true;
this.button3.Enabled = false;
}
}
public string GetData()
{
if (this == null)
{
return("");
}
string result = "";
result += this.Name;
if (this.IsMonster())
{
result += Environment.NewLine;
result += this.IsFrame(FRAME.Xyz)
? string.Format("Rank {0}", (double.IsNaN(Rank) ? "?" : Rank.ToString()))
: string.Format("Level {0}", (double.IsNaN(Level) ? "?" : Level.ToString()));
result += " " + this.Attribute.ToString();
if (Type != TYPE.NONE)
{
result += " " + string.Format("{0}-Type", this.Type.GetString());
}
if (this.IsPendulum)
{
result += " Pendulum";
}
result += " " + this.Frame;
if (this.Abilities.Count > 0)
{
result += " " + string.Join(" ", this.Abilities);
}
result += " Monster";
result += Environment.NewLine;
result += string.Format("ATK {0}\nDEF {1}",
(double.IsNaN(ATK) ? "?" : ATK.ToString()),
(double.IsNaN(DEF) ? "?" : DEF.ToString()));
if (this.IsPendulum)
{
result += "\nPendulum Scale ";
if (ScaleLeft.Equals(ScaleRight))
{
result += (double.IsNaN(ScaleLeft) ? "?" : ScaleLeft.ToString());
}
else
{
result += (double.IsNaN(ScaleLeft) ? "?" : ScaleLeft.ToString());
result += "/";
result += (double.IsNaN(ScaleRight) ? "?" : ScaleRight.ToString());
}
}
result += Environment.NewLine;
if (this.IsPendulum)
{
result += "Pendulum Effect:\n";
result += this.PendulumEffect.CleanUpUnnecessarySpace();
result += Environment.NewLine;
if (this.IsFrame(FRAME.Normal))
{
result += "Lore:";
result += Environment.NewLine;
}
else
{
result += "Monster Effect:";
result += Environment.NewLine;
}
}
}
else
{
result += Environment.NewLine;
if (Property != PROPERTY.NONE && Property != PROPERTY.Normal)
{
result += Property.GetString() + " ";
}
result += Frame.ToString() + " Card";
result += Environment.NewLine;
}
result += this.Description.CleanUpUnnecessarySpace();
return(result);
}
void Start()
{
string gameName = DEF.GetGamePrefabName(InGame.I.gameId);
_path = xLIB.xSystem.GetPlatformPath() + "/Assets/GameWorks/" + gameName + "/TestNetFiles/";
}
void ParserCommand(Hashtable has)
{
SCENEIDs _IDs = (SCENEIDs)has["id"].GetHashCode();
#if UNITY_EDITOR
Debug.Log(Time.frameCount + " <Color=#fff000> SCENE::ParserCommand - " + _IDs.ToString() + " </Color>");
#endif
switch (_IDs)
{
case SCENEIDs.Company:
Main.I.ShowCompany(true);
Main.I._logo.color = Color.white;
Main.I._logo.DOFade(0, 1f).SetDelay(2f).OnComplete(() => {
remove(SCENEIDs.Company);
});
return;
case SCENEIDs.MsgBoxNetReConnect:
MsgBoxNetworkReConnect();
break;
case SCENEIDs.NetReConnect:
NetworkReConnect();
break;
case SCENEIDs.FirstLoginToLobby:
Main.I.ShowCompany(false);
UI.ShowLoginLoadingPage((id, args) =>
{
remove(SCENEIDs.FirstLoginToLobby);
}, SCENEIDs.FirstLoginToLobby, has["name"].ToString());
return;
case SCENEIDs.FirstActiveLobby:
//UI.I.FirstActiveLobby();
break;
case SCENEIDs.FBSignOut:
{
SOUND.I.PlayStop(DEF.SND.lobby_bgm);
USER.I.ResetReConnect();
UI.SetWaitLoading(false);
UI.ShowLoginLoadingPage((id, args) =>
{
remove(SCENEIDs.FBSignOut);
}, SCENEIDs.FBSignOut);
}
return;
case SCENEIDs.FacebookShare:
break;
case SCENEIDs.InitLobby:
UI.I.FirstActiveLobby();
break;
case SCENEIDs.InviteFriends:
Main.I.GetFBController().InviteFriends();
break;
case SCENEIDs.ReConnectServer:
UI.SetWaitLoading(false);
USER.I.ResetReConnect();
UI.ShowLoginLoadingPage((id, args) =>
{
remove(SCENEIDs.ReConnectServer);
}, SCENEIDs.ReConnectServer);
return;
case SCENEIDs.GuestToFacebook:
{
if (USER.I.IsGuestLogin)
{
UI.I.ShowGuestGuide((_id, args) =>
{
if (args[0].ToString() == "ok")
{
AddMessage(SCENEIDs.LoginGuestToFacebook);
remove(SCENEIDs.GuestToFacebook);
}
else // cancel
{
remove(SCENEIDs.GuestToFacebook);
}
});
}
else
{
remove(SCENEIDs.GuestToFacebook);
}
}
return;
case SCENEIDs.LoginGuestToFacebook:
{
UI.SetWaitLoading(true);
Main.FB.FBLogin((x) =>
{
if (x == true)
{
SOUND.I.PlayStop(DEF.SND.lobby_bgm);
long guestId = System.Convert.ToInt64(PlayerPrefHelper.GetUserID());
long fbid = System.Convert.ToInt64(Main.FB.GetFbLoginInfo().id);
NET.I.SendReqGuestToFacebook((id, msg) =>
{
// reset data
USER.I.ResetReConnect();
I.AddMessage(SCENEIDs.ReLoginFacebook);
}, NET.I.OnSendReqTimerout, guestId, fbid);
}
else
{
UI.SetWaitLoading(false);
}
});
}
break;
case SCENEIDs.ReLoginFacebook:
UI.SetWaitLoading(false);
UI.ShowLoginLoadingPage((id, args) =>
{
remove(SCENEIDs.ReLoginFacebook);
}, SCENEIDs.ReLoginFacebook);
return;
case SCENEIDs.GuestToFBActiveLobby:
UI.I.GuestToFBActiveLobby();
break;
case SCENEIDs.LobbyToGame:
int gameID = System.Convert.ToInt32(has["game"].ToString());
if (DEF.IsUseGameID((eGameList)gameID))
{
if (Lobby.I != null)
{
Lobby.I.gameObject.SetActive(false);
}
UI.ShowGameLoadingPage((id, args) =>
{
if (args[0].ToString() == "ok")
{
//UI.I.LobbyToGame((eGameList)args[1]);
remove(SCENEIDs.LobbyToGame);
}
}, SCENEIDs.LobbyToGame, gameID);
return;
}
break;
case SCENEIDs.GameToLobby:
UI.I.GameToLobby();
break;
case SCENEIDs.Quit:
UI.I.ShowMsgBox("Are you sure you want to quit the game?", (id, args) => {
if (args[0].ToString() == "ok")
{
Main.I.OnQuit();
}
});
break;
case SCENEIDs.DEBUG_LOADING_COMPLETED:
{
UI.GameMain = GameObject.FindObjectOfType <InGame>();
if (UI.GameMain.gameId == DEF.FIRST_INSTALL_GAME)
{
BUNDLE.I.UnLoadBundle(DEF.GetGameBundleName(DEF.FIRST_INSTALL_GAME)); // 로비에서 다운받기 때문에 삭제
}
UI.I.LobbyToGame(UI.GameMain.gameId);
UI.GameMain.Init();
}
break;
// first news popups
case SCENEIDs.NewsDailySpin:
UI.Popup.ShowPopup <UIPopDailySpin>("DailySpin", (int)_IDs, (id, args) => {
if (args[0].ToString() == "x")
{
base.removeAt(SCENEIDs.NewsGoldenSpin); // 취소면 NewsGoldenSpin 메세지 강제 제거
}
remove(SCENEIDs.NewsDailySpin);
}, true);
return;
case SCENEIDs.NewsGoldenSpin:
UI.Popup.ShowPopup <UIPopDailySpinShop>("DailySpinShop", (int)_IDs, (id, args) => {
remove(SCENEIDs.NewsGoldenSpin);
}, null);
return;
case SCENEIDs.NewsFirstPurchase:
UI.Popup.ShowPopup <UIPopFirstPurchaseOffer>("FirstPurchaseOffer", (int)_IDs, (id, args) => {
remove(SCENEIDs.NewsFirstPurchase);
}, true);
return;
case SCENEIDs.NewsSweetOffer:
UI.Popup.ShowPopup <UIPopSweetOffer>("SweetOffer", (int)_IDs, (id, args) => {
if (args[0].ToString() == "buy")
{
UI.Popup.ShowPopup <UIPopPurchaseSuccessful>("PurchaseSuccessful", 0, (id2, args2) => {
remove(SCENEIDs.NewsSweetOffer);
}, args[1]);
}
else
{
remove(SCENEIDs.NewsSweetOffer);
}
}, true);
return;
case SCENEIDs.NewsNormal:
UI.Popup.ShowPopup <UIPopNewsNormal>("NewsNormal", (int)_IDs, (id, args) => {
remove(SCENEIDs.NewsNormal);
}, has["url"], has["value"]);
return;
case SCENEIDs.NewsGame:
UI.Popup.ShowPopup <UIPopNewsGame>("NewsGame", (int)_IDs, (id, args) => {
remove(SCENEIDs.NewsGame);
if (args[0].ToString() == "ok")
{
AddMessage(SCENEIDs.NewsGameRun, "gameid", args[1]);
}
else
{
AddMessage(SCENEIDs.NewsInbox);
}
}, has["url"], has["value"]);
return;
case SCENEIDs.NewsGameRun:
Lobby.I.RunNewsGame((eGameList)HasToInt("gameid"));
break;
case SCENEIDs.NewsInbox:
//UI.Popup.ShowPopup<UIPopGift>("Gift", (int)_IDs, null, "InBox");
UI.I.AddMessage(UI.IDs.PopGift, "tab", "InBox");
break;
}
I.remove(_IDs);
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (this.openFileDialog1.ShowDialog() != DialogResult.OK)
{
return;
}
this.button1.Enabled = false;
this.button3.Enabled = true;
this.isStop = false;
Log("Начало обработки");
ulong ProcentTotal = 0;
ulong ProcentCurr = 0;
Dictionary <string, int> theTipor = new Dictionary <string, int>();
foreach (var pathSelect in this.openFileDialog1.FileNames)
{
FileInfo newFile = new FileInfo(pathSelect);
pck = new ExcelPackage(newFile);
try
{
foreach (var worksheet in this.pck.Workbook.Worksheets)
{
if (worksheet.Dimension == null)
{
continue;
}
var rowCnt = (ulong)worksheet.Dimension.End.Row;
ProcentTotal += rowCnt;
}
}
catch
{
}
}
foreach (var pathSelect in this.openFileDialog1.FileNames)
{
Log("Выбран файл: " + Path.GetFileName(this.openFileDialog1.FileName));
FileInfo newFile = new FileInfo(pathSelect);
pck = new ExcelPackage(newFile);
try
{
List <Nameface> theListNameface = Nameface.GetAll();
foreach (var worksheet in this.pck.Workbook.Worksheets)
{
Log("Обрабатываем страницу: " + worksheet.Name);
if (worksheet.Dimension == null)
{
Log("Страница пуста - пропускаем");
continue;
}
worksheet.InsertColumn(2, 4);
var rowCnt = worksheet.Dimension.End.Row;
Log("Кол-во строк в странице: " + rowCnt.ToString());
for (int i = 2; i <= rowCnt; i++)
{
ProcentCurr++;
this.labelProcent.Text = ((decimal)ProcentCurr / (decimal)ProcentTotal * 100).ToString("0");
Application.DoEvents();
if (this.isStop == true)
{
Log("Принудительное завершение");
this.pck.Save();
return;
}
if (worksheet.Cells[i, 1].Value == null)
{
Log("Значение в " + i.ToString() + " строке - отсутствует - пропускаем ");
continue;
}
string NameInCell = "";
if (worksheet.Cells[i, 6].Value != null)
{
NameInCell = worksheet.Cells[i, 6].Value.ToString();
}
string tel = IndexMobileCore.Helper.Telephone.Normalize(worksheet.Cells[i, 1].Value.ToString());
if (tel.Length < 10)
{
Log("Значение в " + i.ToString() + " строке - меньше 10 по длине - пропускаем ");
worksheet.DeleteRow(i); i--; rowCnt--;
continue;
}
if (tel[0] != '9')
{
Log("Не пройдена проверка: не имеют сотового номера (89..,+79..,79) ");
worksheet.DeleteRow(i); i--; rowCnt--;
continue;
}
string _Code = tel.Substring(0, 3);
string _Number = tel.Substring(3, 7);
Log("_Code - " + _Code);
Log("_Number - " + _Number);
int Code = 0; Convert.ToInt32(_Code);
int Number = 0; Convert.ToInt32(_Number);
try
{
Code = Convert.ToInt32(_Code);
Number = Convert.ToInt32(_Number);
}
catch
{
Log("Ошибка при определении Code и Number");
}
Log("Вызываем: IndexMobileCore.Helper.Telephone.Operator(" + Code.ToString() + ", " + Number.ToString() + ")");
string NumberTel = String.Format("8{0}{1}", _Code, _Number);
if (theTipor.ContainsKey(NumberTel))
{
worksheet.DeleteRow(i); i--; rowCnt--;
continue;
}
else
{
theTipor.Add(NumberTel, i);
}
worksheet.Cells[i, 1].Value = NumberTel;
var theDEF = DEF.GetOperator(Code, Number);
if (theDEF != null)
{
Log("Получено значение: tel_operator = " + theDEF.Operator + " - " + theDEF.Region);
worksheet.Cells[i, 4].Value = theDEF.Operator;
worksheet.Cells[i, 5].Value = theDEF.Region;
}
else
{
Log("Значение отсутствует");
}
string theName = "";
foreach (var item in NameInCell.Split(new char[] { ' ', '(' }, StringSplitOptions.RemoveEmptyEntries))
{
if (item.Length == 1)
{
continue;
}
var list = theListNameface.Where(x => x.NameOff.ToLower() == item.ToLower() || Nameface.NameOffTranslate(item).ToLower() == x.NameOff.ToLower());
if (list.Count() > 0)
{
theName = list.ToList <Nameface>()[0].NameOn;
break;
}
else
{
var check = theListNameface.Where(x => x.NameOn.ToLower() == item.ToLower());
if (check.Count() > 0)
{
theName = check.ToList <Nameface>()[0].NameOn;
break;
}
}
}
worksheet.Cells[i, 2].Value = theName;
if (theName.Length > 0)
{
if ((IndexMobileCore.Helper.Telephone.Reverse(theName)[0] == 'а' || IndexMobileCore.Helper.Telephone.Reverse(theName)[0] == 'А' || IndexMobileCore.Helper.Telephone.Reverse(theName)[0] == 'я' || IndexMobileCore.Helper.Telephone.Reverse(theName)[0] == 'Я') && theName.ToUpper() != "ИЛЬЯ")
{
worksheet.Cells[i, 3].Value = "Ж";
}
else
{
worksheet.Cells[i, 3].Value = "M";
}
}
else
{
worksheet.Cells[i, 3].Value = "M";
}
}
worksheet.Cells[1, 1].Value = "Телефон";
worksheet.Cells[1, 2].Value = "Имя";
worksheet.Cells[1, 3].Value = "Пол";
worksheet.Cells[1, 4].Value = "Оператор";
worksheet.Cells[1, 5].Value = "Регион";
}
pck.Save();
}
catch (Exception ex)
{
string err = ex.Message;
err += ex.StackTrace;
Log(err);
}
}
this.labelProcent.Text = "100%";
Log("Завершено!");
}
catch (Exception ex)
{
string err = ex.Message;
err += ex.StackTrace;
Log(err);
}
finally
{
}
}
