DAL/Income.cs

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

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

using System;
using System.Data;
using System.Data.SqlClient;
using DBUtility;

namespace DAL
{
    /// <summary>
    /// 数据访问类:Income
    /// </summary>
    public partial class Income
    {
        public Income()
        { }
        #region  Method
        /// <summary>
        ///  增加一条数据
        /// </summary>
        public static int Add(Model.Income model)
        {
            int rowsAffected;
            SqlParameter[] parameters = {
					new SqlParameter("@Id", SqlDbType.Int,4),
					new SqlParameter("@Time", SqlDbType.DateTime),
					new SqlParameter("@Money", SqlDbType.Decimal,9),
					new SqlParameter("@Departs", SqlDbType.NVarChar,64),
					new SqlParameter("@S2", SqlDbType.NVarChar,64)};
            parameters[0].Direction = ParameterDirection.Output;
            parameters[1].Value = model.Time;
            parameters[2].Value = model.Money;
            parameters[3].Value = model.Departs;
            parameters[4].Value = model.S2;

            DbHelperSQL.RunProcedure(PubConstant.ConnectionString, "Income_ADD", parameters, out rowsAffected);
            return (int)parameters[0].Value;
        }

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public static Model.Income GetModel(int Id)
        {
            SqlParameter[] parameters = {
					new SqlParameter("@Id", SqlDbType.Int,4)
			};
            parameters[0].Value = Id;

            Model.Income model = new Model.Income();
            DataSet ds = DbHelperSQL.RunProcedure(PubConstant.ConnectionString, "Income_GetModel", parameters, "ds");
            if (ds.Tables[0].Rows.Count > 0)
            {
                return DataRowToModel(ds.Tables[0].Rows[0]);
            }
            else
            {
                return null;
            }
        }

        /// <summary>