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;
}
}