materialexecutedal.cs

来自「为了便于企业对客户按照地区进行统计查询分析」· CS 代码 · 共 35 行

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

namespace DataAccess.DAL
{
    public class MaterialExecuteDal
    {
        Common.Common common = new DataAccess.Common.Common();
        /// <summary>
        /// 查询货物销售计划执行信息
        /// </summary>
        /// <param name="plan"></param>
        /// <returns></returns>
        public DataTable SelectMaterialExecute(XS_Plan plan)
        {

            SqlParameter[] param ={new SqlParameter("@KjYear",SqlDbType.Int),
                                  new SqlParameter("@DeptCode",SqlDbType.VarChar),
                                  new SqlParameter("@WareCode",SqlDbType.VarChar)};

            param[0].Value = plan.KjYear;
            param[1].Value = plan.DeptCode;
            param[2].Value = plan.WareCode;

            return common.Search("SelectMaterialExecuteProcedure", param);

        }

    }
}