private void IniGrid1()
{
grid1.Cell(0, 0).Text = "序号";
grid1.Column(0).Width = 40;
grid1.Cell(0, 1).Text = "ID";
grid1.Column(1).Width = 50;
grid1.Column(1).Alignment = FlexCell.AlignmentEnum.CenterCenter;
grid1.Cell(0, 2).Text = "人员姓名";
grid1.Column(2).Width = 100;
grid1.Column(2).Alignment = FlexCell.AlignmentEnum.CenterCenter;
grid1.Cell(0, 3).Text = "职位";
grid1.Column(3).Width = 80;
grid1.Column(3).Alignment = FlexCell.AlignmentEnum.CenterCenter;
grid1.Cell(0, 4).Text = "部门";
grid1.Column(4).Width = 150;
grid1.Column(4).Alignment = FlexCell.AlignmentEnum.CenterCenter;
grid1.Cell(0, 5).Text = "用户状态";
grid1.Column(5).Width = 80;
grid1.Column(5).Alignment = FlexCell.AlignmentEnum.CenterCenter;
//var au = Person.FindAll();
//var au = Person.FindAll(Person._.Status,'1');
string sSql = " select Deptid,DeptName from Dept order by deptID";
var dau = Dept.FindAll(sSql);
comDeptID.Items.Clear();
foreach (Dept dau1 in dau)
{
comDeptID.Items.Add(dau1.DeptID.ToString().Trim() + "|" + dau1.DeptName.ToString().Trim());
}
sSql = " select p.ID,p.Pname,p.Job,p.Areaid,p.[Status] ,p.deptid,d.deptname from Person p ";
sSql += " inner join dept d on p.deptid=d.deptid";
sSql += " where p.[Status]='1' order by p.Job";
var au = Person.FindAll(sSql);
Int32 ir = 1;
if (au.Count > 0)
{
grid1.Rows = ir;
foreach (Person u in au)
{
ir += 1;
grid1.Rows = ir;
try
{
grid1.Cell(ir - 1, 1).Text = u.ID.ToString();
grid1.Cell(ir - 1, 2).Text = u.Pname.ToString().Trim();
grid1.Cell(ir - 1, 3).Text = u.Job.ToString().Trim();
grid1.Cell(ir - 1, 4).Text = u.DeptID.ToString().Trim();
grid1.Cell(ir - 1, 5).Text = u.Status.ToString().Trim();
}
catch { }
}
}
}