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;
}
}
/// <summary>
/// 直接从dataReader中读取第i列的日期值，如果值为空，则返回DateTime.MinValue
/// </summary>
/// <param name="dataReader">要从中读取数据的dataReader</param>
/// <param name="i">dataReader中的列索引</param>
/// <returns></returns>
public static DateTime GetDateTime(System.Data.IDataReader dataReader, int i)
{
if (dataReader.IsDBNull(i))
{
return(DateTime.MinValue);
}
return(dataReader.GetDateTime(i));
}
/// <summary>
/// 直接从dataReader中读取第i列的日期值，如果值为空，则返回DateTime.MinValue
/// </summary>
/// <param name="dataReader">要从中读取数据的dataReader</param>
/// <param name="i">dataReader中的列索引</param>
/// <returns></returns>
public static DateTime?GetDateTimeNullable(System.Data.IDataReader dataReader, int i)
{
if (dataReader.IsDBNull(i))
{
return(null);
}
return(dataReader.GetDateTime(i));
}
private static T_Entity DataReader2Entity(System.Data.IDataReader dataReader)
{
T_Entity obj = new T_Entity
{
FLong = dataReader.GetInt64(0),
FString = dataReader.GetString(1),
FDecimal = dataReader.GetDecimal(2),
FNullDecimal = dataReader.IsDBNull(3) ? default(decimal?) : dataReader.GetDecimal(3),
FBool = dataReader.GetBoolean(4),
FNullBool = dataReader.IsDBNull(5) ? default(bool?) : dataReader.GetBoolean(5),
Status = (EntityStatus)Enum.ToObject(_entityStatusType, dataReader.GetInt16(7)),
NullStatus = dataReader.IsDBNull(8) ? default(EntityStatus?) : (EntityStatus)Enum.ToObject(_entityStatusType, dataReader.GetInt16(8)),
CreationTime = dataReader.GetDateTime(9),
LastUpdateTime = dataReader.IsDBNull(10) ? default(DateTime?) : dataReader.GetDateTime(10),
};
return(obj);
}
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()
});
}
public static DateTime GetDateTime(System.Data.IDataReader rdr, string Column, DateTime NullValue)
{
if (rdr[Column] != DBNull.Value)
{
return(rdr.GetDateTime(rdr.GetOrdinal(Column)));
}
else
{
return(NullValue);
}
}
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))
});
}
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.GetGuid(0);
Name = childData.GetString(1);
LastChanged = childData.GetDateTime(2);
// 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
}
//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);
ConstrainedValueListId = childData.GetGuid(1);
Value = childData.GetString(2);
Description = childData.GetString(3);
Ordinal = childData.GetInt32(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
}
//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
}
//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);
// Then call the Schema to get other information
TypeName = HIS.Library.Common.HISSchema.GetTypeName(TypeId);
Characteristics = HIS.Library.Common.HISSchema.GetTypeCharacteristics(TypeId);
Version = HIS.Library.Common.HISSchema.GetTypeVersion(TypeId);
MarkOld();
#if TRACE
PLLog.Trace("End", PLLOG_APPNAME, CLASS_BASE_ERRORNUMBER + 3, startTicks);
#endif
}
//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);
TypeId = childData.GetGuid(1);
AttributeId = childData.GetGuid(2);
Characteristics = childData.GetInt32(3);
DataTypeId = childData.GetInt32(4);
Version = childData.GetInt32(5);
Description = childData.GetString(6);
LastChanged = childData.GetDateTime(7);
// 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
}
private static T_Entity DataReader2Entity_GetValue(System.Data.IDataReader dataReader)
{
var FNullDecimal = dataReader.GetValue(3);
var FNullBool = dataReader.GetValue(5);
var NullStatus = dataReader.GetValue(8);
var LastUpdateTime = dataReader.GetValue(10);
T_Entity obj = new T_Entity
{
FLong = dataReader.GetInt64(0),
FString = dataReader.GetString(1),
FDecimal = dataReader.GetDecimal(2),
FNullDecimal = FNullDecimal == DBNull.Value ? default(decimal?) : (decimal)FNullDecimal,
FBool = dataReader.GetBoolean(4),
FNullBool = FNullBool == DBNull.Value ? default(bool?) : (bool)FNullBool,
Status = (EntityStatus)Enum.ToObject(_entityStatusType, dataReader.GetInt16(7)),
NullStatus = NullStatus == DBNull.Value ? default(EntityStatus?) : (EntityStatus)Enum.ToObject(_entityStatusType, NullStatus),
CreationTime = dataReader.GetDateTime(9),
LastUpdateTime = LastUpdateTime == DBNull.Value ? default(DateTime?) : (DateTime)LastUpdateTime,
};
return(obj);
}
public override DTOBase PopulateDTO(System.Data.IDataReader reader)
{
var credential = base.PopulateId(reader, new Credential());
if (!reader.IsDBNull(_ordinals.EmailAddress))
{
credential.EmailAddress = reader.GetString(_ordinals.EmailAddress);
}
if (!reader.IsDBNull(_ordinals.Salt))
{
credential.Salt = reader.GetString(_ordinals.Salt);
}
if (!reader.IsDBNull(_ordinals.PasswordHash))
{
credential.PasswordHash = reader.GetString(_ordinals.PasswordHash);
}
if (!reader.IsDBNull(_ordinals.CreateDateTimeUtc))
{
credential.CreateDateTimeUtc = reader.GetDateTime(_ordinals.CreateDateTimeUtc);
}
credential.IsNew = false;
return(credential);
}
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 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 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 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 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;
}
}
internal static Addressee getAddresseeFromReader(System.Data.IDataReader rdr, Dictionary <string, bool> columnTable)
{
Addressee addr = new Addressee();
if (columnTable["ADDRESSEE_ID"])
{
int idIndex = rdr.GetOrdinal("ADDRESSEE_ID");
if (!rdr.IsDBNull(idIndex))
{
addr.Id = Convert.ToInt32(rdr.GetDecimal(idIndex));
}
}
if (columnTable["ADDRESSEE_ROLE"])
{
int roleIndex = rdr.GetOrdinal("ADDRESSEE_ROLE");
if (!rdr.IsDBNull(roleIndex))
{
addr.Role = (AddresseeRoleEnum)Convert.ToInt32(rdr.GetDecimal(roleIndex));
}
}
if (columnTable["SECURE_MESSAGE_ID"])
{
int smIdIndex = rdr.GetOrdinal("SECURE_MESSAGE_ID");
if (!rdr.IsDBNull(smIdIndex))
{
addr.Message = new Message()
{
Id = Convert.ToInt32(rdr.GetDecimal(smIdIndex))
};
}
}
if (columnTable["USER_ID"])
{
int userIdIndex = rdr.GetOrdinal("USER_ID");
if (!rdr.IsDBNull(userIdIndex))
{
addr.Owner = new User()
{
Id = Convert.ToInt32(rdr.GetDecimal(userIdIndex))
};
}
}
if (columnTable["ADDROPLOCK"])
{
int oplockIndex = rdr.GetOrdinal("ADDROPLOCK");
if (!rdr.IsDBNull(oplockIndex))
{
addr.Oplock = Convert.ToInt32(rdr.GetDecimal(oplockIndex));
}
}
if (columnTable["FOLDER_ID"])
{
int folderIdIndex = rdr.GetOrdinal("FOLDER_ID");
if (!rdr.IsDBNull(folderIdIndex))
{
addr.FolderId = Convert.ToInt32(rdr.GetDecimal(folderIdIndex));
}
addr.Folder = Folder.getFolderFromReader(rdr);
}
if (columnTable["READ_DATE"])
{
int readDateIndex = rdr.GetOrdinal("READ_DATE");
if (!rdr.IsDBNull(readDateIndex))
{
addr.ReadDate = rdr.GetDateTime(readDateIndex);
}
}
if (columnTable["REMINDER_DATE"])
{
int reminderDateIndex = rdr.GetOrdinal("REMINDER_DATE");
if (!rdr.IsDBNull(reminderDateIndex))
{
addr.ReminderDate = rdr.GetDateTime(reminderDateIndex);
}
}
return(addr);
}
public void GenerateXlsxReport(System.Data.Common.DbConnection conn)
{
SetDbParams(conn);
using (ExcelPackage package = (templateFile != null ? new ExcelPackage(newFile, templateFile) : new ExcelPackage(newFile)))
{
foreach (var tab in def.tabs)
{
var ws = GetWs(package, tab);
var riadok = 1;
var stlpec = 1;
var start = 1;
// set start position for Label - that would be Global or Local
if (templateFile != null)
{
ExcelNamedRange label = null;
try
{
label = ws.Names["Label"];
}
catch
{
//Console.WriteLine("{0} Exception caught.", e);
try
{
label = package.Workbook.Names["Label"];
}
catch
{
SimpleLog.WriteLog("Label field not found in this workbook/template");
}
}
if (label != null)
{
riadok = label.Start.Row;
stlpec = label.Start.Column;
}
}
var nadpis = "";
if (!(tab.title == null || tab.title == ""))
{
if (tab.title.Trim().ToUpper().Substring(0, 6) == "SELECT")
{
nadpis = conn.QuerySingle <string>(tab.title, QuerryArguments(tab.title));
}
else
{
nadpis = tab.title;
}
}
// Main Select
// https://github.com/ericmend/oracleClientCore-2.0/blob/master/test/dotNetCore.Data.OracleClient.test/OracleClientCore.cs
System.Data.IDataReader reader = conn.ExecuteReader(tab.query, QuerryArguments(tab.query));
List <TableFields> rowConfig = GetDeclaration(reader, tab.fields);
outDef.tabs.Add(new Tab {
name = tab.name, title = tab.title, query = tab.query, fields = rowConfig
});
int r = 0;
int activeColCount = 0;
while (reader.Read())
{
r++;
//Initial section for sheet
if (r == 1)
{
if (nadpis != null && nadpis != "")
{
ws.Cells[riadok, stlpec].Value = nadpis;
if (templateFile == null)
{
using (ExcelRange rr = ws.Cells[riadok, stlpec, riadok, stlpec - 1 + rowConfig.Where(o => o.order != 0).Count()])
{
rr.Merge = true;
//rr.Style.Font.SetFromFont(new Font("Britannic Bold", 12, FontStyle.Italic));
rr.Style.Font.Size = 12;
rr.Style.Font.Bold = true;
rr.Style.Font.Color.SetColor(Color.FromArgb(63, 63, 63));
rr.Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.CenterContinuous;
rr.Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
//r.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(23, 55, 93));
rr.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(242, 242, 242));
}
}
riadok++;
}
// set Data position
if (templateFile != null)
{
ExcelNamedRange label = null;
try
{
label = ws.Names["Data"];
}
catch
{
try
{
label = package.Workbook.Names["Data"];
}
catch
{
SimpleLog.WriteLog("Data field not found in this workbook/template");
}
}
if (label != null)
{
riadok = label.Start.Row - 1; // Header je nad riadkom (above row)
stlpec = label.Start.Column;
}
}
//Add the headers
for (int i = 0; i < rowConfig.Count; i++)
{
if (rowConfig[i].order != 0)
{
activeColCount++;
if (templateFile == null || tab.printHeader)
{
ws.Cells[riadok, activeColCount + stlpec - 1].Value = rowConfig[i].title;
}
ws.Names.Add(rowConfig[i].name, ws.Cells[riadok, activeColCount + stlpec - 1]);
}
}
//Ok now format the values;
//ws.Cells[1, 1, 1, tab.fields.Count].Style.Font.Bold = true; //Font should be bold
//ws.Cells[1, 1, 1, tab.fields.Count].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
//ws.Cells[1, 1, 1, tab.fields.Count].Style.Fill.BackgroundColor.SetColor(Color.Aqua);
if (templateFile == null || tab.printHeader)
{
using (var range = ws.Cells[riadok, stlpec, riadok, activeColCount + stlpec - 1])
{
range.Style.Font.Color.SetColor(Color.White);
range.Style.Fill.PatternType = ExcelFillStyle.Solid;
//range.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(184, 204, 228));
range.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(79, 129, 189));
range.Style.Font.Bold = true;
range.Style.WrapText = true;
//Only need to grab the first cell of the merged range
//ws.Cells[$"A{row}"].Style.VerticalAlignment = ExcelVerticalAlignment.Center;
//ws.Cells[$"A{row}"].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
}
}
riadok++;
// set line for data
start = riadok;
}
//data section, FETCH RECORDS
for (int i = 0; i < rowConfig.Count(); i++)
{
var colId = rowConfig[i].colId;
if (rowConfig[i].order != 0 && !reader.IsDBNull(colId))
{
var a = reader.GetValue(colId);
switch (rowConfig[i].type)
{
case "String":
var pom = reader.GetString(colId);
ws.SetValue(riadok, rowConfig[i].order + stlpec - 1, pom.Substring(0, pom.Length /*- correctStringChars */));
break;
case "Integer":
ws.SetValue(riadok, rowConfig[i].order + stlpec - 1, reader.GetInt32(colId));
break;
case "DateTime":
ws.SetValue(riadok, rowConfig[i].order + stlpec - 1, reader.GetDateTime(colId));
break;
case "Date":
ws.SetValue(riadok, rowConfig[i].order + stlpec - 1, reader.GetDateTime(colId));
break;
case "Decimal":
ws.SetValue(riadok, rowConfig[i].order + stlpec - 1, reader.GetDecimal(colId));
break;
case "Byte[]":
ws.SetValue(riadok, rowConfig[i].order + stlpec - 1, reader.GetByte(colId));
break;
default:
ws.SetValue(riadok, rowConfig[i].order + stlpec - 1, reader.GetValue(colId).ToString());
break;
}
;
}
}
riadok++;
}
// no rows
if (r == 0)
{
if (nadpis != null)
{
ws.Cells[riadok, stlpec].Value = nadpis;
using (ExcelRange rr = ws.Cells[riadok, stlpec, riadok, 8 + stlpec])
{
rr.Merge = true;
rr.Style.Font.Size = 12;
rr.Style.Font.Bold = true;
rr.Style.Font.Color.SetColor(Color.FromArgb(63, 63, 63));
rr.Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.CenterContinuous;
rr.Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
rr.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(242, 242, 242));
}
riadok++;
}
ws.Cells[riadok, stlpec].Value = "No rows in querry result";
SimpleLog.WriteLog("No rows in Query from " + tab.name);
}
else
{
foreach (var row in rowConfig.Where(o => o.format != null && o.format != "auto"))
{
ws.Cells[start, row.order + stlpec - 1, riadok, row.order + stlpec - 1].Style.Numberformat.Format = row.format;
}
//ws.Cells[1, 1, Rows, 1].Style.Numberformat.Format = "#,##0";
//ws.Cells[1, 3, Rows, 3].Style.Numberformat.Format = "YYYY-MM-DD";
//ws.Cells[1, 4, Rows, 5].Style.Numberformat.Format = "#,##0.00";
// add comp fields
// worksheet.Cell(5, 2).Formula = string.Format("SUM({0}:{1})", calcStartAddress, calcEndAddress);
// Autofit
if (templateFile == null)
{
ws.Cells[start - 1, stlpec, riadok, activeColCount + stlpec - 1].AutoFitColumns();
foreach (var row in rowConfig.Where(o => o.order != 0))
{
if (ws.Column(row.order).Width < row.minsize)
{
ws.Column(row.order).Width = row.minsize;
}
}
}
//Create an autofilter(global settings) for the range
if (def.autofilter)
{
ws.Cells[start - 1, stlpec, riadok, activeColCount + stlpec - 1].AutoFilter = true;
}
}
if (enabledTimestamp && def.timestamp)
{
ws.Cells[riadok + 2, stlpec].Value = "Created : " + DateTime.Now.ToString("dd.MM.yyyy H:mm:ss");
}
}
package.Workbook.Calculate();
// Set document properties
package.Workbook.Properties.Comments = "Created with EpSqlGen Copyright © 2018 Miroslav Dubovsky";
package.Workbook.Properties.Created = DateTime.Now;
package.Workbook.Properties.Title = outFileName;
var pomProp = System.Configuration.ConfigurationManager.AppSettings.Get("Author");
if (pomProp != null)
{
package.Workbook.Properties.Author = pomProp;
}
pomProp = System.Configuration.ConfigurationManager.AppSettings.Get("Company");
if (pomProp != null)
{
package.Workbook.Properties.Company = pomProp;
}
if (def.version != null)
{
package.Workbook.Properties.Subject = "Template " + defFileName + ", version:" + def.version;
}
else
{
package.Workbook.Properties.Subject = "Template " + defFileName;
}
package.Save();
}
if (!enabledConsoleLog)
{
Console.Write(JsonConvert.SerializeObject(new { output_file = newFile.FullName }, Formatting.Indented));
}
else
{
SimpleLog.WriteLog("Generated file: " + newFile.FullName);
}
}
public static DateTime DateTime(System.Data.IDataReader reader, MapPoint mapPoint, DateTime defaultValue)
{
try
{
return(mapPoint.IsInResultSet() && !reader.IsDBNull(mapPoint.Index) ? reader.GetDateTime(mapPoint.Index) : defaultValue);
}
catch (Exception)
{
throw;
}
}
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;
}
}
public void SetFromReader <T>(T obj, System.Data.IDataReader reader, Action <T, string, object> setMethod)
where T : class
{
if (!reader.IsDBNull(this.Index))
{
switch (this.SqlType)
{
case System.Data.SqlDbType.BigInt:
setMethod(obj, FieldName, reader.GetInt64(this.Index));
break;
case System.Data.SqlDbType.Image:
case System.Data.SqlDbType.VarBinary:
case System.Data.SqlDbType.Binary:
long size = reader.GetBytes(this.Index, 0, null, 0, 0);
byte[] values = new byte[size];
int bufferSize = 1024;
long bytesRead = 0;
int curPos = 0;
while (bytesRead < size)
{
bytesRead += reader.GetBytes(this.Index, curPos, values, curPos, bufferSize);
curPos += bufferSize;
}
setMethod(obj, FieldName, values);
break;
case System.Data.SqlDbType.Bit:
setMethod(obj, FieldName, reader.GetBoolean(this.Index));
break;
case System.Data.SqlDbType.Char:
setMethod(obj, FieldName, reader.GetChar(this.Index));
break;
case System.Data.SqlDbType.SmallDateTime:
case System.Data.SqlDbType.Date:
case System.Data.SqlDbType.DateTime:
case System.Data.SqlDbType.DateTime2:
setMethod(obj, FieldName, reader.GetDateTime(this.Index));
break;
case System.Data.SqlDbType.SmallMoney:
case System.Data.SqlDbType.Money:
case System.Data.SqlDbType.Decimal:
setMethod(obj, FieldName, reader.GetDecimal(this.Index));
break;
case System.Data.SqlDbType.Float:
setMethod(obj, FieldName, reader.GetDouble(this.Index));
break;
case System.Data.SqlDbType.Int:
setMethod(obj, FieldName, reader.GetInt32(this.Index));
break;
case System.Data.SqlDbType.Text:
case System.Data.SqlDbType.NVarChar:
case System.Data.SqlDbType.NText:
case System.Data.SqlDbType.VarChar:
case System.Data.SqlDbType.NChar:
setMethod(obj, FieldName, reader.GetString(this.Index));
break;
case System.Data.SqlDbType.Real:
setMethod(obj, FieldName, reader.GetFloat(this.Index));
break;
case System.Data.SqlDbType.SmallInt:
setMethod(obj, FieldName, reader.GetInt16(this.Index));
break;
case System.Data.SqlDbType.TinyInt:
setMethod(obj, FieldName, reader.GetByte(this.Index));
break;
case System.Data.SqlDbType.UniqueIdentifier:
setMethod(obj, FieldName, reader.GetGuid(this.Index));
break;
default:
break;
}
}
else
{
setMethod(obj, FieldName, null);
}
}
private IList <AccountCatalogEntity> ReadCatalogEntities(System.Data.IDataReader dataReader)
{
IList <AccountCatalogEntity> tmpCatalogEntities = null;
if (dataReader != null)
{
tmpCatalogEntities = new List <AccountCatalogEntity>();
while (dataReader.Read())
{
var tmpCatalogEntity = new AccountCatalogEntity();
string tmpColumnName;
for (int index = 0; index < dataReader.FieldCount; index++)
{
if (dataReader.IsDBNull(index))
{
continue;
}
tmpColumnName = dataReader.GetName(index);
switch (tmpColumnName.ToLower())
{
case "catalogid":
tmpCatalogEntity.CatalogId = dataReader.GetInt32(index);
break;
case "name":
tmpCatalogEntity.Name = dataReader.GetString(index);
break;
case "parentid":
tmpCatalogEntity.ParentId = dataReader.GetInt32(index);
break;
case "depth":
tmpCatalogEntity.Depth = dataReader.GetInt32(index);
break;
case "orderno":
tmpCatalogEntity.Order = dataReader.GetInt32(index);
break;
case "versionno":
tmpCatalogEntity.VersionNo = dataReader.GetInt32(index);
break;
case "createtime":
tmpCatalogEntity.CreateTime = dataReader.GetDateTime(index);
break;
case "updatetime":
tmpCatalogEntity.UpdateTime = dataReader.GetDateTime(index);
break;
case "description":
tmpCatalogEntity.Description = dataReader.GetString(index);
break;
default:
break;
}
}
tmpCatalogEntities.Add(tmpCatalogEntity);
}
}
return(tmpCatalogEntities);
}
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;
}
}
public static DateTime AsDateTime(this System.Data.IDataReader reader, string name, DateTime defaultValue)
{
var o = reader[name];
return(o != null && o != DBNull.Value ? reader.GetDateTime(reader.GetOrdinal(name)) : defaultValue);
}
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 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 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 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 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 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 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 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 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;
}
}
System.DateTime System.Data.IDataRecord.GetDateTime(int i)
{
return(_dataReader.GetDateTime(i));
}
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;
}
}
internal static Message getMessageFromReader(System.Data.IDataReader rdr, Dictionary <string, bool> columnTable)
{
Message msg = new Message();
if (columnTable["SECURE_MESSAGE_ID"])
{
msg.Id = Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("SECURE_MESSAGE_ID")));
}
if (columnTable["CLINICIAN_STATUS"])
{
msg.Status = (domain.sm.enums.ClinicianStatusEnum)Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("CLINICIAN_STATUS")));
}
if (columnTable["COMPLETED_DATE"])
{
if (!rdr.IsDBNull(rdr.GetOrdinal("COMPLETED_DATE")))
{
msg.CompletedDate = rdr.GetDateTime(rdr.GetOrdinal("COMPLETED_DATE"));
}
}
if (columnTable["ASSIGNED_TO"])
{
if (!rdr.IsDBNull(rdr.GetOrdinal("ASSIGNED_TO")))
{
if (msg.AssignedTo == null)
{
msg.AssignedTo = new Clinician();
}
msg.AssignedTo.Id = Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("ASSIGNED_TO")));
}
}
if (columnTable["CHECKSUM"])
{
if (!rdr.IsDBNull(rdr.GetOrdinal("CHECKSUM")))
{
msg.Checksum = rdr.GetString(rdr.GetOrdinal("CHECKSUM"));
}
}
if (columnTable["THREAD_ID"])
{
if (msg.MessageThread == null)
{
msg.MessageThread = new Thread();
}
msg.MessageThread.Id = Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("THREAD_ID")));
}
if (columnTable["STATUS_SET_BY"])
{
if (!rdr.IsDBNull(rdr.GetOrdinal("STATUS_SET_BY")))
{
if (msg.StatusSetBy == null)
{
msg.StatusSetBy = new Clinician();
}
msg.StatusSetBy.Id = Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("STATUS_SET_BY")));
}
}
if (columnTable["SMOPLOCK"])
{
msg.Oplock = Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("SMOPLOCK")));
}
if (columnTable["ESCALATED"])
{
if (!rdr.IsDBNull(rdr.GetOrdinal("ESCALATED")))
{
msg.EscalatedDate = rdr.GetDateTime(rdr.GetOrdinal("ESCALATED"));
}
}
if (columnTable["BODY"])
{
msg.Body = rdr.GetString(rdr.GetOrdinal("BODY"));
}
if (columnTable["SENT_DATE"])
{
if (!rdr.IsDBNull(rdr.GetOrdinal("SENT_DATE")))
{
msg.SentDate = rdr.GetDateTime(rdr.GetOrdinal("SENT_DATE"));
}
}
if (columnTable["SENDER_TYPE"])
{
msg.SenderType = (domain.sm.enums.ParticipantTypeEnum)Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("SENDER_TYPE")));
}
if (columnTable["SENDER_ID"])
{
msg.SenderId = Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("SENDER_ID")));
}
if (columnTable["SENDER_NAME"])
{
msg.SenderName = rdr.GetString(rdr.GetOrdinal("SENDER_NAME"));
}
if (columnTable["RECIPIENT_TYPE"])
{
if (!rdr.IsDBNull(rdr.GetOrdinal("RECIPIENT_TYPE")))
{
msg.RecipientType = (domain.sm.enums.ParticipantTypeEnum)Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("RECIPIENT_TYPE")));
}
}
if (columnTable["RECIPIENT_ID"])
{
if (!rdr.IsDBNull(rdr.GetOrdinal("RECIPIENT_ID")))
{
msg.RecipientId = Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("RECIPIENT_ID")));
}
}
if (columnTable["RECIPIENT_NAME"])
{
if (!rdr.IsDBNull(rdr.GetOrdinal("RECIPIENT_NAME")))
{
msg.RecipientName = rdr.GetString(rdr.GetOrdinal("RECIPIENT_NAME"));
}
}
if (columnTable["SENT_DATE_LOCAL"])
{
if (!rdr.IsDBNull(rdr.GetOrdinal("SENT_DATE_LOCAL")))
{
msg.SentDateLocal = rdr.GetDateTime(rdr.GetOrdinal("SENT_DATE_LOCAL"));
}
}
if (columnTable["ESCALATION_NOTIFICATION_DATE"])
{
if (!rdr.IsDBNull(rdr.GetOrdinal("ESCALATION_NOTIFICATION_DATE")))
{
msg.EscalationNotificationDate = rdr.GetDateTime(rdr.GetOrdinal("ESCALATION_NOTIFICATION_DATE"));
}
}
if (columnTable["ESCALATION_NOTIFICATION_TRIES"])
{
if (!rdr.IsDBNull(rdr.GetOrdinal("ESCALATION_NOTIFICATION_TRIES")))
{
msg.EscalationNotificationTries = Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("ESCALATION_NOTIFICATION_TRIES")));
}
}
if (columnTable["READ_RECEIPT"])
{
if (!rdr.IsDBNull(rdr.GetOrdinal("READ_RECEIPT")))
{
msg.ReadReceipt = rdr.GetString(rdr.GetOrdinal("READ_RECEIPT"));
}
}
if (columnTable["HAS_ATTACHMENT"])
{
if (!rdr.IsDBNull(rdr.GetOrdinal("HAS_ATTACHMENT")))
{
msg.Attachment = Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("HAS_ATTACHMENT"))) == 1;
}
}
if (columnTable["ATTACHMENT_ID"])
{
if (!rdr.IsDBNull(rdr.GetOrdinal("ATTACHMENT_ID")))
{
msg.AttachmentId = Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("ATTACHMENT_ID")));
}
}
return(msg);
}
public static DateTime?GetDateTime(System.Data.IDataReader rdr, string Column)
{
return(rdr [Column] != DBNull.Value ? (DateTime?)rdr.GetDateTime(rdr.GetOrdinal(Column)) : null);
}
