/// <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)); }
/// <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); } }
/// <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); }
/// <summary> /// 获取计算结果 /// </summary> /// <param name="model"></param> /// <returns></returns> public System.Data.DataTable GetDataTableCacle(MulaolaoLibrary.CheJianZhuRenKaoHeDzLibrary model) { return(dao.GetDataTableCacle(model)); }
/// <summary> /// 更新一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateTwo(MulaolaoLibrary.CheJianZhuRenKaoHeDzLibrary model) { return(dao.UpdateTwo(model)); }
/// <summary> /// 增加一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddTwo(MulaolaoLibrary.CheJianZhuRenKaoHeDzLibrary model) { return(dao.AddTwo(model)); }