public List<HR_In> GetTimeSheettreeZW(string code) { List<HR_Department> list = deptInstance.GetLevelDeptListWidthSeft(code); StringBuilder sb = new StringBuilder(); for (int i = 0; i < list.Count; i++) { var d = list[i]; sb.AppendFormat("'{0}',", d.Dept_Code); } string where = string.Format(" AND Stuff_DepCode in ({0})", sb.ToString().Trim().TrimEnd(',')); List<HR_In> listS = new DAL.ADODeptEmployee_Relation().GetListByWhereZW(where); return listS; }
public List <HR_In> GetTimeSheettreeZW(string code) { List <HR_Department> list = deptInstance.GetLevelDeptListWidthSeft(code); StringBuilder sb = new StringBuilder(); for (int i = 0; i < list.Count; i++) { var d = list[i]; sb.AppendFormat("'{0}',", d.Dept_Code); } string where = string.Format(" AND Stuff_DepCode in ({0})", sb.ToString().Trim().TrimEnd(',')); List <HR_In> listS = new DAL.ADODeptEmployee_Relation().GetListByWhereZW(where); return(listS); }