personsetdal.cs

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

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


namespace DataAccess.DAL
{
    public class PersonSetDal
    {
        Common.Common common = new DataAccess.Common.Common();
        /// <summary>
        /// 查询销售员编制信息
        /// </summary>
        /// <param name="plan"></param>
        /// <returns></returns>
        public DataTable SelectPersonSet(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("SelectPersonSetProcedure", param);

        }
        /// <summary>
        /// 插入销售员编制计划
        /// </summary>
        /// <param name="plan"></param>
        /// <returns></returns>
        public int InsertPersonSet(XS_Plan plan)
        {
            SqlParameter[] param ={new SqlParameter("@KjYear",SqlDbType.Int), 
                new SqlParameter("@DeptCode",SqlDbType.VarChar),
                new SqlParameter("@PersonCode",SqlDbType.VarChar),
                new SqlParameter("@CusCode",SqlDbType.VarChar),
                new SqlParameter("@WareCode",SqlDbType.VarChar),
                new SqlParameter("@YearPlanMoney",SqlDbType.Float),
                new SqlParameter("@YearPlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@YearPlanAmount",SqlDbType.Decimal),
                new SqlParameter("@OnePlanMoney",SqlDbType.Float),
                new SqlParameter("@OnePlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@OnePlanAmount",SqlDbType.Decimal),
                new SqlParameter("@TwoPlanMoney",SqlDbType.Float),
                new SqlParameter("@TwoPlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@TwoPlanAmount",SqlDbType.Decimal),
                new SqlParameter("@ThreePlanMoney",SqlDbType.Float),
                new SqlParameter("@ThreePlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@ThreePlanAmount",SqlDbType.Decimal),
                new SqlParameter("@FourPlanMoney",SqlDbType.Float),
                new SqlParameter("@FourPlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@FourPlanAmount",SqlDbType.Decimal),
                new SqlParameter("@FivePlanMoney",SqlDbType.Float),
                new SqlParameter("@FivePlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@FivePlanAmount",SqlDbType.Decimal),
                new SqlParameter("@SixPlanMoney",SqlDbType.Float),
                new SqlParameter("@SixPlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@SixPlanAmount",SqlDbType.Decimal),
                new SqlParameter("@ServenPlanMoney",SqlDbType.Float),
                new SqlParameter("@ServenPlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@ServenPlanAmount",SqlDbType.Decimal),
                new SqlParameter("@EightPlanMoney",SqlDbType.Float),
                new SqlParameter("@EightPlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@EightPlanAmount",SqlDbType.Decimal),
                new SqlParameter("@NinePlanMoney",SqlDbType.Float),
                new SqlParameter("@NinePlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@NinePlanAmount",SqlDbType.Decimal),
                new SqlParameter("@TenPlanMoney",SqlDbType.Float),
                new SqlParameter("@TenPlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@TenPlanAmount",SqlDbType.Decimal),
                new SqlParameter("@ElevenPlanMoney",SqlDbType.Float),
                new SqlParameter("@ElevenPlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@ElevenPlanAmount",SqlDbType.Decimal),
                new SqlParameter("@TwelvePlanMoney",SqlDbType.Float),
                new SqlParameter("@TwelvePlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@TwelvePlanAmount",SqlDbType.Decimal)};
            return common.Excute("InsertPersonSetProcedure", param);

        }
        /// <summary>
        /// 修改销售员计划编制
        /// </summary>
        /// <param name="plan"></param>
        /// <returns></returns>
        public int UpdatePersonSet(XS_Plan plan)
        {
            SqlParameter[] param ={new SqlParameter("@KjYear",SqlDbType.Int), 
                new SqlParameter("@DeptCode",SqlDbType.VarChar),
                new SqlParameter("@PersonCode",SqlDbType.VarChar),
                new SqlParameter("@CusCode",SqlDbType.VarChar),
                new SqlParameter("@WareCode",SqlDbType.VarChar),
                new SqlParameter("@YearPlanMoney",SqlDbType.Float),
                new SqlParameter("@YearPlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@YearPlanAmount",SqlDbType.Decimal),
                new SqlParameter("@OnePlanMoney",SqlDbType.Float),
                new SqlParameter("@OnePlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@OnePlanAmount",SqlDbType.Decimal),
                new SqlParameter("@TwoPlanMoney",SqlDbType.Float),
                new SqlParameter("@TwoPlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@TwoPlanAmount",SqlDbType.Decimal),
                new SqlParameter("@ThreePlanMoney",SqlDbType.Float),
                new SqlParameter("@ThreePlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@ThreePlanAmount",SqlDbType.Decimal),
                new SqlParameter("@FourPlanMoney",SqlDbType.Float),
                new SqlParameter("@FourPlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@FourPlanAmount",SqlDbType.Decimal),
                new SqlParameter("@FivePlanMoney",SqlDbType.Float),
                new SqlParameter("@FivePlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@FivePlanAmount",SqlDbType.Decimal),
                new SqlParameter("@SixPlanMoney",SqlDbType.Float),
                new SqlParameter("@SixPlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@SixPlanAmount",SqlDbType.Decimal),
                new SqlParameter("@ServenPlanMoney",SqlDbType.Float),
                new SqlParameter("@ServenPlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@ServenPlanAmount",SqlDbType.Decimal),
                new SqlParameter("@EightPlanMoney",SqlDbType.Float),
                new SqlParameter("@EightPlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@EightPlanAmount",SqlDbType.Decimal),
                new SqlParameter("@NinePlanMoney",SqlDbType.Float),
                new SqlParameter("@NinePlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@NinePlanAmount",SqlDbType.Decimal),
                new SqlParameter("@TenPlanMoney",SqlDbType.Float),
                new SqlParameter("@TenPlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@TenPlanAmount",SqlDbType.Decimal),
                new SqlParameter("@ElevenPlanMoney",SqlDbType.Float),
                new SqlParameter("@ElevenPlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@ElevenPlanAmount",SqlDbType.Decimal),
                new SqlParameter("@TwelvePlanMoney",SqlDbType.Float),
                new SqlParameter("@TwelvePlanMoneyMin",SqlDbType.Float),
                new SqlParameter("@TwelvePlanAmount",SqlDbType.Decimal)};
            param[0].Value = plan.KjYear;
            param[1].Value = plan.DeptCode;
            param[2].Value = plan.PersonCode;
            param[3].Value = plan.CusCode;
            param[4].Value = plan.WareCode;
            param[5].Value = plan.YearPlanMoney;
            param[6].Value = plan.YearPlanMoneyMin;
            param[7].Value = plan.YearPlanAmount;
            param[8].Value = plan.OnePlanMoney;
            param[9].Value = plan.OnePlanMoneyMin;
            param[10].Value = plan.OnePlanAmount;
            param[11].Value = plan.TwoPlanMoney;
            param[12].Value = plan.TwoPlanMoneyMin;
            param[13].Value = plan.TwoPlanAmount;
            param[14].Value = plan.ThreePlanMoney;
            param[15].Value = plan.ThreePlanMoneyMin;
            param[16].Value = plan.ThreePlanAmount;
            param[17].Value = plan.FourPlanMoney;
            param[18].Value = plan.FourPlanMoneyMin;
            param[19].Value = plan.FourPlanAmount;
            param[20].Value = plan.FivePlanMoney;
            param[21].Value = plan.FivePlanMoneyMin;
            param[22].Value = plan.FivePlanAmount;
            param[23].Value = plan.SixPlanMoney;
            param[24].Value = plan.SixPlanMoneyMin;
            param[25].Value = plan.SixPlanAmount;
            param[26].Value = plan.SevenPlanMoney;
            param[27].Value = plan.SevenPlanMoneyMin;
            param[28].Value = plan.SevenPlanAmount;
            param[29].Value = plan.EightPlanMoney;
            param[30].Value = plan.EightPlanMoneyMin;
            param[31].Value = plan.EightPlanAmount;
            param[32].Value = plan.NinePlanMoney;
            param[33].Value = plan.NinePlanMoneyMin;
            param[34].Value = plan.NinePlanAmount;
            param[35].Value = plan.TenPlanMoney;
            param[36].Value = plan.TenPlanMoneyMin;
            param[37].Value = plan.TenPlanAmount;
            param[38].Value = plan.ElevenPlanMoney;
            param[39].Value = plan.ElevenPlanMoneyMin;
            param[40].Value = plan.ElevenPlanAmount;
            param[41].Value = plan.TwelvePlanMoney;
            param[42].Value = plan.TwelvePlanMoneyMin;
            param[43].Value = plan.TwelvePlanAmount;
            return common.Excute("UpdatePersonSetProcedure", param);

        }
        /// <summary>
        /// 删除销售员计划编制
        /// </summary>
        /// <param name="plan"></param>
        /// <returns></returns>
        public int DeletePersonSet(XS_Plan plan)
        {
            SqlParameter[] param ={ new SqlParameter("@PlanId", SqlDbType.Int) };
            param[0].Value = plan.PlanID;
            return common.Excute("DeletePersonSetProcedure", param);

        }

    }
}