コード例 #1
0
ファイル: Defects.cs プロジェクト: jhogan/qed
 public Defect Add(Defect def)
 {
     def.BusinessCollection = this;
     def.Parent = this._parent;
     List.Add(def); return def;
 }
コード例 #2
0
ファイル: Defects.cs プロジェクト: jhogan/qed
 public bool Contains(Defect def)
 {
     foreach(Defect obj in List) {
         if (obj.Equals(def)){
             return true;
         }
     }
     return false;
 }
コード例 #3
0
ファイル: Defects.cs プロジェクト: jhogan/qed
 public Defects(BusinessBase parent)
 {
     Defect def;
     string SQL;
     _parent = parent;
     using(MySqlConnection conn = Connections.Inst.item("QED_DB").MySqlConnection){
         conn.Open();
         using(MySqlCommand cmd = conn.CreateCommand()){
             if (parent is Effort){
                 SQL = "SELECT * FROM " + _table + " WHERE effId = @effId and forRoll = 0";
                 cmd.Parameters.Add("@effId", parent.Id);
             }else{
                 SQL = "SELECT * FROM " + _table + " WHERE rollId = @rollId and forRoll = 1";
                 cmd.Parameters.Add("@rollId", parent.Id);
             }
             cmd.CommandText = SQL;
             using(MySqlDataReader dr = cmd.ExecuteReader()){
                 while(dr.Read()) {
                     def = new Defect(dr);
                     def.BusinessCollection = this;
                     List.Add(def);
                 }
                 conn.Close();
             }
         }
     }
 }