Controllers/I3/I0304Controller.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 System.Web.UI.WebControls;

namespace OPMS.Controllers
{
    /// <summary>
    /// 费用报销，借款单
    /// </summary>
    public class I0304Controller : BaseController
    {
        private DBHelp db = new DBHelp();

        //
        // GET: /I0304/

        public ActionResult Index()
        {
            var i0304 = db.I0304.Include(i => i.i0302);
            return View(i0304.ToList());
        }

        public ActionResult ExIndex()
        {
            var i0304 = db.I0304.Include(i => i.i0302);
            return View(i0304.ToList());
        }

        //
        // GET: /I0304/Details/5

        public ActionResult Details(string id = null)
        {
            I0304 i0304 = db.I0304.Find(id);
            if (i0304 == null)
            {
                return HttpNotFound();
            }
            List<OPMS.Models.I0304a> list = db.I0304a.Where(t => t.RID == i0304.RID).ToList();
            ViewBag.list = list;
            return View(i0304);
        }

        //
        // GET: /I0304/Create

        public ActionResult Create()
        {
            int Applicant = CurrentUserInfo.Number;//申请人
            string StrSql = @"select i.BtripID ID,i.Title MC from I0302 i  where i.States<4 and i.States>0 and i.Traveler like '%" + Applicant + "%' and  i.TravelerName like '%" + CurrentUserInfo.Name + "%' ";//获取最大ID
            List<DropdownBoxTo> list = db.Database.SqlQuery<DropdownBoxTo>(StrSql).ToList();
            if (list != null && list.Count > 0)
            {
                ViewBag.BtripID = new SelectList(list, "ID", "MC");