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