//特定咨询详情页面(用户和专家共用) 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> /// 将一条数据转化为SpecialConsult_model数据 /// </summary> /// <param name="row"></param> /// <returns></returns> public SpecialConsult_model ToModel(DataRow row) { ///这里还缺少一个处理,那就是,当数据库里的某个字段为空时,要初始化什么值,或者做什么处理 SpecialConsult_model specialConsult_model = new SpecialConsult_model(); specialConsult_model.id = (int)row["id"]; specialConsult_model.caption = row["caption"].ToString(); specialConsult_model.userPhotoUrl = row["geRenZhao"].ToString(); specialConsult_model.occasion = row["occasion"].ToString(); specialConsult_model.likeStyleUrl = row["likeStyleUrl"].ToString(); specialConsult_model.dislikeStyleUrl = row["dislikeStyleUrl"].ToString(); specialConsult_model.detail = row["detail"].ToString(); //咨询者数据 specialConsult_model.user.userId = (int)row["userId"]; specialConsult_model.user.userName = row["userName"].ToString(); specialConsult_model.user.height = Convert.ToInt32(row["height"]); specialConsult_model.user.weight = Convert.ToInt32(row["weight"]); specialConsult_model.user.yaoWei = Convert.ToInt32(row["yaoWei"]); specialConsult_model.user.tuiChang = Convert.ToInt32(row["tuiChang"]); specialConsult_model.user.daTuiWei = Convert.ToInt32(row["daTuiWei"]); specialConsult_model.user.xiaoTunWei = Convert.ToInt32(row["xiaoTuiWei"]); specialConsult_model.user.tunWei = Convert.ToInt32(row["tunWei"]); specialConsult_model.user.biWei = Convert.ToInt32(row["biWei"]); specialConsult_model.user.xiongWei = Convert.ToInt32(row["xiongWei"]); specialConsult_model.user.skinColor = row["skinColor"].ToString(); return(specialConsult_model); }
/// <summary> /// 将一条数据转化为SpecialConsult_model数据 /// 特定咨询帖子id 标题 用户个人照 详细描述 日期 /// </summary> /// <param name="row"></param> /// <returns></returns> public SpecialConsult_model ToShortModel(DataRow row) { SpecialConsult_model specialConsult_model = new SpecialConsult_model(); specialConsult_model.id = (int)row["id"]; specialConsult_model.caption = row["caption"].ToString(); specialConsult_model.userPhotoUrl = row["geRenZhao"].ToString(); specialConsult_model.detail = row["detail"].ToString(); specialConsult_model.datetime = (DateTime)row["date"]; return(specialConsult_model); }
/// <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)); }
//特定咨询详情页面(用户和专家共用) 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> /// 通过特定咨询的帖子编号specialConsultId查询数据库的tb_SpecialConsult, /// 获取用户特定咨询时填写的特定咨询数据 /// </summary> /// <param name="specialConsultId">特定咨询的帖子编号</param> /// <returns></returns> public SpecialConsult_model GetOneConsultData(int specialConsultId) { string sqlStr = @"select consult.SpecialConsult_Id id,consult.SpecialConsult_Caption caption,consult.SpecialConsult_Occasion occasion, consult.SpecialConsult_UserPhotoUrl geRenZhao,consult.SpecialConsult_LikeStyleUrl likeStyleUrl, consult.SpecialConsult_DislikeStyleUrl dislikeStyleUrl,consult.SpecialConsult_Detail detail, theUser.User_Id userId,theUser.User_Name userName,theUser.User_Height height,theUser.User_Weight weight, theUser.User_YaoWei yaoWei,theUser.User_LegLength tuiChang,theUser.User_ThighGirth daTuiWei, theUser.User_SkinColor skinColor,theUser.User_TunWei tunWei,theUser.User_ArmGirth biWei, theUser.User_XiongWei xiongWei,theUser.User_CalfGirth xiaoTuiWei from tb_SpecialConsult consult left join tb_User theUser on consult.SpecialConsult_UserId=theUser.User_Id where consult.SpecialConsult_Id=@specialConsultId"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@specialConsultId", specialConsultId) }; DataTable dataTable = SqlHelper.ExecuteDataTable(sqlStr, parameters); SpecialConsult_model specialConsult_model = ToModel(dataTable.Rows[0]); return(specialConsult_model); }
/// <summary> /// 根据specialConsultId获取特定咨询的SpecialConsult_Caption,SpecialConsult_Occasion,SpecialConsult_Detail,SpecialConsult_Date /// </summary> /// <param name="specialConsultId"></param> /// <returns></returns> public SpecialConsult_model GetOneShortConsultData(int specialConsultId) { string sqlStr = @"select SpecialConsult_Caption caption,SpecialConsult_Occasion occasion, SpecialConsult_Detail detail,SpecialConsult_Date [date] from tb_SpecialConsult where SpecialConsult_Id=@specialConsultId"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@specialConsultId", specialConsultId) }; DataTable dt = SqlHelper.ExecuteDataTable(sqlStr, parameters); SpecialConsult_model specialConsult_model = new SpecialConsult_model(); if (dt.Rows.Count == 1) { specialConsult_model.caption = dt.Rows[0]["caption"].ToString(); specialConsult_model.datetime = (DateTime)dt.Rows[0]["date"]; specialConsult_model.occasion = dt.Rows[0]["occasion"].ToString(); specialConsult_model.detail = dt.Rows[0]["detail"].ToString(); } return(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)); }