/// <summary>
/// 更新SR的状态
/// </summary>
/// <param name="strITBDocumentID">标书的IDKey</param>
/// <param name="State">状态，本处应该为3（开标阶段）</param>
/// <returns>错误信息</returns>
public void SetTenderState(string strITBDocumentID)
{
string strSql = "SELECT TenderID FROM ITBDocument WHERE ITBIDKey = '" + strITBDocumentID + "'";
string sTendorID = _da.GetDataTable(strSql).Rows[0][0].ToString();
string strErrorMsg = string.Empty;
if (sTendorID != "")
{
ceu.UpdateStrategyState(sTendorID, TenderState.State_ITBTechOpen);
string UpdateSql = "UPDATE ITBDocument SET State = " + (int)TenderState.State_ITBTechOpen + " WHERE ITBIDKey = '" + strITBDocumentID + "'";
strErrorMsg = _da.ExecuteDMLSQL(UpdateSql);
}
}
/// <summary>
/// 更新策略状态
/// </summary>
/// <param name="state">状态</param>
/// <param name="strTenderID">策略ID</param>
/// <returns>错误信息</returns>
public string UpdateStrategyState(string strTenderIDKey, TenderState state)
{
// Add by ZZH on 2008-1-11 如果是MR状态要回置到MR 所以实例化这类，以调用公共函数
string strErrorMsg = pEntityUitlity.UpdateStrategyState(strTenderIDKey, state);
// int iState = Convert.ToInt32 ( state );
//
// string strErrorMsg = string.Empty;
//
// //string UpdateSql = "UPDATE TCStrategy Set Status = "+iState+" WHERE TenderID = ( SELECT ObjectiveID FROM PutIn Where IDKey = '"+strPutInIDKey+"')";
// string UpdateSql = "UPDATE TCStrategy Set Status = "+iState+" WHERE TenderID = '"+strTenderIDKey+"'";
//
// strErrorMsg = _da.ExecuteDMLSQL( UpdateSql );
//
// // ========= Modified by Liujun at 11.29 ================= //
// /* 更新TC策略得同时,同步更新SR */
// string UpdateSql_SR = "Update ServiceRequistion set ServiceRequistion.TenderState = "+iState+" WHERE ServiceRequistion.IDKey = (SELECT TCStrategy.SRIDKey From TCStrategy WHERE TCStrategy.TenderID = '"+strTenderIDKey+"' )";
// strErrorMsg += _da.ExecuteDMLSQL ( UpdateSql_SR );
// // ==================================================== //
return(strErrorMsg);
//********************************************************************************
}