public IList<AuthorDetailEntity> GetExpertGroupMapList(ExpertGroupMapEntity query)
{
IAuthorDetailService service = ServiceContainer.Instance.Container.Resolve<IAuthorDetailService>();
return service.GetExpertGroupMapList(query);
}
/// <summary>
/// 获取显示html
/// </summary>
/// <returns></returns>
private string GetExpertGroupMapHtml(Int32 GroupID)
{
StringBuilder strHtml = new StringBuilder();
IAuthorPlatformFacadeService service = ServiceContainer.Instance.Container.Resolve<IAuthorPlatformFacadeService>();
ExpertGroupMapEntity query = new ExpertGroupMapEntity();
query.JournalID = JournalID;
query.ExpertGroupID = GroupID;
var list = service.GetExpertGroupMapList(query);
if (list != null && list.Count > 0)
{
strHtml.Append("<table>");
int i = 1;
foreach (var model in list)
{
if (i == 1)
strHtml.Append("<tr>");
strHtml.Append("<td style=\"padding-left:10px;height:25px;width:130px;\">");
strHtml.Append("<input id=\"chkExpertGroup_")
.Append(model.AuthorID)
.Append("\" type=\"checkbox\" name=\"ExpertGroup\" value=\"")
.Append(model.AuthorID)
.Append("\" ");
if (model.IsChecked)
{
strHtml.Append(" checked=\"checked\" ");
}
strHtml.Append(" key=\"")
.Append(model.AuthorName)
.Append("\"/><label for=\"chkExpertGroup_")
.Append(model.AuthorID)
.Append("\" style=\"margin-right:30px;\" ");
if (!string.IsNullOrWhiteSpace(model.ResearchTopics))
{
strHtml.Append(" title=\"研究方向：");
strHtml.Append(model.ResearchTopics);
strHtml.Append("\"");
}
strHtml.Append(" >");
strHtml.Append(model.AuthorName);
strHtml.Append("</label></td>");
if (i == 5)
{
strHtml.Append("</tr>");
i = 0;
}
i++;
}
strHtml.Append("</table>");
}
return strHtml.ToString();
}
/// <summary>
/// 获取专家分组信息
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<AuthorDetailEntity> GetExpertGroupMapList(ExpertGroupMapEntity query)
{
return AuthorDetailDataAccess.Instance.GetExpertGroupMapList(query);
}
/// <summary>
/// 设置作者为专家
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<AuthorDetailEntity> GetExpertGroupMapList(ExpertGroupMapEntity query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
IList<AuthorDetailEntity> result = clientHelper.Post<IList<AuthorDetailEntity>, ExpertGroupMapEntity>(GetAPIUrl(APIConstant.AUTHOR_GETEXPERTGROUPMAPLIST), query);
return result;
}
/// <summary>
/// 获取专家分组信息
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<AuthorDetailEntity> GetExpertGroupMapList(ExpertGroupMapEntity query)
{
return AuthorDetailBusProvider.GetExpertGroupMapList(query);
}
/// <summary>
/// 获取专家分组信息
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<AuthorDetailEntity> GetExpertGroupMapList(ExpertGroupMapEntity query)
{
string strSql = @" select a.AuthorID,a.LoginName,a.RealName,c.PKID from
(SELECT b.AuthorID ,b.LoginName ,b.RealName,B.JournalID FROM dbo.AuthorDetail a with(nolock)
RIGHT JOIN dbo.AuthorInfo b with(nolock) ON a.JournalID=b.JournalID and a.AuthorID=b.AuthorID WHERE b.JournalID=" + query.JournalID + " and (b.GroupID=3 or exists(select 1 from dbo.RoleAuthor m with(nolock) WHERE b.JournalID=m.JournalID and b.AuthorID=m.AuthorID and m.RoleID=3))) as A LEFT JOIN dbo.ExpertGroupMap c ON A.JournalID=c.JournalID and a.AuthorID=c.AuthorID and c.ExpertGroupID=" + query.ExpertGroupID + " ORDER BY RealName";
return db.GetList<AuthorDetailEntity>(strSql, (dr) =>
{
List<AuthorDetailEntity> list = new List<AuthorDetailEntity>();
AuthorDetailEntity model = null;
while (dr.Read())
{
model = new AuthorDetailEntity();
model.AuthorID = dr.GetDrValue<Int64>("AuthorID");
model.Emial = dr.GetDrValue<String>("LoginName");
model.AuthorName = dr.GetDrValue<String>("RealName");
model.IsChecked = dr.GetDrValue<Int64>("PKID") > 0;
list.Add(model);
}
return list;
});
}
/// <summary>
/// 获取专家分类信息
/// </summary>
/// <param name="AuthorID"></param>
/// <returns></returns>
private IList<ExpertGroupMapEntity> GetExpertGroupMapList(Int64 AuthorID)
{
string strSql = "SELECT * FROM dbo.ExpertGroupMap with(nolock) WHERE AuthorID=" + AuthorID;
return db.GetList<ExpertGroupMapEntity>(strSql, (dr) =>
{
List<ExpertGroupMapEntity> list = new List<ExpertGroupMapEntity>();
ExpertGroupMapEntity model = null;
while (dr.Read())
{
model = new ExpertGroupMapEntity();
model.PKID = dr.GetDrValue<Int64>("PKID");
model.JournalID = dr.GetDrValue<Int64>("JournalID");
model.AuthorID = dr.GetDrValue<Int64>("AuthorID");
model.ExpertGroupID = dr.GetDrValue<Int32>("ExpertGroupID");
model.AddDate = dr.GetDrValue<DateTime>("AddDate");
list.Add(model);
}
return list;
});
}
/// <summary>
/// 添加专家分类
/// </summary>
/// <param name="model"></param>
/// <param name="trans"></param>
/// <returns></returns>
private bool AddExpertGroupMap(ExpertGroupMapEntity model, DbTransaction trans)
{
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" @JournalID");
sqlCommandText.Append(", @AuthorID");
sqlCommandText.Append(", @ExpertGroupID");
DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.ExpertGroupMap ({0},AddDate) VALUES ({1},getdate())", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString()));
db.AddInParameter(cmd, "@JournalID", DbType.Int64, model.JournalID);
db.AddInParameter(cmd, "@AuthorID", DbType.Int64, model.AuthorID);
db.AddInParameter(cmd, "@ExpertGroupID", DbType.Int32, model.ExpertGroupID);
try
{
bool result = false;
if (trans == null)
result = db.ExecuteNonQuery(cmd) > 0;
else
result = db.ExecuteNonQuery(cmd, trans) > 0;
if (!result)
throw new Exception("新增专家分类信息失败！");
return result;
}
catch (Exception ex)
{
throw ex;
}
}