DAL/WorkExperience.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace DAL
{
    public class WorkExperience
    {
        /// <summary>
        /// 工作经验获取
        /// </summary>
        /// <param name="model_workexperience"></param>
        /// <returns></returns>
        public bool WorkExperienceAdd(Model.WorkExperience model_workexperience)
        {
            string sql = @" INSERT INTO WorkExperience VALUES(@EmployeeId,@Department,@JobContent,@Treatment,@StartDate, @EndDate,@ReasonsForLeaving,@Kdate,@Kuser)";
            SqlParameter[] sqlpa = 
             { 
             new  SqlParameter("@EmployeeId",model_workexperience.EmployeeId),
             new  SqlParameter("@Department",model_workexperience.Department),
             new  SqlParameter("@JobContent",model_workexperience.JobContent),
             new  SqlParameter("@Treatment",model_workexperience.Treatment),
             new  SqlParameter("@StartDate",model_workexperience.StartDate),
             new  SqlParameter("@EndDate",model_workexperience.EndDate),
             new  SqlParameter("@ReasonsForLeaving",model_workexperience.ReasonsForLeaving),
             new  SqlParameter("@Kdate",model_workexperience.Kdate),
             new  SqlParameter("@Kuser",model_workexperience.Kuser)
             };
            return DBhelp.ExecuteComand(sql, sqlpa);
        }

        /// <summary>
        /// 工作经验修改
        /// </summary>
        /// <param name="model_workexperience"></param>
        /// <returns></returns>
        public bool WorkExperienceUpdate(Model.WorkExperience model_workexperience)
        {

            string sql = @"UPDATE dbo.WorkExperience SET   Department=@Department,
JobContent=@JobContent,Treatment=@Treatment,StartDate=@StartDate,EndDate=@EndDate,ReasonsForLeaving=@ReasonsForLeaving
WHERE Rowid=@Rowid";
            SqlParameter[] sqlpa = 
             { 
              new SqlParameter("@Rowid",model_workexperience.Rowid),
             new  SqlParameter("@Department",model_workexperience.Department),
             new  SqlParameter("@JobContent",model_workexperience.JobContent),
             new  SqlParameter("@Treatment",model_workexperience.Treatment),
             new  SqlParameter("@StartDate",model_workexperience.StartDate),
             new  SqlParameter("@EndDate",model_workexperience.EndDate),
             new  SqlParameter("@ReasonsForLeaving",model_workexperience.ReasonsForLeaving)
             };
            return DBhelp.ExecuteComand(sql, sqlpa);
        }
        /// <summary>
        /// 工作经验修改
        /// </summary>
        /// <param name="model_workexperience"></param>