public Dividend_Control_Queue GetCopy() { Dividend_Control_Queue newEntity = new Dividend_Control_Queue(); if (!this.DividendIndex.IsNull_flag) { newEntity.DividendIndex.Value = this.DividendIndex.Value; } if (!this.TabName.IsNull_flag) { newEntity.TabName.Value = this.TabName.Value; } if (!this.FieldName.IsNull_flag) { newEntity.FieldName.Value = this.FieldName.Value; } if (!this.ColumnName.IsNull_flag) { newEntity.ColumnName.Value = this.ColumnName.Value; } if (!this.PreviousValue.IsNull_flag) { newEntity.PreviousValue.Value = this.PreviousValue.Value; } if (!this.NewValue.IsNull_flag) { newEntity.NewValue.Value = this.NewValue.Value; } if (!this.DataType.IsNull_flag) { newEntity.DataType.Value = this.DataType.Value; } if (!this.UserID.IsNull_flag) { newEntity.UserID.Value = this.UserID.Value; } if (!this.QueueDateTime.IsNull_flag) { newEntity.QueueDateTime.Value = this.QueueDateTime.Value; } if (!this.Status.IsNull_flag) { newEntity.Status.Value = this.Status.Value; } if (!this.ApprovedBy.IsNull_flag) { newEntity.ApprovedBy.Value = this.ApprovedBy.Value; } if (!this.Event.IsNull_flag) { newEntity.Event.Value = this.Event.Value; } if (!this.Active.IsNull_flag) { newEntity.Active.Value = this.Active.Value; } return(newEntity); }
public List <Dividend_Control_Queue> XBRL_Get_controlQueue() { this.Create_attrDic(); List <Dividend_Control_Queue> list = new List <Dividend_Control_Queue>(); foreach (KeyValuePair <string, I_modelAttr> pair in this.attr_dic) { if (!pair.Value.ValueChanged) { continue; } Dividend_Control_Queue dcq = new Dividend_Control_Queue(); dcq.Init_from_attr(pair.Key, pair.Value); list.Add(dcq); } return(list); }
/// <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_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); }
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); }