Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- foreach (var val in (from r in arg.dsData.Tables[this.dsDoc.DocsAccount.TableName].AsEnumerable()
- where r.Field<object>(this.dsDoc.DocsAccount.AgentIDColumn.ColumnName) != null
- select r.Field<int>(this.dsDoc.DocsAccount.AgentIDColumn.ColumnName))
- .Union
- (from r in arg.dsData.Tables[this.dsDoc.DocsActServic.TableName].AsEnumerable()
- where r.Field<object>(this.dsDoc.DocsActServic.AgentIDColumn.ColumnName) != null
- select r.Field<int>(this.dsDoc.DocsActServic.AgentIDColumn.ColumnName))
- .Union
- (from r in arg.dsData.Tables[this.dsDoc.DocsAct.TableName].AsEnumerable()
- where r.Field<object>(this.dsDoc.DocsAct.CounteragentIDColumn.ColumnName) != null
- select r.Field<int>(this.dsDoc.DocsAct.CounteragentIDColumn.ColumnName))
- .Union
- (from r in arg.dsData.Tables[this.dsDoc.DocsVKeepDetail.TableName].AsEnumerable()
- where r.Field<object>(this.dsDoc.DocsVKeepDetail.CounteragentIDColumn.ColumnName) != null
- select r.Field<int>(this.dsDoc.DocsVKeepDetail.CounteragentIDColumn.ColumnName))
- .Union
- (from r in arg.dsData.Tables[this.dsDoc.DocsVKeepCost.TableName].AsEnumerable()
- where r.Field<object>(this.dsDoc.DocsVKeepCost.AgentIDColumn.ColumnName) != null
- select r.Field<int>(this.dsDoc.DocsVKeepCost.AgentIDColumn.ColumnName))
- .Union
- (from r in arg.dsData.Tables[this.dsDoc.DocsEvalutAmDetail.TableName].AsEnumerable()
- where r.Field<object>(this.dsDoc.DocsEvalutAmDetail.MarketIDColumn.ColumnName) != null
- select r.Field<int>(this.dsDoc.DocsEvalutAmDetail.MarketIDColumn.ColumnName))
- .Union
- (from r in arg.dsData.Tables[this.dsDoc.DocsEvalutMnDetail.TableName].AsEnumerable()
- where (r.Field<int>(this.dsDoc.DocsEvalutMnDetail.AssetKindIDColumn.ColumnName) == (int)CData.Dict.CAssetKind.id.Debet ||
- r.Field<int>(this.dsDoc.DocsEvalutMnDetail.AssetKindIDColumn.ColumnName) == (int)CData.Dict.CAssetKind.id.Kredit) &&
- r.Field<object>(this.dsDoc.DocsEvalutMnDetail.AssetIDColumn.ColumnName) != null
- select r.Field<int>(this.dsDoc.DocsEvalutMnDetail.AssetIDColumn.ColumnName))
- .Union
- (from r in arg.dsData.Tables[this.dsDoc.DocsKUA.TableName].AsEnumerable()
- where r.Field<object>(this.dsDoc.DocsKUA.AgentIDColumn.ColumnName) != null
- select r.Field<int>(this.dsDoc.DocsKUA.AgentIDColumn.ColumnName))
- .Union
- (from r in arg.dsData.Tables[this.dsDoc.DocsOperDetAnalyt.TableName].AsEnumerable()
- where (r.Field<int>(this.dsDoc.DocsOperDetAnalyt.AnalyticPlanIDColumn.ColumnName) == (int)CData.Dict.CAnalytic.id.Agent ||
- r.Field<int>(this.dsDoc.DocsOperDetAnalyt.AnalyticPlanIDColumn.ColumnName) == (int)CData.Dict.CAnalytic.id.IssuerSP) &&
- r.Field<object>(this.dsDoc.DocsOperDetAnalyt.IDColumn.ColumnName) != null
- select r.Field<int>(this.dsDoc.DocsOperDetAnalyt.IDColumn.ColumnName))
- .Union
- (from r in arg.dsData.Tables[this.dsDoc.DocsEconom.TableName].AsEnumerable()
- where r.Field<object>(this.dsDoc.DocsEconom.CounteragentIDColumn.ColumnName) != null
- select r.Field<int>(this.dsDoc.DocsEconom.CounteragentIDColumn.ColumnName))
- .Union
- (from r in arg.dsData.Tables[this.dsDoc.DocsPay.TableName].AsEnumerable()
- where r.Field<object>(this.dsDoc.DocsPay.CounteragentIDColumn.ColumnName) != null
- select r.Field<int>(this.dsDoc.DocsPay.CounteragentIDColumn.ColumnName))
- .Union
- (from r in arg.dsData.Tables[this.dsDoc.DocsCurrenc.TableName].AsEnumerable()
- where r.Field<object>(this.dsDoc.DocsCurrenc.AgentIDColumn.ColumnName) != null
- select r.Field<int>(this.dsDoc.DocsCurrenc.AgentIDColumn.ColumnName))
- .Union
- (from r in arg.dsData.Tables[this.dsDoc.DocsPayBill.TableName].AsEnumerable()
- where r.Field<object>(this.dsDoc.DocsPayBill.CounteragentIDColumn.ColumnName) != null
- select r.Field<int>(this.dsDoc.DocsPayBill.CounteragentIDColumn.ColumnName))
- .Union
- (from r in arg.dsData.Tables[this.dsDoc.DocsSalaryDetail.TableName].AsEnumerable()
- where r.Field<object>(this.dsDoc.DocsSalaryDetail.AgentIDColumn.ColumnName) != null
- select r.Field<int>(this.dsDoc.DocsSalaryDetail.AgentIDColumn.ColumnName))
- .Union
- (from r in arg.dsData.Tables[this.dsDoc.DocsProtQuestion.TableName].AsEnumerable()
- where r.Field<object>(this.dsDoc.DocsProtQuestion.KuaIDColumn.ColumnName) != null
- select r.Field<int>(this.dsDoc.DocsProtQuestion.KuaIDColumn.ColumnName))
- .Union
- (from r in arg.dsData.Tables[this.dsAgre.AgDisposal.TableName].AsEnumerable()
- where r.Field<object>(this.dsAgre.AgDisposal.DepositoryAgentIDColumn.ColumnName) != null
- select r.Field<int>(this.dsAgre.AgDisposal.DepositoryAgentIDColumn.ColumnName))
- .Union
- (from r in arg.dsData.Tables[this.dsAgre.AgDisposal.TableName].AsEnumerable()
- where r.Field<object>(this.dsAgre.AgDisposal.CounterpartyAgentIDColumn.ColumnName) != null
- select r.Field<int>(this.dsAgre.AgDisposal.CounterpartyAgentIDColumn.ColumnName))
- .Union
- (from r in arg.dsData.Tables[this.dsAgre.AgDisposal.TableName].AsEnumerable()
- where r.Field<object>(this.dsAgre.AgDisposal.TraderAgentIDColumn.ColumnName) != null
- select r.Field<int>(this.dsAgre.AgDisposal.TraderAgentIDColumn.ColumnName))
- ) arg.agent_id.Add(val);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement