DAL/CompanyDAL.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using Entitry;
using Common;
namespace DAL
{
    public class CompanyDAL
    {
        public  List<company> GetCompany()
        {
            string sql = "select * from company where state=1";
            SqlDataReader sqlReader = DBHelp.SelectData(sql);

            List<company> Company = new List<company>();
            while (sqlReader.Read())
            {
                company f = new company();
                f.companyID = (int)sqlReader["companyID"];
                f.CText = (string)sqlReader["CText"];
                f.CName = (string)sqlReader["CName"];
                f.Lable = (string)sqlReader["Lable"];
                f.ProductPic = (string)sqlReader["ProductPic"];
                f.ProductName = (string)sqlReader["ProductName"];
                f.ProductUrl = (string)sqlReader["ProductUrl"];
                f.ProductTxt = (string)sqlReader["ProductTxt"];
                f.Address = (string)sqlReader["Address"];
                f.Count = (string)sqlReader["Count"];
                f.IndexUrl = (string)sqlReader["IndexUrl"];
                f.ThisFinacncing = (string)sqlReader["ThisFinacncing"];
                f.Finacning = (string)sqlReader["Finacning"];
                f.FinacningName = (string)sqlReader["FinacningName"];
                f.CreateName = (string)sqlReader["CreateName"];
                f.CreateTxt = (string)sqlReader["CreateTxt"];
                f.Report = (string)sqlReader["Report"];
                f.ReportUrl = (string)sqlReader["ReportUrl"];
                f.state=(int)sqlReader["state"];
                Company.Add(f);
            }
            sqlReader.Close();
            return Company;
        }
        public static List<company> SearchComp(string cmpName)
        {
            string sql = "select * from company where state=1 and CText='" + cmpName + "'";
            SqlDataReader sqlReader = DBHelp.SelectData(sql);

            List<company> Company = new List<company>();
            while (sqlReader.Read())
            {
                company f = new company();
                f.companyID = (int)sqlReader["companyID"];
                f.CText = (string)sqlReader["CText"];
                f.CName = (string)sqlReader["CName"];
                f.Lable = (string)sqlReader["Lable"];
                f.ProductPic = (string)sqlReader["ProductPic"];
                f.ProductName = (string)sqlReader["ProductName"];