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

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

        #endregion

        #region "命令"

        /// <summary>
        /// 新增一条记录
        /// </summary>
        private const string InsertCmdText = "INSERT [BizServicePart] ([Code],[Name],[Note],[ClassId],[ClassNo],[BrandId],[BrandNo],[VtypeId],[VtypeNo],[ManufactureType],[AbcType],[UnitName],[EntityCode],[Dosage],[StandingStockFlag],[GenericCode],[GenericCode1],[GenericCode2],[GenericCode3],[SpecifiedUserId],[SpecifiedUserNo],[SpecifiedPrice],[SpecifiedDate],[RetailPrice],[TradePrice],[LastestBuyingPrice],[LastestBuyingDate],[LowestBuyingPrice],[LowestBuyingDate],[HighestBuyingPrice],[HighestBuyingDate],[OpponentPrice],[Price4S],[Specification],[Volume],[Weight],[Long],[Width],[Height],[Photo],[BarCode],[FirstChoiceSupplierId],[Operator],[MnemonicCode],[PartsName1],[PartsName2],[PartsNameEn],[Manufacturer],[StockUpperLimit],[StockLowerLimit],[CreateDate],[UpdateDate],[AdmShopId]) VALUES(@Code,@Name,@Note,@ClassId,@ClassNo,@BrandId,@BrandNo,@VtypeId,@VtypeNo,@ManufactureType,@AbcType,@UnitName,@EntityCode,@Dosage,@StandingStockFlag,@GenericCode,@GenericCode1,@GenericCode2,@GenericCode3,@SpecifiedUserId,@SpecifiedUserNo,@SpecifiedPrice,@SpecifiedDate,@RetailPrice,@TradePrice,@LastestBuyingPrice,@LastestBuyingDate,@LowestBuyingPrice,@LowestBuyingDate,@HighestBuyingPrice,@HighestBuyingDate,@OpponentPrice,@Price4S,@Specification,@Volume,@Weight,@Long,@Width,@Height,@Photo,@BarCode,@FirstChoiceSupplierId,@Operator,@MnemonicCode,@PartsName1,@PartsName2,@PartsNameEn,@Manufacturer,@StockUpperLimit,@StockLowerLimit,@CreateDate,@UpdateDate,@AdmShopId) Select @@IDENTITY";

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

        /// <summary>
        /// 更新一条记录
        /// </summary>
        private const string UpdateCmdText = "UPDATE [BizServicePart] SET [Code]=@Code,[Name]=@Name,[Note]=@Note,[ClassId]=@ClassId,[ClassNo]=@ClassNo,[BrandId]=@BrandId,[BrandNo]=@BrandNo,[VtypeId]=@VtypeId,[VtypeNo]=@VtypeNo,[ManufactureType]=@ManufactureType,[AbcType]=@AbcType,[UnitName]=@UnitName,[EntityCode]=@EntityCode,[Dosage]=@Dosage,[StandingStockFlag]=@StandingStockFlag,[GenericCode]=@GenericCode,[GenericCode1]=@GenericCode1,[GenericCode2]=@GenericCode2,[GenericCode3]=@GenericCode3,[SpecifiedUserId]=@SpecifiedUserId,[SpecifiedUserNo]=@SpecifiedUserNo,[SpecifiedPrice]=@SpecifiedPrice,[SpecifiedDate]=@SpecifiedDate,[RetailPrice]=@RetailPrice,[TradePrice]=@TradePrice,[LastestBuyingPrice]=@LastestBuyingPrice,[LastestBuyingDate]=@LastestBuyingDate,[LowestBuyingPrice]=@LowestBuyingPrice,[LowestBuyingDate]=@LowestBuyingDate,[HighestBuyingPrice]=@HighestBuyingPrice,[HighestBuyingDate]=@HighestBuyingDate,[OpponentPrice]=@OpponentPrice,[Price4S]=@Price4S,[Specification]=@Specification,[Volume]=@Volume,[Weight]=@Weight,[Long]=@Long,[Width]=@Width,[Height]=@Height,[Photo]=@Photo,[BarCode]=@BarCode,[FirstChoiceSupplierId]=@FirstChoiceSupplierId,[Operator]=@Operator,[MnemonicCode]=@MnemonicCode,[PartsName1]=@PartsName1,[PartsName2]=@PartsName2,[PartsNameEn]=@PartsNameEn,[Manufacturer]=@Manufacturer,[StockUpperLimit]=@StockUpperLimit,[StockLowerLimit]=@StockLowerLimit,[CreateDate]=@CreateDate,[UpdateDate]=@UpdateDate,[AdmShopId]=@AdmShopId WHERE [Id]=@Id";

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

        /// <summary>
        /// 更新配件指导价格
        /// </summary>
        private const string UpdateSpecifiedPriceCmdText = "UPDATE [BizServicePart] SET SpecifiedUserId=@SpecifiedUserId,SpecifiedUserNo=@SpecifiedUserNo,SpecifiedPrice=@SpecifiedPrice,SpecifiedDate=getdate() Where [Code]=@Code ";

        #endregion

        #region "参数"

        /// <summary>
        /// 新增一条记录
        /// </summary>
        private IDbDataParameter[] InsertParameters()
        {
            IDbDataParameter[] paramlist = (IDbDataParameter[])Hl.DataDbHelper.DbUlitity.GetCacheParameters(InsertCmdText);
            if (paramlist == null)