SQL中if语句的用法示例

复制_sql = " if not exists (select * from ProDesignSheet5 where Sheet5ID = " + this.Sheet5id + ") "                 + " insert into ProDesignSheet5 values(" + this.Sheet5id                 + ",语句" + this.Consplacepbfee.ToString()                 + "," + this.Searchtestfee.ToString()                 + "," + this.Ccdesignfee.ToString()                 + "," + this.Propreparefee.ToString()                 + "," + this.Elecfee.ToString()                 + "," + this.Workerdqfee.ToString()                 + "," + this.Cjzpgdqfee.ToString()                 + "," + this.Dxsgjxdqfee.ToString()                 + "," + this.Debzglfee.ToString()                 + "," + this.Jsqtzdkrate.ToString()                 + "," + this.Gczljdfee.ToString()                 + "," + this.Yuntufee.ToString()                 + "," + this.Jfgzjgzfee.ToString()                 + "," + this.Wsdyrfee.ToString()                 + "," + this.Whclfee.ToString()                 + "," + this.Bgyffee.ToString()                 + "," + this.Yytfee.ToString()                 + "," + this.Hlhtfee.ToString()                 + "," + this.Jfxtfee.ToString()                 + "," + this.Ybgjfee.ToString()                 + "," + this.Gxzfzfee.ToString()                 + "," + this.Lyglfee.ToString()                 + "," + this.Jfzjfee.ToString()                 + "," + this.Gdzjfee.ToString()                 + "," + this.Gdlxlzjfee.ToString()                 + "," + this.Workteamfee.ToString()                 + "," + this.Condeptfee.ToString()                 + "," + this.Tower.ToString()                 + "," + this.Servicefee.ToString()                 + "," + this.Checkfee.ToString()                 + "," + this.Other.ToString()                 + "," + this.ItemNum.ToString()                 + "," + this.ItemName.ToString()                 + "," + this.PassId.ToString()                 + ")"                 + " else update ProDesignSheet5 set Consplacepbfee=" + this.Consplacepbfee.ToString()                 + ",Searchtestfee=" + this.Searchtestfee.ToString()                 + ",Ccdesignfee=" + this.Ccdesignfee.ToString()                 + ",Propreparefee=" + this.Propreparefee.ToString()                 + ",Elecfee=" + this.Elecfee.ToString()                 + ",Workerdqfee=" + this.Workerdqfee.ToString()                 + ",Cjzpgdqfee=" + this.Cjzpgdqfee.ToString()                 + ",Dxsgjxdqfee=" + this.Dxsgjxdqfee.ToString()                 + ",Debzglfee=" + this.Debzglfee.ToString()                 + ",Jsqtzdkrate=" + this.Jsqtzdkrate.ToString()                 + ",Gczljdfee=" + this.Gczljdfee.ToString()                 + ",Yuntufee=" + this.Yuntufee.ToString()                 + ",Jfgzjgzfee=" + this.Jfgzjgzfee.ToString()                 + ",Wsdyrfee=" + this.Wsdyrfee.ToString()                 + ",Whclfee=" + this.Whclfee.ToString()                 + ",Bgyffee=" + this.Bgyffee.ToString()                 + ",Yytfee=" + this.Yytfee.ToString()                 + ",Hlhtfee=" + this.Hlhtfee.ToString()                 + ",Jfxtfee=" + this.Jfxtfee.ToString()                 + ",Ybgjfee=" + this.Ybgjfee.ToString()                 + ",Gxzfzfee=" + this.Gxzfzfee.ToString()                 + ",Lyglfee=" + this.Lyglfee.ToString()                 + ",Jfzjfee=" + this.Jfzjfee.ToString()                 + ",Gdzjfee=" + this.Gdzjfee.ToString()                 + ",Gdlxlzjfee=" + this.Gdlxlzjfee.ToString()                 + ",Workteamfee=" + this.Workteamfee.ToString()                 + ",Condeptfee=" + this.Condeptfee.ToString()                 + ",Tower=" + this.Tower.ToString()                 + ",Servicefee=" + this.Servicefee.ToString()                 + ",Checkfee=" + this.Checkfee.ToString()                 + ",Other=" + this.Other.ToString()                 //+ ",ItemNum=" + this.ItemNum.ToString()                 //+ ",ItemName=" + this.ItemName.ToString()                 //+ ",PassId=" + this.PassId.ToString()                 + " where Sheet5id =" + this.Sheet5id + "";   1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.66.67.68.69.70.71.72.