/// <summary>
/// 根据ProvinceID获取指定属性
/// </summary>
/// <param name="ProvinceID"></param>
/// <param name="PropertyName"></param>
/// <param name="ProvinceDataObj"></param>
/// <returns></returns>
public string GetPropertyByProvinceID(string ProvinceID, string PropertyName, object ProvinceDataObj)
{
string propertyValue = "";
ProvinceData provinceData = (ProvinceData)ProvinceDataObj;
if (provinceData == null)
{
return(propertyValue);
}
if (provinceData.Tables[ProvinceData.TableName].Rows.Count == 0)
{
return(propertyValue);
}
foreach (DataRow row in provinceData.Tables[ProvinceData.TableName].Rows)
{
if (ProvinceID == Convert.ToString(row[ProvinceData.Field_ProvinceID]))
{
propertyValue = Convert.ToString(row[PropertyName]);
break;
}
}
return(propertyValue);
}
private object GetProvinceData()
{
ProvinceData provinceData = new ProvinceData();
DataSet tmpData = new DataSet();
try
{
string Sql_GetProvinceInfo =
@"Select ProvinceID,ProvinceCode,ProvinceName,ProvinceType,'' InterfaceUrl, RegionProvince " +
"From [dbo].[Province]";
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = Sql_GetProvinceInfo;
// 获取数据
tmpData = DBUtility.FillData(cmd, DBUtility.BestToneCenterConStr);
// 数据转换
// DataSet --> SPData
int intTargetColumnCount = provinceData.Tables[ProvinceData.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];
}
provinceData.Tables[ProvinceData.TableName].Rows.Add(newRow);
}
}
catch (Exception Ex)
{
throw Ex;
}
return(provinceData);
}
