departexecutedal.cs

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

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

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

            SqlParameter[] param ={new SqlParameter("@KjYear",SqlDbType.Int),
                                  new SqlParameter("@DeptCode",SqlDbType.VarChar) };
            param[0].Value = plan.KjYear;
            param[1].Value = plan.DeptCode;
            return common.Search("SelectDeptExecuteProcedure", param);

        }
    }
    
}