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);
}
