/// <summary> /// 根据省份ID获取服务商 /// </summary> /// <param name="proId"></param> /// <returns></returns> public static IList <CloudServer> GetAllCloudServiceDealByProId(int proId) { IList <CloudServer> list = new List <CloudServer>(); string sql = "select * from CloudServiceList"; if (proId > 0) { sql += " where ProID ='" + proId + "';"; } DataTable table = DBHelper.GetDataSet(sql); foreach (DataRow row in table.Rows) { CloudServer cldser = new CloudServer(); cldser.CloudServiceID = (int)row["CloudServiceID"]; cldser.CloudServiceName = (String)row["CloudServiceName"]; cldser.ProvinceID = CloudServiceProService.GetCloudServiceProById(int.Parse(row["ProID"].ToString())); cldser.Address = (string)row["Address"]; cldser.Company = (string)row["Company"]; cldser.WebSite = (string)row["WebSite"]; cldser.Logo = (string)row["Logo"]; list.Add(cldser); } return(list); }
/// <summary> /// 根据服务商ID和用户ID获取服务商 /// </summary> /// <param name="cloudserviceid"></param> /// <returns></returns> public static CloudServer GetCloudServiceByCldSerIdAndUserId(string cloudserviceid, string userid) { CloudServer cldser = new CloudServer(); string sql = "select * from CloudService where CloudServiceID='" + cloudserviceid + "'"; SqlDataReader datareader = DBHelper.GetReader(sql); if (datareader.Read()) { cldser.CloudServiceID = (int)datareader["CloudServiceID"]; cldser.CloudServiceName = (string)datareader["CloudServiceName"]; cldser.ProvinceID = CloudServiceProService.GetCloudServiceProById(int.Parse(datareader["ProID"].ToString())); cldser.Address = (string)datareader["Address"]; cldser.Company = (string)datareader["Company"]; cldser.WebSite = (string)datareader["WebSite"]; cldser.Logo = (string)datareader["Logo"]; } datareader.Close(); return(cldser); }