本文整理汇总了C#中IDataReader.HasColumn方法的典型用法代码示例。如果您正苦于以下问题:C# IDataReader.HasColumn方法的具体用法?C# IDataReader.HasColumn怎么用?C# IDataReader.HasColumn使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IDataReader
的用法示例。
在下文中一共展示了IDataReader.HasColumn方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Insurance
public Insurance(IDataReader dbReader)
: this()
{
if (dbReader.HasColumn("InsuranceId") && dbReader["InsuranceId"] != DBNull.Value)
InsuranceId = (int)dbReader["InsuranceId"];
if (dbReader.HasColumn("CompanyId") && dbReader["CompanyId"] != DBNull.Value)
CompanyId = (int)dbReader["CompanyId"];
if (dbReader.HasColumn("InsuranceAddress") && dbReader["InsuranceAddress"] != DBNull.Value)
InsuranceAddress = (string)dbReader["InsuranceAddress"];
if (dbReader.HasColumn("InsuranceWebsite") && dbReader["InsuranceWebsite"] != DBNull.Value)
InsuranceWebsite = (string)dbReader["InsuranceWebsite"];
if (dbReader.HasColumn("InsurancePhone") && dbReader["InsurancePhone"] != DBNull.Value)
InsurancePhone = (string)dbReader["InsurancePhone"];
if (dbReader.HasColumn("InsuranceName") && dbReader["InsuranceName"] != DBNull.Value)
InsuranceName = (string)dbReader["InsuranceName"];
if (dbReader.HasColumn("CreatedBy") && dbReader["CreatedBy"] != DBNull.Value)
base.CreatedBy = (int)dbReader["CreatedBy"];
if (dbReader.HasColumn("UpdatedBy") && dbReader["UpdatedBy"] != DBNull.Value)
base.UpdatedBy = (int)dbReader["UpdatedBy"];
if (dbReader.HasColumn("DateCreated") && dbReader["DateCreated"] != DBNull.Value)
base.DateCreated = (DateTime)dbReader["DateCreated"];
if (dbReader.HasColumn("DateUpdated") && dbReader["DateUpdated"] != DBNull.Value)
base.DateUpdated = (DateTime)dbReader["DateUpdated"];
}
示例2: DashboardAppointment
public DashboardAppointment(IDataReader dbReader)
: this()
{
if (dbReader.HasColumn("DoctorName") && dbReader["DoctorName"] != DBNull.Value)
DoctorName = (string)dbReader["DoctorName"];
if (dbReader.HasColumn("TotalAppointment") && dbReader["TotalAppointment"] != DBNull.Value)
NoOfAppointments = Convert.ToInt32(dbReader["TotalAppointment"]);
}
示例3: ProfessionalSchedule
public ProfessionalSchedule(IDataReader dbReader)
: this()
{
if (dbReader.HasColumn("ProfessionalScheduleId") && dbReader["ProfessionalScheduleId"] != DBNull.Value)
ProfessionalScheduleId = (int)dbReader["ProfessionalScheduleId"];
if (dbReader.HasColumn("ProfessionalId") && dbReader["ProfessionalId"] != DBNull.Value)
ProfessionalId = (int)dbReader["ProfessionalId"];
if (dbReader.HasColumn("StartTime") && dbReader["StartTime"] != DBNull.Value)
StartTime = (DateTime)dbReader["StartTime"];
if (dbReader.HasColumn("EndTime") && dbReader["EndTime"] != DBNull.Value)
EndTime = (DateTime)dbReader["EndTime"];
if (dbReader.HasColumn("TimeIntervalMinutes") && dbReader["TimeIntervalMinutes"] != DBNull.Value)
TimeIntervalMinutes = Convert.ToInt16(dbReader["TimeIntervalMinutes"]);
if (dbReader.HasColumn("CreatedBy") && dbReader["CreatedBy"] != DBNull.Value)
base.CreatedBy = (int)dbReader["CreatedBy"];
if (dbReader.HasColumn("UpdatedBy") && dbReader["UpdatedBy"] != DBNull.Value)
base.UpdatedBy = (int)dbReader["UpdatedBy"];
if (dbReader.HasColumn("DateCreated") && dbReader["DateCreated"] != DBNull.Value)
base.DateCreated = (DateTime)dbReader["DateCreated"];
if (dbReader.HasColumn("DateUpdated") && dbReader["DateUpdated"] != DBNull.Value)
base.DateUpdated = (DateTime)dbReader["DateUpdated"];
}
示例4: Role
public Role(IDataReader dbReader)
: this()
{
if (dbReader.HasColumn("RoleId") && dbReader["RoleId"] != DBNull.Value)
RoleId = (int)dbReader["RoleId"];
if (dbReader.HasColumn("CompanyId") && dbReader["CompanyId"] != DBNull.Value)
CompanyId = (int)dbReader["ProfessionalId"];
if (dbReader.HasColumn("RoleName") && dbReader["RoleName"] != DBNull.Value)
RoleName = (string)dbReader["RoleName"];
}
示例5: StatusType
public StatusType(IDataReader dbReader)
: this()
{
if (dbReader.HasColumn("StatusId") && dbReader["StatusId"] != DBNull.Value)
StatusId = (int)dbReader["StatusId"];
if (dbReader.HasColumn("StatusDesc") && dbReader["StatusDesc"] != DBNull.Value)
StatusDesc = (string)dbReader["StatusDesc"];
if (dbReader.HasColumn("CompanyId") && dbReader["CompanyId"] != DBNull.Value)
CompanyId = (int)dbReader["CompanyId"];
}
示例6: Invoice
public Invoice(IDataReader dbReader)
{
if (dbReader.HasColumn("FirstName") && dbReader["FirstName"] != DBNull.Value) FirstName = dbReader["FirstName"].ToString();
if (dbReader.HasColumn("LastName") && dbReader["LastName"] != DBNull.Value) LastName = dbReader["LastName"].ToString();
if (dbReader.HasColumn("ProjectName") && dbReader["ProjectName"] != DBNull.Value) ProjectName = dbReader["ProjectName"].ToString();
if (dbReader.HasColumn("TaskName") && dbReader["TaskName"] != DBNull.Value) TaskName = dbReader["TaskName"].ToString();
if (dbReader.HasColumn("WorkDate") && dbReader["WorkDate"] != DBNull.Value) WorkDate = Convert.ToDateTime(dbReader["WorkDate"]).ToShortDateString();
if (dbReader.HasColumn("HoursWorked") && dbReader["HoursWorked"] != DBNull.Value) HoursWorked = Convert.ToInt32(dbReader["HoursWorked"].ToString());
if (dbReader.HasColumn("WorkDescription") && dbReader["WorkDescription"] != DBNull.Value) Description = dbReader["WorkDescription"].ToString();
if (dbReader.HasColumn("ChargeRate") && dbReader["ChargeRate"] != DBNull.Value) ChargeRate = dbReader["ChargeRate"].ToString();
if (dbReader.HasColumn("Total") && dbReader["Total"] != DBNull.Value) TotalAmount = dbReader["Total"].ToString();
if (dbReader.HasColumn("TimeID") && dbReader["TimeID"] != DBNull.Value) InvoiceID = dbReader["TimeID"].ToString();
}
示例7: Module
public Module(IDataReader dbReader)
: base()
{
if (dbReader.HasColumn("ModuleId") && dbReader["ModuleId"] != DBNull.Value)
ModuleId = (int)dbReader["ModuleId"];
if (dbReader.HasColumn("ModuleName") && dbReader["ModuleName"] != DBNull.Value)
ModuleName = (string)dbReader["ModuleName"];
if (dbReader.HasColumn("ModuleDescription") && dbReader["ModuleDescription"] != DBNull.Value)
ModuleDescription = (string)dbReader["ModuleDescription"];
if (dbReader.HasColumn("DisplayOrder") && dbReader["DisplayOrder"] != DBNull.Value)
DisplayOrder = (int)dbReader["DisplayOrder"];
if (dbReader.HasColumn("ModuleURL") && dbReader["ModuleURL"] != DBNull.Value)
ModuleURL = (string)dbReader["ModuleURL"];
if (dbReader.HasColumn("IsForAll") && dbReader["IsForAll"] != DBNull.Value)
IsForAll = (bool)dbReader["IsForAll"];
if (dbReader.HasColumn("ParentId") && dbReader["ParentId"] != DBNull.Value)
ParentId = (int)dbReader["ParentId"];
if (dbReader.HasColumn("IconName") && dbReader["IconName"] != DBNull.Value)
IconName = (string)dbReader["IconName"];
}
示例8: HeartbeatParams
public HeartbeatParams(IDataReader dbReader,string callType)
{
if(callType=="users")
{
if (dbReader.HasColumn("WorkerID") && dbReader["WorkerID"] != DBNull.Value) ParamValue = dbReader["WorkerID"].ToString();
if (dbReader.HasColumn("Name") && dbReader["Name"] != DBNull.Value) ParamName = dbReader["Name"].ToString();
}
if (callType == "tasks")
{
if (dbReader.HasColumn("TaskID") && dbReader["TaskID"] != DBNull.Value) ParamValue = dbReader["TaskID"].ToString();
if (dbReader.HasColumn("TaskName") && dbReader["TaskName"] != DBNull.Value) ParamName = dbReader["TaskName"].ToString();
}
}
示例9: ConfigValues
public ConfigValues(IDataReader dbReader)
: this()
{
if (dbReader.HasColumn("ControlItemKey") && dbReader["ControlItemKey"] != DBNull.Value)
ControlItemKey = (string)dbReader["ControlItemKey"];
if (dbReader.HasColumn("ControlItemValue") && dbReader["ControlItemValue"] != DBNull.Value)
ControlItemValue = (string)dbReader["ControlItemValue"];
if (dbReader.HasColumn("ControlItemText") && dbReader["ControlItemText"] != DBNull.Value)
ControlItemText = (string)dbReader["ControlItemText"];
if (dbReader.HasColumn("ControlItemOrder") && dbReader["ControlItemOrder"] != DBNull.Value)
ControlItemOrder = (float)dbReader["ControlItemOrder"];
if (dbReader.HasColumn("OtherText") && dbReader["OtherText"] != DBNull.Value)
OtherText = (string)dbReader["OtherText"];
}
示例10: DataReader2ShapefileGroup
public static ShapefileGroup DataReader2ShapefileGroup(IDataReader reader)
{
if (!reader.HasColumn("shapefilegroup_id")) return null;
return new ShapefileGroup
{
ID = (int)reader["shapefilegroup_id"],
Name = (string)reader["shapefilegroup_name"]
};
}
示例11: DataReader2Configuration
public static Configuration DataReader2Configuration(IDataReader reader)
{
if (!reader.HasColumn("configuration_id")) return null;
return new Configuration
{
ID = (int)reader["configuration_id"],
GeoLevel = (string)reader["configuration_geolevel"],
Shapefile = DataReader2Shapefile(reader)
};
}
示例12: DataReader2Provider
public static Provider DataReader2Provider(IDataReader reader)
{
if (!reader.HasColumn("provider_id")) return null;
return new Provider
{
ID = (int)reader["provider_id"],
Name = (string)reader["provider_name"],
NameAbbr = (string)reader["provider_nameabbr"],
ServiceURL = (string)reader["provider_serviceurl"],
URL = (string)reader["provider_url"]
};
}
示例13: DataReader2SubTheme
public static SubTheme DataReader2SubTheme(IDataReader reader)
{
if (!reader.HasColumn("subtheme_id")) return null;
return new SubTheme
{
ID = (int)reader["subtheme_id"],
Name = (string)reader["subtheme_name"],
NameAbbr = (string)reader["subtheme_nameabbr"],
ProviderID = (int)reader["provider_id"],
ThemeID = (int)reader["theme_id"]
};
}
示例14: UserProfile
public UserProfile(IDataReader dbReader)
: this()
{
if (dbReader["CompanyId"] != DBNull.Value) CompanyId = (int)dbReader["CompanyId"];
if (dbReader["UserName"] != DBNull.Value) UserName = (string)dbReader["UserName"];
if (dbReader["FirstName"] != DBNull.Value) FirstName = (string)dbReader["FirstName"];
if (dbReader["LastName"] != DBNull.Value) LastName = (string)dbReader["LastName"];
if (dbReader["Email"] != DBNull.Value) Email = (string)dbReader["Email"];
if (dbReader["UserId"] != DBNull.Value) UserId = (int)dbReader["UserId"];
if (dbReader["Password"] != DBNull.Value) Password = (string)dbReader["Password"];
if (dbReader["RoleId"] != DBNull.Value) RoleId = (int)dbReader["RoleId"];
if (dbReader.HasColumn("RoleName") && dbReader["RoleName"] != DBNull.Value) RoleName = (string)dbReader["RoleName"];
}
示例15: DataReader2Shapefile
public static Shapefile DataReader2Shapefile(IDataReader reader)
{
if (!reader.HasColumn("shapefile_id")) return null;
return new Shapefile
{
Group = DataReader2ShapefileGroup(reader),
ID = (int)reader["shapefile_id"],
Level = (int)reader["shapefile_level"],
Name = (string)reader["shapefile_name"],
Path = (string)reader["shapefile_path"],
FileName = (string)reader["shapefile_filename"]
};
}