/// <summary>
/// 根据ID查找评审意见
/// </summary>
/// <param name="id">要查找的评审意见ID</param>
/// <returns>返回找到的评审意见对象</returns>
public static AssessOpinion GetAssessOpinionById(int id)
{
AssessOpinion assessOption = new AssessOpinion(); //实例化一个新的查询结果
DBVisit.ObjDBAccess.CommandStr = @"select AssessOpinion_State,AssessOpinion_SendID,
AssessOpinion_Result,AssessOpinion_Article,
AssessOpinion_Message,AssessOpinion_Remark,
AssessOpinion_ArticleStateID
from AssessOpinion where AssessOpinion_ID=@id";
SqlParameter sqlPm = new SqlParameter("@id", id);
DBVisit.ObjDBAccess.CmdParas.Add(sqlPm);
DataSet ds = new DataSet();
ds = DBVisit.ObjDBAccess.ExecuteSelectSqlCommand(); //调用DBhelp执行查询方法 返回一个DataSet对象
assessOption.ID = id; //跟相应的属性赋值
assessOption.AssessStateInfo = AssessStateService.GetAssessStateById(int.Parse(ds.Tables[0].Rows[0]["AssessOpinion_State"].ToString()));
assessOption.AssessResultInfo = AssessResultService.GetAssessResultById(int.Parse(ds.Tables[0].Rows[0]["AssessOpinion_Result"].ToString()));
assessOption.Article = Convert.ToInt32(ds.Tables[0].Rows[0]["AssessOpinion_Article"]);
assessOption.Message = Convert.ToString(ds.Tables[0].Rows[0]["AssessOpinion_Message"]);
assessOption.Remark = Convert.ToString(ds.Tables[0].Rows[0]["AssessOpinion_Remark"]);
assessOption.SendID = Convert.ToInt32(ds.Tables[0].Rows[0]["AssessOpinion_SendID"]);
assessOption.ArticleStateID = Convert.ToInt32(ds.Tables[0].Rows[0]["AssessOpinion_ArticleStateID"]);
return(assessOption); //返回找到的结果
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="assessOption">要增加的对象</param>
/// <returns></returns>
public static int AddAssessOption(AssessOpinion assessOption)
{
DBVisit.ObjDBAccess.CommandStr = @"insert into AssessOpinion values
(@state,@sendId,@result,@article,@message,@articleState,@remark)"; //要执行的SQL语句
SqlParameter[] sqlPm = new SqlParameter[] //实例化一个参数列表
{
new SqlParameter("@state", assessOption.AssessStateInfo.ID),
new SqlParameter("@sendId", assessOption.SendID),
new SqlParameter("@result", assessOption.AssessResultInfo.ID),
new SqlParameter("@article", assessOption.Article),
new SqlParameter("@message", assessOption.Message),
new SqlParameter("@articleState", assessOption.ArticleStateID),
new SqlParameter("@remark", assessOption.Remark)
};
DBVisit.ObjDBAccess.CmdParas.AddRange(sqlPm); //假如到SqlCommand的参数列表中去
return(DBVisit.ObjDBAccess.ExecuteUnSelectSqlCommand()); //执行SQL语句
}
/// <summary>
/// 修改评审意见表
/// </summary>
/// <param name="assessOption">要修改的新对象</param>
/// <returns></returns>
public static int UpdateAssessOption(AssessOpinion assessOption)
{
DBVisit.ObjDBAccess.CommandStr = @"update AssessOpinion set AssessOpinion_State=@state,
AssessOpinion_SendID=@sendId,AssessOpinion_Result=@result,
AssessOpinion_Article=@article,AssessOpinion_Message=@message,
AssessOpinion_Remark=@remark where AssessOpinion_ID=@id"; //要执行的SQL语句
SqlParameter[] sqlPm = new SqlParameter[] //实例化一个参数列表
{
new SqlParameter("@state", assessOption.AssessStateInfo.ID),
new SqlParameter("@sendId", assessOption.SendID),
new SqlParameter("@result", assessOption.AssessResultInfo.ID),
new SqlParameter("@article", assessOption.Article),
new SqlParameter("@message", assessOption.Message),
new SqlParameter("@remark ", assessOption.Remark),
new SqlParameter("@id", assessOption.ID)
};
DBVisit.ObjDBAccess.CmdParas.AddRange(sqlPm); //假如到SqlCommand的参数列表中去
return(DBVisit.ObjDBAccess.ExecuteUnSelectSqlCommand()); //执行SQL语句
}
/// <summary>
/// 查询所有的评审意见返回List
/// </summary>
/// <returns>返回类型List</returns>
public static List <AssessOpinion> GetAllAssessOpinion()
{
List <AssessOpinion> list = new List <AssessOpinion>();
DBVisit.ObjDBAccess.CommandStr = @"select AssessOpinion_ID,AssessOpinion_State,AssessOpinion_SendID,
AssessOpinion_Result,AssessOpinion_Article,AssessOpinion_Message,
AssessOpinion_Remark,AssessOpinion_ArticleStateID from AssessOpinion ";
DataTable dt = DBVisit.ObjDBAccess.ExecuteSelectSqlCommand().Tables [0];
foreach (DataRow dr in dt.Rows)
{
AssessOpinion ass = new AssessOpinion();
ass.ID = Convert.ToInt32(dr["AssessOpinion_ID"]);
ass.AssessStateInfo = AssessStateService.GetAssessStateById(Convert.ToInt32(dr["AssessOpinion_State"]));
ass.AssessResultInfo = AssessResultService.GetAssessResultById(Convert.ToInt32(dr["AssessOpinion_Result"]));
ass.SendID = Convert.ToInt32(dr["AssessOpinion_SendID"]);
ass.Article = Convert.ToInt32(dr["AssessOpinion_Article"]);
ass.Remark = Convert.ToString(dr["AssessOpinion_Remark"]);
ass.Message = Convert.ToString(dr["AssessOpinion_Message"]);
ass.ArticleStateID = Convert.ToInt32(dr["AssessOpinion_ArticleStateID"]);
list.Add(ass);
}
return(list);
}
/// <summary>
/// 更新评审信息
/// </summary>
/// <param name="assessOpinion"></param>
/// <returns></returns>
public static int UpdateAssessOpinion(AssessOpinion assessOpinion)
{
return(AssessOpinionService.UpdateAssessOption(assessOpinion));
}
/// <summary>
/// 插入新评审信息
/// </summary>
/// <param name="assessOpinion"></param>
/// <returns></returns>
public static int InsertAssessOpinion(AssessOpinion assessOpinion)
{
return(AssessOpinionService.AddAssessOption(assessOpinion));
}
/// <summary>
/// 用户点击提交评审信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
GeneralUser user = (Session["UserInfo"] as GeneralUser); //获取用户信息
Article article = ArticleManager.GetArticleInfoById(Convert.ToInt32(Session["ArticleIDForAddAss"])); //获取文章
//////////////添加评审意见//////////////
AssessOpinion newAssOp = new AssessOpinion();
newAssOp.AssessStateInfo.ID = 0; //已评审
newAssOp.SendID = user.Id; //评论者
newAssOp.AssessResultInfo.ID = Convert.ToInt32(this.ddlResult.SelectedValue); //评审结果
newAssOp.Article = article.Id; //文章编号
newAssOp.Message = this.txtMessage.Text; //评语
newAssOp.Remark = this.txtRemark.Text; //备注
newAssOp.ArticleStateID = article.ArticleStateInfo.Id; //评审批次
AssessOpinionManager.InsertAssessOpinion(newAssOp); //添加
///////////是责编初审 指派专家//////////////
if (ddlResult.SelectedValue == "0") //如果通过
{
if (user.RoleInfo.Id == UserRoleConst.ResponsibleEditor && article.ArticleStateInfo.Id == 1) //责编初审
{
for (int i = 0; i < CblExpert.Items.Count; i++)
{
if (CblExpert.Items[i].Selected)
{
ExpertArticle expertArt = new ExpertArticle();
expertArt.ArticleId = article.Id;
expertArt.ExpertId = Convert.ToInt32(CblExpert.Items[i].Value);
if (ExpertArticleManager.AddExpertArticle(expertArt) == 0)
{
ClientScript.RegisterStartupScript(GetType(), "", "alert('指派专家出错！')", true);
return;
}
}
}
}
}
/////////修改文章状态//////////////////
if (user.RoleInfo.Id == UserRoleConst.Expert) //专家修改稿件状态(专家过不过稿件都成为一个状态)
{
article.ArticleStateInfo.Id = 16; //改状态为专家已评审
if (ArticleManager.UpdateArticleInfo(article) != 1)
{
ClientScript.RegisterStartupScript(GetType(), "", "alert('写入数据出错！')", true);
}
ClientScript.RegisterStartupScript(GetType(), "", "alert('评审完毕！')", true);
//跳转
Response.Redirect("~/success.aspx"); //成功
return;
}
if (ddlResult.SelectedValue == "0") //选择通过
{
if (article.ArticleStateInfo.Id == 1)
{
article.ArticleStateInfo.Id = 2; //过初审
}
else if (article.ArticleStateInfo.Id == 2 || article.ArticleStateInfo.Id == 16)
{
article.ArticleStateInfo.Id = 3; //过二审
}
else if (article.ArticleStateInfo.Id == 3)
{
article.ArticleStateInfo.Id = 8; //过复审
}
else if (article.ArticleStateInfo.Id == 8)
{
article.ArticleStateInfo.Id = 9; //过终审
}
else
{
ClientScript.RegisterStartupScript(GetType(), "", "alert('稿件状态出错！')", true);
}
//写入数据库
if (ArticleManager.UpdateArticleInfo(article) != 1)
{
ClientScript.RegisterStartupScript(GetType(), "", "alert('写入数据出错！')", true);
}
}
else
{
article.ArticleStateInfo.Id = 13; //不通过 稿件成为退回稿件
//写入数据库
if (ArticleManager.UpdateArticleInfo(article) != 1)
{
ClientScript.RegisterStartupScript(GetType(), "", "alert('写入数据出错！')", true);
}
}
ClientScript.RegisterStartupScript(GetType(), "", "alert('评审完毕！')", true);
Response.Redirect("~/success.aspx"); //成功
}
