/// <summary>
/// Load all records of the same factory and project as the supplied record.
/// </summary>
/// <param name="record">A record with factory and project set.</param>
/// <returns>A list of all mathcing records.</returns>
public List<RecProductionCastStrand> LoadProductionCastStrand( RecProductionCastStrand record )
{
ImpactQuery query = new ImpactQuery()
{
Select =
{
ImpProductionCastStrand.Factory,
ImpProductionCastStrand.Project,
ImpProductionCastStrand.CastId,
ImpProductionCastStrand.StrandPos,
ImpProductionCastStrand.StrandX,
ImpProductionCastStrand.StrandY,
ImpProductionCastStrand.StrandQuality,
ImpProductionCastStrand.StrandDimension,
ImpProductionCastStrand.StrandPrestressing,
},
From = { ImpProductionCastStrand.As( "T1" ) },
Where = { ImpProductionCastStrand.Factory.Equal( record.Factory ),
ImpProductionCastStrand.Project.Equal( record.Factory ),// Factory, Factory for productionCast & ProductionCastStrand
ImpProductionCastStrand.CastId.Equal( record.CastId )}
};
string statement = query.ToString();
List<RecProductionCastStrand> result;
using( ImpactDatabase database = new ImpactDatabase() )
{
result = database.GetAll( statement, ParseProductionCastStrand );
}
return result;
}
public List<RecCalendarWorkday> LoadWorkDays(RecCalendar record)
{
ImpactQuery query = new ImpactQuery()
{
Select =
{
ImpCalendarWorkday.Factory,
ImpCalendarWorkday.Project ,
ImpCalendarWorkday.Calendar,
ImpCalendarWorkday.Weekday ,
ImpCalendarWorkday.DayType ,
ImpCalendarWorkday.ChangedBy ,
ImpCalendarWorkday.ChangedDate
},
From = { ImpCalendarWorkday.As("T1") },
Where = {
ImpCalendarWorkday.Factory.Equal(record.Factory),
ImpCalendarWorkday.Project.Equal(record.Project),
ImpCalendarWorkday.Calendar.Equal(record.Name)
}
};
string statement = query.ToString();
List<RecCalendarWorkday> result;
using (ImpactDatabase database = new ImpactDatabase())
{
result = database.GetAll(statement, WorkDayParse);
}
return result;
}
/// <summary>
/// Get the query for fetching company, factory and project data available for the specified user.
/// </summary>
/// <param name="user">
/// </param>
/// <returns>
/// The System.String.
/// </returns>
static string GetCompanyFactoryProjectQuery( string user )
{
ImpactQuery query = new ImpactQuery( true )
{
Select =
{
ImpCompany.Company,
ImpCompany.Name,
ImpFactory.Factory,
ImpFactory.Name,
ImpProject.Project,
ImpProject.Name,
ImpProject.Description,
ImpProject.RegisterDate,
ImpProject.ProjectType,
ImpProject.Status,
},
From = {
ImpFactory.As( "T1" )
},
Join =
{
Join.Inner( ImpUserCompany.As( "T2" ), ImpFactory.Company.Equal( ImpUserCompany.Company ) ),
Join.Inner( ImpCompany.As( "T3" ), ImpFactory.Company.Equal( ImpCompany.Company ) ),
Join.Inner( ImpProject.As( "T4" ), ImpFactory.Factory.Equal( ImpProject.Factory ) ),
Join.Inner( ImpUserGroup.As( "T5" ), ImpUserCompany.Userid.Equal( ImpUserGroup.Userid ) ),
Join.Inner( ImpUserGroupStd.As( "T6" ), ImpUserGroup.UserGroup.Equal( ImpUserGroupStd.Name ) ),
},
Where =
{
ImpUserCompany.Userid.Equal( user ),
ImpFactory.Factory.NotEqual( ImpProject.Project ),
ImpUserGroupStd.RoleId.In( new[] { 1, 2, 3 } ),
},
OrderBy =
{
{ ImpCompany.Company, OrderBy.Ascending },
{ ImpFactory.Factory, OrderBy.Ascending },
{ ImpProject.Project, OrderBy.Ascending },
}
};
return query.ToString();
}
/// <summary>
/// Load of Transport Vehicle Standard items
/// </summary>
/// <param name="vehicle"></param>
/// <returns></returns>
public List<RecTransportVehicleStd> LoadTransportVehicleStd( RecTransportVehicleStd record )
{
if( record == null )
{
throw new ArgumentNullException( "TransportVehicleStd" );
}
ImpactQuery query = new ImpactQuery()
{
Select =
{
ImpTransportVehicleStd.Factory,
ImpTransportVehicleStd.Project,
ImpTransportVehicleStd.Name,
ImpTransportVehicleStd.Division,
ImpTransportVehicleStd.Description,
ImpTransportVehicleStd.VehicleType,
ImpTransportVehicleStd.TransportType,
ImpTransportVehicleStd.Length,
ImpTransportVehicleStd.Width,
ImpTransportVehicleStd.Height,
ImpTransportVehicleStd.Mass,
ImpTransportVehicleStd.MaxLength,
ImpTransportVehicleStd.MaxWidth,
ImpTransportVehicleStd.MaxHeight,
ImpTransportVehicleStd.MaxMass,
ImpTransportVehicleStd.CreatedBy,
ImpTransportVehicleStd.CreatedDate,
ImpTransportVehicleStd.ChangedBy,
ImpTransportVehicleStd.ChangedDate,
},
From = { ImpTransportVehicleStd.As( "T1" ) },
Where = { ImpTransportVehicleStd.Factory.Equal( record.Factory ),
ImpTransportVehicleStd.Project.Equal( record.Factory ),//for Std use Factory, Factory
},
OrderBy = {ImpTransportVehicleStd.Name}
};
string statement = query.ToString();
List<RecTransportVehicleStd> result;
using( ImpactDatabase database = new ImpactDatabase() )
{
result = database.GetAll( statement, ParseTransportVehicleStd );
}
return result;
}
/// <summary>
/// Return report standard data
/// </summary>
/// <param name="record">RecReportStd</param>
/// <returns></returns>
public List<RecReportStd> LoadReport( RecReportStd record )
{
var company = Util.FactoryToCompany( record.Factory );
var query = new ImpactQuery()
{
Select =
{
ImpReportStd.Factory,
ImpReportStd.Project,
ImpReportStd.ReportId,
ImpReportStd.Name,
ImpReportStd.ReportType,
ImpReportStd.Filename,
ImpReportStd.Foldername,
ImpReportStd.PageMaxX,
ImpReportStd.PageMaxY,
ImpReportStd.ContinuousHeaderRow,
ImpReportStd.ContinuousStartRow,
ImpReportStd.ContinuousEndRow,
ImpReportStd.ContinuousSumRow,
},
From = { ImpReportStd.As( "T1" ) },
Where = {
ImpReportStd.Factory.Equal( company ),
ImpReportStd.Project.Equal( company ), // company, company
}
};
if( !string.IsNullOrWhiteSpace( record.Name ) )
{
query.Where.Add( ImpReportStd.Name.Equal( record.Name ) );
}
if( record.ReportType > 0 )
{
query.Where.Add( ImpReportStd.ReportType.Equal( (int)record.ReportType ) );
}
var statement = query.ToString();
List<RecReportStd> result;
using( var database = new ImpactDatabase() )
{
result = database.GetAll( statement, ParseReport );
}
return result;
}
/// <summary>
/// Load all records of the same factory and project as the supplied record.
/// </summary>
/// <param name="record">A record with factory and project set.</param>
/// <returns>A list of all mathcing records.</returns>
public List<RecTransportStack> LoadTransportStack( RecTransportStack record )
{
ImpactQuery query = new ImpactQuery()
{
Select =
{
ImpTransportStack.Factory,
ImpTransportStack.Project,
ImpTransportStack.TransportId,
ImpTransportStack.VehicleId,
ImpTransportStack.StackId,
ImpTransportStack.Rack,
ImpTransportStack.StackX,
ImpTransportStack.StackY,
ImpTransportStack.StackZ,
ImpTransportStack.StackRotation,
ImpTransportStack.Description,
ImpTransportStack.StackType,
ImpTransportStack.StackPosition,
ImpTransportStack.MaxLength,
ImpTransportStack.MaxWidth,
ImpTransportStack.MaxHeight,
ImpTransportStack.MaxMass,
},
From = { ImpTransportStack.As( "T1" ) },
Where = { ImpTransportStack.Factory.Equal( record.Factory ),
ImpTransportStack.Project.Equal( record.Project ),
ImpTransportStack.TransportId.Equal( record.TransportId ),
ImpTransportStack.VehicleId.Equal( record.VehicleId )
}
};
if( record.StackId > 0 )
{
query.Where.Add( ImpTransportStack.StackId.Equal( record.StackId ) );
}
string statement = query.ToString();
List<RecTransportStack> result;
using( ImpactDatabase database = new ImpactDatabase() )
{
result = database.GetAll( statement, ParseTransportStack );
}
return result;
}
/// <summary>
/// Load all records of the same factory and project as the supplied record.
/// </summary>
/// <param name="record">A record with factory and project set.</param>
/// <returns>A list of all mathcing records.</returns>
public List<RecProductionFormStrandStd> LoadProductionFormStrandStd( RecProductionFormStrandStd record )
{
ImpactQuery query = new ImpactQuery()
{
Select =
{
ImpProductionFormStrandStd.Factory,
ImpProductionFormStrandStd.Project,
ImpProductionFormStrandStd.Name,
ImpProductionFormStrandStd.StrandPos,
ImpProductionFormStrandStd.StrandX,
ImpProductionFormStrandStd.StrandY,
ImpProductionFormStrandStd.StrandQuality,
ImpProductionFormStrandStd.StrandDimension,
ImpProductionFormStrandStd.StrandPrestressing,
ImpProductionFormStrand.Form,
},
From = { ImpProductionFormStrandStd.As( "T1" ) },
Join =
{
Join.Left( ImpProductionFormStrand.As( "T2" ),
ImpProductionFormStrand.Factory.Equal( ImpProductionFormStrandStd.Factory ),
ImpProductionFormStrand.Project.Equal( ImpProductionFormStrandStd.Project ),//Factory, Factory
ImpProductionFormStrand.Form.Equal( ImpProductionFormStrandStd.Name ),
ImpProductionFormStrand.Strand.Equal( ImpProductionFormStrandStd.StrandPos )),
},
Where = { ImpProductionFormStrandStd.Factory.Equal( record.Factory ),
ImpProductionFormStrandStd.Project.Equal( record.Factory ),
ImpProductionFormStrandStd.Name.Equal( record.Name )} //Form name
};
string statement = query.ToString();
List<RecProductionFormStrandStd> result;
using( ImpactDatabase database = new ImpactDatabase() )
{
result = database.GetAll( statement, ParseProductionFormStrandStd );
}
return result;
}
/// <summary>
/// Load all records of the same factory and project as the supplied record.
/// </summary>
/// <param name="record">A record with factory and project set.</param>
/// <returns>A list of all mathcing records.</returns>
public List<RecCalendar> LoadCalendar(RecCalendar record)
{
ImpactQuery query = new ImpactQuery()
{
Select =
{
ImpCalendar.Factory,
ImpCalendar.Project,
ImpCalendar.Name,
ImpCalendar.Description,
ImpCalendar.CreatedBy,
ImpCalendar.CreatedDate,
ImpCalendar.ChangedBy,
ImpCalendar.ChangedDate,
},
From = { ImpCalendar.As("T1") },
Where = { ImpCalendar.Factory.Equal(record.Factory), ImpCalendar.Project.Equal(record.Factory) }
};
string statement = query.ToString();
List<RecCalendar> result;
using (ImpactDatabase database = new ImpactDatabase())
{
result = database.GetAll( statement, ParseCalendar );
}
if (null != result)
{
foreach (RecCalendar recCalendar in result)
{
recCalendar.WorkDays = LoadWorkDays(recCalendar );
recCalendar.InvalidDays = LoadInvalidDays(recCalendar);
}
}
return result;
}
/// <summary>
/// Load all records of the same factory and project as the supplied record.
/// </summary>
/// <param name="record">A record with factory and project set.</param>
/// <returns>A list of all mathcing records.</returns>
public List<RecTransportVehicleStackStd> LoadTransportVehicleStackStd( RecTransportVehicleStackStd record )
{
ImpactQuery query = new ImpactQuery()
{
Select =
{
ImpTransportVehicleStackStd.Name,
ImpTransportVehicleStackStd.StackId,
ImpTransportVehicleStackStd.Rack,
ImpTransportVehicleStackStd.StackPosition,
ImpTransportVehicleStackStd.StackX,
ImpTransportVehicleStackStd.StackY,
ImpTransportVehicleStackStd.StackZ,
ImpTransportVehicleStackStd.StackRotation,
ImpTransportVehicleStackStd.Description,
ImpTransportVehicleStackStd.StackType,
ImpTransportVehicleStackStd.MaxLength,
ImpTransportVehicleStackStd.MaxWidth,
ImpTransportVehicleStackStd.MaxHeight,
ImpTransportVehicleStackStd.MaxMass
},
From = { ImpTransportVehicleStackStd.As( "T1" ) },
Where = { ImpTransportVehicleStackStd.Factory.Equal( record.Factory ),
ImpTransportVehicleStackStd.Project.Equal( record.Factory ),//for Std use Factory, Factory
ImpTransportVehicleStackStd.Name.Equal( record.Name )}
};
string statement = query.ToString();
List<RecTransportVehicleStackStd> result;
using( ImpactDatabase database = new ImpactDatabase() )
{
result = database.GetAll( statement, ParseTransportVehicleStackStd );
}
return result;
}
/// <summary>
/// Load all records of the same factory and project as the supplied record.
/// </summary>
/// <param name="record">A record with factory and project set.</param>
/// <returns>A list of all mathcing records.</returns>
public List<RecSectionStyleStd> LoadSqlServer( RecSectionStyleStd record )
{
if( record == null || record.Factory == null )
{
return null;
}
string company = record.Factory.Substring( 0, 2 ) + "00"; //Is this really OK ??!!
WhereGroup wgElementType = WhereGroup.Or( ImpSectionStyleStd.ElementType.Equal( "HD/F" ),
ImpSectionStyleStd.ElementType.Equal( "D/F" ));
// Prepare Factory, Project statement
ImpactQuery projectQuery = new ImpactQuery()
{
Select = {
ImpSectionStyleStd.Factory,
ImpSectionStyleStd.Project,
ImpSectionStyleStd.ElementType,
ImpSectionStyleStd.Name,
ImpSectionStyleStd.SectionType,
ImpSectionStyleStd.Description,
},
From = { ImpSectionStyleStd.As( "T1" ) },
Where = {
ImpSectionStyleStd.Factory.Equal( record.Factory ),
ImpSectionStyleStd.Project.Equal( record.Project ),
wgElementType },
};
string projectStatement = projectQuery.ToString();
// Prepare Factory, Factory statement
ImpactQuery factoryQuery = new ImpactQuery()
{
Select = {
ImpSectionStyleStd.Factory,
ImpSectionStyleStd.Project,
ImpSectionStyleStd.ElementType,
ImpSectionStyleStd.Name,
ImpSectionStyleStd.SectionType,
ImpSectionStyleStd.Description,
},
From = { ImpSectionStyleStd.As( "T1" ) },
Where = {
ImpSectionStyleStd.Factory.Equal( record.Factory ),
ImpSectionStyleStd.Project.Equal( record.Factory ),
wgElementType
},
};
string factoryStatement = factoryQuery.ToString();
ImpactQuery projectSubquery = new ImpactQuery {
Select = { ImpSectionStyleStd.Name },
From = { ImpSectionStyleStd.As( "T1" ) },
Where = {
ImpSectionStyleStd.Factory.Equal( record.Factory ),
ImpSectionStyleStd.Project.Equal( record.Project ),
wgElementType
},
};
factoryStatement += " AND T1.Name Not In (" + projectSubquery.ToString() + ")";
// Prepare Company, Company statement
ImpactQuery companyQuery = new ImpactQuery()
{
Select = {
ImpSectionStyleStd.Factory,
ImpSectionStyleStd.Project,
ImpSectionStyleStd.ElementType,
ImpSectionStyleStd.Name,
ImpSectionStyleStd.SectionType,
ImpSectionStyleStd.Description,
},
From = { ImpSectionStyleStd.As( "T1" ) },
Where = {
ImpSectionStyleStd.Factory.Equal( company ),
ImpSectionStyleStd.Project.Equal( company ),
wgElementType },
};
string companyStatement = companyQuery.ToString();
ImpactQuery factorySubquery = new ImpactQuery()
{
Select = { ImpSectionStyleStd.Name },
From = { ImpSectionStyleStd.As( "T1" ) },
Where = {
ImpSectionStyleStd.Factory.Equal( record.Factory ),
ImpSectionStyleStd.Project.Equal( record.Factory ),
wgElementType },
};
companyStatement += " AND T1.Name Not In (" + projectSubquery.ToString() + ")"
+ " AND T1.Name Not In (" + factorySubquery.ToString() + ")";
string statement = projectStatement + " Union " + factoryStatement + " Union " + companyStatement + " Order By T1.ELEMENT_TYPE, T1.Name";
List<RecSectionStyleStd> result;
using( ImpactDatabase database = new ImpactDatabase() )
{
result = database.GetAll( statement, ParseSectionStyleStd );
}
return result;
}
/// <summary>
/// Load the strands of the given pattern.
/// </summary>
/// <param name="factory"> </param>
/// <param name="project"> </param>
/// <param name="elementType"> </param>
/// <param name="style"> </param>
/// <param name="strandpattern"> </param>
/// <returns>A list of all mathcing records.</returns>
public List<RecProductionCastStrand> LoadStrands( string factory, string project, string elementType, string style, string strandpattern )
{
// Add, Factory, Factory and Company, Company
var company = factory.Substring( 0, 2 ) + "00"; //Is this really OK ??!!
var where1 = WhereGroup.And( ImpSectionStyleStd.Factory.Equal( factory ), ImpSectionStyleStd.Project.Equal( project ) );
var where2 = WhereGroup.And( ImpSectionStyleStd.Factory.Equal( factory ), ImpSectionStyleStd.Project.Equal( factory ) );
var where3 = WhereGroup.And( ImpSectionStyleStd.Factory.Equal( company ), ImpSectionStyleStd.Project.Equal( company ) );
var orProjectFactoryCompany = WhereGroup.Or( where1, where2, where3 );
var query = new ImpactQuery()
{
Select =
{
ImpSectionStyleStd.Factory,
ImpSectionStyleStd.Project,
ImpSectionStyleStd.Name,
ImpSectionStrandptnStd.Name,
ImpSectionStrandPosStd.StrandPos,
ImpSectionStrandPosStd.StrandX,
ImpSectionStrandPosStd.StrandY,
ImpSectionStrandptnGrpStd.StrandDimension,
ImpSectionStrandptnGrpStd.StrandPrestressing,
ImpSectionStrandptnGrpStd.StrandQuality,
},
From = { ImpSectionStyleStd.As( "T1" ) },
Join =
{
Join.Left( ImpSectionStrandptnStd.As( "T2" ),
ImpSectionStrandptnStd.Factory.Equal( ImpSectionStyleStd.Factory ),
ImpSectionStrandptnStd.Project.Equal( ImpSectionStyleStd.Project ),
ImpSectionStrandptnStd.ElementType.Equal( ImpSectionStyleStd.ElementType ),
ImpSectionStrandptnStd.Section.Equal( ImpSectionStyleStd.Name )),
Join.Left( ImpSectionStrandptnPosStd.As( "T3" ),
ImpSectionStrandptnPosStd.Factory.Equal( ImpSectionStrandptnStd.Factory ),
ImpSectionStrandptnPosStd.Project.Equal( ImpSectionStrandptnStd.Project ),
ImpSectionStrandptnPosStd.ElementType.Equal( ImpSectionStrandptnStd.ElementType ),
ImpSectionStrandptnPosStd.Section.Equal( ImpSectionStrandptnStd.Section ),
ImpSectionStrandptnPosStd.Strandptn.Equal( ImpSectionStrandptnStd.Name )),
Join.Left( ImpSectionStrandPosStd.As( "T4" ),
ImpSectionStrandPosStd.Factory.Equal( ImpSectionStrandptnPosStd.Factory ),
ImpSectionStrandPosStd.Project.Equal( ImpSectionStrandptnPosStd.Project ),
ImpSectionStrandPosStd.ElementType.Equal( ImpSectionStrandptnPosStd.ElementType ),
ImpSectionStrandPosStd.Section.Equal( ImpSectionStrandptnPosStd.Section ),
ImpSectionStrandPosStd.StrandPos.Equal( ImpSectionStrandptnPosStd.StrandPos )),
Join.Left( ImpSectionStrandptnGrpStd.As( "T5" ),
ImpSectionStrandptnGrpStd.Factory.Equal( ImpSectionStrandPosStd.Factory ),
ImpSectionStrandptnGrpStd.Project.Equal( ImpSectionStrandPosStd.Project ),
ImpSectionStrandptnGrpStd.ElementType.Equal( ImpSectionStrandPosStd.ElementType ),
ImpSectionStrandptnGrpStd.Section.Equal( ImpSectionStrandPosStd.Section ),
ImpSectionStrandptnGrpStd.Strandptn.Equal( ImpSectionStrandptnPosStd.Strandptn ),
ImpSectionStrandptnGrpStd.StrandGrp.Equal( ImpSectionStrandPosStd.StrandGrp )),
},
Where =
{
ImpSectionStyleStd.ElementType.Equal( elementType ),
ImpSectionStyleStd.Name.Equal( style ),
ImpSectionStrandptnPosStd.Strandptn.Equal( strandpattern ),
orProjectFactoryCompany
},
};
var statement = query.ToString();
List<RecProductionCastStrand> result;
using( var database = new ImpactDatabase() )
{
result = database.GetAll( statement, column => new RecProductionCastStrand()
{
Factory = column[0].Cast<string>(),
Project = column[1].Cast<string>(),
Style = column[2].Cast<string>(),
Strandpattern = column[3].Cast<string>(),
StrandPos = column[4].Cast<int>(),
StrandX = column[5].Cast<double>(),
StrandY = column[6].Cast<double>(),
StrandDimension = column[7].Cast<double>(),
StrandPrestressing = column[8].Cast<double>(),
StrandQuality = column[9].Cast<string>(),
} );
}
if( result == null || result.Count == 0 )
{
return result;
}
var strands = ( from o in result where ( o.Factory == factory && o.Project == project ) select o ).ToList();
if( strands.Count > 0 )
{
return strands;
}
strands = ( from o in result where ( o.Factory == factory && o.Project == factory ) select o ).ToList();
if( strands.Count > 0 )
{
return strands;
}
return ( from o in result where ( o.Factory == company && o.Project == company ) select o ).ToList();
}
//public List<RecProductionFormStrandStd> LoadFormStrandStd( RecProductionFormStd rec )
//{
// ImpactQuery query = new ImpactQuery()
// {
// Select =
// {
// //ImpProductionFormStrandStd.Name,
// ImpProductionFormStrandStd.StrandPos,
// ImpProductionFormStrandStd.StrandX,
// ImpProductionFormStrandStd.StrandY,
// ImpProductionFormStrandStd.StrandDimension,
// ImpProductionFormStrandStd.StrandQuality,
// ImpProductionFormStrandStd.StrandPrestressing,
// },
// From = { ImpProductionFormStrandStd.As( "STD" ) },
// Where =
// {
// ImpProductionFormStrandStd.Factory.Equal( rec.Factory ),
// ImpProductionFormStrandStd.Project.Equal( rec.Factory ),
// ImpProductionFormStrandStd.Name.Equal( rec.Name ), //Form name
// },
// OrderBy =
// {
// { ImpProductionFormStrandStd.StrandPos },
// },
// };
// string statement = query.ToString();
// List<RecProductionFormStrandStd> result;
// using( ImpactDatabase database = new ImpactDatabase() )
// {
// result = database.GetAll( statement, FormStrandParse );
// }
// return result;
//}
//public static RecProductionFormStrandStd FormStrandParse( DbDataReader column )
//{
// var record = new RecProductionFormStrandStd();
// //record.Name = DataConverter.Cast<string>( column[0] );
// record.StrandPos = DataConverter.Cast<int>( column[0] );
// record.StrandX = DataConverter.Cast<double>( column[1] );
// record.StrandY = DataConverter.Cast<double>( column[2] );
// record.StrandDimension = DataConverter.Cast<double>( column[3] );
// record.StrandQuality = DataConverter.Cast<string>( column[4] );
// record.StrandPrestressing = DataConverter.Cast<double>( column[5] );
// return record;
//}
//public int DeleteFormStrandStd( RecProductionFormStd recProductionFormStd, RecProductionFormStrandStd recProductionFormStrandStd )
//{
// return 0;
//}
private bool FindProductionFormStrand( RecProductionFormStrandStd record )
{
using( ImpactDatabase database = new ImpactDatabase() )
{
var query = new ImpactQuery()
{
From = { ImpProductionFormStrand.As( "T1" ) },
Where =
{
ImpProductionFormStrand.Factory.Equal( record.Factory ),
ImpProductionFormStrand.Project.Equal( record.Factory ),
ImpProductionFormStrand.Form.Equal( record.Name ),
ImpProductionFormStrand.Strand.Equal( record.StrandPos.ToString() ),
},
};
var statement = query.ToString();
record = database.GetFirst( statement, column => new RecProductionFormStrandStd() );
}
return record != null;
}
/// <summary>
/// Load all records of the same factory and project as the supplied record.
/// </summary>
/// <param name="factory"> </param>
/// <param name="project"> </param>
/// <returns>A list of all mathcing records.</returns>
public List<RecSectionStyleStd> LoadSectionStyleStd( string factory, string project )
{
// Add, Factory, Factory and Company, Company
var company = factory.Substring( 0, 2 ) + "00"; //Is this really OK ??!!
var orElementType = WhereGroup.Or( ImpSectionStyleStd.ElementType.Equal( "HD/F" ),
ImpSectionStyleStd.ElementType.Equal( "D/F" ));
var where1 = WhereGroup.And( ImpSectionStyleStd.Factory.Equal( factory ), ImpSectionStyleStd.Project.Equal( project ) );
var where2 = WhereGroup.And( ImpSectionStyleStd.Factory.Equal( factory ), ImpSectionStyleStd.Project.Equal( factory ) );
var where3 = WhereGroup.And( ImpSectionStyleStd.Factory.Equal( company ), ImpSectionStyleStd.Project.Equal( company ) );
var orProjectFactoryCompany = WhereGroup.Or( where1, where2, where3 );
var query = new ImpactQuery()
{
Select =
{
ImpSectionStyleStd.Factory,
ImpSectionStyleStd.Project,
ImpSectionStyleStd.ElementType,
ImpSectionStyleStd.Name,
ImpSectionStyleStd.SectionType,
ImpSectionStyleStd.Description,
ImpSectionStrandptnStd.Name,
Aggregate.Count( ImpSectionStrandptnPosStd.StrandPos ),
//ImpSectionStyleStd.Width,
//ImpSectionStyleStd.WidthTolerance,
//ImpSectionStyleStd.DiffBottomTop,
//ImpSectionStyleStd.Height,
//ImpSectionStyleStd.Endcap,
//ImpSectionStyleStd.Strandptn,
//ImpSectionStyleStd.RcTemplate,
//ImpSectionStyleStd.Material,
//ImpSectionStyleStd.ProductionLine,
//ImpSectionStyleStd.CutType,
//ImpSectionStyleStd.UseCutZone,
//ImpSectionStyleStd.LiftMethod,
//ImpSectionStyleStd.LiftRotation1,
//ImpSectionStyleStd.LiftRotation2,
//ImpSectionStyleStd.LiftPlacingLs,
//ImpSectionStyleStd.LiftParameterLs,
//ImpSectionStyleStd.LiftPlacingSs,
//ImpSectionStyleStd.LiftParameterSs,
//ImpSectionStyleStd.LiftCores,
//ImpSectionStyleStd.LiftCoreLength,
//ImpSectionStyleStd.LiftCoreDisplayMode,
//ImpSectionStyleStd.LiftDistanceMax,
//ImpSectionStyleStd.LiftDistanceMin,
//ImpSectionStyleStd.LiftSpacing,
//ImpSectionStyleStd.LiftType,
//ImpSectionStyleStd.SectionViewDimStrandGrp,
//ImpSectionStyleStd.SectionViewTxtStrandGrp,
//ImpSectionStyleStd.SectionViewNbrCores,
//ImpSectionStyleStd.SectionViewScale,
//ImpSectionStyleStd.UseSectionViewSymbol,
//ImpSectionStyleStd.SectionViewFilename,
//ImpSectionStyleStd.ChamferDistance,
//ImpSectionStyleStd.ChamferText,
//ImpSectionStyleStd.ChamferVisibility,
//ImpSectionStyleStd.RcCoverCut1,
//ImpSectionStyleStd.RcCoverCut2,
//ImpSectionStyleStd.ElementGrp,
//ImpSectionStyleStd.ProductPrefix,
//ImpSectionStyleStd.Product,
//ImpSectionStyleStd.ElementMarkPrefix,
//ImpSectionStyleStd.DrawingNamePrefix,
//ImpSectionStyleStd.DrawingType,
//ImpSectionStyleStd.DrawingTemplate,
//ImpSectionStyleStd.CreatedBy,
//ImpSectionStyleStd.CreatedDate,
//ImpSectionStyleStd.ChangedBy,
//ImpSectionStyleStd.ChangedDate,
//ImpSectionStyleStd.LiftHolePosition,
},
From = { ImpSectionStyleStd.As( "T1" ) },
Join =
{
Join.Left( ImpSectionStrandptnStd.As( "T2" ),
ImpSectionStrandptnStd.Factory.Equal( ImpSectionStyleStd.Factory ),
ImpSectionStrandptnStd.Project.Equal( ImpSectionStyleStd.Project ),
ImpSectionStrandptnStd.ElementType.Equal( ImpSectionStyleStd.ElementType ),
ImpSectionStrandptnStd.Section.Equal( ImpSectionStyleStd.Name )),
Join.Left( ImpSectionStrandptnPosStd.As( "T3" ),
ImpSectionStrandptnPosStd.Factory.Equal( ImpSectionStrandptnStd.Factory ),
ImpSectionStrandptnPosStd.Project.Equal( ImpSectionStrandptnStd.Project ),
ImpSectionStrandptnPosStd.ElementType.Equal( ImpSectionStrandptnStd.ElementType ),
ImpSectionStrandptnPosStd.Section.Equal( ImpSectionStrandptnStd.Section ),
ImpSectionStrandptnPosStd.Strandptn.Equal( ImpSectionStrandptnStd.Name )),
},
Where = { orElementType, orProjectFactoryCompany },
GroupBy =
{
ImpSectionStyleStd.Factory,
ImpSectionStyleStd.Project,
ImpSectionStyleStd.ElementType,
ImpSectionStyleStd.Name,
ImpSectionStyleStd.SectionType,
ImpSectionStyleStd.Description,
ImpSectionStrandptnStd.Name,
}
};
var statement = query.ToString();
List<RecSectionStyleStd> result;
using( var database = new ImpactDatabase() )
{
result = database.GetAll( statement, ParseSectionStyleStd );
}
if( result == null || result.Count == 0 )
{
return result;
}
var companyDic = ( from o in result
where ( o.Factory == company && o.Project == company )
select new RecSectionStyleStd { Factory = o.Factory, Project = o.Factory, ElementType = o.ElementType,
Name = o.Name, Strandptn = o.Strandptn, NumOfStrands = o.NumOfStrands } ).ToDictionary( x => x.Name + x.Strandptn );
var factoryDic = ( from o in result
where ( o.Factory == factory && o.Project == factory )
select new RecSectionStyleStd { Factory = o.Factory, Project = o.Factory, ElementType = o.ElementType,
Name = o.Name, Strandptn = o.Strandptn, NumOfStrands = o.NumOfStrands } ).ToDictionary( x => x.Name + x.Strandptn );
var projectDic = ( from o in result
where ( o.Factory == factory && o.Project == project )
select new RecSectionStyleStd { Factory = o.Factory, Project = o.Project, ElementType = o.ElementType,
Name = o.Name, Strandptn = o.Strandptn, NumOfStrands = o.NumOfStrands } ).ToDictionary( x => x.Name + x.Strandptn );
foreach( var pair in factoryDic )
{
if( !projectDic.ContainsKey( pair.Key ) )
{
projectDic.Add( pair.Key, pair.Value );
}
}
foreach( var pair in companyDic )
{
if( !projectDic.ContainsKey( pair.Key ) )
{
projectDic.Add( pair.Key, pair.Value );
}
}
return GetStylesFromDictionary( projectDic);
}
/// <summary>
/// Load
/// </summary>
/// <param name="reportFilter"></param>
/// <returns></returns>
public DrawingReportData Load( ReportFilter reportFilter )
{
var data = new DrawingReportData();
var query = new ImpactQuery()
{
Select =
{
ImpDrawing.Factory,
ImpDrawing.Project,
ImpDrawing.DrawingName,
ImpDrawing.DrawingType,
ImpDrawing.DesignedBy,
ImpDrawing.Status,
ImpDrawing.ApprovedDate,
ImpDrawing.CreatedDate,
ImpDrawing.Text6,
},
From = { ImpDrawing.As( "T1" ) },
Join =
{
Join.Left(
ImpElement.As( "T2" ),
ImpDrawing.Factory.Equal( ImpElement.Factory ),
ImpDrawing.Project.Equal( ImpElement.Project ),
ImpDrawing.DrawingName.Equal( ImpElement.DrawingName ) ),
},
Where =
{
ImpDrawing.Factory.Equal( reportFilter.Factory ),
ImpDrawing.Project.Equal( reportFilter.Project ),
},
};
if( reportFilter.Ranges.Count > 0 )
{
var list = new List<Where>();
foreach( var range in reportFilter.Ranges )
{
if( !string.IsNullOrEmpty( range.From ) && !string.IsNullOrEmpty( range.To ) )
{
list.Add( ImpDrawing.DrawingName.Between( range.From, range.To ) );
}
}
if( list.Count > 0 )
{
query.Where.Add( WhereGroup.Or( list.ToArray() ) );
}
}
var statement = query.ToString();
using( var database = new ImpactDatabase() )
{
data.Rows = database.GetAll( statement, column => new DrawingReportRow()
{
Factory = column[0].Cast<string>(),
Project = column[1].Cast<string>(),
DrawingName = column[2].Cast<string>(),
DrawingType = column[3].Cast<string>(),
DesignedBy = column[4].Cast<string>(),
Status = column[5].Cast<string>(),
ApprovedDate = column[6].Cast<DateTime?>(),
CreatedDate = column[7].Cast<DateTime?>(),
DrawingText6 = column[8].Cast<string>(),
} );
}
return data;
}
/// <summary>
/// Get the query for fetching the phases for each project available to the specified user.
/// </summary>
/// <param name="user">
/// </param>
/// <returns>
/// The System.String.
/// </returns>
static string GetAllProjectPhaseQuery( string user )
{
ImpactQuery query = new ImpactQuery
{
Select =
{
ImpModelPhase.Factory,
ImpModelPhase.Project,
ImpModelPhase.Name,
},
From = {
ImpFactory.As( "T1" )
},
Join =
{
Join.Inner( ImpUserCompany.As( "T2" ), ImpFactory.Company.Equal( ImpUserCompany.Company ) ),
Join.Inner( ImpCompany.As( "T3" ), ImpFactory.Company.Equal( ImpCompany.Company ) ),
Join.Inner( ImpProject.As( "T4" ), ImpFactory.Factory.Equal( ImpProject.Factory ) ),
Join.Inner( ImpModelPhase.As( "T5" ), ImpProject.Factory.Equal( ImpModelPhase.Factory ), ImpProject.Project.Equal( ImpModelPhase.Project ) ),
},
Where =
{
ImpUserCompany.Userid.Equal( user ),
ImpFactory.Factory.NotEqual( ImpProject.Project ),
},
OrderBy =
{
{ ImpModelPhase.Factory, OrderBy.Descending },
{ ImpModelPhase.Project, OrderBy.Descending },
{ ImpModelPhase.Name, OrderBy.Descending },
}
};
return query.ToString();
}
/// <summary>
/// Load data
/// </summary>
/// <param name="rec"> </param>
/// <returns></returns>
public List<RecTransport> LoadTemplates( RecTMElement rec )
{
if( rec == null )
{
throw new ArgumentNullException( "RecTransportManager" );
}
List<RecTransport> result = new List<RecTransport>();
using( ImpactDatabase database = new ImpactDatabase() )
{
ImpactQuery query = new ImpactQuery()
{
From = { ImpTransport.As( "T1" ) },
Where =
{
ImpTransport.Factory.Equal( rec.Factory ),
ImpTransport.Project.Equal( rec.Project ),
ImpTransport.IsTemplate.Equal( true ),
ImpTransport.IsVisible.Equal( true ),
},
OrderBy = { ImpTransport.TransportId },
};
string statement = query.ToString();
result = database.GetAll( statement, rdr => new RecTransport()
{
Factory = DataConverter.Cast<string>( rdr["FACTORY"] ),
Project = DataConverter.Cast<string>( rdr["PROJECT"] ),
TransportStatus = DataConverter.Cast<int>( rdr["Transport_status"] ),
Description = DataConverter.Cast<string>( rdr["Description"] ),
TransportId = DataConverter.Cast<int>( rdr["Transport_Id"] ),
LoadDate = DataConverter.Cast<DateTime>( rdr["Load_Date"] ),
DeliveryDate = DataConverter.Cast<DateTime>( rdr["Delivery_Date"] ),
TimeInterval = DataConverter.Cast<int>( rdr["Time_Interval"] ),
IsTemplate = DataConverter.Cast<int>( rdr["Is_Template"] ),
TemplateId = DataConverter.Cast<int>( rdr["Template_Id"] ),
IsVisible = DataConverter.Cast<int>( rdr["Is_Visible"] ),
} );
}
return result;
}
/// <summary>
/// Load of Transport items
/// </summary>
/// <returns></returns>
public List<RecTMTransport> LoadTransports( PlanningFilter filter, ReportFilter reportFilter )
{
if( filter == null )
{
throw new ArgumentNullException( "Transport" );
}
var where = WhereGroup.And( ImpTransport.Factory.Equal( filter.Factory ) );
if( !string.IsNullOrWhiteSpace( filter.Project ) )
{
where.Add( ImpTransport.Project.Equal( filter.Project ) );
}
WhereGroup whereStatus = WhereGroup.Or( new Where[] { } );
if( filter.NoStatus )
{
whereStatus.Add( ImpTransport.TransportStatus.Equal( TransportStatus.NoStatus ) );
}
if( filter.Planned )
{
whereStatus.Add( ImpTransport.TransportStatus.Equal( TransportStatus.Planned ) );
}
if( filter.CallOff )
{
whereStatus.Add( ImpTransport.TransportStatus.Equal( TransportStatus.CallOff ) );
}
if( filter.Delivered )
{
whereStatus.Add( ImpTransport.TransportStatus.Equal( TransportStatus.Delivered ) );
}
if( whereStatus.Count > 0 )
{
where.Add( whereStatus );
}
where.Add( ImpTransport.IsTemplate.Equal( false ) );
WhereGroup wgDeleted = WhereGroup.Or( ImpModelGeometry.Deleted.NotEqual( 1 ),
ImpModelGeometry.Deleted.IsNull() );
where.Add( wgDeleted );
if( filter.UseLoadDateFrom )
{
where.Add( ImpTransport.LoadDate.GreaterThanOrEqual( filter.LoadDateFrom ) );
}
if( filter.UseLoadDateTo )
{
where.Add( ImpTransport.LoadDate.LessThanOrEqual( filter.LoadDateTo ) );
}
if( filter.UseDeliveryDateFrom )
{
where.Add( ImpTransport.DeliveryDate.GreaterThanOrEqual( filter.DeliveryDateFrom ) );
}
if( filter.UseDeliveryDateTo )
{
where.Add( ImpTransport.DeliveryDate.LessThanOrEqual( filter.DeliveryDateTo ) );
}
if( reportFilter != null && reportFilter.Ranges.Count > 0 )
{
var list = new List<Where>();
foreach( var range in reportFilter.Ranges )
{
if( !string.IsNullOrEmpty( range.From ) && !string.IsNullOrEmpty( range.To ) )
{
list.Add( ImpTransport.TransportId.Between( range.From, range.To ) );
}
}
if( list.Count > 0 )
{
where.Add( WhereGroup.Or( list.ToArray() ) );
}
}
where.Add( ImpTransport.TransportId.GreaterThan( 0 ) );
ImpactQuery query = new ImpactQuery()
{
Select =
{
ImpTransport.Project,
ImpTransport.TransportId,
ImpTransport.Description,
ImpTransport.LoadDate,
ImpTransport.DeliveryDate,
ImpTransport.TransportStatus,
ImpTransportVehicle.VehicleId,
ImpTransportVehicleStd.Name,
ImpTransportVehicleStd.MaxMass,
ImpTransportVehicle.TransportType,
ImpTransportVehicleStd.VehicleType,
ImpTransportStack.StackId,
//ImpTransportStack.Rack,
ImpTransportStack.MaxMass,
ImpTransportStack.Description,
ImpTransportStack.StackType,
ImpModelPlanning.ElementId,
ImpModelPlanning.ErectionSequenceNo,
ImpModelPlanning.StackSequenceNo,
ImpModelPlanning.StackId,
ImpModelPlanning.ElementIdStatus,
ImpModelPlanning.PlannedDeliveryDate,
ImpModelPlanning.DeliveryDate,
ImpModelGeometry.ElementMark,
ImpModelGeometry.Building,
ImpModelGeometry.FloorId,
ImpModelGeometry.Phase,
ImpElement.ElementType,
ImpElement.Product,
ImpElement.Style,
ImpElement.Mass,
ImpElement.ElementLength,
ImpElement.ElementWidth,
ImpElement.ElementHeight,
ImpElement.GrossArea,
ImpElement.NetArea,
},
//ELEMENT_TYPE, STYLE BOUNDING_BOX_AREA
From = { ImpTransport.As( "TRA" ) },
Join =
{
Join.Left( ImpTransportVehicle.As( "TRV" ),
ImpTransport.Factory.Equal( ImpTransportVehicle.Factory ),
ImpTransport.Project.Equal( ImpTransportVehicle.Project ),
ImpTransport.TransportId.Equal( ImpTransportVehicle.TransportId ) ),
Join.Left( ImpTransportVehicleStd.As( "VST" ),
ImpTransport.Factory.Equal( ImpTransportVehicleStd.Factory ),
ImpTransport.Factory.Equal( ImpTransportVehicleStd.Project ), // Factory, factory only so far (Needs to be complated with company, company)
ImpTransportVehicle.Vehicle.Equal( ImpTransportVehicleStd.Name ) ),
Join.Left( ImpTransportStack.As( "RCK" ),
ImpTransport.Factory.Equal( ImpTransportStack.Factory ),
ImpTransport.Project.Equal( ImpTransportStack.Project ),
ImpTransport.TransportId.Equal( ImpTransportStack.TransportId ),
ImpTransportVehicle.VehicleId.Equal( ImpTransportStack.VehicleId )),
Join.Left( ImpModelPlanning.As( "MPL" ),
ImpTransport.Factory.Equal( ImpModelPlanning.Factory ),
ImpTransport.Project.Equal( ImpModelPlanning.Project ),
ImpTransport.TransportId.Equal( ImpModelPlanning.TransportId ),
ImpTransportVehicle.VehicleId.Equal( ImpModelPlanning.VehicleId ) ,
ImpTransportStack.StackId.Equal( ImpModelPlanning.StackId ) ),
Join.Left( ImpModelGeometry.As( "MGO" ),
ImpModelPlanning.Factory.Equal( ImpModelGeometry.Factory ),
ImpModelPlanning.Project.Equal( ImpModelGeometry.Project ),
ImpModelPlanning.ElementId.Equal( ImpModelGeometry.ElementId ) ),
Join.Left( ImpElement.As( "ELM" ),
ImpModelGeometry.Factory.Equal( ImpElement.Factory ),
ImpModelGeometry.Project.Equal( ImpElement.Project ),
ImpModelGeometry.ElementMark.Equal( ImpElement.ElementMark ) ),
},
Where = { where },
OrderBy =
{
{ ImpTransport.TransportId, OrderBy.Descending },
{ ImpTransportVehicle.VehicleId },
{ ImpTransportStack.StackId },
{ ImpModelPlanning.StackSequenceNo, OrderBy.Descending }
},
};
string statement = query.ToString();
List<RecTMTransport> tmList = new List<RecTMTransport>();
TranportParser parser = new TranportParser( tmList );
using( ImpactDatabase database = new ImpactDatabase() )
{
var list = database.GetAll( statement, column =>
{
string project = DataConverter.Cast<string>( column[0] );
int transportId = DataConverter.Cast<int>( column[1] );
return new
{
// TODO: THEIB, you must handle null dates in your record class.
transport = new RecTransport()
{
Factory = filter.Factory,
Project = project,
TransportId = transportId,
Description = DataConverter.Cast<string>( column[2] ),
LoadDate = DataConverter.Cast<DateTime>( column[3] ),
DeliveryDate = DataConverter.Cast<DateTime?>( column[4] ),
TransportStatus = DataConverter.Cast<int>( column[5] ),
},
veh = new RecTransportVehicleStd()
{
Factory = filter.Factory,
Project = project,
VehicleId = DataConverter.Cast<int?>( column[6] ) ?? 0,
Name = DataConverter.Cast<string>( column[7] ),
MaxMass = DataConverter.Cast<double?>( column[8] ) ?? 0d,
TransportId = transportId,
TransportType = DataConverter.Cast<int?>( column[9] ) ?? 0,
VehicleType = DataConverter.Cast<int?>( column[10] ) ?? 0
},
stack = new RecTransportVehicleStackStd()
{
StackId = DataConverter.Cast<int?>( column[11] ) ?? 0,
MaxMass = DataConverter.Cast<double?>( column[12] ) ?? 0,
Description = DataConverter.Cast<string>( column[13] ),
StackType = DataConverter.Cast<int?>( column[14] ) ?? 0
},
elem = new RecTMElement()
{
Factory = filter.Factory,
Project = project,
ElementId = DataConverter.Cast<int?>( column[15] ) ?? 0,
ErectionSequenceNo = DataConverter.Cast<int?>( column[16] ) ?? 0,
StackSequenceNo = DataConverter.Cast<int?>( column[17] ) ?? 0,
StackId = DataConverter.Cast<int?>( column[18] ) ?? 0,
ElementIdStatus = DataConverter.Cast<int?>( column[19] ) ?? 0,
PlannedDeliveryDate = DataConverter.Cast<DateTime?>( column[20] ),
DeliveryDate = DataConverter.Cast<DateTime?>( column[21] ),
ElementMark = DataConverter.Cast<string>( column[22] ),
Building = DataConverter.Cast<string>( column[23] ),
FloorId = DataConverter.Cast<int?>( column[24] ) ?? 0,
Phase = DataConverter.Cast<string>( column[25] ),
ElementType = DataConverter.Cast<string>( column[26] ),
Product = DataConverter.Cast<string>( column[27] ),
Style = DataConverter.Cast<string>( column[28] ),
Mass = DataConverter.Cast<double?>( column[29] ) ?? 0d,
ElementLength = DataConverter.Cast<double?>( column[30] ) ?? 0d,
ElementWidth = DataConverter.Cast<double?>( column[31] ) ?? 0d,
ElementHeight = DataConverter.Cast<double?>( column[32] ) ?? 0d,
GrossArea = DataConverter.Cast<double?>( column[33] ) ?? 0d,
NetArea = DataConverter.Cast<double?>( column[34] ) ?? 0d,
}
};
} );
foreach( var item in list )
{
parser.Parse( item.transport, item.veh, item.stack, item.elem );
}
}
return tmList;
}
/// <summary>
/// Load data, returns transport templates only
/// </summary>
/// <param name="transport"></param>
/// <returns></returns>
public List<RecTransport> LoadTransport( RecTransport record )
{
if( record == null )
{
throw new ArgumentNullException( "Transport" );
}
string project = "";
if( record.IsTemplate == 1 )
{
// Templates are saved on factory level (factory, factory), 2012-04-23
project = record.Factory;
}
else
{
project = record.Project;
}
ImpactQuery query = new ImpactQuery()
{
Select =
{
ImpTransport.TransportId,
ImpTransport.Description,
ImpTransport.LoadLocation,
ImpTransport.LoadDate,
ImpTransport.DeliveryDate,
ImpTransport.TimeInterval,
ImpTransport.LoadDivision,
ImpTransport.DeliveryDivision,
ImpTransport.IsTemplate,
ImpTransport.TemplateId,
ImpTransport.IsVisible,
ImpTransport.TransportStatus
},
From = { ImpTransport.As( "T1" ) },
Where = { ImpTransport.Factory.Equal( record.Factory ),
ImpTransport.Project.Equal( project ), // Templates are saved on factory level (factory, factory), 2012-04-23
ImpTransport.IsTemplate.Equal( record.IsTemplate )},
//OrderBy = {
// {ImpTransport.TransportId, OrderBy.Descending} // gives Asc !! to be corrected
// }
};
string statement = query.ToString();
statement += " ORDER BY T1.TRANSPORT_ID DESC";
List<RecTransport> result;
using( ImpactDatabase database = new ImpactDatabase() )
{
result = database.GetAll( statement, column =>
{
return new RecTransport()
{
Factory = record.Factory,
Project = record.Project,
TransportId = DataConverter.Cast<int>( column[0] ),
Description = DataConverter.Cast<string>( column[1] ),
LoadLocation = DataConverter.Cast<string>( column[2] ),
LoadDate = DataConverter.Cast<DateTime>( column[3] ),
DeliveryDate = DataConverter.Cast<DateTime>( column[4] ),
TimeInterval = DataConverter.Cast<int>( column[5] ),
LoadDivision = DataConverter.Cast<string>( column[6] ),
DeliveryDivision = DataConverter.Cast<string>( column[7] ),
IsTemplate = DataConverter.Cast<int>( column[8] ),
TemplateId = DataConverter.Cast<int>( column[9] ),
IsVisible = DataConverter.Cast<int>( column[10] ),
TransportStatus = DataConverter.Cast<int>( column[11] ),
};
} );
}
return result;
}
/// <summary>
/// Returns a list of elements that are allowed to bed positioned of the given castunit(bed)
/// </summary>
/// <param name="filter">curFilter</param>
/// <param name="form">castunit</param>
/// <param name="recProductionCast"> </param>
/// <param name="elements">A list of elements to be positioned</param>
/// <param name="strict">Strict flag</param>
/// <returns></returns>
private List<RecTMElement> LoadAllowedElements( BedFilter filter, RecProductionFormStd form, RecProductionCast recProductionCast, List<RecTMElement> elements, bool strict )
{
if( elements == null || elements.Count == 0 || form == null &&
filter == null || string.IsNullOrEmpty( filter.Factory ) || string.IsNullOrEmpty( filter.Project ) )
{
return null;
}
var inVect = ( from o in elements select o.ElementId ).ToArray();
List<RecTMElement> result;
var query = new ImpactQuery()
{
Select =
{
ImpElement.ElementMark,
ImpElement.ElementLength,
ImpElement.ElementWidth,
ImpElement.ElementHeight,
ImpElement.ElementType,
ImpElement.AngleLeftSide,
ImpElement.AngleRightSide,
ImpElement.Style,
ImpElement.Strandptn,
ImpElement.NbrOfStrands,
ImpModelGeometry.Factory,
ImpModelGeometry.Project,
ImpModelGeometry.ElementId,
},
From = { ImpElement.As( "ELM" ) },
Join =
{
Join.Left( ImpModelGeometry.As( "GEO" ),
ImpModelGeometry.Factory.Equal( ImpElement.Factory ),
ImpModelGeometry.Project.Equal( ImpElement.Project ),
ImpModelGeometry.ElementMark.Equal( ImpElement.ElementMark ) ),
},
Where = {
ImpElement.Factory.Equal( filter.Factory ),
ImpElement.Project.Equal( filter.Project ),
ImpModelGeometry.ElementId.In( inVect ),
},
};
if( form != null && ( strict && form.FormType == FormType.Bed ) )
{
query.Where.Add( ImpElement.ElementType.Equal( form.ElementType ) );
var hasStrands = form.ElementType.Equals( ImpactElementType.HollowCore ) ||
form.ElementType.Equals( ImpactElementType.PrestressedSlab ) ||
form.ElementType.Equals( ImpactElementType.PrestressedFormSlab );
if( hasStrands )
{
if( filter.ForceStyleControl )
{
var style = (null != recProductionCast)? recProductionCast.Style : form.Style;
var strandptn = (null != recProductionCast)? recProductionCast.Strandptn : form.Strandptn;
var nbrOfStrands = (null != recProductionCast)? GetNumberOfStrands( recProductionCast ) : GetNumberOfStrands( form );
query.Where.Add( ImpElement.Style.Equal( style ) );
query.Where.Add( ImpElement.Strandptn.Equal( strandptn ) );
query.Where.Add( ImpElement.NbrOfStrands.LessThanOrEqual( nbrOfStrands ) );
}
}
}
var statement = query.ToString();
using( var database = new ImpactDatabase() )
{
result = database.GetAll( statement, ElementParse );
}
return result;
}
/// <summary>
/// The load user data.
/// </summary>
/// <param name="user">
/// The user.
/// </param>
/// <returns>
/// The StruSoft.Impact.V120.ProjectManager.Core.ProjectBrowserData.UserData.
/// </returns>
public UserData LoadUserData( string user )
{
user = user.ToLower();
ImpactQuery query = new ImpactQuery( true )
{
From = {
ImpUser.As( "U" )
},
Select = {
ImpUserGroup.Company, ImpUserGroupStd.RoleId
},
Join =
{
Join.Inner( ImpUserGroup.As( "UG" ), ImpUser.Userid.Equal( ImpUserGroup.Userid ) ),
Join.Inner( ImpUserGroupStd.As( "UGS" ), ImpUserGroup.UserGroup.Equal( ImpUserGroupStd.Name ) ),
},
Where = {
ImpUser.Userid.Equal( user )
},
};
string statement = query.ToString();
UserData userData = new UserData
{
UserId = user
};
using( var database = new ImpactDatabase() )
{
var groupedCompanyRoleList = database.GetAll(
statement,
column => new
{
Company = column[0].Cast<string>(),
Role = column[1].Cast<UserRole>(),
}
).GroupBy( x => x.Company ).ToList();
foreach( var companyGroup in groupedCompanyRoleList )
{
UserRoleData urd = new UserRoleData( companyGroup.Key, from item in companyGroup select item.Role );
userData.UserRoles.Add( urd );
}
}
return userData;
}
/// <summary>
/// Returns a new erections sequence number for the specified project, of the specified factory.
/// </summary>
/// <param name="factory">
/// The factory to which the project belongs.
/// </param>
/// <param name="project">
/// The project.
/// </param>
/// <returns>
/// The next available erection sequence number.
/// </returns>
public int GetNewErectionSequenceNumber( string factory, string project )
{
project = project.PadLeft( 12 );
ImpactQuery query = new ImpactQuery
{
Select = {
Aggregate.Max( ImpModelPlanning.ErectionSequenceNo )
},
From = {
ImpModelPlanning.As( "T1" )
},
Where =
{
ImpModelPlanning.Factory.Equal( factory ),
ImpModelPlanning.Project.Equal( project ),
},
};
string statement = query.ToString();
using( var database = new ImpactDatabase() )
{
var erectionSequenceList = database.GetAll( statement, column => column[0].Cast<int>() );
int maxEs = 0;
if( erectionSequenceList.Count != 0 )
{
maxEs = erectionSequenceList[0];
}
maxEs++;
return maxEs;
}
}
/// <summary>
/// Returns CastData which contains the following info
/// (1) List<RecProductionFormStd>: a set of beds, each with one production cast ONLY.
/// The production cast object can contain elements.
/// (2) ProductionFormStdData: Production Forms Standard Data
/// </summary>
/// <param name="filter">BedFilter</param>
/// <param name="form">RecProductionFormStd</param>
/// <returns></returns>
public CastData LoadBedPlanning( BedFilter filter, RecProductionFormStd form )
{
if( null == filter ||
string.IsNullOrEmpty( filter.Factory ) ||
string.IsNullOrEmpty( filter.Project ) )
{
return null;
}
ImpactQuery query = new ImpactQuery()
{
Select =
{
ImpProductionCast.CastId,
ImpProductionCast.Description,
ImpProductionCast.StartDate,
ImpProductionCast.EndDate,
ImpProductionCast.Tolerance,
ImpProductionCast.ElementType,
ImpProductionCast.Style,
ImpProductionCast.Strandptn,
ImpProductionCast.CastType,
ImpProductionCast.CastStatus,
ImpProductionCast.Form,
ImpProductionCast.Shift,
Aggregate.Count( ImpProductionCastStrand.StrandPos ),
ImpProductionFormStd.Name,
ImpProductionFormStd.MaxLength,
ImpProductionFormStd.MaxWidth,
ImpProductionFormStd.MaxHeight,
ImpProductionFormStd.ElementType,
ImpProductionFormStd.Style,
ImpProductionFormStd.Strandptn,
ImpProductionFormStd.StrandType,
ImpProductionFormStd.FormType,
ImpModelPlanning.ElementId,
ImpModelGeometry.ElementMark,
ImpModelPlanning.ErectionSequenceNo,
ImpModelPlanning.TransportId,
ImpModelPlanning.BedSequenceNo,
ImpModelPlanning.BedX,
ImpModelPlanning.BedY,
ImpModelPlanning.BedZ,
ImpModelPlanning.BedRotation,
ImpModelPlanning.ElementIdStatus,
ImpModelPlanning.ProductionDate,
ImpModelPlanning.PlannedProductionDate,
ImpElement.ElementLength,
ImpElement.ElementWidth,
ImpElement.ElementHeight,
ImpElement.ElementType,
ImpElement.GrossArea,
ImpElement.Product,
ImpElement.Project,
ImpElement.AngleLeftSide,
ImpElement.AngleRightSide,
ImpElement.Style,
ImpElement.Strandptn,
ImpElement.NbrOfStrands,
ImpElement.Volume,
},
From = { ImpProductionFormStd.As( "FRM" ) },
Join =
{
Join.Left( ImpProductionCast.As( "CST" ),
ImpProductionCast.Factory.Equal( ImpProductionFormStd.Factory ),
ImpProductionCast.Project.Equal( ImpProductionFormStd.Project ),//Factory, Factory
ImpProductionCast.Form.Equal( ImpProductionFormStd.Name ) ),
Join.Left( ImpProductionCastStrand.As( "STA" ),
ImpProductionCast.Factory.Equal( ImpProductionCastStrand.Factory ),
ImpProductionCast.Project.Equal( ImpProductionCastStrand.Project ),// Factory, Factory for productionCast & ProductionCastStrand
ImpProductionCast.CastId.Equal( ImpProductionCastStrand.CastId ) ),
Join.Left( ImpModelPlanning.As( "MPL" ),
ImpProductionCast.Factory.Equal( ImpModelPlanning.Factory ),
ImpProductionCast.Project.Equal( ImpModelPlanning.Factory ),// Factory, Factory for productionCast & ProductionCastStrand
ImpProductionCast.CastId.Equal( ImpModelPlanning.CastId ) ),
Join.Left( ImpModelGeometry.As( "MGO" ),
ImpModelPlanning.Factory.Equal( ImpModelGeometry.Factory ),
ImpModelPlanning.Project.Equal( ImpModelGeometry.Project ),
ImpModelPlanning.ElementId.Equal( ImpModelGeometry.ElementId ) ),
Join.Left( ImpElement.As( "ELM" ),
ImpModelGeometry.Factory.Equal( ImpElement.Factory ),
ImpModelGeometry.Project.Equal( ImpElement.Project ),
ImpModelGeometry.ElementMark.Equal( ImpElement.ElementMark ) ),
},
Where = {
ImpProductionCast.Factory.Equal( filter.Factory ),
ImpProductionCast.Project.Equal( filter.Factory ), // Factory, Factory for productionCast & ProductionCastStrand
ImpProductionCast.StartDate.Equal( filter.StartDateFrom ),
ImpProductionCast.Shift.Equal( filter.Shift ),
// ImpModelPlanning.CastId.GreaterThan( 0 ), // Get even the casts without elements!
},
GroupBy =
{
ImpProductionCast.CastId,
ImpProductionCast.Description,
ImpProductionCast.StartDate,
ImpProductionCast.EndDate,
ImpProductionCast.Tolerance,
ImpProductionCast.ElementType,
ImpProductionCast.Style,
ImpProductionCast.Strandptn,
ImpProductionCast.CastType,
ImpProductionCast.CastStatus,
ImpProductionCast.Form,
ImpProductionCast.Shift,
ImpProductionFormStd.Name,
ImpProductionFormStd.MaxLength,
ImpProductionFormStd.MaxWidth,
ImpProductionFormStd.MaxHeight,
ImpProductionFormStd.ElementType,
ImpProductionFormStd.Style,
ImpProductionFormStd.Strandptn,
ImpProductionFormStd.StrandType,
ImpProductionFormStd.FormType,
ImpModelPlanning.ElementId,
ImpModelGeometry.ElementMark,
ImpModelPlanning.ErectionSequenceNo,
ImpModelPlanning.TransportId,
ImpModelPlanning.BedSequenceNo,
ImpModelPlanning.BedX,
ImpModelPlanning.BedY,
ImpModelPlanning.BedZ,
ImpModelPlanning.BedRotation,
ImpModelPlanning.ElementIdStatus,
ImpModelPlanning.ProductionDate,
ImpModelPlanning.PlannedProductionDate,
ImpElement.ElementLength,
ImpElement.ElementWidth,
ImpElement.ElementHeight,
ImpElement.ElementType,
ImpElement.GrossArea,
ImpElement.Product,
ImpElement.Project,
ImpElement.AngleLeftSide,
ImpElement.AngleRightSide,
ImpElement.Style,
ImpElement.Strandptn,
ImpElement.NbrOfStrands,
ImpElement.Volume,
},
OrderBy =
{
{ ImpElement.Project },
{ ImpProductionFormStd.Name },
{ ImpProductionCast.CastId },
{ ImpModelPlanning.BedSequenceNo, OrderBy.Ascending }
},
};
if( filter.FormType != FormType.All )
{
query.Where.Add( ImpProductionCast.CastType.Equal( filter.FormType ) );
}
if( !string.IsNullOrWhiteSpace( filter.Location ) && !filter.Location.Equals( Filter.All ) )
{
query.Where.Add( ImpProductionFormStd.Location.Equal( filter.Location ) );
}
if( !filter.Bed.Equals( Filter.All ) )
{
query.Where.Add( ImpProductionCast.Form.Equal( filter.Bed ) );
}
// used when sorting elements on bed
if( form != null && !string.IsNullOrWhiteSpace( form.Name ) )
{
query.Where.Add( ImpProductionFormStd.Name.Equal( form.Name ) );
}
var statement = query.ToString();
var tmList = new List<RecProductionFormStd>();
var parser = new FormParser( tmList );
using( var database = new ImpactDatabase() )
{
var list = database.GetAll( statement, ParseCast );
foreach( var item in list )
{
item.Form.Factory = filter.Factory;
item.Cast.Factory = filter.Factory;
item.Form.Project = filter.Project; // What does that really mean!
item.Cast.Project = filter.Project; // What does that really mean!
if( null != item.Element )
{
item.Element.Factory = filter.Factory;
// Never set element.project to curFilter.project
// since we retrieve elmenets from different projects!
}
parser.Parse( item.Form, item.Cast, item.Element );
}
}
var formSvc = new ProjectManager();
var filter2 = new BedFilter( filter ) { Location = "" };
var productionFormStdData = formSvc.LoadProductionFormStd( filter2 );
// Load strands
LoadCastStrands( tmList, filter );
LoadFormStrands( productionFormStdData.Forms, filter );
return new CastData( tmList, productionFormStdData );
}
/// <summary>
/// Returns a set of casts with element information
/// </summary>
/// <param name="filter">curFilter</param>
/// <param name="reportFilter"> </param>
/// <returns></returns>
public CastScheduleData LoadCastSchedule( BedFilter filter, ReportFilter reportFilter )
{
if( filter == null || string.IsNullOrEmpty( filter.Factory ) || string.IsNullOrEmpty( filter.Project ) )
{
return null;
}
var query = new ImpactQuery()
{
Select =
{
ImpProductionCast.CastId,
ImpProductionCast.Description,
ImpProductionCast.StartDate,
ImpProductionCast.EndDate,
ImpProductionCast.Tolerance,
ImpProductionCast.ElementType,
ImpProductionCast.Style,
ImpProductionCast.Strandptn,
ImpProductionCast.CastStatus,
ImpProductionCast.CastType,
ImpProductionCast.Form,
ImpProductionCast.Shift,
Aggregate.Count( ImpProductionCastStrand.StrandPos ),
ImpProductionFormStd.Location,
ImpProductionFormStd.FormType,
ImpProductionFormStd.MaxLength,
ImpProductionFormStd.MaxWidth,
ImpProductionFormStd.MaxHeight,
ImpProductionFormStd.ElementType,
ImpModelPlanning.ElementId,
ImpModelGeometry.ElementMark,
ImpModelGeometry.Building,
ImpModelGeometry.FloorId,
ImpModelGeometry.Phase,
ImpModelPlanning.ErectionSequenceNo,
ImpModelPlanning.TransportId,
ImpModelPlanning.BedSequenceNo,
ImpModelPlanning.BedX,
ImpModelPlanning.BedY,
ImpModelPlanning.BedZ,
ImpModelPlanning.BedRotation,
ImpModelPlanning.ElementIdStatus,
ImpModelPlanning.ProductionDate,
ImpModelPlanning.PlannedProductionDate,
ImpElement.ElementLength,
ImpElement.ElementWidth,
ImpElement.ElementHeight,
ImpElement.ElementType,
ImpElement.GrossArea,
ImpElement.NetArea,
ImpElement.Volume,
ImpElement.Product,
ImpElement.Project,
ImpElement.AngleLeftSide,
ImpElement.AngleRightSide,
ImpElement.Mass,
ImpElement.Style,
ImpElement.Strandptn,
ImpElement.NbrOfStrands,
},
From = { ImpProductionCast.As( "CST" ) },
Join =
{
Join.Left( ImpProductionCastStrand.As( "STA" ),
ImpProductionCast.Factory.Equal( ImpProductionCastStrand.Factory ),
ImpProductionCast.Project.Equal( ImpProductionCastStrand.Project ),//Factory, Factory
ImpProductionCast.CastId.Equal( ImpProductionCastStrand.CastId ) ),
Join.Left( ImpProductionFormStd.As( "FRM" ),
ImpProductionCast.Factory.Equal( ImpProductionFormStd.Factory ),
ImpProductionCast.Project.Equal( ImpProductionFormStd.Project ),// Factory, Factory for productionCast & ProductionCastStrand
ImpProductionCast.Form.Equal( ImpProductionFormStd.Name ) ),
Join.Left( ImpModelPlanning.As( "MPL" ),
ImpProductionCast.Factory.Equal( ImpModelPlanning.Factory ),
ImpProductionCast.Project.Equal( ImpModelPlanning.Factory ),// Factory, Factory for productionCast & ProductionCastStrand
ImpProductionCast.CastId.Equal( ImpModelPlanning.CastId ) ),
Join.Left( ImpModelGeometry.As( "MGO" ),
ImpModelPlanning.Factory.Equal( ImpModelGeometry.Factory ),
ImpModelPlanning.Project.Equal( ImpModelGeometry.Project ),
ImpModelPlanning.ElementId.Equal( ImpModelGeometry.ElementId ) ),
Join.Left( ImpElement.As( "ELM" ),
ImpModelGeometry.Factory.Equal( ImpElement.Factory ),
ImpModelGeometry.Project.Equal( ImpElement.Project ),
ImpModelGeometry.ElementMark.Equal( ImpElement.ElementMark ) ),
},
Where = {
ImpProductionCast.Factory.Equal( filter.Factory ),
ImpProductionCast.Project.Equal( filter.Factory ), // Factory, Factory for productionCast & ProductionCastStrand
//ImpModelPlanning.CastId.GreaterThan( 0 ),
},
GroupBy =
{
ImpProductionCast.CastId,
ImpProductionCast.Description,
ImpProductionCast.StartDate,
ImpProductionCast.EndDate,
ImpProductionCast.Tolerance,
ImpProductionCast.ElementType,
ImpProductionCast.Style,
ImpProductionCast.Strandptn,
ImpProductionCast.CastStatus,
ImpProductionCast.CastType,
ImpProductionCast.Form,
ImpProductionCast.Shift,
ImpProductionFormStd.Location,
ImpProductionFormStd.FormType,
ImpProductionFormStd.MaxLength,
ImpProductionFormStd.MaxWidth,
ImpProductionFormStd.MaxHeight,
ImpProductionFormStd.ElementType,
ImpModelPlanning.ElementId,
ImpModelGeometry.ElementMark,
ImpModelGeometry.Building,
ImpModelGeometry.FloorId,
ImpModelGeometry.Phase,
ImpModelPlanning.ErectionSequenceNo,
ImpModelPlanning.TransportId,
ImpModelPlanning.BedSequenceNo,
ImpModelPlanning.BedX,
ImpModelPlanning.BedY,
ImpModelPlanning.BedZ,
ImpModelPlanning.BedRotation,
ImpModelPlanning.ElementIdStatus,
ImpModelPlanning.ProductionDate,
ImpModelPlanning.PlannedProductionDate,
ImpElement.ElementLength,
ImpElement.ElementWidth,
ImpElement.ElementHeight,
ImpElement.ElementType,
ImpElement.GrossArea,
ImpElement.NetArea,
ImpElement.Volume,
ImpElement.Product,
ImpElement.Project,
ImpElement.AngleLeftSide,
ImpElement.AngleRightSide,
ImpElement.Mass,
ImpElement.Style,
ImpElement.Strandptn,
ImpElement.NbrOfStrands,
},
OrderBy =
{
{ ImpElement.Project },
{ ImpProductionCast.StartDate, OrderBy.Descending },
{ ImpProductionCast.CastId },
},
};
var whereStatus = WhereGroup.Or( new Where[] { } );
if( filter.NoStatus )
{
whereStatus.Add( ImpProductionCast.CastStatus.Equal( CastStatus.NoStatus ) );
}
if( filter.Planned )
{
whereStatus.Add( ImpProductionCast.CastStatus.Equal( CastStatus.Planned ) );
}
if( filter.Produced )
{
whereStatus.Add( ImpProductionCast.CastStatus.Equal( CastStatus.Produced ) );
}
if( whereStatus.Count > 0 )
{
query.Where.Add( whereStatus );
}
if( filter.UseStartDateFrom )
{
query.Where.Add( ImpProductionCast.StartDate.GreaterThanOrEqual( filter.StartDateFrom ) );
}
if( filter.UseStartDateTo )
{
query.Where.Add( ImpProductionCast.StartDate.LessThanOrEqual( filter.StartDateTo ) );
}
if( filter.UseEndDateFrom )
{
query.Where.Add( ImpProductionCast.EndDate.GreaterThanOrEqual( filter.EndDateFrom ) );
}
if( filter.UseEndDateTo )
{
query.Where.Add( ImpProductionCast.EndDate.LessThanOrEqual( filter.EndDateTo ) );
}
if( filter.Shift != 0 )
{
query.Where.Add( ImpProductionCast.Shift.Equal( filter.Shift ) );
}
if( !string.IsNullOrEmpty(filter.Location) && !filter.Location.Equals( Filter.All ) )
{
query.Where.Add( ImpProductionFormStd.Location.Equal( filter.Location ) );
}
if( !filter.Bed.Equals( Filter.All ) )
{
query.Where.Add( ImpProductionCast.Form.Equal( filter.Bed ) );
}
if( !string.IsNullOrEmpty( filter.CastId ) )
{
query.Where.Add( ImpProductionCast.CastId.Like( filter.CastId ) );
}
if( reportFilter != null && reportFilter.Ranges.Count > 0 )
{
var list = new List<Where>();
foreach( var range in reportFilter.Ranges )
{
if( !string.IsNullOrEmpty( range.From ) && !string.IsNullOrEmpty( range.To ) )
{
list.Add( ImpProductionCast.CastId.Between( range.From, range.To ) );
}
}
if( list.Count > 0 )
{
query.Where.Add( WhereGroup.Or( list.ToArray() ) );
}
}
var statement = query.ToString();
var tmList = new List<RecProductionCast>();
var parser = new CastParser( tmList );
using( var database = new ImpactDatabase() )
{
var list = database.GetAll( statement, ParseSchedule );
foreach( var item in list )
{
item.Form.Factory = filter.Factory;
item.Cast.Factory = filter.Factory;
item.Form.Project = filter.Project;
item.Cast.Project = filter.Project;
if( null != item.Element )
{
item.Element.Factory = filter.Factory;
// Never set element.project to curFilter.project
// since we retrieve elmenets from different projects!
}
parser.Parse( item.Form, item.Cast, item.Element );
}
}
// Now load all the existing forms
var formSvc = new ProjectManager();
var productionFormStdData = formSvc.LoadProductionFormStd( new BedFilter( filter ) { Location = Filter.All } );
return new CastScheduleData( tmList, productionFormStdData );
}
/// <summary>
/// Returns a list of projects that are involved in a certain cast
/// </summary>
/// <param name="filter">curFilter</param>
/// <param name="castId">castId</param>
/// <returns></returns>
public List<string> LoadCastProjects( BedFilter filter, int castId )
{
if( null == filter || string.IsNullOrWhiteSpace( filter.Factory ) )
{
return null;
}
var query = new ImpactQuery( true )
{
Select =
{
ImpModelPlanning.Project,
},
From = { ImpProductionCast.As( "CST" ) },
Join =
{
Join.Left( ImpModelPlanning.As( "PLN" ),
ImpModelPlanning.Factory.Equal( ImpProductionCast.Factory ),
ImpModelPlanning.CastId.Equal( ImpProductionCast.CastId ) ),
},
Where = {
ImpModelPlanning.CastId.GreaterThan( 0 ),
ImpProductionCast.Factory.Equal( filter.Factory ),
},
};
if( castId > 0 )
{
query.Where.Add( ImpProductionCast.CastId.Equal( castId ) );
}
else
{
query.Where.Add( ImpProductionCast.StartDate.Equal( filter.StartDateFrom ) );
query.Where.Add( ImpProductionCast.Shift.Equal( filter.Shift ) );
}
string statement = query.ToString();
List<string> result;
using( ImpactDatabase database = new ImpactDatabase() )
{
result = database.GetAll( statement, Parse );
}
return result;
}
/// <summary>
/// The update erection sequence.
/// </summary>
/// <param name="factory">
/// The factory.
/// </param>
/// <param name="project">
/// The project.
/// </param>
/// <param name="erectionSequenceList">
/// The erection sequence list.
/// </param>
/// <returns>
/// The System.Boolean.
/// </returns>
public bool UpdateErectionSequence( string factory, string project, List<KeyValuePair<int, int>> erectionSequenceList )
{
project = project.PadLeft( 12 );
List<string> statementList = new List<string>( erectionSequenceList.Count );
using( var database = new ImpactDatabase() )
{
var allIdArray = erectionSequenceList.Select( x => (object)x.Key ).ToArray();
ImpactQuery query = new ImpactQuery
{
Select = {
ImpModelPlanning.ElementId
},
From = {
ImpModelPlanning.As( "T1" )
},
Where =
{
ImpModelPlanning.Factory.Equal( factory ),
ImpModelPlanning.Project.Equal( project ),
ImpModelPlanning.ElementId.In( allIdArray ),
},
};
string statement = query.ToString();
var existingPlanningList = database.GetAll( statement, column => column[0].Cast<int>() );
var groupedByInsertUpdate = erectionSequenceList.GroupBy( x => existingPlanningList.Remove( x.Key ) ).ToList();
var updateList = groupedByInsertUpdate.Find( x => x.Key );
var insertList = groupedByInsertUpdate.Find( x => !x.Key );
if( null != updateList )
{
foreach( var item in updateList )
{
var update = new ImpactUpdate( ImpModelPlanning.Instance )
{
Columns = {
{ ImpModelPlanning.ErectionSequenceNo, item.Value }
},
Where =
{
ImpModelPlanning.Factory.Equal( factory ),
ImpModelPlanning.Project.Equal( project ),
ImpModelPlanning.ElementId.Equal( item.Key ),
}
};
statementList.Add( update.ToString() );
}
}
if( null != insertList )
{
foreach( var item in insertList )
{
var insert = new ImpactInsert( ImpModelPlanning.Instance )
{
Columns =
{
{ ImpModelPlanning.Factory, factory },
{ ImpModelPlanning.Project, project },
{ ImpModelPlanning.ElementId, item.Key },
{ ImpModelPlanning.ErectionSequenceNo, item.Value },
},
};
statementList.Add( insert.ToString() );
}
}
int result = database.ExecuteNonQuery( statementList.ToArray() );
return result > 0;
}
}
private RecTransportVehicleStd LoadVehicleStdDetails( RecTransportVehicleStd record )
{
if( record == null )
{
throw new ArgumentNullException( "VehicleStd" );
}
ImpactQuery query = new ImpactQuery()
{
Select =
{
ImpTransportVehicleStd.Name,
ImpTransportVehicleStd.Description,
ImpTransportVehicleStd.MaxLength,
ImpTransportVehicleStd.MaxWidth,
ImpTransportVehicleStd.MaxHeight,
ImpTransportVehicleStd.MaxMass,
ImpTransportVehicleStd.VehicleType,
ImpTransportVehicleStd.TransportType,
},
From = { ImpTransportVehicleStd.As( "T1" ) },
Where = { ImpTransportVehicleStd.Factory.Equal( record.Factory ),
ImpTransportVehicleStd.Project.Equal( record.Factory ),
ImpTransportVehicleStd.Name.Equal( record.Name)}
};
string statement = query.ToString();
RecTransportVehicleStd result;
using( ImpactDatabase database = new ImpactDatabase() )
{
result = database.GetFirst<RecTransportVehicleStd>( statement, column =>
{
return new RecTransportVehicleStd()
{
Factory = record.Factory,
Project = record.Project,
Name = DataConverter.Cast<string>( column[0] ),
Description = DataConverter.Cast<string>( column[1] ),
MaxLength = DataConverter.Cast<double>( column[2] ),
MaxWidth = DataConverter.Cast<double>( column[3] ),
MaxHeight = DataConverter.Cast<double>( column[4] ),
MaxMass = DataConverter.Cast<double>( column[5] ),
VehicleType = DataConverter.Cast<int>( column[6] ),
TransportType = DataConverter.Cast<int>( column[7] ),
};
} );
}
if( result != null )
{
result.Factory = record.Factory;
result.Project = record.Project;
result.TransportType = record.TransportType; // Hmm which one should be used?
result.VehicleId = record.VehicleId;
result.TransportId = record.TransportId;
}
return result;
}
/// <summary>
/// The update planning element data.
/// </summary>
/// <param name="factory">
/// The factory.
/// </param>
/// <param name="project">
/// The project.
/// </param>
/// <param name="planningElementList">
/// The planning element list.
/// </param>
/// <exception cref="InvalidOperationException">
/// Thrown when the database source is unknown.
/// </exception>
public void UpdatePlanningElementData( string factory, string project, List<PlanningElementDataUpdate> planningElementList )
{
project = Util.CorrectProjectName( project );
switch( ImpactDatabase.DataSource )
{
case DataSource.Ingres92:
case DataSource.Ingres100:
{
// Create a query that return all the id's of those elements that aldready has planning data.
ImpactQuery query = new ImpactQuery()
{
From = { ImpModelPlanning.As( "T1" ) },
Select = { ImpModelPlanning.ElementId },
Where =
{
ImpModelPlanning.Factory.Equal(factory),
ImpModelPlanning.Project.Equal(project),
ImpModelPlanning.ElementId.In<int>( planningElementList.Select( element => element.ElementId ) )
}
};
using( var database = new ImpactDatabase() )
{
var existingIds = database.GetAll( query.ToString(), reader => reader[0].Cast<int>() );
var statementList = new List<string>( planningElementList.Count );
foreach( var element in planningElementList )
{
string producingFactory;
if( 0 == string.Compare( Factory.External.Number, element.ProducingFactory, StringComparison.OrdinalIgnoreCase ) )
{
producingFactory = ProjectBrowserLoader.ProducingFactoryExternalValue;
}
else
{
producingFactory = element.ProducingFactory;
}
if( existingIds.Contains( element.ElementId ) )
{
// We have an update.
var update = new ImpactUpdate( ImpModelPlanning.Instance )
{
Where =
{
ImpModelPlanning.Factory.Equal( factory ),
ImpModelPlanning.Project.Equal( project ),
ImpModelPlanning.ElementId.Equal( element.ElementId ),
},
Columns =
{
{ ImpModelPlanning.ProductionFactory, producingFactory ?? string.Empty },
{ ImpModelPlanning.DivisionProduction, element.Division ?? string.Empty },
{ ImpModelPlanning.ProductionDate, element.ProductionDate },
{ ImpModelPlanning.DeliveryDate, element.DeliveryDate },
{ ImpModelPlanning.ErectionSequenceNo, element.ErectionSequenceNo },
{ ImpModelPlanning.PlannedDrawingDate, element.PlannedDrawingDate },
{ ImpModelPlanning.PlannedProductionDate, element.PlannedProductionDate },
{ ImpModelPlanning.PlannedReadyForDeliveryDate, element.PlannedStorageDate },
{ ImpModelPlanning.PlannedDeliveryDate, element.PlannedDeliveryDate },
{ ImpModelPlanning.PlannedErectionDate, element.PlannedErectionDate },
{ ImpModelPlanning.ElementIdStatus, element.Status },
}
};
statementList.Add( update.ToString() );
}
else
{
// We must insert a new row.
var insert = new ImpactInsert( ImpModelPlanning.Instance )
{
Columns =
{
{ ImpModelPlanning.Factory, factory },
{ ImpModelPlanning.Project, project },
{ ImpModelPlanning.ElementId, element.ElementId },
{ ImpModelPlanning.ProductionFactory, producingFactory ?? string.Empty },
{ ImpModelPlanning.DivisionProduction, element.Division ?? string.Empty },
{ ImpModelPlanning.ProductionDate, element.ProductionDate },
{ ImpModelPlanning.DeliveryDate, element.DeliveryDate },
{ ImpModelPlanning.ErectionSequenceNo, element.ErectionSequenceNo },
{ ImpModelPlanning.PlannedDrawingDate, element.PlannedDrawingDate },
{ ImpModelPlanning.PlannedProductionDate, element.PlannedProductionDate },
{ ImpModelPlanning.PlannedReadyForDeliveryDate, element.PlannedStorageDate },
{ ImpModelPlanning.PlannedDeliveryDate, element.PlannedDeliveryDate },
{ ImpModelPlanning.PlannedErectionDate, element.PlannedErectionDate },
{ ImpModelPlanning.ElementIdStatus, element.Status },
}
};
statementList.Add( insert.ToString() );
}
}
database.ExecuteNonQuery( statementList.ToArray() );
}
break;
}
case DataSource.SqlServer:
case DataSource.SqlServerExpress:
{
List<string> statementList = new List<string>( planningElementList.Count );
foreach( var element in planningElementList )
{
string producingFactory;
if( 0 == string.Compare( Factory.External.Number, element.ProducingFactory, StringComparison.OrdinalIgnoreCase ) )
{
producingFactory = ProjectBrowserLoader.ProducingFactoryExternalValue;
}
else
{
producingFactory = element.ProducingFactory;
}
ImpactInsertOrUpdate insertOrUpdate = new ImpactInsertOrUpdate( ImpModelPlanning.Instance )
{
Keys =
{
{ ImpModelPlanning.Factory, factory },
{ ImpModelPlanning.Project, project },
{ ImpModelPlanning.ElementId, element.ElementId },
},
Columns =
{
{ ImpModelPlanning.ProductionFactory, producingFactory ?? string.Empty },
{ ImpModelPlanning.DivisionProduction, element.Division ?? string.Empty },
{ ImpModelPlanning.ProductionDate, element.ProductionDate },
{ ImpModelPlanning.DeliveryDate, element.DeliveryDate },
{ ImpModelPlanning.ErectionSequenceNo, element.ErectionSequenceNo },
{ ImpModelPlanning.PlannedDrawingDate, element.PlannedDrawingDate },
{ ImpModelPlanning.PlannedProductionDate, element.PlannedProductionDate },
{ ImpModelPlanning.PlannedReadyForDeliveryDate, element.PlannedStorageDate },
{ ImpModelPlanning.PlannedDeliveryDate, element.PlannedDeliveryDate },
{ ImpModelPlanning.PlannedErectionDate, element.PlannedErectionDate },
{ ImpModelPlanning.ElementIdStatus, element.Status },
}
};
statementList.Add( insertOrUpdate.ToString() );
}
using( var database = new ImpactDatabase() )
{
database.ExecuteNonQuery( statementList.ToArray() );
}
break;
}
default:
{
throw new InvalidOperationException( "Unknown database source." );
}
}
}
/// <summary>
/// GetUntransportedElement
/// </summary>
/// <param name="factory"></param>
/// <param name="project"></param>
/// <param name="elements"></param>
/// <returns></returns>
private List<RecTMElement> GetUntransportedElement( string factory, string project, List<RecTMElement> elements )
{
if( elements == null || elements.Count == 0 )
{
return null;
}
int[] InVect = new int[elements.Count];
// Linq is to be used
//InVect = (int[])(from row in elements select row.ElementId);
//int i = 0;
//foreach (RecTMElement rec in elements)
//{
// InVect[i] = rec.ElementId;
// i++;
//}
string whereIn = "";
foreach( RecTMElement rec in elements )
{
whereIn += rec.ElementId.ToString() + ",";
}
if( whereIn.Length > 0 )
{
whereIn = whereIn.Substring( 0, whereIn.Length - 1 );
}
List<RecTMElement> transported = null;
using( ImpactDatabase database = new ImpactDatabase() )
{
ImpactQuery query = new ImpactQuery()
{
From = { ImpModelPlanning.As( "T1" ) },
Select = { ImpModelPlanning.ElementId },
Where = { ImpModelPlanning.Factory.Equal(factory),
ImpModelPlanning.Project.Equal(project),
ImpModelPlanning.TransportId.GreaterThan(0)
} //ImpModelPlanning.ElementId.In(InVect) //To be used in stead of the code below!
};
string statement = query.ToString();
if( whereIn.Length > 0 )
{
statement += " AND T1.ELEMENT_ID " + "IN(" + whereIn + ")";
}
transported = database.GetAll( statement, column => new RecTMElement()
{
ElementId = DataConverter.Cast<int>( column[0] )
} );
}
List<RecTMElement> result = elements;
if( transported != null && transported.Count > 0 )
{
//Some of our elements in the list are already transported
//so remove them from the incoming list
result = new List<RecTMElement>();
foreach( RecTMElement rec in elements )
{
if( !IsTransported( rec, transported ) )
{
result.Add( rec );
}
}
}
return result;
}
/// <summary>
/// Returns max value of transport_id
/// </summary>
/// <param name="transport"></param>
/// <returns></returns>
public int GetMaxTransportId( RecTransport record )
{
if( record == null )
{
throw new ArgumentNullException( "Transport" );
}
int ret = 0;
using( ImpactDatabase database = new ImpactDatabase() )
{
ImpactQuery query = new ImpactQuery()
{
Select =
{
Aggregate.Max(ImpTransport.TransportId)
},
From = { ImpTransport.As( "T1" ) },
Where = { ImpTransport.Factory.Equal( record.Factory ),
ImpTransport.Project.Equal( record.Project ),
ImpTransport.TransportId.GreaterThan( 0 )},
};
string statement = query.ToString();
List<int> result = null;
try
{
result = database.GetAll( statement, column =>
{
return DataConverter.Cast<int?>( column[0] ) ?? 0;
} );
ret = result[0];
}
catch( Exception ) { }//Just eat it please!
}
return ret;
}
/// <summary>
/// Load Element status Settings
/// </summary>
/// <param name="record"></param>
/// <returns></returns>
public List<RecElementIdStatusStd> LoadStandardSettings( RecElementIdStatusStd record )
{
if( record == null || record.Factory == null )
{
return null;
}
string company = record.Factory.Substring( 0, 2 ) + "00"; //Is this really OK ??!!
// Prepare Factory, Project statement
ImpactQuery projectQuery = new ImpactQuery()
{
Select = {
ImpElementIdStatusStd.Factory,
ImpElementIdStatusStd.Project,
ImpElementIdStatusStd.StatusId,
ImpElementIdStatusStd.Description,
ImpElementIdStatusStd.StatusType,
ImpElementIdStatusStd.ColorIndex,
},
From = { ImpElementIdStatusStd.As( "T2" ) },
Where = {
{ ImpElementIdStatusStd.Factory.Equal( record.Factory )},
{ ImpElementIdStatusStd.Project.Equal( record.Project )},
},
};
string projectStatement = projectQuery.ToString();
// Prepare Factory, Factory statement
ImpactQuery factoryQuery = new ImpactQuery()
{
Select = {
ImpElementIdStatusStd.Factory,
ImpElementIdStatusStd.Project,
ImpElementIdStatusStd.StatusId,
ImpElementIdStatusStd.Description,
ImpElementIdStatusStd.StatusType,
ImpElementIdStatusStd.ColorIndex,
},
From = { ImpElementIdStatusStd.As( "T1" ) },
Where = {
{ ImpElementIdStatusStd.Factory.Equal( record.Factory )},
{ ImpElementIdStatusStd.Project.Equal( record.Factory )},
},
};
string factoryStatement = factoryQuery.ToString();
ImpactQuery projectSubquery = new ImpactQuery()
{
Select = { ImpElementIdStatusStd.StatusId },
From = { ImpElementIdStatusStd.As( "T1" ) },
Where = {
{ ImpElementIdStatusStd.Factory.Equal( record.Factory )},
{ ImpElementIdStatusStd.Project.Equal( record.Project )},
},
};
factoryStatement += " AND T1.Status_Id Not In (" + projectSubquery.ToString() + ")";
// Prepare Company, Company statement
ImpactQuery companyQuery = new ImpactQuery()
{
Select = {
ImpElementIdStatusStd.Factory,
ImpElementIdStatusStd.Project,
ImpElementIdStatusStd.StatusId,
ImpElementIdStatusStd.Description,
ImpElementIdStatusStd.StatusType,
ImpElementIdStatusStd.ColorIndex,
},
From = { ImpElementIdStatusStd.As( "T1" ) },
Where = {
{ ImpElementIdStatusStd.Factory.Equal( company )},
{ ImpElementIdStatusStd.Project.Equal( company )},
},
};
string companyStatement = companyQuery.ToString();
ImpactQuery factorySubquery = new ImpactQuery()
{
Select = { ImpElementIdStatusStd.StatusId },
From = { ImpElementIdStatusStd.As( "T1" ) },
Where = {
{ ImpElementIdStatusStd.Factory.Equal( record.Factory )},
{ ImpElementIdStatusStd.Project.Equal( record.Factory )},
},
};
companyStatement += " AND T1.Status_Id Not In (" + projectSubquery.ToString() + ")"
+ " AND T1.Status_Id Not In (" + factorySubquery.ToString() + ")";
string statement = projectStatement + " Union " + factoryStatement + " Union " + companyStatement + " Order By T2.Status_Id";
List<RecElementIdStatusStd> result;
using( ImpactDatabase database = new ImpactDatabase() )
{
result = database.GetAll( statement, SettingParse );
}
return result;
}
