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