【Net】.Net 文本框实现内容提示的实例代码(仿Google、Baidu)-文本框-内容提示

欢迎您访问我爱IT技术网，今天小编为你分享的编程技术是：【.Net 文本框实现内容提示的实例代码(仿Google、Baidu)】，下面是详细的讲解！

.Net 文本框实现内容提示的实例代码(仿Google、Baidu)

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web.UI;
using Oceansoft.Net.Bll;
using SubSonic;
using System.Transactions;

using System.Data;
using Oceansoft.Net.Dal;

 

namespace Oceansoft.Net.Bll
{
    /// <summary>
    /// :ceshi
    /// :jibp
    /// :2014-2-27 15:52:15
    ///</summary>
    public class CeshiManage
    {

        private SqlQuery m_sqlquery=Oceansoft.Net.Dal.DB.Select().From(Ceshi.Schema);

        /// <summary>
        /// Ceshi查询器
        /// </summary>
        public SqlQuery CeshiSelecter
        {
            get { return m_sqlquery; }
            set { m_sqlquery=value; }
        }

        /// <summary>
        /// 构造函数,设置查询器
        ///</summary>
        public CeshiManage()
        {
            m_sqlquery=m_sqlquery.Where("id").IsNotEqualTo("");
        }

        #region Ceshi管理

        /// <summary>
        /// 获取ceshi列表
        /// </summary>
        /// <returns></returns>
        public List<Ceshi> getCeshiList()
        {

            return CeshiSelecter.ExecuteTypedList<Ceshi>();
        }

        /// <summary>
        /// 获取ceshi列表,同时分页操作
        /// </summary>
        /// <returns></returns>
        public List<Ceshi> getCeshiList(int currentPage, int pageSize, out int RecordCount)
        {
            RecordCount=m_sqlquery.GetRecordCount();
            return CeshiSelecter
            .Paged(currentPage, pageSize)
            .ExecuteTypedList<Ceshi>();
        }

 

 

        /// <summary>
        /// 新增 ceshi
        /// </summary>
        /// <param name="HandleEntity"></param>
        /// <param name="sErr"></param>
        /// <returns></returns>
        public bool AddCeshi(Ceshi beAddMode, out string sErr)
        {

            sErr="";
            bool bRet=true;
            try
            {

                using (TransactionScope sc=new TransactionScope())
                {
                    //此处写代码
                    //流水编号的生成
                    //GenerateNo No=new GenerateNo();
                    //No.TableName="Ceshi"; //表名
                    //No.NoName="XXX";   //流水号前字母
                    //No.ColName="CC_Number";  //编号字段
                    //No.CreateTime="CC_CreateTime";  //日期字段
                    //string BillNo="";
                    //Customer_Comp.CC_Number=No.AutoGenerateNo();
                    beAddMode.IsNew=true;
                    beAddMode.Save();
                    //LogHelper.WriteLog(logType.新增 , logModule.Deptrelation,"ceshi新增成功("+beAddMode.GetPrimaryKeyValue().ToString()
                    //+")!");
                    //如果生成扩展类请使用add方法方法
                    sc.Complete();
                }
            }
            catch (Exception ex)
            {
                sErr="ceshi新增不成功!";
                return false;
            }

            sErr="ceshi新增成功!";
            return bRet;

        }

 

        /// <summary>
        /// 修改 ceshi
        /// </summary>
        /// <param name="HandleEntity"></param>
        /// <param name="sErr"></param>
        /// <returns></returns>
        public bool UpdataCeshi(Ceshi beUpdataMode, out string sErr)
        {

            sErr="";
            bool bRet=true;
            try
            {

                using (TransactionScope sc=new TransactionScope())
                {

                    //如果生成扩展类请使用Update()方法方法
                    beUpdataMode.IsNew=false;
                    beUpdataMode.Save();
                    //LogHelper.WriteLog(logType.修改 , logModule.Deptrelation,"ceshi修改成功("+beUpdataMode.GetPrimaryKeyValue().ToString()
                    //+")!");

                    sc.Complete();
                }
            }
            catch (Exception ex)
            {
                sErr="ceshi修改不成功!";
                return false;
            }

            sErr="ceshi修改成功!";
            return bRet;

        }

 

        /// <summary>
        /// 删除 ceshi
        /// </summary>
        /// <param name="HandleEntity"></param>
        /// <param name="sErr"></param>
        /// <returns></returns>
        public bool DeleteCeshi(Ceshi beDeleteMode, out string sErr)
        {
            sErr="";
            bool bRet=true;
            try
            {

                using (TransactionScope sc=new TransactionScope())
                {
                    //如果生成扩展类请使用Delete()方法方法
                    Ceshi.Delete(beDeleteMode.GetPrimaryKeyValue());
                    //LogHelper.WriteLog(logType.删除 , logModule.Deptrelation,"ceshi删除成功("+beDeleteMode.GetPrimaryKeyValue().ToString()
                    //+")!");
                    sc.Complete();
                }
            }
            catch (Exception ex)
            {
                sErr="ceshi删除不成功!";
                return false;
            }

            sErr="ceshi删除成功!";
            return bRet;

        }

        /// <summary>
        /// 删除 ceshi 列表
        /// </summary>
        /// <param name="HandleEntity"></param>
        /// <param name="sErr"></param>
        /// <returns></returns>
        public bool DeleteCeshiList(List<Ceshi> lstCeshi, out string sErr)
        {

            sErr="";
            int ii=0;
            bool bRet=true;
            try
            {

                using (TransactionScope sc=new TransactionScope())
                {
                    //如果生成扩展类请使用Delete()方法方法
                    foreach (Ceshi bedelmode in lstCeshi)
                    {
                        ii++;
                        Ceshi.Delete(bedelmode.GetPrimaryKeyValue());

                        //LogHelper.WriteLog(logType.删除 , logModule.Deptrelation,"ceshi删除成功("+bedelmode.GetPrimaryKeyValue().ToString()
                        //+")!");
                    }
                    sc.Complete();
                }
            }
            catch (Exception ex)
            {
                sErr="ceshi删除不成功!";
                return false;
            }

            sErr="共" + ii.ToString() + "条单据删除成功!";
            return bRet;

 

        }

        public  void GetTopUserName(int topCount, string name, out List<string> listId, out  List<string> listcname)
        {
            string sql=string.Format(@"Select id,cname from(Select ROW_NUMBER() over(order by cname)as ROWNUM," +
                "id,cname FROM [dbo].[Ceshi] where cname like '%" + name + "%' or  dbo.f_GetPy(cname) like '%" + name + "%') as ta where ta.ROWNUM <=" + topCount);
            DataTable dt=new DataTable();
            QueryCommand qc=new InlineQuery().GetCommand(sql);
            dt=DataService.GetDataSet(qc).Tables[0];//将查询出来的数据集放到List中去（查询数据的方法，有很多，这边我用的是Subsonic类自带的查询方法）
            listcname=new List<string>();
            listId=new List<string>();
            foreach (DataRow row in dt.Rows)
            {

                listId.Add(row[0].ToString());
                listcname.Add(row[1].ToString());

            }

        }

       #endregion

    }
}

关于.Net 文本框实现内容提示的实例代码(仿Google、Baidu)的用户互动如下：

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细