GeneralMethod.cs 106 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711
  1. 
  2. using Microsoft.AspNetCore.SignalR;
  3. using Microsoft.International.Converters.PinYinConverter;
  4. using Microsoft.VisualBasic;
  5. using NPOI.HSSF.Util;
  6. using OASystem.API.OAMethodLib.Hub.HubClients;
  7. using OASystem.API.OAMethodLib.Hub.Hubs;
  8. using OASystem.API.OAMethodLib.JuHeAPI;
  9. using OASystem.API.OAMethodLib.SignalR.Hubs;
  10. using OASystem.Domain.Entities.Customer;
  11. using OASystem.Domain.Entities.District;
  12. using OASystem.Domain.Entities.Financial;
  13. using OASystem.Domain.Entities.Groups;
  14. using OASystem.Domain.ViewModels.Financial;
  15. using OASystem.Domain.ViewModels.Groups;
  16. using OASystem.Domain.ViewModels.JuHeExchangeRate;
  17. using OASystem.Infrastructure.Repositories.CRM;
  18. using OASystem.Infrastructure.Repositories.Groups;
  19. using System.Data;
  20. using System.IdentityModel.Tokens.Jwt;
  21. using System.IO.Compression;
  22. using System.Security.Claims;
  23. using System.Web;
  24. using static OpenAI.GPT3.ObjectModels.SharedModels.IOpenAiModels;
  25. namespace OASystem.API.OAMethodLib
  26. {
  27. public static class GeneralMethod
  28. {
  29. //团组信息
  30. private readonly static DelegationInfoRepository _dirRep = AutofacIocManager.Instance.GetService<DelegationInfoRepository>();
  31. private readonly static TeamRateRepository _teamRateRep = AutofacIocManager.Instance.GetService<TeamRateRepository>();
  32. private readonly static IJuHeApiService _juHeApi = AutofacIocManager.Instance.GetService<IJuHeApiService>();
  33. private readonly static SetDataRepository _setDataRep = AutofacIocManager.Instance.GetService<SetDataRepository>();
  34. private readonly static TableOperationRecordRepository _tableOperationRecordRep = AutofacIocManager.Instance.GetService<TableOperationRecordRepository>();
  35. private readonly static MessageRepository _messageRep = AutofacIocManager.Instance.GetService<MessageRepository>();
  36. private readonly static IHubContext<ChatHub, IChatClient> _hubContext = AutofacIocManager.Instance.GetService<IHubContext<ChatHub, IChatClient>>();
  37. private readonly static string[] weekdays = new string[] { "星期日", "星期一", "星期二", "星期三", "星期四", "星期五", "星期六" };
  38. #region 员工注册默认添加基础页面
  39. /// <summary>
  40. /// 默认职位权限
  41. /// </summary>
  42. public static bool DefaultPostAuth(int depId, int postId, int userId, int createUserId)
  43. {
  44. if (depId < 1) return false;
  45. if (postId < 1) return false;
  46. if (userId < 1) return false;
  47. if (userId < 1) return false;
  48. List<DefaultPostPageAuthView> _defaultData = AppSettingsHelper.Get<DefaultPostPageAuthView>("DefaultPostPageData");
  49. if (_defaultData.Count < 1) return false;
  50. var postJobDatas = _dirRep._sqlSugar.Queryable<Sys_JobPost>().Where(it => it.IsDel == 0).ToList();
  51. List<int> pageData = new List<int>();
  52. //添加公司公共页面
  53. pageData.AddRange(_defaultData.Find(it => it.DepId == -1)?.PostPageAuths[0].PageIds ?? new List<int>());
  54. //添加部门页面
  55. var depPublicPageData = _defaultData.Find(it => it.DepId == depId);
  56. var jobPublicPageData = postJobDatas.Find(it => it.DepId == depId && it.Id == postId);
  57. if (depPublicPageData != null) //特殊部门
  58. {
  59. //公共页面
  60. pageData.AddRange(depPublicPageData.PostPageAuths.Find(it => it.PostId == -1)?.PageIds ?? new List<int>());
  61. if (depId == 7) //国交部特殊处理
  62. {
  63. List<string> postNames = new List<string>() { "主管", "经理" };
  64. //岗位页面
  65. if (jobPublicPageData != null)
  66. {
  67. if (postNames.Contains(jobPublicPageData.JobName))
  68. {
  69. pageData.AddRange(depPublicPageData.PostPageAuths.Find(it => it.PostId == 0)?.PageIds ?? new List<int>());
  70. }
  71. else
  72. {
  73. pageData.AddRange(depPublicPageData.PostPageAuths.Find(it => it.PostId == postId)?.PageIds ?? new List<int>());
  74. }
  75. }
  76. }
  77. }
  78. else //通用部门
  79. {
  80. pageData.AddRange(_defaultData.Find(it => it.DepId == 0)?.PostPageAuths[0].PageIds ?? new List<int>());
  81. }
  82. if (pageData.Count > 0)
  83. {
  84. //页面操作权限数据(添加修改等...)
  85. var pageFunctionData = _dirRep._sqlSugar.Queryable<Sys_SystemMenuAndFunction>().Where(it => pageData.Contains(it.SmId) && it.IsDel == 0).ToList();
  86. var defaultPageData = pageFunctionData.Select(it => new Sys_UserAuthority() {
  87. UId = userId,
  88. SmId = it.SmId,
  89. FId = it.FId,
  90. CreateUserId = createUserId, //管理员
  91. CreateTime = DateTime.Now,
  92. IsDel = 0,
  93. IsTemp = 1
  94. }).ToList();
  95. if (defaultPageData.Count > 0)
  96. {
  97. //移除每个页面的审核权限,审核权限需要单独开启
  98. defaultPageData = defaultPageData.Where(it => it.FId != 12).ToList();
  99. //添加页面操作权限
  100. var s = _dirRep._sqlSugar.Fastest<Sys_UserAuthority>().PageSize(100000).BulkCopy(defaultPageData);
  101. if (s > 0)
  102. {
  103. return true;
  104. }
  105. }
  106. }
  107. return false;
  108. }
  109. #endregion
  110. #region 消息
  111. /// <summary>
  112. /// 消息 发布And 通知
  113. /// </summary>
  114. /// <param name="msgTypeEnum">
  115. /// 消息类型
  116. /// 1 公告通知
  117. /// 2 团组流程管控通知
  118. /// 3 团组业务操作通知
  119. /// 4 团组费用审核消息
  120. /// 5 团组签证进度通知
  121. /// 6 团组任务进度通知
  122. /// </param>
  123. /// <param name="title">消息标题</param>
  124. /// <param name="content">消息内容</param>
  125. /// <param name="userIds"></param>
  126. /// <param name="diId">团组id</param>
  127. /// <param name="param">团组id</param>
  128. /// <returns></returns>
  129. public static async Task<bool> MessageIssueAndNotification(MessageTypeEnum msgTypeEnum, string title, string content, List<int> userIds, int diId = 0, string param = "")
  130. {
  131. MessageDto messageDto = new()
  132. {
  133. Type = msgTypeEnum,
  134. IssuerId = 4,//管理员
  135. DiId = diId,
  136. Title = title,
  137. Content = content,
  138. ReleaseTime = DateTime.Now,
  139. UIdList = userIds,
  140. Param = param
  141. };
  142. var status = await _messageRep.AddMsg(messageDto);//添加消息
  143. if (status)
  144. {
  145. //给在线在用户发送消息
  146. List<string> connIds = UserStore.OnlineUser.Where(it => userIds.Contains(it.UserId)).Select(it => it.ConnectionId).ToList();
  147. string notificationTypeStr1 = GetMsgNotificationType(msgTypeEnum);
  148. string notificationTypeStr = JsonConvert.SerializeObject(
  149. new
  150. {
  151. UserIds = userIds,
  152. Msg = $"您有一条{notificationTypeStr1}相关的消息!"
  153. }
  154. );
  155. await _hubContext.Clients.Clients(connIds).ReceiveMessage($"您有一条{notificationTypeStr1}相关的消息!");
  156. return true;
  157. }
  158. return false;
  159. }
  160. /// <summary>
  161. /// 根据消息类型 获取 消息通知类型
  162. /// </summary>
  163. /// <returns></returns>
  164. public static string GetMsgNotificationType(MessageTypeEnum msgTypeEnum)
  165. {
  166. int notificationType = 0;
  167. string notificationStr = "";
  168. List<NotificationTypeView> notificationTypeViews = AppSettingsHelper.Get<NotificationTypeView>("MessageNotificationType");
  169. notificationType = notificationTypeViews.Where(it => it.MsgTypeIds.Contains((int)msgTypeEnum)).Select(it => it.TypeId).FirstOrDefault();
  170. if (notificationType == 1021) notificationStr = "操作";
  171. else if (notificationType == 1020) notificationStr = "任务";
  172. return notificationStr;
  173. }
  174. #endregion
  175. #region md5 加密
  176. /// <summary>
  177. /// MD5加密,和动网上的16/32位MD5加密结果相同,
  178. /// 使用的UTF8编码
  179. /// </summary>
  180. /// <param name="source">待加密字串</param>
  181. /// <param name="length">16或32值之一,其它则采用.net默认MD5加密算法</param>
  182. /// <returns>加密后的字串</returns>
  183. public static string Encrypt(string source, int length = 32)
  184. {
  185. if (string.IsNullOrWhiteSpace(source))
  186. return string.Empty;
  187. HashAlgorithm hashAlgorithm = CryptoConfig.CreateFromName("MD5") as HashAlgorithm;
  188. byte[] bytes = Encoding.UTF8.GetBytes(source);
  189. byte[] hashValue = hashAlgorithm.ComputeHash(bytes);
  190. StringBuilder sb = new StringBuilder();
  191. switch (length)
  192. {
  193. case 16://16位密文是32位密文的9到24位字符
  194. for (int i = 4; i < 12; i++)
  195. {
  196. sb.Append(hashValue[i].ToString("x2"));
  197. }
  198. break;
  199. case 32:
  200. for (int i = 0; i < 16; i++)
  201. {
  202. sb.Append(hashValue[i].ToString("x2"));
  203. }
  204. break;
  205. default:
  206. for (int i = 0; i < hashValue.Length; i++)
  207. {
  208. sb.Append(hashValue[i].ToString("x2"));
  209. }
  210. break;
  211. }
  212. return sb.ToString();
  213. }
  214. #endregion
  215. #region jwt
  216. /// <summary>
  217. /// 获取token
  218. /// </summary>
  219. /// <param name="_config"></param>
  220. /// <param name="Number"></param>
  221. /// <param name="exp"></param>
  222. /// <returns></returns>
  223. public static async Task<string> GetToken(IConfiguration _config, string Number, int uId, string uName, DateTime exp)
  224. {
  225. string userId = Guid.NewGuid().ToString().Replace("-", "");
  226. var claims = new[] {
  227. new Claim(ClaimTypes.NameIdentifier, uName),
  228. new Claim(ClaimTypes.NameIdentifier, uId.ToString()),
  229. new Claim(ClaimTypes.NameIdentifier, userId),
  230. new Claim("Number",Number)
  231. };
  232. var key = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(_config["JwtSecurityKey"]));
  233. var creds = new SigningCredentials(key, SecurityAlgorithms.HmacSha256);
  234. var token = new JwtSecurityToken(
  235. issuer: "OASystem.com",
  236. audience: "OASystem.com",
  237. claims: claims,
  238. expires: exp,
  239. signingCredentials: creds);
  240. var indentity = new ClaimsIdentity(claims, "formlogin");
  241. var principal = new ClaimsPrincipal(indentity);
  242. // await _httpContext.SignInAsync (CookieAuthenticationDefaults.AuthenticationScheme, principal);
  243. return new JwtSecurityTokenHandler().WriteToken(token);
  244. }
  245. #endregion
  246. #region 数据类型转换
  247. /// <summary>
  248. /// object 转 Int
  249. /// </summary>
  250. /// <param name="obj"></param>
  251. /// <returns></returns>
  252. public static int GetInt(this object obj)
  253. {
  254. if (obj == null)
  255. return 0;
  256. int _number = 0;
  257. bool reslut = Int32.TryParse(obj.ToString(), out _number);
  258. return _number;
  259. }
  260. private static DateTime dateStart = new DateTime(1970, 1, 1, 8, 0, 0);
  261. private static long longTime = 621355968000000000;
  262. private static int samllTime = 10000000;
  263. /// <summary>
  264. /// 时间戳 转 datetime
  265. /// </summary>
  266. /// <param name="timeStamp"></param>
  267. /// <returns></returns>
  268. public static DateTime GetTimeSpmpToDate(this object timeStamp)
  269. {
  270. if (timeStamp == null) return dateStart;
  271. DateTime dateTime = new DateTime(longTime + Convert.ToInt64(timeStamp) * samllTime, DateTimeKind.Utc).ToLocalTime();
  272. return dateTime;
  273. }
  274. #endregion
  275. #region 用户页面操作功能 权限
  276. /// <summary>
  277. /// 用户页面操作功能(可使用)
  278. /// </summary>
  279. /// <param name="userId">用户Id</param>
  280. /// <param name="PageId">页面Id</param>
  281. /// <returns></returns>
  282. public static async Task<PageFunAuthViewBase> PostUserPageFuncDatas(int userId, int PageId)
  283. {
  284. PageFunAuthViewBase pageFunAuth = new PageFunAuthViewBase();
  285. List<UserPageFuncView> userPageFuncDatas = new List<UserPageFuncView>();
  286. string sql = string.Format(@"Select ua.UId As UserId, u.CnName As UserName, pa.ModuleId,pa.ModuleName,pa.PageId,pa.PageName,pa.PageIsEnable,
  287. pa.PagePhoneIsEnable,pa.FuncId,pa.FuncName,pa.FuncIsEnable
  288. From Sys_UserAuthority ua
  289. Left Join Sys_Users u On ua.UId = u.Id
  290. Left Join (
  291. Select sd.Id As ModuleId,sd.Name As ModuleName, smp.Id As PageId,smp.Name As PageName,smp.IsEnable As PageIsEnable,
  292. smp.phoneIsEnable As PagePhoneIsEnable,pfp.Id As FuncId,pfp.FunctionName As FuncName,pfp.IsEnable As FuncIsEnable
  293. From Sys_SystemMenuAndFunction smaf
  294. Left Join Sys_SystemMenuPermission smp On smaf.SmId = smp.Id
  295. Left Join Sys_SetData sd On sd.STid = 5 And smp.Mid = sd.Id
  296. Left Join Sys_PageFunctionPermission pfp On smaf.FId = pfp.Id
  297. Where smaf.IsDel = 0 And smp.IsDel = 0 And pfp.IsDel = 0 And sd.IsDel = 0 And smp.IsEnable = 1
  298. ) As pa On ua.SmId = pa.PageId And ua.FId = pa.FuncId
  299. Where ua.IsDel = 0 And ua.UId = {0} And pa.PageId = {1}
  300. Order By ModuleId,PageId,FuncId Asc", userId, PageId);
  301. userPageFuncDatas = await _dirRep._sqlSugar.SqlQueryable<UserPageFuncView>(sql).ToListAsync();
  302. if (userPageFuncDatas.Count <= 0)
  303. {
  304. return pageFunAuth;
  305. }
  306. UserPageFuncView userPageFunc = new UserPageFuncView();
  307. //查询 1
  308. userPageFunc = userPageFuncDatas.Where(it => it.FuncId == 1).FirstOrDefault();
  309. if (userPageFunc != null) pageFunAuth.CheckAuth = 1;
  310. //删除 2
  311. userPageFunc = userPageFuncDatas.Where(it => it.FuncId == 2).FirstOrDefault();
  312. if (userPageFunc != null) pageFunAuth.DeleteAuth = 1;
  313. //编辑 3
  314. userPageFunc = userPageFuncDatas.Where(it => it.FuncId == 3).FirstOrDefault();
  315. if (userPageFunc != null) pageFunAuth.EditAuth = 1;
  316. //下载 4
  317. userPageFunc = userPageFuncDatas.Where(it => it.FuncId == 4).FirstOrDefault();
  318. if (userPageFunc != null) pageFunAuth.FilesDownloadAuth = 1;
  319. //上传 5
  320. userPageFunc = userPageFuncDatas.Where(it => it.FuncId == 5).FirstOrDefault();
  321. if (userPageFunc != null) pageFunAuth.FilesUploadAuth = 1;
  322. //添加 11
  323. userPageFunc = userPageFuncDatas.Where(it => it.FuncId == 11).FirstOrDefault();
  324. if (userPageFunc != null) pageFunAuth.AddAuth = 1;
  325. //审核 12
  326. userPageFunc = userPageFuncDatas.Where(it => it.FuncId == 12).FirstOrDefault();
  327. if (userPageFunc != null) pageFunAuth.AuditAuth = 1;
  328. return pageFunAuth;
  329. }
  330. #endregion
  331. #region 业务模块 团组权限
  332. /// <summary>
  333. /// 业务模块 团组操作权限
  334. /// 验证 并返回可操作的团
  335. /// </summary>
  336. /// <param name="diId">团组Id</param>
  337. /// <param name="userId">用户Id</param>
  338. /// <param name="CTable">业务模块Id</param>
  339. /// <returns></returns>
  340. public static async Task<Result> PostGroupOperationAuth(int diId, int userId, int CTable)
  341. {
  342. Result _result = new Result { Code = -1, Msg = "No Operation Authorty!" };
  343. if (CTable < 1)
  344. {
  345. _result.Msg = "请填写正确的用户Id!";
  346. return _result;
  347. }
  348. var data = _dirRep._sqlSugar.Queryable<Grp_GroupsTaskAssignment>().Where(it => it.DIId == diId && it.UId == userId && it.CTId == CTable && it.IsDel == 0).First();
  349. if (data == null)
  350. {
  351. _result.Msg = "你没有本团下的该业务模块操作,请联系主管分配操作权限!";
  352. }
  353. else
  354. {
  355. _result.Code = 0;
  356. }
  357. return _result;
  358. }
  359. /// <summary>
  360. /// 业务模块 团组操作权限
  361. /// 返回可操作的团
  362. /// </summary>
  363. /// <param name="diId">团组Id</param>
  364. /// <param name="userId">用户Id</param>
  365. /// <param name="CTable">业务模块Id</param>
  366. /// <returns></returns>
  367. public static async Task<List<Web_ShareGroupInfoView>> PostOperationAuthReturnGroupInfosAsync(int userId, int CTable)
  368. {
  369. List<Web_ShareGroupInfoView> _ShareGroupInfoViews = new List<Web_ShareGroupInfoView>();
  370. var taskDatas = _dirRep._sqlSugar.Queryable<Grp_GroupsTaskAssignment>().Where(it => it.UId == userId && it.CTId == CTable && it.IsDel == 0).ToList();
  371. if (taskDatas.Count < 1) return _ShareGroupInfoViews;
  372. string diIds = string.Join(",", taskDatas.Select(it => it.DIId).ToList());
  373. string sql = string.Format(@"Select Id,TeamName,TourCode,ClientName,VisitCountry,VisitStartDate,VisitEndDate,VisitDays,VisitPNumber
  374. From Grp_DelegationInfo Where Id In({0}) And IsDel = 0 Order By Id Desc", diIds);
  375. _ShareGroupInfoViews = await _dirRep._sqlSugar.SqlQueryable<Web_ShareGroupInfoView>(sql).ToListAsync();
  376. return _ShareGroupInfoViews;
  377. }
  378. #endregion
  379. #region 团组相关
  380. #region 建团按国家默认添加汇率 / 默认权限分配
  381. /// <summary>
  382. /// 团组汇率
  383. /// 建团时 添加基础汇率 CNY
  384. /// 按国家 添加 默认币种
  385. /// </summary>
  386. /// <param name="userId"></param>
  387. /// <param name="diId"></param>
  388. /// <returns></returns>
  389. public static async Task<Result> PostGroupRateAddInit(int userId, int diId)
  390. {
  391. Result result = new() { Code = -2 };
  392. if (userId < 1)
  393. {
  394. result.Msg = string.Format(@"请传入正确的userId");
  395. return result;
  396. }
  397. if (diId < 1)
  398. {
  399. result.Msg = string.Format(@"请传入正确的DiId");
  400. return result;
  401. }
  402. //美元(USD):1.0000|欧元(EUR):1.0000|墨西哥比索(MXN):1.0000
  403. string rateInit = string.Format(@"人民币(CNY):1.0000");
  404. //var gropInfo = _dirRep._sqlSugar.Queryable<Grp_DelegationInfo>().Where(it => it.IsDel == 0 && it.Id == diId).First();
  405. //if (gropInfo == null)
  406. //{
  407. // result.Msg = $@"未查询到团组信息!";
  408. // return result;
  409. //}
  410. var juheRateData = await _juHeApi.GetExchangeRateAsync();
  411. if (juheRateData.Error_code != 0)
  412. {
  413. result.Msg = juheRateData.Reason;
  414. return result;
  415. }
  416. List<ExchangeRateModel> exchangeRateModels = (List<ExchangeRateModel>)juheRateData.Result;
  417. if (exchangeRateModels.Count <= 0)
  418. {
  419. result.Msg = $@"未查询到聚合接口汇率信息!";
  420. return result;
  421. }
  422. if (exchangeRateModels.Count > 0)
  423. {
  424. var codes = _dirRep._sqlSugar.Queryable<Sys_SetData>().Where(it => it.IsDel == 0 && it.STid == 66).ToList();
  425. for (int i = 0; i < exchangeRateModels.Count; i++)
  426. {
  427. string currencyName = exchangeRateModels[i].Name;
  428. string code = "";
  429. var currencyData = codes.Where(it => it.Remark == currencyName).FirstOrDefault();
  430. if (currencyData != null)
  431. {
  432. code = currencyData.Name;
  433. decimal currRate = 0.00M;
  434. string MSellPri = exchangeRateModels[i].MSellPri;
  435. if (!string.IsNullOrEmpty(MSellPri))
  436. {
  437. currRate = Convert.ToDecimal(MSellPri) / 100M;
  438. }
  439. rateInit += $@"|{currencyName}({code}):{currRate.ToString("#0.0000")}";
  440. }
  441. }
  442. }
  443. var cTableIds = _dirRep._sqlSugar.Queryable<Sys_SetData>().Where(it => it.IsDel == 0 && it.STid == 16).ToList();
  444. if (cTableIds.Count < 1)
  445. {
  446. result.Msg = $@"未查询到操作模块信息!";
  447. return result;
  448. }
  449. List<Grp_TeamRate> grp_TeamRates = new List<Grp_TeamRate>();
  450. foreach (var item in cTableIds)
  451. {
  452. grp_TeamRates.Add(
  453. new Grp_TeamRate() { DiId = diId, CTable = item.Id, Remark = rateInit, CreateUserId = userId }
  454. );
  455. }
  456. if (grp_TeamRates.Count > 0)
  457. {
  458. var addId = _teamRateRep._sqlSugar.Insertable(grp_TeamRates).ExecuteCommand();
  459. if (addId < 1)
  460. {
  461. result.Msg = string.Format(@"添加失败!");
  462. return result;
  463. }
  464. }
  465. result.Code = 0;
  466. result.Msg = string.Format(@"操作成功!");
  467. return result;
  468. }
  469. /// <summary>
  470. /// 团组任务分配
  471. /// 建团时 默认按照岗位分配权限
  472. /// </summary>
  473. /// <param name="userId"></param>
  474. /// <param name="diId"></param>
  475. /// <param name="companyId"></param>
  476. /// <returns></returns>
  477. public static async Task<Result> PostGroupAuthAddInit(int userId, int diId, int companyId = 2)
  478. {
  479. Result result = new() { Code = -2 };
  480. if (userId < 0)
  481. {
  482. result.Msg = string.Format(@"请传入正确的userId");
  483. return result;
  484. }
  485. if (companyId < 0)
  486. {
  487. result.Msg = string.Format(@"请传入正确的companyId");
  488. return result;
  489. }
  490. if (diId < 0)
  491. {
  492. result.Msg = string.Format(@"请传入正确的DiId");
  493. return result;
  494. }
  495. var userDatas = await _teamRateRep._sqlSugar
  496. .Queryable<Sys_Users>()
  497. .LeftJoin<Sys_Department>((su, sd) => su.DepId == sd.Id && sd.IsDel == 0)
  498. .LeftJoin<Sys_JobPost>((su, sd, sjp) => su.JobPostId == sjp.Id && sjp.IsDel == 0)
  499. .Where(su => su.IsDel == 0)
  500. .Select((su, sd, sjp) => new {
  501. su.DepId,
  502. sd.DepName,
  503. su.JobPostId,
  504. sjp.JobName,
  505. su.Id,
  506. su.CnName
  507. })
  508. .ToListAsync();
  509. /*
  510. * 76 酒店预订 --> 国交部门 酒店 岗位
  511. * 77 行程 --> 国交部门 经理,主管 岗位
  512. * 79 车/导游地接 --> 国交部门 OP 岗位
  513. * 80 签证 --> 国交部门 签证 岗位
  514. * 81 邀请/公务活动 --> 国交部门 商邀 岗位
  515. * 82 团组客户保险 --> 国交部 经理,主管 岗位
  516. * 85 机票预订 --> 国交部门 机票 岗位
  517. * 98 其他款项 --> 总经办部门 总经理 岗位/国交部门(ALL) 岗位/财务部门(ALL) 岗位/策划部门(ALL) 岗位/人事部门 采购 岗位
  518. * 1015 超支费用,69 收款退还 --> 财务部门(ALL)岗位
  519. * 1015 超支费用 --> 国交部(ALL)岗位
  520. */
  521. List<Grp_GroupsTaskAssignment> _GroupsTaskAssignments = new List<Grp_GroupsTaskAssignment>();
  522. // 76 酒店预订 --> 国交部门(7) 酒店(25) 岗位
  523. _GroupsTaskAssignments.AddRange(
  524. userDatas
  525. .Where(it => it.DepId == 7 && it.JobPostId == 25)
  526. .Select(it => new Grp_GroupsTaskAssignment()
  527. {
  528. DIId = diId,
  529. CTId = 76,
  530. UId = it.Id,
  531. CreateUserId = userId
  532. }).ToList()
  533. );
  534. // 77 行程 --> 国交部门(7) 经理(32),主管(22) 岗位
  535. _GroupsTaskAssignments.AddRange(
  536. userDatas
  537. .Where(it => it.DepId == 7 && (it.JobPostId == 22 || it.JobPostId == 32))
  538. .Select(it => new Grp_GroupsTaskAssignment()
  539. {
  540. DIId = diId,
  541. CTId = 77,
  542. UId = it.Id,
  543. CreateUserId = userId
  544. }).ToList()
  545. );
  546. //79 车/导游地接 --> 国交部门(7) OP(28) 岗位
  547. _GroupsTaskAssignments.AddRange(
  548. userDatas.Where(it => it.DepId == 7 && it.JobPostId == 28)
  549. .Select(it => new Grp_GroupsTaskAssignment()
  550. {
  551. DIId = diId,
  552. CTId = 79,
  553. UId = it.Id,
  554. CreateUserId = userId
  555. }).ToList()
  556. );
  557. //81 邀请/公务活动 --> 国交部门(7) 商邀(27) 岗位
  558. _GroupsTaskAssignments.AddRange(
  559. userDatas
  560. .Where(it => it.DepId == 7 && it.JobPostId == 27)
  561. .Select(it => new Grp_GroupsTaskAssignment()
  562. {
  563. DIId = diId,
  564. CTId = 81,
  565. UId = it.Id,
  566. CreateUserId = userId
  567. }).ToList()
  568. );
  569. //80 签证 --> 国交部门(7) 签证(26) 岗位
  570. _GroupsTaskAssignments.AddRange(
  571. userDatas
  572. .Where(it => it.DepId == 7 && it.JobPostId == 26)
  573. .Select(it => new Grp_GroupsTaskAssignment()
  574. {
  575. DIId = diId,
  576. CTId = 80,
  577. UId = it.Id,
  578. CreateUserId = userId
  579. }).ToList()
  580. );
  581. //82 团组客户保险 --> 国交部(7) 经理(32),主管(22) 岗位
  582. _GroupsTaskAssignments.AddRange(
  583. userDatas
  584. .Where(it => it.DepId == 7 && (it.JobPostId == 22 || it.JobPostId == 32))
  585. .Select(it => new Grp_GroupsTaskAssignment()
  586. {
  587. DIId = diId,
  588. CTId = 82,
  589. UId = it.Id,
  590. CreateUserId = userId
  591. }).ToList()
  592. );
  593. //85 机票预订 --> 国交部门(7) 机票(24) 岗位
  594. _GroupsTaskAssignments.AddRange(
  595. userDatas
  596. .Where(it => it.DepId == 7 && it.JobPostId == 24)
  597. .Select(it => new Grp_GroupsTaskAssignment()
  598. {
  599. DIId = diId,
  600. CTId = 85,
  601. UId = it.Id,
  602. CreateUserId = userId
  603. }).ToList()
  604. );
  605. //98 其他款项 --> 总经办部门(1) 总经理(1) 岗位/国交部门(7)(ALL) 岗位/财务部门(3)(ALL) 岗位/策划部门(5)(ALL) 岗位/人事部门(4) 采购(74) 岗位
  606. List<int> depIds = new List<int>() { 7, 3, 5 };
  607. List<int> jobIds = new List<int>() { 1, 74 };
  608. _GroupsTaskAssignments.AddRange(
  609. userDatas
  610. .Where(it => depIds.Contains(it.DepId) || jobIds.Contains(it.JobPostId))
  611. .Select(it => new Grp_GroupsTaskAssignment()
  612. {
  613. DIId = diId,
  614. CTId = 98,
  615. UId = it.Id,
  616. CreateUserId = userId
  617. }).ToList()
  618. );
  619. //1015 超支费用,285 收款退还 --> 财务部门(ALL)岗位
  620. _GroupsTaskAssignments.AddRange(
  621. userDatas
  622. .Where(it => it.DepId == 3)
  623. .Select(it => new Grp_GroupsTaskAssignment()
  624. {
  625. DIId = diId,
  626. CTId = 1015,
  627. UId = it.Id,
  628. CreateUserId = userId
  629. }).ToList()
  630. );
  631. _GroupsTaskAssignments.AddRange(
  632. userDatas
  633. .Where(it => it.DepId == 3)
  634. .Select(it => new Grp_GroupsTaskAssignment()
  635. {
  636. DIId = diId,
  637. CTId = 285,
  638. UId = it.Id,
  639. CreateUserId = userId
  640. }).ToList()
  641. );
  642. //1015 超支费用 --> 国交部(ALL)岗位
  643. _GroupsTaskAssignments.AddRange(
  644. userDatas
  645. .Where(it => it.DepId == 7)
  646. .Select(it => new Grp_GroupsTaskAssignment()
  647. {
  648. DIId = diId,
  649. CTId = 1015,
  650. UId = it.Id,
  651. CreateUserId = userId
  652. }).ToList()
  653. );
  654. if (_GroupsTaskAssignments.Count > 0)
  655. {
  656. var addId = _teamRateRep._sqlSugar.Insertable(_GroupsTaskAssignments).ExecuteCommand();
  657. }
  658. result.Code = 0;
  659. result.Msg = string.Format(@"操作成功!");
  660. return result;
  661. }
  662. #endregion
  663. #endregion
  664. #region 团组汇率
  665. /// <summary>
  666. /// 团组汇率
  667. /// 获取板块 币种 及 汇率
  668. /// 76 酒店预订 77 行程 79 车/导游地接
  669. /// 80 签证 82 团组客户保险 85 机票预订
  670. /// 98 其他款项 285 收款退还
  671. /// </summary>
  672. /// <param name="teamRateModels"></param>
  673. /// <param name="cTable"></param>
  674. /// <param name="currencyCode"></param>
  675. /// <returns>
  676. /// string
  677. /// eg: CNY 1.0000
  678. /// </returns>
  679. public static async Task<string> PostGroupRateByCTableAndCurrency(List<TeamRateModelView> teamRateModels, int cTable, List<string> currencyCodes)
  680. {
  681. string str = "";
  682. List<string> currencyRates = new List<string>();
  683. TeamRateModelView hotelRateData = teamRateModels.Where(it => it.CTableId == cTable).FirstOrDefault();
  684. if (hotelRateData != null)
  685. {
  686. var hotelRates = hotelRateData.TeamRates;
  687. foreach (var item in currencyCodes)
  688. {
  689. if (!string.IsNullOrEmpty(item))
  690. {
  691. var hotelRateInfo = hotelRates.Where(it => it.CurrencyCode.Equals(item)).FirstOrDefault();
  692. if (hotelRateInfo != null)
  693. {
  694. string str1 = string.Format("{0} {1}\r\n", hotelRateInfo.CurrencyCode, hotelRateInfo.Rate.ToString("#0.0000"));
  695. currencyRates.Add(str1);
  696. }
  697. }
  698. }
  699. if (currencyRates != null || currencyRates.Count > 0)
  700. {
  701. currencyRates = currencyRates.Distinct().ToList();
  702. foreach (var item in currencyRates)
  703. {
  704. str += item;
  705. }
  706. }
  707. }
  708. return str;
  709. }
  710. /// <summary>
  711. /// 团组汇率 币种 Item (来源:团组汇率)
  712. /// 根据 团组Id And 业务类型(CTable)Id
  713. /// api处理CTable = 285,默认返回CNY
  714. /// </summary>
  715. /// <param name="portType"></param>
  716. /// <param name="diId"></param>
  717. /// <param name="cTable"></param>
  718. /// <returns></returns>
  719. public static async Task<TeamRateModelGeneralView> PostGroupTeamRateByDiIdAndCTableId(int portType, int diId, int cTable)
  720. {
  721. TeamRateModelGeneralView _view = new TeamRateModelGeneralView();
  722. _view = await _teamRateRep.PostGroupTeamRateByDiIdAndCTableId(portType, diId, cTable);
  723. return _view;
  724. }
  725. /// <summary>
  726. /// 汇率备注拆分
  727. /// (美元(USD):7.2370|日元(JPY):0.0499|欧元(EUR):8.3000|英镑(GBP):9.1996|港币(HKD):0.9291)
  728. /// </summary>
  729. /// <param name="rateRemark"></param>
  730. /// <returns></returns>
  731. public static async Task<List<TeamRateDescAddCurrencyIdView>> SplitExchangeRate(this string rateRemark)
  732. {
  733. List<TeamRateDescAddCurrencyIdView> _view = new List<TeamRateDescAddCurrencyIdView>();
  734. List<SetDataInfoView> currencyDatas = new List<SetDataInfoView>();
  735. #region 获取所有币种
  736. string sql = string.Format(@"select * from Sys_SetData where STid = {0} and isdel = 0", 66);
  737. var DBdata = _setDataRep.GetListBySqlWithNolock(sql);
  738. if (DBdata == null || DBdata.Count == 0)
  739. {
  740. return _view;
  741. }
  742. currencyDatas = DBdata.Select(x => new SetDataInfoView
  743. {
  744. Name = x.Name,
  745. Id = x.Id,
  746. Remark = x.Remark,
  747. }).ToList();
  748. #endregion
  749. #region 拆分remark里的汇率
  750. if (string.IsNullOrEmpty(rateRemark))
  751. {
  752. return _view;
  753. }
  754. if (rateRemark.Contains("|"))
  755. {
  756. string[] currencyArr = rateRemark.Split("|");
  757. foreach (string currency in currencyArr)
  758. {
  759. string[] currency1 = currency.Split(":");
  760. string[] currency2 = currency1[0].Split("(");
  761. string currencyCode = currency2[1].Replace(")", "").TrimEnd();
  762. TeamRateDescAddCurrencyIdView rateDescView = new TeamRateDescAddCurrencyIdView()
  763. {
  764. CurrencyId = currencyDatas.Find(it => it.Name == currencyCode).Id,
  765. CurrencyCode = currencyCode,
  766. CurrencyName = currency2[0],
  767. Rate = decimal.Parse(currency1[1]),
  768. };
  769. _view.Add(rateDescView);
  770. }
  771. }
  772. else
  773. {
  774. try
  775. {
  776. string[] currency1 = rateRemark.Split(":");
  777. string[] currency2 = currency1[0].Split("(");
  778. string currencyCode = currency2[1].Replace(")", "").TrimEnd();
  779. TeamRateDescAddCurrencyIdView rateDescView = new TeamRateDescAddCurrencyIdView()
  780. {
  781. CurrencyId = currencyDatas.Find(it => it.Name == currencyCode).Id,
  782. CurrencyCode = currencyCode,
  783. CurrencyName = currency2[0],
  784. Rate = decimal.Parse(currency1[1]),
  785. };
  786. _view.Add(rateDescView);
  787. }
  788. catch (Exception)
  789. {
  790. return _view;
  791. }
  792. }
  793. #endregion
  794. return _view;
  795. }
  796. #endregion
  797. #region 汉字转换拼音
  798. private static Dictionary<int, List<string>> GetTotalPingYinDictionary(string text)
  799. {
  800. var chs = text.ToCharArray();
  801. //记录每个汉字的全拼
  802. Dictionary<int, List<string>> totalPingYinList = new Dictionary<int, List<string>>();
  803. for (int i = 0; i < chs.Length; i++)
  804. {
  805. var pinyinList = new List<string>();
  806. //是否是有效的汉字
  807. if (ChineseChar.IsValidChar(chs[i]))
  808. {
  809. ChineseChar cc = new ChineseChar(chs[i]);
  810. pinyinList = cc.Pinyins.Where(p => !string.IsNullOrWhiteSpace(p)).ToList();
  811. }
  812. else
  813. {
  814. pinyinList.Add(chs[i].ToString());
  815. }
  816. //去除声调,转小写
  817. pinyinList = pinyinList.ConvertAll(p => Regex.Replace(p, @"\d", "").ToLower());
  818. //去重
  819. pinyinList = pinyinList.Where(p => !string.IsNullOrWhiteSpace(p)).Distinct().ToList();
  820. if (pinyinList.Any())
  821. {
  822. totalPingYinList[i] = pinyinList;
  823. }
  824. }
  825. return totalPingYinList;
  826. }
  827. /// <summary>
  828. /// 获取汉语拼音全拼
  829. /// </summary>
  830. /// <param name="text">The string.</param>
  831. /// <returns></returns>
  832. public static List<string> GetTotalPingYin(this string text)
  833. {
  834. var result = new List<string>();
  835. foreach (var pys in GetTotalPingYinDictionary(text))
  836. {
  837. var items = pys.Value;
  838. if (result.Count <= 0)
  839. {
  840. result = items;
  841. }
  842. else
  843. {
  844. //全拼循环匹配
  845. var newTotalPingYinList = new List<string>();
  846. foreach (var totalPingYin in result)
  847. {
  848. newTotalPingYinList.AddRange(items.Select(item => totalPingYin + item));
  849. }
  850. newTotalPingYinList = newTotalPingYinList.Distinct().ToList();
  851. result = newTotalPingYinList;
  852. }
  853. }
  854. return result;
  855. }
  856. /// <summary>
  857. /// 获取汉语拼音首字母
  858. /// </summary>
  859. /// <param name="text"></param>
  860. /// <returns></returns>
  861. public static List<string> GetFirstPingYin(this string text)
  862. {
  863. var result = new List<string>();
  864. foreach (var pys in GetTotalPingYinDictionary(text))
  865. {
  866. var items = pys.Value;
  867. if (result.Count <= 0)
  868. {
  869. result = items.ConvertAll(p => p.Substring(0, 1)).Distinct().ToList();
  870. }
  871. else
  872. {
  873. //首字母循环匹配
  874. var newFirstPingYinList = new List<string>();
  875. foreach (var firstPingYin in result)
  876. {
  877. newFirstPingYinList.AddRange(items.Select(item => firstPingYin + item.Substring(0, 1)));
  878. }
  879. newFirstPingYinList = newFirstPingYinList.Distinct().ToList();
  880. result = newFirstPingYinList;
  881. }
  882. }
  883. return result;
  884. }
  885. #endregion
  886. #region 新客户资料表 操作记录
  887. /// <summary>
  888. /// 新客户资料表
  889. /// 操作记录添加
  890. /// </summary>
  891. /// <param name="portType"></param>
  892. /// <param name="operationEnum"></param>
  893. /// <param name="userId"></param>
  894. /// <param name="dataId"></param>
  895. /// <param name="remark"></param>
  896. /// <returns></returns>
  897. public static async Task<bool> NewClientOperationRecord(int portType, OperationEnum operationEnum, int userId, int dataId, string remark)
  898. {
  899. Crm_TableOperationRecord _TableOperationRecord = new Crm_TableOperationRecord()
  900. {
  901. TableName = "Crm_NewClientData",
  902. PortType = portType,
  903. OperationItem = operationEnum,
  904. DataId = dataId,
  905. CreateUserId = userId,
  906. CreateTime = DateTime.Now,
  907. Remark = remark
  908. };
  909. bool add = await _tableOperationRecordRep._Add(_TableOperationRecord);
  910. if (add) return false;
  911. return false;
  912. }
  913. #endregion
  914. #region 金额转大写
  915. /// <summary>
  916. /// 金额转换为大写数字
  917. /// <para>1、支持的最大数字:999999999999.99(玖仟玖佰玖拾玖亿玖仟玖佰玖拾玖万玖仟玖佰玖拾玖元玖角玖分)</para>
  918. /// <para>2、小数点后最多支持两位</para>
  919. /// </summary>
  920. /// <param name="num">数值</param>
  921. /// <returns></returns>
  922. public static string ConvertCNYUpper(this decimal num)
  923. {
  924. if (num == 0)
  925. {
  926. return "零元";
  927. }
  928. // 解决327000000转换后缺少单位万的问题
  929. return ConvertToChinese(num);
  930. }
  931. #region 实例
  932. /// <summary>
  933. /// 要转换的数字
  934. /// </summary>
  935. private static decimal j;
  936. /// <summary>
  937. ///
  938. /// </summary>
  939. private static string[] NumChineseCharacter = new string[] { "零", "壹", "贰", "叁", "肆", "伍", "陆", "柒", "捌", "玖" };
  940. /// <summary>
  941. /// 判断输入的数字是否大于double类型
  942. /// </summary>
  943. private static bool IsNumber
  944. {
  945. get
  946. {
  947. if (j > decimal.MaxValue || j <= 0)
  948. return false;
  949. else
  950. return true;
  951. }
  952. }
  953. /// <summary>
  954. /// 数字转换成大写汉字主函数
  955. /// </summary>
  956. /// <returns>返回转换后的大写汉字</returns>
  957. public static string ConvertToChinese(decimal m)
  958. {
  959. j = m;
  960. string bb = "";
  961. if (IsNumber)
  962. {
  963. string str = j.ToString();
  964. string[] Num = str.Split('.');
  965. if (Num.Length == 1)
  966. {
  967. bb = NumberString(Num[0]) + "元整";
  968. bb = bb.Replace("零零", "零");
  969. }
  970. else
  971. {
  972. bb = NumberString(Num[0]) + "元";
  973. bb += FloatString(Num[1]);
  974. bb = bb.Replace("零零", "零");
  975. }
  976. }
  977. else
  978. {
  979. throw new FormatException("你输入的数字格式不正确或不是数字!");
  980. }
  981. return bb;
  982. }
  983. /// <summary>
  984. /// 小数位转换只支持两位的小数
  985. /// </summary>
  986. /// <param name="Num">转换的小数</param>
  987. /// <returns>小数转换成汉字</returns>
  988. private static string FloatString(string Num)
  989. {
  990. string cc = "";
  991. if (Num.Length > 2)
  992. {
  993. throw new FormatException("小数位数过多.");
  994. }
  995. else
  996. {
  997. string bb = ConvertString(Num);
  998. int len = bb.IndexOf("零");
  999. if (len != 0)
  1000. {
  1001. bb = bb.Replace("零", "");
  1002. if (bb.Length == 1)
  1003. {
  1004. cc = bb.Substring(0, 1) + "角";
  1005. }
  1006. else
  1007. {
  1008. cc = bb.Substring(0, 1) + "角";
  1009. cc += bb.Substring(1, 1) + "分";
  1010. }
  1011. }
  1012. else
  1013. cc = bb + "分";
  1014. }
  1015. return cc;
  1016. }
  1017. /// <summary>
  1018. /// 判断数字位数以进行拆分转换
  1019. /// </summary>
  1020. /// <param name="Num">要进行拆分的数字</param>
  1021. /// <returns>转换成的汉字</returns>
  1022. private static string NumberString(string Num)
  1023. {
  1024. string bb = "";
  1025. if (Num.Length <= 4)
  1026. {
  1027. bb = Convert4(Num);
  1028. }
  1029. else if (Num.Length > 4 && Num.Length <= 8)
  1030. {
  1031. bb = Convert4(Num.Substring(0, Num.Length - 4)) + "万";
  1032. bb += Convert4(Num.Substring(Num.Length - 4, 4));
  1033. }
  1034. else if (Num.Length > 8 && Num.Length <= 12)
  1035. {
  1036. bb = Convert4(Num.Substring(0, Num.Length - 8)) + "亿";
  1037. if (Convert4(Num.Substring(Num.Length - 8, 4)) == "")
  1038. if (Convert4(Num.Substring(Num.Length - 4, 4)) != "")
  1039. bb += "零";
  1040. else
  1041. bb += "";
  1042. else
  1043. bb += Convert4(Num.Substring(Num.Length - 8, 4)) + "万";
  1044. bb += Convert4(Num.Substring(Num.Length - 4, 4));
  1045. }
  1046. else
  1047. {
  1048. throw new Exception("整数部分最多支持12位");
  1049. }
  1050. return bb;
  1051. }
  1052. /// <summary>
  1053. /// 四位数字的转换
  1054. /// </summary>
  1055. /// <param name="Num">准备转换的四位数字</param>
  1056. /// <returns>转换以后的汉字</returns>
  1057. private static string Convert4(string Num)
  1058. {
  1059. string bb = "";
  1060. if (Num.Length == 1)
  1061. {
  1062. bb = ConvertString(Num);
  1063. }
  1064. else if (Num.Length == 2)
  1065. {
  1066. bb = ConvertString(Num);
  1067. bb = Convert2(bb);
  1068. }
  1069. else if (Num.Length == 3)
  1070. {
  1071. bb = ConvertString(Num);
  1072. bb = Convert3(bb);
  1073. }
  1074. else
  1075. {
  1076. bb = ConvertString(Num);
  1077. string cc = "";
  1078. string len = bb.Substring(0, 4);
  1079. if (len != "零零零零")
  1080. {
  1081. len = bb.Substring(0, 3);
  1082. if (len != "零零零")
  1083. {
  1084. bb = bb.Replace("零零零", "");
  1085. if (bb.Length == 1)
  1086. {
  1087. bb = bb.Substring(0, 1) + "仟";
  1088. }
  1089. else
  1090. {
  1091. if (bb.Substring(0, 1) != "零" && bb.Substring(0, 2) != "零")
  1092. cc = bb.Substring(0, 1) + "仟";
  1093. else
  1094. cc = bb.Substring(0, 1);
  1095. bb = cc + Convert3(bb.Substring(1, 3));
  1096. }
  1097. }
  1098. else
  1099. {
  1100. bb = bb.Replace("零零零", "零");
  1101. }
  1102. }
  1103. else
  1104. {
  1105. bb = bb.Replace("零零零零", "");
  1106. }
  1107. }
  1108. return bb;
  1109. }
  1110. /// <summary>
  1111. /// 将数字转换成汉字
  1112. /// </summary>
  1113. /// <param name="Num">需要转换的数字</param>
  1114. /// <returns>转换后的汉字</returns>
  1115. private static string ConvertString(string Num)
  1116. {
  1117. string bb = "";
  1118. for (int i = 0; i < Num.Length; i++)
  1119. {
  1120. bb += NumChineseCharacter[int.Parse(Num.Substring(i, 1))];
  1121. }
  1122. return bb;
  1123. }
  1124. /// <summary>
  1125. /// 两位数字的转换
  1126. /// </summary>
  1127. /// <param name="Num">两位数字</param>
  1128. /// <returns>转换后的汉字</returns>
  1129. private static string Convert2(string Num)
  1130. {
  1131. string bb = ""; string cc = "";
  1132. string len = Num.Substring(0, 1);
  1133. if (len != "零")
  1134. {
  1135. bb = Num.Replace("零", "");
  1136. if (bb.Length == 1)
  1137. {
  1138. cc = bb.Substring(0, 1) + "拾";
  1139. }
  1140. else
  1141. {
  1142. cc = bb.Substring(0, 1) + "拾";
  1143. cc += bb.Substring(1, 1);
  1144. }
  1145. }
  1146. else
  1147. cc = Num;
  1148. return cc;
  1149. }
  1150. /// <summary>
  1151. /// 三位数字的转换
  1152. /// </summary>
  1153. /// <param name="Num">三位数字</param>
  1154. /// <returns>转换后的汉字</returns>
  1155. private static string Convert3(string Num)
  1156. {
  1157. string bb = ""; string cc = "";
  1158. string len = Num.Substring(0, 2);
  1159. if (len != "零零")
  1160. {
  1161. bb = Num.Replace("零零", "");
  1162. if (bb.Length == 1)
  1163. {
  1164. bb = bb.Substring(0, 1) + "佰";
  1165. }
  1166. else
  1167. {
  1168. if (bb.Substring(0, 1) != "零")
  1169. cc = bb.Substring(0, 1) + "佰";
  1170. else
  1171. cc = bb.Substring(0, 1);
  1172. bb = cc + Convert2(bb.Substring(1, 2));
  1173. }
  1174. }
  1175. else
  1176. {
  1177. bb = Num.Replace("零零", "零");
  1178. }
  1179. return bb;
  1180. }
  1181. #endregion
  1182. #endregion
  1183. #region 数字验证
  1184. /// <summary>
  1185. /// 验证数字字符串
  1186. /// </summary>
  1187. /// <param name="num"></param>
  1188. /// <returns></returns>
  1189. public static bool IsNumeric(this string numStr)
  1190. {
  1191. bool isNumeric = Regex.IsMatch(numStr, @"^\d+$");
  1192. if (isNumeric)
  1193. {
  1194. return true;
  1195. }
  1196. return false;
  1197. }
  1198. #endregion
  1199. #region 日期 格式转换
  1200. /// <summary>
  1201. /// 验证数字字符串
  1202. /// </summary>
  1203. /// <param name="str"></param>
  1204. /// <returns></returns>
  1205. public static string ConvertToDatetime(this string str)
  1206. {
  1207. if (!string.IsNullOrEmpty(str))
  1208. {
  1209. DateTime currentDate = Convert.ToDateTime(str);
  1210. return $"{currentDate.Year}年{currentDate.Month}月{currentDate.Day}日";
  1211. }
  1212. return "";
  1213. }
  1214. #endregion
  1215. #region 月份/季度
  1216. /// <summary>
  1217. /// 获取月份对应的起始天数
  1218. /// </summary>
  1219. /// <param name="year"></param>
  1220. /// <returns></returns>
  1221. public static List<MonthInfo> GetMonthInfos(int year)
  1222. {
  1223. List<MonthInfo> months = new List<MonthInfo>();
  1224. if (year > 1)
  1225. {
  1226. for (int i = 1; i < 13; i++)
  1227. {
  1228. months.Add(new MonthInfo()
  1229. {
  1230. Month = i,
  1231. Days = new DaysInfo() { BeginDays = 1, EndDays = DateTime.DaysInMonth(year, i) }
  1232. });
  1233. }
  1234. }
  1235. return months;
  1236. }
  1237. /// <summary>
  1238. /// 获取季度对应的起始天数
  1239. /// </summary>
  1240. /// <param name="year"></param>
  1241. /// <returns></returns>
  1242. public static List<MonthInfo> GetQuarter(int year)
  1243. {
  1244. List<MonthInfo> months = new List<MonthInfo>();
  1245. months.Add(new MonthInfo() { Month = 1, Days = new DaysInfo() { BeginDays = 1, EndDays = 31 } }); //1.1 - 3.31
  1246. months.Add(new MonthInfo() { Month = 2, Days = new DaysInfo() { BeginDays = 1, EndDays = 31 } }); //4.1 - 6.30
  1247. months.Add(new MonthInfo() { Month = 3, Days = new DaysInfo() { BeginDays = 1, EndDays = 31 } }); //7.1 - 9.31
  1248. months.Add(new MonthInfo() { Month = 4, Days = new DaysInfo() { BeginDays = 1, EndDays = 31 } }); //10.1 - 12.31
  1249. return months;
  1250. }
  1251. public class MonthInfo
  1252. {
  1253. public int Month { get; set; }
  1254. public DaysInfo Days { get; set; }
  1255. }
  1256. public class DaysInfo
  1257. {
  1258. public int BeginDays { get; set; }
  1259. public int EndDays { get; set; }
  1260. }
  1261. #endregion
  1262. #region op行程单,黑屏幕代码
  1263. public static string GetCountryStandingTime(int diId)
  1264. {
  1265. DataTable datas = GetTableByBlackCode(diId);
  1266. string countryStr = "[黑屏代码未录入].";
  1267. if (datas.Rows.Count > 0)
  1268. {
  1269. var airDatas = from row in datas.AsEnumerable()
  1270. select new
  1271. {
  1272. Three = row.Field<string>("Three"),
  1273. Day = row.Field<string>("Day"),
  1274. ArrivedDate = row.Field<string>("ArrivedDate"),
  1275. };
  1276. //三字码信息
  1277. List<Res_ThreeCode> listcode = _dirRep._sqlSugar.Queryable<Res_ThreeCode>().Where(x => x.IsDel == 0).ToList();
  1278. //string countryStr = "";
  1279. int index = 0;
  1280. List<string> cityCodes = new List<string>();
  1281. //去掉开始和结束城市
  1282. foreach (var row in airDatas)
  1283. {
  1284. if (!string.IsNullOrEmpty(row.Three))
  1285. {
  1286. if (index == 0) cityCodes.Add(row.Three.Substring(3, 3)); //到达国家
  1287. else if (airDatas.Count() - 1 == index) cityCodes.Add(row.Three.Substring(0, 3)); //到达国家
  1288. else cityCodes.Add(row.Three.Substring(0, 3)); //到达国家
  1289. }
  1290. index++;
  1291. }
  1292. cityCodes = cityCodes.Distinct().ToList();
  1293. if (cityCodes.Count > 0) countryStr = "";
  1294. foreach (var item in cityCodes)
  1295. {
  1296. var airData = airDatas.Where(it => it.Three.Contains(item)).ToList();
  1297. string country = listcode.Find(it => it.Three.Equals(item))?.Country ?? "Unknown";
  1298. if (country.Equals("中国"))
  1299. {
  1300. country = listcode.Find(it => it.Three.Equals(item))?.City ?? "Unknown";
  1301. }
  1302. int days = 0;
  1303. if (airData.Count == 2)
  1304. {
  1305. DateTime arr_dt = Convert.ToDateTime(airData[0].ArrivedDate); //抵达时间
  1306. DateTime dep_dt = Convert.ToDateTime(airData[1].Day); //离开时间
  1307. days = (dep_dt - arr_dt).Days;
  1308. //countryStr += $@"{country}停留{days}日、";
  1309. countryStr += $@"{country}停留 日、";
  1310. }
  1311. }
  1312. if (countryStr.Length > 0) countryStr = countryStr.Substring(0, countryStr.Length - 1);
  1313. }
  1314. return countryStr;
  1315. }
  1316. /// <summary>
  1317. ///根据机票黑屏代码整理DataTable
  1318. /// </summary>
  1319. /// <param name="diid"></param>
  1320. /// <returns></returns>
  1321. public static DataTable GetTableByBlackCode1(int diid)
  1322. {
  1323. //黑屏代码信息
  1324. List<Air_TicketBlackCode> listcode = _dirRep._sqlSugar.Queryable<Air_TicketBlackCode>().Where(x => x.DiId == diid && x.IsDel == 0).ToList();
  1325. //测试数据为序号,航班号,起飞日期,三字码,起飞时刻,到达时刻,出发航站楼,到达航站楼,机型,飞行时间
  1326. //1.3U8391 TU17NOV CTUCAI 0220 0715 T1 T2 330 10H55M
  1327. DataTable dt = new DataTable();
  1328. dt.Columns.Add("Fliagtcode", typeof(string)); //航班号
  1329. dt.Columns.Add("Date", typeof(string));//起飞日期
  1330. dt.Columns.Add("Three", typeof(string));//三字码
  1331. dt.Columns.Add("StartTime", typeof(string));//起飞时刻
  1332. dt.Columns.Add("EndTime", typeof(string));//到达时刻
  1333. dt.Columns.Add("StartBuilding", typeof(string));//出发航站楼
  1334. dt.Columns.Add("EndBuilding", typeof(string));//到达航站楼
  1335. dt.Columns.Add("AirModel", typeof(string)); //机型
  1336. dt.Columns.Add("FlightTime", typeof(string));//飞行时间
  1337. dt.Columns.Add("Day", typeof(string));//整理的起飞日期;作为排序依据
  1338. dt.Columns.Add("ArrivedDate", typeof(string));//整理的到达日期
  1339. dt.Columns.Add("Error", typeof(string));//整理的到达日期
  1340. dt.Columns.Add("Sign", typeof(string));//标识:0表示为原生黑屏代码、1表示“+1”新增的黑屏代码
  1341. //判断是否录入黑屏代码
  1342. if (listcode.Count() == 0 || listcode == null)
  1343. {
  1344. dt.Rows.Add(null, null, null, null, null, null, null, null, null, null, null, "黑屏代码未录入!", null);
  1345. }
  1346. else
  1347. {
  1348. //读取单段黑屏代码
  1349. for (int i = 0; i < listcode.Count; i++)
  1350. {
  1351. //去除序号
  1352. string[] CodeList = Regex.Split(listcode[i].BlackCode, "\\d+\\.", RegexOptions.IgnoreCase);
  1353. //去除多余空格,方法一Linq扩展方法
  1354. CodeList = CodeList.Where(str => str != "").ToArray();
  1355. CodeList = CodeList.Where(str => str != " ").ToArray();
  1356. //年
  1357. int year = Convert.ToInt32(DateTime.Now.Year.ToString());
  1358. //读取单条黑屏代码
  1359. for (int j = 0; j < CodeList.Count(); j++)
  1360. {
  1361. //去除多余空格,方法二使用Split()方法进行分割,分割有一个选项是RemoveEmptyEntries
  1362. CodeList[j] = CodeList[j].Replace("\r\n", string.Empty).Replace("\\r\\n", string.Empty).TrimStart().TrimEnd();
  1363. string[] Info = CodeList[j].Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
  1364. //string[] Info = CodeList[j].Replace("\r\n", string.Empty).Replace("\\r\\n", string.Empty)
  1365. // .TrimStart().TrimEnd().Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
  1366. //去除多余空格
  1367. Info = Info.Where(str => str != "").ToArray();
  1368. Info = Info.Where(str => str != " ").ToArray();
  1369. //判断黑屏代码是否正确拆分; 理应拆成9段
  1370. if (Info.Count() < 9)
  1371. {
  1372. dt.Rows.Add(null, null, null, null, null, null, null, null, null, null, null, "本团组第" + (i + 1) + "段黑屏代码中第" + (j + 1) + " 条有误,请联系机票同事核对", null);
  1373. }
  1374. else
  1375. {
  1376. try
  1377. {
  1378. //月
  1379. int month = Convert.ToInt32(GetLonger(Info[1].Substring(4, 3)));
  1380. //日
  1381. int day = Convert.ToInt32(Info[1].Substring(2, 2));
  1382. #region 逐一比较月份,判断是否翻年;逐一比较三字码顶真,判断是否跑错机场
  1383. if (j > 0)
  1384. {
  1385. string[] Temp = CodeList[j - 1].Replace("\r\n", string.Empty).Replace("\\r\\n", string.Empty)
  1386. .TrimStart().TrimEnd().Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
  1387. Temp = Temp.Where(str => str != "").ToArray();
  1388. Temp = Temp.Where(str => str != " ").ToArray();
  1389. int monthTemp = Convert.ToInt32(GetLonger(Temp[1].Substring(4, 3)));
  1390. // 如果相邻月份之差小于0,则证明次一条年份需+1
  1391. if (month - monthTemp < 0)
  1392. {
  1393. year = year + 1;
  1394. }
  1395. //如果相邻代码三字码不顶真,提醒
  1396. string FootThree = Temp[2].Substring(3, 3);
  1397. string HeadThree = Info[2].Substring(0, 3);
  1398. if (FootThree != HeadThree)
  1399. {
  1400. //DelegationInfoService s = new DelegationInfoService();
  1401. //UsersService us = new UsersService();
  1402. //GroupsTaskAssignmentService gts = new GroupsTaskAssignmentService();
  1403. //77 行程
  1404. List<Grp_GroupsTaskAssignment> list2 = _dirRep._sqlSugar.Queryable<Grp_GroupsTaskAssignment>().Where(x => x.CTId == 77 && x.DIId == diid && x.IsDel == 0).ToList();
  1405. foreach (var temp in list2)
  1406. {
  1407. //if (temp.UId != 21)
  1408. //SendAndReturn(us.GetUsersByID(temp.UId).Email,
  1409. // "黑屏代码提醒",
  1410. // s.GetDelegationInfoByID(diid).TeamName + "的机票黑屏代码中,相邻航段的三字码不连续,请查看!");
  1411. }
  1412. //85 机票预订
  1413. List<Grp_GroupsTaskAssignment> list6 = _dirRep._sqlSugar.Queryable<Grp_GroupsTaskAssignment>().Where(x => x.CTId == 85 && x.DIId == diid && x.IsDel == 0).ToList();
  1414. foreach (var temp in list6)
  1415. {
  1416. //if (temp.UId != 21)
  1417. //SendAndReturn(us.GetUsersByID(temp.UId).Email,
  1418. // "黑屏代码提醒",
  1419. // s.GetDelegationInfoByID(diid).TeamName + "的机票黑屏代码中,相邻航段的三字码不连续,请查看!");
  1420. }
  1421. }
  1422. }
  1423. #endregion
  1424. #region 判断到达日期是否需要加1
  1425. if (Info[4].Contains("+"))
  1426. {
  1427. //日期+1
  1428. day = day + 1;
  1429. //判断是否进入下一月
  1430. if (day > Convert.ToInt32(GetDaysByMonth(Info[1].Substring(4, 3), year)))
  1431. {
  1432. day = day - Convert.ToInt32(GetDaysByMonth(Info[1].Substring(4, 3), year));
  1433. month = month + 1;
  1434. //判断是否进入下一年
  1435. if (month > 12)
  1436. {
  1437. month = month - 12;
  1438. year = year + 1;
  1439. }
  1440. }
  1441. //月份整理格式
  1442. string monthTemp = month.ToString();
  1443. if (month < 10)
  1444. {
  1445. monthTemp = "0" + monthTemp;
  1446. }
  1447. //日期整理格式
  1448. string daytemp = day.ToString();
  1449. if (day < 10)
  1450. {
  1451. daytemp = "0" + daytemp;
  1452. }
  1453. string temp = Info[4].Split('+')[0];
  1454. //添加起飞数据
  1455. dt.Rows.Add(Info[0],
  1456. Info[1],
  1457. Info[2],
  1458. Info[3],
  1459. temp,
  1460. Info[5],
  1461. Info[6],
  1462. Info[7],
  1463. Info[8],
  1464. year + "-" + GetLonger(Info[1].Substring(4, 3)) + "-" + Info[1].Substring(2, 2),
  1465. year + "-" + monthTemp + "-" + daytemp,
  1466. "",
  1467. "0");
  1468. //加1天,添加到达数据
  1469. dt.Rows.Add(Info[0],
  1470. Info[1].Replace(Info[1].Substring(2, 2), daytemp),
  1471. Info[2],
  1472. Info[3],
  1473. temp,
  1474. Info[5],
  1475. Info[6],
  1476. Info[7],
  1477. Info[8],
  1478. year + "-" + monthTemp + "-" + daytemp,
  1479. year + "-" + monthTemp + "-" + daytemp,
  1480. "",
  1481. "1");
  1482. }
  1483. else
  1484. {
  1485. //月份整理格式
  1486. string monthTemp = month.ToString();
  1487. if (month < 10)
  1488. {
  1489. monthTemp = "0" + monthTemp;
  1490. }
  1491. //日期整理格式
  1492. string daytemp = day.ToString();
  1493. if (day < 10)
  1494. {
  1495. daytemp = "0" + daytemp;
  1496. }
  1497. dt.Rows.Add(Info[0],
  1498. Info[1],
  1499. Info[2],
  1500. Info[3],
  1501. Info[4],
  1502. Info[5],
  1503. Info[6],
  1504. Info[7],
  1505. Info[8],
  1506. year + "-" + monthTemp + "-" + daytemp,
  1507. year + "-" + monthTemp + "-" + daytemp,
  1508. "",
  1509. "0");
  1510. }
  1511. #endregion
  1512. }
  1513. catch (Exception ex)
  1514. {
  1515. string exstr = ex.Message.ToString();
  1516. }
  1517. }
  1518. }
  1519. //排序
  1520. dt.DefaultView.Sort = "Day asc";
  1521. dt = dt.DefaultView.ToTable();
  1522. }
  1523. }
  1524. return dt;
  1525. }
  1526. private readonly static string[] excludeArr = new string[] { "[中转]", };
  1527. /// <summary>
  1528. ///根据机票黑屏代码整理DataTable
  1529. /// </summary>
  1530. /// <param name="diid"></param>
  1531. /// <returns></returns>
  1532. public static DataTable GetTableByBlackCode(int diid)
  1533. {
  1534. //黑屏代码信息
  1535. List<Air_TicketBlackCode> listcode = _dirRep._sqlSugar.Queryable<Air_TicketBlackCode>().Where(x => x.DiId == diid && x.IsDel == 0).ToList();
  1536. //测试数据为序号,航班号,起飞日期,三字码,起飞时刻,到达时刻,出发航站楼,到达航站楼,机型,飞行时间
  1537. //1.3U8391 TU17NOV CTUCAI 0220 0715 T1 T2 330 10H55M
  1538. DataTable dt = new DataTable();
  1539. dt.Columns.Add("Fliagtcode", typeof(string)); //航班号
  1540. dt.Columns.Add("Date", typeof(string));//起飞日期
  1541. dt.Columns.Add("Three", typeof(string));//三字码
  1542. dt.Columns.Add("StartTime", typeof(string));//起飞时刻
  1543. dt.Columns.Add("EndTime", typeof(string));//到达时刻
  1544. dt.Columns.Add("StartBuilding", typeof(string));//出发航站楼
  1545. dt.Columns.Add("EndBuilding", typeof(string));//到达航站楼
  1546. dt.Columns.Add("AirModel", typeof(string)); //机型
  1547. dt.Columns.Add("FlightTime", typeof(string));//飞行时间
  1548. dt.Columns.Add("Day", typeof(string));//整理的起飞日期;作为排序依据
  1549. dt.Columns.Add("ArrivedDate", typeof(string));//整理的到达日期
  1550. dt.Columns.Add("Error", typeof(string));//整理的到达日期
  1551. dt.Columns.Add("Sign", typeof(string));//标识:0表示为原生黑屏代码、1表示“+1”新增的黑屏代码
  1552. //添加转机标识
  1553. dt.Columns.Add("isTransitShipment", typeof(bool));
  1554. //判断是否录入黑屏代码
  1555. if (listcode.Count() == 0 || listcode == null)
  1556. {
  1557. dt.Rows.Add(null, null, null, null, null, null, null, null, null, null, null, "黑屏代码未录入!", null, false);
  1558. }
  1559. else
  1560. {
  1561. //读取单段黑屏代码
  1562. for (int i = 0; i < listcode.Count; i++)
  1563. {
  1564. //去除序号
  1565. string[] CodeList = Regex.Split(listcode[i].BlackCode, "\\d+\\.", RegexOptions.IgnoreCase);
  1566. //去除多余空格,方法一Linq扩展方法
  1567. CodeList = CodeList.Where(str => !string.IsNullOrWhiteSpace(str)).ToArray();
  1568. //读取单条黑屏代码
  1569. for (int j = 0; j < CodeList.Count(); j++)
  1570. {
  1571. //去除多余空格,方法二使用Split()方法进行分割,分割有一个选项是RemoveEmptyEntries
  1572. CodeList[j] = CodeList[j].Replace("\r\n", string.Empty).Replace("\\r\\n", string.Empty).TrimStart().TrimEnd();
  1573. string[] Info = CodeList[j].Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
  1574. //去除多余空格
  1575. Info = Info.Where(str => !string.IsNullOrWhiteSpace(str)).ToArray();
  1576. //判断黑屏代码是否正确拆分; 理应拆成9段
  1577. if (Info.TakeWhile((x) =>
  1578. {
  1579. return !excludeArr.Contains(x);
  1580. }).Count() != 9)
  1581. {
  1582. dt.Rows.Add(null, null, null, null, null, null, null, null, null, null, null, "本团组第" + (i + 1) + "段黑屏代码中第" + (j + 1) + " 条有误,请联系机票同事核对", null, false);
  1583. //MessageBoxEx.Show("第" + (i + 1) + "段黑屏代码中第" + (j + 1) + " 条有误, 请联系机票同事核对");
  1584. return dt;
  1585. }
  1586. else
  1587. {
  1588. try
  1589. {
  1590. var monthEn = Info[1].Substring(4, 3);
  1591. //月
  1592. int month = Convert.ToInt32(GetLonger(monthEn));
  1593. //日
  1594. int day = Convert.ToInt32(Info[1].Substring(2, 2));
  1595. var time = new DateTime(2023, month, day); //
  1596. var isExist = Info.Contains("[中转]");
  1597. //dt.Columns.Add("Fliagtcode", typeof(string)); //航班号
  1598. //dt.Columns.Add("Date", typeof(string));//起飞日期
  1599. //dt.Columns.Add("Three", typeof(string));//三字码
  1600. //dt.Columns.Add("StartTime", typeof(string));//起飞时刻
  1601. //dt.Columns.Add("EndTime", typeof(string));//到达时刻
  1602. //dt.Columns.Add("StartBuilding", typeof(string));//出发航站楼
  1603. //dt.Columns.Add("EndBuilding", typeof(string));//到达航站楼
  1604. //dt.Columns.Add("AirModel", typeof(string)); //机型
  1605. //dt.Columns.Add("FlightTime", typeof(string));//飞行时间
  1606. //dt.Columns.Add("Day", typeof(string));//整理的起飞日期;作为排序依据
  1607. //dt.Columns.Add("ArrivedDate", typeof(string));//整理的到达日期
  1608. //dt.Columns.Add("Error", typeof(string));//整理的到达日期
  1609. //dt.Columns.Add("Sign", typeof(string));//标识:0表示为原生黑屏代码、1表示“+1”新增的黑屏代码
  1610. dt.Rows.Add(Info[0],
  1611. Info[1],
  1612. Info[2],
  1613. Info[3],
  1614. Info[4],
  1615. Info[5],
  1616. Info[6],
  1617. Info[7],
  1618. Info[8],
  1619. time.ToString("yyyy-MM-dd"),
  1620. time.ToString("yyyy-MM-dd"),
  1621. "",
  1622. "0",
  1623. isExist
  1624. );
  1625. }
  1626. catch (Exception ex)
  1627. {
  1628. string exstr = ex.Message.ToString();
  1629. }
  1630. }
  1631. }
  1632. //排序
  1633. dt.DefaultView.Sort = "Day asc";
  1634. dt = dt.DefaultView.ToTable();
  1635. }
  1636. }
  1637. return dt;
  1638. }
  1639. /// <summary>
  1640. /// 根据星期,月份的缩写,转换成数字或者全称
  1641. /// 根据币种中文名称返回币种代码
  1642. /// 根据数字返回机型型号【2、3开头的就是空客,比如空客320,7开头的就是波音,比如波音777】
  1643. /// 20210903贾文滔
  1644. /// </summary>
  1645. /// <param name="startDate"></param>
  1646. /// <param name="endDate"></param>
  1647. /// <returns></returns>
  1648. public static string GetLonger(string temp)
  1649. {
  1650. string str = "";
  1651. switch (temp.ToUpper())
  1652. {
  1653. case "美元":
  1654. str = "USD";
  1655. break;
  1656. case "日元":
  1657. str = "JPY";
  1658. break;
  1659. case "英镑":
  1660. str = "GBP";
  1661. break;
  1662. case "欧元":
  1663. str = "EUR";
  1664. break;
  1665. case "港币":
  1666. str = "HKD";
  1667. break;
  1668. case "MO":
  1669. str = "星期一";
  1670. break;
  1671. case "TU":
  1672. str = "星期二";
  1673. break;
  1674. case "WE":
  1675. str = "星期三";
  1676. break;
  1677. case "TH":
  1678. str = "星期四";
  1679. break;
  1680. case "FR":
  1681. str = "星期五";
  1682. break;
  1683. case "SA":
  1684. str = "星期六";
  1685. break;
  1686. case "SU":
  1687. str = "星期天";
  1688. break;
  1689. case "JAN":
  1690. str = "01";
  1691. break;
  1692. case "FEB":
  1693. str = "02";
  1694. break;
  1695. case "MAR":
  1696. str = "03";
  1697. break;
  1698. case "APR":
  1699. str = "04";
  1700. break;
  1701. case "MAY":
  1702. str = "05";
  1703. break;
  1704. case "JUN":
  1705. str = "06";
  1706. break;
  1707. case "JUL":
  1708. str = "07";
  1709. break;
  1710. case "AUG":
  1711. str = "08";
  1712. break;
  1713. case "SEP":
  1714. str = "09";
  1715. break;
  1716. case "OCT":
  1717. str = "10";
  1718. break;
  1719. case "NOV":
  1720. str = "11";
  1721. break;
  1722. case "DEC":
  1723. str = "12";
  1724. break;
  1725. case "MONDAY":
  1726. str = "星期一";
  1727. break;
  1728. case "TUESDAY":
  1729. str = "星期二";
  1730. break;
  1731. case "WEDNESDAY":
  1732. str = "星期三";
  1733. break;
  1734. case "THURSDAY":
  1735. str = "星期四";
  1736. break;
  1737. case "FRIDAY":
  1738. str = "星期五";
  1739. break;
  1740. case "SATURDAY":
  1741. str = "星期六";
  1742. break;
  1743. case "SUNDAY":
  1744. str = "星期日";
  1745. break;
  1746. case "01":
  1747. str = "JAN";
  1748. break;
  1749. case "02":
  1750. str = "FEB";
  1751. break;
  1752. case "03":
  1753. str = "MAR";
  1754. break;
  1755. case "04":
  1756. str = "APR";
  1757. break;
  1758. case "05":
  1759. str = "MAY";
  1760. break;
  1761. case "06":
  1762. str = "JUN";
  1763. break;
  1764. case "07":
  1765. str = "JUL";
  1766. break;
  1767. case "08":
  1768. str = "AUG";
  1769. break;
  1770. case "09":
  1771. str = "SEP";
  1772. break;
  1773. case "10":
  1774. str = "OCT";
  1775. break;
  1776. case "11":
  1777. str = "NOV";
  1778. break;
  1779. case "12":
  1780. str = "DEC";
  1781. break;
  1782. case "2":
  1783. str = "空客A";
  1784. break;
  1785. case "3":
  1786. str = "空客A";
  1787. break;
  1788. case "7":
  1789. str = "波音";
  1790. break;
  1791. }
  1792. return str;
  1793. }
  1794. /// <summary>
  1795. /// 根据月份返回天数
  1796. /// </summary>
  1797. /// <param name="temp"></param>
  1798. /// <returns></returns>
  1799. public static string GetDaysByMonth(string Month, int year)
  1800. {
  1801. string str = "";
  1802. //判断是否是闰年
  1803. if (DateTime.IsLeapYear(year) == false)
  1804. {
  1805. switch (Month.ToUpper())
  1806. {
  1807. case "JAN":
  1808. str = "31";
  1809. break;
  1810. case "FEB":
  1811. str = "28";
  1812. break;
  1813. case "MAR":
  1814. str = "31";
  1815. break;
  1816. case "APR":
  1817. str = "30";
  1818. break;
  1819. case "MAY":
  1820. str = "31";
  1821. break;
  1822. case "JUN":
  1823. str = "30";
  1824. break;
  1825. case "JUL":
  1826. str = "31";
  1827. break;
  1828. case "AUG":
  1829. str = "31";
  1830. break;
  1831. case "SEP":
  1832. str = "30";
  1833. break;
  1834. case "OCT":
  1835. str = "31";
  1836. break;
  1837. case "NOV":
  1838. str = "30";
  1839. break;
  1840. case "DEC":
  1841. str = "31";
  1842. break;
  1843. case "01":
  1844. str = "31";
  1845. break;
  1846. case "02":
  1847. str = "28";
  1848. break;
  1849. case "03":
  1850. str = "31";
  1851. break;
  1852. case "04":
  1853. str = "30";
  1854. break;
  1855. case "05":
  1856. str = "31";
  1857. break;
  1858. case "06":
  1859. str = "30";
  1860. break;
  1861. case "07":
  1862. str = "31";
  1863. break;
  1864. case "08":
  1865. str = "31";
  1866. break;
  1867. case "09":
  1868. str = "30";
  1869. break;
  1870. case "10":
  1871. str = "31";
  1872. break;
  1873. case "11":
  1874. str = "30";
  1875. break;
  1876. case "12":
  1877. str = "31";
  1878. break;
  1879. }
  1880. }
  1881. else
  1882. {
  1883. switch (Month.ToUpper())
  1884. {
  1885. case "JAN":
  1886. str = "31";
  1887. break;
  1888. case "FEB":
  1889. str = "29";
  1890. break;
  1891. case "MAR":
  1892. str = "31";
  1893. break;
  1894. case "APR":
  1895. str = "30";
  1896. break;
  1897. case "MAY":
  1898. str = "31";
  1899. break;
  1900. case "JUN":
  1901. str = "30";
  1902. break;
  1903. case "JUL":
  1904. str = "31";
  1905. break;
  1906. case "AUG":
  1907. str = "31";
  1908. break;
  1909. case "SEP":
  1910. str = "30";
  1911. break;
  1912. case "OCT":
  1913. str = "31";
  1914. break;
  1915. case "NOV":
  1916. str = "30";
  1917. break;
  1918. case "DEC":
  1919. str = "31";
  1920. break;
  1921. case "01":
  1922. str = "31";
  1923. break;
  1924. case "02":
  1925. str = "29";
  1926. break;
  1927. case "03":
  1928. str = "31";
  1929. break;
  1930. case "04":
  1931. str = "30";
  1932. break;
  1933. case "05":
  1934. str = "31";
  1935. break;
  1936. case "06":
  1937. str = "30";
  1938. break;
  1939. case "07":
  1940. str = "31";
  1941. break;
  1942. case "08":
  1943. str = "31";
  1944. break;
  1945. case "09":
  1946. str = "30";
  1947. break;
  1948. case "10":
  1949. str = "31";
  1950. break;
  1951. case "11":
  1952. str = "30";
  1953. break;
  1954. case "12":
  1955. str = "31";
  1956. break;
  1957. }
  1958. }
  1959. return str;
  1960. }
  1961. /// <summary>
  1962. /// op行程单 团组 城市路径
  1963. /// </summary>
  1964. /// <param name="diid">团组Id</param>
  1965. /// <param name="separator">分隔符</param>
  1966. /// <returns></returns>
  1967. public static string GetGroupCityLine(int diid, string separator)
  1968. {
  1969. string city = string.Empty;
  1970. var blackCode = _dirRep._sqlSugar.Queryable<Air_TicketBlackCode>().Where(x => x.IsDel == 0 && x.DiId == diid).ToList();
  1971. if (blackCode.Count > 0)
  1972. {
  1973. var black = blackCode.First();
  1974. black.BlackCode = black.BlackCode == null ? "" : black.BlackCode;
  1975. var blackSp = Regex.Split(black.BlackCode, "\\d+\\.", RegexOptions.IgnoreCase).Where(x => !string.IsNullOrWhiteSpace(x)).ToArray();
  1976. if (blackSp.Length > 0)
  1977. {
  1978. try
  1979. {
  1980. var cityArrCode = new List<string>(20);
  1981. foreach (var item in blackSp)
  1982. {
  1983. var itemSp = item.Split(' ').Where(x => !string.IsNullOrWhiteSpace(x)).ToList();
  1984. var IndexSelect = itemSp[2];
  1985. var cityArrCodeLength = cityArrCode.Count - 1;
  1986. var startCity = IndexSelect.Substring(0, 3);
  1987. if (cityArrCodeLength > 0)
  1988. {
  1989. var arrEndCity = cityArrCode[cityArrCodeLength];
  1990. if (arrEndCity != startCity)
  1991. {
  1992. cityArrCode.Add(startCity.ToUpper());
  1993. }
  1994. }
  1995. else
  1996. {
  1997. cityArrCode.Add(startCity.ToUpper());
  1998. }
  1999. var endCity = IndexSelect.Substring(3, 3);
  2000. cityArrCode.Add(endCity.ToUpper());
  2001. }
  2002. var cityThree = string.Empty;
  2003. cityArrCode.ForEach(x => cityThree += "'" + x + "',");
  2004. cityThree = cityThree.TrimEnd(',');
  2005. if (string.IsNullOrWhiteSpace(cityThree))
  2006. {
  2007. throw new Exception("error");
  2008. }
  2009. string sql = $"SELECT * FROM Res_ThreeCode rtc WHERE UPPER(rtc.Three) in ({cityThree}) ";
  2010. var cityArr = _dirRep._sqlSugar.SqlQueryable<Res_ThreeCode>(sql).ToList();
  2011. foreach (var item in cityArrCode)
  2012. {
  2013. var find = cityArr.Find(x => x.Three.ToUpper() == item.ToUpper());
  2014. if (find != null)
  2015. {
  2016. city += find.City + separator;
  2017. }
  2018. else
  2019. {
  2020. city += item + "[三字码未收录]" + separator;
  2021. }
  2022. }
  2023. city = city.TrimEnd(char.Parse(separator));
  2024. }
  2025. catch (Exception e)
  2026. {
  2027. city = "[黑屏代码格式不正确!]";
  2028. }
  2029. }
  2030. }
  2031. else city = "[未录入黑屏代码]";
  2032. return city;
  2033. }
  2034. /// <summary>
  2035. /// 获取黑屏代码日期列表
  2036. /// </summary>
  2037. /// <param name="dt"></param>
  2038. /// <returns></returns>
  2039. public static List<string> GetTimeListByDataTable(DataTable dt)
  2040. {
  2041. DateTime datestart = Convert.ToDateTime(dt.Rows[0]["Day"].ToString());
  2042. DateTime dateend = Convert.ToDateTime(dt.Rows[dt.Rows.Count - 1]["ArrivedDate"].ToString());
  2043. List<string> timeList = new List<string>();
  2044. while (datestart <= dateend)
  2045. {
  2046. timeList.Add(datestart.ToString("yyyy-MM-dd"));
  2047. datestart = datestart.AddDays(1);
  2048. }
  2049. return timeList;
  2050. }
  2051. const decimal conversion = 1.61M;
  2052. /// <summary>
  2053. /// 简要行程
  2054. /// </summary>
  2055. /// <param name="diid"></param>
  2056. /// <returns></returns>
  2057. public static Result GetBriefStroke (int diid)
  2058. {
  2059. DataTable resultTable = GetTableByBlackCode(diid);
  2060. if (resultTable == null)
  2061. {
  2062. return new Result { Code = -1, Msg = "黑屏代码有误或黑屏代码未录入" };
  2063. }
  2064. if (resultTable.Rows.Count == 0 || string.IsNullOrWhiteSpace(resultTable.Rows[0][1].ToString()))
  2065. {
  2066. string msg = string.Empty;
  2067. if (resultTable.Rows.Count > 0)
  2068. {
  2069. msg = resultTable.Rows[0]["Error"].ToString();
  2070. }
  2071. return new Result { Code = -1, Msg = $"黑屏代码有误;{msg}" };
  2072. }
  2073. var timeArr = GetTimeListByDataTable(resultTable);
  2074. var threeCodes = _dirRep._sqlSugar.Queryable<Res_ThreeCode>().Where(it => it.IsDel == 0).ToList(); //三字码
  2075. var airCompanys = _dirRep._sqlSugar.Queryable<Res_AirCompany>().Where(it => it.IsDel == 0).ToList(); //航司公司
  2076. var obDatas = _dirRep._sqlSugar.Queryable<Res_OfficialActivities>().Where(it => it.IsDel == 0 && it.DiId == diid).ToList(); //公务信息
  2077. var NewListTravel = new List<Grp_TravelList>();
  2078. var index = 0;
  2079. var stopCity = string.Empty;
  2080. foreach (var item in timeArr)
  2081. {
  2082. string trip = string.Empty;
  2083. string weekDay = string.Empty;
  2084. DateTime time = DateTime.Now;
  2085. if (DateTime.TryParse(item, out time))
  2086. {
  2087. weekDay = weekdays[(int)time.DayOfWeek];
  2088. }
  2089. else
  2090. {
  2091. weekDay = "日期格式不正确!";
  2092. }
  2093. var empty = "【未收入该三字码!请机票同事录入】";
  2094. var tabSelect = resultTable.Select(string.Format("Day = '{0}'", item));
  2095. var isMoreTraffic = false;
  2096. if (tabSelect.Length > 0)
  2097. {
  2098. isMoreTraffic = true;
  2099. var takeOffTime = DateTime.Parse(item);
  2100. var fallToTime = DateTime.Parse(item);
  2101. Res_ThreeCode start_Object = null;
  2102. Res_ThreeCode end_Object = null;
  2103. bool isTrade = false;
  2104. //air 处理
  2105. foreach (var tabRow in tabSelect)
  2106. {
  2107. takeOffTime = DateTime.Parse(item);
  2108. fallToTime = DateTime.Parse(item);
  2109. var takeOff = tabRow["StartTime"].ToString();
  2110. var fallTo = tabRow["EndTime"].ToString();
  2111. takeOffTime = takeOffTime.AddHours(int.Parse(takeOff.Substring(0, 2)));
  2112. takeOffTime = takeOffTime.AddMinutes(int.Parse(takeOff.Substring(2, 2)));
  2113. fallToTime = fallToTime.AddHours(int.Parse(fallTo.Substring(0, 2)));
  2114. fallToTime = fallToTime.AddMinutes(int.Parse(fallTo.Substring(2, 2)));
  2115. var threeCode = tabRow["Three"].ToString();
  2116. var start = threeCode.Substring(0, 3);
  2117. var end = threeCode.Substring(3, 3);
  2118. stopCity = end;
  2119. start_Object = threeCodes.Find(x => x.Three.ToUpper() == start.ToUpper());
  2120. end_Object = threeCodes.Find(x => x.Three.ToUpper() == end.ToUpper());
  2121. if (start_Object == null)
  2122. {
  2123. start_Object = new Res_ThreeCode()
  2124. {
  2125. AirPort = empty,
  2126. AirPort_En = empty,
  2127. City = empty,
  2128. Country = empty,
  2129. Four = empty,
  2130. Three = empty,
  2131. };
  2132. }
  2133. if (end_Object == null)
  2134. {
  2135. end_Object = new Res_ThreeCode()
  2136. {
  2137. AirPort = empty,
  2138. AirPort_En = empty,
  2139. City = empty,
  2140. Country = empty,
  2141. Four = empty,
  2142. Three = empty,
  2143. };
  2144. }
  2145. //航班号
  2146. string flightcode = tabRow["Fliagtcode"].ToString();
  2147. trip += $"{takeOffTime.ToString("HH:mm")}—{fallToTime.ToString("HH:mm")} {start_Object.City}—{end_Object.City} 航班号:{flightcode}\r\n";
  2148. }
  2149. //var airArrive = fallToTime; //航班落地时间
  2150. time = fallToTime.AddHours(1.5); //出机场一个半小时
  2151. string Time = string.Empty;
  2152. string Distance = string.Empty;
  2153. int GetGoogleResult = 0;
  2154. int GetDistResult = 0;
  2155. JObject Result = null;
  2156. try
  2157. {
  2158. Time = Result["routes"][0]["legs"][0]["duration"]["text"].ToString().Replace(" ", "").Trim();
  2159. Distance = Result["routes"][0]["legs"][0]["distance"]["text"].ToString().Replace(" ", "").Trim();
  2160. if (Time.Contains("hours"))
  2161. {
  2162. Time = Time.Replace("hours", "小时");
  2163. }
  2164. if (Time.Contains("hour"))
  2165. {
  2166. Time = Time.Replace("hour", "小时");
  2167. }
  2168. Time = Time.Replace("mins", "分钟");
  2169. if (Distance.Contains("mi"))
  2170. {
  2171. var distSp = Regex.Split(Distance, "mi");
  2172. if (distSp.Length > 0)
  2173. {
  2174. Distance = (decimal.Parse(distSp[0]) * conversion).ToString("#0.00") + " 公里";
  2175. }
  2176. }
  2177. if (Distance.Contains("km"))
  2178. {
  2179. Distance = Distance.Replace("km", "公里");
  2180. }
  2181. if (Time.Contains("小时"))
  2182. {
  2183. var xs = Regex.Split(Time, "小时");
  2184. var xsValue = int.Parse(xs[0]);
  2185. var fz = Regex.Split(xs[1], "分钟");
  2186. var fzValue = int.Parse(fz[0]);
  2187. GetGoogleResult = xsValue * 60;
  2188. GetGoogleResult += fzValue;
  2189. }
  2190. else if (Time.Contains("分钟"))
  2191. {
  2192. GetGoogleResult = int.Parse(Regex.Split(Time, "分钟")[0]);
  2193. }
  2194. if (Distance.Contains("公里"))
  2195. {
  2196. GetDistResult = (int)decimal.Parse(Regex.Split(Distance, "公里")[0]);
  2197. }
  2198. if (GetGoogleResult > 0 && GetGoogleResult % 5 != 0)
  2199. {
  2200. while (GetGoogleResult % 5 != 0)
  2201. {
  2202. GetGoogleResult++;
  2203. }
  2204. }
  2205. if (GetDistResult % 5 != 0 && GetDistResult > 0)
  2206. {
  2207. while (GetDistResult % 5 != 0)
  2208. {
  2209. GetDistResult++;
  2210. }
  2211. }
  2212. int H = (GetGoogleResult / 60);
  2213. int m = (GetGoogleResult % 60);
  2214. string TimeStr = string.Empty;
  2215. if (H != 0)
  2216. {
  2217. if (H < 10)
  2218. {
  2219. TimeStr += "0" + H + "小时";
  2220. }
  2221. else
  2222. {
  2223. TimeStr += H + "小时";
  2224. }
  2225. }
  2226. if (m < 10)
  2227. {
  2228. TimeStr += "0" + m + "分钟";
  2229. }
  2230. else
  2231. {
  2232. TimeStr += m + "分钟";
  2233. }
  2234. Time = TimeStr;
  2235. Distance = GetDistResult.ToString() + "公里";
  2236. }
  2237. catch (Exception ex)
  2238. {
  2239. Time = "未知!";
  2240. Distance = "未知!";
  2241. }
  2242. //trip += $"{time.ToString("HH:mm")} 搭乘专车前往市区({end_Object.AirPort} - {end_Object.City}市区 路程{Distance},耗时{Time})";
  2243. //trip += $"{time.ToString("HH:mm")} 搭乘专车前往市区({end_Object.AirPort} - {end_Object.City}市区)";
  2244. time = time.AddMinutes(GetGoogleResult); //到达市区时间
  2245. string tripDate = Convert.ToDateTime(item).ToString("M月d日");
  2246. if (index == timeArr.Count - 1)
  2247. {
  2248. NewListTravel.Add(new Grp_TravelList
  2249. {
  2250. CreateTime = DateTime.Now,
  2251. CreateUserId = 0,
  2252. Diid = diid,
  2253. Date = tripDate,
  2254. Trip = trip,
  2255. WeekDay = weekDay,
  2256. Days = index + 1,
  2257. Traffic_First = "飞机",
  2258. Traffic_Second = "汽车",
  2259. Diffgroup = 1,
  2260. Issel = 1,
  2261. IsDel = 0,
  2262. });
  2263. continue;
  2264. }
  2265. if (time.Day != fallToTime.Day) //超出一天
  2266. {
  2267. NewListTravel.Add(new Grp_TravelList
  2268. {
  2269. CreateTime = DateTime.Now,
  2270. CreateUserId = 0,
  2271. Diid = diid,
  2272. Date = tripDate,
  2273. Trip = trip,
  2274. WeekDay = weekDay,
  2275. Days = index + 1,
  2276. Traffic_First = "飞机",
  2277. Traffic_Second = "汽车",
  2278. Diffgroup = 1,
  2279. Issel = 1,
  2280. IsDel = 0,
  2281. });
  2282. continue;
  2283. }
  2284. var obInfo = obDatas.Find(it => Convert.ToDateTime(it.Date).ToString("M月d日").Equals(tripDate));
  2285. string obtime = "";
  2286. string obcontent = "";
  2287. if (obInfo != null)
  2288. {
  2289. obtime = obInfo.Time;
  2290. obcontent = $"拜访{obInfo.Client ?? "公务出访单位未录入"}{obInfo.Job ?? "公务出访联系人职务未录入"}{obInfo.Contact ?? "公务出访联系人职务未录入"}";
  2291. }
  2292. bool obTime_bool = DateTime.TryParse(obtime, out DateTime obTimeDt);
  2293. if (time.Hour < 9) // && (airArrive < new DateTime(airArrive.Year,airArrive.Month,airArrive.Day,6, 30, 0))
  2294. {
  2295. if (obTime_bool)
  2296. {
  2297. if (obTimeDt.Hour < 9)
  2298. {
  2299. trip += $"{obTimeDt.ToString("HH:mm")}—10:30 {obcontent};\r\n";
  2300. }
  2301. }
  2302. else
  2303. {
  2304. trip += "09:00—10:30 公务活动;\r\n";
  2305. }
  2306. }
  2307. else if (time.Hour < 10)
  2308. {
  2309. if (obTime_bool)
  2310. {
  2311. if (obTimeDt.Hour < 10)
  2312. {
  2313. trip += $"{obTimeDt.ToString("HH:mm")}—12:00 {obcontent};\r\n";
  2314. }
  2315. }
  2316. else
  2317. {
  2318. trip += "10:30—12:00 公务活动;\r\n";
  2319. }
  2320. }
  2321. if (time.Hour < 13)
  2322. {
  2323. //trip += $"\r\n{time.ToString("HH:mm")} 午餐于当地餐厅;";
  2324. }
  2325. if (time < new DateTime(time.Year, time.Month, time.Day, 14, 30, 0))
  2326. {
  2327. if (obTime_bool)
  2328. {
  2329. if (obTimeDt < new DateTime(time.Year, time.Month, time.Day, 14, 30, 0))
  2330. {
  2331. trip += $"{obTimeDt.ToString("HH:mm")}—16:00 {obcontent};\r\n";
  2332. }
  2333. }
  2334. else
  2335. {
  2336. trip += "14:00—16:00 公务活动;\r\n";
  2337. }
  2338. }
  2339. else if (time.Hour < 16)
  2340. {
  2341. if (obTime_bool)
  2342. {
  2343. if (obTimeDt.Hour < 16)
  2344. {
  2345. trip += $"{obTimeDt.ToString("HH:mm")}—17:30 {obcontent};\r\n";
  2346. }
  2347. }
  2348. else
  2349. {
  2350. trip += "16:00—17:30 公务活动;\r\n";
  2351. }
  2352. }
  2353. //if (time.Hour < 18)
  2354. //{
  2355. // trip += $"\r\n18:00 晚餐于当地餐厅;";
  2356. //}
  2357. //time = time.AddHours(1);
  2358. //trip += $"\r\n{time.ToString("HH:mm")} 搭乘专车前往酒店,抵达后办理入住;";
  2359. }
  2360. else
  2361. {
  2362. var end_Object = threeCodes.Find(x => x.Three.ToUpper() == stopCity.ToUpper());
  2363. if (end_Object == null)
  2364. {
  2365. end_Object = new Res_ThreeCode()
  2366. {
  2367. AirPort = empty,
  2368. AirPort_En = empty,
  2369. City = empty,
  2370. Country = empty,
  2371. Four = empty,
  2372. Three = empty,
  2373. };
  2374. }
  2375. //trip += $"{end_Object.City}\r\n";
  2376. // trip += @"08:00 早餐于酒店;
  2377. //09:00—10:30 公务活动;
  2378. //12:00 午餐于当地餐厅;
  2379. //14:00—16:00 公务活动;
  2380. //18:00 晚餐于当地餐厅;
  2381. //19:00 入住酒店休息;";
  2382. trip += "09:00—10:30 公务活动;\r\n14:00—16:00 公务活动;\r\n";
  2383. }
  2384. string[] traffic = new string[] { "飞机", "汽车" };
  2385. if (!isMoreTraffic)
  2386. {
  2387. traffic = new string[] { "汽车", "" };
  2388. }
  2389. NewListTravel.Add(new Grp_TravelList
  2390. {
  2391. CreateTime = DateTime.Now,
  2392. CreateUserId = 0,
  2393. Diid = diid,
  2394. Date = Convert.ToDateTime(item).ToString("M月d日"),
  2395. Trip = trip,
  2396. WeekDay = weekDay,
  2397. Days = index + 1,
  2398. Traffic_First = traffic[0],
  2399. Traffic_Second = traffic[1],
  2400. Diffgroup = 1,
  2401. Issel = 1,
  2402. IsDel = 0,
  2403. });
  2404. index++;
  2405. }
  2406. return new Result() { Code = 0, Msg = "获取成功!", Data = NewListTravel };
  2407. }
  2408. /// <summary>
  2409. /// 根据日期获取星期
  2410. /// </summary>
  2411. /// <param name="dt"></param>
  2412. /// <returns></returns>
  2413. public static string GetWeek(this string dtStr)
  2414. {
  2415. string week = "";
  2416. bool isDt = DateTime.TryParse(dtStr,out DateTime dt);
  2417. if (isDt)
  2418. {
  2419. week = weekdays[(int)dt.DayOfWeek];
  2420. }
  2421. return week;
  2422. }
  2423. #endregion
  2424. }
  2425. }