ZLPMS/PMS.DBService/BaseCode/ProblemClassfyService.cs

using PMS.BusinessModels.Account;
using PMS.BusinessModels.Problem;
using QWPlatform.IService;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace PMS.DBService.BaseCode
{
    public class ProblemClassfyService: DataServiceBase
    {
        public DataTable GetTreeGrid(UserInfo user)
        {
            var sql = @"select * from 问题分值管理 where 所属渠道ID=:ChannelId and 是否删除!=1
                       Start With 上级ID is null
                       connect By Prior ID=上级ID
                       order Siblings by 编码 asc";
            return this.SqlBuilder.SqlText(sql).Parameters("ChannelId", user.CompanyID).Select();
        }
        public DataTable GetClassTree(UserInfo user)
        {
            var sql = @"select ID,名称|| '('|| 编码 ||')' as 名称,上级ID from 问题分值管理 where 所属渠道ID=:ChannelId and 是否删除!=1
                       Start With 上级ID is null
                       connect By Prior ID=上级ID
                       order Siblings by 编码 asc";
            return this.SqlBuilder.SqlText(sql).Parameters("ChannelId", user.CompanyID).Select();
        }
        public bool AddClass(ProblemClassModel model)
        {
            return this.InsertBuilder.Insert("问题分值管理")
                                     .Column("ID",Guid.NewGuid().ToString())
                                     .Column("上级ID",model.parentid)
                                     .Column("编码",model.Coding)
                                     .Column("名称",model.name)
                                     .Column("分值", model.ClassCore)
                                     .Column("说明",model.Deatil)
                                     .Column("所属渠道ID", model.ChanelId)
                                     .Execute()>0;
        }
        public bool DelClass(string id)
        {
            return this.UpdateBuilder.Column("是否删除", 1)
                                      .Where("ID", id)
                                      .Update("问题分值管理")
                                      .Execute() > 0;
        }
        public DataTable GetProblemClassByID(string id)
        {
            return this.SqlBuilder.SqlText("Select ID,上级ID,编码,名称,说明,分值 from 问题分值管理 where ID=:id").Parameters("id", id).Select();
        }
        public  bool EditClass(ProblemClassModel model)
        {
            var t = this.UpdateBuilder.Column("上级ID", model.parentid)
                                     .Column("编码", model.Coding)
                                     .Column("名称", model.name)
                                     .Column("说明", model.Deatil)
                                     .Column("分值", model.ClassCore)
                                     .Where("ID", model.ID)
                                     .Update("问题分值管理")
                                     .Execute();
            return t > 0;
        }
    }
}