public static StructureCollection GetStructuresByActivityID(Int64 ActivityID) { StructureCollection c = new StructureCollection(); DataTable dt = Execute.FillDataTable(StoredProcedures.GetStructuresByActivityID, new System.Data.SqlClient.SqlParameter("ActivityID", ActivityID)); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { Structure o = new Structure(); LoadStructureByReader(row, o); c.Add(o); } } return(c); }
/// <summary> /// 执行Json脚本 /// </summary> /// <returns></returns> public int Execute() { string sql = GetNormalSQLString(); gSC.Clear(); using (Ly.Data.SQLClient Conn = new Ly.Data.SQLClient(gstrConn)) { Conn.ExecuteReader(sql); while (Conn.DataReader.Read()) { Structure st = new Structure(); for (int i = 0; i < Conn.DataReader.FieldCount; i++) { string sName = Conn.DataReader.GetName(i); st[sName] = Conn.DataReader[i].ToString(); } gSC.Add(st); } } return(gSC.Count); }