protected void GridViewBind(int CourseID)
        {
            LabMS.BLL.CourseAndProject courseproject = new LabMS.BLL.CourseAndProject();
            List<LabMS.Model.CourseAndProject> courseprojectlist = new List<LabMS.Model.CourseAndProject>();

            string strWhere1 = " CourseID=" + CourseID;
            courseprojectlist = courseproject.GetModelList(strWhere1);

            string strWhere2 = "";

            foreach (LabMS.Model.CourseAndProject cp in courseprojectlist)
            {
                if (cp.ProjectID != null)
                {
                    if (strWhere2.Equals(""))
                    {
                        strWhere2 += " Project.ID=" + cp.ProjectID;
                    }
                    else
                    {
                        strWhere2 += " or Project.ID=" + cp.ProjectID;
                    }
                }
            }
            if (strWhere2 == "")
            {
                strWhere2 = "1<>1";
            }

            ExtendBLL.ProjectAndOther project = new ExtendBLL.ProjectAndOther();
            List<ExtendModule.ProjectAndOther> projectlist = new List<ExtendModule.ProjectAndOther>();

            projectlist = project.GetModelList2(strWhere2);
            gvProjectList.DataSource = projectlist;
            gvProjectList.DataBind();
        }
Esempio n. 2
0
        protected string GetProjectList(object CourseID)
        {
            string ProjectList = "";
            if (CourseID != null)
            {

                int ID = 0;
                if (int.TryParse(CourseID.ToString(), out ID))
                {
                    LabMS.BLL.CourseAndProject CourseProject = new LabMS.BLL.CourseAndProject();
                    List<LabMS.Model.CourseAndProject> lsCourseProject = CourseProject.GetModelList("CourseID=" + ID.ToString());
                    string strWhere = "";
                    if (lsCourseProject.Count != 0)
                    {
                        for (int n = 0; n < lsCourseProject.Count; n++)
                        {
                            if (lsCourseProject[n].ProjectID != null)
                            {
                                if (strWhere == "")
                                {
                                    strWhere += "ID=" + lsCourseProject[n].ProjectID;
                                }
                                else
                                {
                                    strWhere += "or ID=" + lsCourseProject[n].ProjectID;
                                }
                            }
                        }
                    }

                    List<LabMS.Model.Project> ls = new List<LabMS.Model.Project>();
                    if (strWhere != "")
                    {
                        LabMS.BLL.Project Project = new LabMS.BLL.Project();
                        ls = Project.GetModelList(strWhere);

                    }

                    if (ls.Count != 0)
                    {
                        for (int i = 0; i < ls.Count-1; i++)
                        {
                            ProjectList += ls[i].Project_Name;
                            ProjectList += "<br/>";
                        }
                        ProjectList += ls[ls.Count - 1].Project_Name;
                    }
                }
            }

            return ProjectList;
        }
Esempio n. 3
0
        protected void DataBinds(int CourseID)
        {
            LabMS.BLL.Course Course = new LabMS.BLL.Course();
            LabMS.Model.Course model = new LabMS.Model.Course();
            model = Course.GetModel(CourseID);
            lb_CourseCode.Text = model.Course_Code;
            lb_CourseName.Text = model.Course_Name;
            lb_CourseType.Text = model.CourseType;
            lb_EnglishName.Text = model.EnglishName;
            #region ����Ŀ�б�
            LabMS.BLL.CourseAndProject courseproject = new LabMS.BLL.CourseAndProject();
            List<LabMS.Model.CourseAndProject> courseprojectlist = new List<LabMS.Model.CourseAndProject>();

            string strWhere1 = " CourseID=" + CourseID;
            courseprojectlist = courseproject.GetModelList(strWhere1);

            string strWhere2 = "";
            foreach (LabMS.Model.CourseAndProject cp in courseprojectlist)
            {
                if (cp.ProjectID != null)
                {
                    if (strWhere2.Equals(""))
                    {
                        strWhere2 += " Project.ID=" + cp.ProjectID;
                    }
                    else
                    {
                        strWhere2 += " or Project.ID=" + cp.ProjectID;
                    }
                }
            }

            if (strWhere2 == "")
            {
                strWhere2 = "1<>1";
            }
            ExtendBLL.ProjectAndOther project = new ExtendBLL.ProjectAndOther();
            List<ExtendModule.ProjectAndOther> projectlist = new List<ExtendModule.ProjectAndOther>();

            projectlist = project.GetModelList2(strWhere2);

            string strHTML = "<table id='studenlist' border='1' class='infoTable' style='border-collapse: collapse;'>";
            strHTML += "<thead>";
            strHTML += "<tr class='header'>";
            strHTML += "<td class='none'>";
            strHTML += "��ĿID";
            strHTML += "</td>";

            strHTML += "<td>";
            strHTML += "ʵ���ұ���";

            strHTML += "<td>";
            strHTML += "ʵ��������";
            strHTML += "</td>";

            strHTML +="<td>";
            strHTML +="��Ŀ����";
            strHTML +="</td>";

            strHTML += "<td>";
            strHTML += "��Ŀ����";
            strHTML += "</td>";

            strHTML += "<td>";
            strHTML += "����";
            strHTML += "</td>";
            strHTML += "</tr>";
            strHTML += "</thead>";
            strHTML += "<tbody>";
            tb_ProjectIDs.Value = "";
            foreach(ExtendModule.ProjectAndOther p in projectlist)
            {
                if(tb_ProjectIDs.Value == "")
                {
                    tb_ProjectIDs.Value += p.ID.ToString();
                }
                else
                {
                    tb_ProjectIDs.Value += "," + p.ID.ToString();
                }
                strHTML += "<tr>";
                strHTML += "<td>";
                strHTML += p.ID.ToString();
                strHTML += "</td>";

                strHTML += "<td>";
                strHTML += p.Lab_Code;

                strHTML += "<td>";
                strHTML += p.Lab_Name;
                strHTML += "</td>";

                strHTML +="<td>";
                strHTML += p.Project_Name;
                strHTML += "</td>";

                strHTML += "<td>";
                strHTML += p.Project_Code;
                strHTML += "</td>";

                strHTML += "<td>";
                strHTML += "<a>ɾ��</a>";
                strHTML += "</td>";
                strHTML += "</tr>";
            }
            strHTML += "</tbody>";
            strHTML += "</table>";
            tbListProject.Value += strHTML;
            tblistEmpty.Value = "0";
            #endregion
        }
Esempio n. 4
0
        //通过项目ID和课程ID获取课程项目ID
        protected int GetProCourseIDByProID(int PID,int CID)
        {
            LabMS.BLL.CourseAndProject proCou = new LabMS.BLL.CourseAndProject();
            List<LabMS.Model.CourseAndProject> proCouModel = new List<LabMS.Model.CourseAndProject>();
            int PCID=0;

            proCouModel = proCou.GetModelList("ProjectID=" + PID + " and CourseID=" + CID);
            if (proCouModel.Count != 0)
            {
                PCID = proCouModel[0].ID;
            }
            return PCID;
        }