/// <summary>
/// 2015-11-11
/// 通过项目Guid找到建设程序中证照批复的Guid
/// </summary>
/// <param name="ProjGuid"></param>
/// <param name="fileSign"></param>
/// <returns></returns>
public string GetRefGuid(string ProjGuid, string fileSign)
{
string sql = "";
string strAffiliation = BuildProcedureInfo.GetProjAffiliation(ProjGuid);
if (strAffiliation == "集中立项可研")
{
//判断是否是项目建议书、可行性研究报告
if (fileSign == "Busi_ProjProposal" || fileSign == "Busi_ProjFsbtyStudy")
{
//获取项目的TopGuid主键
string topGuid = "select TopGuid from Busi_ProjRegister where Guid='" + ProjGuid + "' and sysstatus<>-1 ";
if (db.ExecuteScalar(topGuid).ToString() == "")//TopGuid为空是主项目
{
sql = "SELECT TOP 1 Guid FROM " + fileSign + " WHERE ProjGuid='" + ProjGuid + "' AND SysStatus<>-1 ORDER BY tstamp DESC";
}
else//子项目
{
sql = "SELECT TOP 1 Guid FROM " + fileSign + " WHERE ProjGuid='" + db.ExecuteScalar(topGuid).ToString() + "' AND SysStatus<>-1 ORDER BY tstamp DESC";
}
}
else
{
sql = "SELECT TOP 1 Guid FROM " + fileSign + " WHERE ProjGuid='" + ProjGuid + "' AND SysStatus<>-1 ORDER BY tstamp DESC";
}
}
else if (strAffiliation == "集中批复立项可研概算")
{
//获取项目的TopGuid主键
string topGuid = "select TopGuid from Busi_ProjRegister where Guid='" + ProjGuid + "' and sysstatus<>-1 ";
if (db.ExecuteScalar(topGuid).ToString() == "")//TopGuid为空是主项目
{
sql = "SELECT TOP 1 Guid FROM " + fileSign + " WHERE ProjGuid='" + ProjGuid + "' AND SysStatus<>-1 ORDER BY tstamp DESC";
}
else//子项目
{
sql = "SELECT TOP 1 Guid FROM " + fileSign + " WHERE ProjGuid='" + db.ExecuteScalar(topGuid).ToString() + "' AND SysStatus<>-1 ORDER BY tstamp DESC";
}
}
else
{
sql = "SELECT TOP 1 Guid FROM " + fileSign + " WHERE ProjGuid='" + ProjGuid + "' AND SysStatus<>-1 ORDER BY tstamp DESC";
}
string refGuid = "";
if (db.ExecuteScalar(sql) != null)
{
refGuid = db.ExecuteScalar(sql).ToString();
}
return(refGuid);
}
/// <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 string GetProjAffiliation(string ProjGuid)
{
return(BuildProcedureInfo.GetProjAffiliation(ProjGuid));
}