/// <summary> /// /// 编写日期:2010-4-23 /// 编写人:JW /// </summary> /// <param name="GUID"></param> public Detail_CAW_AGENTSHIPINFO GetDetail(string GUID) { Database db = DatabaseFactory.CreateDatabase("ZJGEportConnStr"); string strSql = (db.DbProviderFactory.ToString() != "System.Data.OracleClient.OracleClientFactory") ? "SELECT A.*, B.DATASTATUS,B.DATASTATUS_NAME FROM CAW_AGENTSHIPINFO A INNER JOIN CAW_DATESTATUS B ON A.GUID=B.KEYGUID WHERE A.GUID=@GUID " : "SELECT A.*, B.DATASTATUS,B.DATASTATUS_NAME FROM CAW_AGENTSHIPINFO A INNER JOIN CAW_DATESTATUS B ON A.GUID=B.KEYGUID WHERE A.GUID=:GUID "; DbCommand cmd = db.GetSqlStringCommand(strSql); db.AddInParameter(cmd, "GUID", DbType.String, GUID); Detail_CAW_AGENTSHIPINFO myDetail = new Detail_CAW_AGENTSHIPINFO(); using (IDataReader myReader = db.ExecuteReader(cmd)) { if (myReader.Read()) { if (!Convert.IsDBNull(myReader["GUID"])) { myDetail.GUID = Convert.ToString(myReader["GUID"]); } if (!Convert.IsDBNull(myReader["SHIPGUID"])) { myDetail.SHIPGUID = Convert.ToString(myReader["SHIPGUID"]); } if (!Convert.IsDBNull(myReader["COMPANYGUID"])) { myDetail.COMPANYGUID = Convert.ToString(myReader["COMPANYGUID"]); } if (!Convert.IsDBNull(myReader["COMPANYNAME"])) { myDetail.COMPANYNAME = Convert.ToString(myReader["COMPANYNAME"]); } 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["CALLLETTER"])) { myDetail.CALLLETTER = Convert.ToString(myReader["CALLLETTER"]); } if (!Convert.IsDBNull(myReader["OWNER"])) { myDetail.OWNER = Convert.ToString(myReader["OWNER"]); } if (!Convert.IsDBNull(myReader["BUILDDATE"])) { myDetail.BUILDDATE = Convert.ToInt16(myReader["BUILDDATE"]); } if (!Convert.IsDBNull(myReader["NATIONNALITY"])) { myDetail.NATIONNALITY = Convert.ToString(myReader["NATIONNALITY"]); } 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["SHIPHOIST"])) { myDetail.SHIPHOIST = Convert.ToInt32(myReader["SHIPHOIST"]); } if (!Convert.IsDBNull(myReader["SHIPHOLD"])) { myDetail.SHIPHOLD = Convert.ToInt32(myReader["SHIPHOLD"]); } if (!Convert.IsDBNull(myReader["TOTALTON"])) { myDetail.TOTALTON = Convert.ToDecimal(myReader["TOTALTON"]); } if (!Convert.IsDBNull(myReader["NETTON"])) { myDetail.NETTON = Convert.ToDecimal(myReader["NETTON"]); } if (!Convert.IsDBNull(myReader["LOADTON"])) { myDetail.LOADTON = Convert.ToDecimal(myReader["LOADTON"]); } 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["DEPTH"])) { myDetail.DEPTH = Convert.ToDecimal(myReader["DEPTH"]); } if (!Convert.IsDBNull(myReader["GOODSINFO"])) { myDetail.GOODSINFO = Convert.ToString(myReader["GOODSINFO"]); } if (!Convert.IsDBNull(myReader["FEEINFO"])) { myDetail.FEEINFO = Convert.ToString(myReader["FEEINFO"]); } if (!Convert.IsDBNull(myReader["LENGTH"])) { myDetail.LENGTH = Convert.ToDecimal(myReader["LENGTH"]); } if (!Convert.IsDBNull(myReader["LOLLDEPTH"])) { myDetail.LOLLDEPTH = Convert.ToDecimal(myReader["LOLLDEPTH"]); } if (!Convert.IsDBNull(myReader["HEIGHT"])) { myDetail.HEIGHT = Convert.ToDecimal(myReader["HEIGHT"]); } if (!Convert.IsDBNull(myReader["SHIPMENNATIONNALITY"])) { myDetail.SHIPMENNATIONNALITY = Convert.ToString(myReader["SHIPMENNATIONNALITY"]); } if (!Convert.IsDBNull(myReader["PORTGUID"])) { myDetail.PORTGUID = Convert.ToString(myReader["PORTGUID"]); } if (!Convert.IsDBNull(myReader["PORTNAME"])) { myDetail.PORTNAME = Convert.ToString(myReader["PORTNAME"]); } if (!Convert.IsDBNull(myReader["BERTHGUID"])) { myDetail.BERTHGUID = Convert.ToString(myReader["BERTHGUID"]); } if (!Convert.IsDBNull(myReader["BERTHNAME"])) { myDetail.BERTHNAME = Convert.ToString(myReader["BERTHNAME"]); } if (!Convert.IsDBNull(myReader["LOADHARBOUR"])) { myDetail.LOADHARBOUR = Convert.ToString(myReader["LOADHARBOUR"]); } if (!Convert.IsDBNull(myReader["UNLOADHARBOUR"])) { myDetail.UNLOADHARBOUR = Convert.ToString(myReader["UNLOADHARBOUR"]); } if (!Convert.IsDBNull(myReader["PREVIOUSHARBOUR"])) { myDetail.PREVIOUSHARBOUR = Convert.ToString(myReader["PREVIOUSHARBOUR"]); } if (!Convert.IsDBNull(myReader["NEXTHARBOUR"])) { myDetail.NEXTHARBOUR = Convert.ToString(myReader["NEXTHARBOUR"]); } if (!Convert.IsDBNull(myReader["ARRIVEYANGTSERIVERDATE"])) { myDetail.ARRIVEYANGTSERIVERDATE = Convert.ToDateTime(myReader["ARRIVEYANGTSERIVERDATE"]); } if (!Convert.IsDBNull(myReader["ARRIVEZJGDATE"])) { myDetail.ARRIVEZJGDATE = Convert.ToDateTime(myReader["ARRIVEZJGDATE"]); } if (!Convert.IsDBNull(myReader["DEALGOODSCMPGUID"])) { myDetail.DEALGOODSCMPGUID = Convert.ToString(myReader["DEALGOODSCMPGUID"]); } if (!Convert.IsDBNull(myReader["DEALGOODSCMPNAME"])) { myDetail.DEALGOODSCMPNAME = Convert.ToString(myReader["DEALGOODSCMPNAME"]); } if (!Convert.IsDBNull(myReader["DATASTATUS"])) { myDetail.DATASTATUS = Convert.ToString(myReader["DATASTATUS"]); } if (!Convert.IsDBNull(myReader["DATASTATUS_NAME"])) { myDetail.DATASTATUS_NAME = Convert.ToString(myReader["DATASTATUS_NAME"]); } } } return myDetail; }
/// <summary> /// /// 编写日期:2010-3-19 /// 编写人:GWF /// </summary> /// <param name="DESIGNGUID"></param> public Detail_CAW_AGENTSHIPMOVEMENT Select(string pGUID) { Database db = DatabaseFactory.CreateDatabase(CawConnStr); string strSql = "SELECT A.*, B.DATASTATUS,B.DATASTATUS_NAME FROM CAW_AGENTSHIPMOVEMENT A,CAW_DATESTATUS B WHERE A.GUID=B.KEYGUID AND A.GUID='" + pGUID + "'"; DbCommand cmd = db.GetSqlStringCommand(strSql); DataView dv = db.ExecuteDataView(cmd); Detail_CAW_AGENTSHIPMOVEMENT CDG = new Detail_CAW_AGENTSHIPMOVEMENT(); if (dv.Count > 0) { CDG.GUID = dv[0]["GUID"].ToString(); CDG.COMPANYGUID = dv[0]["COMPANYGUID"].ToString(); CDG.AGENTSHIPGUID = dv[0]["AGENTSHIPGUID"].ToString(); CDG.AFFAIR = dv[0]["AFFAIR"].ToString(); CDG.BERTH = dv[0]["BERTH"].ToString(); CDG.PORT = dv[0]["PORT"].ToString(); CDG.DATASTATUS = dv[0]["DATASTATUS"].ToString(); CDG.DATASTATUS_NAME = dv[0]["DATASTATUS_NAME"].ToString(); } DataView dvinfo = new CawInfoAgentShipInfo().Select(CDG.AGENTSHIPGUID); if (dvinfo.Count>0) { Detail_CAW_AGENTSHIPINFO AGENTSHIPINFO = new Detail_CAW_AGENTSHIPINFO(); AGENTSHIPINFO.GUID = dvinfo[0]["GUID"].ToString(); AGENTSHIPINFO.SHIPNAMECN=dvinfo[0]["SHIPNAMECN"].ToString(); AGENTSHIPINFO.SHIPNAMEEN = dvinfo[0]["SHIPNAMEEN"].ToString(); AGENTSHIPINFO.NATIONNALITY = dvinfo[0]["NATIONNALITY"].ToString(); AGENTSHIPINFO.SHIPLENGTH = Convert.ToDecimal(dvinfo[0]["SHIPLENGTH"].ToString()); AGENTSHIPINFO.PREVIOUSHARBOUR = dvinfo[0]["PREVIOUSHARBOUR"].ToString(); AGENTSHIPINFO.NEXTHARBOUR = dvinfo[0]["NEXTHARBOUR"].ToString(); AGENTSHIPINFO.SHIPMENNATIONNALITY = dvinfo[0]["SHIPMENNATIONNALITY"].ToString(); CDG.AGENTSHIPINFO = AGENTSHIPINFO; } return CDG; }