//特定咨询详情页面(用户和专家共用) public ActionResult ConsultDetails() { if (Session["userName"] == null) { return(RedirectToAction("LoginRemind", "Topic")); } LoginStatusConfig();//配置登录状态 string userName = Session["userName"].ToString(); ////获取用户等级名 Rank_bll rank_bll = new Rank_bll(); string rankNameDB = rank_bll.GetRankName(userName); //该用户数据库里的等级名 rankNameDB = rankNameDB.Trim(); //去除空格 //string expertUserName = Request["expertUserName"].ToString(); int specialConsultId = Convert.ToInt32(Request["specialConsultId"]); SpecialConsult_bll specialConsult_bll = new SpecialConsult_bll(); SpecialConsult_model specialConsult_model = specialConsult_bll.GetOneSpecialConsult(specialConsultId);//通过specialConsultId获取用户特定咨询时填写的特定咨询数据 ViewData["specialConsult_model"] = specialConsult_model; ViewData["rankName"] = rankNameDB; SpecialConsultAnswer_bll specialConsultAnswer_bll = new SpecialConsultAnswer_bll(); string expertUserName = Request["expertUserName"].ToString(); User_bll user_bll = new User_bll(); int expertId = user_bll.GetUserId(expertUserName); SpecialConsultAnswer_model specialConsultAnswer_model = specialConsultAnswer_bll.GetOneSpecialAnswerData(specialConsultId, expertId);//通过specialConsultId获取特定咨询的专家解答数据 return(View(specialConsultAnswer_model)); }
/// <summary> /// 遍历我的特定咨询过的帖子 /// Creator:Simple /// </summary> /// <returns></returns> public ActionResult MySpecialConsult() { if (Session["userName"] == null) { return(RedirectToAction("LoginRemind", "Topic")); } LoginStatusConfig();//配置登录状态 string userName = Session["userName"].ToString(); ////判断用户类型是否为普通用户 Rank_bll rank_bll = new Rank_bll(); string rankNameDB = rank_bll.GetRankName(userName); //该用户数据库里的等级名 rankNameDB = rankNameDB.Trim(); //去除空格 if (rankNameDB != "普通用户") { return(Content("错误提示:您不是普通用户")); } User_bll user_bll = new User_bll(); int userId = Convert.ToInt32(user_bll.GetUserId(userName)); //通过用户名获取userId CountUser_model countUser_model = user_bll.GetCountUser(userId, rankNameDB); //获取用户的CountUser_model 数据:点赞数 关注数 粉丝数 收藏数 提问数 回帖数 特定咨询数 等 ViewData["countUser_model"] = countUser_model; ViewData["rankName"] = rankNameDB; ViewData["actionName"] = "MySpecialConsult"; //当前action名 SpecialConsult_bll specialConsult_bll = new SpecialConsult_bll(); List <SpecialConsult_model> specialConsult_modelList = specialConsult_bll.GetMyConsultData(userId); //通过userId获取该用户的特定咨询数据 return(View(specialConsult_modelList)); }
/// <summary> /// 专家对特定咨询的回帖,当点击提交时调用此函数 /// </summary> /// <returns></returns> public ActionResult MakeExpertAnswer() { ////先把前端传回来的content内容保存为静态页面 byte[] byteData = new byte[Request.InputStream.Length]; //定义一个字节数组保存前端传回来的Post数据全部数据 Request.InputStream.Read(byteData, 0, byteData.Length); //将流读取到byteData,InputStream读取到的是http头里的主体数据 //string postData = System.Text.Encoding.Default.GetString(byteData);//系统的默认编码为gb2312,不适用这种 string postData = System.Text.Encoding.UTF8.GetString(byteData); postData = Server.UrlDecode(postData); //对数据进行url解码 string[] datas = postData.Split('&'); //对前端传回来的数据进行分割,提取出文本框里的html数据 string contentData = datas[0].ToString(); //data[0]为变量名为content的内容 contentData = contentData.Substring(contentData.IndexOf('=') + 1); //去除变量名,如content=aaa,只取出aaa DateTime datetime = DateTime.Now; string fileName = datetime.ToString("yyyyMMddHHmmss_ffff") + ".html"; //定义文件名fileName string fileNamePath = Server.MapPath("~/StaticHtml/ConsultAnswerHtml/") + fileName; //物理路径 while (System.IO.File.Exists(fileNamePath)) //先判断文件是否存在,若存在:更换文件名 { datetime = DateTime.Now; fileName = datetime.ToString("yyyyMMddHHmmss_ffff") + ".html"; fileNamePath = Server.MapPath("~/StaticHtml/ConsultAnswerHtml/") + fileName; } System.IO.FileStream fs = new System.IO.FileStream(fileNamePath, System.IO.FileMode.Create); byte[] contentBytes = System.Text.Encoding.UTF8.GetBytes(contentData); //byte[] contentBytes = System.Text.Encoding.Default.GetBytes(contentData); fs.Write(contentBytes, 0, contentBytes.Length); fs.Close(); //保存静态html成功 ////将数据保存到数据库里tb_SpecialConsultAnswer SpecialConsultAnswer_SpecialConsultId SpecialConsultAnswer_HtmlUrl int specialConsultId = Convert.ToInt32(Request["hidSpecialConsultId"]); //用户特定咨询的id string staticConsultAnswerHtml = "/StaticHtml/ConsultAnswerHtml/" + fileName; //相对路径 SpecialConsult_bll specialConsult_bll = new SpecialConsult_bll(); specialConsult_bll.InsertAnswerData(specialConsultId, staticConsultAnswerHtml, datetime); ////保存购买链接 int specialConsultAnswer_Id = specialConsult_bll.GetConsultAnswerId(staticConsultAnswerHtml); int selectCount = Convert.ToInt32(Request["selectCount"]); //代表购买链接的条数 Dictionary <string, string> selectClothUrlDic = new Dictionary <string, string>(); //服饰类型名:购买链接 for (int i = 1; i <= selectCount; i++) { try { selectClothUrlDic.Add(Request["selectCloth" + i].ToString(), Request["clothShoppingUrl" + i].ToString()); } catch (Exception e) { return(Content("<script type='text/javascript'>alert('请不要出入两种同样的服饰,请重新操作');window.location.href = '../Consult/ExpertAnswer';</script>")); } } SpecialConsultAnswerClothes_bll specialConsultAnswerClothes_bll = new SpecialConsultAnswerClothes_bll(); specialConsultAnswerClothes_bll.InsertConsultAnswerClothes(specialConsultAnswer_Id, selectClothUrlDic); return(Content("1")); }
/// <summary> /// 保存特定咨询的数据 /// </summary> /// <returns></returns> public ActionResult MakeConsult() { if (Session["username"] == null) { return(View("loginremind")); } string userName = Session["username"].ToString(); User_bll user_bll = new User_bll(); int userId = user_bll.GetUserId(userName); //string expertName=Request[].ToString(); //int expertId = user_bll.GetUserId(expertName); string occasion = Request["occasion"].ToString(); //场合 string details = Request["details"].ToString(); //特定咨询详情 DateTime datetime = DateTime.Now; //保存个人照片到文件夹:GeRenZhao byte[] imgGeRenZhao64Byte = Convert.FromBase64String(Request["geRenZhao"]);//将图片数据转化为base64的格式 System.IO.MemoryStream ms = new System.IO.MemoryStream(imgGeRenZhao64Byte); System.Drawing.Bitmap bitmap = new System.Drawing.Bitmap(ms); string geRenZhaoFileName = Guid.NewGuid().ToString() + ".png";//唯一的文件名 bitmap.Save(Server.MapPath("~/Images/ConsultImages/GeRenZhao/" + geRenZhaoFileName), System.Drawing.Imaging.ImageFormat.Png); //保存喜欢风格的照片到文件夹:LikeStyleImage byte[] likeStyleImageBase64 = Convert.FromBase64String(Request["likeStyleImage"]);//将图片数据转化为base64的格式 System.IO.MemoryStream ms2 = new System.IO.MemoryStream(likeStyleImageBase64); System.Drawing.Bitmap bitmap2 = new System.Drawing.Bitmap(ms2); string likeStyleImageFileName = Guid.NewGuid().ToString() + ".png";//唯一的文件名 bitmap2.Save(Server.MapPath("~/Images/ConsultImages/LikeStyleImage/" + likeStyleImageFileName), System.Drawing.Imaging.ImageFormat.Png); //保存不喜欢风格的照片到文件夹:DislikeStyleImage byte[] dislikeStyleImageBase64 = Convert.FromBase64String(Request["dislikeStyleImage"]);//将图片数据转化为base64的格式 System.IO.MemoryStream ms3 = new System.IO.MemoryStream(dislikeStyleImageBase64); System.Drawing.Bitmap bitmap3 = new System.Drawing.Bitmap(ms3); string dislikeStyleImageFileName = Guid.NewGuid().ToString() + ".png";//唯一的文件名 bitmap3.Save(Server.MapPath("~/Images/ConsultImages/DislikeStyleImage/" + dislikeStyleImageFileName), System.Drawing.Imaging.ImageFormat.Png); SpecialConsult_bll specialConsult_bll = new SpecialConsult_bll();//保存特定咨询数据 specialConsult_bll.InsertConsultData(userId, occasion, details, geRenZhaoFileName, likeStyleImageFileName, dislikeStyleImageFileName, datetime); //通过geRenZhaoFileName查询该咨询的id int specialConsult_Id = specialConsult_bll.GetSpecialConsultId(geRenZhaoFileName); //将用户特定咨询时选择的专家,添加到数据库 SpecialConsultSelectExperts_bll specialConsultSelectExperts_bll = new SpecialConsultSelectExperts_bll(); List <string> expertIdList = new List <string>(); string expertIdStr = Request["expertIdList"].ToString();//获取用户选择的专家id foreach (string expertId in expertIdStr.Split(',')) { expertIdList.Add(expertId); } specialConsultSelectExperts_bll.InsertSpecialConsultSelectExperts(specialConsult_Id, expertIdList); return(Content(specialConsult_Id.ToString()));//返回specialConsult_Id }
/// <summary> /// 保存特定咨询的数据 /// </summary> /// <returns></returns> public ActionResult MakeConsult() { if (Session["username"] == null) { return(View("loginremind")); } string userName = Session["username"].ToString(); User_bll user_bll = new User_bll(); int userId = user_bll.GetUserId(userName); //string expertName=Request[].ToString(); //int expertId = user_bll.GetUserId(expertName); int expertId = Convert.ToInt32(Request["expertId"]); string occasion = Request["occasion"].ToString(); //场合 string details = Request["details"].ToString(); //特定咨询详情 DateTime datetime = DateTime.Now; //保存个人照片到文件夹:GeRenZhao byte[] imgGeRenZhao64Byte = Convert.FromBase64String(Request["geRenZhao"]);//将图片数据转化为base64的格式 System.IO.MemoryStream ms = new System.IO.MemoryStream(imgGeRenZhao64Byte); System.Drawing.Bitmap bitmap = new System.Drawing.Bitmap(ms); string geRenZhaoFileName = Guid.NewGuid().ToString() + ".png";//唯一的文件名 bitmap.Save(Server.MapPath("~/Images/ConsultImages/GeRenZhao/" + geRenZhaoFileName), System.Drawing.Imaging.ImageFormat.Png); //保存喜欢风格的照片到文件夹:LikeStyleImage byte[] likeStyleImageBase64 = Convert.FromBase64String(Request["likeStyleImage"]);//将图片数据转化为base64的格式 System.IO.MemoryStream ms2 = new System.IO.MemoryStream(likeStyleImageBase64); System.Drawing.Bitmap bitmap2 = new System.Drawing.Bitmap(ms2); string likeStyleImageFileName = Guid.NewGuid().ToString() + ".png";//唯一的文件名 bitmap2.Save(Server.MapPath("~/Images/ConsultImages/LikeStyleImage/" + likeStyleImageFileName), System.Drawing.Imaging.ImageFormat.Png); //保存不喜欢风格的照片到文件夹:DislikeStyleImage byte[] dislikeStyleImageBase64 = Convert.FromBase64String(Request["dislikeStyleImage"]);//将图片数据转化为base64的格式 System.IO.MemoryStream ms3 = new System.IO.MemoryStream(dislikeStyleImageBase64); System.Drawing.Bitmap bitmap3 = new System.Drawing.Bitmap(ms3); string dislikeStyleImageFileName = Guid.NewGuid().ToString() + ".png";//唯一的文件名 bitmap3.Save(Server.MapPath("~/Images/ConsultImages/DislikeStyleImage/" + dislikeStyleImageFileName), System.Drawing.Imaging.ImageFormat.Png); SpecialConsult_bll specialConsult_bll = new SpecialConsult_bll();//保存特定咨询数据 specialConsult_bll.InsertConsultData(userId, expertId, occasion, details, geRenZhaoFileName, likeStyleImageFileName, dislikeStyleImageFileName, datetime); return(Content("特定咨询成功")); }
/// <summary> /// 显示特定咨询选择的专家列表解答情况 /// </summary> /// <returns></returns> public ActionResult MySpecialConsultExpertList() { if (Session["userName"] == null) { return(RedirectToAction("LoginRemind", "Topic")); } LoginStatusConfig(); //配置登录状态 int specialConsultId = Convert.ToInt32(Request["specialConsultId"]); //特定咨询帖子的id ViewData["specialConsultId"] = specialConsultId; SpecialConsult_bll specialConsult_bll = new SpecialConsult_bll(); SpecialConsult_model specialConsult_model = specialConsult_bll.GetOneShortConsultData(specialConsultId);//获取的咨询的标题,场合,内容以及时间 ViewData["specialConsult_model"] = specialConsult_model; SpecialConsultAnswer_bll specialConsultAnswer_bll = new SpecialConsultAnswer_bll(); List <SpecialConsultAnswer_model> specialConsultAnswer_modelList = specialConsultAnswer_bll.GetAllSelectExpertShortAnswer(specialConsultId);//获取选择的多个专家的解答数据 return(View(specialConsultAnswer_modelList)); }
/// <summary> /// 遍历我的特定咨询过的帖子 /// </summary> /// <returns></returns> public ActionResult MySpecialConsult() { if (Session["userName"] == null) { return(RedirectToAction("LoginRemind", "Topic")); } LoginStatusConfig();//配置登录状态 string userName = Session["userName"].ToString(); User_bll user_bll = new User_bll(); int userId = Convert.ToInt32(user_bll.GetUserId(userName)); //通过用户名获取userId CountUser_model countUser_model = user_bll.GetCountUser(userId); //获取用户的CountUser_model 数据:点赞数 关注数 粉丝数 收藏数 提问数 回帖数 特定咨询数 等 ViewData["countUser_model"] = countUser_model; SpecialConsult_bll specialConsult_bll = new SpecialConsult_bll(); List <SpecialConsult_model> specialConsult_modelList = specialConsult_bll.GetMyConsultData(userId); //通过userId获取该用户的特定咨询数据 return(View(specialConsult_modelList)); }
//特定咨询详情页面(用户和专家共用) public ActionResult ConsultDetails() { if (Session["userName"] == null) { return(RedirectToAction("LoginRemind", "Topic")); } LoginStatusConfig();//配置登录状态 //string expertUserName = Request["expertUserName"].ToString(); int specialConsultId = Convert.ToInt32(Request["specialConsultId"]); SpecialConsult_bll specialConsult_bll = new SpecialConsult_bll(); SpecialConsult_model specialConsult_model = specialConsult_bll.GetOneSpecialConsult(specialConsultId);//通过specialConsultId获取用户特定咨询时填写的特定咨询数据 ViewData["specialConsult_model"] = specialConsult_model; SpecialConsultAnswer_bll specialConsultAnswer_bll = new SpecialConsultAnswer_bll(); SpecialConsultAnswer_model specialConsultAnswer_model = specialConsultAnswer_bll.GetOneSpecialAnswerData(specialConsultId);//通过specialConsultId获取特定咨询的专家解答数据 return(View(specialConsultAnswer_model)); }
/// <summary> /// 返回专家特定咨询解答页面 /// </summary> /// <returns></returns> public ActionResult ExpertAnswer() { //string expertUserName = Request["expertUserName"].ToString(); string expertUserName = "******"; int specialConsultId = 3; //检查用户是否为专家 Rank_bll rank_bll = new Rank_bll(); string rankName = rank_bll.GetRankName(expertUserName); //获取用户的等级名称 rankName = rankName.Trim(); //去除字符串里的空格 if (rankName != "专家") { return(Content("0")); } //获取specialConsultId的特定咨询的数据 SpecialConsult_bll specialConsult_bll = new SpecialConsult_bll(); SpecialConsult_model specialConsult_model = specialConsult_bll.GetOneSpecialConsult(specialConsultId); return(View(specialConsult_model)); }
/// <summary> /// 返回专家特定咨询解答页面 /// </summary> /// <returns></returns> public ActionResult ExpertAnswer() { if (Session["userName"] == null) { return(RedirectToAction("LoginRemind", "Topic")); } LoginStatusConfig();//配置登录状态 string expertUserName = Request["expertUserName"].ToString(); int specialConsultId = Convert.ToInt32(Request["specialConsultId"]); //检查用户是否为专家 Rank_bll rank_bll = new Rank_bll(); string rankName = rank_bll.GetRankName(expertUserName); //获取用户的等级名称 rankName = rankName.Trim(); //去除字符串里的空格 if (rankName != "专家") { return(Content("0")); } //获取specialConsultId的特定咨询的数据 SpecialConsult_bll specialConsult_bll = new SpecialConsult_bll(); SpecialConsult_model specialConsult_model = specialConsult_bll.GetOneSpecialConsult(specialConsultId); return(View(specialConsult_model)); }