Exemple #1
0
        /// <summary>
        /// 获取计算结果
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public DataTable GetDataTableCacle(MulaolaoLibrary.CheJianZhuRenKaoHeDzLibrary model)
        {
            StringBuilder strSql = new StringBuilder( );

            strSql.Append("SELECT DZ004,ISNULL(SUM(DZ019*DZ020),0) U7,ISNULL(SUM(DZ073*DZ074)+SUM(DZ022*DZ023)+SUM(DZ025*DZ026)+SUM(DZ028*DZ029),0) U0,ISNULL(SUM(DZ075*DZ076*DZ077),0) U1,ISNULL(SUM(DZ030*DZ031*DZ032),0) U2,ISNULL(SUM(DZ033*DZ034*DZ035),0) U3,ISNULL(SUM(DZ036*DZ037*DZ038),0) U4,ISNULL(SUM(DZ018),0) F0,ISNULL(SUM(DZ020),0) F1,ISNULL(SUM(DZ073*DZ074),0) F2,ISNULL(SUM(DZ025*DZ026),0) F3,ISNULL(SUM(DZ022*DZ023),0) F4,ISNULL(SUM(DZ028*DZ029),0) F5 FROM R_PQDZ");
            strSql.Append(" WHERE DZ001=@DZ001 AND DZ002=@DZ002 AND DZ003=@DZ003");
            strSql.Append(" GROUP BY DZ004");
            SqlParameter[] parameter =
            {
                new SqlParameter("@DZ001", SqlDbType.NVarChar),
                new SqlParameter("@DZ002", SqlDbType.NVarChar),
                new SqlParameter("@DZ003", SqlDbType.NVarChar)
            };

            parameter[0].Value = model.DZ001;
            parameter[1].Value = model.DZ002;
            parameter[2].Value = model.DZ003;

            return(SqlHelper.ExecuteDataTable(strSql.ToString( ), parameter));
        }
Exemple #2
0
        /// <summary>
        /// 更新一条记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateTwo(MulaolaoLibrary.CheJianZhuRenKaoHeDzLibrary model)
        {
            StringBuilder strSql = new StringBuilder( );

            strSql.Append("UPDATE R_PQDZ SET ");
            strSql.Append("DZ002=@DZ002,");
            strSql.Append("DZ003=@DZ003,");
            strSql.Append("DZ004=@DZ004,");
            strSql.Append("DZ005=@DZ005,");
            strSql.Append("DZ006=@DZ006,");
            strSql.Append("DZ007=@DZ007,");
            strSql.Append("DZ008=@DZ008,");
            strSql.Append("DZ009=@DZ009,");
            strSql.Append("DZ010=@DZ010,");
            strSql.Append("DZ011=@DZ011,");
            strSql.Append("DZ012=@DZ012,");
            strSql.Append("DZ013=@DZ013,");
            strSql.Append("DZ014=@DZ014,");
            strSql.Append("DZ015=@DZ015,");
            strSql.Append("DZ016=@DZ016,");
            strSql.Append("DZ017=@DZ017,");
            strSql.Append("DZ018=@DZ018,");
            strSql.Append("DZ019=@DZ019,");
            strSql.Append("DZ020=@DZ020,");
            strSql.Append("DZ021=@DZ021,");
            strSql.Append("DZ022=@DZ022,");
            strSql.Append("DZ023=@DZ023,");
            strSql.Append("DZ024=@DZ024,");
            strSql.Append("DZ025=@DZ025,");
            strSql.Append("DZ026=@DZ026,");
            strSql.Append("DZ027=@DZ027,");
            strSql.Append("DZ028=@DZ028,");
            strSql.Append("DZ029=@DZ029,");
            strSql.Append("DZ030=@DZ030,");
            strSql.Append("DZ031=@DZ031,");
            strSql.Append("DZ032=@DZ032,");
            strSql.Append("DZ033=@DZ033,");
            strSql.Append("DZ034=@DZ034,");
            strSql.Append("DZ035=@DZ035,");
            strSql.Append("DZ036=@DZ036,");
            strSql.Append("DZ037=@DZ037,");
            strSql.Append("DZ038=@DZ038,");
            strSql.Append("DZ039=@DZ039,");
            strSql.Append("DZ040=@DZ040,");
            strSql.Append("DZ041=@DZ041,");
            strSql.Append("DZ042=@DZ042,");
            strSql.Append("DZ043=@DZ043,");
            strSql.Append("DZ044=@DZ044,");
            strSql.Append("DZ045=@DZ045,");
            strSql.Append("DZ046=@DZ046,");
            strSql.Append("DZ047=@DZ047,");
            strSql.Append("DZ048=@DZ048,");
            strSql.Append("DZ049=@DZ049,");
            strSql.Append("DZ050=@DZ050,");
            strSql.Append("DZ051=@DZ051,");
            strSql.Append("DZ052=@DZ052,");
            strSql.Append("DZ053=@DZ053,");
            strSql.Append("DZ054=@DZ054,");
            strSql.Append("DZ055=@DZ055,");
            strSql.Append("DZ056=@DZ056,");
            strSql.Append("DZ057=@DZ057,");
            strSql.Append("DZ058=@DZ058,");
            strSql.Append("DZ059=@DZ059,");
            strSql.Append("DZ060=@DZ060,");
            strSql.Append("DZ061=@DZ061,");
            strSql.Append("DZ062=@DZ062,");
            strSql.Append("DZ063=@DZ063,");
            strSql.Append("DZ064=@DZ064,");
            strSql.Append("DZ065=@DZ065,");
            strSql.Append("DZ066=@DZ066,");
            strSql.Append("DZ067=@DZ067,");
            strSql.Append("DZ068=@DZ068,");
            strSql.Append("DZ069=@DZ069,");
            strSql.Append("DZ070=@DZ070,");
            strSql.Append("DZ071=@DZ071,");
            strSql.Append("DZ072=@DZ072,");
            strSql.Append("DZ073=@DZ073,");
            strSql.Append("DZ074=@DZ074,");
            strSql.Append("DZ075=@DZ075,");
            strSql.Append("DZ076=@DZ076,");
            strSql.Append("DZ077=@DZ077");
            strSql.Append(" WHERE idx=@idx");
            SqlParameter[] parameter =
            {
                new SqlParameter("@idx",   SqlDbType.Int),
                new SqlParameter("@DZ002", SqlDbType.NVarChar),
                new SqlParameter("@DZ003", SqlDbType.NVarChar),
                new SqlParameter("@DZ004", SqlDbType.NVarChar),
                new SqlParameter("@DZ005", SqlDbType.NVarChar),
                new SqlParameter("@DZ006", SqlDbType.NVarChar),
                new SqlParameter("@DZ007", SqlDbType.NVarChar),
                new SqlParameter("@DZ008", SqlDbType.Decimal),
                new SqlParameter("@DZ009", SqlDbType.DateTime),
                new SqlParameter("@DZ010", SqlDbType.DateTime),
                new SqlParameter("@DZ011", SqlDbType.DateTime),
                new SqlParameter("@DZ012", SqlDbType.DateTime),
                new SqlParameter("@DZ013", SqlDbType.Int),
                new SqlParameter("@DZ014", SqlDbType.DateTime),
                new SqlParameter("@DZ015", SqlDbType.Decimal),
                new SqlParameter("@DZ016", SqlDbType.Decimal),
                new SqlParameter("@DZ017", SqlDbType.Decimal),
                new SqlParameter("@DZ018", SqlDbType.Decimal),
                new SqlParameter("@DZ019", SqlDbType.Decimal),
                new SqlParameter("@DZ020", SqlDbType.Decimal),
                new SqlParameter("@DZ021", SqlDbType.Int),
                new SqlParameter("@DZ022", SqlDbType.Int),
                new SqlParameter("@DZ023", SqlDbType.Int),
                new SqlParameter("@DZ024", SqlDbType.Int),
                new SqlParameter("@DZ025", SqlDbType.Int),
                new SqlParameter("@DZ026", SqlDbType.Int),
                new SqlParameter("@DZ027", SqlDbType.Int),
                new SqlParameter("@DZ028", SqlDbType.Int),
                new SqlParameter("@DZ029", SqlDbType.Int),
                new SqlParameter("@DZ030", SqlDbType.Int),
                new SqlParameter("@DZ031", SqlDbType.Int),
                new SqlParameter("@DZ032", SqlDbType.Int),
                new SqlParameter("@DZ033", SqlDbType.Int),
                new SqlParameter("@DZ034", SqlDbType.Int),
                new SqlParameter("@DZ035", SqlDbType.Int),
                new SqlParameter("@DZ036", SqlDbType.Int),
                new SqlParameter("@DZ037", SqlDbType.Int),
                new SqlParameter("@DZ038", SqlDbType.Int),
                new SqlParameter("@DZ039", SqlDbType.Int),
                new SqlParameter("@DZ040", SqlDbType.Int),
                new SqlParameter("@DZ041", SqlDbType.Int),
                new SqlParameter("@DZ042", SqlDbType.Int),
                new SqlParameter("@DZ043", SqlDbType.Int),
                new SqlParameter("@DZ044", SqlDbType.Int),
                new SqlParameter("@DZ045", SqlDbType.Int),
                new SqlParameter("@DZ046", SqlDbType.Int),
                new SqlParameter("@DZ047", SqlDbType.Int),
                new SqlParameter("@DZ048", SqlDbType.Int),
                new SqlParameter("@DZ049", SqlDbType.NVarChar),
                new SqlParameter("@DZ050", SqlDbType.NVarChar),
                new SqlParameter("@DZ051", SqlDbType.Int),
                new SqlParameter("@DZ052", SqlDbType.NVarChar),
                new SqlParameter("@DZ053", SqlDbType.Int),
                new SqlParameter("@DZ054", SqlDbType.NVarChar),
                new SqlParameter("@DZ055", SqlDbType.Int),
                new SqlParameter("@DZ056", SqlDbType.NVarChar),
                new SqlParameter("@DZ057", SqlDbType.Int),
                new SqlParameter("@DZ058", SqlDbType.Int),
                new SqlParameter("@DZ059", SqlDbType.Int),
                new SqlParameter("@DZ060", SqlDbType.Int),
                new SqlParameter("@DZ061", SqlDbType.Int),
                new SqlParameter("@DZ062", SqlDbType.Int),
                new SqlParameter("@DZ063", SqlDbType.Int),
                new SqlParameter("@DZ064", SqlDbType.Int),
                new SqlParameter("@DZ065", SqlDbType.Int),
                new SqlParameter("@DZ066", SqlDbType.Int),
                new SqlParameter("@DZ067", SqlDbType.Int),
                new SqlParameter("@DZ068", SqlDbType.Int),
                new SqlParameter("@DZ069", SqlDbType.Int),
                new SqlParameter("@DZ070", SqlDbType.Int),
                new SqlParameter("@DZ071", SqlDbType.Int),
                new SqlParameter("@DZ072", SqlDbType.Int),
                new SqlParameter("@DZ073", SqlDbType.Int),
                new SqlParameter("@DZ074", SqlDbType.Int),
                new SqlParameter("@DZ075", SqlDbType.Int),
                new SqlParameter("@DZ076", SqlDbType.Int),
                new SqlParameter("@DZ077", SqlDbType.Int)
            };

            parameter[0].Value  = model.IDX;
            parameter[1].Value  = model.DZ002;
            parameter[2].Value  = model.DZ003;
            parameter[3].Value  = model.DZ004;
            parameter[4].Value  = model.DZ005;
            parameter[5].Value  = model.DZ006;
            parameter[6].Value  = model.DZ007;
            parameter[7].Value  = model.DZ008;
            parameter[8].Value  = model.DZ009;
            parameter[9].Value  = model.DZ010;
            parameter[10].Value = model.DZ011;
            parameter[11].Value = model.DZ012;
            parameter[12].Value = model.DZ013;
            parameter[13].Value = model.DZ014;
            parameter[14].Value = model.DZ015;
            parameter[15].Value = model.DZ016;
            parameter[16].Value = model.DZ017;
            parameter[17].Value = model.DZ018;
            parameter[18].Value = model.DZ019;
            parameter[19].Value = model.DZ020;
            parameter[20].Value = model.DZ021;
            parameter[21].Value = model.DZ022;
            parameter[22].Value = model.DZ023;
            parameter[23].Value = model.DZ024;
            parameter[24].Value = model.DZ025;
            parameter[25].Value = model.DZ026;
            parameter[26].Value = model.DZ027;
            parameter[27].Value = model.DZ028;
            parameter[28].Value = model.DZ029;
            parameter[29].Value = model.DZ030;
            parameter[30].Value = model.DZ031;
            parameter[31].Value = model.DZ032;
            parameter[32].Value = model.DZ033;
            parameter[33].Value = model.DZ034;
            parameter[34].Value = model.DZ035;
            parameter[35].Value = model.DZ036;
            parameter[36].Value = model.DZ037;
            parameter[37].Value = model.DZ038;
            parameter[38].Value = model.DZ039;
            parameter[39].Value = model.DZ040;
            parameter[40].Value = model.DZ041;
            parameter[41].Value = model.DZ042;
            parameter[42].Value = model.DZ043;
            parameter[43].Value = model.DZ044;
            parameter[44].Value = model.DZ045;
            parameter[45].Value = model.DZ046;
            parameter[46].Value = model.DZ047;
            parameter[47].Value = model.DZ048;
            parameter[48].Value = model.DZ049;
            parameter[49].Value = model.DZ050;
            parameter[50].Value = model.DZ051;
            parameter[51].Value = model.DZ052;
            parameter[52].Value = model.DZ053;
            parameter[53].Value = model.DZ054;
            parameter[54].Value = model.DZ055;
            parameter[55].Value = model.DZ056;
            parameter[56].Value = model.DZ057;
            parameter[57].Value = model.DZ058;
            parameter[58].Value = model.DZ059;
            parameter[59].Value = model.DZ060;
            parameter[60].Value = model.DZ061;
            parameter[61].Value = model.DZ062;
            parameter[62].Value = model.DZ063;
            parameter[63].Value = model.DZ064;
            parameter[64].Value = model.DZ065;
            parameter[65].Value = model.DZ066;
            parameter[66].Value = model.DZ067;
            parameter[67].Value = model.DZ068;
            parameter[68].Value = model.DZ069;
            parameter[69].Value = model.DZ070;
            parameter[70].Value = model.DZ071;
            parameter[71].Value = model.DZ072;
            parameter[72].Value = model.DZ073;
            parameter[73].Value = model.DZ074;
            parameter[74].Value = model.DZ075;
            parameter[75].Value = model.DZ076;
            parameter[76].Value = model.DZ077;

            int rows = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Exemple #3
0
        /// <summary>
        /// 增加一条记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int AddTwo(MulaolaoLibrary.CheJianZhuRenKaoHeDzLibrary model)
        {
            StringBuilder strSql = new StringBuilder( );

            strSql.Append("INSERT INTO R_PQDZ (");
            strSql.Append("DZ001,DZ002,DZ003,DZ004,DZ005,DZ006,DZ007,DZ008,DZ009,DZ010,DZ011,DZ012,DZ013,DZ014,DZ015,DZ016,DZ017,DZ018,DZ019,DZ020,DZ021,DZ022,DZ023,DZ024,DZ025,DZ026,DZ027,DZ028,DZ029,DZ030,DZ031,DZ032,DZ033,DZ034,DZ035,DZ036,DZ037,DZ038,DZ039,DZ040,DZ041,DZ042,DZ043,DZ044,DZ045,DZ046,DZ047,DZ048,DZ049,DZ050,DZ051,DZ052,DZ053,DZ054,DZ055,DZ056,DZ057,DZ058,DZ059,DZ060,DZ061,DZ062,DZ063,DZ064,DZ065,DZ066,DZ067,DZ068,DZ069,DZ070,DZ071,DZ072,DZ073,DZ074,DZ075,DZ076,DZ077)");
            strSql.Append(" VALUES (");
            strSql.Append("@DZ001,@DZ002,@DZ003,@DZ004,@DZ005,@DZ006,@DZ007,@DZ008,@DZ009,@DZ010,@DZ011,@DZ012,@DZ013,@DZ014,@DZ015,@DZ016,@DZ017,@DZ018,@DZ019,@DZ020,@DZ021,@DZ022,@DZ023,@DZ024,@DZ025,@DZ026,@DZ027,@DZ028,@DZ029,@DZ030,@DZ031,@DZ032,@DZ033,@DZ034,@DZ035,@DZ036,@DZ037,@DZ038,@DZ039,@DZ040,@DZ041,@DZ042,@DZ043,@DZ044,@DZ045,@DZ046,@DZ047,@DZ048,@DZ049,@DZ050,@DZ051,@DZ052,@DZ053,@DZ054,@DZ055,@DZ056,@DZ057,@DZ058,@DZ059,@DZ060,@DZ061,@DZ062,@DZ063,@DZ064,@DZ065,@DZ066,@DZ067,@DZ068,@DZ069,@DZ070,@DZ071,@DZ072,@DZ073,@DZ074,@DZ075,@DZ076,@DZ077);");
            strSql.Append("SELECT SCOPE_IDENTITY();");
            SqlParameter[] parameter =
            {
                new SqlParameter("@DZ001", SqlDbType.NVarChar),
                new SqlParameter("@DZ002", SqlDbType.NVarChar),
                new SqlParameter("@DZ003", SqlDbType.NVarChar),
                new SqlParameter("@DZ004", SqlDbType.NVarChar),
                new SqlParameter("@DZ005", SqlDbType.NVarChar),
                new SqlParameter("@DZ006", SqlDbType.NVarChar),
                new SqlParameter("@DZ007", SqlDbType.NVarChar),
                new SqlParameter("@DZ008", SqlDbType.Decimal),
                new SqlParameter("@DZ009", SqlDbType.DateTime),
                new SqlParameter("@DZ010", SqlDbType.DateTime),
                new SqlParameter("@DZ011", SqlDbType.DateTime),
                new SqlParameter("@DZ012", SqlDbType.DateTime),
                new SqlParameter("@DZ013", SqlDbType.Int),
                new SqlParameter("@DZ014", SqlDbType.DateTime),
                new SqlParameter("@DZ015", SqlDbType.Decimal),
                new SqlParameter("@DZ016", SqlDbType.Decimal),
                new SqlParameter("@DZ017", SqlDbType.Decimal),
                new SqlParameter("@DZ018", SqlDbType.Decimal),
                new SqlParameter("@DZ019", SqlDbType.Decimal),
                new SqlParameter("@DZ020", SqlDbType.Decimal),
                new SqlParameter("@DZ021", SqlDbType.Int),
                new SqlParameter("@DZ022", SqlDbType.Int),
                new SqlParameter("@DZ023", SqlDbType.Int),
                new SqlParameter("@DZ024", SqlDbType.Int),
                new SqlParameter("@DZ025", SqlDbType.Int),
                new SqlParameter("@DZ026", SqlDbType.Int),
                new SqlParameter("@DZ027", SqlDbType.Int),
                new SqlParameter("@DZ028", SqlDbType.Int),
                new SqlParameter("@DZ029", SqlDbType.Int),
                new SqlParameter("@DZ030", SqlDbType.Int),
                new SqlParameter("@DZ031", SqlDbType.Int),
                new SqlParameter("@DZ032", SqlDbType.Int),
                new SqlParameter("@DZ033", SqlDbType.Int),
                new SqlParameter("@DZ034", SqlDbType.Int),
                new SqlParameter("@DZ035", SqlDbType.Int),
                new SqlParameter("@DZ036", SqlDbType.Int),
                new SqlParameter("@DZ037", SqlDbType.Int),
                new SqlParameter("@DZ038", SqlDbType.Int),
                new SqlParameter("@DZ039", SqlDbType.Int),
                new SqlParameter("@DZ040", SqlDbType.Int),
                new SqlParameter("@DZ041", SqlDbType.Int),
                new SqlParameter("@DZ042", SqlDbType.Int),
                new SqlParameter("@DZ043", SqlDbType.Int),
                new SqlParameter("@DZ044", SqlDbType.Int),
                new SqlParameter("@DZ045", SqlDbType.Int),
                new SqlParameter("@DZ046", SqlDbType.Int),
                new SqlParameter("@DZ047", SqlDbType.Int),
                new SqlParameter("@DZ048", SqlDbType.Int),
                new SqlParameter("@DZ049", SqlDbType.NVarChar),
                new SqlParameter("@DZ050", SqlDbType.NVarChar),
                new SqlParameter("@DZ051", SqlDbType.Int),
                new SqlParameter("@DZ052", SqlDbType.NVarChar),
                new SqlParameter("@DZ053", SqlDbType.Int),
                new SqlParameter("@DZ054", SqlDbType.NVarChar),
                new SqlParameter("@DZ055", SqlDbType.Int),
                new SqlParameter("@DZ056", SqlDbType.NVarChar),
                new SqlParameter("@DZ057", SqlDbType.Int),
                new SqlParameter("@DZ058", SqlDbType.Int),
                new SqlParameter("@DZ059", SqlDbType.Int),
                new SqlParameter("@DZ060", SqlDbType.Int),
                new SqlParameter("@DZ061", SqlDbType.Int),
                new SqlParameter("@DZ062", SqlDbType.Int),
                new SqlParameter("@DZ063", SqlDbType.Int),
                new SqlParameter("@DZ064", SqlDbType.Int),
                new SqlParameter("@DZ065", SqlDbType.Int),
                new SqlParameter("@DZ066", SqlDbType.Int),
                new SqlParameter("@DZ067", SqlDbType.Int),
                new SqlParameter("@DZ068", SqlDbType.Int),
                new SqlParameter("@DZ069", SqlDbType.Int),
                new SqlParameter("@DZ070", SqlDbType.Int),
                new SqlParameter("@DZ071", SqlDbType.Int),
                new SqlParameter("@DZ072", SqlDbType.Int),
                new SqlParameter("@DZ073", SqlDbType.Int),
                new SqlParameter("@DZ074", SqlDbType.Int),
                new SqlParameter("@DZ075", SqlDbType.Int),
                new SqlParameter("@DZ076", SqlDbType.Int),
                new SqlParameter("@DZ077", SqlDbType.Int)
            };

            parameter[0].Value  = model.DZ001;
            parameter[1].Value  = model.DZ002;
            parameter[2].Value  = model.DZ003;
            parameter[3].Value  = model.DZ004;
            parameter[4].Value  = model.DZ005;
            parameter[5].Value  = model.DZ006;
            parameter[6].Value  = model.DZ007;
            parameter[7].Value  = model.DZ008;
            parameter[8].Value  = model.DZ009;
            parameter[9].Value  = model.DZ010;
            parameter[10].Value = model.DZ011;
            parameter[11].Value = model.DZ012;
            parameter[12].Value = model.DZ013;
            parameter[13].Value = model.DZ014;
            parameter[14].Value = model.DZ015;
            parameter[15].Value = model.DZ016;
            parameter[16].Value = model.DZ017;
            parameter[17].Value = model.DZ018;
            parameter[18].Value = model.DZ019;
            parameter[19].Value = model.DZ020;
            parameter[20].Value = model.DZ021;
            parameter[21].Value = model.DZ022;
            parameter[22].Value = model.DZ023;
            parameter[23].Value = model.DZ024;
            parameter[24].Value = model.DZ025;
            parameter[25].Value = model.DZ026;
            parameter[26].Value = model.DZ027;
            parameter[27].Value = model.DZ028;
            parameter[28].Value = model.DZ029;
            parameter[29].Value = model.DZ030;
            parameter[30].Value = model.DZ031;
            parameter[31].Value = model.DZ032;
            parameter[32].Value = model.DZ033;
            parameter[33].Value = model.DZ034;
            parameter[34].Value = model.DZ035;
            parameter[35].Value = model.DZ036;
            parameter[36].Value = model.DZ037;
            parameter[37].Value = model.DZ038;
            parameter[38].Value = model.DZ039;
            parameter[39].Value = model.DZ040;
            parameter[40].Value = model.DZ041;
            parameter[41].Value = model.DZ042;
            parameter[42].Value = model.DZ043;
            parameter[43].Value = model.DZ044;
            parameter[44].Value = model.DZ045;
            parameter[45].Value = model.DZ046;
            parameter[46].Value = model.DZ047;
            parameter[47].Value = model.DZ048;
            parameter[48].Value = model.DZ049;
            parameter[49].Value = model.DZ050;
            parameter[50].Value = model.DZ051;
            parameter[51].Value = model.DZ052;
            parameter[52].Value = model.DZ053;
            parameter[53].Value = model.DZ054;
            parameter[54].Value = model.DZ055;
            parameter[55].Value = model.DZ056;
            parameter[56].Value = model.DZ057;
            parameter[57].Value = model.DZ058;
            parameter[58].Value = model.DZ059;
            parameter[59].Value = model.DZ060;
            parameter[60].Value = model.DZ061;
            parameter[61].Value = model.DZ062;
            parameter[62].Value = model.DZ063;
            parameter[63].Value = model.DZ064;
            parameter[64].Value = model.DZ065;
            parameter[65].Value = model.DZ066;
            parameter[66].Value = model.DZ067;
            parameter[67].Value = model.DZ068;
            parameter[68].Value = model.DZ069;
            parameter[69].Value = model.DZ070;
            parameter[70].Value = model.DZ071;
            parameter[71].Value = model.DZ072;
            parameter[72].Value = model.DZ073;
            parameter[73].Value = model.DZ074;
            parameter[74].Value = model.DZ075;
            parameter[75].Value = model.DZ076;
            parameter[76].Value = model.DZ077;

            int idx = SqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameter);

            return(idx);
        }
Exemple #4
0
 /// <summary>
 /// 获取计算结果
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public System.Data.DataTable GetDataTableCacle(MulaolaoLibrary.CheJianZhuRenKaoHeDzLibrary model)
 {
     return(dao.GetDataTableCacle(model));
 }
Exemple #5
0
 /// <summary>
 /// 更新一条记录
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public bool UpdateTwo(MulaolaoLibrary.CheJianZhuRenKaoHeDzLibrary model)
 {
     return(dao.UpdateTwo(model));
 }
Exemple #6
0
 /// <summary>
 /// 增加一条记录
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public int AddTwo(MulaolaoLibrary.CheJianZhuRenKaoHeDzLibrary model)
 {
     return(dao.AddTwo(model));
 }