Esempio n. 1
0
        /// <summary>
        /// 查询所有ID
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public string SelCompanyID()
        {
            StringBuilder sb  = new StringBuilder();
            string        sql = "select CompanyID from CompanyShow order by StartTime desc";
            DataSet       ds  = crm.ExecuteQueryShow(sql);

            if (ds != null & ds.Tables[0].Rows.Count > 0)
            {
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    DataRow row = ds.Tables[0].Rows[i];
                    sb.Append("" + row["CompanyID"].ToString() + ",");
                }
            }
            return(sb.ToString());
        }