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