Example #1
0
        public static string TeachingClassStudent_List(string fileUrl, string OCClassID)
        {
            DataTable dt = new DataTable();

            dt = NPOIHandler.ExcelToDataTable(fileUrl, "Student");

            OCClassBLL            oCClassBLL = new OCClassBLL();
            List <OCClassStudent> newList    = new List <OCClassStudent>();
            string UserNos = "";

            //int sucessnum = 0;
            //int lostNum = 0;
            //int allnum = dt.Rows.Count;
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                //int result = oCClassBLL.OCClassStudent_Import(teachingclassid, dt.Rows[i]["UserNo"].ToString());
                //if (result == 1)
                //{
                //    sucessnum++;
                //}
                //else if (result == 0)
                //{
                //    lostNum++;
                //}

                UserNos += dt.Rows[i]["UserNo"].ToString() + ",";
            }
            if (UserNos != "" && UserNos.IndexOf(',') > 0)
            {
                UserNos = UserNos.Substring(0, UserNos.Length - 1);
            }
            //return "成功导入学生:"sucessnum.ToString() + "@" + lostNum.ToString();
            return(oCClassBLL.OCClassStudent_Import(UserNos, OCClassID));
            //end检查用户
        }