/// <summary> /// 获取开工报明细 /// 编写日期:2010-3-27 /// 编写人:JW /// </summary> /// <param name="GUID"></param> public Detail_CAW_MANAGE_START GetDetail(string GUID) { Database db = DatabaseFactory.CreateDatabase(CawConnStr); string strSql = (db.DbProviderFactory.ToString() != "System.Data.OracleClient.OracleClientFactory") ? "SELECT A.*,B.DATASTATUS,B.DATASTATUS_NAME FROM CAW_MANAGE_START A INNER JOIN CAW_DATESTATUS B ON A.GUID=B.KEYGUID WHERE A.GUID=@GUID " : "SELECT A.*,B.DATASTATUS,B.DATASTATUS_NAME FROM CAW_MANAGE_START 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_MANAGE_START myDetail = new Detail_CAW_MANAGE_START(); using (IDataReader myReader = db.ExecuteReader(cmd)) { if (myReader.Read()) { if (!Convert.IsDBNull(myReader["GUID"])) { myDetail.GUID = Convert.ToString(myReader["GUID"]); } 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["SHIPGUID"])) { myDetail.SHIPGUID = Convert.ToString(myReader["SHIPGUID"]); } if (!Convert.IsDBNull(myReader["SHIPNAME"])) { myDetail.SHIPNAME = Convert.ToString(myReader["SHIPNAME"]); } 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["UPHARBOUR"])) { myDetail.UPHARBOUR = Convert.ToString(myReader["UPHARBOUR"]); } if (!Convert.IsDBNull(myReader["WORKTYPE"])) { myDetail.WORKTYPE = Convert.ToString(myReader["WORKTYPE"]); } if (!Convert.IsDBNull(myReader["ARRIVETIME"])) { myDetail.ARRIVETIME = Convert.ToDateTime(myReader["ARRIVETIME"]); } if (!Convert.IsDBNull(myReader["STARTWORKTIME"])) { myDetail.STARTWORKTIME = Convert.ToDateTime(myReader["STARTWORKTIME"]); } if (!Convert.IsDBNull(myReader["CARGOTYPE"])) { myDetail.CARGOTYPE = Convert.ToString(myReader["CARGOTYPE"]); } if (!Convert.IsDBNull(myReader["CARGONAME"])) { myDetail.CARGONAME = Convert.ToString(myReader["CARGONAME"]); } if (!Convert.IsDBNull(myReader["CARGOPIECE"])) { myDetail.CARGOPIECE = Convert.ToInt32(myReader["CARGOPIECE"]); } if (!Convert.IsDBNull(myReader["CARGOCLASSGUID1"])) { myDetail.CARGOCLASSGUID1 = Convert.ToString(myReader["CARGOCLASSGUID1"]); } if (!Convert.IsDBNull(myReader["CARGOCLASSNAME1"])) { myDetail.CARGOCLASSNAME1 = Convert.ToString(myReader["CARGOCLASSNAME1"]); } if (!Convert.IsDBNull(myReader["CARGOCLASSGUID2"])) { myDetail.CARGOCLASSGUID2 = Convert.ToString(myReader["CARGOCLASSGUID2"]); } if (!Convert.IsDBNull(myReader["CARGOCLASSNAME2"])) { myDetail.CARGOCLASSNAME2 = Convert.ToString(myReader["CARGOCLASSNAME2"]); } if (!Convert.IsDBNull(myReader["EMPTY20"])) { myDetail.EMPTY20 = Convert.ToInt32(myReader["EMPTY20"]); } if (!Convert.IsDBNull(myReader["EMPTY40"])) { myDetail.EMPTY40 = Convert.ToInt32(myReader["EMPTY40"]); } if (!Convert.IsDBNull(myReader["EMPTY45"])) { myDetail.EMPTY45 = Convert.ToInt32(myReader["EMPTY45"]); } if (!Convert.IsDBNull(myReader["EMPTYTOTAL"])) { myDetail.EMPTYTOTAL = Convert.ToDecimal(myReader["EMPTYTOTAL"]); } if (!Convert.IsDBNull(myReader["WEIGHTY20"])) { myDetail.WEIGHTY20 = Convert.ToInt32(myReader["WEIGHTY20"]); } if (!Convert.IsDBNull(myReader["WEIGHTY40"])) { myDetail.WEIGHTY40 = Convert.ToInt32(myReader["WEIGHTY40"]); } if (!Convert.IsDBNull(myReader["WEIGHTY45"])) { myDetail.WEIGHTY45 = Convert.ToInt32(myReader["WEIGHTY45"]); } if (!Convert.IsDBNull(myReader["WEIGHTTOTAL"])) { myDetail.WEIGHTTOTAL = Convert.ToDecimal(myReader["WEIGHTTOTAL"]); } if (!Convert.IsDBNull(myReader["CARGOWEIGHT"])) { myDetail.CARGOWEIGHT = Convert.ToDecimal(myReader["CARGOWEIGHT"]); } if (!Convert.IsDBNull(myReader["CONTAINERTOTAL"])) { myDetail.CONTAINERTOTAL = Convert.ToDecimal(myReader["CONTAINERTOTAL"]); } if (!Convert.IsDBNull(myReader["TRADETYPE"])) { myDetail.TRADETYPE = Convert.ToString(myReader["TRADETYPE"]); } if (!Convert.IsDBNull(myReader["WORKLOAD"])) { myDetail.WORKLOAD = Convert.ToString(myReader["WORKLOAD"]); } if (!Convert.IsDBNull(myReader["INOROUT"])) { myDetail.INOROUT = Convert.ToString(myReader["INOROUT"]); } if (!Convert.IsDBNull(myReader["LOADCOUNTRY"])) { myDetail.LOADCOUNTRY = Convert.ToString(myReader["LOADCOUNTRY"]); } if (!Convert.IsDBNull(myReader["LOADHARBOUR"])) { myDetail.LOADHARBOUR = Convert.ToString(myReader["LOADHARBOUR"]); } if (!Convert.IsDBNull(myReader["UNLOADCOUNTRY"])) { myDetail.UNLOADCOUNTRY = Convert.ToString(myReader["UNLOADCOUNTRY"]); } if (!Convert.IsDBNull(myReader["UNLOADHARBOUR"])) { myDetail.UNLOADHARBOUR = Convert.ToString(myReader["UNLOADHARBOUR"]); } if (!Convert.IsDBNull(myReader["AGENTGUID"])) { myDetail.AGENTGUID = Convert.ToString(myReader["AGENTGUID"]); } if (!Convert.IsDBNull(myReader["AGENTCORP"])) { myDetail.AGENTCORP = Convert.ToString(myReader["AGENTCORP"]); } if (!Convert.IsDBNull(myReader["DEALGOODSGUID"])) { myDetail.DEALGOODSGUID = Convert.ToString(myReader["DEALGOODSGUID"]); } if (!Convert.IsDBNull(myReader["DEALGOODSCORP"])) { myDetail.DEALGOODSCORP = Convert.ToString(myReader["DEALGOODSCORP"]); } if (!Convert.IsDBNull(myReader["LOADCORP"])) { myDetail.LOADCORP = Convert.ToString(myReader["LOADCORP"]); } if (!Convert.IsDBNull(myReader["IS_AGENT"])) { myDetail.IS_AGENT = Convert.ToString(myReader["IS_AGENT"]); } 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; }
private void InitiData() { string StartGuid = ViewState["Guid"].ToString(); DCMS = StartDB.GetDetail(StartGuid); ViewState["IS_AGENT"] = DCMS.IS_AGENT; if (DCMS.IS_AGENT == "1") { this.lblCompanyName.Text = DCMS.AGENTCORP; this.lblCompanyGuid.Text = DCMS.AGENTGUID; this.ddlAgentCorp.Enabled = false; } else { this.lblCompanyGuid.Text = DCMS.COMPANYGUID; this.lblCompanyName.Text = DCMS.COMPANYNAME; this.ddlCorp.Enabled = false; } this.lblDataStatusName.Text = DCMS.DATASTATUS_NAME; this.ddlCorp.SelectedIndex = this.ddlCorp.Items.IndexOf(this.ddlCorp.Items.FindByValue(DCMS.COMPANYGUID)); new CawBindInfoDB().BindCorpBerth(this.ddlBerth, DCMS.COMPANYGUID); //船舶信息 this.hidShipGuid.Value = DCMS.SHIPGUID; this.txtShip.Value = DCMS.SHIPNAME; this.ddlBerth.SelectedIndex = this.ddlBerth.Items.IndexOf(this.ddlBerth.Items.FindByValue(DCMS.BERTHGUID)); this.txtUpAdd.Text = DCMS.UPHARBOUR; this.rbtWorkType.SelectedItem.Value = DCMS.WORKTYPE; this.dtbDockTime.Text = DCMS.ARRIVETIME.ToShortDateString(); this.ntbDockHour.Text = DCMS.ARRIVETIME.Hour.ToString(); this.ntbDockHour.Text = DCMS.ARRIVETIME.Minute.ToString(); this.dtbStartTime.Text = DCMS.STARTWORKTIME.ToShortDateString(); this.ntbStartHour.Text = DCMS.STARTWORKTIME.Hour.ToString(); this.ntbStartHour.Text = DCMS.STARTWORKTIME.Minute.ToString(); //装卸货物信息 this.rbtCargoType.SelectedIndex=this.rbtCargoType.Items.IndexOf(this.rbtCargoType.Items.FindByValue(DCMS.CARGOTYPE)); if (DCMS.CARGOTYPE == "0") { this.txtCargoName.Text = DCMS.CARGONAME; this.ntbPiece.Text = DCMS.CARGOPIECE.ToString(); this.ttvCargoClass1.Text = DCMS.CARGOCLASSNAME1; this.ttvCargoClass1.Value = DCMS.CARGOCLASSGUID1; //this.ttvCargoClass1.Value = CCCD.GetCodeByGuid(DCMS.CARGOCLASSGUID1); this.ttvCargoClass2.Text = DCMS.CARGOCLASSNAME2; this.ttvCargoClass2.Value = DCMS.CARGOCLASSGUID2; //this.ttvCargoClass2.Value = CCCD.GetCodeByGuid(DCMS.CARGOCLASSGUID2); this.ntbWeight.Text = DCMS.CARGOWEIGHT.ToString(); } else { this.CallJsFun("javascript:Is_JZX(1);"); this.ntbEmrty20.Text = DCMS.EMPTY20.ToString(); this.ntbEmrty40.Text = DCMS.EMPTY40.ToString(); this.ntbEmrty45.Text = DCMS.EMPTY45.ToString(); this.ntbEmrtyTotal.Text = DCMS.EMPTYTOTAL.ToString(); this.ntbWeighty20.Text = DCMS.WEIGHTY20.ToString(); this.ntbWeighty40.Text = DCMS.WEIGHTY40.ToString(); this.ntbWeighty45.Text = DCMS.WEIGHTY45.ToString(); this.ntbWeightyTotal.Text = DCMS.WEIGHTTOTAL.ToString(); this.ntbContainerTotal.Text = DCMS.CONTAINERTOTAL.ToString(); this.ntbConWeight.Text = DCMS.CARGOWEIGHT.ToString(); } this.rbtTradeType.SelectedIndex = this.rbtTradeType.Items.IndexOf(this.rbtTradeType.Items.FindByValue(DCMS.TRADETYPE)); this.rbtUpORDown.SelectedIndex = this.rbtUpORDown.Items.IndexOf(this.rbtUpORDown.Items.FindByValue(DCMS.WORKLOAD)); this.rbtInOROut.SelectedIndex = this.rbtInOROut.Items.IndexOf(this.rbtInOROut.Items.FindByValue(DCMS.INOROUT)); this.txtLoadCountry.Text = DCMS.LOADCOUNTRY; this.txtLoadHarbour.Text = DCMS.LOADHARBOUR; this.txtUnloadCountry.Text = DCMS.UNLOADCOUNTRY; this.txtUnloadHarbour.Text = DCMS.UNLOADHARBOUR; this.ddlAgentCorp.SelectedIndex = this.ddlAgentCorp.Items.IndexOf(this.ddlAgentCorp.Items.FindByValue(DCMS.AGENTGUID)); this.ddlDealgoodsCorp.SelectedIndex = this.ddlDealgoodsCorp.Items.IndexOf(this.ddlDealgoodsCorp.Items.FindByValue(DCMS.DEALGOODSGUID)); this.txtLoadCorp.Text = DCMS.LOADCORP; if (DCMS.DATASTATUS == "1" || DCMS.DATASTATUS == "2") { this.ShipsList.Visible = false; } //根据传入的参数进行按钮的可见和可用设置 //根据明细判断:审核用(按钮全隐藏) //数据状态:0保存未提交(可修改);1提交待审批(不可修改);2审批通过(不可修改);3退回(可修改);4审批暂停(可修改) //以下为按钮控制 bool InCheck = false; if (Request.QueryString["InCheck"] != null) { InCheck = true; } //注意传入的按钮顺序,如果没有则填null,分别为:保存按钮、提交按钮、返回按钮、添加附件按钮 new CommonFun().SetBtnStatus(InCheck, DCMS.DATASTATUS, btnEdit, btnSubmit, btnReturn, null); }
private void InitiData() { string EndGuid = Request.QueryString["guid"].ToString(); DCME = EndDB.GetDetail(EndGuid); DataView dv = EndDB.GetStatusByGuid(EndGuid); this.lblDataStatusName.Text = dv.Count == 0 ? "未填写完工报" : dv[0]["DATASTATUS_NAME"].ToString(); this.hidDataStatus.Value = dv.Count == 0 ? "" : dv[0]["DATASTATUS"].ToString(); ViewState["CurrStatus"] = this.hidDataStatus.Value; this.txtDownAdd.Text = DCME.DOWNHARBOUR; this.dtbEndDate.Text = DCME.ENDTIME == DateTime.MinValue ? "" : DCME.ENDTIME.ToShortDateString(); this.ntbEndHour.Text = DCME.ENDTIME == DateTime.MinValue ? "00" : DCME.ENDTIME.Hour.ToString("00"); this.ntbEndMinute.Text = DCME.ENDTIME == DateTime.MinValue ? "00" : DCME.ENDTIME.Minute.ToString("00"); this.dtbLeaveDate.Text = DCME.LEAVETIME == DateTime.MinValue ? "" : DCME.LEAVETIME.ToShortDateString(); this.ntbLeaveHour.Text = DCME.LEAVETIME == DateTime.MinValue ? "00" : DCME.LEAVETIME.Hour.ToString("00"); this.ntbLeaveMinute.Text = DCME.LEAVETIME == DateTime.MinValue ? "00" : DCME.LEAVETIME.Minute.ToString("00"); string StartGuid = DCME.STARTGUID; DCMS = StartDB.GetDetail(StartGuid); if (DCMS.IS_AGENT == "1") { this.lblCompanyGuid.Text = DCMS.AGENTGUID; this.lblCompanyName.Text = DCMS.AGENTCORP; } else { this.lblCompanyName.Text = DCMS.COMPANYNAME; this.lblCompanyGuid.Text = DCMS.COMPANYGUID; } this.lblCorp.Text = DCMS.COMPANYNAME; //船舶信息 this.lblShipGuid.Text = DCMS.SHIPGUID; this.lblShip.Text = DCMS.SHIPNAME; this.lblBerth.Text = DCMS.BERTHNAME; this.lblUpAdd.Text = DCMS.UPHARBOUR; this.rbtWorkType.SelectedItem.Value = DCMS.WORKTYPE; this.lblDockTime.Text = DCMS.ARRIVETIME.ToString("yyyy-MM-dd HH:mm"); this.lblStartTime.Text = DCMS.STARTWORKTIME.ToString("yyyy-MM-dd HH:mm"); //装卸货物信息 this.rbtCargoType.SelectedIndex = this.rbtCargoType.Items.IndexOf(this.rbtCargoType.Items.FindByValue(DCMS.CARGOTYPE)); if (DCMS.CARGOTYPE == "0") { this.lblCargoName.Text = DCMS.CARGONAME; this.lblPiece.Text = DCMS.CARGOPIECE.ToString(); this.lblCargoClass1.Text = DCMS.CARGOCLASSNAME1; this.lblCargoClass2.Text = DCMS.CARGOCLASSNAME2; this.lblWeight.Text = DCMS.CARGOWEIGHT.ToString(); } else { this.CallJsFun("javascript:Is_JZX(1);"); this.lblEmpty20.Text = DCMS.EMPTY20.ToString(); this.lblEmpty40.Text = DCMS.EMPTY40.ToString(); this.lblEmpty45.Text = DCMS.EMPTY45.ToString(); this.lblEmptyTotal.Text = DCMS.EMPTYTOTAL.ToString(); this.lblWeighty20.Text = DCMS.WEIGHTY20.ToString(); this.lblWeighty40.Text = DCMS.WEIGHTY40.ToString(); this.lblWeighty45.Text = DCMS.WEIGHTY45.ToString(); this.lblWeightyTotal.Text = DCMS.WEIGHTTOTAL.ToString(); this.lblContainerTotal.Text = DCMS.CONTAINERTOTAL.ToString(); this.lblConWeight.Text = DCMS.CARGOWEIGHT.ToString(); } this.rbtTradeType.SelectedIndex = this.rbtTradeType.Items.IndexOf(this.rbtTradeType.Items.FindByValue(DCMS.TRADETYPE)); this.rbtUpORDown.SelectedIndex = this.rbtUpORDown.Items.IndexOf(this.rbtUpORDown.Items.FindByValue(DCMS.WORKLOAD)); this.rbtInOROut.SelectedIndex = this.rbtInOROut.Items.IndexOf(this.rbtInOROut.Items.FindByValue(DCMS.INOROUT)); this.lblLoadCountry.Text = DCMS.LOADCOUNTRY; this.lblLoadHarbour.Text = DCMS.LOADHARBOUR; this.lblUnloadCountry.Text = DCMS.UNLOADCOUNTRY; this.lblUnloadHarbour.Text = DCMS.UNLOADHARBOUR; this.lblAgentCorp.Text = DCMS.AGENTCORP; this.lblDealgoodsCorp.Text = DCMS.DEALGOODSCORP; this.lblLoadCorp.Text = DCMS.LOADCORP; if (Session["IsCAW"].ToString() == "Y") { this.spanLeave.Visible = false; this.spanEnd.Visible = false; } //根据传入的参数进行按钮的可见和可用设置 //根据明细判断:审核用(按钮全隐藏) //数据状态:0保存未提交(可修改);1提交待审批(不可修改);2审批通过(不可修改);3退回(可修改);4审批暂停(可修改) //以下为按钮控制 bool InCheck = false; if (Request.QueryString["InCheck"] != null) { InCheck = true; } if (this.hidDataStatus.Value != "") { //注意传入的按钮顺序,如果没有则填null,分别为:保存按钮、提交按钮、返回按钮、添加附件按钮 new CommonFun().SetBtnStatus(InCheck, this.hidDataStatus.Value.Trim(), btnEdit, btnSubmit, btnReturn, null); } }
private void InitiData() { string EndGuid = Request.QueryString["guid"].ToString(); DCME = EndDB.GetDetail(EndGuid); DataView dv = EndDB.GetStatusByGuid(EndGuid); this.lblDataStatusName.Text = dv[0]["DATASTATUS_NAME"].ToString(); this.lblDownHarbour.Text = DCME.DOWNHARBOUR; this.lblEndTime.Text = DCME.ENDTIME.ToString("yyyy-MM-dd HH:mm"); this.lblLeaveTime.Text = DCME.ENDTIME.ToString("yyyy-MM-dd HH:mm"); string StartGuid = DCME.STARTGUID; DCMS = StartDB.GetDetail(StartGuid); if (DCMS.IS_AGENT == "1") { this.lblCompanyGuid.Text = DCMS.AGENTGUID; this.lblCompanyName.Text = DCMS.AGENTCORP; } else { this.lblCompanyGuid.Text = DCMS.COMPANYGUID; this.lblCompanyName.Text = DCMS.COMPANYNAME; } this.lblCorp.Text = DCMS.COMPANYNAME; //船舶信息 this.lblShipGuid.Text = DCMS.SHIPGUID; this.lblShip.Text = DCMS.SHIPNAME; this.lblBerth.Text = DCMS.BERTHNAME; this.lblUpAdd.Text = DCMS.UPHARBOUR; this.rbtWorkType.SelectedItem.Value = DCMS.WORKTYPE; this.lblDockTime.Text = DCMS.ARRIVETIME.ToString("yyyy-MM-dd HH:mm"); this.lblStartTime.Text = DCMS.STARTWORKTIME.ToString("yyyy-MM-dd HH:mm"); //装卸货物信息 this.rbtCargoType.SelectedIndex = this.rbtCargoType.Items.IndexOf(this.rbtCargoType.Items.FindByValue(DCMS.CARGOTYPE)); if (DCMS.CARGOTYPE == "0") { this.lblCargoName.Text = DCMS.CARGONAME; this.lblPiece.Text = DCMS.CARGOPIECE.ToString(); this.lblCargoClass1.Text = DCMS.CARGOCLASSNAME1; this.lblCargoClass2.Text = DCMS.CARGOCLASSNAME2; this.lblWeight.Text = DCMS.CARGOWEIGHT.ToString(); } else { this.CallJsFun("javascript:Is_JZX(1);"); this.lblEmpty20.Text = DCMS.EMPTY20.ToString(); this.lblEmpty40.Text = DCMS.EMPTY40.ToString(); this.lblEmpty45.Text = DCMS.EMPTY45.ToString(); this.lblEmptyTotal.Text = DCMS.EMPTYTOTAL.ToString(); this.lblWeighty20.Text = DCMS.WEIGHTY20.ToString(); this.lblWeighty40.Text = DCMS.WEIGHTY40.ToString(); this.lblWeighty45.Text = DCMS.WEIGHTY45.ToString(); this.lblWeightyTotal.Text = DCMS.WEIGHTTOTAL.ToString(); this.lblContainerTotal.Text = DCMS.CONTAINERTOTAL.ToString(); this.lblConWeight.Text = DCMS.CARGOWEIGHT.ToString(); } this.rbtTradeType.SelectedIndex = this.rbtTradeType.Items.IndexOf(this.rbtTradeType.Items.FindByValue(DCMS.TRADETYPE)); this.rbtUpORDown.SelectedIndex = this.rbtUpORDown.Items.IndexOf(this.rbtUpORDown.Items.FindByValue(DCMS.WORKLOAD)); this.rbtInOROut.SelectedIndex = this.rbtInOROut.Items.IndexOf(this.rbtInOROut.Items.FindByValue(DCMS.INOROUT)); this.lblLoadCountry.Text = DCMS.LOADCOUNTRY; this.lblLoadHarbour.Text = DCMS.LOADHARBOUR; this.lblUnloadCountry.Text = DCMS.UNLOADCOUNTRY; this.lblUnloadHarbour.Text = DCMS.UNLOADHARBOUR; this.lblAgentCorp.Text = DCMS.AGENTCORP; this.lblDealgoodsCorp.Text = DCMS.DEALGOODSCORP; this.lblLoadCorp.Text = DCMS.LOADCORP; }