public ActionResult EditListen(FormCollection form) { ExcelInfo ExcelInfo = new Models.ExcelInfo(); ExcelInfo.KPName = new List <string>(); ExcelInfo.OldKPName = new List <string>(); ExcelInfo.QuestionID = new List <string>(); ExcelInfo.KnowledgeID = new List <string>(); ExcelInfo ExcelInfo1 = new Models.ExcelInfo(); ExcelInfo1.KPName = new List <string>(); ExcelInfo1.KnowledgeID = new List <string>(); ExcelInfo1.QuestionID = new List <string>(); ExcelInfo1.OldKPName = new List <string>(); ExcelInfo.ItemName = form["ItemType_CN"]; ExcelInfo.UserName = User.Identity.Name; ExcelInfo.ItemID = form["AssessID"]; ExcelInfo1.ItemName = form["ItemType_CN"]; ExcelInfo1.UserName = User.Identity.Name; ExcelInfo1.ItemID = form["AssessID"]; Guid AssessmentID = Guid.Parse(ExcelInfo.ItemID); var UpdateUserID = (from m in db.CEDTS_AssessmentItem where m.AssessmentItemID == AssessmentID select m.UpdateUserID).FirstOrDefault(); var UpdateUserName = (from m in db.CEDTS_User where m.UserID == UpdateUserID select m.UserAccount).FirstOrDefault(); ExcelInfo.UpdateUserName = UpdateUserName; ExcelInfo1.UpdateUserName = UpdateUserName; int Count = int.Parse(form["Count"]); int QuestionCount = int.Parse(form["QuestionCount"]); string ques = form["QuestionID"]; string[] QuestionID = ques.Split(','); for (int i = 0; i < QuestionCount; i++) { string KpID = form["hidden" + (i + 1)]; string OldKPID = form["OldKPID" + (i + 1)]; string OldQuestionID = form["OldQuestionID" + (i + 1)]; string[] list = KpID.Split(','); string[] list1 = OldKPID.Split(','); int Length = 0; if (list.Length == list1.Length) { for (int s = 0; s < list.Length; s++) { if (list.Contains(list1[s])) { Length += 1; } } } if (KpID != OldKPID) { if (Length != list.Length) { ExcelInfo.KnowledgeID.Add(KpID); string name = string.Empty; string[] Kps = KpID.Split(','); for (int b = 0; b < Kps.Length; b++) { Guid Kp = Guid.Parse(Kps[b]); var Kpname = (from m in db.CEDTS_KnowledgePoints where m.KnowledgePointID == Kp select m.Title).FirstOrDefault(); if (b == Kps.Length - 1) { name += Kpname; } else { name += Kpname + ","; } } string Oldname = string.Empty; string[] OldKps = OldKPID.Split(','); for (int b = 0; b < OldKps.Length; b++) { Guid Kp = Guid.Parse(OldKps[b]); var Kpname = (from m in db.CEDTS_KnowledgePoints where m.KnowledgePointID == Kp select m.Title).FirstOrDefault(); if (b == OldKps.Length - 1) { Oldname += Kpname; } else { Oldname += Kpname + ","; } } ExcelInfo.OldKPName.Add(Oldname); ExcelInfo.KPName.Add(name); ExcelInfo.QuestionID.Add(OldQuestionID); ExcelInfo.Time = DateTime.Now; } else { } } else { string SameName = string.Empty; string[] Kps = KpID.Split(','); for (int b = 0; b < Kps.Length; b++) { Guid Kp = Guid.Parse(Kps[b]); var Kpname = (from m in db.CEDTS_KnowledgePoints where m.KnowledgePointID == Kp select m.Title).FirstOrDefault(); if (b == Kps.Length - 1) { SameName += Kpname; } else { SameName += Kpname + ","; } } string Oldname = string.Empty; string[] OldKps = OldKPID.Split(','); for (int b = 0; b < OldKps.Length; b++) { Guid Kp = Guid.Parse(OldKps[b]); var Kpname = (from m in db.CEDTS_KnowledgePoints where m.KnowledgePointID == Kp select m.Title).FirstOrDefault(); if (b == OldKps.Length - 1) { Oldname += Kpname; } else { Oldname += Kpname + ","; } } ExcelInfo1.KnowledgeID.Add(KpID); ExcelInfo1.OldKPName.Add(Oldname); ExcelInfo1.KPName.Add(SameName); ExcelInfo1.QuestionID.Add(OldQuestionID); ExcelInfo1.Time = DateTime.Now; } } try { using (TransactionScope tran = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(0, 5, 0))) { if (ExcelInfo.QuestionID.Count != 0) { if (UpdateUserID != 1) { CEDTS_AssignAssessment AssignItem = new CEDTS_AssignAssessment(); Guid ItemID = Guid.Parse(ExcelInfo.ItemID); var ItemInfo = (from m in db.CEDTS_AssessmentItem where m.AssessmentItemID == ItemID select m).FirstOrDefault(); AssignItem.AssessmentItemID = ItemInfo.AssessmentItemID; AssignItem.Content = ItemInfo.Content; AssignItem.Count = ItemInfo.Count; AssignItem.Course = ItemInfo.Course; AssignItem.Description = ItemInfo.Description; AssignItem.Difficult = ItemInfo.Difficult; AssignItem.Duration = ItemInfo.Duration; AssignItem.Interval = ItemInfo.Interval; AssignItem.ItemTypeID = ItemInfo.ItemTypeID; AssignItem.Original = ItemInfo.Original; AssignItem.QuestionCount = ItemInfo.QuestionCount; AssignItem.SaveTime = ItemInfo.SaveTime; AssignItem.Score = ItemInfo.Score; AssignItem.Unit = ItemInfo.Unit; AssignItem.UpdateTime = DateTime.Now; AssignItem.UpdateUserID = _item.SelectUserID(User.Identity.Name); AssignItem.UserID = ItemInfo.UserID; AssignItem.State = true; db.AddToCEDTS_AssignAssessment(AssignItem); db.SaveChanges(); for (int i = 0; i < ExcelInfo.QuestionID.Count; i++) { Guid QuestionID1 = Guid.Parse(ExcelInfo.QuestionID[i]); string[] KpID = ExcelInfo.KnowledgeID[i].Split(','); for (int j = 0; j < KpID.Length; j++) { Guid Kp = Guid.Parse(KpID[j]); CEDTS_AssignQuestionKnowledge AssignKp = new CEDTS_AssignQuestionKnowledge(); AssignKp.KnowledgePointID = Kp; AssignKp.QuestionID = QuestionID1; db.AddToCEDTS_AssignQuestionKnowledge(AssignKp); db.SaveChanges(); } } Guid ItemID1 = Guid.Parse(ExcelInfo.ItemID); int UserID = _item.SelectUserID(User.Identity.Name); db.Update(ItemID1, UserID, DateTime.Now); } else { Guid ItemID = Guid.Parse(ExcelInfo.ItemID); int UserID = _item.SelectUserID(User.Identity.Name); db.Update(ItemID, UserID, DateTime.Now); //删除QuestionKnowledge中数据 string qkIDs = form["QkID"]; string[] qkID = qkIDs.Split(','); List <int> q = new List <int>(); for (int m = 0; m < qkID.Length; m++) { q.Add(Int32.Parse(qkID[m])); } _QuestionKnowledge.Delete(q); //新增QuestionKnowledge中数据 for (int s = 0; s < QuestionID.Length; s++) { string[] Knowledge = form["hidden" + (s + 1)].ToString().Split(','); for (int k = 0; k < Knowledge.Length; k++) { CEDTS_QuestionKnowledge qk = new CEDTS_QuestionKnowledge(); qk.QuestionID = Guid.Parse(QuestionID[s]); qk.KnowledgePointID = Guid.Parse(Knowledge[k]); qk.Weight = k + 1; _QuestionKnowledge.Create(qk); } } } string QID = string.Empty; for (int j = 0; j < ExcelInfo.QuestionID.Count; j++) { if (j == ExcelInfo.QuestionID.Count - 1) { QID += ExcelInfo.QuestionID[j]; } else { QID += ExcelInfo.QuestionID[j] + ","; } } CEDTS_Assign Assign = new CEDTS_Assign(); Assign.AssessmentItemID = Guid.Parse(ExcelInfo.ItemID); Assign.Time = DateTime.Now; Assign.QuestionID = QID; db.AddToCEDTS_Assign(Assign); db.SaveChanges(); } else { Guid ItemID2 = Guid.Parse(ExcelInfo.ItemID); int UserID2 = _item.SelectUserID(User.Identity.Name); db.Update(ItemID2, UserID2, DateTime.Now); db.SaveChanges(); } tran.Complete(); } } catch (Exception ex) { return(Json(ex.Message.ToString())); } #region Excel //Microsoft.Office.Interop.Excel.Application ExcelApp = new Application(); //string FileName = ExcelInfo.UserName+".xls"; //string file = "E://Web//" + FileName; //if (System.IO.File.Exists(file)) //{ // Microsoft.Office.Interop.Excel.Workbook xBook = ExcelApp.Workbooks.Open(Server.MapPath("/"+FileName), Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);// // int s = ExcelApp.ActiveSheet.UsedRange.Rows.Count; // for (int l = 1; l < (ExcelInfo.QuestionID.Count+1); l++) // { // ExcelApp.Cells[(s + l), 1] = ExcelInfo.UserName; // ExcelApp.Cells[(s + l), 2] = ExcelInfo.Time; // ExcelApp.Cells[(s + l), 3] = ExcelInfo.ItemName; // ExcelApp.Cells[(s + l), 4] = ExcelInfo.ItemID; // ExcelApp.Cells[(s + l), 5] = ExcelInfo.QuestionID[(l-1)]; // ExcelApp.Cells[(s + l), 6] = ExcelInfo.OldKPName[(l-1)]; // ExcelApp.Cells[(s + l), 7] = ExcelInfo.KPName[(l-1)]; // } // xBook.SaveAs(Server.MapPath("/" + FileName));//保存 // xBook.Close(false, Missing.Value, Missing.Value);//关闭 //} //else //{ // ExcelApp.Visible = false; // Microsoft.Office.Interop.Excel.Workbook Wb = ExcelApp.Application.Workbooks.Add(true); // ExcelApp.Cells[1, 1] = "用户名"; // ExcelApp.Cells[1, 2] = "更改时间"; // ExcelApp.Cells[1, 3] = "试题类型"; // ExcelApp.Cells[1, 4] = "ItemID"; // ExcelApp.Cells[1, 5] = "QuestionID"; // ExcelApp.Cells[1, 6] = "更改前的知识点"; // ExcelApp.Cells[1, 7] = "更改后的知识点"; // for (int p = 2; p < (ExcelInfo.QuestionID.Count + 2); p++) // { // ExcelApp.Cells[p, 1] = ExcelInfo.UserName; // ExcelApp.Cells[p, 2] = ExcelInfo.Time; // ExcelApp.Cells[p, 3] = ExcelInfo.ItemName; // ExcelApp.Cells[p, 4] = ExcelInfo.ItemID; // ExcelApp.Cells[p, 5] = ExcelInfo.QuestionID[(p-2)]; // ExcelApp.Cells[p, 6] = ExcelInfo.OldKPName[(p-2)]; // ExcelApp.Cells[p, 7] = ExcelInfo.KPName[(p-2)]; // } // Wb.SaveCopyAs(Server.MapPath("/" + FileName));//另存 // Wb.Close(false, Missing.Value, Missing.Value);//关闭 //} #endregion if (ExcelInfo.KPName.Count > 0) { string FileName = "D://Cedts//Excel//" + User.Identity.Name + "赋值不同.txt"; if (System.IO.File.Exists(FileName)) { StreamReader Sr = new StreamReader(FileName); int Num = 0; string Str = Sr.ReadToEnd(); Sr.BaseStream.Seek(0, SeekOrigin.Begin); string StrLine = Sr.ReadLine(); while (StrLine != null) { if (StrLine != "") { Num++; } StrLine = Sr.ReadLine(); } Sr.Close(); StreamWriter Sw = new StreamWriter(FileName); Sw.WriteLine(Str); for (int a = 0; a < ExcelInfo.QuestionID.Count; a++) { string Content = string.Empty; Content = Num + " " + ExcelInfo.UserName + " " + ExcelInfo.UpdateUserName + " " + ExcelInfo.Time + " " + ExcelInfo.ItemName + " " + ExcelInfo.ItemID + " " + ExcelInfo.QuestionID[a] + " " + ExcelInfo.OldKPName[a] + " " + ExcelInfo.KPName[a]; Sw.WriteLine(Content); } Sw.Close(); Sw.Close(); } else { FileStream myFs = new FileStream(FileName, FileMode.Create); StreamWriter mySw = new StreamWriter(myFs); string Title = "编号" + " " + "用户名" + " " + "上次更新用户" + " " + "更改时间" + " " + "试题类型" + " " + "ItemID" + " " + "QuestionID" + " " + "更改前知识点名称" + " " + "更改后知识点"; mySw.WriteLine(Title); for (int a = 0; a < ExcelInfo.QuestionID.Count; a++) { string Content = string.Empty; Content = (a + 1) + " " + ExcelInfo.UserName + " " + ExcelInfo.UpdateUserName + " " + ExcelInfo.Time + " " + ExcelInfo.ItemName + " " + ExcelInfo.ItemID + " " + ExcelInfo.QuestionID[a] + " " + ExcelInfo.OldKPName[a] + " " + ExcelInfo.KPName[a]; mySw.WriteLine(Content); } mySw.Close(); myFs.Close(); } } if (ExcelInfo1.KPName.Count > 0) { //赋值相同 string FileName1 = "D://Cedts//Excel//" + User.Identity.Name + "赋值相同.txt"; if (System.IO.File.Exists(FileName1)) { StreamReader Sr = new StreamReader(FileName1); int Num = 0; string Str = Sr.ReadToEnd(); Sr.BaseStream.Seek(0, SeekOrigin.Begin); string StrLine = Sr.ReadLine(); while (StrLine != null) { if (StrLine != "") { Num++; } StrLine = Sr.ReadLine(); } Sr.Close(); StreamWriter Sw = new StreamWriter(FileName1); Sw.WriteLine(Str); for (int a = 0; a < ExcelInfo1.QuestionID.Count; a++) { string Content = string.Empty; Content = Num + " " + ExcelInfo1.UserName + " " + ExcelInfo1.UpdateUserName + " " + ExcelInfo1.Time + " " + ExcelInfo1.ItemName + " " + ExcelInfo1.ItemID + " " + ExcelInfo1.QuestionID[a] + " " + ExcelInfo1.OldKPName[a] + " " + ExcelInfo1.KPName[a]; Sw.WriteLine(Content); } Sw.Close(); Sw.Close(); } else { FileStream myFs = new FileStream(FileName1, FileMode.Create); StreamWriter mySw = new StreamWriter(myFs); string Title = "编号" + " " + "用户名" + " " + "上次更新用户" + " " + "更改时间" + " " + "试题类型" + " " + "ItemID" + " " + "QuestionID" + " " + "更改前知识点名称" + " " + "更改后知识点"; mySw.WriteLine(Title); for (int a = 0; a < ExcelInfo1.QuestionID.Count; a++) { string Content = string.Empty; Content = (a + 1) + " " + ExcelInfo1.UserName + " " + ExcelInfo1.UpdateUserName + " " + ExcelInfo1.Time + " " + ExcelInfo1.ItemName + " " + ExcelInfo1.ItemID + " " + ExcelInfo1.QuestionID[a] + " " + ExcelInfo1.OldKPName[a] + " " + ExcelInfo1.KPName[a]; mySw.WriteLine(Content); } mySw.Close(); myFs.Close(); } } return(RedirectToAction("index")); }
public ActionResult Listen(FormCollection form) { ExcelInfo ExcelInfo = new Models.ExcelInfo(); ExcelInfo.KPName = new List <string>(); ExcelInfo.OldKPName = new List <string>(); ExcelInfo.QuestionID = new List <string>(); ExcelInfo.KnowledgeID = new List <string>(); ExcelInfo.ItemName = form["ItemType_CN"]; ExcelInfo.UserName = User.Identity.Name; ExcelInfo.ItemID = form["AssessID"]; ExcelInfo ExcelInfo1 = new Models.ExcelInfo(); ExcelInfo1.KPName = new List <string>(); ExcelInfo1.OldKPName = new List <string>(); ExcelInfo1.QuestionID = new List <string>(); ExcelInfo1.KnowledgeID = new List <string>(); ExcelInfo1.FirstName = new List <string>(); ExcelInfo1.ItemName = form["ItemType_CN"]; ExcelInfo1.UserName = User.Identity.Name; ExcelInfo1.ItemID = form["AssessID"]; int Count = int.Parse(form["Count"]); int QuestionCount = int.Parse(form["QuestionCount"]); string ques = form["QuestionID"]; string[] QuestionID = ques.Split(','); for (int i = 0; i < QuestionCount; i++) { string KpID = form["hidden" + (i + 1)]; string OldKPID = form["OldKPID" + (i + 1)]; string OldQuestionID = form["OldQuestionID" + (i + 1)]; string[] list = KpID.Split(','); string[] list1 = OldKPID.Split(','); Guid qid = Guid.Parse(OldQuestionID);//第二次赋值QuestionID var first = (from m in db.CEDTS_AssignQuestionKnowledge where m.QuestionID == qid select m.KnowledgePointID).ToList(); int Length = 0; int Length1 = 0; if (list.Length <= list1.Length || list.Length <= first.Count) //第三次赋值知识点个数小于第一个和第二次个数 { if (list.Length <= list1.Length) //第二次赋值与第三次赋值知识点个数是否相同 { for (int s = 0; s < list1.Length; s++) { if (list.Contains(list1[s])) { Length += 1; } } } if (list.Length <= first.Count)//第三次和第一次赋值比较 { for (int s = 0; s < first.Count; s++) { if (list.Contains(first[s].ToString())) { Length1 += 1; } } } } if (Length == list.Length || Length1 == list.Length) { ExcelInfo.KnowledgeID.Add(KpID); string name = string.Empty; string[] Kps = KpID.Split(','); for (int b = 0; b < Kps.Length; b++) { Guid Kp = Guid.Parse(Kps[b]); var Kpname = (from m in db.CEDTS_KnowledgePoints where m.KnowledgePointID == Kp select m.Title).FirstOrDefault(); if (b == Kps.Length - 1) { name += Kpname; } else { name += Kpname + ","; } } string Oldname = string.Empty; string[] OldKps = OldKPID.Split(','); for (int b = 0; b < OldKps.Length; b++) { Guid Kp = Guid.Parse(OldKps[b]); var Kpname = (from m in db.CEDTS_KnowledgePoints where m.KnowledgePointID == Kp select m.Title).FirstOrDefault(); if (b == OldKps.Length - 1) { Oldname += Kpname; } else { Oldname += Kpname + ","; } } ExcelInfo.OldKPName.Add(Oldname); ExcelInfo.KPName.Add(name); ExcelInfo.QuestionID.Add(OldQuestionID); ExcelInfo.Time = DateTime.Now; } else { string name = string.Empty; string[] Kps = KpID.Split(','); for (int b = 0; b < Kps.Length; b++) { Guid Kp = Guid.Parse(Kps[b]); var Kpname = (from m in db.CEDTS_KnowledgePoints where m.KnowledgePointID == Kp select m.Title).FirstOrDefault(); if (b == Kps.Length - 1) { name += Kpname; } else { name += Kpname + ","; } } string Oldname = string.Empty; string[] OldKps = OldKPID.Split(','); for (int b = 0; b < OldKps.Length; b++) { Guid Kp = Guid.Parse(OldKps[b]); var Kpname = (from m in db.CEDTS_KnowledgePoints where m.KnowledgePointID == Kp select m.Title).FirstOrDefault(); if (b == OldKps.Length - 1) { Oldname += Kpname; } else { Oldname += Kpname + ","; } } string TwoName = string.Empty; Guid FQID = Guid.Parse(OldQuestionID); var FirstKPIDList = (from m in db.CEDTS_AssignQuestionKnowledge where m.QuestionID == FQID select m.KnowledgePointID); foreach (var FirstKPID in FirstKPIDList) { var Name = (from m in db.CEDTS_KnowledgePoints where m.KnowledgePointID == FirstKPID select m.Title).FirstOrDefault(); TwoName += Name + ","; } ExcelInfo1.KnowledgeID.Add(KpID); ExcelInfo1.OldKPName.Add(Oldname); ExcelInfo1.KPName.Add(name); ExcelInfo1.QuestionID.Add(OldQuestionID); ExcelInfo1.FirstName.Add(TwoName); ExcelInfo1.Time = DateTime.Now; } } try { using (TransactionScope tran = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(0, 5, 0))) { if (ExcelInfo1.QuestionID.Count > 0) { if (ExcelInfo.QuestionID.Count > 0) { for (int i = 0; i < ExcelInfo.QuestionID.Count; i++) { Guid QID = Guid.Parse(ExcelInfo.QuestionID[i]); var QkInfos = (from m in db.CEDTS_QuestionKnowledge where m.QuestionID == QID select m).ToList(); foreach (var qkinfo in QkInfos) { db.DeleteObject(qkinfo); } string[] kps = ExcelInfo.KnowledgeID[i].Split(','); for (int j = 0; j < kps.Length; j++) { CEDTS_QuestionKnowledge Qk = new CEDTS_QuestionKnowledge(); Qk.QuestionID = QID; Qk.KnowledgePointID = Guid.Parse(kps[j]); Qk.Weight = (j + 1); db.AddToCEDTS_QuestionKnowledge(Qk); db.SaveChanges(); } } } string QID1 = string.Empty; for (int j = 0; j < ExcelInfo1.QuestionID.Count; j++) { if (j == ExcelInfo1.QuestionID.Count - 1) { QID1 += ExcelInfo.QuestionID[j]; } else { QID1 += ExcelInfo.QuestionID[j] + ","; } } CEDTS_Assign Assign = new CEDTS_Assign(); Assign.AssessmentItemID = Guid.Parse(ExcelInfo1.ItemID); Assign.Time = DateTime.Now; Assign.QuestionID = QID1; db.AddToCEDTS_Assign(Assign); db.SaveChanges(); Guid ID = Guid.Parse(ExcelInfo.ItemID); db.UpdateState(ID); db.SaveChanges(); } else { //删除QuestionKnowledge中数据 string qkIDs = form["QkID"]; string[] qkID = qkIDs.Split(','); List <int> q = new List <int>(); for (int m = 0; m < qkID.Length; m++) { q.Add(Int32.Parse(qkID[m])); } _QuestionKnowledge.Delete(q); //新增QuestionKnowledge中数据 for (int s = 0; s < QuestionID.Length; s++) { string[] Knowledge = form["hidden" + (s + 1)].ToString().Split(','); for (int k = 0; k < Knowledge.Length; k++) { CEDTS_QuestionKnowledge qk = new CEDTS_QuestionKnowledge(); qk.QuestionID = Guid.Parse(QuestionID[s]); qk.KnowledgePointID = Guid.Parse(Knowledge[k]); qk.Weight = k + 1; _QuestionKnowledge.Create(qk); } } string QID = string.Empty; for (int j = 0; j < ExcelInfo.QuestionID.Count; j++) { if (j == ExcelInfo.QuestionID.Count - 1) { QID += ExcelInfo.QuestionID[j]; } else { QID += ExcelInfo.QuestionID[j] + ","; } } Guid ID = Guid.Parse(ExcelInfo.ItemID); var AssignItem = (from m in db.CEDTS_AssignAssessment where m.AssessmentItemID == ID select m).FirstOrDefault(); db.DeleteObject(AssignItem); db.SaveChanges(); } tran.Complete(); } } catch (Exception ex) { return(Json(ex.Message.ToString())); } if (ExcelInfo1.KPName.Count > 0) { string FileName = "D://Cedts//Excel//" + User.Identity.Name + "第三次赋值不同.txt"; if (System.IO.File.Exists(FileName)) { StreamReader Sr = new StreamReader(FileName); int Num = 0; string Str = Sr.ReadToEnd(); Sr.BaseStream.Seek(0, SeekOrigin.Begin); string StrLine = Sr.ReadLine(); while (StrLine != null) { if (StrLine != "") { Num++; } StrLine = Sr.ReadLine(); } Sr.Close(); StreamWriter Sw = new StreamWriter(FileName); Sw.WriteLine(Str); for (int a = 0; a < ExcelInfo1.QuestionID.Count; a++) { string Content = string.Empty; Content = Num + " " + ExcelInfo1.UserName + " " + ExcelInfo1.UpdateUserName + " " + ExcelInfo1.Time + " " + ExcelInfo1.ItemName + " " + ExcelInfo1.ItemID + " " + ExcelInfo1.QuestionID[a] + " " + ExcelInfo1.OldKPName[a] + " " + ExcelInfo1.FirstName[a] + " " + ExcelInfo1.KPName[a]; Sw.WriteLine(Content); } Sw.Close(); Sw.Close(); } else { FileStream myFs = new FileStream(FileName, FileMode.Create); StreamWriter mySw = new StreamWriter(myFs); string Title = "编号" + " " + "用户名" + " " + "上次更新用户" + " " + "更改时间" + " " + "试题类型" + " " + "ItemID" + " " + "QuestionID" + " " + "第一次知识点名称" + " " + "第二次知识点名称" + " " + "第三次知识点"; mySw.WriteLine(Title); for (int a = 0; a < ExcelInfo1.QuestionID.Count; a++) { string Content = string.Empty; Content = (a + 1) + " " + ExcelInfo1.UserName + " " + ExcelInfo1.UpdateUserName + " " + ExcelInfo1.Time + " " + ExcelInfo1.ItemName + " " + ExcelInfo1.ItemID + " " + ExcelInfo1.QuestionID[a] + " " + ExcelInfo1.OldKPName[a] + " " + ExcelInfo1.FirstName[a] + " " + ExcelInfo1.KPName[a]; mySw.WriteLine(Content); } mySw.Close(); myFs.Close(); } } return(RedirectToAction("index")); }