public static List <Task_Detail> GetTaskDetail_list(int taskID, string sourceID, string taskName) { List <Task_Detail> list = new List <Task_Detail>(); DB_select db_sel = new DB_select(Task_Detail.Get_cmdTP()); SQL_relation rela0 = new SQL_relation("TaskID", RelationalOperator.Equals, taskID); SQL_relation rela1 = new SQL_relation("sourceID", RelationalOperator.Equals, sourceID); SQL_condition cond = new SQL_condition(rela0, ConditionalOperator.And, rela1); if (taskName != null) { SQL_relation rela2 = new SQL_relation("TaskName", RelationalOperator.Equals, taskName); cond = new SQL_condition(cond, ConditionalOperator.And, rela2); } db_sel.SetCondition(cond); DB_reader reader = new DB_reader(db_sel, Utility.Get_DRWIN_hDB()); while (reader.Read()) { Task_Detail dp = new Task_Detail(); dp.Init_from_reader(reader); list.Add(dp); } reader.Close(); return(list); }
/// <summary> /// Get DB_reader for retrieving Task_Detail info /// </summary> /// <param name="completed_option">0 for Uncompleted, 1 for Completed, other values for all</param> /// <param name="extraCond">Extra Condition</param> public static DB_reader Get_DB_reader(int completed_option, SQL_condition extraCond) { DB_select selt = new DB_select(Task_Detail.Get_cmdTP()); SQL_relation rela = null; if (completed_option == 0) { rela = new SQL_relation("Completed", RelationalOperator.Equals, false); } else if (completed_option == 1) { rela = new SQL_relation("Completed", RelationalOperator.Equals, true); } SQL_condition cond = new SQL_condition(rela, ConditionalOperator.And, extraCond); selt.SetCondition(cond); DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB()); return(reader); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } else { this.LastModifiedBy.Value = Utility.CurrentUser; this.LastModifiedDateTime.Value = DateTime.Now; } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Task_Detail.Get_cmdTP()); if (this.TaskID.ValueChanged) { upd.AddValue("TaskID", this.TaskID); } if (this.TaskName.ValueChanged) { upd.AddValue("TaskName", this.TaskName); } if (this.Country.ValueChanged) { upd.AddValue("Country", this.Country); } if (this.Depositary.ValueChanged) { upd.AddValue("Depositary", this.Depositary); } if (this.Issue.ValueChanged) { upd.AddValue("Issue", this.Issue); } if (this.CUSIP.ValueChanged) { upd.AddValue("CUSIP", this.CUSIP); } if (this.RecordDate.ValueChanged) { upd.AddValue("RecordDate", this.RecordDate); } if (this.SourceTable.ValueChanged) { upd.AddValue("SourceTable", this.SourceTable); } if (this.SourceID.ValueChanged) { upd.AddValue("SourceID", this.SourceID); } if (this.StartDate.ValueChanged) { upd.AddValue("StartDate", this.StartDate); } if (this.PriorityDate.ValueChanged) { upd.AddValue("PriorityDate", this.PriorityDate); } if (this.EndDate.ValueChanged) { upd.AddValue("EndDate", this.EndDate); } if (this.Notes.ValueChanged) { upd.AddValue("Notes", this.Notes); } if (this.Priority.ValueChanged) { upd.AddValue("Priority", this.Priority); } if (this.Completed.ValueChanged) { upd.AddValue("Completed", this.Completed); } if (this.CreatedBy.ValueChanged) { upd.AddValue("CreatedBy", this.CreatedBy); } if (this.CreatedDateTime.ValueChanged) { upd.AddValue("CreatedDateTime", this.CreatedDateTime); } if (this.CompletedBy.ValueChanged) { upd.AddValue("CompletedBy", this.CompletedBy); } if (this.CompletedDateTime.ValueChanged) { upd.AddValue("CompletedDateTime", this.CompletedDateTime); } if (this.LastModifiedBy.ValueChanged) { upd.AddValue("LastModifiedBy", this.LastModifiedBy); } if (this.LastModifiedDateTime.ValueChanged) { upd.AddValue("LastModifiedDateTime", this.LastModifiedDateTime); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("TaskDetailID", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { this.LastModifiedBy.Value = Utility.CurrentUser; this.LastModifiedDateTime.Value = DateTime.Now; this.CreatedBy.Value = Utility.CurrentUser; this.CreatedDateTime.Value = DateTime.Now; HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Task_Detail.Get_cmdTP()); dbIns.AddValue("TaskID", this.TaskID.Value); dbIns.AddValue("TaskName", this.TaskName); /*Optional 3*/ dbIns.AddValue("Country", this.Country); /*Optional 4*/ dbIns.AddValue("Depositary", this.Depositary); /*Optional 5*/ dbIns.AddValue("Issue", this.Issue); /*Optional 6*/ dbIns.AddValue("CUSIP", this.CUSIP); /*Optional 7*/ dbIns.AddValue("RecordDate", this.RecordDate); /*Optional 8*/ dbIns.AddValue("SourceTable", this.SourceTable); /*Optional 9*/ dbIns.AddValue("SourceID", this.SourceID); /*Optional 10*/ dbIns.AddValue("StartDate", this.StartDate); /*Optional 11*/ dbIns.AddValue("PriorityDate", this.PriorityDate); /*Optional 12*/ dbIns.AddValue("EndDate", this.EndDate); /*Optional 13*/ dbIns.AddValue("Notes", this.Notes); /*Optional 14*/ dbIns.AddValue("Priority", this.Priority); /*Optional 15*/ dbIns.AddValue("Completed", this.Completed); /*Optional 16*/ dbIns.AddValue("CreatedBy", this.CreatedBy); /*Optional 17*/ dbIns.AddValue("CreatedDateTime", this.CreatedDateTime); /*Optional 18*/ dbIns.AddValue("CompletedBy", this.CompletedBy); /*Optional 19*/ dbIns.AddValue("CompletedDateTime", this.CompletedDateTime); /*Optional 20*/ dbIns.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 21*/ dbIns.AddValue("LastModifiedDateTime", this.LastModifiedDateTime); /*Optional 22*/ return(dbIns); }
/// <summary> /// Initialize object from DB /// </summary> public bool Init_from_DB() { if (this.TaskDetailID < 0) { return(false); } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(Task_Detail.Get_cmdTP()); db_sel.tableName = "Task_Detail"; HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("TaskDetailID", HssUtility.General.RelationalOperator.Equals, this.TaskDetailID); db_sel.SetCondition(rela); bool res_flag = false; HssUtility.SQLserver.DB_reader reader = new HssUtility.SQLserver.DB_reader(db_sel, Utility.Get_DRWIN_hDB()); if (reader.Read()) { this.Init_from_reader(reader); res_flag = true; } reader.Close(); return(res_flag); }