SERVER数据转换ORACLE问题(2)

　2008-12-16 13:05:12　来源：WEB开发网　闂傚倸鍊搁崐椋庢濮橆兗缂氱憸宥堢亱闂佸湱铏庨崰鏍不椤栫偞鐓ラ柣鏇炲€圭€氾拷

闂傚倸鍊搁崐椋庣矆娓氣偓楠炲鏁撻悩鎻掔€梺姹囧灩閻忔艾鐣烽弻銉︾厵闁规鍠栭。濂告煕鎼达紕校闁靛洤瀚伴獮鎺楀箣濠靛啫浜鹃柣銏⑶圭壕濠氭煙閻愵剚鐏辨俊鎻掔墛缁绘盯宕卞Δ鍐冣剝绻涘畝濠佺敖缂佽鲸鎹囧畷鎺戭潩閹典焦鐎搁梻浣烘嚀閸ゆ牠骞忛敓锟�

婵犵數濮烽弫鍛婃叏椤撱垹绠柛鎰靛枛瀹告繃銇勯幘瀵哥畼闁硅娲熷缁樼瑹閳ь剙岣胯鐓ら柕鍫濇偪濞差亜惟闁宠桨鑳堕崝锕€顪冮妶鍡楃瑐闁煎啿鐖奸崺濠囧即閵忥紕鍘梺鎼炲劗閺呮稒绂掕缁辨帗娼忛埡浣锋闂佽桨鐒﹂幑鍥极閹剧粯鏅搁柨鐕傛嫹闂傚倸鍊搁崐椋庢濮橆兗缂氱憸宥堢亱闂佸湱铏庨崰鏍不椤栫偞鐓ラ柣鏇炲€圭€氾拷　　闂傚倸鍊搁崐鐑芥嚄閼哥數浠氱紓鍌欒兌缁垶銆冮崨鏉戠厺鐎广儱顦崡鎶芥煏韫囨洖校闁诲寒鍓熷铏圭磼濡搫顫岄梺鍦拡閸嬪棝鎯€椤忓浂妯勯梺鍝勬湰濞叉ḿ鎹㈠┑濠勭杸闁哄洨濮烽悰銉╂⒒娴ｅ搫甯跺鐟帮攻缁傚秴饪伴崼姘ｅ亾閺冨牆绀冩い蹇庣娴滈箖鏌ㄥ┑鍡涱€楀褜鍠栭湁闁绘ɑ鐟ョ€氼喚绮绘ィ鍐╃厱妞ゆ劑鍊曢弸搴ㄦ煟韫囧鍔滈柕鍥у瀵潙螣閸濆嫬袝婵＄偑鍊戦崹娲偡閳哄懎绠栭柍鈺佸暞閸庣喖鏌曢崶褍绨婚柟鍑ゆ嫹

核心提示：下面要做的就是往oracle中写你要的数据了！建立连接:string OracleString = "user id=construct;data source=oracle;password=rose";string OracleText = “在这里写你要插入的sql语句&ldquo

下面要做的就是往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; }