private void lue_Brand_EditValueChanged(object sender, EventArgs e) { try { if (lue_Brand.ItemIndex >= 0) { int id = Convert.ToInt32(lue_Brand.EditValue.ToString()); Service.IService.IPropTypeBase prop = new Service.ServiceImp.PropTypeBase(); bool IsExist = prop.IsExist(p => p.PROPPARENT == id); if (IsExist) { InitLookUpEdit(lue_Model, id); //加载类型 } else { lue_Model.Properties.DataSource = null; } } else { lue_Model.Properties.NullText = "请选择"; } } catch (Exception ex) { XtraMessageBox.Show("加载类型出错!" + ex.Message); } }
/// <summary> /// 加载下拉列表 /// </summary> /// <param name="lue">下拉控件</param> /// <param name="parentId">根节点ID</param> private void InitLookUpEdit(LookUpEdit lue, int parentId) { try { if (parentId <= 0) { return; } Service.IService.IPropTypeBase prop = new Service.ServiceImp.PropTypeBase(); var list_lue = prop.LoadListAll(p => p.PROPPARENT == parentId); //品牌 if (list_lue.Count() > 0) { Domain.PROPTYPEBASE p = new Domain.PROPTYPEBASE(); p.PROPID = 0; p.PROPNAME = ""; list_lue.Insert(0, p); var l = list_lue.Select(m => new { m.PROPID, m.PROPNAME }).ToList(); lue.Properties.NullText = "请选择"; lue.EditValue = "PROPID"; lue.Properties.ValueMember = "PROPID"; lue.Properties.DisplayMember = "PROPNAME"; lue.Properties.ShowHeader = false; lue.ItemIndex = 0; //选择第一项 lue.Properties.DataSource = l; //自适应宽度 lue.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup; //填充列 lue.Properties.PopulateColumns(); //lue.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("PROPID")); lue.Properties.Columns[0].Visible = false; } else { lue.Properties.NullText = "请选择"; } } catch (Exception ex) { XtraMessageBox.Show("加载数据出错!" + ex.Message); } }
/// <summary> /// 根据年份统计 /// </summary> /// <param name="time"></param> /// <returns></returns> private DataTable GetData_Year(DateTime time) { DataTable dt = new DataTable(); dt.Columns.Add("Count", typeof(int)); //个数 dt.Columns.Add("Brand", typeof(string)); //品牌 DataRow dr; try { Service.IService.IMobilePhone service = new Service.ServiceImp.MobilePhone(); Service.IService.IPropTypeBase prop = new Service.ServiceImp.PropTypeBase(); var firstMonth = Convert.ToDateTime(time.Year + "-01-01"); var lastMonth = Convert.ToDateTime(Convert.ToDateTime(time.Year + "-12-31").ToString("yyyy-MM-dd 23:59")); var list = service.LoadListAll(p => p.MobileOutTime >= firstMonth && p.MobileOutTime < lastMonth); var brand = prop.LoadListAll(p => p.PROPPARENT == 2); //获取所有品牌 foreach (var b in brand) { dr = dt.NewRow(); dr["Brand"] = b.PROPNAME; dr["Count"] = list.Where(p => p.MobileBrandId == b.PROPID).Where(p => p.MobileOutTime >= firstMonth && p.MobileOutTime < lastMonth).ToList().Count; dt.Rows.Add(dr); } } catch (Exception) { throw; } return(dt); }