public object Execute(ISession session) { //try //{ IDbCommand cmd = session.Connection.CreateCommand(); cmd.CommandText = ActiveRecordHelp.GetFilgerCount(cmd, _start, _limit, _sort, _dir, _tableName, _primaryKey, _filters, _otherWhere, _otherParameter); return(cmd.ExecuteScalar()); //} //catch (Exception ex) //{ return 0; } }
public object Execute(ISession session) { CommonDictionary dic = ActiveRecordHelp.GetFilgerCount(_tableName, _filters, _otherWhere, _otherParameter); ISQLQuery query = session.CreateSQLQuery(dic.ContentSql); if (dic.Parameters != null) { foreach (DictionaryEntry par in dic.Parameters) { query.SetParameter(par.Key.ToString(), par.Value); } } return(query.List()[0]); }
public object Execute(ISession session) { CommonDictionary dic = ActiveRecordHelp.GetFilterSql(_query, _start, _limit, _sort, _dir, _tableName, _primaryKey, _filters, _otherWhere, _otherParameter); ISQLQuery query = session.CreateSQLQuery(dic.ContentSql).AddEntity(typeof(T)); if (dic.Parameters != null) { foreach (DictionaryEntry par in dic.Parameters) { query.SetParameter(par.Key.ToString(), par.Value); } } return(query.List()); }
public object Execute(ISession session) { IDbCommand cmd = session.Connection.CreateCommand(); cmd.CommandText = ActiveRecordHelp.GetFilterSql(_query, cmd, _start, _limit, _sort, _dir, _tableName, _primaryKey, _filters, _otherWhere, _otherParameter); List <T> list = new List <T>(); try { IDataReader r = cmd.ExecuteReader(); while (r.Read()) { T o = new T(); for (int i = 0; i < r.FieldCount; i++) { object value = r.GetValue(i); PropertyInfo pro = typeof(T).GetProperty(r.GetName(i)); if (pro != null) { if (pro.PropertyType == typeof(string) && value == DBNull.Value) { value = ""; } //if (pro.PropertyType == typeof(int?) && value == DBNull.Value) value = null; if (pro.PropertyType == typeof(int) && value == DBNull.Value) { value = 0; } if (value == DBNull.Value) { value = null; } pro.SetValue(o, value, null); } } list.Add(o); } } catch (Exception ex) { throw ex; } return(list.ToArray()); }