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);
}
