// public DataTable GetListSQL(Criteria criteria, Order order) { DataTable result; using (ISession session = sessionFaction.OpenSession()) { string sql = "SELECT * FROM vipsoft_category"; result = session.ExecuteDataTable(sql, CommandType.Text); } return result; }
//自定义SQL public List<Category> GetListSQL(Criteria criteria,Order order) { List<Category> result; using (ISession session = sessionFaction.OpenSession()) { // string sql = "SELECT * FROM vipsoft_category WHERE depth=?P_depth"; // DbParameter[] s = session.GetParameters<Category>("depth"); // s[0].Value = 1; result = session.Load<Category>(criteria,order); } return result; }
public static CmdParameter CreateDataCountSql(ISessionImplementor session, IEntityPersister entityPersister, Criteria criteria) { var classMetadata = entityPersister.ClassMetadata; var result = new CmdParameter(); var parameters = new List<DbParameter>(); var sql = new StringBuilder(); sql.AppendFormat("SELECT COUNT(1) FROM {0} ", classMetadata.TableName); if (criteria != null && criteria.CriterionList != null && criteria.CriterionList.Count > 0) { criteria.Driver = entityPersister.Driver; criteria.DicParameter = entityPersister.GetParameter(session); criteria.DbParameter = parameters; sql.Append(" WHERE ").Append(criteria.ToString(classMetadata)); result.Parameters = parameters.ToArray(); } sql.Append(entityPersister.Driver.MultipleQueriesSeparator); result.CommandText = sql.ToString(); log.Info(sql); return result; }
public static CmdParameter CreateSelectSql2(ISessionImplementor session, IEntityPersister entityPersister, Criteria criteria, Order order) { var classMetadata = entityPersister.ClassMetadata; var result = new CmdParameter(); //if (string.IsNullOrEmpty(obj.Conditaion)) //{ // var columnInfo = classMetadata.ColumnInfos.Find(t => t.IsPrimaryKey); // if (columnInfo != null) // { // var v = columnInfo.PropertyInfo.FastGetValue(obj); // if (!IsNull(v)) result = CreateSelectSql(session, entityPersister, v); // } //} var parameters = new List<DbParameter>(); //entityPersister.Driver.FormatNameForSql(columnInfo.Name) // string rConditaion = GetConditaion(session, entityPersister, obj, out parameters); var sql = new StringBuilder("SELECT "); //sql.Append(string.IsNullOrEmpty(obj.ResultColumns) ? "*" : obj.ResultColumns); sql.Append("*"); sql.AppendFormat(" FROM {0} ", classMetadata.TableName); if (criteria != null && criteria.CriterionList != null && criteria.CriterionList.Count > 0) { criteria.Driver = entityPersister.Driver; criteria.DicParameter = entityPersister.GetParameter(session); criteria.DbParameter = parameters; sql.Append(" WHERE ").Append(criteria.ToString(classMetadata)); result.Parameters = parameters.ToArray(); } // entityPersister.SetDbParamter(session, parameters, columnInfo.Name, value); //var where = GetWhereCaluse(rConditaion); //if (where.Length > 0) //{ // sql.AppendFormat(" WHERE {0} ", where); // result.Parameters = parameters.ToArray(); //} //sql.Append(obj.OrderBy ?? "" ); sql.Append(order != null ? order.ToString(classMetadata) : ""); sql.Append(entityPersister.Driver.MultipleQueriesSeparator); result.CommandText = sql.ToString(); log.Info(sql); return result; }
public Criterion(LOP logicOperation, Criteria criteria) { LogicOperation = logicOperation; Value = criteria; }
public Criterion(Criteria criteria) { LogicOperation = LOP.AND; Value = criteria; }
public Criteria Add(LOP logicOperation, Criteria criteria) { this.AddCriterion(new Criterion(logicOperation, criteria)); return(this); }
public Criteria Add(Criteria criteria) { this.AddCriterion(new Criterion(criteria)); return(this); }
/// <summary> /// 如果有子分类就显示子分类,如果没有就显示同级分类 /// </summary> /// <returns></returns> public ActionResult NavigationMenu() { ViewBag.CurrentCategory = CurrentCategory; // var model = new Category { ID = CId, Conditaion = "parent_id=[ID]" }; var criteria = new Criteria("ParentID", CId); criteria.Add(LOP.AND, "Status", 1); var list = CategoryService.GetList(criteria, new Order("sequence")); if (list.Count == 0) //有子类就显示子类,没有子类就显示同级节点。 { list = CategoryService.GetBrotherNode(CId); } return View(list); }
public Criteria Add(LOP logicOperation, Criteria criteria) { this.AddCriterion(new Criterion(logicOperation, criteria)); return this; }
public Criteria Add(Criteria criteria) { this.AddCriterion(new Criterion(criteria)); return this; }