DW5S/DW5S.App/UserControl/CtrlRefTask.cs

using DevExpress.Mvvm.Native;
using DevExpress.XtraBars.Customization;
using DevExpress.XtraGrid.Views.Grid;
using DW5S.App.EditForms;
using DW5S.Entity;
using DW5S.Repostory;
using DW5S.ViewModel;
using DxHelper;
using ExtensionsDev;
using Google.Protobuf.WellKnownTypes;
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Drawing;
using System.Linq;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Linq;
using System.Linq.Expressions;
using Microsoft.EntityFrameworkCore.Query;
namespace DW5S.App.UserControl
{
    public partial class CtrlRefTask : DevExpress.XtraEditors.XtraUserControl
    {
        readonly List<RefTaskViewModel> list = new List<RefTaskViewModel>();
        public CtrlRefTask()
        {
            InitializeComponent();
        }
        private async void CtrlRefTask_Load(object sender, EventArgs e)
        {


            try
            {
                gridRefTask.UseDefault(list).UseMultiSelect().UseRowNumber()
                    .UseAddAsync(Add)
                    .UseEditAsync<RefTaskViewModel>(Edit)
                    .UseDeleteAsync<RefTaskViewModel>(Delete)
                    .AddContentMenu<RefTaskViewModel>("一键启用", SvgHelper.CreateCycle("#2E8B57"), async data =>
                    {
                        try
                        {

                            var ids = data.Select(p => p.Id);
                            var unitOfWork = IocContainer.UnitOfWork;
                            var reps = unitOfWork.OfLong<RefTaskFreq>();
                            await reps.UpdatePropAsync(p => ids.Contains(p.Id), s => s.SetProperty(b => b.Enable, true));
                            await unitOfWork.SaveAsync();

                            data.ForEach(d => d.Enable = true);
                            gridView1.RefreshData();
                            gridView1.BestFitColumns();

                            DxHelper.MsgBoxHelper.ShowInfo("一键启用成功!");
                        }
                        catch (Exception ex)
                        {
                            IocContainer.Logger.Error(ex, "一键启用异常");
                            DxHelper.MsgBoxHelper.ShowError("一键启用异常");
                        }
                    }, false)
                    .AddContentMenu<RefTaskViewModel>("一键禁用", SvgHelper.CreateCycle("#FF0000"), async data =>
                     {

                         try
                         {
                             var ids = data.Select(p => p.Id);
                             var unitOfWork = IocContainer.UnitOfWork;
                             var reps = unitOfWork.OfLong<RefTaskFreq>();
                             await reps.UpdatePropAsync(p => ids.Contains(p.Id), s => s.SetProperty(b => b.Enable, false));
                             await unitOfWork.SaveAsync();

                             data.ForEach(d => d.Enable = false);
                             gridView1.RefreshData();
                             gridView1.BestFitColumns();
                             DxHelper.MsgBoxHelper.ShowInfo("一键禁用成功!");
                         }
                         catch (Exception ex)
                         {
                             IocContainer.Logger.Error(ex, "一键禁用异常");
                             DxHelper.MsgBoxHelper.ShowError("一键禁用异常");
                         }
                     }, false);
                List<TxInfo> refTxList = new List<TxInfo>();
                var unitOfWork = IocContainer.UnitOfWork;
                var items = await unitOfWork.OfLong<RefTaskFreq>().AsQueryable()
                     .Include(r => r.SampleInfo)
                        .Include(r => r.SampleInfo.SigInfo)
                        .Include(r => r.SampleInfo.RefTxInfo)
                        .Include(r => r.SatInfo).OrderBy(p => p.Enable).ThenBy(p=>p.SampleInfo.SigInfo.FreqDown).ToListAsync();
                list.AddRange(items.To<List<RefTaskViewModel>>());

                refTxList = await unitOfWork.Of<TxInfo>().AsQueryable()
                    .Where(t => t.TxType == EnumTxType.Ref)
                  .OrderByDescending(p => p.UpdateTime).ToListAsync();

                this.txtRef.UseDefault(showClearBtn: true).SetData(refTxList.To<List<RefTxViewModel>>(), displayField: nameof(RefTxViewModel.Name)).UseDoubleClickToSelectAll();
            }
            catch (Exception ex)
            {
                IocContainer.Logger.Error(ex, "查询参考任务信息异常");
                DxHelper.MsgBoxHelper.ShowError("查询参考任务信息异常");
            }
        }

        private async Task<RefTaskViewModel> Add()
        {
            try
            {
                RefTaskFreqEditor frm = new RefTaskFreqEditor();
                if (frm.ShowDialog() != DialogResult.OK) return null;
                var addItem = frm.info;
                var unitOfWork = IocContainer.UnitOfWork;
                var addRefTaskFreq = await unitOfWork.OfLong<RefTaskFreq>().AddOrUpdateAsync(new RefTaskFreq
                {
                    SampleInfoID = addItem.SampleInfoID,
                    SatInfoID = addItem.SatInfoID,
                    CalccCycle = addItem.CalccCycle,
                    Snr = addItem.Snr,
                    DtoCenter = addItem.DtoCenter,
                    DtoRange = addItem.DtoRange,
                    SampleLen = addItem.SampleLen,
                    Enable = addItem.Enable,
                    UpdateTime = DateTime.Now,
                });

                await unitOfWork.SaveAsync();
                addItem.Id = addRefTaskFreq.Id;
                return addItem;
            }
            catch (Exception ex)
            {
                IocContainer.Logger.Error(ex, "添加参考任务信息异常");
                DxHelper.MsgBoxHelper.ShowError("添加参考任务信息异常");
                return null;
            }
        }

        private async Task<RefTaskViewModel> Edit(RefTaskViewModel editItem)
        {
            try
            {
                RefTaskFreqEditor frm = new RefTaskFreqEditor(editItem);
                if (frm.ShowDialog() != DialogResult.OK) return null;
                editItem = frm.info;

                var unitOfWork = IocContainer.UnitOfWork;
                var edit = editItem.To<RefTaskFreq>();
                edit.SampleInfo = null;
                edit.SatInfo = null;
                edit.UpdateTime = DateTime.Now;

                await unitOfWork.OfLong<RefTaskFreq>().AddOrUpdateAsync(edit);
                await unitOfWork.SaveAsync();
                return editItem;
            }
            catch (Exception ex)
            {
                IocContainer.Logger.Error(ex, "保存参考任务信息异常");
                DxHelper.MsgBoxHelper.ShowError("保存参考任务信息异常");
                return null;
            }
        }

        private async Task<bool> Delete(List<RefTaskViewModel> list)
        {
            try
            {
                var unitOfWork = IocContainer.UnitOfWork;
                await unitOfWork.OfLong<RefTaskFreq>().DeleteAsync(list.To<List<RefTaskFreq>>());
                await unitOfWork.SaveAsync();
                return true;
            }
            catch (Exception ex)
            {
                IocContainer.Logger.Error(ex, "删除参考任务信息异常");
                DxHelper.MsgBoxHelper.ShowError("删除参考任务信息异常");
                return false;
            }
        }

        private async void gridView1_DoubleClick(object sender, EventArgs e)
        {
            var editItem = gridView1.GetFocusedRow() as RefTaskViewModel;
            if (editItem == null) return;
            await Edit(editItem);
        }

        private void gridView1_CustomDrawCell(object sender, DevExpress.XtraGrid.Views.Base.RowCellCustomDrawEventArgs e)
        {
            GridView view = sender as GridView;
            if (e.Column == view.Columns["IsEnable"])
            {
                string status = view.GetRowCellValue(e.RowHandle, view.Columns["IsEnable"]) as string;
                if (status == "启用")
                {

                    e.Appearance.BackColor = Color.LightGreen; // 设置为绿色背景，表示活跃状态
                }
                else if (status == "禁用")
                {
                    e.Appearance.BackColor = Color.LightCoral; // 设置为淡红色背景，表示非活跃状态
                }
            }
        }

        private async void btnSerach_Click(object sender, EventArgs e)
        {
            try
            {
                var reftxInfo = (txtRef.EditValue as RefTxViewModel);

                var unitOfWork = IocContainer.UnitOfWork;
                var query = unitOfWork.OfLong<RefTaskFreq>().AsQueryable();
                if (reftxInfo != null)
                {
                    query.Where(r => r.SampleInfo.TxInfoID == reftxInfo.Id);
                }
                var items = await query
                     .Include(r => r.SampleInfo.SigInfo)
                        .Include(r => r.SampleInfo.RefTxInfo)
                        .Include(r => r.SatInfo)
                        .OrderBy(p => p.Enable).ToListAsync();
                list.Clear();
                list.AddRange(items.To<List<RefTaskViewModel>>());
                gridView1.RefreshData();
            }
            catch (Exception ex)
            {
                IocContainer.Logger.Error(ex, "查询参考任务信息异常");
                DxHelper.MsgBoxHelper.ShowError("查询参考任务信息异常");

            }

        }
    }
}