/// <summary>
/// 获取企业信息状态
/// </summary>
/// <param name="DWGuid"></param>
/// <returns></returns>
protected string GetDWStatus(object DWGuid)
{
string strSql = string.Format(" SELECT TOP(1)STATUS FROM RG_OUInfo WHERE DWGUID='{0}' ORDER BY ROW_ID DESC ", DWGuid);
return(OUStatus.GetTextByValue(Epoint.MisBizLogic2.DB.ExecuteToString(strSql)));
//return "";
}
/// <summary>
/// 获取动态信息
/// </summary>
/// <param name="DWGuid"></param>
/// <returns></returns>
protected string GetDTStatus(object DWGuid)
{
string strSql = string.Format(" SELECT COUNT(*) FROM RG_DongTaiInfo WHERE DWGUID='{0}' AND UpdateTime>='{1}' AND UpdateTime<='{1}' ",
DWGuid, ViewState["YC"], ViewState["YM"]);
if (Epoint.MisBizLogic2.DB.ExecuteToInt(strSql) == 0)
{
return("<span style='color:red'>本月未填报</span>");
}
strSql = string.Format(" SELECT TOP(1)STATUS FROM RG_DongTaiInfo WHERE DWGUID='{0}' AND UpdateTime>='{1}' AND UpdateTime<='{1}' ORDER BY ROW_ID DESC ",
DWGuid, ViewState["YC"], ViewState["YM"]);
return(OUStatus.GetTextByValue(Epoint.MisBizLogic2.DB.ExecuteToString(strSql)));
//return "";
}
protected string GetStatus(object Status)
{
return(OUStatus.GetTextByValue(Status.ToString()));
//switch (Status.ToString())
//{
// case "1":
// return "编辑中";
// case "2":
// return "待审核";
// case "3":
// return "已通过";
// default:
// return "";
//}
}
protected string GetRSStatus(object DWGuid)
{
//注意还有季度的限制
string strSql = string.Format(" SELECT COUNT(*) FROM RG_RenShiInfo WHERE DWGUID='{0}' AND s_qijian='{1}' ",
DWGuid, ViewState["JD"]);
if (Epoint.MisBizLogic2.DB.ExecuteToInt(strSql) == 0)
{
return("<span style='color:red'>本季度未填报</span>");
}
strSql = string.Format(" SELECT TOP(1)STATUS FROM RG_RenShiInfo WHERE DWGUID='{0}' AND s_qijian='{1}' ORDER BY ROW_ID DESC ",
DWGuid, ViewState["JD"]);
return(OUStatus.GetTextByValue(Epoint.MisBizLogic2.DB.ExecuteToString(strSql)));
//return "";
}
/// <summary>
/// 获取月度财务信息
/// </summary>
/// <param name="DWGuid"></param>
/// <returns></returns>
protected string GetCWStatus(object DWGuid)
{
//注意还有月底的限制
string strSql = string.Format(" SELECT COUNT(*) FROM RG_YueDuCaiWu WHERE DWGUID='{0}' AND YEAR='{1}' AND MONTH='{2}' ",
DWGuid, DateTime.Now.Year, DateTime.Now.Month);
if (Epoint.MisBizLogic2.DB.ExecuteToInt(strSql) == 0)
{
return("<span style='color:red'>本月未填报</span>");
}
strSql = string.Format(" SELECT TOP(1)STATUS FROM RG_YueDuCaiWu WHERE DWGUID='{0}' AND YEAR='{1}' AND MONTH='{2}' ORDER BY ROW_ID DESC ",
DWGuid, DateTime.Now.Year, DateTime.Now.Month);
return(OUStatus.GetTextByValue(Epoint.MisBizLogic2.DB.ExecuteToString(strSql)));
//return "";
}