private MeCreditcardHistoryInfo getDataReader(iSqlDataReader dar) { try { int i = -1; MeCreditcardHistoryInfo info = new MeCreditcardHistoryInfo(); info.Memberid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Creditcardid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Balance = dar.IsDBNull(++i) ? 0 : dar.GetFloat(i); info.Amount = dar.IsDBNull(++i) ? 0 : dar.GetFloat(i); info.Addorsub = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Note = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); return info; } catch (Exception ex) { throw ex; } }
private static hierarchy3a ORM_CreateProxy(System.Data.IDataReader result, System.Collections.Generic.IDictionary <string, int> ordinals) { return(new hierarchy3a() { pid = result.IsDBNull(ordinals["pid"]) ? new Guid() : result.GetGuid(ordinals["pid"]), fid = result.IsDBNull(ordinals["fid"]) ? 0 : result.GetInt64(ordinals["fid"]), uid = result.IsDBNull(ordinals["uid"]) ? new Guid() : result.GetGuid(ordinals["uid"]), numfield1 = result.IsDBNull(ordinals["numfield1"]) ? 0 : result.GetInt32(ordinals["numfield1"]), numfield2 = result.IsDBNull(ordinals["numfield2"]) ? 0 : result.GetInt32(ordinals["numfield2"]), numfield3 = result.IsDBNull(ordinals["numfield3"]) ? 0 : result.GetInt32(ordinals["numfield3"]), textfield1 = result.IsDBNull(ordinals["textfield1"]) ? null : result.GetString(ordinals["textfield1"]), textfield2 = result.IsDBNull(ordinals["textfield2"]) ? null : result.GetString(ordinals["textfield2"]), textfield3 = result.IsDBNull(ordinals["textfield3"]) ? null : result.GetString(ordinals["textfield3"]) }); //var obj = new hierarchy3a(); //obj.pid = result.IsDBNull(ordinals["pid"]) ? new Guid() : result.GetGuid(ordinals["pid"]), //obj.fid = result.IsDBNull(ordinals["fid"]) ? 0 : result.GetInt64(ordinals["fid"]), //obj.uid = result.IsDBNull(ordinals["uid"]) ? new Guid() : result.GetGuid(ordinals["uid"]), //obj.numfield1 = result.IsDBNull(ordinals["numfield1"]) ? 0 : result.GetInt32(ordinals["numfield1"]), //obj.numfield2 = result.IsDBNull(ordinals["numfield2"]) ? 0 : result.GetInt32(ordinals["numfield2"]), //obj.numfield3 = result.IsDBNull(ordinals["numfield3"]) ? 0 : result.GetInt32(ordinals["numfield3"]), //obj.textfield1 = result.IsDBNull(ordinals["textfield1"]) ? null : result.GetString(ordinals["textfield1"]), //obj.textfield2 = result.IsDBNull(ordinals["textfield2"]) ? null : result.GetString(ordinals["textfield2"]), //obj.textfield3 = result.IsDBNull(ordinals["textfield3"]) ? null : result.GetString(ordinals["textfield3"]) //return obj; }
///******************************************************************************* ///NOMBRE DE LA FUNCIÓN : Consultar_Detalles_Menu ///DESCRIPCIÓN : Regresa un objeto con los datos de un Menu. ///PARAMETROS : Parametros: Contiene los criterios para la busqueda. ///CREO : Salvador Vázquez Camacho ///FECHA_CREO : 12/Enero/2013 ///MODIFICO : ///FECHA_MODIFICO : ///CAUSA_MODIFICACIÓN : ///******************************************************************************* public static Cls_Apl_Menus_Negocio Consultar_Detalles_Menu(Cls_Apl_Menus_Negocio Parametros) { StringBuilder Mi_SQL; Cls_Apl_Menus_Negocio Contrato = new Cls_Apl_Menus_Negocio(); Conexion.Iniciar_Helper(); Conexion.HelperGenerico.Conexion_y_Apertura(); Mi_SQL = new StringBuilder(); Mi_SQL.Append("SELECT * FROM " + Apl_Menus.Tabla_Apl_Menus); Mi_SQL.Append(" WHERE " + Apl_Menus.Campo_Menu_Id + " = '" + Parametros.P_Menu_Id + "'"); System.Data.IDataReader Dr_Menu = (System.Data.IDataReader)Conexion.HelperGenerico.Obtener_Data_Reader(Mi_SQL.ToString()); while (Dr_Menu.Read()) { Contrato.P_Menu_Id = Dr_Menu.IsDBNull(0) ? "" : Dr_Menu.GetString(0); Contrato.P_Parent_Id = Dr_Menu.IsDBNull(1) ? "" : Dr_Menu.GetString(1); Contrato.P_Menu_Descripcion = Dr_Menu.IsDBNull(2) ? "" : Dr_Menu.GetString(2); Contrato.P_Url_Link = Dr_Menu.IsDBNull(3) ? "" : Dr_Menu.GetString(3); Contrato.P_Estatus = Dr_Menu.IsDBNull(4) ? "" : Dr_Menu.GetString(4); } return(Contrato); Conexion.HelperGenerico.Cerrar_Conexion(); }
public RemoteVolume(System.Data.IDataReader rd) { this.ID = rd.GetInt64(0); this.Name = rd.GetString(1); this.Size = rd.GetInt64(2); this.Hash = rd.GetString(3); this.VerificationCount = rd.GetInt64(4); }
public object MapRow(System.Data.IDataReader reader, int rowNum) { User model = new User(); model.id = reader.GetInt32(0); model.name = reader.GetString(1); model.pwd = reader.GetString(2); return(model); }
protected override Subject Create(System.Data.IDataReader reader) { return(new Subject { ID = reader.GetString(0), Name = reader.GetString(1), Semester = reader.GetInt32(2) }); }
protected override StudyProgramme Create(System.Data.IDataReader reader) { return(new StudyProgramme { ID = reader.GetString(0), Name = reader.GetString(1), Length = reader.GetInt32(2), StudyType = reader.GetInt32(3) == 0 ? StudyType.Bachelor : StudyType.Magister }); }
public AccountItem MapRow(System.Data.IDataReader reader, int rowNum) { AccountItem account = new AccountItem(); account.Id = reader.GetInt32(reader.GetOrdinal("id")); account.Email = reader.GetString(reader.GetOrdinal("email")); account.Password = reader.GetString(reader.GetOrdinal("password")); account.State = reader.GetString(reader.GetOrdinal("state")); return(account); }
protected override Exam Create(System.Data.IDataReader reader) { return(new Exam { ID = reader.GetString(0), Time = reader.GetDateTime(1), Subject = SubjectRepository.GetSingle(reader.GetString(2)), Teacher = TeacherRepository.GetSingle(reader.GetString(3)), SignedStudents = StudentRepository.GetByExam(reader.GetString(0)).ToList() }); }
protected override Student Create(System.Data.IDataReader reader) { return(new Student { ID = reader.GetString(0), Name = reader.GetString(1), Lastname = reader.GetString(2), Semester = reader.GetInt32(3), DateOfBirth = reader.GetDateTime(4), StudyProgramme = StudyProgrammeRepository.GetSingle(reader.GetString(5)) }); }
public static Food Parse(System.Data.IDataReader reader) { string _name = reader.GetString(0); string _description = reader.GetString(1); int _power = reader.GetInt32(2); int _cost = reader.GetInt32(3); int _quantity = reader.GetInt32(4); byte[] _img = (byte[])reader["picture"]; return(new Food(_name, _description, _power, _cost, _img, _quantity)); }
public LectureTypeRequirementItem MapRow(System.Data.IDataReader reader, int rowNum) { LectureTypeRequirementItem lectureTypeRequirement = new LectureTypeRequirementItem(); lectureTypeRequirement.AccountId = reader.GetInt32(reader.GetOrdinal("accountId")); lectureTypeRequirement.Cutline = reader.GetInt32(reader.GetOrdinal("cutline")); lectureTypeRequirement.Id = reader.GetInt32(reader.GetOrdinal("id")); lectureTypeRequirement.LectureTypeId = reader.GetInt32(reader.GetOrdinal("lectureTypeId")); lectureTypeRequirement.LectureTypeName = reader.GetString(reader.GetOrdinal("lectureTypeName")); lectureTypeRequirement.LectureCategoryName = reader.GetString(reader.GetOrdinal("lectureCategoryName")); lectureTypeRequirement.LectureCategoryId = reader.GetInt32(reader.GetOrdinal("lectureCategoryId")); return(lectureTypeRequirement); }
internal override void SetEntity(System.Data.IDataReader reader, Dictionary <string, int> lowerFields) { BatchID = reader.GetInt32(lowerFields["batchid"]); Cluster = GetField <string>(reader, lowerFields["cluster"]); AliasCluster = reader.GetString(lowerFields["aliascluster"]); ClusterIP = reader.GetString(lowerFields["clusterip"]); ClusterVPort = reader.GetInt32(lowerFields["clustervport"]); MachineName = reader.GetString(lowerFields["machinename"]); IPAddress = reader.GetString(lowerFields["ipaddress"]); Port = reader.GetInt32(lowerFields["port"]); Status = reader.GetInt32(lowerFields["status"]); CreateTime = reader.GetDateTime(lowerFields["createtime"]); Zone = GetField <int?>(reader, lowerFields["zone"]); }
//protected override void Child_Create() //{ // // TODO: load default values // // omit this override if you have no defaults to set // base.Child_Create(); //} private void Child_Fetch(System.Data.IDataReader childData) { #if TRACE long startTicks = PLLog.Trace("Start", PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 1); #endif Id = childData.GetInt32(0); Name = childData.GetString(1); Description = childData.GetString(2); LastChanged = childData.GetDateTime(3); // TODO(crhodes): Added this to try to get things to not be dirty. MarkOld(); #if TRACE PLLog.Trace("End", PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 3, startTicks); #endif }
internal static Thread getThreadFromReader(System.Data.IDataReader rdr, Dictionary <string, bool> columnTable) { Thread thread = new Thread(); if (columnTable["THREAD_ID"]) { thread.Id = Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("THREAD_ID"))); } if (columnTable["SUBJECT"]) { thread.Subject = rdr.GetString(rdr.GetOrdinal("SUBJECT")); } if (columnTable["TRIAGE_GROUP_ID"]) { if (!rdr.IsDBNull(rdr.GetOrdinal("TRIAGE_GROUP_ID"))) { thread.MailGroup = new TriageGroup() { Id = Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("TRIAGE_GROUP_ID"))) }; } } if (columnTable["MTOPLOCK"]) { thread.Oplock = Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("MTOPLOCK"))); } if (columnTable["CATEGORY_TYPE"]) { thread.MessageCategoryType = (enums.MessageCategoryTypeEnum)Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("CATEGORY_TYPE"))); } return(thread); }
/// <summary> /// Returns the value of the specified variable name /// </summary> /// <param name="varName">Variable name</param> /// <returns>variable value</returns> public string GetVarValue(string varName) { string Function_Name = "GetVarValue"; LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered"); string varValue = "null"; string localSQL = "SELECT VAR_VALUE FROM CONFIG_VARS WHERE VAR_NAME = '" + varName + "'"; System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL); if (drReader != null) { try { while (drReader.Read()) { if (!drReader.IsDBNull(0)) { varValue = drReader.GetString(0).ToString(); } } } catch (System.Exception ex) { LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString()); } drReader.Close(); drReader.Dispose(); } LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited"); return(varValue); }
/// <summary> /// /// </summary> /// <param name="docNumber"></param> /// <param name="versionId"></param> /// <returns></returns> public static int getVersionNumberById(string docNumber, string versionId) { // Reperimento del numero di versione using (DocsPaDB.DBProvider dbProvider = new DocsPaDB.DBProvider()) { // Query per reperire le versioni string commandText = string.Format("SELECT version_id FROM versions WHERE docNumber = {0} order by version_id DESC", docNumber); using (System.Data.IDataReader reader = dbProvider.ExecuteReader(commandText)) { bool trovato = false; int numVersione = 0; while (reader.Read() || trovato) { numVersione++; if (reader.GetString(reader.GetOrdinal("version_id")).Equals(versionId)) { trovato = true; } return(numVersione); } } return(-1); } }
// USED FOR SHOP AND GWAP // HACK (kasiu): This is all stuck in here haphazardly because I'm lazy. // I will clean it up once the study goes out, hopefully. internal string[] LookupRandomTraces(int tracetype, int maxNumTraces) { // XXX (kasiu): HOLY FLYING FRUITCAKE DO SOME ERROR CHECKING PLEASE openConnection(); System.Text.StringBuilder sbSQL = new System.Text.StringBuilder(); // Pulls random traces sbSQL.Append("SELECT tracevalue FROM gametrace WHERE tracetype == ").Append(tracetype); sbSQL.Append(" ORDER BY RANDOM() LIMIT ").Append(maxNumTraces); DebugConsole.Log(sbSQL.ToString()); System.Data.IDataReader res = this.db.BasicQuery(sbSQL.ToString()); string[] s = new string[maxNumTraces]; if (res.Read()) { for (int i = 0; i < maxNumTraces; i++) { if (!res.IsDBNull(i)) // null if nothing's in the DB { s[i] = res.GetString(i); } } } closeConnection(); return(s); }
private JsonElement GetJson(System.Data.IDataReader reader, string name) { var json = reader.GetString(name); if (json.IsNullOrWhiteSpace()) { return(default);
public Payer LoadFromReader(System.Data.IDataReader rdr) { return(new Payer() { Id = rdr.GetInt32(rdr.GetOrdinal("PayerID")), Name = rdr.GetString(rdr.GetOrdinal("Name")) }); }
//public override BaseEntity FromReader(System.Data.Common.DbDataReader reader) //{ // TestEntity entity = new TestEntity(); // entity.Id = reader.GetFieldValue<int>(reader.GetOrdinal("Id")); // entity.Description = reader.GetFieldValue<string>(reader.GetOrdinal("Description")); // return entity; //} public override TEntity ToEntity <TEntity>(System.Data.IDataReader reader) { TestEntity entity = new TestEntity(); entity.Id = reader.GetInt32(reader.GetOrdinal("Id")); entity.Description = reader.GetString(reader.GetOrdinal("Description")); return(entity as TEntity); }
public void ReadData(System.Data.IDataReader reader) { try { if (reader.Read()) { _password = reader.GetString(0); _email = reader.GetString(1); } else { SetFailure(); } } catch (Exception) { SetFailure(); } }
public Race LoadFromReader(System.Data.IDataReader rdr) { return(new Race() { Id = rdr.GetInt32(rdr.GetOrdinal("RaceID")), Name = rdr.GetString(rdr.GetOrdinal("Name")) }); }
public DispositionCode LoadFromReader(System.Data.IDataReader rdr) { return(new DispositionCode() { Id = rdr.GetInt32(rdr.GetOrdinal("DispositionCodeID")), Name = rdr.GetString(rdr.GetOrdinal("Name")) }); }
/// <summary> /// 直接从dataReader中读取第i列的值,如果值为空,则返回空串 /// </summary> /// <param name="dataReader">要读取数据的dataReader</param> /// <param name="i">dataReader中的列索引</param> /// <returns></returns> public static string GetString(System.Data.IDataReader dataReader, int i) { if (dataReader.IsDBNull(i)) { return(null); } return(dataReader.GetString(i)); }
public LectureDetailItem MapRow(System.Data.IDataReader reader, int rowNum) { LectureDetailItem lectureDetail = new LectureDetailItem(); lectureDetail.Id = reader.GetInt32(reader.GetOrdinal("id")); lectureDetail.LectureCategoryId = reader.GetInt32(reader.GetOrdinal("lectureCategoryId")); lectureDetail.LectureTypeId = reader.GetInt32(reader.GetOrdinal("lectureTypeId")); lectureDetail.Name = reader.GetString(reader.GetOrdinal("name")); lectureDetail.Score = reader.GetString(reader.GetOrdinal("score")); lectureDetail.SectionId = reader.GetInt32(reader.GetOrdinal("sectionId")); lectureDetail.AccountId = reader.GetInt32(reader.GetOrdinal("accountId")); lectureDetail.Credit = reader.GetInt32(reader.GetOrdinal("credit")); lectureDetail.LectureCategoryName = reader.GetString(reader.GetOrdinal("lectureCategoryName")); lectureDetail.LectureTypeName = reader.GetString(reader.GetOrdinal("lectureTypeName")); lectureDetail.SectionName = reader.GetString(reader.GetOrdinal("sectionName")); return(lectureDetail); }
public LectureCategoryItem MapRow(System.Data.IDataReader reader, int rowNum) { LectureCategoryItem lectureCategory = new LectureCategoryItem(); lectureCategory.Id = reader.GetInt32(reader.GetOrdinal("id")); lectureCategory.Name = reader.GetString(reader.GetOrdinal("name")); return(lectureCategory); }
public AdmissionType LoadFromReader(System.Data.IDataReader rdr) { return(new AdmissionType() { Id = rdr.GetInt32(rdr.GetOrdinal("AdmissionTypeID")), Name = rdr.GetString(rdr.GetOrdinal("Name")) }); }
public Sex LoadFromReader(System.Data.IDataReader rdr) { return(new Sex() { Id = rdr.GetInt32(rdr.GetOrdinal("SexID")), Name = rdr.GetString(rdr.GetOrdinal("Name")) }); }
public PointOfOrigin LoadFromReader(System.Data.IDataReader rdr) { return(new PointOfOrigin() { Id = rdr.GetInt32(rdr.GetOrdinal("PointOfOriginID")), Name = rdr.GetString(rdr.GetOrdinal("Name")) }); }
private static hierarchy2b ORM_CreateProxy(System.Data.IDataReader result, System.Collections.Generic.IDictionary <string, int> ordinals) { return(new hierarchy2b() { pid = result.IsDBNull(ordinals["pid"]) ? 0 : result.GetInt64(ordinals["pid"]), fid = result.IsDBNull(ordinals["fid"]) ? 0 : result.GetInt64(ordinals["fid"]), textfield = result.IsDBNull(ordinals["textfield"]) ? null : result.GetString(ordinals["textfield"]) }); }
private CategorytypeofInfo getDataReader(iSqlDataReader dar) { try { int i = -1; CategorytypeofInfo info = new CategorytypeofInfo(); info.Code = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Note = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); return info; } catch (Exception ex) { throw ex; } }
private MenuInfo getDataReader(iSqlDataReader dar) { try { int i = -1; MenuInfo info = new MenuInfo(); info.Code = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Note = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Navigateurl = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Tooltip = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Attributes = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.ApplyAttributesChild = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Visible = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Cid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Orderd = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i); info.Iconex = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Pis = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Pid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Depth = dar.IsDBNull(++i) ? 1 : dar.GetInt32(i); info.Cataloguetypeofid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Catalogueid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Insertcatalogue = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Noroot = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); return info; } catch (Exception ex) { throw ex; } }
private Settingsite.MailServer getDataReader(iSqlDataReader dar) { try { int i = -1; Settingsite.MailServer info = new Settingsite.MailServer(); info.SMTPServer = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.SMTPPort = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.UseSSL = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Receiver = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Password = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); return info; } catch (Exception ex) { throw ex; } }
private LibrariesInfo getDataReader(iSqlDataReader dar) { try { int i = -1; LibrariesInfo info = new LibrariesInfo(); info.Code = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Introduce = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Description = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Filepreview = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Cid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Cname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Orderd = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i); info.Iconex = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Timecreate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Allowcomment = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Album = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Viewcounter = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Relateditem = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); return info; } catch (Exception ex) { throw ex; } }
private GeneralInfo getDataReader_com(iSqlDataReader dar) { try { int i = -1; GeneralInfo info = new GeneralInfo(); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); return info; } catch (Exception ex) { throw ex; } }
private FileattachInfo getDataReader(iSqlDataReader dar) { try { int i = -1; FileattachInfo info = new FileattachInfo(); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Path = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Note = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Subject = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Url = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Sized = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); info.Typed = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Orderd = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i); info.Iconex = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Belongto = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Iid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); return info; } catch (Exception ex) { throw ex; } }
private SymbolInfo getDataReader(iSqlDataReader dar) { try { int i = -1; SymbolInfo info = new SymbolInfo(); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Path = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Note = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Sized = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Status = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Orderd = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); return info; } catch (Exception ex) { throw ex; } }
private StaticcontentInfo getDataReader(iSqlDataReader dar) { try { int i = -1; StaticcontentInfo info = new StaticcontentInfo(); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Code = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Separatepage = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Filepath = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Description = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? -1 : dar.GetInt64(i); return info; } catch (Exception ex) { throw ex; } }
private RSSResourceInfo getDataReader(iSqlDataReader dar) { try { int i = -1; RSSResourceInfo info = new RSSResourceInfo(); info.Code = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.WebsiteUrl = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.RSSUrl = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Timelastestget = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Nodecontent = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Nodetitle = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Nodeintroduce = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Cid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Cname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Orderd = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i); info.Iconex = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); return info; } catch (Exception ex) { throw ex; } }
private ProductInfo getDataReader(iSqlDataReader dar) { try { int i = -1; ProductInfo info = new ProductInfo(); info.Code = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Introduce = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Description = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Features = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Filepreview = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Cid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Cname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Orderd = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i); info.Iconex = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Timecreate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Viewcounter = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Provider = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Advertise = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Price = dar.IsDBNull(++i) ? 0 : Math.Round(dar.GetFloat(i)); info.Pricealter = dar.IsDBNull(++i) ? 0 : Math.Round(dar.GetFloat(i), 2); info.Allowcomment = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Album = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Relateditem = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Relatednews = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); info.lCategory = (new CCategory(LANG)).Wcmm_Getlist_ofiid(info.Id, Webcmm.Id.Product); info.lCategoryattr = (new CCategoryattr(LANG)).Wcmm_Getlist_ofiid(info.Id, Webcmm.Id.Product); return info; } catch (Exception ex) { throw ex; } }
private CartInfo getDataReader(iSqlDataReader dar) { try { int i = -1; CartInfo info = new CartInfo(); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Timecomplete = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Lang = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Memberid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Membername = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Paymenttype = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Amount = dar.IsDBNull(++i) ? 0 : Math.Round(dar.GetFloat(i)); info.Shippingfee = dar.IsDBNull(++i) ? 0 : Math.Round(dar.GetFloat(i)); info.Discountfee = dar.IsDBNull(++i) ? 0 : Math.Round(dar.GetFloat(i)); info.Couponcode = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Checkout = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Note = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Shipping_Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Shipping_Address = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Shipping_Address2 = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Shipping_City = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Shipping_District = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Shipping_Nationalid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Shipping_Zipcode = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Shipping_Phone = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Shipping_Email = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Shipping_Nationalname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Billing_Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Billing_Address = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Billing_Address2 = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Billing_City = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Billing_District = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Billing_Nationalid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Billing_Zipcode = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Billing_Phone = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Billing_Email = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Billing_Nationalname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); return info; } catch (Exception ex) { throw ex; } }
private MeProfileInfo getDataReader(iSqlDataReader dar) { try { int i = -1; MeProfileInfo info = new MeProfileInfo(); info.Address = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Zipcode = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.State = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Nationalid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Nationalname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Cityid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Cityname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Districtid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Districtname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Phone = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.About = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Blog = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Homepage = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Facebook = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Twitter = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Youtube = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Flickr = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Skype = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Yahoo = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Birthday = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Profession = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); return info; } catch (Exception ex) { throw ex; } }
private CommentInfo getDataReader(iSqlDataReader dar) { try { int i = -1; CommentInfo info = new CommentInfo(); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Introduce = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Description = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Orderd = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i); info.Iconex = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Timecreate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Iid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Belongto = dar.IsDBNull(++i) ? 1 : dar.GetInt32(i); info.Viewcounter = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rating = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Sender_Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Sender_Address = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Sender_Email = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Sender_Phone = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); return info; } catch (Exception ex) { throw ex; } }
private FeedbackInfo getDataReader(iSqlDataReader dar) { try { int i = -1; FeedbackInfo info = new FeedbackInfo(); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Description = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Sender_Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Sender_Address = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Sender_Email = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Sender_Phone = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Pis = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Pid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Depth = dar.IsDBNull(++i) ? 1 : dar.GetInt32(i); info.Viewcounter = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); return info; } catch (Exception ex) { throw ex; } }
private UserInfo getDataReader(iSqlDataReader dar) { try { int i = -1; UserInfo info = new UserInfo(); info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Password = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Email = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Pis = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Pid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Depth = dar.IsDBNull(++i) ? 1 : dar.GetInt32(i); info.Logincache = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Loginfirst = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); if (info.iRight == null) info.iRight = (new CUserright()).Getinfo(info.Id); return info; } catch (Exception ex) { throw ex; } }
private BannerInfo getDataReader(iSqlDataReader dar) { try { int i = -1; BannerInfo info = new BannerInfo(); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Code = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Album = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Status = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); return info; } catch (Exception ex) { throw ex; } }
private UserrightInfo getDataReader(iSqlDataReader dar) { try { int i = -1; UserrightInfo info = new UserrightInfo(); info.R_new = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.R_upt = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.R_del = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.R_sys = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); return info; } catch (Exception ex) { throw ex; } }
private GeneralInfo getDataReader_search(iSqlDataReader dar) { try { int i = -1; GeneralInfo info = new GeneralInfo(); info.Code = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Introduce = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Description = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Filepreview = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Cid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Cname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Orderd = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i); info.Iconex = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); return info; } catch (Exception ex) { throw ex; } }
private VideoInfo getDataReader(iSqlDataReader dar) { try { int i = -1; VideoInfo info = new VideoInfo(); info.Code = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Description = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Tag = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Filepreview = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Cid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Cname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Orderd = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i); info.Iconex = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Timecreate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Allowcomment = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Viewcounter = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Sourcetype = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Url = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); info.lCategory = (new CCategory(LANG)).Wcmm_Getlist_ofiid(info.Id, Webcmm.Id.Video); info.lCategoryattr = (new CCategoryattr(LANG)).Wcmm_Getlist_ofiid(info.Id, Webcmm.Id.Video); return info; } catch (Exception ex) { throw ex; } }
private MeCreditcardInfo getDataReader(iSqlDataReader dar) { try { int i = -1; MeCreditcardInfo info = new MeCreditcardInfo(); info.Firstname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Lastname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Cardnumber = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Cardtype = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Expirationmonth = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Expirationyear = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Address = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.City = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.State = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Zipcode = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Memberid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Balance = dar.IsDBNull(++i) ? 0 : dar.GetFloat(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); return info; } catch (Exception ex) { throw ex; } }
private CartitemInfo getDataReader(iSqlDataReader dar) { try { int i = -1; CartitemInfo info = new CartitemInfo(); info.CartID = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.ProductID = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Productname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Quantity = dar.IsDBNull(++i) ? -1 : dar.GetInt32(i); info.Amount = dar.IsDBNull(++i) ? 0 : Math.Round(dar.GetFloat(i)); info.TemporaryID = dar.IsDBNull(++i) ? 0 : long.Parse(dar.GetValue(i).ToString()); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); return info; } catch (Exception ex) { throw ex; } }
private MemberInfo getDataReader(iSqlDataReader dar) { try { int i = -1; MemberInfo info = new MemberInfo(); info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Password = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Firstname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Lastname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Email = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.PIN = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Logincache = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Loginfirst = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Autosave = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Temporarycode = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Grouptype = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Filepreview = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Ranking = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Vote = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Ratingweight = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); info.iProfile = new CMeProfile(LANG).Getinfo(info.Id); return info; } catch (Exception ex) { throw ex; } }
private AccesscounterInfo getDataReader(iSqlDataReader dar) { try { int i = -1; AccesscounterInfo info = new AccesscounterInfo(); info.Name = dar.IsDBNull(++i) ? "" : dar.GetString(i); info.Counter = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); return info; } catch (Exception ex) { throw ex; } }
private CategoryattrInfo getDataReader(iSqlDataReader dar) { try { int i = -1; CategoryattrInfo info = new CategoryattrInfo(); info.Code = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Note = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Url = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Filepreview = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Cid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Orderd = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i); info.Iconex = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Pis = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Pid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Depth = dar.IsDBNull(++i) ? 1 : dar.GetInt32(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); return info; } catch (Exception ex) { throw ex; } }
private Settingsite.RestrictedPages getDataReader(iSqlDataReader dar) { try { int i = -1; Settingsite.RestrictedPages info = new Settingsite.RestrictedPages(); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Query = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.PathandQuery = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); return info; } catch (Exception ex) { throw ex; } }