DAL/DAO/Logistics_FcrDAO.cs

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

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

// ******************************************************************
// 文件名: Logistics_FcrDAO.cs
// 主要内容： 操作承运单信息对象的方法集合
// ******************************************************************

using System;
using System.Collections.Generic;
using Logistics.IDal;
using Logistics.Model;
using System.Data;
using System.Text;
using System.Data.SqlClient;

namespace Logistics.DAL.DAO
{

    public class Logistics_FcrDAO : IDao
    {
        #region IDao 成员

        public SqlConnection connection { get; set; }
        public SqlTransaction transaction { get; set; }

        /// <summary>
        /// 添加一个对象
        /// </summary>
        /// <param name="m"></param>
        /// <returns></returns>
        public int add(object m)
        {
            Logistics_Fcr model = m as Logistics_Fcr;
            int rowsAffected;
            SqlParameter[] parameters = {
					new SqlParameter("@Fcr_ID", SqlDbType.Int,4),
					new SqlParameter("@User_ID", SqlDbType.Int,4),
					new SqlParameter("@Fcr_Send_Cliernt", SqlDbType.Int,4),
					new SqlParameter("@Fcr_Accept_Client", SqlDbType.Int,4),
					new SqlParameter("@Company_ID", SqlDbType.Int,4),
                    new SqlParameter("@Roadinfo_ID",SqlDbType.Int,4),
					new SqlParameter("@Fcr_Num", SqlDbType.NVarChar,16),
					new SqlParameter("@Fcr_Filling_Time", SqlDbType.DateTime),
					new SqlParameter("@Fcr_Arrived_time", SqlDbType.DateTime),
					new SqlParameter("@Fcr_Weight", SqlDbType.Float,8),
					new SqlParameter("@Fcr_Volume", SqlDbType.Float,8),
					new SqlParameter("@Fcr_Payway", SqlDbType.NVarChar,10),
					new SqlParameter("@Fcr_Cost", SqlDbType.Float,8),
					new SqlParameter("@Fcr_Rrecost", SqlDbType.Float,8),
					new SqlParameter("@Fcr_State", SqlDbType.NVarChar,20),
					new SqlParameter("@Fcr_Remark", SqlDbType.NText)};
            parameters[0].Direction = ParameterDirection.Output;
            parameters[1].Value = model.User_ID;
            parameters[2].Value = model.Fcr_Send_Cliernt;
            parameters[3].Value = model.Fcr_Accept_Client;
            parameters[4].Value = model.Company_ID;
            parameters[5].Value = model.Roadinfo_id;
            parameters[6].Value = model.Fcr_Num;
            parameters[7].Value = model.Fcr_Filling_Time;
            parameters[8].Value = model.Fcr_Arrived_time;
            parameters[9].Value = model.Fcr_Weight;
            parameters[10].Value = model.Fcr_Volume;