SERVER数据转换ORACLE问题(2)
2008-12-16 13:05:12 来源:WEB开发网下面要做的就是往oracle中写你要的数据了!
建立连接:
string OracleString = "user id=construct;data source=oracle;password=rose";
string OracleText = “在这里写你要插入的sql语句“
OracleConnection OracleCon = new OracleConnection(OracleString);
OracleCommand OracleCmd = new OracleCommand(OracleText,OracleCon);
然后帮oracle表中构造字段:
#region BuildingEnnginger参数设置
OracleCmd.Parameters.Clear();
OracleCmd.Parameters.Add(":DOCID",OracleType.Int32);
OracleCmd.Parameters.Add(":CONSTRUCTDENSITY",OracleType.Float);
OracleCmd.Parameters.Add(":BUILDINGTOTALHEIGHT",OracleType.Float);
OracleCmd.Parameters.Add(":GREENAREA",OracleType.Float);
OracleCmd.Parameters.Add(":PARKINGAREA",OracleType.Float);
OracleCmd.Parameters.Add(":MINIPARKINGAREA",OracleType.Float);
OracleCmd.Parameters.Add(":OTHERESTABLISHMENTAREA",OracleType.Float);
OracleCmd.Parameters.Add(":CUBAGERATE",OracleType.Float);
OracleCmd.Parameters.Add(":LANDUSAGE",OracleType.Int32);
OracleCmd.Parameters.Add(":AGROUNDFLOORCOUNT",OracleType.Int32);
OracleCmd.Parameters.Add(":UNDERGROUNDFLOORCOUNT",OracleType.Int32);
OracleCmd.Parameters.Add(":EAST",OracleType.VarChar);
OracleCmd.Parameters.Add(":WEST",OracleType.VarChar);
OracleCmd.Parameters.Add(":SOUTH",OracleType.VarChar);
OracleCmd.Parameters.Add(":NORTH",OracleType.VarChar);
OracleCmd.Parameters.Add(":ORIGINALUSELANDAREA",OracleType.VarChar);
OracleCmd.Parameters.Add(":ORIGINALBUILDINGAREA",OracleType.Float);
OracleCmd.Parameters.Add(":ORIGINALSTRUCTURETYPE",OracleType.VarChar);
OracleCmd.Parameters.Add(":ORIGINALFLOORAMOUNT",OracleType.Int32);
OracleCmd.Parameters.Add(":ORIGINALEAST",OracleType.VarChar);
OracleCmd.Parameters.Add(":ORIGINALWEST",OracleType.VarChar);
OracleCmd.Parameters.Add(":ORIGINALSOUTH",OracleType.VarChar);
OracleCmd.Parameters.Add(":ORIGINALNORTH",OracleType.VarChar);
OracleCmd.Parameters.Add(":BUILDINGMEMO",OracleType.VarChar);
OracleCmd.Parameters.Add(":ALLPLINTHAREA",OracleType.Float);
OracleCmd.Parameters.Add(":DESIGNAGROUNDFLOOR",OracleType.Int32);
OracleCmd.Parameters.Add(":DESIGNUNDERGROUNDFLOOR",OracleType.Int32);
OracleCmd.Parameters.Add(":DESIGNSPECIALTIESFLOOR",OracleType.VarChar);
#endregion
#region 参数附值
OracleCmd.Parameters[":DOCID"].Value = SelectInsert(bg.Tworder_Code).ToString(); //这里是传参数进去获得想得到的数据
后面的就是你俯值的详细代码了;( 如bg.Densy_B)
if(bg.Densy_B.ToString() == "")
OracleCmd.Parameters[":CONSTRUCTDENSITY"].Value = DBNull.Value;
else
OracleCmd.Parameters[":CONSTRUCTDENSITY"].Value = bg.Densy_B;
OracleCmd.Parameters[":BUILDINGTOTALHEIGHT"].Value = DBNull.Value;
if(bg.Grean_B.ToString() == "")
OracleCmd.Parameters[":GREENAREA"].Value = DBNull.Value;
else
OracleCmd.Parameters[":GREENAREA"].Value = bg.Grean_B;
if(bg.Park.ToString() =="")
OracleCmd.Parameters[":PARKINGAREA"].Value = DBNull.Value;
else
OracleCmd.Parameters[":PARKINGAREA"].Value = bg.Park;
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() +"'";
OracleCommand OracleComd = new OracleCommand(str,OracleConn);
Object obj = OracleComd.ExecuteScalar();
if(obj != null)
{
id = Convert.ToInt32(obj);
}
//id = int.Parse(OracleComd.ExecuteOracleScalar().ToString());
#region
// Object obj = OracleComd.ExecuteReader();
// if(obj!=null)
// {
// id = Convert.ToInt32(obj);
// }
// if(obj >1)
// {
// id = Convert.ToInt32(obj) + 100;
// }
#endregion
OracleConn.Close();
OracleConn.Dispose();
//DR1.Dispose();
}
catch(Exception ex)
{
Debug.Fail(ex.Message +"-"+ ex.StackTrace);
}
return id;
}