Exemplo n.º 1
0
        private void BindGrid2()
        {
            bool isGroup = PrjPub.CurrentStudent.IsGroupLearder;
            int  tech    = PrjPub.CurrentStudent.TechnicianTypeID;

            CoursewareBLL coursewareBLL = new CoursewareBLL();
            IList <RailExam.Model.Courseware> coursewareList = coursewareBLL.GetEmployeeStudyCoursewareInfo(Convert.ToInt32(ViewState["TrainTypeID"].ToString()), PrjPub.CurrentStudent.OrgID, PrjPub.CurrentStudent.PostID, isGroup, tech, 5);

            if (coursewareList.Count > 0)
            {
                foreach (RailExam.Model.Courseware courseware in coursewareList)
                {
                    courseware.ToolTip = courseware.CoursewareName;
                    if (courseware.CoursewareName.Length <= 13)
                    {
                        courseware.CoursewareName = courseware.CoursewareName;
                    }
                    else
                    {
                        courseware.CoursewareName = courseware.CoursewareName.Substring(0, 13) + "...";
                    }
                }
            }

            gvCourse.DataSource = coursewareList;
            gvCourse.DataBind();
        }
Exemplo n.º 2
0
        private void BindGrid2()
        {
            CoursewareBLL coursewareBLL = new CoursewareBLL();
            IList <RailExam.Model.Courseware> coursewareList = new List <RailExam.Model.Courseware>();

            if (!string.IsNullOrEmpty(Request.QueryString.Get("id")))
            {
                TrainTypeBLL trainTypeBLL = new TrainTypeBLL();
                TrainType    trainType    = trainTypeBLL.GetTrainTypeInfo(Convert.ToInt32(ViewState["TrainAimID"].ToString()));
                coursewareList = coursewareBLL.GetCoursewaresByTrainTypeIDPath(trainType.IDPath, 1);
            }
            else
            {
                coursewareList = coursewareBLL.GetCoursewaresByCoursewareTypeOnline(PrjPub.CurrentLoginUser.StationOrgID,
                                                                                    Convert.ToInt32(ViewState["TrainAimID"].ToString()), "%", true,
                                                                                    5);
            }

            if (coursewareList.Count > 0)
            {
                foreach (RailExam.Model.Courseware courseware in coursewareList)
                {
                    if (courseware.CoursewareName.Length <= 15)
                    {
                        courseware.CoursewareName = "<a onclick=EditCourseware(" + courseware.CoursewareID + ") href=# title=" + courseware.CoursewareName + " > " + courseware.CoursewareName + " </a>";
                    }
                    else
                    {
                        courseware.CoursewareName = "<a onclick=EditCourseware(" + courseware.CoursewareID + ") href=# title=" + courseware.CoursewareName + " > " + courseware.CoursewareName.Substring(0, 15) + "..." + " </a>";
                    }
                }
                gvCourse.DataSource = coursewareList;
                gvCourse.DataBind();
            }
        }
Exemplo n.º 3
0
        private void BindGridByCoursewareTypeID()
        {
            int typeID = Convert.ToInt32(ViewState["CoursewareTypeID"].ToString());
            int postID = Convert.ToInt32(ViewState["PostID"].ToString());
            int orgID  = Convert.ToInt32(ViewState["OrgID"].ToString());
            int techID = Convert.ToInt32(ViewState["Tech"].ToString());
            int leader = Convert.ToInt32(ViewState["Leader"].ToString());

            CoursewareBLL coursewareBLL = new CoursewareBLL();
            IList <RailExam.Model.Courseware> coursewareList = coursewareBLL.GetStudyCoursewareInfoByTypeID(typeID, orgID, postID, leader, techID, 0);


            if (coursewareList.Count > 0)
            {
                foreach (RailExam.Model.Courseware courseware in coursewareList)
                {
                    //if (courseware.CoursewareName.Length <= 15)
                    //{
                    courseware.CoursewareName = "<a onclick=OpenIndex('" + courseware.CoursewareID + "')  href=#  title=" + courseware.CoursewareName + ">" + courseware.CoursewareName + "</a>";
                    //}
                    //else
                    //{
                    //    courseware.CoursewareName = "<a onclick=OpenIndex('" + courseware.Url + "')  href=#  title=" + courseware.CoursewareName + ">" + courseware.CoursewareName.Substring(0, 15) + "...</a>";
                    //}
                }
                gvCourse.DataSource = coursewareList;
                gvCourse.DataBind();
            }
        }
Exemplo n.º 4
0
        private void BindGrid()
        {
            string strIDPath = Request.QueryString["id"];

            CoursewareBLL coursewareBLL = new CoursewareBLL();
            IList <RailExam.Model.Courseware> coursewares = new List <RailExam.Model.Courseware>();

            if (Request.QueryString.Get("type") == "Courseware")
            {
                coursewares = coursewareBLL.GetCoursewaresByCoursewareTypeID(Convert.ToInt32(strIDPath), 1);
            }
            else
            {
                coursewares = coursewareBLL.GetCoursewaresByTrainTypeID(Convert.ToInt32(strIDPath), 1);
            }

            foreach (RailExam.Model.Courseware courseware in coursewares)
            {
                //if (courseware.CoursewareName.Length <= 15)
                //{
                courseware.CoursewareName = "<a onclick=OpenIndex('" + courseware.CoursewareID + "')  href=#  title=" + courseware.CoursewareName + ">" + courseware.CoursewareName + "</a>";
                //}
                //else
                //{
                //    courseware.CoursewareName = "<a onclick=OpenIndex('" + courseware.Url + "')  href=#  title=" + courseware.CoursewareName + ">" + courseware.CoursewareName.Substring(0, 15) + "...</a>";
                //}
            }
            Grid1.DataSource = coursewares;
            Grid1.DataBind();
        }
        private void BindGridCourseByCoursewareTypeID()
        {
            int postID;

            if (!Int32.TryParse(ViewState["PostID"].ToString(), out postID))
            {
                return;
            }

            int typeID = Convert.ToInt32(ViewState["KnowledgeID"]);
            int orgID  = PrjPub.CurrentStudent.OrgID;
            int techID = PrjPub.CurrentStudent.TechnicianTypeID;
            int leader = PrjPub.CurrentStudent.IsGroupLearder ? 1 : 0;

            CoursewareBLL coursewareBLL = new CoursewareBLL();
            IList <RailExam.Model.Courseware> coursewareList = coursewareBLL.GetStudyCoursewareInfoByTypeID(typeID, orgID, postID, leader, techID, 0);

            if (coursewareList.Count > 0)
            {
                foreach (RailExam.Model.Courseware courseware in coursewareList)
                {
                    courseware.CoursewareName = "<a onclick=OpenCourse('" + courseware.CoursewareID + "')  href=#  title=" + courseware.CoursewareName + ">" + courseware.CoursewareName + "</a>";
                }
                Grid2.DataSource = coursewareList;
                Grid2.DataBind();
            }
        }
Exemplo n.º 6
0
        private void BindCoursewareGrid()
        {
            CoursewareBLL coursewareBLL = new CoursewareBLL();
            IList <RailExam.Model.Courseware> coursewares = new List <RailExam.Model.Courseware>();

            string strKnowledgeID = Request.QueryString.Get("id");
            IList <RailExam.Model.Book> bookList = new List <RailExam.Model.Book>();

            if (strKnowledgeID != null & strKnowledgeID != "" & strKnowledgeID != "0")
            {
                coursewares = coursewareBLL.GetCoursewaresByCoursewareTypeID(Convert.ToInt32(strKnowledgeID), 1);
            }

            string strtypeID = Request.QueryString.Get("id1");

            if (strtypeID != null & strtypeID != "" && strtypeID != "0")
            {
                coursewares = coursewareBLL.GetCoursewaresByTrainTypeID(Convert.ToInt32(strtypeID), 1);
            }

            foreach (RailExam.Model.Courseware courseware in coursewares)
            {
                courseware.CoursewareName = "<a onclick=OpenCourse('" + courseware.CoursewareID + "')  href=#  title=" + courseware.CoursewareName + ">" + courseware.CoursewareName + "</a>";
            }
            Grid2.DataSource = coursewares;
            Grid2.DataBind();
        }
        private void BindCourse()
        {
            bool isGroup = PrjPub.CurrentStudent.IsGroupLearder;
            int  tech    = PrjPub.CurrentStudent.TechnicianTypeID;
            int  orgID   = PrjPub.CurrentStudent.OrgID;
            int  postID  = PrjPub.CurrentStudent.PostID;

            string        strIDPath = Request.QueryString.Get("Courseware");
            CoursewareBLL objBll    = new CoursewareBLL();
            IList <RailExam.Model.Courseware> objCourseware =
                objBll.GetCoursewaresByCoursewareTypeOnline(orgID, postID, strIDPath, isGroup, tech);

            if (objCourseware.Count > 0)
            {
                foreach (RailExam.Model.Courseware courseware in objCourseware)
                {
                    if (courseware.CoursewareName.Length <= 15)
                    {
                        courseware.CoursewareName = courseware.CoursewareName;
                    }
                    else
                    {
                        courseware.CoursewareName = courseware.CoursewareName.Substring(0, 15) + "...";
                    }
                }
            }

            gvCourse.DataSource = objCourseware;
            gvCourse.DataBind();

            gvBook.Visible   = false;
            gvCourse.Visible = true;
        }
Exemplo n.º 8
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                string strCoursewareID = Request.QueryString.Get("id");

                CoursewareBLL             objBll = new CoursewareBLL();
                RailExam.Model.Courseware obj    = objBll.GetCourseware(Convert.ToInt32(strCoursewareID));

                hfUrl.Value = obj.Url;
            }
        }
Exemplo n.º 9
0
        private void BindGrid2()
        {
            CoursewareBLL coursewareBLL = new CoursewareBLL();
            IList <RailExam.Model.Courseware> coursewareList = coursewareBLL.GetCoursewareInfoByDate(6);

            if (coursewareList.Count > 0)
            {
                foreach (RailExam.Model.Courseware courseware in coursewareList)
                {
                    courseware.CoursewareName = courseware.CoursewareName + "(" + courseware.ProvideOrgName + "," + courseware.Authors + "," + courseware.PublishDate.ToString("yyyy-MM-dd") + ")";
                }
            }
            gvCourse.DataSource = coursewareList;
            gvCourse.DataBind();
        }
Exemplo n.º 10
0
        protected void btnQuery_Click(object sender, EventArgs e)
        {
            // int nID = int.Parse(Request.QueryString["id"]);


            string strKnowledgeID = Request.QueryString.Get("id");

            string[] str1 = strKnowledgeID.Split(new char[] { '/' });

            int nID = int.Parse(str1[str1.LongLength - 1].ToString());

            OrganizationBLL orgBll = new OrganizationBLL();
            int             orgID  = orgBll.GetStationOrgID(PrjPub.CurrentLoginUser.OrgID);

            CoursewareBLL coursewareBLL = new CoursewareBLL();
            IList <RailExam.Model.Courseware> coursewares = new List <RailExam.Model.Courseware>();

            if (Request.QueryString.Get("type") == "Courseware")
            {
                coursewares = coursewareBLL.GetCoursewares(nID, -1, txtCoursewareName.Text, txtKeyWords.Text, txtAuthors.Text, orgID);
            }
            else if (Request.QueryString.Get("type") == "TrainType")
            {
                coursewares = coursewareBLL.GetCoursewares(-1, nID, txtCoursewareName.Text, txtKeyWords.Text, txtAuthors.Text, orgID);
            }
            else
            {
                coursewares = coursewareBLL.GetCoursewaresByPostID(nID, txtCoursewareName.Text, txtKeyWords.Text, txtAuthors.Text, orgID);
            }

            if (coursewares != null)
            {
                foreach (RailExam.Model.Courseware obj in coursewares)
                {
                    if (obj.CoursewareName.Length <= 20)
                    {
                        obj.CoursewareName = "<a onclick=OpenIndex('" + obj.CoursewareID + "') href=# title=" + obj.CoursewareName + " > " + obj.CoursewareName + " </a>";
                    }
                    else
                    {
                        obj.CoursewareName = "<a onclick=OpenIndex('" + obj.CoursewareID + "') href=# title=" + obj.CoursewareName + " > " + obj.CoursewareName.Substring(0, 20) + "...</a>";
                    }
                }

                Grid1.DataSource = coursewares;
                Grid1.DataBind();
            }
        }
Exemplo n.º 11
0
        private void DeleteData(int nCoursewareID)
        {
            CoursewareBLL coursewareBLL = new CoursewareBLL();

            coursewareBLL.DeleteCourseware(nCoursewareID);

            string strPath = Server.MapPath("/RailExamBao/Online/Courseware/" + nCoursewareID + "/");

            if (Directory.Exists(strPath))
            {
                string[] filenames = Directory.GetFiles(strPath);
                for (int i = 0; i < filenames.Length; i++)
                {
                    File.Delete(filenames[i]);
                }
            }
        }
Exemplo n.º 12
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                string strCoursewareID = Request.QueryString.Get("id");

                CoursewareBLL             objBll = new CoursewareBLL();
                RailExam.Model.Courseware obj    = objBll.GetCourseware(Convert.ToInt32(strCoursewareID));

                string   strFileName = obj.Url.Replace("/RailExamBao/Online/Courseware/" + obj.CoursewareID + "/", "");
                FileInfo f           = new FileInfo(strFileName);

                //下载文件的路径
                string path = Server.MapPath(obj.Url);

                //下载文件的名称
                string filename = f.Name;

                System.IO.FileInfo toDownload = new System.IO.FileInfo(path);

                if (toDownload.Exists == true)
                {
                    const long ChunkSize = 10000;
                    byte[]     buffer    = new byte[ChunkSize];

                    Response.Clear();
                    System.IO.FileStream iStream = System.IO.File.OpenRead(path);
                    long dataLengthToRead        = iStream.Length;
                    Response.ContentType = "application/octet-stream";
                    Response.AddHeader("Content-Disposition", "attachment; filename=new_" + HttpUtility.UrlEncode(toDownload.Name));
                    while (dataLengthToRead > 0 && Response.IsClientConnected)
                    {
                        int lengthRead = iStream.Read(buffer, 0, Convert.ToInt32(ChunkSize));
                        Response.OutputStream.Write(buffer, 0, lengthRead);
                        Response.Flush();
                        dataLengthToRead = dataLengthToRead - lengthRead;
                    }
                    iStream.Close();
                    Response.Close();
                }
            }
        }
Exemplo n.º 13
0
        private void BindGrid()
        {
            string strIDPath = Request.QueryString["id"];

            CoursewareBLL coursewareBLL = new CoursewareBLL();
            IList <RailExam.Model.Courseware> coursewares = new List <RailExam.Model.Courseware>();

            OrganizationBLL orgBll = new OrganizationBLL();
            int             orgID  = orgBll.GetStationOrgID(PrjPub.CurrentLoginUser.OrgID);

            if (Request.QueryString.Get("type") == "Courseware")
            {
                coursewares = coursewareBLL.GetCoursewaresByCoursewareTypeID(Convert.ToInt32(strIDPath), orgID);
            }
            else if (Request.QueryString.Get("type") == "TrainType")
            {
                coursewares = coursewareBLL.GetCoursewaresByTrainTypeID(Convert.ToInt32(strIDPath), orgID);
            }
            else
            {
                coursewares = coursewareBLL.GetCoursewaresByPostID(Convert.ToInt32(strIDPath), orgID);
            }

            if (coursewares != null)
            {
                foreach (RailExam.Model.Courseware obj in coursewares)
                {
                    if (obj.CoursewareName.Length <= 20)
                    {
                        obj.CoursewareName = "<a onclick=OpenIndex('" + obj.CoursewareID + "') href=# title=" + obj.CoursewareName + " > " + obj.CoursewareName + " </a>";
                    }
                    else
                    {
                        obj.CoursewareName = "<a onclick=OpenIndex('" + obj.CoursewareID + "') href=# title=" + obj.CoursewareName + " > " + obj.CoursewareName.Substring(0, 20) + "...</a>";
                    }
                }

                Grid1.DataSource = coursewares;
                Grid1.DataBind();
            }
        }
Exemplo n.º 14
0
        private void BindGridCourseByCoursewareTypeID()
        {
            int typeID = Convert.ToInt32(ViewState["KnowledgeID"].ToString());
            int postID = Convert.ToInt32(ViewState["PostID"].ToString());
            int orgID  = Convert.ToInt32(ViewState["OrgID"].ToString());
            int techID = Convert.ToInt32(ViewState["Tech"].ToString());
            int leader = Convert.ToInt32(ViewState["Leader"].ToString());

            CoursewareBLL coursewareBLL = new CoursewareBLL();
            IList <RailExam.Model.Courseware> coursewareList = coursewareBLL.GetStudyCoursewareInfoByTypeID(typeID, orgID, postID, leader, techID, 0);

            if (coursewareList.Count > 0)
            {
                foreach (RailExam.Model.Courseware courseware in coursewareList)
                {
                    courseware.CoursewareName = "<a onclick=OpenCourse('" + courseware.CoursewareID + "')  href=#  title=" + courseware.CoursewareName + ">" + courseware.CoursewareName + "</a>";
                }
                Grid2.DataSource = coursewareList;
                Grid2.DataBind();
            }
        }
Exemplo n.º 15
0
        protected void btnOK_Click(object sender, EventArgs e)
        {
            if (Request.QueryString.Get("TrainTypeID") != null)
            {
                int bookID      = Convert.ToInt32(Request.QueryString.Get("CoursewareID"));
                int trainTypeID = Convert.ToInt32(Request.QueryString.Get("TrainTypeID"));
                CoursewareTrainTypeBLL objBll = new CoursewareTrainTypeBLL();
                CoursewareTrainType    obj    = objBll.GetCoursewareTrainType(bookID, trainTypeID);
                int order = Convert.ToInt32(txtOrderIndex.Text);
                int max   = Convert.ToInt32(Request.QueryString.Get("MaxOrder"));
                if (order > max)
                {
                    obj.OrderIndex = max;
                }
                else
                {
                    obj.OrderIndex = order;
                }
                objBll.UpdateCoursewareTrainType(obj);
            }
            else
            {
                CoursewareBLL             objBll = new CoursewareBLL();
                RailExam.Model.Courseware obj    = objBll.GetCourseware(Convert.ToInt32(Request.QueryString.Get("CoursewareID")));
                int order = Convert.ToInt32(txtOrderIndex.Text);
                int max   = Convert.ToInt32(Request.QueryString.Get("MaxOrder"));
                if (order > max)
                {
                    obj.OrderIndex = max;
                }
                else
                {
                    obj.OrderIndex = order;
                }
                objBll.UpdateCourseware(obj);
            }

            Response.Write("<script>top.returnValue='true';window.close();</script>");
        }
Exemplo n.º 16
0
        private void BindGridCourseByCoursewareTypeID()
        {
            int typeID = Convert.ToInt32(ViewState["KnowledgeID"]);

            CoursewareBLL coursewareBLL = new CoursewareBLL();
            IList <RailExam.Model.Courseware> coursewareList = coursewareBLL.GetCoursewaresByCoursewareTypeID(typeID, 200);

            if (ViewState["PostID"] != null && ViewState["PostID"].ToString() != "undefined")
            {
                int postID = Int32.Parse(ViewState["PostID"].ToString());
                coursewareList = coursewareBLL.GetStudyCoursewareInfoByTypeID(typeID, 200, postID, 0, 1, 0);
            }

            if (coursewareList.Count > 0)
            {
                foreach (RailExam.Model.Courseware courseware in coursewareList)
                {
                    courseware.CoursewareName = "<a onclick=OpenCourse('" + courseware.CoursewareID + "')  href=#  title=" + courseware.CoursewareName + ">" + courseware.CoursewareName + "</a>";
                }
                Grid2.DataSource = coursewareList;
                Grid2.DataBind();
            }
        }
Exemplo n.º 17
0
        private void DeleteData(int nCoursewareID)
        {
            CoursewareBLL coursewareBLL = new CoursewareBLL();

            coursewareBLL.DeleteCourseware(nCoursewareID);
        }
Exemplo n.º 18
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (PrjPub.CurrentLoginUser == null)
                {
                    Response.Redirect("/RailExamBao/Common/Error.aspx?error=Session过期请重新登录本系统!");
                    return;
                }

                if (PrjPub.HasEditRight("课件管理") && PrjPub.IsServerCenter)                //&& PrjPub.CurrentLoginUser.SuitRange == 1
                {
                    HfUpdateRight.Value = "True";
                }
                else
                {
                    HfUpdateRight.Value = "False";
                }
                if (PrjPub.HasDeleteRight("课件管理") && PrjPub.IsServerCenter)                //&& PrjPub.CurrentLoginUser.SuitRange == 1
                {
                    HfDeleteRight.Value = "True";
                }
                else
                {
                    HfDeleteRight.Value = "False";
                }

                OrganizationBLL orgBll = new OrganizationBLL();
                int             orgID  = orgBll.GetStationOrgID(PrjPub.CurrentLoginUser.OrgID);
                HfOrgId.Value = orgID.ToString();

                BindGrid();
            }
            else
            {
                string strDeleteID = Request.Form.Get("DeleteID");
                if (!string.IsNullOrEmpty(strDeleteID))
                {
                    DeleteData(int.Parse(strDeleteID));
                    BindGrid();
                }

                if (Request.Form.Get("Refresh") == "true")
                {
                    BindGrid();
                }
            }

            string strUpID = Request.Form.Get("UpID");

            if (strUpID != null && strUpID != "")
            {
                if (Request.QueryString.Get("type") == "Courseware")
                {
                    CoursewareBLL             objBll = new CoursewareBLL();
                    RailExam.Model.Courseware obj    = objBll.GetCourseware(Convert.ToInt32(strUpID));
                    obj.OrderIndex = obj.OrderIndex - 1;
                    objBll.UpdateCourseware(obj);
                }

                if (Request.QueryString.Get("type") == "TrainType")
                {
                    int trainTypeID = Convert.ToInt32(Request.QueryString.Get("id"));
                    CoursewareTrainTypeBLL objTrainTypeBll = new CoursewareTrainTypeBLL();
                    CoursewareTrainType    objTrainType    =
                        objTrainTypeBll.GetCoursewareTrainType(Convert.ToInt32(strUpID), trainTypeID);
                    objTrainType.OrderIndex = objTrainType.OrderIndex - 1;
                    objTrainTypeBll.UpdateCoursewareTrainType(objTrainType);
                }
                BindGrid();
            }

            string strDownID = Request.Form.Get("DownID");

            if (strDownID != null && strDownID != "")
            {
                if (Request.QueryString.Get("type") == "Courseware")
                {
                    CoursewareBLL             objBll = new CoursewareBLL();
                    RailExam.Model.Courseware obj    = objBll.GetCourseware(Convert.ToInt32(strDownID));
                    obj.OrderIndex = obj.OrderIndex + 1;
                    objBll.UpdateCourseware(obj);
                }

                if (Request.QueryString.Get("type") == "TrainType")
                {
                    int trainTypeID = Convert.ToInt32(Request.QueryString.Get("id"));
                    CoursewareTrainTypeBLL objTrainTypeBll = new CoursewareTrainTypeBLL();
                    CoursewareTrainType    objTrainType    =
                        objTrainTypeBll.GetCoursewareTrainType(Convert.ToInt32(strDownID), trainTypeID);
                    objTrainType.OrderIndex = objTrainType.OrderIndex + 1;
                    objTrainTypeBll.UpdateCoursewareTrainType(objTrainType);
                }
                BindGrid();
            }
        }
Exemplo n.º 19
0
        private void BindGrid()
        {
            string strIDPath = Request.QueryString["id"];

            CoursewareBLL coursewareBLL = new CoursewareBLL();
            IList <RailExam.Model.Courseware> coursewares = new List <RailExam.Model.Courseware>();

            OrganizationBLL orgBll = new OrganizationBLL();
            int             orgID  = orgBll.GetStationOrgID(PrjPub.CurrentLoginUser.OrgID);

            if (Request.QueryString.Get("type") == "Courseware")
            {
                coursewares = coursewareBLL.GetCoursewaresByCoursewareTypeID(Convert.ToInt32(strIDPath), orgID);
            }
            else
            {
                coursewares = coursewareBLL.GetCoursewaresByTrainTypeID(Convert.ToInt32(strIDPath), orgID);
            }

            OracleAccess oa           = new OracleAccess();
            int          railSystemid = PrjPub.RailSystemId();

            if (railSystemid != 0)
            {
                IList <RailExam.Model.Courseware> coursewaresVia = new List <RailExam.Model.Courseware>();
                string sql = String.Format(
                    @"select courseware_id from courseware_RANGE_ORG t 
                        where 
                            org_Id in (select org_id from org where rail_System_Id={0} and level_num=2) ",
                    railSystemid
                    );

                DataSet dscoursewareIDs = oa.RunSqlDataSet(sql);
                if (dscoursewareIDs != null && dscoursewareIDs.Tables.Count > 0)
                {
                    foreach (RailExam.Model.Courseware courseware in coursewares)
                    {
                        DataRow[] drs = dscoursewareIDs.Tables[0].Select("courseware_id=" + courseware.CoursewareID);
                        if (drs.Length > 0)
                        {
                            coursewaresVia.Add(courseware);
                        }
                    }
                    coursewares.Clear();
                    coursewares = coursewaresVia;
                }
            }

            if (coursewares != null)
            {
                foreach (RailExam.Model.Courseware obj in coursewares)
                {
                    if (obj.CoursewareName.Length <= 20)
                    {
                        obj.CoursewareName = "<a onclick=OpenIndex('" + obj.CoursewareID + "') href=# title=" + obj.CoursewareName + " > " + obj.CoursewareName + " </a>";
                    }
                    else
                    {
                        obj.CoursewareName = "<a onclick=OpenIndex('" + obj.CoursewareID + "') href=# title=" + obj.CoursewareName + " > " + obj.CoursewareName.Substring(0, 20) + "...</a>";
                    }
                }

                Grid1.DataSource = coursewares;
                Grid1.DataBind();
            }
        }
Exemplo n.º 20
0
        private void BindWareTree()
        {
            tvWare.Nodes.Clear();
            CoursewareTypeBLL      coursewareTypeBll  = new CoursewareTypeBLL();
            IList <CoursewareType> coursewareTypeList = coursewareTypeBll.GetCoursewareTypes(0, 0, "", 0, 0,
                                                                                             "", "", "", 0, 40,
                                                                                             "LevelNum,OrderIndex Asc");
            ArrayList objList = GetCourseWareList();

            if (coursewareTypeList.Count > 0)
            {
                TreeViewNode tvn = null;

                foreach (CoursewareType coursewareType in coursewareTypeList)
                {
                    tvn         = new TreeViewNode();
                    tvn.ID      = coursewareType.CoursewareTypeId.ToString();
                    tvn.Value   = coursewareType.CoursewareTypeId.ToString();
                    tvn.Text    = coursewareType.CoursewareTypeName;
                    tvn.ToolTip = coursewareType.CoursewareTypeName;

                    if (coursewareType.ParentId == 0)
                    {
                        tvWare.Nodes.Add(tvn);
                    }
                    else
                    {
                        try
                        {
                            tvWare.FindNodeById(coursewareType.ParentId.ToString()).Nodes.Add(tvn);
                        }
                        catch
                        {
                            tvWare.Nodes.Clear();
                            Response.Write("数据错误!");
                            return;
                        }
                    }
                }
            }
            tvWare.DataBind();

            foreach (TreeViewNode node1 in tvWare.Nodes)
            {
                if (node1.Nodes.Count > 0)
                {
                    foreach (TreeViewNode node in node1.Nodes)
                    {
                        CoursewareBLL coursewareBll = new CoursewareBLL();
                        IList <RailExam.Model.Courseware> coursewareList = null;
                        //coursewareBll.GetCoursewares(Convert.ToString(node.Value), -1);

                        if (coursewareList.Count > 0)
                        {
                            foreach (RailExam.Model.Courseware courseware in coursewareList)
                            {
                                TreeViewNode tvn = new TreeViewNode();
                                tvn.ID           = courseware.CoursewareTypeID.ToString();
                                tvn.Value        = courseware.CoursewareID.ToString();
                                tvn.Text         = courseware.CoursewareName;
                                tvn.ToolTip      = courseware.CoursewareName;
                                tvn.ShowCheckBox = true;

                                if (objList.Count > 0)
                                {
                                    if (objList.IndexOf(courseware.CoursewareID.ToString()) != -1)
                                    {
                                        tvn.Checked = true;
                                    }
                                }

                                tvWare.FindNodeById(node.ID.ToString()).Nodes.Add(tvn);
                            }
                        }
                    }
                }
            }
            tvWare.DataBind();

            tvWare.ExpandAll();
        }
Exemplo n.º 21
0
        private void FillPage(int nCoursewareID)
        {
            CoursewareBLL coursewareBLL = new CoursewareBLL();

            ArrayList trainTypeIDAL = new ArrayList();
            ArrayList orgIDAL       = new ArrayList();
            ArrayList postIDAL      = new ArrayList();

            RailExam.Model.Courseware courseware = coursewareBLL.GetCourseware(nCoursewareID);

            if (courseware != null)
            {
                txtCoursewareName.Text     = courseware.CoursewareName;
                txtCoursewareTypeName.Text = courseware.CoursewareTypeNames;
                hfCoursewareTypeID.Value   = courseware.CoursewareTypeID.ToString();

                txtTrainTypeName.Text = courseware.TrainTypeNames;

                txtProvideOrgName.Text = courseware.ProvideOrgName;
                hfProvideOrgID.Value   = courseware.ProvideOrg.ToString();

                datePublishDate.DateValue = courseware.PublishDate.ToString("yyyy-MM-dd");
                txtAuthors.Text           = courseware.Authors;
                txtRevisers.Text          = courseware.Revisers;
                txtKeyWord.Text           = courseware.KeyWord;
                txtDescription.Text       = courseware.Description;
                string strUrl = string.Empty;
                strUrl                   = "ViewCourseware.aspx?id=" + courseware.CoursewareID;
                hlUrl.Text               = strUrl;
                hlUrl.NavigateUrl        = strUrl;
                ddlIsGroup.SelectedValue = courseware.IsGroupLearder.ToString();
                ddlTech.SelectedValue    = courseware.TechnicianTypeID.ToString();
                hfOrderIndex.Value       = courseware.OrderIndex.ToString();

                txtMemo.Text = courseware.Memo;

                trainTypeIDAL = courseware.TrainTypeIDAL;
                orgIDAL       = courseware.OrgIDAL;
                postIDAL      = courseware.PostIDAL;
            }
            //tvOrg.Nodes.Clear();
            //tvPost.Nodes.Clear();

            BindOrganizationTree(orgIDAL);
            BindPostTree(postIDAL);

            string strUpdate = PrjPub.HasEditRight("课件管理").ToString();
            string strOrgID  = PrjPub.CurrentLoginUser.OrgID.ToString();

            if (courseware != null)
            {
                //if (strUpdate == "True" && strOrgID == courseware.ProvideOrg.ToString())
                if (strUpdate == "True" && PrjPub.CurrentLoginUser.SuitRange == 1)
                {
                    SaveButton.Visible   = true;
                    CancelButton.Visible = false;
                }
                else
                {
                    SaveButton.Visible   = false;
                    CancelButton.Visible = true;
                }
            }

            string strMode = Request.QueryString.Get("mode");

            if (strMode == "ReadOnly")
            {
                SaveButton.Visible   = false;
                CancelButton.Visible = true;

                //隐藏图片

                txtCoursewareName.ReadOnly = true;
                txtAuthors.ReadOnly        = true;
                txtRevisers.ReadOnly       = true;
                txtKeyWord.ReadOnly        = true;
                txtDescription.ReadOnly    = true;
                txtMemo.ReadOnly           = true;
            }
            else
            {
                SaveButton.Visible   = true;
                CancelButton.Visible = false;

                for (int i = 0; i < trainTypeIDAL.Count; i++)
                {
                    if (i == 0)
                    {
                        hfTrainTypeID.Value = trainTypeIDAL[0].ToString();
                    }
                    else
                    {
                        hfTrainTypeID.Value += "," + trainTypeIDAL[i].ToString();
                    }
                }
            }

            ViewState["AddFlag"] = 0;
        }
Exemplo n.º 22
0
        protected void SaveButton_Click(object sender, EventArgs e)
        {
            string strFullName = string.Empty;            //, strUrl, strContentType, strSize

            CoursewareBLL coursewareBLL = new CoursewareBLL();


            if (ViewState["AddFlag"].ToString() == "1")      //新增
            {
                strFullName = File1.FileName;                //直接取得文件名



                if (!string.IsNullOrEmpty(strFullName))
                {
                    FileInfo fi = new FileInfo(File1.FileName);

                    //判断只能上传.flv与.swf格式

                    //if (fi.Extension.ToLower() != ".flv" && fi.Extension.ToLower() != ".swf")
                    //{
                    //    SessionSet.PageMessage = "文件格式应为FLV或SWF视频! 现在格式为:" + fi.Extension.ToLower();
                    //    return;
                    //}

                    if (fi.Name.Replace(fi.Extension, "") != txtCoursewareName.Text)
                    {
                        SessionSet.PageMessage = "上传文件名与课件名不一致,请确认上传文件名!";
                        return;
                    }
                }
                RailExam.Model.Courseware courseware = new RailExam.Model.Courseware();

                courseware.CoursewareName   = txtCoursewareName.Text;
                courseware.CoursewareTypeID = int.Parse(hfCoursewareTypeID.Value);
                courseware.ProvideOrg       = SessionSet.OrganizationID;
                courseware.PublishDate      = DateTime.Parse(datePublishDate.DateValue.ToString());
                courseware.Authors          = txtAuthors.Text;
                courseware.Revisers         = txtRevisers.Text;
                courseware.KeyWord          = txtKeyWord.Text;
                courseware.Description      = txtDescription.Text;
                courseware.Memo             = txtMemo.Text;
                courseware.IsGroupLearder   = Convert.ToInt32(ddlIsGroup.SelectedValue);
                courseware.TechnicianTypeID = Convert.ToInt32(ddlTech.SelectedValue);

                ArrayList al = new ArrayList();
                courseware.OrgIDAL = GetOrg(tvOrg.Nodes, al);

                ArrayList al1 = new ArrayList();

                foreach (TreeViewNode tn in tvPost.Nodes)
                {
                    if (tn.Checked)
                    {
                        al1.Add(tn.ID);
                    }

                    if (tn.Nodes.Count > 0)
                    {
                        foreach (TreeViewNode tns in tn.Nodes)
                        {
                            if (tns.Checked)
                            {
                                al1.Add(tns.ID);
                            }

                            if (tns.Nodes.Count > 0)
                            {
                                foreach (TreeViewNode tnss in tns.Nodes)
                                {
                                    if (tnss.Checked)
                                    {
                                        al1.Add(tnss.ID);
                                    }
                                }
                            }
                        }
                    }
                }
                courseware.PostIDAL = al1;

                ArrayList trainTypeIDList = new ArrayList();
                string[]  strType         = hfTrainTypeID.Value.Split(',');
                for (int i = 0; i < strType.Length; i++)
                {
                    if (!string.IsNullOrEmpty(strType[i]))
                    {
                        trainTypeIDList.Add(strType[i]);
                    }
                }
                courseware.TrainTypeIDAL = trainTypeIDList;

                int nCoursewareID = coursewareBLL.AddCourseware(courseware);

                if (!string.IsNullOrEmpty(strFullName))
                {
                    //strUrl = File1.PostedFile.FileName;//先取得全部的上传文件路径个名字,然后再利用SubString方法来得到用户名,现在看来是没有必要了


                    //strContentType = File1.PostedFile.ContentType;//获取文件MIME内容类型
                    //strFileType = strFullName.Substring(strFullName.LastIndexOf(".") + 1);//获取文件名字 . 后面的字符作为文件类型


                    //strSize = File1.PostedFile.ContentLength.ToString();


                    Directory.CreateDirectory(Server.MapPath("../Online/Courseware/" + nCoursewareID));
                    File1.SaveAs(Server.MapPath("../Online/Courseware/" + nCoursewareID + "/") + strFullName);                    //将文件保存在跟目录的UP文件夹下

                    courseware.CoursewareID = nCoursewareID;
                    courseware.Url          = "/RailExamBao/Online/Courseware/" + nCoursewareID + "/" + strFullName;

                    coursewareBLL.UpdateCourseware(courseware);
                }
                Response.Write("<script>window.opener.form1.Refresh.value='true';window.opener.form1.submit();window.close();</script>");
            }
            else                //修改
            {
                string strCoursewareID = Request.QueryString.Get("id");

                RailExam.Model.Courseware courseware = coursewareBLL.GetCourseware(Convert.ToInt32(strCoursewareID));
                courseware.CoursewareID     = int.Parse(strCoursewareID);
                courseware.CoursewareName   = txtCoursewareName.Text;
                courseware.CoursewareTypeID = int.Parse(hfCoursewareTypeID.Value);
                courseware.ProvideOrg       = int.Parse(hfProvideOrgID.Value);
                courseware.PublishDate      = DateTime.Parse(datePublishDate.DateValue.ToString());
                courseware.Authors          = txtAuthors.Text;
                courseware.Revisers         = txtRevisers.Text;
                courseware.KeyWord          = txtKeyWord.Text;
                courseware.Description      = txtDescription.Text;
                courseware.IsGroupLearder   = Convert.ToInt32(ddlIsGroup.SelectedValue);
                courseware.TechnicianTypeID = Convert.ToInt32(ddlTech.SelectedValue);
                courseware.OrderIndex       = Convert.ToInt32(hfOrderIndex.Value);

                strFullName = File1.FileName;                //直接取得文件名



                //strUrl = File1.PostedFile.FileName;//先取得全部的上传文件路径个名字,然后再利用SubString方法来得到用户名,现在看来是没有必要了


                //strContentType = File1.PostedFile.ContentType;//获取文件MIME内容类型
                //strFileType = strFullName.Substring(strFullName.LastIndexOf(".") + 1);//获取文件名字 . 后面的字符作为文件类型


                //strSize = File1.PostedFile.ContentLength.ToString();

                if (!string.IsNullOrEmpty(strFullName))
                {
                    FileInfo fi = new FileInfo(File1.FileName);

                    //如果是武汉,就判断只能上传.flv与.swf格式

                    //if (fi.Extension.ToLower() != ".flv" && fi.Extension.ToLower() != ".swf")
                    //{
                    //    SessionSet.PageMessage = "文件格式应为FLV或SWF视频! 现在格式为:" + fi.Extension.ToLower();
                    //    return;
                    //}

                    if (fi.Name.Replace(fi.Extension, "") != txtCoursewareName.Text)
                    {
                        SessionSet.PageMessage = "上传文件名与课件名不一致,请确认上传文件名!";
                        return;
                    }

                    if (File.Exists(Server.MapPath(courseware.Url)))
                    {
                        //string[] filelist = Directory.GetFileSystemEntries(Server.MapPath("../Online/Courseware/" + courseware.CoursewareID + "/"));
                        //foreach (string file in filelist)
                        //{
                        //    if(!Directory.Exists(file))
                        //    {
                        //        File.Delete(file);
                        //    }
                        //}
                        File.Delete(Server.MapPath(courseware.Url));
                    }

                    if (!Directory.Exists(Server.MapPath("../Online/Courseware/" + strCoursewareID)))
                    {
                        Directory.CreateDirectory(Server.MapPath("../Online/Courseware/" + strCoursewareID));
                    }

                    File1.SaveAs(Server.MapPath("../Online/Courseware/" + strCoursewareID + "/") + strFullName);                    //将文件保存在跟目录的UP文件夹下

                    courseware.Url = "/RailExamBao/Online/Courseware/" + strCoursewareID + "/" + strFullName;
                }
                courseware.Memo = txtMemo.Text;

                ArrayList al = new ArrayList();
                courseware.OrgIDAL = GetOrg(tvOrg.Nodes, al);

                ArrayList al1 = new ArrayList();

                foreach (TreeViewNode tn in tvPost.Nodes)
                {
                    if (tn.Checked)
                    {
                        al1.Add(tn.ID);
                    }

                    if (tn.Nodes.Count > 0)
                    {
                        foreach (TreeViewNode tns in tn.Nodes)
                        {
                            if (tns.Checked)
                            {
                                al1.Add(tns.ID);
                            }

                            if (tns.Nodes.Count > 0)
                            {
                                foreach (TreeViewNode tnss in tns.Nodes)
                                {
                                    if (tnss.Checked)
                                    {
                                        al1.Add(tnss.ID);
                                    }
                                }
                            }
                        }
                    }
                }
                courseware.PostIDAL = al1;

                ArrayList trainTypeIDList = new ArrayList();
                string[]  strType         = hfTrainTypeID.Value.Split(',');
                for (int i = 0; i < strType.Length; i++)
                {
                    if (!string.IsNullOrEmpty(strType[i]))
                    {
                        trainTypeIDList.Add(strType[i]);
                    }
                }
                courseware.TrainTypeIDAL = trainTypeIDList;

                coursewareBLL.UpdateCourseware(courseware);

                Response.Write("<script>window.opener.form1.Refresh.value='true';window.opener.form1.submit();window.close();</script>");
            }
        }