WELOA.BLL/Equipment/SB_Testing.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using WELOA.Model;
using SBDAL_SQL;
using System.Data;

namespace SBBLL
{
    public class SB_Testing
    {
        
        private DateSetInformation dsinfo = new DateSetInformation();
        private sb_storageDAO storageDAO = new sb_storageDAO();
        private sb_testingDAO testingDAO = new sb_testingDAO();
        private Polytechnic trinfo = new Polytechnic();

        
        public DateSetInformation select_Testing()
        {
            this.dsinfo = this.storageDAO.select_Devicenumber_testing();
            if ((this.dsinfo.nException <= 0) && (this.dsinfo.ds.Tables[0].Rows.Count > 0))
            {
                DataSet ds = this.dsinfo.ds;
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    this.dsinfo = this.testingDAO.select_testing_devicenumber(ds.Tables[0].Rows[i]["devicenumber"].ToString());
                    if (this.dsinfo.nException > 0)
                    {
                        return this.dsinfo;
                    }
                    if (this.dsinfo.ds.Tables[0].Rows.Count > 0)
                    {
                        TimeSpan span = (TimeSpan)(DateTime.Now - Convert.ToDateTime(this.dsinfo.ds.Tables[0].Rows[0]["testingtime"].ToString()));
                        if (Math.Truncate(span.TotalDays) < Convert.ToInt32(ds.Tables[0].Rows[i]["testingdays"].ToString()))
                        {
                            ds.Tables[0].Rows[i].Delete();
                            ds.Tables[0].Rows[i].AcceptChanges();
                            i--;
                        }
                    }
                }
                this.dsinfo.ds = ds;
            }
            return this.dsinfo;
        }

        public DateSetInformation select_testing_devicenumber(string strDevicenumber)
        {
            this.dsinfo = this.testingDAO.select_testing_devicenumber(strDevicenumber);
            return this.dsinfo;
        }
    }
}