// /// <summary>
// /// 通过招标公告的ID来获得:服务申请编号,合同模式,采办策略编号,项目名称
// /// </summary>
// /// <param name="publishID"></param>
// /// <returns></returns>
// public Hashtable GetDetailByPublishID ( string publishID )
// {
// string SelectSql = "SELECT TCStrategy.SRID , TCStrategy.ContractMode , TCStrategy.ProjectName , TCStrategy.TenderID FROM TCStrategy JOIN BidPlacard on TCStrategy.TenderID = BidPlacard.TenderID WHERE BidPlacard.PublishID = '"+publishID+"'";
//
// Hashtable hashtable = new Hashtable();
//
// using ( System.Data.SqlClient.SqlDataReader dr = _da.GetDataReader ( SelectSql ) )
// {
// while ( dr.Read() )
// {
// hashtable.Add ( "SRID" , Convert.ToString ( dr["SRID"] ));
// hashtable.Add ( "ContractMode" , Convert.ToString ( dr["ContractMode"] ) );
// hashtable.Add ( "ProjectName" , Convert.ToString ( dr["ProjectName"] ) );
// hashtable.Add ( "TenderID" , Convert.ToString ( dr["TenderID"] ));
// }
// }
//
// return hashtable ;
// }
/// <summary>
/// 更新招标公告的状态
/// </summary>
/// <param name="TenderState"></param>
/// <param name="IDKey"></param>
/// <returns></returns>
public string UpdateState(DataEntity.TenderState state, string PublishID)
{
int nTenderState = (int)state;
return(_da.ExecuteDMLSQL("UPDATE BidPlacard Set State = " + nTenderState + " WHERE PublishID = '" + PublishID + "'"));
}
/// <summary>
/// 更新SR的状态
/// </summary>
/// <param name="TenderState"></param>
/// <param name="IDKey"></param>
/// <returns></returns>
public string UpdateTenderState(DataEntity.TenderState state, string IDKey)
{
int nTenderState = (int)state;
return(_da.ExecuteDMLSQL("UPDATE ServiceRequistion Set SRState = " + nTenderState + " WHERE IDKey = '" + IDKey + "'"));
}
