/// <summary> /// Creates a new instance of the ViewSeguridadUsuario class and populates it with data from the specified SqlDataReader. /// </summary> private static ViewSeguridadUsuarioInfo MakeViewSeguridadUsuario(SqlDataReader dataReader) { ViewSeguridadUsuarioInfo viewSeguridadUsuario = new ViewSeguridadUsuarioInfo(); if (dataReader.IsDBNull(SeguridadUsuarioId) == false) viewSeguridadUsuario.SeguridadUsuarioId = dataReader.GetInt32(SeguridadUsuarioId); if (dataReader.IsDBNull(SeguridadRolId) == false) viewSeguridadUsuario.SeguridadRolId = dataReader.GetInt32(SeguridadRolId); if (dataReader.IsDBNull(Rol) == false) viewSeguridadUsuario.Rol = dataReader.GetString(Rol); if (dataReader.IsDBNull(NombreUsuario) == false) viewSeguridadUsuario.NombreUsuario = dataReader.GetString(NombreUsuario); if (dataReader.IsDBNull(Nombres) == false) viewSeguridadUsuario.Nombres = dataReader.GetString(Nombres); if (dataReader.IsDBNull(Apellidos) == false) viewSeguridadUsuario.Apellidos = dataReader.GetString(Apellidos); if (dataReader.IsDBNull(PaswordHash) == false) viewSeguridadUsuario.PaswordHash = dataReader.GetString(PaswordHash); if (dataReader.IsDBNull(Salt) == false) viewSeguridadUsuario.salt = dataReader.GetString(Salt); if (dataReader.IsDBNull(Activo) == false) viewSeguridadUsuario.Activo = dataReader.GetBoolean(Activo); if (dataReader.IsDBNull(NombreCompleto) == false) viewSeguridadUsuario.NombreCompleto = dataReader.GetString(NombreCompleto); return viewSeguridadUsuario; }
/// <summary> /// Loads the entity from a <b>SqlDataReader</b> object. /// </summary> /// <param name="dr">The data reader to read from.</param> /// <returns>Returns the number of columns read.</returns> /// <remarks> /// Always reads at the current cursor position, doesn't calls the <b>Read</b> function /// on the <b>SqlDataReader</b> object. Reads data columns by their ordinal position in /// the query and not by their names. /// </remarks> internal override int LoadFromDataReader(SqlDataReader dr) { int o = base.LoadFromDataReader(dr); ++o; // skip guid this.workflowTypeName = dr.GetString(++o); this.dateStarted = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o); this.dateFinished = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o); this.jobExecutionStatus = (JobExecutionState)dr.GetInt32(++o); this.suspendTimeout = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o); this.scheduleType = (ScheduleType)dr.GetInt32(++o); this.scheduleTime = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o); this.recurringPeriod = (RecurringPeriod)dr.GetInt32(++o); this.recurringInterval = dr.GetInt32(++o); this.recurringMask = dr.GetInt64(++o); this.workflowInstanceId = dr.IsDBNull(++o) ? Guid.Empty : dr.GetGuid(o); this.adminRequestTime = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o); if (!dr.IsDBNull(++o)) { XmlSerializer ser = new XmlSerializer(typeof(JobAdminRequestData)); StringReader sr = new StringReader(dr.GetString(o)); this.adminRequestData = (JobAdminRequestData)ser.Deserialize(sr); } else { this.adminRequestData = null; } this.adminRequestResult = dr.GetInt32(++o); this.exceptionMessage = dr.IsDBNull(++o) ? null : dr.GetString(o); return o; }
/** Descripcion: * * REQ: SqlDataReader, int * * RET: static string */ public static string SafeGetString(SqlDataReader reader, int colIndex) { if (!reader.IsDBNull(colIndex)) return reader.GetString(colIndex); else return string.Empty; }
/// <summary> /// Creates a new instance of the ViewCalidadPlanAccion class and populates it with data from the specified SqlDataReader. /// </summary> private static ViewCalidadPlanAccionInfo MakeViewCalidadPlanAccion(SqlDataReader dataReader) { ViewCalidadPlanAccionInfo viewCalidadPlanAccion = new ViewCalidadPlanAccionInfo(); if (dataReader.IsDBNull(CalidadPlanAccionId) == false) viewCalidadPlanAccion.CalidadPlanAccionId = dataReader.GetInt32(CalidadPlanAccionId); if (dataReader.IsDBNull(AuditorId) == false) viewCalidadPlanAccion.AuditorId = dataReader.GetInt32(AuditorId); if (dataReader.IsDBNull(NombreAuditor) == false) viewCalidadPlanAccion.NombreAuditor = dataReader.GetString(NombreAuditor); if (dataReader.IsDBNull(TerritorioId) == false) viewCalidadPlanAccion.TerritorioId = dataReader.GetInt32(TerritorioId); if (dataReader.IsDBNull(Territorio) == false) viewCalidadPlanAccion.Territorio = dataReader.GetString(Territorio); if (dataReader.IsDBNull(AuditoriaCausaRaizId) == false) viewCalidadPlanAccion.AuditoriaCausaRaizId = dataReader.GetInt32(AuditoriaCausaRaizId); if (dataReader.IsDBNull(CausaRaiz) == false) viewCalidadPlanAccion.CausaRaiz = dataReader.GetString(CausaRaiz); if (dataReader.IsDBNull(AccionPreventiva) == false) viewCalidadPlanAccion.AccionPreventiva = dataReader.GetString(AccionPreventiva); if (dataReader.IsDBNull(FechaPlaneada) == false) viewCalidadPlanAccion.FechaPlaneada = dataReader.GetDateTime(FechaPlaneada); if (dataReader.IsDBNull(Observacion) == false) viewCalidadPlanAccion.Observacion = dataReader.GetString(Observacion); if (dataReader.IsDBNull(FechaCierre) == false) viewCalidadPlanAccion.FechaCierre = dataReader.GetDateTime(FechaCierre); if (dataReader.IsDBNull(Estatus) == false) viewCalidadPlanAccion.Estatus = dataReader.GetString(Estatus); return viewCalidadPlanAccion; }
/// <summary> /// Creates a new instance of the ViewControlesAsignados class and populates it with data from the specified SqlDataReader. /// </summary> private static ViewControlesAsignadosInfo MakeViewControlesAsignados(SqlDataReader dataReader) { ViewControlesAsignadosInfo viewControlesAsignados = new ViewControlesAsignadosInfo(); if (dataReader.IsDBNull(AuditoriaResultadoId) == false) viewControlesAsignados.AuditoriaResultadoId = dataReader.GetInt32(AuditoriaResultadoId); if (dataReader.IsDBNull(AuditoriaControlId) == false) viewControlesAsignados.AuditoriaControlId = dataReader.GetInt32(AuditoriaControlId); if (dataReader.IsDBNull(AuditoriaPuntoId) == false) viewControlesAsignados.AuditoriaPuntoId = dataReader.GetInt32(AuditoriaPuntoId); if (dataReader.IsDBNull(Punto) == false) viewControlesAsignados.Punto = dataReader.GetString(Punto); if (dataReader.IsDBNull(Control) == false) viewControlesAsignados.Control = dataReader.GetString(Control); if (dataReader.IsDBNull(AuditoriaId) == false) viewControlesAsignados.AuditoriaId = dataReader.GetInt32(AuditoriaId); if (dataReader.IsDBNull(PuntajeRequerido) == false) viewControlesAsignados.PuntajeRequerido = dataReader.GetDecimal(PuntajeRequerido); if (dataReader.IsDBNull(EsNoConformidad) == false) viewControlesAsignados.EsNoConformidad = dataReader.GetBoolean(EsNoConformidad); if (dataReader.IsDBNull(AuditoriaCausaRaizId) == false) viewControlesAsignados.AuditoriaCausaRaizId = dataReader.GetInt32(AuditoriaCausaRaizId); if (dataReader.IsDBNull(Observacion) == false) viewControlesAsignados.Observacion = dataReader.GetString(Observacion); if (dataReader.IsDBNull(Orden) == false) viewControlesAsignados.Orden = dataReader.GetByte(Orden); return viewControlesAsignados; }
public static Request Map(SqlDataReader record) { if (record == null) throw new ArgumentNullException("record"); var request = new Request(); request.Id = (int) record["Id"]; request.RequesTime = (DateTime) record["RequetTime"]; if (record["CreatorId"].ToString() != string.Empty) { request.CreatorId = (int) record["CreatorId"]; } request.PhoneNumber = (string) record["PhoneNumber"]; request.Status = (int) record["Status"]; request.StartPoint = (string) record["StartPoint"]; request.FinishPoint = (string) record["FinishPoint"]; request.OperatorId = record.IsDBNull(record.GetOrdinal("OperatorId")) == false ? (int)record["OperatorId"] : default(int?); request.DriverId = record.IsDBNull(record.GetOrdinal("DriverId")) == false ? (int?) record["DriverId"] : default(int?); request.Price = record.IsDBNull(record.GetOrdinal("Price")) == false ? (decimal?)record["Price"] : default(decimal?); request.Additional = record.IsDBNull(record.GetOrdinal("Additional")) == false ? (string)record["Additional"] : default(string); return request; }
public void PopulateVolunteer(SqlDataReader _dtr, Volunteer obj) { int columnIndex = 0; columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.ID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_NAME); if (!_dtr.IsDBNull(columnIndex)) { obj.Name = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_EMAIL); if (!_dtr.IsDBNull(columnIndex)) { obj.Email = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_CV); if (!_dtr.IsDBNull(columnIndex)) { obj.CV = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_MESSAGE); if (!_dtr.IsDBNull(columnIndex)) { obj.Message = _dtr.GetString((columnIndex)); } }
/// <summary> /// Creates a new instance of the ViewAPM class and populates it with data from the specified SqlDataReader. /// </summary> private static ViewAPMInfo MakeViewAPM(SqlDataReader dataReader) { ViewAPMInfo viewAPM = new ViewAPMInfo(); if (dataReader.IsDBNull(Cod_APM) == false) viewAPM.Cod_APM = dataReader.GetInt32(Cod_APM); if (dataReader.IsDBNull(Cod_Delegacion) == false) viewAPM.Cod_Delegacion = dataReader.GetInt32(Cod_Delegacion); if (dataReader.IsDBNull(Delegacion) == false) viewAPM.Delegacion = dataReader.GetString(Delegacion); if (dataReader.IsDBNull(Cod_Regional) == false) viewAPM.Cod_Regional = dataReader.GetInt32(Cod_Regional); if (dataReader.IsDBNull(Codigo_Completo) == false) viewAPM.Codigo_Completo = dataReader.GetString(Codigo_Completo); if (dataReader.IsDBNull(Numero_APM) == false) viewAPM.Numero_APM = dataReader.GetString(Numero_APM); if (dataReader.IsDBNull(Apellido) == false) viewAPM.Apellido = dataReader.GetString(Apellido); if (dataReader.IsDBNull(Nombre) == false) viewAPM.Nombre = dataReader.GetString(Nombre); if (dataReader.IsDBNull(Fecha_Nacimiento) == false) viewAPM.Fecha_Nacimiento = dataReader.GetDateTime(Fecha_Nacimiento); if (dataReader.IsDBNull(Action) == false) viewAPM.Action = dataReader.GetString(Action); if (dataReader.IsDBNull(Cod_Provincia) == false) viewAPM.Cod_Provincia = dataReader.GetInt32(Cod_Provincia); return viewAPM; }
///<summary></summary> protected override void ReadExecuted(System.Data.SqlClient.SqlDataReader dr) { if (dr != null && !dr.IsClosed) { #region Read Each Field if (!dr.IsDBNull(dr.GetOrdinal("Id"))) { m_Current.Id = dr.GetInt32(dr.GetOrdinal("Id")); } if (!dr.IsDBNull(dr.GetOrdinal("Name"))) { m_Current.Name = dr.GetString(dr.GetOrdinal("Name")); } if (!dr.IsDBNull(dr.GetOrdinal("UrlSlug"))) { m_Current.UrlSlug = dr.GetString(dr.GetOrdinal("UrlSlug")); } if (!dr.IsDBNull(dr.GetOrdinal("Description"))) { m_Current.Description = dr.GetString(dr.GetOrdinal("Description")); } #endregion ExistsInDB = true; Mode = EditMode.None; SetOriginalValues(); } }
protected void lbtnforgetpass_Click(object sender, EventArgs e) { if (txtforgrtid.Text == "") { ScriptManager.RegisterStartupScript(this, this.GetType(), "popup", "alert('Please Enter The User_ID.');", true); return; } else { a = txtforgrtid.Text; } try { dr = cls.FillDataReader("select R_password , R_EmailId from Registerlist where R_logid='" + a + "'"); if (dr.Read()) { if (!dr.IsDBNull(0)) { pass = dr.GetValue(0).ToString(); } if (!dr.IsDBNull(1)) { emal = dr.GetValue(1).ToString(); } } dr.Close(); if (pass == null && emal == null) { ScriptManager.RegisterStartupScript(this, this.GetType(), "popup", "alert('Not a valid User_ID.');", true); txtforgrtid.Text = ""; return; } else { bool var = MailHelper.CheckForInternetConnection(); if (var == true) { MailHelper.SendMailMessage("*****@*****.**", emal, "Password", "Your Password:'******'"); ScriptManager.RegisterStartupScript(this, this.GetType(), "popup", "alert('Password have been sent to your registered email_ID.');", true); txtforgrtid.Text = ""; } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "popup", "alert('Please Check Your Internet Connection.');", true); txtforgrtid.Text = ""; } } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, this.GetType(), "popup", "alert(" + ex + ");", true); } }
public Tarjeta(SqlDataReader reader) { this.codTarjeta = reader.IsDBNull(reader.GetOrdinal("codTarjeta")) ? null : (string)reader["codTarjeta"]; this.fecEmision = reader.IsDBNull(reader.GetOrdinal("fechaEmi")) ? null : (string)reader["fechaEmi"].ToString(); this.fecAnulado = reader.IsDBNull(reader.GetOrdinal("fechaAnu")) ? null : (string)reader["fechaAnu"].ToString(); this.estado = reader.IsDBNull(reader.GetOrdinal("estado")) ? -1 : (int)reader["estado"]; this.cliente = new Cliente(reader); }
/// <summary> /// 数据转类别实体 /// </summary> public static UserCategoryInfo DataToModel(SqlDataReader rdr) { UserCategoryInfo category = new UserCategoryInfo(); if (!rdr.IsDBNull(0)) category.CategoryTypeID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) category.CategoryTypeName = rdr.GetString(1); if (!rdr.IsDBNull(2)) category.CategoryTypePrice = rdr.GetDecimal(2); return category; }
public void PopulateCategory(SqlDataReader _dtr, Category obj) { int columnIndex = 0; columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.ID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_NAME); if (!_dtr.IsDBNull(columnIndex)) { obj.Name = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_DESCRIPTION); if (!_dtr.IsDBNull(columnIndex)) { obj.Description = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_TYPE); if (!_dtr.IsDBNull(columnIndex)) { obj.Type = (TG.ExpressCMS.DataLayer.Enums.RootEnums.CategoryType)_dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_ATTRIBUTES); if (!_dtr.IsDBNull(columnIndex)) { obj.Attributes = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_ISDELETED); if (!_dtr.IsDBNull(columnIndex)) { obj.IsDeleted = _dtr.GetBoolean((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_XSL_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.XslID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_image); if (!_dtr.IsDBNull(columnIndex)) { obj.Image = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_LANGUAGE_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.LanguageID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_HASH); if (!_dtr.IsDBNull(columnIndex)) { obj.Hash = _dtr.GetString((columnIndex)); } }
public EntityBase PopulateEntity(SqlDataReader reader) { Customer customer = new Customer(); if (!reader.IsDBNull(ord_CustomerID)) customer.CustomerID = reader.GetInt32(ord_CustomerID); if (!reader.IsDBNull(ord_FirstName)) customer.FirstName = reader.GetString(ord_FirstName); if (!reader.IsDBNull(ord_LastName)) customer.LastName = reader.GetString(ord_LastName); if (!reader.IsDBNull(ord_Age)) customer.Age = reader.GetInt32(ord_Age); if (!reader.IsDBNull(ord_EmailAddress)) customer.EmailAddress = reader.GetString(ord_EmailAddress); return customer; }
/// <summary> /// Creates a new instance of the TipoEspecialidad class and populates it with data from the specified SqlDataReader. /// </summary> private static TipoEspecialidadInfo MakeTipoEspecialidad(SqlDataReader dataReader) { TipoEspecialidadInfo tipoEspecialidad = new TipoEspecialidadInfo(); if (dataReader.IsDBNull(Cod_TipoEspecialidad) == false) tipoEspecialidad.Cod_TipoEspecialidad = dataReader.GetInt32(Cod_TipoEspecialidad); if (dataReader.IsDBNull(Descripcion) == false) tipoEspecialidad.Descripcion = dataReader.GetString(Descripcion); return tipoEspecialidad; }
/// <summary> /// Creates a new instance of the DelegacionProvincia class and populates it with data from the specified SqlDataReader. /// </summary> private static DelegacionProvinciaInfo MakeDelegacionProvincia(SqlDataReader dataReader) { DelegacionProvinciaInfo delegacionProvincia = new DelegacionProvinciaInfo(); if (dataReader.IsDBNull(Cod_Delegacion) == false) delegacionProvincia.Cod_Delegacion = dataReader.GetInt32(Cod_Delegacion); if (dataReader.IsDBNull(Cod_Provincia) == false) delegacionProvincia.Cod_Provincia = dataReader.GetInt32(Cod_Provincia); if (dataReader.IsDBNull(Cod_APM) == false) delegacionProvincia.Cod_APM = dataReader.GetInt32(Cod_APM); return delegacionProvincia; }
/// <summary> /// Creates a new instance of the ART_SeguridadAcceso class and populates it with data from the specified SqlDataReader. /// </summary> private static ART_SeguridadAccesoInfo MakeART_SeguridadAcceso(SqlDataReader dataReader) { ART_SeguridadAccesoInfo aRT_SeguridadAcceso = new ART_SeguridadAccesoInfo(); if (dataReader.IsDBNull(SeguridadAccesoId) == false) aRT_SeguridadAcceso.SeguridadAccesoId = dataReader.GetInt32(SeguridadAccesoId); if (dataReader.IsDBNull(SeguridadModuloId) == false) aRT_SeguridadAcceso.SeguridadModuloId = dataReader.GetInt32(SeguridadModuloId); if (dataReader.IsDBNull(SeguridadRolId) == false) aRT_SeguridadAcceso.SeguridadRolId = dataReader.GetInt32(SeguridadRolId); return aRT_SeguridadAcceso; }
/// <summary> /// Creates a new instance of the ViewAuditoresLideres class and populates it with data from the specified SqlDataReader. /// </summary> private static ViewAuditoresLideresInfo MakeViewAuditoresLideres(SqlDataReader dataReader) { ViewAuditoresLideresInfo viewAuditoresLideres = new ViewAuditoresLideresInfo(); if (dataReader.IsDBNull(AuditoriaId) == false) viewAuditoresLideres.AuditoriaId = dataReader.GetInt32(AuditoriaId); if (dataReader.IsDBNull(AuditorId) == false) viewAuditoresLideres.AuditorId = dataReader.GetInt32(AuditorId); if (dataReader.IsDBNull(NombreAuditor) == false) viewAuditoresLideres.NombreAuditor = dataReader.GetString(NombreAuditor); return viewAuditoresLideres; }
/// <summary> /// Creates a new instance of the ViewCargosPorLista class and populates it with data from the specified SqlDataReader. /// </summary> private static ViewCargosPorListaInfo MakeViewCargosPorLista(SqlDataReader dataReader) { ViewCargosPorListaInfo viewCargosPorLista = new ViewCargosPorListaInfo(); if (dataReader.IsDBNull(AuditoriaListaVerificacionId) == false) viewCargosPorLista.AuditoriaListaVerificacionId = dataReader.GetInt32(AuditoriaListaVerificacionId); if (dataReader.IsDBNull(CargoId) == false) viewCargosPorLista.CargoId = dataReader.GetInt32(CargoId); if (dataReader.IsDBNull(Descripcion) == false) viewCargosPorLista.Descripcion = dataReader.GetString(Descripcion); return viewCargosPorLista; }
/// <summary> /// Creates a new instance of the ART_SeguridadRol class and populates it with data from the specified SqlDataReader. /// </summary> private static ART_SeguridadRolInfo MakeART_SeguridadRol(SqlDataReader dataReader) { ART_SeguridadRolInfo aRT_SeguridadRol = new ART_SeguridadRolInfo(); if (dataReader.IsDBNull(SeguridadRolId) == false) aRT_SeguridadRol.SeguridadRolId = dataReader.GetInt32(SeguridadRolId); if (dataReader.IsDBNull(DescripcionRol) == false) aRT_SeguridadRol.DescripcionRol = dataReader.GetString(DescripcionRol); if (dataReader.IsDBNull(Activo) == false) aRT_SeguridadRol.Activo = dataReader.GetBoolean(Activo); return aRT_SeguridadRol; }
public IProject Resolve(IProject project, SqlDataReader reader) { project.ProjectId = Convert.ToInt32(reader["projectId"]); project.Name = Convert.ToString(reader["name"]); project.StatusId = Convert.ToInt32(reader["statusId"]); if(!reader.IsDBNull(reader.GetOrdinal("PlannedEndDate"))) project.PlannedEndDate = Convert.ToDateTime(reader["PlannedEndDate"]); if (!reader.IsDBNull(reader.GetOrdinal("ActualEndDate"))) project.ActualEndDate = Convert.ToDateTime(reader["ActualEndDate"]); if (!reader.IsDBNull(reader.GetOrdinal("PlannedStartDate"))) project.PlannedStartDate = Convert.ToDateTime(reader["PlannedStartDate"]); if (!reader.IsDBNull(reader.GetOrdinal("ActualStartDate"))) project.ActualEndDate = Convert.ToDateTime(reader["ActualStartDate"]); project.CompanyId = Convert.ToInt32(reader["companyId"]); return project; }
/// <summary> /// Creates a new instance of the ViewProductoObjetivo class and populates it with data from the specified SqlDataReader. /// </summary> private static ViewProductoObjetivoInfo MakeViewProductoObjetivo(SqlDataReader dataReader) { ViewProductoObjetivoInfo viewProductoObjetivo = new ViewProductoObjetivoInfo(); if (dataReader.IsDBNull(Cod_Producto) == false) viewProductoObjetivo.Cod_Producto = dataReader.GetInt32(Cod_Producto); if (dataReader.IsDBNull(Cod_Trilogia) == false) viewProductoObjetivo.Cod_Trilogia = dataReader.GetInt32(Cod_Trilogia); if (dataReader.IsDBNull(Producto) == false) viewProductoObjetivo.Producto = dataReader.GetString(Producto); if (dataReader.IsDBNull(Cantidad) == false) viewProductoObjetivo.Cantidad = dataReader.GetInt16(Cantidad); return viewProductoObjetivo; }
/// <summary> /// Creates a new instance of the ART_SeguridadOpcion class and populates it with data from the specified SqlDataReader. /// </summary> private static ART_SeguridadOpcionInfo MakeART_SeguridadOpcion(SqlDataReader dataReader) { ART_SeguridadOpcionInfo aRT_SeguridadOpcion = new ART_SeguridadOpcionInfo(); if (dataReader.IsDBNull(SeguridadOpcionId) == false) aRT_SeguridadOpcion.SeguridadOpcionId = dataReader.GetInt32(SeguridadOpcionId); if (dataReader.IsDBNull(CodigoOpcion) == false) aRT_SeguridadOpcion.CodigoOpcion = dataReader.GetString(CodigoOpcion); if (dataReader.IsDBNull(Descripcion) == false) aRT_SeguridadOpcion.Descripcion = dataReader.GetString(Descripcion); if (dataReader.IsDBNull(Activo) == false) aRT_SeguridadOpcion.Activo = dataReader.GetBoolean(Activo); return aRT_SeguridadOpcion; }
/// <summary> /// Creates a new instance of the ART_SeguridadModulo class and populates it with data from the specified SqlDataReader. /// </summary> private static ART_SeguridadModuloInfo MakeART_SeguridadModulo(SqlDataReader dataReader) { ART_SeguridadModuloInfo aRT_SeguridadModulo = new ART_SeguridadModuloInfo(); if (dataReader.IsDBNull(SeguridadModuloId) == false) aRT_SeguridadModulo.SeguridadModuloId = dataReader.GetInt32(SeguridadModuloId); if (dataReader.IsDBNull(DescripcionModulo) == false) aRT_SeguridadModulo.DescripcionModulo = dataReader.GetString(DescripcionModulo); if (dataReader.IsDBNull(NombreFormulario) == false) aRT_SeguridadModulo.NombreFormulario = dataReader.GetString(NombreFormulario); if (dataReader.IsDBNull(Activo) == false) aRT_SeguridadModulo.Activo = dataReader.GetBoolean(Activo); return aRT_SeguridadModulo; }
public List <Product> GetProductList() { List <Product> ProductList = new List <Product>(); Dao dao = new Dao(); string sqlStatement = "SELECT ProductID, ProductName, Price, Quantity, Image, Description, CategoryID FROM Product"; System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement); if (reader == null) { return(null); } while (reader.Read()) { try { int id = reader.GetInt32(0); string name = reader.GetString(1); double price = (double)reader.GetDecimal(2); int quantity = reader.GetInt32(3); string image = reader.GetString(4); string description = reader.IsDBNull(5) ? null : reader.GetString(5); int categoryID = reader.GetInt32(6); ProductList.Add(new Product(id, name, price, quantity, image, description, categoryID)); } catch (Exception) { } } dao.Con.Close(); return(ProductList); }
static Document CreateDocument(SqlDataReader reader, IDictionary<int, List<string>> packageFrameworks) { var package = new Dictionary<string, string>(); for (var i = 0; i < reader.FieldCount; i++) { if (!reader.IsDBNull(i)) { string name = reader.GetName(i); object obj = reader.GetValue(i); if (name == "key") { var key = (int)obj; List<string> targetFrameworks; if (packageFrameworks.TryGetValue(key, out targetFrameworks)) { package.Add("supportedFrameworks", string.Join("|", targetFrameworks)); } } var value = (obj is DateTime) ? ((DateTime)obj).ToUniversalTime().ToString("O") : obj.ToString(); package.Add(name, value); } } return DocumentCreator.CreateDocument(package); }
/** Descripcion: * * REQ: SqlDataReader,int * * RET: static int */ public static int SafeGetInt32(SqlDataReader reader, int colIndex) { if (!reader.IsDBNull(colIndex)) return reader.GetInt32(colIndex); else return -1; }
protected override Exception ProcessSqlResult(SqlDataReader reader) { Exception nextResultSet = StoreUtilities.GetNextResultSet(base.InstancePersistenceCommand.Name, reader); if (nextResultSet == null) { bool flag = !reader.IsDBNull(1); TimeSpan? taskIntervalOverride = null; bool flag2 = false; if (flag) { DateTime dateTime = reader.GetDateTime(1); DateTime time2 = reader.GetDateTime(2); if (dateTime <= time2) { flag2 = true; } else { taskIntervalOverride = new TimeSpan?(dateTime.Subtract(time2)); } } if (flag2) { base.Store.UpdateEventStatus(true, InstancePersistenceEvent<HasRunnableWorkflowEvent>.Value); return nextResultSet; } base.Store.UpdateEventStatus(false, InstancePersistenceEvent<HasRunnableWorkflowEvent>.Value); base.StoreLock.InstanceDetectionTask.ResetTimer(false, taskIntervalOverride); } return nextResultSet; }
/// <summary> /// Creates a new instance of the ViewAuditoriaResultado class and populates it with data from the specified SqlDataReader. /// </summary> private static ViewAuditoriaResultadoInfo MakeViewAuditoriaResultado(SqlDataReader dataReader) { ViewAuditoriaResultadoInfo viewAuditoriaResultado = new ViewAuditoriaResultadoInfo(); if (dataReader.IsDBNull(AuditoriaResultadoId) == false) viewAuditoriaResultado.AuditoriaResultadoId = dataReader.GetInt32(AuditoriaResultadoId); if (dataReader.IsDBNull(AuditoriaId) == false) viewAuditoriaResultado.AuditoriaId = dataReader.GetInt32(AuditoriaId); if (dataReader.IsDBNull(AuditoriaPuntoId) == false) viewAuditoriaResultado.AuditoriaPuntoId = dataReader.GetInt32(AuditoriaPuntoId); if (dataReader.IsDBNull(AuditoriaControlId) == false) viewAuditoriaResultado.AuditoriaControlId = dataReader.GetInt32(AuditoriaControlId); if (dataReader.IsDBNull(PuntajeRequerido) == false) viewAuditoriaResultado.PuntajeRequerido = dataReader.GetDecimal(PuntajeRequerido); if (dataReader.IsDBNull(PuntajeObtenido) == false) viewAuditoriaResultado.PuntajeObtenido = dataReader.GetDecimal(PuntajeObtenido); if (dataReader.IsDBNull(ResultadoPunto) == false) viewAuditoriaResultado.ResultadoPunto = dataReader.GetDecimal(ResultadoPunto); if (dataReader.IsDBNull(Control) == false) viewAuditoriaResultado.Control = dataReader.GetString(Control); if (dataReader.IsDBNull(Punto) == false) viewAuditoriaResultado.Punto = dataReader.GetString(Punto); if (dataReader.IsDBNull(EsNoConformidad) == false) viewAuditoriaResultado.EsNoConformidad = dataReader.GetBoolean(EsNoConformidad); if (dataReader.IsDBNull(AuditoriaCausaRaizId) == false) viewAuditoriaResultado.AuditoriaCausaRaizId = dataReader.GetInt32(AuditoriaCausaRaizId); if (dataReader.IsDBNull(CausaRaiz) == false) viewAuditoriaResultado.CausaRaiz = dataReader.GetString(CausaRaiz); if (dataReader.IsDBNull(CargoId) == false) viewAuditoriaResultado.CargoId = dataReader.GetInt32(CargoId); if (dataReader.IsDBNull(PuntajeCargo) == false) viewAuditoriaResultado.PuntajeCargo = dataReader.GetDecimal(PuntajeCargo); return viewAuditoriaResultado; }
/** * Descripción: Obtiene el campo fecha de la tabla de forma segura (revisando si es null o no antes de leerlo) * Recibe un SqlDataReader con el que se obtiene el campo y el índice de la columna a consultar * Devuelve un valor DateTime dependiendo del resultado de la consulta. La fecha actual si el campo está nulo */ public static DateTime SafeGetDate(SqlDataReader reader, int colIndex) { if (!reader.IsDBNull(colIndex)) return reader.GetDateTime(colIndex); else return DateTime.Now; }
private Value GetValue(SqlDataReader reader, int column) { Value value = new Value(); value.Item = reader.GetValue(column); Type type = value.Item.GetType(); if (reader.IsDBNull(column)) { value.Type = ColumnType.Null; } else if(typeof(bool).IsAssignableFrom(type)) { value.Type = ColumnType.Boolean; } else if(typeof(int).IsAssignableFrom(type)) { value.Type = ColumnType.Integer; } else if (typeof(float).IsAssignableFrom(type) || typeof(double).IsAssignableFrom(type)) { value.Type = ColumnType.Double; } else if (typeof(byte[]).IsAssignableFrom(type)) { value.Type = ColumnType.Blob; } else { value.Type = ColumnType.String; } return value; }
private void btnLogin_Click(object sender, EventArgs e) { db_command.CommandText = "SELECT [id_user], [id_post], [id_point], [guid], [name], [сontact], [login], [password], [permission], [postname], [pointname] FROM [vwUserFull] WHERE [login] = '" + txtLogin.Text + "' AND [password] = '" + txtPassword.Text + "'"; db_reader = db_command.ExecuteReader(); if (db_reader.Read()) { this.FormOK = true; this.DialogResult = DialogResult.OK; usr = new UserInfo(); if (!db_reader.IsDBNull(0)) usr.Id_user = Convert.ToInt32(db_reader[0]); if (!db_reader.IsDBNull(1)) usr.Id_point = Convert.ToInt32(db_reader[1]); if (!db_reader.IsDBNull(2)) usr.Id_post = Convert.ToInt32(db_reader[2]); if (!db_reader.IsDBNull(3)) usr.Guid = Convert.ToString(db_reader[3]); if (!db_reader.IsDBNull(4)) usr.Name = Convert.ToString(db_reader[4]); if (!db_reader.IsDBNull(5)) usr.Contact = Convert.ToString(db_reader[5]); if (!db_reader.IsDBNull(6)) usr.Login = Convert.ToString(db_reader[6]); if (!db_reader.IsDBNull(7)) usr.Password = Convert.ToString(db_reader[7]); if (!db_reader.IsDBNull(8)) usr.Permission = Convert.ToInt64(db_reader[8]); if (!db_reader.IsDBNull(9)) usr.Post = Convert.ToString(db_reader[9]); if (!db_reader.IsDBNull(10)) usr.Point = Convert.ToString(db_reader[10]); if (!usr.prmCanLogin) { this.FormOK = false; this.DialogResult = DialogResult.Retry; MessageBox.Show("Доступ в программу запрещен!", "Вход в программу", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { this.FormOK = false; this.DialogResult = DialogResult.Retry; MessageBox.Show("Неверный пароль!", "Вход в программу", MessageBoxButtons.OK, MessageBoxIcon.Error); } db_reader.Close(); }
public TList_Empreendimento Select(TpBusca[] vBusca, Int32 vTop, string vNM_Campo) { bool podeFecharBco = false; TList_Empreendimento lista = new TList_Empreendimento(); if (Banco_Dados == null) { this.CriarBanco_Dados(false); podeFecharBco = true; } System.Data.SqlClient.SqlDataReader reader = this.ExecutarBusca(this.SqlCodeBusca(vBusca, vTop, vNM_Campo)); try { while (reader.Read()) { TRegistro_Empreendimento reg = new TRegistro_Empreendimento(); if (!(reader.IsDBNull(reader.GetOrdinal("ID_Empreendimento")))) { reg.Id_empreendimento = reader.GetDecimal(reader.GetOrdinal("ID_Empreendimento")); } if (!(reader.IsDBNull(reader.GetOrdinal("CD_Empresa")))) { reg.Cd_empresa = reader.GetString(reader.GetOrdinal("CD_Empresa")); } if (!(reader.IsDBNull(reader.GetOrdinal("NM_Empresa")))) { reg.Nm_empresa = reader.GetString(reader.GetOrdinal("NM_Empresa")); } if (!reader.IsDBNull(reader.GetOrdinal("DS_Empreendimento"))) { reg.Ds_empreendimento = reader.GetString(reader.GetOrdinal("DS_Empreendimento")); } if (!reader.IsDBNull(reader.GetOrdinal("DS_Observacao"))) { reg.Ds_observacao = reader.GetString(reader.GetOrdinal("DS_Observacao")); } if (!reader.IsDBNull(reader.GetOrdinal("DT_IniEmpreendimento"))) { reg.Dt_iniempreendimento = reader.GetDateTime(reader.GetOrdinal("DT_IniEmpreendimento")); } if (!(reader.IsDBNull(reader.GetOrdinal("ST_Registro")))) { reg.St_registro = reader.GetString(reader.GetOrdinal("ST_Registro")); } lista.Add(reg); } } finally { reader.Close(); reader.Dispose(); if (podeFecharBco) { this.deletarBanco_Dados(); } } return(lista); }
} //gets string or null when pulling records public int GetInt32OrZero(System.Data.SqlClient.SqlDataReader r, int i) { int rv = 0; if (!r.IsDBNull(i)) { rv = r.GetInt32(i); } return(rv); } //gets int or defaults value to '0'
///<summary></summary> protected override void ReadExecuted(System.Data.SqlClient.SqlDataReader dr) { if (dr != null && !dr.IsClosed) { #region Read Each Field if (!dr.IsDBNull(dr.GetOrdinal("Code"))) { m_Current.Code = dr.GetString(dr.GetOrdinal("Code")); } if (!dr.IsDBNull(dr.GetOrdinal("Value"))) { m_Current.Value = dr.GetString(dr.GetOrdinal("Value")); } #endregion ExistsInDB = true; Mode = EditMode.None; SetOriginalValues(); } }
} //gets int or defaults value to '0' public DateTime GetDateTimeOrMinValue(System.Data.SqlClient.SqlDataReader r, int i) { DateTime rv = DateTime.MinValue; if (!r.IsDBNull(i)) { rv = r.GetDateTime(i); } return(rv); } //gets the date or sets the minimum value
public bool GetBoolean(System.Data.SqlClient.SqlDataReader r, int i) { bool rv = true; if (!r.IsDBNull(i)) { rv = r.GetBoolean(i); } return(rv); }
public int GetInt32OrZero(System.Data.SqlClient.SqlDataReader r, int i) { int rv = 0; if (!r.IsDBNull(i)) { rv = r.GetInt32(i); } return(rv); }
public string GetStringOrNull(System.Data.SqlClient.SqlDataReader r, int i) { string rv = null; if (!r.IsDBNull(i)) { rv = r.GetString(i); } return(rv); } //gets string or null when pulling records
public TList_LanServico_X_Duplicata Select(Utils.TpBusca[] vBusca, Int32 vTop, string vNM_Campo) { bool podeFecharBco = false; TList_LanServico_X_Duplicata lista = new TList_LanServico_X_Duplicata(); if (Banco_Dados == null) { podeFecharBco = this.CriarBanco_Dados(false); } System.Data.SqlClient.SqlDataReader reader = this.ExecutarBusca(this.SqlCodeBusca(vBusca, vTop, vNM_Campo)); try { while (reader.Read()) { TRegistro_LanServico_X_Duplicata reg = new TRegistro_LanServico_X_Duplicata(); if (!reader.IsDBNull(reader.GetOrdinal("id_os"))) { reg.Id_os = reader.GetDecimal(reader.GetOrdinal("id_os")); } if (!reader.IsDBNull(reader.GetOrdinal("cd_empresa"))) { reg.Cd_empresa = reader.GetString(reader.GetOrdinal("cd_empresa")); } if (!reader.IsDBNull(reader.GetOrdinal("nr_lancto"))) { reg.Nr_lancto = reader.GetDecimal(reader.GetOrdinal("nr_lancto")); } lista.Add(reg); } } finally { reader.Close(); reader.Dispose(); if (podeFecharBco) { this.deletarBanco_Dados(); } } return(lista); }
public List <Persona> GetAllDocentes() { List <Persona> listadoPersonas = new List <Persona>(); try { this.OpenConnection(); SqlCommand consulta = new SqlCommand("SELECT id_persona,nombre,apellido,direccion,email,telefono,fecha_nac FROM personas WHERE tipo_persona = 2 ", SqlConn); System.Data.SqlClient.SqlDataReader dr = consulta.ExecuteReader(); while (dr.Read()) { Persona per = new Persona(); per.ID = Convert.ToInt32(dr[0]); per.Nombre = dr.IsDBNull(1) ? string.Empty : dr[1].ToString(); per.Apellido = dr.IsDBNull(2) ? string.Empty : dr[2].ToString(); per.Direccion = dr.IsDBNull(3) ? string.Empty : dr[3].ToString(); per.Email = dr.IsDBNull(4) ? string.Empty : dr[4].ToString(); per.Telefono = dr.IsDBNull(5) ? string.Empty : dr[5].ToString(); per.FechaNacimiento = Convert.ToDateTime(dr[6]); //per.Legajo = dr.IsDBNull(3) ? string.Empty : dr[3].ToString(); //per.Id_Tipo_Persona = dr.IsDBNull(8) ? 0 : Convert.ToInt32(dr[8]); //per.Plan = dr.IsDBNull(9) ? null : PlanAdapter.GetOne(Convert.ToInt32(dr[9])); listadoPersonas.Add(per); } return(listadoPersonas); } catch (Exception e) { Exception ExcepcionManejada = new Exception("Error al tratar de abrir la conexion", e); throw ExcepcionManejada; } finally { this.CloseConnection(); } }
///<summary></summary> protected override void ReadExecuted(System.Data.SqlClient.SqlDataReader dr) { if (dr != null && !dr.IsClosed) { #region Read Each Field if (!dr.IsDBNull(dr.GetOrdinal("ImageId"))) { m_Current.ImageId = dr.GetInt32(dr.GetOrdinal("ImageId")); } if (!dr.IsDBNull(dr.GetOrdinal("FileName"))) { m_Current.FileName = dr.GetString(dr.GetOrdinal("FileName")); } if (!dr.IsDBNull(dr.GetOrdinal("Extension"))) { m_Current.Extension = dr.GetString(dr.GetOrdinal("Extension")); } if (!dr.IsDBNull(dr.GetOrdinal("ProjectFileDirectory"))) { m_Current.ProjectFileDirectory = dr.GetString(dr.GetOrdinal("ProjectFileDirectory")); } if (!dr.IsDBNull(dr.GetOrdinal("Description"))) { m_Current.Description = dr.GetString(dr.GetOrdinal("Description")); } if (!dr.IsDBNull(dr.GetOrdinal("Enabled"))) { m_Current.Enabled = dr.GetBoolean(dr.GetOrdinal("Enabled")); } #endregion ExistsInDB = true; Mode = EditMode.None; SetOriginalValues(); } }
public TList_Empreendimento_X_LanCCusto Select(TpBusca[] vBusca, Int32 vTop, string vNM_Campo) { bool podeFecharBco = false; TList_Empreendimento_X_LanCCusto lista = new TList_Empreendimento_X_LanCCusto(); if (Banco_Dados == null) { this.CriarBanco_Dados(false); podeFecharBco = true; } System.Data.SqlClient.SqlDataReader reader = this.ExecutarBusca(this.SqlCodeBusca(vBusca, vTop, vNM_Campo)); try { while (reader.Read()) { TRegistro_Empreendimento_X_lanCCusto reg = new TRegistro_Empreendimento_X_lanCCusto(); if (!(reader.IsDBNull(reader.GetOrdinal("ID_Empreendimento")))) { reg.Id_empreendimento = reader.GetDecimal(reader.GetOrdinal("ID_Empreendimento")); } if (!(reader.IsDBNull(reader.GetOrdinal("ID_CCustoLan")))) { reg.Id_ccustolan = reader.GetDecimal(reader.GetOrdinal("ID_CCustoLan")); } lista.Add(reg); } } finally { reader.Close(); reader.Dispose(); if (podeFecharBco) { this.deletarBanco_Dados(); } } return(lista); }
public static void setFieldValue(ref object Variable, string Field, System.Data.SqlClient.SqlDataReader Reader) { if (!Reader.IsDBNull(Reader.GetOrdinal(Field))) { Variable = Reader.GetValue(Reader.GetOrdinal(Field)); if (Variable.GetType().Name == "String") { Variable = Variable.ToString().Trim(); } if (Variable.GetType().Name == "DateTime") { Variable = Variable.ToString(); } } else { if ((Variable != null)) { switch (Variable.GetType().Name) { case "Short": Variable = 0; break; case "Double": Variable = 0; break; case "Int64": Variable = 0; break; case "Boolean": Variable = false; break; case "String": Variable = ""; break; case "DateTime": Variable = new System.DateTime(1, 1, 1); break; } } else { Variable = ""; } } }
private void CreatePLMParameterModes(int plmId, int userId, System.Data.SqlClient.SqlCommand command) { List <BusinessLogic.Json.PlmParameterModeInfo> modes = new List <BusinessLogic.Json.PlmParameterModeInfo>(); string sql = "SELECT Id, DefaultHostSpeedId, DefaultPowerId FROM PLMParameterModeType WHERE (Id NOT IN (SELECT Id FROM PLMParameterMode WHERE (PLMId = " + plmId + ")))"; command.CommandText = sql; System.Data.SqlClient.SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { BusinessLogic.Json.PlmParameterModeInfo mode = new Durados.Web.Mvc.Specifics.SanDisk.Allegro.BusinessLogic.Json.PlmParameterModeInfo(); mode.Id = reader.GetInt32(reader.GetOrdinal("Id")); if (!reader.IsDBNull(reader.GetOrdinal("DefaultHostSpeedId"))) { mode.DefaultHostSpeedId = reader.GetInt32(reader.GetOrdinal("DefaultHostSpeedId")); } if (!reader.IsDBNull(reader.GetOrdinal("DefaultPowerId"))) { mode.DefaultPowerId = reader.GetInt32(reader.GetOrdinal("DefaultPowerId")); } modes.Add(mode); } reader.Close(); foreach (BusinessLogic.Json.PlmParameterModeInfo mode in modes) { sql = "insert into PLMParameterMode (PLMId, PLMParameterModeTypeId" + (mode.DefaultHostSpeedId.HasValue ? ",HostSpeedId" : "") + (mode.DefaultPowerId.HasValue ? ",PowerId" : "") + ") values (" + plmId + "," + mode.Id + (mode.DefaultHostSpeedId.HasValue ? "," + mode.DefaultHostSpeedId.Value : "") + (mode.DefaultPowerId.HasValue ? "," + mode.DefaultPowerId.Value : "") + "); SELECT IDENT_CURRENT('[PLMParameterMode]') AS ID"; command.CommandText = sql; int id = Convert.ToInt32(command.ExecuteScalar()); sql = "insert into durados_ChangeHistory (ViewName, PK, ActionId, UpdateUserId) values ('PLMParameterMode', '" + id + "', 1, " + userId + ")"; command.CommandText = sql; command.ExecuteNonQuery(); } }
///<summary></summary> protected override void ReadExecuted(System.Data.SqlClient.SqlDataReader dr) { if (dr != null && !dr.IsClosed) { #region Read Each Field if (!dr.IsDBNull(dr.GetOrdinal("Id"))) { m_Current.Id = dr.GetInt32(dr.GetOrdinal("Id")); } if (!dr.IsDBNull(dr.GetOrdinal("UserHostAddress"))) { m_Current.UserHostAddress = dr.GetString(dr.GetOrdinal("UserHostAddress")); } if (!dr.IsDBNull(dr.GetOrdinal("Browser"))) { m_Current.Browser = dr.GetString(dr.GetOrdinal("Browser")); } if (!dr.IsDBNull(dr.GetOrdinal("BrowserVersion"))) { m_Current.BrowserVersion = dr.GetString(dr.GetOrdinal("BrowserVersion")); } if (!dr.IsDBNull(dr.GetOrdinal("Url"))) { m_Current.Url = dr.GetString(dr.GetOrdinal("Url")); } if (!dr.IsDBNull(dr.GetOrdinal("UserAgent"))) { m_Current.UserAgent = dr.GetString(dr.GetOrdinal("UserAgent")); } if (!dr.IsDBNull(dr.GetOrdinal("AccessTime"))) { m_Current.AccessTime = dr.GetDateTime(dr.GetOrdinal("AccessTime")); } #endregion ExistsInDB = true; Mode = EditMode.None; SetOriginalValues(); } }
/// <summary> /// Populate a <see cref="QueryResult"/> with result-sets from the specified <see cref="SqlClient.SqlDataReader"/>. /// </summary> /// <param name="reader"> /// The <see cref="SqlClient.SqlDataReader"/> to read from. /// </param> /// <param name="queryResult"> /// The <see cref="QueryResult"/> to populate. /// </param> /// <returns> /// A <see cref="Task"/> representing the operation. /// </returns> async Task ReadResults(SqlClient.SqlDataReader reader, QueryResult queryResult) { if (reader == null) { throw new ArgumentNullException(nameof(reader)); } if (queryResult == null) { throw new ArgumentNullException(nameof(queryResult)); } ResultSet resultSet = new ResultSet(); queryResult.ResultSets.Add(resultSet); while (await reader.ReadAsync()) { var row = new ResultRow(); resultSet.Rows.Add(row); for (int fieldIndex = 0; fieldIndex < reader.FieldCount; fieldIndex++) { string fieldName = reader.GetName(fieldIndex); if (!reader.IsDBNull(fieldIndex)) { row.Columns[fieldName] = new JValue( reader.GetValue(fieldIndex) ); } else { row.Columns[fieldName] = null; } } } }
public TList_Plantio_X_Talhoes Select(Utils.TpBusca[] vBusca, Int32 vTop, string vNm_Campo) { TList_Plantio_X_Talhoes lista = new TList_Plantio_X_Talhoes(); System.Data.SqlClient.SqlDataReader reader = null; bool podeFecharBco = false; if (Banco_Dados == null) { podeFecharBco = this.CriarBanco_Dados(false); } try { reader = this.ExecutarBusca(this.SqlCodeBusca(vBusca, Convert.ToInt16(vTop), vNm_Campo)); while (reader.Read()) { TRegistro_Plantio_X_Talhoes reg = new TRegistro_Plantio_X_Talhoes(); if (!reader.IsDBNull(reader.GetOrdinal("Id_Plantio"))) { reg.Id_plantio = reader.GetDecimal(reader.GetOrdinal("Id_Plantio")); } if (!reader.IsDBNull(reader.GetOrdinal("ID_Talhao"))) { reg.Id_talhao = reader.GetDecimal(reader.GetOrdinal("ID_Talhao")); } if (!reader.IsDBNull(reader.GetOrdinal("DS_Talhao"))) { reg.Ds_talhao = reader.GetString(reader.GetOrdinal("DS_Talhao")); } if (!reader.IsDBNull(reader.GetOrdinal("area_talhao"))) { reg.Area_talhao = reader.GetDecimal(reader.GetOrdinal("area_talhao")); } if (!reader.IsDBNull(reader.GetOrdinal("ID_Area"))) { reg.Id_area = reader.GetDecimal(reader.GetOrdinal("ID_Area")); } if (!reader.IsDBNull(reader.GetOrdinal("DS_Area"))) { reg.Ds_area = reader.GetString(reader.GetOrdinal("DS_Area")); } if (!reader.IsDBNull(reader.GetOrdinal("CD_Fazenda"))) { reg.Cd_fazenda = reader.GetString(reader.GetOrdinal("CD_Fazenda")); } if (!reader.IsDBNull(reader.GetOrdinal("NM_Fazenda"))) { reg.Nm_fazenda = reader.GetString(reader.GetOrdinal("NM_Fazenda")); } if (!reader.IsDBNull(reader.GetOrdinal("sigla_unidade"))) { reg.Sigla_unidade = reader.GetString(reader.GetOrdinal("sigla_unidade")); } if (!reader.IsDBNull(reader.GetOrdinal("Area_Plantada"))) { reg.Area_plantada = reader.GetDecimal(reader.GetOrdinal("Area_Plantada")); } if (!reader.IsDBNull(reader.GetOrdinal("producao_prevista"))) { reg.Producao_prevista = reader.GetDecimal(reader.GetOrdinal("producao_prevista")); } lista.Add(reg); } } finally { reader.Close(); reader.Dispose(); if (podeFecharBco) { this.deletarBanco_Dados(); } } return(lista); }
///<summary></summary> protected override void ReadExecuted(System.Data.SqlClient.SqlDataReader dr) { if (dr != null && !dr.IsClosed) { #region Read Each Field if (!dr.IsDBNull(dr.GetOrdinal("Id"))) { m_Current.Id = dr.GetInt32(dr.GetOrdinal("Id")); } if (!dr.IsDBNull(dr.GetOrdinal("Title"))) { m_Current.Title = dr.GetString(dr.GetOrdinal("Title")); } if (!dr.IsDBNull(dr.GetOrdinal("Body"))) { m_Current.Body = dr.GetString(dr.GetOrdinal("Body")); } if (!dr.IsDBNull(dr.GetOrdinal("ShortDesc"))) { m_Current.ShortDesc = dr.GetString(dr.GetOrdinal("ShortDesc")); } if (!dr.IsDBNull(dr.GetOrdinal("Description"))) { m_Current.Description = dr.GetString(dr.GetOrdinal("Description")); } if (!dr.IsDBNull(dr.GetOrdinal("Meta"))) { m_Current.Meta = dr.GetString(dr.GetOrdinal("Meta")); } if (!dr.IsDBNull(dr.GetOrdinal("UrlSlug"))) { m_Current.UrlSlug = dr.GetString(dr.GetOrdinal("UrlSlug")); } if (!dr.IsDBNull(dr.GetOrdinal("Published"))) { m_Current.Published = dr.GetBoolean(dr.GetOrdinal("Published")); } if (!dr.IsDBNull(dr.GetOrdinal("PostedOn"))) { m_Current.PostedOn = dr.GetDateTime(dr.GetOrdinal("PostedOn")); } if (!dr.IsDBNull(dr.GetOrdinal("Modified"))) { m_Current.Modified = dr.GetDateTime(dr.GetOrdinal("Modified")); } if (!dr.IsDBNull(dr.GetOrdinal("Category"))) { m_Current.Category = dr.GetString(dr.GetOrdinal("Category")); } if (!dr.IsDBNull(dr.GetOrdinal("Enabled"))) { m_Current.Enabled = dr.GetBoolean(dr.GetOrdinal("Enabled")); } #endregion ExistsInDB = true; Mode = EditMode.None; SetOriginalValues(); } }
private int ReadBytes(byte[] buffer, int offset, int count) { bool gotData = true; int intCount = 0; int cb = 0; if (_reader.IsClosed || _endOfColumn) { return(0); } try { while (count > 0) { // if I haven't read any bytes, get the next row if (_advanceReader && (0 == _bytesCol)) { gotData = false; if (_readFirstRow && !_processAllRows) { // for XML column, stop processing after the first row // no op here - reader is closed after the end of this loop } else if (AdvanceToNextRow(_reader)) { _readFirstRow = true; if (_reader.IsDBNull(_columnOrdinal)) { // VSTFDEVDIV 479659: handle row with DBNULL as empty data // for XML column, processing is stopped on the next loop since _readFirstRow is true continue; } // the value is not null, read it gotData = true; } // else AdvanceToNextRow has returned false - no more rows or result sets remained, stop processing } if (gotData) { cb = (int)_reader.GetBytesInternal(_columnOrdinal, _bytesCol, buffer, offset, count); if (cb < count) { _bytesCol = 0; gotData = false; if (!_advanceReader) { _endOfColumn = true; } } else { Debug.Assert(cb == count); _bytesCol += cb; } // we are guaranteed that cb is < Int32.Max since we always pass in count which is of type Int32 to // our getbytes interface count -= (int)cb; offset += (int)cb; intCount += (int)cb; } else { break; // no more data available, we are done } } if (!gotData && _advanceReader) { _reader.Close(); // Need to close the reader if we are done reading } } catch (Exception e) { if (_advanceReader && ADP.IsCatchableExceptionType(e)) { _reader.Close(); } throw; } return(intCount); }
/// <summary> /// [To be supplied.] /// </summary> /// <returns>[To be supplied.]</returns> public bool Refresh() { this.displayName = null; this.col_TitleWasUpdated = false; this.col_TitleWasSet = false; this.col_Title = System.Data.SqlTypes.SqlString.Null; bool alreadyOpened = false; Params.spS_Title Param = new Params.spS_Title(true); Param.CommandTimeOut = this.selectCommandTimeOut; switch (this.lastKnownConnectionType) { case Bob.DataClasses.ConnectionType.ConnectionString: Param.SetUpConnection(this.connectionString); break; case Bob.DataClasses.ConnectionType.SqlConnection: Param.SetUpConnection(this.sqlConnection); alreadyOpened = (this.sqlConnection.State == System.Data.ConnectionState.Open); break; case Bob.DataClasses.ConnectionType.SqlTransaction: Param.SetUpConnection(this.sqlTransaction); break; } if (!this.col_TitleId.IsNull) { Param.Param_TitleId = this.col_TitleId; } System.Data.SqlClient.SqlDataReader sqlDataReader = null; SPs.spS_Title Sp = new SPs.spS_Title(false); if (Sp.Execute(ref Param, out sqlDataReader)) { if (sqlDataReader.Read()) { if (!sqlDataReader.IsDBNull(SPs.spS_Title.Resultset1.Fields.Column_Title.ColumnIndex)) { this.col_Title = sqlDataReader.GetSqlString(SPs.spS_Title.Resultset1.Fields.Column_Title.ColumnIndex); } if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); this.recordIsLoaded = true; return(true); } else { if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); this.recordIsLoaded = false; return(false); } } else { if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); throw new Bob.DataClasses.CustomException(Param, "Bob.BusinessComponents.Title", "Refresh"); } }
public TList_Plantio Select(Utils.TpBusca[] vBusca, Int32 vTop, string vNm_Campo) { TList_Plantio lista = new TList_Plantio(); System.Data.SqlClient.SqlDataReader reader = null; bool podeFecharBco = false; if (Banco_Dados == null) { podeFecharBco = this.CriarBanco_Dados(false); } try { reader = this.ExecutarBusca(this.SqlCodeBusca(vBusca, Convert.ToInt16(vTop), vNm_Campo)); while (reader.Read()) { TRegistro_Plantio reg = new TRegistro_Plantio(); if (!reader.IsDBNull(reader.GetOrdinal("Id_Plantio"))) { reg.Id_plantio = reader.GetDecimal(reader.GetOrdinal("Id_Plantio")); } if (!reader.IsDBNull(reader.GetOrdinal("id_cultura"))) { reg.Id_cultura = reader.GetDecimal(reader.GetOrdinal("id_cultura")); } if (!reader.IsDBNull(reader.GetOrdinal("ds_cultura"))) { reg.Ds_cultura = reader.GetString(reader.GetOrdinal("ds_cultura")); } if (!reader.IsDBNull(reader.GetOrdinal("sigla_unidade"))) { reg.Sigla_unidade = reader.GetString(reader.GetOrdinal("sigla_unidade")); } if (!reader.IsDBNull(reader.GetOrdinal("cd_produto"))) { reg.Cd_produto = reader.GetString(reader.GetOrdinal("cd_produto")); } if (!reader.IsDBNull(reader.GetOrdinal("ds_produto"))) { reg.Ds_produto = reader.GetString(reader.GetOrdinal("ds_produto")); } if (!reader.IsDBNull(reader.GetOrdinal("DS_Observacao"))) { reg.Ds_observacao = reader.GetString(reader.GetOrdinal("DS_Observacao")); } if (!reader.IsDBNull(reader.GetOrdinal("AnoSafra"))) { reg.Anosafra = reader.GetString(reader.GetOrdinal("AnoSafra")); } if (!reader.IsDBNull(reader.GetOrdinal("DS_Safra"))) { reg.Ds_safra = reader.GetString(reader.GetOrdinal("DS_Safra")); } if (!reader.IsDBNull(reader.GetOrdinal("DT_IniPlantio"))) { reg.Dt_iniplantio = reader.GetDateTime(reader.GetOrdinal("DT_IniPlantio")); } if (!reader.IsDBNull(reader.GetOrdinal("DT_FinPlantio"))) { reg.Dt_finplantio = reader.GetDateTime(reader.GetOrdinal("DT_FinPlantio")); } if (!reader.IsDBNull(reader.GetOrdinal("QT_SementesPorMetro"))) { reg.Qt_sementespormetro = reader.GetDecimal(reader.GetOrdinal("QT_SementesPorMetro")); } if (!reader.IsDBNull(reader.GetOrdinal("EspacoSemente"))) { reg.Espacosemente = reader.GetDecimal(reader.GetOrdinal("EspacoSemente")); } lista.Add(reg); } } finally { reader.Close(); reader.Dispose(); if (podeFecharBco) { this.deletarBanco_Dados(); } } return(lista); }
void FillBirthAndDeathDates() { if (Persons.Count == 0) { // Nothing to do here. return; } // Craft query for all the persons. // using (var connection = new QC.SqlConnection(GetConnectionString(HomeController.DefaultProviderName))) { connection.Open(); using (var command = new QC.SqlCommand()) { command.Connection = connection; command.CommandType = DT.CommandType.Text; // This shouldn't be done like this. command.CommandText = "SELECT name, birth_date, death_date FROM persons WHERE name IN (" + string.Join(", ", Persons.Keys.Select(p => "'" + p.Replace("'", "''") + "'").ToArray()) + ")"; QC.SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Person person = Persons[reader.GetString(0)]; string birthDateStringRaw = null; string deathDateStringRaw = null; if (!reader.IsDBNull(1)) { birthDateStringRaw = reader.GetString(1); } if (!reader.IsDBNull(2)) { deathDateStringRaw = reader.GetString(2); } // TODO: Need better logic for handling BC dates. Action <string, Action <DateTime> > fillDate = (inputRaw, setter) => { if (inputRaw != null) { DateTime dt; // Try to extract something useful from date strings. if (DateTime.TryParse(inputRaw, out dt) || DateTime.TryParse(inputRaw.Replace("\"", ""), out dt)) { setter(dt); } else { int year; if (Int32.TryParse(inputRaw.Replace("\"", ""), out year)) { dt = new DateTime(year, 1, 1); setter(dt); } } } }; fillDate(birthDateStringRaw, (dt) => person.BirthDate = dt); fillDate(deathDateStringRaw, (dt) => person.DeathDate = dt); } } } }
/// <summary> /// [To be supplied.] /// </summary> /// <returns>[To be supplied.]</returns> public bool Refresh() { this.displayName = null; this.col_JobIdWasUpdated = false; this.col_JobIdWasSet = false; this.col_JobId = System.Data.SqlTypes.SqlInt32.Null; this.col_DescriptionWasUpdated = false; this.col_DescriptionWasSet = false; this.col_Description = System.Data.SqlTypes.SqlString.Null; this.col_JobPartTypeIdWasUpdated = false; this.col_JobPartTypeIdWasSet = false; this.col_JobPartTypeId = System.Data.SqlTypes.SqlInt32.Null; this.col_UnitsWasUpdated = false; this.col_UnitsWasSet = false; this.col_Units = System.Data.SqlTypes.SqlDecimal.Null; this.col_PricePerUnitWasUpdated = false; this.col_PricePerUnitWasSet = false; this.col_PricePerUnit = System.Data.SqlTypes.SqlMoney.Null; this.col_TotalPriceWasUpdated = false; this.col_TotalPriceWasSet = false; this.col_TotalPrice = System.Data.SqlTypes.SqlMoney.Null; bool alreadyOpened = false; Params.spS_JobPart Param = new Params.spS_JobPart(true); Param.CommandTimeOut = this.selectCommandTimeOut; switch (this.lastKnownConnectionType) { case Bob.DataClasses.ConnectionType.ConnectionString: Param.SetUpConnection(this.connectionString); break; case Bob.DataClasses.ConnectionType.SqlConnection: Param.SetUpConnection(this.sqlConnection); alreadyOpened = (this.sqlConnection.State == System.Data.ConnectionState.Open); break; case Bob.DataClasses.ConnectionType.SqlTransaction: Param.SetUpConnection(this.sqlTransaction); break; } if (!this.col_JobPartId.IsNull) { Param.Param_JobPartId = this.col_JobPartId; } System.Data.SqlClient.SqlDataReader sqlDataReader = null; SPs.spS_JobPart Sp = new SPs.spS_JobPart(false); if (Sp.Execute(ref Param, out sqlDataReader)) { if (sqlDataReader.Read()) { if (!sqlDataReader.IsDBNull(SPs.spS_JobPart.Resultset1.Fields.Column_JobId.ColumnIndex)) { this.col_JobId = sqlDataReader.GetSqlInt32(SPs.spS_JobPart.Resultset1.Fields.Column_JobId.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_JobPart.Resultset1.Fields.Column_Description.ColumnIndex)) { this.col_Description = sqlDataReader.GetSqlString(SPs.spS_JobPart.Resultset1.Fields.Column_Description.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_JobPart.Resultset1.Fields.Column_JobPartTypeId.ColumnIndex)) { this.col_JobPartTypeId = sqlDataReader.GetSqlInt32(SPs.spS_JobPart.Resultset1.Fields.Column_JobPartTypeId.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_JobPart.Resultset1.Fields.Column_Units.ColumnIndex)) { this.col_Units = sqlDataReader.GetSqlDecimal(SPs.spS_JobPart.Resultset1.Fields.Column_Units.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_JobPart.Resultset1.Fields.Column_PricePerUnit.ColumnIndex)) { this.col_PricePerUnit = sqlDataReader.GetSqlMoney(SPs.spS_JobPart.Resultset1.Fields.Column_PricePerUnit.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_JobPart.Resultset1.Fields.Column_TotalPrice.ColumnIndex)) { this.col_TotalPrice = sqlDataReader.GetSqlMoney(SPs.spS_JobPart.Resultset1.Fields.Column_TotalPrice.ColumnIndex); } if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); this.recordIsLoaded = true; return(true); } else { if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); this.recordIsLoaded = false; return(false); } } else { if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); throw new Bob.DataClasses.CustomException(Param, "Bob.BusinessComponents.JobPart_Record", "Refresh"); } }
protected void LoginButton_Click(object sender, EventArgs e) { String connectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; System.Data.SqlClient.SqlConnection sql = new System.Data.SqlClient.SqlConnection(connectionString); sql.Open(); System.Data.SqlClient.SqlCommand query = new System.Data.SqlClient.SqlCommand(); query.Connection = sql; //query to grab the password of the username entered in query.CommandText = "SELECT DISTINCT dbo.Password.PasswordHash FROM dbo.Password INNER JOIN " + "dbo.UserEntity ON dbo.Password.UserEntityID = dbo.UserEntity.UserEntityID where upper(username) = upper(@userName)"; query.Parameters.AddWithValue("@userName", HttpUtility.HtmlEncode(username.Value)); System.Data.SqlClient.SqlDataReader reader = query.ExecuteReader(); String storedPassword = "******"; while (reader.Read()) { //Lazy way to handle null usernames. if (reader.IsDBNull(0)) { storedPassword = "******"; } else { storedPassword = reader.GetString(0); } } sql.Close(); reader.Close(); //method to validate if password in hashed textbox matches our hashed password in the DB if (PasswordHash.ValidatePassword(password.Value, storedPassword)) { Label10.Text = "Success!"; String permissions = " "; int school = 0; sql.Open(); System.Data.SqlClient.SqlCommand query1 = new System.Data.SqlClient.SqlCommand(); query1.Connection = sql; query1.CommandText = "SELECT dbo.UserEntity.UserEntityID from dbo.userentity where upper(username) like upper(@userName1)"; query1.Parameters.AddWithValue("@userName1", HttpUtility.HtmlEncode(username.Value)); System.Data.SqlClient.SqlDataReader reader1 = query1.ExecuteReader(); int id = 0; while (reader1.Read()) { if (reader1.IsDBNull(0)) { username.Value = "null"; } else { id = reader1.GetInt32(0); } } query1.CommandText = "SELECT dbo.SchoolEmployee.SchoolEmployeeEntityType from dbo.schoolemployee where SchoolEmployeeEntityID = @SchoolEmployeeEntityID"; query1.Parameters.AddWithValue("@SchoolEmployeeEntityID", id); reader1.Close(); System.Data.SqlClient.SqlDataReader reader2 = query1.ExecuteReader(); while (reader2.Read()) { if (reader2.IsDBNull(0)) { username.Value = "null"; } else { permissions = reader2.GetString(0); } } int schoolEntityId = 0; String schoolName = ""; String schoolCounty = ""; int userEntityID = 0; query1.CommandText = "SELECT School.SchoolEntityID, School.SchoolName, School.SchoolCounty, SchoolEmployee.SchoolEmployeeEntityID FROM School INNER JOIN SchoolEmployee ON School.SchoolEntityID = SchoolEmployee.SchoolEntityID" + " where SchoolEmployeeEntityID = @userEntityID"; query1.Parameters.AddWithValue("@userEntityID", id); reader2.Close(); System.Data.SqlClient.SqlDataReader reader3 = query1.ExecuteReader(); while (reader3.Read()) { schoolEntityId = reader3.GetInt32(0); schoolName = reader3.GetString(1); schoolCounty = reader3.GetString(2); userEntityID = reader3.GetInt32(3); } query1.CommandText = "SELECT dbo.SchoolEmployee.SchoolentityID from dbo.schoolemployee where SchoolEmployeeEntityID = @SchoolEmployeeEntityID1"; query1.Parameters.AddWithValue("@SchoolEmployeeEntityID1", id); reader3.Close(); System.Data.SqlClient.SqlDataReader reader4 = query1.ExecuteReader(); while (reader4.Read()) { if (reader4.IsDBNull(0)) { school = 0; } else { school = reader4.GetInt32(0); } } Session["schoolID"] = schoolEntityId; Session["userCounty"] = schoolCounty; Session["schoolName"] = schoolName; Session["EntityID"] = userEntityID; //Test the permsissions if (permissions.Equals("Admin")) { Session["user"] = username.Value; Session["permission"] = permissions; Session["schoolid"] = school; Response.Redirect("LandingPage.aspx"); } else if (permissions.Equals("Counselor")) { Session["user"] = username.Value; Session["permission"] = permissions; Session["schoolid"] = school; Response.Redirect("CounselorLandingPage.aspx"); } else if (permissions.Equals("Teacher")) { Session["user"] = username.Value; Session["permission"] = permissions; Session["schoolid"] = school; Response.Redirect("TeacherLandingPage.aspx"); } } else { Label10.Text = "Your username or password is incorrect, please try again."; username.Value = ""; password.Value = ""; } }
/// <summary> /// [To be supplied.] /// </summary> /// <returns>[To be supplied.]</returns> public bool Refresh() { this.displayName = null; this.col_Ord_DatOrderedOnWasUpdated = false; this.col_Ord_DatOrderedOnWasSet = false; this.col_Ord_DatOrderedOn = System.Data.SqlTypes.SqlDateTime.Null; this.col_Ord_LngCustomerIDWasUpdated = false; this.col_Ord_LngCustomerIDWasSet = false; this.col_Ord_LngCustomerID = System.Data.SqlTypes.SqlInt32.Null; this.col_Ord_CurTotalWasUpdated = false; this.col_Ord_CurTotalWasSet = false; this.col_Ord_CurTotal = System.Data.SqlTypes.SqlMoney.Null; bool alreadyOpened = false; Params.spS_tblOrder Param = new Params.spS_tblOrder(true); Param.CommandTimeOut = this.selectCommandTimeOut; switch (this.lastKnownConnectionType) { case OlymarsDemo.DataClasses.ConnectionType.ConnectionString: Param.SetUpConnection(this.connectionString); break; case OlymarsDemo.DataClasses.ConnectionType.SqlConnection: Param.SetUpConnection(this.sqlConnection); alreadyOpened = (this.sqlConnection.State == System.Data.ConnectionState.Open); break; case OlymarsDemo.DataClasses.ConnectionType.SqlTransaction: Param.SetUpConnection(this.sqlTransaction); break; } if (!this.col_Ord_GuidID.IsNull) { Param.Param_Ord_GuidID = this.col_Ord_GuidID; } System.Data.SqlClient.SqlDataReader sqlDataReader = null; SPs.spS_tblOrder Sp = new SPs.spS_tblOrder(false); if (Sp.Execute(ref Param, out sqlDataReader)) { if (sqlDataReader.Read()) { if (!sqlDataReader.IsDBNull(SPs.spS_tblOrder.Resultset1.Fields.Column_Ord_DatOrderedOn.ColumnIndex)) { this.col_Ord_DatOrderedOn = sqlDataReader.GetSqlDateTime(SPs.spS_tblOrder.Resultset1.Fields.Column_Ord_DatOrderedOn.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_tblOrder.Resultset1.Fields.Column_Ord_LngCustomerID.ColumnIndex)) { this.col_Ord_LngCustomerID = sqlDataReader.GetSqlInt32(SPs.spS_tblOrder.Resultset1.Fields.Column_Ord_LngCustomerID.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_tblOrder.Resultset1.Fields.Column_Ord_CurTotal.ColumnIndex)) { this.col_Ord_CurTotal = sqlDataReader.GetSqlMoney(SPs.spS_tblOrder.Resultset1.Fields.Column_Ord_CurTotal.ColumnIndex); } if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); this.recordIsLoaded = true; return(true); } else { if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); this.recordIsLoaded = false; return(false); } } else { if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); throw new OlymarsDemo.DataClasses.CustomException(Param, "OlymarsDemo.BusinessComponents.tblOrder_Record", "Refresh"); } }
/// <summary> /// [To be supplied.] /// </summary> /// <returns>[To be supplied.]</returns> public bool Refresh() { this.displayName = null; this.col_CompanyNameWasUpdated = false; this.col_CompanyNameWasSet = false; this.col_CompanyName = System.Data.SqlTypes.SqlString.Null; this.col_ContactNameWasUpdated = false; this.col_ContactNameWasSet = false; this.col_ContactName = System.Data.SqlTypes.SqlString.Null; this.col_TitleIdWasUpdated = false; this.col_TitleIdWasSet = false; this.col_TitleId = System.Data.SqlTypes.SqlInt32.Null; this.col_AddressWasUpdated = false; this.col_AddressWasSet = false; this.col_Address = System.Data.SqlTypes.SqlString.Null; this.col_CityWasUpdated = false; this.col_CityWasSet = false; this.col_City = System.Data.SqlTypes.SqlString.Null; this.col_PostalCodeWasUpdated = false; this.col_PostalCodeWasSet = false; this.col_PostalCode = System.Data.SqlTypes.SqlString.Null; this.col_PhoneWasUpdated = false; this.col_PhoneWasSet = false; this.col_Phone = System.Data.SqlTypes.SqlString.Null; this.col_EmailWasUpdated = false; this.col_EmailWasSet = false; this.col_Email = System.Data.SqlTypes.SqlString.Null; this.col_WebAddressWasUpdated = false; this.col_WebAddressWasSet = false; this.col_WebAddress = System.Data.SqlTypes.SqlString.Null; this.col_FaxWasUpdated = false; this.col_FaxWasSet = false; this.col_Fax = System.Data.SqlTypes.SqlString.Null; this.col_ActiveWasUpdated = false; this.col_ActiveWasSet = false; this.col_Active = System.Data.SqlTypes.SqlBoolean.Null; bool alreadyOpened = false; Params.spS_Customers Param = new Params.spS_Customers(true); Param.CommandTimeOut = this.selectCommandTimeOut; switch (this.lastKnownConnectionType) { case Bob.DataClasses.ConnectionType.ConnectionString: Param.SetUpConnection(this.connectionString); break; case Bob.DataClasses.ConnectionType.SqlConnection: Param.SetUpConnection(this.sqlConnection); alreadyOpened = (this.sqlConnection.State == System.Data.ConnectionState.Open); break; case Bob.DataClasses.ConnectionType.SqlTransaction: Param.SetUpConnection(this.sqlTransaction); break; } if (!this.col_CustomerID.IsNull) { Param.Param_CustomerID = this.col_CustomerID; } System.Data.SqlClient.SqlDataReader sqlDataReader = null; SPs.spS_Customers Sp = new SPs.spS_Customers(false); if (Sp.Execute(ref Param, out sqlDataReader)) { if (sqlDataReader.Read()) { if (!sqlDataReader.IsDBNull(SPs.spS_Customers.Resultset1.Fields.Column_CompanyName.ColumnIndex)) { this.col_CompanyName = sqlDataReader.GetSqlString(SPs.spS_Customers.Resultset1.Fields.Column_CompanyName.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_Customers.Resultset1.Fields.Column_ContactName.ColumnIndex)) { this.col_ContactName = sqlDataReader.GetSqlString(SPs.spS_Customers.Resultset1.Fields.Column_ContactName.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_Customers.Resultset1.Fields.Column_TitleId.ColumnIndex)) { this.col_TitleId = sqlDataReader.GetSqlInt32(SPs.spS_Customers.Resultset1.Fields.Column_TitleId.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_Customers.Resultset1.Fields.Column_Address.ColumnIndex)) { this.col_Address = sqlDataReader.GetSqlString(SPs.spS_Customers.Resultset1.Fields.Column_Address.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_Customers.Resultset1.Fields.Column_City.ColumnIndex)) { this.col_City = sqlDataReader.GetSqlString(SPs.spS_Customers.Resultset1.Fields.Column_City.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_Customers.Resultset1.Fields.Column_PostalCode.ColumnIndex)) { this.col_PostalCode = sqlDataReader.GetSqlString(SPs.spS_Customers.Resultset1.Fields.Column_PostalCode.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_Customers.Resultset1.Fields.Column_Phone.ColumnIndex)) { this.col_Phone = sqlDataReader.GetSqlString(SPs.spS_Customers.Resultset1.Fields.Column_Phone.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_Customers.Resultset1.Fields.Column_Email.ColumnIndex)) { this.col_Email = sqlDataReader.GetSqlString(SPs.spS_Customers.Resultset1.Fields.Column_Email.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_Customers.Resultset1.Fields.Column_WebAddress.ColumnIndex)) { this.col_WebAddress = sqlDataReader.GetSqlString(SPs.spS_Customers.Resultset1.Fields.Column_WebAddress.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_Customers.Resultset1.Fields.Column_Fax.ColumnIndex)) { this.col_Fax = sqlDataReader.GetSqlString(SPs.spS_Customers.Resultset1.Fields.Column_Fax.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_Customers.Resultset1.Fields.Column_Active.ColumnIndex)) { this.col_Active = sqlDataReader.GetSqlBoolean(SPs.spS_Customers.Resultset1.Fields.Column_Active.ColumnIndex); } if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); this.recordIsLoaded = true; return(true); } else { if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); this.recordIsLoaded = false; return(false); } } else { if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); throw new Bob.DataClasses.CustomException(Param, "Bob.BusinessComponents.Customer", "Refresh"); } }
} // GetLayerSourceInfo() public PDX.BTS.DataMaintenance.MaintTools.FeatureClassSourceInfo GetLayerSourceInfo(string FeatureClassName, string OutputGeodatabaseName) { System.Data.SqlClient.SqlCommand getSourceInfoSQLCommand = null; System.Data.SqlClient.SqlDataReader getSourceInfoSQLDataReader = null; ESRI.ArcGIS.esriSystem.IPropertySet sourcePropertySet = null; PDX.BTS.DataMaintenance.MaintTools.GeneralUtilities maintenanceGeneralUtilities = null; PDX.BTS.DataMaintenance.MaintTools.PathManager shapefilePathGenerator = null; PDX.BTS.DataMaintenance.MaintTools.FeatureClassUtilities featureClassUtilities = null; try { // Make sure there is a valid connection to the Load Metadata Database before attempting to update it. if (!ConnecttoImportMonitorDatabase()) { // Send a Message to the calling application to let the user know why this process failed. if (ErrorMessage != null) { ErrorMessage(" Could not establish a connection to the Load Metadata Database! LoaderUtilities.DatabaseTools.GetLayerSourceInfo() Failed!"); } // Return a NULL String to the calling routine to indicate that this process failed. return(null); } // Build the SQL Statement that will be used to retrieve the Source Information for the Feature Class. string getSourceInfoSQLStatement = "SELECT [Load_Source], [Data_Source], [Dataset], [GeoDB_File], [Source_Server_Name]," + " [Source_Instance], [Source_Database_Name], [Source_Database_User_Name]," + " [Input_Dataset_Name], [Output_Database] " + "FROM " + _monitorTableName + " " + "WHERE [Feature_Class_Name] = '" + FeatureClassName + "'"; // If the Output Geodatabase Name was passed to this method, include it in the query. if (!System.String.IsNullOrEmpty(OutputGeodatabaseName)) { // Add the Output Geodatabase Name to the SQL Statement. getSourceInfoSQLStatement = getSourceInfoSQLStatement + " AND [Output_Database] = '" + OutputGeodatabaseName + "'"; } // Build the SQL Command Object that will be used to retrieve the Source Data Info for the specified Feature Class. getSourceInfoSQLCommand = new System.Data.SqlClient.SqlCommand(); getSourceInfoSQLCommand.Connection = _importMonitorDatabaseConnection; getSourceInfoSQLCommand.CommandType = System.Data.CommandType.Text; getSourceInfoSQLCommand.CommandText = getSourceInfoSQLStatement; getSourceInfoSQLCommand.CommandTimeout = 30; // Use the SQL Command Object that was just instantiated to populate a SQL Data Reader Object with the info about the specified // Feature Class. getSourceInfoSQLDataReader = getSourceInfoSQLCommand.ExecuteReader(); // Instantiate a Feature Class Source Info Object. PDX.BTS.DataMaintenance.MaintTools.FeatureClassSourceInfo currentFeatureClassSourceInfo = new PDX.BTS.DataMaintenance.MaintTools.FeatureClassSourceInfo(); // If some information was retrieved, populate a Feature Class Source Info Object and return it to the calling method. If not, // return a NULL Pointer to indicate that this method failed. if (getSourceInfoSQLDataReader.HasRows) { if (getSourceInfoSQLDataReader.Read()) { // Populate the New Feature Class Source Info Object with the Source Info for the specified Feature Class. // Populate the Source Type Property. if (!getSourceInfoSQLDataReader.IsDBNull(getSourceInfoSQLDataReader.GetOrdinal("Load_Source"))) { currentFeatureClassSourceInfo.SourceType = (string)getSourceInfoSQLDataReader["Load_Source"]; } else { currentFeatureClassSourceInfo.SourceType = ""; } // Populate the Source Data Share Property. if (!getSourceInfoSQLDataReader.IsDBNull(getSourceInfoSQLDataReader.GetOrdinal("Data_Source"))) { currentFeatureClassSourceInfo.SourceDataShare = (string)getSourceInfoSQLDataReader["Data_Source"]; } else { currentFeatureClassSourceInfo.SourceDataShare = ""; } // Populate the Source Dataset Property. if (!getSourceInfoSQLDataReader.IsDBNull(getSourceInfoSQLDataReader.GetOrdinal("Dataset"))) { currentFeatureClassSourceInfo.SourceDataset = (string)getSourceInfoSQLDataReader["Dataset"]; } else { currentFeatureClassSourceInfo.SourceDataset = ""; } // Populate the Source Geodatabase File Property. if (!getSourceInfoSQLDataReader.IsDBNull(getSourceInfoSQLDataReader.GetOrdinal("GeoDB_File"))) { currentFeatureClassSourceInfo.SourceGeoDBFile = (string)getSourceInfoSQLDataReader["GeoDB_File"]; } else { currentFeatureClassSourceInfo.SourceGeoDBFile = ""; } // Populate the Source Server Name Property. if (!getSourceInfoSQLDataReader.IsDBNull(getSourceInfoSQLDataReader.GetOrdinal("Source_Server_Name"))) { currentFeatureClassSourceInfo.SourceServerName = (string)getSourceInfoSQLDataReader["Source_Server_Name"]; } else { currentFeatureClassSourceInfo.SourceServerName = ""; } // Populate the Source Instance Property. if (!getSourceInfoSQLDataReader.IsDBNull(getSourceInfoSQLDataReader.GetOrdinal("Source_Instance"))) { currentFeatureClassSourceInfo.SourceInstance = (string)getSourceInfoSQLDataReader["Source_Instance"]; } else { currentFeatureClassSourceInfo.SourceInstance = ""; } // Populate the Source Database Name Property. if (!getSourceInfoSQLDataReader.IsDBNull(getSourceInfoSQLDataReader.GetOrdinal("Source_Database_Name"))) { currentFeatureClassSourceInfo.SourceDatabaseName = (string)getSourceInfoSQLDataReader["Source_Database_Name"]; } else { currentFeatureClassSourceInfo.SourceDatabaseName = ""; } // Populate the Source Database User Name Property. if (!getSourceInfoSQLDataReader.IsDBNull(getSourceInfoSQLDataReader.GetOrdinal("Source_Database_User_Name"))) { currentFeatureClassSourceInfo.SourceDatabaseUser = (string)getSourceInfoSQLDataReader["Source_Database_User_Name"]; } else { currentFeatureClassSourceInfo.SourceDatabaseUser = ""; } // Populate the Input Feature Class Name Property. if (!getSourceInfoSQLDataReader.IsDBNull(getSourceInfoSQLDataReader.GetOrdinal("Input_Dataset_Name"))) { currentFeatureClassSourceInfo.SourceFeatureClassName = (string)getSourceInfoSQLDataReader["Input_Dataset_Name"]; } else { currentFeatureClassSourceInfo.SourceFeatureClassName = ""; } // Populate the Output Geodatabase Property. if (!getSourceInfoSQLDataReader.IsDBNull(getSourceInfoSQLDataReader.GetOrdinal("Output_Database"))) { currentFeatureClassSourceInfo.OutputGeodatabaseName = (string)getSourceInfoSQLDataReader["Output_Database"]; } else { currentFeatureClassSourceInfo.OutputGeodatabaseName = ""; } } else { // Send a Message to the calling application to let the user know why this process failed. if (ErrorMessage != null) { ErrorMessage(" No Source Information for the Specified Feature Class was found in the Load Metadata Database! LoaderUtilities.DatabaseTools.GetLayerSourceInfo() Failed!"); } // Return a NULL String to the calling routine to indicate that this process failed. return(null); } } else { // Send a Message to the calling application to let the user know why this process failed. if (ErrorMessage != null) { ErrorMessage(" The query to retrieve Source Information for the Specified Feature Class failed to retrieve any data from the Load Metadata Database! LoaderUtilities.DatabaseTools.GetLayerSourceInfo() Failed!"); } // Return a NULL String to the calling routine to indicate that this process failed. return(null); } // Instantiate a Feature Class Utilities Object. featureClassUtilities = new PDX.BTS.DataMaintenance.MaintTools.FeatureClassUtilities(); // Build the Property Set for the Source Dataset and determine its Last Update Date. sourcePropertySet = new ESRI.ArcGIS.esriSystem.PropertySet(); switch (currentFeatureClassSourceInfo.SourceType) { case "FILEGEODB": // Build the File Geodatabase PropertySet. sourcePropertySet.SetProperty("DATABASE", currentFeatureClassSourceInfo.SourceGeoDBFile); // Determine the File Geodatabase Feature Class Last Update Date. currentFeatureClassSourceInfo.SourceLastUpdateDate = featureClassUtilities.GetFileGeodatabaseFeatureClassLastUpdate(currentFeatureClassSourceInfo.SourceGeoDBFile, currentFeatureClassSourceInfo.SourceFeatureClassName); // Exit this case. break; case "PERSONALGEODB": // Build the Personal Geodatabase PropertySet. sourcePropertySet.SetProperty("DATABASE", currentFeatureClassSourceInfo.SourceGeoDBFile); // Determine the Source Personal Geodatabase Last Update Date. currentFeatureClassSourceInfo.SourceLastUpdateDate = featureClassUtilities.GetPersonalGeoDBLastUpdateDate(currentFeatureClassSourceInfo.SourceGeoDBFile); // Exit this case. break; case "GEODATABASE": // Determine the Server User Password. maintenanceGeneralUtilities = new PDX.BTS.DataMaintenance.MaintTools.GeneralUtilities(); string serverUserPassword = maintenanceGeneralUtilities.RetrieveParameterValue(currentFeatureClassSourceInfo.SourceDatabaseUser + "_Password", _parameterTableName, _parameterDatabaseConnectionString, true); // Build the Enterprise Geodatabase Property Set. sourcePropertySet.SetProperty("SERVER", currentFeatureClassSourceInfo.SourceServerName); sourcePropertySet.SetProperty("INSTANCE", currentFeatureClassSourceInfo.SourceInstance); sourcePropertySet.SetProperty("DATABASE", currentFeatureClassSourceInfo.SourceDatabaseName); sourcePropertySet.SetProperty("USER", currentFeatureClassSourceInfo.SourceDatabaseUser); sourcePropertySet.SetProperty("PASSWORD", serverUserPassword); sourcePropertySet.SetProperty("VERSION", "SDE.Default"); // Determine the Enterprise Geodatabase Feature Class Last Udpate Date. currentFeatureClassSourceInfo.SourceLastUpdateDate = featureClassUtilities.GetEntGeoDBFeatureClassLastUpdate(currentFeatureClassSourceInfo.SourceFeatureClassName, currentFeatureClassSourceInfo.SourceServerName, currentFeatureClassSourceInfo.SourceDatabaseName, currentFeatureClassSourceInfo.SourceDatabaseUser, serverUserPassword); // Exit this case. break; case "SHAPEFILE": // Instantiate a City of Portland Path Manager Object that will be used to determine the Path to the Source Shapefile. shapefilePathGenerator = new PDX.BTS.DataMaintenance.MaintTools.PathManager(); string shapefileDirectoryPath = shapefilePathGenerator.BuildShapefileDirectoryPath(currentFeatureClassSourceInfo.SourceDataShare, currentFeatureClassSourceInfo.SourceDataset, currentFeatureClassSourceInfo.SourceFeatureClassName); // Build the Shapefile PropertySet. sourcePropertySet.SetProperty("DATABASE", shapefileDirectoryPath); // Determine the Source Shapefile Last Update Date. string fullShapefilePath = shapefilePathGenerator.BuildShapefilePath(currentFeatureClassSourceInfo.SourceDataShare, currentFeatureClassSourceInfo.SourceDataset, currentFeatureClassSourceInfo.SourceFeatureClassName); currentFeatureClassSourceInfo.SourceLastUpdateDate = featureClassUtilities.GetShapefileLastUpdateDate(fullShapefilePath); // Exit this case. break; default: // Exit this case. break; } // Set the Source PropertySet Property of the Current Source Feature Class Info Object. currentFeatureClassSourceInfo.SourceDatasetPropertySet = sourcePropertySet; // Return the populated Current Feature Class Source Info Object to the calling method. return(currentFeatureClassSourceInfo); } catch (Exception caught) { // Send a Message to the calling application to let the user know why this process failed. if (ErrorMessage != null) { ErrorMessage(" The LoaderUtilities.DatabaseTools.GetLayerSourceInfo() Method Failed with error message: " + caught.Message); } // Return a NULL String to the calling routine to indicate that this process failed. return(null); } finally { // If the Get Source Info SQL Data Reader Object was instantiated, close it. if (getSourceInfoSQLDataReader != null) { if (!getSourceInfoSQLDataReader.IsClosed) { getSourceInfoSQLDataReader.Close(); } getSourceInfoSQLDataReader.Dispose(); getSourceInfoSQLDataReader = null; } // If the Get Source Info SQL Command Object was instantiated, close it. if (getSourceInfoSQLCommand != null) { getSourceInfoSQLCommand.Dispose(); getSourceInfoSQLCommand = null; } } } // GetLayerSourceInfo()
/// <summary> /// [To be supplied.] /// </summary> /// <returns>[To be supplied.]</returns> public override string ToString() { if (!this.recordWasLoadedFromDB) { throw new ArgumentException("No record was loaded from the database. The DisplayName is not available."); } if (this.displayName == null) { bool alreadyOpened = false; Params.spS_Customers_Display Param = new Params.spS_Customers_Display(true); switch (this.lastKnownConnectionType) { case Bob.DataClasses.ConnectionType.ConnectionString: Param.SetUpConnection(this.connectionString); break; case Bob.DataClasses.ConnectionType.SqlConnection: Param.SetUpConnection(this.sqlConnection); alreadyOpened = (this.sqlConnection.State == System.Data.ConnectionState.Open); break; case Bob.DataClasses.ConnectionType.SqlTransaction: Param.SetUpConnection(this.sqlTransaction); break; } Param.Param_CustomerID = this.col_CustomerID; System.Data.SqlClient.SqlDataReader sqlDataReader = null; SPs.spS_Customers_Display Sp = new SPs.spS_Customers_Display(false); if (Sp.Execute(ref Param, out sqlDataReader)) { if (sqlDataReader.Read()) { if (!sqlDataReader.IsDBNull(SPs.spS_Customers_Display.Resultset1.Fields.Column_Display.ColumnIndex)) { if (sqlDataReader.GetFieldType(SPs.spS_Customers_Display.Resultset1.Fields.Column_Display.ColumnIndex) == typeof(string)) { this.displayName = sqlDataReader.GetString(SPs.spS_Customers_Display.Resultset1.Fields.Column_Display.ColumnIndex); } else { this.displayName = sqlDataReader.GetValue(SPs.spS_Customers_Display.Resultset1.Fields.Column_Display.ColumnIndex).ToString(); } } } if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); } else { if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); throw new Bob.DataClasses.CustomException(Param, "Bob.BusinessComponents.Customer", "ToString"); } } return(this.displayName); }
protected void Page_Load(object sender, EventArgs e) { Master.Title = "执行SQL语句"; builder.Append(Out.Tab("<div class=\"title\">执行SQL语句</div>", "")); string act = Utils.GetRequest("act", "post", 1, "", ""); if (act == "ok") { string SqlText = Request.Form["SqlText"]; if (string.IsNullOrEmpty(SqlText)) { Utils.Error("SQL语句不能为空", ""); } SqlText = SqlText.ToLower(); string SqlKey = "exec,declare,netuser,xp_cmdshell,drop,master,create,alter";//truncate string[] temp = SqlKey.Split(",".ToCharArray()); for (int i = 0; i < temp.Length; i++) { if (SqlText.Contains(temp[i])) { Utils.Error("为了系统安全," + temp[i] + "方法已被禁止", ""); } } builder.Append(Out.Tab("<div>", "")); try { if (!SqlText.Contains("select")) { int rows = BCW.Data.SqlHelper.ExecuteSql(SqlText.Trim()); builder.Append("执行" + SqlText + "成功|影响" + rows + "行"); } else { builder.Append("执行" + SqlText + "<br />"); using (System.Data.SqlClient.SqlDataReader reader = BCW.Data.SqlHelper.ExecuteReader(SqlText)) { int fieldCount = reader.FieldCount; builder.Append("<table><tr>"); for (int i = 0; i < fieldCount; i++) { builder.Append("<td>" + reader.GetName(i) + "</td>"); } builder.Append("</tr>"); while (reader.Read()) { builder.Append("<tr>"); for (int i = 0; i < fieldCount; i++) { builder.Append("<td><textarea>"); if (!reader.IsDBNull(i)) { builder.Append(GetObjectValue(reader, i)); } builder.Append("</textarea></td>"); } builder.Append("</tr>"); } builder.Append("</table>"); } } } catch { builder.Append("执行" + SqlText + "失败"); } builder.Append(Out.Tab("</div>", "")); builder.Append(Out.Tab("<div>", "<br />")); builder.Append("<a href=\"" + Utils.getUrl("datasql.aspx") + "\">返回上一级</a>"); builder.Append(Out.Tab("</div>", "")); } else { builder.Append(Out.Tab("<div>", "")); builder.Append("语句案例:<br />插入语句: insert into 表名(字段1,字段2)values('内容1','内容2')<br />更新语句: update 表名 set 字段1='内容1',字段2='内容2' where 字段3='内容3'<br />删除语句: delete from 表名 where 字段='内容'<br />查询语句: select top 显示的记录数目 字段1,字段2 from 表名 where 字段1='内容1'"); builder.Append(Out.Tab("</div>", "")); string strText = "输入一条SQL语句:/,"; string strName = "SqlText,act"; string strType = "big,hidden"; string strValu = "'ok"; string strEmpt = "true,false"; string strIdea = "/"; string strOthe = "确定执行|reset,datasql.aspx,post,1,red|blue"; builder.Append(Out.wapform(strText, strName, strType, strValu, strEmpt, strIdea, strOthe)); builder.Append(Out.Tab("<div>", "<br />")); builder.Append("重要提示:<br />必须先备份数据库再进行操作.<br />必须熟悉SQL语句才可以进行操作."); builder.Append(Out.Tab("</div>", "")); } builder.Append(Out.Tab("<div class=\"hr\"></div>", Out.Hr())); builder.Append(Out.Tab("<div>", "")); builder.Append("<a href=\"" + Utils.getUrl("default.aspx") + "\">系统服务中心</a><br />"); builder.Append(Out.Tab("</div><div class=\"title\"><a href=\"" + Utils.getUrl("../default.aspx") + "\">返回管理中心</a>", "<a href=\"" + Utils.getUrl("../default.aspx") + "\">返回管理中心</a>")); builder.Append(Out.Tab("</div>", "<br />")); }