/// <summary>
/// 根据投资类型和审批类型获取相对应的主要审批手续
/// </summary>
/// <param name="ProjGuid">项目主键</param>
/// <returns></returns>
public static DataSet GetMainByType(string ProjGuid)
{
string MainSql = "";
//string ProjAffiliationSql = "";//获取该项目的项目主从关系
//DataSet AffiliationDs = new DataSet();//项目主从关系
string ProjAffiliation = BuildProcedureInfo.GetProjAffiliation(ProjGuid);
//判断该项目是主项目还是子项目
int count = BuildProcedureInfo.GetProjTop(ProjGuid);
//如果是主项目
if (count == 0)
{
// //判断主从关系是否是集中批复立项可研概算，子项目独立概算
if (ProjAffiliation == "集中批复立项可研概算")
{
//只显示集中批复立项可研概算
MainSql = "SELECT * FROM Busi_ApprovalConfig WHERE Type='主要审批手续' AND Code IN ('1','2','3','4','5','6','7','10','12') ORDER BY convert(INT, Code)";
}
}
//如果是子项目
else
{
// //判断主从关系是否是集中批复立项可研概算，子项目独立概算
if (ProjAffiliation == "集中批复立项可研概算")
{
//根据投资类型查询出相对应的审批手续
//加入集中批复立项可研概算
MainSql = "SELECT * FROM Busi_ApprovalConfig WHERE Type='主要审批手续' AND Code IN ('11') ORDER BY OrderCode";
}
}
DataSet MainDs = GetDatabase().ExecuteDataSet(MainSql);
return(MainDs);
}
/// <summary>
/// 判断项目是主项目还是子项目
/// </summary>
/// <param name="ProjGuid"></param>
/// <returns></returns>
public static int GetProjTop(string ProjGuid)
{
return(BuildProcedureInfo.GetProjTop(ProjGuid));
}