JCK.DAL/DAL_DEC_BOX_DETAIL_Entrust.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using JCK.DBUtility;

namespace JCK.DAL
{
    /// <summary>
    /// 数据访问类:DEC_BOX_DETAIL_Entrust
    /// </summary>
    public partial class DAL_DEC_BOX_DETAIL_Entrust
    {
        public DAL_DEC_BOX_DETAIL_Entrust()
        { }
        #region  BasicMethod
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(decimal DBD_ID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from DEC_BOX_DETAIL_Entrust");
            strSql.Append(" where DBD_ID=@DBD_ID");
            SqlParameter[] parameters = {
					new SqlParameter("@DBD_ID", SqlDbType.Decimal)
			};
            parameters[0].Value = DBD_ID;

            return DbHelperSQL.Exists(strSql.ToString(), parameters);
        }


        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(JCK.Model.DEC_BOX_DETAIL_Entrust model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into DEC_BOX_DETAIL_Entrust(");
            strSql.Append("DL_ID,DLD_guid,Cn,Model_Name,CN_number,Each_number,Total_number,Gw,Total_Gw,Nw,Total_Nw,Volume,NOTE_S,gl_id)");
            strSql.Append(" values (");
            strSql.Append("@DL_ID,@DLD_guid,@Cn,@Model_Name,@CN_number,@Each_number,@Total_number,@Gw,@Total_Gw,@Nw,@Total_Nw,@Volume,@NOTE_S,@gl_id)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
					new SqlParameter("@DL_ID", SqlDbType.Decimal,9),
					new SqlParameter("@DLD_guid", SqlDbType.NVarChar,50),
					new SqlParameter("@Cn", SqlDbType.VarChar,10),
					new SqlParameter("@Model_Name", SqlDbType.VarChar,255),
					new SqlParameter("@CN_number", SqlDbType.Decimal,5),
					new SqlParameter("@Each_number", SqlDbType.Decimal,9),
					new SqlParameter("@Total_number", SqlDbType.VarChar,13),
					new SqlParameter("@Gw", SqlDbType.VarChar,13),
					new SqlParameter("@Total_Gw", SqlDbType.VarChar,13),
					new SqlParameter("@Nw", SqlDbType.VarChar,13),
					new SqlParameter("@Total_Nw", SqlDbType.VarChar,13),
					new SqlParameter("@Volume", SqlDbType.VarChar,50),
					new SqlParameter("@NOTE_S", SqlDbType.VarChar,255),