Controllers/I1/I0102Controller.cs

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

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using OPMS.Models;
using OPMS.Common;
using System.Text;

namespace OPMS.Controllers
{
    public class I0102Controller : BaseController
    {
        //选择员工号
        private DBHelp db = new DBHelp();

        #region Index
        public ActionResult Index(string DCode = "0", string queryStr = null)
        {
            GetPDCode();//获取一级下拉框
            StringBuilder strSQl = new StringBuilder();
            strSQl.Append(@"SELECT DCode,DeptName,Leader,FullName +(select CASE Audit
              WHEN '7' THEN '[行政审核授权]'
               WHEN '8' THEN '[财务助理授权]'
                WHEN '9' THEN '[财务审核授权]'
                 WHEN '10' THEN '[总经理授权]'
                  else  '' end from I0105 where I0105.Number=I0102.Leader) FullName
               ,DeptDescription,PCode,ALevel FROM I0102 where 1=1 ");
            if (DCode != "0")
            {
                strSQl.Append(" and (PCode like '" + DCode + "' or DCode like '" + DCode + "') ");
            }
            if (!string.IsNullOrEmpty(queryStr))
            {
                strSQl.Append(" and DeptName like '" + queryStr + "' or FullName like '" + queryStr + "' ");
            }
            strSQl.Append(" order by DCode ,ALevel");
            List<I0102> mylist = db.Database.SqlQuery<I0102>(strSQl.ToString()).ToList();
            List<I0102> Data = new List<I0102>();
            Data = mylist;
            foreach (I0102 item in Data)
            {
                if (item.PCode != null)
                {
                    List<I0102> plist=mylist.Where(t => t.DCode == item.PCode).ToList();
                    if(plist.Count==1)
                        item.DeptName = plist[0].DeptName + "->" + item.DeptName;
                }
            }

            #region 以前组合方法 注释
            
            //IQueryable<I0102> lists = db.I0102;
           
            //List<I0102> list2 = new List<I0102>();
            //if (DCode != "0")
            //{
            //    list2 = lists.ToList(); //所有过滤