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; }