BLL/Transit.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Logistics.DAL;
using System.Data;
using Logistics.IDal;
using Logistics.Model;
namespace Logistics.BLL
{
    public class Transit
    {
        public Logistics_Transit getTransitModel(int id)
        {
            ISessionn session = SessionFactory.createSession();
            Logistics_Transit lt = null;
            try
            {
                lt = session.get<Logistics.Model.Logistics_Transit>(id);
            }
            catch
            {
                lt = null;
            }
            session.Dispose();
            return lt;

        }

        /// <summary>
        /// 完成运输单
        /// </summary>
        /// <param name="sTime">时间</param>
        /// <param name="t_id">运输单ID</param>
        /// <returns></returns>
        public bool checkin(string sTime, int t_id)
        {
            ISessionn session = SessionFactory.createSession();
            session.beginTransaction();
            bool b_result;
            try
            {
                DataTable dt = new DataTable();
                IQuery Iq = session.createQuery();
                var mt = session.get<Logistics_Transit>(t_id);
                b_result = Iq.executeInt("update Logistics_Transit set Transit_State='已经到达',[Transit_End_Time] = '" + sTime + "' where Transit_ID=" + t_id.ToString()) > 0 ? true : false;

                var mc = session.get<Logistics_Car>(mt.Car_ID);
                mc.Car_state = "可用";
                b_result = session.update(mc);

                dt = Iq.execute("select * from Loaded_Goods where Transit_ID=" + t_id.ToString()).Tables[0];

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    var mg = session.get<Logistics_Goods>(int.Parse(dt.Rows[i]["Goods_ID"].ToString()));
                    mg.Goods_State = 3;
                    session.update(mg);
                    DataTable dt1 = Iq.execute("select * from Goods_List where Fcr_ID=" + mg.Fcr_ID.ToString()).Tables[0];
                    DataView dv = dt1.DefaultView;