//特定咨询详情页面（用户和专家共用）
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));
}