/// <summary> /// 导入评价 /// </summary> /// <param name="pdtComment"></param> /// <returns></returns> public bool AddPdtComment(AddPLPLUserPdtComment pdtComment) { var req = Mapper.Map <AddPLPLUserPdtComment, AddPLPLUserPdtCommentRequest>(pdtComment); var res = OpcClient.Send <AddPLPLUserPdtCommentResponse>(req); return(res.DoFlag); }
/// <summary> /// 批量导入评论 /// </summary> /// <returns></returns> public void UploadFile() { try { //设置上传目录 string path = Server.MapPath("~/Content/upload/"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } //判断是否已经选择上传文件 HttpPostedFileBase file = Request.Files["file"]; if (file != null && file.ContentLength > 0) { string filenName = file.FileName; string fileExt = Path.GetExtension(filenName).ToLower().Substring(1); if (fileExt != "xls" && fileExt != "xlsx") { ModelState.AddModelError("", "您选择的不是Excel文件"); //return View("Index"); } else { #region 文件 string filepath = path + filenName; file.SaveAs(filepath); //读取excel文件,转换成dataset string strConn; strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties=Excel 8.0;"; OleDbConnection conn = new OleDbConnection(strConn); OleDbDataAdapter oada = new OleDbDataAdapter("select * from [Sheet1$]", strConn); DataTable dt = new DataTable(); oada.Fill(dt); #endregion AddPLPLUserPdtComment list = new AddPLPLUserPdtComment(); list.AddCommentDos = new List <UserPdtCommentDetail>(); #region 循环读取每一行,将数据插入到sql server数据库 if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { UserPdtCommentDetail model = new UserPdtCommentDetail(); model.IntProductID = Convert.ToInt32(row[0]); model.VchContent = row[1].ToString(); model.DtCommentDate = Convert.ToDateTime(row[2]); model.VchEmail = row[3].ToString(); model.IntUserID = 0; model.IntOrderNO = 0; model.IntGroupID = 0; model.VchPdtName = ""; model.IntStart = 5; model.IntIsMask = 1; model.IntIsHighLight = 0; model.IntIndexVisible = 0; model.IntAuditState = 1; list.AddCommentDos.Add(model); } } #endregion #region 批量导入数据库 var res = UserPdtCommentClient.Instance.AddPdtComment(list); if (res) { Response.Write("<script>alert('导入全部成功!');window.location.href='/UserPdtComment/index'</script>"); } else { Response.Write("<script>alert('部分导入成功!,修改后再继续导入!');window.location.href='/UserPdtComment/index'</script>"); } #endregion } } else { Response.Write("<script>alert('请选择文件!');window.location.href='/UserPdtComment/index'</script>"); } } catch (Exception ex) { ModelState.AddModelError("", "请选择文件"); Response.Write("<script>alert('请选择文件!');window.location.href='/UserPdtComment/index'</script>"); } }