/// <summary>
/// 用户特定咨询，保存用户特定咨询填写的数据
/// </summary>
/// <param name="userId">咨询者的id</param>
/// <param name="expertId">专家id</param>
/// <param name="occasion">场合</param>
/// <param name="details">咨询详情</param>
/// <param name="geRenZhaoFileName">个人照片名</param>
/// <param name="likeStyleImageFileName">喜欢风格的照片名</param>
/// <param name="dislikeStyleImageFileName">不喜欢风格的照片名</param>
/// <returns></returns>
public int InsertConsultData(int userId, string occasion, string details, string geRenZhaoFileName, string likeStyleImageFileName, string dislikeStyleImageFileName, DateTime datetime)
{
SpecialConsult_dal specialConsul_dal = new SpecialConsult_dal();
string geRenZhaoUrl = "/Images/ConsultImages/GeRenZhao/" + geRenZhaoFileName;
string likeStyleImageUrl = "/Images/ConsultImages/LikeStyleImage/" + likeStyleImageFileName;
string dislikeStyleImageUrl = "/Images/ConsultImages/DisLikeStyleImage/" + dislikeStyleImageFileName;
return(specialConsul_dal.InsertConsultData(userId, occasion, details, geRenZhaoUrl, likeStyleImageUrl, dislikeStyleImageUrl, datetime));
}
/// <summary>
/// 专家对特定咨询的解答
/// 将专家对特定咨询的回答存入数据库tb_SpecialConsultAnswer，1条数据
/// 成功返回1，失败返回0
/// </summary>
/// <param name="specialConsultId">用户特定咨询数据表里的id</param>
/// <param name="htmlUrl">专家回答的静态htmlurl</param>
/// <returns></returns>
public int InsertAnswerData(int specialConsultId, int expertId, string htmlUrl, DateTime datetime)
{
SpecialConsult_dal specialConsult_dal = new SpecialConsult_dal();
if (specialConsult_dal.InsertAnswerData(specialConsultId, expertId, htmlUrl, datetime) != 1)
{
return(0);
}
return(1);
}
/// <summary>
/// 通过专家解答的特定咨询staticConsultAnswerHtml查询该条数据的id
/// </summary>
/// <param name="staticConsultAnswerHtml"></param>
/// <returns></returns>
public int GetConsultAnswerId(string staticConsultAnswerHtml)
{
SpecialConsult_dal specialConsult_dal = new SpecialConsult_dal();
object objSpecialConsultAnswer_Id = specialConsult_dal.GetConsultAnswerId(staticConsultAnswerHtml);
if (objSpecialConsultAnswer_Id == null || objSpecialConsultAnswer_Id == System.DBNull.Value)
{
}
return(Convert.ToInt32(objSpecialConsultAnswer_Id));
}
/// <summary>
/// Creator:Simple
/// 通过用户特定咨询后保存的个人照路径查询该条特定咨询数据的id，因为个人照路径geRenZhaoUrl是唯一的
/// </summary>
/// <param name="geRenZhaoUrl"></param>
/// <returns></returns>
public int GetSpecialConsultId(string geRenZhaoFileName)
{
string geRenZhaoUrl = "/Images/ConsultImages/GeRenZhao/" + geRenZhaoFileName;
SpecialConsult_dal specialConsult_dal = new SpecialConsult_dal();
object objSpecialConsult_Id = specialConsult_dal.GetSpecialConsultId(geRenZhaoUrl);
if (objSpecialConsult_Id == null || objSpecialConsult_Id == System.DBNull.Value)
{
}
return(Convert.ToInt32(objSpecialConsult_Id));
}
/// <summary>
/// 根据specialConsultId获取特定咨询的SpecialConsult_Caption，SpecialConsult_Occasion，SpecialConsult_Detail，SpecialConsult_Date
/// </summary>
/// <param name="specialConsultId"></param>
/// <returns></returns>
public SpecialConsult_model GetOneShortConsultData(int specialConsultId)
{
SpecialConsult_dal specialConsult_dal = new SpecialConsult_dal();
return(specialConsult_dal.GetOneShortConsultData(specialConsultId));
}
