public IHttpActionResult SearchPosition(string storeCode)
{
var sql = string.Format(@"SELECT tb_employee.Code,tb_employee.NameZHCN,tb_employee.NameENUS,tb_position.NameENUS as PositionName,tb_position.PositionCode
FROM dbo.Store tb_store
INNER JOIN dbo.UserMiniMarket tb_mini
ON tb_mini.MiniMarketCode = tb_store.MiniMarketCode
INNER JOIN dbo.UserPosition tb_position
ON tb_position.Id = tb_mini.PositionId
INNER JOIN dbo.Employee tb_employee
ON tb_employee.Id = tb_position.UserId
WHERE tb_store.code = '{0}' AND tb_position.PositionCode in ('suoya303051','suoya303055','suoya303057','suoya450007','suoya303050','suoya303054')
AND tb_employee.Status = 1
ORDER BY PositionCode", storeCode);
//AND tb_employee.Status = 1
var list = ClosureInfo.SqlQuery <SPosition>(sql, null).ToList();
return(Ok(list));
}
