DAL/DAO/Logistics_RoadinfoDAO.cs

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

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

// ******************************************************************
// 文件名: Logistics_RoadinfoDAO.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_RoadinfoDAO: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_Roadinfo model = m as Logistics_Roadinfo;
            int rowsAffected;
            SqlParameter[] parameters = {
					new SqlParameter("@Roadinfo_ID", SqlDbType.Int,4),
					new SqlParameter("@Roadinfo_Startcity", SqlDbType.Int,4),
					new SqlParameter("@Roadinfo_Endcity", SqlDbType.Int,4),
					new SqlParameter("@Roadinfo_Distance", SqlDbType.Float,8),
					new SqlParameter("@Roadinfo_Remark", SqlDbType.NText)};
            parameters[0].Direction = ParameterDirection.Output;
            parameters[1].Value = model.Roadinfo_Startcity;
            parameters[2].Value = model.Roadinfo_Endcity;
            parameters[3].Value = model.Roadinfo_Distance;
            parameters[4].Value = model.Roadinfo_Remark;

            rowsAffected = SqlUtil.executeProcInt("UP_Logistics_Roadinfo_ADD", parameters, connection,transaction);
            return (int)parameters[0].Value;
        }

        /// <summary>
        /// 通过指定属性得到实体对象列表
        /// </summary>
        /// <param name="attribute"></param>
        /// <param name="value"></param>
        /// <returns></returns>
        public DataTable getModelListByAttribute(string attribute, string value)
        {
            DataTable lo = new DataTable();
            string where = attribute + "='" + value + "'";
            lo = getModelList(0, where, null);