Hl.DataDalSql/BizBaseInfo_Supplier/BizSupplierInfo.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 BizSupplierInfo : DataDalInterface.BizSupplierInfo
    {
        #region "访问"

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

        #endregion

        #region "命令"

        /// <summary>
        /// 新增一条记录
        /// </summary>
        private const string InsertCmdText = "INSERT [BizSupplierInfo] ([ClassId],[ClassNo],[Code],[Name],[ContactPhone],[ContactFixed],[ContactFax],[ContactPostalCode],[ContactArea],[ContactAddress],[BusinessLinkMan],[BusinessLinkPhone],[FinanceLinkMan],[FinanceLinkPhone],[MainBrandList],[Note],[CheckOutWayId],[CheckOutWayNo],[BillTypeId],[BillTypeNo],[Rank],[TaxPoint],[FullName],[LegalPerson],[LegalPersonPhone],[DepositBank],[DepositBankAccount],[BusinessRegisterNo],[TaxRegisterNo],[CreateDate],[UpdateDate],[AdmShopId]) VALUES(@ClassId,@ClassNo,@Code,@Name,@ContactPhone,@ContactFixed,@ContactFax,@ContactPostalCode,@ContactArea,@ContactAddress,@BusinessLinkMan,@BusinessLinkPhone,@FinanceLinkMan,@FinanceLinkPhone,@MainBrandList,@Note,@CheckOutWayId,@CheckOutWayNo,@BillTypeId,@BillTypeNo,@Rank,@TaxPoint,@FullName,@LegalPerson,@LegalPersonPhone,@DepositBank,@DepositBankAccount,@BusinessRegisterNo,@TaxRegisterNo,@CreateDate,@UpdateDate,@AdmShopId) Select @@IDENTITY";

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

        /// <summary>
        /// 更新一条记录
        /// </summary>
        private const string UpdateCmdText = "UPDATE [BizSupplierInfo] SET [ClassId]=@ClassId,[ClassNo]=@ClassNo,[Code]=@Code,[Name]=@Name,[ContactPhone]=@ContactPhone,[ContactFixed]=@ContactFixed,[ContactFax]=@ContactFax,[ContactPostalCode]=@ContactPostalCode,[ContactArea]=@ContactArea,[ContactAddress]=@ContactAddress,[BusinessLinkMan]=@BusinessLinkMan,[BusinessLinkPhone]=@BusinessLinkPhone,[FinanceLinkMan]=@FinanceLinkMan,[FinanceLinkPhone]=@FinanceLinkPhone,[MainBrandList]=@MainBrandList,[Note]=@Note,[CheckOutWayId]=@CheckOutWayId,[CheckOutWayNo]=@CheckOutWayNo,[BillTypeId]=@BillTypeId,[BillTypeNo]=@BillTypeNo,[Rank]=@Rank,[TaxPoint]=@TaxPoint,[FullName]=@FullName,[LegalPerson]=@LegalPerson,[LegalPersonPhone]=@LegalPersonPhone,[DepositBank]=@DepositBank,[DepositBankAccount]=@DepositBankAccount,[BusinessRegisterNo]=@BusinessRegisterNo,[TaxRegisterNo]=@TaxRegisterNo,[CreateDate]=@CreateDate,[UpdateDate]=@UpdateDate,[AdmShopId]=@AdmShopId WHERE [Id]=@Id";

        /// <summary>
        /// 查询一条记录
        /// </summary>
        private const string SelectCmdText = "SELECT * FROM [BizSupplierInfo] 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("@ClassId",SqlDbType.Int,4),
                    new SqlParameter("@ClassNo",SqlDbType.NVarChar,50),
                    new SqlParameter("@Code",SqlDbType.NVarChar,50),