/// <summary> /// 只查找从某周到某周 /// </summary> /// <param name="startWeek"></param> /// <param name="WeekEnd"></param> /// <returns></returns> public static DataTable GetDataAndCreateChartBySum(int startWeek, int WeekEnd) { string strSql = "select * from TabDepartment";//每个系部总人数 DataTable dtCount = AddSQLStringToDAL.GetDtBySQL(strSql); string[] AllCount = new string[dtCount.Rows.Count];//保存每个系部总人数 for (int i = 0; i < dtCount.Rows.Count; i++) { AllCount[i] = dtCount.Rows[i]["sum"].ToString(); } string[] AllDepartment = { "会计系", "信息工程系", "经济管理系", "食品工程系", "机械工程系", "商务外语系", "建筑工程系" }; string[] AllData = new string[AllDepartment.Length]; string[] AllLate = new string[AllDepartment.Length]; string[] AllAttendance = new string[AllDepartment.Length]; string[] AllEarly = new string[AllDepartment.Length]; string[] AllLeave = new string[AllDepartment.Length]; //储存每个系合计后的考勤情况 for (int i = 0; i < AllDepartment.Length; i++) { string[] allWeek = AllWeekInitial(AllDepartment[i], startWeek, WeekEnd); AllData[i] = allWeek[4]; //各种缺勤合计 AllLeave[i] = allWeek[3]; //请假合计 AllAttendance[i] = allWeek[2]; //旷课 AllEarly[i] = allWeek[1]; //早退 AllLate[i] = allWeek[0]; //迟到 } //储存所有系考勤合计和缺勤率 DataTable gridViewDt = CreateDataTableReplaceChart(AllDepartment, AllCount, AllLate, AllEarly, AllAttendance, AllLeave, AllData); return(gridViewDt); }
private static void FillParentNode(TreeNode node, string menuName) { string sqlQuery = "Select DISTINCT Parent_Node From " + menuName + ""; DataTable dt = AddSQLStringToDAL.GetDtBySQL(sqlQuery); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { TreeNode NewNode = new TreeNode(row["Parent_Node"].ToString(), "ddad"); NewNode.PopulateOnDemand = true; NewNode.SelectAction = TreeNodeSelectAction.Expand; node.ChildNodes.Add(NewNode); } } }
public static void FillChildNode(TreeNode node, string menuName) { string sqlQuery = "Select * From " + menuName + "" + " Where Parent_Node = '" + node.Text + "'"; DataTable dt = AddSQLStringToDAL.GetDtBySQL(sqlQuery); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { TreeNode NewNode = new TreeNode(row["Child_Node"].ToString(), "", "", row["Navigate_Url"].ToString(), ""); NewNode.PopulateOnDemand = false; node.ChildNodes.Add(NewNode); } } }