/// <summary> /// /// 编写日期:2010-3-25 /// 编写人:JW /// </summary> /// <param name="GUID"></param> public Detail_CAW_MANAGE_SHIPS GetDetail(string GUID) { Database db = DatabaseFactory.CreateDatabase(CawConnStr); string strSql = (db.DbProviderFactory.ToString() != "System.Data.OracleClient.OracleClientFactory") ? "SELECT * FROM CAW_MANAGE_SHIPS WHERE GUID=@GUID " : "SELECT * FROM CAW_MANAGE_SHIPS WHERE GUID=:GUID "; DbCommand cmd = db.GetSqlStringCommand(strSql); db.AddInParameter(cmd, "GUID", DbType.String, GUID); Detail_CAW_MANAGE_SHIPS myDetail = new Detail_CAW_MANAGE_SHIPS(); using (IDataReader myReader = db.ExecuteReader(cmd)) { if (myReader.Read()) { if (!Convert.IsDBNull(myReader["GUID"])) { myDetail.GUID = Convert.ToString(myReader["GUID"]); } if (!Convert.IsDBNull(myReader["SHIPNAMECN"])) { myDetail.SHIPNAMECN = Convert.ToString(myReader["SHIPNAMECN"]); } if (!Convert.IsDBNull(myReader["SHIPNAMEEN"])) { myDetail.SHIPNAMEEN = Convert.ToString(myReader["SHIPNAMEEN"]); } if (!Convert.IsDBNull(myReader["SHIPTYPE"])) { myDetail.SHIPTYPE = Convert.ToInt32(myReader["SHIPTYPE"]); } if (!Convert.IsDBNull(myReader["SHIPTYPENAME"])) { myDetail.SHIPTYPENAME = Convert.ToString(myReader["SHIPTYPENAME"]); } if (!Convert.IsDBNull(myReader["NATIONALITY"])) { myDetail.NATIONALITY = Convert.ToString(myReader["NATIONALITY"]); } if (!Convert.IsDBNull(myReader["CALLLETTER"])) { myDetail.CALLLETTER = Convert.ToString(myReader["CALLLETTER"]); } if (!Convert.IsDBNull(myReader["YEARNUM"])) { myDetail.YEARNUM = Convert.ToInt32(myReader["YEARNUM"]); } if (!Convert.IsDBNull(myReader["GRT"])) { myDetail.GRT = Convert.ToDecimal(myReader["GRT"]); } if (!Convert.IsDBNull(myReader["NRT"])) { myDetail.NRT = Convert.ToDecimal(myReader["NRT"]); } if (!Convert.IsDBNull(myReader["DWT"])) { myDetail.DWT = Convert.ToDecimal(myReader["DWT"]); } if (!Convert.IsDBNull(myReader["SHIPLENGTH"])) { myDetail.SHIPLENGTH = Convert.ToDecimal(myReader["SHIPLENGTH"]); } if (!Convert.IsDBNull(myReader["SHIPWIDTH"])) { myDetail.SHIPWIDTH = Convert.ToDecimal(myReader["SHIPWIDTH"]); } if (!Convert.IsDBNull(myReader["SEAGUAGE"])) { myDetail.SEAGUAGE = Convert.ToDecimal(myReader["SEAGUAGE"]); } if (!Convert.IsDBNull(myReader["LOLLSEAGUAGE"])) { myDetail.LOLLSEAGUAGE = Convert.ToDecimal(myReader["LOLLSEAGUAGE"]); } if (!Convert.IsDBNull(myReader["OWNER"])) { myDetail.OWNER = Convert.ToString(myReader["OWNER"]); } if (!Convert.IsDBNull(myReader["SHIPHOIST"])) { myDetail.SHIPHOIST = Convert.ToInt32(myReader["SHIPHOIST"]); } if (!Convert.IsDBNull(myReader["SHIPHOLD"])) { myDetail.SHIPHOLD = Convert.ToInt32(myReader["SHIPHOLD"]); } if (!Convert.IsDBNull(myReader["LENGTH"])) { myDetail.LENGTH = Convert.ToDecimal(myReader["LENGTH"]); } if (!Convert.IsDBNull(myReader["HEIGHT"])) { myDetail.HEIGHT = Convert.ToDecimal(myReader["HEIGHT"]); } } } return myDetail; }
private void InitiData(string ShipGuid) { DCShip = ShipDB.GetDetail(ShipGuid); this.txtShipNameCN.Text = DCShip.SHIPNAMECN; this.txtSHIPNAMEEN.Text = DCShip.SHIPNAMEEN; this.txtCALLLETTER.Text = DCShip.CALLLETTER; this.txtOWNER.Text = DCShip.OWNER; this.ntbYearNum.Text = DCShip.YEARNUM.ToString(); this.txtNationality.Text = DCShip.NATIONALITY; this.ddlShipType.SelectedIndex = this.ddlShipType.Items.IndexOf(this.ddlShipType.Items.FindByValue(DCShip.SHIPTYPE.ToString())); this.ntbShipHoist.Text = DCShip.SHIPHOIST.ToString(); this.ntbShipHold.Text = DCShip.SHIPHOLD.ToString(); this.ntxtTOTALTON.Text = DCShip.GRT.ToString(); this.ntxtNETTON.Text = DCShip.NRT.ToString(); this.ntxtLOADTON.Text = DCShip.DWT.ToString(); this.ntxtSHIPLENGTH.Text = DCShip.SHIPLENGTH.ToString(); this.ntxtSHIPWIDTH.Text = DCShip.SHIPWIDTH.ToString(); this.ntxtLENGTH.Text = DCShip.LENGTH.ToString(); this.ntxtHEIGHT.Text = DCShip.HEIGHT.ToString(); this.ntxtDEPTH.Text = DCShip.SEAGUAGE.ToString(); this.ntxtLOLLDEPTH.Text = DCShip.LOLLSEAGUAGE.ToString(); }