/// <summary> /// 根据电话区号获取指定属性 /// </summary> /// <param name="PhoneAreaCode"></param> /// <param name="PropertyName"></param> /// <param name="PhoneAreaDataObj"></param> /// <returns></returns> public string GetPropertyByPhoneAreaCode(string PhoneAreaCode, string PropertyName, object PhoneAreaDataObj) { string propertyValue = ""; PhoneAreaData phoneareaData = (PhoneAreaData)PhoneAreaDataObj; if (phoneareaData == null) { return(propertyValue); } if (phoneareaData.Tables[PhoneAreaData.TableName].Rows.Count == 0) { return(propertyValue); } foreach (DataRow row in phoneareaData.Tables[PhoneAreaData.TableName].Rows) { if (PhoneAreaCode == Convert.ToString(row[PhoneAreaData.Field_PhoneAreaID])) { propertyValue = Convert.ToString(row[PropertyName]); break; } } return(propertyValue); }
private object GetPhoneAreaData(string ProvinceID) { PhoneAreaData phoneareaData = new PhoneAreaData(); DataSet tmpData = new DataSet(); try { string Sql_GetPhoneArea = "Select AreaID AreaID, AreaName AreaName,ProvinceID ProvinceID " + "From [dbo].[Area] where ProvinceID='" + ProvinceID + "'"; SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = Sql_GetPhoneArea; // 获取数据 tmpData = DBUtility.FillData(cmd, DBUtility.BestToneCenterConStr); // 数据转换 // DataSet --> PhoneAreaData int intTargetColumnCount = phoneareaData.Tables[PhoneAreaData.TableName].Columns.Count; foreach (DataRow row in tmpData.Tables[0].Rows) { object[] newRow = new object[intTargetColumnCount]; for (int j = 0; j < intTargetColumnCount; j++) { newRow[j] = row[j]; } phoneareaData.Tables[PhoneAreaData.TableName].Rows.Add(newRow); } } catch (Exception Ex) { throw Ex; } return(phoneareaData); }
private object GetPhoneAreaData() { PhoneAreaData phoneareaData = new PhoneAreaData(); DataSet tmpData = new DataSet(); try { string Sql_GetPhoneArea = "Select AreaID AreaID, AreaName AreaName,ProvinceID ProvinceID " + "From [dbo].[Area]"; SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = Sql_GetPhoneArea; // 获取数据 tmpData = DBUtility.FillData(cmd, DBUtility.BestToneCenterConStr); // 数据转换 // DataSet --> PhoneAreaData int intTargetColumnCount = phoneareaData.Tables[PhoneAreaData.TableName].Columns.Count; foreach (DataRow row in tmpData.Tables[0].Rows) { object[] newRow = new object[intTargetColumnCount]; for (int j = 0; j < intTargetColumnCount; j++) { newRow[j] = row[j]; } phoneareaData.Tables[PhoneAreaData.TableName].Rows.Add(newRow); } } catch (Exception Ex) { throw Ex; } return phoneareaData; }