public static EntityData GetFinanceSubjectSet(DataTable tbRelation) { EntityData data2; try { EntityData allSubjectSet = SubjectDAO.GetAllSubjectSet(); allSubjectSet.CurrentTable.Columns.Add("U8Code"); foreach (DataRow row in tbRelation.Rows) { string text = ConvertRule.ToString(row["SubjectSetCode"]); string text2 = ConvertRule.ToString(row["U8Code"]); DataRow[] rowArray = allSubjectSet.CurrentTable.Select(string.Format("SubjectSetCode='{0}'", text)); if (rowArray.Length > 0) { rowArray[0]["U8Code"] = text2; } } data2 = allSubjectSet; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetFinanceSubjectSetWithProject(DataTable tbRelation, string SubjectSetCode, string ProjectCode) { EntityData data3; try { EntityData allSubjectSet; EntityData data = new EntityData("SupplierSubjectSet"); data.CurrentTable.Columns.Add("SubjectSetName"); data.CurrentTable.Columns.Add("ProjectName"); if (SubjectSetCode == "") { allSubjectSet = SubjectDAO.GetAllSubjectSet(); } else { allSubjectSet = SubjectDAO.GetSubjectSetByCode(SubjectSetCode); } QueryAgent agent = new QueryAgent(); try { foreach (DataRow row in allSubjectSet.CurrentTable.Rows) { string text = ConvertRule.ToString(row["FinanceInterfaceSupplierCode"]); string queryString = "select * from ( select a.SubjectSetCode + '_' + p.ProjectCode as SupplierSubjectSetCode, a.SubjectSetCode, a.SubjectSetName, p.ProjectCode, p.ProjectName from SubjectSet a, Project p where a.SubjectSetCode = p.SubjectSetCode union all select a.SubjectSetCode + '_' as SupplierSubjectSetCode, a.SubjectSetCode, a.SubjectSetName, '', '集团' from SubjectSet a) as a where 1 = 1 and SubjectSetCode = '" + ConvertRule.ToString(row["SubjectSetCode"]) + "'"; if (text.ToUpper() == "ByGroup".ToUpper()) { queryString = queryString + " and ProjectCode = ''"; } else if (ProjectCode != "") { queryString = queryString + " and ProjectCode = '" + ProjectCode + "'"; } else { queryString = queryString + " and ProjectCode <> ''"; } queryString = queryString + " order by SubjectSetName, ProjectName"; DataTable tbSrc = agent.ExecSqlForDataSet(queryString).Tables[0]; foreach (DataRow row2 in tbSrc.Rows) { DataRow drDst = data.CurrentTable.NewRow(); ConvertRule.DataRowCopy(row2, drDst, tbSrc, data.CurrentTable); data.CurrentTable.Rows.Add(drDst); } } } finally { agent.Dispose(); } foreach (DataRow row4 in tbRelation.Rows) { string text3 = ConvertRule.ToString(row4["SubjectSetCode"]); string text4 = ConvertRule.ToString(row4["ProjectCode"]); string text5 = ConvertRule.ToString(row4["U8Code"]); DataRow[] rowArray = data.CurrentTable.Select(string.Format("SubjectSetCode='{0}' and ProjectCode='{1}'", text3, text4)); if (rowArray.Length > 0) { rowArray[0]["U8Code"] = text5; } } allSubjectSet.Dispose(); data3 = data; } catch (Exception exception) { throw exception; } return(data3); }