/// <summary> /// 查询数据绑定 /// </summary> void DataBinder() { int voy_vessel = -1; try { voy_vessel = Convert.ToInt32(cmbVessel.SelectedItem.Value); } catch { cmbVessel.Value = ""; cmbVessel.Text = ""; } DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_OceanImport_Voyage_SP", new List <IFields>() { dal.CreateIFields(). Append("Option", "list"). Append("voy_Stat", FSecurityHelper.CurrentUserDataGET()[12]). Append("voy_Vessel", voy_vessel) }).GetList(); if (ds == null || ds.Tables[0].Rows.Count == 0) { txtVoyageID.Text = "0"; //labCarrierCode.Text = ""; txtVoyage.Text = ""; txtCFS.RawText = ""; txtCY.RawText = ""; txtETA.RawText = ""; txtETD.RawText = ""; txtOnboard.RawText = ""; cmbPOD.setValue(""); cmbPOL.setValue(""); gridVoyageRoute.GetStore().RemoveAll(); } if (ds != null && ds.Tables[1].Rows.Count > 0) { labCarrierCode.Text = ds.Tables[1].Rows[0]["Carrier"].ToString(); } storeVoyage.DataSource = ds; storeVoyage.DataBind(); if ((string.IsNullOrEmpty(Request["vessel"]) && Request["vesselID"] == null) && refresh) { RowSelectionModel sm = gridVoyage.GetSelectionModel() as RowSelectionModel; sm.SelectRow(0); sm.SelectedRows.Add(new SelectedRow(0)); } else if (Request["vesselID"] != null && cmbVessel.SelectedItem.Value != Request["vesselID"].ToString() && refresh) { RowSelectionModel sm = gridVoyage.GetSelectionModel() as RowSelectionModel; sm.SelectRow(0); sm.SelectedRows.Add(new SelectedRow(0)); } }
private void DataBindList() { List <IFields> Getlist = new List <IFields>(); Getlist.Add(dal.CreateIFields().Append("Option", "List") .Append("wbm_Seed", hidSeed.Text == "" ? null : hidSeed.Text) ); DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirExport_Manifest_SP", Getlist).GetList(); if (ds != null && ds.Tables[0].Rows[0][0].ToString() == "Y") { if (ds != null && ds.Tables[1].Rows.Count > 0) { txtHAWB.Text = ds.Tables[1].Rows[0]["wbm_HAWB"].ToString(); txtPKG.Text = ds.Tables[1].Rows[0]["wbm_RCP"].ToString(); txtWT.Text = ds.Tables[1].Rows[0]["wbm_WT"].ToString(); txtPreWT.Text = ds.Tables[1].Rows[0]["wbm_PreAlertWT"].ToString(); txtInfo.Text = ds.Tables[1].Rows[0]["wbm_WTLine"].ToString(); CmbDest.SelectedItem.Value = ds.Tables[1].Rows[0]["wbm_Final"].ToString(); CmbShipperCode.setValue(ds.Tables[1].Rows[0]["wbm_ShipperCode"].ToString()); lblShipper1.Text = ds.Tables[1].Rows[0]["wbm_Shipper1"].ToString(); lblShipper2.Text = ds.Tables[1].Rows[0]["wbm_Shipper2"].ToString(); lblShipper3.Text = ds.Tables[1].Rows[0]["wbm_Shipper3"].ToString(); lblShipper4.Text = ds.Tables[1].Rows[0]["wbm_Shipper4"].ToString(); lblShipper5.Text = ds.Tables[1].Rows[0]["wbm_Shipper5"].ToString(); lblShipper6.Text = ds.Tables[1].Rows[0]["wbm_Shipper6"].ToString(); CmbConsignee.setValue(ds.Tables[1].Rows[0]["wbm_ConsigneeCode"].ToString()); lblConsignee1.Text = ds.Tables[1].Rows[0]["wbm_Consignee1"].ToString(); lblConsignee2.Text = ds.Tables[1].Rows[0]["wbm_Consignee2"].ToString(); lblConsignee3.Text = ds.Tables[1].Rows[0]["wbm_Consignee3"].ToString(); lblConsignee4.Text = ds.Tables[1].Rows[0]["wbm_Consignee4"].ToString(); lblConsignee5.Text = ds.Tables[1].Rows[0]["wbm_Consignee5"].ToString(); lblConsignee6.Text = ds.Tables[1].Rows[0]["wbm_Consignee6"].ToString(); lblNature1.Text = ds.Tables[1].Rows[0]["wbm_Nature1"].ToString(); lblNature2.Text = ds.Tables[1].Rows[0]["wbm_Nature2"].ToString(); lblNature3.Text = ds.Tables[1].Rows[0]["wbm_Nature3"].ToString(); lblNature4.Text = ds.Tables[1].Rows[0]["wbm_Nature4"].ToString(); lblNature5.Text = ds.Tables[1].Rows[0]["wbm_Nature5"].ToString(); lblNature6.Text = ds.Tables[1].Rows[0]["wbm_Nature6"].ToString(); } if (ds != null && ds.Tables[2].Rows.Count > 0) { gpHawb.GetStore().DataSource = ds.Tables[2]; gpHawb.GetStore().DataBind(); RowSelectionModel sm = gpHawb.GetSelectionModel() as RowSelectionModel; sm.SelectRow(0); sm.SelectedRows.Add(new SelectedRow(0)); } } else { if (ds.Tables[1].Rows.Count > 0) { txtHAWB.Text = ds.Tables[1].Rows[0]["wbm_HAWB"].ToString(); txtPKG.Text = ds.Tables[1].Rows[0]["wbm_RCP"].ToString(); txtWT.Text = ds.Tables[1].Rows[0]["wbm_WT"].ToString(); CmbDest.SelectedItem.Value = ds.Tables[1].Rows[0]["wbm_Final"].ToString(); } } }