DW5S/DW5S.App/UserControl/CtrlSample.cs

using DW5S.App.EditForms;
using DW5S.Entity;
using DW5S.Repostory;
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace DW5S.App.UserControl
{
    public partial class CtrlSample : DevExpress.XtraEditors.XtraUserControl
    {
        readonly List<SampleInfo> listSampleInfo = new List<SampleInfo>();
        public CtrlSample()
        {
            InitializeComponent();
        }

        private async void CtrlSample_Load(object sender, EventArgs e)
        {
            try
            {
                gridSample.UseDefault(listSampleInfo).UseMultiSelect().UseRowNumber()
          .UseAddAsync(AddSampleInfo)
          .UseEditAsync<SampleInfo>(EditSampleInfo)
          .UseDeleteAsync<SampleInfo>(DeleteSampleInfo);


                var unitOfWork = IocContainer.UnitOfWork;
                var items = await unitOfWork.Of<SampleInfo>().AsQueryable()
                      .Include(s => s.SigInfo)
                        .Include(s => s.RefTxInfo)
                        .OrderBy(p => p.SampleName)
                        .ToListAsync();

                listSampleInfo.AddRange(items);

                gridViewSample.RefreshData();
            }
            catch (Exception ex)
            {
                IocContainer.Logger.Error(ex, "查询样本信息异常");
                DxHelper.MsgBoxHelper.ShowError("查询样本信息异常");
            }
        }



        private async Task<SampleInfo> AddSampleInfo()
        {
            try
            {
                SampleEditor frm = new SampleEditor();
                if (frm.ShowDialog() != DialogResult.OK) return null;
                var addItem = frm.info;
                var unitOfWork = IocContainer.UnitOfWork;
                var addSample = await unitOfWork.Of<SampleInfo>().AddOrUpdateAsync(new SampleInfo
                {
                    SampleName = addItem.SampleName,
                    SamplePath = addItem.SamplePath,
                    SampleFileName = addItem.SampleFileName,
                    Fs = addItem.Fs,
                    StartSec = addItem.StartSec,
                    EndSec = addItem.EndSec,
                    RefTxInfoID = addItem.RefTxInfoID,
                    SigInfoID = addItem.SigInfoID,
                    Remark = addItem.Remark,
                    UpdateTime = DateTime.Now,
                });
                await unitOfWork.SaveAsync();
                addItem.Id = addSample.Id;
                return addItem;
            }
            catch (Exception ex)
            {
                IocContainer.Logger.Error(ex, "添加样本信息异常");
                DxHelper.MsgBoxHelper.ShowError("添加样本信息异常");
                return null;
            }
        }
        private async Task<SampleInfo> EditSampleInfo(SampleInfo editItem)
        {
            try
            {
                SampleEditor frm = new SampleEditor(editItem);
                if (frm.ShowDialog() != DialogResult.OK) return null;
                editItem = frm.info;
                var unitOfWork = IocContainer.UnitOfWork;
                editItem.UpdateTime = DateTime.Now;
                await unitOfWork.Of<SampleInfo>().AddOrUpdateAsync(editItem);
                await unitOfWork.SaveAsync();
                return editItem;
            }
            catch (Exception ex)
            {
                IocContainer.Logger.Error(ex, "保存样本信息异常");
                DxHelper.MsgBoxHelper.ShowError("保存样本信息异常");
                return null;
            }
        }
        private async Task<bool> DeleteSampleInfo(List<SampleInfo> list)
        {
            try
            {
                var unitOfWork = IocContainer.UnitOfWork;
                await unitOfWork.Of<SampleInfo>().DeleteAsync(list);
                await unitOfWork.SaveAsync();
                return true;
            }
            catch (Exception ex)
            {
                IocContainer.Logger.Error(ex, "删除样本信息异常");
                DxHelper.MsgBoxHelper.ShowError("删除样本信息异常");
                return false;
            }
        }
        private async void gridViewSignal_DoubleClick(object sender, EventArgs e)
        {
            var editItem = gridViewSample.GetFocusedRow() as SampleInfo;
            if (editItem == null) return;
            await EditSampleInfo(editItem);
        }


    }
}