DAL/ProjectInfoDAL.cs

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

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

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

namespace DAL
{
    public class ProjectInfoDAL
    {


        /// <summary>
        /// 添加 
        ///</summary>
        public static int AddProjectInfo(ProjectInfo ProjectInfoModel)
        {
            string sql = string.Format("insert into  ProjectInfo (ProjectNum,ProjectName,AuditState,AuditWhy,ApprovalState,UserId,EntryTime,Members,Reason,UserIds )values('{0}','{1}','{2}','{3}','{4}',{5},'{6}','{7}','{8}',{9})",ProjectInfoModel.ProjectNum,ProjectInfoModel.ProjectName,ProjectInfoModel.AuditState,ProjectInfoModel.AuditWhy,ProjectInfoModel.ApprovalState,ProjectInfoModel.UserId,ProjectInfoModel.EntryTime,ProjectInfoModel.Members,ProjectInfoModel.Reason,ProjectInfoModel.UserIds);
            return DBHelper.ExecuteCommand(sql);
        }

        /// <summary>
        /// 查询最大id
        /// </summary>
        /// <returns></returns>
        public static int MaxId()
        {
            string sql = string.Format(@"select max(ProjectInfoId) from ProjectInfo");
            return DBHelper.GetIntScalar2(sql);
        }
        /// <summary>
        /// 查询预约项目最大id
        /// </summary>
        /// <returns></returns>
        public static int BookMaxId()
        {
            string sql = string.Format(@"select max(bookid) from ProjectBook");
            return DBHelper.GetIntScalar2(sql);
        }

        /// <summary> 
        /// 根据ID修改 
        ///</summary>
        public static int UpdateProjectInfo(ProjectInfo ProjectInfoModel)
        {
            string sql = string.Format(" UPDATE ProjectInfo  set ProjectNum='{0}',ProjectName='{1}',AuditState='{2}',AuditWhy='{3}',ApprovalState='{4}',UserId={5},EntryTime='{6}',Members='{7}',Reason='{8}',UserIds={9} where ProjectInfoId={10} ",ProjectInfoModel.ProjectNum,ProjectInfoModel.ProjectName,ProjectInfoModel.AuditState,ProjectInfoModel.AuditWhy,ProjectInfoModel.ApprovalState,ProjectInfoModel.UserId,ProjectInfoModel.EntryTime,ProjectInfoModel.Members,ProjectInfoModel.Reason,ProjectInfoModel.UserIds  ,ProjectInfoModel.ProjectInfoId);
            return DBHelper.ExecuteCommand(sql);
        }

        /// <summary> 
        /// 根据主键删除 
        ///</summary>
        public static int DeleteProjectInfo(int Id)
        {
            string sql = string.Format("delete from ProjectInfo where ProjectInfoId={0}", Id);
            return DBHelper.ExecuteCommand(sql);
        }