示例#1
0
文件: Efforts.cs 项目: jhogan/qed
 public Efforts Sort()
 {
     ArrayList al = new ArrayList();
     Efforts newEfforts = new Efforts();
     foreach(Effort eff in this){
         al.Add(eff.ConventionalId);
     }
     al.Sort();
     foreach(string conventionalID in al){
         foreach(Effort eff in this){
             if (eff.ConventionalId == conventionalID){
                 newEfforts.Add(eff);
             }
         }
     }
     this.Clear();
     foreach(Effort eff in newEfforts){
         this.Add(eff);
     }
     return this;
 }
示例#2
0
文件: Efforts.cs 项目: jhogan/qed
 public static Efforts AllEfforts()
 {
     Efforts effs = new Efforts();
     Effort eff;
     using(MySqlConnection conn = Connections.Inst.item("QED_DB").MySqlConnection){
         conn.Open();
         MySqlCommand cmd = conn.CreateCommand();
         cmd.CommandText =	 "SELECT * FROM efforts";
         using(MySqlDataReader dr = cmd.ExecuteReader()){
             while(dr.Read()) {
                 eff = new Effort(dr, true);
                 eff.BusinessCollection = effs;
                 effs.Add(eff);
             }
         }
     }
     return effs;
 }
示例#3
0
文件: Efforts.cs 项目: jhogan/qed
        public static Efforts Unrolled()
        {
            Efforts effs = new Efforts();
            Effort eff;
            bool beenHere = false;
            System.Text.StringBuilder inList = new System.Text.StringBuilder();
            using(MySqlConnection conn = Connections.Inst.item("QED_DB").MySqlConnection){
                conn.Open();
                MySqlCommand cmd = conn.CreateCommand();
                cmd.CommandText =	 "SELECT effId FROM effortRollouts WHERE rolled = 1";
                using(MySqlDataReader dr = cmd.ExecuteReader()){
                    while(dr.Read()){
                        if (beenHere) inList.Append(","); else beenHere = true;
                        inList.Append(Convert.ToString(dr[0]));
                    }
                }
                if (inList.Length > 0){
                    cmd.CommandText =	 "SELECT * FROM efforts WHERE id not in (" + inList.ToString() + ")";
                }else{
                    cmd.CommandText =	 "SELECT * FROM efforts";
                }
                using(MySqlDataReader dr = cmd.ExecuteReader()){
                    while(dr.Read()) {
                        eff = new Effort(dr, true);
                        eff.BusinessCollection = effs;
                        effs.Add(eff);
                    }
                }

            }
            return effs;
        }
示例#4
0
文件: Rollout.cs 项目: jhogan/qed
 public Efforts GetCachedEfforts(bool reload)
 {
     if (reload || _cachedEfforts == null)
         _cachedEfforts = this.Efforts;
     return _cachedEfforts;
 }