MES/BusinessManger/MaterialWareHouseManager/MaterialWareHouse_Over_Delivery_List.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using MES.BaseOperater;
using MES.BLL.BusinessBLL;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace MES.BusinessManger.MaterialWareHouseManager
{
    public partial class MaterialWareHouse_Over_Delivery_List : FartherWindow
    {
        public MaterialWareHouse_Over_Delivery_List()
        {
            InitializeComponent();
        }

        private void btnCheck_Click(object sender, EventArgs e)
        {
            StringBuilder strBuilder=new StringBuilder();
            strBuilder.Append(" and a.SaleBill_Date>a.End_Date ");
            gridControlBase.DataSource = new SaleBillBLL().GetSaleBillListByCondtion(strBuilder.ToString());
        }

        private void btnOutExcel_Click(object sender, EventArgs e)
        {
            SaveFileDialog fileDialog = new SaveFileDialog();
            fileDialog.Title = "导出Excel";
            fileDialog.Filter = "Excel文件(*.xls)|*.xls";
            DialogResult dialogResult = fileDialog.ShowDialog(this);
            if (dialogResult != DialogResult.OK)
                return;
            DevExpress.XtraPrinting.XlsExportOptions options = new DevExpress.XtraPrinting.XlsExportOptions();
            gridControlBase.ExportToXls(fileDialog.FileName);
            DevExpress.XtraEditors.XtraMessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }

        private void MaterialWareHouse_Over_Delivery_List_Load(object sender, EventArgs e)
        {
            dateStart.Text = DateTime.Now.AddYears(-1).ToString("yyyy-MM-dd 00:00:01");
            dateEnd.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");
        }
    }
}