Hl.DataDalSql/BizBaseInfo_Customer/BizCustomerInfo.cs

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

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

using System;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using Hl.Code;
namespace Hl.DataDalSql
{
    /// <summary>
    /// 客户信息[DAL]  
    /// </summary>
    public class BizCustomerInfo : DataDalInterface.BizCustomerInfo
    {
        #region "访问"

        /// <summary>
        /// DbHelper
        /// </summary>
        private Hl.DataDbHelper.DbHelper DbHelper = Hl.DataDbHelper.DbUlitity.Instance();

        #endregion

        #region "命令"

        /// <summary>
        /// 新增一条记录
        /// </summary>
        private const string InsertCmdText = "INSERT [BizCustomerInfo] ([CustomerNo],[CustomerClassId],[CustomerClassNo],[CustomerName],[CustomerRank],[CustomerNote],[CustomerFullName],[CustomerSource],[CustomerSignedClient],[ContactFixed],[ContactPhone],[ContactWebPage],[ContactFax],[ContactMsnOrQq],[ContactEmail],[ContactIdCard],[ContactPostalCode],[ContactAreaProv],[ContactAreaCity],[ContactAreaXian],[ContactAddress],[ContactAddressStatus],[LegalPersonName],[LegalPersonPhone],[BankDeposit],[BankAccount],[UnitRegNo],[UnitTaxNo],[UnitNote],[UnitCreditLimit],[UintPreTakeRate],[UintCreditDays],[UnitCheckOutWayId],[UintCheckOutWayNo],[UnitBillTypeId],[UintBillTypeNo],[CsChargeId],[CsChargeNo],[MarketingId],[MarketingNo],[SalesmanId],[SalesmanNo],[FollowNote],[CreateDate],[UpdateDate],[AdmShopId]) VALUES(@CustomerNo,@CustomerClassId,@CustomerClassNo,@CustomerName,@CustomerRank,@CustomerNote,@CustomerFullName,@CustomerSource,@CustomerSignedClient,@ContactFixed,@ContactPhone,@ContactWebPage,@ContactFax,@ContactMsnOrQq,@ContactEmail,@ContactIdCard,@ContactPostalCode,@ContactAreaProv,@ContactAreaCity,@ContactAreaXian,@ContactAddress,@ContactAddressStatus,@LegalPersonName,@LegalPersonPhone,@BankDeposit,@BankAccount,@UnitRegNo,@UnitTaxNo,@UnitNote,@UnitCreditLimit,@UintPreTakeRate,@UintCreditDays,@UnitCheckOutWayId,@UintCheckOutWayNo,@UnitBillTypeId,@UintBillTypeNo,@CsChargeId,@CsChargeNo,@MarketingId,@MarketingNo,@SalesmanId,@SalesmanNo,@FollowNote,@CreateDate,@UpdateDate,@AdmShopId) Select @@IDENTITY";

        /// <summary>
        /// 删除一条记录
        /// </summary>
        private const string DeleteCmdText = "DELETE [BizCustomerInfo] Where [Id]=@Id";

        /// <summary>
        /// 更新一条记录
        /// </summary>
        private const string UpdateCmdText = "UPDATE [BizCustomerInfo] SET [CustomerNo]=@CustomerNo,[CustomerClassId]=@CustomerClassId,[CustomerClassNo]=@CustomerClassNo,[CustomerName]=@CustomerName,[CustomerRank]=@CustomerRank,[CustomerNote]=@CustomerNote,[CustomerFullName]=@CustomerFullName,[CustomerSource]=@CustomerSource,[CustomerSignedClient]=@CustomerSignedClient,[ContactFixed]=@ContactFixed,[ContactPhone]=@ContactPhone,[ContactWebPage]=@ContactWebPage,[ContactFax]=@ContactFax,[ContactMsnOrQq]=@ContactMsnOrQq,[ContactEmail]=@ContactEmail,[ContactIdCard]=@ContactIdCard,[ContactPostalCode]=@ContactPostalCode,[ContactAreaProv]=@ContactAreaProv,[ContactAreaCity]=@ContactAreaCity,[ContactAreaXian]=@ContactAreaXian,[ContactAddress]=@ContactAddress,[ContactAddressStatus]=@ContactAddressStatus,[LegalPersonName]=@LegalPersonName,[LegalPersonPhone]=@LegalPersonPhone,[BankDeposit]=@BankDeposit,[BankAccount]=@BankAccount,[UnitRegNo]=@UnitRegNo,[UnitTaxNo]=@UnitTaxNo,[UnitNote]=@UnitNote,[UnitCreditLimit]=@UnitCreditLimit,[UintPreTakeRate]=@UintPreTakeRate,[UintCreditDays]=@UintCreditDays,[UnitCheckOutWayId]=@UnitCheckOutWayId,[UintCheckOutWayNo]=@UintCheckOutWayNo,[UnitBillTypeId]=@UnitBillTypeId,[UintBillTypeNo]=@UintBillTypeNo,[CsChargeId]=@CsChargeId,[CsChargeNo]=@CsChargeNo,[MarketingId]=@MarketingId,[MarketingNo]=@MarketingNo,[SalesmanId]=@SalesmanId,[SalesmanNo]=@SalesmanNo,[FollowNote]=@FollowNote,[CreateDate]=@CreateDate,[UpdateDate]=@UpdateDate,[AdmShopId]=@AdmShopId WHERE [Id]=@Id";

        /// <summary>
        /// 查询一条记录
        /// </summary>
        private const string SelectCmdText = "SELECT * FROM [BizCustomerInfo] WHERE [Id]=@Id";

        #endregion

        #region "参数"

        /// <summary>
        /// 新增一条记录
        /// </summary>
        private IDbDataParameter[] InsertParameters()
        {
            IDbDataParameter[] paramlist = (IDbDataParameter[])Hl.DataDbHelper.DbUlitity.GetCacheParameters(InsertCmdText);
            if (paramlist == null)
            {
                paramlist = new SqlParameter[]{
                    new SqlParameter("@CustomerNo",SqlDbType.NVarChar,50),
                    new SqlParameter("@CustomerClassId",SqlDbType.Int,4),
                    new SqlParameter("@CustomerClassNo",SqlDbType.NVarChar,50),