if(bg.park_bike.tostring() =="")
oraclecmd.parameters[":miniparkingarea"].value = dbnull.value;
else
oraclecmd.parameters[":miniparkingarea"].value = bg.park_bike;
if(bg.other_area.tostring() == "")
oraclecmd.parameters[":otherestablishmentarea"].value = dbnull.value;
else
oraclecmd.parameters[":otherestablishmentarea"].value = bg.other_area;
oraclecmd.parameters[":cubagerate"].value = dbnull.value;
oraclecmd.parameters[":landusage"].value = dbnull.value; //词典
if(bg.layer_b.tostring() == "")
oraclecmd.parameters[":agroundfloorcount"].value = dbnull.value;
else
oraclecmd.parameters[":agroundfloorcount"].value = bg.layer_b;
oraclecmd.parameters[":undergroundfloorcount"].value = dbnull.value;
if(bg.east_b == "")
oraclecmd.parameters[":east"].value = dbnull.value;
else
oraclecmd.parameters[":east"].value = bg.east_b;
if(bg.west_b == "")
oraclecmd.parameters[":west"].value = dbnull.value;
else
oraclecmd.parameters[":west"].value = bg.west_b;
if(bg.south_b == "")
oraclecmd.parameters[":south"].value = dbnull.value;
else
oraclecmd.parameters[":south"].value = bg.south_b;
if(bg.north_b == "")
oraclecmd.parameters[":north"].value = dbnull.value;
else
oraclecmd.parameters[":north"].value = bg.north_b;
if(bg.area_ub == "")
oraclecmd.parameters[":originaluselandarea"].value = dbnull.value;
else
oraclecmd.parameters[":originaluselandarea"].value = bg.area_ub;
if(bg.area_b == "")
oraclecmd.parameters[":originalbuildingarea"].value = dbnull.value;
else
oraclecmd.parameters[":originalbuildingarea"].value = bg.area_b;
if(bg.stru_b == "")
oraclecmd.parameters[":originalstructuretype"].value = dbnull.value;
else
oraclecmd.parameters[":originalstructuretype"].value = bg.stru_b;
oraclecmd.parameters[":originalflooramount"].value = dbnull.value;
oraclecmd.parameters[":originaleast"].value = dbnull.value;
oraclecmd.parameters[":originalwest"].value = dbnull.value;
oraclecmd.parameters[":originalsouth"].value = dbnull.value;
oraclecmd.parameters[":originalnorth"].value = dbnull.value;
oraclecmd.parameters[":buildingmemo"].value = dbnull.value;
oraclecmd.parameters[":allplintharea"].value = dbnull.value;
oraclecmd.parameters[":designagroundfloor"].value = dbnull.value;
oraclecmd.parameters[":designundergroundfloor"].value = dbnull.value;
oraclecmd.parameters[":designspecialtiesfloor"].value = dbnull.value;
最后要讲到的就是写函数来获得你要从其他表中得到的数据!
public int selectinsert(string tm)
{
int id = 0;
try
{
string oraclestring = "user id=construct;data source=oracle;password=rose";
oracleconnection oracleconn = new oracleconnection(oraclestring);
oracleconn.open();
//string temp;
string str = "select id from document.doc where tm = '" +tm.trim() +"'";
