public bool CreateMZHZY(string start, string end, out string msg)
{
try
{
//执行两个门诊病案存储过程
sqlClient.ExecuteSP(SqlStr.MZ_MZLGFY);
sqlClient.ExecuteSP(SqlStr.MZ_MZLGPELBLE);
log.WriteLog("查询" + start + "-" + end + "门诊和在院流感数据");
log.WriteLog(SqlStr.MzhzySql(start, end));
DataTable data = sqlClient.ExecuteQuery(SqlStr.MzhzySql(start, end), CommandType.Text);
if (data.Rows.Count < 0)
{
msg = "无门诊和在院流感数据\n";
}
else
{
CSVUtil.SaveCSV(data, fluUrl + "\\flu_门诊和在院流感" + start + "-" + end + ".csv");
CSVUtil.SaveCSV(data, backUpUrl + "\\flu_门诊和在院流感" + start + "-" + end + ".csv");
msg = "门诊和在院流感数据生成成功\n";
}
log.WriteLog("查询成功");
}
catch (Exception ex)
{
msg = ex.Message;
log.WriteLog("查询失败:" + ex.Message, LogType.Error);
return(false);
}
return(true);
}
public bool CreateSWJL(string start, string end, out string msg)
{
try
{
log.WriteLog("查询" + start + "-" + end + "死亡记录数据");
log.WriteLog(SqlStr.SwjlSql(start, end));
DataTable data = sqlClient.ExecuteQuery(SqlStr.SwjlSql(start, end), CommandType.Text);
if (data.Rows.Count < 0)
{
msg = "无死亡记录数据\n";
}
else
{
CSVUtil.SaveCSV(data, fluUrl + "\\hdr_死亡记录" + start + "-" + end + ".csv");
CSVUtil.SaveCSV(data, backUpUrl + "\\hdr_死亡记录" + start + "-" + end + ".csv");
msg = "死亡记录数据生成成功\n";
}
log.WriteLog("查询成功");
}
catch (Exception ex)
{
msg = ex.Message;
log.WriteLog("查询失败:" + ex.Message, LogType.Error);
return(false);
}
return(true);
}
public static Dictionary<int, IllustratedData> GetIllustratedDataDicionary ()
{
if (_illustratedDataDictionary == null)
{
_illustratedDataDictionary = CSVUtil.Parse<int, IllustratedData>("config/csv/atlas", "id");
// _illustratedDataDictionary = new Dictionary<int, IllustratedData>();
// LuaTable luaTable = LuaScriptMgr.Instance.GetLuaTable("gamemanager");
// object[] objs = LuaScriptMgr.Instance.CallLuaFunction("gamemanager.GetData","illustration_data");
// LuaTable datas = objs[0] as LuaTable;
// foreach(DictionaryEntry kvp in datas.ToDictTable())
// {
// LuaTable data = kvp.Value as LuaTable;
// if(data == null)
// continue;
// IllustratedData illusData = new IllustratedData();
// illusData.id = data["id"].ToString().ToInt32();
// illusData.type = data["type"].ToString().ToInt32();
// illusData.type_name = data["type_name"].ToString();
// illusData.sheet = data["sheet"].ToString().ToInt32();
// illusData.sheet_name = data["sheet_name"].ToString();
// illusData.hero_id = data["hero_id"].ToString().ToInt32();
// illusData.hero_star = data["hero_star"].ToString().ToInt32();
// _illustratedDataDictionary.Add(illusData.id,illusData);
// }
}
return _illustratedDataDictionary;
}
private void CacheTranslationData(string _serializedData)
{
string[][] deserializedData = CSVUtil.DeserializeCSV(_serializedData);
m_languageKeyToIndex = new Dictionary <string, int>();
m_localizedValues = new Dictionary <string, List <string> >();
if (deserializedData != null && deserializedData.Length > 0)
{
for (int i = 0; i < deserializedData.Length; i++)
{
if (i == 0)
{
DeserializeLanguages(deserializedData[i]);
}
else
{
DeserializeTranslations(deserializedData[i]);
}
}
}
else
{
LogHelper.LogWarning("Failed to initialize "
+ this.GetType()
+ "; "
+ nameof(dataFile)
+ " is not set",
this
);
}
}
public static InfoData GetInfoData()
{
if (_infoData == null)
{
#if UNITY_EDITOR
if (!Application.isPlaying)
{
_infoData = CSVUtil.ParseClass <InfoData>("config/info");
}
else
{
#endif
string localPath = "config/csv/info";
if (Common.ResMgr.ResUtil.ExistsInLocal(localPath + ".csv"))
{
_infoData = CSVUtil.ParseClass <InfoData>(localPath);
}
else
{
_infoData = CSVUtil.ParseClass <InfoData>("config/info");
}
#if UNITY_EDITOR
}
#endif
}
return(_infoData);
}
private string GetFeature(int wordId, params int[] fields)
{
string[] allFeatures = GetAllFeaturesArray(wordId);
if (allFeatures is null)
{
return(null);
}
StringBuilder sb = new StringBuilder();
if (fields.Length == 0)
{ // All features
foreach (string feature in allFeatures)
{
sb.Append(CSVUtil.QuoteEscape(feature)).Append(",");
}
}
else if (fields.Length == 1)
{ // One feature doesn't need to escape value
sb.Append(allFeatures[fields[0]]).Append(",");
}
else
{
foreach (int field in fields)
{
sb.Append(CSVUtil.QuoteEscape(allFeatures[field])).Append(",");
}
}
return(sb.Remove(sb.Length - 1, 1).ToString());
}
public static RandomNameData GetRandomNameData()
{
if (_randomNameDataList == null)
{
#if UNITY_EDITOR
string localPath = "config/names";
#else
string localPath = "config/csv/names";
#endif
if (Common.ResMgr.ResUtil.ExistsInLocal(localPath + ".csv"))
{
_randomNameDataList = CSVUtil.Parse <RandomNameData>(localPath);
}
else
{
_randomNameDataList = CSVUtil.Parse <RandomNameData>("config/names");
}
}
if (_randomNameDataList.Count > 0)
{
return(_randomNameDataList[0]);
}
else
{
return(null);
}
}
public static List <ModelCommon> ReadArinc429File(String filepath)
{
List <String[]> Arinc429datas = CSVUtil.ReadCsv(filepath);
List <ModelCommon> arinc429s = new List <ModelCommon>();
foreach (String[] data in Arinc429datas)
{
Arinc429 arinc429 = new Arinc429();
arinc429.DateTime_arinc429_1 = ModelUtil.ParseDateTime(data[0], data[1]);
arinc429.StaticPSSECorrected = float.Parse(data[2]);
//
String[] two = Regex.Split(data[3], "-");
arinc429.ImpactPressure = float.Parse(two[0]);
arinc429.Altitude_arinc429_1 = float.Parse(two[1]);
arinc429.BaroCorrectedAltitude = float.Parse(data[4]);
arinc429.Mach = float.Parse(data[5]);
arinc429.Airspeed = float.Parse(data[6]);
arinc429.TrueAirSpeed = float.Parse(data[7]);
arinc429.Totaltemp = float.Parse(data[8]);
arinc429.veritcalSpeed = float.Parse(data[9]);
arinc429.magheadingdeg = float.Parse(data[10]);
arinc429s.Add(arinc429);
}
return(arinc429s);
}
public static List <ModelCommon> ReadTracgasFile(String filepath)
{
List <String[]> datas = CSVUtil.ReadCsv(filepath);
List <ModelCommon> traceGass = new List <ModelCommon>();
foreach (String[] data in datas)
{
Tracegas tracegas = new Tracegas();
tracegas.DateTime_tracegas_1 = ModelUtil.ParseDateTime(data[0], data[1]);
int secondsMidNight = Convert.ToInt32(data[2]);
DateTime dateTime = ModelUtil.ProcessSecondMidNight(filepath, secondsMidNight);
tracegas.DateTime_tracegas_2 = dateTime;
tracegas.ARINCAltitudeft_tracegas_1 = float.Parse(data[3]);
tracegas.ARINCStaticPmb = float.Parse(data[3]);
tracegas.RMTStaticC = float.Parse(data[3]);
tracegas.DPC = float.Parse(data[4]);
tracegas.O3 = float.Parse(data[5]);
tracegas.NOX = float.Parse(data[6]);
tracegas.SO2 = float.Parse(data[7]);
tracegas.H2O2 = float.Parse(data[8]);
tracegas.O3_tracegas_1 = float.Parse(data[9]);
tracegas.NOX_tracegas_1 = float.Parse(data[10]);
tracegas.SO2_tracegas_1 = float.Parse(data[11]);
tracegas.H2O2_tracegas_1 = float.Parse(data[12]);
tracegas.CO_tracegas_1 = float.Parse(data[13]);
traceGass.Add(tracegas);
}
return(traceGass);
}
public static List <ModelCommon> ReadInletcontroldataFile(String filepath)
{
List <String[]> datas = CSVUtil.ReadCsv(filepath);
List <ModelCommon> inletcontroldatas = new List <ModelCommon>();
foreach (String[] data in datas)
{
Inletcontroldata inletcontroldata = new Inletcontroldata();
inletcontroldata.DateTime_inletcontroldata_1 = ModelUtil.ParseDateTime(data[0], data[1]);
inletcontroldata.tip_flow = float.Parse(data[2]);
inletcontroldata.tipfltrg = float.Parse(data[3]);
inletcontroldata.airspeed_inletcontroldata_1 = float.Parse(data[4]);
inletcontroldata.oat_temp = float.Parse(data[5]);
inletcontroldata.instflow = float.Parse(data[6]);
inletcontroldata.inltpres = float.Parse(data[7]);
inletcontroldata.blwrflow = float.Parse(data[8]);
inletcontroldata.blwrtarg = float.Parse(data[9]);
inletcontroldata.blwr_tmp = float.Parse(data[10]);
inletcontroldata.blwr_pwr = float.Parse(data[11]);
inletcontroldata.throtpos = float.Parse(data[12]);
inletcontroldata.fconetmp = float.Parse(data[13]);
inletcontroldata.rconetmp = float.Parse(data[14]);
inletcontroldata.pylontmp = float.Parse(data[15]);
inletcontroldata.sensrtmp = float.Parse(data[16]);
inletcontroldata.fconepwr = float.Parse(data[17]);
inletcontroldata.rconepwr = float.Parse(data[18]);
inletcontroldata.pylonpwr = float.Parse(data[19]);
inletcontroldata.sensrpwr = float.Parse(data[20]);
inletcontroldatas.Add(inletcontroldata);
}
return(inletcontroldatas);
}
/// <summary>
/// CSV 表映射到对象
/// </summary>
private Dictionary <int, T> ReadCSVTable <T>(string csvName)
{
Dictionary <int, T> csvTable = new Dictionary <int, T>();
CSVUtil.ReadCSV(csvName, csvTable);
return(csvTable);
}
public static Dictionary <uint, SkillData> GetSkillDatas()
{
if (_skillDataDic == null)
{
_skillDataDic = CSVUtil.Parse <uint, SkillData>("config/csv/skill", "SkillId");
}
return(_skillDataDic);
}
public static List <PrizeElementData> GetPrizeElementDatas()
{
if (_prizeElementDataList == null)
{
_prizeElementDataList = CSVUtil.Parse <PrizeElementData>("config/csv/prize_element");
}
return(_prizeElementDataList);
}
public static Dictionary <int, ShopCardRandomData> GetShopCardRandomDataDictionary()
{
if (_shopCardRandomDataDictionary == null)
{
_shopCardRandomDataDictionary = CSVUtil.Parse <int, ShopCardRandomData>("config/csv/shop_card_random", "id");
}
return(_shopCardRandomDataDictionary);
}
public static Dictionary <int, PrizeData> GetPrizeDatas()
{
if (_prizeDataDictionary == null)
{
_prizeDataDictionary = CSVUtil.Parse <int, PrizeData>("config/csv/prize", "id");
}
return(_prizeDataDictionary);
}
public static Dictionary <int, TaskData> GetTaskDataDicionary()
{
if (_taskDataDictionary == null)
{
_taskDataDictionary = CSVUtil.Parse <int, TaskData>("config/csv/task", "id");
}
return(_taskDataDictionary);
}
public static Dictionary <int, ShopItemData> GetShopItemData()
{
if (_shopItemDataDictionary == null)
{
_shopItemDataDictionary = CSVUtil.Parse <int, ShopItemData>("config/csv/shop_item", "id");
}
return(_shopItemDataDictionary);
}
public static Dictionary <int, DungeonStarData> GetDungeonStarDataDictionary()
{
if (_dungeonStarDataDictionary == null)
{
_dungeonStarDataDictionary = CSVUtil.Parse <int, DungeonStarData>("config/csv/dungeon_star", "id");
}
return(_dungeonStarDataDictionary);
}
public static Dictionary <uint, AvatarData> GetAvatarDatas()
{
if (_avatarDataDictionary == null)
{
_avatarDataDictionary = CSVUtil.Parse <uint, AvatarData>("config/csv/avatar", "Id");
}
return(_avatarDataDictionary);
}
public static Dictionary <int, FormationData> GetFormationDatas()
{
if (_formationDataDictionary == null)
{
_formationDataDictionary = CSVUtil.Parse <int, FormationData>("config/csv/formation", "id");
}
return(_formationDataDictionary);
}
public static Dictionary <int, ExpeditionData> GetExpeditionDatas()
{
if (_expeditionDataDictionary == null)
{
_expeditionDataDictionary = CSVUtil.Parse <int, ExpeditionData>("config/csv/faraway_expedition", "id");
}
return(_expeditionDataDictionary);
}
public static Dictionary <int, SignInData> GetSignInDatas()
{
if (_SignInDataDictionary == null)
{
_SignInDataDictionary = CSVUtil.Parse <int, SignInData>("config/csv/sign", "sign_id");
}
return(_SignInDataDictionary);
}
public static Dictionary <int, AudioData> GetAudioDatas()
{
if (_audioDataDic == null)
{
_audioDataDic = CSVUtil.Parse <int, AudioData>("config/csv/audio", "id");
}
return(_audioDataDic);
}
public static Dictionary <uint, MechanicsData> GetMechanicsDatas()
{
if (_mechanicsDataDic == null)
{
_mechanicsDataDic = CSVUtil.Parse <uint, MechanicsData>("config/csv/mechanics", "Id");
}
return(_mechanicsDataDic);
}
public static Dictionary <uint, PassiveData> GetPassiveDatas()
{
if (_passiveDataDic == null)
{
_passiveDataDic = CSVUtil.Parse <uint, PassiveData>("config/csv/passive", "SkillId");
}
return(_passiveDataDic);
}
public static Dictionary <int, HeroData> GetHeroDatas()
{
if (_heroDataDictionary == null)
{
_heroDataDictionary = CSVUtil.Parse <int, HeroData>("config/csv/hero", "id");
}
return(_heroDataDictionary);
}
private static Dictionary <int, ConsumeTipData> GetConsumeTipDataDicionary()
{
if (_consumeTipDataDictionary == null)
{
_consumeTipDataDictionary = CSVUtil.Parse <int, ConsumeTipData>("config/csv/consumer_tips", "function_id");
}
return(_consumeTipDataDictionary);
}
public static Dictionary <int, HeroCombineNeedData> GetHeroCombineNeedDatas()
{
if (_heroCombineNeedDataDictionary == null)
{
_heroCombineNeedDataDictionary = CSVUtil.Parse <int, HeroCombineNeedData>("config/csv/compose_need", "star");
}
return(_heroCombineNeedDataDictionary);
}
public static Dictionary <uint, TeamData> GetTeamDatas()
{
if (_teamDataDictionary == null)
{
_teamDataDictionary = CSVUtil.Parse <uint, TeamData>("config/csv/team", "team_id");
}
return(_teamDataDictionary);
}
public static Dictionary <int, HeroAdvanceData> GetHeroAdvanceDatas()
{
if (_heroAdvanceDataDictionary == null)
{
_heroAdvanceDataDictionary = CSVUtil.Parse <int, HeroAdvanceData>("config/csv/advance", "star");
}
return(_heroAdvanceDataDictionary);
}