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; }
/// <summary> /// Gets the active users. /// </summary> /// <returns>The active users.</returns> public static NameValueCollection GetActiveUsers(IfyContext context, string startdate, string enddate, string skipids, string allowedids) { var ids = new NameValueCollection(); int activeThreshold = context.GetConfigIntegerValue("report-activeUsers-threshold"); string sql = string.Format("SELECT usr.id,usr.level FROM usr WHERE " + "id IN (SELECT id_usr FROM usrsession{0} GROUP BY id_usr HAVING COUNT(*) > {1}){2}{3};", !string.IsNullOrEmpty(startdate) && !string.IsNullOrEmpty(enddate) ? " WHERE usrsession.log_time >= '" + startdate + "' AND usrsession.log_time <= '" + enddate + "'" : "", activeThreshold, string.IsNullOrEmpty(skipids) ? "" : " AND id NOT IN (" + skipids + ")", string.IsNullOrEmpty(allowedids) ? "" : " AND id IN (" + allowedids + ")"); context.LogDebug(context, "GetActiveUsers (SQL) : " + sql); System.Data.IDbConnection dbConnection = context.GetDbConnection(); System.Data.IDataReader reader = context.GetQueryResult(sql, dbConnection); while (reader.Read()) { if (reader.GetValue(0) != DBNull.Value) { var id = reader.GetInt32(0); var level = reader.GetInt32(1); ids.Set(id + "", level + ""); } } context.CloseQueryResult(reader, dbConnection); return(ids); }
public ScoreRequirementItem MapRow(System.Data.IDataReader reader, int rowNum) { ScoreRequirementItem scoreRequirement = new ScoreRequirementItem(); scoreRequirement.AccountId = reader.GetInt32(reader.GetOrdinal("accountId")); scoreRequirement.Cutline = reader.GetInt32(reader.GetOrdinal("cutline")); scoreRequirement.Id = reader.GetInt32(reader.GetOrdinal("id")); return(scoreRequirement); }
public SectionItem MapRow(System.Data.IDataReader reader, int rowNum) { SectionItem section = new SectionItem(); section.Id = reader.GetInt32(reader.GetOrdinal("id")); section.LectureTypeId = reader.GetInt32(reader.GetOrdinal("lectureTypeId")); section.Name = reader.GetString(reader.GetOrdinal("name")); return(section); }
public LectureTypeItem MapRow(System.Data.IDataReader reader, int rowNum) { LectureTypeItem lectureType = new LectureTypeItem(); lectureType.Id = reader.GetInt32(reader.GetOrdinal("id")); lectureType.LectureCategoryId = reader.GetInt32(reader.GetOrdinal("lectureCategoryId")); lectureType.Name = reader.GetString(reader.GetOrdinal("name")); return(lectureType); }
public SectionRequirementItem MapRow(System.Data.IDataReader reader, int rowNum) { SectionRequirementItem sectionRequirement = new SectionRequirementItem(); sectionRequirement.Id = reader.GetInt32(reader.GetOrdinal("id")); sectionRequirement.LectureTypeId = reader.GetInt32(reader.GetOrdinal("lectureTypeId")); sectionRequirement.AccountId = reader.GetInt32(reader.GetOrdinal("accountId")); sectionRequirement.Cutline = reader.GetInt32(reader.GetOrdinal("Cutline")); return(sectionRequirement); }
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 LectureCategoryRequirementItem MapRow(System.Data.IDataReader reader, int rowNum) { LectureCategoryRequirementItem lectureCategoryRequirement = new LectureCategoryRequirementItem(); lectureCategoryRequirement.Id = reader.GetInt32(reader.GetOrdinal("id")); lectureCategoryRequirement.AccountId = reader.GetInt32(reader.GetOrdinal("accountId")); lectureCategoryRequirement.LectureCategoryId = reader.GetInt32(reader.GetOrdinal("lectureCategoryId")); lectureCategoryRequirement.LectureCategoryName = reader.GetString(reader.GetOrdinal("lectureCategoryName")); lectureCategoryRequirement.Cutline = reader.GetInt32(reader.GetOrdinal("cutline")); return(lectureCategoryRequirement); }
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)); }
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"]); }
internal int createPlayerID(string udid) { Debug.Log("createPlayerID"); openConnection(); int playerid = -1; System.Text.StringBuilder sbSQLInsert = new System.Text.StringBuilder(); sbSQLInsert.Append("INSERT OR IGNORE INTO player (udid) VALUES ( '").Append(udid).Append("' )"); db.BasicQuery(sbSQLInsert.ToString()); //inserts System.Text.StringBuilder sbSQLSelect = new System.Text.StringBuilder(); sbSQLSelect.Append("SELECT playerid FROM player WHERE udid='").Append(udid).Append("'"); System.Data.IDataReader res = db.BasicQuery(sbSQLSelect.ToString()); //get the new playerid if (res.Read()) //got it, as expected { playerid = res.GetInt32(0); //FIRST TIME PLAYER } else { Debug.LogError("Failed to get playerid for udid just inserted. Very very odd, and evil."); } closeConnection(); return(playerid); }
// Saves game basics and returns the new gameid // XXX (kasiu): Probably unnecessarily complicated. internal int SaveGameBasics(string gamename) { int gameid = -1; DebugConsole.Log("Saving trace results."); openConnection(); System.Text.StringBuilder sbSQL = new System.Text.StringBuilder(); sbSQL.Append("INSERT INTO game(name,dAdded) VALUES(\""); // XXX (kasiu) Ignoring name column for now. sbSQL.Append(gamename).Append("\","); sbSQL.Append("CURRENT_TIMESTAMP").Append(")"); DebugConsole.Log(sbSQL.ToString()); System.Data.IDataReader res = this.db.BasicQuery(sbSQL.ToString()); // Retrieve the correct gameID using a name hack System.Text.StringBuilder sbSQL2 = new System.Text.StringBuilder(); sbSQL2.Append("SELECT gameid FROM game WHERE name == \"").Append(gamename).Append("\""); DebugConsole.Log(sbSQL2.ToString()); System.Data.IDataReader res2 = this.db.BasicQuery(sbSQL2.ToString()); if (res2.Read() && !res2.IsDBNull(0)) { gameid = res2.GetInt32(0); } // Finally, overwrite the name in the table System.Text.StringBuilder sbSQL3 = new System.Text.StringBuilder(); sbSQL3.Append("UPDATE game SET name = \"NONE\" WHERE name == \"").Append(gamename).Append("\""); DebugConsole.Log(sbSQL3.ToString()); System.Data.IDataReader res3 = this.db.BasicQuery(sbSQL3.ToString()); closeConnection(); return(gameid); }
//Marcar la tarea como completada public void CompleteTask() { //Eliminarla de la lista DeleteTask(); //Sumar 5 monedas por tarea completada int monedasActuales = PlayerPrefs.GetInt("Monedas"); PlayerPrefs.SetInt("Monedas", monedasActuales + 1); //Aumentar el numero de tareas completadas float tareasCompletadas = PlayerPrefs.GetFloat("TareasCompletadas"); PlayerPrefs.SetFloat("TareasCompletadas", tareasCompletadas + 1); //Recuperar de la bd tareas almacenadas hoy EstadisticasDB estadisticasDB = new EstadisticasDB(); string fechaActual = DateTime.Today.Date.ToShortDateString(); int tareasGuardadas = 0; System.Data.IDataReader reader = estadisticasDB.BuscarTareasPorFecha(fechaActual); while (reader.Read()) { tareasGuardadas = reader.GetInt32(0); } //Sumar minutos y guardarlos tareasGuardadas++; estadisticasDB.GuardarTareasPorFecha(fechaActual, tareasGuardadas); estadisticasDB.close(); //Comprobar logro (id = 4) LogrosManager.ComprobarLogroCompletado(4); }
private List <int> GetExternalConnectionIds() { List <int> conIds = new List <int>(); string sql = "SELECT SqlConnectionId FROM durados_ExternaInstance WITH(NOLOCK) INNER JOIN durados_SqlConnection WITH(NOLOCK) on durados_SqlConnection.Id = durados_ExternaInstance.SqlConnectionId"; using (System.Data.IDbConnection cnn = Durados.DataAccess.DataAccessObject.GetNewConnection(SqlProduct.SqlServer, Maps.Instance.ConnectionString)) { using (DuradosCommand command = new DuradosCommand(GetSystemProduct())) { command.Connection = cnn; command.CommandText = sql; if (command.Connection.State == System.Data.ConnectionState.Closed) { try { command.Connection.Open(); } catch (Exception ex) { Maps.Instance.DuradosMap.Logger.Log("AppFactory", null, "GetExternalInstanceConnection", null, 1, "No connection to main database"); throw new Exception("No connection to main database", ex); } } System.Data.IDataReader reader = command.ExecuteReader(); while (reader.Read()) { conIds.Add(reader.GetInt32(reader.GetOrdinal("SqlConnectionId"))); } } } return(conIds); }
public void ReadData(System.Data.IDataReader reader) { try { if (reader.Read()) { _winno = (ushort)reader.GetInt32(0); _lossno = (ushort)reader.GetInt32(1); } else { SetFailure(); } } catch (Exception) { SetFailure(); } }
public Payer LoadFromReader(System.Data.IDataReader rdr) { return(new Payer() { Id = rdr.GetInt32(rdr.GetOrdinal("PayerID")), Name = rdr.GetString(rdr.GetOrdinal("Name")) }); }
/// <summary> /// 直接从dataReader中读取第i列的值,如果值为空,则返回Int.MinValue /// </summary> /// <param name="dataReader">要读取数据的dataReader</param> /// <param name="i">dataReader中的列索引</param> /// <returns></returns> public static int?GetInt32Nullable(System.Data.IDataReader dataReader, int i) { if (dataReader.IsDBNull(i)) { return(null); } return(dataReader.GetInt32(i)); }
//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 DispositionCode LoadFromReader(System.Data.IDataReader rdr) { return(new DispositionCode() { Id = rdr.GetInt32(rdr.GetOrdinal("DispositionCodeID")), Name = rdr.GetString(rdr.GetOrdinal("Name")) }); }
public AdmissionType LoadFromReader(System.Data.IDataReader rdr) { return(new AdmissionType() { Id = rdr.GetInt32(rdr.GetOrdinal("AdmissionTypeID")), 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")) }); }
public Race LoadFromReader(System.Data.IDataReader rdr) { return(new Race() { Id = rdr.GetInt32(rdr.GetOrdinal("RaceID")), Name = rdr.GetString(rdr.GetOrdinal("Name")) }); }
/// <summary> /// 直接从dataReader中读取第i列的值,如果值为空,则返回Int.MinValue /// </summary> /// <param name="dataReader">要读取数据的dataReader</param> /// <param name="i">dataReader中的列索引</param> /// <returns></returns> public static int GetInt32(System.Data.IDataReader dataReader, int i) { if (dataReader.IsDBNull(i)) { return(int.MinValue); } return(dataReader.GetInt32(i)); }
public Sex LoadFromReader(System.Data.IDataReader rdr) { return(new Sex() { Id = rdr.GetInt32(rdr.GetOrdinal("SexID")), Name = rdr.GetString(rdr.GetOrdinal("Name")) }); }
protected override Subject Create(System.Data.IDataReader reader) { return(new Subject { ID = reader.GetString(0), Name = reader.GetString(1), Semester = reader.GetInt32(2) }); }
protected virtual T PopulateId <T>(System.Data.IDataReader reader, T t) where T : DTOBase { if (!reader.IsDBNull(_ordinals.Id)) { t.Id = reader.GetInt32(_ordinals.Id); } return(t); }
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 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.GetGuid(0); Name = childData.GetString(1); Characteristics = childData.GetInt32(2); Version = childData.GetInt32(3); Description = childData.GetString(4); LastChanged = childData.GetDateTime(5); // 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 }
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 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 // First get the data from the retrieved record Id = childData.GetGuid(0); Name = childData.GetString(1); TypeId = childData.GetGuid(2); LastChanged = childData.GetDateTime(3); TypeName = childData.GetString(4); Characteristics = childData.GetInt32(5); Version = childData.GetInt32(6); MarkOld(); #if TRACE PLLog.Trace("End", PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 3, startTicks); #endif }
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_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 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 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 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 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 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 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 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 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 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 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 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 ItemcategoryattrInfo getDataReader(iSqlDataReader dar) { try { int i = -1; ItemcategoryattrInfo info = new ItemcategoryattrInfo(); info.Iid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Categoryid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Belongto = dar.IsDBNull(++i) ? 0 : dar.GetInt32(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 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 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 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 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 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 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; } }