DAL/CompanyInfo.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Common;
using Entitry;
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;

namespace DAL
{
   public  class CompanyInfo
    {
        public static int AddCompanyInfo(company company) {

            string sql = "insert into company(CText,CName,ProductPic,ProductUrl,Address,ProductName,Count,ThisFinacncing,Finacning,FinacningName,ProductTxt,state)values('" + company.CText + "','" + company.CName + "','" + company.ProductPic + "','" + company.ProductUrl + "','" + company.Address + "','" + company.ProductName + "','" + company.Count + "','" + company.ThisFinacncing + "','" + company.Finacning + "','" + company.FinacningName + "','" + company.ProductTxt + "',1)";

            int add = DBHelp.AddData(sql);           
            return add;
        
        }
       //tag页面添加信息

        public static int AddCompanyInfoTag(string company)
        {

            string sql = "update company set Lable='"+company+"' where companyID=(select max(companyID)from company)";

            int add = DBHelp.AddData(sql);
            return add;

        }
        public static int AddCompanyInfoFounder(company company)
        {

            string sql = "update company set  CreateName='"+company.CreateName+"',createPic='"+company.CreatePic+"',CreatePosition='"+company.CreatePosition+"' where companyID=(select max(companyID)from company)";

            int add = DBHelp.AddData(sql);
            return add;

        }

        public static int AddCompanyInfoIndex02(company company)
        {

            string sql = "update company set  ProductName='"+company.ProductName+"',ProductUrl='"+company.ProductUrl+"',ProductTxt='"+company.ProductTxt+"' where companyID=(select max(companyID)from company)";

            int add = DBHelp.AddData(sql);
            return add;

        }

        public static int AddCompanyInfoIndex03(company company)
        {

            string sql = "update company set Report='"+company.Report+"' where companyID=(select max(companyID)from company)";

            int add = DBHelp.AddData(sql);