private void InitData()
{
DetailSL = CSSLD.GetDetail(Request.QueryString["guid"]);
this.lblShipGuid.Text = DetailSL.SHIPGUID;
this.lblShipName.Text = DetailSL.SHIPNAME;
this.txtNationNum.Text = DetailSL.NATIONNUM;
this.txtNationPreNum.Text = DetailSL.NATIONPRENUM;
this.dtbNationFrom.Text = DetailSL.NATIONFROMDATE == DateTime.MinValue ? "" : DetailSL.NATIONFROMDATE.ToShortDateString();
this.dtbNationTo.Text = DetailSL.NATIONTODATE == DateTime.MinValue ? "" : DetailSL.NATIONTODATE.ToShortDateString();
this.txtDroitNum.Text = DetailSL.DROITNUM;
this.txtDroitPreNum.Text = DetailSL.DROITPRENUM;
this.dtbNationTo.Text = DetailSL.DROITDATE == DateTime.MinValue ? "" : DetailSL.DROITDATE.ToShortDateString();
this.dtbFZYWZS.Text = DetailSL.FZYWZSDATE == DateTime.MinValue ? "" : DetailSL.FZYWZSDATE.ToShortDateString();
this.dtbSHZS.Text = DetailSL.SHZSDATE == DateTime.MinValue ? "" : DetailSL.SHZSDATE.ToShortDateString();
this.dtbZHXZS.Text = DetailSL.ZHXZSDATE == DateTime.MinValue ? "" : DetailSL.ZHXZSDATE.ToShortDateString();
if (Request.QueryString["type"] == null)
{
btnAdd.Visible = false;
}
}
/// <summary>
/// 单据明细
/// 编写日期：2010-3-25
/// 编写人：JW
/// </summary>
/// <param name="GUID"></param>
public Detail_CAW_COR_SHIPLICENCE GetDetail(string GUID)
{
Database db = DatabaseFactory.CreateDatabase(CawConnStr);
string strSql = (db.DbProviderFactory.ToString() != "System.Data.OracleClient.OracleClientFactory") ?
"SELECT * FROM CAW_COR_SHIPLICENCE WHERE GUID=@GUID " :
"SELECT * FROM CAW_COR_SHIPLICENCE WHERE GUID=:GUID ";
DbCommand cmd = db.GetSqlStringCommand(strSql);
db.AddInParameter(cmd, "GUID", DbType.String, GUID);
Detail_CAW_COR_SHIPLICENCE myDetail = new Detail_CAW_COR_SHIPLICENCE();
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["SHIPNAME"]))
{
myDetail.SHIPNAME = Convert.ToString(myReader["SHIPNAME"]);
}
if (!Convert.IsDBNull(myReader["NATIONNUM"]))
{
myDetail.NATIONNUM = Convert.ToString(myReader["NATIONNUM"]);
}
if (!Convert.IsDBNull(myReader["NATIONPRENUM"]))
{
myDetail.NATIONPRENUM = Convert.ToString(myReader["NATIONPRENUM"]);
}
if (!Convert.IsDBNull(myReader["NATIONFROMDATE"]))
{
myDetail.NATIONFROMDATE = Convert.ToDateTime(myReader["NATIONFROMDATE"]);
}
if (!Convert.IsDBNull(myReader["NATIONTODATE"]))
{
myDetail.NATIONTODATE = Convert.ToDateTime(myReader["NATIONTODATE"]);
}
if (!Convert.IsDBNull(myReader["DROITNUM"]))
{
myDetail.DROITNUM = Convert.ToString(myReader["DROITNUM"]);
}
if (!Convert.IsDBNull(myReader["DROITPRENUM"]))
{
myDetail.DROITPRENUM = Convert.ToString(myReader["DROITPRENUM"]);
}
if (!Convert.IsDBNull(myReader["DROITDATE"]))
{
myDetail.DROITDATE = Convert.ToDateTime(myReader["DROITDATE"]);
}
if (!Convert.IsDBNull(myReader["FZYWZSDATE"]))
{
myDetail.FZYWZSDATE = Convert.ToDateTime(myReader["FZYWZSDATE"]);
}
if (!Convert.IsDBNull(myReader["SHZSDATE"]))
{
myDetail.SHZSDATE = Convert.ToDateTime(myReader["SHZSDATE"]);
}
if (!Convert.IsDBNull(myReader["ZHXZSDATE"]))
{
myDetail.ZHXZSDATE = Convert.ToDateTime(myReader["ZHXZSDATE"]);
}
}
}
return myDetail;
}
