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

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

        #endregion

        #region "命令"

        /// <summary>
        /// 新增一条记录
        /// </summary>
        private const string InsertCmdText = "INSERT [BizServicePartOrderSale] ([OrderCode],[OrderNote],[CustomerId],[CustomerNo],[CustomerName],[BillTypeId],[BillTypeNo],[PaymentId],[PaymentNo],[InvoiceNo],[PackageMannerId],[PackageMannerNo],[TransportMannerId],[TransportMannerNo],[WarehouseKeeperId],[WarehouseKeeperNo],[PartsDirectorId],[PartsDirectorNo],[OperatorId],[OperatorNo],[EnsureDate],[CreateDate],[UpdateDate],[DeleteFlag],[Status],[AdmShopId]) VALUES(@OrderCode,@OrderNote,@CustomerId,@CustomerNo,@CustomerName,@BillTypeId,@BillTypeNo,@PaymentId,@PaymentNo,@InvoiceNo,@PackageMannerId,@PackageMannerNo,@TransportMannerId,@TransportMannerNo,@WarehouseKeeperId,@WarehouseKeeperNo,@PartsDirectorId,@PartsDirectorNo,@OperatorId,@OperatorNo,@EnsureDate,@CreateDate,@UpdateDate,@DeleteFlag,@Status,@AdmShopId) Select @@IDENTITY";

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

        /// <summary>
        /// 更新一条记录
        /// </summary>
        private const string UpdateCmdText = "UPDATE [BizServicePartOrderSale] SET [OrderCode]=@OrderCode,[OrderNote]=@OrderNote,[CustomerId]=@CustomerId,[CustomerNo]=@CustomerNo,[CustomerName]=@CustomerName,[BillTypeId]=@BillTypeId,[BillTypeNo]=@BillTypeNo,[PaymentId]=@PaymentId,[PaymentNo]=@PaymentNo,[InvoiceNo]=@InvoiceNo,[PackageMannerId]=@PackageMannerId,[PackageMannerNo]=@PackageMannerNo,[TransportMannerId]=@TransportMannerId,[TransportMannerNo]=@TransportMannerNo,[WarehouseKeeperId]=@WarehouseKeeperId,[WarehouseKeeperNo]=@WarehouseKeeperNo,[PartsDirectorId]=@PartsDirectorId,[PartsDirectorNo]=@PartsDirectorNo,[OperatorId]=@OperatorId,[OperatorNo]=@OperatorNo,[EnsureDate]=@EnsureDate,[CreateDate]=@CreateDate,[UpdateDate]=@UpdateDate,[DeleteFlag]=@DeleteFlag,[Status]=@Status,[AdmShopId]=@AdmShopId WHERE [Id]=@Id";

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