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);
}