public dynamic SelectDynamicFirst(string Sql, params ODAParameter[] Parameters) { ODAScript oSql = new ODAScript() { ScriptType = SQLType.Select }; oSql.SqlScript.Append(Sql); if (Parameters != null) { oSql.ParamList.AddRange(Parameters); } var db = GetDBAccess(oSql); var dt = db.Select(Sql, Parameters, 0, 1, ""); ODynamicModel M = new ODynamicModel(); if (dt != null && dt.Rows.Count > 0) { foreach (DataColumn c in dt.Columns) { M.Add(c.ColumnName, dt.Rows[0][c.ColumnName]); } } return(M); }
public dynamic SelectDynamicFirst(params IODAColumns[] Cols) { int total = 0; var dt = this.Select(0, 1, out total, Cols); ODynamicModel M = new ODynamicModel(); if (dt != null && dt.Rows.Count > 0) { foreach (DataColumn c in dt.Columns) { M.Add(c.ColumnName, dt.Rows[0][c.ColumnName]); } } else { foreach (IODAColumns c in Cols) { M.Add(c.ColumnName, null); } } return(M); }
public List <dynamic> SelectDynamic(int StartIndex, int MaxRecord, out int Total, params IODAColumns[] Cols) { var dt = this.Select(StartIndex, MaxRecord, out Total, Cols); List <dynamic> Models = new List <dynamic>(); if (dt != null && dt.Rows.Count > 0) { string[] CNames = new string[dt.Columns.Count]; for (int i = 0; i < CNames.Length; i++) { CNames[i] = dt.Columns[i].ColumnName; } foreach (DataRow r in dt.Rows) { ODynamicModel M = new ODynamicModel(); for (int i = 0; i < CNames.Length; i++) { M.Add(CNames[i], r.ItemArray[i]); } Models.Add(M); } } return(Models); }