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.DocsAccountAsset.TableName].AsEnumerable()
- where r.Field<object>(this.dsDoc.DocsAccountAsset.AssetKindIDColumn.ColumnName) != null &&
- r.Field<object>(this.dsDoc.DocsAccountAsset.AssetIDColumn.ColumnName) != null
- select new
- {
- AssetKindID = r.Field<int>(this.dsDoc.DocsAccountAsset.AssetKindIDColumn.ColumnName),
- AssetID = r.Field<int>(this.dsDoc.DocsAccountAsset.AssetIDColumn.ColumnName)
- })
- .Union
- (from h in arg.dsData.Tables[this.dsDoc.DocsAct.TableName].AsEnumerable()
- join r in arg.dsData.Tables[this.dsDoc.DocsActDetail.TableName].AsEnumerable()
- on h.Field<int>(this.dsDoc.DocsAct.ActDocIDColumn.ColumnName) equals r.Field<int>(this.dsDoc.DocsActDetail.ActDocIDColumn.ColumnName)
- where h.Field<object>(this.dsDoc.DocsAct.AssetKindIDColumn.ColumnName) != null &&
- r.Field<object>(this.dsDoc.DocsActDetail.AssetIDColumn.ColumnName) != null
- select new
- {
- AssetKindID = h.Field<int>(this.dsDoc.DocsAct.AssetKindIDColumn.ColumnName),
- AssetID = r.Field<int>(this.dsDoc.DocsActDetail.AssetIDColumn.ColumnName)
- })
- .Union
- (from r in arg.dsData.Tables[this.dsDoc.DocsVKeepDetail.TableName].AsEnumerable()
- where r.Field<object>(this.dsDoc.DocsVKeepDetail.AssetKindIDColumn.ColumnName) != null &&
- r.Field<object>(this.dsDoc.DocsVKeepDetail.AssetIDColumn.ColumnName) != null
- select new
- {
- AssetKindID = r.Field<int>(this.dsDoc.DocsVKeepDetail.AssetKindIDColumn.ColumnName),
- AssetID = r.Field<int>(this.dsDoc.DocsVKeepDetail.AssetIDColumn.ColumnName)
- })
- .Union//кол. активы
- (from r in arg.dsData.Tables[this.dsDoc.DocsEvalutAmDetail.TableName].AsEnumerable()
- where r.Field<object>(this.dsDoc.DocsEvalutAmDetail.AssetKindIDColumn.ColumnName) != null &&
- r.Field<object>(this.dsDoc.DocsEvalutAmDetail.AssetIDColumn.ColumnName) != null
- select new
- {
- AssetKindID = r.Field<int>(this.dsDoc.DocsEvalutAmDetail.AssetKindIDColumn.ColumnName),
- AssetID = r.Field<int>(this.dsDoc.DocsEvalutAmDetail.AssetIDColumn.ColumnName)
- })
- .Union//банковские счета
- (from r in arg.dsData.Tables[this.dsDoc.DocsEvalutMnDetail.TableName].AsEnumerable()
- where r.Field<object>(this.dsDoc.DocsEvalutMnDetail.AssetKindIDColumn.ColumnName) != null &&
- r.Field<object>(this.dsDoc.DocsEvalutMnDetail.AssetIDColumn.ColumnName) != null &&
- (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)
- select new
- {
- AssetKindID = r.Field<int>(this.dsDoc.DocsEvalutMnDetail.AssetKindIDColumn.ColumnName),
- AssetID = r.Field<int>(this.dsDoc.DocsEvalutMnDetail.AssetIDColumn.ColumnName)
- })
- .Union////
- (from r in arg.dsData.Tables[this.dsDoc.DocsOperDetAnalyt.TableName].AsEnumerable()
- where r.Field<object>(this.dsDoc.DocsOperDetAnalyt.IDColumn.ColumnName) != null &&
- (r.Field<int>(this.dsDoc.DocsOperDetAnalyt.AnalyticPlanIDColumn.ColumnName) == (int)CData.Dict.CAnalytic.id.SPaper ||
- r.Field<int>(this.dsDoc.DocsOperDetAnalyt.AnalyticPlanIDColumn.ColumnName) == (int)CData.Dict.CAnalytic.id.REstate ||
- r.Field<int>(this.dsDoc.DocsOperDetAnalyt.AnalyticPlanIDColumn.ColumnName) == (int)CData.Dict.CAnalytic.id.CRight ||
- r.Field<int>(this.dsDoc.DocsOperDetAnalyt.AnalyticPlanIDColumn.ColumnName) == (int)CData.Dict.CAnalytic.id.OAsset)
- select new
- {
- AssetKindID = (r.Field<int>(this.dsDoc.DocsOperDetAnalyt.AnalyticPlanIDColumn.ColumnName) == (int)CData.Dict.CAnalytic.id.SPaper ? (int)CData.Dict.CAssetKind.id.SPaper :
- r.Field<int>(this.dsDoc.DocsOperDetAnalyt.AnalyticPlanIDColumn.ColumnName) == (int)CData.Dict.CAnalytic.id.REstate ? (int)CData.Dict.CAssetKind.id.REstate :
- r.Field<int>(this.dsDoc.DocsOperDetAnalyt.AnalyticPlanIDColumn.ColumnName) == (int)CData.Dict.CAnalytic.id.CRight ? (int)CData.Dict.CAssetKind.id.CRight :
- r.Field<int>(this.dsDoc.DocsOperDetAnalyt.AnalyticPlanIDColumn.ColumnName) == (int)CData.Dict.CAnalytic.id.OAsset ? (int)CData.Dict.CAssetKind.id.OAsset : -1),
- AssetID = r.Field<int>(this.dsDoc.DocsOperDetAnalyt.IDColumn.ColumnName)
- })
- .Union
- (from h in arg.dsData.Tables[this.dsDoc.DocsPay.TableName].AsEnumerable()
- join r in arg.dsData.Tables[this.dsDoc.DocsPayDetail.TableName].AsEnumerable()
- on h.Field<int>(this.dsDoc.DocsPay.PayDocIDColumn.ColumnName) equals r.Field<int>(this.dsDoc.DocsPayDetail.PayDocIDColumn.ColumnName)
- where h.Field<object>(this.dsDoc.DocsPay.AssetKindIDColumn.ColumnName) != null &&
- r.Field<object>(this.dsDoc.DocsPayDetail.AssetIDColumn.ColumnName) != null
- select new
- {
- AssetKindID = h.Field<int>(this.dsDoc.DocsPay.AssetKindIDColumn.ColumnName),
- AssetID = r.Field<int>(this.dsDoc.DocsPayDetail.AssetIDColumn.ColumnName)
- })
- .Union
- (from r in arg.dsData.Tables[this.dsDoc.DocsPayBillDetail.TableName].AsEnumerable()
- where r.Field<object>(this.dsDoc.DocsPayBillDetail.AssetKindIDColumn.ColumnName) != null &&
- r.Field<object>(this.dsDoc.DocsPayBillDetail.SecurityIDColumn.ColumnName) != null
- select new
- {
- AssetKindID = r.Field<int>(this.dsDoc.DocsPayBillDetail.AssetKindIDColumn.ColumnName),
- AssetID = r.Field<int>(this.dsDoc.DocsPayBillDetail.SecurityIDColumn.ColumnName)
- })
- .Union
- (from h in arg.dsData.Tables[this.dsDoc.DocsPayBill.TableName].AsEnumerable()
- join r in arg.dsData.Tables[this.dsDoc.DocsPayBillAsset.TableName].AsEnumerable()
- on h.Field<int>(this.dsDoc.DocsPayBill.BillPayDocIDColumn.ColumnName) equals
- r.Field<int>(this.dsDoc.DocsPayBillAsset.BillPayDocIDColumn.ColumnName)
- where h.Field<object>(this.dsDoc.DocsPayBill.AssetKindIDColumn.ColumnName) != null &&
- r.Field<object>(this.dsDoc.DocsPayBillAsset.AssetIDColumn.ColumnName) != null
- select new
- {
- AssetKindID = h.Field<int>(this.dsDoc.DocsPayBill.AssetKindIDColumn.ColumnName),
- AssetID = r.Field<int>(this.dsDoc.DocsPayBillAsset.AssetIDColumn.ColumnName)
- })
- .Union
- (from r in arg.dsData.Tables[this.dsDict.AgentEmis.TableName].AsEnumerable()
- where r.Field<object>(this.dsDict.AgentEmis.AssetKindIDColumn.ColumnName) != null &&
- r.Field<object>(this.dsDict.AgentEmis.AssetIDColumn.ColumnName) != null
- select new
- {
- AssetKindID = r.Field<int>(this.dsDict.AgentEmis.AssetKindIDColumn.ColumnName),
- AssetID = r.Field<int>(this.dsDict.AgentEmis.AssetIDColumn.ColumnName)
- })
- .Union
- (from r in arg.dsData.Tables[this.dsAgre.AgDisposalAsset.TableName].AsEnumerable()
- where r.Field<object>(this.dsAgre.AgDisposalAsset.AssetIDColumn.ColumnName) != null
- select new
- {
- AssetKindID = (int)1,
- AssetID = r.Field<int>(this.dsAgre.AgDisposalAsset.AssetIDColumn.ColumnName)
- })
- ) arg.asset_id.Add(new int[] { val.AssetKindID, val.AssetID });
Advertisement
Add Comment
Please, Sign In to add comment