/// <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;
}
