internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Dividend_Control_Queue.Get_cmdTP()); if (this.DividendIndex.ValueChanged) { upd.AddValue("DividendIndex", this.DividendIndex); } if (this.TabName.ValueChanged) { upd.AddValue("TabName", this.TabName); } if (this.FieldName.ValueChanged) { upd.AddValue("FieldName", this.FieldName); } if (this.ColumnName.ValueChanged) { upd.AddValue("ColumnName", this.ColumnName); } if (this.PreviousValue.ValueChanged) { upd.AddValue("PreviousValue", this.PreviousValue); /*Optional 6*/ } if (this.NewValue.ValueChanged) { upd.AddValue("NewValue", this.NewValue); /*Optional 7*/ } if (this.DataType.ValueChanged) { upd.AddValue("DataType", this.DataType); } if (this.UserID.ValueChanged) { upd.AddValue("UserID", this.UserID); } if (this.QueueDateTime.ValueChanged) { upd.AddValue("QueueDateTime", this.QueueDateTime); } if (this.Status.ValueChanged) { upd.AddValue("Status", this.Status); } if (this.ApprovedBy.ValueChanged) { upd.AddValue("ApprovedBy", this.ApprovedBy); } if (this.Event.ValueChanged) { upd.AddValue("Event", this.Event); /*Optional 13*/ } if (this.Active.ValueChanged) { upd.AddValue("Active", this.Active); /*Optional 14*/ } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("Queue_ID", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
/// <summary> /// Initialize object from DB /// </summary> public bool Init_from_DB() { if (this.Queue_ID < 0) { return(false); } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(Dividend_Control_Queue.Get_cmdTP()); db_sel.tableName = "Dividend_Control_Queue"; HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("Queue_ID", HssUtility.General.RelationalOperator.Equals, this.Queue_ID); 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); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Dividend_Control_Queue.Get_cmdTP()); dbIns.AddValue("DividendIndex", this.DividendIndex); dbIns.AddValue("TabName", this.TabName); dbIns.AddValue("FieldName", this.FieldName); dbIns.AddValue("ColumnName", this.ColumnName); dbIns.AddValue("PreviousValue", this.PreviousValue); /*Optional 6*/ dbIns.AddValue("NewValue", this.NewValue); /*Optional 7*/ dbIns.AddValue("DataType", this.DataType); dbIns.AddValue("UserID", this.UserID); dbIns.AddValue("QueueDateTime", this.QueueDateTime); dbIns.AddValue("Status", this.Status); dbIns.AddValue("ApprovedBy", this.ApprovedBy); dbIns.AddValue("Event", this.Event); /*Optional 13*/ dbIns.AddValue("Active", this.Active); /*Optional 14*/ return(dbIns); }