private void fillGrid(DataSet ds) { GridView_All.DataSource = ds.Tables[0]; GridView_All.DataBind(); }
private void ShowCalender() //顯示行事曆 { try { Session["PickDate"] = TextBox_DatePick.Text; //取得目前日期 string[] PickDate = Session["PickDate"].ToString().Split('-'); #region 顯示日期 Session["Days"] = 0; int days = GetDaysInMonth(Convert.ToInt32(PickDate[1]), Convert.ToInt32(PickDate[0])); //依照天數創建表格 DataTable dt = new DataTable(); DataRow drow; //DataColumn dcol1 = new DataColumn("Column1", typeof(string)); //dt.Columns.Add(dcol1); for (int i = 1; i <= days; i++) { drow = dt.NewRow(); dt.Rows.Add(drow); } #endregion DataSet CalenderDs = new DataSet(); string Tsql = ""; if (Session["PPermission"].ToString() == "1" || Session["SPermission"].ToString() == "1") { for (int i = 1; i <= days; i++) { Tsql += "SELECT ProjectID, MissionID, MType, Creator, Title, Description, StartDate AS StartDate, EndDate, CreatDate, ResponsibleName, Complete, CompleteDate FROM PMMission WHERE (ProjectID = '" + DropDownList_Project.SelectedValue.ToString() + "') AND (DATEPART(MM, StartDate) = '" + PickDate[1] + "') AND (DATEPART(yyyy, StartDate) = '" + PickDate[0] + "') AND (DATEPART(dd, StartDate) = '" + i + "') AND (Alive = '1');"; } } else { #region 取得使用者擁有的任務代號 string LTsql = "SELECT MissionID FROM PMMMember WHERE (ProjectID = '" + DropDownList_Project.SelectedValue.ToString() + "') AND (UserID = '" + Session["UserID"].ToString() + "') AND (Alive = '1') ORDER BY MissionID"; DataSet MMerberList = SS.GetSqlTable(LTsql); string UserMissionID = ""; if (MMerberList.Tables[0].Rows.Count > 0) { UserMissionID = "AND (MissionID = '" + MMerberList.Tables[0].Rows[0]["MissionID"].ToString() + "'"; for (int i = 1; i < MMerberList.Tables[0].Rows.Count; i++) { UserMissionID += " OR MissionID = '" + MMerberList.Tables[0].Rows[i]["MissionID"].ToString() + "'"; } UserMissionID += ")"; for (int i = 1; i <= days; i++) { Tsql += "SELECT ProjectID, MissionID, MType, Creator, Title, Description, StartDate AS StartDate, EndDate, CreatDate, ResponsibleName, Complete, CompleteDate FROM PMMission WHERE (ProjectID = '" + DropDownList_Project.SelectedValue.ToString() + "') AND (DATEPART(MM, StartDate) = '" + PickDate[1] + "') AND (DATEPART(yyyy, StartDate) = '" + PickDate[0] + "') AND (DATEPART(dd, StartDate) = '" + i + "') AND (Alive = '1')" + UserMissionID + ";"; } } #endregion } CalenderDs = SS.GetSqlTable(Tsql); Session["CalenderDs"] = CalenderDs; GridView_All.DataSource = dt; GridView_All.DataBind(); } catch { Relogin(1, 0); } }