public override global::System.Data.DataSet Clone()
{
masterDataSet cln = ((masterDataSet)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
masterDataSet ds = new masterDataSet();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
masterDataSet ds = new masterDataSet();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "DataTable1DataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
private void ReportViewerLoad(object sender, EventArgs e)
{
foreach (var objectWholeTableSet in db.WholeTableSet)
{
db.WholeTableSet.DeleteObject(objectWholeTableSet);
}
db.SaveChanges();
var tableQuery = from cl in db.Clearings
join bs in db.Buildings on cl.Building.Id equals bs.Id
join hs in db.HeatSuppliers on bs.HeatSupplier.Id equals hs.Id
join dt in db.DateTimeIntervals on hs.Id equals dt.HeatSupplier.Id
join mr in db.MeterReadings on dt.MeterReading.ID equals mr.ID
join ch in db.ContractConsumptionHeats on dt.ContractConsumptionHeat.ID equals ch.ID
join nc in db.NormativeCalculations on dt.NormativeCalculation.Id equals nc.Id
select new {cl, bs, hs, dt , mr , nc , ch};
foreach (var building in tableQuery)
{
db.WholeTableSet.AddObject(new WholeTable() {BuildingName = building.bs.Name,
BuildingDescription = building.bs.Description,
BuildingStandartOfHeat = building.bs.StandartOfHeat,
BuildingTotalArea = building.bs.TotalArea,
HeatSupplierName = building.hs.Name,
HeatSupplierDescription = building.hs.Description,
DateTimeIntervalName = building.dt.Name,
DateTimeIntervalStartDate = building.dt.StartDate,
DateTimeIntervalEndDate = building.dt.EndDate,
ClearingRequirements = building.cl.Requirements,
ClearingCalculationHot = building.cl.CalculationHot,
ClearingCalculationByBuhgaltery = building.cl.CalculationByBughaltery,
MeterReadingHeat = building.mr.CurrentHeatMeterReader,
MeterReadingWater = building.mr.CurrentWaterHeatReader,
ContractHeatByLoading = building.ch.HeatByLoading,
//ContractPeopleCount = building.ch.PeopleCount,
ContractHotWaterByNorm = building.ch.HotWaterByNorm,
ContractTotalHeatConsumption = building.ch.TotalHeatConsumption,
//NormativeCalculationArea = building.nc.CalculationArea,
NormativeEstimateConsumptionHeat = building.nc.EstimateConsumptionHeat,
NormativeConsumptionHeatByCalculationArea = building.nc.ConsumptionHeatByCalculationArea,
NormativConsumptionHeatByTotalArea = building.nc.ConsumptionHeatByTotalArea
});
}
try
{
db.SaveChanges();
}
catch (Exception er)
{
MessageBox.Show(er.Message);
}
if (!_isReportViewerLoaded)
{
var reportDataSource1 = new
Microsoft.Reporting.WinForms.ReportDataSource {Name = "TableSet"};
var masterdataset = new masterDataSet();
masterdataset.BeginInit();
//Name of the report dataset in our .RDLC file
reportDataSource1.Value = masterdataset.WholeTableSet;
this._reportViewer.LocalReport.DataSources.Add(reportDataSource1);
this._reportViewer.LocalReport.ReportPath = "../../Report.rdlc";
masterdataset.EndInit();
//fill data into WpfApplication4DataSet
var wholeTableAdapter = new
masterDataSetTableAdapters.WholeTableSetTableAdapter {ClearBeforeFill = true};
try
{
wholeTableAdapter.Fill(masterdataset.WholeTableSet);
}
catch(Exception er)
{
int x;
}
_reportViewer.RefreshReport();
_isReportViewerLoaded = true;
}
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
masterDataSet ds = new masterDataSet();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}