App_Code/BLL/Company.cs

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

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

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using SystemDAL;
using SystemModel;
using System.Data.OleDb;
using Wuqi.Webdiyer;

/// <summary>
/// company 的摘要说明
/// </summary>
/// 

namespace SystemCompany
{
    public class Company
    {
        public Company()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }
        #region 公司简介 后台
        #region 搜索绑定
        /// <summary>
        /// 搜索查询得出总条目所用
        /// </summary>
        /// <param name="search">关键字</param>
        /// <param name="searchsort">类别：可以为空null</param>
        /// <returns>int数量</returns>
        public static int CountSearch(string search, string searchsort)
        {
            string cmdText = "";
            if (search != null)
            {
                cmdText = "select [company].*,[companyclass].name,[companyclass].name_en from [company],[companyclass] where [company].classid=[companyclass].cid and ([companyclass].name=@searchname or [companyclass].name_en=@searchname) order by [company].xuhao asc";
                int nresult = 0;
                try
                {
                    OleDbParameter[] OleDbParameter =
                {
                    new OleDbParameter("@searchname",search)
                };
                    DAL dal = new DAL();
                    DataSet ds = dal.OleExecuteDataSet(cmdText, OleDbParameter);
                    return nresult = Convert.ToInt32(ds.Tables[0].DefaultView.Count);
                }
                catch (Exception E)
                {
                    throw E;
                }
            }
            else