protected void Page_Load(object sender, EventArgs e)
{
RegisterOEMSkins("form.css");
RegisterOEMSkins("page.css");
if (!IsPostBack)
{
initData();
string provinceCode = Request.QueryString["provinceCode"];
if (!string.IsNullOrWhiteSpace(provinceCode))
{
AreaRelationView view = AreaService.QueryRelation(provinceCode);
this.lblProvinceName.Text = view.ProcinceName;
this.dropArea.SelectedValue = view.AreaName;
}
}
}
public AreaRelationView QueryRelation(string provinceCode)
{
AreaRelationView view = null;
string sql = "SELECT [Province],[ProvinceName],[Name] from [dbo].[V_SellArea] where [Province]=@Province";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("Province", provinceCode);
using (var reader = dbOperator.ExecuteReader(sql)) {
while (reader.Read())
{
view = new AreaRelationView();
view.Province = reader.GetString(0);
view.AreaName = reader.IsDBNull(2) ? string.Empty : reader.GetString(2);
view.ProcinceName = reader.IsDBNull(1) ? string.Empty : reader.GetString(1);
}
}
}
return(view);
}
