public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from NodeRoute a where ");
NodeRoute noderoute = (NodeRoute)data;
if (noderoute != null)
{
Parms = new List<Object[]>();
if (noderoute.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", noderoute.RowID });
}
if (noderoute.NextNode != null && noderoute.NextNode.NodeID != 0)
{
sql.Append(" a.NextNode.NodeID = :id1 and ");
Parms.Add(new Object[] { "id1", noderoute.NextNode.NodeID });
}
if (noderoute.CurNode != null && noderoute.CurNode.NodeID != 0)
{
sql.Append(" a.CurNode.NodeID = :id2 and ");
Parms.Add(new Object[] { "id2", noderoute.CurNode.NodeID });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append("1=1 order by a.RowID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from ConnectionType a where ");
ConnectionType ConnectionType = (ConnectionType)data;
if (ConnectionType != null)
{
Parms = new List<Object[]>();
if (ConnectionType.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", ConnectionType.RowID });
}
if (ConnectionType.IsEditable != null)
{
sql.Append(" a.IsEditable = :edt and ");
Parms.Add(new Object[] { "edt", ConnectionType.IsEditable });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.RowID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from UnitProductEquivalence a where ");
UnitProductEquivalence unitproductequivalence = (UnitProductEquivalence)data;
if (unitproductequivalence != null)
{
Parms = new List<Object[]>();
if (unitproductequivalence.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", unitproductequivalence.RowID });
}
if (unitproductequivalence.UnitProductRelation != null && unitproductequivalence.UnitProductRelation.RowID != 0)
{
sql.Append(" a.UnitProductRelation.RowID = :id1 and ");
Parms.Add(new Object[] { "id1", unitproductequivalence.UnitProductRelation.RowID });
}
if (unitproductequivalence.EquivMeasureUnit != null && unitproductequivalence.EquivMeasureUnit.MeasureUnitID != 0)
{
sql.Append(" a.EquivMeasureUnit.MeasureUnitID = :id2 and ");
Parms.Add(new Object[] { "id2", unitproductequivalence.EquivMeasureUnit.MeasureUnitID });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.RowID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from DocumentConcept a where ");
DocumentConcept docconcept = (DocumentConcept)data;
if (docconcept != null)
{
Parms = new List<Object[]>();
if (docconcept.DocConceptID != 0)
{
sql.Append(" a.DocConceptID = :id and ");
Parms.Add(new Object[] { "id", docconcept.DocConceptID });
}
if (docconcept.DocClass != null && docconcept.DocClass.DocClassID != 0)
{
sql.Append(" a.DocClass.DocClassID = :id1 and ");
Parms.Add(new Object[] { "id1", docconcept.DocClass.DocClassID });
}
if (!String.IsNullOrEmpty(docconcept.Name))
{
sql.Append(" a.Name = :nom and ");
Parms.Add(new Object[] { "nom", docconcept.Name });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.DocConceptID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from IqTable a where ");
IqTable iqtable = (IqTable)data;
if (iqtable != null)
{
Parms = new List<Object[]>();
if (iqtable.TableId != 0)
{
sql.Append(" a.TableId = :id and ");
Parms.Add(new Object[] { "id", iqtable.TableId });
}
if (!String.IsNullOrEmpty(iqtable.Name))
{
sql.Append(" a.Name = :nom2 and ");
Parms.Add(new Object[] { "nom2", iqtable.Name });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append("1=1 order by a.TableId asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from C_CasNumber a where ");
C_CasNumber C_CasNumber = (C_CasNumber)data;
if (C_CasNumber != null)
{
Parms = new List<Object[]>();
if (C_CasNumber.CasNumberID != 0)
{
sql.Append(" a.CasNumberID = :id and ");
Parms.Add(new Object[] { "id", C_CasNumber.CasNumberID });
}
if (!String.IsNullOrEmpty(C_CasNumber.Name))
{
sql.Append(" (a.Name like :nom OR a.Code like :nomz) and ");
Parms.Add(new Object[] { "nom", "%" + C_CasNumber.Name + "%" });
Parms.Add(new Object[] { "nomz", C_CasNumber.Name + "%" });
}
if (!String.IsNullOrEmpty(C_CasNumber.Code))
{
sql.Append(" a.Code = :nom1 and ");
Parms.Add(new Object[] { "nom1", C_CasNumber.Code });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.CasNumberID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public override IQuery GetHsql(object data)
{
StringBuilder sql = new StringBuilder("select a from MenuOptionExtension a where ");
MenuOptionExtension MenuOptionExtension = (MenuOptionExtension)data;
if (MenuOptionExtension != null)
{
Parms = new List<Object[]>();
if (MenuOptionExtension.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", MenuOptionExtension.RowID });
}
if (MenuOptionExtension.MenuOption != null && MenuOptionExtension.MenuOption.MenuOptionID != 0)
{
sql.Append(" a.MenuOption.MenuOptionID = :id1 and ");
Parms.Add(new Object[] { "id1", MenuOptionExtension.MenuOption.MenuOptionID });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append("1=1 order by a.RowID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public override IQuery GetHsql(object data)
{
StringBuilder sql = new StringBuilder("select a from MenuOption a where ");
MenuOption menuoption = (MenuOption)data;
if (menuoption != null)
{
Parms = new List<Object[]>();
if (menuoption.MenuOptionID != 0)
{
sql.Append(" a.MenuOptionID = :id and ");
Parms.Add(new Object[] { "id", menuoption.MenuOptionID });
}
if (!String.IsNullOrEmpty(menuoption.Name))
{
sql.Append(" a.Name = :nom and ");
Parms.Add(new Object[] { "nom", menuoption.Name });
}
if (!String.IsNullOrEmpty(menuoption.Url))
{
sql.Append(" a.Url = :nom1 and ");
Parms.Add(new Object[] { "nom1", menuoption.Url });
}
if (menuoption.MenuOptionType != null && menuoption.MenuOptionType.MenuOptionTypeID != 0)
{
sql.Append(" a.MenuOptionType.MenuOptionTypeID = :id1 and ");
Parms.Add(new Object[] { "id1", menuoption.MenuOptionType.MenuOptionTypeID });
}
if (menuoption.NumOrder != 0)
{
sql.Append(" a.NumOrder = :id2 and ");
Parms.Add(new Object[] { "id2", menuoption.NumOrder });
}
if (menuoption.Active != null)
{
sql.Append(" a.Active = :ia2 and ");
Parms.Add(new Object[] { "ia2", menuoption.Active });
}
if (menuoption.OptionType != null && menuoption.OptionType.OpTypeID != 0)
{
sql.Append(" a.OptionType.OpTypeID = :io2 and ");
Parms.Add(new Object[] { "io2", menuoption.OptionType.OpTypeID });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append("1=1 order by a.MenuOptionID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from Rol a where ");
Rol rol = (Rol)data;
if (rol != null)
{
Parms = new List<Object[]>();
if (rol.RolID != 0)
{
sql.Append(" a.RolID = :id and ");
Parms.Add(new Object[] { "id", rol.RolID });
}
if (!String.IsNullOrEmpty(rol.RolCode))
{
sql.Append(" a.RolCode = :nom and ");
Parms.Add(new Object[] { "nom", rol.RolCode });
}
if (!String.IsNullOrEmpty(rol.Name))
{
sql.Append(" a.Name = :nom1 and ");
Parms.Add(new Object[] { "nom1", rol.Name });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append("1=1 order by a.RolID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public List<Team> FillTeams(Team homeTeam, Team awayTeam)
{
List<Team> teams = new List<Team>();
teams.Add(homeTeam);
teams.Add(awayTeam);
return teams;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from C_CasNumberRule a where ");
C_CasNumberRule C_CasNumberRule = (C_CasNumberRule)data;
if (C_CasNumberRule != null)
{
Parms = new List<Object[]>();
if (C_CasNumberRule.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", C_CasNumberRule.RowID });
}
if (C_CasNumberRule.CasNumber != null && C_CasNumberRule.CasNumber.CasNumberID != 0)
{
sql.Append(" a.CasNumber.CasNumberID = :idp1 and ");
Parms.Add(new Object[] { "idp1", C_CasNumberRule.CasNumber.CasNumberID });
}
if (C_CasNumberRule.Rule != null )
{
if (C_CasNumberRule.Rule.MetaMasterID != 0)
{
sql.Append(" a.Rule.MetaMasterID = :idc1 and ");
Parms.Add(new Object[] { "idc1", C_CasNumberRule.Rule.MetaMasterID });
}
if (C_CasNumberRule.Rule.MetaType != null)
{
if (C_CasNumberRule.Rule.MetaType.MetaTypeID != 0)
{
sql.Append(" a.Rule.MetaType.MetaTypeID = :itt1 and ");
Parms.Add(new Object[] { "itt1", C_CasNumberRule.Rule.MetaType.MetaTypeID });
}
if (!string.IsNullOrEmpty(C_CasNumberRule.Rule.MetaType.Code))
{
sql.Append(" a.Rule.MetaType.Code= :itc1 and ");
Parms.Add(new Object[] { "itc1", C_CasNumberRule.Rule.MetaType.Code });
}
}
}
if (! string.IsNullOrEmpty(C_CasNumberRule.RuleValue))
{
sql.Append(" a.RuleValue = :idz1 and ");
Parms.Add(new Object[] { "idz1", C_CasNumberRule.RuleValue });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.RowID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
/// <summary>
/// Creates the bonuses, obstacles and power ups contained in a level.
/// </summary>
/// <param name="interactiveEntityDescriptions">A list of interactive entity descriptions.</param>
/// <param name="physicsWorld">The physics world to create the entities in.</param>
/// <param name="interactiveEntities">An empty list to store the interactive entities in.</param>
/// <param name="mineCart">The mine cart entity.</param>
/// <param name="cartSwitch">The switch entity.</param>
/// <param name="spriteBatch">The sprite batch to use for rendering.</param>
/// <param name="contentManager">The game's content manager.</param>
public static void CreateInteractiveEntities(List<InteractiveEntityDescription> interactiveEntityDescriptions, ref World physicsWorld, ref List<InteractiveEntity> interactiveEntities, ref MineCart mineCart, ref Switch cartSwitch, SpriteBatch spriteBatch, ContentManager contentManager)
{
if (interactiveEntities.Count == 0)
{
foreach (InteractiveEntityDescription description in interactiveEntityDescriptions)
{
if (EntityConstants.PowerUpNames.Contains(description.Name))
{
interactiveEntities.Add(new PowerUp(ref physicsWorld, spriteBatch, contentManager, description, EntitySettingsLoader.GetPowerUpSettings(description.Name)));
}
else if (EntityConstants.BonusNames.Contains(description.Name) || EntityConstants.ObstacleNames.Contains(description.Name))
{
interactiveEntities.Add(new BonusOrObstacle(ref physicsWorld, spriteBatch, contentManager, description, EntitySettingsLoader.GetObstacleOrBonusSetting(description.Name)));
}
else if (description.Name == EntityConstants.CartBody)
{
mineCart = new MineCart(spriteBatch, contentManager, ref physicsWorld, description.Position, 100.0f, 240.0f, 350.0f, 80.0f, -80.0f);
}
else if (description.Name == EntityConstants.Switch)
{
cartSwitch = new Switch(spriteBatch, contentManager, ref physicsWorld, description.Position, mineCart);
}
}
}
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from Contract a where ");
Contract Contract = (Contract)data;
if (Contract != null)
{
Parms = new List<Object[]>();
if (Contract.ContractID != 0)
{
sql.Append(" a.ContractID = :id and ");
Parms.Add(new Object[] { "id", Contract.ContractID });
}
if (Contract.Account != null && Contract.Account.AccountID != 0)
{
sql.Append(" a.Account.AccountID = :id1 and ");
Parms.Add(new Object[] { "id1", Contract.Account.AccountID });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.ContractID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from ContactPosition a where ");
ContactPosition contactposition = (ContactPosition)data;
if (contactposition != null)
{
Parms = new List<Object[]>();
if (contactposition.ContactPositionID != 0)
{
sql.Append(" a.ContactPositionID = :id and ");
Parms.Add(new Object[] { "id", contactposition.ContactPositionID });
}
if (!String.IsNullOrEmpty(contactposition.Name))
{
sql.Append(" a.Name = :nom and ");
Parms.Add(new Object[] { "nom", contactposition.Name });
}
//if (contactposition.Status != null && contactposition.Status.StatusID != 0)
//{
// sql.Append(" a.Status.StatusID= :id1 and ");
// Parms.Add(new Object[] { "id1", contactposition.Status.StatusID });
//}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.contactPositionID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from ZoneBinRelation a where ");
ZoneBinRelation zoneRel = (ZoneBinRelation)data;
if ( zoneRel != null)
{
Parms = new List<Object[]>();
if ( zoneRel.Zone != null && zoneRel.Zone.ZoneID != 0 )
{
sql.Append(" a.Zone.ZoneID = :id and ");
Parms.Add(new Object[] { "id", zoneRel.Zone.ZoneID });
}
if (zoneRel.Bin != null && zoneRel.Bin.BinID != 0)
{
sql.Append(" a.Bin.BinID = :id1 and ");
Parms.Add(new Object[] { "id1", zoneRel.Bin.BinID });
}
if (zoneRel.BinType != 0)
{
sql.Append(" a.BinType = :id2 and ");
Parms.Add(new Object[] { "id2", zoneRel.BinType });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.Rank asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from MeasureType a where ");
MeasureType measuretype = (MeasureType)data;
if (measuretype != null)
{
Parms = new List<Object[]>();
if (measuretype.MeasureTypeID != 0)
{
sql.Append(" a.MeasureTypeID = :id and ");
Parms.Add(new Object[] { "id", measuretype.MeasureTypeID });
}
if (!String.IsNullOrEmpty(measuretype.Name))
{
sql.Append(" a.Name = :nom and ");
Parms.Add(new Object[] { "nom", measuretype.Name });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.measureTypeID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from ContactEntityRelation a where ");
ContactEntityRelation contactentityrelation = (ContactEntityRelation)data;
if (contactentityrelation != null)
{
Parms = new List<Object[]>();
if (contactentityrelation.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", contactentityrelation.RowID });
}
if (contactentityrelation.Contact != null && contactentityrelation.Contact.ContactID != 0)
{
sql.Append(" a.Contact.ContactID = :id1 and ");
Parms.Add(new Object[] { "id1", contactentityrelation.Contact.ContactID });
}
if (contactentityrelation.ClassEntity != null && contactentityrelation.ClassEntity.ClassEntityID != 0)
{
sql.Append(" a.classEntity.ClassEntityID = :id2 and ");
Parms.Add(new Object[] { "id2", contactentityrelation.ClassEntity.ClassEntityID });
}
if (contactentityrelation.EntityRowID != 0)
{
sql.Append(" a.EntityRowID = :id3 and ");
Parms.Add(new Object[] { "id3", contactentityrelation.EntityRowID });
}
if (contactentityrelation.ContactPosition != null && contactentityrelation.ContactPosition.ContactPositionID != 0)
{
sql.Append(" a.ContactPosition.ContactPositionID = :id4 and ");
Parms.Add(new Object[] { "id4", contactentityrelation.ContactPosition.ContactPositionID });
}
if (contactentityrelation.IsMain != null)
{
sql.Append(" upper(a.IsMain) like :nom and ");
Parms.Add(new Object[] { "nom", contactentityrelation.IsMain + "%" });
}
if (contactentityrelation.Status != null && contactentityrelation.Status.StatusID != 0)
{
sql.Append(" a.Status.StatusID = :id5 and ");
Parms.Add(new Object[] { "id5", contactentityrelation.Status.StatusID });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.RowID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public static List<string> getYears()
{
List<string> years = new List<string>();
years.Add("2015");
years.Add("2016");
years.Add("2017");
return years;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from Unit a where ");
Unit unit = (Unit)data;
if (unit != null)
{
Parms = new List<Object[]>();
if (unit.UnitID != 0)
{
sql.Append(" a.UnitID = :id and ");
Parms.Add(new Object[] { "id", unit.UnitID });
}
if (unit.Company != null && unit.Company.CompanyID != 0)
{
sql.Append(" a.Company.CompanyID = :id1 and ");
Parms.Add(new Object[] { "id1", unit.Company.CompanyID });
}
if (!String.IsNullOrEmpty(unit.Name))
{
sql.Append(" a.Name = :nom and ");
Parms.Add(new Object[] { "nom", unit.Name });
}
if (!String.IsNullOrEmpty(unit.ErpCode))
{
sql.Append(" a.ErpCode = :nom1 and ");
Parms.Add(new Object[] { "nom1", unit.ErpCode });
}
if (!String.IsNullOrEmpty(unit.ErpCodeGroup))
{
sql.Append(" a.ErpCodeGroup = :nom2 and ");
Parms.Add(new Object[] { "nom2", unit.ErpCodeGroup });
}
if (!String.IsNullOrEmpty(unit.Description))
{
sql.Append(" a.Description = :nom3 and ");
Parms.Add(new Object[] { "nom3", unit.Description });
}
if (unit.BaseAmount > 0)
{
sql.Append(" a.BaseAmount = :u3 and ");
Parms.Add(new Object[] { "u3", unit.BaseAmount });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.UnitID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from IqReportColumn a where ");
IqReportColumn iqreportcolumn = (IqReportColumn)data;
if (iqreportcolumn != null)
{
Parms = new List<Object[]>();
if (iqreportcolumn.ReportColumnId != 0)
{
sql.Append(" a.ReportColumnId = :id and ");
Parms.Add(new Object[] { "id", iqreportcolumn.ReportColumnId });
}
//if (iqreportcolumn.IsSelected != null)
//{
sql.Append(" a.IsSelected = :nom2 and ");
Parms.Add(new Object[] { "nom2", iqreportcolumn.IsSelected });
//}
if (!String.IsNullOrEmpty(iqreportcolumn.Alias))
{
sql.Append(" a.Alias = :nom3 and ");
Parms.Add(new Object[] { "nom3", iqreportcolumn.Alias });
}
if (iqreportcolumn.IsFiltered != null)
{
sql.Append(" a.IsFiltered = :nom4 and ");
Parms.Add(new Object[] { "nom4", iqreportcolumn.IsFiltered });
}
if (!String.IsNullOrEmpty(iqreportcolumn.FilteredValue))
{
sql.Append(" a.FilteredValue = :nom5 and ");
Parms.Add(new Object[] { "nom5", iqreportcolumn.FilteredValue });
}
if (iqreportcolumn.Column != null && iqreportcolumn.Column.ColumnId != 0)
{
sql.Append(" a.Column.ColumnId = :idd6 and ");
Parms.Add(new Object[] { "idd6", iqreportcolumn.Column.ColumnId });
}
if (iqreportcolumn.ReportTable != null && iqreportcolumn.ReportTable.ReportTableId != 0)
{
sql.Append(" a.ReportTable.ReportTableId = :idd7 and ");
Parms.Add(new Object[] { "idd7", iqreportcolumn.ReportTable.ReportTableId });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append("1=1 order by a.ReportColumnId asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from IqReportTable a where ");
IqReportTable iqreporttable = (IqReportTable)data;
if (iqreporttable != null)
{
Parms = new List<Object[]>();
if (iqreporttable.ReportTableId != 0)
{
sql.Append(" a.ReportTableId = :id and ");
Parms.Add(new Object[] { "id", iqreporttable.ReportTableId });
}
if (!String.IsNullOrEmpty(iqreporttable.Alias))
{
sql.Append(" a.Alias = :nom2 and ");
Parms.Add(new Object[] { "nom2", iqreporttable.Alias });
}
if (iqreporttable.Secuence != 0)
{
sql.Append(" a.Secuence = :id3 and ");
Parms.Add(new Object[] { "id3", iqreporttable.Secuence });
}
if (!String.IsNullOrEmpty(iqreporttable.JoinQuery))
{
sql.Append(" a.JoinQuery = :nom4 and ");
Parms.Add(new Object[] { "nom4", iqreporttable.JoinQuery });
}
if (!String.IsNullOrEmpty(iqreporttable.WhereCondition))
{
sql.Append(" a.WhereCondition = :nom5 and ");
Parms.Add(new Object[] { "nom5", iqreporttable.WhereCondition });
}
if (iqreporttable.Report != null && iqreporttable.Report.ReportId != 0)
{
sql.Append(" a.Report.ReportId = :idd6 and ");
Parms.Add(new Object[] { "idd6", iqreporttable.Report.ReportId });
}
if (iqreporttable.Table != null && iqreporttable.Table.TableId != 0)
{
sql.Append(" a.Table.TableId = :idd7 and ");
Parms.Add(new Object[] { "idd7", iqreporttable.Table.TableId });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append("1=1 order by a.ReportTableId asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public IList<WorkCenter> GetWorkCenters()
{
List<WorkCenter> workCenters = new List<WorkCenter>();
workCenters.Add(new WorkCenter() { Id = "911", Name = "911", Group/* = new WorkCenterGroup() { Name*/ = "Milling" });// });
workCenters.Add(new WorkCenter() { Id = "921", Name = "921", Group/* = new WorkCenterGroup() { Name*/ = "Milling" });//});
workCenters.Add(new WorkCenter() { Id = "955", Name = "955", Group/* = new WorkCenterGroup() { Name*/ = "Annealing" });//});
workCenters.Add(new WorkCenter() { Id = "901", Name = "901", Group/* = new WorkCenterGroup() { Name*/ = "Casting" });//});
return workCenters;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from BinByTask a where ");
BinByTask binTask = (BinByTask)data;
if (binTask != null)
{
Parms = new List<Object[]>();
if (binTask.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", binTask.RowID });
}
if (binTask.Bin != null && binTask.Bin.BinID != 0)
{
sql.Append(" a.Bin.BinID = :idd1 and ");
Parms.Add(new Object[] { "idd1", binTask.Bin.BinID });
}
if (binTask.Status != null && binTask.Status.StatusID != 0)
{
sql.Append(" a.Status.StatusID = :ids5 and ");
Parms.Add(new Object[] { "ids5", binTask.Status.StatusID });
}
if (binTask.Bin != null && !String.IsNullOrEmpty(binTask.Bin.BinCode))
{
sql.Append(" a.Bin.BinCode = :idd2 and ");
Parms.Add(new Object[] { "idd2", binTask.Bin.BinCode });
}
if (binTask.TaskDocument != null && binTask.TaskDocument.DocID != 0)
{
sql.Append(" a.TaskDocument.DocID = :idd3 and ");
Parms.Add(new Object[] { "idd3", binTask.TaskDocument.DocID });
}
if (binTask.Product != null && binTask.Product.ProductID != 0)
{
sql.Append(" a.Product.ProductID = :idd4 and ");
Parms.Add(new Object[] { "idd4", binTask.Product.ProductID });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.Bin.BinCode"); //.BinCode asc
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from TrackOption a where ");
TrackOption track = (TrackOption)data;
if (track != null)
{
Parms = new List<Object[]>();
if (track.RowID != 0)
{
sql.Append(" a.RowID = :id1 and ");
Parms.Add(new Object[] { "id1", track.RowID });
}
if (!String.IsNullOrEmpty(track.Name))
{
sql.Append(" a.Name = :nom1 and ");
Parms.Add(new Object[] { "nom1", track.Name });
}
if (!String.IsNullOrEmpty(track.DisplayName))
{
sql.Append(" a.Displayname = :nom2 and ");
Parms.Add(new Object[] { "nom2", track.DisplayName });
}
if (track.IsUnique != null)
{
sql.Append(" a.IsUnique = :nom7 and ");
Parms.Add(new Object[] { "nom7", track.IsUnique });
}
if (track.IsSystem != null)
{
sql.Append(" a.IsSystem = :nom10 and ");
Parms.Add(new Object[] { "nom10", track.IsSystem });
}
if (track.DataType != null && track.DataType.DataTypeID != 0)
{
sql.Append(" a.DataType.DataTypeID = :nom8 and ");
Parms.Add(new Object[] { "nom8", track.DataType.DataTypeID });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.RowID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public static List<string> getSemesters()
{
List<string> semesters = new List<string>();
semesters.Add("Fall");
semesters.Add("Winter");
semesters.Add("Summer");
semesters.Add("Spring");
return semesters;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from ProductInventory a where ");
ProductInventory ProductInventory = (ProductInventory)data;
if (ProductInventory != null)
{
Parms = new List<Object[]>();
if (ProductInventory.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", ProductInventory.RowID });
}
if (ProductInventory.Location != null && ProductInventory.Location.LocationID != 0)
{
sql.Append(" a.Location.LocationID = :id1 and ");
Parms.Add(new Object[] { "id1", ProductInventory.Location.LocationID });
}
if (ProductInventory.Product != null && ProductInventory.Product.ProductID != 0)
{
sql.Append(" a.Product.ProductID = :cot1 and ");
Parms.Add(new Object[] { "cot1", ProductInventory.Product.ProductID });
}
if (ProductInventory.Document != null && ProductInventory.Document.DocID != 0)
{
sql.Append(" a.Document.DocID = :doc and ");
Parms.Add(new Object[] { "doc", ProductInventory.Document.DocID });
}
if (!string.IsNullOrEmpty(ProductInventory.CreatedBy))
{
sql.Append(" a.ModifiedBy = :mod and ");
Parms.Add(new Object[] { "mod", ProductInventory.CreatedBy });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
/// <summary>
/// Adds the item template to project.
/// </summary>
/// <param name="instance">The instance.</param>
/// <param name="templateInfos">The template infos.</param>
/// <returns>
/// The messages.
/// </returns>
public static IEnumerable<string> AddItemTemplateToProjects(
this Solution2 instance,
IEnumerable<ItemTemplateInfo> templateInfos)
{
string method = "SolutionExtensions::AddItemTemplateToProjects ";
TraceService.WriteLine(method);
List<string> messages = new List<string>();
IEnumerable<Project> projects = instance.GetProjects();
IEnumerable<Project> projectItems = projects as Project[] ?? projects.ToArray();
foreach (ItemTemplateInfo info in templateInfos)
{
Project project = projectItems.FirstOrDefault(x => x.Name.EndsWith(info.ProjectSuffix));
if (project != null)
{
string context = project.Name + " (template=" + info.TemplateName + ") fileName=" + info.FileName;
TraceService.WriteLine(method + context);
try
{
if (project.AddItemToFolderFromTemplate(info.TemplateName, info.FileName))
{
messages.Add(info.FileName + " added to " + project.Name + " project (template=" + info.TemplateName + ")");
}
}
catch (Exception exception)
{
TraceService.WriteError(method + context + " exception=" + exception.Message);
messages.Add(method + context + " exception=" + exception.Message);
}
}
else
{
TraceService.WriteError(method + " cannot find project " + info.ProjectSuffix);
foreach (string projectName in projectItems
.Select(projectItem => projectItem.Name))
{
TraceService.WriteError(method + " project " + projectName);
messages.Add(info.FileName + " added to " + projectName + " project (template=" + info.TemplateName + ")");
}
}
}
return messages;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from UnitProductRelation a where ");
UnitProductRelation unitproductrelation = (UnitProductRelation)data;
if (unitproductrelation != null)
{
Parms = new List<Object[]>();
if (unitproductrelation.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", unitproductrelation.RowID });
}
if (unitproductrelation.Product != null && unitproductrelation.Product.ProductID != 0)
{
sql.Append(" a.Product.ProductID = :id1 and ");
Parms.Add(new Object[] { "id1", unitproductrelation.Product.ProductID });
}
if (unitproductrelation.Product != null && !String.IsNullOrEmpty(unitproductrelation.Product.ProductCode))
{
sql.Append(" a.Product.ProductCode = :nom1 and ");
Parms.Add(new Object[] { "nom1", unitproductrelation.Product.ProductCode });
}
if (unitproductrelation.Unit != null && unitproductrelation.Unit.UnitID != 0)
{
sql.Append(" a.Unit.UnitID = :id2 and ");
Parms.Add(new Object[] { "id2", unitproductrelation.Unit.UnitID });
}
if (!String.IsNullOrEmpty(unitproductrelation.UnitErpCode))
{
sql.Append(" a.UnitErpCode = :nom and ");
Parms.Add(new Object[] { "nom", unitproductrelation.UnitErpCode });
}
if (unitproductrelation.Status != null && unitproductrelation.Status.StatusID != 0)
{
sql.Append(" a.Status.StatusID = :id4 and ");
Parms.Add(new Object[] { "id4", unitproductrelation.Status.StatusID });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.RowID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public List<ExamenDTO> GetExamen(long idperiodo, string tipo_evaluado)
{
List<ExamenDTO> examenes = new List<ExamenDTO>();
try
{
// consultas
periodos periodo = db.periodos.Where(x => x.id == idperiodo && x.estado != 0).FirstOrDefault();
List<evaluacion> evaluacionlst = db.evaluacion.Where(x => x.id == periodo.id_evaluacion && x.estado != 0).ToList();
if (evaluacionlst.Count() > 0)
{
evaluacion e = evaluacionlst.FirstOrDefault();
// algoritmo para filtrar las competencias por rango
List<competencias> competenciaslst = tipo_evaluado.Equals("Jefe") ?
competenciaslst = db.competencias.Where(x => x.idevaluacion == e.id).ToList()
:
competenciaslst = db.competencias.Where(x => x.idevaluacion == e.id && x.rango_evaluacion == tipo_evaluado).ToList();
foreach(competencias c in competenciaslst){
ExamenDTO examen = new ExamenDTO();
examen.competencia = new CompetenciaDTO();
// añado la competencia
examen.competencia.id = c.id;
examen.competencia.idevaluacion = c.idevaluacion;
examen.competencia.nombre = c.nombre;
examen.competencia.rango_evaluacion = c.rango_evaluacion;
// añado preguntas
examen.preguntas = from p in db.preguntas
where p.idcompetencia == c.id
select new PreguntaDTO()
{
id = p.id,
idcompetencia = p.idcompetencia,
nombre = p.nombre,
};
// añado a la lista de examenes
examenes.Add(examen);
}
}
else
{
examenes.Add(new ExamenDTO());
}
}
catch (Exception e)
{
throw e;
}
return examenes;
}
public static List<Odeme> getPayments(DateTime First, DateTime Last, Bilesen Type)
{
List<Odeme> Value = new List<Odeme>();
SqlConnection con = new SqlConnection("Server=.;Database=KutuphaneOtomasyon;Trusted_Connection=true");
String CommandString = "select Tarih,Uye.Adi,Uye.Soyadi,Aciklama,Tutar";
if(Type == null)
{
CommandString += ",OdemeTipi.Adi";
CommandString += " from dbo.Odeme";
CommandString += " join dbo.Uye on Uye.ID = Odeme.UyeID";
CommandString += " join dbo.OdemeTipi on OdemeTipi.ID = Odeme.OdemeTipi";
CommandString += " where (Tarih between ";
CommandString += "'" + convertToSqlDate(First.ToShortDateString()) + "' and ";
CommandString += "'" + convertToSqlDate(Last.ToShortDateString()) + "')";
SqlCommand cmd = new SqlCommand(CommandString, con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Odeme Current = new Odeme(reader.GetDateTime(0), reader.GetString(1), reader.GetString(2),
reader.GetString(3), reader.GetDecimal(4), reader.GetString(5));
Value.Add(Current);
}
reader.Close();
con.Close();
}
else
{
CommandString += " from dbo.Odeme";
CommandString += " join dbo.Uye on Uye.ID = Odeme.UyeID";
CommandString += " join dbo.OdemeTipi on OdemeTipi.ID = Odeme.OdemeTipi";
CommandString += " where (Tarih between ";
CommandString += "'" + convertToSqlDate(First.ToShortDateString()) + "' and ";
CommandString += "'" + convertToSqlDate(Last.ToShortDateString()) + "')";
CommandString += " and (Odeme.OdemeTipi=" + Type.ID.ToString() + ")";
SqlCommand cmd = new SqlCommand(CommandString, con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Odeme Current = new Odeme(reader.GetDateTime(0), reader.GetString(1), reader.GetString(2),
reader.GetString(3), reader.GetDecimal(4), "");
Value.Add(Current);
}
reader.Close();
con.Close();
}
return Value;
}
