WebClass/CompanyBDL.cs

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

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using Utils;

namespace WebClass
{
	public class CompanyBDL
	{
		public HelpCompany gettb_CompanyObj(int id)
		{
			HelpCompany result;
			using (huadushuiEntities db = new huadushuiEntities())
			{
				HelpCompany query = (from a in db.tb_Company
				where a.Id == id
				select new HelpCompany
				{
					bz = a.bz,
					cz = a.cz,
					dzyj = a.dzyj,
					fgy = a.fgy,
					fgyid = a.fgyid,
					gcdz = a.gcdz,
					gcmc = a.gcmc,
					Id = a.Id,
					jfmc = a.jfmc,
					jsxqy = a.jsxqy,
					jsxqydm = a.jsxqydm,
					lxbm = a.lxbm,
					lxdh = a.lxdh,
					lxr = a.lxr,
					qybh = a.qybh,
					sbsl = a.sbsl,
					sshy = a.sshy,
					xzds = a.xzds,
					ysed = a.ysed,
					yszzrz = a.yszzrz,
					yzbm = a.yzbm,
					zgld = a.zgld,
					pianqustr = a.pianqustr,
					sshyname = (from b in db.TypeList
					where b.ListID == a.sshy.Value
					select b.TypeName).FirstOrDefault<string>(),
					xydsname = (from c in db.TypeList
					where c.ListID == a.xzds.Value
					select c.TypeName).FirstOrDefault<string>()
				}).FirstOrDefault<HelpCompany>();
				result = query;
			}
			return result;
		}

		public HelpCompanyHistory gettb_Company_historyObj(int id)
		{
			HelpCompanyHistory result;
			using (huadushuiEntities db = new huadushuiEntities())
			{
				HelpCompanyHistory query = (from a in db.tb_Company_history