CtrlXl.cs 6.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193
  1. using DevExpress.XtraEditors;
  2. using DevExpress.XtraScheduler;
  3. using DxHelper;
  4. using ExtensionsDev;
  5. using System;
  6. using System.Collections.Generic;
  7. using System.Diagnostics;
  8. using System.Linq;
  9. using System.Threading.Tasks;
  10. using System.Windows.Forms;
  11. using DW5S.App.CorTools;
  12. using DW5S.DTO;
  13. using DW5S.Entity;
  14. using DW5S.Repostory;
  15. using Serilog;
  16. using static DevExpress.Xpo.Helpers.AssociatedCollectionCriteriaHelper;
  17. using DW5S.Service;
  18. using DW5S.ViewModel;
  19. using XdCxRhDW5S.ViewModel;
  20. namespace DW5S.App.UserControl
  21. {
  22. public partial class CtrlXl : DevExpress.XtraEditors.XtraUserControl
  23. {
  24. List<XlViewModel> list = new List<XlViewModel>();
  25. int maxCount = 0;
  26. int maxPage = 0;
  27. int currentPage = 1;
  28. int? satCode = null;
  29. public CtrlXl()
  30. {
  31. InitializeComponent();
  32. this.layoutControl1.UseDefault();
  33. this.ctrlPage1.Compact = false;
  34. this.ctrlPage1.ShowGoto = true;
  35. btnOpen.UseChooseFile().UseDoubleClickToSelectAll();
  36. }
  37. private void TxtSat_EditValueChanged(object sender, EventArgs e)
  38. {
  39. var sat = txtSat.EditValue as SatViewModel;
  40. satCode = sat?.SatCode;
  41. ctrlPage1.RefreshData();
  42. }
  43. private async void CtrlXl_Load(object sender, EventArgs e)
  44. {
  45. ctrlPage1.SetOnQuery(LoadPageData);
  46. var unitOfWork = IocContainer.UnitOfWork;
  47. var repsXl = unitOfWork.Of<XlInfo>() as XlRepository;
  48. var sat = await repsXl.GetAllSat();
  49. txtSat.UseDefault("不限制", true).SetData(sat.To<List<SatViewModel>>(), displayField: nameof(SatViewModel.Sat)).UseDoubleClickToSelectAll();
  50. gridXl.UseDefault(list).UseRowNumber().UseDeleteAsync<XlViewModel>(Del)
  51. .UseClearAsync<XlViewModel>(Clear).UseExportXlsx()
  52. .AddMenu("星历推算", SvgHelper.LoadFromFile("Image\\XlCalc.svg"), () =>
  53. {
  54. var ids = gridView1.GetSelectedRows();
  55. if (ids.Length <= 0)
  56. {
  57. XtraMessageBox.Show("请选择需要星历推算的数据信息!");
  58. return;
  59. }
  60. var item = gridView1.GetRow(ids[0]) as XlViewModel;
  61. XlCalculateForm form = new XlCalculateForm(item.TwoLine);
  62. form.ShowDialog();
  63. });
  64. //.AddMenu("刷新数据", SvgHelper.CreateRefresh(), () =>
  65. //{
  66. // currentPage = 1;
  67. // ctrlPage1.RefreshData();
  68. //});
  69. }
  70. private async Task<PageData> LoadPageData(PageQueryDto arg)
  71. {
  72. var repsXl = IocContainer.UnitOfWork.Of<XlInfo>();
  73. var queryable = repsXl.AsQueryable();
  74. if (satCode != null)
  75. queryable = queryable.Where(x => x.SatCode == satCode);
  76. queryable = queryable.OrderByDescending(p => p.TimeUTC).ThenByDescending(p => p.Lon);
  77. var pageData = await repsXl.GetPageData(arg, queryable);
  78. list.Clear();
  79. list.AddRange(pageData.Data.To<List<XlViewModel>>());
  80. gridView1.RefreshData();
  81. return pageData;
  82. }
  83. private async void btnImp_Click(object sender, EventArgs e)
  84. {
  85. this.layoutControl1.Enabled = false;
  86. if (string.IsNullOrEmpty(btnOpen.Text))
  87. {
  88. DxHelper.MsgBoxHelper.ShowInfo($"请选择星历文件");
  89. this.layoutControl1.Enabled = true;
  90. return;
  91. }
  92. string file;
  93. try
  94. {
  95. file = await HttpHelper.UploadFileAsync(btnOpen.Text);
  96. }
  97. catch (Exception ex)
  98. {
  99. layoutControl1.Enabled = true;
  100. string msg = "上传星历文件异常";
  101. IocContainer.Logger.Error(ex, msg);
  102. DxHelper.MsgBoxHelper.ShowError(msg);
  103. return;
  104. }
  105. try
  106. {
  107. XlImportDto dto = new XlImportDto() { File = file };
  108. var result = await HttpHelper.PostRequestAsync<RecordRes>(SysConfig.GetUrl("Xl/ImportTle"), dto);
  109. if (result.code == 200)
  110. {
  111. DxHelper.MsgBoxHelper.ShowInfo($"星历导入成功.共导入{result.data.Count}条");
  112. ctrlPage1.RefreshData();
  113. }
  114. else
  115. {
  116. IocContainer.Logger.Error(result.msg);
  117. DxHelper.MsgBoxHelper.ShowError(result.msg);
  118. }
  119. }
  120. catch (Exception ex)
  121. {
  122. string msg = "星历导入异常";
  123. IocContainer.Logger.Error(ex, msg);
  124. DxHelper.MsgBoxHelper.ShowError(msg);
  125. }
  126. this.layoutControl1.Enabled = true;
  127. }
  128. private async Task<bool> Del(List<XlViewModel> list)
  129. {
  130. try
  131. {
  132. this.Enabled = false;
  133. var unitOfWork = IocContainer.UnitOfWork;
  134. var repsXl = unitOfWork.Of<XlInfo>();
  135. var count = await repsXl.DeleteAsync(list.To<List<XlInfo>>());
  136. await unitOfWork.SaveAsync();
  137. ctrlPage1.RefreshData();
  138. IocContainer.Logger.Information($"删除选中星历,共删除了{count}条星历记录");
  139. return true;
  140. }
  141. catch (Exception ex)
  142. {
  143. string msg = "删除选中星历异常";
  144. IocContainer.Logger.Error(ex, msg);
  145. DxHelper.MsgBoxHelper.ShowError(msg);
  146. return false;
  147. }
  148. finally
  149. {
  150. this.Enabled = true;
  151. }
  152. }
  153. private async Task<bool> Clear()
  154. {
  155. try
  156. {
  157. this.Enabled = false;
  158. var unitOfWork = IocContainer.UnitOfWork;
  159. var repsXl = unitOfWork.Of<XlInfo>();
  160. var count = await repsXl.DeleteAsync(p => true);
  161. await unitOfWork.SaveAsync();
  162. ctrlPage1.RefreshData();
  163. IocContainer.Logger.Information($"删除所有星历,共删除了{count}条星历记录");
  164. return true;
  165. }
  166. catch (Exception ex)
  167. {
  168. string msg = "删除所有星历异常";
  169. IocContainer.Logger.Error(ex, msg);
  170. DxHelper.MsgBoxHelper.ShowError(msg);
  171. return false;
  172. }
  173. finally
  174. {
  175. this.Enabled = true;
  176. }
  177. }
  178. }
  179. }