public IList<MessageRuleByCompany> Select(MessageRuleByCompany data)
{
IList<MessageRuleByCompany> datos = new List<MessageRuleByCompany>();
datos = GetHsql(data).List<MessageRuleByCompany>();
if (!Factory.IsTransactional)
Factory.Commit();
return datos;
}
} //Dias (86400), Hour (3600), Minutes (60), Seconds (1)
public override Boolean Equals(object obj)
{
if ((obj == null) || (obj.GetType() != this.GetType()))
{
return(false);
}
MessageRuleByCompany castObj = (MessageRuleByCompany)obj;
return((castObj != null) && (this.RowID == castObj.RowID));
}
public void UpdateMessageRuleByCompany(MessageRuleByCompany data) { Factory.DaoMessageRuleByCompany().Update(data); }
public void DeleteMessageRuleByCompany(MessageRuleByCompany data) { Factory.DaoMessageRuleByCompany().Delete(data); }
public MessageRuleByCompany SaveMessageRuleByCompany(MessageRuleByCompany data) { return Factory.DaoMessageRuleByCompany().Save(data); }
public IList<MessageRuleByCompany> GetMessageRuleByCompany(MessageRuleByCompany data) { return Factory.DaoMessageRuleByCompany().Select(data); }
public IList<Int32> SelectRulesMessage(Document document, MessageRuleByCompany rule)
{
string sQuery = "";
sQuery = "select DocID from Trace.Document a left outer join Report.MessagePool m on a.DocID = m.RecordID "+
" and m.EntityID = :idx1 and m.RuleID = :rule Where " +
" ( a.CreationDate >= :dtm1 or a.ModDate >= :dtm1 ) and m.RecordID is null ";
StringBuilder sql = new StringBuilder(sQuery);
if (document != null)
{
Parms = new List<Object[]>();
Parms.Add(new Object[] { "dtm1", DateTime.Today.AddDays(-5) }); //Limita a enviar solo los del dia
Parms.Add(new Object[] { "idx1", EntityID.Document });
Parms.Add(new Object[] { "rule", rule.RowID }); //Rule a ejecutar
if (document.DocType != null && document.DocType.DocTypeID != 0)
{
sql.Append(" and a.DocTypeID = :id1 ");
Parms.Add(new Object[] { "id1", document.DocType.DocTypeID });
}
if (document.DocStatus != null && document.DocStatus.StatusID != 0)
{
sql.Append(" and a.DocStatusID = :id3 ");
Parms.Add(new Object[] { "id3", document.DocStatus.StatusID });
}
//sql.Append(" and ( a.DocStatusID != :id2) ");
//Parms.Add(new Object[] { "id2", DocStatus.Cancelled });
}
sql = new StringBuilder(sql.ToString());
IQuery query = Factory.Session.CreateSQLQuery(sql.ToString());
SetParameters(query);
return query.List<Int32>();
}
public MessageRuleByCompany SelectById(MessageRuleByCompany data)
{
return (MessageRuleByCompany)base.SelectById(data);
}
public Boolean Delete(MessageRuleByCompany data)
{
return base.Delete(data);
}
public Boolean Update(MessageRuleByCompany data)
{
return base.Update(data);
}
public MessageRuleByCompany Save(MessageRuleByCompany data)
{
return (MessageRuleByCompany)base.Save(data);
}