// /// <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 + "'")); }