private void pageinit() { DataTable list; list = ULCode.QDA.XSql.GetDataTable("Select te.UserID,te.RealName,te.Sex,te.Mobile,te.Email,te.IDCard,te.Edu,td.Name deptname,tduty.Name dutyname from TU_Employees te left join TE_Departments td on te.DepartmentID=td.ID left join TE_Duties tduty on te.dutyID=tduty.ID where te.CompanyId=" + Request["CompanyId"] + " order by te.Sort asc"); AssetsRepeater.DataSource = list; AssetsRepeater.DataBind(); }
private void pageinit() { DataTable list; list = ULCode.QDA.XSql.GetDataTable("Select tcp.*,te.IDCard,te.Sex,tu.RealName from [TE_Companys_Partner] tcp left join TU_Users tu on tcp.EmployeeID=tu.UserID left join TU_Employees te on tcp.EmployeeID=te.UserID where tcp.State=1 and tcp.CompanyId=" + Request["CompanyId"] + " order by ID asc"); AssetsRepeater.DataSource = list; AssetsRepeater.DataBind(); }