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

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

        #endregion

        #region "命令"

        /// <summary>
        /// 新增一条记录
        /// </summary>
        private const string InsertCmdText = "INSERT [BizServicePartStockChuKuDetail] ([OrderPurchaseId],[OrderPurchaseNo],[PartId],[PartNo],[PartCount],[PartPrice],[PartPriceBuying],[RelatedFormKeys],[RelatedFormCode],[RelatedFormType],[RelatedFormName],[ChuKuId],[ChuKuNo],[ChuKuDate],[CheckerId],[CheckerNo],[CheckerDate],[OperatorId],[OperatorNo],[ChuKuType],[ChuKuFlag],[ChuKuNote],[ChuKuReason],[GuiKuCount],[CreateDate],[UpdateDate],[AdmShopId]) VALUES(@OrderPurchaseId,@OrderPurchaseNo,@PartId,@PartNo,@PartCount,@PartPrice,@PartPriceBuying,@RelatedFormKeys,@RelatedFormCode,@RelatedFormType,@RelatedFormName,@ChuKuId,@ChuKuNo,@ChuKuDate,@CheckerId,@CheckerNo,@CheckerDate,@OperatorId,@OperatorNo,@ChuKuType,@ChuKuFlag,@ChuKuNote,@ChuKuReason,@GuiKuCount,@CreateDate,@UpdateDate,@AdmShopId) Select @@IDENTITY";

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

        /// <summary>
        /// 更新一条记录
        /// </summary>
        private const string UpdateCmdText = "UPDATE [BizServicePartStockChuKuDetail] SET [OrderPurchaseId]=@OrderPurchaseId,[OrderPurchaseNo]=@OrderPurchaseNo,[PartId]=@PartId,[PartNo]=@PartNo,[PartCount]=@PartCount,[PartPrice]=@PartPrice,[PartPriceBuying]=@PartPriceBuying,[RelatedFormKeys]=@RelatedFormKeys,[RelatedFormCode]=@RelatedFormCode,[RelatedFormType]=@RelatedFormType,[RelatedFormName]=@RelatedFormName,[ChuKuId]=@ChuKuId,[ChuKuNo]=@ChuKuNo,[ChuKuDate]=@ChuKuDate,[CheckerId]=@CheckerId,[CheckerNo]=@CheckerNo,[CheckerDate]=@CheckerDate,[OperatorId]=@OperatorId,[OperatorNo]=@OperatorNo,[ChuKuType]=@ChuKuType,[ChuKuFlag]=@ChuKuFlag,[ChuKuNote]=@ChuKuNote,[ChuKuReason]=@ChuKuReason,[GuiKuCount]=@GuiKuCount,[CreateDate]=@CreateDate,[UpdateDate]=@UpdateDate,[AdmShopId]=@AdmShopId WHERE [Id]=@Id";

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