本文整理汇总了C#中CSS2.Models.SafeDataReader.GetDateTime方法的典型用法代码示例。如果您正苦于以下问题:C# SafeDataReader.GetDateTime方法的具体用法?C# SafeDataReader.GetDateTime怎么用?C# SafeDataReader.GetDateTime使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类CSS2.Models.SafeDataReader
的用法示例。
在下文中一共展示了SafeDataReader.GetDateTime方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: FetchDisbursementItemsByID
//Need to check
private DisbursementItem FetchDisbursementItemsByID(DisbursementItem SearchDisbursementItem, SafeDataReader dr)
{
SearchDisbursementItem.WorkOrderNumber = dr.GetString("WOCode").Trim();
SearchDisbursementItem.ClientNumber = dr.GetString("ClientName");
SearchDisbursementItem.ID = dr.GetInt32("ID");
SearchDisbursementItem.RefID = SearchDisbursementItem.ID;
SearchDisbursementItem.WOID = dr.GetInt32("WOID");
SearchDisbursementItem.Type = dr.GetString("DIType");
SearchDisbursementItem.Units = dr.GetInt32("Units");
SearchDisbursementItem.Code = dr.GetString("ItemCode");
SearchDisbursementItem.ItemNumber = dr.GetString("ItemNumber");
SearchDisbursementItem.Amount = dr.GetDecimal("Amount");
SearchDisbursementItem.Description = dr.GetString("Description");
SearchDisbursementItem.DateIncurred = dr.GetString("DateIncurred");
SearchDisbursementItem.VenderRefID = dr.GetString("VenderRefId");
SearchDisbursementItem.IsVerified = dr.GetBoolean("IsVerified");
SearchDisbursementItem.IsAdhoc = dr.GetBoolean("IsAdhoc");
SearchDisbursementItem.IsArchived = dr.GetBoolean("IsArchived");
SearchDisbursementItem.IsBilled = dr.GetBoolean("IsBilled");
SearchDisbursementItem.UnitPrice = dr.GetDecimal("UnitPrice");
SearchDisbursementItem.NeedVerification = dr.GetBoolean("NeedVerification");
SearchDisbursementItem.NoteCount = dr.GetInt32("NoteCount");
SearchDisbursementItem.NoteType = dr.GetString("NoteType");
SearchDisbursementItem.CreatedDate = dr.GetDateTime("CreatedDate").ToString("dd MMM yyyy hh:mm:ss tt");
SearchDisbursementItem.ACCPACStatus = dr.GetInt32("ACCPACStatus");
SearchDisbursementItem.ACCPACDescription = dr.GetString("ACCPACDescription");
SearchDisbursementItem.ACCPACExplanation = dr.GetString("Explaination");
SearchDisbursementItem.InvoiceNumber = dr.GetString("InvoiceNumber");
SearchDisbursementItem.IsMatched = dr.GetBoolean("IsMatched");
return SearchDisbursementItem;
}
示例2: FetchWOAGMDetails
private AGMDetails FetchWOAGMDetails(AGMDetails AGMDetails, SafeDataReader dr)
{
AGMDetails.ID = dr.GetInt32("ID");
AGMDetails.WOIDForWoAGM = dr.GetString("WOID");
AGMDetails.ROPlaceOfAGM = dr.GetBoolean("ROPlaceofAGM");
AGMDetails.DateOfAGM = dr.GetDateTime("DateofAGM").ToString("dd/MM/yyyy") == "01/01/0001" ? "" : dr.GetDateTime("DateofAGM").ToString("dd/MM/yyyy");
AGMDetails.TimeOfAGM = dr.GetString("TimeofAGM");
AGMDetails.FinancialYearEnd = dr.GetDateTime("FinancialYearEnd").ToString("dd/MM/yyyy") == "01/01/0001" ? "" : dr.GetDateTime("FinancialYearEnd").ToString("dd/MM/yyyy");
AGMDetails.DateOfFinancialStatement = dr.GetDateTime("DateofFinancialStatement").ToString("dd/MM/yyyy") == "01/01/0001" ? "" : dr.GetDateTime("DateofFinancialStatement").ToString("dd/MM/yyyy");
AGMDetails.IsAuditor = dr.GetBoolean("IsAuditor");
AGMDetails.Auditors = dr.GetInt32("Auditors");
AGMDetails.ShareHoldingStructure = dr.GetInt32("ShareHoldingStructure");
AGMDetails.IsDirectorsFeeAmount = dr.GetBoolean("IsDirectorsFeeAmount");
AGMDetails.DirectorFeeAmount = dr.GetString("DirectorFeeAmount");
AGMDetails.DirectorCurrency = dr.GetInt32("DirectorCurrency");
AGMDetails.IsRemunerationAmount = dr.GetBoolean("IsRemunerationAmount");
AGMDetails.RemunerationAmount = dr.GetString("RemunerationAmount");
AGMDetails.RemunerationCurrency = dr.GetInt32("RemunerationCurrency");
AGMDetails.MeetingNotice = dr.GetString("MeetingNotice");
AGMDetails.MeetingNoticeSource = dr.GetString("MeetingNoticeSource");
AGMDetails.MeetingMinutes = dr.GetString("MeetingMinutes");
AGMDetails.MeetingMinutesSource = dr.GetString("MeetingMinutesSource");
AGMDetails.OtherMeetingMinutes = dr.GetString("OtherMeetingMinutes");
AGMDetails.DesignationofPersonSigningAGM = dr.GetString("DesignationofPersonSigningAGM");
AGMDetails.S197Certificate = dr.GetString("S197Certificate");
AGMDetails.S197CertificateSource = dr.GetString("S197CertificateSource");
AGMDetails.IsS161toIssueShares = dr.GetBoolean("IsS161toIssueShares");
AGMDetails.S161NoticeofResolution = dr.GetString("S161NoticeofResolution");
AGMDetails.S161NoticeofResolutionSource = dr.GetString("S161NoticeofResolutionSource");
AGMDetails.DividentVoucher = dr.GetString("DividentVoucher");
AGMDetails.DividentVoucherSource = dr.GetString("DividentVoucherSource");
AGMDetails.IsDirectorsdueforRetirement = dr.GetBoolean("IsDirectorsdueforRetirement");
AGMDetails.IsDividend = dr.GetBoolean("IsDividend");
AGMDetails.Dividendpershare = dr.GetString("Dividendpershare");
AGMDetails.DividendCurrency = dr.GetInt32("DividendCurrency");
AGMDetails.TotalNetAmountofDividend = dr.GetString("TotalNetAmountofDividend");
AGMDetails.TotalNoOfShares = dr.GetString("TotalNoOfShares");
AGMDetails.ApprovalFS = dr.GetBoolean("IsApprovalFS");
AGMDetails.MeetingAddressLine1 = dr.GetString("MeetingAddressLine1");
AGMDetails.MeetingAddressLine2 = dr.GetString("MeetingAddressLine2");
AGMDetails.MeetingAddressLine3 = dr.GetString("MeetingAddressLine3");
AGMDetails.MeetingAddressCountry = dr.GetInt32("MeetingAddressCountry");
AGMDetails.MeetingAddressPostalCode = dr.GetString("MeetingAddressPostalCode");
return AGMDetails;
}
示例3: FetchCorporation
private Corporation FetchCorporation(Corporation Corporation, SafeDataReader dr)
{
Corporation.ID = dr.GetInt32("ID");
Corporation.NameOfCompany = dr.GetString("NameOfCompany");
Corporation.CountryOfIncorporation = dr.GetInt32("CountryOfIncorporation");
Corporation.CountryNameOfIncorp = dr.GetString("CountryNameOfIncorp");
Corporation.DateOfIncorporation = dr.GetDateTime("DateOfIncorporation").ToString("dd/MM/yyyy") == "01/01/0001" ? "" : dr.GetDateTime("DateOfIncorporation").ToString("dd/MM/yyyy");
Corporation.DateOfIncorporationList = Corporation.DateOfIncorporation == "" ? "" : dr.GetDateTime("DateOfIncorporation").ToString("dd MMM yyyy");
Corporation.RegistrationNo = dr.GetString("RegistrationNo");
Corporation.AccPacCode = dr.GetString("AccpacCode");
Corporation.AddressLine1 = dr.GetString("AddressLine1");
Corporation.AddressLine2 = dr.GetString("AddressLine2");
Corporation.AddressLine3 = dr.GetString("AddressLine3");
Corporation.Country = dr.GetInt32("Country");
Corporation.CountryName = dr.GetString("CountryName");
Corporation.PostalCode = dr.GetString("PostalCode");
Corporation.Email = dr.GetString("Email");
Corporation.ContactNo = dr.GetString("Phone");
Corporation.Fax = dr.GetString("Fax");
return Corporation;
}
示例4: FetchDisbursementItemsForSearch
//need to check
private DisbursementItem FetchDisbursementItemsForSearch(DisbursementItem SearchDisbursementItem, SafeDataReader dr)
{
SearchDisbursementItem.ID = dr.GetInt32("ID");
SearchDisbursementItem.RefID = SearchDisbursementItem.ID;
SearchDisbursementItem.WOID = dr.GetInt32("WOID");
SearchDisbursementItem.Code = dr.GetString("Code");
SearchDisbursementItem.ItemNumber = dr.GetString("ItemNumber");
SearchDisbursementItem.DiItemToolTip = dr.GetString("DIItemToolTip");
SearchDisbursementItem.Name = dr.GetString("Name");
SearchDisbursementItem.Units = dr.GetInt32("Units");
SearchDisbursementItem.ClientName = dr.GetString("ClientName");
SearchDisbursementItem.UnitPrice = dr.GetDecimal("UnitPrice");
SearchDisbursementItem.Amount = dr.GetDecimal("Amount");
SearchDisbursementItem.WorkOrderNumber = dr.GetString("WOCode").Trim();
//SearchDisbursementItem.Currency = dr.GetString("Currency");
SearchDisbursementItem.VenderRefID = dr.GetString("VenderRefId");
SearchDisbursementItem.DateIncurred = dr.GetString("DateIncurred");
SearchDisbursementItem.Description = dr.GetString("Description");
SearchDisbursementItem.NoteCount = dr.GetInt32("NoteCount");
SearchDisbursementItem.NoteType = dr.GetString("NoteType");
string toolTip = dr.GetString("Description");
if (toolTip.Contains("~^"))
{
toolTip = toolTip.Replace("~^", Environment.NewLine);
}
SearchDisbursementItem.DescriptionToolTip = toolTip;
int descLength = SearchDisbursementItem.Description.Length;
if (descLength > 10)
{
string strNewDesc = SearchDisbursementItem.Description.Substring(0, 10);
strNewDesc = strNewDesc + "...";
SearchDisbursementItem.Description = strNewDesc;
}
SearchDisbursementItem.ACCPACStatus = dr.GetInt32("ACCPACStatus");
SearchDisbursementItem.ACCPACDescription = dr.GetString("ACCPACDescription");
SearchDisbursementItem.ACCPACExplanation = dr.GetString("Explaination");
SearchDisbursementItem.IsAdhoc = dr.GetBoolean("IsAdhoc");
SearchDisbursementItem.IsArchived = dr.GetBoolean("IsArchived");
SearchDisbursementItem.IsBilled = dr.GetBoolean("IsBilled");
SearchDisbursementItem.IsVerified = dr.GetBoolean("IsVerified");
SearchDisbursementItem.CreatedDate = dr.GetDateTime("CreatedDate").ToString("dd MMM yyyy hh:mm:ss tt");
return SearchDisbursementItem;
}
示例5: FetchScheduleHistory
internal void FetchScheduleHistory(ScheduleHistory history, SafeDataReader dr)
{
history.Id = dr.GetInt32("Id");
history.ScheduleName = dr.GetString("ScheduleName");
history.Parameter = dr.GetString("Parameter");
history.ScheduleDescription = dr.GetString("ScheduleDescription");
history.RunbySystem = dr.GetString("RunbySystem");
history.LatRunOn = dr.GetDateTime("LatRunOn").ToString("dd MMM yyyy hh:mm:ss tt");
}
示例6: FetchBatchDetails
private static CABBatch FetchBatchDetails(CABBatch CABBatch, SafeDataReader dr)
{
CABBatch.ID = dr.GetInt32("ID");
CABBatch.Name = dr.GetString("Name");
CABBatch.BatchCode = dr.GetString("BatchType");
CABBatch.BatchID = dr.GetString("BatchID");
CABBatch.FromDate = dr.GetDateTime("FromDate").ToString("dd/MM/yyyy");
CABBatch.ToDate = dr.GetDateTime("ToDate").ToString("dd/MM/yyyy");
CABBatch.FromDateList = CABBatch.FromDate == "" ? "" : dr.GetDateTime("FromDate").ToString("dd MMM yyyy");
CABBatch.ToDateList = CABBatch.ToDate == "" ? "" : dr.GetDateTime("ToDate").ToString("dd MMM yyyy");
CABBatch.CreatedDate = dr.GetDateTime("CreatedDate").ToString("dd MMM yyyy hh:mm:ss tt"); ;
return CABBatch;
}
示例7: FetchCABMasterReport
internal static CABMaster FetchCABMasterReport(CABMaster CABMaster, SafeDataReader dr)
{
CABMaster.ID = dr.GetInt32("ID");
CABMaster.BillToClientCode = dr.GetInt32("BillToClientCode");
CABMaster.BillToSourceID = dr.GetString("BillToSourceID");
CABMaster.BillToName = dr.GetString("BillToName");
CABMaster.BillToAccpacCode = dr.GetString("BillToAccpacCode");
CABMaster.BillForClientCode = dr.GetInt32("BillForClientCode");
CABMaster.BillForSourceID = dr.GetString("BillForSourceID");
CABMaster.BillForName = dr.GetString("BillForName");
CABMaster.BillForAccpacCode = dr.GetString("BillForAccpacCode");
CABMaster.IsBillToThirdParty = dr.GetInt32("IsBillToThirdParty");
CABMaster.CreatedDate = dr.GetDateTime("CreatedDate").ToString("dd MMM yyyy hh:mm:ss tt"); ;
CABMaster.ISAdhoc = dr.GetBoolean("ISAdhoc");
CABMaster.Amount = dr.GetDecimal("Amount");
CABMaster.InvoiceNumber = dr.GetString("InvoiceNumber");
CABMaster.BillType = dr.GetString("BillType");
if (string.IsNullOrEmpty(CABMaster.InvoiceNumber))
CABMaster.IsInvoice = false;
else CABMaster.IsInvoice = true;
CABMaster.HSReceivedStatus = dr.GetInt32("HSReceivedStatus");
CABMaster.Description = dr.GetString("Description");
CABMaster.Explaination = dr.GetString("Explaination");
return CABMaster;
}
示例8: FetchCss1IntegrationErrors
internal void FetchCss1IntegrationErrors(Css1IntegrationErrors Css1IntegrationErrors, SafeDataReader dr)
{
Css1IntegrationErrors.ErrorNumber = dr.GetString("ErrorNumber");
Css1IntegrationErrors.ErrorMessage = dr.GetString("ErrorMessage");
Css1IntegrationErrors.ErrorState = dr.GetString("ErrorState");
Css1IntegrationErrors.ErrorProcedure = dr.GetString("ErrorProcedure");
Css1IntegrationErrors.ErrorLine = dr.GetString("ErrorLine");
Css1IntegrationErrors.Type = dr.GetString("Type");
Css1IntegrationErrors.CreatedOn = dr.GetDateTime("CreatedOn").ToString("dd MMM yyyy hh:mm:ss tt");
}
示例9: FetchCABFeeScheduleReportByMasterID
internal static CABFeeSchedule FetchCABFeeScheduleReportByMasterID(CABFeeSchedule CABFeeSchedule, SafeDataReader dr)
{
CABFeeSchedule.ID = dr.GetInt32("ID");
CABFeeSchedule.ClientCode = dr.GetString("ClientCode");
CABFeeSchedule.SourceID = dr.GetString("SourceID");
CABFeeSchedule.FeeCode = dr.GetString("FeeCode");
CABFeeSchedule.FromDate = dr.GetDateTime("FromDate").ToString("dd/MMM/yyyy");
CABFeeSchedule.ToDate = dr.GetDateTime("ToDate").ToString("dd/MMM/yyyy");
CABFeeSchedule.Amount = dr.GetDecimal("Amount");
CABFeeSchedule.IsArrear = dr.GetBoolean("IsArrear");
CABFeeSchedule.CreatedDate = dr.GetString("CreatedDate");
CABFeeSchedule.IsClubFee = dr.GetBoolean("IsClubFee");
CABFeeSchedule.IsClubFeeBillGenerated = dr.GetBoolean("IsClubFeeBillGenerated");
CABFeeSchedule.ClubFeeBillID = dr.GetInt32("ClubFeeBillID");
CABFeeSchedule.CABMasterID = dr.GetInt32("CABMasterID");
return CABFeeSchedule;
}
示例10: FetchCABFeeScheduleDetailsReportByCABFeeScheduleID
internal static CABFeeScheduleDetails FetchCABFeeScheduleDetailsReportByCABFeeScheduleID(CABFeeScheduleDetails CABFeeScheduleDetails, SafeDataReader dr)
{
CABFeeScheduleDetails.ID = dr.GetInt32("ID");
CABFeeScheduleDetails.ClientCode = dr.GetString("ClientCode");
CABFeeScheduleDetails.SourceID = dr.GetString("SourceID");
CABFeeScheduleDetails.FeeCode = dr.GetString("FeeCode");
CABFeeScheduleDetails.BilledFrom = dr.GetDateTime("BilledFrom").ToString("dd/MMM/yyyy"); ;
CABFeeScheduleDetails.BilledTo = dr.GetDateTime("BilledTo").ToString("dd/MMM/yyyy"); ;
CABFeeScheduleDetails.Amount = dr.GetDecimal("Amount");
CABFeeScheduleDetails.Prorate = dr.GetDecimal("Prorate");
CABFeeScheduleDetails.BillableAmount = dr.GetDecimal("BillableAmount");
CABFeeScheduleDetails.IsArrear = dr.GetBoolean("IsArrear");
CABFeeScheduleDetails.CreatedDate = dr.GetString("CreatedDate");
CABFeeScheduleDetails.CABFeeScheduleID = dr.GetInt32("CABFeeScheduleID");
return CABFeeScheduleDetails;
}
示例11: FetchFeeItemsByWOID
private WOFee FetchFeeItemsByWOID(WOFee Item, SafeDataReader dr)
{
Item.ID = dr.GetInt32("ID");
Item.WOCode = dr.GetString("WOCode");
Item.ClientName = dr.GetString("ClientName");
Item.ItemNumber = dr.GetString("ItemNumber");
Item.Code = dr.GetString("Code");
Item.Units = dr.GetInt32("Units");
Item.Amount = dr.GetDecimal("Amount");
Item.IsAdhoc = dr.GetBoolean("IsAdhoc");
Item.IsArchived = dr.GetBoolean("IsArchived");
Item.IsBilled = dr.GetBoolean("IsBilled");
Item.Description = dr.GetString("Description");
string toolTip = dr.GetString("Description");
if (toolTip.Contains("~^"))
{
toolTip = toolTip.Replace("~^", Environment.NewLine);
}
Item.FeeDescriptionToolTip = toolTip;
int descLength = Item.Description.Length;
if (descLength > 10)
{
string strNewDesc = Item.Description.Substring(0, 10);
strNewDesc = strNewDesc + "...";
Item.Description = strNewDesc;
}
Item.UnitPrice = dr.GetDecimal("UnitPrice");
Item.NoteCount = dr.GetInt32("NoteCount");
Item.NoteType = dr.GetString("NoteType");
Item.RefID = Item.ID;
Item.CreatedDate = dr.GetDateTime("CreatedDate").ToString("dd MMM yyyy hh:mm:ss tt");
Item.FeeItemToolTip = dr.GetString("FeeToolTip");
Item.ACCPACStatus = dr.GetInt32("ACCPACStatus");
Item.ACCPACDescription = dr.GetString("ACCPACDescription");
Item.ACCPACExplanation = dr.GetString("Explaination");
return Item;
}
示例12: FetchWODraftDetails
private Dashbord FetchWODraftDetails(Dashbord WorkOrderList, SafeDataReader dr)
{
WorkOrderList.WorkOrderID = dr.GetString("WOID");
WorkOrderList.WorkOrderTypeText = dr.GetString("Type");
WorkOrderList.Name = dr.GetString("ClientName");
WorkOrderList.CreatedBy = dr.GetString("CreatedBy");
WorkOrderList.UpdatedDate = dr.GetDateTime("UpdatedDate").ToString("dd MMM yyyy hh:mm:ss tt");
WorkOrderList.WOCode = dr.GetString("WO");
WorkOrderList.GroupCode = dr.GetString("GroupCode");
WorkOrderList.RefID = dr.GetInt32("WOID");
WorkOrderList.NoteCount = dr.GetInt32("NoteCount");
WorkOrderList.NoteType = dr.GetString("NoteType");
WorkOrderList.RowCount = dr.GetString("RowCount");
return WorkOrderList;
}
示例13: FetchAssignedWODetails
private Dashbord FetchAssignedWODetails(Dashbord WorkOrderList, SafeDataReader dr)
{
WorkOrderList.WorkOrderID = dr.GetString("WOID");
WorkOrderList.WorkOrderTypeText = dr.GetString("Type");
WorkOrderList.Name = dr.GetString("ClientName");
WorkOrderList.AssignedTo = dr.GetString("AssignedTo");
WorkOrderList.AssignedDate = dr.GetDateTime("AssignedDate").ToString("dd MMM yyyy hh:mm:ss tt");
WorkOrderList.WOCode = dr.GetString("WO");
WorkOrderList.GroupCode = dr.GetString("GroupCode");
WorkOrderList.RefID = dr.GetInt32("WOID");
WorkOrderList.NoteCount = dr.GetInt32("NoteCount");
WorkOrderList.NoteType = dr.GetString("NoteType");
WorkOrderList.ColorFlag = dr.GetString("ColorFlag");
WorkOrderList.RowCount = dr.GetString("RowCount");
return WorkOrderList;
}
示例14: FetchActiveUsers
internal void FetchActiveUsers(ActiveUsers user, SafeDataReader dr)
{
user.DisplayName = dr.GetString("DisplayName");
user.UserName = dr.GetString("UserName");
user.Roles = dr.GetString("Roles");
user.Login = dr.GetDateTime("Login").ToString("dd MMM yyyy hh:mm:ss tt");
user.Duration = dr.GetString("Duration");
user.Logout = (dr.GetDateTime("LogoutOn") == DateTime.MinValue) ? string.Empty : dr.GetDateTime("LogoutOn").ToString("dd MMM yyyy hh:mm:ss tt");
}
示例15: FetchClientScheduleGapInfo
public FeeSchedule FetchClientScheduleGapInfo(FeeSchedule getClientScheduleGapInfo, SafeDataReader dr)
{
getClientScheduleGapInfo.SNO = dr.GetInt32("new_id");
getClientScheduleGapInfo.FromDate = dr.GetDateTime("start_date").ToString("dd MMM yyyy");
getClientScheduleGapInfo.ToDate = dr.GetDateTime("end_date").ToString("dd MMM yyyy");
getClientScheduleGapInfo.Duration = dr.GetInt32("NoofDays");
return getClientScheduleGapInfo;
}