62,046
社区成员
发帖
与我相关
我的任务
分享
<asp:GridView ID="GVStuClass" runat="server" AutoGenerateColumns="False"
CellPadding="4" ForeColor="#333333" GridLines="None" CssClass="gridviewText"
AllowPaging="True"
AllowSorting="True">
<AlternatingRowStyle BackColor="White" />
<EditRowStyle BackColor="#2461BF" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F5F7FB" />
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
<SortedDescendingCellStyle BackColor="#E9EBEF" />
<SortedDescendingHeaderStyle BackColor="#4870BE" />
<Columns>
<asp:BoundField DataField="ClassID" Visible="False" />
<asp:BoundField DataField="CourseID" HeaderText="上什么课" >
<ItemStyle Width="15%" />
</asp:BoundField>
<asp:BoundField DataField="TeacherID" HeaderText="授课教师" >
<ItemStyle Width="15%" />
</asp:BoundField>
<asp:BoundField DataField="ClassPlace" HeaderText="上课地点" >
<ItemStyle Width="13%" />
</asp:BoundField>
<asp:BoundField DataField="ClassTime" HeaderText="上课时间" >
<ItemStyle Width="13%" />
</asp:BoundField>
<asp:BoundField DataField="Point" HeaderText="学分" >
<ItemStyle Width="7%" />
</asp:BoundField>
<asp:BoundField DataField="SinOrDou" HeaderText="单/双周" >
<ItemStyle Width="12%" />
</asp:BoundField>
<asp:BoundField DataField="DepartID" HeaderText="所属学院" >
<ItemStyle Width="18%" />
</asp:BoundField>
<asp:TemplateField HeaderText="选择">
<ItemTemplate>
<asp:CheckBox ID="CBStuClass" runat="server" />
</ItemTemplate>
<ItemStyle Width="8%" />
</asp:TemplateField>
</Columns>
</asp:GridView>
protected void Page_Load(object sender, EventArgs e)
{
string userName = Session["userName"].ToString();
AdminBLL adminObject = new AdminBLL();
departID = Convert.ToInt32(adminObject.GetAdminByAdminName(userName).Rows[0]["AdminDepartID"].ToString());
if (!IsPostBack)
{
GVStuClassBind();
}
}
// GridView绑定数据库
public void GVStuClassBind()
{
string adminName = Session["userName"].ToString();
ClassBLL classObject = new ClassBLL();
CourseBLL courseObject = new CourseBLL();
TeacherBLL teacherObject = new TeacherBLL();
DepartBLL departObject = new DepartBLL();
AdminBLL adminObject = new AdminBLL();
GVStuClass.DataSource = classObject.GetClassByDepartID(departID);
GVStuClass.DataBind();
for (int i = 0; i < GVStuClass.Rows.Count; i++)
{
string teacherName, courseName, departName;
int SinOrDou;
int teacherID = Convert.ToInt32(classObject.GetClassByDepartID(departID).Rows[i]["teacherID"].ToString());
teacherName = teacherObject.GetTeacherByTeacherID(teacherID).Rows[0]["TeacherName"].ToString();
int courseID = Convert.ToInt32(classObject.GetClassByDepartID(departID).Rows[i]["CourseID"].ToString());
courseName = courseObject.GetCourseByCourseID(courseID).Rows[0]["CourseName"].ToString();
departName = departObject.GetDepartByDepartID(departID).Rows[0]["DepartName"].ToString();
SinOrDou = Convert.ToInt32(classObject.GetClassByDepartID(departID).Rows[i]["SinOrDou"].ToString());
if (SinOrDou == 1)
GVStuClass.Rows[i].Cells[6].Text = "单周";
if (SinOrDou == 2)
GVStuClass.Rows[i].Cells[6].Text = "双周";
if (SinOrDou == 0)
GVStuClass.Rows[i].Cells[6].Text = "全周";
GVStuClass.Rows[i].Cells[2].Text = teacherName;
GVStuClass.Rows[i].Cells[1].Text = courseName;
GVStuClass.Rows[i].Cells[7].Text = departName;
}
}
select (case SinOrDou when 1 then '单周' when 2 then '双周' else '全周') as SinOrDou from tb
<dx:GridViewDataColumn Caption="授课教师" VisibleIndex="14" Width="100%" > <DataItemTemplate>
<%#GeteacherNamebyId(Eval("TeacherID"))%>
</DataItemTemplate>
<EditFormSettings Visible="False" />
</dx:GridViewDataColumn>