XDFZ/MGetCount.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using BLL;
using Model;
using CommonTools;
using DAL;

namespace XDFZ
{
    public partial class MGetCount : Form
    {
        DataTable binddt = new DataTable();
        public MGetCount()
        {
            InitializeComponent();
            binddt.Columns.Add("原材料名称");
            binddt.Columns.Add("领用数量");
        }

        private void MGetCount_Load(object sender, EventArgs e)
        {
            this.winGridView1.AppendedMenu = this.contextMenuStrip1;
            this.winGridView1.AddColumnAlias("原材料名称", "原材料名称");
            this.winGridView1.AddColumnAlias("领用数量", "领用数量");
            this.winGridView1.PrintTitle = "原材料领用统计报表";
            this.winGridView1.DataSource = binddt.DefaultView;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            this.binddt.Rows.Clear();

            string startTime = this.dateTimePicker1.Text.Trim();
            string endTime = this.dateTimePicker2.Text.Trim();

            if (endTime.CompareTo(startTime) < 0)
            {
                MessageBox.Show("截止时间不能早于开始时间！");
                return;
            }

            DataTable mdt = CommonProxy.GetMCountByTime(this.dateTimePicker1.Value, this.dateTimePicker2.Value);
            string mName;
            float count;
            if(mdt != null && mdt.Rows.Count > 0)
            {
                mName = mdt.Rows[0]["MaterialName"].ToString();
                count = float.Parse(mdt.Rows[0]["Amount"].ToString());
                for (int i = 0; i < mdt.Rows.Count; i++)
                {
                    if(mdt.Rows[i]["MaterialName"] == mName)
                    {
                        if (!string.IsNullOrEmpty(mdt.Rows[i]["Amount"].ToString()))
                        {
                            count += float.Parse(mdt.Rows[i]["Amount"].ToString());