Exemplo n.º 1
0
//		/// <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 + "'"));
        }
Exemplo n.º 2
0
        /// <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 + "'"));
        }