JCK.DAL/DAL_DECLARATION_DETAIL.cs

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

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

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

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

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


        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(JCK.Model.DECLARATION_DETAIL model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into DECLARATION_DETAIL(");
            strSql.Append("GL_ID,DL_ID,G_NO,CODE_S,CODE_T,CLASS_MARK,G_NAME,G_MODEL,ORIGIN_COUNTRY,ORIGIN_COUNTRY_NAME,CONTR_ITEM,QTY_1,G_UNIT,G_UNIT_NAME,FACTOR,QTY_CONV,UNTI_1,UNTI_1_NAME,QTY_2,UNTI_2,UNTI_2_NAME,TRADE_CURR,TRADE_CURR_NAME,DECL_PRICE,TRADE_TOTAL,DUTY_MODE,DUTY_MODE_NAME,USE_TO,USE_TO_NAME,WORK_USD,MANUAL_NO,NOTE_1,TRADE_PACK_NO,TRADE_WT,TRADE_NET_WT,WORK_PAY,CURR_WORK,FROM_TABLE,GOODS_ID,PRDT_NO,VD_ID,MERGER_ID,MERGER_FLAG)");
            strSql.Append(" values (");
            strSql.Append("@GL_ID,@DL_ID,@G_NO,@CODE_S,@CODE_T,@CLASS_MARK,@G_NAME,@G_MODEL,@ORIGIN_COUNTRY,@ORIGIN_COUNTRY_NAME,@CONTR_ITEM,@QTY_1,@G_UNIT,@G_UNIT_NAME,@FACTOR,@QTY_CONV,@UNTI_1,@UNTI_1_NAME,@QTY_2,@UNTI_2,@UNTI_2_NAME,@TRADE_CURR,@TRADE_CURR_NAME,@DECL_PRICE,@TRADE_TOTAL,@DUTY_MODE,@DUTY_MODE_NAME,@USE_TO,@USE_TO_NAME,@WORK_USD,@MANUAL_NO,@NOTE_1,@TRADE_PACK_NO,@TRADE_WT,@TRADE_NET_WT,@WORK_PAY,@CURR_WORK,@FROM_TABLE,@GOODS_ID,@PRDT_NO,@VD_ID,@MERGER_ID,@MERGER_FLAG)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
					new SqlParameter("@GL_ID", SqlDbType.NVarChar,50),
					new SqlParameter("@DL_ID", SqlDbType.Int,4),
					new SqlParameter("@G_NO", SqlDbType.Float,8),
					new SqlParameter("@CODE_S", SqlDbType.VarChar,8),
					new SqlParameter("@CODE_T", SqlDbType.VarChar,8),
					new SqlParameter("@CLASS_MARK", SqlDbType.VarChar,1),
					new SqlParameter("@G_NAME", SqlDbType.VarChar,50),
					new SqlParameter("@G_MODEL", SqlDbType.VarChar,255),
					new SqlParameter("@ORIGIN_COUNTRY", SqlDbType.VarChar,5),
					new SqlParameter("@ORIGIN_COUNTRY_NAME", SqlDbType.VarChar,30),
					new SqlParameter("@CONTR_ITEM", SqlDbType.Float,8),
					new SqlParameter("@QTY_1", SqlDbType.Decimal,9),
					new SqlParameter("@G_UNIT", SqlDbType.VarChar,4),