解决方案 »
- C#多线程打开word,load事件没有问题,线程有出问题
- 根据不同情况来决定是否执行主程序
- HttpWebRequest如何获取web页面中JavaScript变量的值
- c# progressBar 如何改成向上?
- iis6.0 能不能将一个网站配置为另一个网站的虚拟目录
- JAVA区看到的,我们也来讨论下
- 一个很奇怪的问题,列表和树控件里面的项,出现不了图标,怎么回事啊?
- 解读字符串吧,大家帮忙看看!
- 谁能告诉我为什么DataGrid中的记录删除不了??昨天搞了一天了
- 问一个数据库数据处理的问题
- 结上贴重问:ACCESS能允许多个线程同时读(select)或写(insert update)一个表吗?在线等
- 请教关于cookies写入的问题
我贴下代码吧,大家帮忙看看。
[code=Assembl]OilInfo实体类[/code] public class OilInfo
{
public virtual int Id { get; set; }
public virtual string OilName { get; set; }
public virtual string TemplateId { get; set; }
public virtual string Comment { get; set; }
public virtual string AD { get; set; } public virtual OilStaticData OilStaticData { get; set; }[code=Assembl]OilStaticData实体类[/code] public class OilStaticData
{
public virtual int Id { get; set; } public virtual string ParentSheet { get; set; } public virtual string ReservoirType { get; set; }
public virtual string GeologicalReserves { get; set; }
public virtual string OilBearingArea { get; set; }
public virtual string OilViscosity { get; set; }
public virtual string GroundOilViscosity { get; set; }
public virtual string MeanPorosity { get; set; }
public virtual string MeanPermeability { get; set; }
public virtual string InitialOilSaturation { get; set; } public virtual OilInfo OilInfo { get; set; }
}[code=Assembl]OilInfoMap[/code] public class OilInfoMap : ClassMap<OilInfo>
{
public OilInfoMap()
{
this.Table("OIL_INFO");
HasOne<OilStaticData>
(d => d.OilStaticData)
.LazyLoad()
.Cascade.All();
//.PropertyRef("OilInfo"); Id(x => x.Id)
.GeneratedBy.Native()
.Not.Nullable()
.Column("ID"); Map(x => x.OilName)
.Not.Nullable()
.Column("OIL_NAME"); Map(x => x.TemplateId)
.Default("")
.Column("TEMPLATE_ID"); Map(x => x.Comment)
.Default("")
.Column("OIL_COMMENT"); Map(x => x.AD)
.Default("")
.Column("AD");
}[code=Assembl]OilStaticDataMap[/code] public OilStaticDataMap()
{
this.Table("DATASHEET_FIELDSDATA"); Id(x => x.Id)
.GeneratedBy.Foreign("OilInfo")
.Column("ID")
.Not.Nullable(); HasOne<OilInfo>(d => d.OilInfo)
.LazyLoad()
.Cascade.All().Constrained(); Map(x => x.ParentSheet)
.Not.Nullable()
.Column("PARENT_SHEET"); Map(x => x.InitialOilSaturation)
.Default("")
.Column("COLUMN51"); Map(x => x.MeanPermeability)
.Default("")
.Column("COLUMN40"); Map(x => x.MeanPorosity)
.Default("")
.Column("COLUMN38"); Map(x => x.OilBearingArea)
.Default("")
.Column("COLUMN14"); Map(x => x.OilViscosity)
.Default("")
.Column("COLUMN47"); Map(x => x.ReservoirType)
.Default("")
.Column("COLUMN123"); Map(x => x.GroundOilViscosity)
.Default("")
.Column("COLUMN46");
}
数据库连接对的,我不建立条件,直接选取全部就没问题
我贴下代码吧,大家帮忙看看。
[code=Assemb]OilInfo实体类[/code]
public class OilInfo
{
public virtual int Id { get; set; }
public virtual string OilName { get; set; }
public virtual string TemplateId { get; set; }
public virtual string Comment { get; set; }
public virtual string AD { get; set; } public virtual OilStaticData OilStaticData { get; set; } [code=Assemb]OilStaticData实体类[/code]
public class OilStaticData
{
public virtual int Id { get; set; } public virtual string ParentSheet { get; set; } public virtual string ReservoirType { get; set; }
public virtual string GeologicalReserves { get; set; }
public virtual string OilBearingArea { get; set; }
public virtual string OilViscosity { get; set; }
public virtual string GroundOilViscosity { get; set; }
public virtual string MeanPorosity { get; set; }
public virtual string MeanPermeability { get; set; }
public virtual string InitialOilSaturation { get; set; } public virtual OilInfo OilInfo { get; set; }
} [code=Assemb]OilInfoMap[/code]
public class OilInfoMap : ClassMap <OilInfo>
{
public OilInfoMap()
{
this.Table("OIL_INFO");
HasOne <OilStaticData>
(d => d.OilStaticData)
.LazyLoad()
.Cascade.All();
//.PropertyRef("OilInfo"); Id(x => x.Id)
.GeneratedBy.Native()
.Not.Nullable()
.Column("ID"); Map(x => x.OilName)
.Not.Nullable()
.Column("OIL_NAME"); Map(x => x.TemplateId)
.Default("")
.Column("TEMPLATE_ID"); Map(x => x.Comment)
.Default("")
.Column("OIL_COMMENT"); Map(x => x.AD)
.Default("")
.Column("AD");
} [code=Assemb]OilStaticDataMap[/code]
public OilStaticDataMap()
{
this.Table("DATASHEET_FIELDSDATA"); Id(x => x.Id)
.GeneratedBy.Foreign("OilInfo")
.Column("ID")
.Not.Nullable(); HasOne <OilInfo>(d => d.OilInfo)
.LazyLoad()
.Cascade.All().Constrained(); Map(x => x.ParentSheet)
.Not.Nullable()
.Column("PARENT_SHEET"); Map(x => x.InitialOilSaturation)
.Default("")
.Column("COLUMN51"); Map(x => x.MeanPermeability)
.Default("")
.Column("COLUMN40"); Map(x => x.MeanPorosity)
.Default("")
.Column("COLUMN38"); Map(x => x.OilBearingArea)
.Default("")
.Column("COLUMN14"); Map(x => x.OilViscosity)
.Default("")
.Column("COLUMN47"); Map(x => x.ReservoirType)
.Default("")
.Column("COLUMN123"); Map(x => x.GroundOilViscosity)
.Default("")
.Column("COLUMN46");
}
我贴下代码吧,大家帮忙看看。
[code=Assembl]OilInfo实体类[/code]
public class OilInfo
{
public virtual int Id { get; set; }
public virtual string OilName { get; set; }
public virtual string TemplateId { get; set; }
public virtual string Comment { get; set; }
public virtual string AD { get; set; } public virtual OilStaticData OilStaticData { get; set; } [code=Assembl]OilStaticData实体类[/code]
public class OilStaticData
{
public virtual int Id { get; set; } public virtual string ParentSheet { get; set; } public virtual string ReservoirType { get; set; }
public virtual string GeologicalReserves { get; set; }
public virtual string OilBearingArea { get; set; }
public virtual string OilViscosity { get; set; }
public virtual string GroundOilViscosity { get; set; }
public virtual string MeanPorosity { get; set; }
public virtual string MeanPermeability { get; set; }
public virtual string InitialOilSaturation { get; set; } public virtual OilInfo OilInfo { get; set; }
} [code=Assembl]OilInfoMap[/code]
public class OilInfoMap : ClassMap <OilInfo>
{
public OilInfoMap()
{
this.Table("OIL_INFO");
HasOne <OilStaticData>
(d => d.OilStaticData)
.LazyLoad()
.Cascade.All();
//.PropertyRef("OilInfo"); Id(x => x.Id)
.GeneratedBy.Native()
.Not.Nullable()
.Column("ID"); Map(x => x.OilName)
.Not.Nullable()
.Column("OIL_NAME"); Map(x => x.TemplateId)
.Default("")
.Column("TEMPLATE_ID"); Map(x => x.Comment)
.Default("")
.Column("OIL_COMMENT"); Map(x => x.AD)
.Default("")
.Column("AD");
} [code=Assembl]OilStaticDataMap[/code]
public OilStaticDataMap()
{
this.Table("DATASHEET_FIELDSDATA"); Id(x => x.Id)
.GeneratedBy.Foreign("OilInfo")
.Column("ID")
.Not.Nullable(); HasOne <OilInfo>(d => d.OilInfo)
.LazyLoad()
.Cascade.All().Constrained(); Map(x => x.ParentSheet)
.Not.Nullable()
.Column("PARENT_SHEET"); Map(x => x.InitialOilSaturation)
.Default("")
.Column("COLUMN51"); Map(x => x.MeanPermeability)
.Default("")
.Column("COLUMN40"); Map(x => x.MeanPorosity)
.Default("")
.Column("COLUMN38"); Map(x => x.OilBearingArea)
.Default("")
.Column("COLUMN14"); Map(x => x.OilViscosity)
.Default("")
.Column("COLUMN47"); Map(x => x.ReservoirType)
.Default("")
.Column("COLUMN123"); Map(x => x.GroundOilViscosity)
.Default("")
.Column("COLUMN46");
}