/// <summary> /// Bind the divisions by region /// </summary> private void BindDivisions() { //获取当前region的所有division var dsDivisions = _bllDivisions.GetList(string.Format(" [RegionID]={0}", CurrentRegion.RegionId)); gridDivisionList.DataSource = dsDivisions; gridDivisionList.DataBind(); }
/// <summary> /// Get division data /// </summary> /// <returns></returns> private DataTable GetDivisionData(string sRegionID) { DataTable dtDivision; try { Divisions divisionManager = new Divisions(); //Binding Division string sCondition = " Enabled='true'"; if (sRegionID != "" && sRegionID != "0") { sCondition += " AND RegionID = " + sRegionID; } dtDivision = divisionManager.GetList(sCondition).Tables[0]; DataRow drNewDivision = dtDivision.NewRow(); drNewDivision["DivisionId"] = 0; drNewDivision["Name"] = "All Divisions"; dtDivision.Rows.InsertAt(drNewDivision, 0); } catch (Exception ex) { throw ex; } return(dtDivision); }