/// <summary>
/// 批量更改协议状态
/// </summary>
/// <param name="guidList">主键列表</param>
/// <param name="status">状态</param>
public void UpdateAgreeStatus(List <string> guidList, StatusEnum.AgreeStatusEnum status)
{
StringBuilder strSql = new StringBuilder("update T_Agreements set status='" + status.ToString("D") + "' where ID in(");
for (int i = 0; i < guidList.Count; i++)
{
strSql.AppendFormat(i == guidList.Count - 1 ? "'{0}'" : "'{0}',", guidList[i]);
}
strSql.Append(")");
using (DBHelper db = DBHelper.Create())
{
db.ExecuteNonQuery(strSql.ToString());
}
}
/// <summary>
/// 更改协议为已审批
/// </summary>
/// <param name="guidList"></param>
/// <param name="status"></param>
public void ApprovalAgree(List <string> guidList, StatusEnum.AgreeStatusEnum status)
{
new Ajax.DAL.AgreementsDAL().UpdateAgreeStatus(guidList, status);
}
