Backup/JinYeTransportCostsSystem/document/gatheringdocument/Main.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 System.Collections;

namespace JinYeTransportCostsSystem.document.gatheringdocument
{
    public partial class Main : Form
    {
        public Main()
        {
            InitializeComponent();
        }

        int i_wz = 0;
        #region 查询要付款的运输单据
        private void Main_Click(object sender, EventArgs e)
        {
            panel1.Visible = false;
        }

        private void GetYsd(int i_Type)
        {
            if (i_Type == 1)
            {
                Tsr.BLL.FZ_DJ_YSD bll = new Tsr.BLL.FZ_DJ_YSD();
                dgv_Query.DataSource = bll.GetListByFkdQuery(" YsdTdd='" + tb_Tdd.Text.Trim() + "' and (djType=-1 or djType=0) and Mark=1").Tables[0];
            }
            else if (i_Type == 2)
            {
                Tsr.BLL.FZ_DJ_YSD bll = new Tsr.BLL.FZ_DJ_YSD();
                dgv_Query.DataSource = bll.GetListByFkdQuery(" YsdTdd='" + tb_Tdd.Text.Trim() + "' and YsdTruck like '%" + tb_car.Text.Trim() + "%' and (djType=-1 or djType=0) and Mark=1").Tables[0];
            }
            else if (i_Type == 3)
            {
                Tsr.BLL.FZ_DJ_YSD bll = new Tsr.BLL.FZ_DJ_YSD();
                dgv_Query.DataSource = bll.GetListByFkdQuery(" YsdTruck like '%" + tb_car.Text.Trim() + "%' and (djType=-1 or djType=0) and Mark=1").Tables[0];
            }

            else if (i_Type == 4)
            {
                Tsr.BLL.FZ_DJ_YSD bll = new Tsr.BLL.FZ_DJ_YSD();
                dgv_Query.DataSource = bll.GetListByFkdQuery(" YsdStartDate  between '" + dateTimePicker1.Value + "' and '" + dateTimePicker2.Value + "' and (djType=-1 or djType=0) and Mark=1").Tables[0];
            }

            else if (i_Type == 5)
            {
                Tsr.BLL.FZ_DJ_YSD bll = new Tsr.BLL.FZ_DJ_YSD();
                dgv_Query.DataSource = bll.GetListByFkdQuery(" YsdTdd='" + tb_Tdd.Text.Trim() + "' and YsdStartDate  between '" + dateTimePicker1.Value + "' and '" + dateTimePicker2.Value + "' and (djType=-1 or djType=0) and Mark=1").Tables[0];

            }
            else if (i_Type == 6)
            {
                Tsr.BLL.FZ_DJ_YSD bll = new Tsr.BLL.FZ_DJ_YSD();
                dgv_Query.DataSource = bll.GetListByFkdQuery(" YsdTruck like '%" + tb_car.Text.Trim() + "%' and YsdStartDate  between '" + dateTimePicker1.Value + "' and '" + dateTimePicker2.Value + "' and (djType=-1 or djType=0) and Mark=1").Tables[0];